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

[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

to

insert into yournukedbname.nuke_users

Worked for me.

[Admin]

[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

insert into nuke_users

to

insert into yournukedbname.nuke_users

Worked for me.

[orca]

You sure? I never got an error message.

[Admin]

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:

PHP Code:

$user_regdate = date("M d, Y"); 


is no where in register.php.

[orca]

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)

[N.B.]

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