Major Additions - Share users database among many forums

This is a feature requested many times, and we are still waiting, so I released a patch to be able to run many forums with the same user database.

This is an EXPERIMENTAL PATCH I'm running on my forums.

--- ../../../private/upload/includes/class_core.php     2008-07-10 11:17:32.000000000 +0200
+++ class_core.php      2008-07-11 17:44:20.000000000 +0200
@@ -405,6 +405,33 @@
                $this->connection_recent =& $link;
                $this->querycount++;

+               $shared_tables = Array("user","useractivation","userban","usertitle","userchangelog","usertextfield","userfield","usergroup","userlist","usernote","profilevisitor","reputation","reputationlevel","spamlog","strikes","pm","pmreceipt","pmtext","avatar","profilefield");
+
+               $main_prefix = "FP_";
+               foreach ($shared_tables as $shared_table)
+               {
+                       $orig = TABLE_PREFIX.$shared_table;
+                       $dst  = $main_prefix.$shared_table;
+
+                       $this->sql = str_replace($orig." ",$dst." "  ,$this->sql);
+                       $this->sql = str_replace($orig.".",$dst."."  ,$this->sql);
+                       $this->sql = str_replace($orig."\r",$dst."\r",$this->sql);
+                       $this->sql = str_replace($orig."\n",$dst."\n",$this->sql);
+                       $this->sql = str_replace($orig."\t",$dst."\t",$this->sql);
+
+               }
+

                if ($queryresult = $this->functions[$buffered ? 'query' : 'query_unbuffered']($this->sql, $link))
                {

You can add "session" to $shared_tables if you want to share your sessions among forums under the same domain (Thanks Lionel)

This is only useful for new forums joining anothers one user database.

Requirements:

• An old forum where all users are.
• Sharing the same database, using diferent prefixes for tables (TABLE_PREFIX)

For example: Imagine we have FORUM_A , FORUM_B, and FORUM_C each one with their respective licenses.

FORUM A has table prefix FA_ in database, FORUM_B has FB_ and FORUM_C has FC_

FORUM A is the main, and older forum, where we have all our users.

then we would install FORUM_B and FORUM_C normally, using the same database that FORUM_A uses, but setting up their own table prefixes.


once FB_ and FC_ are installed then we go patching class_core.php from FORUM_B and FORUM_C setting up $main_prefix = "FA_"; so they use FORUM_A for shared tables.

Possible problems:

• memcached issues?, not sure
• avatar/signature pics/etc issues when storage is set to disk.
• more to come...

Author: Optimizacion Web

[ROTPAR]

Ok I got it working BUT I have 2 questions.

1.) Forum B does not show the registerd members in the forums statistics (bottom of the forums homepage)

2.) How can I show all online members on both forums. I want to show all current online members who are online on both forums.

[ROTPAR]

come on guys, nobody who can help me with this little detail ?

[ROTPAR]

bump

[merk_aus]

not working in the vb3.8.x - to extend on this it always comes up with a database error no matter what you try

[gibgib]

<font color="Blue">"56 installs"</font> so has anyone else successfully upgraded to 3.8 with 2 forums on one database?
If so, how did you go about it & does everything work as it did with 3.7?

[kderentz]

I took the mod out as it was working but I felt the unknow for the long term effects where too much of a hassle

[gibgib]

I intended on basing 3 sites off the one database permanently but I may need to re think if I want to upgrade vb versions.

[timegate]

Originally Posted by merk_aus

not working in the vb3.8.x - to extend on this it always comes up with a database error no matter what you try

This modification only works in version 3.7.x? Does anyone know why it doesn't it work in 3.8.x? Thanks in advance!

[Lionel]

Yesterday I just integrated it with two 3.83 install

[timegate]

Originally Posted by Lionel

Yesterday I just integrated it with two 3.83 install

And it works then? Did you have to make any modifications to the code to get it to work?