<?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 avec leur catégories */
	$A_temp_table	= array();
	$S_req			= "
		SELECT
			`wp_posts`.`ID`,
			`wp_posts`.`post_content`
		FROM
			`wp_posts`";
	$A_result		= mysql_query($S_req);
	while ($A_row = mysql_fetch_row($A_result)) {
		$A_temp_table[]=$A_row;
	}
	
	//print_rn ($A_temp_table);
	
	$I_nb_elements = count($A_temp_table);
	for ($i=0; $i < $I_nb_elements; $i++){
		$s_link 			= $A_temp_table[$i][1];
		//print_rn ($s_link);
		$s_blogLink			= "/blog/images/";
		$s_photoblogLink 	= "/photoblog/wp-includes/images/dotclear/";
		$s_finalLink		= str_replace($s_blogLink, $s_photoblogLink, $s_link);
		//print_rn ($s_finalLink);
		$S_req_update = "
			UPDATE wp_posts 
			SET post_content = '".$s_finalLink."'
			WHERE ID = ".$A_temp_table[$i][0];
			//print_rn ($S_req_update);
			mysql_query($S_req_update);
	}

}

?>
<form id='import' enctype="multipart/form-data" action='' method='POST'>
<input type='hidden' name='type_action' value=''/>
<table>
	<tr>
		<td><input type="submit" name="ok" value="MOVE"/></td>
	</tr>
</form>
</table>