72 lines
3.2 KiB
PHP
72 lines
3.2 KiB
PHP
<?
|
||
defined('AntiBK') or die("Доступ запрещен!");
|
||
|
||
$dat = $adb->selectRow("SELECT * FROM `city_stella_main` WHERE `city` = ?s", $city);
|
||
$state = $adb->selectCell("SELECT `state` FROM `character_info` WHERE `guid` = ?d", $guid);
|
||
$open = ($dat['open']) ?"Голосование открыто" :"Голосование окончено";
|
||
|
||
if (isset($_POST['vote']) && $level >= $dat['min_level'] && $char_db['vote'] > 0 && $state == $dat['city'])
|
||
{
|
||
$quest = $adb->selectCell("SELECT `answer` FROM `city_stella_question` WHERE `id` = ?d and `question` = ?d", $_POST['stella'] ,$dat['id']);
|
||
$chat->say($guid, "Вы выбрали ответ: <b>$quest</b> - спасибо что проголосавали");
|
||
$adb->query("UPDATE `characters` SET `vote` = `vote` - '1' WHERE `guid` = ?d", $guid);
|
||
$adb->query("UPDATE `city_stella_question` SET `count` = `count` + '1' WHERE `id` = ?d and `question` = ?d", $_POST['stella'] ,$dat['id']);
|
||
}
|
||
$vote = $adb->selectCell("SELECT `vote` FROM `characters` WHERE `guid` = ?d", $guid);
|
||
?>
|
||
<script src="scripts/move_check.js" type="text/javascript"></script>
|
||
<table width="100%" border="0" cellpadding="0" cellspacing="1">
|
||
<tr>
|
||
<td><h3>Голосование</h3></td>
|
||
<td align="right">
|
||
<?getUpdateBar();?>
|
||
<table width="148" border="0" cellpadding="0" cellspacing="1" bgcolor="#DEDEDE">
|
||
<tr>
|
||
<td bgcolor="#D3D3D3"><img src="img/links.gif" width="9" height="7" /></td>
|
||
<td bgcolor="#D3D3D3" nowrap><a href="main.php?action=go&room_go=centsquare" class="passage" alt="<?echo $char->city->getRoomOnline('centsquare', 'mini');?>">Центральная Площадь</a></td>
|
||
</tr>
|
||
</table>
|
||
</td>
|
||
</tr>
|
||
</table>
|
||
<br>
|
||
<table width="98%" border="0" cellpadding="0" cellspacing="1" align="center"><td>
|
||
<form name="vote" method="post">
|
||
<?
|
||
$rows = $adb->select("SELECT `id`,
|
||
`answer`,
|
||
`count`
|
||
FROM `city_stella_question`
|
||
WHERE `question` = ?d ORDER BY `id`", $dat['id']);
|
||
$count = $adb->selectCell("SELECT SUM(count) FROM `city_stella_question` WHERE `question` = ?d ORDER BY `id`", $dat['id']);
|
||
echo "<fieldset><legend><b>$dat[question]</b></legend>";
|
||
if ($vote > 0 && $level > $dat['min_level'] && $state == $dat['city'])
|
||
{
|
||
foreach ($rows as $answers)
|
||
{
|
||
$id = $answers['id'];
|
||
echo "<input type='radio' name='stella' value='$id' id='$id' align='center'><b><label for='$id'>$answers[answer]</label></b><br>";
|
||
}
|
||
echo "<br> <input type='submit' name='vote' value='Голосовать' size='30' class='new'>";
|
||
}
|
||
else
|
||
{
|
||
foreach ($rows as $answers)
|
||
{
|
||
$p = rdf(($answers['count'] / $count) * 100);
|
||
echo " <b>$answers[answer]</b> ($p%)<br>";
|
||
}
|
||
}
|
||
?>
|
||
</fieldset>
|
||
</form>
|
||
</td></tr></table>
|
||
</div>
|
||
<?
|
||
echo "Всего голосов: $count<br>";
|
||
echo "Время голосования: <b>$open</b><br>";
|
||
echo "Минимальный уровень: $dat[min_level]<br>";
|
||
echo "Можете голосовать раз: $vote<br>";
|
||
?>
|
||
<br><br>
|
||
Голосовать имеют право лишь лица достигшие указанного уровня, родившиеся в городе, где проводится голосование.
|