function del()
{
$ids = Tree::getChilds($_GET['id']);
$ids[] = $_GET['id'];
foreach ($ids as $id) {
Tree::saveSearch($id);
$sql = '
SELECT * FROM {{data}}
WHERE type=\'gallery\' AND tree=\'' . $id . '\'
';
$gals = DB::getAll($sql);
foreach ($gals as $item) {
if ($item['id']) {
$sql = '
SELECT * FROM {{relations}}
WHERE modul1=\'data\' AND modul2=\'files\' AND id1=\'' . $item['id'] . '\'
';
$files = DB::getAll($sql);
foreach ($files as $file) {
$sql = '
SELECT id1 FROM {{relations}}
WHERE modul1=\'data\' AND modul2=\'files\' AND id1<>\'' . $item['id'] . '\' AND id2=' . $file['id2'] . '
';
$id1 = DB::getOne($sql);
if (!$id1) {
Fields::removeFile($item['id'], $file['id2']);
}
}
}
}
$sql = '
DELETE FROM {{relations}}
WHERE modul1=\'tree\' AND id1=\'' . $id . '\'
';
DB::exec($sql);
$sql = '
DELETE FROM {{data}}
WHERE tree=\'' . $id . '\'
';
DB::exec($sql);
$sql = '
DELETE FROM {{tree}}
WHERE id=\'' . $id . '\'
';
DB::exec($sql);
$sql = '
DELETE FROM {{catalog}}
WHERE tree=\'' . $id . '\'
';
DB::exec($sql);
}
}
public function removeGallery($id)
{
$sql = '
SELECT id2 FROM {{relations}}
WHERE modul1=\'data\' AND modul2=\'files\' AND id1=' . $id . '
';
$files = DB::getAll($sql, 'id2');
foreach ($files as $item) {
Fields::removeFile($id, $item);
}
$sql = '
DELETE FROM {{data}}
WHERE id=' . $id . '
';
DB::exec($sql);
}
function removefile()
{
Fields::removeFile();
}