Query_SQL Help

[REKT]

Hello, it's me again! i just wanted to confirm the following script that i edit? if this one is correct.

Uhm? if possible? could you add also the Logo for the Emblem and the following name of the guild?

Ex:

[LOGO] Hello Kitty Guild.

Could you fix it below the script?

I just stole it from 'Chris' sorry!

and i don't have any idea how to fix the query_sql properly.

query_sql "SELECT `char_num` , `name` , `class` , `base_level` , `job_level`

mes "Character Name: ^0000FF" + @name$[0] + "^000000";
mes "Base/Job Level: ^993333" + @base_level[@a] + " / " + @job_level[@a] + "^000000";
mes "Class: ^993333" + jobname(@class[@a]) + "^000000";
mes "Guild: [LOGO] and the Name of the [GUILD]";

Don't know what else i could explain about this script since, i'm not familiar with query_sql.

Thank you and much appreciated for those who help me here.

Regards,

Melody

[KeyWorld]

Hi Melody.

We have to know what you want to display, the filter :

-> All character in a specify account ?

-> One character in a party based on the party id ?

-> ...

Specify.

It's not possible to display an emblem in the npc dialog (or is it a new feature I'm missing ?).

Here the code, just missing the "what do we need to select" thing in the sql query.

	set .@n, query_sql(
	"SELECT " +
		"c.`name`, c.`base_level`, c.`job_level`, c.`class`, " +
		"g.`name` " +
	"FROM " +
		"`char` AS c " +
	"LEFT JOIN " +
		"`guild` AS g " +
	"ON " +
		"c.`guild_id` = g.`guild_id` " +
	"WHERE " +
	    "<don't know what to write here, missing some informations>",
	.@name$, .@base_level, .@job_level, .@class, .@guild_name$
);

for ( set .@i, 0; .@i<.@n; set .@i, .@i+1 ) {
	mes(
		"Character Name: ^0000FF" + .@name$[.@i] + "^000000",
		"Base/Job Level: ^993333" + .@base_level[.@i] + " / " + .@job_level[.@i] + "^000000",
		"Class: ^993333" + jobname(.@class[.@i]) + "^000000",
		"Guild: ^993333" + .@guild_name$[.@i] + "^000000",
		""
	);
}

[REKT]

Oh my 'GOSH' seems i can't read this professional scripting tricks, could you make it more 'BASICS' i don't need something like this, i can't even read some of the 'DETAILS' Please?

Regards,

Melody

[KeyWorld]

I can't really make it more simple... It's just a basic SQL request.

As I said below, we just have to know what the script is supposed to do to complete it (display players in your party ? display members in your guild ? display all players of a map ?)

[Lighta]

I guess she could display an emblem using cutin function and put it in the good location and format.

Take a look at (*cutin) on doc/script_command.txt.

KeyWorld query is a good exemple to learn, (even if "as" may be trouble), but first you need to knoww what you wanna get from that query and what do you already have. It's like searching in a big array you need an index to found what u want.

If I get it right you wanted an sql query to load the emblem from a specified guild right ? Dunno if it's possible like that but take a look at cutin as I said.

Last from your and Keyworld actual query, you could have all those value via npc already.

[llchrisll]

Hmm, looks like from my InGame CP D:, to specify the source more ;O.

Don't got a problem with so don't worry.

About the guild.

Instead of getting the guild name via SQL wouldn't that be more better:?

getguildname(getcharid(2,.@name$[.@i]))

So in this case you won't the "JOIN" part in the sql query.

Regards,

Chris

[REKT]

Hmm, looks like from my InGame CP D:, to specify the source more ;O.

Don't got a problem with so don't worry.

About the guild.

Instead of getting the guild name via SQL wouldn't that be more better:?

getguildname(getcharid(2,.@name$[.@i]))

So in this case you won't the "JOIN" part in the sql query.

Regards,

Chris

Hello, Chris the 'CODE' is working but, few Suggestion? EX: what if the player has no 'GUILD'?

Could you also put "None Guild"? please understand me here, i'm still new in 'query_sql' sorry for stealing your 'CODE' @_@?

@Keyworld, thanks a lot! but sorry, i can't understand that good 'query_sql' code of yours, maybe i should messing around with /doc.txt

Melody

[llchrisll]

In that case this code would be the correct one:

mes ( (!getcharid(2,.@name$[.@i]))?"No Guild":getguildname(getcharid(2,.@name$[.@i])));

This is a called a short-if.

completed it would be look like this:

if(!getcharid(2,.@name$[.@i])) // Player doesn't have an guild.
   mes "No Guild";
else // Player has one D:
   mes getguildname(getcharid(2,.@name$[.@i]));

So with an short-if you can make the script shorter .

Regards,

Chris

Note: I'm pretty sure "short-if" has an another term, I saw somewhere o.o. Can't remember though where.