[Davey-UK]

Yes that works, but still not showing the number in sideblock. Would this be correct?

global $vbulletin;
if ($result = $vbulletin->db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE usergroupid = 12"))
{     
$output =  "We currently have" . $num_grp_members . "<br />" . "<a href=http://www.mysite.com/forum/payments.php> Upgrade now</a>";

return $output; 
}