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

[gibgib]

Got it to work!!

This mod WILL NOT work if you have the database type on the subsequent forums set to 'mysqli' in the config.php. Change it to 'mysql'.
Hope that saves some pulling of hair out of your noggin

[kderentz]

Hey guys ... running into an issue now ...

On the test site I have the Avatars set to the DB, but they still are not showing up.

2nd thing is I started to build the live site and have the patch set up, however unlike the the test site the Reg. User count isnt updating when someone registers, will it only do that when some reg on site B? should I set up a cron job just to update counters once a day?

[gibgib]

Originally Posted by kderentz

Hey guys ... running into an issue now ...

On the test site I have the Avatars set to the DB, but they still are not showing up.

2nd thing is I started to build the live site and have the patch set up, however unlike the the test site the Reg. User count isnt updating when someone registers, will it only do that when some reg on site B? should I set up a cron job just to update counters once a day?

Can help with the first Q....
You need to add "customavatar", to your array list.

[maidos]

my main forum doesnt have prefix so what should i do

[kderentz]

Originally Posted by maidos

my main forum doesnt have prefix so what should i do

Check out my posts above

[kderentz]

Originally Posted by gibgib

Can help with the first Q....
You need to add "customavatar", to your array list.

Thank ... ill look into that.

[maidos]

Originally Posted by kderentz

Check out my posts above

did check but i get database error that way

my second forum got prefix fb_

[kderentz]

Originally Posted by maidos

did check but i get database error that way

my second forum got prefix fb_

If you have no prefix in Forum A .... and Forum B has the prefix "fb_" then you simply set it to:

$main_prefix = "";

^make sure the quote marks have no spaces .. it really doesn't matter what Forum B, C, D, ect prefixes are as you only need to set the prefix for the forum whom user database your using.

[kderentz]

Originally Posted by gibgib

Can help with the first Q....
You need to add "customavatar", to your array list.

That worked thanks!

Also it looks like the user count will update when someone posts :up:

[maidos]

Originally Posted by kderentz

If you have no prefix in Forum A .... and Forum B has the prefix "fb_" then you simply set it to:

$main_prefix = "";

^make sure the quote marks have no spaces .. it really doesn't matter what Forum B, C, D, ect prefixes are as you only need to set the prefix for the forum whom user database your using.

thats what i did, not working