Ejemplo n.º 1
0
function showChronoContact($option)
{
    global $mainframe;
    $limit = $mainframe->getUserStateFromRequest($option . '.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
    $limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int');
    // count entries
    $database =& JFactory::getDBO();
    $database->setQuery("SELECT count(*) FROM #__chrono_contact");
    $total = $database->loadResult();
    echo $database->getErrorMsg();
    jimport('joomla.html.pagination');
    $pageNav = new JPagination($total, $limitstart, $limit);
    # main database query
    $database->setQuery("SELECT * FROM #__chrono_contact ORDER BY id LIMIT {$pageNav->limitstart},{$pageNav->limit}");
    $rows = $database->loadObjectList();
    if ($database->getErrorNum()) {
        JError::raiseWarning(100, $database->stderr());
        $mainframe->redirect("index2.php?option={$option}");
    }
    HTML_ChronoContact::showChronoContact($rows, $pageNav, $option);
}