Wow, for some time I've posted - or looks like at least!
When I opened a session in my WordPress dashboard (start your own WordPress blog), I was pleasantly greeted by the comments of 10,265 held for moderation:
Therefore, I have the plugin installed ProtectWebForm Captcha and I have not found if it's broken, or spammers received an automated software that solves CAPTCHA.
What I can gather, is that there will be a flurry of comments coming in a comment for each of my blog to blog. Each comment has a different IP address, but it seems to be automated based on the timestamp (or the marketer people engaged in India to do this manually, no intended stereotype).
In any case, I want a quick way to moderate the comments of 10 000 inhabitants. I want a quick way to differentiate legitimate comments and spam comments.
If you had a blog for a while, you'll quickly see that spammers will usually leave a Web site URL when they submit comments. This is the first sign that a comment may be spam.
Comments more sophisticated spam inserts the URL of Web site in the body of the comment itself, making it less obvious.
OK, the discussion below is a little technical, but you can follow along if you have a mess in your hand as I (a).
To my webhost, I have cPanel, and the database administration tool is phpMyAdmin.
Pop open phpMyAdmin and open the database of wordpress. There, you will find a table called wp_comments.
Inside of this table is a field called comment_author_url.
comment_author_url is anything but "http://" If a site Web that URL is filled during a presentation of comment.
Therefore, here is the query MySQL you can use which will return all comments who completed a Web site URL, and that is not already approved:
Note the use of the comment_approved field. It is set to ' 1' if it approved comment.From here you can then simply delete these comments, or set comment_approved "spam."That's all! Next step for me is to understand how to combat these automated comment submissions. Let me know if you know the good ways or an another plugin which works best.Select * from 'wp_comments' WHERE 'comment_author_url'! ='http: / /' and 'comment_approved '! = ' 1' ;
View the original article here
This post was made using the Auto Blogging Software from WebMagnates.org This line will not appear when posts are made after activating the software to full version.
0 Comments:
Post a Comment