    <h3>/home/bparcsg/public_html/bookingnew/common/toolboxx.php dĂźzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/bookingnew/common/toolboxx.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
======== ADMIN WORK BENCH TOOLS =========

Š Copyright 2009-2018 LuxSoft - www.LuxSoft.eu

This file is part of the LuxCal Web Calendar.
*/
//default settings
$defSet = array( //name =&gt; default value, outline
	'calendarTitle' =&gt; array('LuxCal Calendar','Calendar title displayed in the top bar'),
	'calendarUrl' =&gt; array('http://'.$_SERVER['SERVER_NAME'].rtrim(dirname($_SERVER[&quot;PHP_SELF&quot;]),'/').'/index.php','Calendar link (URL)'),
	'backLinkUrl' =&gt; array('','Nav bar back link URL (blank: no link, url: link)'),
	'logoPath' =&gt; array('','Path/name of optional left upper corner logo image'),
	'timeZone' =&gt; array('Europe/Amsterdam','Calendar time zone'),
	'notifChange' =&gt; array(0,'Send a notification when event added/edited/deleted (0:no, 1:yes)'),
	'recipList' =&gt; array('','List of notification email/SMS addresses'),
	'rssFeed' =&gt; array(1,'Display RSS feed links in footer and HTML head (0:no, 1:yes)'),
	'logWarnings' =&gt; array(1,'Log calendar warning messages (0:no, 1:yes)'),
	'logNotices' =&gt; array(0,'Log calendar notice messages (0:no, 1:yes)'),
	'navButText' =&gt; array(0,'Navigation buttons with text or icons (0:icons, 1:text)'),
	'contButton' =&gt; array(1,'Display Contact button on navbar (0:no, 1:yes)'),
	'navToapList' =&gt; array(1,'Display Toab List button on navbar (0:no, 1:yes)'),
	'navTodoList' =&gt; array(1,'Display Todo List button on navbar (0:no, 1:yes)'),
	'navUpcoList' =&gt; array(1,'Display Upco List button on navbar (0:no, 1:yes)'),
	'viewMenu' =&gt; array(1,'Display view menu in options panel (0:no, 1:yes)'),
	'groupMenu' =&gt; array(1,'Display group filter menu in options panel (0:no, 1:yes)'),
	'userMenu' =&gt; array(1,'Display user filter menu in options panel (0:no, 1:yes)'),
	'catMenu' =&gt; array(1,'Display category filter menu in options panel(0:no, 1:yes)'),
	'langMenu' =&gt; array(0,'Display ui-language selection menu in options panel (0:no, 1:yes)'),
	'viewsPublic' =&gt; array('1,2,3,4,5,6,7,8,9,10','Calendar views available to the public users'),
	'viewsLogged' =&gt; array('1,2,3,4,5,6,7,8,9,10','Calendar views available to the logged-in users'),
	'viewButsPub' =&gt; array('','View buttons on the navbar (1:year, ... 9:matrix) - public user'),
	'viewButsLog' =&gt; array('','View buttons on the navbar (1:year, ... 9:matrix) - logged in user'),
	'defViewPub' =&gt; array(2,'Calendar view at start-up (1:year, ... 8:changes) - public user'),
	'defViewLog' =&gt; array(2,'Calendar view at start-up (1:year, ... 8:changes) - logged in user'),
	'language' =&gt; array('English','Default user interface language'),
	'ownerTitle' =&gt; array(0,'Prepend owner to event title (0:disabled 1:enabled)'),
	'privEvents' =&gt; array(1,'Private events (0:disabled 1:enabled, 2:default, 3:always)'),
	'aldDefault' =&gt; array(0,'All-day event default in event window (0:no 1:yes)'),
	'details4All' =&gt; array(1,'Show event details to x users (0:none, 1:all, 2:logged-in users)'),
	'evtDelButton' =&gt; array(1,'Display Delete button in Event window (0:no, 1:yes, 2:manager)'),
	'eventColor' =&gt; array(1,'Event colors (0:user color, 1:cat color)'),
	'xField1Label' =&gt; array('','Label optional extra event field 1'),
	'xField2Label' =&gt; array('','Label optional extra event field 2'),
	'xField1Public' =&gt; array(1,'Extra event field 1 for all users'),
	'xField2Public' =&gt; array(1,'Extra event field 2 for all users'),
	'selfReg' =&gt; array(0,'Self-registration (0:no, 1:yes)'),
	'selfRegGrp' =&gt; array(4,'Self-registration user group ID'),
	'selfRegNot' =&gt; array(0,'User self-reg notification to admin (0:no, 1:yes)'),
	'restLastSel' =&gt; array(1,'Restore last session when user revisits calendar'),
	'cookieExp' =&gt; array(30,'Number of days before a Remember Me cookie expires'),
	'evtTemplGen' =&gt; array('12345678','Event fields and order of fields in general views'),
	'evtTemplUpc' =&gt; array('123458','Event fields and order of fields in upcoming events view'),
	'evtTemplPop' =&gt; array('123458','Event fields and order of fields in hover box'),
	'yearStart' =&gt; array(0,'Start month in year view (1-12 or 0, 0:current month)'),
	'YvColsToShow' =&gt; array(3,'Number of months to show per row in year view'),
	'YvRowsToShow' =&gt; array(4,'Number of rows to show in year view'),
	'MvWeeksToShow' =&gt; array(10,'Number of weeks to show in month view'),
	'workWeekDays' =&gt; array('12345','Working days (0: su - 6: sa)'),
	'weekStart' =&gt; array(1,'First day of the week (0: su - 6: sa)'),
	'XvWeeksToShow' =&gt; array(8,'Number of weeks to show in matrix view'),
	'lookaheadDays' =&gt; array(14,'Days to look ahead in upcoming view, todo list and RSS feeds'),
	'dwStartHour' =&gt; array(6,'Day/week view start hour'),
	'dwEndHour' =&gt; array(18,'Day/week view end hour'),
	'dwTimeSlot' =&gt; array(30,'Day/week time slot in minutes'),
	'dwTsHeight' =&gt; array(20,'Day/week time slot height in pixels'),
	'showUrlInMV' =&gt; array(1,'Show URL-links in month view (0:no, 1:yes)'),
	'showEmlInMV' =&gt; array(1,'Show mailto-links in month view (0:no, 1:yes)'),
	'showImgInMV' =&gt; array(0,'Show images in month view (0:no, 1:yes)'),
	'monthInDCell' =&gt; array(0,'Show in month view month for each day (0:no, 1:yes)'),
	'dateFormat' =&gt; array('d.m.y','Date format: yyyy-mm-dd (y:yyyy, m:mm, d:dd)'),
	'MdFormat' =&gt; array('d M','Date format: dd month (d:dd, M:month)'),
	'MdyFormat' =&gt; array('d M y','Date format: dd month yyyy (d:dd, M:month, y:yyyy)'),
	'MyFormat' =&gt; array('M y','Date format: month yyyy (M:month, y:yyyy)'),
	'DMdFormat' =&gt; array('WD d M','Date format: weekday dd month (WD:weekday d:dd, M:month)'),
	'DMdyFormat' =&gt; array('WD d M y','Date format: weekday dd month yyyy (WD:weekday d:dd, M:month, y:yyyy)'),
	'timeFormat' =&gt; array('h:m','Time format (H:hh, h:h, m:mm, a:am|pm, A:AM|PM)'),
	'weekNumber' =&gt; array(1,'Week numbers on(1) or off(0)'),
	'emlService' =&gt; array(1,'Mail service (0:no, 1:yes)'),
	'smsService' =&gt; array(0,'SMS service (0:no, 1:yes)'),
	'defRecips' =&gt; array('','Default recipients list for email and SMS notifications'),
	'notSenderEml' =&gt; array(0,'Sender of notification emails (0:calendar, 1:user)'),
	'calendarEmail' =&gt; array('calendar@email.com','Sender of email notifications'),
	'smtpServer' =&gt; array('','SMTP mail server name'),
	'smtpPort' =&gt; array(465,'SMTP port number'),
	'smtpSsl' =&gt; array(1,'Use SSL (Secure Sockets Layer) (0:no, 1:yes)'),
	'smtpAuth' =&gt; array(1,'Use SMTP authentication (0:no, 1:yes)'),
	'smtpUser' =&gt; array('','SMTP username'),
	'smtpPass' =&gt; array('','SMTP password'),
	'notSenderSms' =&gt; array(0,'Sender of notification SMSes (0:calendar, 1:user)'),
	'calendarPhone' =&gt; array('','Sender of SMS notifications'),
	'smsCarrier' =&gt; array('','SMS carrier template (# = mob. phone number)'),
	'smsCountry' =&gt; array('','SMS country code'),
	'cCodePrefix' =&gt; array(1,'Country code starts with prefix + or 00 (0:no, 1:yes)'),
	'smsSubject' =&gt; array(' ','Subject field template for SMS emails to the carrier'),
	'maxLenSms' =&gt; array(70,'Maximum length of SMS messages (bytes)'),
	'smsAddLink' =&gt; array(0,'Add event report link to SMS (0:no, 1:yes)'),
	'mailServer' =&gt; array(1,'Mail server (1:PHP mail, 2:SMTP mail)'),
	'adminCronSum' =&gt; array(1,'Send cron job summary to admin (0:no, 1:yes)'),
	'chgEmailList' =&gt; array('','Recipient email addresses for calendar changes'),
	'chgNofDays' =&gt; array(1,'Number of days to look back for calendar changes'),
	'icsExport' =&gt; array(0,'Daily export of events in iCal format (0:no 1:yes)'),
	'eventExp' =&gt; array(0,'Number of days after due when an event expires / can be deleted (0:never)'),
	'maxNoLogin' =&gt; array(0,'Number of days not logged in, before deleting user account (0:never delete)'),
	'popFieldsSbar' =&gt; array('12345','Event fields in sidebar hover box (none: no box)'),
	'showLinkInSB' =&gt; array(1,'Show URL-links in sidebar (0:no, 1:yes)'),
	'sideBarDays' =&gt; array(14,'Days to look ahead in sidebar')
);

//default styles &amp; settings
//B: background, C; color, E: border, F&quot; font family, P: fontsize px, M; font size em
$defSaS = array( //name =&gt; default value
	'000' =&gt; 'THEME TITLE',
	'THEME' =&gt; '', //theme title
	'010' =&gt; 'GENERAL',
	'011' =&gt; 'BACKGROUND COLORS',
	'BXXXX' =&gt; '#E0E0E0', //calendar general
	'BTBAR' =&gt; '#FDFDFD', //calendar top bar
	'BBHAR' =&gt; '#AAAAFF', //bar, headers &amp; rulers
	'BBUTS' =&gt; '#FFFFFF', //buttons
	'BDROP' =&gt; '#FFFFFF', //drop down menus
	'BXWIN' =&gt; '#FFFFEE', //event/help window
	'BINBX' =&gt; '#FFFFEE', //insert boxes
	'BOVBX' =&gt; '#FEFEFE', //overlay boxes
	'BFFLD' =&gt; '#FFFFFF', //form fields
	'BCONF' =&gt; '#A0D070', //confirmation msg
	'BWARN' =&gt; '#FFF0A0', //warning msg
	'BERRO' =&gt; '#F0A070', //error msg
	'BHLIT' =&gt; '#FF2222', //text highlight
	'012' =&gt; 'TEXT COLORS',
	'CXXXX' =&gt; '#2B3856', //normal text
	'CTBAR' =&gt; '#2B3856', //calendar top bar
	'CBHAR' =&gt; '#2B3856', //bars, headers &amp; rulers
	'CBUTS' =&gt; '#2B3856', //buttons
	'CDROP' =&gt; '#2B3856', //drop down menus
	'CXWIN' =&gt; '#2B3856', //event/help window
	'CINBX' =&gt; '#2B3856', //insert boxes
	'COVBX' =&gt; '#2B3856', //overlay boxes
	'CFFLD' =&gt; '#2B3856', //form fields
	'CCONF' =&gt; '#2B3856', //confirmation msg
	'CWARN' =&gt; '#2B3856', //warning msg
	'CERRO' =&gt; '#2B3856', //error msg
	'CHLIT' =&gt; '#2B3856', //text highlight
	'013' =&gt; 'BORDER COLORS',
	'EXXXX' =&gt; '#808080', //general borders
	'EOVBX' =&gt; '#AAAAFF', //overlay borders
	'EBUTS' =&gt; '#0080FE', //buttons on hover borders
	'014' =&gt; 'FONT FAMILY/SIZES',
	'FFXXX' =&gt; 'arial,sans-serif', //base font family
	'PSXXX' =&gt; '12', //base font size
	'PTBAR' =&gt; '13', //top bar text
	'PPGTL' =&gt; '14', //page headers
	'PTHDL' =&gt; '13', //table headers L
	'MTHDM' =&gt; '1.0', //table headers M
	'MDTHD' =&gt; '1.0', //date headers
	'MSNHD' =&gt; '1.0', //section headers
	'MOVBX' =&gt; '1.0', //side bar, options panel
	'MFFLD' =&gt; '1.0', //form fields
	'MBUTS' =&gt; '0.9', //buttons
	'MPWIN' =&gt; '1.1', //popup window
	'MSMAL' =&gt; '0.8', //small text
	'015' =&gt; 'MISCELLANEOUS',
	'sTbSw' =&gt; 1, //top bar shadow (0:no 1:yes)
	'sCtOf' =&gt; 0, //content top in pixels

	'020' =&gt; 'GRID / VIEWS',
	'021' =&gt; 'BACKGROUND COLORS',
	'BGCTH' =&gt; '#F2F2F2', //day cell top - hover
	'BGTFD' =&gt; '#AAAAFF', //first day of month
	'BGWTC' =&gt; '#FFFFBB', //grid - weeknr/time column
	'BGWD1' =&gt; '#FFFFEE', //grid - weekday month 1
	'BGWD2' =&gt; '#FFFFDD', //grid - weekday month 2
	'BGWE1' =&gt; '#FFFFCC', //grid - weekend month 1
	'BGWE2' =&gt; '#FFFFBB', //grid - weekend month 2
	'BGOUT' =&gt; '#FEFEFE', //grid - outside month
	'BGTOD' =&gt; '#EEEEFF', //grid - day cell today
	'BGSEL' =&gt; '#FFEEEE', //grid - day cell selected day
	'BCHBX' =&gt; '#FFFFDD', //todo check box
	'022' =&gt; 'TEXT COLORS',
	'CGWTC' =&gt; '#666666', //cell head, times, week numbers
	'CGTFD' =&gt; '#2B3856', //1st day of month
	'CGWD1' =&gt; '#2B3856', //grid - weekday month 1
	'CGWD2' =&gt; '#2B3856', //grid - weekday month 2
	'CGWE1' =&gt; '#2B3856', //grid - weekend month 1
	'CGWE2' =&gt; '#2B3856', //grid - weekend month 2
	'CGOUT' =&gt; '#2B3856', //grid - outside month
	'CGTOD' =&gt; '#2B3856', //grid - day cell today
	'CGSEL' =&gt; '#2B3856', //grid - day cell selected day
	'CCHBX' =&gt; '#FF0000', //todo check box
	'023' =&gt; 'BORDER COLORS',
	'EGTOD' =&gt; '#0000FF', //grid - day cell today
	'EGSEL' =&gt; '#FF0000', //grid - day cell selected day
	'024' =&gt; 'FONT SIZES',
	'MEVTI' =&gt; '1.0', //event title in views

	'030' =&gt; 'HOVER BOXES',
	'031' =&gt; 'BACKGROUND COLORS',
	'BHNOR' =&gt; '#FFFFE0', //normal event
	'BHPRI' =&gt; '#CCFFCC', //private event
	'BHREP' =&gt; '#FFFFE0', //repeating event
	'032' =&gt; 'TEXT COLORS',
	'CHNOR' =&gt; '#2B3856', //hover popup box
	'CHPRI' =&gt; '#2B3856', //hover popup box
	'CHREP' =&gt; '#2B3856', //hover popup box
	'033' =&gt; 'BORDER COLORS',
	'EHNOR' =&gt; '#808080', //normal event
	'EHPRI' =&gt; '#808080', //private event
	'EHREP' =&gt; '#E00060', //repeating event
	'034' =&gt; 'FONT SIZES',
	'MPOPU' =&gt; '1.0' //hover popup box
);

//database table SQL definitions
$sqlTableDefs = array(
	&quot;events&quot; =&gt; &quot;`ID` INTEGER PRIMARY KEY &quot;.($dbType == 'SQLite' ? 'AUTOINCREMENT' : 'AUTO_INCREMENT').&quot;,
		`type` TINYINT NOT NULL DEFAULT 0,
		`private` TINYINT NOT NULL DEFAULT 0,
		`title` VARCHAR(255) DEFAULT NULL,
		`venue` VARCHAR(128) DEFAULT NULL,
		`text1` TEXT DEFAULT NULL,
		`text2` VARCHAR(255) DEFAULT NULL,
		`text3` VARCHAR(255) DEFAULT NULL,
		`attach` TEXT DEFAULT NULL,
		`catID` MEDIUMINT NOT NULL DEFAULT 1,
		`scatID` TINYINT NOT NULL DEFAULT 0,
		`userID` MEDIUMINT DEFAULT NULL,
		`editor` VARCHAR(48) NOT NULL DEFAULT '',
		`approved` TINYINT NOT NULL DEFAULT 0,
		`checked` TEXT DEFAULT NULL,
		`notEml` TINYINT NOT NULL DEFAULT -1,
		`notSms` TINYINT NOT NULL DEFAULT -1,
		`notRecip` VARCHAR(255) DEFAULT NULL,
		`sDate` VARCHAR(10) DEFAULT NULL,
		`eDate` VARCHAR(10) NOT NULL DEFAULT '9999-00-00',
		`xDates` TEXT DEFAULT NULL,
		`sTime` VARCHAR(5) DEFAULT NULL,
		`eTime` VARCHAR(5) NOT NULL DEFAULT '99:00',
		`rType` TINYINT NOT NULL DEFAULT 0,
		`rInterval` TINYINT NOT NULL DEFAULT 0,
		`rPeriod` TINYINT NOT NULL DEFAULT 0,
		`rMonth` TINYINT NOT NULL DEFAULT 0,
		`rUntil` VARCHAR(10) NOT NULL DEFAULT '9999-00-00',
		`aDateTime` VARCHAR(16) NOT NULL DEFAULT '9999-00-00 00:00',
		`mDateTime` VARCHAR(16) NOT NULL DEFAULT '9999-00-00 00:00',
		`status` BOOLEAN NOT NULL DEFAULT 0&quot;,
	&quot;categories&quot; =&gt; &quot;`ID` INTEGER PRIMARY KEY &quot;.($dbType == 'SQLite' ? 'AUTOINCREMENT' : 'AUTO_INCREMENT').&quot;,
		`name` VARCHAR(48) NOT NULL DEFAULT '',
		`symbol` VARCHAR(8) NOT NULL DEFAULT '',
		`sequence` TINYINT NOT NULL DEFAULT 1,
		`repeat` TINYINT NOT NULL DEFAULT 0,
		`noverlap` TINYINT NOT NULL DEFAULT 0,
		`olErrMsg` VARCHAR(56) NOT NULL DEFAULT '',
		`defSlot` TINYINT NOT NULL DEFAULT 0,
		`approve` TINYINT NOT NULL DEFAULT 0,
		`dayColor` TINYINT NOT NULL DEFAULT 0,
		`color` VARCHAR(8) DEFAULT NULL,
		`bgColor` VARCHAR(8) DEFAULT NULL,
		`checkBx` TINYINT NOT NULL DEFAULT 0,
		`checkLb` VARCHAR(16) NOT NULL DEFAULT 'approved',
		`checkMk` VARCHAR(8) NOT NULL DEFAULT '&amp;#x2713;',
		`subName1` VARCHAR(20) NOT NULL DEFAULT '',
		`subColor1` VARCHAR(8) DEFAULT NULL,
		`subBgrnd1` VARCHAR(8) DEFAULT NULL,
		`subName2` VARCHAR(20) NOT NULL DEFAULT '',
		`subColor2` VARCHAR(8) DEFAULT NULL,
		`subBgrnd2` VARCHAR(8) DEFAULT NULL,
		`subName3` VARCHAR(20) NOT NULL DEFAULT '',
		`subColor3` VARCHAR(8) DEFAULT NULL,
		`subBgrnd3` VARCHAR(8) DEFAULT NULL,
		`subName4` VARCHAR(20) NOT NULL DEFAULT '',
		`subColor4` VARCHAR(8) DEFAULT NULL,
		`subBgrnd4` VARCHAR(8) DEFAULT NULL,
		`urlLink` VARCHAR(120) NOT NULL DEFAULT '',
		`status` BOOLEAN NOT NULL DEFAULT 0&quot;,
	&quot;users&quot; =&gt; &quot;`ID` INTEGER PRIMARY KEY &quot;.($dbType == 'SQLite' ? 'AUTOINCREMENT' : 'AUTO_INCREMENT').&quot;,
		`name` VARCHAR(48) NOT NULL DEFAULT '',
		`password` VARCHAR(32) NOT NULL DEFAULT '',
		`tPassword` VARCHAR(32) DEFAULT NULL,
		`email` VARCHAR(255) NOT NULL DEFAULT '',
		`phone` VARCHAR(32) NOT NULL DEFAULT '',
		`number` VARCHAR(32) NOT NULL DEFAULT '',
		`groupID` MEDIUMINT NOT NULL DEFAULT 3,
		`language` VARCHAR(24) DEFAULT 'english',
		`login0` VARCHAR(10) NOT NULL DEFAULT '9999-00-00',
		`login1` VARCHAR(10) NOT NULL DEFAULT '9999-00-00',
		`loginCnt` MEDIUMINT NOT NULL DEFAULT 0,
		`status` BOOLEAN NOT NULL DEFAULT 0&quot;,
	&quot;groups&quot; =&gt; &quot;`ID` INTEGER PRIMARY KEY &quot;.($dbType == 'SQLite' ? 'AUTOINCREMENT' : 'AUTO_INCREMENT').&quot;,
		`name` VARCHAR(255) NOT NULL DEFAULT '',
		`privs` TINYINT NOT NULL DEFAULT 0,
		`vCatIDs` VARCHAR(128) NOT NULL DEFAULT '0',
		`eCatIDs` VARCHAR(128) NOT NULL DEFAULT '0',
		`rEvents` TINYINT NOT NULL DEFAULT 1,
		`mEvents` TINYINT NOT NULL DEFAULT 1,
		`pEvents` TINYINT NOT NULL DEFAULT 1,
		`upload` TINYINT NOT NULL DEFAULT 0,
		`sendSms` TINYINT NOT NULL DEFAULT 0,
		`color` VARCHAR(8) DEFAULT NULL,
		`status` BOOLEAN NOT NULL DEFAULT 0&quot;,
	&quot;settings&quot; =&gt; &quot;`name` VARCHAR(16) NOT NULL DEFAULT '',
		`value` VARCHAR(255) DEFAULT NULL,
		`outline` VARCHAR(128) DEFAULT NULL&quot;,
	&quot;styles&quot; =&gt; &quot;`name` VARCHAR(8) NOT NULL DEFAULT '',
		`value` VARCHAR(255) DEFAULT NULL&quot;
);

function createDbTable($name,$drop = 0) { //create database table
	global $sqlTableDefs, $dbType;

	if ($drop) { dbQuery(&quot;DROP TABLE IF EXISTS `{$name}`&quot;); }
	if ($dbType == 'SQLite') { //SQLite
		dbQuery(&quot;CREATE TABLE IF NOT EXISTS `{$name}` (\n{$sqlTableDefs[rtrim($name,'X')]})&quot;);
	} else { //MySQL
		dbQuery(&quot;CREATE TABLE IF NOT EXISTS `{$name}` (\n{$sqlTableDefs[rtrim($name,'X')]}) ENGINE=InnoDB  DEFAULT CHARSET=utf8 &quot;);
	}
}

function initCats() { //init categories table
	$stH = stPrep(&quot;REPLACE INTO `categories` (`ID`,`name`,`sequence`) VALUES (?,?,?)&quot;);
	stExec($stH,array(1,'no cat',1));
}

function initUsers($adName,$adMail,$adPwMd5) { //init users table
	$users = array(array(1,'Public Access','','',3),array(2,$adName,$adMail,$adPwMd5,2)); //public user + admin user
	dbTransaction('begin');
	$stH = stPrep(&quot;REPLACE INTO `users` (`ID`,`name`,`email`,`password`,`groupID`) VALUES (?,?,?,?,?)&quot;);
	foreach($users as $user) {
		stExec($stH,$user);
	}
	dbTransaction('commit');
}

function initGroups() { //init groups table
	$groups = array(array(1,'No access',0,'0',0,0),array(2,'Admin',9,'0',1,1),array(3,'Read access',1,'0',0,0),array(4,'Post Own',2,'0',0,0),array(5,'Post All',3,'0',0,0),array(6,'Manager',4,'0',1,1));
	dbTransaction('begin');
	$stH = stPrep(&quot;REPLACE INTO `groups` (`ID`,`name`,`privs`,`vCatIDs`,`upload`,`sendSms`) VALUES (?,?,?,?,?,?)&quot;);
	foreach($groups as $group) {
		stExec($stH,$group);
	}
	dbTransaction('commit');
}

function initStyles() { //init styles table
	global $defSaS, $set;
	
	dbTransaction('begin');
	$stH = stPrep(&quot;INSERT INTO `styles` (`name`,`value`) VALUES (?,?)&quot;);
	foreach($defSaS as $key =&gt; $value) {
		$dbValue = $key != 'THEME' ? $value : $set['calendarTitle'];
		if ($key[0] != '0') { //skip titles
			stExec($stH,array($key,$dbValue));
		}
	}
	dbTransaction('commit');
}

function checkSettings(&amp;$dbSet) { //check &amp; complete calendar settings
	global $defSet;
	
	foreach($defSet as $key =&gt; $value) {
		if (!isset($dbSet[$key])) { //set not-set settings to default value
			$dbSet[$key] = $value[0];
		}
	}
	foreach($dbSet as $key =&gt; $value) {
		if (!isset($defSet[$key])) { //delete redundant settings
			unset($dbSet[$key]);
		}
	}
}

function saveSettings(&amp;$dbSet) { //save settings to calendar
	global $defSet;
	
	dbTransaction('begin');
	$stH = stPrep(&quot;DELETE FROM `settings`&quot;); // empty table
	stExec($stH,null);
	$stH = stPrep(&quot;REPLACE INTO `settings` VALUES (?,?,?)&quot;); //save settings
	foreach($dbSet as $key =&gt; $value) {
		stExec($stH,array($key,$value,$defSet[$key][1]));
	}
	dbTransaction('commit');
}

function saveConfig() { //Save LuxCal version and db data to lcconfig.php
	global $lcV, $dbType, $dbDef, $dbSel, $crHost, $crIpAd;

	$config = '&lt;?php
/*
= LuxCal event calendar configuration =
*/
$lcV=&quot;'.$lcV.'&quot;; //LuxCal version';
	if ($dbType == 'SQLite') { //SQLite
		global $dbDir;

		$config .= '
$dbType=&quot;SQLite&quot;; //db type (MySQL or SQLite)
$dbDir=&quot;'.(isset($dbDir) ? $dbDir : 'db/').'&quot;; //db directory';
	} else { //MySQL
		global $dbHost, $dbUnam, $dbPwrd, $dbName;

		$config .= '
$dbType=&quot;MySQL&quot;; //db type (MySQL or SQLite)
$dbHost=&quot;'.$dbHost.'&quot;; //MySQL server
$dbUnam=&quot;'.$dbUnam.'&quot;; //database username
$dbPwrd=&quot;'.$dbPwrd.'&quot;; //database password
$dbName=&quot;'.$dbName.'&quot;; //database name';
	}
	$config .= '
$dbDef=&quot;'.(isset($dbDef) ? $dbDef : '').'&quot;; //default calendar (db name)
$dbSel='.(isset($dbSel) ? $dbSel : 1).'; //selectable in Options panel
$crHost='.(isset($crHost) ? $crHost : 0).'; //0:local, 1:remote, 2:remote+IP address
$crIpAd=&quot;'.(isset($crIpAd) ? $crIpAd : '').'&quot;; //IP address of remote cron service
?&gt;';
	return file_put_contents('./lcconfig.php',$config);
}

function backupDatabase($tables,$echo) { //Create a backup file of the database tables
	global $ax, $calID, $set, $lcV;
	
	//make file header
	$sqlFile = &quot;--\n&quot;;
	$sqlFile .= &quot;-- SQL DUMP &quot;.date('Y.m.d @ H:i').&quot;\n&quot;;
	$sqlFile .= &quot;-- Calendar: {$set['calendarTitle']}\n&quot;;
	$sqlFile .= &quot;-- Calendar ID: {$calID}\n&quot;;
	$sqlFile .= &quot;--\n&quot;;
	$sqlFile .= &quot;-- LuxCal version: {$lcV}\n&quot;;
	$sqlFile .= &quot;-- http://www.luxsoft.eu\n&quot;;
	$sqlFile .= &quot;--\n\n&quot;;
	//backup tables
	foreach ($tables as $table) {
		if ($echo) { echo &quot;{$ax['mdb_backup_table']} '{$table}' - &quot;; }
		$sqlFile .= &quot;\n-- &quot;.str_repeat(&quot;=&quot;, 56).&quot;\n\n--\n-- Table {$table}\n--\n\n&quot;;
		$sqlFile .= &quot;DROP TABLE IF EXISTS `{$table}`;\n\n&quot;;
		$sqlFile .= getTableSql($table).&quot;;\n\n&quot;; //get SQL code to create table
		$stH = dbQuery(&quot;SELECT * FROM `{$table}`&quot;);
		$counter = 0;
		while($row = $stH-&gt;fetch(PDO::FETCH_NUM)) {
			$sqlFile .= &quot;INSERT INTO `{$table}` VALUES (&quot;;
			foreach($row as $value) {
				$sqlFile .= isset($value) ? &quot;'&quot;.str_replace(&quot;'&quot;,&quot;''&quot;,$value).&quot;',&quot; : &quot;'',&quot;;
			}
			$sqlFile = substr($sqlFile,0,-1).&quot;);\n&quot;;
			$counter++;
		}
		$stH = null; //release statement handle!
		$sqlFile .=&quot;\n&quot;;
		if ($echo) { echo &quot;{$ax['mdb_backup_done']} ({$counter} {$ax['mdb_records']})&lt;br&gt;\n&quot;; }
	}
	return $sqlFile;
}

function importSqlFile(&amp;$sqlArray) { //Import a database backup file
	global $dbType;

	//init
	$query = '';
	$matches = array();
	$busy = false;
	$curTab = '';
	$count = array('cat' =&gt; 0, 'eve' =&gt; 0, 'use' =&gt; 0, 'gro' =&gt; 0, 'set' =&gt; 0, 'sty' =&gt; 0); //init table counters
	//preprocess SQL queries
	$patTable = '~\s+[&quot;`]?(?:\w{1,20})?_?(events|categories|users|groups|settings|styles)[&quot;`]?(\s*[(;V])~'; //strip calID_ and replace &quot; by ` around table names
	$repTable = ' `$1`$2';
	$patLine = array('~\\\\+[&quot;\']~'); //modify escaped quotes
	$repLine = array(&quot;''&quot;);
	if ($dbType == 'SQLite') { //SQLite - solve MySQL incompatibilities
		$patLine[] = '~\).*ENGINE.*;~';
		$repLine[] = ');';
		$patLine[] = '~\sunsigned~';
		$repLine[] = '';
		$patLine[] = '~\sAUTO_?INCREMENT~';
		$repLine[] = '';
		$patLine[] = '~\s?COLLATE\s[\w]+~';
		$repLine[] = '';
		$patLine[] = '~\sclass=[^\s&gt;]+~';
		$repLine[] = '';
	} else { //MySQL - solve SQLite incompatibilities
		$patLine[] = '~\sAUTOINCREMENT~';
		$repLine[] = ' AUTO_INCREMENT';
	}
	//restore
	dbTransaction('begin');
	foreach ($sqlArray as $qLine) {
		$qLine = trim($qLine);
		$qLine6 = substr($qLine,0,6);
		if ($qLine6 != 'INSERT' and $qLine6 != 'CREATE' and !$busy) { continue; } //skip line
		if (!$busy) { //begin INSERT or CREATE
			$busy = true;
			$qLine = preg_replace($patTable,$repTable,$qLine,1); //1 replacement
			preg_match('~`(events|categories|users|groups|settings|styles)`~',$qLine,$matches); //find table name
			if ($qLine6 == 'CREATE') { //begin CREATE
				$stH = dbQuery(&quot;DROP TABLE IF EXISTS `{$matches[1]}`;\n&quot;); //drop table before creating
			} else { //begin INSERT
				$curTab = substr($matches[1],0,3); //current table
				$qLine = str_replace('&quot;','`',strstr($qLine,'VALUES',true)).strstr($qLine,'VALUES'); //replace &quot;' by ` around possible column names
				if (substr($qLine,-1) == ';') { $count[$curTab]++; }
			}
		}
		if ($qLine6 != 'INSERT' and $curTab) { $count[$curTab]++; } //increment INSERT counter
		$qLine = preg_replace($patLine,$repLine,$qLine); //do it
		$query .= $qLine.&quot;\n&quot;;
		if (substr($qLine,-1) == ';') { //execute sql query
			$stH = dbQuery($query);
			$busy = false;
			$query = $curTab = '';
		}
	}
	dbTransaction('commit');
	return $count;
}

//
//Upgrade the current ($calID) database from 2.7.2+ to the latest version
//
function upgradeDb() { //upgrade $calID database from 2.7.2+
	global $dbType;
	
	/* === tables pre-processing === */
	//if users.sedit: set privs to 9 for admin accounts (sedit == 1)
	$stH = dbQuery(&quot;SELECT `sedit` FROM `users` LIMIT 1&quot;,0);
	if ($stH) { //column 'sedit' present (V2.7.2)
		$stH = null;
		dbQuery(&quot;UPDATE `users` SET `privs` = 9 WHERE `sedit` = 1&quot;);
	}
	//if table groups not existing - create and populate
	$stH = dbQuery(&quot;SELECT * FROM `groups` LIMIT 1&quot;,0);
	if ($stH === false) { //table not present
		$stH = null;
		createDbTable(&quot;groups&quot;);
		initGroups();
	}
	//if table styles not existing - create and populate
	$stH = dbQuery(&quot;SELECT * FROM `styles` LIMIT 1&quot;,0);
	if ($stH === false) { //table not present
		$stH = null;
		createDbTable(&quot;styles&quot;);
		initStyles();
	} else { //table present, if empty - initialize
		$stH = dbQuery(&quot;SELECT COUNT(*) FROM `styles` LIMIT 1&quot;,0);
		$result = $stH-&gt;fetch(PDO::FETCH_NUM);
		if ($result[0] == 0) { //empty
			initStyles();
		}
	}

	//create temporary tables with new schema
	createDbTable(&quot;usersX&quot;);
	createDbTable(&quot;groupsX&quot;);
	createDbTable(&quot;categoriesX&quot;);
	createDbTable(&quot;eventsX&quot;);
	createDbTable(&quot;settingsX&quot;);
	createDbTable(&quot;stylesX&quot;);

	/* === tables version-processing === */
	dbTransaction('begin');
	do {
		//test if version &lt; 3.1
		$stH = dbQuery(&quot;SELECT `approve` FROM `categories` LIMIT 1&quot;,0);
		if (!$stH) { //column 'approve' not present - version 2.7
			$lcVUpg = '2.7';
			dbQuery(&quot;INSERT INTO `eventsX` (`ID`,`private`,`title`,`venue`,`text1`,`catID`,`userID`,`editor`,`checked`,`notEml`,`notRecip`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status`) 
				SELECT `event_id`,`private`,`title`,`venue`,`description`,`category_id`,`user_id`,`editor`,`checked`,`notify`,`not_mail`,`s_date`,`e_date`,`x_dates`,SUBSTRING(`s_time`,1,5),SUBSTRING(`e_time`,1,5) ,`r_type`,`r_interval`,`r_period`,`r_month`,`r_until`,`a_date`,`m_date`,`status` FROM `events`&quot;); //copy content events table
			dbQuery(&quot;INSERT INTO `usersX` (`ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status`) 
				SELECT `user_id`,`user_name`,`password`,`temp_password`,`email`,`privs`,`language`,`login_0`,`login_1`,`login_cnt`,`status` FROM `users`&quot;); //copy content users table
			dbQuery(&quot;INSERT INTO `groupsX` SELECT * FROM `groups`&quot;); //new table, no change
			dbQuery(&quot;INSERT INTO `categoriesX` (`ID`,`name`,`sequence`,`repeat`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status`) 
				SELECT `category_id`,`name`,`sequence`,`rpeat`,`color`,`background`,`check2`,`label2`,`mark2`,`status` FROM `categories`&quot;); //copy content categories table
			dbQuery(&quot;INSERT INTO `settingsX` (`name`,`value`,`outline`) 
				SELECT `name`,`value`,`description` FROM `settings`&quot;); //copy content settings table
			dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;); //new table, no change
				break; //done
		}
		//test if version = 3.1
		$stH = dbQuery(&quot;SELECT `a_date` FROM `events` LIMIT 1&quot;,0);
		if ($stH !== false) { //column 'a_date' present - version 3.1
			$lcVUpg = '3.1';
			dbQuery(&quot;INSERT INTO `eventsX` (`ID`,`private`,`title`,`venue`,`text1`,`catID`,`userID`,`editor`,`approved`,`checked`,`notEml`,`notRecip`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status`) 
				SELECT `event_id`,`private`,`title`,`venue`,`description`,`category_id`,`user_id`,`editor`,`approved`,`checked`,`notify`,`not_mail`,`s_date`,`e_date`,`x_dates`,SUBSTRING(`s_time`,1,5),SUBSTRING(`e_time`,1,5),`r_type`,`r_interval`,`r_period`,`r_month`,`r_until`,`a_date`,`m_date`,`status` FROM `events`&quot;); //copy content events table
			dbQuery(&quot;INSERT INTO `usersX` (`ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status`) 
				SELECT `user_id`,`user_name`,`password`,`temp_password`,`email`,`privs`,`language`,`login_0`,`login_1`,`login_cnt`,`status` FROM `users`&quot;); //copy content users table
			dbQuery(&quot;INSERT INTO `groupsX` SELECT * FROM `groups`&quot;); //new table, no change
			dbQuery(&quot;INSERT INTO `categoriesX` (`ID`,`name`,`sequence`,`repeat`,`approve`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status`) 
				SELECT `category_id`,`name`,`sequence`,`rpeat`,`approve`,`color`,`background`,`chbox`,`chlabel`,`chmark`,`status` FROM `categories`&quot;); //copy content categories table
			dbQuery(&quot;INSERT INTO `settingsX` (`name`,`value`,`outline`) 
				SELECT `name`,`value`,`description` FROM `settings`&quot;); //copy content settings table
			dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;); //new table, no change
			break; //done
		}
		//test if version = 3.2
		$stH = dbQuery(&quot;SELECT `ID` FROM `events` LIMIT 1&quot;,0);
		if (!$stH) { //column 'ID' not present - version 3.2
			$lcVUpg = '3.2';
			dbQuery(&quot;INSERT INTO `eventsX` (`ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`catID`,`userID`,`editor`,`approved`,`checked`,`notEml`,`notRecip`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status`) 
				SELECT `event_id`,`private`,`title`,`venue`,`description`,`xfield1`,`xfield2`,`category_id`,`user_id`,`editor`,`approved`,`checked`,`notify`,`not_mail`,`s_date`,`e_date`,`x_dates`,SUBSTRING(`s_time`,1,5),SUBSTRING(`e_time`,1,5),`r_type`,`r_interval`,`r_period`,`r_month`,`r_until`,`a_datetime`,`m_datetime`,`status` FROM `events`&quot;); //copy content events table
			dbQuery(&quot;INSERT INTO `usersX` (`ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status`) 
				SELECT `user_id`,`user_name`,`password`,`temp_password`,`email`,`privs`,`language`,`login_0`,`login_1`,`login_cnt`,`status` FROM `users`&quot;); //copy content users table
			dbQuery(&quot;INSERT INTO `groupsX` SELECT * FROM `groups`&quot;); //new table, no change
			dbQuery(&quot;INSERT INTO `categoriesX` (`ID`,`name`,`sequence`,`repeat`,`approve`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status`) 
				SELECT `category_id`,`name`,`sequence`,`rpeat`,`approve`,`color`,`background`,`chbox`,`chlabel`,`chmark`,`status` FROM `categories`&quot;); //copy content categories table
			dbQuery(&quot;INSERT INTO `settingsX` (`name`,`value`,`outline`) 
				SELECT `name`,`value`,`description` FROM `settings`&quot;); //copy content settings table
			dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;); //new table, no change
			break; //done
		}
		//test if version = 4.1
		$stH = dbQuery(&quot;SELECT `dayColor` FROM `categories` LIMIT 1&quot;,0);
		if (!$stH) { //column 'dayColor' not present - version 4.1
			$lcVUpg = '4.1';
			dbQuery(&quot;INSERT INTO `eventsX` (`ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`catID`,`userID`,`editor`,`approved`,`checked`,`notEml`,`notRecip`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status`) 
				SELECT `ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`catID`,`userID`,`editor`,`approved`,`checked`,`notify`,`notMail`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status` FROM `events`&quot;); //copy content events table
			dbQuery(&quot;INSERT INTO `usersX` (`ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status`) 
				SELECT `ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status` FROM `users`&quot;); //copy content users table
			dbQuery(&quot;INSERT INTO `groupsX` (`ID`,`name`,`privs`,`vCatIDs`,`color`,`status`) 
				SELECT `ID`,`name`,`privs`,`catIDs`,`color`,`status` FROM `groups`&quot;); //copy content groups table
			dbQuery(&quot;INSERT INTO `categoriesX` (`ID`,`name`,`sequence`,`repeat`,`approve`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status`) 
				SELECT `ID`,`name`,`sequence`,`repeat`,`approve`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status` FROM `categories`&quot;); //copy content categories table
			dbQuery(&quot;INSERT INTO `settingsX` SELECT * FROM `settings`&quot;); //copy content settings table
			dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;); //new table, no change
			break; //done
		}
		//test if version = 4.2
		$stH = dbQuery(&quot;SELECT `noverlap` FROM `categories` LIMIT 1&quot;,0);
		if (!$stH) { //column 'overlay' not present - version 4.2
			$lcVUpg = '4.2';
			dbQuery(&quot;INSERT INTO `eventsX` (`ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`catID`,`userID`,`editor`,`approved`,`checked`,`notEml`,`notRecip`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status`) 
				SELECT `ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`catID`,`userID`,`editor`,`approved`,`checked`,`notify`,`notMail`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status` FROM `events`&quot;); //copy content events table
			dbQuery(&quot;INSERT INTO `usersX` (`ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status`) 
				SELECT `ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status` FROM `users`&quot;); //copy content users table
			dbQuery(&quot;INSERT INTO `groupsX` (`ID`,`name`,`privs`,`vCatIDs`,`color`,`status`) 
				SELECT `ID`,`name`,`privs`,`catIDs`,`color`,`status` FROM `groups`&quot;); //copy content groups table
			dbQuery(&quot;INSERT INTO `categoriesX` (`ID`,`name`,`sequence`,`repeat`,`approve`,`dayColor`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status`) 
				SELECT `ID`,`name`,`sequence`,`repeat`,`approve`,`dayColor`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status` FROM `categories`&quot;); //copy content categories table
			dbQuery(&quot;INSERT INTO `settingsX` SELECT * FROM `settings`&quot;); //copy content settings table
			dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;); //new table, no change
			break; //done
		}
		//test if version = 4.3
		$stH = dbQuery(&quot;SELECT `attach` FROM `events` LIMIT 1&quot;,0);
		if (!$stH) { //column 'attach' not present - version 4.3
			$lcVUpg = '4.3';
			dbQuery(&quot;INSERT INTO `eventsX` (`ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`catID`,`userID`,`editor`,`approved`,`checked`,`notEml`,`notRecip`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status`) 
				SELECT `ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`catID`,`userID`,`editor`,`approved`,`checked`,`notify`,`notMail`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status` FROM `events`&quot;); //copy content events table
			dbQuery(&quot;INSERT INTO `usersX` (`ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status`) 
				SELECT `ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status` FROM `users`&quot;); //copy content users table
			dbQuery(&quot;INSERT INTO `groupsX` (`ID`,`name`,`privs`,`vCatIDs`,`rEvents`,`mEvents`,`pEvents`,`color`,`status`) 
				SELECT `ID`,`name`,`privs`,`catIDs`,`rEvents`,`mEvents`,`pEvents`,`color`,`status` FROM `groups`&quot;); //copy content groups table
			dbQuery(&quot;INSERT INTO `categoriesX` (`ID`,`name`,`sequence`,`repeat`,`noverlap`,`olErrMsg`,`defSlot`,`approve`,`dayColor`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status`)
				SELECT `ID`,`name`,`sequence`,`repeat`,`noverlap`,`olErrMsg`,`defSlot`,`approve`,`dayColor`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status` FROM `categories`&quot;); //copy content categories table
			dbQuery(&quot;INSERT INTO `settingsX` SELECT * FROM `settings`&quot;); //copy content settings table
			dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;); //new table, no change
			break; //done
		}
		//test if version = 4.4
		$stH = dbQuery(&quot;SELECT `vCatIDs` FROM `groups` LIMIT 1&quot;,0);
		if (!$stH) { //column 'vCatIDs' not present - version 4.4
			$lcVUpg = '4.4';
			dbQuery(&quot;INSERT INTO `eventsX` (`ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`attach`,`catID`,`userID`,`editor`,`approved`,`checked`,`notEml`,`notRecip`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status`) 
				SELECT `ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`attach`,`catID`,`userID`,`editor`,`approved`,`checked`,`notify`,`notMail`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status` FROM `events`&quot;); //copy content events table
			dbQuery(&quot;INSERT INTO `usersX` (`ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status`) 
				SELECT `ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status` FROM `users`&quot;); //copy content users table
			dbQuery(&quot;INSERT INTO `groupsX` (`ID`,`name`,`privs`,`vCatIDs`,`rEvents`,`mEvents`,`pEvents`,`upload`,`color`,`status`) 
				SELECT `ID`,`name`,`privs`,`catIDs`,`rEvents`,`mEvents`,`pEvents`,`upload`,`color`,`status` FROM `groups`&quot;); //copy content groups table
			dbQuery(&quot;INSERT INTO `categoriesX` (`ID`,`name`,`sequence`,`repeat`,`noverlap`,`olErrMsg`,`defSlot`,`approve`,`dayColor`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status`)
				SELECT `ID`,`name`,`sequence`,`repeat`,`noverlap`,`olErrMsg`,`defSlot`,`approve`,`dayColor`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`status` FROM `categories`&quot;); //copy content categories table
			dbQuery(&quot;INSERT INTO `settingsX` SELECT * FROM `settings`&quot;); //copy content settings table
			dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;); //new table, no change
			break; //done
		}
		//test if version = 4.5
		$stH = dbQuery(&quot;SELECT `notRecip` FROM `events` LIMIT 1&quot;,0);
		if (!$stH) { //column 'notRecip' not present - version 4.5
			$lcVUpg = '4.5';
			dbQuery(&quot;INSERT INTO `eventsX` (`ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`attach`,`catID`,`userID`,`editor`,`approved`,`checked`,`notEml`,`notRecip`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status`) 
				SELECT `ID`,`private`,`title`,`venue`,`text1`,`text2`,`text3`,`attach`,`catID`,`userID`,`editor`,`approved`,`checked`,`notify`,`notMail`,`sDate`,`eDate`,`xDates`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`,`status` FROM `events`&quot;); //copy content events table
			dbQuery(&quot;INSERT INTO `usersX` (`ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status`) 
				SELECT `ID`,`name`,`password`,`tPassword`,`email`,`groupID`,`language`,`login0`,`login1`,`loginCnt`,`status` FROM `users`&quot;); //copy content users table
			dbQuery(&quot;INSERT INTO `groupsX` (`ID`,`name`,`privs`,`vCatIDs`,`eCatIDs`,`rEvents`,`mEvents`,`pEvents`,`upload`,`color`,`status`) 
				SELECT `ID`,`name`,`privs`,`vcatIDs`,`ecatIDs`,`rEvents`,`mEvents`,`pEvents`,`upload`,`color`,`status` FROM `groups`&quot;); //copy content groups table
			dbQuery(&quot;INSERT INTO `categoriesX` SELECT * FROM `categories`&quot;); //no change
			dbQuery(&quot;INSERT INTO `settingsX` SELECT * FROM `settings`&quot;); //no change
			dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;); //no change
			break; //done
		}
		//version = current version (no changes)
		$lcVUpg = '4.6';
		dbQuery(&quot;INSERT INTO `eventsX` SELECT * FROM `events`&quot;);
		dbQuery(&quot;INSERT INTO `usersX` SELECT * FROM `users`&quot;);
		dbQuery(&quot;INSERT INTO `groupsX` SELECT * FROM `groups`&quot;);
		dbQuery(&quot;INSERT INTO `categoriesX` SELECT * FROM `categories`&quot;);
		dbQuery(&quot;INSERT INTO `settingsX` SELECT * FROM `settings`&quot;);
		dbQuery(&quot;INSERT INTO `stylesX` SELECT * FROM `styles`&quot;);
	} while (0); //end of: process calendar $calID

	/* === tables post-processing === */
	$stH = dbQuery(&quot;SELECT `privs` FROM `users` LIMIT 1&quot;,0);
	if ($stH !== false) { //privs found, table groups is new
		$stH = null;
		//convert users.groupID (old privs) to new groupID
		$groups = array(0 =&gt; 1, 9 =&gt; 2, 1 =&gt; 3, 2 =&gt; 4, 3 =&gt; 5, 4 =&gt; 6);
		$stH = dbQuery(&quot;SELECT `ID`,`groupID` FROM `usersX`&quot;); //get groupID (old privs)
		while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
			dbQuery(&quot;UPDATE `usersX` SET `groupID` = {$groups[$row['groupID']]} WHERE `ID` = {$row['ID']}&quot;);
		}
	}
	//groups.ID and users.groupID: renumber ID starting from 1
	$stH = dbQuery(&quot;SELECT * FROM `groupsX` WHERE `ID` = 0&quot;);
	if ($row = $stH-&gt;fetch(PDO::FETCH_NUM)) { //column 'ID' = 0 exists - renumber
		$stH = dbQuery(&quot;SELECT `ID` FROM `groupsX` ORDER BY `ID` DESC&quot;); 
		while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
			dbQuery(&quot;UPDATE `groupsX` SET `ID` = `ID` + 1 WHERE `ID` = {$row['ID']}&quot;); //must be done in reverse order
		}
		dbQuery(&quot;UPDATE `usersX` SET `groupID` = `groupID` + 1&quot;);
	}
	//correct groupIDs admin (3 -&gt; 2) and read-access (2 -&gt; 3)
	$stH = dbQuery(&quot;SELECT `ID`,`groupID` FROM `usersX` WHERE `ID` = 2 and `groupID` = 3&quot;,0); //admin in group 3
	if ($row = $stH-&gt;fetch(PDO::FETCH_NUM)) {
		dbQuery(&quot;UPDATE `groupsX` SET `ID` = 100 WHERE `ID` = 2&quot;); //park read-only
		dbQuery(&quot;UPDATE `usersX` SET `groupID` = 100 WHERE `groupID` = 2&quot;); //idem
		dbQuery(&quot;UPDATE `groupsX` SET `ID` = 2 WHERE `ID` = 3&quot;); //set admin to 2
		dbQuery(&quot;UPDATE `usersX` SET `groupID` = 2 WHERE `groupID` = 3&quot;); //idem
		dbQuery(&quot;UPDATE `groupsX` SET `ID` = 3 WHERE `ID` = 100&quot;); //set parked to 3
		dbQuery(&quot;UPDATE `usersX` SET `groupID` = 3 WHERE `groupID` = 100&quot;); //idem
	}

	//events.checked: ;dd-mm-yyyya -&gt; ;dd-mm-yyyy and drop ;dd-mm-yyyyb
	$stH = dbQuery(&quot;SELECT `ID`,`checked` FROM `eventsX` WHERE `checked` LIKE '%a%'&quot;);
	while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
		$chBoxed = preg_replace(array('~;\d\d\d\d-\d\d-\d\db~','~(;\d\d\d\d-\d\d-\d\d)a~'),array('','$1'),$row['checked']); //drop ;dd-mm-yyyyb and trim a in ;dd-mm-yyyya
		dbQuery(&quot;UPDATE `eventsX` SET `checked`='{$chBoxed}' WHERE `ID` = {$row['ID']}&quot;);
	}
	//events.sTime/eTime: truncate time to 00:00
	$stH = dbQuery(&quot;SELECT `sTime` FROM `eventsX` LIMIT 1&quot;);
	if ($row = $stH-&gt;fetch(PDO::FETCH_NUM)) { //column 'sTime' exists
		if (strlen($row[0]) &gt; 5) { //truncate times
			dbQuery(&quot;UPDATE `eventsX` SET `sTime` = substr(`sTime`,1,5),`eTime` = substr(`eTime`,1,5)&quot;);
		}
	}
	//events.aDateTime/mDateTime: truncate time to 00:00
	$stH = dbQuery(&quot;SELECT `aDateTime` FROM `eventsX` LIMIT 1&quot;);
	if ($row = $stH-&gt;fetch(PDO::FETCH_NUM)) { //column 'aDateTime' exists
		if (strlen($row[0]) &gt; 16) { //truncate time
			dbQuery(&quot;UPDATE `eventsX` SET `aDateTime` = substr(`aDateTime`,1,16),`mDateTime` = substr(`mDateTime`,1,16)&quot;);
		}
		if (strlen($row[0]) &lt; 16) { //pad to yyyy-mm-dd 00:00
			if ($dbType == 'SQLite') { //SQLite - solve MySQL incompatibilities
				dbQuery(&quot;UPDATE `eventsX` SET `aDateTime` = substr(`aDateTime`,1,10)||' 00:00',`mDateTime` = substr(`mDateTime`,1,10)||' 00:00'&quot;);
			} else {
				dbQuery(&quot;UPDATE `eventsX` SET `aDateTime` = CONCAT(substr(`aDateTime`,1,10),' 00:00'),`mDateTime` = CONCAT(substr(`mDateTime`,1,10),' 00:00')&quot;);
			}
		}
	}

	$stH = null; //release statement handle

	//drop original tables and rename new upgraded tables
	dbQuery(&quot;DROP TABLE `users`&quot;);
	dbQuery(&quot;ALTER TABLE `usersX` RENAME TO `users`&quot;);
	dbQuery(&quot;DROP TABLE `groups`&quot;);
	dbQuery(&quot;ALTER TABLE `groupsX` RENAME TO `groups`&quot;);
	dbQuery(&quot;DROP TABLE `categories`&quot;);
	dbQuery(&quot;ALTER TABLE `categoriesX` RENAME TO `categories`&quot;);
	dbQuery(&quot;DROP TABLE `events`&quot;);
	dbQuery(&quot;ALTER TABLE `eventsX` RENAME TO `events`&quot;);
	dbQuery(&quot;DROP TABLE `settings`&quot;);
	dbQuery(&quot;ALTER TABLE `settingsX` RENAME TO `settings`&quot;);
	dbQuery(&quot;DROP TABLE `styles`&quot;);
	dbQuery(&quot;ALTER TABLE `stylesX` RENAME TO `styles`&quot;);
	dbTransaction('commit');
	return $lcVUpg;
}
?&gt;</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/bookingnew/common">â Geri</a>