I want it to display the two names of my char in my account but it displays only one
Here is the code:
prontera,158,174,4 script Account Checker 88,{
mes "Please input a valid character name";
input .@playername$;
query_sql "SELECT `account_id` FROM `char` WHERE `name` = '"+escape_sql(.@playername$)+"'",.@accountid;
if (!.@accountid) {
next;
mes "The name is invalid!";
close;
}
else
next;
query_sql "SELECT `name` FROM `char` WHERE `account_id`="+.@accountid,
.@whoischar$;
// Take Locations
setarray .@name$[0],.@whoischar$;
// Generate Menu
for (set .@a, 0; .@a < getarraysize(.@name$); set .@a, .@a + 1) {
set .@menu_num$[getarraysize(.@menu_num$)], .@name$[.@a];
set .@menu_index[getarraysize(.@menu_index)], .@a;
}
// Generate the Menu String
set .@menu$, .@menu_num$[0];
for (set .@a, 1; .@a <= getarraysize(.@menu_num$); set .@a, .@a + 1) {
set .@menu$, .@menu$ + ":" + .@menu_num$[.@a];
}
// Query Selection
set .@a, select(.@menu$) - 1;
goto L_Char;
L_Char:
mes "...";
close;
end;
}
thx!!
any help would be greatly appreciated!