yuhsing

Untitled

Mar 26th, 2013
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1.  
  2.  
  3. - script Sample -1,{
  4. OnClock0000:
  5. query_sql( "SELECT `account_id` FROM `login` WHERE DATEDIFF( `lastlogin`,NOW() ) < -90 LIMIT 127",.@account_id );
  6. for( .@i = 0; .@i < getarraysize( .@account_id ); .@i++ ){
  7. query_sql( "DELETE FROM `char` WHERE `account_id`='"+.@account_id[.@i]+"'" );
  8. query_sql( "DELETE FROM `global_reg_value` WHERE `account_id`='"+.@account_id[.@i]+"'" );
  9. query_sql( "DELETE FROM `guild_expulsion` WHERE `account_id`='"+.@account_id[.@i]+"'" );
  10. query_sql( "DELETE FROM `guild_member` WHERE `account_id`='"+.@account_id[.@i]+"'" );
  11. query_sql( "DELETE FROM `login` WHERE `account_id`='"+.@account_id[.@i]+"'" );
  12. query_sql( "DELETE FROM `sc_data` WHERE `account_id`='"+.@account_id[.@i]+"'" );
  13. query_sql( "DELETE FROM `pet` WHERE `account_id`='"+.@account_id[.@i]+"'" );
  14. query_sql( "DELETE FROM `storage` WHERE `account_id`='"+.@account_id[.@i]+"'" );
  15. }
  16. end;
  17. }
Advertisement
Add Comment
Please, Sign In to add comment