mike
Banned User
How command I need execute in the SQL for Delete inactive accounts in 1 week?
Problem Delete Accounts
- Thread starter mike
- Start date
http://otland.net/f139/phpmyadmin-commands-edit-database-7751/
" * Delete inactive players, here below lvl 50, 20 days of inactivity (By Jonern)
"
" * Delete inactive players, here below lvl 50, 20 days of inactivity (By Jonern)
Code:
DELETE FROM players WHERE level < 50 AND lastlogin < UNIX_TIMEST
OP
OP
mike
Banned User
"DELETE ACCOUNTS INACTIVE... BY 7 DAYS"... Not Player below -50
- Joined
- Aug 19, 2007
- Messages
- 4,940
- Solutions
- 11
- Reaction score
- 354
PHP:
DELETE FROM players WHERE lastlogin < UNIX_TIMESTAMP() - 7 * 24 * 60 * 60
OP
OP
mike
Banned User
I need delete Accounts!!! not player!! Afff >.<
It's impossible beacuse in accounts isn't stored last login, only in players table 
OP
OP
mike
Banned User
I put to think and if one could ... the command is this..
DELETE FROM accounts WHERE lastday <UNIX_TIMESTAMP () - 14*24*60*60
DELETE ALL ACCOUNTS INACTIVE BY 14 DAYS :>
DELETE FROM accounts WHERE lastday <UNIX_TIMESTAMP () - 14*24*60*60
DELETE ALL ACCOUNTS INACTIVE BY 14 DAYS :>
Hmm 
You're right
I thought lastday is for the pacc...
You're right I thought lastday is for the pacc...