Putting my VB and Postnuke together

[Dontom]

Hi,
I am planning to use Postnuke (http://www.postnuke.com) aside my vb-forum; to avoid double registration I need little bit of integration between both of them:

Both systems encrypt pw using md5 so there are two (or more?)possibilities:
1) hacking up postnuke to access vb's usertable or

2) copying all entries from vb's to pn's usertable and then writing a script which updates (or inserts ;-) ) pn's usertable hourly. Forwarding all access from pn's reg-system to vb's register.php and usercp.php
###


1)
+ both systems access the same usertable
- changes to vb's tablestructure
- changing PN-Scripts

2)
+ easier to implement (??)
+ tablestructure in both systems remains untouched
+ PostNuke remains upgradeable
- delay when registering or changing pw (max 1h)

Any recommendations? Has anyone done this? I tend to start working for 2), what do you think?
TIA
Tom



Here both Tablestructures

VB-Usertable

CREATE TABLE user (
userid int(10) unsigned NOT NULL auto_increment,
usergroupid smallint(5) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
password varchar(50) NOT NULL default '',
email varchar(50) NOT NULL default '',
styleid smallint(5) unsigned NOT NULL default '0',
parentemail varchar(50) NOT NULL default '',
coppauser smallint(6) NOT NULL default '0',
homepage varchar(100) NOT NULL default '',
icq varchar(20) NOT NULL default '',
aim varchar(20) NOT NULL default '',
yahoo varchar(20) NOT NULL default '',
signature mediumtext NOT NULL,
adminemail smallint(6) NOT NULL default '0',
showemail smallint(6) NOT NULL default '0',
invisible smallint(6) NOT NULL default '0',
usertitle varchar(250) NOT NULL default '',
customtitle smallint(6) NOT NULL default '0',
joindate int(10) unsigned NOT NULL default '0',
cookieuser smallint(6) NOT NULL default '0',
daysprune smallint(6) NOT NULL default '0',
lastvisit int(10) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
posts smallint(5) unsigned NOT NULL default '0',
timezoneoffset varchar(4) NOT NULL default '',
emailnotification smallint(6) NOT NULL default '0',
buddylist mediumtext NOT NULL,
ignorelist mediumtext NOT NULL,
pmfolders mediumtext NOT NULL,
receivepm smallint(6) NOT NULL default '0',
emailonpm smallint(6) NOT NULL default '0',
pmpopup smallint(6) NOT NULL default '0',
avatarid smallint(6) NOT NULL default '0',
avatarrevision int(6) unsigned NOT NULL default '0',
options smallint(6) NOT NULL default '1',
birthday date NOT NULL default '0000-00-00',
maxposts smallint(6) NOT NULL default '-1',
startofweek smallint(6) NOT NULL default '1',
ipaddress varchar(20) NOT NULL default '',
referrerid int(10) unsigned NOT NULL default '0',
nosessionhash smallint(6) NOT NULL default '0',
showleftcolumn smallint(6) NOT NULL default '1',
receivebulletin smallint(5) unsigned NOT NULL default '1',
starlevel varchar(5) NOT NULL default '0',
starimg varchar(25) NOT NULL default '0',
picture_name varchar(50) NOT NULL default '',
photodesc varchar(255) NOT NULL default '',
pictime varchar(30) NOT NULL default '',
updatetime varchar(30) NOT NULL default '',
inforum smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (userid),
KEY usergroupid (usergroupid),
KEY username (username),
KEY referrerid (referrerid),
KEY inforum (inforum)
) TYPE=MyISAM;


PN-Usertable
CREATE TABLE `nuke_users` (
`uid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`uname` varchar(25) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`femail` varchar(60) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`user_avatar` varchar(30) default NULL,
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_intrest` varchar(150) default NULL,
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`pass` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`timezone_offset` float(3,1) NOT NULL default '0.0',
PRIMARY KEY (`uid`)
) TYPE=MyISAM;

[epic]

If you make vbb a module of postnuke,you can upgrade the postnuke when there is a new release of postnuke!
and PM is another problem.

[Dontom]

finally did it
i now have a cron which copies relevant fields from vbs usertable to Postnukes usertable (Userid, user, pw, sig, email) - people can login now in Postnuke too and post comments and so on...
Registration and usermanangement (changing pw'S etc) is performed by vb alone

Kevins (Tubedoggs) User online & Last 10 Posts hacks worked without modification as 2 blocks in postnuke
[high]* Dontom happy
[/high]
Now I only need to change the standard-PN-theme and will start this part hopefully before holidays...
Preview here:
http://www.mtb-news.de/pn

[Konqueror]

I've actually hacked my phpnuke to use vbulletin's user info.

[amykhar]

Konquerer, If you would document the hack and release it, you would be an extremely popular man around here. People are always asking for the nuke or postnuke integration.

Amy

[Konqueror]

It's not complete yet. As of now vBulletin and nuke use 2 different cookies... I want them to use one cookie of course. After that I'll try to enable the use of sessionhash for both of them as well.
I actually wanted to finish a complete integration between the two before I release it, but if there's demand for just this one hack I'll release it of course. The little app "Search and Replace" from funduc.com helped me a lot btw. I just love that app so I had to mention it.

[amykhar]

I actually need two separate cookies because I am on two separate domains. I would be interested in seeing what you've done so far.

Amy

[Konqueror]

Oh, so you need two cookies? Hm...
I should have something ready for you very soon then. Note though that the only thing I've done so far is telling nuke to use vBulletin's user info. Nothing more. If that's what you need I got your solution. I just started with the whole thing 2 days ago, so I didn't get much further yet.
Oh, and both, nuke and vBulletin, got all their info in one database... Would be a bit more work if you need them to connect to two different databases, but if there's demand for that I'll be willing to do that. Just let me know.

[amykhar]

What you have already is perfect. My domains are on the same server and sharing a database is no problem. Sharing the user tables is really all that I need for now.

Amy

[Konqueror]

Well, I'll put the instruction together tomorrow after some more testing.
I've just noticed that I use too many smilies.