Salutare,

Dupa ce am cumparat acum cateva zile site-ul cerintedesistem.com am observat ca inafara de cateva posturi care aveau seo spam in taguri, restul nu aveau deloc.Cum erau 1400 de posturi varianta manuala nu m-a incantat asa ca am scris un mic script care ar trebui sa mearga pe orice blog wordpress pentru a adauga in cazul meu tag-ul : minimum-system-requirements-$Post_title .Am considerat ca este o idee buna de a castiga vizite pe system requirements jocuxxx .

Codul a fost scris in mare graba si nu foarte frumos , dar in 2s a adaugat 1.400 de taguri, deci este ok.Nu stiu daca exista un plugin de genul, dar poate fi folositor.

Uita-ti cum arata :
Cod:
define('DB_NAME', 'nume');


/** MySQL database username */

define('DB_USER', 'user');


/** MySQL database password */

define('DB_PASSWORD', 'pass');


/** MySQL hostname */

define('DB_HOST', 'localhost');

/** Conectare la baza de date */

$link_id = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD);

  if (!$link_id) {

           $MYSQL_ERRONO = 0;
           $MYSQL_ERROR = "Unable to conned to host $dbhost";
           return 0;
  }
  else{
  	mysql_select_db (DB_NAME, $link_id);
  	
  }
  
$q ="select ID,post_title,post_name from wp_posts where post_status='publish' and post_type='post'";

$r=mysql_query($q);

while ($res = mysql_fetch_assoc($r)){

      $tag = "Minimum System Requirements ".$res[post_title];

      $slug = "minimum-system-requirements-".$res[post_name];

      $object_id = $res[ID];

      $q1="insert into wp_terms(name,slug,term_group) values('$tag','$slug',0)";

      $r1=mysql_query($q1);

      $q2="select term_id from wp_terms order by term_id desc limit 1";

      $r2=mysql_query($q2);

      $res1=mysql_fetch_assoc($r2);

      $term_id=$res1[term_id];

      $q3="insert into wp_term_taxonomy(term_id,taxonomy,description,parent,count) values('$term_id','post_tag','',0,1)";

      $r3=mysql_query($q3);

      $q4="select term_taxonomy_id from wp_term_taxonomy order by term_taxonomy_id desc limit 1";
       $r4=mysql_query($q4);

       $res2=mysql_fetch_assoc($r4);

       $term_taxonomy_id=$res2[term_taxonomy_id];

       $q5="insert into wp_term_relationships(object_id,term_taxonomy_id,term_order) values('$object_id','$term_taxonomy_id',0)";

       $r5=mysql_query($q5);

}
Mersi!