Файл: news/index.php
Строк: 83
<?
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();
echo "<a href='/news/rss.php'><div class='u_menu'>";
echo "<img src='/s-klub/img/my_f.png'> <b>RSS лента</b>";
echo "</div></a>";
if (user_access('adm_news'))
{
echo "<a href='/panel/news_add.php'><div class='u_menu'>";
echo "<img src='/s-klub/img/rss-add.png'> <b>Добавить новость</b>";
echo "</div></a>";
}
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `news`"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($k_post==0)
{
echo "<div class='err'>";
echo "Новости отсуствуют!";
echo "</div>";
}
$q=mysql_query("SELECT * FROM `news` ORDER BY `time` DESC LIMIT $start, $set[p_str]");
while ($post=mysql_fetch_assoc($q))
{
$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);
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 "<a href='news.php?id=".$post['id']."'><b>".output_text($post['title'])."</b></a><br />";
echo "</td>";
echo "</tr><tr>";
echo "<td class='p_m' colspan='2'>";
if (user_access('adm_news'))
{
echo "<span style='float : right;'>";
echo "<a href='/panel/news_del.php?id=".$post['id']."'><img src='/s-klub/img/del.png'> <b>Удалить</b></a>";
echo "</span>";
}
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 "<span style='float : right;'>";
if (isset($user) && !$n_l)
{
echo "<a href='/news/like.php?id=".$post['id']."'>";
echo "<img src='/s-klub/img/up.png'> <b>Класс</b>";
echo "</a> | ";
}
echo "<a href='/news/like_all.php?id=".$post['id']."'><img src='/s-klub/img/up.png'> <b>".$likes." чел.</b></a> | ";
echo "<a href='/news/komm.php?id=".$post['id']."'><img src='/s-klub/img/post.png'> <b>Комментарии (".$komm.")</b></a>";
echo "</span>";
echo "</td>";
echo "</tr></table>";
}
if ($k_page>1)
{
str('?',$k_page,$page);
}
include_once '../sys/includes/footer.php';
?>