Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons

Reply
 
Thread Tools
Multiple Forums using a single user table Details »»
Multiple Forums using a single user table
Version: 1.00, by e2s e2s is offline
Developer Last Online: Mar 2009 Show Printable Version Email this Page

Version: 3.5.4 Rating:
Released: 06-12-2006 Last Update: Never Installs: 48
 
No support by the author.

This was originaly done in 3.0.9 by westpointer you can view that thread here

This Modification is for VB3.5.4 This is not supported but I will give as much help as I possible can.

I have this working now on 2 sites

The main site is http://forums.everything2stroke.com

Slave sites are
http://forums.everythingmx.com
and
http://forums.everythingduners.com

After a successfull install of this modification your sites will share User, PM, and sesson data.

This thread will detail how to have a single login for multiple forums. It makes the following assumptions:
  • A valid vbulletin license exists for each install
  • All forums will be on the same server
  • One database will contain all the tables
A valid vbulletin license exists for each install


Follow these steps

1.) Download your new copy of VB that contains a seperate license key
2.) Go to /includes/config.php.new rename the file to config.php and make necessary changes to the file. See VB Directions. Make sure this code has a different setting than the master site for table prefix.

PHP Code:
 //          ****** TABLE PREFIX ******
 //          Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = ''
3.) Run the vb install from the new directory (/www/new_forums/install/install.php)

4.) During the install, be sure NOT to empty the tables. If you have any doubt about what this means, stop NOW! If you empty the tables, you will lose all of your existing data from a prior install!

5.) Download all files and directories to your PC from the new install location.

6.) You will need a tool to do a mass Search and replace on all files. I use WildEdit. Here is what you will do using a tool like Wild Edit.
  • Search for [" . TABLE_PREFIX . "user] Replace with [" . "vb3_user] where "vb3_" is the prefix to your master site. 110 Files modified 599 Total changes made
  • Search for [" . TABLE_PREFIX . "strikes] Replace with [" . "vb3_strikes] where "vb3_" is the prefix to your master site 4 Files modified 8 Total changes made
  • Search for [" . TABLE_PREFIX . "pm] Replace with [" . "vb3_pm] where "vb3_" is the prefix to your master site 16 Files modified 77 Total changes made
  • Search for [" . TABLE_PREFIX . "session] Replace with [" . "vb3_session] where "vb3_" is the prefix to your master site 20 Files modified 31 Total changes made

Now to modify some of the code.

In /include/class_dm.php

Search for:
PHP Code:
 function fetch_insert_sql($tableprefix$table)

            { 
Add below change vb3_ to your master site prefix:
PHP Code:
if ($table == "vb3_pmtext")

            {

                        
$sql "INSERT INTO {$table}\r\n\t(" implode(', 'array_keys($this->$table)) . 


")\r\nVALUES\r\n\t(";

            

            }

            else 

Go to /include/class_dm_pm.php

Search for:
PHP Code:
var $table 'pmtext'
Replace with making vb3_ the prefix to your master site:
PHP Code:
var $table 'vb3_pmtext'

Search for:
PHP Code:
$pmtextid = ($this->existing['pmtextid'] ? $this->existing['pmtextid'] : $this->pmtext['pmtextid']); 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
$pmtextid = ($this->existing['pmtextid'] ? $this->existing['pmtextid'] : $this->vb3_pmtext['pmtextid']); 
Search for:
PHP Code:
$this->dbobject->query_write("INSERT INTO " TABLE_PREFIX "pm (pmtextid, userid) VALUES ($pmtextid$user[userid])"); 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
$this->dbobject->query_write("INSERT INTO " "vb3_pm (pmtextid, userid) VALUES ($pmtextid$user[userid])"); 
Search for:
PHP Code:
" . $this->dbobject->escape_string($user['username']) . "', '" . $this->dbobject->escape_string($this->pmtext['title']) . 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
" . $this->dbobject->escape_string($user['username']) . "', '" . $this->dbobject->escape_string($this->vb3_pmtext['title']) . 

Go to /include/class_dm_user.php

Search for:
PHP Code:
$return $this->db_update(TABLE_PREFIX'user'$this->condition$doquery$delayed); 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
$return $this->db_update('vb3_''user'$this->condition$doquery$delayed); 
Search for:
PHP Code:
$this->db_update(TABLE_PREFIX'userfield',     $this->condition$doquery$delayed); 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
$this->db_update('vb3_''userfield',     $this->condition$doquery$delayed); 
Search for:
PHP Code:
$this->db_update(TABLE_PREFIX'usertextfield'$this->condition$doquery$delayed); 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
$this->db_update('vb3_''usertextfield'$this->condition$doquery$delayed); 
Search for:
PHP Code:
if ($return $this->db_insert(TABLE_PREFIX'user'$doquery)) 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
if ($return $this->db_insert('vb3_''user'$doquery)) 
Search for:
PHP Code:
$this->db_insert(TABLE_PREFIX'userfield',     $doquery); 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
$this->db_insert('vb3_''userfield',     $doquery); 
Search for:
PHP Code:
$this->db_insert(TABLE_PREFIX'usertextfield'$doquery); 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
$this->db_insert('vb3_''usertextfield'$doquery); 
Search for:
PHP Code:
DELETE FROM " . TABLE_PREFIX . "session 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
DELETE FROM ?.?vb3_session 
Search for:
PHP Code:
INSERT INTO " . TABLE_PREFIX . "passwordhistory (useridpasswordpassworddate
Replace with where vb3_ is the prefix to your master site:
PHP Code:
INSERT INTO " . "vb3_passwordhistory (useridpasswordpassworddate
Search for:
PHP Code:
 UPDATE " . TABLE_PREFIX . "session SET 
Replace with where vb3_ is the prefix to your master site:
PHP Code:
   UPDATE ?.?vb3_session SET 

That is all the code modification.


The only other item I did is remove a couple cron jobs.

Go into Scheduled tasks then to Scheduled Task Manager

Delete the following CRON jobs from the Slave Site

User Promotions*
Birthdays
Activation Reminder Email

This will eliminate members getting emails from the primary and secondary sites
*not sure if this will duplicate efforts between primary and secondary sites I have it running on both sites still waiting to see if it causes any issues.


Please post here if you have any problems and questions I will try my best to keep up with everyone to help you through this. Once you get the code done the first time you can just do a mass search and replace on your license code and you can be up and running in minutes with a new site.

This is my first major modification so I hope I posted this all correct, again Thanks to Westpointer for his original work without his post this would not have been possible.

Thanks

UPDATE:

Please make this changes it will allow you to make changes to usergroups in the subscription section and when editing a user.

admincp/adminfunctions.php
Search for
PHP Code:
                $result $vbulletin->db->query_read("SELECT title, $tableid FROM " TABLE_PREFIX "$tablename $wherecondition ORDER BY title"); 
Replace with
PHP Code:
if ($tablename == "usergroup")
                {
                
$result $vbulletin->db->query_read("SELECT title, $tableid FROM " "vb3_$tablename $wherecondition ORDER BY title");
                }
                else
                {
                
$result $vbulletin->db->query_read("SELECT title, $tableid FROM " TABLE_PREFIX "$tablename $wherecondition ORDER BY title");
                } 

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #92  
Old 03-12-2007, 08:04 PM
pedro-hofmann pedro-hofmann is offline
 
Join Date: Mar 2007
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hey guys... this sounds awesome

this is really too tricky for me -

can you help for install this tool onto my server ?
Need payed for ?

Let me know asap how we can proceed to get it on.

mail to this email adress plz

mail@visual-act.com

got 2 databases on same server
using php 4.1.1
mySQl database and vbulletin 3.6.5

brandnew installation, but on one of them already imported users and threads

thanks in advance
Reply With Quote
  #93  
Old 03-19-2007, 03:18 PM
feldon23's Avatar
feldon23 feldon23 is offline
 
Join Date: Oct 2001
Posts: 124
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well since a version that works with 3.6.x has not been released, it's going to be pretty tough to get to install it.

And yes I think someone is going to charge you money to make almost 700 code changes to each copy of vB.
Reply With Quote
  #94  
Old 03-20-2007, 03:37 PM
pedro-hofmann pedro-hofmann is offline
 
Join Date: Mar 2007
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks in advance

we are in contact with the support now
they will tell us what we shall do very soon

we keep u posted
Reply With Quote
  #95  
Old 04-25-2007, 12:59 AM
Shelby Shelby is offline
 
Join Date: Nov 2005
Posts: 67
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I sure wish this was an official product.
Reply With Quote
  #96  
Old 04-27-2007, 11:26 PM
Rebecca217 Rebecca217 is offline
 
Join Date: May 2002
Posts: 84
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Any plans to make this work with 3.6?
Reply With Quote
  #97  
Old 04-28-2007, 01:21 PM
Sir_Yaro's Avatar
Sir_Yaro Sir_Yaro is offline
 
Join Date: Jun 2004
Location: Ireland
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Rebecca217 View Post
Any plans to make this work with 3.6?
it does.
Reply With Quote
  #98  
Old 04-28-2007, 08:11 PM
Rebecca217 Rebecca217 is offline
 
Join Date: May 2002
Posts: 84
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Sir_Yaro View Post
it does.
Excellent. Thank you!
Reply With Quote
  #99  
Old 05-17-2007, 11:42 PM
Lord Kirken Mor's Avatar
Lord Kirken Mor Lord Kirken Mor is offline
 
Join Date: Nov 2006
Location: Gj?vik, Norway
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

worls with 3.6.6 & 3.6.7 aswell?
Reply With Quote
  #100  
Old 05-18-2007, 02:33 AM
Lord Kirken Mor's Avatar
Lord Kirken Mor Lord Kirken Mor is offline
 
Join Date: Nov 2006
Location: Gj?vik, Norway
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the main site doesnt have a table prefix, how do i make it have one?
Reply With Quote
  #101  
Old 05-25-2007, 02:21 AM
FreshPrince FreshPrince is offline
 
Join Date: Oct 2006
Posts: 108
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi, this is a really interesting mod. How many items of code do I have to replace, someone said 600? Can I hire someone to do this? Anyone willing? Please PM me.

Also, the current bandwidth usage right now is about 1%. If I used this forum and connected it to another forum with 50 active posters on it, how much do you think my bandwidth usage would go up? Thank you.


FP
Reply With Quote
Reply

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

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 06:46 AM.


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.05287 seconds
  • Memory Usage 2,376KB
  • Queries Executed 25 (?)
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
  • (31)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete