$hostname = "localhost";
$username = "vva";
$password = "olis34x";
$dbName = "uz_vva";
$userstable = "vict_crimea";
MYSQL_CONNECT($hostname,$username,$password) OR DIE("Не могу создать соединение ");
@mysql_select_db("$dbName") or die("Не могу выбрать базу данных ");
Srand(date("U"));
$l="0";
if ($l == '' )
{
include "vict_top.html";
PRINT '
Home';
exit;
}
if ($l == 0 )
{
$query = "SELECT * FROM $userstable";
$result = MYSQL_QUERY($query);
$k=MYSQL_NUMROWS($result);
$k--;
if ( $nq == '' ) {
$nq=0;
$v[0]=rand(0,$k);
$v[1]=rand(0,$k);
$v[2]=rand(0,$k);
$v[3]=rand(0,$k);
$v[4]=rand(0,$k);
while($v[1] == $v[0]) { $v[1]=rand(0,$k); };
while($v[2] == $v[0] || $v[2] == $v[1]) { $v[2]=rand(0,$k); };
while($v[3] == $v[0] || $v[3] == $v[1] || $v[3] == $v[2]) { $v[3]=rand(0,$k); };
while($v[4] == $v[0] || $v[4] == $v[1] || $v[4] == $v[2] || $v[4] == $v[3]) { $v[4]=rand(0,$k); };
};
$n[0]=$v[$nq];
$o[$nq - 1]=$otv;
#####
#$p=rand(0,4);
$p=rand(0,3); ##### UZ
#####
$n[1]=rand(0,$k);
$n[2]=rand(0,$k);
$n[3]=rand(0,$k);
while($n[0] == $n[1]) { $n[1]=rand(0,$k); }
while($n[1] == $n[2] || $n[0] == $n[2]) { $n[2]=rand(0,$k); }
while($n[2] == $n[3] || $n[1] == $n[3] || $n[0] == $n[3]) { $n[3]=rand(0,$k); }
#print "k=$k clas=$clas nq=$nq n0= $n[0] n1= $n[1] n2= $n[2] n3=$n[3] u=$u p=$p otv=$otv
";
#print "v0=$v[0] v1=$v[1] v2=$v[2] v3=$v[3] v4=$v[4]
";
#print "o0=$o[0] o1=$o[1] o2=$o[2] o3=$o[3] o4=$o[4]
";
} # end if $l == 0
IF ($nq == 5) {
$o[4]=$otv;
###$j=0;while ($j < 5) { PRINT "v[$j]=$v[$j] o[$j]=$o[$j]
"; $j++; }
include "vict_top.html";
PRINT "";
PRINT " | Вопрос | Ваш ответ | Правильный ответ | Ваш ответ |
";
$pr=0;$npr=0;
$j=0;while ($j < 5) {
$pic_s_v = mysql_result($result,$v[$j],"pic_s");
$pic_title[0] = mysql_result($result,$v[$j],"pic_title");
$town0 = mysql_result($result,$v[$j],"town");
IF ( $o[$j] != 777 ) {
$pic_s_o = mysql_result($result,$o[$j],"pic_s");
$pic_title[1] = mysql_result($result,$o[$j],"pic_title");
$town1 = mysql_result($result,$o[$j],"town");
}
ELSEIF ( $o[$j] == 777 ) { $pic_title[1]="Не знаю"; $pic_s_o="116.gif"; $town1="../img"; };
PRINT "";
IF ( $v[$j] == $o[$j] ) { $pr++; PRINT ":-) | "; }
ELSEIF ( $v[$j] != $o[$j] ) { $npr++; PRINT ":-( | "; }
PRINT " | | ";
PRINT "$pic_title[0] | $pic_title[1] |
";
$j++; };
PRINT " | | Вопросов: 5 | Правильных ответов: $pr | Не правильных ответов: $npr |
";
PRINT 'Home. Попробуйте еще раз';
include "vict_tail.html";
$userstable = "vict_res";
$dt=date("Y-m-d H:i:s");
$ip=getenv(REMOTE_ADDR);
$ip2=getenv(HTTP_X_FORWARDED_FOR);
$vop=$pr + $npr;
$query = "INSERT INTO $userstable (dt,ip,ip2,level,vict,res,vop)
VALUES ('$dt','$ip','$ip2','0','1','$pr','$vop')";
$result = MYSQL_QUERY($query);
mysql_close();
}
# if $nq == 5
ELSEIF ($nq != 5) {
$town = mysql_result($result,$n[0],"town");
$pic_title[0] = mysql_result($result,$n[0],"pic_title");
$pic_l = mysql_result($result,$n[0],"pic_l");
###$pic_help = mysql_result($result0,0,"pic_help");
$pic_h = mysql_result($result,$n[0],"pic_h");
$pic_w = mysql_result($result,$n[0],"pic_w");
$pic_title[1] = mysql_result($result,$n[1],"pic_title");
$pic_title[2] = mysql_result($result,$n[2],"pic_title");
$pic_title[3] = mysql_result($result,$n[3],"pic_title");
include "vict_top.html";
PRINT '
';
PRINT " |
";
$nq++;
PRINT "Вопрос $nq";
PRINT '
|
';
PRINT 'Home. Вернуться в начало';
include "vict_tail.html";
};
?>