    <h3>/home/bparcsg/public_html/bookingtest/pages/exportICS.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/bookingtest/pages/exportICS.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
= iCal event file export 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;;

$fileName = (isset($_POST['fileName'])) ? $_POST['fileName'] : ''; //file name
$fileDes = (isset($_POST['fileDes'])) ? strip_tags($_POST['fileDes']) : ''; //file description
$usrName = (isset($_POST['usrName'])) ? $_POST['usrName'] : ''; //user filter
$catName = (isset($_POST['catName'])) ? $_POST['catName'] : ''; //category filter
$fromDda = (isset($_POST['fromDda'])) ? DDtoID($_POST['fromDda']) : ''; //from event due date
$fromMda = (isset($_POST['fromMda'])) ? DDtoID($_POST['fromMda']) : ''; //from event modified date
$tillDda = (isset($_POST['tillDda'])) ? DDtoID($_POST['tillDda']) : ''; //untill event due date
$tillMda = (isset($_POST['tillMda'])) ? DDtoID($_POST['tillMda']) : ''; //untill event modified date

$meta = array(); //iCal meta data
$calProps = array(&quot;PRODID&quot;,&quot;VERSION&quot;); //iCal properties and components of interest


/* sub-functions */

function catList($selCat) {
	global $ax;
	$stH = dbQuery(&quot;SELECT `name`,`color`,`bgColor` FROM `categories` WHERE `status` &gt;= 0 ORDER BY `sequence`&quot;);
	echo &quot;&lt;option value='*'&gt;{$ax['iex_all_cats']}&amp;nbsp;&lt;/option&gt;\n&quot;;
	while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
		$selected = ($selCat == $row['name']) ? ' selected' : '';
		$catColor = ($row['color'] ? &quot;color:{$row['color']};&quot; : '').($row['bgColor'] ? &quot;background-color:{$row['bgColor']};&quot; : '');
		echo &quot;&lt;option value=\&quot;{$row['name']}\&quot;&quot;.($catColor ? &quot; style='{$catColor}'&quot; : '').&quot;{$selected}&gt;{$row['name']}&lt;/option&gt;\n&quot;;
	}
}

function userMenu($selUser) {
	global $ax;
	$stH = dbQuery(&quot;SELECT `name` FROM `users` ORDER BY `name`&quot;);
	echo &quot;&lt;option value='*'&gt;{$ax['iex_all_users']}&amp;nbsp;&lt;/option&gt;\n&quot;;
	while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
		$selected = ($selUser == $row['name']) ? ' selected' : '';
		echo &quot;&lt;option value=\&quot;{$row['name']}\&quot;{$selected}&gt;{$row['name']}&lt;/option&gt;\n&quot;;
	}
}


/* main functions */

function selectEvents() {
	global $ax, $set, $msg, $fileName, $fileDes, $usrName, $catName, $fromDda, $fromMda, $tillDda, $tillMda, $lcI;
	
	if (!$fileName) {
		$fileName = substr(translit($set['calendarTitle'],true),0,60);
	}
	echo &quot;&lt;form action='index.php' method='post'&gt;
&lt;input type='hidden' name='lcI' value='{$lcI}'&gt;
&lt;fieldset&gt;&lt;legend&gt;{$ax['iex_create_ics']}&lt;/legend&gt;
&lt;table class='list'&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_file_name']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='fileName' maxlength='60' value=\&quot;{$fileName}\&quot; size='26'&gt; .ics&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_file_description']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='fileDes' value=\&quot;{$fileDes}\&quot; maxlength='50' size='30'&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan='2'&gt;&lt;hr&gt;\n&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan='2'&gt;{$ax['iex_filters']}&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_owner']}:&lt;/td&gt;&lt;td&gt;&lt;select name='usrName' &gt;\n&quot;;
	userMenu($usrName);
	echo &quot;&lt;/select&gt;&lt;/td&gt;&lt;/tr&gt;\n&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_category']}:&lt;/td&gt;&lt;td&gt;&lt;select name='catName' &gt;\n&quot;;
	catList($catName);
	echo &quot;&lt;/select&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_between_dates']}:&lt;/td&gt;&lt;td&gt;
&lt;input type='text' name='fromDda' id='fromDda' value='&quot;.IDtoDD($fromDda).&quot;' size='10'&gt;
&lt;span class='dtPick' title=\&quot;{$ax['iex_select_start_date']}\&quot; onclick=\&quot;dPicker(1,'nill','fromDda');return false;\&quot;&gt;&amp;#x1F4C5;&lt;/span&gt; &amp;#8211;
&lt;input type='text' name='tillDda' id='tillDda' value='&quot;.IDtoDD($tillDda).&quot;' size='10'&gt;
&lt;span class='dtPick' title=\&quot;{$ax['iex_select_end_date']}\&quot; onclick=\&quot;dPicker(1,'nill','tillDda');return false;\&quot;&gt;&amp;#x1F4C5;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='label'&gt;{$ax['iex_changed_between']}:&lt;/td&gt;&lt;td&gt;
&lt;input type='text' name='fromMda' id='fromMda' value='&quot;.IDtoDD($fromMda).&quot;' size='10'&gt;
&lt;span class='dtPick' title=\&quot;{$ax['iex_select_start_date']}\&quot; onclick=\&quot;dPicker(1,'nill','fromMda');return false;\&quot;&gt;&amp;#x1F4C5;&lt;/span&gt; &amp;#8211;
&lt;input type='text' name='tillMda' id='tillMda' value='&quot;.IDtoDD($tillMda).&quot;' size='10'&gt;
&lt;span class='dtPick' title=\&quot;{$ax['iex_select_end_date']}\&quot; onclick=\&quot;dPicker(1,'nill','tillMda');return false;\&quot;&gt;&amp;#x1F4C5;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;
&lt;/fieldset&gt;
&lt;button class='noPrint' type='submit' name='create' value='y'&gt;{$ax['iex_create_file']}&lt;/button&gt;\n&quot;;
	if (isset($_POST['create']) and $msg == $ax['iex_file_created']) {
		$icalfName = $fileName ? $fileName : $set['calendarTitle'];
		$icalfName = substr(translit($icalfName,true).'.ics',0,60);
		$rName = str_replace('.','-'.date(&quot;Ymd-Hi&quot;).'.',$icalfName);
		echo &quot;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;button class='noPrint' type='button' onclick=\&quot;location.href='dloader.php?ftd={$icalfName}&amp;amp;rName={$rName}'\&quot;&gt;{$ax['iex_download_file']}&lt;/button&gt;\n&quot;;
	}
	echo &quot;&lt;/form&gt;\n&lt;div style='clear:right'&gt;&lt;/div&gt;\n&quot;;
}

function makeFile() {
	global $ax, $evtList, $set, $fileName, $fileDes, $usrName, $catName, $fromDda, $fromMda, $tillDda, $tillMda;

	$icsHead = &quot;BEGIN:VCALENDAR\r\n&quot;;
	$icsHead .= &quot;VERSION:2.0\r\n&quot;;
	$icsHead .= &quot;METHOD:PUBLISH\r\n&quot;;
	$icsHead .= &quot;PRODID:- // LuxCal &quot;.LCV.&quot; // {$set['calendarTitle']} // EN\r\n&quot;;
	$icsHead .= &quot;X-LC-CONTENT:user: &quot;.(($usrName != '*') ? $usrName : &quot;all&quot;);
	$icsHead .= &quot; // cat: &quot;.(($catName != '*') ? $catName : &quot;all&quot;);
	$icsHead .= &quot; // due: &quot;.(($fromDda) ? $fromDda : &quot;begin&quot;).&quot; - &quot;.(($tillDda) ? $tillDda : &quot;end&quot;);
	$icsHead .= &quot; // mod: &quot;.(($fromMda) ? $fromMda : &quot;begin&quot;).&quot; - &quot;.(($tillMda) ? $tillMda : &quot;end&quot;).&quot;\r\n&quot;;
	$icsHead .= &quot;X-WR-CALNAME:&quot;.(($fileDes) ? htmlspecialchars_decode($fileDes,ENT_QUOTES) : &quot;Events&quot;).&quot;\r\n&quot;;
	$icsHead .= &quot;X-WR-TIMEZONE:&quot;.date_default_timezone_get().&quot;\r\n&quot;;
	$icsHead .= &quot;CALSCALE:GREGORIAN\r\n&quot;;

	//set event filter
	$filter = ($usrName != '*') ? &quot; AND u.`name` = '$usrName'&quot; : '';
	if ($catName != '*') { $filter .= &quot; AND c.`name` = '$catName'&quot;; }
	if ($fromMda) { $filter .= &quot; AND SUBSTR(e.`mDateTime`,1,10) &gt;= '$fromMda'&quot;; }
	if ($tillMda) { $filter .= &quot; AND SUBSTR(e.`mDateTime`,1,10) &lt;= '$tillMda'&quot;; }

	//set event date range
	$sRange = ($fromDda) ? $fromDda : date('Y-m-d',time()-31536000); //-1 year
	$eRange = ($tillDda) ? $tillDda : date('Y-m-d',time()+31536000); //+1 year

	retrieve($sRange,$eRange,'',substr($filter,5)); //grab events
	
	if (count($evtList) == 0) { return $ax['iex_no_events_found']; }

	$icsBody = '';
	$from = array(',',';','&lt;br&gt;');
	$to = array('\,','\;','\n');
	$eidDone = array(); //events processed
	foreach ($evtList as $evtListDate) {
		foreach ($evtListDate as $evt) {
			if (!in_array($evt['eid'], $eidDone)) { //event not yet processed
				$vDescription = str_replace($from,$to,htmlspecialchars_decode(makeE($evt,$set['evtTemplGen'],'br','\n','345'),ENT_QUOTES));
				$vDescription = chunk_split_unicode($vDescription,72,&quot;\r\n &quot;); //fold to 72 chars line length
				//compile DTSTART and DTEND values
				$dateS = str_replace('-','',$evt['sda']);
				$dateE = ($evt['eda'][0] != '9') ? str_replace('-','',$evt['eda']) : $dateS;
				$timeS = str_replace(':','',$evt['sti']);
				$timeE = str_replace(':','',$evt['eti']);
				if ($evt['ald']) { //all day
					$timeS = '0000';
					$dateE = date('Ymd',strtotime($dateE.'12:00:00') + 86400); //+1 day
				} else {
					$dateS .= 'T'.$timeS.'00';
					$dateE .= 'T'.(!empty($timeE) ? $timeE.'00' : $timeS.'01');
				}

				//compile RRULE property
				$rrule = '';
				if ($evt['r_t'] == 1) { //every 1|2|3|4 d|w|m|y
					$rrule .= &quot;FREQ=&quot;;
					switch ($evt['r_p']) {
						case 1: $rrule .= 'DAILY'; break;
						case 2: $rrule .= 'WEEKLY'; break;
						case 3: $rrule .= 'MONTHLY'; break;
						case 4: $rrule .= 'YEARLY';
					}
					$rrule .= &quot;;INTERVAL=&quot;.$evt['r_i'];
				}
				if ($evt['r_t'] == 2) { //every 1|2|3|4|5 m|t|w|t|f|s|s of the month
					$rrule .= $evt['r_m'] ? &quot;FREQ=YEARLY&quot; : &quot;FREQ=MONTHLY&quot;;
					$rrule .= &quot;;BYDAY=&quot;.(($evt['r_i'] != 5) ? $evt['r_i'] : '-1');
					switch ($evt['r_p']) {
						case 1: $rrule .= 'MO'; break;
						case 2: $rrule .= 'TU'; break;
						case 3: $rrule .= 'WE'; break;
						case 4: $rrule .= 'TH'; break;
						case 5: $rrule .= 'FR'; break;
						case 6: $rrule .= 'SA'; break;
						case 7: $rrule .= 'SU';
					}
					if ($evt['r_m']) {
						$rrule .= &quot;;BYMONTH=&quot;.$evt['r_m'];
					}
				}
				if ($evt['r_u'][0] != '9') {
					$rrule .= &quot;;UNTIL=&quot;.str_replace('-','',$evt['r_u']).'T235900';
				}
				$tStamp = mktime(substr($timeS,0,2),substr($timeS,2,2),0,substr($dateS,4,2),substr($dateS,6,2),substr($dateS,0,4));
				$icsBody .= &quot;BEGIN:VEVENT\r\n&quot;;
				$icsBody .= &quot;DTSTAMP:&quot;.gmdate('Ymd\THis\Z').&quot;\r\n&quot;;
				if ($evt['adt']) {
					$icsBody .= &quot;CREATED:&quot;.gmdate('Ymd\THis\Z',strtotime($evt['adt'])).&quot;\r\n&quot;;
				}
				if ($evt['mdt']) {
					$icsBody .= &quot;LAST-MODIFIED:&quot;.gmdate('Ymd\THis\Z',strtotime($evt['mdt']) + 86400).&quot;\r\n&quot;;
				}
				$calUrlShort = preg_match('~.+://([^?/]+)~',$set['calendarUrl'],$matches); //strip http(s)://
				$icsBody .= &quot;UID:&quot;.gmdate(&quot;Ymd\THis\Z&quot;, $tStamp).trim(substr(iconv('UTF-8','ASCII//TRANSLIT//IGNORE',$evt['tit']),0,4)).&quot;-LuxCal@{$matches[1]}\r\n&quot;;
				$icsBody .= &quot;SUMMARY:&quot;.str_replace(&quot;,&quot;,&quot;\,&quot;,htmlspecialchars_decode($evt['tit'],ENT_QUOTES)).&quot;\r\n&quot;;
				if ($vDescription) { $icsBody .= &quot;DESCRIPTION:{$vDescription}\r\n&quot;; }
				$icsBody .= &quot;CATEGORIES:&quot;.str_replace(&quot;,&quot;,&quot;\,&quot;,$evt['cnm']).&quot;\r\n&quot;;
				if ($evt['pri']) { $icsBody .= &quot;CLASS:PRIVATE\r\n&quot;; }
				if ($evt['ven']) { $icsBody .= &quot;LOCATION:&quot;.str_replace(&quot;,&quot;,&quot;\,&quot;,htmlspecialchars_decode($evt['ven'],ENT_QUOTES)).&quot;\r\n&quot;; }
				if ($rrule) { $icsBody .= &quot;RRULE:{$rrule}\r\n&quot;; }
				$icsBody .= &quot;DTSTART;&quot;.($evt['ald'] ? &quot;VALUE=DATE&quot; : &quot;TZID=&quot;.date_default_timezone_get()).&quot;:{$dateS}\r\n&quot;;
				$icsBody .= &quot;DTEND;&quot;.($evt['ald'] ? &quot;VALUE=DATE&quot; : &quot;TZID=&quot;.date_default_timezone_get()).&quot;:{$dateE}\r\n&quot;; //+1 ?
				$icsBody .= &quot;END:VEVENT\r\n&quot;;
				$eidDone[] = $evt['eid']; //mark as processed
			}
		}
	}
	$icsTail = &quot;END:VCALENDAR&quot;;
	//save to iCal file
	$icalfName = $fileName ? $fileName : $set['calendarTitle'];
	$icalfName = translit($icalfName,true);
	if (file_put_contents(&quot;./files/{$icalfName}.ics&quot;, $icsHead.$icsBody.$icsTail, LOCK_EX) !== false) {
		$result = $ax['iex_file_created'];
	} else {
		$result = $ax['iex_write error'];
	}
	return $result;
}

//control logic
$msg = ''; //init
if ($usr['privs'] == 9) { //admin
	if (isset($_POST['create'])) {
		$msg = makeFile();
	}
	echo &quot;&lt;p class='error'&gt;{$msg}&lt;/p&gt;
&lt;div class='scrollBoxAd'&gt;
&lt;aside class='aside'&gt;{$ax['xpl_export_ical']}&lt;/aside&gt;
&lt;div class='centerBox'&gt;\n&quot;;
	selectEvents();
	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/bookingtest/pages">← Geri</a>