function writerList()
{
global $database, $mainframe, $option;
$limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', 10);
$limitstart = $mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0);
$search = $mainframe->getUserStateFromRequest("search{$option}", 'search', '');
$search = $database->getEscaped(trim(strtolower($search)));
$database->setQuery("SELECT COUNT(*)" . "\nFROM `#__cb_writers` AS a" . (count($where) ? "\nWHERE " . implode(' AND ', $where) : ""));
$total = $database->loadResult();
echo $database->getErrorMsg();
include_once "includes/pageNavigation.php";
$pageNav = new mosPageNav($total, $limitstart, $limit);
$query = "select #__cb_writers.* from #__cb_writers" . (count($where) ? "\nWHERE " . implode(' AND ', $where) : "") . "\nORDER BY `name` ASC" . "\nLIMIT {$pageNav->limitstart}, {$pageNav->limit}";
$database->setQuery($query);
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
HTML_chordbase::writerList($option, $rows, $search, $pageNav);
}
