".$lang_polloverview['text_polls_overview']."\n");
print("\n" .
"| ".$lang_polloverview['col_id']." | ".$lang_polloverview['col_added']." | ".$lang_polloverview['col_question']." |
\n");
while ($poll = mysql_fetch_assoc($res))
{
$o = array($poll["option0"], $poll["option1"], $poll["option2"], $poll["option3"], $poll["option4"], $poll["option5"], $poll["option6"], $poll["option7"], $poll["option8"], $poll["option9"], $poll["option10"], $poll["option11"], $poll["option12"], $poll["option13"], $poll["option14"], $poll["option15"], $poll["option16"], $poll["option17"], $poll["option18"], $poll["option19"]);
$added = gettime($poll['added']);
print("| ".$poll['id']." | ".$added." | ".$poll['question']." |
\n");
}
print("
\n");
print("".$lang_polloverview['text_poll_question']."
\n");
print("| ".$lang_polloverview['col_option_no']." | ".$lang_polloverview['col_options']." |
\n");
foreach($o as $key=>$value) {
if($value != "")
print("| ".$key." | ".$value." |
\n");
}
print("
\n");
$count = get_row_count("pollanswers", "WHERE pollid = ".sqlesc($pollid)." AND selection < 20");
print("".$lang_polloverview['text_polls_user_overview']."
\n");
if ($count == 0) {
print("".$lang_polloverview['text_no_users_voted']."
");
}
else{
$perpage = 100;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, "?id=".$pollid."&");
$res2 = sql_query("SELECT pollanswers.*, users.username FROM pollanswers LEFT JOIN users ON pollanswers.userid = users.id WHERE pollid = ".sqlesc($pollid)." AND selection < 20 ORDER BY username ASC ".$limit) or sqlerr();
print($pagertop);
print("");
print("| ".$lang_polloverview['col_username']." | ".$lang_polloverview['col_selection']." |
\n");
while ($useras = mysql_fetch_assoc($res2))
{
$username = get_username($useras['userid']);
print("| ".$username." | ".$o[$useras['selection']]." |
\n");
}
print("
\n");
print($pagerbottom);
}
stdfoot();
}
else
{
$res = sql_query("SELECT id, added, question FROM polls ORDER BY id DESC") or sqlerr();
if (mysql_num_rows($res) == 0)
stderr($lang_polloverview['std_error'], $lang_polloverview['text_no_users_voted']);
stdhead($lang_polloverview['head_poll_overview']);
print("".$lang_polloverview['text_polls_overview']."
\n");
print("\n" .
"| ".$lang_polloverview['col_id']." | ".$lang_polloverview['col_added']." | ".$lang_polloverview['col_question']." |
\n");
while ($poll = mysql_fetch_assoc($res))
{
$added = gettime($poll['added']);
print("| ".$poll['id']." | ".$added." | ".$poll['question']." |
\n");
}
print("
\n");
stdfoot();
}
?>