Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's
Author Message
Gannet
New Member
New Member


Joined: Oct 27, 2004
Posts: 1

PostPosted: Wed Oct 27, 2004 2:50 am Reply with quote

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
 
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Wed Oct 27, 2004 5:25 pm Reply with quote

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();
?>
 
View user's profile Send private message
Donovan
Client


Joined: Oct 07, 2003
Posts: 735
Location: Ohio

PostPosted: Tue Nov 30, 2004 11:29 am Reply with quote

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.
 
View user's profile Send private message Visit poster's website ICQ Number
Raven
PostPosted: Tue Nov 30, 2004 12:20 pm Reply with quote

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!
 
Donovan
PostPosted: Tue Nov 30, 2004 1:24 pm Reply with quote

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!
 
Raven
PostPosted: Tue Nov 30, 2004 1:27 pm Reply with quote

Try going into Forum management and select Resync on the forums you imported.
 
Donovan
PostPosted: Tue Nov 30, 2004 1:36 pm Reply with quote

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
PostPosted: Tue Nov 30, 2004 1:45 pm Reply with quote

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
New Member


Joined: Dec 30, 2004
Posts: 4

PostPosted: Thu Dec 30, 2004 8:53 pm Reply with quote

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?
 
View user's profile Send private message
Raven
PostPosted: Thu Dec 30, 2004 10:43 pm Reply with quote

Just copy and paste that code into your editor and save it.
 
Static
PostPosted: Fri Dec 31, 2004 12:15 am Reply with quote

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
PostPosted: Fri Dec 31, 2004 12:22 am Reply with quote

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
PostPosted: Fri Dec 31, 2004 1:28 am Reply with quote

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
New Member


Joined: Jan 01, 2005
Posts: 6

PostPosted: Sat Jan 01, 2005 9:04 pm Reply with quote

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?
 
View user's profile Send private message
Raven
PostPosted: Sat Jan 01, 2005 9:18 pm Reply with quote

That would imply that you probably haven't set the mysql parameters and/or tables up correctly.
 
Nate
PostPosted: Sun Jan 02, 2005 5:22 pm Reply with quote

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
PostPosted: Sun Jan 02, 2005 6:41 pm Reply with quote

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
PostPosted: Sun Jan 02, 2005 8:06 pm Reply with quote

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
PostPosted: Sun Jan 02, 2005 11:15 pm Reply with quote

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
PostPosted: Sun Jan 02, 2005 11:21 pm Reply with quote

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
PostPosted: Sun Jan 02, 2005 11:58 pm Reply with quote

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!!
 
Static
PostPosted: Mon Jan 03, 2005 12:04 am Reply with quote

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
PostPosted: Mon Jan 03, 2005 5:13 am Reply with quote

Glad it all worked out!
 
iamasteve
New Member
New Member


Joined: Jan 08, 2005
Posts: 9

PostPosted: Sat Jan 08, 2005 4:37 pm Reply with quote

Wow thanks worked perfectly in about 5 minutes!! Great work!
 
View user's profile Send private message
Raven
PostPosted: Sat Jan 08, 2005 5:11 pm Reply with quote

RavensScripts
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©