    <h3>/home/bparcsg/public_html/booking/pages/importCSV.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/booking/pages/importCSV.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
= CSV 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;;

$delimiter = (isset($_POST['delimiter'])) ? $_POST['delimiter'] : ',';
$birthdayID = (isset($_POST['birthdayID'])) ? $_POST['birthdayID'] : '';
$dFormat = (isset($_POST['dFormat'])) ? $_POST['dFormat'] : 'y-m-d';
$tFormat = (isset($_POST['tFormat'])) ? $_POST['tFormat'] : 'h:m';

/* sub-functions */

function processEvtFields(&amp;$sDate,&amp;$eDate,&amp;$sTime,&amp;$eTime,&amp;$title,&amp;$catID) {
	global $dFormat, $tFormat;
	
	//Get calendar category ids
	$catIDs = array();
	$stH = dbQuery(&quot;SELECT `ID` FROM `categories` WHERE `status` &gt;= 0&quot;);
 	while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
		$catIDs[] = $row['ID'];
	}
	//Processing
	$errors = 0;
	$nofDates = count($sDate);
	for ($i = 0; $i &lt; $nofDates; $i++) {
		$error = 0;
		if (($IsDate = DDtoID($sDate[$i],$dFormat)) === false) { $error++; }
		if (($IeDate = DDtoID($eDate[$i],$dFormat)) === false) { $error++; }
		if (($IsTime = DTtoIT($sTime[$i],$tFormat)) === false) { $error++; }
		if (($IeTime = DTtoIT($eTime[$i],$tFormat)) === false) { $error++; }
		if (!$error) {
			if ($eDate[$i]) {
				if ($IsDate == $IeDate) { $eDate[$i] = ''; }
				elseif ($IeDate &lt; $IsDate) {
					list($sDate[$i],$eDate[$i]) = array($eDate[$i],$sDate[$i]); //swap start and end date
				} elseif ($IeDate &gt; $IsDate and !$IsTime and !$IeTime) { //all day
					$eDate[$i] = IDtoDD(date(&quot;Y-m-d&quot;,strtotime($IeDate.' 12:00:00') - 86400),$dFormat); //-1 day
				}
			}
			if (!$sTime[$i] and $eTime[$i]) { $sTime[$i] = $eTime[$i]; }
			if ($sTime[$i] == $eTime[$i]) { $eTime[$i] = ''; }
			if ($eTime[$i]) {
				if ($IeTime &lt; $IsTime) {
					list($sTime[$i],$eTime[$i]) = array($eTime[$i],$sTime[$i]); //swap start and end time
				}
			}
		}
		$errors += $error;
		if (!$title[$i]) { $errors++; } //title empty
		if (!in_array($catID[$i], $catIDs)) { $catID[$i] = 0; } //reset non-existing category IDs
	}
return $errors;
}


/* 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;\n{$ax['xpl_import_csv']}
		&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, $delimiter, $birthdayID, $dFormat, $tFormat, $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_csv']}&lt;/legend&gt;
&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='fileName'&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_fields_sep_by']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='delimiter' value='{$delimiter}' maxlength='2' size='1'&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_birthday_cat_id']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='birthdayID' value='{$birthdayID}' size='1'&gt; ({$ax['iex_see_insert']})&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_date_format']}:&lt;/td&gt;&lt;td&gt;
&lt;input type='radio' name='dFormat' id='dmy' value='d-m-y'&quot;.($dFormat == 'd-m-y' ? &quot; checked&quot; : '').&quot;&gt;&lt;label for='dmy'&gt;{$ax['dd_mm_yyyy']}&lt;/label&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;input type='radio' name='dFormat' id='mdy' value='m-d-y'&quot;.($dFormat == 'm-d-y' ? &quot; checked&quot; : '').&quot;&gt;&lt;label for='mdy'&gt;{$ax['mm_dd_yyyy']}&lt;/label&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;input type='radio' name='dFormat' id='ymd' value='y-m-d'&quot;.($dFormat == 'y-m-d' ? &quot; checked&quot; : '').&quot;&gt;&lt;label for='ymd'&gt;{$ax['yyyy_mm_dd']}&lt;/label&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_time_format']}:&lt;/td&gt;&lt;td&gt;
&lt;input type='radio' name='tFormat' id='hma' value='h:ma'&quot;.($tFormat == 'h:ma' ? &quot; checked&quot; : '').&quot;&gt;&lt;label for='hma'&gt;{$ax['time_format_us']}&lt;/label&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;
&lt;input type='radio' name='tFormat' id='hm' value='h:m'&quot;.($tFormat == 'h:m' ? &quot; checked&quot; : '').&quot;&gt;&lt;label for='hm'&gt;{$ax['time_format_eu']}&lt;/label&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, $tFormat;
	
	$fileName = $_FILES['fileName']['tmp_name'];
	if (!$fileName) { return $ax['iex_no_file_name']; } //csv file missing
	$csvArray = file($fileName, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
	unlink($fileName); //release file
 	$lineNr = 0;
	//process events from CSV array
	foreach ($csvArray as $csvEvent) {
		$csvEvent = strip_tags(html_entity_decode($csvEvent),'&lt;a&gt;&lt;b&gt;&lt;i&gt;&lt;u&gt;&lt;s&gt;&lt;br&gt;&lt;img&gt;'); //remove unwanted html tags
		$csvFields = preg_split(&quot;%(?&lt;!\\\\){$_POST['delimiter']}%&quot;,$csvEvent,8); //split on delimiter not escaped by \
		foreach ($csvFields as $key =&gt; $dum) { $csvFields[$key] = trim($csvFields[$key],' &quot;\''); } //remove blanks &amp; quotes
		$lineNr++;
		if ((!empty($csvFields[2]) and !ctype_digit($csvFields[2])) and $lineNr = 1) { continue; } //flush header line
		if (empty($csvFields[0])) { continue; } //flush events without title
		if (empty($csvFields[3]) or count($csvFields) &lt; 4) { //fields empty or too few fields
			return &quot;{$ax['iex_csv_file_error_on_line']}: {$lineNr}&quot;;
		}
		array_push($csvFields,'','','',''); //pad to ensure 8 fields
		list($title, $venue, $cat, $sDate, $eDate, $sTime, $eTime, $desc) = $csvFields;
		$_POST['title'][] = $title;
		$_POST['venue'][] = $venue;
		$_POST['catID'][] = $cat;
		$_POST['sDate'][] = $sDate;
		$_POST['eDate'][] = $eDate;
		$_POST['sTime'][] = preg_replace('~(\d\d?:\d\d):\d\d~','$1',$sTime); //remove seconds
		$_POST['eTime'][] = preg_replace('~(\d\d?:\d\d):\d\d~','$1',$eTime); //remove seconds
		$_POST['descr'][] = $desc;
		$_POST['birthday'][] = 0;
		$_POST['ignore'][] = 0;
	}
	return ''; //no error
}

function displayEvents($errors) {
	global $ax, $delimiter, $birthdayID, $dFormat, $tFormat, $lcI;
	
	echo &quot;&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_birthday']}&lt;br&gt;&lt;br&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='delimiter' value='{$delimiter}'&gt;
&lt;input type='hidden' name='birthdayID' value='{$birthdayID}'&gt;
&lt;input type='hidden' name='dFormat' value='{$dFormat}'&gt;
&lt;input type='hidden' name='tFormat' value='{$tFormat}'&gt;\n&quot;;
	$nofEvents = count($_POST['title']);
	echo &quot;&lt;table&gt;
		&lt;tr&gt;&lt;th&gt;#&lt;/th&gt;&lt;th&gt;{$ax['iex_ignore']}&lt;/th&gt;&lt;th&gt;{$ax['iex_birthday']}&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;/tr&gt;\n&quot;;
	for ($i = 0; $i &lt; $nofEvents; $i++) {
		$tic = (!$_POST['title'][$i]) ? &quot; class='inputError'&quot; : '';
		$sdc = (DDtoID($_POST['sDate'][$i],$dFormat) === false) ? ' inputError' : '';
		$edc = (($_POST['eDate'][$i]) and (DDtoID($_POST['eDate'][$i],$dFormat) === false)) ? ' inputError' : '';
		$stc = (DTtoIT($_POST['sTime'][$i],$tFormat) === false) ? ' inputError' : '';
		$etc = (($_POST['eTime'][$i]) and (DTtoIT($_POST['eTime'][$i],$tFormat) === false)) ? ' inputError' : '';
		$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='ignore[{$i}]' value='1'&quot;.(empty($_POST['ignore'][$i]) ? '' : &quot; checked&quot;).&quot;&gt;&lt;/td&gt;
&lt;td class='floatC'&gt;&lt;input type='checkbox' name='birthday[{$i}]' value='1'&quot;.(empty($_POST['birthday'][$i]) ? '' : &quot; checked&quot;).&quot;&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{$sdc}' type='text' size='10' name='sDate[]' value='{$_POST['sDate'][$i]}'&gt;&lt;/td&gt;
&lt;td&gt;&lt;input class='floatC{$edc}' type='text' size='10' name='eDate[]' value='{$_POST['eDate'][$i]}'&gt;&lt;/td&gt;
&lt;td&gt;&lt;input class='floatC{$stc}' type='text' size='5' name='sTime[]' value='{$_POST['sTime'][$i]}'&gt;&lt;/td&gt;
&lt;td&gt;&lt;input class='floatC{$etc}' type='text' 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;/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;\n&quot;;
}

function addEvents() {
	global $usr, $ax, $birthdayID, $dFormat, $tFormat;

	$msg = '';
	$nofEvents = count($_POST['title']);
	$added = $dropped = 0;
	for ($i = 0; $i &lt; $nofEvents; $i++) {
		if (empty($_POST['ignore'][$i])) {
			$title = strip_tags($_POST['title'][$i]);
			$venue = strip_tags($_POST['venue'][$i]);
			$descr = strip_tags($_POST['descr'][$i],'&lt;a&gt;&lt;b&gt;&lt;i&gt;&lt;u&gt;&lt;s&gt;&lt;img&gt;'); //remove most html tags
			$descr = preg_replace(&quot;~ +~&quot;,&quot; &quot;, $descr); //trim spaces
			$descr = str_replace(array(&quot;\r\n&quot;,&quot;\n\r&quot;,&quot;\n&quot;,&quot;\r&quot;),&quot;&lt;br&gt;&quot;, $descr); //replace newline by &lt;br&gt;
			$descr = addUrlImgEmlTags($descr,'x--'); //add URL link tags
			$sDate = DDtoID($_POST['sDate'][$i],$dFormat);
			$eDate = ($_POST['eDate'][$i]) ? DDtoID($_POST['eDate'][$i],$dFormat) : &quot;9999-00-00&quot;;
			$sTime = DTtoIT($_POST['sTime'][$i],$tFormat);
			$eTime = ($_POST['eTime'][$i]) ? DTtoIT($_POST['eTime'][$i],$tFormat) : &quot;99:00:00&quot;;
			if (empty($sTime)) { //all day
				$sTime = '00:00';
				$eTime = '23:59';
			}
			$catID = ($_POST['catID'][$i]) ? $_POST['catID'][$i] : 1; //no cat
			$rType = $rInterval = $rPeriod = $rMonth = 0;
			if (!empty($_POST['birthday'][$i]) or $catID == $birthdayID) { //birthday
				$catID = $birthdayID;
				$rType = 1;
				$rInterval = 1;
				$rPeriod = 4;
				$eDate = &quot;9999-00-00&quot;;
			}
			// test if event present in db
			$q = &quot;SELECT `title` FROM `events` 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;
			//if not present add event to db
			if (empty($row)) { //not present
				$q = &quot;INSERT INTO `events` (`title`,`venue`,`text1`,`catID`,`userID`,`sDate`,`eDate`,`sTime`,`eTime`,`rType`,`rInterval`,`rPeriod`,`rMonth`,`aDateTime`,`mDateTime`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)&quot;;
				$stH = stPrep($q);
				stExec($stH,array($title,$venue,$descr,$catID,$usr['ID'],$sDate,$eDate,$sTime,$eTime,$rType,$rInterval,$rPeriod,$rMonth,date(&quot;Y-m-d H:i&quot;),date(&quot;Y-m-d H:i&quot;)));
				$added++;
			} else {
				$dropped++;
			}
		}
	}
	if (!$msg) $msg = &quot;{$added} {$ax['iex_events_added']}&quot;.($dropped &gt; 0 ? &quot; / {$dropped} {$ax['iex_events_dropped']}&quot; : '');
	return $msg;
}


//control logic

$msg = ''; $errors = 0; //init
if ($usr['privs'] == 9) { //admin
	if (isset($_POST['uploadFile'])) {
		$msg = processUpload();
	}
	if ((isset($_POST['uploadFile']) and !$msg) or isset($_POST['addEvents'])) {
		$errors = processEvtFields($_POST['sDate'],$_POST['eDate'],$_POST['sTime'],$_POST['eTime'],$_POST['title'],$_POST['catID']);
	}
	if (isset($_POST['addEvents']) and !$errors) {
		$msg = addEvents(); //add events to calendar
	}
	echo &quot;&lt;p class='error'&gt;{$msg}&lt;/p&gt;\n&quot;;
	echo &quot;&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({delimiter:'{$_POST['delimiter']}',birthdayID:'{$_POST['birthdayID']}',dFormat:'{$_POST['dFormat']}',tFormat:'{$_POST['tFormat']}'});\&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>