Файл: news/news.php
Строк: 91
<?
include_once '../sys/includes/start.php';
include_once '../sys/includes/compress.php';
include_once '../sys/includes/sess.php';
include_once '../sys/includes/home.php';
include_once '../sys/includes/settings.php';
include_once '../sys/includes/db_connect.php';
include_once '../sys/includes/ipua.php';
include_once '../sys/includes/fnc.php';
include_once '../sys/includes/user.php';
$set['title']='Подробнее о новости';
include_once '../sys/includes/header.php';
title();
auter();
if (isset($_GET['id']))
{
$it=intval($_GET['id']);
$post=mysql_fetch_assoc(mysql_query("SELECT * FROM `news` WHERE `id`='".$it."' LIMIT 1"));
$n_eye=mysql_fetch_assoc(mysql_query("SELECT * FROM `news_eye` WHERE `id_news` = '".$post['id']."' AND `id_user` = '".$user['id']."'"));
$n_l=mysql_fetch_assoc(mysql_query("SELECT * FROM `news_likes` WHERE `id_news` = '".$post['id']."' AND `id_user` = '".$user['id']."'"));
$likes=mysql_result(mysql_query("SELECT COUNT(*) FROM `news_likes` WHERE `id_news` = '".$post['id']."'"),0);
$komm=mysql_result(mysql_query("SELECT COUNT(*) FROM `news_komm` WHERE `id_news` = '".$post['id']."'"),0);
}
if (!isset($_GET['id']) || !$post || $post['id']==0)
{
echo "<div class='err'>";
echo "Новость не найдена!";
echo "</div>";
echo "<a href='index.php'><div class='foot'>";
echo "<img src='/s-klub/img/left.png'> <b>Новости</b>";
echo "</div></a>";
include_once '../sys/includes/footer.php';
exit;
}
if (isset($user) && !$n_eye)
{
mysql_query("INSERT INTO `news_eye` (`id_user`, `id_news`, `time`) values ('".$user['id']."', '".$post['id']."', '".$time."')");
}
echo "<table style='width:100%' cellspacing='1' cellpadding='1'><tr>";
echo "<td class='icon14'><center>";
echo "<img src='/s-klub/img/big/megaphone.png'>";
echo "</center></td>";
echo "<td class='p_t'>";
echo "<span style='float : right;'>";
echo "<img src='/s-klub/img/time.png'> ".vremja($post['time'])."<br />";
echo "</span>";
echo "<b>".output_text($post['title'])."</b><br />";
echo "</td>";
echo "</tr><tr>";
echo "<td class='p_m' colspan='2'>";
echo "<img src='/s-klub/img/post.png'> <b>Суть новости:</b><br >";
echo "<div class='forum_post'>";
echo "".output_text($post['msg'])."<br />";
echo "</div>";
echo "<table style='width:100%' cellspacing='1' cellpadding='1'><tr>";
if (isset($user) && !$n_l)
{
echo "<td class='u_menu'><center>";
echo "<a href='like.php?id=".$post['id']."&like'>";
echo "<img src='/s-klub/img/up.png'> <b>Класс</b>";
echo "</a>";
echo "</center></td>";
}
echo "<td class='u_menu'><center>";
echo "<a href='like_all.php?id=".$post['id']."'><img src='/s-klub/img/up.png'> <b>".$likes." чел.</b></a>";
echo "</center></td>";
echo "<td class='forum_tema'><center>";
echo "<img src='/s-klub/img/eye.png'> <b>".$post['prosm']." чел.</b>";
echo "</center></td>";
echo "<td class='u_menu'><center>";
echo "<a href='/news/komm.php?id=".$post['id']."'><img src='/s-klub/img/post.png'> <b>Комментарии (".$komm.")</b></a>";
echo "</center></td>";
echo "</tr></table>";
echo "</td>";
echo "</tr></table>";
echo "<a href='index.php'><div class='foot'>";
echo "<img src='/s-klub/img/left.png'> <b>Новости</b>";
echo "</div></a>";
include_once '../sys/includes/footer.php';
?>