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; }