[newnuker]

Hi,

thanx for this site,,,,

I use phpNuke 6.5 and before that, I was using only the PHPBB2.04 forum as standalone...

After that, I've installed PHP-Nuke 6.5...

But I dont want to use the forum with Nuke 6.5

Ok, lets go back to the topic

I've download themepack PHPib2 for my nuke, with this theme is a center Top forum block included...

I cant use this block with my site, coz. it works with the forum as module and not a standalone PHPBB2.04

I would like to modify this block to make work with my PHPBB2.04

So, I made some changes like this:

$prefix = "phpbb";

and this:

$viewlast .=" <tr>
<td width=\"100%\" bgcolor=\"#EAEFF6\" class=\"row1\">&$topic_title</td>
<td align=\"center\" bgcolor=\"#DFE6EF\" class=\"row2\">$topic_replies</td>
<td align=\"center\" bgcolor=\"#EAEFF6\" class=\"row3\">$avtor</td>
<td align=\"center\" bgcolor=\"#DFE6EF\" class=\"row2\">$topic_views</td>
</tr>";

I have been unable to make the $topic_title clickable...

coz. the org. file looks like this:

<td width=\"100%\" bgcolor=\"#FFFFFF\" class=\"row1\">&<a href=\"modules.php?name=Forums&file=viewtopic&t=$t opic_id#$topic_last_post_id\">$topic_title</a></td>

and that's not working:


So, my problem is:

How can I make this block to make it work as php-Nuke center block and it should connect to the PHPBB2.04 as standalone and gets the last 5 top forum topic? and make it clickable?

Any one? any tips! or tricks?

[newnuker]

am I asking some thing too easy? or too difficult!

Any way,,, is some body could help with any tips, coz. I'm too new for all this php stuff...

[IACOJ]

You are asking something that probably most people here can't test to check because we don't use stand alone phpbb.

Why don't you just import the information from your current forum into the forum module? Then the whole thing is linked together, people wont have to register twice, the block will work, the whole site will be the same theme etc.

[newnuker]

Well,,

I would be happey to do that, If I can...

I've downloaded a script to import im current PHPBB2.04 to Nuke module, but it asks for Perl!!! :!:

I dont have Perl, and I dont know enough about php, mysql and all that stuff...

If you would tell me more, maybe a tip ! how to do that? it would be very nice of you....

thanx.

[IACOJ]

Please confirm that you are using 2.0.4 and Nuke 6.5.

I'll see if I can find a script. Do you have cgi bin?

[IACOJ]

Try this php script. Put it in your main Nuke dir (where config.php and mainfile.php etc are) The download is disabled for this script at the site where I got it from, but there was an ongoing discussion about issues with it. This one apparently works now.

If you want to read the discussion on the site where I got this from go to http://www.ruleit.co.uk/nuke

Understand that this needs to go on a fresh Nuke install. If there is anything in the current forum module it will be lost.

Please pay special attention to the setting of your database. If they are incorrect the script will not work properly.

Save and upload file (name it what you want, but don't overwrite anything) and point your browser to it.

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