position title

[TiMz]

Using SQL entries I instead of numbers appearing in-game I would like the value 0 appear as apple, 1 appear as grapes, 2 appear as watermelon etc etc.

mes "[ " +.@position[.@a]+" ]");     <<< This will appear as a number in-game from the guild position table. How to attach a word to the corresponding number.
mes " ";
close;
}

Edited April 5, 2014 by Isaiah

[Emistry]

.@guild_id = 100;

setarray .@name_list$,

"Apple",

"Orange",

"Watermelon",

"Banana",

"Strawberry";

.@name_list_size = getarraysize( .@name_list$ );

query_sql( "SELECT `name`,`position` FROM `guild_member` WHERE `guild_id` = "+.@guild_id+" ORDER BY `position` LIMIT "+.@name_list_size,.@name$,.@position );

.@name_size = getarraysize( .@name$ );

mes "["+getguildname( .@guild_id )+"]";

for( .@i = 0; .@i < .@name_size; .@i++ )

mes .@name$[.@i]+" | "+.@name_list$[ .@position[.@i] ];

close;

Edited February 12, 2014 by Emistry

[sandbox]

Why not use an if-else/switch statement instead of attaching them as a permanent variable?

 

if(.@position[.@] == 0) mes "Apple";
else if...

 

But anyways, to answer your question though, use $ as the prefix. You can find the variables stored in mapreg table

 

set $fruit$[0],"Apple";

 

Kindly correct if i have stated something wrong or misunderstood your question..

[TiMz]

query_sql( "SELECT `name`,`guild_id`,`position` FROM `guild_member` where guild_id = 100 LIMIT 5",.@Name$,.@gid,.@position );
mes "[ Fruit Clan ]";
mes " ";
for( set .@a,0; .@a < getarraysize(.@name$); set .@a,.@a + 1)
if(.@position[.@] == 0) mes "Apple";
else if(.@position[.@] == 1) mes "Orange";
mes " "+.@name$[.@a]+ " | " +.@position[.@a]+" | ";
mes " ";
close;
}

@sandbox It doesn't appear to work.

[sandbox]

sorry for the typo

 

change 

.@position[.@]

 

to

.@position[.@a]

[TiMz]

@sandbox

 

It still doesn't show the member's position as "apple"

 

It now looks something like

 

[Fruit Clan]

 

apple

Name | 0 |   // 0 meaning guildmaster.

[TiMz]

@Emistry

 

Thanks for the quick response. I didn't get any errors on the console although the npc is only showing the guild name of ID 100. And nothing else.

Edited February 12, 2014 by Isaiah

[Emistry]

@Emistry

 

Thanks for the quick response. I didn't get any errors on the console although the npc is only showing the guild name of ID 100. And nothing else.

.@name_list_size = getarraysize( .@name_list$ );

refer above script...updated

[TiMz]

@Emistry Worked like a charm! Great support thank you!