function dbupdate() { startup_gettext(); if (!SINGLE_USER_MODE && $_SESSION["access_level"] < 10) { $_SESSION["login_error_msg"] = __("Your access level is insufficient to run this script."); render_login_form(); exit; } ?> <html> <head> <title>Database Updater</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <link rel="stylesheet" type="text/css" href="css/utility.css"/> </head> <style type="text/css"> span.ok { color : #009000; font-weight : bold; } span.err { color : #ff0000; font-weight : bold; } </style> <body> <script type='text/javascript'> function confirmOP() { return confirm("Update the database?"); } </script> <div class="floatingLogo"><img src="images/logo_small.png"></div> <h1><?php echo __("Database Updater"); ?> </h1> <div class="content"> <?php @($op = $_REQUEST["subop"]); $updater = new DbUpdater(Db::get(), DB_TYPE, SCHEMA_VERSION); if ($op == "performupdate") { if ($updater->isUpdateRequired()) { print "<h2>Performing updates</h2>"; print "<h3>Updating to schema version " . SCHEMA_VERSION . "</h3>"; print "<ul>"; for ($i = $updater->getSchemaVersion() + 1; $i <= SCHEMA_VERSION; $i++) { print "<li>Performing update up to version {$i}..."; $result = $updater->performUpdateTo($i); if (!$result) { print "<span class='err'>FAILED!</span></li></ul>"; print_warning("One of the updates failed. Either retry the process or perform updates manually."); print "<p><form method=\"GET\" action=\"index.php\">\n\t\t\t\t\t\t\t\t<input type=\"submit\" value=\"" . __("Return to Tiny Tiny RSS") . "\">\n\t\t\t\t\t\t\t\t</form>"; break; } else { print "<span class='ok'>OK!</span></li>"; } } print "</ul>"; print_notice("Your Tiny Tiny RSS database is now updated to the latest version."); print "<p><form method=\"GET\" action=\"index.php\">\n\t\t\t\t\t\t<input type=\"submit\" value=\"" . __("Return to Tiny Tiny RSS") . "\">\n\t\t\t\t\t\t</form>"; } else { print "<h2>Your database is up to date.</h2>"; print "<p><form method=\"GET\" action=\"index.php\">\n\t\t\t\t\t\t<input type=\"submit\" value=\"" . __("Return to Tiny Tiny RSS") . "\">\n\t\t\t\t\t\t</form>"; } } else { if ($updater->isUpdateRequired()) { print "<h2>Database update required</h2>"; print "<h3>"; printf("Your Tiny Tiny RSS database needs update to the latest version: %d to %d.", $updater->getSchemaVersion(), SCHEMA_VERSION); print "</h3>"; print_warning("Please backup your database before proceeding."); print "<form method='POST'>\n\t\t\t\t\t\t\t<input type='hidden' name='subop' value='performupdate'>\n\t\t\t\t\t\t\t<input type='submit' onclick='return confirmOP()' value='" . __("Perform updates") . "'>\n\t\t\t\t\t\t</form>"; } else { print_notice("Tiny Tiny RSS database is up to date."); print "<p><form method=\"GET\" action=\"index.php\">\n\t\t\t\t\t\t\t<input type=\"submit\" value=\"" . __("Return to Tiny Tiny RSS") . "\">\n\t\t\t\t\t\t</form>"; } } ?> </div> </body> </html> <?php }
$filter["enabled"] = $line["enabled"] ? "on" : "off"; $filter["rule"] = array(json_encode(array("reg_exp" => $line["reg_exp"], "feed_id" => $feed_id, "filter_type" => $line["filter_type"]))); $filter["action"] = array(json_encode(array("action_id" => $line["action_id"], "action_param_label" => $line["action_param"], "action_param" => $line["action_param"]))); // Oh god it's full of hacks $_REQUEST = $filter; $_SESSION["uid"] = $owner_uid; $filters = new Pref_Filters($_REQUEST); $filters->add(); } } } if (isset($options["update-schema"])) { _debug("checking for updates (" . DB_TYPE . ")..."); $updater = new DbUpdater(Db::get(), DB_TYPE, SCHEMA_VERSION); if ($updater->isUpdateRequired()) { _debug("schema update required, version " . $updater->getSchemaVersion() . " to " . SCHEMA_VERSION); _debug("WARNING: please backup your database before continuing."); _debug("Type 'yes' to continue."); if (read_stdin() != 'yes') { exit; } for ($i = $updater->getSchemaVersion() + 1; $i <= SCHEMA_VERSION; $i++) { _debug("performing update up to version {$i}..."); $result = $updater->performUpdateTo($i); _debug($result ? "OK!" : "FAILED!"); if (!$result) { return; } } } else { _debug("update not required.");