} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_CREATE_TABLES) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
createTables();
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_SET_MANAGEMENT) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
setManagement();
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_SET_CONFIG) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
setConfig();
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_SET_AVAILABILITY) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
setAvailability($_POST[POST_INTERN_SERVER_AVAILABILITY]);
}
}
}
}
}
}
}
}
}
}
}
}
}
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_GET_BANNER_LIST) {
function setConfig($id = 0)
{
global $INTERNAL, $RESPONSE, $STATS;
if (SERVERSETUP && $INTERNAL[CALLER_SYSTEM_ID]->Level == USER_LEVEL_ADMIN) {
if (STATS_ACTIVE && isset($_POST[POST_INTERN_RESET_STATS]) && $_POST[POST_INTERN_RESET_STATS] == "1") {
$STATS->ResetAll();
}
$id = createFile(FILE_CONFIG, base64_decode($_POST[POST_INTERN_UPLOAD_VALUE]), true);
if (isset($_POST[POST_INTERN_SERVER_AVAILABILITY])) {
setAvailability($_POST[POST_INTERN_SERVER_AVAILABILITY]);
}
if (isset($_POST[POST_INTERN_FILE_CARRIER_LOGO]) && strlen($_POST[POST_INTERN_FILE_CARRIER_LOGO]) > 0) {
base64ToFile(FILE_CARRIERLOGO, $_POST[POST_INTERN_FILE_CARRIER_LOGO]);
} else {
if (isset($_POST[POST_INTERN_FILE_CARRIER_LOGO]) && file_exists(FILE_CARRIERLOGO)) {
@unlink(FILE_CARRIERLOGO);
}
}
if (isset($_POST[POST_INTERN_FILE_CARRIER_HEADER]) && strlen($_POST[POST_INTERN_FILE_CARRIER_HEADER]) > 0) {
base64ToFile(FILE_CARRIERHEADER, $_POST[POST_INTERN_FILE_CARRIER_HEADER]);
} else {
if (isset($_POST[POST_INTERN_FILE_CARRIER_HEADER]) && file_exists(FILE_CARRIERHEADER)) {
@unlink(FILE_CARRIERHEADER);
}
}
if (isset($_POST[POST_INTERN_FILE_INVITATION_LOGO]) && strlen($_POST[POST_INTERN_FILE_INVITATION_LOGO]) > 0) {
base64ToFile(FILE_INVITATIONLOGO, $_POST[POST_INTERN_FILE_INVITATION_LOGO]);
} else {
if (isset($_POST[POST_INTERN_FILE_INVITATION_LOGO]) && file_exists(FILE_INVITATIONLOGO)) {
@unlink(FILE_INVITATIONLOGO);
}
}
$int = 1;
while (isset($_POST[POST_INTERN_DOWNLOAD_TRANSLATION_ISO . "_" . $int]) && strpos($_POST[POST_INTERN_DOWNLOAD_TRANSLATION_ISO . "_" . $int], "..") === false) {
if (!isset($_POST[POST_INTERN_DOWNLOAD_TRANSLATION_DELETE . "_" . $int])) {
createFile("./_language/lang" . strtolower($_POST[POST_INTERN_DOWNLOAD_TRANSLATION_ISO . "_" . $int]) . ".php", slashesStrip($_POST[POST_INTERN_DOWNLOAD_TRANSLATION_CONTENT . "_" . $int]), true);
} else {
@unlink("./_language/lang" . strtolower($_POST[POST_INTERN_DOWNLOAD_TRANSLATION_ISO . "_" . $int]) . ".php");
}
$int++;
}
}
removeSSpanFile(true);
setIdle(0);
$RESPONSE->SetStandardResponse($id, "");
}
<?php
session_start();
require '../DBcon.php';
$from = $_POST['from'];
$to = $_POST['to'];
$roomId = $_POST['roomid'];
$available = $_POST['available'];
$price = $_POST['price'];
$mystring = "room" . $roomId . "prices";
$counter = 0;
setAvailability($from, $to, $roomId, $available);
echo $available;
if ($available == 0) {
mysql_query("DELETE * FROM " . $mystring);
} else {
mysql_query("INSERT INTO `" . $mystring . "` (`From`,`To`,`Price`) VALUES('" . $from . "','" . $to . "','" . $price . "')");
}
$result = mysql_query("SELECT * FROM availability WHERE Dates >= '" . $from . "' AND Dates <= '" . $to . "'");
echo "<table class='reser' id='mytable' cellspacing='0' summary='The technical specifications of the Apple PowerMac G5 series';>";
echo "<tr>";
echo "<th scope='col' abbr='Configurations' class='nobg'>Dates</th>";
for ($i = 1; $i < mysql_num_fields($result); $i++) {
$meta = mysql_fetch_field($result, $i);
echo "<th scope='col'>";
echo "Room ID: " . $meta->name;
echo "</th>";
}
echo "</tr>";
while ($row = mysql_fetch_array($result)) {
echo "<tr id='row" . $counter . "'>";
function setConfig($id = 0)
{
global $INTERNAL, $RESPONSE, $STATS, $CONFIG;
administrationLog("setConfig", "", CALLER_SYSTEM_ID);
if (isValidated() && ($INTERNAL[CALLER_SYSTEM_ID]->Level == USER_LEVEL_ADMIN || in_array($CONFIG["gl_host"], $INTERNAL[CALLER_SYSTEM_ID]->WebsitesConfig))) {
if (is("STATS_ACTIVE") && !empty($_POST["p_reset_stats"])) {
$STATS->ResetAll();
}
$int = 0;
$file = ISSUBSITE || $INTERNAL[CALLER_SYSTEM_ID]->Level != USER_LEVEL_ADMIN ? str_replace("config.inc", "config." . SUBSITEHOST . ".inc", FILE_CONFIG) : FILE_CONFIG;
if (DB_CONNECTION && (!ISSUBSITE || file_exists($file))) {
queryDB(true, "UPDATE `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_TYPES . "` SET `delete`='1';");
queryDB(true, "DELETE FROM `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_LOCALIZATIONS . "`;");
while (!empty($_POST["p_cfg_cct_id_" . $int])) {
$cct = new CommercialChatBillingType($_POST["p_cfg_cct_id_" . $int], $_POST["p_cfg_cct_mnoc_" . $int], $_POST["p_cfg_cct_mtloc_" . $int], $_POST["p_cfg_cct_tae_" . $int], $_POST["p_cfg_cct_tvbo_" . $int], $_POST["p_cfg_cct_svbo_" . $int], $_POST["p_cfg_cct_evbo_" . $int], $_POST["p_cfg_cct_citl_" . $int], $_POST["p_cfg_cct_p_" . $int]);
$cct->Save();
$iint = 0;
while (!empty($_POST["p_cfg_cctli_id_" . $int . "_" . $iint])) {
$cctl = new CommercialChatVoucherLocalization($_POST["p_cfg_cctli_id_" . $int . "_" . $iint], $_POST["p_cfg_cctli_itl_" . $int . "_" . $iint], $_POST["p_cfg_cctli_t_" . $int . "_" . $iint], $_POST["p_cfg_cctli_d_" . $int . "_" . $iint], $_POST["p_cfg_cctli_terms_" . $int . "_" . $iint], $_POST["p_cfg_cctli_emvc_" . $int . "_" . $iint], $_POST["p_cfg_cctli_emvp_" . $int . "_" . $iint], $_POST["p_cfg_cctli_emvu_" . $int . "_" . $iint], $_POST["p_cfg_cctli_exr_" . $int . "_" . $iint]);
$cctl->Save($_POST["p_cfg_cct_id_" . $int]);
$iint++;
}
$int++;
}
$int = 0;
queryDB(true, "DELETE FROM `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_PROVIDERS . "`;");
while (!empty($_POST["p_cfg_ccpp_id_" . $int])) {
$ccpp = new CommercialChatPaymentProvider($_POST["p_cfg_ccpp_id_" . $int], $_POST["p_cfg_ccpp_n_" . $int], $_POST["p_cfg_ccpp_a_" . $int], $_POST["p_cfg_ccpp_u_" . $int], $_POST["p_cfg_ccpp_l_" . $int]);
$ccpp->Save();
$int++;
}
$int = 0;
queryDB(true, "DELETE FROM `" . DB_PREFIX . DATABASE_MAILBOXES . "`;");
while (!empty($_POST["p_cfg_es_i_" . $int])) {
$acc = new Mailbox($int, true);
$acc->Save();
$int++;
}
queryDB(true, "DELETE FROM `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_TYPES . "` WHERE `delete`='1';");
queryDB(true, "DELETE FROM `" . DB_PREFIX . DATABASE_CONFIG . "`;");
foreach ($_POST as $key => $value) {
if (strpos($key, "p_cfg_g_") === 0) {
$skey = str_replace("p_cfg_g_", "", $key);
$value = base64_decode($value);
queryDB(true, "REPLACE INTO `" . DB_PREFIX . DATABASE_CONFIG . "` (`key`,`value`) VALUES ('" . DBManager::RealEscape($skey) . "','" . DBManager::RealEscape($value) . "');");
}
}
}
if (isset($_POST["p_available"])) {
setAvailability(!empty($_POST["p_available"]));
}
$id = createFile($file, base64_decode($_POST["p_upload_value"]), true);
$int = 1;
$delete = false;
while (isset($_POST["p_int_trans_iso_" . $int]) && strpos($_POST["p_int_trans_iso_" . $int], "..") === false) {
$file = getLocalizationFileString($_POST["p_int_trans_iso_" . $int], false);
if (!isset($_POST["p_int_trans_delete_" . $int])) {
createFile($file, $_POST["p_int_trans_content_" . $int], true);
} else {
$delete = true;
if (file_exists($file)) {
@unlink($file);
}
if (empty($CONFIG["gl_root"])) {
createFile($file, "", true);
}
}
$int++;
}
if (!$delete && (!@file_exists($file) || @file_exists($file) && @filemtime($file) !== false && @filemtime($file) < time() - 10)) {
header("HTTP/1.1 502 Bad Gateway");
exit("HTTP/1.1 502 Bad Gateway");
}
}
removeSSpanFile(true);
setIdle(0);
$RESPONSE->SetStandardResponse($id, "");
}
$capacity = $_POST['capacity'];
mysql_query("INSERT INTO rooms (id,type,description ,capacity ) VALUES('" . $id . "','" . $type . "','" . $description . "','" . $capacity . "')");
mysql_query("ALTER TABLE `availability` ADD `" . $id . "` VARCHAR( 4 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0'");
mysql_query("CREATE TABLE `room" . $id . "prices` (`From` DATE NOT NULL ,`To` DATE NOT NULL ,`Price` DOUBLE NOT NULL)");
if ($_POST['From']) {
$i = 0;
while (isset($_POST['From'][$i])) {
$From[$i] = $_POST['From'][$i];
$To[$i] = $_POST['To'][$i];
$Available[$i] = $_POST['Available'][$i];
$Price[$i] = $_POST['Price'][$i];
$i = $i + 1;
}
$counter = $i;
for ($k = 0; $k < $counter; $k++) {
setAvailability($From[$k], $To[$k], $id, $Available[$k]);
$mystring = "room" . $id . "prices";
mysql_query("INSERT INTO `" . $mystring . "` (`From`,`To`,`Price`) VALUES('" . $From[$k] . "','" . $To[$k] . "','" . $Price[$k] . "')");
}
echo "Success!!";
} else {
}
function setAvailability($DayFrom, $DayTo, $IDroom, $Available)
{
$myDates = array();
$sql = "SELECT Dates FROM availability WHERE Dates >= '" . $DayFrom . "' AND Dates <= '" . $DayTo . "'";
$result = mysql_query($sql);
$j = 0;
while ($row = mysql_fetch_array($result)) {
$dates[$j] = $row['Dates'];
$j++;
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
if (createTables()) {
setManagement($_POST[POST_INTERN_DATABASE_PREFIX], true);
}
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_SET_MANAGEMENT) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
setManagement(DB_PREFIX);
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_SET_CONFIG) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
setConfig();
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_SET_AVAILABILITY) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
setAvailability($_POST["p_available"]);
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_DOWNLOAD_TRANSLATION) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
getTranslationData();
} else {
if ($_POST[POST_INTERN_SERVER_ACTION] == INTERN_ACTION_GET_BANNER_LIST) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
getBannerList();
}
}
}
}
}
}
}
function setConfig($id = 0)
{
global $INTERNAL, $RESPONSE;
if (SERVERSETUP) {
$id = createFile(FILE_CONFIG, base64_decode($_POST[POST_INTERN_UPLOAD_VALUE]), true);
if (isset($_POST[POST_INTERN_SERVER_AVAILABILITY])) {
setAvailability($_POST[POST_INTERN_SERVER_AVAILABILITY]);
}
if (isset($_POST[POST_INTERN_FILE_CARRIER_LOGO]) && strlen($_POST[POST_INTERN_FILE_CARRIER_LOGO]) > 0) {
base64ToFile(FILE_CARRIERLOGO, $_POST[POST_INTERN_FILE_CARRIER_LOGO]);
} else {
if (isset($_POST[POST_INTERN_FILE_CARRIER_LOGO]) && file_exists(FILE_CARRIERLOGO)) {
@unlink(FILE_CARRIERLOGO);
}
}
if (isset($_POST[POST_INTERN_FILE_INVITATION_LOGO]) && strlen($_POST[POST_INTERN_FILE_INVITATION_LOGO]) > 0) {
base64ToFile(FILE_INVITATIONLOGO, $_POST[POST_INTERN_FILE_INVITATION_LOGO]);
} else {
if (isset($_POST[POST_INTERN_FILE_INVITATION_LOGO]) && file_exists(FILE_INVITATIONLOGO)) {
@unlink(FILE_INVITATIONLOGO);
}
}
}
removeSSpanFile(true);
setIdle(0);
$RESPONSE->SetStandardResponse($id, "");
}
<?php
require "set_ava.php";
require "makeyear.php";
setAvailability("2013-12-02", "2013-12-22", 1, 18);
?>
