function delete_results() { db_init(); $f = fopen('dbc_out.dat', 'r'); while (1) { $x = fgets($f); if (!$x) { break; } $n = sscanf($x, "%d", $resid); if ($n != 1) { echo "bad line: {$x}\n"; continue; } $result = lookup_result($resid); if (!$result) { echo "no result {$resultid}\n"; continue; } $wu = lookup_wu($result->workunitid); if ($wu) { echo "result has WU: {$resid}\n"; continue; } echo "deleting {$resid}\n"; // uncomment the following to actually delete die("edit script to enable deletion\n"); //mysql_query("delete from result where id=$resid"); } }
<?php // This file is part of BOINC. // http://boinc.berkeley.edu // Copyright (C) 2008 University of California // // BOINC is free software; you can redistribute it and/or modify it // under the terms of the GNU Lesser General Public License // as published by the Free Software Foundation, // either version 3 of the License, or (at your option) any later version. // // BOINC is distributed in the hope that it will be useful, // but WITHOUT ANY WARRANTY; without even the implied warranty of // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. // See the GNU Lesser General Public License for more details. // // You should have received a copy of the GNU Lesser General Public License // along with BOINC. If not, see <http://www.gnu.org/licenses/>. // show a result require_once "../inc/db.inc"; require_once "../inc/util.inc"; require_once "../inc/result.inc"; check_get_args(array("resultid")); $resultid = get_int("resultid"); $result = lookup_result($resultid); if (!$result) { error_page(tra("No such task")); } page_head(tra("Task %1", $resultid)); show_result($result); page_tail();