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