Cleaning up your accounts

Status
Not open for further replies.
Joined
Jun 11, 2006
Messages
518
Reaction score
0
Location
London, Ontario
Here's a simple query for anyone who didn't already know this.

DELETE FROM accounts WHERE lastip = '0.0.0.0'


It deletes every account in the accounts table with the lastip of 0.0.0.0

If the account has the IP 0.0.0.0 that means it has never been logged into.
 
Status
Not open for further replies.
Back