DELETE from users WHERE user is spammer

Posted on:February 18 2006

How do you distinguish spammers from normal users in a phpBB2 board using SQL? Not easy. I just did a simple
DELETE FROM phpbb_usersWHERE user_id != -1AND user_posts = 0AND user_website <> "" AND user_new_privmsg = 0AND user_unread_privmsg = 0AND 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.





Comments:


Hahaha! :D
Matthias
Quote
2006-02-20 14:22:00


that catches everyone who doesn't post? what about the spammers who does post?
lug
Quote
2006-02-22 02:33:00


Add comment:


Posted by:


Enter the missing letter in: "Intern?tional"


Text:

 

  

Possible Codes


Feature Code
Link [url] www.example.com [/url]
Bold [b]bold text[/b]
Quote [quote]quoted text[/quote]
Code [code]source code[/code]

Emoticons