Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2012, 08:28 PM
Chris8's Avatar
Chris8 Chris8 is offline
 
Join Date: Nov 2009
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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 05-28-2012, 04:55 PM
PinkMilk PinkMilk is offline
 
Join Date: May 2010
Location: Earth
Posts: 193
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 06-02-2012, 04:39 PM
Chris8's Avatar
Chris8 Chris8 is offline
 
Join Date: Nov 2009
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 https://vborg.vbsupport.ru/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 06-02-2012, 04:55 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 06-08-2012, 07:30 PM
Chris8's Avatar
Chris8 Chris8 is offline
 
Join Date: Nov 2009
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:52 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03736 seconds
  • Memory Usage 2,200KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete