function edit()
{
$sql = '
UPDATE {{reference}}
SET
parent=' . trim($_POST['parent']) . ',
name=\'' . trim($_POST['name']) . '\',
path=\'' . trim($_POST['path']) . '\',
value=\'' . trim($_POST[$_POST['type']]) . '\',
type=\'' . trim($_POST['type']) . '\'
WHERE id=' . $_POST['id'] . '
';
DB::exec($sql);
$addingSql = '';
if (count($_POST['fileIds']) > 0) {
$addingSql = ' AND id NOT IN (' . implode(',', $_POST['fileIds']) . ') ';
}
$sql = '
SELECT path FROM {{reference_files}}
WHERE reference=' . $_POST['id'] . ' ' . $addingSql . '
';
$delFiles = DB::getAll($sql, 'path');
foreach ($delFiles as $item) {
if (file_exists($_SERVER['DOCUMENT_ROOT'] . $item)) {
unlink($_SERVER['DOCUMENT_ROOT'] . $item);
}
}
$dir = md5('touch' . $user);
$dir = '/u/files/reference/' . $_POST['id'] . '/';
if (is_dir($_SERVER['DOCUMENT_ROOT'] . $dir)) {
if (count(scandir($_SERVER['DOCUMENT_ROOT'] . $dir)) == 2) {
rmdir($_SERVER['DOCUMENT_ROOT'] . $dir);
}
}
$sql = '
DELETE FROM {{reference_files}}
WHERE reference=' . $_POST['id'] . ' ' . $addingSql . '
';
DB::exec($sql);
Reference::upload($_POST['id']);
}
