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

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.

[Madison]

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.

[Madison]

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

[Robert9]

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.

[Lionel]

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?