vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Shared User Database (https://vborg.vbsupport.ru/showthread.php?t=39966)

leeherron 06-17-2002 04:31 PM

Shared User Database
 
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 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 06-17-2002 08:06 PM

Im pretty sure it wouldnt work...

Satan

leeherron 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 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 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 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 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 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 08-27-2002 09:04 PM

I have two different vbs using one same userbase.


All times are GMT. The time now is 12:34 AM.

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.01091 seconds
  • Memory Usage 1,729KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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