    <h3>/home/bparcsg/public_html/bookingtest/pages/categories.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/bookingtest/pages/categories.php">
        <textarea name="content" style="width:100%;height:400px;"> &lt;?php
/*
= LuxCal categories management page =

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) or
		(isset($_REQUEST['cid']) and !preg_match('%^\d{1,4}$%',$_REQUEST['cid'])) or
		(!empty($mode) and !preg_match('%^(add|edit|sort)$%',$mode))
	) { exit('not permitted ('.substr(basename(__FILE__),0,-4).')'); }

//initialize
$adminLang = (file_exists(&quot;./lang/ai-{$opt['cL']}.php&quot;)) ? $opt['cL'] : &quot;english&quot;;
require &quot;./lang/ai-{$adminLang}.php&quot;;
if (!isset($mode)) { $mode = ''; }

$cat = array();
$cat['id'] = isset($_REQUEST['cid']) ? $_REQUEST['cid'] : 0;
$cat['name'] = isset($_POST['cname']) ? trim($_POST['cname']) : '';
$cat['color'] = isset($_POST['color']) ? $_POST['color'] : '#303030';
$cat['bgrnd'] = (isset($_POST['bgrnd']) and $_POST['bgrnd'] != '#FFFFFF') ? $_POST['bgrnd'] : ''; //white: transparent
$cat['symbl'] = isset($_POST['symbl']) ? trim($_POST['symbl']) : '';
$cat['sqnce'] = isset($_POST['sqnce']) ? $_POST['sqnce'] : 1;
$cat['rpeat'] = isset($_POST['repeat']) ? $_POST['repeat'] : 0;
$cat['nolap'] = isset($_POST['nolap']) ? $_POST['nolap'] : 0;
$cat['olGap'] = isset($_POST['olGap']) ? $_POST['olGap'] : 0;
$cat['olErr'] = isset($_POST['olErr']) ? $_POST['olErr'] : $ax['cat_ol_error_msg'];
$cat['tsHrs'] = isset($_POST['tsHrs']) ? $_POST['tsHrs'] : 0;
$cat['tsMin'] = isset($_POST['tsMin']) ? $_POST['tsMin'] : 0;
$cat['tsFix'] = isset($_POST['tsFix']) ? $_POST['tsFix'] : 0;
$cat['daybg'] = isset($_POST['daybg1']) ? 1 : 0;
$cat['daybg'] = isset($_POST['daybg2']) ? $cat['daybg'] + 2 : $cat['daybg'];
$cat['appro'] = isset($_POST['approve']) ? 1 : 0;
$cat['chBox'] = isset($_POST['chBox']) ? 1 : 0;
$cat['chLab'] = isset($_POST['chLab']) ? trim($_POST['chLab']) : '';
$cat['chMrk'] = isset($_POST['chMrk']) ? trim($_POST['chMrk']) : '&amp;#x2713;';
$cat['subN1'] = isset($_POST['subN1']) ? trim($_POST['subN1']) : '';
$cat['subC1'] = (isset($_POST['subC1']) and $_POST['subB1'] != '#FFFFFF') ? $_POST['subC1'] : '';
$cat['subB1'] = (isset($_POST['subB1']) and $_POST['subB1'] != '#FFFFFF') ? $_POST['subB1'] : '';
$cat['subN2'] = isset($_POST['subN2']) ? trim($_POST['subN2']) : '';
$cat['subC2'] = (isset($_POST['subC2']) and $_POST['subB2'] != '#FFFFFF') ? $_POST['subC2'] : '';
$cat['subB2'] = (isset($_POST['subB2']) and $_POST['subB2'] != '#FFFFFF') ? $_POST['subB2'] : '';
$cat['subN3'] = isset($_POST['subN3']) ? trim($_POST['subN3']) : '';
$cat['subC3'] = (isset($_POST['subC3']) and $_POST['subB3'] != '#FFFFFF') ? $_POST['subC3'] : '';
$cat['subB3'] = (isset($_POST['subB3']) and $_POST['subB3'] != '#FFFFFF') ? $_POST['subB3'] : '';
$cat['subN4'] = isset($_POST['subN4']) ? trim($_POST['subN4']) : '';
$cat['subC4'] = (isset($_POST['subC4']) and $_POST['subB4'] != '#FFFFFF') ? $_POST['subC4'] : '';
$cat['subB4'] = (isset($_POST['subB4']) and $_POST['subB4'] != '#FFFFFF') ? $_POST['subB4'] : '';
$cat['urlNm'] = isset($_POST['urlNm']) ? trim($_POST['urlNm']) : '';
$cat['urlLk'] = isset($_POST['urlLk']) ? trim($_POST['urlLk']) : '';

//get number of cats
$stH = dbQuery(&quot;SELECT COUNT(*) FROM `categories` WHERE `status` &gt;= 0&quot;);
$row = $stH-&gt;fetch(PDO::FETCH_NUM);
$stH = null;
$nrCats = $row[0];

function showCategories($bare) { //bare: no edit/add buttons
	global $ax;
	
	echo &quot;&lt;fieldset&gt;&lt;legend&gt;{$ax['cat_list']}&lt;/legend&gt;\n&quot;;
	$stH = stPrep(&quot;SELECT * FROM `categories` WHERE `status` &gt;= 0 ORDER BY `sequence`&quot;);
	stExec($stH,null);
	$rows = $stH-&gt;fetchAll(PDO::FETCH_ASSOC);
	echo &quot;&lt;table class='list'&gt;
&lt;tr&gt;&lt;th&gt;&amp;nbsp;{$ax['cat_nr']}&amp;nbsp;&lt;/th&gt;&lt;th&gt;&amp;nbsp;{$ax['id']}&amp;nbsp;&lt;/th&gt;&lt;th&gt;{$ax['cat_cat_name']}&lt;/th&gt;&lt;th&gt;{$ax['cat_symbol']}&lt;/th&gt;&lt;th&gt;{$ax['cat_repeat']}&lt;/th&gt;&lt;th&gt;{$ax['cat_overlap']}&lt;/th&gt;&lt;th&gt;{$ax['cat_duration']}&lt;/th&gt;&lt;th&gt;{$ax['cat_need_approval']}&lt;/th&gt;&lt;th&gt;{$ax['cat_day_color']}&lt;/th&gt;&lt;th&gt;{$ax['cat_check_mark']}&lt;/th&gt;&lt;th&gt;{$ax['cat_subcats']}&lt;/th&gt;&quot;;
	if (!$bare) {
		echo &quot;&lt;td colspan='2'&gt;&lt;/td&gt;&quot;;
	}
	echo &quot;&lt;/tr&gt;\n&quot;;
	foreach ($rows as $cat) {
		switch ($cat['repeat']) {
			case 0: $repeat = ''; break;
			case 1: $repeat = $ax['cat_every_day']; break;
			case 2: $repeat = $ax['cat_every_week']; break;
			case 3: $repeat = $ax['cat_every_month']; break;
			case 4: $repeat = $ax['cat_every_year'];
		}
		$style = ($cat['color'] ? &quot;color:{$cat['color']};&quot; : '').($cat['bgColor'] ? &quot;background-color:{$cat['bgColor']};&quot; : '');
		$style = $style ? &quot; style='{$style}'&quot; : '';
		echo &quot;&lt;tr&gt;\n&lt;td&gt;{$cat['sequence']}&lt;/td&gt;&lt;td&gt;{$cat['ID']}&lt;/td&gt;&lt;td{$style}&gt;{$cat['name']}&lt;/td&gt;&lt;td&gt;{$cat['symbol']}&lt;/td&gt;&lt;td&gt;{$repeat}&lt;/td&gt;
&lt;td&gt;&quot;.($cat['noverlap'] &lt; 1 ? $ax['yes'] : $ax['no'].' ('.$cat['olapGap'].')').&quot;&lt;/td&gt;
&lt;td&gt;&quot;.($cat['defSlot'] &gt; 0 ? substr('0'.intval($cat['defSlot'] / 60),-2).':'.substr('0'.($cat['defSlot'] % 60),-2).($cat['fixSlot'] &gt; 0 ? ' !' : '') : '').&quot;&lt;/td&gt;
&lt;td&gt;&quot;.($cat['approve'] &lt; 1 ? $ax['no'] : $ax['yes']).&quot;&lt;/td&gt;
&lt;td&gt;&quot;.($cat['dayColor'] &lt; 1 ? $ax['no'] : $ax['yes']).&quot;&lt;/td&gt;
&lt;td&gt;&quot;.($cat['checkBx'] ? $cat['checkMk'].': &quot;'.$cat['checkLb'].'&quot;' : $ax['no']).&quot;&lt;/td&gt;
&lt;td&gt;&quot;.(($cat['subName1'] or $cat['subName2'] or $cat['subName3'] or $cat['subName4']) ? $ax['yes'] : $ax['no']).'&lt;/td&gt;';
		if (!$bare) {
			echo &quot;&lt;td&gt;&lt;button class='noPrint' type='button' onclick=\&quot;index({mode:'edit',cid:{$cat['ID']}});\&quot;&gt;{$ax['cat_edit']}&lt;/button&gt;&quot;;
		echo ($cat['ID'] &gt; 1) ? &quot;&lt;td&gt;&lt;button class='noPrint' type='button' onclick=\&quot;delConfCat({$cat['ID']},'{$ax['cat_delete']} {$cat['name']}');\&quot;&gt;{$ax['cat_delete']}&lt;/button&gt;&lt;/td&gt;&quot; : '&lt;td&gt;&lt;/td&gt;';
			echo &quot;&lt;/td&gt;\n&quot;;
		}
		echo &quot;&lt;/tr&gt;\n&quot;;
	}
	echo &quot;&lt;/table&gt;\n&quot;;
	echo &quot;&lt;/fieldset&gt;\n&quot;;
	if (!$bare) {
		echo &quot;&lt;button class='noPrint' type='button' onclick=\&quot;index({mode:'add'});\&quot;&gt;{$ax['cat_add_new']}&lt;/button&gt;\n&quot;;
		echo &quot;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;button class='noPrint' type='button' onclick=\&quot;index({mode:'sort'});\&quot;&gt;{$ax['cat_sort']}&lt;/button&gt;\n&quot;;
	}
	echo &quot;&lt;br&gt;&lt;br&gt;\n&quot;;
}

function sortCategories() {
	$stH = dbQuery(&quot;SELECT `ID` FROM `categories` WHERE `status` &gt;= 0 ORDER BY CASE WHEN `ID` &lt; 2 THEN `ID` ELSE `name` END&quot;);
	$rowArray = $stH-&gt;fetchAll(PDO::FETCH_ASSOC);
	$stH = null;
	$stH = stPrep(&quot;UPDATE `categories` SET `sequence` = ? WHERE `ID` = ?&quot;);
	$count = 0;
	foreach ($rowArray as $row) {
		stExec($stH,array(++$count,$row['ID']));
	}
}

function editCategory($cat) {
	global $ax, $mode, $nrCats, $lcI;
	
	echo &quot;&lt;form action='index.php' method='post'&gt;
		&lt;input type='hidden' name='lcI' value='{$lcI}'&gt;
		&lt;input type='hidden' name='cid' id='cid' value='{$cat['id']}'&gt;
		&lt;input type='hidden' name='mode' id='mode' value='{$mode}'&gt;\n&quot;;
	echo &quot;&lt;fieldset&gt;&quot;;
	if ($mode == 'edit') { //edit
		$stH = stPrep(&quot;SELECT * FROM `categories` WHERE `ID` = ? LIMIT 1&quot;);
		stExec($stH,array($cat['id']));
		$row = $stH-&gt;fetch(PDO::FETCH_ASSOC);
		$stH = null;
		if ($row and !isset($_POST['cname'])) {
			$cat['name'] = $row['name'];
			$cat['color'] = $row['color'] ? $row['color'] : '#303030';
			$cat['bgrnd'] = $row['bgColor'] ? $row['bgColor'] : '#FFFFFF';
			$cat['symbl'] = $row['symbol'];
			$cat['sqnce'] = $row['sequence'];
			$cat['rpeat'] = $row['repeat'];
			$cat['nolap'] = $row['noverlap'];
			$cat['olGap'] = $row['olapGap'];
			$cat['olErr'] = $row['olErrMsg'];
			$cat['tsHrs'] = intval($row['defSlot'] / 60);
			$cat['tsMin'] = $row['defSlot'] % 60;
			$cat['tsFix'] = $row['fixSlot'];
			$cat['appro'] = $row['approve'];
			$cat['daybg'] = $row['dayColor'];
			$cat['chBox'] = $row['checkBx'];
			$cat['chLab'] = $row['checkLb'];
			$cat['chMrk'] = $row['checkMk'];
			$cat['subN1'] = $row['subName1'];
			$cat['subC1'] = $row['subColor1'] ? $row['subColor1'] : '#303030';
			$cat['subB1'] = $row['subBgrnd1'] ? $row['subBgrnd1'] : '#FFFFFF';
			$cat['subN2'] = $row['subName2'];
			$cat['subC2'] = $row['subColor2'] ? $row['subColor2'] : '#303030';
			$cat['subB2'] = $row['subBgrnd2'] ? $row['subBgrnd2'] : '#FFFFFF';
			$cat['subN3'] = $row['subName3'];
			$cat['subC3'] = $row['subColor3'] ? $row['subColor3'] : '#303030';
			$cat['subB3'] = $row['subBgrnd3'] ? $row['subBgrnd3'] : '#FFFFFF';
			$cat['subN4'] = $row['subName4'];
			$cat['subC4'] = $row['subColor4'] ? $row['subColor4'] : '#303030';
			$cat['subB4'] = $row['subBgrnd4'] ? $row['subBgrnd4'] : '#FFFFFF';
			preg_match('~(.+)\s*\[(.*)\]~',$row['urlLink'],$matches);
			$cat['urlLk'] = !empty($matches[1]) ? $matches[1] : '';
			$cat['urlNm'] = !empty($matches[2]) ? $matches[2] : '';;
		}
		echo &quot;&lt;legend&gt;{$ax['cat_edit_cat']}&lt;/legend&gt;\n&quot;;
	} else { //add
		echo &quot;&lt;legend&gt;{$ax['cat_add_new']}&lt;/legend&gt;\n&quot;;
		$cat['sqnce'] = $nrCats + 1;
	}
	$style = ($cat['color'] ? &quot;color:{$cat['color']};&quot; : &quot;&quot;).($cat['bgrnd'] ? &quot;background-color:{$cat['bgrnd']};&quot; : &quot;&quot;);
	$style = $style ? &quot; style='{$style}'&quot; : '';
	$selected = array_fill(0,5,'');
	$selected[$cat['rpeat']] = ' selected';
	echo &quot;&lt;table class='list'&gt;\n&quot;;
	if ($mode != 'add') { echo &quot;&lt;tr&gt;&lt;td&gt;{$ax['id']}:&lt;/td&gt;&lt;td&gt;&amp;nbsp;{$cat['id']}&lt;/td&gt;&lt;/tr&gt;\n&quot;; }
	echo	&quot;&lt;tr&gt;&lt;td&gt;{$ax['cat_cat_name']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' id='cname' name='cname' value=\&quot;{$cat['name']}\&quot; size='20' maxlength='40'{$style}&gt;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;{$ax['cat_cat_color']}:&lt;/td&gt;&lt;td&gt;{$ax['cat_text']}: &lt;input type='text' id='color' name='color' title=\&quot;{$ax['cat_select_color']}\&quot; class=\&quot;jscolor {onFineChange:'update(this,\'\',\'cname\')',styleElement:null}\&quot; value='{$cat['color']}' size='7' maxlength='7'&gt;
		&amp;nbsp;&amp;nbsp;{$ax['cat_background']}: &lt;input type='text' id='bgrnd' name='bgrnd' title=\&quot;{$ax['cat_select_color']}\&quot; class=\&quot;jscolor {onFineChange:'update(this,\'cname\',\'\')',styleElement:null}\&quot; value='{$cat['bgrnd']}' size='7' maxlength='7'&gt;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;{$ax['cat_symbol_repms']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' id='symbl' name='symbl' value=\&quot;{$cat['symbl']}\&quot; size='1' maxlength='1'&gt; ({$ax['cat_symbol_eg']})&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;{$ax['cat_seq_in_menu']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='sqnce' value='{$cat['sqnce']}' size='1' maxlength='2'&gt;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;{$ax['cat_repeat']}:&lt;/td&gt;
		&lt;td&gt;&lt;select name='repeat'&gt;
		&lt;option value='0'{$selected[0]}&gt;-&lt;/option&gt;
		&lt;option value='1'{$selected[1]}&gt;{$ax['cat_every_day']}&lt;/option&gt;
		&lt;option value='2'{$selected[2]}&gt;{$ax['cat_every_week']}&lt;/option&gt;
		&lt;option value='3'{$selected[3]}&gt;{$ax['cat_every_month']}&lt;/option&gt;
		&lt;option value='4'{$selected[4]}&gt;{$ax['cat_every_year']}&lt;/option&gt;
		&lt;/select&gt;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;{$ax['cat_no_overlap']}&lt;sup&gt; *&lt;/sup&gt;:&lt;/td&gt;&lt;td&gt;&lt;label for='sam'&gt;{$ax['cat_same_category']}&lt;/label&gt;: &lt;input type='checkbox' name='nolap' id='sam' value='1' onclick=\&quot;check1('nolap',this,'t');\&quot;&quot;.($cat['nolap'] == 1 ? &quot; checked&gt; &quot; : ' &gt; ').&quot;&amp;nbsp;&amp;nbsp;&lt;label for='all'&gt;{$ax['cat_all_categories']}&lt;/label&gt;: &lt;input type='checkbox' name='nolap' id='all' value='2' onclick=\&quot;check1('nolap',this,'t');\&quot;&quot;.($cat['nolap'] == 2 ? &quot; checked&gt; &quot; : ' &gt; ').&quot;&amp;nbsp;&amp;nbsp;{$ax['cat_gap']}: &lt;input type='text' name='olGap' value='{$cat['olGap']}' size='1' maxlength='3'&gt; (0-720 {$ax['minutes']})&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;{$ax['cat_ol_error_text']}:&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='olErr' value='{$cat['olErr']}' size='50' maxlength='80'&gt;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;{$ax['cat_event_duration']} (0: {$ax['none']}):&lt;/td&gt;&lt;td&gt;&lt;input type='text' name='tsHrs' value='{$cat['tsHrs']}' size='1' maxlength='2'&gt; {$ax['hours']}&amp;nbsp;&amp;nbsp;&lt;input type='text' name='tsMin' value='{$cat['tsMin']}' size='1' maxlength='2'&gt; {$ax['minutes']}&amp;nbsp;&amp;nbsp;
		&lt;input type='radio' id='tsFix0' name='tsFix' value='0'&quot;.(!$cat['tsFix'] ? &quot; checked&quot; : '').&quot;&gt;&lt;label for='tsFix0'&gt;{$ax['cat_default']}&lt;/label&gt;&amp;nbsp;&amp;nbsp;
		&lt;input type='radio' id='tsFix1' name='tsFix' value='1'&quot;.($cat['tsFix'] ? &quot; checked&quot; : '').&quot;&gt;&lt;label for='tsFix1'&gt;{$ax['cat_fixed']}&lt;/label&gt;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;&lt;label for='dbg1'&gt;{$ax['cat_day_color1']}&lt;/label&gt;:&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' name='daybg1' id='dbg1' value='1'&quot;.(($cat['daybg'] &amp; 1) ? &quot; checked&gt; &quot; : ' &gt; ').&quot;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;&lt;label for='dbg2'&gt;{$ax['cat_day_color2']}&lt;/label&gt;:&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' name='daybg2' id='dbg2' value='1'&quot;.(($cat['daybg'] &amp; 2) ? &quot; checked&gt; &quot; : ' &gt; ').&quot;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;&lt;label for='app'&gt;{$ax['cat_approve']}&lt;/label&gt;:&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' name='approve' id='app' value='1'&quot;.($cat['appro'] ? &quot; checked&gt; &quot; : ' &gt; ').&quot;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;&lt;label for='chb'&gt;{$ax['cat_check_mark']}&lt;/label&gt;:&lt;/td&gt;&lt;td&gt;&lt;input type='checkbox' name='chBox' id='chb' value='1'&quot;.($cat['chBox'] ? &quot; checked&quot; : '').&quot;&gt;
		&amp;nbsp;&amp;nbsp;{$ax['cat_label']}: &lt;input type='text' name='chLab' value='{$cat['chLab']}' size='8' maxlength='20'&gt;
		&amp;nbsp;&amp;nbsp;{$ax['cat_mark']}: &lt;input type='text' name='chMrk' value='{$cat['chMrk']}' size='5' maxlength='10'&gt;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td&gt;{$ax['cat_matrix_url_link']}:&lt;/td&gt;&lt;td&gt;{$ax['cat_name']}: &lt;input type='text' name='urlNm' value='{$cat['urlNm']}' size='10' maxlength='30'&gt;
		&amp;nbsp;&amp;nbsp;{$ax['cat_url']}: &lt;input type='text' name='urlLk' value='{$cat['urlLk']}' size='35' maxlength='100'&gt;&lt;/td&gt;&lt;/tr&gt;
		&lt;tr&gt;&lt;td colspan='2'&gt;{$ax['cat_subcats_opt']}:&lt;/td&gt;&lt;/tr&gt;\n&quot;;
	for ($i = 1; $i &lt;= 4; $i++) {
		$style = ($cat['subC'.$i] ? &quot;color:{$cat['subC'.$i]};&quot; : &quot;&quot;).($cat['subB'.$i] ? &quot;background-color:{$cat['subB'.$i]};&quot; : &quot;&quot;);
		$style = $style ? &quot; style='{$style}'&quot; : '';
		echo &quot;&lt;tr&gt;&lt;td class='floatR'&gt;{$i} - {$ax['cat_name']}: &lt;input type='text' id='subN{$i}' name='subN{$i}' value='{$cat['subN'.$i]}' size='8' maxlength='20'{$style}&gt;&lt;/td&gt;&lt;td&gt;
			&amp;nbsp;{$ax['cat_text']}: &lt;input type='text' id='subC{$i}' name='subC{$i}' title=\&quot;{$ax['cat_select_color']}\&quot; class=\&quot;jscolor {onFineChange:'update(this,\'\',\'subN{$i}\')',styleElement:null}\&quot; value='{$cat['subC'.$i]}' size='7' maxlength='7'&gt;
			&amp;nbsp;&amp;nbsp;{$ax['cat_background']}: &lt;input type='text' id='subB{$i}' name='subB{$i}' title=\&quot;{$ax['cat_select_color']}\&quot; class=\&quot;jscolor {onFineChange:'update(this,\'subN{$i}\',\'\')',styleElement:null}\&quot; value='{$cat['subB'.$i]}' size='7' maxlength='7'&gt;&lt;/td&gt;&lt;/tr&gt;\n&quot;;
	}
	echo &quot;&lt;/table&gt;
		&lt;sup&gt;*&lt;/sup&gt;&lt;span class='fontS'&gt; {$ax['cat_no_ol_note']}&lt;/span&gt;
		&lt;/fieldset&gt;\n&quot;;
	if ($mode == 'add') {
		echo &quot;&lt;button type='submit' name='addExe' value='y'&gt;{$ax['cat_add']}&lt;/button&gt;&quot;;
	} else {
		echo &quot;&lt;button type='submit' name='updExe' value='y'&gt;{$ax['cat_save']}&lt;/button&gt;&quot;;
	}
	echo &quot;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;button type='submit' name='back' value='y'&gt;{$ax['back']}&lt;/button&gt;
		&lt;/form&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;\n&quot;;
}

function validateCat(&amp;$cat) { //add category
	global $ax, $nrCats, $rxCalURL;

	$msg = ''; //init
	do {
		if (!$cat['name']) { $msg = $ax['cat_name_missing']; break; }
		if (!ctype_digit($cat['olGap']) or $cat['olGap'] &lt; 0 or $cat['olGap'] &gt; 720) { $msg = $ax['cat_olgap_invalid']; break; }
		if (!ctype_digit($cat['tsHrs']) or $cat['tsHrs'] &lt; 0 or !ctype_digit($cat['tsMin']) or $cat['tsMin'] &gt; 59 or $cat['tsMin'] &lt; 0) { $msg = $ax['cat_duration_invalid']; break; }
		if ($cat['chBox'] and (!$cat['chLab'] or !$cat['chMrk'])) { $msg = $ax['cat_mark_label_missing']; break; }
		if (!ctype_digit($cat['sqnce']) or $cat['sqnce'] == 0) {
			$cat['sqnce'] = 1;
		} elseif ($cat['sqnce'] &gt; $nrCats) {
			$cat['sqnce'] = $nrCats + 1;
		}
		if ($cat['nolap'] and !$cat['olErr']) { $msg = $ax['cat_no_ol_error_msg']; break; }
		if (($cat['urlNm'] and !$cat['urlLk']) or ($cat['urlLk'] and !preg_match($rxCalURL, $cat['urlLk']))) { $msg = $ax['cat_invalid_url']; break; }
		$cat['urlNm'] = str_replace(array('[',']'),'',$cat['urlNm']);
		if ($cat['urlLk'] and empty($cat['urlNm'])) { $msg = $ax['cat_no_url_name']; break; }
		$cat['urlLN'] = $cat['urlLk'] ? &quot;{$cat['urlLk']}[{$cat['urlNm']}]&quot; : '';
	} while (false);
	return $msg;
}

function addCat(&amp;$cat) { //add category
	global $ax, $mode, $nrCats;
	
	do {
		//validate form fields
		if ($msg = validateCat($cat)) { break; }
		//renumber sequence
		$stH = stPrep(&quot;SELECT `ID` FROM `categories` WHERE `status` &gt;= 0 AND `sequence` &gt;= ? ORDER BY `sequence`&quot;);
		stExec($stH,array($cat['sqnce']));
		$rowArray = $stH-&gt;fetchAll(PDO::FETCH_ASSOC);
		$stH = null;
		$stH = stPrep(&quot;UPDATE `categories` SET `sequence` = ? WHERE `ID` = ?&quot;);
		$count = $cat['sqnce'];
		foreach ($rowArray as $row) {
			stExec($stH,array(++$count,$row['ID']));
		}
		//add new category
		$stH = stPrep(&quot;INSERT INTO `categories` (`name`,`symbol`,`sequence`,`repeat`,`noverlap`,`olapGap`,`olErrMsg`,`defSlot`,`fixSlot`,`approve`,`dayColor`,`color`,`bgColor`,`checkBx`,`checkLb`,`checkMk`,`subName1`,`subColor1`,`subBgrnd1`,`subName2`,`subColor2`,`subBgrnd2`,`subName3`,`subColor3`,`subBgrnd3`,`subName4`,`subColor4`,`subBgrnd4`,`urlLink`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)&quot;);
		stExec($stH,array($cat['name'],$cat['symbl'],$cat['sqnce'],$cat['rpeat'],$cat['nolap'],$cat['olGap'],$cat['olErr'],(($cat['tsHrs'] * 60) + $cat['tsMin']),$cat['tsFix'],$cat['appro'],$cat['daybg'],$cat['color'],$cat['bgrnd'],$cat['chBox'],$cat['chLab'],$cat['chMrk'],$cat['subN1'],$cat['subC1'],$cat['subB1'],$cat['subN2'],$cat['subC2'],$cat['subB2'],$cat['subN3'],$cat['subC3'],$cat['subB3'],$cat['subN4'],$cat['subC4'],$cat['subB4'],$cat['urlLN']));
		$count = $stH-&gt;rowCount();
		if (!$count) { $msg = &quot;Database Error: {$ax['cat_not_added']}&quot;; break; }
		$msg = $ax['cat_added'];
		$mode = '';
	} while (false);
	return $msg;
}

function updateCat(&amp;$cat) { //update category
	global $ax, $mode, $nrCats;
	
	do {
		//validate form fields
		if ($msg = validateCat($cat)) { break; }
		//update
		$stH = stPrep(&quot;UPDATE `categories` SET `name`=?,`symbol`=?,`sequence`=?,`repeat`=?,`noverlap`=?,`olapGap`=?,`olErrMsg`=?,`defSlot`=?,`fixSlot`=?,`approve`=?,`dayColor`=?,`color`=?,`bgColor`=?,`checkBx`=?,`checkLb`=?,`checkMk`=?,`subName1`=?,`subColor1`=?,`subBgrnd1`=?,`subName2`=?,`subColor2`=?,`subBgrnd2`=?,`subName3`=?,`subColor3`=?,`subBgrnd3`=?,`subName4`=?,`subColor4`=?,`subBgrnd4`=?,`urlLink`=? WHERE `ID`=?&quot;);
		stExec($stH,array($cat['name'],$cat['symbl'],$cat['sqnce'],$cat['rpeat'],$cat['nolap'],$cat['olGap'],$cat['olErr'],(($cat['tsHrs'] * 60) + $cat['tsMin']),$cat['tsFix'],$cat['appro'],$cat['daybg'],$cat['color'],$cat['bgrnd'],$cat['chBox'],$cat['chLab'],$cat['chMrk'],$cat['subN1'],$cat['subC1'],$cat['subB1'],$cat['subN2'],$cat['subC2'],$cat['subB2'],$cat['subN3'],$cat['subC3'],$cat['subB3'],$cat['subN4'],$cat['subC4'],$cat['subB4'],$cat['urlLN'],$cat['id']));
		$count = $stH-&gt;rowCount();
		if (!$count) { $msg = &quot;Database Error: {$ax['cat_not_updated']}&quot;; break; }
		//renumber sequence
		$stH = dbQuery(&quot;SELECT `ID` FROM `categories` WHERE `status` &gt;= 0 ORDER BY `sequence`&quot;);
		$rowArray = $stH-&gt;fetchAll(PDO::FETCH_ASSOC);
		$stH = null;
		$stH = stPrep(&quot;UPDATE `categories` SET `sequence` = ? WHERE `ID` = ?&quot;);
		$count = 1;
		foreach ($rowArray as $row) {
			if ($row['ID'] != $cat['id']) {
				if ($count == $cat['sqnce']) { $count++; }
				stExec($stH,array($count++,$row['ID']));
			}
		}
		$msg = $ax['cat_updated'];
		$mode = '';
	} while (false);
	return $msg;
}

function deleteCat($cat) { //delete category
	global $ax;
	
	$stH = stPrep(&quot;UPDATE `categories` SET `sequence` = 0, `status` = -1 WHERE `ID` = ?&quot;);
	stExec($stH,array($cat['id']));
	$count = $stH-&gt;rowCount();
	if (!$count) {
		$msg = &quot;Database Error: {$ax['cat_not_deleted']}&quot;;
	} else {
		$msg = $ax['cat_deleted'];
		//renumber sequence
		$stH = dbQuery(&quot;SELECT `ID` FROM `categories` WHERE `status` &gt;= 0 ORDER BY `sequence`&quot;);
		$rowArray = $stH-&gt;fetchAll(PDO::FETCH_ASSOC);
		$stH = null;
		$stH = stPrep(&quot;UPDATE `categories` SET `sequence` = ? WHERE `ID` = ?&quot;);
		$count = 1;
		foreach ($rowArray as $row) {
			stExec($stH,array($count++,$row['ID']));
		}
	}
	return $msg;
}

//Control logic
if ($usr['privs'] &gt;= 4) { //manager or admin
	$msg = '';
	if (isset($_POST['addExe'])) {
		$msg = addCat($cat);
	} elseif (isset($_POST['updExe'])) {
		$msg = updateCat($cat);
	} elseif (isset($_POST['delExe'])) {
		$msg = deleteCat($cat);
	}
	echo &quot;&lt;p class='error'&gt;{$msg}&lt;/p&gt;
		&lt;div class='scrollBoxAd'&gt;
		&lt;div class='centerBox'&gt;\n&quot;;
	if ($mode == 'sort') {
		sortCategories(); //sort on name
	}
	if (($mode != 'add' and $mode != 'edit') or isset($_POST['back'])) {
		showCategories(false); //no add / no edit
	} else {
		editCategory($cat); //add or edit
		showCategories(true);
	}
	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>