function insert_type_file($id_download, $id_type) { delete_type_file($id_download); $sql_insert = "INSERT INTO tdownload_type_file (id_download, id_type) VALUES ({$id_download}, {$id_type})"; $result = process_sql($sql_insert); return $result; }
if ($op == "update" && $id > 0) { $sql_update = "UPDATE tdownload_type SET name = '{$name}', description = '{$description}', icon = '{$icon}' WHERE id = {$id}"; $result = process_sql($sql_update); if (!$result) { echo "<h3 class='error'>" . __('Could not be updated') . "</h3>"; } else { echo "<h3 class='suc'>" . __('Successfully updated') . "</h3>"; } } // Database DELETE // ================== if ($op == "delete" && $id > 0) { $sql_delete = "DELETE FROM tdownload_type WHERE id = {$id}"; $result = process_sql($sql_delete); if ($result) { delete_type_file($id); echo "<h3 class='suc'>" . __('Successfully deleted') . "</h3>"; } else { echo "<h3 class='error'>" . __('Cannot be deteled') . "</h3>"; } $id = 0; } // CREATE form if ($op == "new" || $id > 0) { if ($id > 0) { $type = get_db_row("tdownload_type", "id", $id); $name = $type["name"]; $description = $type["description"]; $icon = $type["icon"]; $type = null; echo "<h1>" . __('Update existing type') . "</h1>";