function showPolls($option)
{
global $database, $mainframe, $mosConfig_list_limit;
$limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit);
$limitstart = $mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0);
$database->setQuery("SELECT COUNT(*) FROM #__polls");
$total = $database->loadResult();
require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php';
$pageNav = new mosPageNav($total, $limitstart, $limit);
$query = "SELECT m.*, u.name AS editor," . "\n COUNT(d.id) AS numoptions" . "\n FROM #__polls AS m" . "\n LEFT JOIN #__users AS u ON u.id = m.checked_out" . "\n LEFT JOIN #__poll_data AS d ON d.pollid = m.id AND d.text <> ''" . "\n GROUP BY m.id" . "\n LIMIT {$pageNav->limitstart},{$pageNav->limit}";
$database->setQuery($query);
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
HTML_poll::showPolls($rows, $pageNav, $option);
}
