# Do updates based on version # But cascade the updates $CURRENT_VERSION = intval(str_replace('.', '', $CURRENT_VERSION)); $latestversion = intval(str_replace('.', '', UPDATE_VERSION)); $mysqlDiff = new MySQLDiff(array('dbuser' => DBASE_USER, 'dbpass' => DBASE_PASS, 'dbname' => DBASE_NAME, 'dbhost' => DBASE_SERVER, 'dumpxml' => 'sql/structure.xml')); $diffs_done = $mysqlDiff->getSQLDiffs(); if (!is_array($diffs_done)) { $diffs_done = array(); } # Run it local so it's logged foreach ($diffs_done as $sql) { DB::query($sql); } /* Run the update fixtures file */ echo '<h2>Populating Update Data...</h2>'; $sqlLines = Installer::readSQLFile(SITE_ROOT . '/install/fixtures/update.sql', TABLE_PREFIX); foreach ($sqlLines as $sql) { DB::query($sql['sql']); if (DB::errno() != 0 && DB::errno() != 1062) { echo '<div id="error" style="text-align: left;">Writing to "' . $sql['table'] . '" table... '; echo "<br /><br />" . DB::error(); echo '</div>'; } } OperationsData::updateAircraftRankLevels(); /* Add them to the default group */ $status_type_list = Config::get('PILOT_STATUS_TYPES'); $pilot_list = PilotData::getAllPilots(); foreach ($pilot_list as $pilot) { echo "Fixing settings for " . $pilot->firstname . " " . $pilot->lastname . "<br>"; PilotData::resetLedgerforPilot($pilot->pilotid);
<?php include dirname(__FILE__) . '/bootstrap.inc.php'; include SITE_ROOT . '/install/includes/Installer.class.php'; echo '<pre>'; $_POST['TABLE_PREFIX'] = 'phpvms_'; $sql = Installer::readSQLFile(SITE_ROOT . '/install/sql/install.sql'); print_r($sql);