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;
}
Example #2
0
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>";