sql command

[TriamerA]

I need to delete accounts of players which didnt log in since 20 days.

Because I found only one which was deleting players- not accounts.
It's like select from accounts lastlogin < UNIX_TIMESTAMP() - 20*24*60*60;
But it doesnt want to show me anything

 

[xxgoosexx]

I need to delete accounts of players which didnt log in since 20 days.

Because I found only one which was deleting players- not accounts.
It's like select from accounts lastlogin < UNIX_TIMESTAMP() - 20*24*60*60;
But it doesnt want to show me anything

you could always just delete the players first then do

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

^ not sure all the column names are right (and remember to back up database b4 making any edits)

and if you want to delete the account and not players for whatever reason

 DELETE FROM accounts WHERE `lastday` < UNIX_TIMESTAMP() - 20*24*60*60;

 

[TriamerA]

ok thanks and i will give you rep if you will help me with this:
-deleting from non existing players depot storage ( got 150k records in "player depot".
-Player Items- 240k records
-Player storage - 210k records

And there must be records from not existing players !! Help again my hero ;D

 

[xxgoosexx]

ok thanks and i will give you rep if you will help me with this:
-deleting from non existing players depot storage ( got 150k records in "player depot".
-Player Items- 240k records
-Player storage - 210k records

And there must be records from not existing players !! Help again my hero ;D

thats easy

  DELETE FROM player_skills 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);

you can pretty much do that for any of the player tables (items,vip,deaths etc)

 

[TriamerA]

ye but when i do that it doesn't delete anything... is that possible? 200k records??

 

[xxgoosexx]

ye but when i do that it doesn't delete anything... is that possible? 200k records??

if u have enough players, if u think about it, each player has 6 skills, and each player also has alot of storage values too for outfits, starting items etc

 

[Pitufo™]

Or delete player that are deleted:

DELETE FROM players WHERE deleted =1;