Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2004, 08:41 PM
Dolby's Avatar
Dolby Dolby is offline
 
Join Date: Oct 2001
Location: Wisconsin
Posts: 72
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Global VB3 user table

I own 5 vbulletin licesens and I would like to have a global user table so a user just needs to register with one site and they are registered with all.

With vb3 am I wrong to think that all the user queries are done in functions_user.php, functions_register.php and adminfunctions_user.php so I can just change the database connections there to use the global user table? Or is this gonna be just about as impossible to do as with vb3.

I could just make a registration page that dumps the info into all the databases but I'd like the userid to be the global.
Reply With Quote
  #2  
Old 03-27-2004, 08:54 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dolby
With vb3 am I wrong to think that all the user queries are done in functions_user.php, functions_register.php and adminfunctions_user.php
Yes, you would be very wrong to think that There are queries all over the place that relate to the 3 user tables, user, userfield and usertextfield. If you have them all in the same database then it should be just a matter of defining a user table prefix in config.php and then editing all the queries, which you'd have to search through all the files for " . TABLE_PREFIX . "user (as well as the other two) and edit the prefixes everywhere and that *should* work, its somthing to go on at least
Reply With Quote
  #3  
Old 03-27-2004, 09:13 PM
Dolby's Avatar
Dolby Dolby is offline
 
Join Date: Oct 2001
Location: Wisconsin
Posts: 72
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the reply NTLDR. These would be seprate databases on a couple servers. Ohh well back to the drawing board.

I think I might just end up makeing a global registration page that dumps the data into all my vbulletins.

To bad there isnt a mysql command to share a specified table or auto sync a table through out multiple databases.
Reply With Quote
  #4  
Old 03-27-2004, 10:27 PM
Ryan Ashbrook's Avatar
Ryan Ashbrook Ryan Ashbrook is offline
 
Join Date: Dec 2002
Location: Cincinnati, Ohio
Posts: 422
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by NTLDR
Yes, you would be very wrong to think that There are queries all over the place that relate to the 3 user tables, user, userfield and usertextfield. If you have them all in the same database then it should be just a matter of defining a user table prefix in config.php and then editing all the queries, which you'd have to search through all the files for " . TABLE_PREFIX . "user (as well as the other two) and edit the prefixes everywhere and that *should* work, its somthing to go on at least
I can verify that.

I've done it before and, while it's weird at first, it works.
Reply With Quote
  #5  
Old 03-28-2004, 12:07 AM
Dolby's Avatar
Dolby Dolby is offline
 
Join Date: Oct 2001
Location: Wisconsin
Posts: 72
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ryan Ashbrook
I can verify that.

I've done it before and, while it's weird at first, it works.
I believe NTLDR, however the 5 databases are all separate at the moment so that wont work for me. I guess I could merge all the databases together and use prefixes but wouldn?t it be more efficient to have 5 small databases then one big hairy db? I guess I could put the one big db on its own server.

Thanks.
Reply With Quote
  #6  
Old 03-28-2004, 04:02 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To be honest I don't know. I'd suggest asking eva2000 over at vB.com as he would have a much better idea of any performance issues
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:09 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04537 seconds
  • Memory Usage 2,209KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete