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

-------------------------------------------------------------
FIND:

$DB_site->query("INSERT INTO user
(userid,username,password,email,".$newstylefield." parentemail,coppauser,
homepage,icq,aim,yahoo,signature,adminemail,showem ail,invisible,usertitl
e,joindate,cookieuser,daysprune,lastvisit,lastacti vity,usergroupid,timez
oneoffset,emailnotification,receivepm,emailonpm,op tions,birthday,maxpost
s,startofweek,ipaddress,pmpopup,referrerid,nosessi onhash) VALUES
(NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes($passw
ord)."','".addslashes(htmlspecialchars($email))."' ,".$newstyleval."'".ad
dslashes(htmlspecialchars($parentemail))."','$copp auser','".addslashes(h
tmlspecialchars($homepage))."','".addslashes(htmls pecialchars($icq))."',
'".addslashes(htmlspecialchars($aim))."','".addsla shes(htmlspecialchars(
$yahoo))."','".addslashes($signature)."','$adminem ail','$showemail','$in
visible','".addslashes($usertitle)."','".time()."' ,'$cookieuser','".adds
lashes($prunedays)."','".time()."','".time()."','$ newusergroupid','".add
slashes($timezoneoffset)."','$emailnotification',' $receivepm','$emailonp
m','$options','".addslashes($birthday)."','".addsl ashes($umaxposts)."','
".addslashes($startofweek)."','".addslashes($ipadd ress)."','$pmpopup','"
.addslashes($testreferrerid['userid'])."','$nosessionhash')");
$userid=$DB_site->insert_id();
$user_regdate = date("M d, Y");
--------------------------------------------------------------
AFTER THAT PLACE:

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

$cryptpass=crypt($password);
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

Find

user.php?op=COPPA

And just change it to

the url to the register.php file of vbulletin

easy hack, but ingenius, thanks again Matt and Russel

You can have it in 2 databases. Just edit the line for the mySQL-Query after where it says PHPNUKE registration from
to
Worked for me.

[QUOTE]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

Code:

---

insert into nuke_users

---

to

Code:

---

insert into yournukedbname.nuke_users

---

Worked for me.

You sure? I never got an error message.

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:
is no where in register.php.

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.

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)

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?s 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?t that problem to use root, but I would sugeest to NOT use root for any PHP program ! ;)

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.

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
russel@buffydownunder.com

Try looking for user.php?op=. May COPPA is replaced by add or similar.

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.

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

It also works fine with PostNuke.
Thanx to the ppl from www.buffydownunder.com

hey, is postnuke as good as php-nuke, would it be easy for me to switch my site to that?

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.

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

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... :)

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.

So just replace every single user.php?op= with http://whatever.com/register.php ?

Yes.
You can make it better, but I`ll tell you later how because I`ve a meeting now.

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.

Forgotten about me Madison? :(

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

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.

Nothing to aplogise for mate! Your English is 100% better than my German! ;)

STILL don't understand this hack. :(

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.

don't know postnuke...

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

meaning:
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.....(!)

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...

Robert

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.

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?

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)."',usergroupi d='$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!

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.

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....

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!

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.

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!

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

Hi,

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 ???????

Thanks,

Michael

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...:)

Thanks....

this hack is for php-nuke m8.