//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]" />