function viewBanners($option) { global $database, $mainframe, $mosConfig_list_limit; $limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit); $limitstart = $mainframe->getUserStateFromRequest("viewban{$option}limitstart", 'limitstart', 0); // get the total number of records $database->setQuery("SELECT count(*) FROM #__banner"); $total = $database->loadResult(); require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php'; $pageNav = new mosPageNav($total, $limitstart, $limit); $query = "SELECT b.*, u.name as editor FROM #__banner as b " . "\n LEFT JOIN #__users AS u ON u.id = b.checked_out" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit}"; $database->setQuery($query); if (!($result = $database->query())) { echo $database->stderr(); return false; } $rows = $database->loadObjectList(); HTML_banners::showBanners($rows, $pageNav, $option); }
function viewBanners($option) { global $database, $mainframe, $mosConfig_list_limit; $limit = intval($mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit)); $limitstart = intval($mainframe->getUserStateFromRequest("viewban{$option}limitstart", 'limitstart', 0)); // get the total number of records $query = "SELECT COUNT(*)" . "\n FROM #__banner"; $database->setQuery($query); $total = $database->loadResult(); require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php'; $pageNav = new mosPageNav($total, $limitstart, $limit); $query = "SELECT b.*, u.name AS editor" . "\n FROM #__banner AS b " . "\n LEFT JOIN #__users AS u ON u.id = b.checked_out"; $database->setQuery($query, $pageNav->limitstart, $pageNav->limit); $rows = $database->loadObjectList(); HTML_banners::showBanners($rows, $pageNav, $option); }