project_init.php

<?php
// This file is part of BOINC.
// http://boinc.berkeley.edu
// Copyright (C) 2018 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/>.

// initialize or update the project DB table
// RUN WHENEVER BOINC PROJECT LIST HAS CHANGED
//
// php get_projects.php
// php project_digest.php
// php project_init.php

// If there are new projects:
// set su_project.authenticator and state using mysql

require_once("../inc/keywords.inc");
require_once("../inc/project_ids.inc");
require_once("../inc/su_db.inc");

// remove projects and everything that refers to them
// THINK TWICE BEFORE DOING THIS
//
//function clean() {
//    die();
//    foreach (SUProject::enum() as $p) {
//        $p->delete();
//    }
//    SUAccount::delete_all();
//    SUHostProject::delete_all();
//    SUAccountingProject::delete_all();
//}

function update_project($p) {
    $name = (string)$p->name;
    $url = (string)$p->url;
    $web_url = (string)$p->web_url;
    $web_rpc_url_base = (string)$p->web_rpc_url_base;
    if (!$web_rpc_url_base) {
        $web_rpc_url_base = $url;
    }
    $project_id = (string)$p->id;
    $now = time();
    $cmd = "~/boinc/lib/crypt_prog -sign_string $url ~/science_united/code_sign_private";
    $out = array();
    $retval = 0;
    exec($cmd, $out, $retval);
    if ($retval) {
        die("$cmd failed\n");
    }
    $url_signature = implode("\n", $out);

    $project = SUProject::lookup_id($project_id);
    if ($project) {
        if ($project->status != PROJECT_STATUS_AUTO) {
            echo "Project $project->name was not enabled\n";
        }
        if ($url_signature != $project->url_signature) {
            echo "updating $project->name URL signature\n";
            $ret = $project->update("url_signature='$url_signature'");
            if (!$ret) {
                echo "update failed\n";
                return;
            }
        }
        if ($url != $project->url) {
            echo "updating $project->name URL\n";
            $ret = $project->update("url='$url'");
            if (!$ret) {
                echo "update failed\n";
                return;
            }
        }
        if ($web_url != $project->web_url) {
            echo "updating $project->name web URL\n";
            $ret = $project->update("web_url='$web_url'");
            if (!$ret) {
                echo "update failed\n";
                return;
            }
        }
        if ($web_rpc_url_base != $project->web_rpc_url_base) {
            echo "updating $project->name RPC URL base\n";
            $ret = $project->update("web_rpc_url_base='$web_rpc_url_base'");
            if (!$ret) {
                echo "update failed\n";
                return;
            }
        }
        if (!$project->authenticator) {
            echo "Project $project->name has no authenticator: create an account\n";
            return;
        }
        echo "Marking $project->name as working\n";
        $project->update("status = ".PROJECT_STATUS_AUTO);
    } else {
        SUProject::insert("(id, create_time, name, url, web_rpc_url_base, url_signature, share, status) values ($project_id, $now, '$name', '$url', '$web_rpc_url_base', '$url_signature', 10, ".PROJECT_STATUS_HIDE.")");

        if (!SUAccountingProject::insert("(project_id, create_time) values ($project_id, $now)")) {
            die("su_accounting_project insert failed\n");
        }
        echo "Added project $name; give it a (weak) authenticator, then set status to 2 (AUTO)\n";
    }
}

// create or update projects based on projects.xml
// If a project is not there, flag as deprecated.
//
function update_projects() {
    $projs = SUProject::enum();
    foreach ($projs as $p) {
        $p->update("status = ".PROJECT_STATUS_HIDE);
    }
    $x = simplexml_load_file("projects.xml");
    $projects = $x->project;
    foreach ($projects as $p) {
        $id = (int)$p->id;

        // Skip projects that don't exist anymore

        if ($id == PROJ_QCN) continue;
        if ($id == PROJ_RADIOACTIVE) continue;
        if ($id == PROJ_LEIDEN) continue;
        if ($id == PROJ_MOO) continue;
        if ($id == PROJ_YOYO) continue;
        if ($id == PROJ_MINECRAFT) continue;
        if ($id == PROJ_COLLATZ) continue;
        if ($id == PROJ_PRIMABOINCA) continue;
        update_project($p);
    }
}

update_projects();

?>