About Date in otservers

[juan5757]

I want to delete all the old characters that were created mmm 2 weeks ago because there are many that only make a character and they dont play anymore so i entered to my database xampp and i looked for the last login and it tells me this 1241539980

 

[Mikuch]

this will delete players lvl < 20 and those who havent loged in last 10 days

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