<?php
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
only_reg();
$set['title']='Quiz';
include_once '../sys/inc/thead.php';
title();
aut();
$vopr=15;
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `viktorina_users` WHERE `user` = '".$user['id']."' && `vopros` = '0'",$db),0)==0)
{
$query = "SELECT num from viktorina";
$sort=@mysql_query($query);
$count=mysql_num_rows($sort);
$countd=round($count/$vopr);
$sql_a="";
for($i=1; $i<=$vopr; $i++) {
$a=$i*$countd-$countd+1;
$b=$i*$countd;
$sql_a.="'".rand($a, $b)."', ";
}
$date_a=date("U");
$date_b=date("U");
$users=$user['id'];
$sql=mysql_query("INSERT INTO `viktorina_users` (user, ball, date_a, date_b, vopros, v1, v2, v3, v4, v5, v6, v7, v8, v9, v10, v11, v12, v13, v14, v15, o1, o2, o3, o4, o5, o6, o7, o8, o9, o10, o11, o12, o13, o14, o15, y1, y2, y3, y4, y5, y6, y7, y8, y9, y10, y11, y12, y13, y14, y15, yes, no)
values(
'$users', 0, '$date_a', '$date_b', 0, $sql_a 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
)");
echo mysql_error();
}
if(isset($_GET['page']) && $_GET['page'] =='end')
{
$otvok=0;
$otvno=15;
$ball=0;
$query = "SELECT * from viktorina_users WHERE user='$user[id]' && vopros=0 LIMIT 1;";
$sort=@mysql_query($query);
$row = @mysql_fetch_array($sort);
$time=$row["date_b"]-$row["date_a"];
echo '<div class="nav1">';
echo"<b>The passed time:</b> $time seconds<br />\n";
for($i=1; $i<=$vopr; $i++) {
$vp="v$i";
$op="o$i";
$sql_o="";
$query = "SELECT * from viktorina WHERE num='".$row["$vp"]."' LIMIT 1;";
$sort=@mysql_query($query);
$row2 = @mysql_fetch_array($sort);
$ops=$row["$op"];
$vps=$row2["otvet"];
if($ops==$vps) {
$otvok++;
$otvno--;
$ball+=50;
$sql_o.="y$i=1,";
}
else {
$ball-=10;
$sql_o.="y$i=0,";
}
}
if(300-$time > 0) { $ball+=300-$time; }
if($ball < 0) { $ball=0; }
echo"<b>Correct Answers</b> $otvok <br />\n";
echo"<b>False Answers</b> $otvno <br />\n";
echo"<b>Total Recruited</b> $ball <b>points</b><br />";
echo "</div>";
echo '<div class="foot">';
echo"<a href='index.php'>Top 10 Results</a><br />";
echo "</div>";
$date_b=date("U");
$sql="UPDATE viktorina_users SET
yes=$otvok,
no=$otvno,
ball=$ball,
vopros=1,
$sql_o
date_b=$date_b
WHERE user=\"$user[id]\" AND vopros=0";
$sql_ok=@mysql_query($sql);
}
else
{
if(isset($_POST["vopros"]) AND isset($_POST["vs"])) {
$vopros=addslashes($_POST["vopros"]);
$vs=round(addslashes($_POST["vs"]));
$date_b=date("U");
$sql="UPDATE `viktorina_users` SET $vopros='$vs', date_b=$date_b WHERE `user`='$user[id]' AND vopros=0";
mysql_query($sql);
}
$i=0;
$j=0;
$query = "SELECT * from viktorina_users WHERE `user` = '".$user['id']."' && `vopros` = '0' LIMIT 1;";
$sort=@mysql_query($query);
$row = @mysql_fetch_array($sort);
for($j=1; $j<=$vopr; $j++) {
if($row["o$j"]==0) { $i++; $v[$i]=$row["v$j"]; $nam[$i]="o$j"; }
}
if(isset($v[1])) {
$query = "SELECT * from viktorina WHERE num='$v[1]';";
$sort=@mysql_query($query);
$row = @mysql_fetch_array($sort);
echo "<form method='post' action='game.php?".rand(1,150)."'>\n";
echo "<input type='hidden' name='vopros' value='$nam[1]' />";
echo '<div class="nav1">';
echo"<img src='img/qs.jpg' /><br /><b>$row[vopros]</b><br />\n";
echo"<img src='img/a.png' /><label><input type='radio' name='vs' value='1' id='1' />$row[otvet1]</label><br />\n";
echo"<img src='img/b.png' /><label><input type='radio' name='vs' value='2' id='2' />$row[otvet2]</label><br />\n";
echo"<img src='img/c.png' /><label><input type='radio' name='vs' value='3' id='3' />$row[otvet3]</label><br />\n";
echo"<img src='img/d.png' /><label><input type='radio' name='vs' value='4' id='4' />$row[otvet4]</label><br />\n";
echo "<input type='submit' value='Next' />\n";
echo "</form>\n";
echo "</div>\n";
}
else
{
$count=mysql_num_rows(mysql_query("SELECT `num` from `viktorina_users` WHERE `user` = '".$user['id']."' && `vopros` = '0' LIMIT 1;"));
if($count==1)
{
echo"<meta http-equiv='refresh' content='1; url=game.php?page=end&".rand(1,150)."' />The poll is over, we are summarizing the results.";
}
else
{
echo"<meta http-equiv='refresh' content='2; url=index.php' />An error occurred please try again later "; }
}
}
include_once '../sys/inc/tfoot.php';
?>