$q=mysql_query("SELECT * FROM `chat_post` WHERE `room` = '".mysql_real_escape_string($room['id'])."' AND (`privat`='0'".(isset($user)?" OR `privat` = '".mysql_real_escape_string($user['id'])."'":null).") ORDER BY id DESC LIMIT 10");
while ($post = mysql_fetch_assoc($q))
{
$ank=get_user($post['id_user']);
echo "".online($ank['id'])." ";
echo output_text($post['msg'])."<br />n";
}
$room = (isset($_GET['id'])? intval($_GET['id']) : $user['id']);
$q = mysql_query("SELECT * FROM `user` WHERE `id` = $room LIMIT 1");
$room = (isset($_GET['id'])? intval($_GET['id']) : $user['id']);
$q = mysql_query("SELECT * FROM `user` WHERE `id` = $room LIMIT 1");
if (isset($_GET['id']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_rooms` WHERE `id` = '".intval($_GET['id'])."'"),0)==1)
{
$room=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_rooms` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"));
if (isset($user))mysql_query("INSERT INTO `chat_who` (`id_user`, `time`, `room`) values('".mysql_real_escape_string($user[id])."', '".mysql_real_escape_string($time)."', '".mysql_real_escape_string($room[id])."')");
if ($set['time_chat']!=0)header("Refresh: $set[time_chat]; url=/chat/room/$room[id]/".rand(1000,9999).'/'); // автообновление
$set['title']='Чат - '.htmlspecialchars($room['name']).' ('.mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_who` WHERE `room` = '".mysql_real_escape_string($room[id])."'"),0).')'; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
require 'inc/room.php';
}
if (isset($_GET['id']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_rooms` WHERE `id` = '".intval($_GET['id'])."'"),0)==1)
{
$room=mysql_fetch_assoc(mysql_query("SELECT * FROM `chat_rooms` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"));
if (isset($user))mysql_query("INSERT INTO `chat_who` (`id_user`, `time`, `room`) values('".mysql_real_escape_string($user[id])."', '".mysql_real_escape_string($time)."', '".mysql_real_escape_string($room[id])."')");
if ($set['time_chat']!=0)header("Refresh: $set[time_chat]; url=/chat/room/$room[id]/".rand(1000,9999).'/'); // автообновление
$set['title']='Чат - '.htmlspecialchars($room['name']).' ('.mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_who` WHERE `room` = '".mysql_real_escape_string($room[id])."'"),0).')'; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
require 'inc/room.php';
}