1. 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

Spammers often use Gmail accounts, here's a quick tutorial for finding and removing

  1. jeffwidman

    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

    Read more about this resource...
     
    LowWaterMark likes this.
  2. Rob

    Rob Well-Known Member

    Would this work with MySQL?
     
  3. jeffwidman

    jeffwidman Active Member

    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: Dec 30, 2014
    Xon and Rob like this.

Share This Page