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