/** * 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($subaction = null) { $clang = Yii::app()->getController()->lang; $dbversionnumber = Yii::app()->getConfig('dbversionnumber'); $currentDBVersion = GetGlobalSetting('DBVersion'); $usertemplaterootdir = Yii::app()->getConfig('usertemplaterootdir'); $standardtemplaterootdir = Yii::app()->getConfig('standardtemplaterootdir'); if (intval($dbversionnumber) > intval($currentDBVersion)) { if (isset($subaction) && $subaction == "yes") { echo Yii::app()->getController()->_getAdminHeader(); echo "<div style='width:90%; padding:1% 5%;background-color:#eee;'>"; Yii::app()->loadHelper('update/updatedb'); $result = db_upgrade_all(intval($currentDBVersion)); if ($result) { $data = "<br />" . sprintf($clang->gT("Database has been successfully upgraded to version %s"), $dbversionnumber); $data .= "<br /><a href='" . Yii::app()->getController()->createUrl("/admin") . "'>" . $clang->gT("Back to main menu") . "</a></div>"; } else { $data = "<p><a href='" . Yii::app()->getController()->createUrl("/admin/update/sa/db") . "'>" . $clang->gT("Please fix this error in your database and try again") . "</a></p></div>"; } return $data; } else { return ShowDBUpgradeNotice(); } } }
/** * 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($subaction = null) { $dbversionnumber = Yii::app()->getConfig('dbversionnumber'); $currentDBVersion = GetGlobalSetting('DBVersion'); $usertemplaterootdir = Yii::app()->getConfig('usertemplaterootdir'); $standardtemplaterootdir = Yii::app()->getConfig('standardtemplaterootdir'); if (intval($dbversionnumber) > intval($currentDBVersion)) { if (isset($subaction) && $subaction == "yes") { echo Yii::app()->getController()->_getAdminHeader(); //echo "<div style='width:90%; padding:1% 5%;background-color:#eee;'>"; Yii::app()->loadHelper('update/updatedb'); $result = db_upgrade_all(intval($currentDBVersion)); if ($result) { $data = '<div class="message-box jumbotron">'; $data .= '<h2 class="text-success">' . gT("Success") . '</h2>'; $data .= "<p class='lead text-success'>" . sprintf(gT("Database has been successfully upgraded to version %s"), $dbversionnumber) . '</p>'; $data .= "<p><a class='btn btn-default btn-lg' href='" . Yii::app()->getController()->createUrl("/admin") . "'>" . gT("Back to main menu") . "</a></p></div>"; } else { $data = '<div class="message-box jumbotron message-box-error">'; $data .= '<h2 class="text-warning">' . gT("Error") . '</h2>'; $data .= '<p class="lead text-warning">'; $data .= gT('An non-recoverable error happened during the update. Error details:'); $data .= '</p>'; $data .= '<p>' . Yii::app()->session['dbError'] . '</p>'; $data .= "<p>" . gT("Please fix this error in your database and try again") . "</p>"; $data .= "<a class='btn btn-default btn-lg' href='" . Yii::app()->getController()->createUrl("/admin/update/sa/db") . "'>" . gT("Continue") . "</a>"; $data .= "</div>"; } return $data; } else { return ShowDBUpgradeNotice(); } } }
/** * 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($subaction = null) { $dbversionnumber = Yii::app()->getConfig('dbversionnumber'); $currentDBVersion = GetGlobalSetting('DBVersion'); $usertemplaterootdir = Yii::app()->getConfig('usertemplaterootdir'); $standardtemplaterootdir = Yii::app()->getConfig('standardtemplaterootdir'); if (intval($dbversionnumber) > intval($currentDBVersion)) { if (isset($subaction) && $subaction == "yes") { echo Yii::app()->getController()->_getAdminHeader(); Yii::app()->loadHelper('update/updatedb'); $result = db_upgrade_all(intval($currentDBVersion)); if ($result) { $data = '<div class="jumbotron message-box">' . '<h2 class="">' . gT('Success') . '</h2>' . '<p class="lead">' . sprintf(gT("Database has been successfully upgraded to version %s"), $dbversionnumber) . '</p>' . '<p>' . '<a href="' . Yii::app()->getController()->createUrl("/admin") . '">' . gT("Back to main menu") . '</a>' . '</p>' . '</div>'; } else { $data = "<p><a href='" . Yii::app()->getController()->createUrl("/admin/databaseupdate/sa/db") . "'>" . gT("Please fix this error in your database and try again") . "</a></p></div>"; } return $data; } else { return ShowDBUpgradeNotice(); } } }
/** * 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($subaction = null) { $clang = Yii::app()->getController()->lang; $dbversionnumber = Yii::app()->getConfig('dbversionnumber'); $currentDBVersion = GetGlobalSetting('DBVersion'); $usertemplaterootdir = Yii::app()->getConfig('usertemplaterootdir'); $standardtemplaterootdir = Yii::app()->getConfig('standardtemplaterootdir'); if (intval($dbversionnumber) > intval($currentDBVersion)) { if (isset($subaction) && $subaction == "yes") { echo Yii::app()->getController()->_getAdminHeader(); echo "<div style='width:90%; padding:1% 5%;background-color:#eee;'>"; Yii::app()->loadHelper('update/updatedb'); db_upgrade_all(intval($currentDBVersion)); Yii::app()->db->createCommand()->update('{{settings_global}}', array('stg_value' => intval($dbversionnumber)), 'stg_name = \'DBVersion\''); $data = "<br />" . sprintf($clang->gT("Database has been successfully upgraded to version %s"), $dbversionnumber); $data .= "<br /><a href='" . Yii::app()->getController()->createUrl("/admin") . "'>" . $clang->gT("Back to main menu") . "</a></div>"; return $data; } else { return ShowDBUpgradeNotice(); } } }
/** * 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(); } } }
// } } 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; }
/** * Checks for action specific authorization and then executes an action * * @access public * @param string $action * @return bool */ public function run($action) { // Check if the DB is up to date if (Yii::app()->db->schema->getTable('{{surveys}}')) { $sDBVersion = getGlobalSetting('DBVersion'); } if ((int) $sDBVersion < Yii::app()->getConfig('dbversionnumber') && $action != 'databaseupdate') { // Try a silent update first Yii::app()->loadHelper('update/updatedb'); if (!db_upgrade_all(intval($sDBVersion), true)) { $this->redirect(array('/admin/databaseupdate/sa/db')); } } if ($action != "databaseupdate" && $action != "db") { if (empty($this->user_id) && $action != "authentication" && $action != "remotecontrol") { if (!empty($action) && $action != 'index') { Yii::app()->session['redirect_after_login'] = $this->createUrl('/'); } App()->user->setReturnUrl(App()->request->requestUri); $this->redirect(array('/admin/authentication/sa/login')); } elseif (!empty($this->user_id) && $action != "remotecontrol") { if (Yii::app()->session['session_hash'] != hash('sha256', getGlobalSetting('SessionName') . Yii::app()->user->getName() . Yii::app()->user->getId())) { Yii::app()->session->clear(); Yii::app()->session->close(); $this->redirect(array('/admin/authentication/sa/login')); } } } return parent::run($action); }
/** * 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; }