sql_4_board.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_boards`;");
mysql_query("TRUNCATE TABLE `smf_categories`;");
mysql_query("INSERT INTO `smf_categories` (`ID_CAT`, `catOrder`, `name`, `canCollapse`) VALUES (3, 1, 'Trends &amp; Fans', 1),
(1, 0, 'Alles rund ums Zeichnen', 1),(4, 2, 'Moderiert', 1),(6, 3, 'Allgemeines', 1),(7, 4, 'Administratives', 0);");




$i=0;
while($i<23){
$i=$i+1;

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

$id_board = $variable["forum_id"];
$id_cat = $variable["categories_id"];
$name = $variable["forum_name"];
$description = $variable["forum_desc"];
$boardorder = $variable["forum_order"];
$numtopics = $variable["forum_topics"];
$id_topic = $variable["forum_last_post_id"];




$sql = "INSERT INTO `smf_boards` (`ID_BOARD`, `ID_CAT`, `childLevel`, `ID_PARENT`, `boardOrder`, `ID_LAST_MSG`, `ID_MSG_UPDATED`, `memberGroups`, `name`, `description`, `numTopics`, `numPosts`, `countPosts`, `ID_THEME`, `permission_mode`, `override_theme`) VALUES 
('$id_board', '$id_cat', 0, 0, '$boardorder', '$id_topic', 0, '-1,0,2,4,5,6,7,8', '$name', '$description', '$numtopics', 0, 0, 0, 0, 0);";


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

mysql_query("UPDATE `smf_boards` SET numPosts = ( SELECT count( ID_BOARD ) FROM smf_messages WHERE ID_BOARD ='$id_board' ) WHERE ID_BOARD ='$id_board';");

}

mysql_query("DELETE FROM `smf_boards` WHERE name = description;");








mysql_close();

?>