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
  #32  
Old 07-01-2006, 11:27 PM
HuangA's Avatar
HuangA HuangA is offline
 
Join Date: Jun 2004
Posts: 102
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by e2s
I don't recall any supposed feature for 3.5. I know they have teh Master and Slave Database but I really don't know that much about it.
Was a hidden thing, look at public beta1's phrase tables
Reply With Quote
  #33  
Old 07-04-2006, 09:44 PM
bonjurkes bonjurkes is offline
 
Join Date: Nov 2005
Posts: 127
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i have a second question

i have 2 boards at different subdomains at same domain

I moved some of the threads from board 1 to board 2

and now i have a problem like that

My user has 6k messages, after the move at first board it shows his message count as 4k and it shows same number at second board as 4k

mustnt it show it like 2k or is it happening because they are sharing the same user table?
Reply With Quote
  #34  
Old 07-05-2006, 03:34 PM
e2s e2s is offline
 
Join Date: Nov 2004
Location: NH
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The total posts of a user is stored in the user table so the amount of posts he has will be for both sites. This modification does not have a way to change it so it shows different post counts for each site.
Reply With Quote
  #35  
Old 07-05-2006, 06:10 PM
utw-Mephisto utw-Mephisto is offline
 
Join Date: Jan 2005
Posts: 648
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default



Quote:
Originally Posted by utw-Mephisto
What about the file edits when I don't use a prefix on the master , like




Since I don't use prefixes for the master, would I change it to :

Code:
$this->db_insert('.', 'usertextfield', $doquery);
???

Also :


But once again, my master does not have a prefix ... would I have to change it to

Code:
change to : var $table = '._pmtext';
Reply With Quote
  #36  
Old 07-16-2006, 02:30 PM
MikeTrin MikeTrin is offline
 
Join Date: Jun 2006
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Any advice for someone merging users on 2 existing vb message boards?
Reply With Quote
  #37  
Old 07-19-2006, 03:26 PM
e2s e2s is offline
 
Join Date: Nov 2004
Location: NH
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes on number one

question 2 would be pmtext no _
Reply With Quote
  #38  
Old 07-19-2006, 03:27 PM
e2s e2s is offline
 
Join Date: Nov 2004
Location: NH
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MikeTrin
Any advice for someone merging users on 2 existing vb message boards?
Sorry I didn't have that situation with my sites I started all new sites. Might be able to work with the usertables in access and get once site to append to the other site. Not really sure
Reply With Quote
  #39  
Old 07-21-2006, 07:43 PM
jstep jstep is offline
 
Join Date: Jan 2006
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What other options are there to wildedit?

also is prefix like your username in cpanel, you know database name is

username_sportsconvo

or is it sportsconvo

Thanks

Jstep
Reply With Quote
  #40  
Old 07-21-2006, 08:12 PM
bonjurkes bonjurkes is offline
 
Join Date: Nov 2005
Posts: 127
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by jstep
What other options are there to wildedit?

also is prefix like your username in cpanel, you know database name is

username_sportsconvo

or is it sportsconvo

Thanks

Jstep
no, it is the vb prefix that you set at your config.php
Reply With Quote
  #41  
Old 07-22-2006, 08:35 AM
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Location: Australia
Posts: 2,469
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have just bought a second vbulletin, I will buy a third if this will work.

I have three different domains all on the same server. www.a.com - Main site
www.b.com and www.c.com

I want to have the main sites data with User, PM, and sesson data. to be shared with the other 2 sites.

Now if a new user signs up on www.b.com will that users info be inserted into the database for www.a.com ?

I'm just not sure on one other thing as well. Is it possible to lock out the config.php from being read except for the sever and myself when i log into ftp, because I run www.a.com and my friend runs www.b.com and I dont want him to know the user and pass to the mysql database and to have access to the database at all, as if I was to lose it, that would be seriously bad lol.

Just wondering on the security wise of this issue, thanks.
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 03:05 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.04938 seconds
  • Memory Usage 2,385KB
  • 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
  • (2)bbcode_code
  • (31)bbcode_php
  • (4)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
  • (1)pagenav_pagelinkrel
  • (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