sql_3_post.php

jforum->smf database migration

<?php
function ersetzen($inhalt){
$result=str_replace("'","\'",$inhalt);
return $result;
}

$dbname="smf";
$dbhost="localhost";
$dbuser="root";
$dbpass="";
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);

mysql_query("TRUNCATE TABLE `smf_messages`;");

$i=1;
while($i<110087){
$i=$i+1;
$sql = "SELECT * FROM jforum_posts_text WHERE post_id = $i";
$result = mysql_query($sql);
$variable = mysql_fetch_array($result);

$id_msg = $variable["post_id"];
$body = ersetzen($variable["post_text"]).".";
$subject = ersetzen($variable["post_subject"]);

#-------------------------------------------------------------

$sql = "SELECT * FROM jforum_posts WHERE post_id = $i";
$result = mysql_query($sql);
$variable = mysql_fetch_array($result);

$id_topic = $variable["topic_id"];
$id_board = $variable["forum_id"];
$id_member = $variable["user_id"];

$postertime = $variable["post_time"];
                    $jah = (int)substr($postertime,0,4);
                    $mon = (int)substr($postertime,5,2);
                    $tag = (int)substr($postertime,8,2);
                    $stu = (int)substr($postertime,11,2);
                    $min = (int)substr($postertime,14,2);
                    $sek = (int)substr($postertime,17,2);
/*echo "J ".$jah." M ".$mon." T ".$tag." S ".$stu." M ".$min." S ".$sek.'<br/>';*/
$postertime = mktime($stu,$min,$sek,$mon,$tag,$jah);
                    
$poster_ip = $variable["poster_ip"];



#-------------------------------------------------------------
$sql = "SELECT * FROM jforum_users WHERE user_id = '$id_member'";
$result = mysql_query($sql);
$variable = mysql_fetch_array($result);

$username = ersetzen($variable["username"]);
$email = $variable["user_email"];




$sql = "INSERT INTO `smf_messages` 
(`ID_MSG`, `ID_TOPIC`, `ID_BOARD`, `posterTime`, `ID_MEMBER`, `ID_MSG_MODIFIED`, `subject`, `posterName`, `posterEmail`, `posterIP`, `smileysEnabled`, `modifiedTime`, `modifiedName`, `body`, `icon`) 
VALUES ('$id_msg', '$id_topic', '$id_board',  '$postertime', '$id_member', '$id_msg', '$subject', '$username', '$email', '$poster_ip', 1, 0, '', '$body', 'xx');";


$result= mysql_query($sql);
if (!$result) {
echo $i.'--'.$postertime.'<br/>';
    #die('Ung黮tige Abfrage: ' . mysql_error());
echo '</br/>'.$sql;


}
}



mysql_close();
/*DELETE FROM `smf_messages` WHERE `posterTime` = 943948800;  	*/
?>