From 5bfa4445d52fc831330600e581656142b30f0ca3 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Fri, 24 Jun 2011 13:50:03 -0400 Subject: [PATCH] - Read _unlock from POST too --- bin/update.sh | 87 +++++++++++++++++++++++++++++++++++++------ 1 files changed, 75 insertions(+), 12 deletions(-) diff --git a/bin/update.sh b/bin/update.sh index 5be7633..9f91c8e 100755 --- a/bin/update.sh +++ b/bin/update.sh @@ -1,16 +1,51 @@ -#!/usr/bin/php +#!/usr/bin/env php <?php +/* + +-----------------------------------------------------------------------+ + | bin/update.sh | + | | + | This file is part of the Roundcube Webmail client | + | Copyright (C) 2010-2011, The Roundcube Dev Team | + | Licensed under the GNU GPL | + | | + | PURPOSE: | + | Check local configuration and database schema after upgrading | + | to a new version | + +-----------------------------------------------------------------------+ + | Author: Thomas Bruederli <roundcube@gmail.com> | + +-----------------------------------------------------------------------+ + + $Id$ + +*/ define('INSTALL_PATH', realpath(dirname(__FILE__) . '/..') . '/' ); -require_once INSTALL_PATH . 'program/include/iniset.php'; +require_once INSTALL_PATH . 'program/include/clisetup.php'; require_once INSTALL_PATH . 'installer/rcube_install.php'; + +// get arguments +$opts = get_opt(array('v' => 'version')); + +// ask user if no version is specified +if (!$opts['version']) { + echo "What version are you upgrading from? Type '?' if you don't know.\n"; + if (($input = trim(fgets(STDIN))) && preg_match('/^[0-9.]+[a-z-]*$/', $input)) + $opts['version'] = $input; +} + +if ($opts['version'] && version_compare($opts['version'], RCMAIL_VERSION, '>')) + die("Nothing to be done here. Bye!\n"); + $RCI = rcube_install::get_instance(); $RCI->load_config(); if ($RCI->configured) { + $success = true; + if ($messages = $RCI->check_config()) { + $success = false; $err = 0; // list missing config options @@ -19,7 +54,7 @@ echo "(These config options should be present in the current configuration)\n"; foreach ($messages['missing'] as $msg) { - echo '- ' . $msg['prop'] . ($msg['name'] ? ': ' . $msg['name'] : '') . "\n"; + echo "- '" . $msg['prop'] . ($msg['name'] ? "': " . $msg['name'] : "'") . "\n"; $err++; } echo "\n"; @@ -31,7 +66,7 @@ echo "(These config options have been replaced or renamed)\n"; foreach ($messages['replaced'] as $msg) { - echo "- " . $msg['prop'] . "\t\t was replaced by " . $msg['replacement'] . "\n"; + echo "- '" . $msg['prop'] . "' was replaced by '" . $msg['replacement'] . "'\n"; $err++; } echo "\n"; @@ -43,7 +78,7 @@ echo "(You still have some obsolete or inexistent properties set. This isn't a problem but should be noticed)\n"; foreach ($messages['obsolete'] as $msg) { - echo "- " . $msg['prop'] . ($msg['name'] ? ': ' . $msg['name'] : '') . "\n"; + echo "- '" . $msg['prop'] . ($msg['name'] ? "': " . $msg['name'] : "'") . "\n"; $err++; } echo "\n"; @@ -75,7 +110,7 @@ // Success! if ($write1 && $write2) { echo "Done.\n"; - echo "Your configuration files are now up-tp-date!\n"; + echo "Your configuration files are now up-to-date!\n"; } else { echo "Failed to write config files!\n"; @@ -83,7 +118,7 @@ } } else { - echo "Please update your config files manually according to the above messages.\n"; + echo "Please update your config files manually according to the above messages.\n\n"; } } @@ -98,18 +133,46 @@ echo "Please fix your config files and run this script again!\n"; echo "See ya.\n"; } - } - else { - echo "This instance of RoundCube is up-to-date.\n"; + + // check database schema + if ($RCI->config['db_dsnw']) { + $DB = new rcube_mdb2($RCI->config['db_dsnw'], '', false); + $DB->db_connect('w'); + if ($db_error_msg = $DB->is_error()) { + echo "Error connecting to database: $db_error_msg\n"; + $success = false; + } + else if ($err = $RCI->db_schema_check($DB, false)) { + $updatefile = INSTALL_PATH . 'SQL/' . (isset($RCI->db_map[$DB->db_provider]) ? $RCI->db_map[$DB->db_provider] : $DB->db_provider) . '.update.sql'; + echo "WARNING: Database schema needs to be updated!\n"; + echo join("\n", $err) . "\n\n"; + $success = false; + + if ($opts['version']) { + echo "Do you want to run the update queries to get the schmea fixed? (y/N)\n"; + $input = trim(fgets(STDIN)); + if (strtolower($input) == 'y') { + $success = $RCI->update_db($DB, $opts['version']); + } + } + + if (!$success) + echo "Open $updatefile and execute all queries below the comment with the currently installed version number.\n"; + } + } + + + if ($success) { + echo "This instance of Roundcube is up-to-date.\n"; echo "Have fun!\n"; } } else { - echo "This instance of RoundCube is not yet configured!\n"; + echo "This instance of Roundcube is not yet configured!\n"; echo "Open http://url-to-roundcube/installer/ in your browser and follow the instuctions.\n"; } echo "\n"; -?> \ No newline at end of file +?> -- Gitblit v1.9.1