if ($themes['type']==1) { if ($themes['us']==$us['id'] || $us['level']>$a['level']) { $query = core :: $dbs -> query ("SELECT * FROM `forum_opr` WHERE (`id_themes`='" . $themes['id'] . "')"); if ($query -> rowCount () == 0) { echo ' | Добавить опрос'; } } } echo ''; echo ''; $query = core :: $dbs -> query ("SELECT * FROM `forum_opr` WHERE (`id_themes`='" . $themes['id'] . "')"); if ($query -> rowCount () != 0) { $opr = $query -> fetch (); echo '
'; echo 'Вопрос: ' . $opr['vopros'] . ' (' . ($opr['type']==1?'открытое':'закрытое') . ' голосование)
'; if (core :: $dbs -> querySingle ("SELECT COUNT(*) FROM `forum_opr_votes` WHERE (`id_opr`='" . $opr['id'] . "') AND (`us`='" . $us['id'] . "')")==0) { if (isset ($_GET['opr_votes'])) { $_POST['otv'] = (int) $_POST['otv']; if (core :: $dbs -> querySingle ("SELECT COUNT(*) FROM `forum_opr_otv` WHERE (`id_opr`='" . $opr['id'] . "') AND (`id`=?)", array ($_POST['otv'])) == 0) { header ('location: /forum/thema' . $themes['id'] . '/page' . $page); exit; } core :: $dbs -> query ("INSERT INTO `forum_opr_votes` (`id_razd`,`id_podrazd`,`id_themes`,`id_opr`,`id_otv`,`us`,`t`) VALUES ('" . $razd['id'] . "', '" . $podrazd['id'] . "', '" . $themes['id'] . "', '" . $opr['id'] . "',?,'" . $us['id'] . "','" . time () . "')", array ($_POST['otv'])); header ('location: /forum/thema' . $themes['id'] . '/page' . $page); } echo '
'; echo '
'; echo ''; echo '
'; } else { $query = core :: $dbs -> query ("SELECT * FROM `forum_opr_otv` WHERE (`id_opr`='" . $opr['id'] . "')"); while ($otv = $query -> fetch ()) { echo '' . $otv['text'] . ' (голосов: ' . core :: $dbs -> querySingle ("SELECT COUNT(*) FROM `forum_opr_votes` WHERE (`id_opr`='" . $opr['id'] . "') AND (`id_otv`='" . $otv['id'] . "')") . ')
'; } if ($opr['type']==1) { echo '- Список проголосовавших
'; } } if ($a['id']==$us['id'] || $a['level']<$us['level']) { // if (isset ($_GET['delo'])) { core :: $dbs -> query ("DELETE FROM `forum_opr` WHERE (`id_themes`='" . $themes['id'] . "')"); core :: $dbs -> query ("DELETE FROM `forum_opr_otv` WHERE (`id_themes`='" . $themes['id'] . "')"); core :: $dbs -> query ("DELETE FROM `forum_opr_votes` WHERE (`id_themes`='" . $themes['id'] . "')"); header ('location: /forum/thema' . $themes['id'] . '/page' . $page); } echo '- Добавить | удалить варианты
'; echo '- Удалить опрос'; } echo '
'; }