    <h3>/home/bparcsg/public_html/2018backup/bparcsite/bookingnew/pages/exportICS.php dÃ¼zenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/2018backup/bparcsite/bookingnew/pages/exportICS.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
= iCal event file export script =

© Copyright 2009-2018 LuxSoft - www.LuxSoft.eu

This file is part of the LuxCal Web Calendar.

The LuxCal Web Calendar is free software: you can redistribute it and/or modify it under 
the terms of the GNU General Public License as published by the Free Software Foundation, 
either version 3 of the License, or (at your option) any later version.

The LuxCal Web Calendar is distributed in the hope that it will be useful, but WITHOUT 
ANY WARRANTY. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the LuxCal 
Web Calendar. If not, see: http://www.gnu.org/licenses/.
*/

//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;button title=\&quot;{$ax['iex_select_start_date']}\&quot; onclick=\&quot;dPicker(1,'nill','fromDda');return false;\&quot;&gt;&amp;larr;&lt;/button&gt; &amp;#8211;
&lt;input type='text' name='tillDda' id='tillDda' value='&quot;.IDtoDD($tillDda).&quot;' size='10'&gt;
&lt;button title=\&quot;{$ax['iex_select_end_date']}\&quot; onclick=\&quot;dPicker(1,'nill','tillDda');return false;\&quot;&gt;&amp;larr;&lt;/button&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;button title=\&quot;{$ax['iex_select_start_date']}\&quot; onclick=\&quot;dPicker(1,'nill','fromMda');return false;\&quot;&gt;&amp;larr;&lt;/button&gt; &amp;#8211;
&lt;input type='text' name='tillMda' id='tillMda' value='&quot;.IDtoDD($tillMda).&quot;' size='10'&gt;
&lt;button title=\&quot;{$ax['iex_select_end_date']}\&quot; onclick=\&quot;dPicker(1,'nill','tillMda');return false;\&quot;&gt;&amp;larr;&lt;/button&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',mktime (12,0,0,substr($dateE,4,2),substr($dateE,6,2)+1,substr($dateE,0,4))); //+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', mktime(substr($evt['adt'],11,2),substr($evt['adt'],14,2),0,substr($evt['adt'],5,2),substr($evt['adt'],8,2)+1,substr($evt['adt'],0,4))).&quot;\r\n&quot;;
				}
				if ($evt['mdt']) {
					$icsBody .= &quot;LAST-MODIFIED:&quot;.gmdate('Ymd\THis\Z', mktime(substr($evt['mdt'],11,2),substr($evt['mdt'],14,2),0,substr($evt['mdt'],5,2),substr($evt['mdt'],8,2)+1,substr($evt['mdt'],0,4))).&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;br&gt;&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/2018backup/bparcsite/bookingnew/pages">â† Geri</a>