Important [Resolved] Total user count wrong

Frontpage index STATS FIXED AND WORKING - No more incorrect total user count!!

If you are using Kunena 1.6.4 and would like to fix the issue with the incorrect stats (Total User Count) showing on the main index page of the forum, then please do the following.

For those that would like to edit the file this is the following code to remove and replace with

Find in lib/kunena.stats.class.php on line ~93 :

public function loadTotalMembers() {
if ($this->totalmembers === null) {
$this->_db->setQuery ( "SELECT COUNT(*) FROM #__users WHERE block=0 AND activation=''" );
$this->totalmembers = $this->_db->loadResult ();
KunenaError::checkDatabaseError();
}
}

AND REPLACE THE CODE WITH THIS

public function loadTotalMembers() {
if ($this->totalmembers === null) {
if ($this->_config->userlist_count_users == '0' ) $where = '1';
elseif ($this->_config->userlist_count_users == '1' ) $where = 'block=0 OR activation=""';
elseif ($this->_config->userlist_count_users == '2' ) $where = 'block=0 AND activation=""';
elseif ($this->_config->userlist_count_users == '3' ) $where = 'block=0';

$this->_db->setQuery ( "SELECT COUNT(*) FROM #__users WHERE {$where}" );
$this->totalmembers = $this->_db->loadResult ();
KunenaError::checkDatabaseError();
}
}

A big thanks to Sozzled and matis

Regards
Jay

This had me scratching my head for a while

Big thanks to all that helped fix the bug