I would like to request for Player Checker NPC...... It's an NPC where you input a certain name, then the npc shows the character that you've input along with all the other character in that account and tells you whether which character is online or he is currently using.....
@Rafael
omg !
yeah you are right, using select inside select will return result faster only if the search key is not indexed xD
if a search inside the where clause is indexed, run time is the same
thx for reminding me
though I still prefer to use this method since I don't need to check the field is indexed or not
here it is
prontera,157,178,5 script Sample 757,{
if ( getgmlevel() < 80 ) end;
mes "Input Player Name";
if ( input( .@input$, 4, 23 ) ) {
mes "inv