<?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 
****************************************************************/ 

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

set_time_limit(0); 

//phpBB2 
$p_user="YOUR_ADMIN_USERNAME"; 
$p_pass="PASSWORD"; 
$p_db="PHPBB_DATABASE_NAME"; 
$p_host="localhost"; 
$p_prefix="PHPBB_PREFIX_IN_DATABASE"; 

//nuke 
$n_user="YOUR_ADMIN_USERNAME"; 
$n_pass="PASSWORD"; 
$n_db="NUKE_DATABASE_NAME"; 
$n_host="localhost"; 
$n_prefix="NUKE_PREFIX"; 

//connect to db's 
$p_con=mysql_connect($p_host,$p_user,$p_pass); 
$n_con=mysql_connect($n_host,$n_user,$n_pass); 

// DO NOT MODIFY ANYTHING BELOW !!! 

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='{$r