PDA

View Full Version : Multiple sites with one user database


99SIVTEC
07-22-2003, 02:35 AM
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, 09: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, 09: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

SELECT s.*
FROM some_database.some_table gallery, another_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/showthread.php?s=&threadid=47436

Brad
07-22-2003, 10: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
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