[MaryTheG(r)eek]

Originally Posted by Leo Brazil

Sorry to bump this, but does one here have a tip for it ?

Open memberindex.php
Find:

  // Build Admins Block
  if ($vbulletin->options[micromembers_admins] == '1') {
     $teammembers_get = $vbulletin->db->query_read("
     SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle
     FROM ".TABLE_PREFIX."user
    JOIN ".TABLE_PREFIX."usergroup AS ugroup
   ON ugroup.usergroupid=".TABLE_PREFIX."user.usergroupid
   LEFT JOIN ".TABLE_PREFIX."usergroup
   ON (FIND_IN_SET(".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."user.membergroupids))
    WHERE ugroup.usergroupid=$admingroup OR ".TABLE_PREFIX."usergroup.usergroupid=$admingroup
   GROUP BY ".TABLE_PREFIX."user.userid
     ORDER BY RAND()
     LIMIT $limit
     ");

Replace with:

  // Build Admins Block
  if ($vbulletin->options[micromembers_admins] == '1') {
     $teammembers_get = $vbulletin->db->query_read("
     SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle
     FROM ".TABLE_PREFIX."user
    JOIN ".TABLE_PREFIX."usergroup AS ugroup
   ON ugroup.usergroupid=".TABLE_PREFIX."user.usergroupid
   LEFT JOIN ".TABLE_PREFIX."usergroup
   ON (FIND_IN_SET(".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."user.membergroupids))
    WHERE ugroup.usergroupid=$admingroup OR ".TABLE_PREFIX."usergroup.usergroupid=$admingroup OR ugroup.usergroupid=xxx OR ".TABLE_PREFIX."usergroup.usergroupid=xxx
 
   GROUP BY ".TABLE_PREFIX."user.userid
     ORDER BY RAND()
     LIMIT $limit
     ");

Replace xxx with the usergroupid that you want.

If you want to use more than 2 usergroups you can use the code below (of course you can use this code even for 2 only usergroups). On memberindex.php
Find:

  $admingroup = $vbulletin->options['micromembers_admins_group'];
  $admingroup2 = $vbulletin->options['micromembers_admins2_group'];
  // Build Admins Block
  if ($vbulletin->options[micromembers_admins] == '1') {
     $teammembers_get = $vbulletin->db->query_read("
     SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle
     FROM ".TABLE_PREFIX."user
    JOIN ".TABLE_PREFIX."usergroup AS ugroup
   ON ugroup.usergroupid=".TABLE_PREFIX."user.usergroupid
   LEFT JOIN ".TABLE_PREFIX."usergroup
   ON (FIND_IN_SET(".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."user.membergroupids))
    WHERE ugroup.usergroupid=$admingroup OR ".TABLE_PREFIX."usergroup.usergroupid=$admingroup
   GROUP BY ".TABLE_PREFIX."user.userid
     ORDER BY RAND()
     LIMIT $limit
     ");

Replace with:

  $admingroup = array('xxx', 'xxx');
  $thesegroups = implode(",", $admingroup);
  $admingroup2 = $vbulletin->options['micromembers_admins2_group'];
  // Build Admins Block
  if ($vbulletin->options[micromembers_admins] == '1') {
     $teammembers_get = $vbulletin->db->query_read("
     SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle
     FROM ".TABLE_PREFIX."user
    JOIN ".TABLE_PREFIX."usergroup AS ugroup
   ON ugroup.usergroupid=".TABLE_PREFIX."user.usergroupid
   LEFT JOIN ".TABLE_PREFIX."usergroup
   ON (FIND_IN_SET(".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."user.membergroupids))
    WHERE ugroup.usergroupid IN $thesegroups OR ".TABLE_PREFIX."usergroup.usergroupid IN $thesegroups
   GROUP BY ".TABLE_PREFIX."user.userid
     ORDER BY RAND()
     LIMIT $limit
     ");

Originally Posted by Leo Brazil

It would be great, I'm getting the same issue here, not a big deal, we could live with that but as we do have a few forums like off-topic ones not counting posts, it's affecting your mod page.
Thanks

I'm trying to find a solution for it. Please have patience.
Mary