$ipok="212.35.161.2";
$ref=getenv(HTTP_REFERER);
$radr=getenv(REMOTE_ADDR);
#print "radr=$radr ref=$ref
";
#if ( $radr != $ipok ) { exit; };
$hostname = "localhost";
$username = "vva";
$password = "olis34x";
$dbName = "uz_vva";
$userstable = "vict_res";
MYSQL_CONNECT($hostname,$username,$password) OR DIE("Не могу создать соединение ");
@mysql_select_db("$dbName") or die("Не могу выбрать базу данных ");
print '
Admin
';
$i=0;while ( $i < 2 ) {
$query = "SELECT level,vict,avg(res) from $userstable WHERE level=$i group by vict order by 2 ASC";
$result = MYSQL_QUERY($query);
echo '';
while(($rs=mysql_fetch_array($result))){
$p=sprintf("%4.2f",$rs[2]*20);
echo "$rs[0] | $rs[1] | $p% |
";
#echo "$l | $v | $p |
";
}; # while
echo "
";
$i++;
}; # while i<2
$query = "SELECT id from $userstable WHERE level = 0 and vict = 1";
$result = MYSQL_QUERY($query);
$k = MYSQL_NUMROWS($result);
print "0 1 $k
";
$query = "SELECT id from $userstable WHERE level = 1 and vict = 1";
$result = MYSQL_QUERY($query);
$k = MYSQL_NUMROWS($result);
print "1 1 $k
";
$query = "SELECT id from $userstable WHERE level = 1 and vict = 2";
$result = MYSQL_QUERY($query);
$k = MYSQL_NUMROWS($result);
print "1 2 $k
";
mysql_close();
print '';
?>