[Release] How to delete accounts that haven't logged in from certain date!

[latruwski]

finally i found this old query back !!!

here it is:

-- Delete all accounts which have not been online for some period of time
DELETE FROM `ACCTDATABASE`.`accounts` WHERE `lastlogin` < '2007-04-15 00:00:00';

-- Delete all characters which have no corresponding account
DELETE FROM `CHARDATABASE`.`characters` WHERE `acct` NOT IN (SELECT `acct` FROM `ACCTDATABASE`.`accounts`);
DELETE FROM `CHARDATABASE`.`playeritems` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`tutorials` WHERE `playerId` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`social` WHERE `guid` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`questlog` WHERE `player_guid` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`corpses` WHERE `guid` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`mailbox` WHERE `player_guid` NOT IN (SELECT `guid` FROM `CHARDATABASE.`characters`);

change the lastlogin date to whatever you wnt... i tested it and it worked for me... before using better test again

i said i would share it with you as soon as i found it
have fun with it !

grtz

[latruwski]

I forgot who needed this... but well i posted it for you

*Bump*

grtz

[Life_Hero]

Mafiaboy I think

[latruwski]

Mafiaboy I think

yea him i know.. but some other guys who pm'd me i forgot xD
delete PMs recently so :-/
anyhow i think a lot of people can use this ^^

grtz