    <h3>/home/bparcsg/public_html/booking/pages/importICS.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/booking/pages/importICS.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
= iCal event file import script =

This file is part of the LuxCal Web Calendar.
Copyright (C) 2009-2018 LuxSoft - www.LuxSoft.eu
License http://www.gnu.org/licenses/gpl.html GPL version 3

The LuxCal Web Calendar is distributed WITHOUT ANY WARRANTY.
*/

//sanity check
if (empty($lcV)) { exit('not permitted ('.substr(basename(__FILE__),0,-4).')'); } //launch via script only

//initialize
$adminLang = (file_exists(&quot;./lang/ai-{$opt['cL']}.php&quot;)) ? $opt['cL'] : &quot;english&quot;;
require &quot;./lang/ai-{$adminLang}.php&quot;;

$defcatID = isset($_POST['defcatID']) ? $_POST['defcatID'] : 1;
$tzAdjust = !empty($_POST['tzAdjust']) ? 1 : 0;
$fromD = isset($_POST['fromD']) ? $_POST['fromD'] : IDtoDD(date(&quot;Y-m-d&quot;));
$fromID = DDtoID($fromD); //convert to ISO date
$tZone = $set['timeZone']; //set default time zone

$curLine = 0; //current iCal file line #

/* sub-functions */

function parseEvent(&amp;$icsLines) { //parse iCal file
global $curLine, $tzAdjust, $tZone, $set;

	//initialize
	$event = array(
		&quot;dtS&quot; =&gt; &quot;&quot;, //date/time stamp
		&quot;uid&quot; =&gt; &quot;&quot;, //unique id
		&quot;tit&quot; =&gt; &quot;&quot;, //title
		&quot;des&quot; =&gt; &quot;&quot;, //description
		&quot;cat&quot; =&gt; &quot;&quot;, //category
		&quot;ven&quot; =&gt; &quot;&quot;, //venue
		&quot;pri&quot; =&gt; 0, //private
		&quot;sda&quot; =&gt; &quot;&quot;, //start date
		&quot;eda&quot; =&gt; &quot;&quot;, //end date
		&quot;sti&quot; =&gt; &quot;&quot;, //start time
		&quot;eti&quot; =&gt; &quot;&quot;, //end time
		&quot;r_t&quot; =&gt; 0, //repeat type
		&quot;r_i&quot; =&gt; 0, //repeat interval
		&quot;r_p&quot; =&gt; 0, //repeat period
		&quot;r_m&quot; =&gt; 0, //repeat month
		&quot;r_u&quot; =&gt; &quot;&quot;, //repeat until
		&quot;tmz&quot; =&gt; &quot;&quot; //timezone
	);
	$hits = array();
	$rrule = $valarm = false;
	
	//iterate icsLines for one event
	while (list($k, $v) = explode(':', str_replace('\;','~',$icsLines[$curLine++]), 2)) { //1st colon only
		$key = explode(';',$k);
		$value = explode(';',$v);
		foreach ($key as &amp;$val) { $val = trim($val); }
		foreach ($value as &amp;$val) { $val = trim($val); }
		unset($val); //break reference
		if ($key[0] == &quot;END&quot; and $value[0] == &quot;VEVENT&quot;) { break; } //event end
		if ($key[0] == &quot;BEGIN&quot; and $value[0] == &quot;VALARM&quot;) { $valarm = true; break; } //alarm begin
		if ($key[0] == &quot;END&quot; and $value[0] == &quot;VALARM&quot;) { $valarm = false; break; } //alarm end
		if ($valarm) { break; } //skipping through alarm component
 		switch (strtoupper($key[0])) {
		case &quot;DTSTAMP&quot;:
			$event['dtS'] = $value[0];
			break;
		case &quot;UID&quot;:
			$event['uid'] = $value[0];
			break;
		case &quot;CLASS&quot;:
			if ($value[0] != &quot;PUBLIC&quot;) {
				$event['pri'] = 1;
			}
			break;
		case &quot;SUMMARY&quot;:
			$event['tit'] = $value[0];
			break;
		case &quot;DESCRIPTION&quot;:
			$event['des'] .= trim(stripslashes(str_ireplace(array('\n','~'),array(&quot;\n&quot;,';'),$value[0]))); //double quotes important!
			break;
		case &quot;URL&quot;:
			$event['des'] .= &quot;\n&lt;a class='urlembed' href='{$value[0]}' target='_blank'&gt;url&lt;/a&gt;\n&quot;;
			break;
		case &quot;LOCATION&quot;:
			$event['ven'] = $value[0];
			break;
		case &quot;CATEGORIES&quot;:
			$event['cat'] = $value[0];
			break;
		case &quot;RRULE&quot;:
			$rrule = true;
			$r_i1 = $r_i2 = $r_p1 = $r_p2 = $r_count = $r_m = 0; $rUntil = ''; //init
			foreach ($value as &amp;$val) { //process each individual value
				if (preg_match(&quot;%^FREQ=(DAILY|WEEKLY|MONTHLY|YEARLY)$%i&quot;, $val, $hits)) {
					$r_i1 = 1;
					switch (strtoupper($hits[1])) {
						case 'DAILY': $r_p1 = 1; break;
						case 'WEEKLY': $r_p1 = 2; break;
						case 'MONTHLY': $r_p1 = 3; break;
						case 'YEARLY': $r_p1 = 4;
					}
				} elseif (preg_match(&quot;%^INTERVAL=([1-6])$%i&quot; , $val, $hits)) {
					$r_i1 = $hits[1];
				} elseif (preg_match(&quot;%^BYMONTH=(\d|1[0-2])$%i&quot; , $val, $hits)) { //only works if only 1 month
					$r_m = $hits[1];
				} elseif (preg_match(&quot;%^BYDAY=([1-4]?|(?:-1)?)(MO|TU|WE|TH|FR|SA|SU)$%i&quot;, $val, $hits)) {
					$r_i2 = ($hits[1]) ? (($hits[1] != '-1') ? $hits[1] : '5') : '1'; //-1 =&gt; 5 (last x-day)
					switch (strtoupper($hits[2])) {
						case 'MO': $r_p2 = 1; break;
						case 'TU': $r_p2 = 2; break;
						case 'WE': $r_p2 = 3; break;
						case 'TH': $r_p2 = 4; break;
						case 'FR': $r_p2 = 5; break;
						case 'SA': $r_p2 = 6; break;
						case 'SU': $r_p2 = 7;
					}
				} elseif (preg_match(&quot;%^COUNT=([1-9][0-9]?)$%i&quot;, $val, $hits)) {
					$r_count = $hits[1];
				} elseif (preg_match(&quot;%^UNTIL=(\d{8})(T.*)*$%i&quot; , $val, $hits)) {
					$rUntil = substr($hits[1],0,4).&quot;-&quot;.substr($hits[1],4,2).&quot;-&quot;.substr($hits[1],6,2);
				}
			}
			break;
		case &quot;DTSTART&quot;:
			if (preg_match(&quot;%^(\d{8})(T\d{4})?%i&quot;,$value[0],$hits)) {
				$event['sda'] = substr($hits[1],0,4).&quot;-&quot;.substr($hits[1],4,2).&quot;-&quot;.substr($hits[1],6,2);
				if (isset($hits[2])) {
					$event['sti'] = substr($hits[2],1,2).&quot;:&quot;.substr($hits[2],3,2);
				}
				if (substr($value[0],-1) == 'Z') {
					$event['tmz'] = 'UTC'; //UTC time
				} elseif (!empty($key[1]) and strtoupper(substr($key[1],0,5)) == 'TZID=') {
					$event['tmz'] = substr($key[1],5);
				}
			}
			break;
		case &quot;DTEND&quot;:
			if (preg_match(&quot;%^(\d{8})(T\d{4})?%i&quot;,$value[0],$hits)) {
				$event['eda'] = substr($hits[1],0,4).&quot;-&quot;.substr($hits[1],4,2).&quot;-&quot;.substr($hits[1],6,2);
				if (isset($hits[2])) {
					$event['eti'] = substr($hits[2],1,2).&quot;:&quot;.substr($hits[2],3,2);
				}
			}
			break;
		case &quot;DURATION&quot;:
			if (!isset($event['eda']) and !isset($event['eti'])) {
				if (preg_match(&quot;%^\+?P(?:(\d{1,2})W)?(?:(\d{1,2})D)?T(?:(\d{1,2})H)?(?:(\d{1,2})M)?%i&quot;, $value[0], $hits)) {
					$durSeconds = 604800*$hits[1] + 86400*$hits[2] + 3600*$hits[3] + 60*$hits[1];
					$eUnixTS = strtotime($event['sda'].' '.$event['sti'].':00') + $durSeconds;
					$event['eda'] = date('Y-m-d',$eUnixTS);
					$event['eti'] = date('H:i',$eUnixTS);
				}
			}
			break;
		}
	}
	if (!$event['tmz']) { $event['tmz'] = $tZone; } //event timezone
	$validTZ = in_array($event['tmz'], timezone_identifiers_list()); //check if valid timezone
	if ($tzAdjust and $validTZ and $event['tmz'] != $set['timeZone']) { //adjust to timezone differences
		$curTZone = new DateTimeZone($set['timeZone']);
		$evtTZone = new DateTimeZone($event['tmz']);
		$dtNow = new DateTime(&quot;now&quot;);
		$tzOffset = $curTZone-&gt;getOffset($dtNow) - $evtTZone-&gt;getOffset($dtNow); //offset
		$eUnixTS = strtotime($event['sda'].' '.$event['sti'].':00') + $tzOffset;
		$event['sda'] = date('Y-m-d',$eUnixTS);
		$event['sti'] = date('H:i',$eUnixTS);
		if ($event['eti']) {
			$eDate = $event['eda'] ? $event['eda'] : $event['sda'];
			$eUnixTS = strotime($eDate.' '.$event['eti'].':00') + $tzOffset;
			$event['eda'] = date('Y-m-d',$eUnixTS);
			$event['eti'] = date('H:i',$eUnixTS);
		}
	}
	/* validate event */
	if (!$event['tit'] or !$event['sda']) { return false; } //error
	$event['des'] = trim($event['des']); //strip off newlines
	/* post processing */
	//end date
	if ($event['eda'] &gt; $event['sda'] and !$event['eti']) {
		$event['eda'] = date('Y-m-d',strtotime($event['eda']) - 86400); //-1 day
	}
	if ($event['eda'] == $event['sda']) { $event['eda'] = ''; };
	//recurring events
	if ($rrule) {
		if (($r_p1 == 3 and $r_p2 &gt; 0) or ($r_p1 == 4 and $r_p2 &gt; 0 and $r_m &gt; 0)) { //every xth (r_i) (0-5) &lt;dayname&gt; (r_p) of the month y (r_m)
			$event['r_t'] = 2;
			$event['r_i'] = $r_i2;
			$event['r_p'] = $r_p2;
			$event['r_m'] = $r_m;
			if ($rUntil) {
				$event['r_u'] = $rUntil;
			} elseif ($r_count) {
				$r_count--;
				$event['r_u'] = date('Y-m-d', mktime (0,0,0,substr($event['sda'],5,2) + $r_count,substr($event['sda'],8,2),substr($event['sda'],0,4)));
			}
		} elseif ($r_i2 == 0 and $r_p1 &gt; 0) {
			$event['r_t'] = 1; //every xth (0-6) day|week|month|year
			$event['r_i'] = $r_i1;
			$event['r_p'] = $r_p1;
			if ($rUntil) {
				$event['r_u'] = $rUntil;
			} elseif ($r_count) {
				$r_count--;
				$r_offd = $r_offm = $r_offy = 0;
				switch ($r_p1) {
					case 1: $r_offd = $r_i1 * $r_count; break; //daily
					case 2: $r_offd = $r_i1 * 7 * $r_count; break; //weekly
					case 3: $r_offm = $r_i1 * $r_count; break; //monthly
					case 4: $r_offy = $r_i1 * $r_count; //yearly
				}
				$event['r_u'] = date('Y-m-d',mktime(12,0,0,substr($event['sda'],5,2) + $r_offm,substr($event['sda'],8,2) + $r_offd,substr($event['sda'],0,4) + $r_offy));
			}
		} else {
			$event['r_t'] = -1; //RRULE incompatible
		}
	}
	return $event;
}

function processEvtFields(&amp;$sDate,&amp;$eDate,&amp;$sTime,&amp;$eTime,&amp;$title) { //validate event fields
	$errors = 0;
	$nofDates = count($sDate);
	for ($i = 0; $i &lt; $nofDates; $i++) {
		$error = 0;
		if (($IsDate = DDtoID($sDate[$i])) === false) { $error++; } //convert Display Date to ISO Date
		if (($IeDate = DDtoID($eDate[$i])) === false) { $error++; }
		if (($IsTime = DTtoIT($sTime[$i])) === false) { $error++; }
		if (($IeTime = DTtoIT($eTime[$i])) === false) { $error++; }
		if (!$error) {
			if ($IsDate == $IeDate) { $IeDate = ''; }
			if ($IeDate and (!$IsDate or $IeDate &lt; $IsDate)) { list($IsDate,$IeDate) = array($IeDate,$IsDate); } //swap start and end date
			if ($IeDate and !$IsTime and !$IeTime) {
				$IeDate = date(&quot;Y-m-d&quot;,strtotime($IeDate.' 12:00:00') - 86400); //-1 day
				if ($IsDate == $IeDate) { $IeDate = ''; }
			}
			if (!$IeDate and $IsTime == $IeTime) { $IeTime = &quot;&quot;; }
			if ($IeTime and !$IeDate and ($IeTime &lt; $IsTime or !$IsTime)) { list($IsTime,$IeTime) = array($IeTime,$IsTime); } //swap start and end time
			$sDate[$i] = IDtoDD($IsDate); //convert ISO Date to Display Date
			$eDate[$i] = IDtoDD($IeDate);
			$sTime[$i] = ITtoDT($IsTime); //convert ISO Time to Display Time
			$eTime[$i] = ITtoDT($IeTime);
		}
		$errors += $error;
		if (!$title[$i]) { $errors++; } //title empty
	}
return $errors;
}

function eventInDb($title,$sDate,$eDate,$sTime,$eTime) {	//test if event present in db

	$q = 
	&quot;SELECT
		`title`
	FROM `events` e
	WHERE
		`status` &gt;= 0 AND `title` = ? AND `sDate` = ? AND `eDate` = ? AND `sTime` = ? AND `eTime` = ?
	&quot;;
	$stH = stPrep($q);
	stExec($stH,array($title,$sDate,$eDate,$sTime,$eTime));
	$row = $stH-&gt;fetch(PDO::FETCH_ASSOC);
	$stH = null;
	return (!empty($row) ? true : false);
}

/* main functions */

function instructions() {
	global $ax;
	
	$stH = dbQuery(&quot;SELECT `ID`,`name` FROM `categories` WHERE `status` &gt;= 0 ORDER BY `ID`&quot;);
	echo &quot;&lt;aside class='aside'&gt;{$ax['xpl_import_ical']}
&lt;table class='list'&gt;
&lt;tr&gt;&lt;th style='width:auto;'&gt;ID&lt;/th&gt;&lt;th style='width:auto;'&gt;{$ax['iex_category']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
	while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
		echo &quot;&lt;tr&gt;&lt;td class='floatC'&gt;{$row['ID']}&lt;/td&gt;&lt;td&gt;&amp;nbsp;{$row['name']}&lt;/td&gt;&lt;/tr&gt;\n&quot;;
	}
	echo &quot;&lt;/table&gt;\n&lt;/aside&gt;\n&quot;;
}

function uploadFile() {
global $ax, $defcatID, $tzAdjust, $fromD, $lcI;

echo &quot;&lt;form action='index.php' method='post' enctype='multipart/form-data'&gt;
&lt;input type='hidden' name='lcI' value='{$lcI}'&gt;
&lt;input type='hidden' name='MAX_FILE_SIZE' value='1000000'&gt;
&lt;fieldset&gt;&lt;legend&gt;{$ax['iex_upload_ics']}&lt;/legend&gt;\n
&lt;table class='list'&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_file']}:&lt;/td&gt;&lt;td&gt;&lt;input type='file' name='fName'&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_default_cat_id']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='defcatID' value='{$defcatID}' size='1'&gt; ({$ax['iex_if_no_cat']})&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_tz_adjust']}:&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' name='tzAdjust' value='1'&quot;.($tzAdjust == 1 ? &quot; checked&quot; : '').&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_import_events_from_date']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='fromD' id='fromD' value='{$fromD}' size='8'&gt;
&lt;span class='dtPick' title=\&quot;{$ax['iex_select_date']}\&quot; onclick=\&quot;dPicker(0,'nill','fromD');return false;\&quot;&gt;&amp;#x1F4C5;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;
&lt;/fieldset&gt;
&lt;button type='submit' name='uploadFile' value='y'&gt;{$ax['iex_upload_file']}&lt;/button&gt;
&lt;/form&gt;
&lt;div style='clear:right'&gt;&lt;/div&gt;\n&quot;;
}

function processUpload() {
	global $ax, $curLine, $defcatID, $tZone, $fromID;
	
	$calProps = array(&quot;PRODID&quot;,&quot;VERSION&quot;,&quot;TZID&quot;,&quot;X-WR-CALNAME&quot;,&quot;X-LC-CONTENT&quot;); //iCal properties and components of interest
	
	$fName = $_FILES['fName']['tmp_name'];
	if (!$fName) { return $ax['iex_no_file_name']; } //ical file missing
	$fContent = file_get_contents($fName); //read file
	unlink($fName);
	$begin = strpos($fContent,'BEGIN:VCALENDAR');
	if ($begin === false) { return $ax['iex_no_begin_tag']; }	//sanity check
	$fContent = preg_replace(&quot;#\r?\n[\s\t]#m&quot;,&quot;&quot;,trim(substr($fContent,$begin+15))); //skip BEGIN and unfold lines
	$icsLines = preg_split(&quot;#\r?\n#&quot;, $fContent); //split into lines
	unset($fContent);

	//Get calendar categories
	$cats = array();
	$stH = dbQuery(&quot;SELECT `ID`,`name` FROM `categories` WHERE `status` &gt;= 0 ORDER BY `ID`&quot;);
 	while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
		$cats[$row['name']] = $row['ID'];
	}

	//Iterate icsLines
	$curLine = 1;
	while (isset($icsLines[$curLine])) {
		list($key, $value) = explode(':', $icsLines[$curLine++], 2);
		$key = strtoupper(trim($key));
		$value = trim($value);
		if ($key == &quot;BEGIN&quot; and strtoupper($value) == &quot;VEVENT&quot;) { //event start
			$event = parseEvent($icsLines);
			if ($event === false) { return $ax['iex_ics_file_error_on_line'].&quot;: &quot;.$curLine; } //ics file error
			//save event data
			if (($event['r_t'] == 0 and ($event['sda'] &gt;= $fromID or $event['eda'] &gt;= $fromID)) or ($event['r_t'] != 0 and (!$event['r_u'] or $event['r_u'] &gt;= $fromID))) {
				$curCat = '';
				foreach ($cats as $catName =&gt; $catID) {
					if (strpos(strtolower($event['cat']), trim(strtolower($catName))) !== false) { $curCat = $catID; break; }
				}
				$_POST['title'][] = $event['tit'];
				$_POST['venue'][] = $event['ven'];
				$_POST['descr'][] = $event['des'];
				$_POST['catID'][] = ($curCat) ? $curCat : $defcatID;
				$_POST['sDate'][] = IDtoDD($event['sda']);
				$_POST['eDate'][] = IDtoDD($event['eda']);
				if ($event['sti'] == '00:00' and $event['eti'] == '23:59') { //all day
					$event['sti'] = $event['eti'] = '';
				}
				$_POST['sTime'][] = ITtoDT($event['sti']);
				$_POST['eTime'][] = ITtoDT($event['eti']);
				$_POST['r_t'][] = $event['r_t'];
				$_POST['r_i'][] = $event['r_i'];
				$_POST['r_p'][] = $event['r_p'];
				$_POST['r_m'][] = $event['r_m'];
				$_POST['r_u'][] = IDtoDD($event['r_u']);
				$_POST['delete'][] = 0;
			}
		} else { //meta data
			if (in_array($key, $calProps)) {
				if ($key == 'TZID') { $tZone = $value; } //set global time zone
				$_POST[$key] = $value; //save meta data
			}
		}
	}
	return ''; //no error
}

function displayEvents($errors) {
	global $ax, $defcatID, $tzAdjust, $fromD, $fromID, $lcI;
	
	$nofEvents = count($_POST['title']);
	if ($nofEvents == 0) { //no events
		echo &quot;&lt;div class='centerBox'&gt;
{$ax['iex_no_events_from_date']} &quot;.IDtoDD($fromID).&quot;&lt;br&gt;&lt;br&gt;
&lt;button class='noPrint' type='button' onclick=\&quot;index({defcatID:'{$_POST['defcatID']}',tzAdjust:'{$_POST['tzAdjust']}',fromD:'{$_POST['fromD']}'});\&quot;&gt;{$ax['back']}&lt;/button&gt;
&lt;/div&gt;\n&quot;;
		return;
	}
	$listHead = &quot;&quot;;
	echo &quot;&lt;div class='centerBox'&gt;
&lt;p class='error'&gt;{$ax['iex_number_of_errors']}: {$errors} ({$ax['iex_bgnd_highlighted']})&lt;/p&gt;&lt;br&gt;
&lt;h3&gt;{$ax['iex_verify_event_list']} \&quot;{$ax['iex_add_events']}\&quot;&lt;/h3&gt;&lt;br&gt;
{$ax['iex_select_ignore']}&lt;br&gt;&lt;br&gt;\n&quot;;
	echo &quot;&lt;button type='button' onclick=\&quot;checkA('delete');\&quot;&gt;Check all ignore boxes&lt;/button&gt;\n&quot;;
//display event list
	echo &quot;&lt;form action='index.php' method='post'&gt;
&lt;input type='hidden' name='lcI' value='{$lcI}'&gt;
&lt;input type='hidden' name='defcatID' value='{$defcatID}'&gt;
&lt;input type='hidden' name='tzAdjust' value='{$tzAdjust}'&gt;
&lt;input type='hidden' name='fromD' value='{$fromD}'&gt;\n&quot;;
	if (!empty($_POST['X-WR-CALNAME'])) {
		$listHead .= $_POST['X-WR-CALNAME'];
		echo &quot;&lt;input type='hidden' name='X-WR-CALNAME' value=\&quot;{$_POST['X-WR-CALNAME']}\&quot;&gt;\n&quot;;
	}
	if (!empty($_POST['X-LC-CONTENT'])) {
		$listHead .= &quot;&amp;nbsp;&amp;nbsp;&amp;nbsp;({$_POST['X-LC-CONTENT']})&quot;;
		echo &quot;&lt;input type='hidden' name='X-LC-CONTENT' value=\&quot;{$_POST['X-LC-CONTENT']}\&quot;&gt;\n&quot;;
	}
	echo &quot;&lt;table&gt;\n&quot;;
	if ($listHead) { echo &quot;&lt;tr&gt;&lt;td colspan='10' class='floatC'&gt;&lt;h3&gt;{$listHead}&lt;/h3&gt;&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;; }
	echo &quot;&lt;tr&gt;&lt;th&gt;#&lt;/th&gt;&lt;th&gt;{$ax['iex_ignore']}&lt;/th&gt;&lt;th&gt;{$ax['iex_title']}&lt;/th&gt;&lt;th&gt;{$ax['iex_venue']}&lt;/th&gt;&lt;th&gt;{$ax['iex_category']}&lt;/th&gt;&lt;th&gt;{$ax['iex_date']}&lt;/th&gt;&lt;th&gt;{$ax['iex_end_date']}&lt;/th&gt;&lt;th&gt;{$ax['iex_start_time']}&lt;/th&gt;&lt;th&gt;{$ax['iex_end_time']}&lt;/th&gt;&lt;th&gt;{$ax['iex_description']}&lt;/th&gt;&lt;th&gt;{$ax['iex_repeat']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
	for ($i = 0; $i &lt; $nofEvents; $i++) {
		$tic = (!$_POST['title'][$i]) ? &quot; class='inputError'&quot; : '';
		$sdc = (DDtoID($_POST['sDate'][$i]) === false) ? ' class=&quot;inputError&quot;' : '';
		$edc = (($_POST['eDate'][$i]) and (DDtoID($_POST['eDate'][$i]) === false)) ? ' class=&quot;inputError&quot;' : '';
		$stc = (DTtoIT($_POST['sTime'][$i]) === false) ? ' class=&quot;inputError&quot;' : '';
		$etc = (($_POST['eTime'][$i]) and (DTtoIT($_POST['eTime'][$i]) === false)) ? ' class=&quot;inputError&quot;' : '';
		$nr = $i+1;
		echo &quot;&lt;tr&gt;
&lt;td&gt;{$nr}&lt;/td&gt;
&lt;td class='floatC'&gt;&lt;input type='checkbox' name='delete[]' value='1'&quot;.(empty($_POST['delete'][$i]) ? &quot;&quot; : &quot; checked&quot;).&quot;&gt;
&lt;input type='hidden' name='r_t[]' value='{$_POST['r_t'][$i]}'&gt;
&lt;input type='hidden' name='r_i[]' value='{$_POST['r_i'][$i]}'&gt;
&lt;input type='hidden' name='r_p[]' value='{$_POST['r_p'][$i]}'&gt;
&lt;input type='hidden' name='r_m[]' value='{$_POST['r_m'][$i]}'&gt;
&lt;input type='hidden' name='r_u[]' value='{$_POST['r_u'][$i]}'&gt;
&lt;/td&gt;
&lt;td&gt;&lt;input type='text'{$tic} size='20' name='title[]' value=\&quot;&quot;.mbtrunc($_POST['title'][$i],100).&quot;\&quot;&gt;&lt;/td&gt;
&lt;td&gt;&lt;input type='text' size='20' name='venue[]' value=\&quot;&quot;.mbtrunc($_POST['venue'][$i],100).&quot;\&quot;&gt;&lt;/td&gt;
&lt;td&gt;&lt;input class='floatC' type='text' size='2' name='catID[]' value='{$_POST['catID'][$i]}'&gt;&lt;/td&gt;
&lt;td&gt;&lt;input class='floatC' type='text'{$sdc} size='9' name='sDate[]' value='{$_POST['sDate'][$i]}'&gt;&lt;/td&gt;
&lt;td&gt;&lt;input class='floatC' type='text'{$edc} size='9' name='eDate[]' value='{$_POST['eDate'][$i]}'&gt;&lt;/td&gt;
&lt;td&gt;&lt;input class='floatC' type='text'{$stc} size='5' name='sTime[]' value='{$_POST['sTime'][$i]}'&gt;&lt;/td&gt;
&lt;td&gt;&lt;input class='floatC' type='text'{$etc} size='5' name='eTime[]' value='{$_POST['eTime'][$i]}'&gt;&lt;/td&gt;
&lt;td&gt;&lt;textarea cols='30' rows='1' name='descr[]'&gt;{$_POST['descr'][$i]}&lt;/textarea&gt;&lt;/td&gt;
&lt;td&gt;&quot;.repeatText($_POST['r_t'][$i],$_POST['r_i'][$i],$_POST['r_p'][$i],$_POST['r_m'][$i],DDtoID($_POST['r_u'][$i])).&quot;&lt;/td&gt;\n&quot;;
//		echo '&lt;td&gt;r_t= '.$_POST['r_t'][$i].' r_i= '.$_POST['r_i'][$i].' r_p= '.$_POST['r_p'][$i].'&lt;br&gt; r_m= '.$_POST['r_m'][$i].' r_u= '.$_POST['r_u'][$i].&quot;&lt;/td&gt;\n&quot;; //for testing
		echo &quot;&lt;/tr&gt;\n&quot;;
	}
	echo &quot;&lt;/table&gt;
&lt;br&gt;
&lt;button class='noPrint' type='submit' name='addEvents' value='y'&gt;{$ax['iex_add_events']}&lt;/button&gt;
&lt;button class='noPrint' type='submit' name='back' value='y'&gt;{$ax['back']}&lt;/button&gt;
&lt;/form&gt;
&lt;/div&gt;\n&quot;;
}

function addEvents() {
	global $usr, $ax, $defcatID;

	$msg = &quot;&quot;;
	$nofEvents = count($_POST['title']);
	$added = $dropped = 0;
	for ($i = 0; $i &lt; $nofEvents; $i++) {
		if (empty($_POST['delete'][$i]) and $_POST['r_t'][$i] &gt;= 0) { //if delete not ticked and repeat-type is valid
			$title = htmlspecialchars_decode(trim($_POST['title'][$i]));
			$venue = htmlspecialchars_decode(trim($_POST['venue'][$i]));
			$descr = strip_tags(trim($_POST['descr'][$i]),'&lt;a&gt;');
			$descr = addUrlImgEmlTags($descr,'x--'); //add URL link tags
			$descr = str_ireplace(array(&quot;\r\n&quot;, &quot;\n&quot;, &quot;\r&quot;),&quot;&lt;br&gt;&quot;,$descr); //allow URLs and replace newline by &lt;br&gt;
			$sDate = DDtoID($_POST['sDate'][$i]);
			$eDate = ($_POST['eDate'][$i]) ? DDtoID($_POST['eDate'][$i]) : &quot;9999-00-00&quot;;
			$sTime = DTtoIT($_POST['sTime'][$i]);
			$eTime = ($_POST['eTime'][$i]) ? DTtoIT($_POST['eTime'][$i]) : &quot;99:00:00&quot;;
			if (empty($sTime)) { //all day
				$sTime = '00:00';
				$eTime = '23:59';
			}
			$r_t = $_POST['r_t'][$i];
			$r_i = $_POST['r_i'][$i];
			$r_p = $_POST['r_p'][$i];
			$r_m = $_POST['r_m'][$i];
			$r_u = ($_POST['r_u'][$i]) ? DDtoID($_POST['r_u'][$i]) : &quot;9999-00-00&quot;;
			$catID = ($_POST['catID'][$i]) ? $_POST['catID'][$i] : 1; //no cat
			if (!eventInDb($title,$sDate,$eDate,$sTime,$eTime)) { //add event to db
				$q = &quot;INSERT INTO `events` (`title`,`venue`,`text1`,`catID`,`userID`,`sDate`,`eDate`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`rUntil`,`aDateTime`,`mDateTime`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)&quot;;
				$stH = stPrep($q);
				stExec($stH,array($title,$venue,$descr,$catID,$usr['ID'],$sDate,$eDate,$sTime,$eTime,$r_t,$r_i,$r_p,$r_m,$r_u,date(&quot;Y-m-d H:i&quot;),date(&quot;Y-m-d H:i&quot;)));
				$added++;
			} else {
				$dropped++;
			}
		}
	}
	if (!$msg) $msg = $added.&quot; &quot;.$ax['iex_events_added'].($dropped &gt; 0 ? &quot; / {$dropped} {$ax['iex_events_dropped']}&quot; : &quot;&quot;);
	return $msg;
}


//control logic

$msg = &quot;&quot;; $errors = 0; //init
if ($usr['privs'] == 9) { //admin
	if (isset($_POST['uploadFile'])) {
		if (!$fromID) {
			$msg = $ax['iex_bad_date']; //invalid date
		} else {
			$msg = processUpload();
		}
	}
	if ((isset($_POST['uploadFile']) and !$msg) or isset($_POST['addEvents'])) {
		$errors = processEvtFields($_POST['sDate'],$_POST['eDate'],$_POST['sTime'],$_POST['eTime'],$_POST['title']);
	}
	if (isset($_POST['addEvents']) and !$errors) {
		$msg = addEvents(); //add events to calendar
	}
	echo &quot;&lt;p class='error'&gt;{$msg}&lt;/p&gt;
		&lt;div class='scrollBoxAd'&gt;\n&quot;;
	if (!isset($_POST['uploadFile']) and !isset($_POST['addEvents']) or (isset($_POST['uploadFile']) and $msg)) {
		instructions();
	}
	echo &quot;&lt;div class='centerBox'&gt;\n&quot;;
	if (!isset($_POST['uploadFile']) and !isset($_POST['addEvents']) or (isset($_POST['uploadFile']) and $msg)) {
		uploadFile();
	} elseif (!isset($_POST['addEvents']) or $errors) {
		displayEvents($errors); //file uploaded or errors, display events
	} else {
		echo &quot;&lt;button type='button' onclick=\&quot;index({defcatID:'{$_POST['defcatID']}',tzAdjust:'{$_POST['tzAdjust']}',fromD:'{$_POST['fromD']}'});\&quot;&gt;{$ax['back']}&lt;/button&gt;\n&quot;;
	}
	echo &quot;&lt;/div&gt;\n&lt;/div&gt;\n&quot;;
} else {
	echo &quot;&lt;p class='error'&gt;{$ax['no_way']}&lt;/p&gt;\n&quot;;
}
?&gt;
</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/booking/pages">← Geri</a>