Delete char and account 30 days away! mysql command!

[TKO]

Hey is there any mysql command to remove 30days away with account and char?

 

[Cykotitan]

DELETE FROM players WHERE lastlogin < UNIX_TIMESTAMP() - 30*24*60*60;

DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_skills WHERE player_id NOT IN (SELECT id FROM players);
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_viplist WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_depotitems WHERE player_id NOT IN (SELECT id FROM players);

DELETE FROM accounts WHERE id NOT IN (SELECT account_id FROM players);

Not tested.

 

[TKO]

Wow that sounds good that it aint tested.... and you think i will test it then? no thanks

 

[Cykotitan]

lol
create a test database or a backup of your current one and test on it?

 

[TKO]

cant atm...
i get error when i import it

 

[TKO]

can any one test them for me?

 

[nclx]

@Cykotitan
I think your sending too unnecessary querys ;s, i think removing player will auto remove acc, and items and stuff.. ;s, no?

@TKO
I loled with you kid...

 

[Cykotitan]

@Cykotitan
I think your sending too unnecessary querys ;s, i think removing player will auto remove acc, and items and stuff.. ;s, no?

It won't, they'll be orphaned. At least not in TFS 0.2

 

[TKO]

well i need to remove some account's and players! i have alot of players account that dosent play! and i need to remove them!