yuhsing

Untitled

Apr 17th, 2013
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1.  
  2. - script Sample -1,{
  3. OnWhisperGlobal:
  4. .@i = query_logsql("SELECT `char_name` FROM `atcommandlog` WHERE `char_name` LIKE '"+@whispervar0$+"'",.@charname$ );
  5. if( !.@i ){
  6. mes "No Record found for player named ^FF0000"+@whispervar0$+"^000000.";
  7. }else{
  8. if( select( "Search Command","List All" ) == 1 ){
  9. mes "Input the @Command.";
  10. input .@search$;
  11. }
  12. .@i = query_logsql("SELECT `atcommand_date`,`map`,`command` FROM `atcommandlog` WHERE `char_name` LIKE '"+@whispervar0$+"' "+( ( .@search$ == "" )?"":" AND `command` LIKE '%"+.@search$+"%'" )+" LIMIT 127",.@date$,.@map$,.@command$ );
  13. if( !.@i ){
  14. mes "No Record found";
  15. }else{
  16. next;
  17. mes "Player : ^0055FF"+@whispervar0$+"^000000";
  18. if( .@search$ != "" ) mes "Command : ^0055FF"+.@search$+"^000000";
  19. .@size = getarraysize( .@date$ );
  20. for( .@i = 0; .@i < .@size; .@i++ ){
  21. mes "^FF0000["+.@date$[.@i]+"] ^0055FF"+.@map$[.@i]+"^000000";
  22. mes " > "+.@command$[.@i];
  23. }
  24. }
  25. }
  26. close;
  27. }
Advertisement
Add Comment
Please, Sign In to add comment