Multiple Forums using a single user table

[e2s]

This was originaly done in 3.0.9 by westpointer you can view that thread here (https://vborg.vbsupport.ru/showthread.php?t=98233&page=6)

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.


// ****** 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:
function fetch_insert_sql($tableprefix, $table)

{


Add below change vb3_ to your master site prefix:
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:
var $table = 'pmtext';

Replace with making vb3_ the prefix to your master site:
var $table = 'vb3_pmtext';


Search for:
$pmtextid = ($this->existing['pmtextid'] ? $this->existing['pmtextid'] : $this->pmtext['pmtextid']);

Replace with where vb3_ is the prefix to your master site:
$pmtextid = ($this->existing['pmtextid'] ? $this->existing['pmtextid'] : $this->vb3_pmtext['pmtextid']);

Search for:
$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:
$this->dbobject->query_write("INSERT INTO " . "vb3_pm (pmtextid, userid) VALUES ($pmtextid, $user[userid])");

Search for:
" . $this->dbobject->escape_string($user['username']) . "', '" . $this->dbobject->escape_string($this->pmtext['title']) .

Replace with where vb3_ is the prefix to your master site:
" . $this->dbobject->escape_string($user['username']) . "', '" . $this->dbobject->escape_string($this->vb3_pmtext['title']) .


Go to /include/class_dm_user.php

Search for:
$return = $this->db_update(TABLE_PREFIX, 'user', $this->condition, $doquery, $delayed);

Replace with where vb3_ is the prefix to your master site:
$return = $this->db_update('vb3_', 'user', $this->condition, $doquery, $delayed);

Search for:
$this->db_update(TABLE_PREFIX, 'userfield', $this->condition, $doquery, $delayed);

Replace with where vb3_ is the prefix to your master site:
$this->db_update('vb3_', 'userfield', $this->condition, $doquery, $delayed);

Search for:
$this->db_update(TABLE_PREFIX, 'usertextfield', $this->condition, $doquery, $delayed);

Replace with where vb3_ is the prefix to your master site:
$this->db_update('vb3_', 'usertextfield', $this->condition, $doquery, $delayed);


Search for:
if ($return = $this->db_insert(TABLE_PREFIX, 'user', $doquery))


Replace with where vb3_ is the prefix to your master site:
if ($return = $this->db_insert('vb3_', 'user', $doquery))

Search for:
$this->db_insert(TABLE_PREFIX, 'userfield', $doquery);

Replace with where vb3_ is the prefix to your master site:
$this->db_insert('vb3_', 'userfield', $doquery);


Search for:
$this->db_insert(TABLE_PREFIX, 'usertextfield', $doquery);


Replace with where vb3_ is the prefix to your master site:
$this->db_insert('vb3_', 'usertextfield', $doquery);

Search for:
DELETE FROM " . TABLE_PREFIX . "session

Replace with where vb3_ is the prefix to your master site:
DELETE FROM ?.?vb3_session

Search for:
INSERT INTO " . TABLE_PREFIX . "passwordhistory (userid, password, passworddate)


Replace with where vb3_ is the prefix to your master site:
INSERT INTO " . "vb3_passwordhistory (userid, password, passworddate)


Search for:
UPDATE " . TABLE_PREFIX . "session SET


Replace with where vb3_ is the prefix to your master site:
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

$result = $vbulletin->db->query_read("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title");


Replace with

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");
}

[Ntfu2]

awesome, i will definetly be trying this out.

What if i have my sites on two different hard drives, but the same server. And MySQL for each is on the same disk as well.

[e2s]

If I understand correct you just have 2 hard drives in your server and the sites happen to be on opposite hard drives. As long as you are only running 1 MySql for both sites you shouldn't have any issues. The path to your install is in the Config.php this Modification is just changing were a second site looks for User, PM, and session data.

Now I have not done this with 2 existing forums. I have only created a new forum to attach to my existing forum. You could still do it with 2 existing forums but it would take a little more effort since you would have to merge your userdatabase and some PM's would be lost unless you could merge those as well. I have no experiance in doing this so I am not sure I could be of much help

[e2s]

Oh just for the record I have successfully made vBadvanced CMPS work on the slave site. There is just a few modification you need to make to the modules. If you are looking to do this PM me.

www.everythingmx.com (http://www.everythingmx.com)

I hope to intergrate other products soon like Photopost but not sure when I will get to it.

[Ntfu2]

awesome :)

im going to give it a shot with two existing forms and see how it goes

[e2s]

Just be sure you do a backup of your databse

[RMS-Chef]

How are paid subscriptions effected by this if at all?
If they buy a subscription on the slave site, does it effect anything on the existing main site?

[lovevn]

Hi
You are using your forums on different domains but I want to use it as the fllowing ways:

Master forum : mydomain.com/forum
Slave forum:forum/mydomain.com

Is it possible?

Thanks

[Steve F]

This must be one of the most sought after hacks, great work e2s, thank you for sharing with us and thanks Westpointer for the original idea :)!

lovevn: I am sure it would work

[e2s]

Hi
You are using your forums on different domains but I want to use it as the fllowing ways:

Master forum : mydomain.com/forum
Slave forum:forum/mydomain.com

Is it possible?

Thanks

If I understand correctly your just looking to point a subdomain forum to your forum directory. That can be done in your server config without even touching the code

[e2s]

How are paid subscriptions effected by this if at all?
If they buy a subscription on the slave site, does it effect anything on the existing main site?

That is a great question but I don't have the answer. I know in the current setup all the usergroups are used by the slave sites so if a member is a paid member in the master site they will also be a paid member in the slave.

I will look into what it will take to get the subscription to work on the slave sites.

[e2s]

This must be one of the most sought after hacks, great work e2s, thank you for sharing with us and thanks Westpointer for the original idea :)!

lovevn: I am sure it would work

Thanks Steve, hopefully it will help some people out.

[TheComputerGuy]

awesome hack e2s!

[e2s]

How are paid subscriptions effected by this if at all?
If they buy a subscription on the slave site, does it effect anything on the existing main site?

Looks like this can be taken care of real easy I am going to try this today and if all works well i will post up the instructions. It should just be a mass Search and replace on table subscriptions and subscriptionlog


Thanks ComputerGuy

[utw-Mephisto]

I have no experiance in doing this so I am not sure I could be of much help

Can't you use Impex ? just wondering .

[lovevn]

Thanks for your reply @e2s

BTW I have one question:

Search for [" . TABLE_PREFIX . "user] Replace with [" . "vb3_user] where "vb3_" is the prefix to your master site. 110 Files modified

If in my master site I do not user prefix so which one is correct?

1. [" . "_user]

2. [" . "user]

Thanks

[e2s]

Number 2 if you have nothing for a prefix.

[Snake]

Great idea!

[e2s]

Ok I have the paid subscriptions working but it is not perfect and kind of wierd how you have to go about getting it to work on the slave sites.

Here are the directions

1.) Search for [" . TABLE_PREFIX . "payment] Replace with [" . "vb3_payment] where "vb3_" is the prefix to your master site. 16 Files modified 36 Total Changes

2.) Search for [" . TABLE_PREFIX . "subscription] Replace with [" . "vb3_subscription] where "vb3_" is the prefix to your master site. 20 Files modified 68 Total Changes

IMPORTANT: This next change is needed regardless if you want to manage users from the slave site Admin console. This will make the Primary Usergroup list correct when editing a user or setting up a new subscription.

admincp/adminfunctions.php
Search for

$result = $vbulletin->db->query_read("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title");


Replace with

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");
}

Now to get Subscriptions to appear on your slave site you have to log into the slave site Admin console and create a dummy subscription which seems to activate paid subscriptions. The subscriptions from your Master site will be the only options your members will have however. You must create and edit your subscriptions from the Master site only.

I looked at the code for a long time and just don't understand enough of it to find out what it works the way it does. However I have tested the paid subscription and everything works perfect.

[futuredood]

if i were to click "find more posts by user a", would it be able to come up with threads and posts by that user in both forums? that way, i can follow "user a" between both forums?

i was searching for a hack that this one kind of fulfills.. https://vborg.vbsupport.ru/showthread.php?t=119107

[e2s]

Posts and Threads are seperate between sites only User, PM, and Session data is shared between sites.

This is not to say it would not be possible. It would probably just take some modification to the search.php so that it looks that the 2 forums you want it to display.

Interesting I might look into this if I find time

[futuredood]

Posts and Threads are seperate between sites only User, PM, and Session data is shared between sites.

This is not to say it would not be possible. It would probably just take some modification to the search.php so that it looks that the 2 forums you want it to display.

Interesting I might look into this if I find time

That'd be cool, especially since their's so many user profile mods making interaction between people greater.

[HuangA]

I was drafting a similar mod before 3.5, then realized that 3.5 was suppose to have a similar feature (if I'm not mistaken), and decided to stop working on it... its too bad that the feature never made it to live...

[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.

[Milad]

$verynice

[e2s]

Thank you.

[bonjurkes]

ok, it sounds a great idea but i have questions about it

2-) will i use same database with my master board?

6-) i will use vb3_ for my slave board, and the prefix for my master board is . (default one) must i do that mass change that told at step 6 ?

[SaN-DeeP]

wonderful addon, I will have to test this before going for some live implementation :)

[thumbsucker]

Ok, so having a slave forum means that you share the same user DB.

But I assume the slave and master forums can have different discussion sections?

How would changing user groups on the slave affect the master? All changes are made essentially simultanously on both?

[utw-Mephisto]

What about the file edits when I don't use a prefix on the master , like

Replace with where vb3_ is the prefix to your master site:
$this->db_insert('vb3_', 'usertextfield', $doquery);


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

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

Also :

Go to /include/class_dm_pm.php

Search for : var $table = 'pmtext';

change to : var $table = 'vb3_pmtext';


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

change to : var $table = '._pmtext';

[HuangA]

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 ;)

[bonjurkes]

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?

[e2s]

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.

[utw-Mephisto]

http://www.ut2007world.com/images/purplesmilieset/icon_bump.gif

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 :

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

Also :


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

change to : var $table = '._pmtext';

[MikeTrin]

Any advice for someone merging users on 2 existing vb message boards?

[e2s]

Yes on number one

question 2 would be pmtext no _

[e2s]

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

[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

[bonjurkes]

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

[Hornstar]

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.

[jstep]

anyone got replacements for wildedit?

[Renmiri]

Great Mod!

I will give it a try after a good solid site backup!

[jstep]

well, without a good solution to use instead of wildedit its like $30, been looking will let you know the results

[Flare]

We have just sucessfully merged two live, active VB systems into one user database. It was a real pain in the ass, and it really is only viable in specific instances.

What we had to do, in a nutshell:

Merge site A with Site B with Impex... so now you have one big, fat, unified site. I copied the mysql database from the new mega-site B into the old Site A and deleted everything from Site B that I did not want in site A. All this was done after this hack was completed on site A.

The limitation of this is one of the sites (in this case, Site B) had no posts on Site A from the users on Site B. So all the Site A users and posts are imported into Site B, and posts are kept intact.

If you want/have to merge both sites and both sites are sharing posts/users in BOTH directions, you're screwed because of the way VB stores threads and individual posts (by user number). This method will ONLY work if one site can be imported into the other, then split from there. It's a major pain.

Anyway ... what I'd like to do now is be able to move/transfer threads between the two sites now ... I don't think there is a hack for this yet (why would there be?) ... but does anyone know if there is, and if not, what exactly is involved in transfering a thread from one site to another?

[wiredinoc]

Hi guys,

This is a very important mod, and thanks to the author. I have installed this with success, and I'm launching a new site this next week based on the ability to now have 2 forums off of one user table. I even got vbpager to work inbetween the two sites using the same table replacement strings ;)

There are a few strange gotchas though.. Here's what I found:

1. While creating new forums, I noticed the (xx users viewing) text pop up on the slave site that was password protected. It looks like VB calculates this number based on the category ID, and then the display order. In a nutshell, the primary forum's viewing numbers are incorrectly passed to the slaves. I'm not sure if this affects threads yet.

2. What happens when I want to add different profile fields, or any profile fields for that matter for new users to complete upon registration? Should I create them on the master site, then dump a table to the slave site? confused.

3. If I ever run a recount process on posts, what would the expected result be? I can't imagine good..

4. Is there a way to maintain login between the two sites (on different domains)? Right now, user needs to re-login on the seperate sites. I'm sure this is a cookie limitation, just curious.

Anyways, I'm balls in at this point, new site running, integration is killer. Thanks guys, this is absolutely awesome... any additional help is appreciated.

oh yeah, also got PP classifieds to use one DB..

[wiredinoc]

Update!

I fixed the user/viewing forums very easily. Went into the forum table, and re-numbered all of the forum ID's starting with 500, and adjusted the parent column accordingly. Now everything is working correctly, and users on the slave site appear in the forums correctly.

Lots of gotcha's here folks, but there is a TON you can do with this using the replacement strings (table_prefix). I'm now testing to see if I can get the avatars to stick in between sites.

Still looking for an answer on #2, and #3. The way things are going now, I may have a full integration of many more elements working soon.

Great mod guys!!! Stay tuned.

[Cedric_FP]

Is it possible to make it so that if a user is online on one of the slave sites, it shows on every other site connected to the same DB?

[wiredinoc]

Cedric, yes, that's how it works with this mod out of the box. If a user is on site B, it aggregates the users from both sites and they all appear in the online list.

[shortbus1662]

I haven't read this entire thread but I've been doing this on my forums for quite sometime.

The difference in what I'm doing is that everything is the same except the domain name, the style, and the templates.

The forums are all the same.

I hired someone to do mine. I have quite a few sites.

One thing, when I first did it, the vb.com guys said I had to have one license for each site now they say since everything is the same and nothing is different, one license is sufficient (now they tell me).

I'd like to figure out how to have certain forums on one domain only rather than all of them. It would be interesting to see how this differs from what was done on my site.

Sorry to hijack, just found this interesting.

[e2s]

Not a problem. This allows you to share the User tables, PM tables, subscription tables, and usergroup tables. The forums have completely different content.

Check out my sites in my signature and you will see. I am starting up 2 more sites in the coming month. Pretty easy to start new sites I just do a search and replace on the License code and it is done.

[jstep]

Anyway to do this where the forums have some of the same content? but some different content

[tako]

I wonder if someone can make this hack for 3.6....

[Karri]

wondering the same thing

[shortbus1662]

my forums all use the same content but I'm pretty sure you can just modify the templates or something so that only certain forums show up on certain domains.

[Quarterbore]

I am also looking to do something like this for a couple of my websites...

Heck, I am good for two or more purchased licenses if we can get some support to make this work for 3.6!

[e2s]

I am purchasing another license here soon and will be opening a new site. When I complete it I will let everyone know what needs to be done.

[Lionel]

can this be done with 3.07 as a master and 3.60 as the slave? Or vice versa?

[MetalAges]

Awesome hack. Couple questions:

1) Threads: 188,926, Posts: 3,959,948, Members: 62,455
Does anyone forsee any issues having a forum this big, and adding on to the database with new forums? The database as it is is huge so I'm a little nervous about adding all the new forums to it.

2) When new versions of VB are released, I assume all these changes will have to be repeated, and researched to make sure there were no code changes?

[kau]

Users would want to use different profile options sig/avatar/bio/etc at each forum it would seem. Would be nice if that would be forum specific and only user name/password/email was shared.

[Lionel]

I noticed that on your sites you don't have statistics, I was curious to know how you pulled userstats from master datastore?

[e2s]

Lionel: user stats are pulled from the master site if that is what you mean.

Kau: The avatar is different on all sites. To get the bio different you have to edit the database so that the new site pulls from higher profile id's then the master site so if your master site pulls profile id 1-10 you would want to setup profile id's for the new site starting at 20. I know I have done this but don't remember how. When I setup a new site and do this I will write up directions. The Signature is located in the user table so the only way around this would be more code changes. You would need to add fields in the database like newsitesig and so on then make changes to the code on the new site to always look at that field when pulling the signature. I might look into doing something like this soon.

Sorry still haven't purchased the 3.6 version yet hoping to in the coming week

[Lionel]

Lionel: user stats are pulled from the master site if that is what you mean.


Hi, yes they are, but the cache is updated only once a day or if I do it manually, meaning that if someone registers in one forum, the new count will not display on other forums right away.

[Lionel]

I've got every perfect but two glitches.

1-userstats update only once with cron or if i rebuild user names

2-avatars are same across (except for custom) , BUT I can't get the avatar categories to display independently. Each have their own categories and the slave site does not display the its avatarcategories in profile.php

[Lionel]

In adminfunctions.php print_delete_confirmation you also need to specify the below (insert it somewhere) or it will switch to default and you will not be able to delete any usergroups. (I don't use prefixes so I have " . ")



case 'usergroup':
$item = $vbulletin->db->query_first("
SELECT usergroupid, title
FROM " . "usergroup
WHERE usergroupid = '" . $vbulletin->db->escape_string($itemid) . "'
");
break;

also in functions.php copy function fetch_query_sql into function fetch_query_sql2 . alter that copy by replacing the 2 instances of " . TABLE_PREFIX . to reflect your master prefix.

Then in usergroup.php call that fetch_query_sql2 instead of fetch_query_sql (many instances)

Now, all that is left is the avatar category that refuses to display. I did do a search and replace for table_prefix avatar so they all have the same.

BTW, there was no problem with userstats and your mod. The problem was with vbadvanced.

[Lionel]

Phew! I finally figured out the avatars
imagecategory was out of sync

[Uebbino]

I'm reading your hack.
It's very good.
It remains a little doubt.
Is possible that each slave forum have a separated table users but in the main forum, there is a table with all users of all slave forum?

Example.

Main Forum= 10000 users

Forum Slave 1= 2000 users
Forum Slave 2= 4000 users
Forum Slave 3= 2000 users

Please, make me know

[redefined04]

2 questions..

1.) I'm assuming when you say admincp/adminfunctions.php you actually mean includes/adminfunctions.php, because adminfunctions.php does not exist in admincp.

2.) When I try to login on the admincp of the slave site, it goes to the "Thank you for logging in" redirect stage, but then it directs me right back to the admincp login form?

[Nero1977]

Sorry still haven't purchased the 3.6 version yet hoping to in the coming week
In a waiting new 3.6.1 modification. :)

2: redefined04
I think you are using vb3.6

adminfunction.php now in /includes/

[redefined04]

In a waiting new 3.6.1 modification. :)

2: redefined04
I think you are using vb3.6

adminfunction.php now in /includes/

Any idea why the /admincp/ login simply redirects to itself even though its the correct account details?

[Nero1977]

Wow! Two different boards 3.6.1 working fine!

[anahowa]

What other options are there to wildedit?



Jstep

you can use ultraedit

http://www.ultraedit.com/

[anahowa]

Oh just for the record I have successfully made vBadvanced CMPS work on the slave site. There is just a few modification you need to make to the modules. If you are looking to do this PM me.

www.everythingmx.com (http://www.everythingmx.com)

I hope to intergrate other products soon like Photopost but not sure when I will get to it.


Can you help to make vBadvanced CMPS work on the slave site?

[Aunt Clara]

I have two questions:

Is it possible to do this on two existing, active forums?
Is anyone, who has done it before, willing to work for me on this?

[MetalAges]

Anyone running this with VB 3.6.4?

I am really nervous to try this out on my forum(s). I recently installed Photopost Pro to my site, and I loved how it was able to use my existing VB user base. Couldn't VB somehow allow a similar "bridge" to the user data like Photopost?

[TRR]

If I wanted to, can I go create a newsite with slave sites, and then use Impex to import my current website in? Also, during the import, do I have to impex to each slave since I will want to divvy up my threads from my current site amongst my new master/slave sites?

[TRR]

Also, will there be a cookie conflict? should they be stored separately?

[TRR]

Is the following a change in the slave forum, or the master forum?

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 ...

[TRR]

I am getting the following database error on my slave site when I try to post a thread.

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE themothership_user SET
posts = posts + 1,
usertitle = 'Administrator',
lastpost = 1165063678,
lastpostid = 0
WHERE userid = 1;

MySQL Error : Table 'themothership.themothership_user' doesn't exist
Error Number : 1146
Date : Saturday, December 2nd 2006 @ 05:47:58 AM
Script : http://sportbikesite.com/thestreetfighter/newthread.php?do=postthread&f=2
Referrer : http://sportbikesite.com/thestreetfighter/newthread.php?do=newthread&f=2
IP Address :
Username :
Classname : vb_database


I also get errors when doing other things, like logging out. I performed all the edits as described. Is this because I am using the latest vbulletin? It looks like the table name is being written incorrectly.

[kafi]

Hello, I wish to upgrade to 3.6x, will this work for it or is there 3.6 version?

Thank you

[david_iglobal]

I also need to know if will this work with the latest edition of vBulletin... from 3.6 on? Thanks in advance.

[Fenriz]

And.. where is the answer - does it work on 3.6.4 or not?

[Hemanth]

Hi e2s ,

Can you please port it to latest vbulletin version? Thank you.

[mattcohn]

Quick question, what happens when you merge two users from the admincp, or delete a user from the admincp? From researching how to do this myself, everything blows up, correct? If you have two websites, site1 and site2, and try to merge user1 into user2 while in the admincp of site1, here is what I foresee happening:

- All of user1's posts, threads, etc on site1 correctly get changed to user2
- All of user1's info (postcount, pm count, etc) correctly gets added to user2
- User1 gets correctly deleted
- However no posts, threads, or anything on site2 get changed to reflect user2 instead of user1

Ideas, thoughts, or comments on how to overcome this short of never deleting or merging members, ever?

[fluxem]

Anyone running this with VB 3.6.4???

[futuredood]

yes, i am interested in getting this to work with 3.6.4 as well..

[FreshFroot]

anyway you could port this for 3.6.4?

[mattcohn]

All this basically does is just use a common database for every table that begins with user, strikes, pm, and session. If you want to do that, just use views. No code editing required, and much simpler. But that still doesn't take care of the situation I just posted about... it will explode if you ever try to merge or delete users.

[Pure Dope]

does it work for 10 different urls?

[Kalyse]

I just got it working with 3.6.4

www.invision-gaming.co.uk/forums and
http://forums.invisiongamers.com

It took ALOT of modding.

There was lots of broken things in there. Mainly with usergroups.

All the usergroups were messed up and I had to play around with the admin functions severaly to hack them up but Im very pleased with the mod.

Gj

[MaestroX]

Could you share the code Kalyse?

I'm would like to do this for 3.6 too :)

[pedro-hofmann]

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:D

[feldon23]

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. :)

[pedro-hofmann]

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

[Shelby]

I sure wish this was an official product.

[Rebecca217]

Any plans to make this work with 3.6?

[Sir_Yaro]

Any plans to make this work with 3.6?

it does.

[Rebecca217]

it does.

Excellent. Thank you! :)

[Lord Kirken Mor]

worls with 3.6.6 & 3.6.7 aswell?

[Lord Kirken Mor]

the main site doesnt have a table prefix, how do i make it have one?

[FreshPrince]

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

[FreshPrince]

Also, does this work on 3.6.7? Thank you again.

[Brandon Sheley]

if anyone is wanting paid help for this mod, shoot me a PM and we can work something out.
Yes, it was posted that it works on the latest vBulletin version :)

[FreshPrince]

Let me also ask something. I've heard that everytime I upgrade to a new version of V-bulletin, that I have to re-write some scripts. Is that true? Thanks

[4x4 Mecca]

Installed! Thanks!

[Lpspider]

If you have two forums user one user table like this how hard would it be to split/duplicate the user tables so the forum users would be separate - say you wanted to host them on separate servers later.

[Fallback]

I am looking to get this installed by a skilled programmer. Will pay of course. Anyone thats interested please contact me via pm or email through this site. Thanks!

[oleee]

i am really supporting this great job plz email me at webmaster@oleeee.com

[iamnofear]

Hi,
May you or anyone tell me how to do it with multiple forum share single user table but different database (same server) ?

[Ahsin1]

im using 3.6.x can some do this for me? pm me please.. THANKS

[Cubevisions]

This works for 3.6.8?

[pspcrazy]

I'm so hoping this works on 3.6.8 I've been looking for something like this for a year or so but never found it. Please reply thanks@!

[Fenriz]

No, this modification is not working on 3.6.x

[JohnBee]

Any chance it could get ported to 3.6x? - This MOD is of great interest to me

[massiveblack]

is it possible to run something like this across multiple servers?

I run a big board (90k members, 1.5 million posts and 1.3 million visits a month) and am wanting to expand into multiple other forums (we are a non-profit organization). Basically setting up about thirty other forums (when it is all done) and having each current user being automatically registered, and all new members being able to auto register across all forums no matter which one they sign up on. Since my site allows image uploads and is art heavy, I do not think a single server is possible when it is all said and done. I will need many servers eventually. I am hoping for assistance and input on this and have some budget to hire someone with appropriate skills.

If anyone can assist me with this, please let me know at jmanley@massiveblack.com The site is called www.conceptart.org/forums. We are making a photography forums, a fine art forums and some other areas.

Please advise...just talented artists here, not many programmers.


Jason
jmanley@massiveblack.com

[TundraSoul]

There's definitely a demand for this type of networking. I also would like the ability to run multiple forums with just one user database. Sign me up!

[geckofrog]

I am interested also...

[regitbull]

ok i want to ask something.

Im looking a few months for a mod that can give discount on paid subscriptions or a coupon mod and its requested many times but nobody could make it.

So i was thinking what if i put a second forum on my site that run a 3.5 serie.
If they buy a paid subscription on that forum does that subscription also work on the main forum then?

Because then i can use the other forum so they can buy a subsripion with discount and it will work on the main forum.

Do you guys think thats posseble or is that a other table?
And if its a other table it it posseble to do did with that other table then?

[kafi]

If there is somebody that will take this mutlipleforum under the wings, I am also interested in paid modification with updates...

[Mythotical]

Has anyone updated this yet? The way vB has things setup now confuses me to death and I can't seem to figure out where insert queries are for users, etc. So if anyone has updated this, please PM me.

[azn_romeo_4u]

I'm willing to pay for a working but enhance version of this mod. Someone send me a PM please =D

[maznos]

hi

myself I tested it on 3.68 and it does work with some additional modifications.

regards

[Floris]

Does anybody know if there's a 3.6 version of this mod?

[Twinkies]

Does anybody know if there's a 3.6 version of this mod?

+1 I could really use this mod as well!!

[Lionel]

Does anybody know if there's a 3.6 version of this mod?

I have been using it with 3.60 and 3.07
In addition of what is posted there are a couple of additional small changes to do

[kafi]

I wish to use it, but since it is very robust and critical hack and not supported I am afraid to install it if there is no future for upgrades...

[Lionel]

It's a nice hack, but it's a real pain to maintain. I had a bunch of 3.07 mods that I wanted to keep, so is the reason why I installed it. However, every single hack that you install you must replace all TABLE_PREFIXES for a group of tables. Real pain!!

[valdet]

bump.

Does anyone knows if this can be used on new vB 3.6.x versions, i.e. to work for two separate forums which are on the same VPS?

[turbo.:R]

bump.

Does anyone knows if this can be used on new vB 3.6.x versions, i.e. to work for two separate forums which are on the same VPS?

me too.. 2 seperate already existing forums...

[vuiveclub]

So has anyone tried this on 3.6.x version?

[Cristi_XP]

Fatal error: The requested language does not exist, reset via tools.php. in /includes/functions.php on line 1223
any ideas ?
i use 3.6.8,isn`t compatible with this hack ?:D

doesn`t anyone have the files already modified... ?
if I put a normal functions.php it is working,i go to the member list and I see al the users...when i click on them I get i"Invalid User specified. If you followed a valid link, please notify the administrator"
In admin CP the users seem to exist...but on the forum i cannot view the information...
I`ve got it to work in 3.6.8
But i don`t know how to make them use the same post count table...any ideea?
I am getting an error when i try to register a new username...
Invalid SQL:
3159, '', '\'i6', FROM_UNIXTIME(1205077658),
'82f7672d43e93ba051f2f292ffbabf39', 'test@test.ro', 'test', 2, 1, 'Incepator', 0, 0, '', '', '0',
'88.158.8.142', '', 1205077658, 1205077658, 1205077658, -1, 1, 0, 5,
10, 0, -1, 0, -1);

[superthang]

can this be done with 3.7? :)

[Fenriz]

really need this with 3.7

[Tekmon]

You can follow the procedures above and do this with 3.7 just as easily. If you run into
any bumps you will see that you can just find the spot in the code that has aproblem and make the change so it is looking for your vb3_ or master table instead of the slave sites table.

I did this on www.mmowned.com and www.fpsowned.com with fpsowned.com being the slave site. It all works very well.

[Ricsca]

With 3.7.x is compatible?

[Tekmon]

With 3.7.x is compatible?


I have it done on 3.7 with www.mmowned.com as the primary and www.fpsowned.com as the secondary.

[sandri]

Hi all,

tested it with 3.7x it looks ok.

but i have one question.

When i login into forum1 and then i go to forum2, i must login again. :-(

Is auto login possible?

Only once login for all forums?

THX for help. ;-)

[Quarterbore]

I may need to check my sanity on why I am asking this but I assume this should work even if one board is a 3.6.x site and the second is a 3.7.x. site?

I think I need to set up a test envionment and try it as I have a significant need for this now so time to give it a go.

[Kaelon]

Does this hack share session data, and if so, does that mean that when one site reports a user logged in, the other site will also show them logged in and online?

[b3hr0uz]

i get this error while registering in my slave forum

Fatal error: Existing data passed is not an array
Called set_existing in [path]/register.php on line 421
in [path]/includes/class_dm.php on line 235

[chikkoo]

Hi..

This is a very good Mod, I like it and installing now in vb3.74. My observations are as below:

1) Avatars are not appearing, similar case in Profile Friends.
2) Slave site is showing the Master site Online Users, this should be avoided.

[Chunky Monkey]

Has anyone got this working properly with 3.7.4?

Is there a way to share some of the forums, as well?

[shri]

Hi - I've tried to contact the author to see if they'll upgrade to the latest version of VB as a paid service, but no avail. Any ideas if this is compatible, or if there is an alternative to this for 3.8.x users?

[wmlvb]

I would love tis in 3.8 too!!

[xlguy]

Anyone fancy doing this for 3.8x?

[sR->Shaun]

I am currently working on a 3.8 version. I have the tables shared and it's working in terms of logging in. Acutally a lot of it works. But I'm getting insert errors when trying to create a new thread.

*edit this might be because I made new forums before importing the usertable.

[sR->Shaun]

Finished. So far so good.

Mod installation seems to be exactly the same in terms of edits for 3.8.1

[sv1cec]

OK, I've asked these questions in the thread for vB 3.0.x and got no answers, so I would post it here as well, since there are a few things that you guys may have seen and could save me the trouble. Here are my questions:

I would like to know how the "sessions" are handled. I have some questions here and I would appreciate if someone can answer them for me.

Let's assume two sites, A and B. With this hack, all user information is kept in the "user" table in database A.

A member of site A logs in Site B. Obviously, since the last login time is stored in the shared user table, the last login time entered in the table, will be common for both sites, correct? So if the member comes back after two days and logs-in in site A, the last login time will be the last login time from his visit in site B. That means that if the user asks to see the new posts since his last visit (for example), the posts shown to him will not be correct, he will miss the posts between the last time he visited site A and the time he visited site B. Am I correct on this? It is of course possible to alter the user table to have separate columns for these time parameters for site A and site B.

Another question: again, let's suppose that a member logs in site B, does some work there and then follows a link to site A. Will he still be logged in in site A or will he need to re-log in in the other site? In other words, how are cookies handled? And what difference will it make if someone uses the "Remember me" checkbox in one site?

[MagicThemeParks]

Great questions John! :)

I'm keeping my eyes open for the answers as I'm researching this as well :D

[betts02]

any update on a new vesion of this mod or if it works on 3.8 and above ?

[sticky]

Would it be possible to get this to work for VB 4? I'll gladly pay.

[Frank T]

Would it be possible to get this to work for VB 4? I'll gladly pay.

I'll do it for you.

[shortbus1662]

You can make it happen? Please PM me with info, background, portfolio, price, etc.

Thanks!

Had been talking to the OP about it but I think he's kinda disappeared.