SW:Rebellion NetworkHosted by the SW:Rebellion Network
Welcome to Evaders Squadron Coding [ESC]
phpNuke, phpBB, and other scripts Expert - Evaders Squadron Coding - Coding Services
Home Forums Nuke Patched Core Coding Services Webmaster Services Personal
  Login/Create an Account    

Forums
· Forums FAQ
· Search
· Usergroups
· Profile
· Private Messages

Support Us
This site runs with your support. Please donate:

User Info/Login
Welcome, Anonymous
Nickname
Password
Security Code: Security Code
Type Security Code

(Register)
Membership:
Latest: AndoRook
New Today: 0
New Yesterday: 0
Overall: 6768

People Online:
Visitors: 12
Members: 0
Total: 12

Link to Us

Affliates
RPG Boards Hosting

Evaders Squadron Coding [ESC] :: View topic - phpBB2phpNuke
phpBB2phpNuke
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next
 
Post new topic   Reply to topic    Evaders Squadron Coding [ESC] Forum Index -> Coding Services
View previous topic :: View next topic  
Author Message
Evaders99



Joined: Jan 11, 2002
Posts: 3049
Location: USA

PostPosted: Fri Mar 10, 2006 1:50 pm    Post subject: phpBB2phpNuke Reply with quote

A database conversion for phpBB to phpNuke is now available here
http://evaders.swrebellion.com/modules.php?name=Downloads&d_op=viewdownloaddetails&lid=10
I created it after finding the ones out there slower and inefficient. It is tested with an original phpBB 2.0.19 and a phpNuke 7.6 + BBToNuke 2.0.19 package, however it should work for other versions if the version numbers are identical.

Please tell me if you have any problems
_________________
Evaders99
SW:Rebellion Fans! Webmaster
Star Wars roleplaying community! Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
Evaders99



Joined: Jan 11, 2002
Posts: 3049
Location: USA

PostPosted: Mon Mar 13, 2006 9:19 am    Post subject: Reply with quote

20 Downloads.. and someone already put it on warp-speed.de already. Go figure Wink
_________________
Evaders99
SW:Rebellion Fans! Webmaster
Star Wars roleplaying community! Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
fade2gray
Newbie
Newbie


Joined: Mar 27, 2006
Posts: 6

PostPosted: Mon Mar 27, 2006 5:47 am    Post subject: Reply with quote

Hi,

Should phpbb2phpnuke be compatible with rwsRavenNuke76_v2.02.00_FULL (which I believe incorporates bb2nuke 2.0.19) Question

I tried merging a phpbb 2.0.19 mysqldb with RaveNuke76, but got the following error...

Quote:
Cannot connect to phpBB's config table. Please check your phpBB prefix settings in phpbb2phpnuke_config.php

The prefixes are "nuke" and "phpbb_gen". Example: http://img88.imageshack.us/img88/9697/prefix3yl.jpg

Thanks for any advice.
Back to top
View user's profile Send private message
Evaders99



Joined: Jan 11, 2002
Posts: 3049
Location: USA

PostPosted: Mon Mar 27, 2006 9:58 pm    Post subject: Reply with quote

Mmm possibly. I honestly have not tried - but my guess is that it would work.

I see the issue. phpNuke puts the underscore after the prefix, but phpbb puts the underscore as part of the prefix. This is going to take some changes to the phpbb2phpnuke.php code

FIND

Code:

   $phpbbtables = array("_auth_access", "_banlist", "_categories", "_config", "_disallow", "_forum_prune", "_forums", "_groups", "_posts", "_posts_text", "_privmsgs", "_privmsgs_text", "_ranks", "_search_results", "_search_wordlist", "_search_wordmatch", "_topics", "_topics_watch", "_user_group", "_vote_desc", "_vote_results", "_vote_voters", "_words");




REPLACE WITH

Code:

   $phpbbtables = array("auth_access", "banlist", "categories", "config", "disallow", "forum_prune", "forums", "groups", "posts", "posts_text", "privmsgs", "privmsgs_text", "ranks", "search_results", "search_wordlist", "search_wordmatch", "topics", "topics_watch", "user_group", "vote_desc", "vote_results", "vote_voters", "words");




FIND (all fragments)

Code:

$phpbb_prefix . "_users


REPLACE WITH

Code:

$phpbb_prefix . "users




FIND (fragment)

Code:

$phpbb_prefix."_config


REPLACE WITH

Code:

$phpbb_prefix."config



FIND (fragment)

Code:

$phpbb_prefix . "_config


REPLACE WITH

Code:

$phpbb_prefix . "config



-----

in phpbb2phpnuke_config.php

Make sure the $phpbb_prefix is set to

Code:

$phpbb_prefix = "phpbb_gen";


That should be 6 changes


Tell me if that works please
_________________
Evaders99
SW:Rebellion Fans! Webmaster
Star Wars roleplaying community! Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
fade2gray
Newbie
Newbie


Joined: Mar 27, 2006
Posts: 6

PostPosted: Mon Mar 27, 2006 10:33 pm    Post subject: Reply with quote

Thanks very much for your reply.

I'm an utter novice concerning the whole phpNuke/phpbb thing but what I did before receiving your post was...

  • Used phpMyAdmin to rename all tables from "phpbb_genxxxx" to "phpbb_xxxx".
  • Changed the original phpbb forum's config.php accordingly.
  • Re-ran your script using a prefix of just "phpbb".

Everything went fine without getting the "Cannot connect...." error. Very Happy

There was a problem trying to view the forum in Nuke, but I'm going to start afresh using an imported dump of the db with the renamed tables.

I'll let you know what develops.
Back to top
View user's profile Send private message
fade2gray
Newbie
Newbie


Joined: Mar 27, 2006
Posts: 6

PostPosted: Mon Mar 27, 2006 10:56 pm    Post subject: Reply with quote

That didn't take long.

Absolute success, thank you. Very Happy
Back to top
View user's profile Send private message
Evaders99



Joined: Jan 11, 2002
Posts: 3049
Location: USA

PostPosted: Mon Mar 27, 2006 11:01 pm    Post subject: Reply with quote

Cool, that'll work too. My thought was you probably wouldn't want to go and rename every table. But since you did that, glad it worked Smile
_________________
Evaders99
SW:Rebellion Fans! Webmaster
Star Wars roleplaying community! Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
_Chipwiz_Ben_
Newbie
Newbie


Joined: Mar 28, 2006
Posts: 1

PostPosted: Tue Mar 28, 2006 7:25 am    Post subject: Reply with quote

Of all the crap that's out there on the web for this kind of stuff it makes you smile when you find something as refreshingly easy to use and effective as this one. So much so in fact, I felt the need to register just to post a big thank you for making my life that little bit easier Very Happy

Great piece of kit, much appriciated.

_Chipwiz_Ben_
Back to top
View user's profile Send private message
Evaders99



Joined: Jan 11, 2002
Posts: 3049
Location: USA

PostPosted: Tue Mar 28, 2006 9:21 am    Post subject: Reply with quote

You're welcome!

Glad it helped you out.
_________________
Evaders99
SW:Rebellion Fans! Webmaster
Star Wars roleplaying community! Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
avfguy
Newbie
Newbie


Joined: Mar 28, 2006
Posts: 1

PostPosted: Tue Mar 28, 2006 9:15 pm    Post subject: Problem Solved, please ignore! (possible problem - not sure) Reply with quote

[update]
Sorry, I discovered that the administrator account had not been removed as previously suspected. Thanks anyway - and thanks again for this tool - saved me a lot of time!

[original posting]
I'm working on setting up a new site with phpNuke and imported the database from an old phpBB site using this - worked great, no hitches - thanks! Very easy to use. The problem now is that it appears the import of users from phpBB has overwritten the users from the phpNuke site (not active yet, still setting up, so it's not a big problem at the moment), but apparently my superuser account from the phpNuke setup no longer exists, so now I can't login to make any changes in phpNuke. I'm brand new to this, so I might be missing something, but is there a way to recover or recreate this account in phpNuke without having to reinstall and reconfigure everything? Thanks for any input - and thanks again for the import code!
Back to top
View user's profile Send private message
Evaders99



Joined: Jan 11, 2002
Posts: 3049
Location: USA

PostPosted: Wed Mar 29, 2006 12:17 am    Post subject: Reply with quote

Just for information, it does not delete your Nuke authors data. However, as stated in the script - it does delete all existing user and forums data in phpNuke
_________________
Evaders99
SW:Rebellion Fans! Webmaster
Star Wars roleplaying community! Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
fade2gray
Newbie
Newbie


Joined: Mar 27, 2006
Posts: 6

PostPosted: Wed Apr 05, 2006 6:51 pm    Post subject: Reply with quote

Must the original phpbb directory and phpbb prefixed tables be left intact after integration?
Back to top
View user's profile Send private message
Evaders99



Joined: Jan 11, 2002
Posts: 3049
Location: USA

PostPosted: Wed Apr 05, 2006 6:59 pm    Post subject: Reply with quote

No, you can remove your original phpBB files and tables. They aren't needed
_________________
Evaders99
SW:Rebellion Fans! Webmaster
Star Wars roleplaying community! Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
fade2gray
Newbie
Newbie


Joined: Mar 27, 2006
Posts: 6

PostPosted: Thu Apr 06, 2006 7:15 pm    Post subject: Reply with quote

Found a problem.

Exported MySQL before and after merging...

Code:
Before:
INSERT INTO `nuke_bbconfig` VALUES ('script_path', '/modules/Forums/');

After:
INSERT INTO `nuke_bbconfig` VALUES ('script_path', '/folder/phpbb/');


If I delete phpbb's original directory, '/folder/phpbb/' becomes invalid.
Back to top
View user's profile Send private message
Evaders99



Joined: Jan 11, 2002
Posts: 3049
Location: USA

PostPosted: Thu Apr 06, 2006 8:00 pm    Post subject: Reply with quote

Yes, you'd need to go to the Forums Configuration and change it. It won't detect it automatically, because it doesn't actually know where you put your files
_________________
Evaders99
SW:Rebellion Fans! Webmaster
Star Wars roleplaying community! Administrator

Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -

The cake is a lie.
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic    Evaders Squadron Coding [ESC] Forum Index -> Coding Services All times are GMT - 5 Hours
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next
Page 1 of 10

 
Jump to:  
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

^Top
Home Your Account Forums Downloads F.A.Q. Submit News Hosting Contact Us

© 2005 - 2007 by Evaders99. All Rights Reserved.
All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters.
You can syndicate our news using the file backend.php
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL.
PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.64 Seconds