sql_1_user.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("DELETE FROM `smf_members` WHERE `ID_MEMBER`>1;");

$i=1;
while($i<2796){
$i=$i+1;

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

$user_id = $variable["user_id"];
$passwd = $variable["user_password"];

$reg_date = $variable["user_regdate"];
                    $jah = (int)substr($reg_date,0,4);
                    $mon = (int)substr($reg_date,5,2);
                    $tag = (int)substr($reg_date,8,2);
                    $stu = (int)substr($reg_date,11,2);
                    $min = (int)substr($reg_date,14,2);
                    $sek = (int)substr($reg_date,17,2);
                    $reg_date=mktime($stu,$min,$sek,$mon,$tag,$jah);

$posts = $variable["user_posts"];
if($posts>0&&$posts<50)$gruppe=4;
if($posts>49&&$posts<100)$gruppe=5;
if($posts>99&&$posts<250)$gruppe=6;
if($posts>249&&$posts<500)$gruppe=7;
if($posts>499)$gruppe=8;

$hi_e = $variable["user_viewemail"]; if($hi_e=='0'){$hi_e='1';}else{$hi_e='0';}
$avatar = $variable["user_avatar"];
if(strpos($avatar,':')==0){ $avatar="_avatars_old/".$avatar;}
$email = $variable["user_email"];
$icq = $variable["user_icq"];
$from = $variable["user_from"];
$us_aim = $variable["user_aim"];
$us_yim = $variable["user_yim"];
$us_msnm = $variable["user_msnm"];


$username = ersetzen($variable["username"]);
$website = ersetzen($variable["user_website"]);
$from = ersetzen($variable["user_from"]);
$signatur =ersetzen($variable["user_sig"]);
$interes =ersetzen($variable["user_interests"]);
$biogr= ersetzen($variable["user_biography"]);
$int_bio='<b>Interessen: </b>'.$interes.'<br/><b>躡er mich: </b>'.$biogr;



$sql2 = "INSERT INTO `smf_members` (`ID_MEMBER`, `memberName`, `dateRegistered`, `posts`, `ID_GROUP`, `lngfile`, `lastLogin`, `realName`, `instantMessages`, `unreadMessages`, `buddy_list`, `pm_ignore_list`, `messageLabels`, `passwd`, `emailAddress`, `personalText`, `gender`, `birthdate`, `websiteTitle`, `websiteUrl`, `location`, `ICQ`, `AIM`, `YIM`, `MSN`, `hideEmail`, `showOnline`, `timeFormat`, `signature`, `timeOffset`, `avatar`, `pm_email_notify`, `karmaBad`, `karmaGood`, `usertitle`, `notifyAnnouncements`, `notifyOnce`, `notifySendBody`, `notifyTypes`, `memberIP`, `memberIP2`, `secretQuestion`, `secretAnswer`, `ID_THEME`, `is_activated`, `validation_code`, `ID_MSG_LAST_VISIT`, `additionalGroups`, `smileySet`, `ID_POST_GROUP`, `totalTimeLoggedIn`, `passwordSalt`) VALUES
($user_id, '$username', $reg_date, $posts, '$gruppe', '', 1185794775, '$username', 0, 0, '', '', '', '$passwd', '$email', '$int_bio', 0, '0001-01-01', '$website', '$website', '$from', '$icq', '$us_aim', '$us_yim', '$us_msnm', $hi_e, 1, '', '$signatur', 0, '$avatar', 0, 0, 0, '', 1, 1, 0, 2, '$reg_date', '192.168.1.34', '', '', 0, 1, '', 2, '', '', 0, 7001, '6c39');";


$result2= mysql_query($sql2);
if (!$result2) {
echo $i.'--'.$username.'<br/>';
    #die('Ung黮tige Abfrage: ' . mysql_error());
}
}



mysql_close();

?>