Did Your Coppermine Gallery (CPG) Get Spammed? Eww Spam..

Mine did, really it sucks!

Anyway if yours did too, you can get rid of all the spam in a few seconds, go to your control panel or however you get to phpMyAdmin on your server (or command line MySQL interface), whichever you are comfortable with and run this SQL statement:


DELETE FROM `cpgXXX_comments`
WHERE
msg_body LIKE '%cialis%'
OR msg_body LIKE '%viagra%'
OR msg_body LIKE '%tinyurl%'
OR msg_body LIKE '%og-seote%'
OR msg_body LIKE '%custom-tshirts%'

cpgXXX will be whatever your table prefix is for coppermine, depending on when you installed it, mine is cpg131_

You will also have to adjust the words for example OR msg_body LIKE ‘%custom-tshirts%’ can be changed to OR msg_body LIKE ‘%YOUR_SPAMWORD%’ you can just keep adding OR statements on following lines according to any of the words that uniquely identify the spam comments.

I mean don’t go deleting everything with ‘the’ in it for example.

Yah spammers are using tinyurl to spam their dirty generic viagra pills too, abusing a free service.

I hope it doesn’t effect legitimate users.

Comments

comments

Subscribe

You can subscribe via e-mail to get my posts in your Inbox, or stalk me on numerous other platforms.

Follow my Dayre!

, , , , , , , , , , , ,


6 Responses to Did Your Coppermine Gallery (CPG) Get Spammed? Eww Spam..

  1. mypapit April 8, 2006 at 7:12 pm #

    yeah, i’ve tried to remove the spam url using SQL command in phpMyAdmin interface, works like a charm. Thanks ShaolinTiger

  2. KY April 9, 2006 at 1:30 am #

    I need to castrate spammers

  3. Sashi April 10, 2006 at 9:19 am #

    I love the way SQL commands sound like deranged teenagers:

    “Delete that thing from that place where the other thing is, like, this, or OMG, like that too.”

  4. Hijackqueen April 10, 2006 at 1:37 pm #

    Wah, why you guys so canggih wan ah?

  5. ShaolinTiger April 12, 2006 at 1:03 pm #

    mypapit: No problems, glad to help 🙂

    KY: Spammers am teh suck indeed.

    Sashi: Always loved SQL, it’s like shouting orders, and it actually makes sense for once..

  6. tuxsoul September 16, 2008 at 7:57 pm #

    Maybe do you like try this plugins to block spam in coppermine gallery:
    http://forum.coppermine-gallery.net/index.php/topic,50081.0.html

    Greetings :-D.