View file ä󿪫¬/modules/blogs/opis_delete.php

<?php

foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
    require_once "../../sys/inc/$inc.php";
}

if (!isset($user)){header("location: index.php?");exit;}

if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    header('Location: user.php');
    exit;
}





$id = htmlspecialchars((int)$_GET['id']);
$q = $pdo->query("SELECT * FROM `MicroBlogs` WHERE `id` = '{$id}'");


$MicroBlog = $q->fetch(PDO::FETCH_ASSOC);
$ank = get_user($MicroBlog['id_autor']);

if ($user['group_access'] < $ank['group_access'] && $user['group_access'] < 7 && $user['id'] != $ank['id']) {
    header('Location: user.php');
    exit;
}

$set['title'] = 'Удаление описания';
include_once '../../sys/inc/thead.php';

aut();


#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltipecho' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/info.php?$user[id]'>$user[nick]</a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='user.php?id=$user[id]'>";
echo lang('Блог');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> Удаление описания</div>";
echo "<div style='padding: 4px; background-color: white;'>";







if (isset($_GET['yes'])) {
        $pdo->query("DELETE
FROM `MicroBlogs_Comments`, `MicroBlogs_Like` , `MicroBlogs_Views`
USING `MicroBlogs`
LEFT JOIN `MicroBlogs_Comments` ON `MicroBlogs_Comments`.`id_microblog` = `MicroBlogs`.`id`
LEFT JOIN `MicroBlogs_Like` ON `MicroBlogs_Like`.`id_microblog` = `MicroBlogs`.`id`
LEFT JOIN `MicroBlogs_Views` ON `MicroBlogs_Views`.`id_microblog` = `MicroBlogs`.`id`
WHERE `MicroBlogs`.`id` = '{$MicroBlog['id']}'");
        $pdo->query("DELETE FROM `MicroBlogs` WHERE `id` = '{$MicroBlog['id']}' LIMIT 1");
        header('Location: user.php');
        exit;
}
$where = htmlspecialchars("WHERE `id_autor` = '{$ank['id']}'");
$q = $pdo->query("SELECT * FROM `MicroBlogs`  $where ORDER BY `time_add` DESC LIMIT 1");
$MicroBlogs = $q->fetch(PDO::FETCH_ASSOC);
echo "<center>Вы действительно хотите удалить описание <b>";
echo toOutput($MicroBlogs['message']);



echo "</b>?<br /><br /><a class='btn btn-primary btn-sm' href='?id={$id}&amp;yes'>Да, удалить</a> <a class='btn btn-secondary btn-sm' href='user.php'>Отмена</a></center>";











echo "</div>";

include_once '../../sys/inc/tfoot.php';
?>