function check_db_version($ver) { $cur_ver = get_db_version(); if ($cur_ver < $ver) { db_upgrade($cur_ver, $ver); } }
/** * Upgrades Elgg * */ function version_upgrade() { $dbversion = (int) datalist_get('version'); // No version number? Oh snap...this is an upgrade from a clean installation < 1.7. // Run all upgrades without error reporting and hope for the best. // See http://trac.elgg.org/elgg/ticket/1432 for more. $quiet = !$dbversion; // Upgrade database if (db_upgrade($dbversion, '', $quiet)) { system_message(elgg_echo('upgrade:db')); } // Upgrade core if (upgrade_code($dbversion, $quiet)) { system_message(elgg_echo('upgrade:core')); } // Now we trigger an event to give the option for plugins to do something $upgrade_details = new stdClass(); $upgrade_details->from = $dbversion; $upgrade_details->to = get_version(); trigger_elgg_event('upgrade', 'upgrade', $upgrade_details); // Update the version datalist_set('version', get_version()); }
/** * Upgrades Elgg * */ function version_upgrade() { $dbversion = (int) datalist_get('version'); // Upgrade database db_upgrade($dbversion); system_message(elgg_echo('upgrade:db')); // Upgrade core if (upgrade_code($dbversion)) { system_message(elgg_echo('upgrade:core')); } // Update the version datalist_set('version', get_version()); }
/** * This functions checks if the databaseversion in the settings table is the same one as required * If not then the necessary upgrade procedures are run */ function CheckForDBUpgrades() { global $connect, $databasetype, $dbprefix, $dbversionnumber, $clang; $currentDBVersion=GetGlobalSetting('DBVersion'); if (intval($dbversionnumber)>intval($currentDBVersion)) { if(isset($_GET['continue']) && $_GET['continue']==1) { echo "<div style='width:90%; padding:1% 10%;background-color:#eee;'>"; $upgradedbtype=$databasetype; if ($upgradedbtype=='mssql_n' || $upgradedbtype=='odbc_mssql' || $upgradedbtype=='odbtp') $upgradedbtype='mssql'; if ($upgradedbtype=='mssqlnative') $upgradedbtype = 'mssqlnative'; if ($upgradedbtype=='mysqli') $upgradedbtype='mysql'; include ('upgrade-'.$upgradedbtype.'.php'); include ('upgrade-all.php'); $tables = $connect->MetaTables(); db_upgrade_all(intval($currentDBVersion)); db_upgrade(intval($currentDBVersion)); echo "<br />".sprintf($clang->gT("Database has been successfully upgraded to version %s"),$dbversionnumber); } else { ShowDBUpgradeNotice(); } } }
/** * Upgrades Elgg Database and code * * @return bool * */ function version_upgrade() { // It's possible large upgrades could exceed the max execution time. set_time_limit(0); $dbversion = (int) datalist_get('version'); // No version number? Oh snap...this is an upgrade from a clean installation < 1.7. // Run all upgrades without error reporting and hope for the best. // See http://trac.elgg.org/elgg/ticket/1432 for more. $quiet = !$dbversion; // Note: Database upgrades are deprecated as of 1.8. Use code upgrades. See #1433 if (db_upgrade($dbversion, '', $quiet)) { system_message(elgg_echo('upgrade:db')); } if (upgrade_code($dbversion, $quiet)) { system_message(elgg_echo('upgrade:core')); // Now we trigger an event to give the option for plugins to do something $upgrade_details = new stdClass(); $upgrade_details->from = $dbversion; $upgrade_details->to = get_version(); elgg_trigger_event('upgrade', 'upgrade', $upgrade_details); return true; } return false; }
// } } elseif (isset($argv[1]) && $argv[1] == 'upgrade') { $upgradedbtype = $databasetype; if ($upgradedbtype == 'mssql_n' || $upgradedbtype == 'odbc_mssql' || $upgradedbtype == 'odbtp') { $upgradedbtype = 'mssql'; } if ($upgradedbtype == 'mssqnlative') { $upgradedbtype = 'mssqlnative'; } include 'upgrade-all.php'; include 'upgrade-' . $upgradedbtype . '.php'; $usquery = "SELECT stg_value FROM " . db_table_name("settings_global") . " where stg_name='DBVersion'"; $usresult = db_execute_assoc($usquery); $usrow = $usresult->FetchRow(); if (intval($usrow['stg_value']) < $dbversionnumber) { print "Upgrading db to {$dbversionnumber}\n"; db_upgrade_all(intval($usrow['stg_value'])); db_upgrade(intval($usrow['stg_value'])); } else { print "Already at db version {$dbversionnumber}\n"; } return 0; } else { print "LimeSurvey Commandline Install\n"; print "Usage: cmd_install <option> < <<path1>> <<path2>> >\n"; print "<option> - 'install' or 'upgrade' \n"; print "<<path1>> - Full path including filename to a custom config-defaults.php\n"; print "<<path2>> - Full path including filename to a custom common.php\n"; print "Paths are optional. If used both paths must be set.\n"; return 2; }
info("Database upgrade not required."); $step--; break; } else { // upgrade info("<br/>Upgrading tables..."); info("Old database version: {$version}"); $sql_array = array(); // select the relevant upgrades (> current version) foreach ($upgrades as $ver => $value) { if ($ver > $version) { $sql_array["{$ver}"] = $value; } } // upgrades successful? $version = db_upgrade($sql_array); if (is_numeric($version)) { info("New database version: {$version}"); // dev-time sanity check if ($version > DB_REQUIRED) { warn("Upgraded database version {$version} is higher than required database version " . DB_REQUIRED); } } else { // error $step--; } } } else { // install info("<br/>Installing tables..."); // re-connect if not continued from step 3
/** * This functions checks if the databaseversion in the settings table is the same one as required * If not then the necessary upgrade procedures are run */ function CheckForDBUpgrades() { global $connect, $databasetype, $dbprefix, $dbversionnumber, $clang; $adminoutput = ''; $currentDBVersion = GetGlobalSetting('DBVersion'); if (intval($dbversionnumber) > intval($currentDBVersion)) { $upgradedbtype = $databasetype; if ($upgradedbtype == 'mssql_n' || $upgradedbtype == 'odbc_mssql' || $upgradedbtype == 'odbtp') { $upgradedbtype = 'mssql'; } if ($upgradedbtype == 'mssqlnative') { $upgradedbtype = 'mssqlnative'; } if ($upgradedbtype == 'mysqli') { $upgradedbtype = 'mysql'; } include 'upgrade-' . $upgradedbtype . '.php'; include 'upgrade-all.php'; $tables = $connect->MetaTables(); db_upgrade_all(intval($currentDBVersion)); db_upgrade(intval($currentDBVersion)); $adminoutput = "<br />" . sprintf($clang->gT("Database has been successfully upgraded to version %s"), $dbversionnumber); } return $adminoutput; }
/** * Upgrades Elgg * */ function version_upgrade() { $dbversion = (int) datalist_get('version'); // Upgrade database db_upgrade($dbversion); system_message(elgg_echo('upgrade:db')); // Upgrade core if (upgrade_code($dbversion)) { system_message(elgg_echo('upgrade:core')); } // Now we trigger an event to give the option for plugins to do something $upgrade_details = stdClass; $upgrade_details->from = $dbversion; $upgrade_details->to = get_version(); trigger_elgg_event('upgrade', 'upgrade', $upgrade_details); // Update the version datalist_set('version', get_version()); }