Autoblog - get unlimited free content
Been to autoblog in the past years, and thought I should start giving back after mainly lurking here. So here is a great "autoblog trick":
Did you notice that your blog get lots of lots of spammed comments?
Some of them are "I like your blog", others are irrelevant, and others are related to the content in that way or another, lets see how we can use that spam to our benefit.
First, why would we like to do it? Google loves when pages getting updated frequently, it boosts ranking. Period. True, we would like our posts to get updated with relevant content, but (as far as autoblogs are concerned) new irrelevant content is better than nothing.
What we want to do is two things:
1. Auto approve all the comments (in this post I will show you how to approve all comments without links in their body).
2. Remove the urls in the comment url field.
For step one, all you need to do is make sure the following are set in your wordpress under discussion:
Allow people to post comments on new articles
Users must be registered and logged in to comment
Anyone posts a comment
A comment is held for moderation
Before a comment appears An administrator must always approve the comment
Comment Moderation Hold a comment in the queue if it contains or more links.
Ok, that will do it, the other thing we want to do is remove the url from the comment url field, for that you need:
1. Create a php file with this code in it:
$con = mysql_connect("Your Sql Host","Your DB User Name","Your DB Password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$sql="update wp.wp_comments set comment_author_url='',comment_approved=1";
mysql_query($sql);
pay attention to this line:
$sql="update wp.wp_comments set comment_author_url='',comment_approved=1";
Now, all you need to do is create a cron job (thats quite simple, if you get confused just ask your hosting for their help) and run that script every hour.
And... the more spam you get the more new comments you will have, the more google will like, WITHOUT linking to bad neighbourhoods!!
Ta DAM or what?