DELETE from users WHERE user is spammer

How do you distinguish spammers from normal users in a phpBB2 board using SQL? Not easy. I just did a simple
DELETE FROM phpbb_users
WHERE user_id != -1
AND user_posts = 0
AND user_website <> ""
AND user_new_privmsg = 0
AND user_unread_privmsg = 0
AND user_last_privmsg = 0
causing the deletion of 5000 of all 7000 user accounts of the Irrlicht Engine forum. I guess I caught most of the spammers. But some poor normal users as well, for sure. I hope they don't get too angry.

two comments, already:

Hahaha! :D
Matthias - 20 02 06 - 14:22

that catches everyone who doesn’t post? what about the spammers who does post?
lug - 22 02 06 - 02:33


Name:  
Remember personal info?
yes
no
Email (optional):
URL (optional):
Enter "layered" (antispam):
Comment:Emoticons / Textile

  ( Register your username / Log in )

Notify: Yes, send me email when someone replies.  

Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.
Note: If you type in your email adress above, it will be visible to other visitors, although it will be hidden for bots using javaScript.