<?PHP
if (isset($_POST["ok"])) {
	$host="localhost";
    $login="root";
    $pass="";
    $base="blog";
	$cnx=mysql_connect($host, $login, $pass);
	if (!$cnx) {
    echo "erreur de connexion : ".mysql_error();
    }else{
      if (!mysql_select_db($base, $cnx)) {
        echo "erreur de connexion : ".mysql_error();
      }
	}
	/* on recupere les billets de dotclear et wordpress avec leur catégories respectives */
	$A_temp_table	= array();
	$S_req			= "
		SELECT
			`dc_post`.`post_titre`,
			`dc_post`.`post_id`,
			`wp_posts`.`ID`,
			`dc_categorie`.`cat_libelle`,
			`dc_categorie`.`cat_id`,
			`wp_terms`.`term_id`,
			`wp_term_taxonomy`.`term_taxonomy_id`
		FROM
			`dc_post`
			Inner Join `dc_categorie` ON `dc_post`.`cat_id` = `dc_categorie`.`cat_id`
			Inner Join `wp_terms` ON `dc_categorie`.`cat_libelle` = `wp_terms`.`name`
			Inner Join `wp_posts` ON `dc_post`.`post_titre` = `wp_posts`.`post_title`
			Inner Join `wp_term_taxonomy` ON `wp_terms`.`term_id` = `wp_term_taxonomy`.`term_id`";
	$A_result		= mysql_query($S_req);
	if (!$A_result) echo mysql_error(); 
	while ($A_row = mysql_fetch_row($A_result)) {
		$A_temp_table[]=$A_row;
	}
	
	/* on insert les categories dans wordpress avec les bons ID (table wp_term_relationships) (il faut préalablement vider la table) */
	$I_nb_elements = count($A_temp_table);
	for ($i=0; $i < $I_nb_elements; $i++){
		$S_req_update = "
			INSERT INTO wp_term_relationships (object_id, term_taxonomy_id)
			VALUES (".$A_temp_table[$i][2].", ".$A_temp_table[$i][5].");";
			$rs = mysql_query($S_req_update);
			if (!$rs) echo mysql_error();
	}
	
	/* on met a jour le nombre de billet par catégories de la table wp_term_taxonomy (sinon les catégories ne s'affichent pas dans le front du blog) */
	$A_temp_table_count	= array();
	$S_req_count = " 
		SELECT term_taxonomy_id, count( * ) AS nb
		FROM wp_term_relationships
		GROUP BY term_taxonomy_id";
	$A_result_count	= mysql_query($S_req_count);
	if (!$A_result_count) echo mysql_error(); 
	while ($A_row_count = mysql_fetch_row($A_result_count)) {
		$A_temp_table_count[]=$A_row_count;
	}
	
	$I_nb_elements_count = count($A_temp_table_count);
	for ($i=0; $i < $I_nb_elements_count; $i++){
		$S_req_update_count = "
			UPDATE wp_term_taxonomy 
			SET count = ".$A_temp_table_count[$i][1]."
			WHERE term_taxonomy_id = ".$A_temp_table_count[$i][0].";";
			$rs = mysql_query($S_req_update_count);
			if (!$rs) echo mysql_error(); 
	}
}

?>
<form id='import' action='' method='POST'>
<table>
	<tr>
		<td><input type="submit" name="ok" value="TRANSFERT"/></td>
	</tr>
</form>
</table>