Autoblog - get unlimited free content

by enderZ
0 replies
Hi there,

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:
PHP Code:
$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); 
The details for : ("Your Sql Host","Your DB User Name","Your DB Password") can be found in the domain directory in the file wp-config.php.

pay attention to this line:
PHP Code:
 $sql="update wp.wp_comments set  comment_author_url='',comment_approved=1"
The wp.wp_comments is the default (it means the DB name is wp) if you set it to a different name it should be changed...

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?
#autoblog #content #free #unlimited

Trending Topics