yuhsing

Untitled

Sep 11th, 2013
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. - script list_same_ip -1,{
  2.  
  3. OnCheck:
  4. mes "Enter Player Name:";
  5. input .@name$;
  6. if( query_sql( "SELECT `name` FROM `char` WHERE `name` LIKE '%"+escape_sql( .@name$ )+"%' LIMIT 50",.@name_list$ ) ){
  7. set .@size,getarraysize( .@name_list$ );
  8. for( set .@i,0; .@i < .@size; set .@i,.@i + 1 )
  9. set .@name_list_menu$,.@name_list_menu$ + .@name_list$[.@i] +":";
  10. set .@i,select( .@name_list_menu$ ) - 1;
  11. set .@name$,escape_sql( .@name_list$[.@i] );
  12. if( query_sql( "SELECT `last_ip` FROM `login` WHERE `account_id` >= 2000000 AND `account_id` = ( SELECT `account_id` FROM `char` WHERE `name` = '"+.@name$+"' LIMIT 1 )",.@last_ip$ ) ){
  13.  
  14. query_sql( "SELECT `account_id`,`name`,`online` FROM `char` WHERE `account_id` IN ( SELECT `account_id` FROM `login` WHERE `last_ip` = '"+.@last_ip$+"' ) ORDER BY `account_id` ASC",.@match_aid,.@match_name$,.@match_online );
  15. mes "Char same IP with ^0055FF"+.@name$+"^000000";
  16. set .@userid_size,getarraysize( .@match_aid );
  17. mes "--- ^0055FFIP : "+.@last_ip$+" ^FF0000( "+.@userid_size+" )^000000 ---";
  18. while( .@id < .@userid_size ){
  19. if( .@name$ != .@match_name$[.@id] )
  20. mes "^777777 > "+.@match_aid[.@id]+" -^"+( ( .@match_online[.@id] )?"0055FF":"777777" )+" "+.@match_name$[.@id]+"^000000";
  21. set .@id,.@id + 1;
  22. }
  23. }
  24. }else{
  25. mes "No Record Found(s) with ^0055FF"+.@ip$+"^000000.";
  26. }
  27. close;
  28. }
Advertisement
Add Comment
Please, Sign In to add comment