//prepare selected Date
list($sy, $sm, $sd) = explode("-", $_SESSION['selectedDate']);
// get outlet maximum capacity
$maxC = maxCapacity();
// get Pax by timeslot
$resbyTime = reservationsByTime('pax');
$tblbyTime = reservationsByTime('tbl');
$_SESSION['passbyTime'] = reservationsByTime('pass');
// get availability by timeslot
$availability = getAvailability($resbyTime, $general['timeintervall']);
$tbl_availability = getAvailability($tblbyTime, $general['timeintervall']);
// some constants
$outlet_name = querySQL('db_outlet');
// translate to selected language
$_SESSION['language'] = $language;
translateSite(substr($language, 0, 2), '../web/');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<html lang="<?php
echo $language;
?>
">
<head>
<meta http-equiv=pragma content=no-cache/>
<meta http-equiv=cache-control content=no-cache/>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=8" />
<!-- Meta data for SEO -->
//$_SESSION['language'] = ($_SESSION['language']!='') ? $_SESSION['language'] : 'en_EN';
// Check for a unique username
// ** set configuration
include '../config/config.general.php';
// ** database functions
include 'classes/database.class.php';
// ** connect to database
include 'classes/connect.db.php';
// ** all database queries
include 'classes/db_queries.db.php';
// ** localization functions
include 'classes/local.class.php';
// ** set configuration
include '../config/config.inc.php';
// translate to selected language
translateSite();
// prevent dangerous input
secureSuperGlobals();
$_SESSION['confHash'] = $_GET['c'];
$errorMessage = "";
$validCount = 0;
//check confirmation hash with the database
$result = querySQL('check_confirm_code');
//print_r($result);
//$validCount = mysql_num_rows($result);
if ($result['active'] == 1) {
$errorMessage .= _errorMessage_all;
}
if (!$result) {
$errorMessage .= _errorMessage_no;
}
// ** business functions
require 'includes/business.class.php';
// ** database functions
include '../web/classes/database.class.php';
// ** localization functions
include '../web/classes/local.class.php';
// ** business functions
include '../web/classes/business.class.php';
// ** connect to database
include '../web/classes/connect.db.php';
// ** all database queries
include '../web/classes/db_queries.db.php';
// ** set configuration
include '../config/config.inc.php';
// translate to selected language
translateSite($_POST['email_type'], '../web/');
// ** get superglobal variables
include '../web/includes/get_variables.inc.php';
// ** get property info for logo path
$prp_info = querySQL('property_info');
// Get POST data
// outlet id
if (!$_SESSION['outletID']) {
$_SESSION['outletID'] = $_GET['outletID'] ? (int) $_GET['outletID'] : querySQL('standard_outlet');
} elseif ($_GET['id']) {
$_SESSION['outletID'] = (int) $_GET['id'];
} elseif ($_POST['id']) {
$_SESSION['outletID'] = (int) $_POST['id'];
}
// property id
if ($_GET['prp']) {
<?php
// ** set configuration
include '../../config/config.general.php';
// ** database functions
include '../classes/database.class.php';
// ** connect to database
include '../classes/connect.db.php';
// ** all database queries
include '../classes/db_queries.db.php';
// ** set configuration
include '../../config/config.inc.php';
// ** localization functions
include '../classes/local.class.php';
// translate to selected language
translateSite(substr($_SESSION['language'], 0, 2), '../');
// prevent dangerous input
secureSuperGlobals();
$start_date = $_POST['s_dbdate'];
$end_date = $_POST['e_dbdate'];
$outlet_id = $_POST['outlet_id'];
$reservation_hotelguest_yn = $_POST['reservation_hotelguest_yn'];
//DEFINE SQL QUERY:
//you can use just about ANY kind of select statement you want -
//edit this to suit your needs!
$sql = "SELECT outlet_name, reservation_date, reservation_time, reservation_guest_name, reservation_pax, reservation_hotelguest_yn, reservation_notes, reservation_guest_adress, reservation_guest_city, reservation_guest_email,reservation_advertise, reservation_guest_phone \nFROM reservations INNER JOIN outlets ON (reservation_outlet_id = outlet_id) \nWHERE reservation_date >= '" . $start_date . "' AND reservation_date <= '" . $end_date . "' ";
if ($reservation_hotelguest_yn != '') {
$sql .= "AND reservation_hotelguest_yn = '" . $reservation_hotelguest_yn . "' ";
}
$sql .= "AND reservation_wait = 0 AND reservation_hidden = 0 AND reservation_outlet_id = '" . $outlet_id . "' ORDER BY reservation_guest_name ASC";
$result = query($sql);
$set_lang = substr($language, 0, 2);
$browser_lang = $_SERVER['HTTP_ACCEPT_LANGUAGE'];
if (isset($_GET['lang'])) {
$language = $_GET['lang'];
$_SESSION['lang'] = $language;
} else {
if (isset($browser_lang) && $_SESSION['lang'] == '' && ($browser_lang == "en" || $browser_lang == $set_lang)) {
$language = $browser_lang;
}
}
if ($_SESSION['lang'] == '') {
$_SESSION['lang'] = $language;
}
//$_SESSION['lang'] = 'en';
$lang = substr($_SESSION['lang'], 0, 2);
translateSite($lang, '../web/');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<html lang="<?php
echo $language;
?>
">
<head>
<!-- Meta data for SEO -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=8" />
<meta name="robots" content="follow,index,no-cache" />
<meta name="author" lang="en" content="Bernd Orttenburger [www.myseat.us]" />
