Announcement

Collapse
No announcement yet.

Sharing users between two forums

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sharing users between two forums

    Hello, is there a way to share/bridge two vB databases (users) between two forums on two separate URLs, but on same server?

    Please assist..
    There must be some way..
    > Follow this link for the CHEAPEST Domain Name Registration - Domain Transfers Are Even Cheaper! :)
    WoW Accounts, FFXI Accounts, Aion Accounts, FFXIV Accounts, MMORPG Market

  • #2
    Short answer: no.

    Long answer: you can hire someone to do the integration but it's a PITA and makes upgrades more challenging. If you don't want to spend a few $1000 over the next few years or really enjoy custom coding, I wouldn't bother.
    David Edelman
    Diabetes DailyDiabetes Forumtwitter.com/davidtalkdavidedelman.com

    Comment


    • #3
      Originally posted by davide101 View Post
      Short answer: no.

      Long answer: you can hire someone to do the integration but it's a PITA and makes upgrades more challenging. If you don't want to spend a few $1000 over the next few years or really enjoy custom coding, I wouldn't bother.
      There has to be a way for PHP to connect to the same server but to a different site to access a database...right?

      :[
      > Follow this link for the CHEAPEST Domain Name Registration - Domain Transfers Are Even Cheaper! :)
      WoW Accounts, FFXI Accounts, Aion Accounts, FFXIV Accounts, MMORPG Market

      Comment


      • #4
        Unless I'm misunderstanding your question, your best bet is to do this at the database level. There are many clustering solutions out there that will allow for mirroring of tables. Basically the clustering software will notice an insert, delete, update, whatever and perform the operation on both tables simultaneously. It will require a very short lock on the foreign database table, but in the case of a user table we're talking microseconds, if that, so you shouldn't notice any performance degradation.

        This would not allow you to actually do the lookups on a different database's table, but instead would allow you to do look ups on the table integral to the database associated with your foum. However the data on the local table will always be identical to the foreign table barring one database being unavailable at the time a write is made. Once the other database becomes available, syncronization will occurr imediately.

        The advantage of this is that you have absolutely zero modifications to the php code that your site runs, and no maintenance whatsoever other than upgrades to the clustering software if and when you upgrade your database version. Doing it at the PHP level is just a sorry hack.
        Anybody who says "it can't be done" will usually be interrupted by somebody who is already doing it.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X