Файл: region_clean/who.php
Строк: 206
<?
#######################################
## Mod By KoT (borispol) [76-75-072] ##
#######################################
require_once "start.php";
require_once "sid.php";
header("Cache-Control: no-cache");
if ($ver == "wml") header ("Content-type:text/vnd.wap.wml; charset=utf-8");
else header("Content-Type:text/html; charset=UTF-8");
require_once "inc.php";
$link = connect_db();
list($row, $id, $ps, $fsize1, $fsize2) = check_login($link);
require_once "version.php";
for ($n = 0; $n <= 12; $n++) {
$room = "room" . $n;
$tm = time() - 100;
$r = mysql_query ("Select usid,who from $room WHERE usid != '1' and usid != '2' and usid != '3' and usid != '4' and usid != '5' and usid != '6' and usid != '7' and usid != '8' and usid != '9' and usid != '11' and id > '".$tm."' group by usid order by id desc;");
$asnum = mysql_affected_rows();
$siz[$n] = $asnum;
@$kol = $kol + $asnum;
}
for ($s = 13; $s <= 22; $s++) {
$room = "room" . $s;
$tmr = time() - 100;
$pr = mysql_query ("Select usid,who from $room WHERE usid != '1' and usid != '2' and usid != '3' and usid != '4' and usid != '5' and usid != '6' and usid != '7' and usid != '8' and usid != '9' and usid != '11' and id > '".$tmr."' group by usid order by id desc;");
$asnums = mysql_affected_rows();
$sizn[$s] = $asnums;
@$kolp = $kolp + $asnums;
}
$pr_count = mysql_query("SELECT * FROM users WHERE onl> '".$tm ."' AND room='holl' group by user order by onl desc;");
$asnumspr = mysql_affected_rows();
@$kolpr = $kolpr + $asnumspr;
$f_count = mysql_query("SELECT * FROM users WHERE onl> '".$tm ."' AND room='forum' group by user order by onl desc;");
$asnumspr = mysql_affected_rows();
@$kolf = $kolf + $asnumspr;
$tm = time() - 100;
$r = mysql_query ("Select usid,who from room23 WHERE id > '".$tm."' group by usid order by id desc;");
$asnum3 = mysql_affected_rows();
$kols = $kol + $kolp + $kolpr + $kolf + $asnum3;
$f_count = mysql_query("SELECT * FROM users WHERE onl> '".$tm ."' AND room='forum' group by user order by onl desc;");
$asnumspr = mysql_affected_rows();
@$kolf = $kolf + $asnumspr;
if ($ver == "wml") {
echo $xml;
echo $dtd;
echo "<wml>
<head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
<card id="who" title="Кто где?(".$kols.")">
<p align="left">";
} else {
echo "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link rel="stylesheet" type="text/css" href="css/$css.css"/>
<title>Кто где?(".$kols.")</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/></head><body>
<div align="left">";
}
echo $fsize1;
echo "<div class = 'c4'>Кто где?(".$kols.")</div><br/>n";
$tm = time() - 100;
$ingame = '';
$outgame = '';
$res = mysql_query ("Select * from room23 WHERE id > '".$tm."' and usid !='1' and usid !='2' and usid !='3' and usid !='4' and usid !='5' and usid !='6' and usid !='7' and usid !='8' and usid !='9' and usid != '11' group by usid order by id desc");
$kolm = mysql_affected_rows();
for ($k = 0; $k < $kolm; $k++) {
$lines = mysql_fetch_array ($res);
$user = $lines['who'];
$user_id = $lines['usid'];
$r = mysql_query("select * from ingame23 WHERE gamer_id = '".$user_id."'");
$a = mysql_fetch_array($r);
$id_in_game = $a['id_in_game'];
if (mysql_affected_rows() != 0) $ingame = $ingame . col_n($user) . "($id_in_game), ";
else $outgame = $outgame . col_n($user) . ", ";
}
unset($lines);
$roommaf = mysql_fetch_array(mysql_query ("Select name from rooms where rm='23' LIMIT 1;"));
echo "<a href="chat.php?$ses&rm=23&ref=$ref">".$roommaf[0]."(".($kolm)."):</a><br/>n
<b>В игре:</b><br/>n
" .$ingame. "<br/>n
<b>Вне игры:</b><br/>n
" .$outgame. "<br/>n";
echo $divide;
$tttimedf = time();
$fpsdf = $tttimedf - 100;
$rdf = mysql_query("SELECT count(`id`) FROM `users` WHERE lastdate>='" . intval($fpsdf) . "';");
$cdf = mysql_fetch_row($rdf);
$count = $cdf[0];
if ((($count%10 == 2) || ($count%10 == 3) || ($count%10 == 4)) && ($count/10) != 1);
echo "<a href="forum/index.php?$ses&ref=$ref">Форум(" .$count. ")</a><br/>";
echo $divide;
echo "<a href="pos.php?$ses">Посольства(".($kolp)."):</a><br/>
---<br/>n";
if ($row['level'] >= 7) {
$tm = time() - 100;
$pr_count = mysql_query("SELECT * FROM users WHERE onl> '".$tm ."' AND room='letters' group by user order by onl desc;");
$kol = mysql_affected_rows();
echo "<a href="chatmail.php?$ses">Записки(".($kol)."):</a><br/>";
for ($k = 0; $k < $kol; $k++)
{
$pdc = mysql_fetch_array($pr_count);
$user = $pdc['user'];
$nk = $pdc['id'];
echo col_n($user);
if (($k + 1) != $kol) echo ', ';
}
if ($kol > 0) echo '<br/>';
unset($pdc);
echo '- - -<br/>';
}
$roomselect = mysql_query("Select name,rm,vid from rooms order by pos limit 0,14;");
while($rooms = mysql_fetch_assoc($roomselect)) {
$roomname = $rooms['name'];
$rms = $rooms['rm'];
$vid = $rooms['vid'];
$room = "room" . $rms;
$tm = time() - 100;
if ($rms == 10) $res = mysql_query ("Select who,hid,pwd,usid from $room WHERE id > '".$tm."' group by who order by id desc;");
else $res = mysql_query ("Select who,hid,usid from $room WHERE usid != '1' and usid != '2' and usid != '3' and usid != '4' and usid != '5' and usid != '6' and usid != '7' and usid != '8' and usid != '9' and usid != '11' and id > '".$tm."' group by who order by id desc;");
echo mysql_error();
$kol = mysql_affected_rows();
$siz[$rms] = $kol;
if ($vid == 1) {
if ($rms == 13) {
if ($row['level'] >= 7) {
echo "<a href="inkognito.php?$ses&rm=$rms">$roomname($siz[$rms]):</a><br/>";
} else {
echo "<a href="inkognito.php?$ses&rm=$rms">$roomname($siz[$rms]):</a><br/>";
}
}
elseif ($rms == 9) {
echo "<a href="anlim.php?$ses&rm=$rms&ref=$ref">$roomname($siz[$rms]):</a><br/>";
}
elseif ($rms == 11) {
echo "<a href="klaznet.php?$ses&rm=$rms&ref=$ref">$roomname($siz[$rms]):</a><br/>";
}
elseif ($rms == 10) {
if ($row['level'] >= 7) echo "<b><a href="intim.php?$ses&rm=$rms&ref=$ref">$roomname($siz[$rms]):</a></b><br/>";
}
elseif ($rms == 8) {
if ($row['level'] > 3) echo "<b><a href="chat.php?$ses&rm=$rms&ref=$ref">$roomname($siz[$rms]):</a></b><br/>";
} else {
echo "<a href="chat.php?$ses&rm=$rms&ref=$ref">$roomname($siz[$rms]):</a><br/>";
}
if ($rms == 13) {
for ($k = 0; $k < $kol; $k++) {
$lines = mysql_fetch_array ($res);
$user = $lines['who'];
$nk = $lines['usid'];
$hd = $lines['hid'];
if ($hd != 1 and $row['level'] >= 7) echo col_n($user);
elseif ($row['level'] >= 7) echo col_n($user) . '(i)';
else echo 'Аноним';
if (($k+1) != $kol) echo ', ';
}
if ($kol > 0) echo '<br/>';
unset($lines);
}
elseif ($rms != 10) {
for ($k = 0; $k < $kol; $k++) {
$lines = mysql_fetch_array ($res);
$user = $lines['who'];
$nk = $lines['usid'];
$hd = $lines['hid'];
if ($hd != 1) echo col_n($user);
elseif ($row['level'] >= 7) echo col_n($user) . '(i)';
if (($k+1) != $kol) echo ', ';
}
if ($kol > 0) echo '<br/>';
unset($lines);
} else {
if ($row['level'] >= 7) {
for ($k = 0; $k < $kol; $k++) {
$lines = mysql_fetch_array ($res);
$user = $lines['who'];
$nk = $lines['usid'];
$hd = $lines['hid'];
$pwd = $lines['pwd'];
if ($hd != 1) echo col_n($user) . "($pwd)";
else echo col_n($user) . "(!)($pwd)";
if (($k + 1) != $kol) echo ', ';
}
if ($kol > 0) echo '<br/>';
unset($lines);
}
}
}
}
echo '- - -<br/>';
$tm = time() - 100;
$pr_count = mysql_query("SELECT * FROM users WHERE onl> '".$tm ."' AND room='holl' group by user order by onl desc;");
$kolpr = mysql_affected_rows();
echo "<a href="enter.php?$ses">Прихожая(".($kolpr)."):</a><br/>";
for ($k = 0; $k < $kolpr; $k++)
{
$pdc = mysql_fetch_array($pr_count);
$user = $pdc['user'];
$inv = $pdc['inv'];
$nk = $pdc['id'];
if ($inv != 1) echo col_n($user);
elseif ($row['level'] > 6 ) echo col_n($user) . '(i)';
if (($k+1) != $kolpr) echo ', ';
}
if ($kolpr > 0) echo '<br/>';
echo '- - -<br/>';
if (isset ($rm)) {
if ($rm == 10) $takep="&pwd=$pwd";
else if ($mod == "privat") $takep="&mod=$mod";
else $takep = '';
echo $divide;
echo "<div class = 'd1'><a href="chat.php?$ses&rm=$rm$takep">В чат</a></div>n";
}
echo "<div class = 'd1'><a href="enter.php?$ses">Прихожая</a></div>n";
echo '<br/>';
echo $fsize2;
include_once 'foot.php';
mysql_close ($link);
?>