Posted on: 2006/3/2 18:22
Re: Multisite HACK for 2.2.3 Final
Ah, perhaps I wasn't clear enough..
Yes, I have existing sites, each with their own independent databases and XOOPS installs (see my siggy). My end result would be a shared database for (at least) the users, forums and extended profiles to eliminate the users having to login to each of them with varying usernames and/or passwords.
I believe I'm going to have to try and attempt this in multiple steps:
a) merge the user tables with an integrated "dupe" user check so that the user's statistics can be summed rather than overwritten - perhaps a complex join statement on the users in the case that their username or email addy shows up in multiple databases
b) merge the extended profiles tables using a common format to include any custom fields that may not extend across the different databases
c) combine all the newbb tables into a single database, adjusting userid information so that credit is not lost for posts and the newbb author fields don't lose reference
Ya know, I think I just talked myself out of it.