} 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); ?>