What command or MySQL inquiry could I use to delete all the spam from before the upgrade when there was no Captcha?
Thank you!
Thank you!
Deleting the Spam
- Thread starter sitepro1476
- Start date
To delete everything marked as spam, then use this:
Code:
DELETE FROM `font_comment` WHERE `status` = 'spam';OK, but... before the upgrade there was no spam classification, right? I mean, how does anything get marked as spam? Rather than just marking it as spam I just delete it, otherwise the useless comments just make the database larger.
So I think I need to...
Right?
I just want to make sure, I'm not a php/MySQL guy.
Thanks!
So I think I need to...
Code:
DELETE FROM `font_comment` WHERE `status` = 'pending';I just want to make sure, I'm not a php/MySQL guy.
Thanks!
OK...
I only have the latest version too, but I upgraded from an older version. I went ahead and executed that query and have over 3,000 less pending spammy comments, now. Good deal.
I'm not getting new spammers yet, so right now the captcha and spam measures seem to be working.
Thanks, guys! It seems to be working great and I am getting ready to upload some of my own fonts that will be exclusive to My online fonts catalog!
I only have the latest version too, but I upgraded from an older version. I went ahead and executed that query and have over 3,000 less pending spammy comments, now. Good deal.
I'm not getting new spammers yet, so right now the captcha and spam measures seem to be working.
Thanks, guys! It seems to be working great and I am getting ready to upload some of my own fonts that will be exclusive to My online fonts catalog!
I'm going to be doing a few modifications/plugins for the font scripts soon, including adding the solvemedia captcha like I have done with the file hosting script.
http://www.yetisharemods.com/topic/3-solvemedia-captcha-v33-now-supported/
http://www.yetisharemods.com/topic/3-solvemedia-captcha-v33-now-supported/