1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF DB Tables

Discussion in 'XenForo Questions and Support' started by Malchus, Aug 13, 2011.

  1. Malchus

    Malchus Member

    I am trying to utilize a forum bridge to connect my forums to my Online gaming server.
    However, it is requiring the following:
    usertable: xf_user (correct me if wrong)
    rank-field: xf_user_group (correct me if wrong)

    I have opened the database using phpmyadmin.
    I can not locate the last 4 options, a few pointers in the right direction would be much appreciated.

    Thank you :)
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    It appears to allow for one joined table to extend the user record. The joined table will have to be xf_user_authenticate so your users can login. But xf_user_authenticate.data contains serialized data so you can't authenticate with just SQL. You need a script. This will likely require more effort than just specifying the appropriate database fields. But here are the fields:

    usertable: xf_user

    rank-field: custom_title
    There isn't a rank feature, but custom titles are stored in the user record if you have assigned titles to any of your users.

    password-field: data

    secondtable: xf_user_authenticate

    useridfield-in-usertable: user_id

    useridfield-in-secondtable: user_id
  3. Malchus

    Malchus Member

    Thank you jake, it is much appreciated, I will see how this turns out.
  4. Malchus

    Malchus Member

    I forgot, on more
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    username-field: username

Share This Page