haha i thought so, here's an update regarding bug check. sorry i cant test it in office.
// Reset Position In-game version
prontera,160,160,4 script Position Reset 909,{
mes "[System]";
mes "Please select a character";
mes "return to save point...";
set .@count, query_sql("SELECT `char_id`,`name` FROM `char` WHERE `account_id` = "+getcharid(3),.@charid,.@charname$);
set .@menu$, "";
for ( set @ctr,0; @ctr < .@count; @ctr++ )
.@menu$ = .@menu$ + .@charname$[@ctr]+":";
.@menu = .@menu$ + "Cancel";
set .@selectedchar, select(.@menu$)-1;
next;
if( .@selectedchar < .@count )
{
if( getcharid(0) != .@charid[.@selectedchar] )
{
query_sql("UPDATE `char` AS ch SET ch.last_map = ch.save_map, ch.last_x = ch.save_x, ch.last_y = ch.save_y WHERE ch.char_id = "+.@charid[.@selectedchar]);
mes .@charname$[@selectedchar] + "'s position has been reset.";
}
else
{
// TODO: instead of having if-else, its better not to show the invoker's name in selection.
mes "you cant reset your own position";
}
}
end;
}