Dealing with comment spam on Gallery 2
May 18, 2008
PHP

Finally! I found a query that effectively deletes the comment spam from the Gallery 2 database. These can be run through phpMyAdmin, but my next task is to turn this into a php script that can be run as a cron job.

To delete comments posted by an IP, or a few IPs, run this SQL statement:


delete ce, e, co from g2_ChildEntity ce, g2_Entity e, g2_Comment co where ce.g_id=e.g_id and e.g_id=co.g_id and e.g_entityType='GalleryComment' and (co.g_host='67.104.112.176' or co.g_host='209.31.123.128')

To delete comments based on the comment itself, run this SQL statement:

delete ce, e, co from g2_ChildEntity ce, g2_Entity e, g2_Comment co where ce.g_id=e.g_id and e.g_id=co.g_id and e.g_entityType='GalleryComment' and (co.g_comment like '%[url=http://%')


Ads by Google

Posted by ellen at May 18, 2008 05:42 PM


To delete comments by a specific author or authors, run this SQL statement:


delete ce, e, co from g2_ChildEntity ce, g2_Entity e, g2_Comment co where ce.g_id=e.g_id and e.g_id=co.g_id and e.g_entityType='GalleryComment' and (co.g_author like '%ialis%' or co.g_author like '%iagra%')


Many thanks to Ned Martin at Hard Answers.net


Ads by Google

3 Comments

Hello

Provide a Rich Site Summary

All these keyword phrases will add up to a flood of traffic for your site.

You can also try PPC (Pay Per Click) advertising to provide you with targeted traffic and sidestep the search engines. Well sort of!

why it is adviced to keep less links in a high PageRank page so that the link would be more valuable

I have no hesitation in recommending goowall.com promotion service to other potential clients.

Hey, ok, I get it, I guess - but does this really work?

Thanks for demonstrating another appraoch to combatting spam.

I just may give this technique a try and write about it myself!


Ads by Google

 RSS   |   Contact Me


Ads by Google