You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 164 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - confused: bbtoNuke, phpBB port, 2.0.2, 2.0.4, 2.0.6v [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
PIP
Nuke Soldier
Nuke Soldier


Joined: Jul 06, 2003
Posts: 11


PostPosted: Thu Aug 07, 2003 8:13 am Reply with quoteBack to top

This will convert your PHPBB2 Tables into your the PHP-Nuke BBtoNuke tables. Original Script by Andareed

THIS SCRIPT DOESN'T SEEM TO BE WORKING CORRECTLY AT THE MOMENT!!! SEE http://ruleit.co.uk/nuke/forums/viewtopic.php?t=272 FOR MORE INFOMATION!

Author: Ukforums (original by Andareed) (nuke at ruleit dot co dot uk)
Version: Filesize: 16.00 Kb

_________________
http://www.longrangereconpatrol.com/pip01.jpg
Find all posts by PIPView user's profileSend private messageVisit poster's websiteICQ Number
Zhen-Xjell
Nuke Cops Founder
Nuke Cops Founder


Joined: Nov 14, 2002
Posts: 5939


PostPosted: Thu Aug 07, 2003 8:21 am Reply with quoteBack to top

Since we're intimate with this stuff, perhaps its about time we spent on importer scripts. I'd hate to say it, but we go down this path, we're going to be doing a lot more work than we intended for.

_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
Find all posts by Zhen-XjellView user's profileSend private messageSend e-mailVisit poster's website
chatserv
General
General


Joined: Jan 12, 2003
Posts: 3128

Location: Puerto Rico

PostPosted: Thu Aug 07, 2003 9:26 am Reply with quoteBack to top

Have checked the script being offered at that link, the site requires registration to download it and the forums are separate and require another registration, ok so the script seems to be having problems returning dates and one has to manually enter the database login info which can be worked around since the script sits in Nuke's main directory, here's my proposal, anyone willing to test it should make a backup first although from what i have seen the script requires that your Nuke install be a new one where the forums have no data entered yet, so try at your own discretion:

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

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

set_time_limit(0);
include ("config.php");
//phpBB2
$p_user="phpbb database uname";
$p_pass="phpbb database pass";
$p_db="phpbb database name";
$p_host="localhost";
$p_prefix="phpbb";

//nuke
$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);
$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();
$reg_date = $row['user_regdate'];
$new_date = strftime ("%B %d, %Y", $reg_date);
   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='{$new_date}',
      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) or mysql_error();
}
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) or mysql_error();
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) or mysql_error();
}
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) or mysql_error();
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) or mysql_error();
}
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) or mysql_error();
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) or mysql_error();
}
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]);
   }
}

?>

_________________
Feed a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
ScriptHeaven | NukeResources
Find all posts by chatservView user's profileSend private messageVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next 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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.148 Seconds - 634 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::