Check out the SMF Function DB!
Started by Spaceman-Spiff, September 03, 2004, 09:14:44 PM
QuoteAt the same time, share the avatar / attachment table using this tips.
Quote from: Arantor on March 27, 2010, 05:47:31 PMIncredibly bad idea!Assuming you have two topic and two message tables, you'll be duplicating attachments unless you modify all the attachment handling code too (have fun with that)Basically, an attachment is attached to a post by id. If you attach a file to message id 1000, the same attachment is visible in BOTH sides' message 1000.
Quote from: Arantor on March 05, 2010, 07:15:54 AMNote that member avatars are shared if they use an external URL or pick from the gallery (since that's stored in the members table, along with their post count) but not if they upload their own (since that's stored in the attachments table)
Quote from: Mr. Doug on March 27, 2010, 08:22:14 PMOk...so that was the most painless process on the planet. (after I got everything in the same DB)RC3, up and running with no issues using the MySQL method. The only thing I'd add is that you need to make sure you "recount forum statistics" after you link them all to the same user DB. I'm showing the correct count across 3 sites now. (Soon to be 4...as soon as I can figure out how to import 25,000 phpBB3 users to my SMF installation.)
updateSettings(array('totalMembers' => true), true);