    <h3>/home/bparcsg/public_html/bookingtest/upgrade472.php dÃ¼zenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/bookingtest/upgrade472.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
*/

//Cipher a string (needed for LuxCal 2.7.2)
function ciph($s,$n=0) {
	$splits = str_split($s);
	foreach ($splits as &amp;$ch) { //lc:F uc:C
		$c = ord($ch);
		if ($c == 58-($n*26)) { $ch = chr(32+($n*26)); }
		$ch = ($c &gt;= 97 and $c &lt;= 122) ? chr(($c-82-($n*4))%26+97) : (($c &gt;= 65 and $c &lt;= 90) ? chr(($c-53+($n*2))%26+65) : $ch);
	}
	return implode($splits);
}

//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')) { //try lcconfig.php (LuxCal 2.7.3+)
	include './lcconfig.php';
} elseif (file_exists('./lcaldbc.dat')) { //try lcaldbc.dat (LuxCal 2.6.0 - 2.7.2)
	if (list(,,$dbc) = file('./lcaldbc.dat',FILE_IGNORE_NEW_LINES)) {
		list($dbHost,$dbName,$dbUnam,$dbPwrd,$dbPfix) = unserialize(ciph($dbc,1));
	}
}
if (empty($dbType)) { $dbType = 'MySQL'; } //set database type
$lcV = implode('.',str_split(substr(basename(__FILE__),7,-4))).'M'; //set new LuxCal version

//delete possible calID cookie of previous installation
$calPath = './'.basename(__DIR__);
setcookie('LCALcid', '', time()-3600,$calPath);

//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:14px arial, sans-serif; background:#E0E0E0; color:#2B3856; cursor:default;}
a {text-decoration:none; cursor:pointer;}
header {margin:6px 0; padding:0 1%; font-size:1.2em; font-weight:bold;}
h4 {margin:6px 0; font-size:1.2em;}
h5 {margin:2px 0; font-size:1.1em;}
td {vertical-align:top;}
input, textarea {font:0.9em arial, sans-serif;}
input[type=&quot;text&quot;], textarea { width:100%;}
button {font-size:0.9em; padding:0 4px; 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:420px; 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:120px;}
.col2 {width:290px;}
.flag {color:#FF3300;}
.title {font:bold 1.4em arial, sans-serif;}
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($dbHost) OR empty($dbUnam) OR empty($dbName)) { //no db credentials found
		$error = &quot;No database credentials found in calendar root (file: lcconfig.php)&quot;; break;
	}
	if (!isset($dbDef)) { //before v4.1
		if (!isset($dbPfix)) { //config data not complete
			$error = &quot;Not all configuration data found in calendar root (file: lcconfig.php)&quot;; break;
		}
		$dbDef = $dbPfix; //set default calendar
	}
	$calID = $dbDef = rtrim($dbDef,'_'); //remove possible separator &quot;_&quot;

	$report[] = &quot;Configuration file 'lcconfig.php' found. Configuration data loaded:&quot;;
	$report[] = &quot;- Database name: {$dbName}&quot;;
	$report[] = &quot;- Default calendar: {$dbDef}&quot;;

	//connect to database
	if (!$dbH = dbConnect('void',0)) {
		$error = &quot;Could not connect to database&quot;; break;
	}

	//check/update table prefixes of old versions
	$stH = dbQuery(&quot;SHOW TABLES LIKE '%settings'&quot;);
	while ($row = $stH-&gt;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 = &quot;RENAME TABLE
			{$fromPf}events     TO {$toPf}_events,
			{$fromPf}categories TO {$toPf}_categories,
			{$fromPf}users      TO {$toPf}_users,
			{$fromPf}settings   TO {$toPf}_settings
			&quot;;
			$stH2 = dbQuery($q);
			if ($stH2) { $report[] = &quot;Tables '{$fromPf}xxxxxx' renamed to '{$toPf}_xxxxxx'&quot;; }
			$calID = $dbDef = $toPf;
		}
	}
	
	//get settings of default calendar and set time zone
	$dbSet = getSettings();
	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'];

	/* ===== LuxCal 3.1.0 drop table `x_sessdata` (not used anymore) ===== */
	dbQuery(&quot;DROP TABLE IF EXISTS `x_sessdata`&quot;,0);
		
	//get installed calendars
	$allCals = getCals();
	if (empty($allCals)) {
		$error = &quot;No calendars found in the database.&quot;; break;
	}
	$report[] = &quot;Calendar(s) found in the database:&quot;;
	foreach($allCals as $cID=&gt;$title) {
		$report[] = '- '.$cID.' = '.$title.($cID == $dbDef ? &quot; &lt;span class='mark'&gt;(default)&lt;/span&gt;&quot; : '');
	}

	/*============================= start upgrading ==============================*/

	foreach($allCals as $cID=&gt;$title) { //process each installed calendar
		$report[] = &quot;Processing calendar: {$cID} - {$title}&quot;;
		$calID = $cID; //set current calendar
		
		//upgrade db tables to the latest schema, while preserving data
		upgradeDb();
		$report[] = &quot;- Database tables and structures verified/updated.&quot;;

		//upgrade admin settings
		$dbSet = getSettings();
		checkSettings($dbSet);
		saveSettings($dbSet);
		$report[] = &quot;- Administrator settings verified/updated&quot;;
	}
	
	//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;;

	//check .htaccess file for blocking access to .cdb, .log and .txt files
	if ($htaccess = htaccess()) { $report[] = &quot;&lt;span class='mark'&gt;{$htaccess}&lt;/span&gt;&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;button type='button' onclick=\&quot;window.location.href='index.php'\&quot;&gt;Start Calendar&lt;/button&gt;\n&quot;;
	echo &quot;&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;?=basename(__FILE__);?&gt; INACCESSIBLE OR REMOVE IT FROM THE SERVER !&lt;/h4&gt;&lt;/div&gt;
&lt;div class=&quot;endBar&quot;&gt;
	design &lt;?=date('Y');?&gt;- 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/bookingtest">â† Geri</a>