\n";
do { //start of processing
if (empty($dbHost) OR empty($dbUnam) OR empty($dbName)) { //no db credentials found
$error = "No database credentials found in calendar root (file: lcconfig.php)"; break;
}
if (!isset($dbDef)) { //before v4.1
if (!isset($dbPfix)) { //config data not complete
$error = "Not all configuration data found in calendar root (file: lcconfig.php)"; break;
}
$dbDef = $dbPfix; //set default calendar
}
$calID = $dbDef = rtrim($dbDef,'_'); //remove possible separator "_"
$report[] = "Configuration file 'lcconfig.php' found. Configuration data loaded:";
$report[] = "- Database name: {$dbName}";
$report[] = "- Default calendar: {$dbDef}";
//connect to database
if (!$dbH = dbConnect('void',0)) {
$error = "Could not connect to database"; break;
}
//check/update table prefixes of old versions
$stH = dbQuery("SHOW TABLES LIKE '%settings'");
while ($row = $stH->fetch(PDO::FETCH_NUM)) {
$matches = array();
if (preg_match('~^([a-z\d]{0,20})settings$~',$row[0],$matches)) { //no prefix or no separator (_)
$fromPf = empty($matches[1]) ? '' : $matches[1];
$toPf = empty($matches[1]) ? 'mycal' : $matches[1]; //no prefix: 'mycal'
$q = "RENAME TABLE
{$fromPf}events TO {$toPf}_events,
{$fromPf}categories TO {$toPf}_categories,
{$fromPf}users TO {$toPf}_users,
{$fromPf}settings TO {$toPf}_settings
";
$stH2 = dbQuery($q);
if ($stH2) { $report[] = "Tables '{$fromPf}xxxxxx' renamed to '{$toPf}_xxxxxx'"; }
$calID = $dbDef = $toPf;
}
}
//get settings of default calendar and set time zone
$dbSet = getSettings();
if ($dbSet === false) {
$error = "Could not retrieve calendar settings from the database"; break;
}
date_default_timezone_set($dbSet['timeZone']);
$report[] = "Default calendar settings retrieved and timezone set to:";
$report[] = "- ".$dbSet['timeZone'];
/* ===== LuxCal 3.1.0 drop table `x_sessdata` (not used anymore) ===== */
dbQuery("DROP TABLE IF EXISTS `x_sessdata`",0);
//get installed calendars
$allCals = getCals();
if (empty($allCals)) {
$error = "No calendars found in the database."; break;
}
$report[] = "Calendar(s) found in the database:";
foreach($allCals as $cID=>$title) {
$report[] = '- '.$cID.' = '.$title.($cID == $dbDef ? "
(default)" : '');
}
/*============================= start upgrading ==============================*/
foreach($allCals as $cID=>$title) { //process each installed calendar
$report[] = "Processing calendar: {$cID} - {$title}";
$calID = $cID; //set current calendar
//upgrade db tables to the latest schema, while preserving data
upgradeDb();
$report[] = "- Database tables and structures verified/updated.";
//upgrade admin settings
$dbSet = getSettings();
checkSettings($dbSet);
saveSettings($dbSet);
$report[] = "- Administrator settings verified/updated";
}
//Save LuxCal version and config data
if (!saveConfig()) {
$error = "Unable to write the file lcconfig.php to calendar root. Check file permissions (should be 755)."; break;
}
$report[] = "Configuration file 'lcconfig.php' updated and saved to root folder.";
//check .htaccess file for blocking access to .cdb, .log and .txt files
if ($htaccess = htaccess()) { $report[] = "
{$htaccess}"; }
} while (0); //end of processing
echo "
\n";
if (empty($error)) {
echo "
Start of Upgrade
\n";
echo "
\n";
foreach($report as $text) { echo $text[0] == '-' ? "
{$text}\n" : "- {$text}\n"; } //show each step
echo "
\n";
echo "
End of Upgrade
\n";
echo "
\n";
echo "
\n";
echo "The calendar has been upgraded to version {$lcV}.\n";
echo "
Make a back-up copy of the configuration file 'lcconfig.php'.
\n";
echo "
\n";
echo "\n";
echo "
\n
\n";
} else {
echo "
\n";
echo "
The following error occurred:
\n";
echo "
- {$error}
\n";
echo "The calendar upgrade to version {$lcV} has been aborted.
\n";
echo "Correct the error and restart the upgrade script.\n";
echo "
\n";
}
echo "
\n";
?>