# 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);
