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

XF DB Tables

#1
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)
password-field
secondtable
useridfield-in-usertable
useridfield-in-secondtable

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 :)
 

Jake Bunce

XenForo moderator
Staff member
#2
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