I'm sure I can set it up so you would be able to specify a particular group to pull from. I'm plugging away on IIP 5.0 and will add that in when I get to those boxes.
As for a quick fix... hmmmm... let me look...
For the random profile find this query:
$query = " SELECT U_Picture,U_Bio,U_Name,U_Username,U_Location,U_Hobbies,U_PicWidth,U_PicHeight FROM w3t_Users WHERE U_Number >= 2 LIMIT $RandNum,1 ";
and change it to this:
$query = " SELECT U_Picture,U_Bio,U_Name,U_Username,U_Location,U_Hobbies,U_PicWidth,U_PicHeight FROM w3t_Users WHERE U_Number >= 2 AND U_Groups LIKE '%-3-%' LIMIT $RandNum,1 ";
For top posters find this:
$query = " SELECT U_Username,U_Totalposts FROM w3t_Users WHERE U_Number >= 2 ORDER BY U_Totalposts DESC $limit ";
and change it to this:
$query = " SELECT U_Username,U_Totalposts FROM w3t_Users WHERE U_Number >= 2 AND U_Groups LIKE '%-3-%' ORDER BY U_Totalposts DESC $limit ";
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.