Просмотр файла online.php

<?php
error_reporting(0);
$urls='online.php';
$ttl='| Кто-Где?';
include("config.php");
include("./includes/".$ver."/banned");

list($msec, $sec) = explode(chr(32), microtime()); 
$headtime = $sec + $msec;

$ref = rand(0, 999999999);

header ("Content-type: text/html; charset=utf-8");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-cache, must-relative");
include("./template/head.php");
//AUTH
$q = mysql_query("SELECT * FROM `chat_users` WHERE `id` = '".$id."' AND `password` = '".$password."';");
	if(mysql_num_rows($q) == 0)
	{
	include("./reginc.php");
  include("./template/foot.php");
	exit();
	}
//END AUTH

//USER DATA
$user = mysql_fetch_array($q);
$level = $user['level'];
$status = $user['status'];
$posts = $user['posts'];
$fsize = $user['fsize'];
//END USER DATA

if($fsize == 0)
{
$fsize = "small";
}
if($fsize == 1)
{
$fsize = "normal";
}
if($fsize == 2)
{
$fsize = "large";
}

/*
//ONLINE
$online = time() + 60;
$update = mysql_query("UPDATE `chat_users` SET `time` = '".$online."', `place` = 0, `ip` = '".getenv('REMOTE_ADDR')."', `ua` = '".htmlspecialchars(getenv('HTTP_USER_AGENT'))."' WHERE `id` = '".$id."';");
//END ONLINE
*/

//ONLINE IN CHAT
$query = mysql_query("SELECT COUNT(*) FROM `chat_users` WHERE `time` > ".time().";");
$online = mysql_result($query, 0);
//END ONLINE


//PUBLIC ROOMS
$q = mysql_query("SELECT * FROM `chat_rooms` WHERE `type` = 0 ORDER BY `position` ASC, `id` DESC;");

$in_embassies = 0;

$sql = mysql_query("SELECT `id` FROM `chat_rooms` WHERE `type` = 2;");

while($array = mysql_fetch_array($sql))
{
$rid = $array['id'];

$query = mysql_query("SELECT COUNT(*) FROM `chat_users` WHERE `time` > ".time()." AND `place` = '".$rid."';");
$in_embassies = $in_embassies + mysql_result($query, 0);
}

//echo "<a href=\"embassies.php?rid=$rid\">Посольства (".$in_embassies.")</a><br/>";

while($room = mysql_fetch_array($q))
{
$c = 0;
$rid = $room['id'];
$rname = $room['name'];
$query = mysql_query("SELECT COUNT(*) FROM `chat_users` WHERE `place` = ".$rid." AND `time` > ".time().";");
$inroom = mysql_result($query, 0);
	if($rid == $wicked_quiz or $rid == $unlim)
	{
	echo "<a href=\"unlim.php?rid=$rid\">".$rname." (".$inroom.")</a><br/>\n";
	}
	else
	{
	echo "<a href=\"room.php?rid=$rid\">".$rname." (".$inroom.")</a><br/>\n";
	}
$sql = mysql_query("SELECT `nickname`, `invisible` FROM `chat_users` WHERE `time` > '".time()."' AND `place` = ".$rid.";");
	while($nick = mysql_fetch_array($sql))
	{
	if($level == 0 && $nick['invisible'] == 1) echo " ";
	else echo $nick['nickname'];
	if($level == 4 && $nick['invisible'] == 1) echo " (невидимый)";
	$c++;
		if($c != $inroom)
		{
		echo ", ";
		}
		else
		{
		echo "<br/>\n";
		}
	}
}
//END ROOMS

if(mysql_num_rows($q) == 0)
{
echo "[Пусто]<br/>\n";
}

echo "---<br/>\n";

//ROOMS FOR MODERATORS
if($level != 0)
{
$q = mysql_query("SELECT * FROM `chat_rooms` WHERE `type` = 1 ORDER BY `position` ASC;");

$count_rooms = 0;

while($room = mysql_fetch_array($q))
{
$c = 0;
$rid = $room['id'];
$rname = $room['name'];
$query = mysql_query("SELECT COUNT(*) FROM `chat_users` WHERE `place` = ".$rid.";");
$inroom = mysql_result($query, 0);
echo "<a href=\"room.php?rid=$rid&amp;ref=$ref\">".$rname." (".$inroom.")</a><br/>\n";
$sql = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `time` > '".time()."' AND `place` = ".$rid.";");
	while($nick = mysql_fetch_array($sql))
	{
	echo $nick['nickname'];
	$c++;
		if($c != $inroom)
		{
		echo ", ";
		}
		else
		{
		echo "<br/>\n";
		}
	}
$count_rooms++;
if(mysql_num_rows($sql) != 0) echo "<br/>\n";
}

	if($count_rooms != 0)
	{
	echo "---<br/>\n";
	}
}
//END ROOMS

$q = mysql_query("SELECT COUNT(*) FROM `chat_users` WHERE `time` > '".time()."' AND `place` = 0;");
$inmenu = mysql_result($q, 0);
$q = mysql_query("SELECT `nickname` FROM `chat_users` WHERE `time` > '".time()."' AND `place` = 0;");

echo "В меню: ".$inmenu."<br/>\n";
$c = 0;
while($nick = mysql_fetch_array($q))
{
echo $nick['nickname'];
$c++;
	if($c != $inmenu)
	{
	echo ", ";
	}
	else
	{
	echo "<br/>\n";
	}
}

echo "<a href=\"index.php\">Прихожая</a><br/>\n";
include("./template/foot.php");
break;
?>