savePoll($option); break; case "remove": removePoll($cid, $option); break; case "publish": publishPolls($cid, 1, $option); break; case "unpublish": publishPolls($cid, 0, $option); break; case "cancel": cancelPoll($option); break; default: showPolls($option); break; } 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()) {
<?php require_once 'config.php'; require 'design_head.php'; echo '<h1>Site polls</h1>'; showPolls(POLL_SITE); require 'design_foot.php';