function showRanks($option) { $kunena_app =& JFactory::getApplication(); $kunena_db =& JFactory::getDBO(); $order = JRequest::getVar('order', ''); $limit = $kunena_app->getUserStateFromRequest("global.list.limit", 'limit', $kunena_app->getCfg('list_limit'), 'int'); $limitstart = $kunena_app->getUserStateFromRequest("{$option}.limitstart", 'limitstart', 0, 'int'); $kunena_db->setQuery("SELECT COUNT(*) FROM #__kunena_ranks"); $total = $kunena_db->loadResult(); if (KunenaError::checkDatabaseError()) { return; } if ($limitstart >= $total) { $limitstart = 0; } if ($limit == 0 || $limit > 100) { $limit = 100; } $kunena_db->setQuery("SELECT * FROM #__kunena_ranks", $limitstart, $limit); $ranks = $kunena_db->loadObjectList(); if (KunenaError::checkDatabaseError()) { return; } jimport('joomla.html.pagination'); $pageNavSP = new JPagination($total, $limitstart, $limit); html_Kunena::showRanks($option, $ranks, $pageNavSP, $order); }
function showRanks($option) { global $order; $app =& JFactory::getApplication(); $kunena_db =& JFactory::getDBO(); $limit = $app->getUserStateFromRequest("global.list.limit", 'limit', $app->getCfg('list_limit'), 'int'); $limitstart = $app->getUserStateFromRequest("{$option}.limitstart", 'limitstart', 0, 'int'); $kunena_db->setQuery("SELECT COUNT(*) FROM #__fb_ranks"); $total = $kunena_db->loadResult(); if ($limitstart >= $total) { $limitstart = 0; } if ($limit == 0 || $limit > 100) { $limit = 100; } $kunena_db->setQuery("SELECT * FROM #__fb_ranks", $limitstart, $limit); $ranks = $kunena_db->loadObjectList(); check_dberror("Unable to load ranks."); $rankpath = rankpath(); jimport('joomla.html.pagination'); $pageNavSP = new JPagination($total, $limitstart, $limit); html_Kunena::showRanks($option, KUNENA_LANGUAGE, $ranks, $pageNavSP, $order, $rankpath); }