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

What is the storage method for secondary groups in MySQL?

Discussion in 'XenForo Development Discussions' started by jflory7, Feb 19, 2014.

  1. jflory7

    jflory7 Active Member

    Hello XenForo forums,

    I am trying to configure the Minecraft plugin CommunityBridge for linking my Minecraft server and website together. However, to do this, I need to know extra information about how XenForo stores secondary groups.

    Below are the different options that it is giving me. It seems like XenForo would either use multiple-key-values or junction, but I'm most certainly not the expert.

    Here's the options it's asking me to configure.

  2. Jeremy

    Jeremy Well-Known Member

    secondary_group_ids is a VARBINARY in a comma separated list.
  3. jflory7

    jflory7 Active Member

    So, based on the options in this configuration file, which options do you think would be the best fit? Would it be a key-value or multiple-key-value?

    Also, while I'm asking, is the primary group stored in a key-value pair?
  4. Jeremy

    Jeremy Well-Known Member

    Single. The comment describes the options and which one to choose.
    jflory7 and SneakyDave like this.
  5. SneakyDave

    SneakyDave Well-Known Member

    Yes, use "single" with the correct column name, and specify the comma delimiter.

    I've done this myself. It works well. The only problem I've found is the way Community Bridge looks for a user avatar. It doesn't quite work with xenForo.

    Shoot me a PM and I'll share my config with you.

    I've seen some other strange group syncing problems with CM, but I hope it was an isolated incident.
  6. jflory7

    jflory7 Active Member

    I skipped over the avatar part, but everything else seems to be making sense. And that would help a lot! :)

Share This Page