Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 27 May 2012, 21:28
Chris8's Avatar
Chris8 Chris8 is offline
 
Join Date: Nov 2009
Two Separate vB Forums One Mysql User Table

I was thinking about creating completely separated vb forum (on other domain) and then connecting it with my first one using mysql views functionality to create virtual mirror of user database table replacing the second forum physical user table. So, users would need to register to the first forum and most things would be on the first forum but they would have an access to this second forum easily, same login same password. I also have a solution to deal with the cookies for seamless surfing both forums. The registration to second forum would be disabled.

My questions are, would it work? Is it possible? What problems it may cause if any? I wonder about it and I can't think of what could go wrong. I've read about other possible solutions of creating a bridge between two separate forum installations and this one seems to be easiest and most suitable for my purpose but I'm not sure if I will no run into any issues...

Any ideas if this would work good way?
Reply With Quote
  #2  
Old 28 May 2012, 17:55
PinkMilk PinkMilk is offline
 
Join Date: May 2010
Just an FYI:
2 domains = 2 licenses

you could however split forums into 2 pages similar to vb.org (forums, articles, mods etc ...) using a mod like this one: Split ForumHome Page into Multiple Pages which would eleviate the need for 2 licenses

then maybe change main logo depending on each forum somehow using an if else condition.

Last edited by PinkMilk : 28 May 2012 at 18:08.
Reply With Quote
  #3  
Old 02 Jun 2012, 17:39
Chris8's Avatar
Chris8 Chris8 is offline
 
Join Date: Nov 2009
Originally Posted by PinkMilk View Post
Just an FYI:
2 domains = 2 licenses

you could however split forums into 2 pages similar to vb.org (forums, articles, mods etc ...) using a mod like this one: Split ForumHome Page into Multiple Pages which would eleviate the need for 2 licenses

then maybe change main logo depending on each forum somehow using an if else condition.
Thank you for your post however that's absolutely not the thing I would like to do. I would like 2 complete separate vb installations with other subforums and other options on separate domains connected via remote mysql.
I'm aware I need two licenses for that. In fact I got a spare one that I was thinking to use this way. What I need is an efficient bridge between those two. I would like the second forum was something like an addition to the first one yet with separate rules and options on separate server...

I found some other ways like for example http://www.vbulletin.org/forum/showthread.php?t=185021 but I still would prefer mysql views. I'm just not sure if it will work. I guess I just need to give it a try.
Reply With Quote
  #4  
Old 02 Jun 2012, 17:55
kh99's Avatar
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I was wondering if it would work if you set up two sites to use the same database but with different table prefixes, then you'd only need to arrange some way to have them use the same table prefix on the tables you wanted to share (e.g. find every place in the code that uses user, userfield, etc and change the TABLE_PREFIX constant to USER_TABLE_PREFIX). But I'm not familiar with views so maybe it's a way of doing the same thing without needing to modify the code.
__________________
Please don't PM me - post your questions in the appropriate forum.
Please don't PM me to ask me to read your thread.
Reply With Quote
  #5  
Old 08 Jun 2012, 20:30
Chris8's Avatar
Chris8 Chris8 is offline
 
Join Date: Nov 2009
Thank you for the suggestion. Yup, that could be an option. I haven't tried any option yet, but I will do.. even only just to fulfill my curiosity. However, I'm not sure if I will proceed with this even if the test will be successful anyway cause I have security worries about this.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 07:22.

Layout Options | Width: Wide Color: