need some advice about wordpress and database

Discussion in 'PHP' started by dougvcd, Feb 4, 2008.

  1. #1
    just installed word press and had a look at database and there are varius new tables and one was ws-members now i already have a table with members password etc can the 2 be combined so if you sign up on my web site the same username etc can be used on blog with out having to reg again
    cheers
    Doug

    hope this is the right forum
     
    dougvcd, Feb 4, 2008 IP
  2. cridenour

    cridenour Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Technically speaking, yes. Is this old table also from wordpress?
     
    cridenour, Feb 4, 2008 IP
  3. dougvcd

    dougvcd Peon

    Messages:
    267
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    no it is what i made
    Doug
     
    dougvcd, Feb 4, 2008 IP
  4. LittleJonSupportSite

    LittleJonSupportSite Peon

    Messages:
    386
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Make sure your password schema matches. IE: MD5 hash or PASSWORD(blah)

    Also remove all duplicate user names if any before merging.

    Make sure you have matching column counts.

    That should wrap up the minimum requirements to what you are trying to do.

    not that difficult either.
     
    LittleJonSupportSite, Feb 4, 2008 IP
  5. cridenour

    cridenour Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    yea you once you check to make sure no user names conflict then you can do

    INSERT INTO wp-members (user, password) VALUES (SELECT user, password from othertable)

    or something similar.
     
    cridenour, Feb 4, 2008 IP
  6. dougvcd

    dougvcd Peon

    Messages:
    267
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Thanks littlejohn
    will have to look into that sound a bit complicated for me at the moment but you never know
    cheers
    Doug
     
    dougvcd, Feb 4, 2008 IP
  7. LinketySplit

    LinketySplit Peon

    Messages:
    97
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #7
    If the forum & the blog are both still a part of your site, you'll probably have to take this concept 1 step further.

    The user tables need to be merged into one (matching the schema and merging the data), and *then* the blog or the forum code would have to be updated so they both are pointing to the same table. In this way, when you have someone that registers on the forum, they're automatically registered on the blog (and visa versa).
     
    LinketySplit, Feb 4, 2008 IP