File size: 3.79Kb
<?
include_once '../../sys/inc/start.php';
include_once '../../sys/inc/compress.php';
include_once '../../sys/inc/sess.php';
include_once '../../sys/inc/home.php';
include_once '../../sys/inc/settings.php';
include_once '../../sys/inc/db_connect.php';
include_once '../../sys/inc/ipua.php';
include_once '../../sys/inc/fnc.php';
include_once '../../sys/inc/user.php';
user_access('adm_news',null,'index.php?'.SID);
define ('id', isset( $_GET['id'] ) ? abs(intval($_GET['id'])) : 0);
define ('ROOT', $_SERVER['DOCUMENT_ROOT'].'/');
$act = mysql_fetch_assoc(mysql_query("SELECT * FROM `news_list` WHERE `id` = '".id."' LIMIT 1"));
$name = htmlspecialchars($act['name']);
// проверяем существует категория
if (!empty($act)) {
if (isset($_POST['save']) && isset($user))
{
// Удаляем категорию , записи , просмотры , лайки ,
$query = mysql_query("SELECT * FROM `news` WHERE `list` = '".$act['id']."'");
while ($news = mysql_fetch_assoc($query))
{
mysql_query("DELETE FROM `news` WHERE `id` = '$news[id]'");
mysql_query("DELETE FROM `news_komm` WHERE `id_news` = '$news[id]'");
mysql_query("DELETE FROM `news_view` WHERE `news` = '$news[id]'");
mysql_query("DELETE FROM `news_read` WHERE `news` = '$news[id]'");
mysql_query("DELETE FROM `like_object` WHERE `id_object` = '$news[id]'");
@unlink(ROOT."news/photo/img/".$news['file']."");
}
mysql_query("DELETE FROM `news_list` WHERE `id` = '$act[id]'");
$_SESSION['message'] = 'Категория удалена ';
header ("Location: /news/list/" . SID);
exit;
}
// заголовок страницы
$set['title'] = 'Новости : Категории : Удаление';
// head
include_once '../../sys/inc/thead.php';
title();
aut();
err();
echo'
<link rel="stylesheet" href="/news/style.css" type="text/css">
<div class="main_bg">
<div class="lc_br wbg font0 relative oh" id="header_path">
<a href="/" style="font-size:0;"> <img src="/news/ico/home.png" alt=""> </a>
<span class="lc_brw">
<img src="/news/ico/sep.png" alt="" class="lc_br_sep"> <span class="lc_br_text">
<a href="/news/">Новости</a></span>
<span class="lc_brw">
<img src="/news/ico/sep.png" alt="" class="lc_br_sep"> <span class="lc_br_text">
<a href="/news/list/">Категории</a></span>
<span class="lc_brw">
<img src="/news/ico/sep.png" alt="" class="lc_br_sep"> <span class="lc_br_text">
<a href="/news/list/act.php?id='.$act['id'].'">'.$name.'</a></span>
<span class="lc_brw">
<img src="/news/ico/sep.png" alt="" class="lc_br_sep"> <span class="lc_br_text">
Удаление</span></span>
</div></div>
<form method="post">
<div class="wrapper">
<div class="block">
<div>
<div class="grey" style ="margin-bottom: 6px;">Категория: <span style ="color: #000;">'.$name.'</span></div>
<div class="grey" style ="margin-bottom: 6px;">Записи: <span style ="color: #000;">';
$сount = mysql_result(mysql_query("SELECT COUNT(*) FROM `news` WHERE `list` = '".$act['id']."'"),0);
if($сount == 0)echo' пусто';
$query = mysql_query("SELECT * FROM `news` WHERE `list` = '".$act['id']."'");
while ($post = mysql_fetch_assoc($query))
{
$title = htmlspecialchars($post['title']);
echo $title.', ';
}
echo'
</span>
</div>
</div>
</div></div>
<table class="table__wrap">
<tbody><tr> <td>
<div class="wrapper mt_0 mr0">
<button name="save" class=" link blue full is_final " style = "color: #ff0c0c!important;">
<img src="/news/ico/delete.png " alt="" class="m">
<span class="m">Удалить категорию</span>
</button>
</div></td> </tr>
</tbody></table>
</form>
';
}else{$_SESSION['message'] = 'Ошибка категория не найдена'; header("location: /news/list/");}
include_once '../../sys/inc/tfoot.php';
?>