View Full Version : phpnuke reg integration hack

12 Sep 2001, 12:25
Before i post it i have to say 2 things

1) it is not my hack, it was made by those wonderful ppl from www.buffydownunder.com, I would like to give them all the credit and the thanks for hooking me up with this helpful hack

2) and this is the big one, the php-nuke and vbulletin databases have to be combined

I dont know if you want it if you have to combine databases, unless you have not installed one of them yet

hell maybe one of the great coders here could find a way for there to be 2 databases, i dunno

here she is

in the register.php file of vbulletin


$DB_site->query("INSERT INTO user
s,startofweek,ipaddress,pmpopup,referrerid,nosessionhash) VALUES
$user_regdate = date("M d, Y");

//PHP-Nuke Registration Addition - by Matt Lyons matt@buffydownunder.com

mysql_query("insert into nuke_users (uname, email, url, user_regdate,
user_icq, user_aim, user_yim, user_viewemail, pass) values ('$username',
'$email', '$homepage', '$user_regdate', '$icq', '$aim', '$yahoo',
'$showemail', '$cryptpass')");


in the user.php file of php.nuke



And just change it to

the url to the register.php file of vbulletin

easy hack, but ingenius, thanks again Matt and Russel

12 Sep 2001, 15:27
You can have it in 2 databases. Just edit the line for the mySQL-Query after where it says PHPNUKE registration from

insert into nuke_users


insert into yournukedbname.nuke_users

Worked for me.

12 Sep 2001, 15:42
Originally posted by orca
You can have it in 2 databases. Just edit the line for the mySQL-Query after where it says PHPNUKE registration from

insert into nuke_users


insert into yournukedbname.nuke_users

Worked for me.
I think that it will only work if you're using the root user. Otherwise you don't have access to another database.

12 Sep 2001, 17:37
You sure? I never got an error message.

12 Sep 2001, 17:41
Well, unless you use root you can't have access to more than one database (I'm 99% sure).
What username are you using Orca?

And by the way, this:
$user_regdate = date("M d, Y");
is no where in register.php.

12 Sep 2001, 20:59
Well, it works at my site. I just checked it with a test account. Maybe I have root access but I need my own username, not 'root'.

What user_ragdate is concerne I need to have a look. I'm not sure anymore. I think the query is more important.

12 Sep 2001, 22:17
i think that hack is for a slightly older ver
the rest of it is there, just paste it after the rest of it (the part before the reg date)

30 Sep 2001, 00:41
You dunno need root access to mysql, but you have to have access to the other database as well ..
So if your hosting only gives you one database you have to mix, there is no other way, but yes, that愀 the way it is ..
If you have root access for yourself you can change the access level with grant and revoke for every database itself ..
Giving root access to any config file is a security risc ..
Bcz with that password all dbs could be deleted !

But usually root login to mysql is only allowed from localhost so it isn愒 that problem to use root, but I would sugeest to NOT use root for any PHP program ! ;)

11 Oct 2001, 21:13
I edited register.php like it says. When I view it as part of vBulletin there are no changes. Is it supposed to be like that?

I look in user.php of phpNuke, but there is not a single "user.php?op=COPPA" in the entire file!

Please help!

I am using vB 2.0.3 and phpNuke 5.2.

12 Oct 2001, 02:42
I feel like an ass, but i could not find it this time either m8, sorry

but here is the email of the guy who uses it on his site, his php programmer friend figured the heack out

12 Oct 2001, 08:11
Try looking for user.php?op=. May COPPA is replaced by add or similar.

12 Oct 2001, 16:32
There are tens of "user.php?op=" references in there... Also, the Buffy Down Under site never works for me now, it used to a few weeks ago when I came accross this hack.

12 Oct 2001, 16:34
LOL I just realised the link at the top of the page has a comma at the end of it... Silly me!

I installed phpNuke with integration being the prime directive. I've spent an age on my template and I really don't want to let it go! Thanks for your help so far guys. :D

15 Oct 2001, 10:39
It also works fine with PostNuke.
Thanx to the ppl from www.buffydownunder.com

15 Oct 2001, 19:27
hey, is postnuke as good as php-nuke, would it be easy for me to switch my site to that?

16 Oct 2001, 08:51
PostNuke is a fork of Francisco Burzi's PHP-Nuke. There are no big differences, but I like it more than PHP-Nuke because there are not so many big bugs included ;)
You can find PostNuke here (http://www.postnuke.com).

I don`t know if there are any problems to switch from PHP-Nuke to PostNuke. I made a clean installation of PostNuke.

16 Oct 2001, 09:48
What files did you edit on PostNuke?
Does the Who's Online work with the VB database?
Can I see an example of your site?

Thanks... :)

16 Oct 2001, 11:20
Sorry, but you can`t see an example of my site because I`m still programming and so it`s running on my notebook. I don`t know if the Who`s Online hack is working because I haven`t integratet it yet. But you can mail it, then I`ll look if it`s working...

I only editeted the user.php file. Search for "user.php?op=" (without the ") and change them to the url of the register.php of vB.

16 Oct 2001, 11:34
So just replace every single user.php?op= with http://whatever.com/register.php ?

16 Oct 2001, 11:48
You can make it better, but I`ll tell you later how because I`ve a meeting now.

16 Oct 2001, 11:50
Thanks... This hack is confusing me a lot. I don't understand how simply changing a few links in 1 file can let phpNuke access the vbulletin database and use it for posting etc. I've looked at postNuke and it looks much better than phpNuke, and hence I expect I will change over - as soon as I understand how this whole thing works.

17 Oct 2001, 10:07
Forgotten about me Madison? :(

I emailed Russel, but I didn't understand his 1 line response.

17 Oct 2001, 22:11
Sorry, but I`ve really forgotten about you. I had to do so much work today.... you know ;)

But tomorrow (10-18-2001) I`ll tell you. But before I have to try it out. Maybe it doesn`t work. But im sure it does...

Sorry for my bad english, but I`m a german.

18 Oct 2001, 16:31
Nothing to aplogise for mate! Your English is 100% better than my German! ;)

20 Oct 2001, 03:31
STILL don't understand this hack. :(

22 Oct 2001, 08:39
Do you have ICQ? I think its easier to tell you with ICQ... :)

My number is 102461327, but maybe I`ll connect with a nother number, so it will be better if you`ll give me your number.

23 Oct 2001, 00:14
don't know postnuke...

have to look into that.... for what i've seen... it's just a modified version of phpnuke...

both version need a LOT of tweaking before it does what you want it to do... but when you do.... OH MAMMA!!!

maybe postnuke is getting more attention now (www.nukeaddons.com), but i'll stick to 'my' phpNuke till postnuke *really* becomes better.....(!)

27 Oct 2001, 23:46
Nice idea to post data in both dbs; but what i fsomeone wants to change his stuff?

With this solution you have to find every mysql-update in both scripts. Cant be the right way!?

Im sitting here for two days now, melting both databases into one;
the idea is to add every extra feield from PN (table users) into table user (VB); then change the PN-Files to use password instead pass, homepgae instead url and so on.
Most of the thing is ready here; some problems will solved this night (registering VB with mail and activation-code, PN with made passwort) and some more.

Its a f*cking work, and im afraid of the next update of pn; but the only way i see...


28 Oct 2001, 03:39
ps. my email's russell@buffydownunder.com ... there's TWO L's :)

And the new version of PHPNuke5.2, the user.php page changed, basically all that line did was to get rid of the click here to register, and change it to a link to the vBulletin rego.

05 Jan 2002, 04:31
This is great code, but how do you deal with password changes for the guy who changes his vb password? And how do you transfer 500 existing users into nuke's database?

24 Jan 2002, 00:04
I imagine that you would need to modify your forums member.php file. I found the statement that controls the password change:

$DB_site->query("UPDATE user SET password='".addslashes($newpassword)."',usergroupid='$bbuserinfo[usergroupid]' WHERE userid='$bbuserinfo[userid]'");

but for the life of me, can't figure out how to have it change the password in the nuke_users table also.

Any ideas guys? I'm sure it's much simpler than I'm making it!

PS -- Thank your Russell for posting the info to integrate the two databases!

24 Jan 2002, 02:08
ok ppl, here is the new and refined hack for ting the 2 scripts together. Got the bulk code from Dontom's hack (but this gets around the cron messiness)

here it is enjoy ppl.

24 Jan 2002, 07:54
Will this script work for post-nuke 7.03 and VB? If not where can I go to ask as this would be great to get it working.

Thanks for any help....

24 Jan 2002, 18:54
Hmmm ... can't figure out what I did wrong. I assume it's working for you wakawaka. It transferred over all of my existing VB members and their current info, (which was an unexpected bonus!) but it doesn't immediately update when they change user info or if a new member is added. It waits until the next new member is added -- therefore it's always one member behind. So if I originally had 3001 members, only 3000 were pulled over. Then when I added #3002, it brought over #3001, but not #3002. Then I updated a profile, but it didn't take effect until I added #3003 (at which time it also copied over #3002). Make sense?

Any ideas on what the problem might be? Other than this little glitch, it's great!

24 Jan 2002, 21:15
I have it setup so it copies the info as soon as someone follows the activation link from the email, but ill look into it to see if i can find a place to make it copy as soon as someone changes their info.

24 Jan 2002, 22:30
Ahhh .... well that makes sense. I copied the new portion of the code you suggested for Activate Form to Start Add Member and it automatically added the new member. Now that just leaves the Update Profile. I'm guessing I'd need different code in member.php since the query is so different. I'll play with it a bit, but I don't hold out high hopes that I'll figure it out.

FYI -- This hack DOES work with two separate databases by doing just what was suggested earlier in this thread (putting your database name and a period prior to nuke_users).

Thanks for your help!

25 Jan 2002, 01:14
thanx for the tip about the 2 diff db's

also i'll try and make it so the profile changes actually work right away

26 Jan 2002, 21:39

First thanks for the above script.

Running: vb 2.03 and Post-Nuke 7.03 (Rogue)

After following the above I went and try adding a new member. I went throught the registration and it worked great until I open the activation e-mail. Where it wanted me to click to activate my new account it came back with the standard vb error page.

The error that MySql generated was this:
Database error in vBulletin: Invalid SQL: SELECT activationid FROM useractivation WHERE userid='5197' AND type=0
mysql error:
mysql error number
Date: Saturday 26th of January 2002 09:14:33 PM
Script: /forums/register.php?a=act&u=5197&i=1012079601
I took a look at the nuke_user file and it had been populated with all my vb users except the latest one as a previous post talked about.

Also Table 'vbullet.useractivation' doesn't exist. Is this new for the latest version of vb? What would be the equivelent for 2.03vb.

Can I substitute the mysql call in register.php with the 2.03 vb version if different?
$user=$DB_site->query_first("SELECT activationid FROM useractivation WHERE userid='$userinfo[userid]' AND type=0");

Any idea's ???????



26 Jan 2002, 23:16
Also I noticed that the nuke_users password table is unencrypted while the Post_Nuke codewants to compare it against an encrypted version.

Hence the compare passwd call does not match and it won't login users.

Anyone get around this? I guess now is a good time for me to start learning how to code...:)


27 Jan 2002, 01:06
this hack is for php-nuke m8.

27 Jan 2002, 01:10
i guess i could try and get this to work on post_nuke, but i never really thought of trying it since i dont like post nuke. But i might try it soon

29 Jan 2002, 16:58
Originally posted by Madison
It also works fine with PostNuke.
Thanx to the ppl from www.buffydownunder.com

can you please whic file to edit in postnuke?

29 Jan 2002, 17:22
i dunno, but i dont think my hack works for postnuke

28 Feb 2002, 21:47
Is anyone still working on this. I'm no techy and from what I've heard there are still problems with the latest versions? I paid for vBPortal, but a situation with the caching in use by my server means that it cannot work. I was 聲gel earlier in this post, back when the forums were on vb.com, this hack would be of great use to me.

05 Mar 2002, 20:28
Did anyone try to do this with postnuke?

10 Mar 2002, 15:34
For those of you who couldn't get this script to copy users...

the lines should read

$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 your_vB_database.user");
$query=mysql_query("update nuke_users set umode='nested', theme='YourTheme' ");

11 Apr 2002, 09:52
Ok, anyone tried this with PHP-Nuke 5.5 and VB 2.2.5???

And did anyone test this with 2 separate databases? Since I don't feel like installing VB's tables in the same database as PHP-Nuke's, because it's gonna be really messy!

05 May 2002, 14:24
So does this work with 2.2.5 and phpnuke? I really need this very much. Thanks :)

28 May 2002, 20:34
This hack works for me on Vbulletin 2.2.5 and Php-nuke 5.5

Is there a way to modify the cookies sent by each so that when a user logs in, in either php-nuke or vbulletin, they will automatically be logged in on the other one?

29 May 2002, 02:19
I cant get this hack to work for vbb 2.2.6 and postnuke at all has anyone else got this to work??

29 May 2002, 05:08
with some editing I got this one to work just fine


29 May 2002, 05:36
I dont understand why you dont just use vBportal?

06 Jun 2002, 10:01
Because some of us are too stingy to purchase vBportal.

18 Jun 2002, 13:29
My php nuke didn't come with a user.php file to edit.... now what?

19 Jun 2002, 02:18
postnuke is way better

19 Jun 2002, 08:01
postnuke, php-nuke... i found them huge. most of users only need few modules-segments from it. i tested postnuke recently. is 6mb in size (the zip content). i simply freaked when i saw the size...

20 Jun 2002, 07:23
Originally posted by nakkid
postnuke, php-nuke... i found them huge. most of users only need few modules-segments from it. i tested postnuke recently. is 6mb in size (the zip content). i simply freaked when i saw the size...

I found PHP-Nuke perfect nakkid. It is small on TAR.GZ format, but also it is reliable and doesn't need a patch every other day.

20 Jun 2002, 07:37
I wonder which hack is better for integrating phpnuke and vbulletin. This one or the one at http://www.vbulletin.org/forum/showthread.php?s=&threadid=36531

On a side note, is there anyway I can keep all my existing users? I don't want to loose a few thousand members on PHP Nuke and a few hundred at vBulletin. If i had a choice on which members to loose, I'd loose the vBulletin members simply because I have less. Though that means I'd have to flush my vBulletin Database from threads and stuff.

I'm using PHP-Nuke 5.6 + vB 2.2.6

16 Jul 2002, 06:11
yea that would suck losing all those members.

23 Sep 2002, 20:22
say if i have phpnuke with over 1000 users.. and i just installed vbull 2.2.7 how do i do this? i am totally lost.. icq# 2541353

www.cthreeracing.com is my site

20 Nov 2002, 02:10
Originally posted by ManagerJosh
Because some of us are too stingy to purchase vBportal.

vbportal is a free download !

21 Jun 2004, 15:02
I think that it will only work if you're using the root user. Otherwise you don't have access to another database.

Yea but if you are not using the root user to your db just add the forum user to your nuke db and it will work...

Eagle Creek
11 Aug 2004, 12:27
Does this work on Vbulletin 3.0.3 and PHPnuke 7.4 too?

14 Aug 2004, 22:22
No, this code is for older versions of vB. Off the record, I may do something like "vB Nuke", but don't quote me on it. (or expect much of anything)