View file stat.php

<?
session_start(); //инициализирум механизм сесссий
include 'include/stat.php';
include 'include/sys.php';
include 'include/game.php';

$vamp = mysql_fetch_assoc(count_query("SELECT  sum(stat_prey), count(*), sum(gold), sum(stat_win), sum(stat_victim)
FROM user
WHERE race=1"));

$obor = mysql_fetch_assoc(count_query("SELECT  sum(stat_prey), count(*), sum(gold), sum(stat_win), sum(stat_victim)
FROM user
WHERE race=2"));

include 'include/head.php';
include 'include/menu.php';
?>

<div class="in">Статистика</div>


<div class="link">
<?=$vamp['count(*)'];?> Вампиры
<br>Добыча: <?=$vamp['sum(stat_prey)'];?> л. крови
<br>Жертвы: <?=$vamp['sum(stat_victim)'];?>
<br>Бои: <?=$vamp['sum(stat_win)'];?>
<br>Золото: <?=rez($vamp['sum(gold)']);?>
</div>
<div class="link">
<?=$obor['count(*)'];?> Оборотни
<br>Добыча: <?=$obor['sum(stat_prey)'];?> кг. мяса
<br>Жертвы: <?=$obor['sum(stat_victim)'];?>
<br>Бои: <?=$obor['sum(stat_win)'];?>
<br>Золото: <?=rez($obor['sum(gold)']);?> </div>
<?include 'include/foot.php';?>