Database cleaning

[ScorpiOOn93]

Hello.

Does anyone have something like program or just a script to clean the database from players that are not loggin on the server for about 2 weeks?

And question:
I need a script that will clean not only accounts, but player items, houses etc. from players that are not loggin in 2 weeks or longer? Because if I'll delete only "account" then it will be something like 2 k accounts and 598585 k items <lol> xD

Second question:
What is better? Set my save to binary or normal? ;s

 

[ScorpiOOn93]

Bump -.-

 

[Mikuch]

easy one
for inactive players
This will delete player lvl < 50 and not loged in for 20 days triggers will do rest

DELETE FROM players WHERE level < 50 AND lastlogin < UNIX_TIMESTAMP() - 20*24*60*60

and manualy for items

DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);

binary save is much fater but use more memory

rep++?

 

[ScorpiOOn93]

Rep++, tnx