コード例 #1
0
ファイル: poll.php プロジェクト: BGCX067/f3site-svn-to-git
function ResetPoll($x = null)
{
    global $db;
    if (!is_numeric($x) && !($x = GetID(true))) {
        return false;
    }
    $db->exec('UPDATE ' . PRE . 'answers SET num=0 WHERE IDP IN (' . $x . ')');
    $db->exec('UPDATE ' . PRE . 'polls SET num=0 WHERE ID IN (' . $x . ')');
    $db->exec('DELETE FROM ' . PRE . 'pollvotes WHERE ID IN (' . $x . ')');
    RebuildPoll();
}
コード例 #2
0
        if (!$id) {
            $id = $db->lastInsertId();
        }
        #Insert answers
        $q1 = $db->prepare('UPDATE ' . PRE . 'answers SET a=?, seq=?, color=? WHERE ID=? AND IDP=?');
        $q2 = $db->prepare('INSERT INTO ' . PRE . 'answers (seq,IDP,a,color) VALUES (?,?,?,?)');
        for ($i = 0; $i < $num; $i++) {
            if ($an[$i][0]) {
                $q1->execute(array($an[$i][1], $i, $an[$i][2], $an[$i][0], $id));
            } elseif ($an[$i][1]) {
                $q2->execute(array($i, $id, $an[$i][1], $an[$i][2]));
            }
        }
        #Update cache of latest polls
        include './mod/polls/poll.php';
        RebuildPoll();
        #Apply changes
        $db->commit();
        $view->info($lang['saved'], array(url('editPoll', '', 'admin') => $lang['addPoll'], url('editPoll/' . $id, '', 'admin') => $lang['editPoll'], url('poll/' . $id) => $poll['name']));
        return 1;
    } catch (Exception $e) {
        $view->info($lang['error'] . $e);
    }
} elseif ($id) {
    if (!($poll = $db->query('SELECT * FROM ' . PRE . 'polls WHERE ID=' . $id)->fetch(2))) {
        return;
    }
    $an = $db->query('SELECT ID,a,color FROM ' . PRE . 'answers WHERE IDP=' . $id . ' ORDER BY seq')->fetchAll(3);
} else {
    $poll = array('name' => '', 'q' => '', 'type' => 1, 'ison' => 1, 'access' => LANG);
    $an = array(array(0, '', '#ed1c24'), array(0, '', '#22b14c'), array(0, '', '#3f48cc'));
コード例 #3
0
ファイル: install.php プロジェクト: BGCX067/f3site-svn-to-git
 function commit(&$data)
 {
     $cfg = array();
     Installer::$urlMode = $this->urls;
     #Content options - category IDs
     foreach ($this->catid as $lang => $id) {
         $cfg['start'][$lang] = $id;
     }
     require './cfg/content.php';
     $o = new Config('content');
     $o->save($cfg);
     $cfg = array();
     require './cfg/main.php';
     #Get Sblam! key
     if (function_exists('fsockopen')) {
         $key = @file_get_contents('http://sblam.com/keygen.html');
         $cfg['captcha'] = 1;
         $cfg['sbKey'] = $key ? $key : NULL;
     } else {
         $cfg['captcha'] = 0;
         $cfg['sbKey'] = NULL;
     }
     #Main options - page title and URL format
     $cfg['title'] = $this->title;
     $cfg['RSS'] = $this->rss;
     $o = new Config('main');
     $o->add('cfg', $cfg);
     $o->save();
     #Database access - db.php
     $this->buildConfig($data);
     #Rebuild polls
     if (file_exists('./mod/polls')) {
         include './mod/polls/poll.php';
         RebuildPoll(null, $this->db);
     }
     #Sort categories
     include './lib/categories.php';
     RebuildTree($this->db);
     RSS(null, $this->db);
     #Create menu cache
     include './lib/mcache.php';
     RenderMenu($this->db);
     #Finish :)
     $this->db->commit();
 }