Integrate a NEW PHPBB install into existing PHPNuke database

Posted: Thu Apr 28, 2005 4:40 pm

Hey all,

I searched the forum to see if anyone had brought this up before (I've actually been to phpbb.com, nukecops.com, and Google), so please feel free to redirect if this is an old question.

I have an existing site, Only registered users can see links on this board! Get registered or login!, and as you can see it has the typical bbtonuke message board and it's all setup and I have a few users already and a few posts.

Now, I would like to expand my site by adding a second message board that focuses on a different subject. I installed phpbb Only registered users can see links on this board! Get registered or login!; it is sharing the same database as my current phpnuke installation with a different prefix. Now, what I would like to do is share the user database between the two forums, just so my existing users wouldn't have to create a new account to use the second forum.

I tried altering the $table_prefix for the user tables in the constants.php file in phpbb so that they pointed to the nuke tables, but it didn't work. I did notice that there are more nuke tables that are involved with users and user sessions that phpbb.

I'm sorry that I'm not posting more info here, honestly I'm not very good at this stuff and I am afraid of ruining my current site/databases.

Posted: Thu Apr 28, 2005 7:27 pm

Don't think you can do that without hacking either Nuke or phpBB, both use different user handling methods, i do recall someone had modified phpBB so that it could be used with Nuke as a standalone forum but with Nuke's tables, problem is i don't recall the site.

Posted: Thu Apr 28, 2005 8:17 pm

I guess what I'll try to do, then, is install another instance of phpnuke and try to combine the user tables that way. Does that sound feasible at all? I'll figure it out. Thanks, chatserv.

Posted: Thu Apr 28, 2005 9:00 pm

With two PHP-Nuke sites you could manage it, you'd only need to have both site tables on the same db with a different prefix of course, site 2's $user_prefix should match site one's $prefix, no need to create the users and users_temp db tables for site two.

Posted: Thu Apr 28, 2005 9:03 pm

I just uploaded Raven Customized, and ran the install, and it wanted to either delete or replace my current database. I take it I cannot use this to auto-create the tables; am I going to have to do this manually?

Posted: Thu Apr 28, 2005 10:12 pm

It would be best to do it manually

Posted: Thu Apr 28, 2005 10:19 pm

That scares me. Wink

I've never done it before, but I'll give it a shot.

Posted: Fri Apr 29, 2005 9:39 am

Killer; I got it working and with a minimal amount of fuss after all my synapses finally fired together. Wink

Thanks for the help chat. If anyone in the future ever needs help on this, feel free to PM me and I'll tell you what you need to do. Smile

Posted: Fri Apr 29, 2005 10:24 am

Excellent

Posted: Fri Apr 29, 2005 8:39 pm

Alright, I have another question and I don't want to clutter up the forums with threads. Smile

I want to set this second site up as a subdomain. I'd like it to be rebel.legendsofstarwars.com

Whatever I do, though, this always points back to the main site. I assume there's code for this somewhere, but I have no idea where to look.

Posted: Wed May 04, 2005 1:53 pm

Alright, just wanted to say that I've completely finished, and both sites exist sharing one user database. Just a couple of oddities:

- Avatars work a little strangely. I had to modify the code a little bit so that you could manage one avatar for both sites. If you setup an avatar via the second site, it messes it all up, but if you do it from the main site, as I have told my members to do, then it works fine over both sites, including the Site Info block.

- The scrolling forums block was working a little strangely, but I managed to get it working properly by altering which site it pulled it's data from.

- Private messages sent via each site are proprietary to the site, but you will be notified on both sites of the PM in your inbox

I'll post any other strange things that I find. I have to say that I think for the most part this has been a success.