what table is the users usergroups stored in?

[CampinCarl]

I need to know which table holds the information that tells vbulletin what users are in what usergroup. Ive looked for a long time searching for it, but i just cant find it. Any help is appreciated

[Dismounted]

I'm probably guessing you need to find out to do a comparison? You can simply use the is_member_of() function.

PHP Code:

if (is_member_of($vbulletin->userinfo, 6))
{
    // user is in usergroup 6
} 


[CampinCarl]

well, thats mildly helpful, but I actualy just need to know what table its stored in

[Dismounted]

The user table, under usergroupid and membergroupids. The first being the primary usergroup and the second being secondary usergroups. Also, displaygroupid stores the chosen display usergroup.