Hard Answers |
Delete Comment Spam From Gallery |
|
Mass-delete comment spam from GalleryEver woken up to find your Gallery full of comment spam? Ever tried deleting the comment spam, one by one? Not good... Here’s how to delete it directly from the database, all at once (for Gallery 2.x). You will need access to the database running behind your Gallery. This can often be through phpMyAdmin in cPanel or similar. You’ll need to change the parts in bold to match what you’re trying to delete. Note that a % is a wildcard in SQL, so matches anything. For example, ‘%a%’ would match anything with an ‘a’ in it, and ‘209.31.123%’ would match anything starting in ‘209.31.123’. 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://%') 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%') More InformationFore more information on:
Updated about 8 mths, 26 days ago (October 11, 2007). Know a better answer? Let us know! Related categories . acpi album apache artist asio cache caching [comment] [computer] epg episode [gallery] golf gossip girl [hosting] hotlinking html linux live messenger mce media center messenger mod_rewrite mp3 msn msn messenger music [mysql] negative delta time ost [pc] php pilot playlist power management remote control seo song soundblaster soundtrack [spam] sport [sql] str suspend television template tv unreal tournament ut video vista vmc [web] windows xhtml xp yahoo messenger
Comment on this article (no HTML, max 1200 characters): |
||
| Got a question? Ask us. | Copyright © 2008 Ned Martin | |