Resource icon

How to remove spammers who used Gmail addresses

jeffwidman

Active member
jeffwidman submitted a new resource:

How to remove spammers who used Gmail addresses - Spammers often use Gmail accounts, here's a quick tutorial for finding and removing

I'm cleaning up spam accounts in my forum, and found a bunch of email addresses with the following format:

Code:
nfljerseys@gmail.com
n.fl.jersey.s@gmail.com
nfl.jerseys@gmail.com
n.flj.er.se.ys@gmail.com

Gmail treats these all as the same email account, versus Xenforo treats them as distinct email addresses, so spammers use this trick to re-use the same email address again and again when creating spam forum accounts....

Read more about this resource...
 
To do the account deduplication you'll need something that supports a regex-find-and-replace; last I checked MySQL doesn't offer this.

You could probably spot most of them by checking for gmail addresses with 4 or more periods by doing a simple query:
Code:
WHERE email LIKE '%.%.%.%.%@gmail.com
I'd be extra careful to make sure none of them are active users though. Just to be extra safe, you could also limit it to:
Code:
WHERE message_count = 0 AND conversations_unread = 0
although this will still delete users who sent PMs to others.
 
Last edited:
Back
Top Bottom