Combining website users

Discussion in 'MySQL' started by ki3000, Jun 7, 2008.

  1. #1
    Hi. I have a website with a blog (wordpress), forum (smf), directory, and a few others that requires users login / registration. i was wondering, is there a way to combine these where members can only have one log in so that my users don't have to log in / sign up each for all the services that I offer?

    Thanks.......
     
    ki3000, Jun 7, 2008 IP
  2. ki3000

    ki3000 Active Member

    Messages:
    361
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Pretty much what i am asking here, is if there's a way to combine the users from one db to another. you know like many big sites do: ie. yahoo (email, chat, news, sports, etc).
     
    ki3000, Jun 7, 2008 IP
  3. Alexj17

    Alexj17 Member

    Messages:
    173
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #3
    I done it with mine, i used my forum database login system as the database for the login system for the website. UIts pretty simple really. You just need to point your blog or forum login script to the other database, so they both work off the same database/tables.

    *say from the blog to the forum*

    You will have copy all the info in your blog table, make sure all the colums are the same and paste your users (for the blog) into the forum database. Make sense?
     
    Alexj17, Jun 8, 2008 IP
  4. Kendothpro

    Kendothpro Well-Known Member

    Messages:
    574
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    120
    #4
    To do that you'll have to first make sure the 2 databases are compatible, and then eventually write a script to convert/merge them. It requires a fairly good knowledge of both php and mysql (or even basic if the two databases are very similar)
     
    Kendothpro, Jun 8, 2008 IP
  5. ki3000

    ki3000 Active Member

    Messages:
    361
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #5
    how about if i have more than two? say 7 or 8 databases? I mean, or later on, add an extra one? What I am trying to do really is to have a central / one login for all my sites (like blog, forum, directory, email, community share site, etc). each has it's own db. and i was wondering if there's a way for all these users to use a single login.

    I am thinking, that if I can't do it, i might have to go with OpenID. what do you all think?
    thanks.
     
    ki3000, Jun 8, 2008 IP
  6. Alexj17

    Alexj17 Member

    Messages:
    173
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #6
    I dont think that will be possible, you will need to use the same database for each section to use the one login script.
     
    Alexj17, Jun 8, 2008 IP
  7. Dreads

    Dreads Well-Known Member

    Messages:
    1,884
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    150
    #7
    it is possible..
    But it will require a lot of php skill and basics. but the major factor is time -_-

    For start you can find out where each script stores the information inside the tables
     
    Dreads, Jun 9, 2008 IP