if (!empty($mask['edit_table']))
return array('error' => 'Cannot handle deletion for secondary table');
+ if (!empty($_POST['table']) && is_array($mask['tables_delete']) && in_array($_POST['table'], $mask['tables_delete']))
+ $table = $_POST['table'];
+ else
+ $table = $mask['table'];
+
if (DELETE_COPY === true) {
$sql = sprintf("INSERT INTO %s_deleted SELECT * FROM %s WHERE id = %d",
- $mask['table'], $mask['table'], $_POST['id']);
+ $table, $table, $_POST['id']);
$sth = pg_query($sql);
}
$sql = sprintf("UPDATE %s_deleted SET sys_user='%s',sys_edit=now() WHERE id = %d",
- $mask['table'], $_SESSION['sys']['login'], $_POST['id']);
+ $table, $_SESSION['sys']['login'], $_POST['id']);
$sth = pg_query($sql);
}
}
- $sql = sprintf("DELETE FROM %s WHERE id = %d", $mask['table'], $_POST['id']);
+ $sql = sprintf("DELETE FROM %s WHERE id = %d", $table, $_POST['id']);
$sth = pg_query($sql);