Файл: users/includes/album/delete.php
Строк: 58
<?php
/*
////////////////////////////////////////////////////////////////////////////////
// JohnCMS Mobile Content Management System //
// Project site: http://johncms.com //
// Support site: http://gazenwagen.com //
////////////////////////////////////////////////////////////////////////////////
// Lead Developer: Oleg Kasyanov (AlkatraZ) alkatraz@gazenwagen.com //
// Development Team: Eugene Ryabinin (john77) john77@gazenwagen.com //
// Dmitry Liseenko (FlySelf) flyself@johncms.com //
////////////////////////////////////////////////////////////////////////////////
*/
defined('_IN_JOHNCMS') or die('Error: restricted access');
require('../incfiles/head.php');
/*
-----------------------------------------------------------------
Удалить альбом
-----------------------------------------------------------------
*/
if ($al && $user['id'] == $user_id || $rights >= 6) {
$req_a = mysql_query("SELECT * FROM `cms_album_cat` WHERE `id` = '$al' AND `user_id` = '" . $user['id'] . "' LIMIT 1");
if (mysql_num_rows($req_a)) {
$res_a = mysql_fetch_assoc($req_a);
echo '<div class="phdr"><a href="album.php?act=list&user=' . $user['id'] . '"><b>' . $lng['photo_album'] . '</b></a> | ' . $lng['delete'] . '</div>';
if (isset($_POST['submit'])) {
$req = mysql_query("SELECT * FROM `cms_album_files` WHERE `album_id` = '" . $res_a['id'] . "'");
while ($res = mysql_fetch_assoc($req)) {
// Удаляем файлы фотографий
@unlink('../files/users/album/' . $user['id'] . '/' . $res['img_name']);
@unlink('../files/users/album/' . $user['id'] . '/' . $res['tmb_name']);
// Удаляем записи из таблицы голосований
mysql_query("DELETE FROM `cms_album_votes` WHERE `file_id` = '" . $res['id'] . "'");
// Удаляем комментарии
mysql_query("DELETE FROM `cms_album_comments` WHERE `sub_id` = '" . $res['id'] . "'");
}
// Удаляем записи из таблиц
mysql_query("DELETE FROM `cms_album_files` WHERE `album_id` = '" . $res_a['id'] . "'");
mysql_query("DELETE FROM `cms_album_cat` WHERE `id` = '" . $res_a['id'] . "'");
mysql_query("OPTIMIZE TABLE `cms_album_cat`");
mysql_query("OPTIMIZE TABLE `cms_album_votes`");
mysql_query("OPTIMIZE TABLE `cms_album_files`");
mysql_query("OPTIMIZE TABLE `cms_album_comments`");
echo '<div class="menu"><p>' . $lng_profile['album_deleted'] . '<br />' .
'<a href="album.php?act=list&user=' . $user['id'] . '">' . $lng['continue'] . '</a></p></div>';
} else {
echo '<div class="rmenu"><form action="album.php?act=delete&al=' . $al . '&user=' . $user['id'] . '" method="post">' .
'<p>' . $lng_profile['album'] . ': <b>' . functions::checkout($res_a['name']) . '</b></p>' .
'<p>' . $lng_profile['album_delete_warning'] . '</p>' .
'<p><input type="submit" name="submit" value="' . $lng['delete'] . '"/></p>' .
'</form></div>' .
'<div class="phdr"><a href="album.php?act=list&user=' . $user['id'] . '">' . $lng['cancel'] . '</a></div>';
}
} else {
echo functions::display_error($lng['error_wrong_data']);
}
}
?>