[kh99]

If you want to make a forum block, then you can make a php type block and use that code as part of it. If you want to put the value in an existing template, then you need to create a plugin, use that code, and also add a line to pre-register it to the template you want it to display in (and also edit the template to add something like {vb:raw num_members}).

For example, if you wanted to add it somewhere in the FORUMHOME template, you could create a plugin using hook location forumhome_complete and code like this:

PHP Code:

if ($result = $vbulletin->db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE usergroupid = 12"))
{
      $num_grp_members = $result['count'];
      vB_Template::preRegister('FORUMHOME', array('num_grp_members' => $num_grp_members));
} 


Then in FORUMHOME, something like:

<vb:if condition="isset($num_grp_members)">There are {vb:raw num_grp_members} in group 12</vb:if>

BTW, you wouldn't expect that query to fail, but it's good to check anyway and do something reasonable rather than display 0.

(I changed it to use num_grp_members because I think num_members might be used already).