SEO From the Dark Side

Content creation is the life-blood of blackhat SEOs. Without some way of auto-generating content, there’s no traffic and, most importantly therefore, no sales which means no money!

There’s a variety of ways to create content including scraping blog feeds, scraping article banks (like goarticles and ezinearticles), scraping sites directly, using databases like Wiki’s, etc.

However, an important factor to consider when creating content is LSI:

Initially, search engines would look solely for the presence and frequency of keywords on a webpage to determine relevancy. But such an approach can result in poor results. For example, search results might distinguish between synonyms, such as “car” and “automobile,” or fail to distinguish between polynyms (words which have multiple meanings) such as “apple” and “computer.” Latent Semantic Indexing (LSI) is an approach to understanding keywords in the context of the words on the entire webpage.

Read more about Latent Semantic Indexing.

So, for ranking purposes, we don’t just want to use any old content for our sites, we want relevant content. For instance, if I’m creating a blog about yeast infections, I want to embed my keywords in content related to yeast infections, and not something else!

Finding and scraping sites to generate content for a network of blackhat sites can be a pain in the ass and very time consuming. But, is there a better way? You bet! Why not create your very own content creation engine? And it’s easier than you think!

1. Create a MySQL database.

2. Create a table for each niche you want content for and two fields in each table: ID and Articles. So, for acne you would have the table called acne and ID and Articles fields. ID is obviously the primary key while Articles hold the acne articles.

3. You need a scraper script  or ton of PLR . Populate the database tables with at least several hundred articles each. You can always add more niche tables and articles at a later date.

4. Now you need a php script that accepts the niche as a parameter, connects to the database, grabs about 20 random articles from the chosen niche (table), combines and manipulates the articles to create one unique article and then outputs it. Here’s a bare-bones script to get you started:

<?php
 function createarticle($niche) {
 
  $result = mysql_query(”SELECT articles FROM $niche ORDER BY RAND() LIMIT 20″);
  while ($row = mysql_fetch_array($result)) {

   $source .= $row[’articles’]; 
  }

  $min = 300;
  $max = 650;
 
  $words = explode(” “, $source); 
  $nonword = $words[count($words)-1]; 
  $w1 = $nonword; 
  foreach($words as $word) {  
   $wordpairs[$w1][] = $word;
   if (strpos($w1, “.”) === strlen($w1)-1) $capitals[] = $w1; 
   $w1 = $word;  
  } 

  $nw=rand($min,$max); 
  $tt = array_rand($capitals); 
  $nonword = $capitals[$tt]; 
  $w1 = $nonword; 
  $output=”"; 
  for($i = 0; $i <$nw; $i++) {  
   $suf = $wordpairs[$w1];  
   $t = array_rand($suf); 
   $ttt = $suf[$t];
   if(rand(1,5)==3) $ttt = preg_replace(”/\./”, “.\n\n”, $ttt); 
   $output .= $ttt.” “; 
   $w1 = $suf[$t];  
  }  
 
  $output = trim($output) . “.”;

  return $output;
 }
 $Database_Name = “database”;
 $Database_Username = “user”;
 $Database_Password = “pass”; 
 $Database_Host = “localhost”;

 $DBConn = mysql_connect($Database_Host, $Database_Username, $Database_Password) or die(”Could not connect to database server. Check your settings.”);
 $DB_DB = mysql_select_db($Database_Name, $DBConn) or die(”Could not connect to database ($Database_Name). Perhaps you don’t have the right permissions on this DB. Check your settings”);

 $niche = $_GET[”niche”];

 $article = createarticle($niche);

 echo $article;
?>

Now you can create essentially unlimited amounts of unique content. However, the above script is very simple and the content it creates is low-quality (single chain) Markov, so you need to improve it… but it’s a starting point!