View file embassies.php

<?php
error_reporting(0);
$urls='embassies.php';
include("config.php");
include("./includes/".$ver."/banned");

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

$nocache = 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

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

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);

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 EMBASSIES

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

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

$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;
?>