How to list character name in ID

[saovarott159]

Hello , help me please

In script  i want show list character name in ID

i'm won't specify ID and name

//===================================================//

-    script    SupportPlayers    -1,{

mes "[ ^0000FFSupportPlayer^000000 ]";
mes "Hello ^800000"+strcharinfo(0)+"^000000";
next;
menu "-Pullcharacter",Lmoveto_save,"- cancel",Lend;

Lmoveto_save:
mes "[ ^000080SupportPlayer^000000 ]";
mes "Pull character Stick Bug return to savepoint";
next;
menu "- Confirm",-,"- cancel",Lend;
mes "[ ^000080SupportPlayer^000000 ]";
mes "please insert ID";
input @select_id$;
next;
query_sql "SELECT `account_id` FROM `login` WHERE `userid`='"+escape_sql(@select_id$)+"'",@accyou;
mes "[ ^000080SupportPlayer^000000 ]";
mes "Please insert name";
input @select_name$;
next;
query_sql "SELECT `name`,`account_id` FROM `char` WHERE `name`='"+escape_sql(@select_name$)+"'",@name$,@accid;
if (@name$ != @select_name$){
mes "[ ^000080SupportPlayer^000000 ]";
mes "^FF0000The system is not name";
next;
goto Lend;
}
if (@accid != @accyou){
mes "[ ^000080SupportPlayer^000000 ]";
mes "^FF0000character "+@select_name$+"";
mes "Error";
mes "ID : "+@select_id$+"";
next;
goto Lend;
}
query_sql "SELECT `online` FROM `char` WHERE `name`='"+escape_sql(@select_name$)+"'",@stat;
if (@stat != 0){
mes "[ ^000080SupportPlayer^000000 ]";
mes "^FF0000character is Online ";
next;
goto Lend;
}
query_sql "SELECT `save_map`,`save_x`,`save_y` FROM `char` WHERE `name`='"+escape_sql(@select_name$)+"'",@mapname_save$,@mapx_save,@mapy_save;
query_sql "UPDATE `char` SET `last_map`='"+@mapname_save$+"',`last_x`='"+@mapx_save+"',`last_y`='"+@mapy_save+"' WHERE `name`='"+escape_sql(@select_name$)+"'";
mes "[ ^000080SupportPlayer^000000 ]";
mes "ID : "+@select_id$+"";
mes "name : "+@select_name$+" ";
mes "return to  : "+@mapname_save$+" "+@mapx_save+" "+@mapy_save+"";
mes ".... Finish ....";
next;
goto Lend;
close;

Lend:
mes "[ ^000080SupportPlayer^000000 ]";
mes "Goodbye";
close;
}

prontera,160,100,4    duplicate(SupportPlayers)    SupportPlayers#01    895

 

Edited November 25, 2016 by Emistry
Please use CODEBOX.