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();
?>
|
Thx
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
