Hi All...
Im aware that there is no way to delete ALL comments in one swoop in the admin pages, however is there a way of digging into the file structure within terminal to delete them....
I have over 1200 comments of spam!
Any advice on reducing or stopping spam to my site would also be appreciated...
Best wishes
Del
Comments
There are several spamfilter available, the 3rd party Akismet one is still maintained so I would try that. Also I would try to enable captcha.
If these are human spammers it will be hard to fight against them itself. We get loads on the forum as well.
`SELECT * FROM 'table' WHERE 'column' BETWEEN 'yyy-mm-dd hh:mm:ss' AND 'yyy-mm-dd hh:mm:ss'`
Obviously you will want to DELETE not SELECT but better to be safe first. :P
I also made a few changes to my simple spam filter so that I could enter partial IPs but I "think" you can get the same result from putting them in the section for pattern matching.
Just keep after the machine posted spam and you will weed out most of the problems after a few tries. I really found that by reading the messages posted then isolating the part that the spammer wanted to get posted and filtering from there worked wonders. I went from about 200 or so a day to a few a week. Mostly they were just new ones that needed to be added into the backend filtering.
Good luck with it.
edit: Acrylian beat me to it.
The Captcha tha comes with zenphoto is installed so not sure how they are hgetting past... I have a Akismet account so I'll plug that in
Thanks again
Del
Many thanks.. Did it through myadminphp... 1200 comments gone...
Del