vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Multiple sites with one user database (https://vborg.vbsupport.ru/showthread.php?t=55496)

99SIVTEC 07-22-2003 01:35 AM

Multiple sites with one user database
 
I run a network of several automotive websites. My members constantly complain about having to register on each site in order to post. I've searched and concluded that it would be far too difficult to use a single user database for all sites, but i'm trying to come up with other idea's. What about a cron job or something that could compare the user table of each site and copy the new users to all the sites? I have a speedy dedicated server, and all the sites are on that one server. Any other idea's?

Logician 07-22-2003 08:32 AM

If you searched in this board I'm sure you run into my post why it is too hard to manage.

CRON job is a good idea but it is still hard to achieve because you have to keep userids same in the all boards to have a solid structure and even with a CRON job it is not easy to keep userids same. (You have to disable registrations in all boards but one.).

I always say the same thing: If this is easy to do, why would vb.com and vb.org has different registrations anyway? This should prove that this is hard to achieve or does not worth working on it even for VB devs.

It can be still possible with a clever design, but frankly I wouldnt bother working on it if I were you.

Though a member here claimed that he managed to do it, so you may want to contact him (I dont remember his name, but he posted in the the other thread) if you are determined to do it.

NanoEntity 07-22-2003 08:50 AM

MySql 4, has a nice feature that leats you link databases, tables & colums together, like forum1.user=forum2.user, it would take a lot of hacking, but it can be done, the only problem, 2 forums have to be on same server.

here is example

PHP Code:

SELECT s.* 
FROM some_database.some_table galleryanother_database.another_table forum 
WHERE gallery
.some_column=forum.another_column 

This will be used in my vgallery I'm rewriting for vbulletin 3, https://vborg.vbsupport.ru/showthrea...threadid=47436

Brad 07-22-2003 09:56 AM

You could also do some back-end code and make the multiple sites run from one board installation. It will require a bit of trickery but is responably easy to do.

fengshui-123 11-25-2003 12:09 AM

Quote:

Originally Posted by Logician
I always say the same thing: If this is easy to do, why would vb.com and vb.org has different registrations anyway? This should prove that this is hard to achieve or does not worth working on it even for VB devs.


I saw this mod for invisionboard here: http://forums.ibplanet.com/index.php?showtopic=2142


Why it is difficult in doing this in vB?

aussiev8 11-30-2004 11:26 AM

uhmm i know this is comming late, but if all the sites are on 1 server, just make all the config.php fields point to the same server.
its as easy as that


All times are GMT. The time now is 04:25 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.01836 seconds
  • Memory Usage 1,724KB
  • 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)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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