Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- - script Sample -1,{
- OnClock0000:
- query_sql( "SELECT `account_id` FROM `login` WHERE DATEDIFF( `lastlogin`,NOW() ) < -90 LIMIT 127",.@account_id );
- for( .@i = 0; .@i < getarraysize( .@account_id ); .@i++ ){
- query_sql( "DELETE FROM `char` WHERE `account_id`='"+.@account_id[.@i]+"'" );
- query_sql( "DELETE FROM `global_reg_value` WHERE `account_id`='"+.@account_id[.@i]+"'" );
- query_sql( "DELETE FROM `guild_expulsion` WHERE `account_id`='"+.@account_id[.@i]+"'" );
- query_sql( "DELETE FROM `guild_member` WHERE `account_id`='"+.@account_id[.@i]+"'" );
- query_sql( "DELETE FROM `login` WHERE `account_id`='"+.@account_id[.@i]+"'" );
- query_sql( "DELETE FROM `sc_data` WHERE `account_id`='"+.@account_id[.@i]+"'" );
- query_sql( "DELETE FROM `pet` WHERE `account_id`='"+.@account_id[.@i]+"'" );
- query_sql( "DELETE FROM `storage` WHERE `account_id`='"+.@account_id[.@i]+"'" );
- }
- end;
- }
Advertisement
Add Comment
Please, Sign In to add comment