Splatt to BBtoMax

allstuff · Inscrit le: Jun 19, 2006 Messages: 19 Aucun point Recherche ou j'habite

Bonjour,

Je souhaite passer de Splatt vers BBtoMax. J'ai essayé de bricoler des scripts mais sans succès pour le moment. Je ne connais pas bien PHP ni HTML Crying or Very sad

Un conseil?

merci

Cyril · **Sujet du message:** *Posté le: Mar 05 Sep, 2006 2:28 pm*

salut

tu avais un splatt sous maximus ???

sebastien · **Sujet du message:** *Posté le: Mar 05 Sep, 2006 7:17 pm*

salut,

NOn vu son site, il devais avoir un splatt sous php-nuke....

@+

allstuff · **Sujet du message:** *Posté le: Mer 06 Sep, 2006 7:35 am*

Bonjour,

cela fait plusieurs semaines que je souhaite migrer de phpnuke vers maximus mais la tâche est ardue surtout pour mon forum (Splatt).

J'ai utilisé l'upgradeur pour transférer les utilisateurs et mes documents vers Maximus, mais avec cette solution je garde l'ensemble de mes tables qui ne sont plus utilisées par les modules non compatible Maximus. Pour avoir une solution propre, j'ai créé une nouvelle base Maximus et je transfère nuke_users, ... pas à pas .....

J'ai trouver un script pour passer de Splatt vers phpBB mais il reste des erreurs. Malheureusement, je ne suis pas un expert en PHP.

Merci pour votre aide

Voici le script:

/********************************************************/
/* Move for PHP-Nuke 6.0.0 Splatt to phpBB port */
/* By: NukeScripts Network (webmaster@nukescripts.net) */
/* http://www.nukescripts.net */
/* Copyright © 2003 by NukeScripts Network */
/********************************************************/
/* While this script contains the NSN copyright it is */
/* released as GPL as it uses some code from the phpBB */
/* port by Tom Nitzschner (tom@toms-home.com) */
/********************************************************/

ob_start("ob_gzhandler");
require_once("config.php");
require_once("includes/sql_layer.php");
global $prefix;
$dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);

function make_bbcode_uid() {
// Unique ID for this message..
$uid = md5(mt_rand());
$uid = substr($uid, 0, 10);
return $uid;
}

//Insert categories info
if(!sql_query("DELETE FROM nuke_bbcategories",$dbi)){
printf ("error to delete")};
$result1 = sql_query("SELECT cat_id, cat_title, cat_order FROM ".$prefix."_splattforum_catagories ORDER BY cat_id", $dbi);
while (list($cat_id, $cat_title, $cat_order) = sql_fetch_row($result1, $dbi)) {
if(!sql_query("INSERT INTO ".$prefix."_bbcategories VALUES ($cat_id, '$cat_title', $cat_order)", $dbi)) {
printf(" Error in category transfer!\n");
}
}
echo "Categories Transfered!\n";

//Insert forums info
if(!sql_query("DELETE FROM nuke_bbforums",$dbi){
printf ("error to delete")};
$result2 = sql_query("SELECT forum_id, forum_name, forum_desc, cat_id FROM ".$prefix."_splattforum_forums ORDER BY cat_id, forum_id", $dbi);
while (list($forum_id, $forum_name, $forum_desc, $cat_id) = sql_fetch_row($result2, $dbi)) {
$forum_posts = sql_num_rows(sql_query("SELECT * FROM ".$prefix."_splattform_posts WHERE forum_id='$forum_id'", $dbi), $dbi);
$forum_topics = sql_num_rows(sql_query("SELECT * FROM ".$prefix."_splattforum_forumtopics WHERE forum_id='$forum_id'", $dbi), $dbi);
printf ("$forum_name, $forum_desc, $forum_posts, $forum_topics\n");
if(!sql_query("INSERT INTO ".$prefix."_bbforums VALUES ($forum_id, $cat_id, '$forum_name','$forum_desc',0,0,$forum_posts,$forum_topics,0,NULL,0,0,0,1,1,1,5,5,3,1,5,0)", $dbi)) {
printf(" Error in $forum_name transfer!\n");
}
echo "Forum = $forum_id - Posts = $forum_posts - Topics = $forum_topics\n";
}
echo "Forums Transfered!\n";

// Insert topics info
if(!sql_query("DELETE FROM nuke_bbtopics",$dbi){
printf ("error to delete")};
$result3 = sql_query("SELECT topic_id, topic_title, topic_poster, topic_time, topic_views, forum_id, topic_status FROM ".$prefix."_splattforum_forumtopics", $dbi);
while (list($topic_id, $topic_title, $topic_poster, $topic_time, $topic_views, $forum_id, $topic_status) = sql_fetch_row($result3, $dbi)) {
$topic_title = stripslashes($topic_title);
$topic_title = ereg_replace("\'","´",$topic_title);
$topic_title = ereg_replace("\"",""",$topic_title);
$topic_title = addslashes($topic_title);
$topic_replies = sql_num_rows(sql_query("SELECT * FROM ".$prefix."_splattforum_posts WHERE topic_id='$topic_id'", $dbi), $dbi);
$topic_time = strtotime($topic_time);
if(!sql_query("INSERT INTO ".$prefix."_bbtopics VALUES ('$topic_id', '$forum_id', '$topic_title', '$topic_poster', '$topic_time', '$topic_views', '$topic_replies', '$topic_status','','','','','')", $dbi)) {
echo " Error in $topic_title transfer!\n";
}
}
echo "Topics Transfered!\n";

// Insert posts info
if(!sql_query("DELETE FROM nuke_bbposts",$dbi){
printf ("error to delete")};
$result5 = sql_query("SELECT post_id, topic_id, forum_id, poster_id, post_text, post_time, poster_ip FROM ".$prefix."_splattforum_posts", $dbi);
while (list($post_id, $topic_id, $forum_id, $poster_id, $post_text, $post_time, $poster_ip) = sql_fetch_row($result5, $dbi)) {
$ip_sep = explode('.', $poster_ip);
$poster_dip = sprintf('%02x%02x%02x%02x', $ip_sep[0], $ip_sep[1], $ip_sep[2], $ip_sep[3]);
$post_text = stripslashes($post_text);
$post_text = ereg_replace("\'","´",$post_text);
$post_text = ereg_replace("\"",""",$post_text);
$post_text = ereg_replace("\[addsig\]","",$post_text);
$post_text = addslashes($post_text);
$post_time = strtotime($post_time);
$bbcode_uid = md5(mt_rand());
$bbcode_uid = substr($bbcode_uid, 0, 10);
list($post_username) = sql_fetch_row(sql_query("SELECT uname FROM ".$user_prefix."_users WHERE uid='$poster_id'", $dbi), $dbi);
list($post_subject) = sql_fetch_row(sql_query("SELECT topic_title FROM ".$prefix."_bbtopics WHERE topic_id='$topic_id'", $dbi), $dbi);
$post_subject = stripslashes($post_subject);
$post_subject = ereg_replace("\'","´",$post_subject);
$post_subject = ereg_replace("\"",""",$post_subject);
$post_subject = addslashes($post_subject);
if(!sql_query("INSERT INTO ".$prefix."_bbposts VALUES ($post_id, $topic_id, $forum_id, $poster_id, $post_time, '$poster_ip', '$post_username', 1, 0, 1, 1, NULL, 0)", $dbi)) {
echo " Error in $post_id Post transfer!\n";
}
if(!sql_query("INSERT INTO ".$prefix."_bbposts_text VALUES ($post_id, '$bbcode_uid', '$post_subject', '$post_text')", $dbi)) {
echo " Error in $post_id Text transfer!\n";
}
}
echo "Posts Transfered!\n";

// Insert first and last post for each topic
$result6 = sql_query("SELECT topic_id FROM ".$prefix."_bbtopics", $dbi);
while (list($topic_id) = sql_fetch_row($result6, $dbi)) {
list($firstpost) = sql_fetch_row(sql_query("SELECT post_id FROM ".$prefix."_bbposts WHERE topic_id='$topic_id' ORDER BY post_id LIMIT 0,1", $dbi), $dbi);
if(!sql_query("UPDATE ".$prefix."_bbtopics SET topic_first_post_id='$firstpost' WHERE topic_id='$topic_id'", $dbi)) {
echo " Error in $topic_title first post update!\n";
}
list($lastpost) = sql_fetch_row(sql_query("SELECT post_id FROM ".$prefix."_bbposts WHERE topic_id='$topic_id' ORDER BY post_id DESC LIMIT 0,1", $dbi), $dbi);
if(!sql_query("UPDATE ".$prefix."_bbtopics SET topic_last_post_id='$lastpost' WHERE topic_id='$topic_id'", $dbi)) {
echo " Error in $topic_title first post update!\n";
}
}
echo "Topics Updated!\n";

allstuff · **Sujet du message:** *Posté le: Dim 10 Sep, 2006 5:48 pm*

re -salut,

je souhaite simplement savoir si ce script a une chance de fonctionner pour la partie initialisation (ouvrir la db, recherche des variables). J'ai activé dbi mais il me renvoi sur la page index?

Merci

Bruno