@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
    • Upvote
    1