The Arcive of Official vBulletin Modifications Site.

leeherron · #1 06-17-2002, 04:31 PM

Interested if anyone has done anything to share a user database between more than one installation of vbb?

There are a few issues that could be addressed .. simply a central database server for the user database of all vbb installations would probably be the easiest, but could cause problems due to server connections on one box being inconsistant.

Has this been discussed or addressed by anyone yet?

leeherron · #2 06-17-2002, 04:32 PM

I should note; I am talking about the vb installations being on different servers than the user database.

Chris M · #3 06-17-2002, 08:06 PM

Im pretty sure it wouldnt work...

Satan

leeherron · #4 06-17-2002, 08:41 PM

There's no question that it can be done, the question is if anyone has discussed or already done it?

Central authorization database is not uncommon. VBB queries a SQL server for permissions, having it query one on a different server is quite doable.

Xenon · #5 06-17-2002, 08:48 PM

i don't know that such a thing has been released...

but it would also be very hard or nearly impossible, because on some times you'll nee the usertable and an other table in the same query...

Logician · #6 06-17-2002, 08:52 PM

In the first look it's very close to impossibility.

If MYSQL has a "redirect" feature for tables just like webservers, one line of code would do the trick, but unfortunately it doesnt have it.

The other possible solution would be going through the entire vb scripts and make heavy modifications in there to query other user table whenever vb interrelates with user table. I really wouldnt want to be the hacker to code this! :knockedout: Even if you have the courage to do this there are "joined queries" to user table in many parts of the code and they have to be structered totally in a different way and code and algorithm would change dramatically. So at last maybe it will work but I wouldnt call this script vbulletin anymore. You can really name the script after you..

And the third possibility (IMO the most practical) is to design the structure similiar to db/dns replication (are you familiar with the concept?). You can create a script connected to a cron job that will be triggered X times a day, go through the both user tables and populate the necassary fields accordingly. For example take existing new users from one and write to the other, update lastactivity field according to highest number etc.. Still not an easy job, but at least it's more practical..

leeherron · #7 06-17-2002, 10:20 PM

Quote:

Originally posted by Logician
.. have the courage to do this there are "joined queries" to user table in many parts ..

After Xenon's post, I remembered all the user table queries .. it would require a complete rewrite to do something like this.

Quote:

Originally posted by Logician
design the structure similiar to db/dns replication

This would be closer, but wouldn't work well with username creation .. would require a delay for new member registration.

The biggest problems stem from the user stats involved ..

planetrap · #8 08-27-2002, 05:25 PM

automotiveforums.com has something done like that, i been planning on doing it as well, but i don't know what to do

g-force2k2 · #9 08-27-2002, 05:42 PM

it looks like just one database to my and one forum... but i could be wrong... if you're looking for similiar design all you have to do is have a list of subforums inside a forum... thats all they did really and then customized the look of the forum home and forum display templates... regards...

g-force2k2

okrogius · #10 08-27-2002, 09:04 PM

I have two different vbs using one same userbase.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04185 seconds Memory Usage 2,255KB 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 (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)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 pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!