sidebar block

[Dragonsys]

Originally Posted by CAG CheechDogg

Mark sorry to highjack this thread ...but how about to show only 1 usergroup even if they belong to a secondary usergroup?

it doesn't display usergroups. Are you wanting to show all member of only 1 specific group? If so, change the query to this:

$users_visited = $vbulletin->db->query_read(" 
    SELECT user.* 
    FROM " . TABLE_PREFIX . "user AS user 
    WHERE lastvisit >= " . TIMENOW . " - " . 7 * 86400 . " 
    AND usergroupid = _YOURUSERGROUP_
    ORDER BY lastvisit DESC 
");

change _YOURUSERGROUP_ to the group ID you want to show