.: ShaolinTiger - Kung-Fu Geekery :.

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

April 8th, 2006 by ShaolinTiger at 1:42 PM MYT - 2,267 views

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.

Tags: , , , , , , , , , , , ,

Posted in Internet & Tech | -

Related Posts:
- Combating Spam - Disable Trackbacks for Older Posts in Wordpress
- “Yue May Not Mail Me Anymore”
- Xmas Eve Party - I was Sober..
- Pukers, Partiers and Perverts
- Cialis? Viagra? Penis Enlargement? Do I look like a LIMP DICK?!
- DOTA Wallpaper

5 Comments so far

  1. mypapit  on April 8th, 2006 at 7:12 pm
    Using Mozilla Firefox Mozilla Firefox 1.5.0.1 on Windows Windows XP 

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

  2. KY  on April 9th, 2006 at 1:30 am
    Using Mozilla Firefox Mozilla Firefox 1.5.0.1 on Windows Windows XP 

    I need to castrate spammers

  3. Sashi  on April 10th, 2006 at 9:19 am
    Using Mozilla Firefox Mozilla Firefox 1.5.0.1 on Windows Windows XP 

    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  on April 10th, 2006 at 1:37 pm
    Using Mozilla Firefox Mozilla Firefox 1.0.6 on Windows Windows ME 

    Wah, why you guys so canggih wan ah?

  5. ShaolinTiger  on April 12th, 2006 at 1:03 pm
    Using Mozilla Firefox Mozilla Firefox 1.5.0.1 on Windows Windows XP 

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

Leave a reply