conference.php

<?php
// conference.php -- HotCRP central helper class (singleton)
// Copyright (c) 2006-2019 Eddie Kohler; see LICENSE.

class Track {
    const VIEW = 0;
    const VIEWPDF = 1;
    const VIEWREV = 2;
    const VIEWREVID = 3;
    const ASSREV = 4;
    const UNASSREV = 5;
    const VIEWTRACKER = 6;
    const ADMIN = 7;
    const HIDDENTAG = 8;
    const VIEWALLREV = 9;

    const BITS_VIEW = 0x1;    // 1 << VIEW
    const BITS_REVIEW = 0x30; // (1 << ASSREV) | (1 << UNASSREV)
    const BITS_ADMIN = 0x80;  // 1 << ADMIN
    const BITS_VIEWADMIN = 0x81;  // (1 << VIEW) | (1 << ADMIN)

    static public $map = [
        "view" => 0, "viewpdf" => 1, "viewrev" => 2, "viewrevid" => 3,
        "assrev" => 4, "unassrev" => 5, "viewtracker" => 6, "admin" => 7,
        "hiddentag" => 8, "viewallrev" => 9
    ];
    static public $zero = [null, null, null, null, null, null, null, null, null, null];
    static function permission_required($perm) {
        return $perm === self::ADMIN || $perm === self::HIDDENTAG;
    }
}

class ResponseRound {
    public $name;
    public $number;
    public $open;
    public $done;
    public $grace;
    public $words;
    public $search;
    function relevant(Contact $user, PaperInfo $prow = null) {
        global $Now;
        if ($user->allow_administer($prow)
            && ($this->done || $this->search || $this->name !== "1"))
            return true;
        else if ($user->isPC)
            return $this->open > 0;
        else
            return $this->open > 0
                && $this->open < $Now
                && (!$this->search || $this->search->filter($prow ? [$prow] : $user->authored_papers()));
    }
    function time_allowed($with_grace) {
        global $Now;
        if ($this->open === null || $this->open <= 0 || $this->open > $Now)
            return false;
        $t = $this->done;
        if ($t !== null && $t > 0 && $with_grace && $this->grace)
            $t += $this->grace;
        return $t === null || $t <= 0 || $t >= $Now;
    }
    function instructions(Conf $conf) {
        $m = $conf->_i("resp_instrux_$this->number", false, $this->words);
        if ($m === false)
            $m = $conf->_i("resp_instrux", false, $this->words);
        return $m;
    }
}

class Conf {
    public $dblink = null;

    public $settings;
    private $settingTexts;
    public $sversion;
    private $_pc_seeall_cache = null;
    private $_pc_see_pdf = false;

    public $dbname;
    public $dsn = null;

    public $short_name;
    public $long_name;
    public $default_format;
    public $download_prefix;
    public $au_seerev;
    public $tag_au_seerev;
    public $any_response_open;
    public $tag_seeall;
    public $sort_by_last;
    public $opt;
    public $opt_override = null;
    private $_opt_timestamp = null;
    public $paper_opts;

    public $headerPrinted = false;
    private $_save_logs = false;
    public $_session_handler;

    private $rounds = null;
    private $_defined_rounds = null;
    private $_round_settings = null;
    private $_resp_rounds = null;
    private $tracks = null;
    private $_taginfo = null;
    private $_track_tags;
    private $_track_sensitivity = 0;
    private $_decisions;
    private $_decision_matcher;
    private $_topic_map;
    private $_topic_order_map;
    private $_topic_groups;
    private $_topic_html;
    private $_topic_separator_cache;
    private $_topic_abbrev_matcher;
    private $_pc_members_cache;
    private $_pc_tags_cache;
    private $_pc_members_and_admins_cache;
    private $_pc_chairs_cache;
    private $_pc_members_fully_loaded = false;
    private $_user_cache;
    private $_user_cache_missing;
    private $_site_contact;
    private $_review_form_cache = null;
    private $_abbrev_matcher = null;
    private $_date_format_initialized = false;
    private $_formatspec_cache = [];
    private $_docstore = false;
    private $_defined_formulas = null;
    private $_emoji_codes = null;
    private $_s3_document = false;
    private $_ims = null;
    private $_format_info = null;
    private $_updating_autosearch_tags = false;
    private $_cdb = false;

    private $_formula_functions;
    private $_search_keyword_base;
    private $_search_keyword_factories;
    private $_assignment_parsers;
    private $_api_map;
    private $_list_action_map;
    private $_list_action_renderers;
    private $_list_action_factories;
    private $_paper_column_map;
    private $_paper_column_factories;
    private $_option_type_map;
    private $_option_type_factories;
    private $_capability_factories;
    private $_hook_map;
    private $_hook_factories;
    public $_file_filters; // maintained externally
    public $_setting_info; // maintained externally
    private $_mail_keyword_map;
    private $_mail_keyword_factories;
    private $_mail_template_map;

    public $paper = null; // current paper row
    private $_active_list = false;

    static public $g;
    static public $no_invalidate_caches = false;
    static public $next_xt_subposition = 0;
    static private $xt_require_resolved = [];

    const BLIND_NEVER = 0;         // these values are used in `msgs.json`
    const BLIND_OPTIONAL = 1;
    const BLIND_ALWAYS = 2;
    const BLIND_UNTILREVIEW = 3;

    const SEEDEC_ADMIN = 0;
    const SEEDEC_REV = 1;
    const SEEDEC_ALL = 2;
    const SEEDEC_NCREV = 3;

    const AUSEEREV_NO = 0;
    const AUSEEREV_UNLESSINCOMPLETE = 1;
    const AUSEEREV_YES = 2;
    const AUSEEREV_TAGS = 3;

    const PCSEEREV_IFCOMPLETE = 0;
    const PCSEEREV_YES = 1;
    const PCSEEREV_UNLESSINCOMPLETE = 3;
    const PCSEEREV_UNLESSANYINCOMPLETE = 4;

    static public $review_deadlines = array("pcrev_soft", "pcrev_hard", "extrev_soft", "extrev_hard");

    static public $hoturl_defaults = null;

    function __construct($options, $make_dsn) {
        // unpack dsn, connect to database, load current settings
        if ($make_dsn && ($this->dsn = Dbl::make_dsn($options)))
            list($this->dblink, $options["dbName"]) = Dbl::connect_dsn($this->dsn);
        if (!isset($options["confid"]))
            $options["confid"] = get($options, "dbName");
        $this->opt = $options;
        $this->dbname = $options["dbName"];
        $this->paper_opts = new PaperOptionList($this);
        if ($this->dblink && !Dbl::$default_dblink) {
            Dbl::set_default_dblink($this->dblink);
            Dbl::set_error_handler(array($this, "query_error_handler"));
        }
        if ($this->dblink) {
            Dbl::$landmark_sanitizer = "/^(?:Dbl::|Conf::q|Conf::fetch|call_user_func)/";
            $this->load_settings();
        } else
            $this->crosscheck_options();
    }


    //
    // Initialization functions
    //

    function load_settings() {
        global $Now;

        // load settings from database
        $this->settings = array();
        $this->settingTexts = array();
        foreach ($this->opt_override ? : [] as $k => $v) {
            if ($v === null)
                unset($this->opt[$k]);
            else
                $this->opt[$k] = $v;
        }
        $this->opt_override = [];

        $result = $this->q_raw("select name, value, data from Settings");
        while ($result && ($row = $result->fetch_row())) {
            $this->settings[$row[0]] = (int) $row[1];
            if ($row[2] !== null)
                $this->settingTexts[$row[0]] = $row[2];
            if (substr($row[0], 0, 4) == "opt.") {
                $okey = substr($row[0], 4);
                $this->opt_override[$okey] = get($this->opt, $okey);
                $this->opt[$okey] = ($row[2] === null ? (int) $row[1] : $row[2]);
            }
        }
        Dbl::free($result);

        // update schema
        $this->sversion = $this->settings["allowPaperOption"];
        if ($this->sversion < 213) {
            require_once("updateschema.php");
            $old_nerrors = Dbl::$nerrors;
            updateSchema($this);
            Dbl::$nerrors = $old_nerrors;
        }
        if ($this->sversion < 95)
            self::msg_error("Warning: The database could not be upgraded to the current version; expect errors. A system administrator must solve this problem.");

        // invalidate all caches after loading from backup
        if (isset($this->settings["frombackup"])
            && $this->invalidate_caches()) {
            $this->qe_raw("delete from Settings where name='frombackup' and value=" . $this->settings["frombackup"]);
            unset($this->settings["frombackup"]);
        }

        // update options
        if (isset($this->opt["ldapLogin"]) && !$this->opt["ldapLogin"])
            unset($this->opt["ldapLogin"]);
        if (isset($this->opt["httpAuthLogin"]) && !$this->opt["httpAuthLogin"])
            unset($this->opt["httpAuthLogin"]);

        // GC old capabilities
        if (get($this->settings, "__capability_gc", 0) < $Now - 86400) {
            foreach (array($this->dblink, $this->contactdb()) as $db)
                if ($db)
                    Dbl::ql($db, "delete from Capability where timeExpires>0 and timeExpires<$Now");
            $this->q_raw("insert into Settings set name='__capability_gc', value=$Now on duplicate key update value=values(value)");
            $this->settings["__capability_gc"] = $Now;
        }

        $this->crosscheck_settings();
        $this->crosscheck_options();
    }

    private function crosscheck_settings() {
        global $Now;

        // enforce invariants
        foreach (array("pcrev_any", "extrev_view") as $x)
            if (!isset($this->settings[$x]))
                $this->settings[$x] = 0;
        if (!isset($this->settings["sub_blind"]))
            $this->settings["sub_blind"] = self::BLIND_ALWAYS;
        if (!isset($this->settings["rev_blind"]))
            $this->settings["rev_blind"] = self::BLIND_ALWAYS;
        if (!isset($this->settings["seedec"])) {
            if (get($this->settings, "au_seedec"))
                $this->settings["seedec"] = self::SEEDEC_ALL;
            else if (get($this->settings, "rev_seedec"))
                $this->settings["seedec"] = self::SEEDEC_REV;
        }
        if (get($this->settings, "pc_seeallrev") == 2) {
            $this->settings["pc_seeblindrev"] = 1;
            $this->settings["pc_seeallrev"] = self::PCSEEREV_YES;
        }
        if (($sub_update = get($this->settings, "sub_update", -1)) > 0
            && ($sub_reg = get($this->settings, "sub_reg", -1)) <= 0) {
            $this->settings["sub_reg"] = $sub_update;
            $this->settings["__sub_reg"] = $sub_reg;
        }

        // rounds
        $this->crosscheck_round_settings();

        // S3 settings
        foreach (array("s3_bucket", "s3_key", "s3_secret") as $k)
            if (!get($this->settingTexts, $k) && ($x = get($this->opt, $k)))
                $this->settingTexts[$k] = $x;
        if (!get($this->settingTexts, "s3_key")
            || !get($this->settingTexts, "s3_secret")
            || !get($this->settingTexts, "s3_bucket"))
            unset($this->settingTexts["s3_key"], $this->settingTexts["s3_secret"],
                  $this->settingTexts["s3_bucket"]);
        if (get($this->opt, "dbNoPapers") && !get($this->opt, "docstore")
            && !get($this->opt, "filestore") && !get($this->settingTexts, "s3_bucket"))
            unset($this->opt["dbNoPapers"]);
        if ($this->_s3_document
            && (!isset($this->settingTexts["s3_bucket"])
                || !$this->_s3_document->check_key_secret_bucket($this->settingTexts["s3_key"], $this->settingTexts["s3_secret"], $this->settingTexts["s3_bucket"])))
            $this->_s3_document = false;

        // tracks settings
        $this->tracks = $this->_track_tags = null;
        $this->_track_sensitivity = 0;
        if (($j = get($this->settingTexts, "tracks")))
            $this->crosscheck_track_settings($j);

        // clear caches
        $this->_decisions = $this->_decision_matcher = null;
        $this->_pc_seeall_cache = null;
        $this->_defined_rounds = null;
        $this->_resp_rounds = null;
        // digested settings
        $this->_pc_see_pdf = true;
        if (get($this->settings, "sub_freeze", 0) <= 0
            && ($so = get($this->settings, "sub_open", 0)) > 0
            && $so < $Now
            && ($ss = get($this->settings, "sub_sub", 0)) > 0
            && $ss > $Now
            && (get($this->settings, "pc_seeallpdf", 0) <= 0
                || !$this->can_pc_see_active_submissions()))
            $this->_pc_see_pdf = false;

        $this->au_seerev = get($this->settings, "au_seerev", 0);
        $this->tag_au_seerev = null;
        if ($this->au_seerev == self::AUSEEREV_TAGS)
            $this->tag_au_seerev = explode(" ", get_s($this->settingTexts, "tag_au_seerev"));
        $this->tag_seeall = get($this->settings, "tag_seeall", 0) > 0;

        $this->any_response_open = 0;
        if (get($this->settings, "resp_active", 0) > 0) {
            foreach ($this->resp_rounds() as $rrd) {
                if ($rrd->time_allowed(true)) {
                    if ($rrd->search) {
                        $this->any_response_open = 1;
                    } else {
                        $this->any_response_open = 2;
                        break;
                    }
                }
            }
        }
    }

    private function crosscheck_round_settings() {
        $this->rounds = [""];
        if (isset($this->settingTexts["tag_rounds"])) {
            foreach (explode(" ", $this->settingTexts["tag_rounds"]) as $r)
                if ($r != "")
                    $this->rounds[] = $r;
        }
        $this->_round_settings = null;
        if (isset($this->settingTexts["round_settings"])) {
            $this->_round_settings = json_decode($this->settingTexts["round_settings"]);
            $max_rs = [];
            foreach ($this->_round_settings as $rs) {
                if ($rs && isset($rs->pc_seeallrev)
                    && self::pcseerev_compare($rs->pc_seeallrev, get($max_rs, "pc_seeallrev", 0)) > 0)
                    $max_rs["pc_seeallrev"] = $rs->pc_seeallrev;
                if ($rs && isset($rs->extrev_view)
                    && $rs->extrev_view > get($max_rs, "extrev_view", 0))
                    $max_rs["extrev_view"] = $rs->extrev_view;
            }
            $this->_round_settings["max"] = (object) $max_rs;
        }

        // review times
        foreach ($this->rounds as $i => $rname) {
            $suf = $i ? "_$i" : "";
            if (!isset($this->settings["extrev_soft$suf"]) && isset($this->settings["pcrev_soft$suf"]))
                $this->settings["extrev_soft$suf"] = $this->settings["pcrev_soft$suf"];
            if (!isset($this->settings["extrev_hard$suf"]) && isset($this->settings["pcrev_hard$suf"]))
                $this->settings["extrev_hard$suf"] = $this->settings["pcrev_hard$suf"];
        }
    }

    private function crosscheck_track_settings($j) {
        if (is_string($j) && !($j = json_decode($j)))
            return;
        $this->tracks = [];
        $default_track = Track::$zero;
        $this->_track_tags = [];
        foreach ((array) $j as $k => $v) {
            if ($k !== "_")
                $this->_track_tags[] = $k;
            if (!isset($v->viewpdf) && isset($v->view))
                $v->viewpdf = $v->view;
            $t = Track::$zero;
            foreach (Track::$map as $tname => $idx)
                if (isset($v->$tname)) {
                    $t[$idx] = $v->$tname;
                    $this->_track_sensitivity |= 1 << $idx;
                }
            if ($k === "_")
                $default_track = $t;
            else
                $this->tracks[$k] = $t;
        }
        $this->tracks["_"] = $default_track;
    }

    function crosscheck_options() {
        global $ConfSitePATH;

        // set longName, downloadPrefix, etc.
        $confid = $this->opt["confid"];
        if ((!isset($this->opt["longName"]) || $this->opt["longName"] == "")
            && (!isset($this->opt["shortName"]) || $this->opt["shortName"] == "")) {
            $this->opt["shortNameDefaulted"] = true;
            $this->opt["longName"] = $this->opt["shortName"] = $confid;
        } else if (!isset($this->opt["longName"]) || $this->opt["longName"] == "")
            $this->opt["longName"] = $this->opt["shortName"];
        else if (!isset($this->opt["shortName"]) || $this->opt["shortName"] == "")
            $this->opt["shortName"] = $this->opt["longName"];
        if (!isset($this->opt["downloadPrefix"]) || $this->opt["downloadPrefix"] == "")
            $this->opt["downloadPrefix"] = $confid . "-";
        $this->short_name = $this->opt["shortName"];
        $this->long_name = $this->opt["longName"];

        // expand ${confid}, ${confshortname}
        foreach (array("sessionName", "downloadPrefix", "conferenceSite",
                       "paperSite", "defaultPaperSite", "contactName",
                       "contactEmail", "docstore") as $k)
            if (isset($this->opt[$k]) && is_string($this->opt[$k])
                && strpos($this->opt[$k], "$") !== false) {
                $this->opt[$k] = preg_replace(',\$\{confid\}|\$confid\b,', $confid, $this->opt[$k]);
                $this->opt[$k] = preg_replace(',\$\{confshortname\}|\$confshortname\b,', $this->short_name, $this->opt[$k]);
            }
        $this->download_prefix = $this->opt["downloadPrefix"];

        foreach (array("emailFrom", "emailSender", "emailCc", "emailReplyTo") as $k)
            if (isset($this->opt[$k]) && is_string($this->opt[$k])
                && strpos($this->opt[$k], "$") !== false) {
                $this->opt[$k] = preg_replace(',\$\{confid\}|\$confid\b,', $confid, $this->opt[$k]);
                if (strpos($this->opt[$k], "confshortname") !== false) {
                    $v = rfc2822_words_quote($this->short_name);
                    if ($v[0] === "\"" && strpos($this->opt[$k], "\"") !== false)
                        $v = substr($v, 1, strlen($v) - 2);
                    $this->opt[$k] = preg_replace(',\$\{confshortname\}|\$confshortname\b,', $v, $this->opt[$k]);
                }
            }

        // remove final slash from $Opt["paperSite"]
        if (!isset($this->opt["paperSite"]) || $this->opt["paperSite"] == "")
            $this->opt["paperSite"] = Navigation::base_absolute();
        if ($this->opt["paperSite"] == "" && isset($this->opt["defaultPaperSite"]))
            $this->opt["paperSite"] = $this->opt["defaultPaperSite"];
        $this->opt["paperSite"] = preg_replace('|/+\z|', "", $this->opt["paperSite"]);

        // option name updates (backwards compatibility)
        foreach (array("assetsURL" => "assetsUrl",
                       "jqueryURL" => "jqueryUrl", "jqueryCDN" => "jqueryCdn",
                       "disableCSV" => "disableCsv") as $kold => $knew)
            if (isset($this->opt[$kold]) && !isset($this->opt[$knew]))
                $this->opt[$knew] = $this->opt[$kold];

        // set assetsUrl and scriptAssetsUrl
        if (!isset($this->opt["scriptAssetsUrl"]) && isset($_SERVER["HTTP_USER_AGENT"])
            && strpos($_SERVER["HTTP_USER_AGENT"], "MSIE") !== false)
            $this->opt["scriptAssetsUrl"] = Navigation::siteurl();
        if (!isset($this->opt["assetsUrl"]))
            $this->opt["assetsUrl"] = Navigation::siteurl();
        if ($this->opt["assetsUrl"] !== "" && !str_ends_with($this->opt["assetsUrl"], "/"))
            $this->opt["assetsUrl"] .= "/";
        if (!isset($this->opt["scriptAssetsUrl"]))
            $this->opt["scriptAssetsUrl"] = $this->opt["assetsUrl"];
        Ht::$img_base = $this->opt["assetsUrl"] . "images/";

        // set docstore
        if (get($this->opt, "docstore") === true)
            $this->opt["docstore"] = "docs";
        else if (!get($this->opt, "docstore") && get($this->opt, "filestore")) { // backwards compat
            $this->opt["docstore"] = $this->opt["filestore"];
            if ($this->opt["docstore"] === true)
                $this->opt["docstore"] = "filestore";
            $this->opt["docstoreSubdir"] = get($this->opt, "filestoreSubdir");
        }
        if (get($this->opt, "docstore") && $this->opt["docstore"][0] !== "/")
            $this->opt["docstore"] = $ConfSitePATH . "/" . $this->opt["docstore"];
        $this->_docstore = false;
        if (($dpath = get($this->opt, "docstore"))) {
            if (strpos($dpath, "%") !== false)
                $this->_docstore = $dpath;
            else {
                if ($dpath[strlen($dpath) - 1] === "/")
                    $dpath = substr($dpath, 0, strlen($dpath) - 1);
                $use_subdir = get($this->opt, "docstoreSubdir");
                if ($use_subdir && ($use_subdir === true || $use_subdir > 0))
                    $dpath .= "/%" . ($use_subdir === true ? 2 : $use_subdir) . "h";
                $this->_docstore = $dpath . "/%h%x";
            }
        }

        // handle timezone
        if (function_exists("date_default_timezone_set")) {
            if (isset($this->opt["timezone"])) {
                if (!date_default_timezone_set($this->opt["timezone"])) {
                    self::msg_error("Timezone option “" . htmlspecialchars($this->opt["timezone"]) . "” is invalid; falling back to “America/New_York”.");
                    date_default_timezone_set("America/New_York");
                }
            } else if (!ini_get("date.timezone") && !getenv("TZ"))
                date_default_timezone_set("America/New_York");
        }
        $this->_date_format_initialized = false;

        // set safePasswords
        if (!get($this->opt, "safePasswords")
            || (is_int($this->opt["safePasswords"]) && $this->opt["safePasswords"] < 1))
            $this->opt["safePasswords"] = 0;
        else if ($this->opt["safePasswords"] === true)
            $this->opt["safePasswords"] = 1;
        if (!isset($this->opt["contactdb_safePasswords"]))
            $this->opt["contactdb_safePasswords"] = $this->opt["safePasswords"];

        // set defaultFormat
        $this->default_format = (int) get($this->opt, "defaultFormat");
        $this->_format_info = null;

        // other caches
        $sort_by_last = !!get($this->opt, "sortByLastName");
        if (!$this->sort_by_last != !$sort_by_last)
            $this->invalidate_caches("pc");
        $this->sort_by_last = $sort_by_last;

        $this->_api_map = null;
        $this->_list_action_map = $this->_list_action_renderers = $this->_list_action_factories = null;
        $this->_file_filters = null;
        $this->_site_contact = null;
    }


    function has_setting($name) {
        return isset($this->settings[$name]);
    }

    function setting($name, $defval = null) {
        return get($this->settings, $name, $defval);
    }

    function setting_data($name, $defval = false) {
        return get($this->settingTexts, $name, $defval);
    }

    function setting_json($name, $defval = false) {
        $x = get($this->settingTexts, $name, $defval);
        return is_string($x) ? json_decode($x) : $x;
    }

    private function __save_setting($name, $value, $data = null) {
        $change = false;
        if ($value === null && $data === null) {
            if ($this->qe("delete from Settings where name=?", $name)) {
                unset($this->settings[$name], $this->settingTexts[$name]);
                $change = true;
            }
        } else {
            $value = (int) $value;
            $dval = $data;
            if (is_array($dval) || is_object($dval))
                $dval = json_encode_db($dval);
            if ($this->qe("insert into Settings set name=?, value=?, data=? on duplicate key update value=values(value), data=values(data)", $name, $value, $dval)) {
                $this->settings[$name] = $value;
                $this->settingTexts[$name] = $data;
                $change = true;
            }
        }
        if ($change && str_starts_with($name, "opt.")) {
            $oname = substr($name, 4);
            if ($value === null && $data === null)
                $this->opt[$oname] = get($this->opt_override, $oname);
            else
                $this->opt[$oname] = $data === null ? $value : $data;
        }
        return $change;
    }

    function save_setting($name, $value, $data = null) {
        $change = $this->__save_setting($name, $value, $data);
        if ($change) {
            $this->crosscheck_settings();
            if (str_starts_with($name, "opt."))
                $this->crosscheck_options();
            if (str_starts_with($name, "tag_") || $name === "tracks")
                $this->invalidate_caches(["taginfo" => true, "tracks" => true]);
        }
        return $change;
    }


    function opt($name, $defval = null) {
        return get($this->opt, $name, $defval);
    }

    function set_opt($name, $value) {
        global $Opt;
        $Opt[$name] = $this->opt[$name] = $value;
    }

    function opt_timestamp() {
        if ($this->_opt_timestamp === null) {
            $this->_opt_timestamp = 1;
            foreach (get($this->opt, "loaded", []) as $fn)
                $this->_opt_timestamp = max($this->_opt_timestamp, +@filemtime($fn));
        }
        return $this->_opt_timestamp;
    }


    static function pcseerev_compare($sr1, $sr2) {
        if ($sr1 == $sr2)
            return 0;
        else if ($sr1 == self::PCSEEREV_YES || $sr2 == self::PCSEEREV_YES)
            return $sr1 == self::PCSEEREV_YES ? 1 : -1;
        else
            return $sr1 > $sr2 ? 1 : -1;
    }


    // database

    function q(/* $qstr, ... */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), 0);
    }
    function q_raw(/* $qstr */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_RAW);
    }
    function q_apply(/* $qstr, $args */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_APPLY);
    }

    function ql(/* $qstr, ... */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_LOG);
    }
    function ql_raw(/* $qstr */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_RAW | Dbl::F_LOG);
    }
    function ql_apply(/* $qstr, $args */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_APPLY | Dbl::F_LOG);
    }

    function qe(/* $qstr, ... */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_ERROR);
    }
    function qe_raw(/* $qstr */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_RAW | Dbl::F_ERROR);
    }
    function qe_apply(/* $qstr, $args */) {
        return Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_APPLY | Dbl::F_ERROR);
    }

    function fetch_rows(/* $qstr, ... */) {
        return Dbl::fetch_rows(Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_ERROR));
    }
    function fetch_first_row(/* $qstr, ... */) {
        return Dbl::fetch_first_row(Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_ERROR));
    }
    function fetch_first_object(/* $qstr, ... */) {
        return Dbl::fetch_first_object(Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_ERROR));
    }
    function fetch_value(/* $qstr, ... */) {
        return Dbl::fetch_value(Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_ERROR));
    }
    function fetch_ivalue(/* $qstr, ... */) {
        return Dbl::fetch_ivalue(Dbl::do_query_on($this->dblink, func_get_args(), Dbl::F_ERROR));
    }

    function db_error_html($getdb = true, $while = "") {
        $text = "<p>Database error";
        if ($while)
            $text .= " $while";
        if ($getdb)
            $text .= ": " . htmlspecialchars($this->dblink->error);
        return $text . "</p>";
    }

    function db_error_text($getdb = true, $while = "") {
        $text = "Database error";
        if ($while)
            $text .= " $while";
        if ($getdb)
            $text .= ": " . $this->dblink->error;
        return $text;
    }

    function query_error_handler($dblink, $query) {
        $landmark = caller_landmark(1, "/^(?:Dbl::|Conf::q|call_user_func)/");
        if (PHP_SAPI == "cli")
            fwrite(STDERR, "$landmark: database error: $dblink->error in $query\n");
        else {
            error_log("$landmark: database error: $dblink->error in $query");
            self::msg_error("<p>" . htmlspecialchars($landmark) . ": database error: " . htmlspecialchars($this->dblink->error) . " in " . Ht::pre_text_wrap($query) . "</p>");
        }
    }


    // name

    function full_name() {
        if ($this->short_name && $this->short_name != $this->long_name)
            return $this->long_name . " (" . $this->short_name . ")";
        else
            return $this->long_name;
    }


    function format_spec($dtype) {
        if (!isset($this->_formatspec_cache[$dtype])) {
            $o = $this->paper_opts->get($dtype);
            $spec = $o ? $o->format_spec() : null;
            $this->_formatspec_cache[$dtype] = $spec ? : new FormatSpec;
        }
        return $this->_formatspec_cache[$dtype];
    }

    function docstore() {
        return $this->_docstore;
    }

    function s3_docstore() {
        global $Now;
        if ($this->_s3_document === false) {
            if ($this->setting_data("s3_bucket")) {
                $opts = ["key" => $this->setting_data("s3_key"),
                         "secret" => $this->setting_data("s3_secret"),
                         "bucket" => $this->setting_data("s3_bucket"),
                         "scope" => $this->setting_data("__s3_scope"),
                         "signing_key" => $this->setting_data("__s3_signing_key")];
                $this->_s3_document = S3Document::make($opts);
                list($scope, $signing_key) = $this->_s3_document->scope_and_signing_key($Now);
                if ($opts["scope"] !== $scope || $opts["signing_key"] !== $signing_key) {
                    $this->__save_setting("__s3_scope", 1, $scope);
                    $this->__save_setting("__s3_signing_key", 1, $signing_key);
                }
            } else
                $this->_s3_document = null;
        }
        return $this->_s3_document;
    }


    static function xt_priority($xt) {
        return $xt ? get($xt, "priority", 0) : -PHP_INT_MAX;
    }
    static function xt_priority_compare($xta, $xtb) {
        $ap = self::xt_priority($xta);
        $bp = self::xt_priority($xtb);
        if ($ap == $bp) {
            $ap = $xta ? get($xta, "__subposition", 0) : -PHP_INT_MAX;
            $bp = $xtb ? get($xtb, "__subposition", 0) : -PHP_INT_MAX;
        }
        return $ap < $bp ? 1 : ($ap == $bp ? 0 : -1);
    }
    static function xt_position_compare($xta, $xtb) {
        $ap = get($xta, "position", 0);
        $bp = get($xtb, "position", 0);
        if ($ap == $bp) {
            $ap = get($xta, "__subposition", 0);
            $bp = get($xtb, "__subposition", 0);
        }
        return $ap < $bp ? -1 : ($ap == $bp ? 0 : 1);
    }
    static function xt_add(&$a, $name, $xt) {
        $a[$name][] = $xt;
        if (($syn = get($xt, "synonym")))
            foreach (is_string($syn) ? [$syn] : $syn as $synname)
                $a[$synname][] = $xt;
        return true;
    }
    static private function xt_combine($xt1, $xt2) {
        foreach (get_object_vars($xt2) as $k => $v)
            if (!property_exists($xt1, $k)
                && $k !== "match"
                && $k !== "expand_callback")
                $xt1->$k = $v;
    }
    static function xt_enabled($xt) {
        return $xt && (!isset($xt->disabled) || !$xt->disabled);
    }
    static function xt_disabled($xt) {
        return !$xt || (isset($xt->disabled) && $xt->disabled);
    }
    static function xt_resolve_require($xt) {
        if ($xt
            && isset($xt->require)
            && !isset(self::$xt_require_resolved[$xt->require])) {
            foreach (expand_includes($xt->require, ["autoload" => true]) as $f)
                require_once($f);
            self::$xt_require_resolved[$xt->require] = true;
        }
        return $xt && (!isset($xt->disabled) || !$xt->disabled) ? $xt : null;
    }
    function xt_check($expr, $xt, Contact $user = null, Qrequest $qreq = null) {
        foreach (is_array($expr) ? $expr : [$expr] as $e) {
            $not = false;
            if (is_string($e)
                && strlen($e) > 0
                && ($e[0] === "!" || $e[0] === "-")) {
                $e = substr($e, 1);
                $not = true;
            }
            if (!is_string($e))
                $b = $e;
            else if ($e === "chair" || $e === "admin")
                $b = !$user || $user->privChair;
            else if ($e === "manager")
                $b = !$user || $user->is_manager();
            else if ($e === "pc")
                $b = !$user || $user->isPC;
            else if ($e === "reviewer")
                $b = !$user || $user->is_reviewer();
            else if ($e === "view_review")
                $b = !$user || $user->can_view_some_review();
            else if ($e === "lead" || $e === "shepherd")
                $b = $this->has_any_lead_or_shepherd();
            else if ($e === "empty")
                $b = $user && $user->is_empty();
            else if ($e === "post")
                $b = $qreq && $qreq->post_ok() && $qreq->method() === "POST";
            else if ($e === "getpost")
                $b = $qreq && $qreq->post_ok()
                    && ($qreq->method() === "GET" || $qreq->method() === "POST");
            else if (strpos($e, "::") !== false) {
                self::xt_resolve_require($xt);
                $b = call_user_func($e, $xt, $user, $this);
            } else {
                // check if setting exists
                if (str_starts_with($e, "opt."))
                    $b = !!$this->opt(substr($e, 4));
                else if (str_starts_with($e, "setting."))
                    $b = !!$this->setting(substr($e, 8));
                else if (str_starts_with($e, "req.")) {
                    $b = false;
                    foreach (explode(" ", $e) as $w) {
                        if (str_starts_with($w, "req."))
                            $w = substr($w, 4);
                        $b = $b || ($qreq && isset($qreq[$w]));
                    }
                } else
                    $b = !!$this->setting($e);
            }
            if ($not ? $b : !$b)
                return false;
        }
        return true;
    }
    function xt_allowed($xt, Contact $user = null) {
        return $xt && (!isset($xt->allow_if)
                       || $this->xt_check($xt->allow_if, $xt, $user));
    }
    static function xt_allow_list($xt) {
        if ($xt && isset($xt->allow_if))
            return is_array($xt->allow_if) ? $xt->allow_if : [$xt->allow_if];
        else
            return [];
    }
    function xt_search_name($map, $name, $checkf, $found = null) {
        if (isset($map[$name])) {
            $list = $map[$name];
            $nlist = count($list);
            if ($nlist > 1)
                usort($list, "Conf::xt_priority_compare");
            for ($i = 0; $i < $nlist; ++$i) {
                $xt = $list[$i];
                while ($i + 1 < $nlist
                       && isset($xt->merge)
                       && $xt->merge) {
                    $overlay = $xt;
                    unset($overlay->merge);
                    $xt = $list[$i + 1];
                    object_replace_recursive($xt, $overlay);
                    $overlay->priority = -PHP_INT_MAX;
                    ++$i;
                }
                if (self::xt_priority_compare($xt, $found) <= 0
                    && call_user_func($checkf, $xt))
                    return $xt;
            }
        }
        return $found;
    }
    function xt_search_factories($factories, $name, $checkf, $found,
                                 Contact $user = null, $reflags = "") {
        $this->xt_user = $user;
        $this->_xt_factory_match = false;
        $this->_xt_factory_error = null;
        $xts = [];
        foreach ($factories as $fxt) {
            if (empty($xts)
                ? self::xt_priority_compare($fxt, $found) >= 0
                : self::xt_priority_compare($fxt, $xts[0]) > 0)
                break;
            if ($fxt->match === ".*")
                $m = [$name];
            else if (!preg_match("\1\\A(?:{$fxt->match})\\z\1{$reflags}", $name, $m))
                continue;
            if (!call_user_func($checkf, $fxt))
                continue;
            self::xt_resolve_require($fxt);
            if (isset($fxt->expand_callback))
                $r = call_user_func($fxt->expand_callback, $name, $this, $fxt, $m);
            else
                $r = (object) ["name" => $name, "match_data" => $m];
            if (is_object($r))
                $r = [$r];
            foreach ($r ? : [] as $xt) {
                self::xt_combine($xt, $fxt);
                $prio = self::xt_priority_compare($xt, $found);
                if ($prio <= 0 && call_user_func($checkf, $xt)) {
                    if ($prio < 0)
                        $xts = [];
                    $xts[] = $found = $xt;
                }
            }
        }
        $this->xt_user = null;
        return $xts;
    }
    function xt_factory_mark_matched() {
        $this->_xt_factory_match = true;
    }
    function xt_factory_error($message) {
        $this->_xt_factory_error[] = $message;
    }
    function xt_factory_matched() {
        return $this->_xt_factory_match;
    }
    function xt_factory_errors() {
        return $this->_xt_factory_error;
    }


    // emoji codes
    function _add_emoji_code($val, $key) {
        if (is_string($val) && str_starts_with($key, ":") && str_ends_with($key, ":")) {
            $this->_emoji_codes->emoji[$key] = $val;
            return true;
        } else
            return false;
    }
    function emoji_code_map() {
        global $ConfSitePATH;
        if ($this->_emoji_codes === null) {
            $this->_emoji_codes = json_decode(file_get_contents("$ConfSitePATH/scripts/emojicodes.json"));
            $this->_emoji_codes->emoji = (array) $this->_emoji_codes->emoji;
            if (($olist = $this->opt("emojiCodes")))
                expand_json_includes_callback($olist, [$this, "_add_emoji_code"]);
        }
        return $this->_emoji_codes->emoji;
    }


    function named_formulas() {
        if ($this->_defined_formulas === null) {
            $this->_defined_formulas = [];
            if ($this->setting("formulas")) {
                $result = $this->q("select * from Formula order by lower(name)");
                while ($result && ($f = Formula::fetch($this, $result)))
                    $this->_defined_formulas[$f->formulaId] = $f;
                Dbl::free($result);
            }
        }
        return $this->_defined_formulas;
    }

    function invalidate_named_formulas() {
        $this->_defined_formulas = null;
    }

    function find_named_formula($text) {
        return $this->abbrev_matcher()->find1($text, self::FSRCH_FORMULA);
    }

    function viewable_named_formulas(Contact $user, $author_only = false) {
        return array_filter($this->named_formulas(), function ($f) use ($user, $author_only) {
            return $user->can_view_formula($f, $author_only);
        });
    }


    function decision_map() {
        if ($this->_decisions === null) {
            $dmap = array();
            if (($j = get($this->settingTexts, "outcome_map"))
                && ($j = json_decode($j, true))
                && is_array($j))
                $dmap = $j;
            $dmap[0] = "Unspecified";
            $this->_decisions = $dmap;
            uksort($this->_decisions, function ($ka, $kb) use ($dmap) {
                if ($ka == 0 || $kb == 0)
                    return $ka == 0 ? -1 : 1;
                else if (($ka > 0) !== ($kb > 0))
                    return $ka > 0 ? 1 : -1;
                else
                    return strcasecmp($dmap[$ka], $dmap[$kb]);
            });
        }
        return $this->_decisions;
    }

    function decision_name($dnum) {
        if ($this->_decisions === null)
            $this->decision_map();
        if (($dname = get($this->_decisions, $dnum)))
            return $dname;
        else
            return false;
    }

    static function decision_name_error($dname) {
        $dname = simplify_whitespace($dname);
        if ((string) $dname === "")
            return "Empty decision name.";
        else if (preg_match(',\A(?:yes|no|any|none|unknown|unspecified|undecided|\?)\z,i', $dname))
            return "Decision name “{$dname}” is reserved.";
        else
            return false;
    }

    function decision_matcher() {
        if ($this->_decision_matcher === null) {
            $this->_decision_matcher = new AbbreviationMatcher;
            foreach ($this->decision_map() as $d => $dname)
                $this->_decision_matcher->add($dname, $d);
            foreach (["none", "unknown", "undecided", "?"] as $dname)
                $this->_decision_matcher->add($dname, 0);
        }
        return $this->_decision_matcher;
    }

    function find_all_decisions($dname) {
        return $this->decision_matcher()->find_all($dname);
    }



    function topic_map() {
        if ($this->_topic_map === null) {
            $txs = [];
            $result = $this->qe_raw("select topicId, topicName from TopicArea");
            while (($row = $result->fetch_row())) {
                $colon = (int) strpos($row[1], ":");
                $other = 0;
                if (preg_match('{\G\s*(?:none of |others?(?: |\z))}i', $row[1], $m, 0, $colon !== 0 ? $colon + 1 : 0)) {
                    $other = $colon === 0 ? 2 : 1;
                }
                $txs[] = [(int) $row[0], $row[1], $other, substr($row[1], 0, $colon)];
            }
            Dbl::free($result);

            usort($txs, function ($ta, $tb) {
                if ($ta[2] !== $tb[2]
                    && ($ta[2] === 2
                        || $tb[2] === 2
                        || strcasecmp($ta[3], $tb[3]) === 0))
                    return $ta[2] > $tb[2] ? 1 : -1;
                else
                    return strnatcasecmp($ta[1], $tb[1]);
            });

            $this->_topic_map = [];
            foreach ($txs as $t)
                $this->_topic_map[$t[0]] = $t[1];
        }
        return $this->_topic_map;
    }

    function topic_group_list() {
        if ($this->_topic_groups === null) {
            $this->_topic_groups = [];
            $last_group = $last_gs = null;
            foreach ($this->topic_map() as $tid => $tname) {
                $colon = (int) strpos($tname, ":") ? : strlen($tname);
                $group = substr($tname, 0, $colon);
                if ($last_group !== null
                    && strcasecmp($last_group, $group) === 0) {
                    if ($last_gs[0] === false)
                        $last_gs[0] = $last_group;
                    $last_gs[] = $tid;
                } else {
                    if ($last_group !== null)
                        $this->_topic_groups[] = $last_gs;
                    $last_gs = [false, $tid];
                    $last_group = $group;
                }
            }
            if ($last_group !== null)
                $this->_topic_groups[] = $last_gs;
        }
        return $this->_topic_groups;
    }

    function topic_order_map() {
        if ($this->_topic_order_map === null) {
            $i = 0;
            $this->_topic_order_map = [];
            foreach ($this->topic_map() as $tid => $tname)
                $this->_topic_order_map[$tid] = $i++;
        }
        return $this->_topic_order_map;
    }

    function topic_abbrev_matcher() {
        if ($this->_topic_abbrev_matcher === null) {
            $this->_topic_abbrev_matcher = new AbbreviationMatcher;
            foreach ($this->topic_map() as $tid => $tname)
                $this->_topic_abbrev_matcher->add($tname, $tid);
            foreach ($this->topic_group_list() as $tg) {
                for ($i = 1; $tg[0] && $i !== count($tg); ++$i)
                    $this->_topic_abbrev_matcher->add($tg[0], $tg[$i], 1);
            }
        }
        return $this->_topic_abbrev_matcher;
    }

    function has_topics() {
        return get($this->settings, "has_topics", 0) !== 0;
    }

    function topic_separator() {
        if ($this->_topic_separator_cache === null) {
            $this->_topic_separator_cache = ", ";
            foreach ($this->topic_map() as $tname)
                if (strpos($tname, ",") !== false) {
                    $this->_topic_separator_cache = "; ";
                    break;
                }
        }
        return $this->_topic_separator_cache;
    }

    static function max_topici_lenclass($lenclass, $tname) {
        if ($lenclass === "long"
            || (strlen($tname) > 50
                && UnicodeHelper::utf8_glyphlen($tname) > 50))
            return "long";
        else if ($lenclass === "medium"
                 || (strlen($tname) > 20
                     && UnicodeHelper::utf8_glyphlen($tname) > 20))
            return "medium";
        else
            return "short";
    }

    function subtopic_name($tid) {
        $n = get($this->topic_map(), $tid);
        if ($n && ($colon = (int) strpos($n, ":")) !== 0)
            return ltrim(substr($n, $colon + 1));
        else
            return false;
    }

    function unparse_topic_name_html($tid) {
        if ($this->_topic_html === null)
            $this->_topic_html = [];
        if (!isset($this->_topic_html[$tid])) {
            $t = "";
            $tname = (string) get($this->topic_map(), $tid);
            $colon = (int) strpos($tname, ":");
            if ($colon > 0) {
                foreach ($this->topic_group_list() as $tg)
                    if ($tg[0] && in_array($tid, $tg, true)) {
                        $t = '<span class="topicg">' . htmlspecialchars($tg[0]) . ':</span> ';
                        $tname = ltrim(substr($tname, strlen($tg[0]) + 1));
                        break;
                    }
            }
            $this->_topic_html[$tid] = $t . htmlspecialchars($tname);
        }
        return $this->_topic_html[$tid];
    }

    function unparse_topic_list_html($tlist, $interests = null) {
        $out = [];
        foreach ($tlist as $tid) {
            $n = $this->unparse_topic_name_html($tid);
            $i = $interests === null ? null : get($interests, $tid, 0);
            if (empty($out) && $i !== null) {
                $n = '<span class="topic' . $i . '">' . $n . '</span>';
                $i = null;
            }
            $out[] = '<li class="pl_topicti' . ($i !== null ? " topic$i" : "") . '">' . $n . '</li>';
        }
        return '<ul class="pl_topict">' . join("", $out) . '</ul>';
    }

    function invalidate_topics() {
        $this->_topic_map = $this->_topic_order_map = $this->_topic_groups =
            $this->_topic_html = $this->_topic_separator_cache =
            $this->_topic_abbrev_matcher = null;
    }


    const FSRCH_OPTION = 1;
    const FSRCH_REVIEW = 2;
    const FSRCH_FORMULA = 4;

    function abbrev_matcher() {
        if (!$this->_abbrev_matcher) {
            $this->_abbrev_matcher = new AbbreviationMatcher;
            $this->_abbrev_matcher->add("paper", $this->paper_opts->get(DTYPE_SUBMISSION), self::FSRCH_OPTION, 1);
            $this->_abbrev_matcher->add("submission", $this->paper_opts->get(DTYPE_SUBMISSION), self::FSRCH_OPTION, 1);
            if ($this->has_any_accepted()) {
                $ol = $this->paper_opts->option_list();
                $this->_abbrev_matcher->add("final", $this->paper_opts->get(DTYPE_FINAL), self::FSRCH_OPTION, 1);
            } else
                $ol = $this->paper_opts->nonfinal_option_list();
            // XXX exposes invisible paper options, review fields
            foreach ($ol as $o) {
                $this->_abbrev_matcher->add($o->name, $o, self::FSRCH_OPTION);
                $this->_abbrev_matcher->add("opt" . $o->id, $o, self::FSRCH_OPTION, 1);
            }
            foreach ($this->all_review_fields() as $f)
                if ($f->displayed)
                    $this->_abbrev_matcher->add($f->name, $f, self::FSRCH_REVIEW);
            foreach ($this->named_formulas() as $f)
                if ($f->name)
                    $this->_abbrev_matcher->add($f->name, $f, self::FSRCH_FORMULA);
        }
        return $this->_abbrev_matcher;
    }

    function find_all_fields($text, $tflags = 0) {
        return $this->abbrev_matcher()->find_all($text, $tflags);
    }


    function review_form_json() {
        $x = get($this->settingTexts, "review_form");
        if (is_string($x))
            $x = $this->settingTexts["review_form"] = json_decode($x);
        return is_object($x) ? $x : null;
    }

    function review_form() {
        if (!$this->_review_form_cache)
            $this->_review_form_cache = new ReviewForm($this->review_form_json(), $this);
        return $this->_review_form_cache;
    }

    function all_review_fields() {
        return $this->review_form()->all_fields();
    }

    function review_field($fid) {
        return $this->review_form()->field($fid);
    }

    function find_review_field($text) {
        return $this->abbrev_matcher()->find1($text, self::FSRCH_REVIEW);
    }



    function tags() {
        if (!$this->_taginfo)
            $this->_taginfo = TagMap::make($this);
        return $this->_taginfo;
    }



    function has_tracks() {
        return $this->tracks !== null;
    }

    function has_track_tags() {
        return $this->_track_tags !== null;
    }

    function track_tags() {
        return $this->_track_tags ? $this->_track_tags : array();
    }

    function permissive_track_tag_for(Contact $user, $perm) {
        foreach ($this->tracks ? : [] as $t => $tr)
            if ($user->has_permission($tr[$perm]))
                return $t;
        return null;
    }

    function check_tracks(PaperInfo $prow, Contact $user, $ttype) {
        $unmatched = true;
        if ($this->tracks) {
            foreach ($this->tracks as $t => $tr)
                if ($t === "_" ? $unmatched : $prow->has_tag($t)) {
                    $unmatched = false;
                    if ($user->has_permission($tr[$ttype]))
                        return true;
                }
        }
        return $unmatched;
    }

    function check_required_tracks(PaperInfo $prow, Contact $user, $ttype) {
        if ($this->_track_sensitivity & (1 << $ttype)) {
            $unmatched = true;
            foreach ($this->tracks as $t => $tr)
                if ($t === "_" ? $unmatched : $prow->has_tag($t)) {
                    $unmatched = false;
                    if ($tr[$ttype] && $user->has_permission($tr[$ttype]))
                        return true;
                }
        }
        return false;
    }

    function check_admin_tracks(PaperInfo $prow, Contact $user) {
        return $this->check_required_tracks($prow, $user, Track::ADMIN);
    }

    function check_default_track(Contact $user, $ttype) {
        return !$this->tracks || $user->has_permission($this->tracks["_"][$ttype]);
    }

    function check_any_tracks(Contact $user, $ttype) {
        if ($this->tracks)
            foreach ($this->tracks as $t => $tr)
                if (($ttype === Track::VIEW
                     || $user->has_permission($tr[Track::VIEW]))
                    && $user->has_permission($tr[$ttype]))
                    return true;
        return !$this->tracks;
    }

    function check_any_admin_tracks(Contact $user) {
        if ($this->_track_sensitivity & Track::BITS_ADMIN)
            foreach ($this->tracks as $t => $tr)
                if ($tr[Track::ADMIN] && $user->has_permission($tr[Track::ADMIN]))
                    return true;
        return false;
    }

    function check_all_tracks(Contact $user, $ttype) {
        if ($this->tracks)
            foreach ($this->tracks as $t => $tr)
                if (!(($ttype === Track::VIEW
                       || $user->has_permission($tr[Track::VIEW]))
                      && $user->has_permission($tr[$ttype])))
                    return false;
        return true;
    }

    function check_track_sensitivity($ttype) {
        return ($this->_track_sensitivity & (1 << $ttype)) !== 0;
    }

    function check_track_view_sensitivity() {
        return ($this->_track_sensitivity & Track::BITS_VIEW) !== 0;
    }

    function check_track_review_sensitivity() {
        return ($this->_track_sensitivity & Track::BITS_REVIEW) !== 0;
    }

    function track_permission($tag, $ttype) {
        if ($this->tracks)
            foreach ($this->tracks as $t => $tr)
                if (strcasecmp($t, $tag) === 0)
                    return $tr[$ttype];
        return null;
    }

    function dangerous_track_mask(Contact $user) {
        $m = 0;
        if ($this->tracks && $user->contactTags) {
            foreach ($this->tracks as $t => $tr)
                foreach ($tr as $i => $perm)
                    if ($perm
                        && $perm[0] === "-"
                        && !$user->has_permission($perm))
                        $m |= 1 << $i;
        }
        return $m;
    }


    function has_rounds() {
        return count($this->rounds) > 1;
    }

    function round_list() {
        return $this->rounds;
    }

    function round0_defined() {
        return isset($this->defined_round_list()[0]);
    }

    function defined_round_list() {
        if ($this->_defined_rounds === null) {
            $dl = [];
            foreach ($this->rounds as $i => $rname)
                if (!$i || $rname !== ";") {
                    foreach (self::$review_deadlines as $rd)
                        if (($dl[$i] = +get($this->settings, $rd . ($i ? "_$i" : ""))))
                            break;
                }
            if (!$dl[0]
                && !$this->fetch_ivalue("select exists (select * from PaperReview where reviewRound=0)"))
                unset($dl[0]);
            $r = [];
            foreach ($this->rounds as $i => $rname)
                if (isset($dl[$i]))
                    $r[$i] = $i ? $rname : "unnamed";
            uksort($r, function ($a, $b) use ($r, $dl) {
                $adl = get($dl, $a);
                $bdl = get($dl, $b);
                if ($adl && $bdl && $adl != $bdl)
                    return $adl < $bdl ? -1 : 1;
                else if (!$adl != !$bdl)
                    return $adl ? -1 : 1;
                else
                    return strcasecmp($a ? $r[$a] : "~", $b ? $r[$b] : "~");
            });
            $this->_defined_rounds = $r;
        }
        return $this->_defined_rounds;
    }

    function round_name($roundno) {
        if ($roundno > 0) {
            if (($rname = get($this->rounds, $roundno)) && $rname !== ";")
                return $rname;
            error_log($this->dbname . ": round #$roundno undefined");
        }
        return "";
    }

    function round_suffix($roundno) {
        if ($roundno > 0) {
            if (($rname = get($this->rounds, $roundno)) && $rname !== ";")
                return "_$rname";
        }
        return "";
    }

    static function round_name_error($rname) {
        if ((string) $rname === "")
            return "Empty round name.";
        else if (!preg_match('/\A[a-zA-Z][a-zA-Z0-9]*\z/', $rname))
            return "Round names must start with a letter and contain only letters and numbers.";
        else if (preg_match('/\A(?:none|any|all|default|unnamed|.*response|pri(?:mary)|sec(?:ondary)|opt(?:ional)|pc(?:review)|ext(?:ernal)|meta(?:review))\z/i', $rname))
            return "Round name $rname is reserved.";
        else
            return false;
    }

    function sanitize_round_name($rname) {
        if ($rname === null)
            return (string) get($this->settingTexts, "rev_roundtag");
        else if ($rname === "" || !strcasecmp($rname, "(none)")
                 || !strcasecmp($rname, "none") || !strcasecmp($rname, "unnamed"))
            return "";
        else if (self::round_name_error($rname))
            return false;
        else
            return $rname;
    }

    function assignment_round_option($external) {
        if (!$external || ($x = get($this->settingTexts, "extrev_roundtag")) === null)
            $x = (string) get($this->settingTexts, "rev_roundtag");
        return $x === "" ? "unnamed" : $x;
    }

    function assignment_round($external) {
        return $this->round_number($this->assignment_round_option($external), false);
    }

    function round_number($rname, $add) {
        if (!$rname || !strcasecmp($rname, "none") || !strcasecmp($rname, "unnamed"))
            return 0;
        for ($i = 1; $i != count($this->rounds); ++$i)
            if (!strcasecmp($this->rounds[$i], $rname))
                return $i;
        if ($add && !self::round_name_error($rname)) {
            $rtext = $this->setting_data("tag_rounds", "");
            $rtext = ($rtext ? "$rtext$rname " : " $rname ");
            $this->__save_setting("tag_rounds", 1, $rtext);
            $this->crosscheck_round_settings();
            return $this->round_number($rname, false);
        } else
            return false;
    }

    function round_selector_options($isexternal) {
        $opt = [];
        foreach ($this->defined_round_list() as $rname)
            $opt[$rname] = $rname;
        if (($isexternal === null || $isexternal === true)
            && ($r = get($this->settingTexts, "rev_roundtag")) !== null
            && !isset($opt[$r ? : "unnamed"]))
            $opt[$r ? : "unnamed"] = $r ? : "unnamed";
        if (($isexternal === null || $isexternal === false)
            && ($r = get($this->settingTexts, "extrev_roundtag")) !== null
            && !isset($opt[$r ? : "unnamed"]))
            $opt[$r ? : "unnamed"] = $r ? : "unnamed";
        return $opt;
    }

    function round_setting($name, $round, $defval = null) {
        if ($this->_round_settings !== null
            && $round !== null
            && isset($this->_round_settings[$round])
            && isset($this->_round_settings[$round]->$name))
            return $this->_round_settings[$round]->$name;
        else
            return get($this->settings, $name, $defval);
    }



    function resp_rounds() {
        if ($this->_resp_rounds === null) {
            $this->_resp_rounds = [];
            $x = get($this->settingTexts, "resp_rounds", "1");
            foreach (explode(" ", $x) as $i => $rname) {
                $r = new ResponseRound;
                $r->number = $i;
                $r->name = $rname;
                $isuf = $i ? "_$i" : "";
                $r->open = get($this->settings, "resp_open$isuf");
                $r->done = get($this->settings, "resp_done$isuf");
                $r->grace = get($this->settings, "resp_grace$isuf");
                $r->words = get($this->settings, "resp_words$isuf", 500);
                if (($s = get($this->settingTexts, "resp_search$isuf")))
                    $r->search = new PaperSearch($this->site_contact(), $s);
                $this->_resp_rounds[] = $r;
            }
        }
        return $this->_resp_rounds;
    }

    function resp_round_name($rnum) {
        $rrd = get($this->resp_rounds(), $rnum);
        return $rrd ? $rrd->name : "1";
    }

    function resp_round_text($rnum) {
        $rname = $this->resp_round_name($rnum);
        return $rname == "1" ? "" : $rname;
    }

    static function resp_round_name_error($rname) {
        if ((string) $rname === "")
            return "Empty round name.";
        else if (!preg_match('/\A[a-zA-Z][a-zA-Z0-9]*\z/', $rname))
            return "Round names must start with a letter and contain letters and numbers.";
        else if (preg_match('/\A(?:none|any|draft-?.*|.*response)\z/i', $rname))
            return "Round name “{$rname}” is reserved.";
        else
            return false;
    }

    function resp_round_number($rname) {
        if (!$rname
            || $rname === 1
            || $rname === "1"
            || $rname === true
            || strcasecmp($rname, "none") === 0)
            return 0;
        foreach ($this->resp_rounds() as $rrd)
            if (strcasecmp($rname, $rrd->name) === 0)
                return $rrd->number;
        return false;
    }


    function format_info($format) {
        if ($this->_format_info === null) {
            $this->_format_info = [];
            if (!isset($this->opt["formatInfo"]))
                /* OK */;
            else if (is_array($this->opt["formatInfo"]))
                $this->_format_info = $this->opt["formatInfo"];
            else if (is_string($this->opt["formatInfo"]))
                $this->_format_info = json_decode($this->opt["formatInfo"], true);
            foreach ($this->_format_info as $format => &$fi)
                $fi = new TextFormat($format, $fi);
        }
        if ($format === null)
            $format = $this->default_format;
        return get($this->_format_info, $format);
    }

    function check_format($format, $text = null) {
        if ($format === null)
            $format = $this->default_format;
        if ($format && $text !== null && ($f = $this->format_info($format))
            && $f->simple_regex && preg_match($f->simple_regex, $text))
            $format = 0;
        return $format;
    }


    function saved_searches() {
        $ss = [];
        foreach ($this->settingTexts as $k => $v)
            if (substr($k, 0, 3) === "ss:" && ($v = json_decode($v)))
                $ss[substr($k, 3)] = $v;
        return $ss;
    }


    // users

    function password_storage_cleartext() {
        return $this->opt["safePasswords"] < 1;
    }

    function external_login() {
        return isset($this->opt["ldapLogin"]) || isset($this->opt["httpAuthLogin"]);
    }

    function site_contact() {
        if (!$this->_site_contact) {
            $args = [
                "fullName" => $this->opt("contactName"),
                "email" => $this->opt("contactEmail"),
                "isChair" => true, "isPC" => true, "is_site_contact" => true,
                "contactTags" => null
            ];
            if (!$args["email"] || $args["email"] === "you@example.com") {
                $result = $this->ql("select firstName, lastName, email from ContactInfo where roles!=0 and (roles&" . (Contact::ROLE_CHAIR | Contact::ROLE_ADMIN) . ")!=0 order by (roles&" . Contact::ROLE_CHAIR . ") desc limit 1");
                if ($result && ($row = $result->fetch_object())) {
                    $this->set_opt("defaultSiteContact", true);
                    $this->set_opt("contactName", Text::name_text($row));
                    $this->set_opt("contactEmail", $row->email);
                    unset($args["fullName"]);
                    $args["email"] = $row->email;
                    $args["firstName"] = $row->firstName;
                    $args["lastName"] = $row->lastName;
                }
                Dbl::free($result);
            }
            $this->_site_contact = new Contact((object) $args, $this);
        }
        return $this->_site_contact;
    }

    function user_by_id($id) {
        $result = $this->qe("select * from ContactInfo where contactId=?", $id);
        $acct = Contact::fetch($result, $this);
        Dbl::free($result);
        return $acct;
    }

    function cached_user_by_id($id, $missing = false) {
        global $Me;
        if ($id && $Me && $Me->contactId == $id)
            return $Me;
        else if (isset($this->_pc_members_and_admins_cache[$id]))
            return $this->_pc_members_and_admins_cache[$id];
        else if (isset($this->_user_cache[$id]))
            return $this->_user_cache[$id];
        else if ($missing) {
            $this->_user_cache_missing[$id] = true;
            return null;
        } else
            return $this->user_by_id($id);
    }

    function load_missing_cached_users() {
        $n = 0;
        if ($this->_user_cache_missing) {
            $result = $this->qe("select " . $this->_cached_user_query() . " from ContactInfo where contactId?a", array_keys($this->_user_cache_missing));
            while ($result && ($u = Contact::fetch($result, $this))) {
                $this->_user_cache[$u->contactId] = $u;
                ++$n;
            }
            Dbl::free($result);
            $this->_user_cache_missing = null;
        }
        return $n > 0;
    }

    function user_by_email($email) {
        $acct = null;
        if (($email = trim((string) $email)) !== "") {
            $result = $this->qe("select * from ContactInfo where email=?", $email);
            $acct = Contact::fetch($result, $this);
            Dbl::free($result);
        }
        return $acct;
    }

    function user_id_by_email($email) {
        $result = $this->qe("select contactId from ContactInfo where email=?", trim($email));
        $row = edb_row($result);
        Dbl::free($result);
        return $row ? (int) $row[0] : false;
    }

    function cached_user_by_email($email) {
        global $Me;
        if ($email && $Me && strcasecmp($Me->email, $email) == 0)
            return $Me;
        else if (($u = $this->pc_member_by_email($email)))
            return $u;
        else
            return $this->user_by_email($email);
    }

    private function _cached_user_query() {
        if ($this->_pc_members_fully_loaded)
            return "*";
        else
            return "contactId, firstName, lastName, unaccentedName, affiliation, email, roles, contactTags, disabled";
    }

    function pc_members() {
        if ($this->_pc_members_cache === null) {
            $result = $this->q("select " . $this->_cached_user_query() . " from ContactInfo where roles!=0 and (roles&" . Contact::ROLE_PCLIKE . ")!=0");
            $pc = $by_name_text = [];
            $expected_by_name_count = 0;
            $this->_pc_tags_cache = ["pc" => "pc"];
            while ($result && ($u = Contact::fetch($result, $this))) {
                $pc[$u->contactId] = $u;
                $u->name_analysis = Text::analyze_name($u);
                if ($u->firstName || $u->lastName) {
                    $by_name_text[Text::name_text($u)][] = $u;
                    $expected_by_name_count += 1;
                }
                if ($u->contactTags)
                    foreach (explode(" ", $u->contactTags) as $t) {
                        list($tag, $value) = TagInfo::unpack($t);
                        if ($tag)
                            $this->_pc_tags_cache[strtolower($tag)] = $tag;
                    }
            }
            Dbl::free($result);

            if ($expected_by_name_count > count($by_name_text)) {
                foreach ($by_name_text as $us)
                    if (count($us) > 1) {
                        $npcus = 0;
                        foreach ($us as $u)
                            $npcus += ($u->roles & Contact::ROLE_PC ? 1 : 0);
                        foreach ($us as $u)
                            if ($npcus > 1 || ($u->roles & Contact::ROLE_PC) == 0) {
                                $u->nameAmbiguous = true;
                                $u->name_analysis = null;
                                $u->name_analysis = Text::analyze_name($u);
                            }
                    }
            }

            uasort($pc, "Contact::compare");
            $this->_pc_members_and_admins_cache = $pc;

            $this->_pc_members_cache = $this->_pc_chairs_cache = [];
            foreach ($pc as $u) {
                if ($u->roles & Contact::ROLE_PC) {
                    $u->sort_position = count($this->_pc_members_cache);
                    $this->_pc_members_cache[$u->contactId] = $u;
                }
                if ($u->roles & Contact::ROLE_CHAIR)
                    $this->_pc_chairs_cache[$u->contactId] = $u;
            }

            TagMap::collator()->asort($this->_pc_tags_cache);
        }
        return $this->_pc_members_cache;
    }

    function pc_members_and_admins() {
        if ($this->_pc_members_and_admins_cache === null)
            $this->pc_members();
        return $this->_pc_members_and_admins_cache;
    }

    function pc_chairs() {
        if ($this->_pc_chairs_cache === null)
            $this->pc_members();
        return $this->_pc_chairs_cache;
    }

    function full_pc_members() {
        if (!$this->_pc_members_fully_loaded) {
            if ($this->_pc_members_cache !== null) {
                $result = $this->q("select * from ContactInfo where roles!=0 and (roles&" . Contact::ROLE_PCLIKE . ")!=0");
                while ($result && ($u = $result->fetch_object())) {
                    if (($pc = get($this->_pc_members_and_admins_cache, $u->contactId)))
                        $pc->merge_secondary_properties($u);
                }
                Dbl::free($result);
            }
            $this->_user_cache = null;
            $this->_pc_members_fully_loaded = true;
        }
        return $this->pc_members();
    }

    function pc_member_by_id($cid) {
        return get($this->pc_members(), $cid);
    }

    function pc_member_by_email($email) {
        foreach ($this->pc_members() as $p)
            if (strcasecmp($p->email, $email) == 0)
                return $p;
        return null;
    }

    function pc_tags() {
        if ($this->_pc_tags_cache === null)
            $this->pc_members();
        return array_values($this->_pc_tags_cache);
    }

    function pc_tag_exists($tag) {
        if ($this->_pc_tags_cache === null)
            $this->pc_members();
        return isset($this->_pc_tags_cache[strtolower($tag)]);
    }

    function pc_completion_map() {
        $map = $bylevel = [];
        foreach ($this->pc_members_and_admins() as $pc)
            if (!$pc->is_disabled()) {
                foreach ($pc->completion_items() as $k => $level) {
                    if (!isset($bylevel[$k])
                        || $bylevel[$k] < $level
                        || get($map, $k) === $pc) {
                        $map[$k] = $pc;
                        $bylevel[$k] = $level;
                    } else
                        unset($map[$k]);
                }
            }
        return $map;
    }


    // contactdb

    function contactdb() {
        if ($this->_cdb === false) {
            $this->_cdb = null;
            if (($dsn = $this->opt("contactdb_dsn")))
                list($this->_cdb, $dbname) = Dbl::connect_dsn($dsn);
        }
        return $this->_cdb;
    }

    private function contactdb_user_by_key($key, $value) {
        if (($cdb = $this->contactdb())) {
            $q = "select ContactInfo.*, roles, activity_at";
            $qv = [];
            if (($confid = $this->opt("contactdb_confid"))) {
                $q .= ", ? confid from ContactInfo left join Roles on (Roles.contactDbId=ContactInfo.contactDbId and Roles.confid=?)";
                array_push($qv, $confid, $confid);
            } else {
                $q .= ", Conferences.confid from ContactInfo left join Conferences on (Conferences.`dbname`=?) left join Roles on (Roles.contactDbId=ContactInfo.contactDbId and Roles.confid=Conferences.confid)";
                $qv[] = $this->dbname;
            }
            $qv[] = $value;
            $result = Dbl::ql_apply($cdb, "$q where ContactInfo.$key=?", $qv);
            $acct = Contact::fetch($result, $this);
            Dbl::free($result);
            return $acct;
        } else
            return null;
    }

    function contactdb_user_by_email($email) {
        return $this->contactdb_user_by_key("email", $email);
    }

    function contactdb_user_by_id($id) {
        return $this->contactdb_user_by_key("contactDbId", $id);
    }


    // session data

    function session($name, $defval = null) {
        if (isset($_SESSION[$this->dsn])
            && isset($_SESSION[$this->dsn][$name]))
            return $_SESSION[$this->dsn][$name];
        else
            return $defval;
    }

    function save_session($name, $value) {
        if ($value !== null) {
            if (empty($_SESSION))
                ensure_session();
            $_SESSION[$this->dsn][$name] = $value;
        } else if (isset($_SESSION[$this->dsn])) {
            unset($_SESSION[$this->dsn][$name]);
            if (empty($_SESSION[$this->dsn]))
                unset($_SESSION[$this->dsn]);
        }
    }


    // update the 'papersub' setting: are there any submitted papers?
    function update_papersub_setting($adding) {
        if ($this->setting("no_papersub", 0) > 0 ? $adding >= 0 : $adding <= 0) {
            $this->qe("delete from Settings where name='no_papersub'");
            $this->qe("insert into Settings (name, value) select 'no_papersub', 1 from dual where exists (select * from Paper where timeSubmitted>0) = 0");
            $this->settings["no_papersub"] = $this->fetch_ivalue("select value from Settings where name='no_papersub'");
        }
    }

    function update_paperacc_setting($adding) {
        if ($this->setting("paperacc", 0) <= 0 ? $adding >= 0 : $adding <= 0) {
            $this->qe_raw("insert into Settings (name, value) select 'paperacc', exists (select * from Paper where outcome>0 and timeSubmitted>0) on duplicate key update value=values(value)");
            $this->settings["paperacc"] = $this->fetch_ivalue("select value from Settings where name='paperacc'");
        }
    }

    function update_rev_tokens_setting($adding) {
        if ($this->setting("rev_tokens", 0) === -1)
            $adding = 0;
        if ($this->setting("rev_tokens", 0) <= 0 ? $adding >= 0 : $adding <= 0) {
            $this->qe_raw("insert into Settings (name, value) select 'rev_tokens', exists (select * from PaperReview where reviewToken!=0) on duplicate key update value=values(value)");
            $this->settings["rev_tokens"] = $this->fetch_ivalue("select value from Settings where name='rev_tokens'");
        }
    }

    function update_paperlead_setting($adding) {
        if ($this->setting("paperlead", 0) <= 0 ? $adding >= 0 : $adding <= 0) {
            $this->qe_raw("insert into Settings (name, value) select 'paperlead', exists (select * from Paper where leadContactId>0 or shepherdContactId>0) on duplicate key update value=values(value)");
            $this->settings["paperlead"] = $this->fetch_ivalue("select value from Settings where name='paperlead'");
        }
    }

    function update_papermanager_setting($adding) {
        if ($this->setting("papermanager", 0) <= 0 ? $adding >= 0 : $adding <= 0) {
            $this->qe_raw("insert into Settings (name, value) select 'papermanager', exists (select * from Paper where managerContactId>0) on duplicate key update value=values(value)");
            $this->settings["papermanager"] = $this->fetch_ivalue("select value from Settings where name='papermanager'");
        }
    }

    function update_metareviews_setting($adding) {
        if ($this->setting("metareviews", 0) <= 0 ? $adding >= 0 : $adding <= 0) {
            $this->qe_raw("insert into Settings (name, value) select 'metareviews', exists (select * from PaperReview where reviewType=" . REVIEW_META . ") on duplicate key update value=values(value)");
            $this->settings["metareviews"] = $this->fetch_ivalue("select value from Settings where name='metareviews'");
        }
    }

    function update_autosearch_tags($paper = null) {
        if ((!$this->setting("tag_autosearch") && !$this->opt("definedTags"))
            || !$this->tags()->has_autosearch
            || $this->_updating_autosearch_tags)
            return;
        $csv = ["paper,tag"];
        if (!$paper) {
            foreach ($this->tags()->filter("autosearch") as $dt) {
                $csv[] = CsvGenerator::quote("#{$dt->tag}") . "," . CsvGenerator::quote("{$dt->tag}#clear");
                $csv[] = CsvGenerator::quote($dt->autosearch) . "," . CsvGenerator::quote($dt->tag);
            }
        } else {
            if (is_object($paper))
                $paper = $paper->paperId;
            $rowset = $this->paper_set(["paperId" => $paper]);
            foreach ($this->tags()->filter("autosearch") as $dt) {
                $search = new PaperSearch($this->site_contact(), ["q" => $dt->autosearch, "t" => "all"]);
                foreach ($rowset as $prow) {
                    $want = $search->test($prow);
                    if ($prow->has_tag($dt->tag) !== $want)
                        $csv[] = "{$prow->paperId}," . CsvGenerator::quote($dt->tag . ($want ? "" : "#clear"));
                }
            }
        }
        $this->_update_autosearch_tags_csv($csv);
    }

    function _update_autosearch_tags_csv($csv) {
        if (count($csv) > 1) {
            $this->_updating_autosearch_tags = true;
            $aset = new AssignmentSet($this->site_contact(), true);
            $aset->set_search_type("all");
            $aset->parse($csv);
            $aset->execute();
            $this->_updating_autosearch_tags = false;
        }
    }


    static private $invariant_row = null;

    private function invariantq($q, $args = []) {
        $result = $this->ql_apply($q, $args);
        if ($result) {
            self::$invariant_row = $result->fetch_row();
            $result->close();
            return !!self::$invariant_row;
        } else
            return null;
    }

    private function invariant_error(&$problems, $abbrev, $text = null) {
        $problems[$abbrev] = true;
        if ((string) $text === "")
            $text = $abbrev;
        trigger_error("$this->dbname invariant error: $text");
    }

    function check_invariants() {
        $ie = [];

        $any = $this->invariantq("select paperId from Paper where timeSubmitted>0 limit 1");
        if ($any !== !get($this->settings, "no_papersub"))
            $this->invariant_error($ie, "no_papersub");

        $any = $this->invariantq("select paperId from Paper where outcome>0 and timeSubmitted>0 limit 1");
        if ($any !== !!get($this->settings, "paperacc"))
            $this->invariant_error($ie, "paperacc");

        $any = $this->invariantq("select reviewId from PaperReview where reviewToken!=0 limit 1");
        if ($any !== !!get($this->settings, "rev_tokens"))
            $this->invariant_error($ie, "rev_tokens");

        $any = $this->invariantq("select paperId from Paper where leadContactId>0 or shepherdContactId>0 limit 1");
        if ($any !== !!get($this->settings, "paperlead"))
            $this->invariant_error($ie, "paperlead");

        $any = $this->invariantq("select paperId from Paper where managerContactId>0 limit 1");
        if ($any !== !!get($this->settings, "papermanager"))
            $this->invariant_error($ie, "papermanager");

        $any = $this->invariantq("select paperId from PaperReview where reviewType=" . REVIEW_META . " limit 1");
        if ($any !== !!get($this->settings, "metareviews"))
            $this->invariant_error($ie, "metareviews");

        // no empty text options
        $text_options = array();
        foreach ($this->paper_opts->option_list() as $ox)
            if ($ox->type === "text")
                $text_options[] = $ox->id;
        if (count($text_options)) {
            $any = $this->invariantq("select paperId from PaperOption where optionId?a and data='' limit 1", [$text_options]);
            if ($any)
                $this->invariant_error($ie, "text_option_empty", "text option with empty text");
        }

        // no funky PaperConflict entries
        $any = $this->invariantq("select paperId from PaperConflict where conflictType<=0 limit 1");
        if ($any)
            $this->invariant_error($ie, "PaperConflict_zero", "PaperConflict with zero conflictType");

        // reviewNeedsSubmit is defined correctly
        $any = $this->invariantq("select r.paperId, r.reviewId from PaperReview r
            left join (select paperId, requestedBy, count(reviewId) ct, count(reviewSubmitted) cs
                       from PaperReview where reviewType<" . REVIEW_SECONDARY . "
                       group by paperId, requestedBy) q
                on (q.paperId=r.paperId and q.requestedBy=r.contactId)
            where r.reviewType=" . REVIEW_SECONDARY . " and reviewSubmitted is null
            and if(coalesce(q.ct,0)=0,1,if(q.cs=0,-1,0))!=r.reviewNeedsSubmit
            limit 1");
        if ($any)
            $this->invariant_error($ie, "reviewNeedsSubmit", "bad reviewNeedsSubmit for review #" . self::$invariant_row[0] . "/" . self::$invariant_row[1]);

        // review rounds are defined
        $result = $this->qe("select reviewRound, count(*) from PaperReview group by reviewRound");
        $defined_rounds = $this->defined_round_list();
        while ($result && ($row = $result->fetch_row())) {
            if (!isset($defined_rounds[$row[0]]))
                $this->invariant_error($ie, "undefined_review_round", "{$row[1]} PaperReviews for reviewRound {$row[0]}, which is not defined");
        }
        Dbl::free($result);

        // anonymous users are disabled
        $any = $this->invariantq("select email from ContactInfo where email regexp '^anonymous[0-9]*\$' and not disabled limit 1");
        if ($any)
            $this->invariant_error($ie, "anonymous_user_enabled", "anonymous user is not disabled");

        // paper denormalizations match
        $any = $this->invariantq("select p.paperId from Paper p join PaperStorage ps on (ps.paperStorageId=p.paperStorageId) where p.finalPaperStorageId<=0 and p.paperStorageId>1 and (p.sha1!=ps.sha1 or p.size!=ps.size or p.mimetype!=ps.mimetype or p.timestamp!=ps.timestamp) limit 1");
        if ($any)
            $this->invariant_error($ie, "paper_denormalization", "bad Paper denormalization, paper #" . self::$invariant_row[0]);
        $any = $this->invariantq("select p.paperId from Paper p join PaperStorage ps on (ps.paperStorageId=p.finalPaperStorageId) where p.finalPaperStorageId>1 and (p.sha1 != ps.sha1 or p.size!=ps.size or p.mimetype!=ps.mimetype or p.timestamp!=ps.timestamp) limit 1");
        if ($any)
            $this->invariant_error($ie, "paper_final_denormalization", "bad Paper final denormalization, paper #" . self::$invariant_row[0]);

        // filterType is never zero
        $any = $this->invariantq("select paperStorageId from PaperStorage where filterType=0 limit 1");
        if ($any)
            $this->invariant_error($ie, "filterType", "bad PaperStorage filterType, id #" . self::$invariant_row[0]);

        // has_colontag is defined
        $any = $this->invariantq("select tag from PaperTag where tag like '%:' limit 1");
        if ($any && !$this->setting("has_colontag"))
            $this->invariant_error($ie, "has_colontag", "has tag " . self::$invariant_row[0] . " but no has_colontag");

        // has_topics is defined
        $any = $this->invariantq("select topicId from TopicArea limit 1");
        if (!$any !== !$this->setting("has_topics"))
            $this->invariant_error($ie, "has_topics");

        $this->check_document_inactive_invariants();

        // autosearches are correct
        if ($this->tags()->has_autosearch) {
            $autosearch_dts = array_values($this->tags()->filter("autosearch"));
            $q = join(" THEN ", array_map(function ($dt) {
                return "((" . $dt->autosearch . ") XOR #" . $dt->tag . ")";
            }, $autosearch_dts));
            $search = new PaperSearch($this->site_contact(), ["q" => $q, "t" => "all"]);
            $p = [];
            foreach ($search->paper_ids() as $pid) {
                $then = $search->thenmap ? $search->thenmap[$pid] : 0;
                if (!isset($p[$then])) {
                    $dt = $autosearch_dts[$then];
                    $this->invariant_error($ie, "autosearch", "autosearch #" . $dt->tag . " disagrees with search " . $dt->autosearch . " on #" . $pid);
                    $p[$then] = true;
                }
            }
        }

        return $ie;
    }

    function check_document_inactive_invariants() {
        $result = $this->ql("select paperStorageId, finalPaperStorageId from Paper");
        $pids = [];
        while ($result && ($row = $result->fetch_row())) {
            if ($row[0] > 1)
                $pids[] = (int) $row[0];
            if ($row[1] > 1)
                $pids[] = (int) $row[1];
        }
        sort($pids);
        $any = $this->invariantq("select s.paperId, s.paperStorageId from PaperStorage s where s.paperStorageId?a and s.inactive limit 1", [$pids]);
        if ($any)
            trigger_error("$this->dbname invariant error: paper " . self::$invariant_row[0] . " document " . self::$invariant_row[1] . " is inappropriately inactive");

        $oids = [];
        $nonempty_oids = [];
        foreach ($this->paper_opts->full_option_list() as $o)
            if ($o->has_document()) {
                $oids[] = $o->id;
                if (!$o->allow_empty_document())
                    $nonempty_oids[] = $o->id;
            }

        if (!empty($oids)) {
            $any = $this->invariantq("select o.paperId, o.optionId, s.paperStorageId from PaperOption o join PaperStorage s on (s.paperStorageId=o.value and s.inactive and s.paperStorageId>1) where o.optionId?a limit 1", [$oids]);
            if ($any)
                trigger_error("$this->dbname invariant error: paper " . self::$invariant_row[0] . " option " . self::$invariant_row[1] . " document " . self::$invariant_row[2] . " is inappropriately inactive");

            $any = $this->invariantq("select o.paperId, o.optionId, s.paperId from PaperOption o join PaperStorage s on (s.paperStorageId=o.value and s.paperStorageId>1 and s.paperId!=o.paperId) where o.optionId?a limit 1", [$oids]);
            if ($any)
                trigger_error("$this->dbname invariant error: paper " . self::$invariant_row[0] . " option " . self::$invariant_row[1] . " document belongs to different paper " . self::$invariant_row[2]);
        }

        if (!empty($nonempty_oids)) {
            $any = $this->invariantq("select o.paperId, o.optionId from PaperOption o where o.optionId?a and o.value<=1 limit 1", [$nonempty_oids]);
            if ($any)
                trigger_error("$this->dbname invariant error: paper " . self::$invariant_row[0] . " option " . self::$invariant_row[1] . " links to empty document");
        }

        $any = $this->invariantq("select l.paperId, l.linkId, s.paperStorageId from DocumentLink l join PaperStorage s on (l.documentId=s.paperStorageId and s.inactive) limit 1");
        if ($any)
            trigger_error("$this->dbname invariant error: paper " . self::$invariant_row[0] . " link " . self::$invariant_row[1] . " document " . self::$invariant_row[2] . " is inappropriately inactive");
    }


    function update_schema_version($n) {
        if (!$n)
            $n = $this->fetch_ivalue("select value from Settings where name='allowPaperOption'");
        if ($n && $this->ql("update Settings set value=? where name='allowPaperOption'", $n)) {
            $this->sversion = $this->settings["allowPaperOption"] = $n;
            return true;
        } else
            return false;
    }

    function invalidate_caches($caches = null) {
        if (!self::$no_invalidate_caches) {
            if (is_string($caches))
                $caches = [$caches => true];
            if (!$caches || isset($caches["pc"]))
                $this->_pc_members_cache = $this->_pc_tags_cache = $this->_pc_members_and_admins_cache = $this->_pc_chairs_cache = $this->_user_cache = null;
            if (!$caches || isset($caches["options"])) {
                $this->paper_opts->invalidate_option_list();
                $this->_formatspec_cache = [];
                $this->_abbrev_matcher = null;
            }
            if (!$caches || isset($caches["rf"])) {
                $this->_review_form_cache = $this->_defined_rounds = null;
                $this->_abbrev_matcher = null;
            }
            if (!$caches || isset($caches["taginfo"]) || isset($caches["tracks"]))
                $this->_taginfo = null;
            if (!$caches || isset($caches["formulas"]))
                $this->_formula_functions = null;
            if (!$caches || isset($caches["assigners"]))
                $this->_assignment_parsers = null;
            if (!$caches || isset($caches["tracks"]))
                Contact::update_rights();
        }
    }


    // times

    private function _dateFormat($type) {
        if (!$this->_date_format_initialized) {
            if (!isset($this->opt["time24hour"]) && isset($this->opt["time24Hour"]))
                $this->opt["time24hour"] = $this->opt["time24Hour"];
            if (!isset($this->opt["dateFormatLong"]) && isset($this->opt["dateFormat"]))
                $this->opt["dateFormatLong"] = $this->opt["dateFormat"];
            if (!isset($this->opt["dateFormat"]))
                $this->opt["dateFormat"] = get($this->opt, "time24hour") ? "j M Y H:i:s" : "j M Y g:i:sa";
            if (!isset($this->opt["dateFormatLong"]))
                $this->opt["dateFormatLong"] = "l " . $this->opt["dateFormat"];
            if (!isset($this->opt["dateFormatObscure"]))
                $this->opt["dateFormatObscure"] = "j M Y";
            if (!isset($this->opt["timestampFormat"]))
                $this->opt["timestampFormat"] = $this->opt["dateFormat"];
            if (!isset($this->opt["dateFormatSimplifier"]))
                $this->opt["dateFormatSimplifier"] = get($this->opt, "time24hour") ? "/:00(?!:)/" : "/:00(?::00|)(?= ?[ap]m)/";
            if (!isset($this->opt["dateFormatTimezone"]))
                $this->opt["dateFormatTimezone"] = null;
            $this->_date_format_initialized = true;
        }
        if ($type === "timestamp")
            return $this->opt["timestampFormat"];
        else if ($type === "obscure")
            return $this->opt["dateFormatObscure"];
        else if ($type === "long")
            return $this->opt["dateFormatLong"];
        else
            return $this->opt["dateFormat"];
    }
    private function _unparse_timezone($value) {
        $z = $this->opt["dateFormatTimezone"];
        if ($z === null) {
            $z = date("T", $value);
            if ($z === "-12")
                $z = "AoE";
            else if ($z && ($z[0] === "+" || $z[0] === "-"))
                $z = "UTC" . $z;
        }
        return $z;
    }

    function parseableTime($value, $include_zone) {
        $f = $this->_dateFormat(false);
        $d = date($f, $value);
        if ($this->opt["dateFormatSimplifier"])
            $d = preg_replace($this->opt["dateFormatSimplifier"], "", $d);
        if ($include_zone && ($z = $this->_unparse_timezone($value)))
            $d .= " $z";
        return $d;
    }
    function parse_time($d, $reference = null) {
        global $Now;
        if ($reference === null)
            $reference = $Now;
        if (!isset($this->opt["dateFormatTimezoneRemover"])) {
            $x = array();
            if (function_exists("timezone_abbreviations_list")) {
                $mytz = date_default_timezone_get();
                foreach (timezone_abbreviations_list() as $tzname => $tzinfo) {
                    foreach ($tzinfo as $tz)
                        if ($tz["timezone_id"] == $mytz)
                            $x[] = preg_quote($tzname);
                }
            }
            if (empty($x)) {
                $z = date("T", $reference);
                if ($z === "-12")
                    $x[] = "AoE";
                $x[] = preg_quote($z);
            }
            $this->opt["dateFormatTimezoneRemover"] =
                "/(?:\\s|\\A)(?:" . join("|", $x) . ")(?:\\s|\\z)/i";
        }
        if ($this->opt["dateFormatTimezoneRemover"])
            $d = preg_replace($this->opt["dateFormatTimezoneRemover"], " ", $d);
        $d = preg_replace_callback('/\b(utc(?=[-+])|aoe(?=\s|\z))/i', function ($m) {
            return strcasecmp($m[1], "aoe") === 0 ? "GMT-1200" : "GMT";
        }, $d);
        return strtotime($d, $reference);
    }

    private function _unparse_time($value, $type, $useradjust, $preadjust = null) {
        if ($value <= 0)
            return "N/A";
        $t = date($this->_dateFormat($type), $value);
        if ($this->opt["dateFormatSimplifier"])
            $t = preg_replace($this->opt["dateFormatSimplifier"], "", $t);
        if ($type !== "obscure" && ($z = $this->_unparse_timezone($value)))
            $t .= " $z";
        if ($preadjust)
            $t .= $preadjust;
        if ($useradjust) {
            $sp = strpos($useradjust, " ");
            $t .= "<$useradjust class=\"usertime hidden need-usertime\" data-time=\"$value\"></" . ($sp ? substr($useradjust, 0, $sp) : $useradjust) . ">";
        }
        return $t;
    }
    function obscure_time($timestamp) {
        if ($timestamp !== null)
            $timestamp = (int) ($timestamp + 0.5);
        if ($timestamp > 0) {
            $offset = 0;
            if (($zone = timezone_open(date_default_timezone_get())))
                $offset = $zone->getOffset(new DateTime("@$timestamp"));
            $timestamp += 43200 - ($timestamp + $offset) % 86400;
        }
        return $timestamp;
    }
    function unparse_time_long($value, $useradjust = false, $preadjust = null) {
        return $this->_unparse_time($value, "long", $useradjust, $preadjust);
    }
    function unparse_time($value) {
        return $this->_unparse_time($value, "timestamp", false, null);
    }
    function unparse_time_obscure($value) {
        return $this->_unparse_time($value, "obscure", false, null);
    }
    function unparse_time_log($value) {
        return date("d/M/Y:H:i:s O", $value);
    }
    function unparse_time_relative($when, $now = 0, $format = 0) {
        global $Now;
        $d = abs($when - ($now ? : $Now));
        $unit = 0;
        if ($d >= 5227200) {
            if (!($format & 1))
                return ($format & 8 ? "on " : "") . date($this->_dateFormat("obscure"), $when);
            $unit = 5;
        } else if ($d >= 259200)
            $unit = 4;
        else if ($d >= 28800)
            $unit = 3;
        else if ($d >= 3630)
            $unit = 2;
        else if ($d >= 180.5)
            $unit = 1;
        $units = [1, 60, 1800, 3600, 86400, 604800];
        $x = $units[$unit];
        $d = ceil(($d - $x / 2) / $x);
        if ($unit === 2)
            $d /= 2;
        if ($format & 4)
            $d .= substr("smhhdw", $unit, 1);
        else {
            $unit_names = ["second", "minute", "hour", "hour", "day", "week"];
            $d .= " " . $unit_names[$unit] . ($d == 1 ? "" : "s");
        }
        if ($format & 2)
            return $d;
        else
            return $when < ($now ? : $Now) ? $d . " ago" : "in " . $d;
    }

    function printableTimeSetting($what, $useradjust = false, $preadjust = null) {
        return $this->unparse_time_long(defval($this->settings, $what, 0), $useradjust, $preadjust);
    }
    function printableDeadlineSetting($what, $useradjust = false, $preadjust = null) {
        if (!isset($this->settings[$what]) || $this->settings[$what] <= 0)
            return "No deadline";
        else
            return "Deadline: " . $this->unparse_time_long($this->settings[$what], $useradjust, $preadjust);
    }

    function settingsAfter($name) {
        global $Now;
        $t = get($this->settings, $name);
        return $t !== null && $t > 0 && $t <= $Now;
    }
    function deadlinesAfter($name, $grace = null) {
        global $Now;
        $t = get($this->settings, $name);
        if ($t !== null && $t > 0 && $grace && ($g = get($this->settings, $grace)))
            $t += $g;
        return $t !== null && $t > 0 && $t <= $Now;
    }
    function deadlinesBetween($name1, $name2, $grace = null) {
        // see also ResponseRound::time_allowed
        global $Now;
        $t = get($this->settings, $name1);
        if (($t === null || $t <= 0 || $t > $Now) && $name1)
            return false;
        $t = get($this->settings, $name2);
        if ($t !== null && $t > 0 && $grace && ($g = get($this->settings, $grace)))
            $t += $g;
        return $t === null || $t <= 0 || $t >= $Now;
    }

    function timeStartPaper() {
        return $this->deadlinesBetween("sub_open", "sub_reg", "sub_grace");
    }
    function timeUpdatePaper($prow = null) {
        return $this->deadlinesBetween("sub_open", "sub_update", "sub_grace")
            && (!$prow || $prow->timeSubmitted <= 0 || $this->setting("sub_freeze") <= 0);
    }
    function timeFinalizePaper($prow = null) {
        return $this->deadlinesBetween("sub_open", "sub_sub", "sub_grace")
            && (!$prow || $prow->timeSubmitted <= 0 || $this->setting('sub_freeze') <= 0);
    }
    function collectFinalPapers() {
        return $this->setting("final_open") > 0;
    }
    function time_submit_final_version() {
        return $this->deadlinesBetween("final_open", "final_done", "final_grace");
    }
    function can_some_author_view_review($reviewsOutstanding = false) {
        return $this->any_response_open
            || ($this->au_seerev > 0
                && ($this->au_seerev != self::AUSEEREV_UNLESSINCOMPLETE
                    || !$reviewsOutstanding));
    }
    function can_all_author_view_decision() {
        return $this->setting("seedec") == self::SEEDEC_ALL;
    }
    function can_some_author_view_decision() {
        return $this->setting("seedec") == self::SEEDEC_ALL;
    }
    function time_review_open() {
        global $Now;
        $rev_open = +get($this->settings, "rev_open");
        return 0 < $rev_open && $rev_open <= $Now;
    }
    function review_deadline($round, $isPC, $hard) {
        $dn = ($isPC ? "pcrev_" : "extrev_") . ($hard ? "hard" : "soft");
        if ($round === null)
            $round = $this->assignment_round(!$isPC);
        else if (is_object($round))
            $round = $round->reviewRound ? : 0;
        if ($round && isset($this->settings["{$dn}_$round"]))
            $dn .= "_$round";
        return $dn;
    }
    function missed_review_deadline($round, $isPC, $hard) {
        global $Now;
        $rev_open = +get($this->settings, "rev_open");
        if (!(0 < $rev_open && $rev_open <= $Now))
            return "rev_open";
        $dn = $this->review_deadline($round, $isPC, $hard);
        $dv = +get($this->settings, $dn);
        if ($dv > 0 && $dv < $Now)
            return $dn;
        return false;
    }
    function time_review($round, $isPC, $hard) {
        return !$this->missed_review_deadline($round, $isPC, $hard);
    }
    function timePCReviewPreferences() {
        return $this->can_pc_see_active_submissions() || $this->has_any_submitted();
    }
    function timePCViewDecision($conflicted) {
        $s = $this->setting("seedec");
        if ($conflicted)
            return $s == self::SEEDEC_ALL || $s == self::SEEDEC_REV;
        else
            return $s >= self::SEEDEC_REV;
    }
    function time_reviewer_view_decision() {
        return $this->setting("seedec") >= self::SEEDEC_REV;
    }
    function time_reviewer_view_accepted_authors() {
        return $this->setting("seedec") == self::SEEDEC_ALL;
    }
    function timePCViewPaper($prow, $pdf) {
        if ($prow->timeWithdrawn > 0)
            return false;
        else if ($prow->timeSubmitted > 0)
            return !$pdf || $this->_pc_see_pdf;
        else
            return !$pdf && $this->can_pc_see_active_submissions();
    }

    function submission_blindness() {
        return $this->settings["sub_blind"];
    }
    function subBlindAlways() {
        return $this->settings["sub_blind"] == self::BLIND_ALWAYS;
    }
    function subBlindNever() {
        return $this->settings["sub_blind"] == self::BLIND_NEVER;
    }
    function subBlindOptional() {
        return $this->settings["sub_blind"] == self::BLIND_OPTIONAL;
    }
    function subBlindUntilReview() {
        return $this->settings["sub_blind"] == self::BLIND_UNTILREVIEW;
    }

    function is_review_blind($rrow) {
        $rb = $this->settings["rev_blind"];
        if ($rb == self::BLIND_ALWAYS)
            return true;
        else if ($rb != self::BLIND_OPTIONAL)
            return false;
        if (is_object($rrow))
            $rrow = (bool) $rrow->reviewBlind;
        return $rrow === null || $rrow;
    }
    function review_blindness() {
        return $this->settings["rev_blind"];
    }
    function can_some_external_reviewer_view_comment() {
        return $this->settings["extrev_view"] == 2;
    }

    function has_any_submitted() {
        return !get($this->settings, "no_papersub");
    }
    function has_any_pc_visible_pdf() {
        return $this->has_any_submitted() && $this->_pc_see_pdf;
    }
    function has_any_accepted() {
        return !!get($this->settings, "paperacc");
    }

    function count_submitted_accepted() {
        $dlt = max($this->setting("sub_sub"), $this->setting("sub_close"));
        $result = $this->qe("select outcome, count(paperId) from Paper where timeSubmitted>0 " . ($dlt ? "or (timeSubmitted=-100 and timeWithdrawn>=$dlt) " : "") . "group by outcome");
        $n = $nyes = 0;
        while (($row = edb_row($result))) {
            $n += $row[1];
            if ($row[0] > 0)
                $nyes += $row[1];
        }
        Dbl::free($result);
        return [$n, $nyes];
    }

    function has_any_lead_or_shepherd() {
        return !!get($this->settings, "paperlead");
    }

    function has_any_manager() {
        return ($this->_track_sensitivity & Track::BITS_ADMIN)
            || !!get($this->settings, "papermanager");
    }

    function has_any_metareviews() {
        return !!get($this->settings, "metareviews");
    }

    function can_pc_see_active_submissions() {
        if ($this->_pc_seeall_cache === null) {
            $this->_pc_seeall_cache = get($this->settings, "pc_seeall") ? : 0;
            if ($this->_pc_seeall_cache > 0 && !$this->timeFinalizePaper())
                $this->_pc_seeall_cache = 0;
        }
        return $this->_pc_seeall_cache > 0;
    }


    function set_siteurl($base) {
        $old_siteurl = Navigation::siteurl();
        $base = Navigation::set_siteurl($base);
        if ($this->opt["assetsUrl"] === $old_siteurl) {
            $this->opt["assetsUrl"] = $base;
            Ht::$img_base = $this->opt["assetsUrl"] . "images/";
        }
        if ($this->opt["scriptAssetsUrl"] === $old_siteurl)
            $this->opt["scriptAssetsUrl"] = $base;
    }

    const HOTURL_RAW = 1;
    const HOTURL_POST = 2;
    const HOTURL_ABSOLUTE = 4;
    const HOTURL_SITE_RELATIVE = 8;
    const HOTURL_NO_DEFAULTS = 16;

    function hoturl($page, $options = null, $flags = 0) {
        global $Me;
        $nav = Navigation::get();
        $amp = ($flags & self::HOTURL_RAW ? "&" : "&amp;");
        $t = $page . $nav->php_suffix;
        $are = '/\A(|.*?(?:&|&amp;))';
        $zre = '(?:&(?:amp;)?|\z)(.*)\z/';
        // parse options, separate anchor
        $anchor = "";
        if (is_array($options)) {
            $x = "";
            foreach ($options as $k => $v) {
                if ($v === null || $v === false)
                    /* skip */;
                else if ($k === "anchor")
                    $anchor = "#" . urlencode($v);
                else
                    $x .= ($x === "" ? "" : $amp) . $k . "=" . urlencode($v);
            }
            if (Conf::$hoturl_defaults && !($flags & self::HOTURL_NO_DEFAULTS))
                foreach (Conf::$hoturl_defaults as $k => $v)
                    if (!array_key_exists($k, $options))
                        $x .= ($x === "" ? "" : $amp) . $k . "=" . $v;
            $options = $x;
        } else {
            $options = (string) $options;
            if (($pos = strpos($options, "#"))) {
                $anchor = substr($options, $pos);
                $options = substr($options, 0, $pos);
            }
            if (Conf::$hoturl_defaults && !($flags & self::HOTURL_NO_DEFAULTS))
                foreach (Conf::$hoturl_defaults as $k => $v)
                    if (!preg_match($are . preg_quote($k) . '=/', $options))
                        $options .= ($options === "" ? "" : $amp) . $k . "=" . $v;
        }
        if ($flags & self::HOTURL_POST)
            $options .= ($options === "" ? "" : $amp) . "post=" . post_value();
        // append forceShow to links to same paper if appropriate
        $is_paper_page = preg_match('/\A(?:paper|review|comment|assign)\z/', $page);
        if ($is_paper_page
            && $this->paper
            && $Me->can_administer($this->paper)
            && $this->paper->has_conflict($Me)
            && $Me->conf === $this
            && preg_match($are . 'p=' . $this->paper->paperId . $zre, $options)
            && !preg_match($are . 'forceShow=/', $options))
            $options .= $amp . "forceShow=1";
        // create slash-based URLs if appropriate
        if ($options) {
            if ($page === "review"
                && preg_match($are . 'r=(\d+[A-Z]+)' . $zre, $options, $m)) {
                $t .= "/" . $m[2];
                $options = $m[1] . $m[3];
                if (preg_match($are . 'p=\d+' . $zre, $options, $m))
                    $options = $m[1] . $m[2];
            } else if (($is_paper_page
                        && preg_match($are . 'p=(\d+|%\w+%|new)' . $zre, $options, $m))
                       || ($page === "help"
                           && preg_match($are . 't=(\w+)' . $zre, $options, $m))
                       || ($page === "settings"
                           && preg_match($are . 'group=(\w+)' . $zre, $options, $m))) {
                $t .= "/" . $m[2];
                $options = $m[1] . $m[3];
                if ($options !== ""
                    && $page === "paper"
                    && preg_match($are . 'm=(\w+)' . $zre, $options, $m)) {
                    $t .= "/" . $m[2];
                    $options = $m[1] . $m[3];
                }
            } else if (($page === "profile"
                        && preg_match($are . 'u=([^&?]+)' . $zre, $options, $m))
                       || ($page === "graph"
                           && preg_match($are . 'g=([^&?]+)' . $zre, $options, $m))
                       || ($page === "doc"
                           && preg_match($are . 'file=([^&]+)' . $zre, $options, $m))) {
                $t .= "/" . str_replace("%2F", "/", $m[2]);
                $options = $m[1] . $m[3];
            } else if (preg_match($are . '__PATH__=([^&]+)' . $zre, $options, $m)) {
                $t .= "/" . urldecode($m[2]);
                $options = $m[1] . $m[3];
            }
            $options = preg_replace('/&(?:amp;)?\z/', "", $options);
        }
        if ($options !== "" && preg_match('/\A&(?:amp;)?(.*)\z/', $options, $m))
            $options = $m[1];
        if ($options !== "")
            $t .= "?" . $options;
        if ($anchor !== "")
            $t .= $anchor;
        if ($flags & self::HOTURL_SITE_RELATIVE)
            return $t;
        $need_site_path = false;
        if ($page === "index") {
            $expect = "index" . $nav->php_suffix;
            $lexpect = strlen($expect);
            if (substr($t, 0, $lexpect) === $expect
                && ($t === $expect || $t[$lexpect] === "?" || $t[$lexpect] === "#")) {
                $need_site_path = true;
                $t = substr($t, $lexpect);
            }
        }
        if (($flags & self::HOTURL_ABSOLUTE) || $this !== Conf::$g)
            return $this->opt("paperSite") . "/" . $t;
        else {
            $siteurl = $nav->site_path_relative;
            if ($need_site_path && $siteurl === "")
                $siteurl = $nav->site_path;
            return $siteurl . $t;
        }
    }

    function hoturl_absolute($page, $options = null, $flags = 0) {
        return $this->hoturl($page, $options, self::HOTURL_ABSOLUTE | $flags);
    }

    function hoturl_site_relative_raw($page, $options = null) {
        return $this->hoturl($page, $options, self::HOTURL_SITE_RELATIVE | self::HOTURL_RAW);
    }

    function hoturl_post($page, $options = null) {
        return $this->hoturl($page, $options, self::HOTURL_POST);
    }

    function hotlink($html, $page, $options = null, $js = null) {
        return Ht::link($html, $this->hoturl($page, $options), $js);
    }


    static $selfurl_safe = [
        "p" => true, "paperId" => "p", "pap" => "p",
        "r" => true, "reviewId" => "r",
        "c" => true, "commentId" => "c",
        "m" => true, "mode" => true, "u" => true, "g" => true,
        "q" => true, "t" => true, "qa" => true, "qo" => true, "qx" => true, "qt" => true,
        "fx" => true, "fy" => true,
        "forceShow" => true, "tab" => true, "atab" => true, "sort" => true,
        "group" => true, "monreq" => true, "noedit" => true,
        "contact" => true, "reviewer" => true,
        "editcomment" => true
    ];

    function selfurl(Qrequest $qreq = null, $params = [], $flags = 0) {
        global $Qreq;
        $qreq = $qreq ? : $Qreq;

        $x = [];
        foreach ($qreq->make_array() as $k => $v) {
            $ak = get(self::$selfurl_safe, $k);
            if ($ak === true)
                $ak = $k;
            if ($ak
                && ($ak === $k || !isset($qreq[$ak]))
                && !array_key_exists($ak, $params)
                && !is_array($v))
                $x[$ak] = $v;
        }
        foreach ($params as $k => $v)
            $x[$k] = $v;
        return $this->hoturl(Navigation::page(), $x, $flags);
    }

    function self_redirect(Qrequest $qreq = null, $params = []) {
        Navigation::redirect($this->selfurl($qreq, $params, self::HOTURL_RAW));
    }


    //
    // Paper storage
    //

    function active_document_ids() {
        $q = array("select paperStorageId from Paper where paperStorageId>1",
            "select finalPaperStorageId from Paper where finalPaperStorageId>1",
            "select paperStorageId from PaperComment where paperStorageId>1");
        $document_option_ids = array();
        foreach ($this->paper_opts->option_list() as $id => $o)
            if ($o->has_document())
                $document_option_ids[] = $id;
        if (!empty($document_option_ids))
            $q[] = "select value from PaperOption where optionId in ("
                . join(",", $document_option_ids) . ") and value>1";

        $result = $this->qe_raw(join(" UNION ", $q));
        $ids = array();
        while (($row = edb_row($result)))
            $ids[(int) $row[0]] = true;
        Dbl::free($result);
        ksort($ids);
        return array_keys($ids);
    }

    function document_by_id($did, PaperInfo $prow = null) {
        $result = $this->qe("select * from PaperStorage where paperStorageId=?"
            . ($prow ? " and paperId={$prow->paperId}" : ""), $did);
        $doc = DocumentInfo::fetch($result, $this, $prow);
        Dbl::free($result);
        return $doc;
    }

    function download_documents($docs, $attachment) {
        if (count($docs) == 1
            && $docs[0]->paperStorageId <= 1
            && (!isset($docs[0]->content) || $docs[0]->content === "")) {
            self::msg_error("Paper #" . $docs[0]->paperId . " hasn’t been uploaded yet.");
            return false;
        }

        foreach ($docs as $doc)
            $doc->filename = $doc->export_filename();
        $downloadname = false;
        if (count($docs) > 1) {
            $o = $this->paper_opts->get($docs[0]->documentType);
            $name = $o->dtype_name();
            if ($docs[0]->documentType <= 0)
                $name = pluralize($name);
            $downloadname = $this->download_prefix . "$name.zip";
        }
        $result = Filer::multidownload($docs, $downloadname, $attachment);
        if ($result->error) {
            self::msg_error($result->error_html);
            return false;
        } else
            return true;
    }


    //
    // Paper search
    //

    static private function _cvt_numeric_set($optarr) {
        $ids = array();
        if (is_object($optarr))
            $optarr = $optarr->selection();
        foreach (mkarray($optarr) as $x)
            if (($x = cvtint($x)) > 0)
                $ids[] = $x;
        return $ids;
    }

    function query_all_reviewer_preference() {
        return "group_concat(contactId,' ',preference,' ',coalesce(expertise,'.'))";
    }

    function paper_result($options, Contact $user = null) {
        // Options:
        //   "paperId" => $pid  Only paperId $pid (if array, any of those)
        //   "reviewId" => $rid Only paper reviewed by $rid
        //   "commentId" => $c  Only paper where comment is $c
        //   "finalized"        Only submitted papers
        //   "unsub"            Only unsubmitted papers
        //   "accepted"         Only accepted papers
        //   "active"           Only nonwithdrawn papers
        //   "author"           Only papers authored by $contactId
        //   "myReviewRequests" Only reviews requested by $contactId
        //   "myReviews"        All reviews authored by $contactId
        //   "myOutstandingReviews" All unsubmitted reviews auth by $contactId
        //   "myConflicts"      Only conflicted papers
        //   "commenterName"    Include commenter names
        //   "tags"             Include paperTags
        //   "minimal"          Only include minimal paper fields
        //   "tagIndex" => $tag Include tagIndex of named tag
        //   "tagIndex" => tag array -- include tagIndex, tagIndex1, ...
        //   "topics"
        //   "options"
        //   "scores" => array(fields to score)
        //   "assignments"
        //   "order" => $sql    $sql is SQL 'order by' clause (or empty)

        $contactId = $user ? $user->contactId : 0;
        if (is_int($options)
            || (is_array($options) && !empty($options) && !is_associative_array($options)))
            $options = ["paperId" => $options];

        // paper selection
        $paperset = array();
        if (isset($options["paperId"]))
            $paperset[] = self::_cvt_numeric_set($options["paperId"]);
        if (isset($options["reviewId"])) {
            if (is_numeric($options["reviewId"])) {
                $result = $this->qe("select paperId from PaperReview where reviewId=?", $options["reviewId"]);
                $paperset[] = self::_cvt_numeric_set(edb_first_columns($result));
            } else if (preg_match('/^(\d+)([A-Z][A-Z]?)$/i', $options["reviewId"], $m)) {
                $result = $this->qe("select paperId from PaperReview where paperId=? and reviewOrdinal=?", $m[1], parseReviewOrdinal($m[2]));
                $paperset[] = self::_cvt_numeric_set(edb_first_columns($result));
            } else
                $paperset[] = array();
        }
        if (isset($options["commentId"])) {
            $result = $this->qe("select paperId from PaperComment where commentId?a", self::_cvt_numeric_set($options["commentId"]));
            $paperset[] = self::_cvt_numeric_set(edb_first_columns($result));
        }
        if (count($paperset) > 1)
            $paperset = array(call_user_func_array("array_intersect", $paperset));
        $papersel = "";
        if (!empty($paperset))
            $papersel = "paperId" . sql_in_numeric_set($paperset[0]) . " and ";

        // prepare query: basic tables
        // * Every table in `$joins` can have at most one row per paperId,
        //   except for `PaperReview`.
        $where = array();

        $joins = array("Paper");

        if (get($options, "minimal"))
            $cols = ["Paper.paperId, Paper.timeSubmitted, Paper.timeWithdrawn, Paper.outcome, Paper.leadContactId"];
        else
            $cols = ["Paper.*"];

        if ($user) {
            $aujoinwhere = null;
            if (get($options, "author")
                && ($aujoinwhere = $user->act_author_view_sql("PaperConflict", true)))
                $where[] = $aujoinwhere;
            if (get($options, "author") && !$aujoinwhere)
                $joins[] = "join PaperConflict on (PaperConflict.paperId=Paper.paperId and PaperConflict.contactId=$contactId and PaperConflict.conflictType>=" . CONFLICT_AUTHOR . ")";
            else
                $joins[] = "left join PaperConflict on (PaperConflict.paperId=Paper.paperId and PaperConflict.contactId=$contactId)";
            $cols[] = "PaperConflict.conflictType";
        } else if (get($options, "author"))
            $where[] = "false";

        // my review
        $no_paperreview = $paperreview_is_my_reviews = false;
        $reviewjoin = "PaperReview.paperId=Paper.paperId and " . ($user ? $user->act_reviewer_sql("PaperReview") : "false");
        if (get($options, "myReviews")) {
            $joins[] = "join PaperReview on ($reviewjoin)";
            $paperreview_is_my_reviews = true;
        } else if (get($options, "myOutstandingReviews"))
            $joins[] = "join PaperReview on ($reviewjoin and reviewNeedsSubmit!=0)";
        else if (get($options, "myReviewRequests"))
            $joins[] = "join PaperReview on (PaperReview.paperId=Paper.paperId and requestedBy=" . ($contactId ? : -100) . " and reviewType=" . REVIEW_EXTERNAL . ")";
        else
            $no_paperreview = true;

        // review signatures
        if (get($options, "reviewSignatures")
            || get($options, "scores")
            || get($options, "reviewWordCounts")) {
            $cols[] = "(select " . ReviewInfo::review_signature_sql($this, get($options, "scores")) . " from PaperReview r where r.paperId=Paper.paperId) reviewSignatures";
            if (get($options, "reviewWordCounts"))
                $cols[] = "(select group_concat(coalesce(reviewWordCount,'.') order by reviewId) from PaperReview where PaperReview.paperId=Paper.paperId) reviewWordCountSignature";
        } else if ($user) {
            // need myReviewPermissions
            if ($no_paperreview)
                $joins[] = "left join PaperReview on ($reviewjoin)";
            if ($no_paperreview || $paperreview_is_my_reviews)
                $cols[] = PaperInfo::my_review_permissions_sql("PaperReview.") . " myReviewPermissions";
            else
                $cols[] = "(select " . PaperInfo::my_review_permissions_sql() . " from PaperReview where $reviewjoin group by paperId) myReviewPermissions";
        }

        // fields
        if (get($options, "topics"))
            $cols[] = "(select group_concat(topicId) from PaperTopic where PaperTopic.paperId=Paper.paperId) topicIds";

        if (get($options, "options")
            && (isset($this->settingTexts["options"]) || isset($this->opt["fixedOptions"]))
            && $this->paper_opts->count_option_list())
            $cols[] = "(select group_concat(PaperOption.optionId, '#', value) from PaperOption where paperId=Paper.paperId) optionIds";
        else if (get($options, "options"))
            $cols[] = "'' as optionIds";

        if (get($options, "tags")
            || ($user && $user->isPC)
            || $this->has_tracks())
            $cols[] = "(select group_concat(' ', tag, '#', tagIndex order by tag separator '') from PaperTag where PaperTag.paperId=Paper.paperId) paperTags";
        if (get($options, "tagIndex") && !is_array($options["tagIndex"]))
            $options["tagIndex"] = array($options["tagIndex"]);
        if (get($options, "tagIndex"))
            foreach ($options["tagIndex"] as $i => $tag)
                $cols[] = "(select tagIndex from PaperTag where PaperTag.paperId=Paper.paperId and PaperTag.tag='" . sqlq($tag) . "') tagIndex" . ($i ? : "");

        if (get($options, "reviewerPreference")) {
            $joins[] = "left join PaperReviewPreference on (PaperReviewPreference.paperId=Paper.paperId and PaperReviewPreference.contactId=$contactId)";
            $cols[] = "coalesce(PaperReviewPreference.preference, 0) as reviewerPreference";
            $cols[] = "PaperReviewPreference.expertise as reviewerExpertise";
        }

        if (get($options, "allReviewerPreference"))
            $cols[] = "(select " . $this->query_all_reviewer_preference() . " from PaperReviewPreference where PaperReviewPreference.paperId=Paper.paperId) allReviewerPreference";

        if (get($options, "allConflictType"))
            // See also SearchQueryInfo::add_allConflictType_column
            $cols[] = "(select group_concat(contactId, ' ', conflictType) from PaperConflict where PaperConflict.paperId=Paper.paperId) allConflictType";

        if (get($options, "watch") && $contactId) {
            $joins[] = "left join PaperWatch on (PaperWatch.paperId=Paper.paperId and PaperWatch.contactId=$contactId)";
            $cols[] = "PaperWatch.watch";
        }

        // conditions
        if (!empty($paperset))
            $where[] = "Paper.paperId" . sql_in_numeric_set($paperset[0]);
        if (get($options, "finalized"))
            $where[] = "timeSubmitted>0";
        else if (get($options, "unsub"))
            $where[] = "timeSubmitted<=0";
        if (get($options, "accepted"))
            $where[] = "outcome>0";
        if (get($options, "undecided"))
            $where[] = "outcome=0";
        if (get($options, "active")
            || get($options, "myReviews")
            || get($options, "myReviewRequests"))
            $where[] = "timeWithdrawn<=0";
        if (get($options, "myLead"))
            $where[] = "leadContactId=$contactId";
        if (get($options, "unmanaged"))
            $where[] = "managerContactId=0";
        if (get($options, "myManaged"))
            $where[] = "managerContactId=$contactId";
        if (get($options, "myWatching") && $contactId) {
            // return the papers with explicit or implicit WATCH_REVIEW
            // (i.e., author/reviewer/commenter); or explicitly managed
            // papers
            $owhere = [
                "PaperConflict.conflictType>=" . CONFLICT_AUTHOR,
                "PaperReview.reviewType>0",
                "exists (select * from PaperComment where paperId=Paper.paperId and contactId=$contactId)",
                "(PaperWatch.watch&" . Contact::WATCH_REVIEW . ")!=0"
            ];
            if ($this->has_any_lead_or_shepherd())
                $owhere[] = "leadContactId=$contactId";
            if ($this->has_any_manager() && $user->is_explicit_manager())
                $owhere[] = "managerContactId=$contactId";
            $where[] = "(" . join(" or ", $owhere) . ")";
        }
        if (get($options, "myConflicts"))
            $where[] = $contactId ? "PaperConflict.conflictType>0" : "false";

        $pq = "select " . join(",\n    ", $cols)
            . "\nfrom " . join("\n    ", $joins);
        if (!empty($where))
            $pq .= "\nwhere " . join("\n    and ", $where);

        $pq .= "\ngroup by Paper.paperId\n";
        // This `having` is probably faster than a `where exists` if most papers
        // have at least one tag.
        if (get($options, "tags") === "require")
            $pq .= "having paperTags!=''\n";
        $pq .= get($options, "order", "order by Paper.paperId") . "\n";

        //Conf::msg_debugt($pq);
        return $this->qe_raw($pq);
    }

    function paper_set($options, Contact $user = null) {
        $rowset = new PaperInfoSet;
        $result = $this->paper_result($options, $user);
        while (($prow = PaperInfo::fetch($result, $user, $this)))
            $rowset->add($prow);
        Dbl::free($result);
        return $rowset;
    }

    function fetch_paper($options, Contact $user = null) {
        $result = $this->paper_result($options, $user);
        $prow = PaperInfo::fetch($result, $user, $this);
        Dbl::free($result);
        return $prow;
    }

    function set_paper_request(Qrequest $qreq, Contact $user) {
        $this->paper = $prow = null;
        if ($qreq->p) {
            if (ctype_digit($qreq->p))
                $prow = $this->fetch_paper(intval($qreq->p), $user);
            if (($whynot = $user->perm_view_paper($prow, false, $qreq->p)))
                $qreq->set_annex("paper_whynot", $whynot);
            else
                $this->paper = $prow;
        }
        return $this->paper;
    }


    function preference_conflict_result($type, $extra) {
        $q = "select PRP.paperId, PRP.contactId, PRP.preference
                from PaperReviewPreference PRP
                join ContactInfo c on (c.contactId=PRP.contactId and c.roles!=0 and (c.roles&" . Contact::ROLE_PC . ")!=0)
                join Paper P on (P.paperId=PRP.paperId)
                left join PaperConflict PC on (PC.paperId=PRP.paperId and PC.contactId=PRP.contactId)
                where PRP.preference<=-100 and coalesce(PC.conflictType,0)<=0
                  and P.timeWithdrawn<=0";
        if ($type !== "all" && $type !== "act")
            $q .= " and P.timeSubmitted>0";
        if ($extra)
            $q .= " " . $extra;
        return $this->ql_raw($q);
    }


    //
    // Message routines
    //

    static function msg_on(Conf $conf = null, $type, $text) {
        if (PHP_SAPI === "cli") {
            if (is_array($text))
                $text = join("\n", $text);
            if ($type === "xmerror" || $type === "merror" || $type === 2)
                fwrite(STDERR, "$text\n");
            else if ($type === "xwarning" || $type === "warning" || $type === 1
                     || !defined("HOTCRP_TESTHARNESS"))
                fwrite(STDOUT, "$text\n");
        } else if ($conf && !$conf->headerPrinted) {
            ensure_session();
            $_SESSION[$conf->dsn]["msgs"][] = [$type, $text];
        } else if ($type[0] === "x" || is_int($type))
            echo Ht::msg($text, $type);
        else {
            if (is_array($text))
                $text = '<div class="multimessage">' . join("", array_map(function ($x) { return '<div class="mmm">' . $x . '</div>'; }, $text)) . '</div>';
            echo "<div class=\"$type\">$text</div>";
        }
    }

    function msg($type, $text) {
        self::msg_on($this, $type, $text);
    }

    function infoMsg($text, $minimal = false) {
        $this->msg($minimal ? "xinfo" : "info", $text);
    }

    static function msg_info($text, $minimal = false) {
        self::msg_on(self::$g, $minimal ? "xinfo" : "info", $text);
    }

    function warnMsg($text, $minimal = false) {
        $this->msg($minimal ? "xwarning" : "warning", $text);
    }

    static function msg_warning($text, $minimal = false) {
        self::msg_on(self::$g, $minimal ? "xwarning" : "warning", $text);
    }

    function confirmMsg($text, $minimal = false) {
        $this->msg($minimal ? "xconfirm" : "confirm", $text);
    }

    static function msg_confirm($text, $minimal = false) {
        self::msg_on(self::$g, $minimal ? "xconfirm" : "confirm", $text);
    }

    function errorMsg($text, $minimal = false) {
        $this->msg($minimal ? "xmerror" : "merror", $text);
        return false;
    }

    static function msg_error($text, $minimal = false) {
        self::msg_on(self::$g, $minimal ? "xmerror" : "merror", $text);
        return false;
    }

    static function msg_debugt($text) {
        if (is_object($text) || is_array($text) || $text === null || $text === false || $text === true)
            $text = json_encode_browser($text);
        self::msg_on(self::$g, "merror", Ht::pre_text_wrap($text));
        return false;
    }

    function post_missing_msg() {
        $this->msg("merror", "Your uploaded data wasn’t received. This can happen on unusually slow connections, or if you tried to upload a file larger than I can accept.");
    }


    //
    // Conference header, footer
    //

    function has_active_list() {
        return !!$this->_active_list;
    }

    function active_list() {
        if ($this->_active_list === false)
            $this->_active_list = null;
        return $this->_active_list;
    }

    function set_active_list(SessionList $list = null) {
        assert($this->_active_list === false);
        $this->_active_list = $list;
    }

    function make_css_link($url, $media = null) {
        global $ConfSitePATH;
        if (str_starts_with($url, "<meta") || str_starts_with($url, "<link"))
            return $url;
        $t = '<link rel="stylesheet" type="text/css" href="';
        $absolute = preg_match(',\A(?:https:?:|/),i', $url);
        if (!$absolute)
            $t .= $this->opt["assetsUrl"];
        $t .= htmlspecialchars($url);
        if (!$absolute && ($mtime = @filemtime("$ConfSitePATH/$url")) !== false)
            $t .= "?mtime=$mtime";
        if ($media)
            $t .= '" media="' . $media;
        return $t . '">';
    }

    function make_script_file($url, $no_strict = false, $integrity = null) {
        global $ConfSitePATH;
        if (str_starts_with($url, "scripts/")) {
            $post = "";
            if (($mtime = @filemtime("$ConfSitePATH/$url")) !== false)
                $post = "mtime=$mtime";
            if (get($this->opt, "strictJavascript") && !$no_strict)
                $url = $this->opt["scriptAssetsUrl"] . "cacheable.php?file=" . urlencode($url)
                    . "&strictjs=1" . ($post ? "&$post" : "");
            else
                $url = $this->opt["scriptAssetsUrl"] . $url . ($post ? "?$post" : "");
            if ($this->opt["scriptAssetsUrl"] === Navigation::siteurl())
                return Ht::script_file($url);
        }
        return Ht::script_file($url, ["crossorigin" => "anonymous", "integrity" => $integrity]);
    }

    private function make_jquery_script_file($jqueryVersion) {
        $integrity = null;
        if ($this->opt("jqueryCdn")) {
            if ($jqueryVersion === "1.12.4")
                $integrity = "sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=";
            else if ($jqueryVersion === "3.1.1")
                $integrity = "sha256-hVVnYaiADRTO2PzUGmuLJr8BLUSjGIZsDYGmIJLv2b8=";
            else if ($jqueryVersion === "3.2.1")
                $integrity = "sha256-hwg4gsxgFZhOsEEamdOYGBf13FyQuiTwlAQgxVSNgt4=";
            else if ($jqueryVersion === "3.3.1")
                $integrity = "sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8=";
            $jquery = "//code.jquery.com/jquery-{$jqueryVersion}.min.js";
        } else
            $jquery = "scripts/jquery-{$jqueryVersion}.min.js";
        return $this->make_script_file($jquery, true, $integrity);
    }

    function prepare_content_security_policy() {
        if (($csp = $this->opt("contentSecurityPolicy"))) {
            if (is_string($csp))
                $csp = [$csp];
            else if ($csp === true)
                $csp = [];
            $report_only = false;
            if (($pos = array_search("'report-only'", $csp)) !== false) {
                $report_only = true;
                array_splice($csp, $pos, 1);
            }
            if (empty($csp))
                array_push($csp, "script-src", "'nonce'");
            if (($pos = array_search("'nonce'", $csp)) !== false) {
                $nonceval = base64_encode(random_bytes(16));
                $csp[$pos] = "'nonce-$nonceval'";
                Ht::set_script_nonce($nonceval);
            }
            header("Content-Security-Policy"
                   . ($report_only ? "-Report-Only: " : ": ")
                   . join(" ", $csp));
        }
    }

    function set_cookie($name, $value, $expires_at) {
        setcookie($name, $value, $expires_at, Navigation::site_path(),
                  $this->opt("sessionDomain", ""), $this->opt("sessionSecure", false));
    }

    function header_head($title, $extra = null) {
        global $Me, $Now, $ConfSitePATH;
        // clear session list cookies
        foreach ($_COOKIE as $k => $v)
            if (str_starts_with($k, "hotlist-info"))
                $this->set_cookie($k, "", $Now - 86400);

        echo "<!DOCTYPE html>
<html lang=\"en\">
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">
<meta name=\"google\" content=\"notranslate\">\n";
        if (!$this->opt("allowIndexPapers") && $this->paper)
            echo "<meta name=\"robots\" content=\"noindex,noarchive\">\n";

        if (($font_script = $this->opt("fontScript"))) {
            if (!str_starts_with($font_script, "<script"))
                $font_script = Ht::script($font_script);
            echo $font_script, "\n";
        }

        foreach (mkarray($this->opt("prependStylesheets", [])) as $css)
            echo $this->make_css_link($css), "\n";
        echo $this->make_css_link("stylesheets/style.css"), "\n";
        if ($this->opt("mobileStylesheet")) {
            echo '<meta name="viewport" content="width=device-width, initial-scale=1">', "\n";
            echo $this->make_css_link("stylesheets/mobile.css", "screen and (max-width: 1024px)"), "\n";
        }
        foreach (mkarray($this->opt("stylesheets", [])) as $css)
            echo $this->make_css_link($css), "\n";

        // favicon
        $favicon = $this->opt("favicon", "images/review24.png");
        if ($favicon) {
            if (strpos($favicon, "://") === false && $favicon[0] != "/") {
                if ($this->opt["assetsUrl"] && substr($favicon, 0, 7) === "images/")
                    $favicon = $this->opt["assetsUrl"] . $favicon;
                else
                    $favicon = Navigation::siteurl() . $favicon;
            }
            if (substr($favicon, -4) == ".png")
                echo "<link rel=\"icon\" type=\"image/png\" href=\"$favicon\">\n";
            else if (substr($favicon, -4) == ".ico")
                echo "<link rel=\"shortcut icon\" href=\"$favicon\">\n";
            else if (substr($favicon, -4) == ".gif")
                echo "<link rel=\"icon\" type=\"image/gif\" href=\"$favicon\">\n";
            else
                echo "<link rel=\"icon\" href=\"$favicon\">\n";
        }

        // title
        echo "<title>";
        if ($title) {
            $title = preg_replace("/<([^>\"']|'[^']*'|\"[^\"]*\")*>/", "", $title);
            $title = preg_replace(",(?: |&nbsp;|\302\240)+,", " ", $title);
            $title = str_replace("&#x2215;", "-", $title);
        }
        if ($title && $title !== "Home" && $title !== "Sign in")
            echo $title, " - ";
        echo htmlspecialchars($this->short_name), "</title>\n</head>\n";

        // jQuery
        $stash = Ht::unstash();
        if (isset($this->opt["jqueryUrl"]))
            Ht::stash_html($this->make_script_file($this->opt["jqueryUrl"], true) . "\n");
        else {
            $jqueryVersion = get($this->opt, "jqueryVersion", "3.3.1");
            if ($jqueryVersion[0] === "3") {
                Ht::stash_html("<!--[if lt IE 9]>" . $this->make_jquery_script_file("1.12.4") . "<![endif]-->\n");
                Ht::stash_html("<![if !IE|gte IE 9]>" . $this->make_jquery_script_file($jqueryVersion) . "<![endif]>\n");
            } else
                Ht::stash_html($this->make_jquery_script_file($jqueryVersion) . "\n");
        }
        if ($this->opt("jqueryMigrate"))
            Ht::stash_html($this->make_script_file("//code.jquery.com/jquery-migrate-3.0.0.js", true));

        // Javascript settings to set before script.js
        $nav = Navigation::get();
        Ht::stash_script("siteurl=" . json_encode_browser($nav->site_path_relative)
            . ";siteurl_base_path=" . json_encode_browser($nav->base_path)
            . ";siteurl_suffix=\"" . $nav->php_suffix . "\"");
        $p = "";
        if (($x = $this->opt("sessionDomain")))
            $p .= "; domain=" . $x;
        if ($this->opt("sessionSecure"))
            $p .= "; secure";
        Ht::stash_script("siteurl_postvalue=" . json_encode(post_value(true)) . ";siteurl_cookie_params=" . json_encode($p));
        if (self::$hoturl_defaults) {
            $urldefaults = [];
            foreach (self::$hoturl_defaults as $k => $v) {
                $urldefaults[$k] = urldecode($v);
            }
            Ht::stash_script("siteurl_defaults=" . json_encode_browser($urldefaults) . ";");
        }
        Ht::stash_script("assetsurl=" . json_encode_browser($this->opt["assetsUrl"]) . ";");
        $huser = (object) array();
        if ($Me && $Me->email)
            $huser->email = $Me->email;
        if ($Me && $Me->is_pclike())
            $huser->is_pclike = true;
        if ($Me && $Me->has_database_account())
            $huser->cid = $Me->contactId;
        Ht::stash_script("hotcrp_user=" . json_encode_browser($huser) . ";");

        $pid = $extra ? get($extra, "paperId") : null;
        $pid = $pid && ctype_digit($pid) ? (int) $pid : 0;
        if (!$pid && $this->paper)
            $pid = $this->paper->paperId;
        if ($pid)
            Ht::stash_script("hotcrp_paperid=$pid");
        if ($pid && $Me && $Me->is_admin_force())
            Ht::stash_script("hotcrp_want_override_conflict=true");

        // script.js
        if (!$this->opt("noDefaultScript"))
            Ht::stash_html($this->make_script_file("scripts/script.js") . "\n");

        // other scripts
        foreach ($this->opt("scripts", []) as $file)
            Ht::stash_html($this->make_script_file($file) . "\n");

        if ($stash)
            Ht::stash_html($stash);
    }

    function has_interesting_deadline($my_deadlines) {
        global $Now;
        if (get($my_deadlines->sub, "open"))
            foreach (["reg", "update", "sub"] as $k)
                if ($Now <= get($my_deadlines->sub, $k, 0) || get($my_deadlines->sub, "{$k}_ingrace"))
                    return true;
        if (get($my_deadlines, "is_author") && get($my_deadlines, "resps"))
            foreach (get($my_deadlines, "resps") as $r)
                if ($r->open && ($Now <= $r->done || get($r, "ingrace")))
                    return true;
        return false;
    }

    function header_body($title, $id, $extra = null) {
        global $ConfSitePATH, $Me, $Now;
        echo "<body";
        if ($id)
            echo ' id="body-', $id, '"';
        $class = get($extra, "class");
        if (($list = $this->active_list()))
            $class = ($class ? $class . " " : "") . "has-hotlist";
        if ($class)
            echo ' class="', $class, '"';
        if ($list)
            echo ' data-hotlist="', htmlspecialchars($list->info_string()), '"';
        echo ">\n";

        // initial load (JS's timezone offsets are negative of PHP's)
        Ht::stash_script("hotcrp_load.time(" . (-date("Z", $Now) / 60) . "," . ($this->opt("time24hour") ? 1 : 0) . ")");

        // deadlines settings
        $my_deadlines = null;
        if ($Me) {
            $my_deadlines = $Me->my_deadlines($this->paper);
            Ht::stash_script("hotcrp_deadlines.init(" . json_encode_browser($my_deadlines) . ")");
        }
        if ($this->default_format)
            Ht::stash_script("render_text.set_default_format(" . $this->default_format . ")");

        echo '<div id="header">';

        // site header
        $is_home = $id === "home";
        $site_div = '<div id="header-site" class="'
            . ($is_home ? "header-site-home" : "header-site-page")
            . '"><h1><a class="qq" href="' . $this->hoturl("index") . '">'
            . '<span class="header-site-name">'
            . htmlspecialchars($this->short_name) . '</span>';
        if (!$is_home)
            $site_div .= ' Home';
        $site_div .= '</a></h1></div>';

        // $header_profile
        $profile_html = "";
        if ($Me && !$Me->is_empty()) {
            // profile link
            $profile_parts = [];
            if ($Me->has_email() && !$Me->is_disabled()) {
                $profile_parts[] = '<a class="q" href="' . $this->hoturl("profile") . '"><strong>'
                    . htmlspecialchars($Me->email)
                    . '</strong></a> &nbsp; <a href="' . $this->hoturl("profile") . '">Profile</a>';
            }

            // "act as" link
            if (($actas = get($_SESSION, "last_actas"))
                && (($Me->privChair && strcasecmp($actas, $Me->email) !== 0)
                    || Contact::$true_user)) {
                // Link becomes true user if not currently chair.
                $actas = Contact::$true_user ? Contact::$true_user->email : $actas;
                $profile_parts[] = "<a href=\""
                    . $this->selfurl(null, ["actas" => Contact::$true_user ? null : $actas]) . "\">"
                    . (Contact::$true_user ? "Admin" : htmlspecialchars($actas))
                    . "&nbsp;" . Ht::img("viewas.png", "Act as " . htmlspecialchars($actas))
                    . "</a>";
            }

            // help, sign out
            $x = ($id == "search" ? "t=$id" : ($id == "settings" ? "t=chair" : ""));
            if (!$Me->is_disabled())
                $profile_parts[] = '<a href="' . $this->hoturl("help", $x) . '">Help</a>';
            if (!$Me->has_email() && !isset($this->opt["httpAuthLogin"]))
                $profile_parts[] = '<a href="' . $this->hoturl("index", "signin=1") . '" class="nw">Sign in</a>';
            if (!$Me->is_empty() || isset($this->opt["httpAuthLogin"]))
                $profile_parts[] = '<a href="' . $this->hoturl_post("index", "signout=1") . '" class="nw">Sign out</a>';

            if (!empty($profile_parts))
                $profile_html .= join(' <span class="barsep">·</span> ', $profile_parts);
        }

        $action_bar = get($extra, "action_bar");
        if ($action_bar === null)
            $action_bar = actionBar();

        $title_div = get($extra, "title_div");
        if (!$title_div) {
            if ($title && $title !== "Home")
                $title_div = '<div id="header-page"><h1>' . $title . '</h1></div>';
            else if ($action_bar)
                $title_div = '<hr class="c">';
        }

        echo $site_div, '<div id="header-right">', $profile_html;
        if ($my_deadlines && $this->has_interesting_deadline($my_deadlines))
            echo '<div id="header-deadline">&nbsp;</div>';
        else
            echo '<div id="header-deadline" class="hidden"></div>';
        echo '</div>', ($title_div ? : ""), ($action_bar ? : "");

        echo "  <hr class=\"c\"></div>\n";

        $this->headerPrinted = true;
        echo "<div id=\"msg-initial\">\n";
        if (($x = $this->opt("maintenance")))
            echo Ht::msg(is_string($x) ? $x : "<strong>The site is down for maintenance.</strong> Please check back later.", 2);
        if ($Me
            && ($msgs = $Me->session("msgs"))
            && !empty($msgs)) {
            $Me->save_session("msgs", null);
            foreach ($msgs as $m)
                $this->msg($m[0], $m[1]);
        }
        echo "</div>\n";

        echo "<div id=\"body\" class=\"body\">\n";

        // If browser owns tracker, send it the script immediately
        if ($this->setting("tracker")
            && MeetingTracker::session_owns_tracker($this))
            echo Ht::unstash();

        // Callback for version warnings
        if ($Me
            && $Me->privChair
            && (!isset($_SESSION["updatecheck"])
                || $_SESSION["updatecheck"] + 3600 <= $Now)
            && (!isset($this->opt["updatesSite"]) || $this->opt["updatesSite"])) {
            $m = isset($this->opt["updatesSite"]) ? $this->opt["updatesSite"] : "//hotcrp.lcdf.org/updates";
            $m .= (strpos($m, "?") === false ? "?" : "&")
                . "addr=" . urlencode($_SERVER["SERVER_ADDR"])
                . "&base=" . urlencode(Navigation::siteurl())
                . "&version=" . HOTCRP_VERSION;
            $v = HOTCRP_VERSION;
            if (is_dir("$ConfSitePATH/.git")) {
                $args = array();
                exec("export GIT_DIR=" . escapeshellarg($ConfSitePATH) . "/.git; git rev-parse HEAD 2>/dev/null; git merge-base origin/master HEAD 2>/dev/null", $args);
                if (count($args) >= 1) {
                    $m .= "&git-head=" . urlencode($args[0]);
                    $v .= " " . $args[0];
                }
                if (count($args) >= 2) {
                    $m .= "&git-upstream=" . urlencode($args[1]);
                    $v .= " " . $args[1];
                }
            }
            Ht::stash_script("check_version(\"$m\",\"$v\")");
            $_SESSION["updatecheck"] = $Now;
        }
    }

    function header($title, $id, $extra = null) {
        if (!$this->headerPrinted) {
            $this->header_head($title, $extra);
            $this->header_body($title, $id, $extra);
        }
    }

    static function git_status() {
        global $ConfSitePATH;
        $args = array();
        if (is_dir("$ConfSitePATH/.git"))
            exec("export GIT_DIR=" . escapeshellarg($ConfSitePATH) . "/.git; git rev-parse HEAD 2>/dev/null; git rev-parse v" . HOTCRP_VERSION . " 2>/dev/null", $args);
        return count($args) == 2 ? $args : null;
    }

    function footer() {
        global $Me, $ConfSitePATH;
        echo "</div>\n", // class='body'
            '<div id="footer"><div id="footer-crp">',
            $this->opt("extraFooter", ""),
            '<a class="uu" href="https://hotcrp.com/">HotCRP</a>';
        if (!$this->opt("noFooterVersion")) {
            if ($Me && $Me->privChair) {
                echo " v", HOTCRP_VERSION;
                if (($git_data = self::git_status()) && $git_data[0] !== $git_data[1])
                    echo " [", substr($git_data[0], 0, 7), "...]";
            } else
                echo "<!-- Version ", HOTCRP_VERSION, " -->";
        }
        echo "</div>\n  <hr class=\"c\"></div>\n";
        echo Ht::unstash(), "</body>\n</html>\n";
    }

    function hotcrp_pc_json(Contact $user) {
        $hpcj = $list = [];
        foreach ($this->pc_members() as $pcm) {
            $hpcj[$pcm->contactId] = $j = (object) ["name" => $user->name_text_for($pcm), "email" => $pcm->email];
            if (($color_classes = $user->user_color_classes_for($pcm)))
                $j->color_classes = $color_classes;
            if ($this->sort_by_last && $pcm->lastName) {
                $r = Text::analyze_name($pcm);
                if (strlen($r->lastName) !== strlen($r->name))
                    $j->lastpos = strlen($r->firstName) + 1;
                if ($r->nameAmbiguous && $r->name !== "" && $r->email !== "")
                    $j->emailpos = strlen($r->name) + 1;
            }
            $list[] = $pcm->contactId;
        }
        $hpcj["__order__"] = $list;
        if ($this->sort_by_last)
            $hpcj["__sort__"] = "last";
        if ($user->can_view_user_tags())
            $hpcj["__tags__"] = $user->viewable_user_tags();
        if ($this->paper
            && ($user->privChair || $user->allow_administer($this->paper))) {
            $list = [];
            foreach ($this->pc_members() as $pcm)
                if ($pcm->can_accept_review_assignment($this->paper))
                    $list[] = $pcm->contactId;
            $hpcj["__assignable__"] = [$this->paper->paperId => $list];
        }
        return $hpcj;
    }

    function stash_hotcrp_pc(Contact $user, $always = false) {
        if (($always || !$this->opt("largePC")) && Ht::mark_stash("hotcrp_pc"))
            Ht::stash_script("demand_load.pc(" . json_encode_browser($this->hotcrp_pc_json($user)) . ");");
    }


    //
    // Action recording
    //

    const action_log_query = "insert into ActionLog (ipaddr, contactId, destContactId, trueContactId, paperId, timestamp, action) values ?v";

    function save_logs($on) {
        if ($on && $this->_save_logs === false)
            $this->_save_logs = array();
        else if (!$on && $this->_save_logs !== false) {
            $qv = [];
            $last_pids = null;
            foreach ($this->_save_logs as $cid_text => $pids) {
                $pos = strpos($cid_text, "|");
                list($user, $dest_user, $true_user) = explode(",", substr($cid_text, 0, $pos));
                $what = substr($cid_text, $pos + 1);
                $pids = array_keys($pids);

                // Combine `Tag:` messages
                if (substr($what, 0, 5) === "Tag: "
                    && ($n = count($qv)) > 0
                    && substr($qv[$n-1][4], 0, 5) === "Tag: "
                    && $last_pids === $pids) {
                    $qv[$n-1][4] = $what . substr($qv[$n-1][4], 4);
                    continue;
                }

                $qv[] = self::format_log_values($what, $user, $dest_user, $true_user, $pids);
                $last_pids = $pids;
            }
            if (!empty($qv))
                $this->qe(self::action_log_query, $qv);
            $this->_save_logs = false;
        }
    }

    private static function log_clean_user($user, &$text) {
        if (!$user)
            return 0;
        else if (!is_numeric($user)) {
            if ($user->email && !$user->contactId && !$user->is_site_contact)
                $text .= " <{$user->email}>";
            return $user->contactId;
        } else
            return $user;
    }

    function log_for($user, $dest_user, $text, $pids = null) {
        $true_user = 0;
        if ($user && is_object($user) && $user->is_actas_user())
            $true_user = Contact::$true_user->contactId;
        $user = self::log_clean_user($user, $text);
        $dest_user = self::log_clean_user($dest_user, $text);

        if (is_object($pids))
            $pids = array($pids->paperId);
        else if (!is_array($pids))
            $pids = $pids > 0 ? array($pids) : array();
        $ps = array();
        foreach ($pids as $p)
            $ps[] = is_object($p) ? $p->paperId : $p;

        if ($this->_save_logs === false) {
            $this->qe(self::action_log_query,
                [self::format_log_values($text, $user, $dest_user, $true_user, $ps)]);
        } else {
            $key = "$user,$dest_user,$true_user|$text";
            if (!isset($this->_save_logs[$key]))
                $this->_save_logs[$key] = [];
            foreach ($ps as $p)
                $this->_save_logs[$key][$p] = true;
        }
    }

    private static function format_log_values($text, $user, $dest_user, $true_user, $pids) {
        global $Now;
        $pid = null;
        if (count($pids) == 1)
            $pid = $pids[0];
        else if (count($pids) > 1)
            $text .= " (papers " . join(", ", $pids) . ")";
        $user = (int) $user;
        $dest_user = (int) $dest_user;
        if ($dest_user === 0 || $dest_user === $user)
            $dest_user = null;
        return [get($_SERVER, "REMOTE_ADDR"), $user, $dest_user,
                (int) $true_user ? : null, $pid, $Now, substr($text, 0, 4096)];
    }


    // capabilities

    function capability_manager($for = null) {
        if ($for && substr($for, 0, 1) === "U") {
            if (($cdb = $this->contactdb()))
                return new CapabilityManager($cdb, "U");
            else
                return null;
        } else
            return new CapabilityManager($this->dblink, "");
    }


    // messages

    function ims() {
        if (!$this->_ims) {
            $this->_ims = new IntlMsgSet;
            $this->_ims->add_requirement_resolver([$this, "resolve_ims_requirement"]);
            $m = ["?etc/msgs.json"];
            if (($lang = $this->opt("lang")))
                $m[] = "?etc/msgs.$lang.json";
            $this->_ims->set_default_priority(-1.0);
            expand_json_includes_callback($m, [$this->_ims, "addj"]);
            $this->_ims->clear_default_priority();
            if (($mlist = $this->opt("messageOverrides")))
                expand_json_includes_callback($mlist, [$this->_ims, "addj"]);
            foreach ($this->settingTexts as $k => $v)
                if (str_starts_with($k, "msg."))
                    $this->_ims->add_override(substr($k, 4), $v);
        }
        return $this->_ims;
    }

    function _($itext) {
        return call_user_func_array([$this->ims(), "x"], func_get_args());
    }

    function _c($context, $itext) {
        return call_user_func_array([$this->ims(), "xc"], func_get_args());
    }

    function _i($id, $itext) {
        return call_user_func_array([$this->ims(), "xi"], func_get_args());
    }

    function _ci($context, $id, $itext) {
        return call_user_func_array([$this->ims(), "xci"], func_get_args());
    }

    function resolve_ims_requirement($s, $isreq) {
        if ($isreq)
            return null;
        else if (str_starts_with($s, "setting."))
            return [$this->setting(substr($s, 8))];
        else if (str_starts_with($s, "opt."))
            return [$this->opt(substr($s, 4))];
        else
            return null;
    }


    // search keywords

    function _add_search_keyword_json($kwj) {
        if (isset($kwj->name) && is_string($kwj->name))
            return self::xt_add($this->_search_keyword_base, $kwj->name, $kwj);
        else if (is_string($kwj->match) && is_string($kwj->expand_callback)) {
            $this->_search_keyword_factories[] = $kwj;
            return true;
        } else
            return false;
    }
    private function make_search_keyword_map() {
        $this->_search_keyword_base = $this->_search_keyword_factories = [];
        expand_json_includes_callback(["etc/searchkeywords.json"], [$this, "_add_search_keyword_json"]);
        if (($olist = $this->opt("searchKeywords")))
            expand_json_includes_callback($olist, [$this, "_add_search_keyword_json"]);
        usort($this->_search_keyword_factories, "Conf::xt_priority_compare");
    }
    function search_keyword($keyword, Contact $user = null) {
        if ($this->_search_keyword_base === null)
            $this->make_search_keyword_map();
        $checkf = function ($xt) use ($user) { return $this->xt_allowed($xt, $user); };
        $uf = $this->xt_search_name($this->_search_keyword_base, $keyword, $checkf);
        if (($expansions = $this->xt_search_factories($this->_search_keyword_factories, $keyword, $checkf, $uf, $user)))
            $uf = $expansions[0];
        return self::xt_resolve_require($uf);
    }


    // assignment parsers

    function _add_assignment_parser_json($uf) {
        if (isset($uf->name) && is_string($uf->name))
            return self::xt_add($this->_assignment_parsers, $uf->name, $uf);
        return false;
    }
    function assignment_parser($keyword, Contact $user = null) {
        require_once("assignmentset.php");
        if ($this->_assignment_parsers === null) {
            $this->_assignment_parsers = [];
            expand_json_includes_callback(["etc/assignmentparsers.json"], [$this, "_add_assignment_parser_json"]);
            if (($olist = $this->opt("assignmentParsers")))
                expand_json_includes_callback($olist, [$this, "_add_assignment_parser_json"]);
        }
        $checkf = function ($xt) use ($user) { return $this->xt_allowed($xt, $user); };
        $uf = $this->xt_search_name($this->_assignment_parsers, $keyword, $checkf);
        $uf = self::xt_resolve_require($uf);
        if ($uf && !isset($uf->__parser)) {
            $p = $uf->parser_class;
            $uf->__parser = new $p($this, $uf);
        }
        return $uf ? $uf->__parser : null;
    }


    // formula functions

    function _add_formula_function_json($fj) {
        if (isset($fj->name) && is_string($fj->name))
            return self::xt_add($this->_formula_functions, $fj->name, $fj);
        return false;
    }
    function formula_function($fname, Contact $user) {
        if ($this->_formula_functions === null) {
            $this->_formula_functions = [];
            expand_json_includes_callback(["etc/formulafunctions.json"], [$this, "_add_formula_function_json"]);
            if (($olist = $this->opt("formulaFunctions")))
                expand_json_includes_callback($olist, [$this, "_add_formula_function_json"]);
        }
        $checkf = function ($xt) use ($user) { return $this->xt_allowed($xt, $user); };
        $uf = $this->xt_search_name($this->_formula_functions, $fname, $checkf);
        return self::xt_resolve_require($uf);
    }


    // API

    function _add_api_json($fj) {
        if (isset($fj->name) && is_string($fj->name)
            && isset($fj->callback) && is_string($fj->callback))
            return self::xt_add($this->_api_map, $fj->name, $fj);
        else
            return false;
    }
    private function api_map() {
        if ($this->_api_map === null) {
            $this->_api_map = [];
            expand_json_includes_callback(["etc/apifunctions.json"], [$this, "_add_api_json"]);
            if (($olist = $this->opt("apiFunctions")))
                expand_json_includes_callback($olist, [$this, "_add_api_json"]);
        }
        return $this->_api_map;
    }
    private function check_api_json($fj, Contact $user = null, $method) {
        if (isset($fj->allow_if) && !$this->xt_allowed($fj, $user))
            return false;
        else if (!$method)
            return true;
        else {
            $methodx = get($fj, strtolower($method));
            return $methodx
                || ($method === "POST" && $methodx === null && get($fj, "get"));
        }
    }
    function has_api($fn, Contact $user = null, $method = null) {
        return !!$this->api($fn, $user, $method);
    }
    function api($fn, Contact $user = null, $method = null) {
        $checkf = function ($xt) use ($user, $method) {
            return $this->check_api_json($xt, $user, $method);
        };
        $uf = $this->xt_search_name($this->api_map(), $fn, $checkf);
        return self::xt_enabled($uf) ? $uf : null;
    }
    private function call_api($fn, $uf, Contact $user, Qrequest $qreq, $prow) {
        $method = $qreq->method();
        if ($method !== "GET"
            && $method !== "HEAD"
            && $method !== "OPTIONS"
            && !$qreq->post_ok()
            && (!$uf || !get($uf, "allow_xss")))
            return new JsonResult(403, "Missing credentials.");
        if (!$uf) {
            if ($this->has_api($fn, $user, null))
                return new JsonResult(405, "Method not supported.");
            else if ($this->has_api($fn, null, $qreq->method()))
                return new JsonResult(403, "Permission error.");
            else
                return new JsonResult(404, "Function not found.");
        }
        if (!$prow && get($uf, "paper"))
            return self::paper_error_json_result($qreq->annex("paper_whynot"));
        self::xt_resolve_require($uf);
        return call_user_func($uf->callback, $user, $qreq, $prow, $uf);
    }
    static function paper_error_json_result($whynot) {
        $result = ["ok" => false];
        if ($whynot) {
            $status = isset($whynot["noPaper"]) ? 404 : 403;
            $result["error"] = whyNotText($whynot, true);
            if (isset($whynot["signin"]))
                $result["loggedout"] = true;
        } else {
            $status = 400;
            $result["error"] = "Bad request, missing submission.";
        }
        return new JsonResult($status, $result);
    }
    function call_api_exit($fn, Contact $user, Qrequest $qreq, PaperInfo $prow = null) {
        // XXX precondition: $user->can_view_paper($prow) || !$prow
        $uf = $this->api($fn, $user, $qreq->method());
        if ($uf && get($uf, "redirect") && $qreq->redirect
            && preg_match('@\A(?![a-z]+:|/).+@', $qreq->redirect)) {
            try {
                JsonResultException::$capturing = true;
                $j = $this->call_api($fn, $uf, $user, $qreq, $prow);
            } catch (JsonResultException $ex) {
                $j = $ex->result;
            }
            if (is_object($j) && $j instanceof JsonResult)
                $j = $j->content;
            if (!get($j, "ok") && !get($j, "error"))
                Conf::msg_error("Internal error.");
            else if (($x = get($j, "error")))
                Conf::msg_error(htmlspecialchars($x));
            else if (($x = get($j, "error_html")))
                Conf::msg_error($x);
            Navigation::redirect_site($qreq->redirect);
        } else {
            $j = $this->call_api($fn, $uf, $user, $qreq, $prow);
            json_exit($j);
        }
    }


    // List action API

    function _add_list_action_json($fj) {
        $ok = false;
        if (isset($fj->name) && is_string($fj->name)) {
            if (isset($fj->render_callback) && is_string($fj->render_callback))
                $ok = self::xt_add($this->_list_action_renderers, $fj->name, $fj);
            if (isset($fj->callback) && is_string($fj->callback))
                $ok = self::xt_add($this->_list_action_map, $fj->name, $fj);
        } else if (is_string($fj->match) && is_string($fj->expand_callback)) {
            $this->_list_action_factories[] = $fj;
            $ok = true;
        }
        return $ok;
    }
    function list_action_map() {
        if ($this->_list_action_map === null) {
            $this->_list_action_map = $this->_list_action_renderers = $this->_list_action_factories = [];
            expand_json_includes_callback(["etc/listactions.json"], [$this, "_add_list_action_json"]);
            if (($olist = $this->opt("listActions")))
                expand_json_includes_callback($olist, [$this, "_add_list_action_json"]);
            usort($this->_list_action_factories, "Conf::xt_priority_compare");
        }
        return $this->_list_action_map;
    }
    function list_action_renderers() {
        $this->list_action_map();
        return $this->_list_action_renderers;
    }
    function has_list_action($name, Contact $user = null, $method = null) {
        return !!$this->list_action($name, $user, $method);
    }
    function list_action($name, Contact $user = null, $method = null) {
        $checkf = function ($xt) use ($user, $method) {
            return $this->check_api_json($xt, $user, $method);
        };
        $uf = $this->xt_search_name($this->list_action_map(), $name, $checkf);
        if (($s = strpos($name, "/")) !== false)
            $uf = $this->xt_search_name($this->list_action_map(), substr($name, 0, $s), $checkf, $uf);
        if (($expansions = $this->xt_search_factories($this->_list_action_factories, $name, $checkf, $uf, $user)))
            $uf = $expansions[0];
        return self::xt_resolve_require($uf);
    }

    function make_csvg($basename, $flags = 0) {
        $csv = new CsvGenerator($flags);
        $csv->set_filename($this->download_prefix . $basename . $csv->extension());
        return $csv;
    }


    // paper columns

    function _add_paper_column_json($fj) {
        $cb = isset($fj->callback) && is_string($fj->callback);
        $ok = false;
        if (isset($fj->name) && is_string($fj->name) && $cb)
            $ok = self::xt_add($this->_paper_column_map, $fj->name, $fj);
        if (isset($fj->match) && is_string($fj->match)
            && (isset($fj->expand_callback) ? is_string($fj->expand_callback) : $cb)) {
            $this->_paper_column_factories[] = $fj;
            $ok = true;
        }
        return $ok;
    }
    function paper_column_map() {
        if ($this->_paper_column_map === null) {
            require_once("papercolumn.php");
            $this->_paper_column_map = $this->_paper_column_factories = [];
            expand_json_includes_callback(["etc/papercolumns.json"], [$this, "_add_paper_column_json"]);
            if (($olist = $this->opt("paperColumns")))
                expand_json_includes_callback($olist, [$this, "_add_paper_column_json"]);
            usort($this->_paper_column_factories, "Conf::xt_priority_compare");
        }
        return $this->_paper_column_map;
    }
    function paper_column_factories() {
        $this->paper_column_map();
        return $this->_paper_column_factories;
    }
    function basic_paper_column($name, Contact $user = null) {
        $checkf = function ($xt) use ($user) { return $this->xt_allowed($xt, $user); };
        $uf = $this->xt_search_name($this->paper_column_map(), $name, $checkf);
        return self::xt_enabled($uf) ? $uf : null;
    }
    function paper_columns($name, Contact $user) {
        if ($name === "" || $name[0] === "?")
            return [];
        $checkf = function ($xt) use ($user) { return $this->xt_allowed($xt, $user); };
        $uf = $this->xt_search_name($this->paper_column_map(), $name, $checkf);
        $expansions = $this->xt_search_factories($this->_paper_column_factories, $name, $checkf, $uf, $user, "i");
        return array_filter($expansions ? : [$uf], "Conf::xt_resolve_require");
    }


    // option types

    function _add_option_type_json($fj) {
        $cb = isset($fj->callback) && is_string($fj->callback);
        if (isset($fj->name) && is_string($fj->name) && $cb)
            return self::xt_add($this->_option_type_map, $fj->name, $fj);
        else if (is_string($fj->match) && (isset($fj->expand_callback) ? is_string($fj->expand_callback) : $cb)) {
            $this->_option_type_factories[] = $fj;
            return true;
        } else
            return false;
    }
    function option_type_map() {
        if ($this->_option_type_map === null) {
            require_once("paperoption.php");
            $this->_option_type_map = $this->_option_type_factories = [];
            expand_json_includes_callback(["etc/optiontypes.json"], [$this, "_add_option_type_json"]);
            if (($olist = $this->opt("optionTypes")))
                expand_json_includes_callback($olist, [$this, "_add_option_type_json"]);
            usort($this->_option_type_factories, "Conf::xt_priority_compare");
            // option types are global (cannot be allowed per user)
            $m = [];
            foreach (array_keys($this->_option_type_map) as $name) {
                if (($uf = $this->xt_search_name($this->_option_type_map, $name, [$this, "xt_allowed"])))
                    $m[$name] = $uf;
            }
            $this->_option_type_map = $m;
        }
        return $this->_option_type_map;
    }
    function option_type($name) {
        $uf = get($this->option_type_map(), $name);
        if (($expansions = $this->xt_search_factories($this->_option_type_factories, $name, [$this, "xt_allowed"], $uf, null, "i")))
            $uf = $expansions[0];
        return $uf;
    }


    // capability tokens

    function _add_capability_json($fj) {
        if (isset($fj->match) && is_string($fj->match)
            && isset($fj->callback) && is_string($fj->callback)) {
            $this->_capability_factories[] = $fj;
            return true;
        } else
            return false;
    }
    function capability_handler($cap) {
        if ($this->_capability_factories === null) {
            $this->_capability_factories = [];
            expand_json_includes_callback(["etc/capabilityhandlers.json"], [$this, "_add_capability_json"]);
            if (($olist = $this->opt("capabilityHandlers")))
                expand_json_includes_callback($olist, [$this, "_add_capability_json"]);
            usort($this->_capability_factories, "Conf::xt_priority_compare");
        }
        $expansions = $this->xt_search_factories($this->_capability_factories, $cap, [$this, "xt_allowed"], null);
        return $expansions ? $expansions[0] : null;
    }


    // mail keywords

    function _add_mail_keyword_json($fj) {
        $cb = isset($fj->callback) && is_string($fj->callback);
        if (isset($fj->name) && is_string($fj->name) && $cb)
            return self::xt_add($this->_mail_keyword_map, $fj->name, $fj);
        else if (is_string($fj->match) && (isset($fj->expand_callback) ? is_string($fj->expand_callback) : $cb)) {
            $this->_mail_keyword_factories[] = $fj;
            return true;
        } else
            return false;
    }
    function mail_keyword_map() {
        if ($this->_mail_keyword_map === null) {
            $this->_mail_keyword_map = $this->_mail_keyword_factories = [];
            expand_json_includes_callback(["etc/mailkeywords.json"], [$this, "_add_mail_keyword_json"]);
            if (($mks = $this->opt("mailKeywords")))
                expand_json_includes_callback($mks, [$this, "_add_mail_keyword_json"]);
            usort($this->_mail_keyword_factories, "Conf::xt_priority_compare");
        }
        return $this->_mail_keyword_map;
    }
    function mail_keywords($name) {
        $checkf = [$this, "xt_allowed"];
        $uf = $this->xt_search_name($this->mail_keyword_map(), $name, $checkf);
        $expansions = $this->xt_search_factories($this->_mail_keyword_factories, $name, $checkf, $uf, null, "");
        return array_filter($expansions ? : [$uf], "Conf::xt_resolve_require");
    }


    // mail templates

    function _add_mail_template_json($fj) {
        if (isset($fj->name) && is_string($fj->name)) {
            if (is_array($fj->body))
                $fj->body = join("", $fj->body);
            return self::xt_add($this->_mail_template_map, $fj->name, $fj);
        } else
            return false;
    }
    function mail_template_map() {
        if ($this->_mail_template_map === null) {
            $this->_mail_template_map = [];
            if ($this->opt("mailtemplate_include")) { // backwards compatibility
                global $ConfSitePATH, $mailTemplates;
                $mailTemplates = [];
                read_included_options($this->opt["mailtemplate_include"]);
                foreach ($mailTemplates as $name => $template) {
                    $template["name"] = $name;
                    $this->_add_mail_template_json((object) $template);
                }
            }
            expand_json_includes_callback(["etc/mailtemplates.json"], [$this, "_add_mail_template_json"]);
            if (($mts = $this->opt("mailTemplates")))
                expand_json_includes_callback($mts, [$this, "_add_mail_template_json"]);
        }
        return $this->_mail_template_map;
    }
    function mail_template($name, $default_only = false) {
        $checkf = [$this, "xt_allowed"];
        $uf = $this->xt_search_name($this->mail_template_map(), $name, $checkf);
        if (!$uf || !Conf::xt_resolve_require($uf))
            return null;
        if (!$default_only) {
            $s = $this->setting_data("mailsubj_$name", false);
            $b = $this->setting_data("mailbody_$name", false);
            if (($s !== false && $s !== $uf->subject)
                || ($b !== false && $b !== $uf->body)) {
                $uf = clone $uf;
                if ($s !== false)
                    $uf->subject = $s;
                if ($b !== false)
                    $uf->body = $b;
            }
        }
        return $uf;
    }


    // hooks

    function _add_hook_json($fj) {
        if (isset($fj->callback) && is_string($fj->callback) && !isset($fj->synonym)) {
            if (isset($fj->event) && is_string($fj->event))
                return self::xt_add($this->_hook_map, $fj->event, $fj);
            else if (isset($fj->match) && is_string($fj->match)) {
                $this->_hook_factories[] = $fj;
                return true;
            }
        }
        return false;
    }
    function add_hook($name, $callback = null, $priority = null) {
        if ($this->_hook_map === null)
            $this->hook_map();
        $fj = is_object($name) ? $name : $callback;
        if (is_string($fj))
            $fj = (object) ["callback" => $fj];
        if (is_string($name))
            $fj->event = $name;
        if ($priority !== null)
            $fj->priority = $priority;
        return $this->_add_hook_json($fj) ? $fj : false;
    }
    function remove_hook($fj) {
        if (isset($fj->event) && is_string($fj->event)
            && isset($this->_hook_map[$fj->event])
            && ($i = array_search($fj, $this->_hook_map[$fj->event], true)) !== false) {
            array_splice($this->_hook_map[$fj->event], $i, 1);
            return true;
        } else if (isset($fj->match) && is_string($fj->match)
                   && ($i = array_search($fj, $this->_hook_factories, true)) !== false) {
            array_splice($this->_hook_factories, $i, 1);
            return true;
        }
        return false;
    }
    private function hook_map() {
        if ($this->_hook_map === null) {
            $this->_hook_map = $this->_hook_factories = [];
            if (($hlist = $this->opt("hooks")))
                expand_json_includes_callback($hlist, [$this, "_add_hook_json"]);
        }
        return $this->_hook_map;
    }
    function call_hooks($name, Contact $user = null /* ... args */) {
        $hs = get($this->hook_map(), $name);
        foreach ($this->_hook_factories as $fj) {
            if ($fj->match === ".*"
                || preg_match("\1\\A(?:{$fxt->match})\\z\1", $name, $m)) {
                $xfj = clone $fj;
                $xfj->event = $name;
                $xfj->match_data = $m;
                $hs[] = $xfj;
            }
        }
        if ($hs !== null) {
            $args = array_slice(func_get_args(), 1);
            usort($hs, "Conf::xt_priority_compare");
            $ids = [];
            foreach ($hs as $fj) {
                if ((!isset($fj->id) || !isset($ids[$fj->id]))
                    && $this->xt_allowed($fj, $user)) {
                    if (isset($fj->id))
                        $ids[$fj->id] = true;
                    if (!self::xt_disabled($fj)) {
                        $fj->conf = $this;
                        $fj->user = $user;
                        $args[0] = $fj;
                        $x = call_user_func_array($fj->callback, $args);
                        unset($fj->conf, $fj->user);
                        if ($x === false)
                            return false;
                    }
                }
            }
        }
    }


    // pages

    function page_template($page) {
        if ($page === "index")
            return (object) ["name" => "index"];
        else if (in_array($page, ["doc", "paper", "search", "review", "assign", "autoassign", "bulkassign", "buzzer", "checkupdates", "comment", "conflictassign", "deadlines", "graph", "help", "log", "mail", "manualassign", "mergeaccounts", "offline", "profile", "resetpassword", "reviewprefs", "scorechart", "settings", "users"]))
            return (object) ["name" => $page, "require" => "$page.php"];
        else
            return null;
    }
}