Файл: news.php
Строк: 101
<?
include_once 'core/system.php';
echo only_reg();
$header = 'Новости игры!';
include_once 'core/head.php';
switch($_GET['act'])
{
default:
$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'];
$q = mysql_query("SELECT * FROM `news` ORDER BY `id` DESC LIMIT $start, $set[p_str]");
if($k_post == 0)echo "<div class='listing-information-two'><div class='mt5 small'> Нет новостей!</div></div>";
while($post = mysql_fetch_assoc($q)) {
?>
<div class='listing-information-two'>
<div class='mt5 small'>
<a href='/news/<?=$post[id]?>'><img src='/images/forum_topic.png'><?=$post[title]?></a>
</div></div>
<?
}
if ($k_page>1){
echo "<div class='listing-information-two'>
<div class='mt5 small'>";
str('?',$k_page,$page); // Вывод страниц
echo "</div></div>";
}
break;
case 'news_read':
if (isset($_GET['id']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `news` WHERE `id` = '".intval($_GET['id'])."'"),0) == true){
$news = mysql_fetch_assoc(mysql_query("SELECT * FROM `news` WHERE `id` = '".intval($_GET['id'])."'"));
}else{
$_SESSION['err'] = "Нет такой новости!";
header('Location: /news');
exit();
}
$header = $news[title];
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '$news[id_user]'"));
if ($user['access'] >= 4){
echo "
<div class='listing-information-two'><div class='mt5 small'>
<a href='?del=news&id=".$news['id']."'>Удалить новость</a></div></div>";}
if(check($_GET['del']) == 'news') {
if ($user['access'] >= 4){
header('Location: /index.php');
mysql_query("update `user` set `news_read` = '0'");
}
$id_news = intval($_GET['id']);
$del_news = mysql_query("DELETE FROM `news` WHERE `id` = '".$id_news."'");
header("Location: ?");
}
echo "<div class='listing-information-two'><div class='mt5 small'>$news[title] ";
echo "[".vremja($news[time])."]<br />";
echo "".smiles($news[msg])."<br />";
echo "Новость добавил: <img width='14' src='/images/guild/$ank[rasa].png'> <a href='/profile/$news[id_user]/'>$ank[nick]</a></div></div>";
# Навигация
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `news_kom` WHERE `id_news` = '".intval($_GET['id'])."'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id`='".intval($_GET['comm'])."'"));
# Комментарии
if($_POST['msg'] && $_SESSION['time_up'] < time())
{
$msg = check($_POST['msg']);
mysql_query("INSERT INTO `news_kom` SET `id_user` = '$user[id]', `id_news` = '$news[id]', `msg` = '$msg', `time` = '".time()."'");
header("Location: /news/$news[id]");
$_SESSION['time_up'] = time() + 5;
}
echo '
<div class="listing-information-two">
<div class="mt5 small">
<form method="post" action="/news/'.$news[id].'">
'.fast_smile().' <br />
<textarea name="msg" id="mess">'.$ank['nick'].'</textarea> <br />
<input class="label" type="submit" value="Отправить"></span></span>
</form>';
$q = mysql_query("SELECT * FROM `news_kom` WHERE `id_news` = '$news[id]' ORDER BY `id` DESC LIMIT $start, $set[p_str]");
if(!$q)echo "<div class='listing-information'>Нет комментарий</div>";
while($post = mysql_fetch_assoc($q))
{
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]' LIMIT 1"));
echo "<img width='14' src='/images/guild/$ank[rasa].png'> <a href='/profile/$ank[id]/'> $ank[nick]</a> [".vremja($post[time])."] ";
if ($user['access'] >= 4)
{
echo "<a href='?del=msg&id_msg=".$post['id']."'> [удалить] </a>";
}
if(check($_GET['del']) == 'msg')
{
if ($user['access'] >= 4) header('Location: /index.php');
$id_chmsg = intval($_GET['id_msg']);
$del_chat_msg = mysql_query("DELETE FROM `news_kom` WHERE `id` = '".$id_chmsg."'");
header("Location: ?");
}
echo "<br />".smiles($post['msg'])."";
echo "<div class='hr p5'></div>";
}
echo "
</div>
</div>";
if ($k_page>1){
echo "<div class='listing-information-two'>
<div class='mt5 small'>";
str('?',$k_page,$page); // Вывод страниц
echo "</div></div>";
}
# Конец
break;
}
include_once 'core/foot.php';
?>