Example #1
0
 * update all code-version-dependent data on a developer system
 */
$rootpath = $opt['rootpath'] = __DIR__ . '/../htdocs/';
chdir($rootpath);
require_once 'lib2/cli.inc.php';
echo "updating composer dependencies\n";
system('composer install --ignore-platform-reqs');
echo "applying sql deltas\n";
require 'dbsv-update.php';
echo "importing data.sql\n";
system('cat ' . $rootpath . '../sql/static-data/data.sql |' . ' mysql -h' . $opt['db']['servername'] . ' -u' . $opt['db']['username'] . ' --password='******'db']['password'] . ' ' . $opt['db']['placeholder']['db']);
echo "importing triggers\n";
chdir($rootpath . '../sql/stored-proc');
system('php maintain.php');
// We do *two* tests for OKAPI presence to get some robustness agains internal OKAPI changes.
//
// This should be replaced by a facade function call, but current OKAPI implementation
// does not work well when called from the command line, due to exception handling problems
// (see http://code.google.com/p/opencaching-api/issues/detail?id=243).
$okapi_vars = sql_table_exists('okapi_vars');
$okapi_syncbase = sql_field_exists('caches', 'okapi_syncbase');
if ($okapi_vars != $okapi_syncbase) {
    echo "!! unknown OKAPI configuration; either dbupdate.php needs an update or your database configuration is wrong\n";
} elseif ($okapi_vars) {
    echo "updating OKAPI database\n";
    chdir($rootpath . '../bin');
    system('php okapi-update.php | grep -i -e mutation');
}
echo "resetting webcache:\n";
chdir($rootpath . '../bin');
system('php clear-webcache.php');
Example #2
0
function dbv_155()
{
    if (!sql_field_exists('cache_report_reasons', 'order')) {
        sql("ALTER TABLE `cache_report_reasons` ADD COLUMN `order` TINYINT(2) UNSIGNED NOT NULL");
    }
}
Example #3
0
function dbv_155()
{
    if (!sql_field_exists('cache_report_reasons', 'order')) {
        sql("ALTER TABLE `cache_report_reasons` ADD COLUMN `order` tinyint(2) unsigned NOT NULL");
    }
}
Example #4
0
function dbv_139()
{
    if (!sql_field_exists('user', 'language_guessed')) {
        sql("ALTER TABLE `user` ADD COLUMN `language_guessed` tinyint(1) NOT NULL default '0' AFTER `language`");
    }
}
Example #5
0
function dbv_125()
{
    global $opt;
    if (!sql_field_exists('cache_lists', 'node')) {
        sql("ALTER TABLE `cache_lists` ADD COLUMN `node` tinyint(3) unsigned NOT NULL default '0' AFTER `uuid`");
        sql("UPDATE `cache_lists` SET `node`='&1'", $opt['logic']['node']['id']);
    }
    if (!sql_field_exists('cache_lists', 'last_state_change')) {
        sql("ALTER TABLE `cache_lists` ADD COLUMN `last_state_change` datetime default NULL AFTER `last_added`");
    }
    update_triggers();
    // runs maintain-125.inc.php
}
function dbv_140()
{
    if (!sql_field_exists('user', 'domain')) {
        sql("ALTER TABLE `user` ADD COLUMN `domain` varchar(40) default NULL AFTER `language_guessed`");
    }
}