phpBB to php nuke

Gannet · New Member Joined: Oct 27, 2004 Posts: 1

I have a phpBB forum 2.0.8 and i want to import the data to the forum in phpnuke,

i have tried backing up the database and then restoring it in phpnukes forum but it say there are errors in the sql.

Any help

Thanks

Raven · Posted: Wed Oct 27, 2004 5:25 pm

This is the last version I worked with. Follow the instructions at the top and run this from the directory of you phpNuke site where the config.php is located.

Code:

<?php
/****************************************************************
* phpBB2 to BB2Nuke (c) 2003 Andareed
* Fixed June 2003 UKForums - http://www.ruleit.co.uk/nuke
*
* This converter is released under the GNU GPL license
*
* You will need to manually edit/update your config table
****************************************************************/
/****************************************************************
**
** Tweaked by Gaylen Fraley (Raven)
**
1 - Run the import script
2 - Change the -1 userid to 0 or (1 if 1 is not already used) in nuke_users.
3 - Using phpMyAdmin, change all poster_id from -1 to 0 in nuke_bbposts.
4 - Using phpMyAdmin, change all topics_poster from -1 to 0 in nuke_bbtopics.
5 - Using phpMyAdmin, change all forum_last_poster_id from -1 to 0 in nuke_bbforums.
6 - Manually export/import the wordlist and wordmatch tables.
****************************************************************/

// MODIFY THE ENTRIES BELOW TO YOU DATABASE!!!

set_time_limit(0);
include ("config.php");

//phpBB2 variables
$p_user="phpbb database uname";
$p_pass="phpbb database pass";
$p_db="phpbb database name";
$p_host="localhost";
$p_prefix="phpbb"; //BE SURE TO USE AN UNDERSCORE IF YOUR PREFIX IS phpbb_ . It is not added in the PHPBB parameters. It is in the Nuke parameters though.

// DO NOT MODIFY ANYTHING BELOW !!!

//PHP-Nuke Variables from config.php
$n_user="$dbuname";
$n_pass="$dbpass";
$n_db="$dbname";
$n_host="$dbhost";
$n_prefix="$prefix";

//connect to db's
$p_con=mysql_connect($p_host,$p_user,$p_pass) or die('Couldn\'t connect to '.$p_host.' - '.mysql_error());
$n_con=mysql_connect($n_host,$n_user,$n_pass) or die('Couldn\'t connect to '.$n_host.' - '.mysql_error());

error_reporting(E_ALL);

// DELETE OLD TABLE DATA

mysql_select_db($n_db,$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbauth_access",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbbanlist",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbcategories",$n_con) or mysql_error();
//mysql_query("DELETE FROM {$n_prefix}_bbconfig",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbdisallow",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbforum_prune",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbforums",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbgroups",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbposts",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbposts_text",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbprivmsgs",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbprivmsgs_text",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbranks",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbsearch_results",$n_con) or mysql_error();
//mysql_query("DELETE FROM {$n_prefix}_bbsearch_wordlist",$n_con) or mysql_error();
//mysql_query("DELETE FROM {$n_prefix}_bbsearch_wordmatch",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbsessions",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbsmilies",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbthemes",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbthemes_name",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbtopics",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbtopics_watch",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbuser_group",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_users",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbvote_desc",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbvote_results",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbvote_voters",$n_con) or mysql_error();
mysql_query("DELETE FROM {$n_prefix}_bbwords",$n_con) or mysql_error();

// START EXPORTING/IMPORTING

global $row,$result,$count;
mysql_select_db($p_db,$p_con);

// phpbb_auth_access
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}auth_access",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbauth_access SET
group_id='{$row['group_id']}',
forum_id='{$row['forum_id']}',
auth_view='{$row['auth_view']}',
auth_read='{$row['auth_read']}',
auth_post='{$row['auth_post']}',
auth_reply='{$row['auth_reply']}',
auth_edit='{$row['auth_edit']}',
auth_delete='{$row['auth_delete']}',
auth_sticky='{$row['auth_sticky']}',
auth_announce='{$row['auth_announce']}',
auth_vote='{$row['auth_vote']}',
auth_pollcreate='{$row['auth_pollcreate']}',
auth_attachments='{$row['auth_attachments']}',
auth_mod='{$row['auth_mod']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_banlist
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}banlist",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_banlist SET
ban_id='{$row['ban_id']}',
ban_userid='{$row['ban_userid']}',
ban_ip='{$row['ban_ip']}',
ban_email='{$row['ban_email']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_categories
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}categories",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbcategories SET
cat_id='{$row['cat_id']}',
cat_title='{$row['cat_title']}',
cat_order='{$row['cat_order']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_config
/*mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}config",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbconfig SET
config_name='{$row['config_name']}',
config_value='{$row['config_value']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);*/

// phpbb_disallow
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}disallow",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbdisallow SET
disallow_id='{$row['disallow_id']}',
disallow_username='{$row['disallow_username']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_forum_prune
// FIXED BY UKFORUMS
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}forum_prune",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{

fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbforum_prune SET
prune_id='{$row['prune_id']}',
forum_id='{$row['forum_id']}',
prune_days='{$row['prune_days']}',
prune_freq='{$row['prune_freq']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_forums
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}forums",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbforums SET
forum_id='{$row['forum_id']}',
cat_id='{$row['cat_id']}',
forum_name='{$row['forum_name']}',
forum_desc='{$row['forum_desc']}',
forum_status='{$row['forum_status']}',
forum_order='{$row['forum_order']}',
forum_posts='{$row['forum_posts']}',
forum_topics='{$row['forum_topics']}',
forum_last_post_id='{$row['forum_last_post_id']}',
prune_next='{$row['prune_next']}',
prune_enable='{$row['prune_enable']}',
auth_view='{$row['auth_view']}',
auth_read='{$row['auth_read']}',
auth_post='{$row['auth_post']}',
auth_reply='{$row['auth_reply']}',
auth_edit='{$row['auth_edit']}',
auth_delete='{$row['auth_delete']}',
auth_sticky='{$row['auth_sticky']}',
auth_announce='{$row['auth_announce']}',
auth_vote='{$row['auth_vote']}',
auth_pollcreate ='{$row['auth_pollcreate']}',
auth_attachments ='{$row['auth_attachments']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_groups
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}groups",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbgroups SET
group_id='{$row['group_id']}',
group_type='{$row['group_type']}',
group_name='{$row['group_name']}',
group_description='{$row['group_description']}',
group_moderator='{$row['group_moderator']}',
group_single_user='{$row['group_single_user']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_posts
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}posts",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbposts SET
post_id='{$row['post_id']}',
topic_id='{$row['topic_id']}',
forum_id='{$row['forum_id']}',
poster_id='{$row['poster_id']}',
post_time='{$row['post_time']}',
poster_ip='{$row['poster_ip']}',
post_username='{$row['post_username']}',
enable_bbcode='{$row['enable_bbcode']}',
enable_html='{$row['enable_html']}',
enable_smilies='{$row['enable_smilies']}',
enable_sig='{$row['enable_sig']}',
post_edit_time='{$row['post_edit_time']}',
post_edit_count='{$row['post_edit_count']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_posts_text
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}posts_text",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbposts_text SET
post_id='{$row['post_id']}',
bbcode_uid='{$row['bbcode_uid']}',
post_subject='{$row['post_subject']}',
post_text='{$row['post_text']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_privmsgs
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}privmsgs",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();

mysql_query("INSERT INTO {$n_prefix}_bbprivmsgs SET
privmsgs_id='{$row['privmsgs_id']}',
privmsgs_type='{$row['privmsgs_type']}',
privmsgs_subject='{$row['privmsgs_subject']}',
privmsgs_from_userid='{$row['privmsgs_from_userid']}',
privmsgs_to_userid='{$row['privmsgs_to_userid']}',
privmsgs_date='{$row['privmsgs_date']}',
privmsgs_ip='{$row['privmsgs_ip']}',
privmsgs_enable_bbcode='{$row['privmsgs_enable_bbcode']}',
privmsgs_enable_html='{$row['privmsgs_enable_html']}',
privmsgs_enable_smilies='{$row['privmsgs_enable_smilies']}',
privmsgs_attach_sig='{$row['privmsgs_attach_sig']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_privmsgs_text
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}privmsgs_text",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbprivmsgs_text SET
privmsgs_text_id='{$row['privmsgs_text_id']}',
privmsgs_bbcode_uid='{$row['privmsgs_bbcode_uid']}',
privmsgs_text='{$row['privmsgs_text']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_ranks
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}ranks",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbranks SET
rank_id='{$row['rank_id']}',
rank_title='{$row['rank_title']}',
rank_min='{$row['rank_min']}',
rank_special='{$row['rank_special']}',
rank_image='{$row['rank_image']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_search_results
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}search_results",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsearch_results SET
search_id='{$row['search_id']}',
session_id='{$row['session_id']}',
search_array='{$row['search_array']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_search_wordlist
/*mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}search_wordlist",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsearch_wordlist SET
word_text='{$row['word_text']}',
word_id='{$row['word_id']}',
word_common='{$row['word_common']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);*/

// phpbb_search_wordmatch
/*mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}search_wordmatch",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsearch_wordmatch SET
post_id='{$row['post_id']}',
word_id='{$row['word_id']}',
title_match='{$row['title_match']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);*/

// phpbb_sessions
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}sessions",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsessions SET
session_id='{$row['session_id']}',
session_user_id='{$row['session_user_id']}',
session_start='{$row['session_start']}',
session_time='{$row['session_time']}',
session_ip='{$row['session_ip']}',
session_page='{$row['session_page']}',
session_logged_in='{$row['session_logged_in']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_smilies
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}smilies",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbsmilies SET
smilies_id='{$row['smilies_id']}',
code='{$row['code']}',
smile_url='{$row['smile_url']}',
emoticon='{$row['emoticon']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_themes
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}themes",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbthemes SET
themes_id='{$row['themes_id']}',
template_name='{$row['template_name']}',
style_name='{$row['style_name']}',
head_stylesheet='{$row['head_stylesheet']}',
body_background='{$row['body_background']}',
body_bgcolor='{$row['body_bgcolor']}',
body_text='{$row['body_text']}',
body_link='{$row['body_link']}',
body_vlink='{$row['body_vlink']}',
body_alink='{$row['body_alink']}',
body_hlink='{$row['body_hlink']}',
tr_color1='{$row['tr_color1']}',
tr_color2='{$row['tr_color2']}',
tr_color3='{$row['tr_color3']}',
tr_class1='{$row['tr_class1']}',
tr_class2='{$row['tr_class2']}',
tr_class3='{$row['tr_class3']}',
th_color1='{$row['th_color1']}',
th_color2='{$row['th_color2']}',
th_color3='{$row['th_color3']}',
th_class1='{$row['th_class1']}',
th_class2='{$row['th_class2']}',
th_class3='{$row['th_class3']}',
td_color1='{$row['td_color1']}',
td_color2='{$row['td_color2']}',
td_color3='{$row['td_color3']}',
td_class1='{$row['td_class1']}',
td_class2='{$row['td_class2']}',
td_class3='{$row['td_class3']}',
fontface1='{$row['fontface1']}',
fontface2='{$row['fontface2']}',
fontface3='{$row['fontface3']}',
fontsize1='{$row['fontsize1']}',
fontsize2='{$row['fontsize2']}',
fontsize3='{$row['fontsize3']}',
fontcolor1='{$row['fontcolor1']}',
fontcolor2='{$row['fontcolor2']}',
fontcolor3='{$row['fontcolor3']}',
span_class1='{$row['span_class1']}',
span_class2='{$row['span_class2']}',
span_class3='{$row['span_class3']}',
img_size_poll='{$row['img_size_poll']}',
img_size_privmsg='{$row['img_size_privmsg']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_themes_name
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}themes_name",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbthemes_name SET
themes_id='{$row['themes_id']}',
tr_color1_name='{$row['tr_color1_name']}',
tr_color2_name='{$row['tr_color2_name']}',
tr_color3_name='{$row['tr_color3_name']}',
tr_class1_name='{$row['tr_class1_name']}',
tr_class2_name='{$row['tr_class2_name']}',
tr_class3_name='{$row['tr_class3_name']}',
th_color1_name='{$row['th_color1_name']}',
th_color2_name='{$row['th_color2_name']}',
th_color3_name='{$row['th_color3_name']}',
th_class1_name='{$row['th_class1_name']}',
th_class2_name='{$row['th_class2_name']}',
th_class3_name='{$row['th_class3_name']}',
td_color1_name='{$row['td_color1_name']}',
td_color2_name='{$row['td_color2_name']}',
td_color3_name='{$row['td_color3_name']}',
td_class1_name='{$row['td_class1_name']}',
td_class2_name='{$row['td_class2_name']}',
td_class3_name='{$row['td_class3_name']}',
fontface1_name='{$row['fontface1_name']}',
fontface2_name='{$row['fontface2_name']}',
fontface3_name='{$row['fontface3_name']}',
fontsize1_name='{$row['fontsize1_name']}',
fontsize2_name='{$row['fontsize2_name']}',
fontsize3_name='{$row['fontsize3_name']}',
fontcolor1_name='{$row['fontcolor1_name']}',
fontcolor2_name='{$row['fontcolor2_name']}',
fontcolor3_name='{$row['fontcolor3_name']}',
span_class1_name='{$row['span_class1_name']}',
span_class2_name='{$row['span_class2_name']}',
span_class3_name='{$row['span_class3_name']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_topics
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}topics",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbtopics SET
topic_id='{$row['topic_id']}',
forum_id='{$row['forum_id']}',
topic_title='{$row['topic_title']}',
topic_poster='{$row['topic_poster']}',
topic_time='{$row['topic_time']}',
topic_views='{$row['topic_views']}',
topic_replies='{$row['topic_replies']}',
topic_status='{$row['topic_status']}',
topic_vote='{$row['topic_vote']}',
topic_type='{$row['topic_type']}',
topic_first_post_id='{$row['topic_first_post_id']}',
topic_last_post_id='{$row['topic_last_post_id']}',
topic_moved_id='{$row['topic_moved_id']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_topics_watch
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}topics_watch",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbtopics_watch SET
topic_id='{$row['topic_id']}',
user_id='{$row['user_id']}',
notify_status='{$row['notify_status']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_user_group
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}user_group",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbuser_group SET
group_id='{$row['group_id']}',
user_id='{$row['user_id']}',
user_pending='{$row['user_pending']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_users
//FIXED BY UKFORUMS
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}users",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
$row['user_regdate'] = date("M j, Y", $row['user_regdate']);
mysql_query("INSERT INTO {$n_prefix}_users SET
user_id='{$row['user_id']}',
user_active='{$row['user_active']}',
name='{$row['username']}',
username='{$row['username']}',
user_password='{$row['user_password']}',
user_session_time='{$row['user_session_time']}',
user_session_page='{$row['user_session_page']}',
user_lastvisit='{$row['user_lastvisit']}',
user_regdate='{$row['user_regdate']}',
user_level='{$row['user_level']}',
user_posts='{$row['user_posts']}',
user_timezone='{$row['user_timezone']}',
user_style='{$row['user_style']}',
user_lang='{$row['user_lang']}',
user_dateformat='{$row['user_dateformat']}',
user_new_privmsg='{$row['user_new_privmsg']}',
user_unread_privmsg='{$row['user_unread_privmsg']}',
user_last_privmsg='{$row['user_last_privmsg']}',
user_emailtime='{$row['user_emailtime']}',
user_viewemail='{$row['user_viewemail']}',
user_attachsig='{$row['user_attachsig']}',
user_allowhtml='{$row['user_allowhtml']}',
user_allowbbcode='{$row['user_allowbbcode']}',
user_allowsmile='{$row['user_allowsmile']}',
user_allowavatar='{$row['user_allowavatar']}',
user_allow_pm='{$row['user_allow_pm']}',
user_allow_viewonline='{$row['user_allow_viewonline']}',
user_notify='{$row['user_notify']}',
user_notify_pm='{$row['user_notify_pm']}',
user_popup_pm='{$row['user_popup_pm']}',
user_rank='{$row['user_rank']}',
user_avatar='{$row['user_avatar']}',
user_avatar_type='{$row['user_avatar_type']}',
user_email='{$row['user_email']}',
user_icq='{$row['user_icq']}',
user_website='{$row['user_website']}',
user_from='{$row['user_from']}',
user_sig='{$row['user_sig']}',
user_sig_bbcode_uid='{$row['user_sig_bbcode_uid']}',
user_aim='{$row['user_aim']}',
user_yim='{$row['user_yim']}',
user_msnm='{$row['user_msnm']}',
user_occ='{$row['user_occ']}',
user_interests='{$row['user_interests']}',
user_actkey='{$row['user_actkey']}',
user_newpasswd='{$row['user_newpasswd']}'
",$n_con) or mysql_error();
}
mysql_free_result($result);

// phpbb_vote_desc
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}vote_desc",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con) or mysql_error();
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}_bbvote_desc SET
vote_id='{$row['vote_id']}',
topic_id='{$row['topic_id']}',
vote_text='{$row['vote_text']}',
vote_start='{$row['vote_start']}',
vote_length='{$row['vote_length']}'
",$n_con);
}
mysql_free_result($result);

// phpbb_vote_results
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}vote_results",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con);
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}bbvote_results SET
vote_id='{$row['vote_id']}',
vote_option_id='{$row['vote_option_id']}',
vote_option_text='{$row['vote_option_text']}',
vote_result='{$row['vote_result']}'
",$n_con);
}
mysql_free_result($result);

// phpbb_vote_voters
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}vote_voters",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con);
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}bbvote_voters SET
vote_id='{$row['vote_id']}',
vote_user_id='{$row['vote_user_id']}',
vote_user_ip='{$row['vote_user_ip']}'
",$n_con);
}
mysql_free_result($result);

// phpbb_words
mysql_select_db($p_db,$p_con);
$result=mysql_query("SELECT * FROM {$p_prefix}words",$p_con);
$count=mysql_num_fields($result);
mysql_select_db($n_db,$n_con);
while($row=mysql_fetch_array($result))
{
fixQuotes();
mysql_query("INSERT INTO {$n_prefix}bbwords SET
word_id='{$row['word_id']}',
word='{$row['word']}',
replacement='{$row['replacement']}'
",$n_con);
}
mysql_free_result($result);

function fixQuotes()
{
global $row,$result,$count;
for($i=0;$i<$count;$i++)
{
$field=mysql_field_name($result,$i);
$row[$field]=str_replace("'","\'",$row[$i]);
}
}

//phpinfo();
?>

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Recieved this error

Quote:

Warning: set_time_limit(): Cannot set time limit in safe mode in /home/virtual/site97/fst/var/www/html/PHPBB_import.php on line 24

Do I do anything to this in the setup?

set_time_limit(0);

Nuke site has members added but no forums were added.

Raven · Posted: Tue Nov 30, 2004 12:20 pm

Just comment out that line. Your host has restricted you. Also, go here for the latest edition

Only registered users can see links on this board!
Get registered or login to the forums!

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

42 members were imported, but still don't get a forum.

Only registered users can see links on this board!
Get registered or login to the forums!

Trying to import from:

Only registered users can see links on this board!
Get registered or login to the forums!

Raven · Posted: Tue Nov 30, 2004 1:27 pm

Try going into Forum management and select Resync on the forums you imported.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Nope

Doesn't matter what theme I use either.

I looked into all the Nuke tables in phpmyadmin and everything is there, just wont come up.

Donovan · Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I haven't done the last step yet

6 - Manually export/import the wordlist and wordmatch tables.

I don't see wordlist and wordmatch.

I have search_wordlist and search_wordmatch

I also have words in the phpbb database that did not get imported into nuke_bbwords

Static · New Member Joined: Dec 30, 2004 Posts: 4

Wow. I'm having the same problem too, but I don't understand how to change it. I'm not that new on html and all of these codes, but I'm new to the advanced parts of it. How do I change the code? And where can I even find the script that says all of that stuff?

Raven · Posted: Thu Dec 30, 2004 10:43 pm

Just copy and paste that code into your editor and save it.

Static · New Member Joined: Dec 30, 2004 Posts: 4

But what I mean is what file? What file are we talking about, and how do I get to it? Lol. Thanks for the help raven, I appreciate it buddy!

Raven · Posted: Fri Dec 31, 2004 12:22 am

You create the file by copying that script above and pasting into your editor. Then save the new file and call it whatever you want. Then, you change this part of the script

Code:

// MODIFY THE ENTRIES BELOW TO YOU DATABASE!!!

set_time_limit(0);
include ("config.php");

//phpBB2 variables
$p_user="phpbb database uname";
$p_pass="phpbb database pass";
$p_db="phpbb database name";
$p_host="localhost";
$p_prefix="phpbb"; //BE SURE TO USE AN UNDERSCORE IF YOUR PREFIX IS phpbb_ . It is not added in the PHPBB parameters. It is in the Nuke parameters though.

to suit your needs.

Static · New Member Joined: Dec 30, 2004 Posts: 4

I feel so stupid right now. What is all of this...

$p_user="phpbb database uname";
$p_pass="phpbb database pass";
$p_db="phpbb database name";
$p_host="localhost";
$p_prefix="phpbb"; //BE SURE TO USE AN UNDERSCORE IF YOUR PREFIX IS phpbb_ . It is not added in the PHPBB parameters. It is in the Nuke parameters though.

I feel really bad asking you guys all of these questions, but it's gunna pay off in the end. Too bad you don't get anything out of it raven lol.

Nate · New Member Joined: Jan 01, 2005 Posts: 6

I too am trying to make the move from phpbb to phpNuke. I tried the older conversion scripts and get tons of errors. I've tried running the script posted above, and get a pagefull of errors like this:

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/...(path-to-the-script).../nsql.php on line 96

Any ideas?

Raven · Posted: Sat Jan 01, 2005 9:18 pm

That would imply that you probably haven't set the mysql parameters and/or tables up correctly.

Nate · New Member Joined: Jan 01, 2005 Posts: 6

I went and double-checked-- sure enough, I had forgotten to add the underscore at the end of the phpbb prefix. I'm running the script now; not sure how long it takes to run, but so far no error messages (knocks on wood).

I guess I'll know in a few minutes whether it worked or not...

Nate · New Member Joined: Jan 01, 2005 Posts: 6

YES!!! It worked! Almost there-- now just for the last step of Export / Import on the wordlist and wordmatch tables. How is it done? In MySQL, I've gone to table phpbb_search_wordlist, and then clicked on Export.

Which options should I select? Am I exporting it as a file? How do I import it? Many, many thanks for your help.

Raven · Posted: Sun Jan 02, 2005 8:06 pm

Export it as a file and save it to your PC. If the tables already exist, EMPTY them, and load them from the file, Inserts only. If they don't exists then export with the CREATE command.

Nate · New Member Joined: Jan 01, 2005 Posts: 6

Alright, I don't know MySQL too well so I'm using the interface instead of command prompt. I was able to export and then insert the data for wordlists, but when I try to do the same with wordmatch, I get an error when trying to insert the data-- the error reads: The document contains no data.

I've tried this several times, each with the same result. Perhaps I should be doing this from the command prompt instead of through the interface? If so, what should I enter in order to export the one table, and then to insert that data into the other?

Nate · New Member Joined: Jan 01, 2005 Posts: 6

Or perhaps it would be simpler matter to simply rebuild the search tables within phpNuke? The only script I could find for such a purpose though (the one they've got at PortedMods), was last updated in 2003 and does not seem to work correctly for me. sigh....

Nate · New Member Joined: Jan 01, 2005 Posts: 6

Stop the presses! I found something that does work-- there's a script called ImportSearch that can be downloaded from

Only registered users can see links on this board!
Get registered or login to the forums!

at PortedMods that worked perfectly at importing the search tables for me from phpBB to phpNuke. Thought I'd post this for anyone else trying to do this.

Thanks again for the help, Raven-- you're awesome!!

Static · New Member Joined: Dec 30, 2004 Posts: 4

Lol thanks nate! After I worked on this for like 3 hours with my host, we finally fixed it. And now you're telling me that there's an easier way!? Lol. Thanks for the info buddy!

Raven · Posted: Mon Jan 03, 2005 5:13 am

Glad it all worked out!

iamasteve · New Member Joined: Jan 08, 2005 Posts: 9

Wow thanks worked perfectly in about 5 minutes!! Great work!

Raven · Posted: Sat Jan 08, 2005 5:11 pm