Kunena 6.4.8 Released

The Kunena team has announce the arrival of Kunena 6.4.8 [K 6.4.8] in stable which is now available for download as a native Joomla extension for J! 5.0.x/5.1.x/5.2.x/5.3.x/5.4.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 6.4
Important note: Go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated. This is particularly necessary for major version jumps so that the table changes are adapted.

This category contains miscellaneous, uncategorised user contributions, (templates, modules, plugins and hacks) relating to older versions of Kunena that are no longer supported.

The topics in this category are for historical interest only. Owing to the structural changes that occurred in K 1.7, many of the ideas in these topics will not work with later versions and, for that reason, the topics are locked.

Question Total user count FIXED !!! :)

More
14 years 6 months ago #1 by jaybuzzard
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
The following user(s) said Thank You: sozzled, xillibit

Please Log in or Create an account to join the conversation.

More
14 years 6 months ago #2 by LN888
:woohoo: B) :laugh: ;)

YAYYYYYYYYYYYYYY!!!! Worked FANTASTIC!

Thnx guys!!!!

Way to stay on top of it!

*throws confetti in the air* :cheer:

Please Log in or Create an account to join the conversation.

More
14 years 5 months ago #3 by CheechDogg
Man, I still don't see how the total count is fixed with this. Even with the latest update the count is still far off.

Maybe it's my configuration?

[img
Find me on Facebook.

CAG Clan 1st and 3rd Person Shooter Clan on XBOX 360 & PS3

Please Log in or Create an account to join the conversation.

Time to create page: 0.285 seconds