phpnuke reg integration hack

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

[BabyU]

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!

[wakawaka]

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.

[mkilty]

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

[BabyU]

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!

[wakawaka]

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.

[BabyU]

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!

[wakawaka]

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

[mkilty]

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

[mkilty]

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

[wakawaka]

this hack is for php-nuke m8.