예제 #1
0
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);
}
예제 #2
0
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);
}