How to use Postnuke & VB with one UserDB

[Dontom]

How to use Postnuke & VB with one UserDB: (got some requests to explain - here it is)

Install both to the same DB (PN uses a configurable prefix - so they won't mess up)

Upload a script that will regularly copy the contents of vbs Userdb to pn's userdb

(I use this cronned..)

PHP Code:

<?php
//connect to database
mysql_connect("localhost", "yourDB", "yourPW");
mysql_select_db("your db");
//empty pn userdb and fill it with fresh userdata
$query=mysql_query("delete from nuke_users");
$query=mysql_query("INSERT INTO nuke_users (uid,uname,email,url,user_sig,pass,user_icq) select userid,username,email,homepage,signature,password,icq from user");
$query=mysql_query("update nuke_users set umode='nested', theme='ExtraLite',timezone_offset='14.0'");

mysql_close();
?>

fill the table called "nuke_group_membership" so pn will recognize you as admin and the rest as regular users (you are in group 2, the rest is group 1)

change all urls in pn which have to do with registration to point to vb's reg-Page/usercp

Include vb's global.php and install Admin_online - people on your newssite will be shown as online reading news...
include Tubedoggs last x posts in your sideblock (works without changes in pn)

Thats it


User needs to log in once into pn and is recognized from then on.

Disadvantage: My cron runs hourly, so in the worst case a new user can't login into the PN-system for about 59 Minutes

Advantage: No code manipulation needed, vb's & pn's Database remains untouched
you are able to Upgrade PN or VB without changing anything (as long as UserDB is not changed...)
You can integrate fantastic Modules, that are available to PN
-> Gallery ... (See it here )

see it in Action:
PN: http://www.mtb-news.de
Forum: http://www.mtb-news.de/forum

:-)
Tom

[TigerLily]

Thank you so much for sharing this! I've been looking and looking for a way to connect those two programs (getting ready to go live with PostNuke, have vb going). I could never find a simple answer, and thought I'd be spending weeks on this problem. I really do appreciate the information!

One question: How has your server performed while using both programs? That's a concern I have when going to so much dynamic content, but it will save so much time.

Thanks,
Kim

[Dontom]

until now without any problems - my news-page does not get the traffic my forums get, but both of them still perform well. yesterday 94 people were online simultaneously and I did not get db-errors (and the site still feeled fast )
I am on a shared server...

[TigerLily]

Thanks again, Tom! And I looked at your site- very nice! I bet it's so much easier to maintain with PostNuke too. I'm really looking forward to using that program.

I was concerned about connecting PN and VB because we average about 100-120 users online for most of the day and into the night- even on weekends. Lately we're spiking up towards 200 at peak times. I made some tweaks to the database, and the server loads look good, just didn't want to crash the site or put a huge strain on the server if connecting the two programs caused problems.

I really enjoy PostNuke and Vbulletin, it's so great to find a way to use both of these excellent programs without having to hack everything to bits! I will let you know how it goes!

Thanks,
Kim

[abdullah]

thanx alot for the quick response and for this great work that made lots of jobs easier.
but i have some simple questions.
do we have to put both tables of pn and vb on the same db because we have different ones.
the other question though i dont think it has any relation but does this affect the permission system of PN.

thanks again Tom

Abdullah

[JTMON]

there's also vbPortal which is a port of post nuke made specifically for vb. It has all the same features and look as far as I can tell and was released here by wajones.

[Dontom]

Originally posted by abdullah
thanx alot for the quick response and for this great work that made lots of jobs easier.
but i have some simple questions.
do we have to put both tables of pn and vb on the same db because we have different ones.
the other question though i dont think it has any relation but does this affect the permission system of PN.

thanks again Tom

Abdullah

Hi Abdullah,
no, you can put this on different db's - just change the cronned "insert into" to reflect aour databases...
you can even use different usergroups. on my pn there is admin, user and faq-maintainer - as long as users remain at the same userid everything will work... - you need to fill the nuke_group_membership table to reflect who is in which group
Tom

good luck!
Tom

[owc]

Can you pls Explain more for using PHP NUKE with Vb

Thnaks

[abdullah]

thanx again Tom

i will start backing up my database and do the integration.
If something went wrong i will let u know.

thanks.
Abdullah

[Pilot]

VBPortal is PHPNuke not PostNuke based.

www.phpportals.com