Файл: chat.php
Строк: 90
<?php
require_once('conf/dbc.php');
require_once('conf/session_start.php');
require_once('conf/ban.php');
if((!isset($_SESSION['id'])) and (!isset($_SESSION['nick']))) {
?>
<script type="text/javascript">
document.location.href = "reg.php?err_login=1";
</script>
<?php
}
$page_title = 'Чат';
require_once('conf/head.php');
if ((isset($_SESSION['id'])) and (isset($_SESSION['nick']))) {
require_once('conf/top.php');
}
?>
Чат
<hr>
Сказать для всех:
<form method="post" action="/chat.php">
<input type="text" name="pole" id="pole"/><br>
<input type="submit" name="send" value="Отправить"></input>
<input type="submit" name="refresh" value="Обновить"></input>
</form>
<?php
if(isset($_POST["refresh"]))
{
print "<script type="text/javascript">document.location.href ="/chat.php?offset=0";</script>";
}
else if(isset($_POST["send"]))
{
$text = $_POST['pole'];
if((preg_match("/sfrpg/i", $text)) OR (preg_match("/script/i", $text)) OR (preg_match("/keo/i", $text)) OR (preg_match("/www/i", $text)) OR (preg_match("/http/i", $text)))
{
echo "<font color=red><b>Не-не-не.. Только не рекламь тут!</b></font>";
require_once('conf/navig.php');
require_once('conf/foot.php');
mysqli_close($dbc);
exit();
}
if(strlen($text) < 3)
{
echo "<font color=red><b>Минимальное кол-во символов отправляемых в чат - 3.</b></font>";
require_once('conf/navig.php');
require_once('conf/foot.php');
mysqli_close($dbc);
exit();
}
$user_id = $_SESSION['id'];
$query = "SELECT `nick`, `gruppa`, `admin` FROM `users` WHERE `id` = '$user_id' LIMIT 1";
$result = mysqli_query($dbc, $query) or die ('Ошибка передачи запроса к БД');
$row = mysqli_fetch_array($result);
$username = $row['nick'];
$date = date('d.m.Y H:i:s');
$gruppa = $row['gruppa'];
$admin = $row['admin'];
$query = "INSERT INTO `general_chat` (`user`, `text`, `date`, `userid`, `gruppa`) VALUES ('$username', '$text', '$date', '$user_id', '$gruppa')";
mysqli_query($dbc, $query);
header('Location: /chat.php');
}
?>
<hr>
<?php
$offset = $_GET['offset'];
if(!isset($offset)) $offset = 0;
$query = "SELECT * FROM `general_chat` ORDER BY `id` DESC LIMIT $offset, 15"; // ORDER BY 'id' ASC
$result = mysqli_query($dbc, $query) or die ('Ошибка передачи запроса к БД 2');
$rrows = mysqli_num_rows($result);
for($i = 0; $i < $rrows; $i++)
{
$row = mysqli_fetch_array($result);
echo ''. $row['id']. '|';
if($row['gruppa'] == 'svoboda') echo '<img src="/img/ico/svoboda.png" width="12" height="12" alt="н">';
else if($row['gruppa'] == 'dolg') echo '<img src="/img/ico/dolg.png" width="12" height="12" alt="н">';
else if($row['gruppa'] == 'naemniki') echo '<img src="/img/ico/odinochki.png" width="12" height="12" alt="н">';
$echojs = "<a href="javascript://" onclick="document.getElementById('pole').value='". $row['user']. ", ';"><font color=yellow>[ОТВЕТИТЬ]</font></a>";
echo ' <a href="/profile.php?id='. $row['userid']. '"><font color=white><b>'. $row['user']. '</b></font></a> ( '. $row['date'];
echo " ) ". $echojs;
if ((isset($_SESSION['id'])) and (isset($_SESSION['nick']))) {
$user_id = $_SESSION['id'];
$query_qq = "Select admin from users where id = '$user_id' limit 1";
$result_qq = mysqli_query($dbc, $query_qq) or die ('Ошибка передачи запроса к БД6');
$row_qq = mysqli_fetch_array($result_qq);
if ($row_qq['admin'] == 1) {
echo '<br><font color="green">' .$row['text']. '</font><br>'; }
if ($row_qq['admin'] == 0) { echo "<br>".$row['text']. "<br>"; }}
echo "<hr>";
}
$query = "SELECT * FROM `general_chat`";
$res = mysqli_query($dbc, $query) or die ('Ошибка передачи запроса к БД 2');
$rowws = mysqli_num_rows($res);
$allpages = ceil($rowws / 15);
echo "<center>";
for($p = 0; $p < $allpages; $p++)
{
$val = $p*15;
if($p != 0) echo ' | ';
echo '<a href="/chat.php?offset='. $val. '">'. ($p+1). '</a>';
}
echo "</center>";
?><hr><?php
require_once('conf/navig.php');
require_once('conf/foot.php');
mysqli_close($dbc);
?>
</body>
</html>