SQL Querry Need.

[Lucenzo]

Heya


Could someone possibly give me a SQL querry for the following?


If under lvl 300 and not in (1,2,3,4) <-Samples and not logged in for longer than 15 days = delete.

Thanks x x

 

[Cykotitan]

http://otland.net/f481/phpmyadmin-commands-edit-database-7751/#post87318

DELETE FROM players WHERE id > 4 AND level < 300 AND lastlogin < UNIX_TIMESTAMP() - 15*24*60*60

 

[Lucenzo]

Thanks x x

Bless you

 

[Chris]

If someone else need the same query, but has different IDs for your samples. Change

WHERE id > 4

to

WHERE id NOT IN( 1, 2, 3, 4 )

(obviously you also have to change the 1, 2, 3, 4 to the appropriate IDs)