Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Shared user database for multiple forums, same server Details »
Shared user database for multiple forums, same server
Mod Version: 1.00, by CyberRanger (Member) CyberRanger is offline
Developer Last Online: Jan 2015 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.0.9 Rating: (0 vote - 0 average) Installs: 15
Released: 12 Oct 2005 Last Update: Never Downloads: 1
Not Supported Code Changes  

For version 3.5x+, please see http://www.vbulletin.org/forum/showthread.php?t=118473

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
  • You already have one forum operational AND that forum uses a BLANK $tableprefix!
  • One database will contain all the tables
This thread is a follow-up from this discussion over at vbulletin.com. Thanks to Brains for some pointers!

Here are the steps:
  1. Copy your forum directories to a parallel directory (for example copy /www/forums to /www/new_forums)
  2. In /includes/config.php, change $tableprefix (line 91) to a new prefix [for example $tableprefix = 'new_';]
  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 the files from these directories to your PC: /new_forums, /new_forums/admincp, /new_forums/archive, /new_forums/includes, /new_forums/modcp, /new_forums/subscriptions
  6. We are now going to make global changes to the files in the folders (and subfolders) above. I used Dreamweaver's "edit-find and replace" function with "find in" set to "Entire Current Local Site". We are basically going to remove the "TABLE_PREFIX" from any code dealing with the user. (Note - if you are comfortable with unix command, you could do these changes from the command line on the server.)
  7. Run the following find and replace operations:
    • Find [" . TABLE_PREFIX . "user] (find what's inside the brackets). Replace with [“.”user] This should find 562 instances of user, usergroup, userfield, and usertextfield
    • Find [" . TABLE_PREFIX . "strikes] (find what's inside the brackets). Replace with [“.”strikes] This should find 5 instances of strikes
    • Find [" . TABLE_PREFIX . "pm] (find what's inside the brackets). Replace with [“.”pm] This should find 61 instances of pm, pmtext, pmtextid, and pmreceipt.
    • Upload these directories back to the server.
  8. We now need to do a little fine tuning
    • In /includes/functions.php: on line 1171 remove the table_prefix before $idname.
    • In /includes/adminfunctions: modify print_choser_row (line 1161)to check for $tableid of user, usergroups


      Block Disabled:      (Update License Status)  
      Suspended or Unlicensed Members Cannot View Code.

    • In /includes/adminfunctions_user.php around line 116 (construct_style_chooser)


      Block Disabled:      (Update License Status)  
      Suspended or Unlicensed Members Cannot View Code.


Done! Both forums are now accessed by the same user table! PM's are unified across forums as is the user count.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #31  
Old 31 Oct 2005, 10:45
CyberRanger's Avatar
CyberRanger CyberRanger is offline
 
Join Date: Mar 2004
Originally Posted by hugojr
here is the error I am getting

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

what does this mean?
It looks like maybe you've created a a double-double quote in that sql statement. Something that looks like
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

I'll try to locate the exact spot where this sql is coded later today but if you can search in for "birthday" in the php files under includes.
Reply With Quote
  #32  
Old 01 Nov 2005, 01:31
hugojr hugojr is offline
 
Join Date: Oct 2005
Originally Posted by westpointer
It looks like maybe you've created a a double-double quote in that sql statement. Something that looks like
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

I'll try to locate the exact spot where this sql is coded later today but if you can search in for "birthday" in the php files under includes.
I have look everywhere can't find nothing wrong, just incase I am using version 3.0.9

Please if you can clear up your explanation of #8 a little better..

Thank You..
Reply With Quote
  #33  
Old 01 Nov 2005, 01:35
hugojr hugojr is offline
 
Join Date: Oct 2005
Question

In /includes/functions.php: on line 1171 remove the table_prefix before $idname.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

this is what it look like after according to your explination


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

is that correct?
Reply With Quote
  #34  
Old 01 Nov 2005, 01:44
hugojr hugojr is offline
 
Join Date: Oct 2005
Question

also In /includes/adminfunctions: modify print_choser_row (line 1161)to check for $tableid of user, usergroups

line 1161 before code change
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

now what I want to know is where do I add your code before or after

also In /includes/adminfunctions_user.php around line 116 (construct_style_chooser)

line 116 before code change
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

is the code you are giving before or after the code that is there
Reply With Quote
  #35  
Old 01 Nov 2005, 03:35
CyberRanger's Avatar
CyberRanger CyberRanger is offline
 
Join Date: Mar 2004
Originally Posted by hugojr
here is the error I am getting

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

what does this mean?
Can you post what you have in includes/functions_databuild.php from line 840 to 846? It should look like this (assuming you've replaced " . TABLE_PREFIX . " with "."

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

What do you have there?
Reply With Quote
  #36  
Old 01 Nov 2005, 03:54
CyberRanger's Avatar
CyberRanger CyberRanger is offline
 
Join Date: Mar 2004
Originally Posted by hugojr
In /includes/functions.php: on line 1171 remove the table_prefix before $idname.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

this is what it look like after according to your explination


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

is that correct?
Correct, you may want to do a "." just to help you find it in the future. To be honest, I don't know for sure what else is used by this query. This may need to be wrapped in an if statement instead. Can anyone else verify if this is only used for user type queries?
Reply With Quote
  #37  
Old 01 Nov 2005, 04:24
hugojr hugojr is offline
 
Join Date: Oct 2005
Originally Posted by westpointer
Can you post what you have in includes/functions_databuild.php from line 840 to 846? It should look like this (assuming you've replaced " . TABLE_PREFIX . " with "."

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

What do you have there?
this is what I have from line 840 to 846

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #38  
Old 01 Nov 2005, 18:04
CyberRanger's Avatar
CyberRanger CyberRanger is offline
 
Join Date: Mar 2004
Originally Posted by hugojr
this is what I have from line 840 to 846
Could you post the URL of the problem page?
Reply With Quote
  #39  
Old 02 Nov 2005, 08:56
hugojr hugojr is offline
 
Join Date: Oct 2005
Originally Posted by westpointer
Could you post the URL of the problem page?
Please check your pm's

Thank You
Reply With Quote
  #40  
Old 02 Nov 2005, 18:52
hugojr hugojr is offline
 
Join Date: Oct 2005
Question Need Help

Is there anyone else that has installed this hack that can help us out we are willing to pay $$$$ please pm us if you are intrested...
Reply With Quote
  #41  
Old 03 Nov 2005, 02:16
CyberRanger's Avatar
CyberRanger CyberRanger is offline
 
Join Date: Mar 2004
Originally Posted by hugojr
Please check your pm's

Thank You
Checked! PM back to you.
Reply With Quote
  #42  
Old 10 Nov 2005, 23:22
DieselDesigns DieselDesigns is offline
 
Join Date: Nov 2005
shared users

I am very new to vbulleting and i don't know anything about php. but i would like to setup a 2 message boards and give same users access. can anyone help me?
Reply With Quote
  #43  
Old 12 Nov 2005, 16:17
DieselDesigns DieselDesigns is offline
 
Join Date: Nov 2005
shared users

hugojr or westpointer

PLEASE help
Reply With Quote
  #44  
Old 13 Nov 2005, 21:45
DieselDesigns DieselDesigns is offline
 
Join Date: Nov 2005
Arrow

Can anyone please help out a newbie please come on what does it take some money that is ok by me. As you can tell I do not know nothing about php nor vbulletin so please help me.
Reply With Quote
  #45  
Old 26 Nov 2005, 17:48
hugojr hugojr is offline
 
Join Date: Oct 2005
Originally Posted by DieselDesigns
Can anyone please help out a newbie please come on what does it take some money that is ok by me. As you can tell I do not know nothing about php nor vbulletin so please help me.
OK I have done everthing but I am getting an error in the admincp now everytime I go to search for users I get this error

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

what does this mean? here is what line 1156 looks like

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

please someone please help me..
Attached Images
File Type: gif error.gif (5.4 KB, 19 views)

Last edited by hugojr; 26 Nov 2005 at 18:05.
Reply With Quote
Reply


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

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


New To Site? Need Help?

All times are GMT. The time now is 04:25.

Layout Options | Width: Wide Color: