Ticket #10260: src_move_wordpress.php

<?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>