[archet1337]

How to add another usergroup?

I've been looking at this without figuring out how to add another group. I would like to have usergroup #9 to this list.

I'm a novice when it comes to php, so it would be awesome if someone could point me in the right direction

PHP Code:

// Sort Memberlist by Usergroups by Hasann
$usergrouplinks = '';
$fetch_usergroups = $vbulletin->db->query_read_slave("
SELECT ".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."usergroup.title,
COUNT(".TABLE_PREFIX."user.userid) AS membercount
FROM ".TABLE_PREFIX."usergroup
LEFT JOIN ".TABLE_PREFIX."user
ON ".TABLE_PREFIX."user.usergroupid=".TABLE_PREFIX."usergroup.usergroupid
OR FIND_IN_SET(".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."user.membergroupids)
WHERE (".TABLE_PREFIX."usergroup.genericoptions & " . $vbulletin->bf_ugp_genericoptions['showmemberlist'] . ")
GROUP BY ".TABLE_PREFIX."usergroup.usergroupid
ORDER BY ".TABLE_PREFIX."usergroup.title ASC
");

while ($usergroups = $vbulletin->db->fetch_array($fetch_usergroups))
{
  $do_not_include = array(1,3,4);
    if (!in_array($usergroups['usergroupid'], $do_not_include))
    {
    $usergrouplinks .= '<a href="memberlist.php?do=getall&amp;groupid='.$usergroups['usergroupid'].'"><b>'.$usergroups['title'].'</b> (<b>'.$usergroups['membercount'].'</b>)</a>&nbsp;&nbsp;&nbsp;';    
    }
}

if (intval($groupid) > 0)
{
$condition .= ' AND (FIND_IN_SET(\''.$groupid.'\', membergroupids) OR user.usergroupid = '.$groupid.')';
}