Database Cleanup ~~SQL~~

[stanczyk]

Could someone write my SQL to remove players, say between 8 and 50 lvlem who do not play for more than seven days?


I rep for HELP +++

 

[Cykotitan]

http://otland.net/f139/phpmyadmin-commands-edit-database-7751/

• Delete inactive players, here below lvl 50, 20 days of inactivity (By Jonern)

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

So u will use:

DELETE FROM players WHERE level > 7 AND level < 51 AND lastlogin < UNIX_TIMESTAMP() - 7*24*60*60

 

[Fallen]

>>87318
>I'm so late

 

[stanczyk]

And how do I use usuenlo such characters from 50 to 150? those that do not play 14 days?

 

[Cykotitan]

DELETE FROM players WHERE level > 49 AND level < 151 AND lastlogin < UNIX_TIMESTAMP() - 14*24*60*60

 

[stanczyk]

Thanks Cykotitan and Existance ;s Rep ++
I think add to me Rep ;p


#Edite

Thanks for adding reputation to this user. May you be lucky enough to receive the same Reputation back in turn.