<?
require "include/bittorrent.php";
dbconn();
loggedinorreturn();
if (get_user_class() < UC_MODERATOR)
stderr("Error","Permission denied.");
$action = $_GET["action"];
$pollid = $_GET["pollid"];
if ($action == "edit")
{
if (!is_valid_id($pollid))
stderr("Error","Invalid ID $pollid.");
$res = mysql_query("SELECT * FROM polls WHERE id = $pollid")
or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 0)
stderr("Error","No poll found with ID $pollid.");
$poll = mysql_fetch_array($res);
}
if ($_SERVER["REQUEST_METHOD"] == "POST")
{
$pollid = $_POST["pollid"];
$question = $_POST["question"];
$option0 = $_POST["option0"];
$option1 = $_POST["option1"];
$option2 = $_POST["option2"];
$option3 = $_POST["option3"];
$option4 = $_POST["option4"];
$option5 = $_POST["option5"];
$option6 = $_POST["option6"];
$option7 = $_POST["option7"];
$option8 = $_POST["option8"];
$option9 = $_POST["option9"];
$option10 = $_POST["option10"];
$option11 = $_POST["option11"];
$option12 = $_POST["option12"];
$option13 = $_POST["option13"];
$option14 = $_POST["option14"];
$option15 = $_POST["option15"];
$option16 = $_POST["option16"];
$option17 = $_POST["option17"];
$option18 = $_POST["option18"];
$option19 = $_POST["option19"];
$sort = $_POST["sort"];
$returnto = $_POST["returnto"];
if (!$question || !$option0 || !$option1)
stderr("Error", "Missing form data!");
if ($pollid)
mysql_query("UPDATE polls SET " .
"question = " . sqlesc($question) . ", " .
"option0 = " . sqlesc($option0) . ", " .
"option1 = " . sqlesc($option1) . ", " .
"option2 = " . sqlesc($option2) . ", " .
"option3 = " . sqlesc($option3) . ", " .
"option4 = " . sqlesc($option4) . ", " .
"option5 = " . sqlesc($option5) . ", " .
"option6 = " . sqlesc($option6) . ", " .
"option7 = " . sqlesc($option7) . ", " .
"option8 = " . sqlesc($option8) . ", " .
"option9 = " . sqlesc($option9) . ", " .
"option10 = " . sqlesc($option10) . ", " .
"option11 = " . sqlesc($option11) . ", " .
"option12 = " . sqlesc($option12) . ", " .
"option13 = " . sqlesc($option13) . ", " .
"option14 = " . sqlesc($option14) . ", " .
"option15 = " . sqlesc($option15) . ", " .
"option16 = " . sqlesc($option16) . ", " .
"option17 = " . sqlesc($option17) . ", " .
"option18 = " . sqlesc($option18) . ", " .
"option19 = " . sqlesc($option19) . ", " .
"sort = " . sqlesc($sort) . " " .
"WHERE id = $pollid") or sqlerr(__FILE__, __LINE__);
else
mysql_query("INSERT INTO polls VALUES(0" .
", '" . get_date_time() . "'" .
", " . sqlesc($question) .
", " . sqlesc($option0) .
", " . sqlesc($option1) .
", " . sqlesc($option2) .
", " . sqlesc($option3) .
", " . sqlesc($option4) .
", " . sqlesc($option5) .
", " . sqlesc($option6) .
", " . sqlesc($option7) .
", " . sqlesc($option8) .
", " . sqlesc($option9) .
", " . sqlesc($option10) .
", " . sqlesc($option11) .
", " . sqlesc($option12) .
", " . sqlesc($option13) .
", " . sqlesc($option14) .
", " . sqlesc($option15) .
", " . sqlesc($option16) .
", " . sqlesc($option17) .
", " . sqlesc($option18) .
", " . sqlesc($option19) .
", " . sqlesc($sort) .
")") or sqlerr(__FILE__, __LINE__);
if ($returnto == "main")
header("Location: $DEFAULTBASEURL");
elseif ($pollid)
header("Location: $DEFAULTBASEURL/polls.php#$pollid");
else
header("Location: $DEFAULTBASEURL");
die;
}
stdhead();
if ($pollid)
print("<h1>Edit poll</h1>");
else
{
// Warn if current poll is less than 3 days old
$res = mysql_query("SELECT question,added FROM polls ORDER BY added DESC LIMIT 1") or sqlerr();
$arr = mysql_fetch_assoc($res);
if ($arr)
{
$hours = floor((gmtime() - sql_timestamp_to_unix_timestamp($arr["added"])) / 3600);
$days = floor($hours / 24);
if ($days < 3)
{
$hours -= $days * 24;
if ($days)
$t = "$days day" . ($days > 1 ? "s" : "");
else
$t = "$hours hour" . ($hours > 1 ? "s" : "");
print("<p><font color=red><b>Note: The current poll (<i>" . $arr["question"] . "</i>) is only $t old.</b></font></p>");
}
}
print("<h1>Make poll</h1>");
}
?>
<table border=1 cellspacing=0 cellpadding=5>
<form method=post action=makepoll.php>
<tr><td class=rowhead>Question <font color=red>*</font></td><td align=left><input name=question size=80 maxlength=255 value="<?=$poll['question']?>"></td></tr>
<tr><td class=rowhead>Option 1 <font color=red>*</font></td><td align=left><input name=option0 size=80 maxlength=40 value="<?=$poll['option0']?>"><br></td></tr>
<tr><td class=rowhead>Option 2 <font color=red>*</font></td><td align=left><input name=option1 size=80 maxlength=40 value="<?=$poll['option1']?>"><br></td></tr>
<tr><td class=rowhead>Option 3</td><td align=left><input name=option2 size=80 maxlength=40 value="<?=$poll['option2']?>"><br></td></tr>
<tr><td class=rowhead>Option 4</td><td align=left><input name=option3 size=80 maxlength=40 value="<?=$poll['option3']?>"><br></td></tr>
<tr><td class=rowhead>Option 5</td><td align=left><input name=option4 size=80 maxlength=40 value="<?=$poll['option4']?>"><br></td></tr>
<tr><td class=rowhead>Option 6</td><td align=left><input name=option5 size=80 maxlength=40 value="<?=$poll['option5']?>"><br></td></tr>
<tr><td class=rowhead>Option 7</td><td align=left><input name=option6 size=80 maxlength=40 value="<?=$poll['option6']?>"><br></td></tr>
<tr><td class=rowhead>Option 8</td><td align=left><input name=option7 size=80 maxlength=40 value="<?=$poll['option7']?>"><br></td></tr>
<tr><td class=rowhead>Option 9</td><td align=left><input name=option8 size=80 maxlength=40 value="<?=$poll['option8']?>"><br></td></tr>
<tr><td class=rowhead>Option 10</td><td align=left><input name=option9 size=80 maxlength=40 value="<?=$poll['option9']?>"><br></td></tr>
<tr><td class=rowhead>Option 11</td><td align=left><input name=option10 size=80 maxlength=40 value="<?=$poll['option10']?>"><br></td></tr>
<tr><td class=rowhead>Option 12</td><td align=left><input name=option11 size=80 maxlength=40 value="<?=$poll['option11']?>"><br></td></tr>
<tr><td class=rowhead>Option 13</td><td align=left><input name=option12 size=80 maxlength=40 value="<?=$poll['option12']?>"><br></td></tr>
<tr><td class=rowhead>Option 14</td><td align=left><input name=option13 size=80 maxlength=40 value="<?=$poll['option13']?>"><br></td></tr>
<tr><td class=rowhead>Option 15</td><td align=left><input name=option14 size=80 maxlength=40 value="<?=$poll['option14']?>"><br></td></tr>
<tr><td class=rowhead>Option 16</td><td align=left><input name=option15 size=80 maxlength=40 value="<?=$poll['option15']?>"><br></td></tr>
<tr><td class=rowhead>Option 17</td><td align=left><input name=option16 size=80 maxlength=40 value="<?=$poll['option16']?>"><br></td></tr>
<tr><td class=rowhead>Option 18</td><td align=left><input name=option17 size=80 maxlength=40 value="<?=$poll['option17']?>"><br></td></tr>
<tr><td class=rowhead>Option 19</td><td align=left><input name=option18 size=80 maxlength=40 value="<?=$poll['option18']?>"><br></td></tr>
<tr><td class=rowhead>Option 20</td><td align=left><input name=option19 size=80 maxlength=40 value="<?=$poll['option19']?>"><br></td></tr>
<tr><td class=rowhead>Sort</td><td>
<input type=radio name=sort value=yes <?=$poll["sort"] != "no" ? " checked" : "" ?>>Yes
<input type=radio name=sort value=no <?=$poll["sort"] == "no" ? " checked" : "" ?>> No
</td></tr>
<tr><td colspan=2 align=center><input type=submit value=<?=$pollid?"'Edit poll'":"'Create poll'"?> style='height: 20pt'></td></tr>
</table>
<p><font color=red>*</font> required</p>
<input type=hidden name=pollid value=<?=$poll["id"]?>>
<input type=hidden name=returnto value=<?=$_GET["returnto"]?>>
</form>
<? stdfoot(); ?>