Script adaugare tag-uri wordpress
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!