Wedge

Public area => The Pub => Off-topic => Discussion démarrée par: NeobeatIKK le 23 Mai 2012 à 21:44

Titre: Same user data in multiple databases.
Posté par: NeobeatIKK le 23 Mai 2012 à 21:44

I have a question:

Is it possible to have multiple forums and share the user data?, let me explain,

I have a forum right now, and I offered a friend to install another forum in a subdomain on my server, but our forums have similar content. So, I could be great if one user registers in one forum and immediately can log in the other forum.

I have total access to SQL and phpMyAdmin in my server, is it possible to achieve?.
Any risk of destroying the database?.

Titre: Re: Same user data in multiple databases.
Posté par: Arantor le 23 Mai 2012 à 22:25

Just as in SMF, this is incredibly difficult to pull off because of how intermixed data is.

For example, you can't just share the member table because part of that is a link to avatars (which are stored in the attachments table) and also to membergroups (directly in the table, linking to the membergroups table) so you have to split the table up.

It's doable but it isn't going to work too well.

Titre: Re: Same user data in multiple databases.
Posté par: NeobeatIKK le 23 Mai 2012 à 22:53

I imagined it is more difficult than it sounds :P

Thanks for your response.

Titre: Re: Same user data in multiple databases.
Posté par: Arantor le 23 Mai 2012 à 22:56

You might want to read the discussion at sm.org about doing it, that covers most of the issues with doing it.