";
echo " ";
echo "";
$chats = array();
$chatc = array();
$tomy = False;
$userstable = "chat";
$userstable1 = "regtab";
$query = "SELECT Fraza, Room, Dates, Times, 4ID, ChID FROM `$userstable` WHERE (Room = '$rom' or Room = '1' or Room = '2' or Room = '3' or Room = '4') ORDER BY Dates DESC, Times DESC, 4ID DESC";
//Значение параметров Room
//'1' - приватное однопользовательское
//'2' - приватное многопользовательское
//'3' - приватно-общественное однопользовательское
//'4' - приватно-общественное многопользовательское
$ath = mysql_query($query) or die(mysql_error());
$nid = 0;
while($author = mysql_fetch_array($ath) and $nid < $kol_str_in_chat)
{
$cid = $author['ChID'];
$times = $author['Times'];
$texts = $author['Fraza'];
$rooms = $author['Room'];
$query1 = "SELECT Nick FROM `$userstable1` WHERE ID = $cid";
$ath1 = mysql_query($query1) or die(mysql_error());
if($ath1)
{
$author1 = mysql_fetch_array($ath1);
$nickk = $author1['Nick'];
}
if ((int)$rooms == 0)//проверка - если первый символ не цифра - выдаст 0, т.е. текст в общак в комнату
{
$chats[$nid] = $times.": ".$nickk." >> ".$texts."
";
$chatc[$nid] = $rom;
}
else if ((int)$rooms == 1 or (int)$rooms == 3)
{
$fromf = strpos($texts, "%");
$froml = strrpos($texts, "%");
$froms = (int)substr($texts, $fromf+1, $froml-1);
$texts = substr($texts, $froml+1);
$query1 = "SELECT Nick FROM $userstable1 WHERE ID = $froms";
$ath1 = mysql_query($query1) or die(mysql_error());
if($ath1)
{
$author1 = mysql_fetch_array($ath1);
$nickt = $author1['Nick'];
}
if ((int)$rooms == 3)
{
$chats[$nid] = $times.": ".$nickk." для ".$nickt." :".$texts."
";
$chatc[$nid] = 3;
}
else if ($froms == $id)
{
$chats[$nid] = $times.": ".$nickk." для ".$nickt." :".$texts."
";
$chatc[$nid] = 1;
}
else
{ $nid--; }
}
else if ((int)$rooms == 2 or (int)$rooms == 4)
{
$fraza = "";
$kl = 1;
$ffraza = $texts;
$i = strrpos($ffraza, "%");
$texts = substr($texts, $i+1);
$lfraza = strlen($texts);
while ($lfraza < strlen($ffraza))
{
$i = strpos($ffraza, "%");
if ((int)($kl/2) == $kl/2)
{
$id_ch = (int)(substr($ffraza, 0, $i));
$query1 = "SELECT Nick FROM $userstable1 WHERE ID = $id_ch";
$ath1 = mysql_query($query1) or die(mysql_error());
if($ath1)
{
$author1 = mysql_fetch_array($ath1);
if ($kl<3) {$fraza = $fraza. $author1['Nick'];}
else {$fraza = $fraza."; ".$author1['Nick'];}
}
if ($id_ch == $id)
{
$tomy = True;
}
}
$ffraza = substr($ffraza, $i+1);
$kl++;
$i = -1;
}
$texts = $fraza." >> ".$texts;
if ((int)$rooms == 4)
{
$chats[$nid] = $times.": ".$nickk." для ".$texts."
";
$chatc[$nid] = 4;
}
else if ($tomy)
{
$chats[$nid] = $times.": ".$nickk." для ".$texts."
";
$chatc[$nid] = 2;
}
else { $nid--; }
}
else
{
echo "Error";
echo('
');
}
$nid++;
}
while ($nid >= 0)
{
switch ($chatc[$nid])
{
case '1':
echo "";
break;
case '2':
echo "";
break;
case '3':
echo "";
break;
case '4':
echo "";
break;
default:
echo "";
}
echo $chats[$nid];
$nid--;
}
echo "";
echo "";
echo "