vBulletin [2.2.8] and Post Nuke [.7.2.1] Integration

[Brew]

This post will be updated from time to time with new info. So check this first post whenever you want to see if there are any changes to the code or docs.

11-9-02 12:15pm est
Made the hack files into zip format.
Added BANNING in PostNuke! (cookie based atm)
Added a lot of instructions.
Changed the link to PostWrap at the bottom of this post.
A couple bug fixes.

11-05-02 12:50pm est
Fixed a bug in the display avatar in PostNuke user profile screen.
I changed the rar download to reflect this.
You can find the fix in this post:
https://vborg.vbsupport.ru/showthread.php?s=&postid=318984#post318984

The above fix is in the zip file attached.

11-04-02 11:00pm est
Updated both the docs and the rar file.
It includes instructions on disabling the PN Admin ability to add or modify users. Only the vBulletin admin screen should be use to update or delete users.

Added a to-do to the list for making the hack work when adding new custom fields. As it is now you should not add any custom fields untill this is worked out. Although you can add custom user fields with some tweaking of the hack. It just needs to be automated somehow...haven't figured out how yet.

Also added a to-do to be sure moderators can modify or delete users where allowed.

Be sure you re-read through the whole thing in case something was overlooked!

11-04-02 4:30pm est
Added a link to my test site at the bottom
Just noticed that I haven't done anything with the PostNuke admin. Don't use the PostNuke admin to change or delete users until I fix this.

---------------------------------------------------------------------

Before you install this hack I must say:

This hack was only tested and used on a new install of vBulletin!!!

Also...BACK UP YOUR DATABASE FIRST!!!!

Once vBulletin is installed you use a small set of scripts that pulls users from the PostNuke tables and inserts them into the vB tables. The only user in the vBulletin database MUST be the admin of vBulletin! If your database already has members then you will have to search out a script that will merge the PostNuke database into vBulletins database.

The insertion files are included in the rar file with the instructions.

Above all else you MUST verify that the user tables are identical in the userid and username columns between PostNuke and vBulletin! If not then the hack will NOT work and you'll get information for wrong users and the whole thing will get buggered up and may even destroy the viability of your current user database!!! So complete and error free mirroring between the two user databases is absolutely essential!

Kier's avatar to file hack (https://vborg.vbsupport.ru/showthread.php?s=&threadid=11760&highlight=avatar+url) MUST be used with this hack as I tried many hours to get the hack to work without it. If you know of a working way to get the avatar from vB to display in a non-vB script I would appreciate the heads up (yes I rummaged through the hacks here at vBulletin.org but none of them worked for me)

If you don't follow the above warnings then TUFF! You've been warned :smoke:

This hack was written using ver2.2.8 of vBulletin and ver .7.2.1 of PostNuke.

The hack is nearly 100% integration. That is to say that PostNuke will use the resources of vBulletin nearly 100% pertaining to the user system. If you find areas where there needs to be better integration or areas I have overlooked please let me know so I can correct it!

This hack shares the user names and ids, avatars, signatures and all other aspects of user information except permissions and groups(it does work with the PN groups though)....which I feel should be separate from each other anyway.

The only things I can think of that are not integrated is the private message system and the ability to add news to the front page from vBulletin and visa-versa. If you know of hacks that would do this would you please share it with me?

Some things this hack will do:

New users coming in from PostNuke who want to register will be redirected to vB to register.

Users who have used the vB registration form can log in to PN but not be allowed to do the same things as a fully registered user can do.

When users click their email link to finish registration they will then have registered status in PN.

The user profile screen in PN displays the same information used in vB.

When using Kier's avatar to file hack the user profile screen in PN will display the same avatar as the user has for vb. (again.....if you know how to get the avatar from vB I would appreciate the heads up!)

When a user needs to have a password emailed to them they will be redirected to the vB send password screen.


This is a very involved hack using 7 different files. I will try to give some support to this....But since I've had vBulletin for only a week (or so) I don't know how well I'll be able to. Yeah...sounds scary to hear but believe me the hack works :p

Thanks to all who would like to test this hack!

As you'll see I need a bit of work in the docs. If you could help with that I would appreciate it!


Some to-do things....

Make the hack more PostNuke API friendly.

Change areas to make it so it will automatically detect the table prefix for PostNuke.

Create a new field where one can poke info in for each domain in a multi-site setup then have the hack peek this field.

Integrate the news system of PostNuke into vBulletin so when news is posted it will be posted to a particular forum.

Make the docs easier to follow.

Clean it all up using appropriate syntax..ie...using arrays where needed in loops etc.

Add the ability for the hack to add custom fields from vB. As it is now you should NOT add any custom fields!

But, of course, only if there's enough interest in the hack for me to do this....

To see this hack in action visit the test site...this is ONLY a test site and is not open to the public. Only those interested in testing the hack may use it.

vBulletin and PostNuke integrated (http://www.mapperz.com/index.php) .... go ahead and create an account...mess with it...whatever...The test site will only be available until I am confident it is bug free then will be moved to another site and be live.

Also the test site is using a module called "PostWrap". It incorporates vBulletin logins into the main page and is not part of the hack above. You can find PostWrap at PostWrap 2.01 at PostNuke.com (http://mods.postnuke.com/modules.php?op=modload&name=News&file=article&sid=1322)

[chad777]

just postnuke or will it work for phpnuke too ? crosses fingers ;)

[Brew]

Originally posted by chad777
just postnuke or will it work for phpnuke too ? crosses fingers ;)

There is only slight differences between PhPNuke and PostNuke in the user tables.

Using PhPMyAdmin look at them and mark the differences...then adjust accordingly.

You'll also have to make adjustmenst with the group settings in the hack as I think PhPNuke does not use groups and permissions.

This is something I'll look into once this hack is completed is to integrate PhPNuke....

But from what I remember they are pretty much the same...though I could be mistaken as it's been a while since I've played with PhPNuke (over a year and a half)

Brew

[thefreestyler]

look great thanks

[yahoooh]

i hope it works with phpnuke which is the best
i will test it at my local host and i will see if it is good integration

thank u

[yahoooh]

ok it is just integration in registeration

i was searching about full integration ex. vbulletin used as module for phpnuke like phpbb2

but i think no one do it here

any one need register integration phpnuke 6.00 and vbulletin 2.2.8
tell me because i do it already and bazed on w4u hack

i wish in the future get full phpnuke and vbulletin integration as phpnuke and phpbb2 which be integrated allready

[Brew]

Originally posted by yahoooh
i hope it works with phpnuke which is the best
i will test it at my local host and i will see if it is good integration

thank u

As I intimated in my earlier post ... I don't believe this hack will work with PhPNuke because of the groups and permissions system. If you try to make this work with it you'll probably have to take out those parts in the hack pertaining to this.

Doing so will mean that once someone registers they will automatically have access to using your site as a registered user. Email authentication will become null and void for your front page.

The only way around this would be to create a new field in nuke_users and then peeking into this field each and every time you want to restrict access to a feature in PhPNuke to registered users.....mucho work man....

My suggestion would be to upgrade to PostNuke from PhPNuke.

[Brew]

Originally posted by yahoooh
ok it is just integration in registeration

i was searching about full integration ex. vbulletin used as module for phpnuke like phpbb2

but i think no one do it here

any one need register integration phpnuke 6.00 and vbulletin 2.2.8
tell me because i do it already and bazed on w4u hack


i wish in the future get full phpnuke and vbulletin integration as phpnuke and phpbb2 which be integrated allready

I wish you would have explained what full integration means. Fully using the user registration IS full integration. Excepting for the private messages and being able to post to the front page there's not a whole lot else you can do....well maybe the calendar. But those things have already been hacked I believe and if you search the forums here you may be able to find them.

And if you were looking for a module maybe you should turn to a module maker.....looking in hacks you may have a hard time finding modules.

Brew

[Knux]

I have a question... IF I have forums that have over 300 members and I am about to do A fresh install of vbulleitn 2.2.8 but I am going to dump the users back in, would this still work or would I have to do something so it would??

[Brew]

Originally posted by Knux
I have a question... IF I have forums that have over 300 members and I am about to do A fresh install of vbulleitn 2.2.8 but I am going to dump the users back in, would this still work or would I have to do something so it would??

The main thing to remember is that the user id has to be the same between PostNuke and vBulletin. Once you have the user tables mirrored it should work great.

Using a utility to open up your sql database look in the "user" table for the userid numbers and take note of who is who. I mean for example user id 15 ok? Note the username for that id number.

Then go to the nuke_users table (or prefix_users depending on what prefix you're using) and do the same thing. All user ids MUST match between vBulletin and PostNuke. They must mirror each other without error.

If there is a utility to MERGE databases....wherein the users and their ids are re-arranged in such a way where all the users and their ids match between the two then it will work. Accurate mirroring is key to this to work.

Now If I didn't want to mirror and I just wanted to use one database I could have done that. And it probably wouldn't be too hard to tweak the hack in order to have only one database. I just feel it's better to have the two user databases seperate in case I drop one or the other....like maybe if I decided to stop using PostNuke...I'll want to keep the user tables in vB.

There could be multiple versions made of this hack. One for people with a new install of vB.....One where there are people in BOTH databases and one where there are people in the vB database but the PN database is empty. It would just take a bit of thought in how to go about it right.

Brew

[Brew]

Originally posted by Knux
I have a question... IF I have forums that have over 300 members and I am about to do A fresh install of vbulleitn 2.2.8 but I am going to dump the users back in, would this still work or would I have to do something so it would??

I just happened to think about this...

What you could do is create a script that would insert your vBulletin users into the PN user tables. Just be sure to leave the user id null and MySQL will add them to the highest userid number within the table.

Then delete the users from the vB user table and userfields and then use the scripts that are in the rar file to put them into the vB tables.....all should work!

One caveat however.....you would have to make sure that the users in your vB database are different then the ones in your PN database. So if harroldM has an account in your vB database AND he has an account in your PN database you would not want to insert his information into the PN database or there will be a duplicate....and I am not sure what that would cause to the whole system...let alone your user who may find himself locked out.

let me know if I am clear enough on this :D

If there's enough demand I'll make a script that will put the users from vB into PN...

BTW...Backup your database first!!!!!

Brew

[Brew]

Don't forget if I am missing anything in the integration to please let me know :nervous:

[darker1]

What about getting it to work with xoops from www.xoops.org. Might be easier then phpnuke.

[Brew]

Originally posted by darker1
What about getting it to work with xoops from www.xoops.org. Might be easier then phpnuke.


I don't have a clue about Xoops....never played with it.

Brew

[w4u]

Originally posted by Brew

I wish you would have explained what full integration means.
Brew

Full integration- is not only user integration, or registration in both- it?s sharing management in one place, 1 user panel, 1 login/logout function and so on. (look into phpBB2 :))
Finally, vbb ?must? be hacked so it will turn into postnuke module.

To do so, you must change a lot of code and/or write ?bridge? between postnuke and vbb.

I managed to change some vbb code, so it can be displayed as postnuke module- with all headers, footers and blocks. But there are a lot of work to do: cookie problems, urls in vbb and so on?. I hope I?ll finish it someday :)

[Brew]

Originally posted by w4u


Full integration- is not only user integration, or registration in both- it?s sharing management in one place, 1 user panel, 1 login/logout function and so on. (look into phpBB2 :))
Finally, vbb ?must? be hacked so it will turn into postnuke module.

To do so, you must change a lot of code and/or write ?bridge? between postnuke and vbb.

I managed to change some vbb code, so it can be displayed as postnuke module- with all headers, footers and blocks. But there are a lot of work to do: cookie problems, urls in vbb and so on?. I hope I?ll finish it someday :)

If all you want is one user panel just link to the user page either at vB or PN.

Why you think vB "must" be hacked into a module is beyond me and ludicrous. But hey....if you want to spend all that time to turn vB into a module power to you...and by the time you're done PN ver .725 will be here and your module will have to be written all over again. At least with the hack I'm doing people can have it now....

[Ninth Dimension]

In my opinion, Postnuke is a far better system that PHPNuke, so this hack initally looked interesting to me, but then I rememberd that I SWORE to never use a Nuke system again :)

But i am impressed with this hack, well done :)

[w4u]

Originally posted by Brew


If all you want is one user panel just link to the user page either at vB or PN.

Why you think vB "must" be hacked into a module is beyond me and ludicrous. But hey....if you want to spend all that time to turn vB into a module power to you...and by the time you're done PN ver .725 will be here and your module will have to be written all over again. At least with the hack I'm doing people can have it now....

LUDICROUS??? So you think phpBB2 integration into nuke system is ludicrous too?? And vbPortal is a waste of time too??
Lol :) btw, it?s only your opinion. Integration is more than only some user transfers.

2 Ninth Dimension: sometimes it seems to me, that it?s easier to write own portal, than try to figure out some schemas in nuke. Yeah it?s good system, but far from perfection. Which is better? Imho it wil be postnuke (pnAPI :)), but it?s harder to learn than phpNuke.

[Knux]

Originally posted by Brew


I just happened to think about this...

What you could do is create a script that would insert your vBulletin users into the PN user tables. Just be sure to leave the user id null and MySQL will add them to the highest userid number within the table.

Then delete the users from the vB user table and userfields and then use the scripts that are in the rar file to put them into the vB tables.....all should work!

One caveat however.....you would have to make sure that the users in your vB database are different then the ones in your PN database. So if harroldM has an account in your vB database AND he has an account in your PN database you would not want to insert his information into the PN database or there will be a duplicate....and I am not sure what that would cause to the whole system...let alone your user who may find himself locked out.

let me know if I am clear enough on this :D

If there's enough demand I'll make a script that will put the users from vB into PN...

BTW...Backup your database first!!!!!

Brew

Sounds good but I don't know that much PHP and I am limited on MySQL Knowledge. Is there any way that you could create a script to port my users to PostNuke???

[Brew]

I just made a change to the docs....I'll update the rar file in the first post to reflect this change:

----------------------------------------------------------------

In modules/NS-User/user.php near line 67 find the following:


if ($userinfo['user_avatar']) {
echo "<img src=\"images/avatar/$userinfo[user_avatar]\" alt=\"\"><br>\n";
}

And change it to the following:

//` Display avatar from vB
$userid=$userinfo['pn_uid'];
if ($userid<=2) {$userid=1; }
$z = mysql_query("SELECT avatarid FROM user WHERE userid='$userid'");
$row = mysql_fetch_assoc($z);
if ($row['avatarid']>'0') {
$avatartid=$row['avatarid'];
$z = mysql_query("SELECT avatarpath FROM avatar WHERE avatarid=$avatartid");
$row = mysql_fetch_assoc($z);
$avatarfile="forums/".$row['avatarpath']."";
if (!file_exists($avatarfile)) {echo"<img src=\"URL TO BLANK GIF\"><br>\n";}//`change this to an error graphic or a default avatar if wanted
else {echo"<img src=\"$avatarfile\"><br>\n";}
}
else {
$z = mysql_query("SELECT avatarrevision FROM user WHERE userid='$userid'");//get customavatar rev num
$row = mysql_fetch_assoc($z);
if ($row['avatarrevision']>'0') {
$avatarfile="forums/custom_avatars/avatar".$userid."_".$row['avatarrevision'].".gif";
if (!file_exists($avatarfile)) { echo"<img src=\"URL TO BLANK GIF\"><br>\n";}//`change this to an error graphic or a default avatar if wanted
else { echo"<img src=\"$avatarfile\"><br>\n"; }
}
}

---------------------------------------------------------------

The above fixes a bug of when showing avatars in the PostNuke User Profile screen.

Brew

[Brew]

Originally posted by Knux


Sounds good but I don't know that much PHP and I am limited on MySQL Knowledge. Is there any way that you could create a script to port my users to PostNuke???

As i was saying you would have to be sure that no two users were the same between the two databases.

To create a script that would first verify that all user id and names are unique and delete duplicate ids and names from one or the other database would be beyond my capability and time.

My suggestion would be to find a source for sql snippets someplace. Of find an existing app that has this and see how they did it.

Another thing you can do is ask in a IRC channel for help...which I am doing at the moment....try looking for a #php or #mysql channel.

If I come across a way to do this I'll let you know.

Brew

[Brew]

hhhmmm.....

Has anyone tried this hack?

There's not a single bug in it someone wants to tell me about?

:nervous:

Brew

[Knux]

well I would try it but now I gotta go out and figure this stuff out.... Also I was askin if you could make that script that ports vb users to postnuke...

[Mythril]

can someone please post an zip file I cant extract the rar file even with the rar extracter. Thanks

[Brew]

There will be a new download tomorrow night with several bug fixes....Hold on till after that, ok?

Brew

Originally posted by Mythril
can someone please post an zip file I cant extract the rar file even with the rar extracter. Thanks

[Mythril]

okay thanks see ya tommorow :)

[Brew]

First post updated with new files....

They are now zip too!

https://vborg.vbsupport.ru/showthread.php?s=&postid=318446#post318446

:glasses:

[Knux]

hey do you think you could make a script to port vb users to postnuke?? That way I could use this hack....

[Knux]

Nevermind I will use Mysticle's hack to prot my users form vb to postnuke then I will use your hack to intergrate them ;)!


BTW hisn hack can be found at: http://www.ctjeep.org/modules.php?op=modload&name=Downloads&file=index&req=viewdownload&cid=3

I will let you know later how this works out :D!

[Katana Myronson]

this looks awesome!

[Hurricane]

OK, I think I have a problem here! In the docs it says:


Near line 919 find the following:

//` put password into PN user table
$pnuser='$bbuserinfo[userid]';
if ($pnuser=1) {$pnuser=2; }
$DB_site->query("UPDATE nuke_users SET pn_pass='".addslashes(md5($newpassword))."' WHERE pn_uid='$pnuser'");

That completes the hacks for forums/member.php!



I think it is missing what I am to look for. HELP! I am now way into this and I am missing stuff? :(

EDIT--

It looks like another problem:


In the PostNuke file modules/NS-Your_Account/user/modules/user.php find the following near the top:

function edituser($htmltext)
{
$ThemeSel = pnConfigGetVar('Default_Theme');


Seems I do not have this file at all. :(

Sorry guy, this really needs some work. And I know the sad part is that I am sure you have put many, many hours into it. You are close, but it has issues.

[Hurricane]

For anyone thinking about doing this, be patient. I am working on some corrections and update install file. I tried to contact Brew, but never got a reply. It is a nice setup. I have also done it with a fully populated VB and moved my members to postnuke.

Sit tight I will post my findings soon! :)

[we_scooter]

Does this mean that we can integrate, VB with PHP nUKE??
regarding the users registerations and latests topics..??

[bharvey42]

Originally posted by we_scooter
Does this mean that we can integrate, VB with PHP nUKE??
regarding the users registerations and latests topics..??

you people should really read the posts. this DOESN'T WORK WITH PHPNUKE

IT WORKS WITH POSTNUKE.

If you use phpnuke and really want this to work upgrade to PostNuke.

[Grendel602]

I've tried using this hack with no luck. I had the same problems that Hurricane was talking about. There are things that aren't quite right with the install file.

Brew, where ya at man? This hack is huge ... if you get it done!!!

[Nomb]

I'm going to be looking at this hack in a week or so. If I figure it out I'll post here. If Brew get's back and fixes it ... Woohoo!

( :

[niudlezz]

Hello guys, I just did this hack and it worked! Is there a way we can make it so that all PN users who sign up on the site can post on the forum as well with the same username? The hack only ports the users over, so if new users were to sign up afterwards, it wouldn't work. Is there a way we can make it so that all PN users can post on the forum as well with the same DB?

[Hurricane]

I have successfully tied them together! (Well for a while anyway) There are quite a few bumps in this project and I am still working through it. I have just been quite busy. I have all the scripts for moving the members from vBulletin into Post Nuke. As soon as I can get my sh*t together I will post it all here. This is a wonderful hack. Another MAJOR change I made was to keep the databases seperate. It is more load on the server as it has to do more queries, but it is worth it.

Let's keep this alive!

[dkny]

Originally posted by Hurricane
I have successfully tied them together! (Well for a while anyway) There are quite a few bumps in this project and I am still working through it. I have just been quite busy. I have all the scripts for moving the members from vBulletin into Post Nuke. As soon as I can get my sh*t together I will post it all here. This is a wonderful hack. Another MAJOR change I made was to keep the databases seperate. It is more load on the server as it has to do more queries, but it is worth it.

Let's keep this alive!

Good luck on the integration, alot of heads are counting on you, including myself. I'm Please keep us updated! :banana:

[C.Birch]

where is this file:

modules/NS-Your_Account/user/modules/user.php

i dont have it :(

[Nomb]

I have our site integrated. Brew did some great work here but I had to change A LOT of things to make this work correctly.

Things I'd still like to do when I have time:

1) Pull avatars over from vB. The php included in this hack was pretty sloppy. I didn't even look into it cause I mainly wanted to get the two integrated so I could open our pN site and allow new registrations.

2) Integrate PM system.

3) Integrate the vB calendar and the pN module ? PostCalendar.

4) Tighten up the banning integration, that code was somewhat sloppy as well. It was made for moderators, but wasn?t setup for admins to simply move a vB user into the banned group.

5) Tighten up User Group integration. If I get this straight banning will be all set as well.

6) Create frames so that vB forms appear in pN. I think there is a module out there called PostWrap ? dunno haven?t looked into this?

Just FYI, this hack creates a channel between vB and pN. Meaning, after it is implemented you will still have 2 mysql databases. Furthermore, user administration, registration, and all other features are done using the vB forms. After one of these vB forms are submitted there are small sql queries that update the pN database to reflect any changes. I don?t know about you but I like it this way. As I do more work and tighten up some of the features I mentioned above I?ll post a full release hack, unless someone else finishes one first.

You can check it out at http://www.otllive.com

( :

[bharvey42]

Well I have a bridge on my site so until I get another vB for my other site I won't have much time to work on a non-bridged integration.

However I am in the process of working on the pm system and the profile system.

I have both using the same database.

Yes you can use PostWrap to display vB within PostNuke there are other ways to accomplish this as well. My soultion is not using postwrap.

You will all be able to see it when the site is finished, unless somebody would like to donate an extra license for me to use :)

Until then stay tuned.

[C.Birch]

Originally posted by Nomb
I have our site integrated. Brew did some great work here but I had to change A LOT of things to make this work correctly.

Things I'd still like to do when I have time:

1) Pull avatars over from vB. The php included in this hack was pretty sloppy. I didn't even look into it cause I mainly wanted to get the two integrated so I could open our pN site and allow new registrations.

2) Integrate PM system.

3) Integrate the vB calendar and the pN module ? PostCalendar.

4) Tighten up the banning integration, that code was somewhat sloppy as well. It was made for moderators, but wasn?t setup for admins to simply move a vB user into the banned group.

5) Tighten up User Group integration. If I get this straight banning will be all set as well.

6) Create frames so that vB forms appear in pN. I think there is a module out there called PostWrap ? dunno haven?t looked into this?

Just FYI, this hack creates a channel between vB and pN. Meaning, after it is implemented you will still have 2 mysql databases. Furthermore, user administration, registration, and all other features are done using the vB forms. After one of these vB forms are submitted there are small sql queries that update the pN database to reflect any changes. I don?t know about you but I like it this way. As I do more work and tighten up some of the features I mentioned above I?ll post a full release hack, unless someone else finishes one first.

You can check it out at http://www.otllive.com

( :

sounds great.

yeah theres a mod called postwrap for pn but it opens things in a i fream so for forums you have two scroll bars you have to move the pn sites and then the i freams.

[dkny]

Originally posted by Nomb
I have our site integrated. Brew did some great work here but I had to change A LOT of things to make this work correctly.

Things I'd still like to do when I have time:

1) Pull avatars over from vB. The php included in this hack was pretty sloppy. I didn't even look into it cause I mainly wanted to get the two integrated so I could open our pN site and allow new registrations.

2) Integrate PM system.

3) Integrate the vB calendar and the pN module ? PostCalendar.

4) Tighten up the banning integration, that code was somewhat sloppy as well. It was made for moderators, but wasn?t setup for admins to simply move a vB user into the banned group.

5) Tighten up User Group integration. If I get this straight banning will be all set as well.

6) Create frames so that vB forms appear in pN. I think there is a module out there called PostWrap ? dunno haven?t looked into this?

Just FYI, this hack creates a channel between vB and pN. Meaning, after it is implemented you will still have 2 mysql databases. Furthermore, user administration, registration, and all other features are done using the vB forms. After one of these vB forms are submitted there are small sql queries that update the pN database to reflect any changes. I don?t know about you but I like it this way. As I do more work and tighten up some of the features I mentioned above I?ll post a full release hack, unless someone else finishes one first.

You can check it out at http://www.otllive.com

( :

Looks good on your site, great work. if you accept donations, I'll be willing to donate when you done. Alot of heads are waiting for this. Btw on your site the "Affiliates" block, was that something you made?

[C.Birch]

I think the Affiliates Block is just a html block :) but i might be wrong.

But im looking farward to this hack being fully done has i now use postnuke for my main site.

my forum has the following stats:

Most users ever online was 130 on 08-12-2002 at 00:29
Members: 1,986

so adding postnuke to my vb database will be a big hit.

[UnForums2k]

iv been waiting on this for along time... this is a must install... but i cant find my modules/NS-Your_Account/user/modules/user.php it doesnt exist.... :) thanx

[bharvey42]

anybody have an extra vB they want to donate to developing the hack further?

[Rezin]

I'm willing to make a donation to get this moving too.

I'd really like to get this hack going, I have a pretty decently trafficked site (and it's only 4 months old!) and we have some beautiful hacks done (compared to comepeting sites) and this would be the icing on the cake.......

I am also interested in skins and the like. If we have talented peeps here, who could design a smooth skin/theme that would match my site, I am willing to pay for that as well. (emial rezin@cycleforums.com if interested)

Thanks for taking it this far, MANY of us anxiously await the outcome!

Rezin
www.cycleforums.com

[bharvey42]

Once I get an extra vB I will start working on some better integration for it. Rezin if your looking for some help on some integration shoot me an e-mail.

[UnForums2k]

ok im tryin to install this hack but i am lost on the first step of modifing the vb.... iv hacked alot of vbs but i dont know wether to replace the whole thing or what? can anyone clear this up???

and hint for future updates... update your instructions to be more easily read... *just suggestion* thanx

And change everything after the above line up to $action="modify"; (but don't change this line)

[UnForums2k]

also found this on the last step of editing forums/member.php

Near line 919 find the following:

//` put password into PN user table
$pnuser='$bbuserinfo[userid]';
if ($pnuser=1) {$pnuser=2; }
$DB_site->query("UPDATE nuke_users SET pn_pass='".addslashes(md5($newpassword))."' WHERE pn_uid='$pnuser'");

that is obviosly nowere in member.php so were do i add it?

[msimplay]

Originally posted by Nomb
I have our site integrated. Brew did some great work here but I had to change A LOT of things to make this work correctly.

Things I'd still like to do when I have time:

1) Pull avatars over from vB. The php included in this hack was pretty sloppy. I didn't even look into it cause I mainly wanted to get the two integrated so I could open our pN site and allow new registrations.

2) Integrate PM system.

3) Integrate the vB calendar and the pN module ? PostCalendar.

4) Tighten up the banning integration, that code was somewhat sloppy as well. It was made for moderators, but wasn?t setup for admins to simply move a vB user into the banned group.

5) Tighten up User Group integration. If I get this straight banning will be all set as well.

6) Create frames so that vB forms appear in pN. I think there is a module out there called PostWrap ? dunno haven?t looked into this?

Just FYI, this hack creates a channel between vB and pN. Meaning, after it is implemented you will still have 2 mysql databases. Furthermore, user administration, registration, and all other features are done using the vB forms. After one of these vB forms are submitted there are small sql queries that update the pN database to reflect any changes. I don?t know about you but I like it this way. As I do more work and tighten up some of the features I mentioned above I?ll post a full release hack, unless someone else finishes one first.

You can check it out at http://www.otllive.com

( :
Hmm with this intergration i see many problems i was considering doing it myself afterall an intergrated site feels the best
but after seeing this site and its Login problems the hack leaves much to be desired

[bharvey42]

Like I said still willing to help out.

[Nomb]

Originally posted by msimplay

Hmm with this intergration i see many problems i was considering doing it myself afterall an intergrated site feels the best
but after seeing this site and its Login problems the hack leaves much to be desired

What do you mean login problems?

[msimplay]

it seems to be out of synch
i login and i get messages ur not logged in when i try to do something
doesn't matter now i suppose Vbportal does the job altho less support its not too bad

[Nomb]

msimplay, you never email verified. You're not going to be able to do anything until you do that. Both at the forums and the main site.

[dkny]

anyone still trying to get this to work?

[Hurricane]

I have not had the time, but I am going to get back to making this work. It is very important to me. I almost had it, but had to undo it temporarily.

I will keep my findings posted here.

[EDIT - I have spent the majority of the night working on this. I almost have it. It will take me a little time to write it up though. --GS]

[Hurricane]

I got it! I think I have tested everything. I will do a write up asap! Let me be the first to say, this is so sweet!

I want to thank Brew for starting this. He gave me enough info to head in the right direction, and enough errors to make it a challenge! :p

[Hurricane]

I am in the process of writing it all up! I should have it ready sometime tomorrow night.

[jwpexe2]

Hi Hurricane,

I just wanted to know what version of vb and postnuke you are using. I am trying this on
vBulletin Version 2.3.0 and
postnuke 0.7.2.3-Phoenix

I have run into a few bumps in the member.php file at the end, looking forward for you write up..

[Hurricane]

That is the same versions that I used this weekend. I have the write up about 75% done and I should have it posted tonight. There were quite a few bumps along the way but I think I have most of it worked out.

[jwpexe2]

cool,

I have studied the code most of the weekend.
I have been trying to get the user conversion from pn to vb today.
Running into some problems with duplication. I am not a php master, but am willing to help get this project done.

[Hurricane]

Once I have all of my stuff together, it will be very easy!

[Hurricane]

OK, here is my write up and files. PLEASE follow the instructions to a T. Also notice that this is still technically a BETA. Also remember that neither I, nor Brew are responsible for your data! Backup BEFORE you begin.

Also it is very important to go through the entire install file BEFORE you run the supporting scripts as there are things you must do first!

My version of this hack was written to use 2 separate databases. It does not integrate the 2 DBs. This way it is easier to undo.

I think that is all. Please let me know how it goes. Please contact me here for support. Do not email me for support!

UPDATE!!!
The file attached is a new file! There was only one download since it was posted, but who ever it was, you need this one. The import script is broken in the old one!!!!

[jwpexe2]

Thanks for the update, I have been trying to figure out what went wrong

Thanks for your Help on this hack!

[Hurricane]

It is my pleasure. I am glad I finally had time to finish it. There is still some issues with the Avatars being displayed in PN. I will try to have the fix posted by tomorrow. It is not a fatal error!

[jwpexe2]

Thanks Hurricane, and Brew sorry to forget about ya

I got it installed on the site.

Good Work!!

[Hurricane]

Well, just remember that it was not all me! Brew had a lot to do with it! ;)

[jwpexe2]

I did notice one thing when I went to Retrieve lost password link I got an error
Parse error: parse error in /NS-LostPassword/user.php on line 141
Untill I took out two }}

include 'footer.php'; // <- This is approx line 138
*/ // <- This is what you are adding!

} /////// delete these
} //////// delete these
}

?>

[Hurricane]

OK, I will check that out. There is another issue! In the member.php (vBull file) it should be this:


Near line 632 [585] find these lines:

if ($showbirthdays)
getbirthdays();
// insert custom user fields
$DB_site->query("UPDATE userfield SET userid=$bbuserinfo[userid]$userfields WHERE userid=$bbuserinfo[userid]");

After the above lines add the following:

///////// PN Integration Hack Start: ///////////////
//`Update PN user database for Bio, Location, Interests and Occupation
$DB_site->query("UPDATE pndb.nuke_users SET pn_bio='$userbio',pn_user_from='$userloc',pn_user_ intrest='$userintrest',pn_user_occ='$userocc' WHERE pn_uid='$userid'");
///////// PN Integration Hack End: ///////////////

The only difference is the end where it says pn_uid='$userid' Was not enclosed in ticks ( ' ' ). It causes issues when updating your profile.


Zip file updated with both the above changes.

[jwpexe2]

I did the fix above, but have got a few emials today that say

Database error in vBulletin 2.3.0:

Invalid SQL: UPDATE pndb.nuke_users SET pn_pass='61c33ac309d60c87faea52ba65c15bd' WHERE userid=$bbuserinfo[userid] mysql error: You have an error in your SQL syntax near '[userid]' at line 1

mysql error number: 1064

[Hurricane]

What were you attempting to do when the error occured?

I can not seem to recreate your error.

[Hurricane]

Another error! In the member.php


Near line 632 [585] find these lines:

if ($showbirthdays)
getbirthdays();
// insert custom user fields
$DB_site->query("UPDATE userfield SET userid=$bbuserinfo[userid]$userfields WHERE userid=$bbuserinfo[userid]");

After the above lines add the following:

///////// PN Integration Hack Start: ///////////////
//`Update PN user database for Bio, Location, Interests and Occupation
$DB_site->query("UPDATE pndb.nuke_users SET pn_bio='$userbio',pn_user_from='$userloc',pn_user_ intrest='$userintrest',pn_user_occ='$userocc' WHERE pn_uid='$bbuserinfo[userid]'");
///////// PN Integration Hack End: ///////////////


The change is the last line. WHERE pn_uid='$userid' is to be WHERE pn_uid='$bbuserinfo[userid]'

Updating the ZIP file!

[dkny]

Hurricane, You the man!
I'll try this hack over the weekend, will keep you updated. Now I have VB 2.9.0 will it be a problem?
Also I dont have a clean VB user database, I have 4k members, will that be a problem?

[Hurricane]

Yesterday at 01:09 AM dkny said this in Post #75 (https://vborg.vbsupport.ru/showthread.php?postid=373454#post373454)
Hurricane, You the man!
I'll try this hack over the weekend, will keep you updated. Now I have VB 2.9.0 will it be a problem?
Also I dont have a clean VB user database, I have 4k members, will that be a problem?

No, no problems with either of them. The import utility that I "made" will not only pull your VB users into Nuke, but it also sets everyones user level to normal users. Just make sure to follow the instructions to a T! ;)

[jwpexe2]

I getting this error in my email box and it is caused when the user tries to update their password from the retrive Retrieve lost password.

Invalid SQL: UPDATE pndb.nuke_users SET pn_pass='56302cb1891d8f4629952f11a8564f30' WHERE userid=$bbuserinfo[userid] mysql error: You have an error in your SQL syntax near '[userid]' at line 1

mysql error number: 1064

I have tried to some to change this part of the code and get new errors so I gess its in here in the members.php file.

///////// PN Integration Hack Start: ///////////////
//`Update PN users password
$pnuser='$bbuserinfo[userid]';
// if ($pnuser=1) {$pnuser=2; } //Uncomment this line if you did not remove the anon account and move the pn admin to uid 1
$DB_site->query("UPDATE pndb.nuke_users SET pn_pass='".addslashes(md5($newpassword))."' WHERE userid=$pnuser");
///////// PN Integration Hack End: ///////////////

[slinky]

Unfortunately PostNuke is currently dead technology, IMHO, as development seems permanently in park.

Probably the best current solution is phpportals.com, which is free although the $20 donation goes to great use and allows you to get beta code. It uses existing vb information, posts news as threads so that comments will go into a ratable vb database area and isn't all messed up as it is in Nuke, and much more.

Right now the successor to Postnuke is xaraya but the product is not out yet and it will take time to see what kind of forum integration will be possible.

[Hurricane]

03-27-03 at 06:26 PM jwpexe2 said this in Post #77 (https://vborg.vbsupport.ru/showthread.php?postid=374242#post374242)
I getting this error in my email box and it is caused when the user tries to update their password from the retrive Retrieve lost password.


Invalid SQL: UPDATE pndb.nuke_users SET pn_pass='56302cb1891d8f4629952f11a8564f30' WHERE userid=$bbuserinfo[userid] mysql error: You have an error in your SQL syntax near '[userid]' at line 1

mysql error number: 1064

I have tried to some to change this part of the code and get new errors so I gess its in here in the members.php file.

///////// PN Integration Hack Start: ///////////////
//`Update PN users password
$pnuser='$bbuserinfo[userid]';
// if ($pnuser=1) {$pnuser=2; } //Uncomment this line if you did not remove the anon account and move the pn admin to uid 1
$DB_site->query("UPDATE pndb.nuke_users SET pn_pass='".addslashes(md5($newpassword))."' WHERE userid=$pnuser");
///////// PN Integration Hack End: ///////////////

Try changing the last part to:
userid='$pnuser'");

See if that will help.

[bharvey42]

03-31-03 at 12:46 PM slinky said this in Post #78 (https://vborg.vbsupport.ru/showthread.php?postid=375977#post375977)
Unfortunately PostNuke is currently dead technology, IMHO, as development seems permanently in park.

Probably the best current solution is phpportals.com, which is free although the $20 donation goes to great use and allows you to get beta code. It uses existing vb information, posts news as threads so that comments will go into a ratable vb database area and isn't all messed up as it is in Nuke, and much more.

Right now the successor to Postnuke is xaraya but the product is not out yet and it will take time to see what kind of forum integration will be possible.


I assure you PN is not a dead product. Nor is the development in park.

[slinky]

Yesterday at 09:05 AM bharvey42 said this in Post #80 (https://vborg.vbsupport.ru/showthread.php?postid=377729#post377729)
I assure you PN is not a dead product. Nor is the development in park. Unless you call a few gifs added in the past 6 months progress. Whatever, it doesn't matter what hope may spring eternal. My post was just to answer the question and provide excellent alternatives that are also far better integrated into VB because they were designed to be.

[Session]

Is there a chance this will be upgraded for 2.3.0 with PN 0.723?? Or will all developments halted untill the release of VBulletin 3.0?

Or will this version work for 2.3.0 aswell?

Thx in advance,
Session.

[bharvey42]

04-06-03 at 02:13 PM slinky said this in Post #81 (https://vborg.vbsupport.ru/showthread.php?postid=378343#post378343)
Unless you call a few gifs added in the past 6 months progress. Whatever, it doesn't matter what hope may spring eternal. My post was just to answer the question and provide excellent alternatives that are also far better integrated into VB because they were designed to be.

Try to avoid commenting on things you know nothing about, if you want to thread crap do it elsewhere.

[bharvey42]

Today at 11:28 AM Session said this in Post #82 (https://vborg.vbsupport.ru/showthread.php?postid=379240#post379240)
Is there a chance this will be upgraded for 2.3.0 with PN 0.723?? Or will all developments halted untill the release of VBulletin 3.0?

Or will this version work for 2.3.0 aswell?

Thx in advance,
Session.

Like I said when I get another vB license I will be more then happy to pick up the development.

[MamiRavi]

i know this is pretty much a dead thread.. but i need help!

[bharvey42]

There will be a better integration soon stay tuned.

www.flashbackmultimedia.com

[slinky]

Xaraya will likely have some integration soon and is now URL friendly too which is very cool. Postnuke is virtually dead technology and has been for almost a year now.

[bharvey42]

I'm sure the 50 people who have downloaded it will like it.

PostNuke isn't dead technology, we will be releasing our final version of .726 shortly. Until then give our new .726 RC3 a test drive.

[slinky]

Today at 06:19 PM bharvey42 said this in Post #88 (https://vborg.vbsupport.ru/showthread.php?postid=418981#post418981)
I'm sure the 50 people who have downloaded it will like it.

PostNuke isn't dead technology, we will be releasing our final version of .726 shortly. Until then give our new .726 RC3 a test drive.
Good luck to you and the 50 downloaders on the release of R3. I'll be sticking with Xaraya from now on and into the future. Look forward to vb integration.

[bharvey42]

zip 6,728 downloads... tar.gz. 4,803 downloads

For those of you counting at home thats 11,531 downloads. much more then your 50 or so. I already have PN integration that works with vB but thanks :)

[slinky]

Yesterday at 10:58 PM bharvey42 said this in Post #90 (https://vborg.vbsupport.ru/showthread.php?postid=419046#post419046)
zip 6,728 downloads... tar.gz. 4,803 downloads

For those of you counting at home thats 11,531 downloads. much more then your 50 or so. I already have PN integration that works with vB but thanks :) Well, you're the one that said 50.

Thankfully Xaraya is a complete rewrite of the old nuke code and is inherently search engine friendly. :) BTW, in terms of ever using Postnuke, users should read the FAQ very, very carefully. ;)

Good luck to you and enjoy it as we enjoy Xaraya.

[huskerman007]

Does this work with vbulliten 3

[ManagerJosh]

Does this work with vbulliten 3
No..

[slinky]

No..

On this topic I have come to one conclusion. The Nuke stuff is horrible. Once you leave you are shocked that you stayed with it for so long. I can recommend plenty of other content management systems that are far superior and then just add in components as you go along. You'd be surprised how useless most of the "modules" really are.

I do know that Miraserver is VB3 compatible and one of my sites plays incredibly well with it. There are several other good packages out there but I am so glad that I have stayed away from anything with "nuke" in its title.

[Holidazed]

Is there any hope of getting this to work with vbb3.6xx and PostNuke .764?