From de1cc4eb44940de94643c936672a8ec92fed1e5d Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Thu, 20 Oct 2011 08:23:15 -0400
Subject: [PATCH] Fixed: FS#1796 - Folder protection must be deleted if a site is deleted
---
interface/web/sites/web_domain_del.php | 23 +++++++++++++++++++++++
1 files changed, 23 insertions(+), 0 deletions(-)
diff --git a/interface/web/sites/web_domain_del.php b/interface/web/sites/web_domain_del.php
index e5614cf..c7d5548 100644
--- a/interface/web/sites/web_domain_del.php
+++ b/interface/web/sites/web_domain_del.php
@@ -78,6 +78,29 @@
foreach($records as $rec) {
$app->db->datalogDelete('cron','id',$rec['id']);
}
+
+ // Delete all records that belog to this zone.
+ $records = $app->db->queryAllRecords("SELECT id FROM cron WHERE parent_domain_id = '".intval($this->id)."'");
+ foreach($records as $rec) {
+ $app->db->datalogDelete('cron','id',$rec['id']);
+ }
+
+ // Delete all records that belog to this zone.
+ $records = $app->db->queryAllRecords("SELECT webdav_user_id FROM webdav_user WHERE parent_domain_id = '".intval($this->id)."'");
+ foreach($records as $rec) {
+ $app->db->datalogDelete('webdav_user','webdav_user_id',$rec['webdav_user_id']);
+ }
+
+ //* Delete all web folders
+ $records = $app->db->queryAllRecords("SELECT web_folder_id FROM web_folder WHERE parent_domain_id = '".intval($this->id)."'");
+ foreach($records as $rec) {
+ //* Delete all web folder users
+ $records2 = $app->db->queryAllRecords("SELECT web_folder_user_id FROM web_folder_user WHERE web_folder_id = '".$rec['web_folder_id']."'");
+ foreach($records2 as $rec2) {
+ $app->db->datalogDelete('web_folder_user','web_folder_user_id',$rec2['web_folder_user_id']);
+ }
+ $app->db->datalogDelete('web_folder','web_folder_id',$rec['web_folder_id']);
+ }
}
}
--
Gitblit v1.9.1