示例#1
0
文件: admin.poll.php 项目: cwcw/cms
        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()) {
示例#2
0
<?php

require_once 'config.php';
require 'design_head.php';
echo '<h1>Site polls</h1>';
showPolls(POLL_SITE);
require 'design_foot.php';