    <h3>/home/bparcsg/public_html/bookingtest/common/toolboxd.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/bparcsg/public_html/bookingtest/common/toolboxd.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/*
=== DATABASE RELATED FUNCTIONS - MYSQL ===

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
*/

//Current LuxCal version
define(&quot;LCV&quot;,&quot;4.7.2M&quot;);

//Connect to database
function dbConnect($calID,$exitOnError=1) {
	global $dbHost, $dbUnam, $dbPwrd, $dbName;
	
	try {
		$dbH = new PDO(&quot;mysql:host={$dbHost};dbname={$dbName};charset=utf8&quot;,$dbUnam,$dbPwrd);
		$dbH-&gt;setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
		$stH = $dbH-&gt;query(&quot;SHOW TABLES LIKE '{$calID}\_%'&quot;);
		if ($exitOnError and !$row = $stH-&gt;fetch(PDO::FETCH_NUM)) {
			exit(&quot;Calendar '{$calID}' not found.&quot;);
		}
	}
	catch(PDOException $e) {
		if ($exitOnError) {
			logMessage('sql',1,&quot;Database connection error: &quot;.$e-&gt;getMessage());
			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, $calID;

	$query = preg_replace(&quot;~(\s`)(events|groups|users|categories|settings|styles)~&quot;,&quot;$1{$calID}_$2&quot;,$query); //use calendar with calID
	try {
		$stH = $dbH-&gt;query($query);
	}
	catch (PDOException $e) {
		if ($logError) {
			logMessage('sql',1,&quot;SQL query error: &quot;.$e-&gt;getMessage().&quot;\nQuery string: {$query}&quot;);
			exit(&quot;SQL error. See 'logs/sql.log'&quot;);
		} else {
			return false; //error
		}
	}
	return $stH; //result statement handle
}

//Begin / commit 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) {
			logMessage('sql',1,&quot;SQL transaction error: &quot;.$e-&gt;getMessage().&quot;\nQuery: {$action} transaction&quot;);
			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, $calID;

	$query = preg_replace(&quot;~(\s`)(events|groups|users|categories|settings|styles)~&quot;,&quot;$1{$calID}_$2&quot;,$query); //use calendar with calID
	try {
		$stH = $dbH-&gt;prepare($query);
	}
	catch (PDOException $e) {
		if ($logError) {
			logMessage('sql',1,&quot;SQL prepare error: &quot;.$e-&gt;getMessage().&quot;\nQuery string: {$query}&quot;);
			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) {
			logMessage('sql',1,&quot;SQL execute error: &quot;.$e-&gt;getMessage().&quot;\nValues string: &quot;.implode(',',$values));
			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;SHOW CREATE TABLE `{$table}`&quot;);
	$sqlCode = $stH-&gt;fetch(PDO::FETCH_NUM);
	$stH = null; //release statement handle!
	return $sqlCode[1];
}

function getTables($like='%') { //get array with db tables
	global $calID;
	
	$tables = array();
	$stH = dbQuery(&quot;SHOW TABLES LIKE '{$calID}\_{$like}'&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;
}

function getCIDs() { //get array with installed calendar IDs
	$cals = array();
	$stH = dbQuery(&quot;SHOW TABLES LIKE '%\_events'&quot;); //get events table names
	while ($row = $stH-&gt;fetch(PDO::FETCH_NUM)) {
		$cals1[] = substr($row[0],0,-7); //extract calendar ID (table prefix)
	}
	$stH = dbQuery(&quot;SHOW TABLES LIKE '%\_settings'&quot;); //get settings table names
	while ($row = $stH-&gt;fetch(PDO::FETCH_NUM)) {
		$cals2[] = substr($row[0],0,-9); //extract calendar ID (table prefix)
	}
	$stH = null; //release statement handle!
	return array_intersect($cals1,$cals2);
}

function getCals() { //get array with installed calendar ID/title pairs
	global $dbH;

	$curCals = array();
	if (isset($dbH)) { //connected to db
		$cals = getCIDs(); //get calendar IDs
		foreach ($cals as $id) {
			if ($stH = dbQuery(&quot;SELECT `value` FROM {$id}_settings WHERE `name` = 'calendarTitle'&quot;,0)) {
				$row = $stH-&gt;fetch(PDO::FETCH_NUM);
				$stH = null; //release statement handle!
				if (!empty($row)) { //found
					$curCals[$id] = $row[0]; //add calendar title
				}
			}
		}
	}
	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/bookingtest/common">← Geri</a>