    <h3>/home/bparcsg/public_html/2018backup/bparcsite/bookingtest/pages/search.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/2018backup/bparcsite/bookingtest/pages/search.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
= text search 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
$schText = (isset($_POST[&quot;schText&quot;])) ? $_POST[&quot;schText&quot;] : &quot;&quot;; //search text
$eF = isset($_POST['eF']) ? $_POST['eF'] : array(0); //field filter
if (isset($_POST['eF1'])) $eF[] = 1;
if (isset($_POST['eF2'])) $eF[] = 2;
if (isset($_POST['eF3'])) $eF[] = 3;
$grpName = (isset($_POST[&quot;grpName&quot;])) ? $_POST[&quot;grpName&quot;] : &quot;&quot;; //group filter
$catName = (isset($_POST[&quot;catName&quot;])) ? $_POST[&quot;catName&quot;] : &quot;&quot;; //category filter
$fromDda = (isset($_POST[&quot;fromDda&quot;])) ? DDtoID($_POST[&quot;fromDda&quot;]) : &quot;&quot;; //from event due date
$tillDda = (isset($_POST[&quot;tillDda&quot;])) ? DDtoID($_POST[&quot;tillDda&quot;]) : &quot;&quot;; //until event due date
if (!$set['xField1Public'] and $usr['ID'] == 1) { $set['evtTemplGen'] = str_replace('4','',$set['evtTemplGen']); } //exclude xField 1
if (!$set['xField2Public'] and $usr['ID'] == 1) { $set['evtTemplGen'] = str_replace('5','',$set['evtTemplGen']); } //exclude xField 2


/* functions */
function groupList($selGrp) {
	global $xx;
	
	$stH = dbQuery(&quot;SELECT `ID`,`name`,`color` FROM `groups` WHERE `status` &gt;= 0 ORDER BY `name`&quot;);
	echo &quot;&lt;option value='*'&gt;{$xx['sch_all_groups']}&amp;nbsp;&lt;/option&gt;\n&quot;;
	while (list($ID,$name,$color) = $stH-&gt;fetch(PDO::FETCH_NUM)) {
		$selected = ($selGrp == $name) ? ' selected' : '';
		echo &quot;&lt;option value=\&quot;{$name}\&quot;&quot;.($color ? &quot; style='background-color:{$color};'&quot; : '').&quot;{$selected}&gt;{$name}&lt;/option&gt;\n&quot;;
	}
}

function catList($selCat) {
	global $xx, $usr;
	
	$where = 'WHERE `status` &gt;= 0'.($usr['vCats'] != '0' ? &quot; AND `ID` IN ({$usr['vCats']})&quot; : '');
	$stH = dbQuery(&quot;SELECT `ID`,`name`,`color`,`bgColor` FROM `categories` {$where} ORDER BY `sequence`&quot;);
	echo &quot;&lt;option value='*'&gt;{$xx['sch_all_cats']}&amp;nbsp;&lt;/option&gt;\n&quot;;
	while (list($ID,$name,$color,$bgColor) = $stH-&gt;fetch(PDO::FETCH_NUM)) {
		$selected = ($selCat == $name) ? ' selected' : '';
		$catColor = ($color ? &quot;color:{$color};&quot; : '').($bgColor ? &quot;background-color:{$bgColor};&quot; : '');
		echo &quot;&lt;option value=\&quot;{$name}\&quot;&quot;.($catColor ? &quot; style='{$catColor}'&quot; : '').&quot;{$selected}&gt;{$name}&lt;/option&gt;\n&quot;;
	}
}

function searchForm() {
	global $xx, $set, $schText, $eF, $grpName, $catName, $fromDda, $tillDda, $lcI;
	
	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;{$xx['sch_define_search']}&lt;/legend&gt;\n
&lt;table class='list'&gt;\n
&lt;tr&gt;\n&lt;td class='label'&gt;{$xx['sch_search_text']}:&lt;/td&gt;
&lt;td&gt;&lt;input type='text' name='schText' id='schText' value=\&quot;{$schText}\&quot; maxlength='50' size='30'&gt;&lt;/td&gt;\n&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan='2'&gt;&lt;hr&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;\n&lt;td class='label'&gt;{$xx['sch_event_fields']}:&lt;/td&gt;
&lt;td&gt;&lt;input type='checkbox' id='eF0' name='eF[]' value='0' onclick=\&quot;checkZ('eF',this);\&quot;&quot;.(in_array(0, $eF) ? &quot; checked&quot; : '').&quot;&gt; 
&lt;label for='eF0'&gt;{$xx['sch_all_fields']}&lt;/label&gt;&lt;/td&gt;\n&lt;/tr&gt;
&lt;tr&gt;\n&lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' id='eF1' name='eF[]' value='1' onclick=\&quot;checkN('eF',this);\&quot;&quot;.(in_array(1, $eF) ? &quot; checked&quot; : '').&quot;&gt; 
&lt;label for='eF1'&gt;{$xx['sch_title']}&lt;/label&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
	foreach (str_split($set['evtTemplGen']) as $fieldNr) {
		if (strpos('1345',$fieldNr) !== false) {
			switch ($fieldNr) {
			case '1': 
				echo &quot;&lt;tr&gt;\n&lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' id='eF2' name='eF[]' value='2' onclick=\&quot;checkN('eF',this);\&quot;&quot;.(in_array(2, $eF) ? &quot; checked&quot; : '').&quot;&gt; &lt;label for='eF2'&gt;{$xx['sch_venue']}&lt;/label&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
				break;
			case '3':
				echo &quot;&lt;tr&gt;\n&lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' id='eF3' name='eF[]' value='3' onclick=\&quot;checkN('eF',this);\&quot;&quot;.(in_array(3, $eF) ? &quot; checked&quot; : '').&quot;&gt; &lt;label for='eF3'&gt;{$xx['sch_description']}&lt;/label&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
				break;
			case '4':
				echo &quot;&lt;tr&gt;\n&lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' id='eF4' name='eF[]' value='4' onclick=\&quot;checkN('eF',this);\&quot;&quot;.(in_array(4, $eF) ? &quot; checked&quot; : '').&quot;&gt; &lt;label for='eF4'&gt;&quot;.($set['xField1Label'] ? &quot;{$set['xField1Label']}&quot; : $xx['sch_extra_field1']).&quot;&lt;/label&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
				break;
			case '5':
				echo &quot;&lt;tr&gt;\n&lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' id='eF5' name='eF[]' value='5' onclick=\&quot;checkN('eF',this);\&quot;&quot;.(in_array(5, $eF) ? &quot; checked&quot; : '').&quot;&gt; &lt;label for='eF5'&gt;&quot;.($set['xField2Label'] ? &quot;{$set['xField2Label']}&quot; : $xx['sch_extra_field2']).&quot;&lt;/label&gt;&lt;/td&gt;\n&lt;/tr&gt;\n&quot;;
			}
		}
	}
	echo &quot;&lt;tr&gt;&lt;td class='label'&gt;{$xx['sch_user_group']}:&lt;/td&gt;&lt;td&gt;&lt;select name='grpName'&gt;\n&quot;;
	groupList($grpName);
	echo &quot;&lt;/select&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
	echo &quot;&lt;tr&gt;&lt;td class='label'&gt;{$xx['sch_event_cat']}:&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;\n&quot;;
	echo &quot;&lt;tr&gt;\n&lt;td class='label'&gt;{$xx['sch_occurring_between']}:&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;{$xx['sch_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;{$xx['sch_select_end_date']}\&quot; onclick=\&quot;dPicker(1,'nill','tillDda');return false;\&quot;&gt;&amp;#x1F4C5;&lt;/span&gt;&lt;/td&gt;\n&lt;/tr&gt;
&lt;/table&gt;\n
&lt;/fieldset&gt;
&lt;button type='submit' name='search' value='y'&gt;{$xx['sch_search']}&lt;/button&gt;\n
&lt;/form&gt;
&lt;div style='clear:right'&gt;&lt;/div&gt;\n
&lt;script&gt;document.getElementById('schText').focus();&lt;/script&gt;&quot;;
}

function validateForm() {
	global $xx, $schText, $fromDda, $tillDda;
	
	$schText = trim(str_replace('%', '', $schText),'&amp;');
	if (strlen(str_replace('_', '', $schText)) &lt; 1) { return $xx['sch_invalid_search_text']; }
	if ($fromDda === false) { return $xx['sch_bad_start_date']; }
	if ($tillDda === false) { return $xx['sch_bad_end_date']; }
	return '';
}
	
function searchText() {
	global $xx, $set, $nowTS, $schText, $eF, $grpName, $catName, $fromDda, $tillDda, $lcI;
	
	//set event filter
	$schString = str_replace('&amp;', '%', &quot;%{$schText}%&quot;);
	//prepare description filter
	$filter = '';
	if ($grpName != '*') { $filter .= &quot; AND g.`name` = '{$grpName}'&quot;; }
	if ($catName != '*') { $filter .= &quot; AND c.`name` = '{$catName}'&quot;; }
	$filter .= &quot; AND (&quot;;
	if (in_array(0, $eF) or in_array(1, $eF)) { $filter .= &quot;e.`title` LIKE '{$schString}'&quot;; } //Title
	if (in_array(0, $eF) or in_array(2, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ').&quot;e.`venue` LIKE '{$schString}'&quot;; } //venue
	if (in_array(0, $eF) or in_array(3, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ').&quot;e.`text1` LIKE '{$schString}'&quot;; } //text field 1
	if (in_array(0, $eF) or in_array(4, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ').&quot;e.`text2` LIKE '{$schString}'&quot;; } //text field 2
	if (in_array(0, $eF) or in_array(5, $eF)) { $filter .= ((substr($filter, -1) == '(') ? '' : ' OR ').&quot;e.`text3` LIKE '{$schString}'&quot;; } //text field 3
	$filter = substr($filter,5).&quot;)&quot;;
	
	//set event date range
	$sDate = ($fromDda) ? $fromDda : date('Y-m-d',$nowTS-31536000); //-1 year
	$eDate = ($tillDda) ? $tillDda : date('Y-m-d',$nowTS+31536000); //+1 year

	retrieve($sDate,$eDate,'',$filter); //grab events

	//display header
	$fields = '';
	if (in_array(0, $eF) or in_array(1, $eF)) { $fields = ' + '.$xx['sch_title']; }
	foreach (str_split($set['evtTemplGen']) as $fieldNr) {
		if (strpos('1345',$fieldNr) !== false) {
			switch ($fieldNr) {
			case '1': 
				if (in_array(0, $eF) or in_array(2, $eF)) { $fields .= ' + '.$xx['sch_venue']; } break;
			case '3':
				if (in_array(0, $eF) or in_array(3, $eF)) { $fields .= ' + '.$xx['sch_description']; } break;
			case '4':
				if (in_array(0, $eF) or in_array(4, $eF)) { $fields .= ' + '.($set['xField1Label'] ? &quot;{$set['xField1Label']}&quot; : $xx['sch_extra_field1']); } break;
			case '5':
				if (in_array(0, $eF) or in_array(5, $eF)) { $fields .= ' + '.($set['xField2Label'] ? &quot;{$set['xField2Label']}&quot; : $xx['sch_extra_field2']); }
			}
		}
	}
	$fields = substr($fields,3);

	echo &quot;&lt;div class='subHead'&gt;
&lt;form id='event' name='event' action='index.php' method='post'&gt;
&lt;input type='hidden' name='lcI' value='{$lcI}'&gt;
&lt;input type='hidden' name='schText' value=\&quot;{$schText}\&quot;&gt;\n&quot;;
	foreach ($eF as $key =&gt; $value) { echo &quot;&lt;input type='hidden' name='eF[]' value=\&quot;{$value}\&quot;&gt;\n&quot;;	}
	echo &quot;&lt;input type='hidden' name='grpName' value=\&quot;{$grpName}\&quot;&gt;
&lt;input type='hidden' name='catName' value=\&quot;{$catName}\&quot;&gt;
&lt;input type='hidden' name='fromDda' value='&quot;.IDtoDD($fromDda).&quot;'&gt;
&lt;input type='hidden' name='tillDda' value='&quot;.IDtoDD($tillDda).&quot;'&gt;
&lt;button class='floatR noPrint' type='submit' name='newSearch' value='y'&gt;{$xx['sch_new_search']}&lt;/button&gt;
&lt;/form&gt;
{$xx['sch_search_text']}: &lt;b&gt;{$schText}&lt;/b&gt;&lt;br&gt;
{$xx['sch_event_fields']}: &lt;b&gt;{$fields}&lt;/b&gt;&lt;br&gt;
{$xx['sch_user_group']}: &lt;b&gt;&quot;.($grpName != '*' ? $grpName : $xx['sch_all_groups']).&quot;&lt;/b&gt;&lt;br&gt;
{$xx['sch_event_cat']}: &lt;b&gt;&quot;.($catName != '*' ? $catName : $xx['sch_all_cats']).&quot;&lt;/b&gt;&lt;br&gt;
{$xx['sch_occurring_between']}: &lt;b&gt;&quot;.makeD($sDate,2).&quot; - &quot;.makeD($eDate,2).&quot;&lt;/b&gt;
&lt;/div&gt;\n&quot;;
}

function showMatches($eType) { //eType (0: normal, 1: mde, 2: recurring)
	global $usr, $set, $xx, $evtList, $schText;

	//display matching events
	$match = '%('.str_replace(array('_','&amp;'), array('.','[^&lt;&gt;]+?'), $schText).')(?![^&lt;]*&gt;)%i'; //convert to regex (?!: neg.look-ahead condition)
	$evtDone = array();
	foreach($evtList as $date =&gt; &amp;$events) {
		foreach ($events as $evt) {
			if ($eType == 0) {
				if ($evt['mde'] or $evt['r_t']) { continue; } //mde or rec event
				$evtDate = &quot;&lt;a href=\&quot;javascript:index({cP:2,cD:'{$date}'})\&quot; title=\&quot;{$xx['sch_calendar']}\&quot;&gt;&quot;.makeD($date,5).&quot;&lt;/a&gt;&quot;;
			} elseif ($eType == 1) {
				if (!$evt['mde'] or in_array($evt['eid'],$evtDone)) { continue; } //!mde or mde processed
				$evtDate = &quot;&lt;a href=\&quot;javascript:index({cP:2,cD:'{$date}'})\&quot; title=\&quot;{$xx['sch_calendar']}\&quot;&gt;&quot;.makeD($evt['sda'],5).&quot; - &quot;.makeD($evt['eda'],5).&quot;&lt;/a&gt;&quot;;
			} elseif ($eType == 2) {
				if (!$evt['r_t'] or in_array($evt['eid'],$evtDone)) { continue; } //!rec or rec processed
				$evtDate = &quot;&lt;a href=\&quot;javascript:index({cP:2,cD:'{$date}'})\&quot; title=\&quot;{$xx['sch_calendar']}\&quot;&gt;&quot;.makeD($date,5).' - '.repeatText($evt['r_t'],$evt['r_i'],$evt['r_p'],$evt['r_m'],$evt['r_u']).&quot;&lt;/a&gt;&quot;;
			}
			$evtDone[] = $evt['eid'];
			$evtTime = $evt['ald'] ? $xx['vws_all_day'] : ITtoDT($evt['sti']).($evt['eti'] ? ' - '.ITtoDT($evt['eti']) : '');
			if ($set['eventColor']) {
				$eStyle = ($evt['cco'] ? &quot;color:{$evt['cco']};&quot; : '').($evt['cbg'] ? &quot;background-color:{$evt['cbg']};&quot; : '');
			} else {
				$eStyle = $evt['uco'] ? &quot;background-color:{$evt['uco']};&quot; : '';
			}
			$eStyle = $eStyle ? ' style=&quot;'.$eStyle.'&quot;' : '';
			$chBox = '';
			if ($evt['cbx']) {
				$mayCheck = ($usr['privs'] &gt; 3 or ($usr['privs'] &gt; 1 and $evt['uid'] == $usr['ID'])); //boolean
				$chBox .= !$evt['mde'] ? (strpos($evt['chd'], $date) ? $evt['cmk'] : '&amp;#x2610;') : '?';
				$cBoxAtt = ($mayCheck and !$evt['mde']) ? &quot; class='chkBox point' onclick=\&quot;checkE(this,{$evt['eid']},'{$date}');\&quot;&quot; : 'class=&quot;chkBox arrow&quot;';
				$chBox = &quot;&lt;span title='{$evt['clb']}' {$cBoxAtt}&gt;{$chBox}&lt;/span&gt;&quot;;
			}
			$toAppr = ($evt['app'] and !$evt['apd']) ? ' toApprove' : '';
			echo &quot;&lt;div class='hired'&gt;{$evtDate}&lt;/div&gt;\n&quot;;
			echo &quot;&lt;table&gt;\n&lt;tr&gt;\n&lt;td class='widthCol1'&gt;{$evtTime}&lt;/td&gt;&quot;;
			echo &quot;&lt;td class='eBox{$toAppr}'&gt;&quot;;
			$eTitle = preg_replace($match, '&lt;mark&gt;$1&lt;/mark&gt;',$evt['tit']);
			if ($set['details4All'] == 1 or ($set['details4All'] == 2 and $usr['ID'] &gt; 1) or $evt['mayE']) {
				$click = ($evt['mayE'] ? 'editE' : 'showE').&quot;({$evt['eid']},'{$date}')&quot;;
				echo &quot;&lt;span class='evtTitle bold'&gt;{$chBox}&lt;span class='point'{$eStyle} onclick=\&quot;{$click};\&quot;&gt;&quot;.$eTitle.&quot;&lt;/span&gt;&lt;/span&gt;\n&quot;;
				echo preg_replace($match, '&lt;mark&gt;$1&lt;/mark&gt;',makeE($evt,$set['evtTemplGen'],'bx',&quot;&lt;br&gt;\n&quot;)).&quot;\n&quot;;
			} else {
				echo &quot;&lt;span class='evtTitle bold'&gt;{$chBox}&lt;span{$eStyle}&gt;&quot;.$eTitle.&quot;&lt;/span&gt;&lt;/span&gt;\n&quot;;
			}
			echo &quot;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;br&gt;\n&quot;;
		}
	}
	if (empty($evtDone)) {
		echo $xx['none'];
	}
}

//control logic

$msg = ''; //init
if (isset($_POST[&quot;search&quot;])) {
	$msg = validateForm();
}
echo &quot;&lt;p class='error'&gt;{$msg}&lt;/p&gt;\n&quot;;
if (isset($_POST[&quot;search&quot;]) and !$msg) {
	searchText(); //search
	echo &quot;&lt;div class='scrollBoxTs'&gt;\n&quot;;
$fsClass = $isMob ? 'upc-m' : 'upc';
	if ($evtList) {
		echo &quot;&lt;fieldset class='{$fsClass}'&gt;\n&lt;legend&gt;{$xx['sch_sd_events']}&lt;/legend&gt;\n&quot;;
		showMatches(0); //show results single-day events
		echo &quot;&lt;/fieldset&gt;&quot;;
		echo &quot;&lt;fieldset class='{$fsClass}'&gt;\n&lt;legend&gt;{$xx['sch_md_events']}&lt;/legend&gt;\n&quot;;
		showMatches(1); //show results multi-day events
		echo &quot;&lt;/fieldset&gt;&quot;;
		echo &quot;&lt;fieldset class='{$fsClass}'&gt;\n&lt;legend&gt;{$xx['sch_rc_events']}&lt;/legend&gt;\n&quot;;
		showMatches(2); //show results recurring events
		echo &quot;&lt;/fieldset&gt;&quot;;
	} else {
		echo &quot;&lt;div class='floatC'&gt;{$xx['sch_no_results']}&lt;/div&gt;\n&quot;;
	}
	echo &quot;&lt;/div&gt;\n&quot;;
} else {
	echo &quot;&lt;div class='scrollBoxTs'&gt;
&lt;aside class='aside'&gt;\n{$xx['sch_instructions']}\n&lt;/aside&gt;
&lt;div class='centerBox'&gt;\n&quot;;
	searchForm(); //define search
	echo &quot;&lt;/div&gt;\n&lt;/div&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/bookingtest/pages">← Geri</a>