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 '
';
}
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 '
';
}