List members of additional usergroup

[Spyike]

Originally Posted by kh99

What happens, do you just get no user names? Is 43 a secondary user group, by any chance? If so I think you'd want

 WHERE usergroupid = $groupid OR FIND_IN_SET($groupid, membergroupids)

It is an additional usergroup, the error I receive is:
Fatal error: Call to a member function query_read() on a non-object in mban.php on line 3

Will report back with your edit.

Edit:

<?php 
$groupid = 43;
$users = $vbulletin->db->query_read("SELECT username FROM ".TABLE_PREFIX."user
                   WHERE usergroupid = $groupid OR FIND_IN_SET($groupid, membergroupids);
$str = '';
$sep = '';
while ($user = $vbulletin->db->fetch_array($users))
{
    $str .= $sep . $user['username'];
    $sep = ', ';
}
// $str is comma separated list of users in $groupid
$vbulletin->db->free_result($users);  
echo "Market Banned: $str";  
?>

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in mban.php on line 9