Файл: pesn_voini/peseni_vojni/instalscript/engine/public/forum/tema.php
Строк: 80
<?php
//
require_once($_SERVER['DOCUMENT_ROOT']."/instalscript/engine/_inc/sys.php");
//
head("Форум",$uid); # Голова
//
//
$id = abs(intval($_GET['id']));
$tema = fch("SELECT * FROM `forum_tema` WHERE `id` = ? LIMIT 1", array($id));
//
$raz = fch("SELECT * FROM `forum` WHERE `id` = ? LIMIT 1", array($tema['id_raz']));
//
if(!$tema){
header('location:/forum/?r='.$r);
exit();
}
//
if($tema['id_raz'] == 1 && $user['news_forum'] != 0){
//
qry("UPDATE `users` SET `news_forum` = ? WHERE `id` = ? LIMIT 1", array(0,$uid));
//
header('location:?r='.$r);
exit();
}
//
//
//
if(isset($_GET['delete']) && $user['adm'] != 0){
$id = abs(intval($_GET['delete']));
$message = fch("SELECT * FROM `forum_tema` WHERE `id` = ? LIMIT 1", array($id));
if(!$message){
header('location:?r='.$r);
exit();
}
//
qry("UPDATE `forum_tema` SET `delete` = ? WHERE `id` = ? LIMIT 1", array(1,$message['id']));
//
header('location:/forum/r'.$tema['id_raz'].'/page/1/?r='.$r);
exit();
}
//
//
//
if(isset($_GET['close']) && $user['adm'] != 0){
$id = abs(intval($_GET['close']));
$message = fch("SELECT * FROM `forum_tema` WHERE `id` = ? LIMIT 1", array($id));
if(!$message){
header('location:?r='.$r);
exit();
}
//
if($message['close'] == 0)$check = 1; else $check = 0;
qry("UPDATE `forum_tema` SET `close` = ? WHERE `id` = ? LIMIT 1", array($check,$message['id']));
//
header('location:?r='.$r);
exit();
}
//
//
if(isset($_GET['top']) && $user['adm'] != 0){
$id = abs(intval($_GET['top']));
$message = fch("SELECT * FROM `forum_tema` WHERE `id` = ? LIMIT 1", array($id));
if(!$message){
header('location:?r='.$r);
exit();
}
//
if($message['top'] == 0)$check = 1; else $check = 0;
qry("UPDATE `forum_tema` SET `top` = ? WHERE `id` = ? LIMIT 1", array($check,$message['id']));
//
header('location:?r='.$r);
exit();
}
//
//
if(isset($_GET['del']) && $user['adm'] != 0){
$id = abs(intval($_GET['del']));
$message = fch("SELECT * FROM `forum_post` WHERE `id` = ? LIMIT 1", array($id));
if(!$message){
header('location:?r='.$r);
exit();
}
//
if($message['del'] == 0)$del_check = 1; else $del_check = 0;
qry("UPDATE `forum_post` SET `del` = ? WHERE `id` = ? LIMIT 1", array($del_check,$message['id']));
//
//
header('location:?r='.$r);
exit();
}
//
//
echo '<div class="message"><a href="/forum/"><b>Форум</b></a> - <a href="/forum/r'.$raz['id'].'/page/1/">'.$raz['name'].'</a> - '.$tema['name'].' </div><div class="hr"></div>';
echo '<div class="message">
'.user_list($tema['id_user']).'<span style="float: right;">'.clock($tema['time']).'</span><br><br>
'.bbcode($tema['text']).'
';
//
if($tema['id_user_edit'] >= 1)echo '<br><br><small>Посл. ред: '.user_list($tema['id_user_edit']).', '.clock($tema['time_edit']).'</small>';
//
if($tema['close'] == 1)$c = 'Открыть';
else $c = 'Закрыть';
//
if($tema['top'] == 0)$t = 'Закрепить';
else $t = 'Открепить';
//
echo '</div>';
if($user['adm'] >= 1)echo '<div class = "message cntr"><a href="/forum/e'.$tema['id'].'/">[Редактировать]</a> - <a href="?close='.$tema['id'].'">['.$c.']</a> - <a href="?top='.$tema['id'].'">['.$t.']</a> - <a href="?delete='.$tema['id'].'">[Удалить]</a></div>';
//
echo "<div class = 'hr'></div>";
//
if($user['adm'] == 0)$del = 1; else $del = 2;
//
$count = $BaseConnect->query("SELECT (id) FROM `forum_post` WHERE `id` != '".$del."' AND `id_tema` = '".$id."'")->rowCount();
//
$str = '10'; # кол-во записей для вывода
$url = "/forum/t".$tema['id']."/page/"; # ссылка
$num = abs(is('1')); # текущая страница
$result = $count; # подсчёт
$msg_q = $BaseConnect->query("SELECT * FROM `forum_post` WHERE `del` != '".$del."' AND `id_tema` = '".$id."' ORDER BY `time` ASC LIMIT ".page($num,$str,$result).",$str ");
//
//
if($count == 0)echo '<div class = "message">Здесь ещё нет сообщений</div>';
//
while($msg = $msg_q->fetch(PDO::FETCH_ASSOC)){
$user3 = fch("SELECT * FROM `users` WHERE `id` = ?LIMIT 1", array($msg['id_opp']));
echo "
<div class = 'message'>
".user_list($msg['id_user'])." ";
if($msg['id_user'] != $uid)echo "- <a class href = '?user=".$msg['id_user']."'>[отв]</a> ";
echo "
<br>
";
if($msg['id_opp'] != 0 && $msg['id_opp'] != $uid)echo " <b>".user($msg['id_opp'],'login')."</b>, ";
//
if($msg['id_opp'] == $uid)echo " <b><font color='lime'>".user($msg['id_opp'],'login')."</font></b>, ";
echo " ".bbcode($msg['text'])."
<span class = 'time'>".clock($msg['time'])." ";
if($user['adm'] != 0){
if($msg['del'] == 0)echo "- <a class href = '?del=".$msg['id']."'>[х]</a> ";
elseif($msg['del'] == 1)echo "- <a class href = '?del=".$msg['id']."'>[восстановить]</a> ";
echo "- <a class href = '/ban/?id=".$msg['id_user']."&forum=".$msg['id']."'>[бан]</a>
";
}
echo "</span>
</div>
";
}
ppage($url,$num,$str,$result);
//
//
//
//
echo logs();
//
if(isset($_GET['form'])){
//
$form = abs(intval($_GET['form']));
if($form == null)$id = 0;
//
$text = checking($_POST['text']);
//
$err = false;
//
if($ban){
err("Вы забанены - <a href='/ban/my/'>подробнее</a>");
$err = true;
}
//
if(mb_strlen($text) < 1 or mb_strlen($text) > 5000){
//err("Слишком короткое или длинное сообщение");
$err = true;
}
//
if($user['level'] <= 14){
//err("Для общения на форуме, нужен 15 уровень");
$err = true;
}
//
if($tema['close'] != 0){
$err = true;
}
//
if($user['spam_message'] > time()){
err("Сообщение можно отправлять, раз 3 секунды");
$err = true;
}
//
if($err == false){
qry("INSERT INTO `forum_post` SET `id_user` = ?, `id_opp` = ?, `id_tema` = ?, `time` = ?, `text` = ?", array($uid,$form,$tema['id'],time(),$text));
//
qry("UPDATE `users` SET `spam_message` = ? WHERE `id` = ? LIMIT 1", array(time()+3,$uid));
//
qry("UPDATE `users` SET `forum_check` = ? WHERE `id` = ? LIMIT 1", array(1,$form));
//
header("Location:?r=".$r);
exit();
}
header("location:?r=".$r);
exit();
}
//
if($tema['close'] == 0 && $user['level'] >= 15){
//
if(isset($_GET['user'])){
$user_id = abs(intval($_GET['user']));
$user2 = fch("SELECT * FROM `users` WHERE `id` = ? LIMIT 1", array($user_id));
if(!$user2){
header('location:?r='.$r);
exit();
}
if($user_id == $uid){
header('location:?r='.$r);
exit();
}
//
//
?>
<center>Ответ для: <?=$user2['login'];?></center><form action = '?form=<?=$user_id;?>' method = 'post'>
<?
}else{
?>
<form action = '?form' method = 'post'>
<?
}
?>
<table>
<td class = 'sm cntr'><a class = 'ma lnk cntr' onclick='{ showSmilies(); return false; }' href='?' title = 'Смайлики'><img src = '/instalscript/images/icons/emoji/0.png'></a></td>
<td><textarea name = 'text' id='message' placeholder='' maxlength = '256'></textarea></td>
<td class = 'sm cntr'>
<button type = 'submit' class = 'submit' title = 'Отправить'>
</button>
</td>
</table>
</form>
<?
require_once($_SERVER['DOCUMENT_ROOT']."/instalscript/engine/modules/smiles.php");
//
} else {
//
if($user['level'] <= 14)$i1 = 'Нужен 15 уровень //';
//
if($tema['close'] != 0)$i2 = 'Тема закрыта';
//
echo '<div class="hr"></div><div class="err">Вы не можете комментировать тему: '.$i1.' '.$i2.'</div>';
}
//
echo '<div class="hr"></div><div class = "message"><a href="/forum/r'.$tema['id_raz'].'/page/1/">Вернуться назад</a></div>';
//
foot($uid);
?>