vb.org Archive - vBulletin [2.2.8] and Post Nuke [.7.2.1] Integration

Page 8 of 10

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)

- - vBulletin [2.2.8] and Post Nuke [.7.2.1] Integration (https://vborg.vbsupport.ru/showthread.php?t=45371)

Hurricane

03-25-2003 04:25 AM

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

Code:

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

03-25-2003 06:52 PM

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

03-26-2003 01:36 AM

What were you attempting to do when the error occured?

I can not seem to recreate your error.

Hurricane

03-26-2003 02:02 AM

Another error! In the member.php

Code:

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	03-26-2003 04:09 AM

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

03-27-2003 08:02 PM

Quote:

Yesterday at 01:09 AM dkny said this in Post #75
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

03-27-2003 09:26 PM

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

03-31-2003 03:46 PM

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

04-02-2003 12:33 PM

Quote:

03-27-03 at 06:26 PM jwpexe2 said this in Post #77
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

04-05-2003 06:05 AM

Quote:

03-31-03 at 12:46 PM slinky said this in Post #78
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.

All times are GMT. The time now is 12:47 PM.

Page 8 of 10

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01131 seconds Memory Usage 1,747KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: