From fecd57c8861ebf5d213e1e85581ae4fc88ee0407 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 24 Feb 2007 17:46:39 +0100 Subject: add new-style schema versions and updater --- update.php | 142 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 142 insertions(+) create mode 100644 update.php (limited to 'update.php') diff --git a/update.php b/update.php new file mode 100644 index 000000000..964626d7f --- /dev/null +++ b/update.php @@ -0,0 +1,142 @@ + + + + + Database Updater + + + + + + +

Database Updater

+ +Warning: Please backup your database before proceeding.

"; + + print "

Your database schema version is $version. Latest version is ". + "$latest_version.

"; + + print "

Available incremental updates:"; + + foreach (array_keys($update_versions) as $v) { + if ($v > $version) { + print " $v"; + } + } + + print "

"; + print "Click here to perform updates."; + + } else if ($op == "do") { + + print "

Performing updates (version: $version)...

"; + + $num_updates = 0; + + foreach (array_keys($update_versions) as $v) { + if ($v == $version + 1) { + print "

Updating to version $v...

"; + $fp = fopen($update_versions[$v], "r"); + if ($fp) { + while (!feof($fp)) { + $query = trim(getline($fp, ";")); + if ($query != "") { + print "

QUERY: $query

"; + db_query($link, $query); + } + } + } + fclose($fp); + + print "

Checking version... "; + + $result = db_query($link, "SELECT schema_version FROM ttrss_version"); + $version = db_fetch_result($result, 0, "schema_version"); + + if ($version == $v) { + print "OK!"; + } else { + print "ERROR!"; + return; + } + + $num_updates++; + } + } + + print "

Finished. Performed $num_updates updates up to schema + version $version.

"; + } +?> + + + + + -- cgit v1.2.3