Thread: Usenet gateway
View Single Post
  #145  
Old 03-24-2001, 03:36 PM
Guest
 
Posts: n/a
Default

Quote:
Originally posted by tamarian
If I install the latest usenet hack on vb2 beta 3, what would be involved in updating the database to future vb release? I don't mind losing the usenet posts, but don't want to lose members posts and information?
You should be OK for the most part. The usenet tables are all prefixed by 'usenet_' and it's unlikely they will ever conflict with a vB table. There are some added columns to the vB tables but again, it's unlikely they will conflict as they only have relevence to usenet stuff.

Where you may run into problems is the indexes. It should be fine when vB 2.0 is finally released, but with each beta I see a different set of indexes on the tables. One major ommission on beta 3 is the unique index on the 'username' column in the user table. This is required if you are importing users from usenet so my script adds it. If beta 4 fixes this ommission, you will end up with redundant indexes.

I can't forsee any scenario that would lead to posts or users being lost or removed so you're safe there.

Don't worry too much as I have this installed on my boards and it will be in my interest to make sure it all works for each new release
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01593 seconds
  • Memory Usage 1,755KB
  • 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_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
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete