    <h3>/home/bparcsg/public_html/2018backup/bparcsite/bookingtest/pages/database.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/2018backup/bparcsite/bookingtest/pages/database.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
= LuxCal database 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)) { 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;;
require './common/toolboxx.php'; //admin tools

function mdbForm() {
	global $ax, $compact, $backup, $restore, $events, $delEvt, $fromD, $tillD, $lcI;
	
	$comChecked = $compact &gt; 0 ? &quot; checked&quot; : '';
	$bacChecked = $backup &gt; 0 ? &quot; checked&quot; : '';
	$resChecked = $restore &gt; 0 ? &quot; checked&quot; : '';
	$evtChecked = $events &gt; 0 ? &quot; checked&quot; : '';
	$delChecked = $delEvt &gt; 0 ? &quot; checked&quot; : '';
	$undChecked = !$delEvt &gt; 0 ? &quot; checked&quot; : '';
	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='2050000'&gt;
		&lt;fieldset&gt;\n
		&lt;legend&gt;{$ax['mdb_dbm_functions']}&lt;/legend&gt;\n
		&lt;br&gt;&lt;input type='checkbox' id='com' name='compact' value='yes'{$comChecked}&gt;&lt;label for='com'&gt; {$ax['mdb_compact']}&lt;/label&gt;&lt;br&gt;
		&lt;br&gt;&lt;input type='checkbox' id='bac' name='backup' value='yes'{$bacChecked}&gt;&lt;label for='bac'&gt; {$ax['mdb_backup']}&lt;/label&gt;&lt;br&gt;
		&lt;br&gt;&lt;input type='checkbox' id='res' name='restore' value='yes'{$resChecked}&gt;&lt;label for='res'&gt; {$ax['mdb_restore']}&lt;/label&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
		&lt;label&gt;{$ax['iex_file']}:&lt;/label&gt; &lt;input type='file' name='fName'&gt;&lt;br&gt;
		&lt;br&gt;&lt;input type='checkbox' id='evt' name='events' value='yes'{$evtChecked}&gt;&lt;label for='evt'&gt; {$ax['mdb_events']}&lt;/label&gt;: &amp;nbsp;&amp;nbsp;&amp;nbsp;
		&lt;input type='radio' id='del' name='delEvt' value='1'{$delChecked}&gt;&lt;label for='del'&gt; {$ax['mdb_delete']}&lt;/label&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;
		&lt;input type='radio' id='und' name='delEvt' value='0'{$undChecked}&gt;&lt;label for='und'&gt; {$ax['mdb_undelete']}&lt;/label&gt;\n&lt;br&gt;
		&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;{$ax['mdb_between_dates']}: &lt;input type='text' name='fromD' id='fromD' value='&quot;.IDtoDD($fromD).&quot;' size='8'&gt;
		&lt;span class='dtPick' title=\&quot;{$ax['iex_select_start_date']}\&quot; onclick=\&quot;dPicker(1,'nill','fromD');return false;\&quot;&gt;&amp;#x1F4C5;&lt;/span&gt; &amp;#8211;
		&lt;input type='text' name='tillD' id='tillD' value='&quot;.IDtoDD($tillD).&quot;' size='8'&gt;
		&lt;span class='dtPick' title=\&quot;{$ax['iex_select_end_date']}\&quot; onclick=\&quot;dPicker(1,'nill','tillD');return false;\&quot;&gt;&amp;#x1F4C5;&lt;/span&gt;
		&lt;/fieldset&gt;\n
		&lt;button type='submit' name='exe' value='y'&gt;{$ax['mdb_start']}&lt;/button&gt;\n
	&lt;/form&gt;\n&quot;;
}

function processFunctions() {
	global $ax, $compact, $backup, $restore, $events, $delEvt, $fromD, $tillD, $lcI;
	
	$fName = false;
	if ($compact) { compactDb(); }
	if ($backup) { $fName = backupTables(); }
	if ($restore) { restoreTables(); }
	if ($events) { delEvents($delEvt, $fromD, $tillD); }
	echo &quot;&lt;form action='index.php' method='post'&gt;
		&lt;input type='hidden' name='lcI' value='{$lcI}'&gt;
		&lt;input type='hidden' name='compact' id='compact' value='{$compact}'&gt;
		&lt;input type='hidden' name='backup' id='backup' value='{$backup}'&gt;
		&lt;input type='hidden' name='restore' id='restore' value='{$restore}'&gt;
		&lt;input type='hidden' name='events' id='events' value='{$events}'&gt;
		&lt;input type='hidden' name='delEvt' id='delEvt' value='{$delEvt}'&gt;
		&lt;input type='hidden' name='fromD' id='fromD' value='&quot;.IDtoDD($fromD).&quot;'&gt;
		&lt;input type='hidden' name='tillD' id='tillD' value='&quot;.IDtoDD($tillD).&quot;'&gt;
		&lt;button class='noPrint' type='submit' name='back' value='y'&gt;{$ax['back']}&lt;/button&gt;\n&quot;;
	if ($fName) {
		echo &quot;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;button class='noPrint' type='button' onclick=\&quot;location.href='dloader.php?ftd={$fName}&amp;amp;rName={$fName}'\&quot;&gt;{$ax['iex_download_file']}&lt;/button&gt;\n&quot;;
	}
	echo &quot;&lt;/form&gt;\n&quot;;
}


/* Compact database */
function compactDb() {
	global $ax, $dbType;
	
	echo &quot;&lt;fieldset&gt;&lt;legend&gt;{$ax['mdb_compact']}&lt;/legend&gt;\n&quot;;
	$deleteDT = date('Y-m-d H:i', time() - 86400*30); //remove if deleted more than 30 days ago
	//remove deleted events from db
	$stH = dbQuery(&quot;DELETE FROM `events` WHERE `status` = -1 and `mDateTime` &lt;= '{$deleteDT}'&quot;);
	echo &quot;{$ax['mdb_purge_done']}.&lt;br&gt;\n&quot;;		
	if ($dbType == 'SQLite') { //SQLite db
		$stH = dbQuery(&quot;VACUUM&quot;);
	} else { //MySQL db
		$stH = dbQuery('OPTIMIZE TABLE `'.implode('`,`',getTables()).'`');
	}
	if ($stH) {
		echo &quot;{$ax['mdb_compact_done']}.&lt;br&gt;\n&quot;;		
	} else {
		echo &quot;{$ax['mdb_compact_error']}.&lt;br&gt;\n&quot;;
	}
	echo &quot;&lt;/fieldset&gt;\n&quot;;
}

/* Backup db tables*/
function backupTables() {
	global $ax, $calID, $set, $lcV;
	
	echo &quot;&lt;fieldset&gt;&lt;legend&gt;{$ax['mdb_backup']}&lt;/legend&gt;\n&quot;;
	//get table names
	$tables = getTables();
	if (empty($tables)) {
		echo &quot;{$ax['mdb_noshow_tables']}\n&quot;;
		$result = false;
	} else {
		$sqlFile = backupDatabase($tables,true); //create backup file
		//save .sql dump file
		$fName = &quot;./files/{$calID}-dump-&quot;.date('Ymd-His').'.sql';
		echo &quot;&lt;br&gt;{$ax['mdb_file_name']}: &lt;strong&gt;{$fName}&lt;/strong&gt;&lt;br&gt;\n&quot;;
		if (file_put_contents($fName, $sqlFile) !== false) {
			echo &quot;{$ax['mdb_file_saved']}&lt;br&gt;\n&quot;;
			$result = basename($fName);
		} else {
			echo &quot;&lt;br&gt;&lt;br&gt;&lt;strong&gt;{$ax['mdb_write_error']}&lt;/strong&gt;&lt;br&gt;\n&quot;;
			$result = false;
		}
	}
	echo &quot;&lt;/fieldset&gt;\n&quot;;
	return $result;
}

/* Restore db tables */
function restoreTables() {
	global $ax, $calID, $lcV, $dbType;
	
	echo &quot;&lt;fieldset&gt;&lt;legend&gt;{$ax['mdb_restore']}&lt;/legend&gt;\n&quot;;
	do {
		if (empty($_FILES['fName']['tmp_name'])) {
			echo &quot;{$ax['mdb_noshow_restore']}\n&quot;; break; //abort restore
		}
		if (substr($_FILES['fName']['name'],-4) != '.sql') {
			echo &quot;{$ax['mdb_file_not_sql']}\n&quot;; break; //abort restore
		}
		$buFile = $_FILES['fName']['tmp_name']; //get backup file name
		//Read SQL queries from $buFile
		$sqlArray = file($buFile, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
		unlink($buFile);
		//check version of backup file
		foreach ($sqlArray as $qLine) { //search 1st comment block
			if ($qLine[0] != '-' or preg_match('~LuxCal version:\s*(\d.\d)~i',$qLine,$matches)) { break; }
		}
		if (!empty($matches) and $matches[1] != substr($lcV,0,3)) { //version found but not matching
			echo &quot;&lt;span class='hired'&gt;{$ax['mdb_no_bup_match']}&lt;/span&gt;&lt;br&gt;\n&quot;; break; //abort restore
		}
		echo &quot;{$ax['mdb_backup_file']}: '&lt;strong&gt;{$_FILES['fName']['name']}&lt;/strong&gt;'&lt;br&gt;&lt;br&gt;&quot;;
		$count = importSqlFile($sqlArray); //import SQL file
		upgradeDb(); //recreate db schema
		echo &quot;{$ax['mdb_restore_table']} 'events' - {$count['eve']} {$ax['mdb_inserted']}&lt;br&gt;
{$ax['mdb_restore_table']} 'users' - {$count['use']} {$ax['mdb_inserted']}&lt;br&gt;
{$ax['mdb_restore_table']} 'groups' - {$count['gro']} {$ax['mdb_inserted']}&lt;br&gt;
{$ax['mdb_restore_table']} 'categories' - {$count['cat']} {$ax['mdb_inserted']}&lt;br&gt;
{$ax['mdb_restore_table']} 'settings' - {$count['set']} {$ax['mdb_inserted']}&lt;br&gt;
{$ax['mdb_restore_table']} 'styles' - {$count['sty']} {$ax['mdb_inserted']}&lt;br&gt;\n&quot;;
		if ($count['cat'] &gt; 0 and $count['use'] &gt; 0 and $count['gro'] &gt; 0 and $count['set'] &gt; 0 and $count['sty'] &gt; 0) {
			echo &quot;&lt;br&gt;&lt;strong&gt;{$ax['mdb_db_restored']}&lt;/strong&gt;&lt;br&gt;\n&quot;;
		}
	} while (0); //end of: restore tables
	echo &quot;&lt;/fieldset&gt;\n&quot;;
}

/* (Un)delete events */
function delEvents($delEvt, $fromD, $tillD) {
	global $ax;
	
	$where = $delEvt ? &quot;WHERE `status` &gt;= 0 &quot; : &quot;WHERE `status` = -1 &quot;;
	if ($fromD) { $where .= &quot; AND `sDate` &gt;= '$fromD'&quot;; }
	if ($tillD) { $where .= &quot; AND (CASE WHEN `rType` &gt; 0 THEN `rUntil` ELSE CASE WHEN `eDate` LIKE '9%' THEN `sDate` ELSE `eDate` END END &lt;= '$tillD')&quot;; }
	if ($delEvt) {
		$stH = dbQuery(&quot;UPDATE `events` SET `status` = -1, `mDateTime` = '&quot;.date(&quot;Y-m-d H:i&quot;).&quot;' $where&quot;); //delete
	} else {
		$stH = dbQuery(&quot;UPDATE `events` SET `status` = 0, `mDateTime` = '&quot;.date(&quot;Y-m-d H:i&quot;).&quot;' $where&quot;); //undelete
	}
	$nrAffected = $stH-&gt;rowCount();
	echo &quot;&lt;fieldset&gt;&lt;legend&gt;{$ax['mdb_events']}&lt;/legend&gt;\n&quot;;
	echo ($delEvt ? $ax['mdb_deleted'] : $ax['mdb_undeleted']).&quot;: {$nrAffected}&quot;;
	echo &quot;&lt;/fieldset&gt;\n&quot;;
}

//init
$msg = '';
$compact = empty($_POST[&quot;compact&quot;]) ? 0 : 1;
$backup = empty($_POST[&quot;backup&quot;]) ? 0 : 1;
$restore = empty($_POST[&quot;restore&quot;]) ? 0 : 1;
$events = empty($_POST[&quot;events&quot;]) ? 0 : 1;
$delEvt = empty($_POST[&quot;delEvt&quot;]) ? 0 : 1;
$fromD = (isset($_POST['fromD'])) ? DDtoID($_POST['fromD']) : ''; //from event date
$tillD = (isset($_POST['tillD'])) ? DDtoID($_POST['tillD']) : ''; //untill event date
if ($fromD and $tillD and $fromD &gt; $tillD) {
	$temp = $fromD;
	$fromD = $tillD;
	$tillD = $temp;
}
$exe = !empty($_POST[&quot;exe&quot;]) ? 1 : 0;

//control logic
if ($usr['privs'] == 9) {
	if ($exe and (!$compact and !$backup and !$restore and !$events)) { $msg = $ax['mdb_no_function_checked'];	}
	echo &quot;&lt;p class='error'&gt;{$msg}&lt;/p&gt;
		&lt;div class='scrollBoxAd'&gt;\n&quot;;
	if (!$exe or (!$compact and !$backup and !$restore and !$events)) {
		echo &quot;&lt;aside class='aside'&gt;{$ax['xpl_manage_db']}&lt;/aside&gt;
			&lt;div class='centerBox'&gt;\n&quot;;
		mdbForm(); //manage db form
		echo &quot;&lt;/div&gt;\n&quot;;
	} else {
		echo &quot;&lt;div class='centerBox'&gt;\n&quot;;
		processFunctions();
		echo &quot;&lt;/div&gt;\n&quot;;
	}
	echo &quot;&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/bookingtest/pages">← Geri</a>