View Single Post
  #10  
Old 11-04-2002, 04:26 PM
Brew's Avatar
Brew Brew is offline
 
Join Date: Sep 2002
Posts: 359
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02024 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete