• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

How to remove spammers who used Gmail addresses

jeffwidman

Active member
#1
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...
 

jeffwidman

Active member
#3
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: