// src = dest
$msg->addFeedback('CANCELLED');
header('Location: ' . url_rewrite('mods/_standard/file_storage/index.php' . $owner_arg_prefix . 'folder=' . $_POST['new_folder'], AT_PRETTY_URL_IS_HEADER));
exit;
}
if (isset($_POST['files'])) {
foreach ($_POST['files'] as $file) {
$file = abs($file);
// check if this file name already exists
$sql = "SELECT file_name FROM " . TABLE_PREFIX . "files WHERE file_id={$file}";
$result = mysql_query($sql, $db);
$row = mysql_fetch_assoc($result);
$sql = "SELECT file_id FROM " . TABLE_PREFIX . "files WHERE folder_id={$_POST['new_folder']} AND file_id<>{$file} AND file_name='{$row['file_name']}' AND parent_file_id=0 AND owner_type={$owner_type} AND owner_id={$owner_id} ORDER BY file_id DESC LIMIT 1";
$result = mysql_query($sql, $db);
if ($row = mysql_fetch_assoc($result)) {
fs_delete_file($row['file_id'], $owner_type, $owner_id);
}
$sql = "UPDATE " . TABLE_PREFIX . "files SET folder_id={$_POST['new_folder']}, date=date WHERE file_id={$file} AND owner_type={$owner_type} AND owner_id={$owner_id}";
mysql_query($sql, $db);
}
$msg->addFeedback('FILES_MOVED');
}
if (isset($_POST['folders'])) {
foreach ($_POST['folders'] as $folder) {
$file = abs($file);
$sql = "UPDATE " . TABLE_PREFIX . "folders SET parent_folder_id={$_POST['new_folder']} WHERE folder_id={$folder} AND owner_type={$owner_type} AND owner_id={$owner_id}";
mysql_query($sql, $db);
}
$msg->addFeedback('DIRS_MOVED');
}
header('Location: ' . url_rewrite('mods/_standard/file_storage/index.php' . $owner_arg_prefix . 'folder=' . $_POST['new_folder'], AT_PRETTY_URL_IS_HEADER));
/**
* deletes all the files, folders, comments, revisions, etc.. in the specified workspace.
*/
function fs_delete_workspace($owner_type, $owner_id) {
global $db;
$sql = "SELECT folder_id, owner_type, owner_id FROM ".TABLE_PREFIX."folders WHERE owner_type=$owner_type AND owner_id=$owner_id AND parent_folder_id=0";
$result = mysql_query($sql, $db);
while ($row = mysql_fetch_assoc($result)) {
fs_delete_folder($row['folder_id'], $row['owner_type'], $row['owner_id']);
}
$sql = "SELECT file_id, owner_type, owner_id FROM ".TABLE_PREFIX."files WHERE owner_type=$owner_type AND owner_id=$owner_id";
$result = mysql_query($sql, $db);
while ($row = mysql_fetch_assoc($result)) {
fs_delete_file($row['file_id'], $row['owner_type'], $row['owner_id']);
}
}
$file_list_to_print .= '<li style="list-style: none; margin: 0px; padding: 0px 10px;"><img src="images/file_types/' . fs_get_file_type_icon($row['file_name']) . '.gif" height="16" width="16" alt="" title="" /> ' . htmlspecialchars($row['file_name']) . '</li>';
}
$msg->addConfirm(array('FILE_DELETE', $file_list_to_print), $hidden_vars);
require AT_INCLUDE_PATH . 'header.inc.php';
$msg->printConfirm();
require AT_INCLUDE_PATH . 'footer.inc.php';
exit;
} else {
if ($has_priv && isset($_POST['submit_yes'])) {
// handle the delete
if (isset($_POST['files'])) {
$files = explode(',', $_POST['files']);
}
if (isset($files)) {
foreach ($files as $file) {
fs_delete_file($file, $owner_type, $_REQUEST['owner_id']);
}
$msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
}
header('Location: index.php');
exit;
} else {
if ($has_priv && isset($_POST['submit_no'])) {
$msg->addFeedback('CANCELLED');
header('Location: index.php');
exit;
}
}
}
}
// display
/**
* deletes all the files, folders, comments, revisions, etc.. in the specified workspace.
*/
function fs_delete_workspace($owner_type, $owner_id)
{
$sql = "SELECT folder_id, owner_type, owner_id FROM %sfolders WHERE owner_type=%d AND owner_id=%d AND parent_folder_id=0";
$rows_folders = queryDB($sql, array(TABLE_PREFIX, $owner_type, $owner_id));
foreach ($rows_folders as $row) {
fs_delete_folder($row['folder_id'], $row['owner_type'], $row['owner_id']);
}
$sql = "SELECT file_id, owner_type, owner_id FROM %sfiles WHERE owner_type=%d AND owner_id=%d";
$rows_files = queryDB($sql, array(TABLE_PREFIX, $owner_type, $owner_id));
foreach ($rows_files as $row) {
fs_delete_file($row['file_id'], $row['owner_type'], $row['owner_id']);
}
}
