Go Back   vb.org Archive > vBulletin Article Depository > Read An Article > vBulletin 4 Articles
Reload this Page [How To] Multiple Forums with shared user database
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
[How To] Multiple Forums with shared user database
we_are_borg
Join Date: Jul 2004
Posts: 108

 

Show Printable Version Email this Page Subscription
we_are_borg we_are_borg is offline 11-21-2010, 10:00 PM
This guide is to let you run multiple vBulletin software from one user database. Please make sure you understand what is written and you have knowledge of Linux commands to make it very clear USE AT OWN RISK.

Original Idea is from krohnathlonman https://vborg.vbsupport.ru/showthread.php?p=1289985 but is for vBulletin 3, i only adapted it for vBulletin 4. Used his example of the path so that you can compare.

You need multiple licenses if you are going to use this (in many cases) read
http://www.vbulletin.com/forum/showt...ifferent-skins
if you do not under stand what is written please ask a staff member at vBulletin.com

USE AT OWN RISK, ALWAYS MAKE BACKUPS.

This is for new forums only you need to merge stuff if you want to include establish forums but this will not be handled here. This is made for vBulletin 4.0.8+ you can adapted it for versions below 4.0.8, if the file does not exist then do not make an ln for it.

There will be issues to deal with you can better test this first do not try this on a live site. First test a few times then do this on a live site, but always remember to make backups.

We can't say it enough BACKUP DATABASE there is no excuse to do so.

You need access to where the database write the files it self this is mostly only the case under VPS and Dedicated servers. You need to stop the database server first, then and only then you can remove the files. One line is one command. If you do not understand the commands let some one else do it that is saver.

Change into the directory where your secondary forum is. Create a shell script and paste these contents into it: (obviously change /backup2/mysql/msusenet/ to the location of your main DB)

rm -f administrator.*
rm -f pm.*
rm -f pmreceipt.*
rm -f pmtext.*
rm -f pmthrottle.*
rm -f user.*
rm -f useractivation.*
rm -f userban.*
rm -f userchangelog.*
rm -f userfield.*
rm -f usergroup.*
rm -f usergroupleader.*
rm -f usergrouprequest.*
rm -f userlist.*
rm -f usernote.*
rm -f userpromotion.*
rm -f usertextfield.*
rm -f usertitle.*

Now that we have done the removing of the files we need to make symbolic links.

ln -s /backup2/mysql/msusenet/administrator.frm administrator.frm
ln -s /backup2/mysql/msusenet/administrator.MYD administrator.MYD
ln -s /backup2/mysql/msusenet/administrator.MYI administrator.MYI
ln -s /backup2/mysql/msusenet/pm.frm pm.frm
ln -s /backup2/mysql/msusenet/pm.MYD pm.MYD
ln -s /backup2/mysql/msusenet/pm.MYI pm.MYI
ln -s /backup2/mysql/msusenet/pmreceipt.frm pmreceipt.frm
ln -s /backup2/mysql/msusenet/pmreceipt.MYD pmreceipt.MYD
ln -s /backup2/mysql/msusenet/pmreceipt.MYI pmreceipt.MYI
ln -s /backup2/mysql/msusenet/pmtext.frm pmtext.frm
ln -s /backup2/mysql/msusenet/pmtext.MYD pmtext.MYD
ln -s /backup2/mysql/msusenet/pmtext.MYI pmtext.MYI
ln -s /backup2/mysql/msusenet/pmthrottle.frm pmthrottle.frm
ln -s /backup2/mysql/msusenet/pmthrottle.MYD pmthrottle.MYD
ln -s /backup2/mysql/msusenet/pmthrottle.MYI pmthrottle.MYI
ln -s /backup2/mysql/msusenet/user.frm user.frm
ln -s /backup2/mysql/msusenet/user.MYD user.MYD
ln -s /backup2/mysql/msusenet/user.MYI user.MYI
ln -s /backup2/mysql/msusenet/useractivation.frm useractivation.frm
ln -s /backup2/mysql/msusenet/useractivation.MYD useractivation.MYD
ln -s /backup2/mysql/msusenet/useractivation.MYI useractivation.MYI
ln -s /backup2/mysql/msusenet/userban.frm userban.frm
ln -s /backup2/mysql/msusenet/userban.MYD userban.MYD
ln -s /backup2/mysql/msusenet/userban.MYI userban.MYI
ln -s /backup2/mysql/msusenet/userchangelog.frm userchangelog.frm
ln -s /backup2/mysql/msusenet/userchangelog.MYD userchangelog.MYD
ln -s /backup2/mysql/msusenet/userchangelog.MYI userchangelog.MYI
ln -s /backup2/mysql/msusenet/userfield.frm userfield.frm
ln -s /backup2/mysql/msusenet/userfield.MYD userfield.MYD
ln -s /backup2/mysql/msusenet/userfield.MYI userfield.MYI
ln -s /backup2/mysql/msusenet/usergroup.frm usergroup.frm
ln -s /backup2/mysql/msusenet/usergroup.MYD usergroup.MYD
ln -s /backup2/mysql/msusenet/usergroup.MYI usergroup.MYI
ln -s /backup2/mysql/msusenet/usergroupleader.frm usergroupleader.frm
ln -s /backup2/mysql/msusenet/usergroupleader.MYD usergroupleader.MYD
ln -s /backup2/mysql/msusenet/usergroupleader.MYI usergroupleader.MYI
ln -s /backup2/mysql/msusenet/usergrouprequest.frm usergrouprequest.frm
ln -s /backup2/mysql/msusenet/usergrouprequest.MYD usergrouprequest.MYD
ln -s /backup2/mysql/msusenet/usergrouprequest.MYI usergrouprequest.MYI
ln -s /backup2/mysql/msusenet/userlist.frm userlist.frm
ln -s /backup2/mysql/msusenet/userlist.MYD userlist.MYD
ln -s /backup2/mysql/msusenet/userlist.MYI userlist.MYI
ln -s /backup2/mysql/msusenet/usernote.frm usernote.frm
ln -s /backup2/mysql/msusenet/usernote.MYD usernote.MYD
ln -s /backup2/mysql/msusenet/usernote.MYI usernote.MYI
ln -s /backup2/mysql/msusenet/userpromotion.frm userpromotion.frm
ln -s /backup2/mysql/msusenet/userpromotion.MYD userpromotion.MYD
ln -s /backup2/mysql/msusenet/userpromotion.MYI userpromotion.MYI
ln -s /backup2/mysql/msusenet/usertextfield.frm usertextfield.frm
ln -s /backup2/mysql/msusenet/usertextfield.MYD usertextfield.MYD
ln -s /backup2/mysql/msusenet/usertextfield.MYI usertextfield.MYI
ln -s /backup2/mysql/msusenet/usertitle.frm usertitle.frm
ln -s /backup2/mysql/msusenet/usertitle.MYD usertitle.MYD
ln -s /backup2/mysql/msusenet/usertitle.MYI usertitle.MYI
Reply With Quote
  #2  
Old 11-27-2010, 07:10 PM
we_are_borg we_are_borg is offline
 
Join Date: Jul 2004
Posts: 108
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Reserved for expansion.
Reply With Quote
  #3  
Old 11-27-2010, 07:38 PM
TheRageIsOn TheRageIsOn is offline
 
Join Date: Mar 2010
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I have done a different approach!

I use a mix from views and 1 codemodification to
replace the tables i want to have shared to the main table !

works for me

I would never tamper with the db's very own structure.
Reply With Quote
  #4  
Old 11-29-2010, 03:51 PM
we_are_borg we_are_borg is offline
 
Join Date: Jul 2004
Posts: 108
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by TheRageIsOn View Post
I have done a different approach!

I use a mix from views and 1 codemodification to
replace the tables i want to have shared to the main table !

works for me

I would never tamper with the db's very own structure.
Well its more of a cheat because you redirect parts of the database and this system you can only use when setting up new sites to do this on an existing database it takes long preparation to do so
Reply With Quote
  #5  
Old 12-01-2010, 02:34 PM
Carnage Carnage is offline
 
Join Date: Jan 2005
Location: uk
Posts: 760
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
This may go horrifically wrong if you ever upgrade your mysql.

You are FAR FAR safer using views.
Reply With Quote
  #6  
Old 12-01-2010, 03:06 PM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
why not just run this mod?
https://vborg.vbsupport.ru/showthread.php?t=254197
Reply With Quote
  #7  
Old 12-03-2010, 04:53 AM
abdobasha2004's Avatar
abdobasha2004 abdobasha2004 is offline
 
Join Date: Aug 2008
Posts: 541
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
wow!
thought it would be much easier
Reply With Quote
  #8  
Old 07-22-2011, 05:19 AM
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
Location: Netherlands
Posts: 3,537
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Brandon Sheley View Post
Because Google sees that as duplicate content. Its really a great mod, but its far from complete. It needs more development.
Reply With Quote
  #9  
Old 11-01-2012, 08:01 PM
Dorgham's Avatar
Dorgham Dorgham is offline
 
Join Date: May 2012
Location: Egypt
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Needs a lot of effort
But he did a great job all standards
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 10:34 AM.

Contact Us - Archive - Top

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.06573 seconds
  • Memory Usage 2,287KB
  • Queries Executed 24 (?)
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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_article
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (2)post_thanks_box_bit
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (9)postbit_onlinestatus
  • (9)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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • 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