[vexxy]

I have the following stats code from the widget that displays the total number of users etc. unfortunately, it shows all users, including the ones from waiting for confirmation etc.

What's the condition to exclude them from usergroups 3 and 4?

ob_start();
global $vbulletin, $db, $vbphrase;
//Begin Forum Stats
// forum stats start
$numbersmembers = $db->query_first("SELECT COUNT(*) AS users,MAX(userid) AS max FROM " . TABLE_PREFIX . "user");
$numbermembers = number_format($numbersmembers['users']);
$counter = $db->query_first("SELECT COUNT(postid) AS posts, COUNT(threadid) AS threads FROM " . TABLE_PREFIX . "post");
$totalposts=number_format($counter['posts']);
$countthreads = $db->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "thread");
$totalthreads=number_format($countthreads['threads']);
// forum stats end

--------------- Added [DATE]1319662936[/DATE] at [TIME]1319662936[/TIME] ---------------

nobody can help me?