Quote:
Originally Posted by luroca
It would be very useful to know the usergroup of the different users. By example:
... User1 (registered) and User2 (Premium) in the same PC ...
|
Well, here it is my little aportation:
Find:
PHP Code:
$checkuser = $vbulletin->db->query_first("SELECT username FROM " . TABLE_PREFIX . "user WHERE userid={$Unums[$i]}");
if ( !empty($andids) ) $andids .= "and";
$andids .= " [url=". $vbulletin->options['bburl'] ."/member.php?u=" . $Unums[$i] . "] ". $checkuser['username'] ."[/url] ";
}
And replace with:
PHP Code:
$checkuser = $vbulletin->db->query_first("SELECT user.username as username, usergroup.title as usergroup FROM " . TABLE_PREFIX . "user LEFT JOIN " . TABLE_PREFIX . "usergroup ON user.usergroupid = usergroup.usergroupid WHERE userid={$Unums[$i]}");
if ( !empty($andids) ) $andids .= "and";
$andids .= " [url=". $vbulletin->options['bburl'] ."/member.php?u=" . $Unums[$i] . "] ". $checkuser['username'] ."[/url] (" . $checkuser['usergroup'] . ") ";
}
Regards