forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: polaatx on September 22, 2006, 05:40:21 am

Title: Mass removal of comments possible?
Post by: polaatx on September 22, 2006, 05:40:21 am

My site has been victim of spammers: http://lotteryofbirth.com/thumbnails.php?album=lastcom&cat=-8 (http://lotteryofbirth.com/thumbnails.php?album=lastcom&cat=-8) with many ugly links. I finally figured out how to turn off anonymous comments. But now removing all this crap will take forever. Is there a way to remove all comments quickly? Or at least, is there a way to get it not to ask for comments-delete confirmation?

Title: Re: Mass removal of comments possible?
Post by: Sami on September 22, 2006, 07:24:42 am

You can maualy delete them by phpmyadmin :
- open up the xxx_comments table from database
- here you can delete each of them or you could delete all the comments (both bad and good one) by running this query

Code: [Select]

truncate table xxx_comments
xxx_ is your  table pre fix
Once again , this query will delete all comments from the table be carefull

Title: Re: Mass removal of comments possible?
Post by: Nibbler on September 22, 2006, 07:33:03 am

To delete any comments containing links:

Code: [Select]

DELETE FROM xxx_comments WHERE msg_body LIKE '%http%'
Backup the table before you run any queries if your comments are important.