<?
$resul = mysql_query("SELECT * FROM `players_the_game` WHERE `username`='{$_SESSION['user']}' and `passw`='{$_SESSION['pass']}' and `email`='{$_SESSION['email']}' LIMIT 1");
$result = mysql_fetch_array($resul);
$my_loc = $result['locations'];
$resul1 = mysql_query("SELECT * FROM `locations` WHERE `id`='{$my_loc}' LIMIT 1");
$result1 = mysql_fetch_array($resul1);
// считаем сколько онлайн
$sql1='select SQL_CALC_FOUND_ROWS * from `online`';
$res1=mysql_query($sql1);
$count_online=mysql_num_rows($res1);
$on="1";
$base = mysql_query("SELECT COUNT(*) FROM `players_the_game` WHERE `locations`='{$my_loc}' and `on_or_off`='{$on}'");
$row = mysql_fetch_array($base);
$posts = $row[0];
$onli = '1';
$base_d = mysql_query("SELECT COUNT(*) FROM `players_the_game` WHERE `on_or_off`='{$onli}'");
$rowes = mysql_fetch_array($base_d);
$online = $rowes[0];
?>
<!DOCTYPE HTML>
<html>
<head>
<link href=still/poke-x_game.css rel=Stylesheet type=text/css>
<script type="text/javascript">
setTimeout("window.location.reload()",10000);
</script>
<script type="text/javascript">
window.frames['_locations'].location.reload();alert("wtf");
</script>
</head>
<body>
<div id=online><div id=online_t>
<center>
<i><? echo $result1['loc_name'];?><br>В игре: <? echo $online; ?> из них в этой локации: <? echo $posts; ?> <br>
</center>
<?
$resul = mysql_query("SELECT * FROM `players_the_game` WHERE `locations`='{$my_loc}' and `on_or_off`='{$on}'");
while ($result = mysql_fetch_array($resul)){ ?>
<a href='http://poke-x.ru/game.php?the=trener_info&id=<? echo $result['ID'];?>' onclick="window.open('http://poke-x.ru/game.php?the=trener_info&id=<? echo $result['ID'];?>', 'trener_info', 'fullscreen=no,scrollbars=yes,width=400,height=600'); return false;" ><img src='images/online.png' border='0'></a><img src='images/gender<? echo $result['gender'];?>.png' border='0'><font color=<? echo $result['colors_chat'];?>><? echo $result['username'];?> <? if($_SESSION['user']==$result['username']){echo '( Вы )';}else{}?></font><br>
<?}?>
</div></div>
</body>
</html>
