function viewBannerClients($option)
{
global $database, $mainframe, $mosConfig_list_limit;
$limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit);
$limitstart = $mainframe->getUserStateFromRequest("viewcli{$option}limitstart", 'limitstart', 0);
// get the total number of records
$database->setQuery("SELECT count(*) FROM #__bannerclient");
$total = $database->loadResult();
require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php';
$pageNav = new mosPageNav($total, $limitstart, $limit);
$sql = "SELECT a.*,\tcount(b.bid) AS bid, u.name AS editor" . "\n FROM #__bannerclient AS a" . "\n LEFT JOIN #__banner AS b ON a.cid = b.cid" . "\n LEFT JOIN #__users AS u ON u.id = a.checked_out" . "\n GROUP BY a.cid" . "\n LIMIT {$pageNav->limitstart},{$pageNav->limit}";
$database->setQuery($sql);
if (!($result = $database->query())) {
echo $database->stderr();
return;
}
$rows = $database->loadObjectList();
HTML_bannerClient::showClients($rows, $pageNav, $option);
}
