phpBB to php nuke

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

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

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();


?>

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.

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! ]

Posted: Tue Nov 30, 2004 1:24 pm

42 members were imported, but still don't get a forum.
[ Only registered users can see links on this board! Get registered or login! ]

Trying to import from:
[ Only registered users can see links on this board! Get registered or login! ]

Posted: Tue Nov 30, 2004 1:27 pm

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

Posted: Tue Nov 30, 2004 1:36 pm

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.

Posted: Tue Nov 30, 2004 1:45 pm

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

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?

Posted: Thu Dec 30, 2004 10:43 pm

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

Posted: Fri Dec 31, 2004 12:15 am

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!

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.

Posted: Fri Dec 31, 2004 1:28 am

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.

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?

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.

Posted: Sun Jan 02, 2005 5:22 pm

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...

Posted: Sun Jan 02, 2005 6:41 pm

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.

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.

Posted: Sun Jan 02, 2005 11:15 pm

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?

Posted: Sun Jan 02, 2005 11:21 pm

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....

Posted: Sun Jan 02, 2005 11:58 pm

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! ] 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!!

Posted: Mon Jan 03, 2005 12:04 am

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!

Posted: Mon Jan 03, 2005 5:13 am

Glad it all worked out!

New Member Joined: Jan 08, 2005 Posts: 9

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

Posted: Sat Jan 08, 2005 5:11 pm