DB Clear !! HELP

[dianagirl]

hello
I need your help guys.
I need to delete all players that wasnt online 15 days ago.
I forgot the command to write in phpmyadmin

thanks alot for your help


rep++ !!

 

[dianagirl]

heelp pleasee

 

[dianagirl]

bumppppppp

 

[dianagirl]

lol why nobody help ??

 

[zakius]

DELETE FROM players WHERE level < 50 AND lastlogin < UNIX_TIMESTAMP() - 7*24*60*60 AND account_id <> 1 AND group_id <3;

7 is number of days here, change it to what you need
you probably would like to clean some other things

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

deletes empty accounts

DELETE FROM player_deaths WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_storage WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_depotitems WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_namelocks WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_spells WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_viplist WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_killers WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM accounts WHERE id NOT IN (SELECT account_id FROM players);

triggers should take care of this, but sometimes some shit can stay, so use it to delete storages, items etc of deleted players