I'm writing a plugin that will need to know what a user's secondary groups are in order to determine what level of access said user has, only issue is I can't figure out how to pull that info from the database.
I suppose I could parse through the xenforo php and figure out how it enters the data in the code somewhere, but I'm hoping someone on here already knows or can provide some insight.
I know in the xf_user_group_relation table it has user id's and their primary group id's, but not secondary.
In xf_user it has a secondary_group_ids column but the data appears to be in hex value (see screenshot here: http://i.imgur.com/UMxYJ.png), might in turn be a bitmask or some other value that through an algorithm can be split into multiple digits...
So again, to reiterate - how the heck do I get individual group id's from that secondary_group_ids field?
Any ideas / help / suggestions is greatly appreciated. I really don't want to go through the php and try to figure this out if I don't have to. Thanks!