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());
}
