View file comm/inc/act.delete_comm.php

File size: 3.8Kb
<?
$comm = mysql_fetch_assoc(mysql_query("SELECT * FROM `comm` WHERE `id` = '".intval(@$_GET['id'])."'"));
if (!@$comm['id'] || $user['level'] < 3) {
	header("Location: /comm/");
	exit();
}
$set['title'] = 'Сообщества - Удаление сообщества';
include_once '../sys/inc/thead.php';
title();
aut();
if (isset($_POST['delete'])) {
	$post_comm = $comm;
	// удаляем все данные из форума
	mysql_query("DELETE FROM `comm_forum` WHERE `id_comm` = '$post_comm[id]'");
	mysql_query("DELETE FROM `comm_forum_komm` WHERE `id_comm` = '$post_comm[id]'");
	// удаляем все данные из чата
	mysql_query("DELETE FROM `comm_chat` WHERE `id_comm` = '$post_comm[id]'");
	mysql_query("DELETE FROM `comm_chat_who` WHERE `id_comm` = '$post_comm[id]'");
	// удаляем все данные из загрузок
	$q_files_dir = mysql_query("SELECT * FROM `comm_files` WHERE `id_comm` = '$post_comm[id]' AND `type` = 'dir'");
	while ($post_files_dir = mysql_fetch_array($q_files_dir)) {
		$q_files_file = mysql_query("SELECT * FROM `comm_files` WHERE `id_comm` = '$post_comm[id]' AND `id_dir` = '$post_files_dir[id]' AND `type` = 'file'");
		while ($post_files_file = mysql_fetch_array($q_files_file)) {
			unlink($files_upload_dir.$post_files_file['id'].'.dat');
			if (is_file($screens_upload_dir.$post_files_file['id'].'_48x48.png'))unlink($screens_upload_dir.$post_files_file['id'].'_48x48.png');
			if (is_file($screens_upload_dir.$post_files_file['id'].'_128x128.png'))unlink($screens_upload_dir.$post_files_file['id'].'_128x128.png');
		}
	}
	// корневые файлы
	$q_root_files_file = mysql_query("SELECT * FROM `comm_files` WHERE `id_comm` = '$post_comm[id]' AND `id_dir` = '0' AND `type` = 'file'");
	while ($post_root_files_file = mysql_fetch_array($q_root_files_file)) {
		unlink($files_upload_dir.$post_root_files_file['id'].'.dat');
		if (is_file($screens_upload_dir.$post_root_files_file['id'].'_48x48.png'))unlink($screens_upload_dir.$post_root_files_file['id'].'_48x48.png');
		if (is_file($screens_upload_dir.$post_root_files_file['id'].'_128x128.png'))unlink($screens_upload_dir.$post_root_files_file['id'].'_128x128.png');
	}
	mysql_query("DELETE FROM `comm_files_komm` WHERE `id_comm` = '$post_comm[id]'");
	mysql_query("DELETE FROM `comm_files_rating` WHERE `id_comm` = '$post_comm[id]'");
	mysql_query("DELETE FROM `comm_files` WHERE `id_comm` = '$post_comm[id]'");
	// удаляем визиты
	mysql_query("DELETE FROM `comm_visits` WHERE `id_comm` = '$post_comm[id]'");
	// удаляем участников
	mysql_query("DELETE FROM `comm_users` WHERE `id_comm` = '$post_comm[id]'");
	// удаляем баны
	mysql_query("DELETE FROM `comm_users_ban` WHERE `id_comm` = '$post_comm[id]'");
	// удаляем записи в журнале
	mysql_query("DELETE FROM `comm_journal` WHERE `id_comm` = '$post_comm[id]'");
	// удаляем юзеров из ч/с сообщества
	mysql_query("DELETE FROM `comm_blist` WHERE `id_comm` = '$post_comm[id]'");
	// удаляем "пересоздателей"
	mysql_query("DELETE FROM `comm_readmin` WHERE `id` = '$post_comm[id]'");
	// удаляем логотип
	if (is_file($logos_upload_dir.$post_comm['id'].'_'.$post_comm['mdi'].'.png'))unlink($logos_upload_dir.$post_comm['id'].'_'.$post_comm['mdi'].'.png');
	// удаляем сообщество :(((
	mysql_query("DELETE FROM `comm` WHERE `id` = '$post_comm[id]'");
	header("Location: ?act=cat&id=".$comm['id_cat']);
	exit();
}
echo "<form method='POST'>\n";
echo "Подтвердите удаление сообщества. Все данные будут удалены!<br/>\n";
echo "<input type='submit' name='delete' value='Удалить'><a href='?act=comm&id=$comm[id]'>Отмена</a>\n";
echo "</form>\n";
?>