vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Two databases sharing the same user table? (https://vborg.vbsupport.ru/showthread.php?t=205539)

sv1cec 02-16-2009 08:08 AM

Two databases sharing the same user table?
 
Guys, I have already a vB site running vB 3.0.xx heavily patched.

I am in the process of creating a new, independent site, which will have its own database, but I need to share the user table between the two sites. I know that I can export the existing table and import it in the new database, but what about future members who will register in my original site? I would like them to immediately become members of the second site as well.

Any ideas on how this can be done?

Thanks for any help you can provide me with.

Dismounted 02-16-2009 08:18 AM

The best solution in your case would be to create a bridge for the sites. As one user is updated, update the other. I usually suggest some sort of MySQL views or another solution that uses one table, but that would not be ideal in your case, as you are running two different versions of vBulletin.

Marco van Herwaarden 02-16-2009 08:21 AM

It has been done (search), but it will also give you a lot of headaches. All the usergroups (&id's) must be the same. If someone is a moderator on 1 forum he will also be a moderator on the other, postcounts, etc..

sv1cec 02-16-2009 03:56 PM

Thanks for the replies guys. The user groups, I do not care, I like actually to keep the same moderators. As for the post counts etc, these can be fixed with a few simple queries.

So Marco, what's your suggestion? Make everyone re-register? We are talking about 35000 members here.

bananalive 02-17-2009 02:37 PM

<a href="https://vborg.vbsupport.ru/showthread.php?t=185021" target="_blank">Share users database among many forums</a>


All times are GMT. The time now is 04:06 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.00938 seconds
  • Memory Usage 1,708KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete