public static function getTopPosters($limit = 0)
{
$limit = $limit ? $limit : KunenaFactory::getConfig()->popusercount;
if (count(self::$_topposters) < $limit) {
$db = JFactory::getDBO();
$query = "SELECT userid as id, posts AS count FROM #__kunena_users WHERE posts>0 ORDER BY posts DESC";
$db->setQuery($query, 0, $limit);
self::$_topposters = $db->loadObjectList();
KunenaError::checkDatabaseError();
}
return self::$_topposters;
}
/**
* @param int $limit
*
* @return array
*/
public static function getTopPosters($limit = 0)
{
$limit = $limit ? $limit : KunenaFactory::getConfig()->popusercount;
if (count(self::$_topposters) < $limit) {
$db = JFactory::getDBO();
$query = "SELECT u.id, ku.posts AS count\n\t\t\t\tFROM #__kunena_users AS ku\n\t\t\t\tINNER JOIN #__users AS u ON u.id=ku.userid\n\t\t\t\tWHERE ku.posts>0\n\t\t\t\tORDER BY ku.posts DESC";
$db->setQuery($query, 0, $limit);
self::$_topposters = (array) $db->loadObjectList();
KunenaError::checkDatabaseError();
}
return self::$_topposters;
}
