public function delete()
{
//Eliminamos las relaciones con etiquetas
$sql = "DELETE FROM " . $this->db->prefix('dtrans_softtag') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
if (!$result) {
return false;
}
//Eliminar caracteristicas
$sql = "DELETE FROM " . $this->db->prefix('dtrans_features') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
if (!$result) {
return false;
}
//Eliminar pantallas
$sql = "SELECT * FROM " . $this->db->prefix('dtrans_screens') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
while ($rows = $this->db->fetchArray($result)) {
$sc = new DTScreenshot();
$sc->assignVars($rows);
$sc->delete();
}
//Eliminar Archivos
$sql = "SELECT * FROM " . $this->db->prefix('dtrans_files') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
while ($rows = $this->db->fetchArray($result)) {
$file = new DTFile();
$file->assignVars($rows);
$file->delete($this);
}
//Eliminar Logs
$sql = "DELETE FROM " . $this->db->prefix('dtrans_logs') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
if (!$result) {
return false;
}
//Eliminar grupo
$sql = "DELETE FROM " . $this->db->prefix('dtrans_groups') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
if (!$result) {
return false;
}
//Eliminar relación de licencias
$sql = "DELETE FROM " . $this->db->prefix('dtrans_licsoft') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
if (!$result) {
return false;
}
//Eliminar relación de plataformas
$sql = "DELETE FROM " . $this->db->prefix('dtrans_platsoft') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
if (!$result) {
return false;
}
//Eliminar alerta
$sql = "DELETE FROM " . $this->db->prefix('dtrans_alerts') . " WHERE id_soft=" . $this->id();
$result = $this->db->queryF($sql);
if (!$result) {
return false;
}
return $this->deleteFromTable();
}
/**
* Delete files
*/
function dt_delete_file()
{
global $mc, $item, $file;
$fl = new DTFile($file);
if ($fl->isNew()) {
redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/files/' . $item->id() : '/?p=cpanel&action=files&id=' . $item->id()), 1, __('Specified file is not valid!', 'dtransport'));
}
if (!$fl->delete()) {
redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/files/' . $item->id() : '/?p=cpanel&action=files&id=' . $item->id()), 1, __('File could not be deleted! Please try again.', 'dtransport'));
}
if ($item->getVar('secure')) {
$dir = rtrim($mc['directory_secure'], '/');
} else {
$dir = rtrim($mc['directory_insecure'], '/');
}
if (!$fl->remote()) {
unlink($dir . '/' . $fl->file());
}
redirect_header(DT_URL . ($mc['permalinks'] ? '/cp/files/' . $item->id() : '/?p=cpanel&action=files&id=' . $item->id()), 1, __('File deleted successfully!', 'dtransport'));
}
/**
* Elimina archivos de la base de datos y el disco duro
*/
function dt_delete_file()
{
global $xoopsSecurity, $functions;
if (!$xoopsSecurity->check()) {
$functions->dt_send_message(__('Session token not valid!', 'dtransport'), 1, 0);
}
$id = rmc_server_var($_POST, 'id', 0);
$item = rmc_server_var($_POST, 'item', 0);
$file = new DTFile($id);
if ($file->isNew()) {
$functions->dt_send_message(__('Specified file does not exists!', 'dtransport'), 1, 1);
}
$sw = new DTSoftware($item);
if ($sw->isNew()) {
$functions->dt_send_message(__('Specified item download does nto exists!', 'dtransport'), 1, 1);
}
if ($file->software() != $item) {
$functions->dt_send_message(__('This file seems not belong to specified download item!', 'dtransport'), 1, 1);
}
if (!$file->delete()) {
$functions->dt_send_message(__('File could not be deleted!', 'dtransport'), 1, 1);
}
$rmu = RMUtilities::get();
$mc = $rmu->module_config('dtransport');
$dir = $sw->getVar('secure') ? $mc['directory_secure'] : $mc['directory_insecure'];
unlink($dir . '/' . $file->file());
$functions->dt_send_message(__('File deleted successfully!', 'dtransport'), 0, 1);
}
