protected static function tearDownHttpMockAfterClass()
{
static::$staticHttp->each(static function (HttpMockFacade $facade) {
$facade->server->stop();
ServerManager::getInstance()->remove($facade->server);
});
}
function getMySQL($error = "")
{
if (!empty(Server::$Configuration->File["gl_db_host"])) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
$extension = !empty(Server::$Configuration->File["gl_db_ext"]) ? Server::$Configuration->File["gl_db_ext"] : "";
$error = ServerManager::ValidateDatabase(Server::$Configuration->File["gl_db_host"], Server::$Configuration->File["gl_db_user"], Server::$Configuration->File["gl_db_pass"], Server::$Configuration->File["gl_db_name"], Server::$Configuration->File["gl_db_prefix"], $extension, true, Server::$Configuration->File["gl_db_eng"]);
}
if (!function_exists("mysql_real_escape_string") && !function_exists("mysqli_real_escape_string")) {
$error = "MySQL PHP extension is not available.";
}
if (empty($error)) {
return null;
} else {
return "<span class=\"lz_index_error_cat\">MySQL:<br></span><span class=\"lz_index_red\">" . $error . "</span>";
}
}
function up_4012_4100($_prefix, $_link)
{
$commands[] = array(1146, "TRUNCATE TABLE `" . DBManager::RealEscape($_prefix) . "operators`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `groups` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `last_chat_allocation`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `groups_hidden` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `groups_status`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `fullname` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `login_id`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `fullname`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `fullname`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `permissions` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `email`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `webspace` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `permissions`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `languages` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `auto_accept_chats` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `login_ip_range` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `password_change` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `password`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `password_change_request` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `system_id` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `id`;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `websites_users` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `websites_config` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "operators` ADD `sign_off` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_goals` ADD `query` INT( 11 ) unsigned NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `dynamic` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `description` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `external` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `internal` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `created` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `standard` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `opening_hours` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `functions` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `chat_inputs_hidden` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `ticket_inputs_hidden` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `chat_inputs_required` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `ticket_inputs_required` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `max_chats` INT( 11 ) NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `hide_chat_group_selection` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `hide_ticket_group_selection` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "groups` ADD `visitor_filters` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$commands[] = array(1050, "CREATE TABLE IF NOT EXISTS `" . DBManager::RealEscape($_prefix) . "images` (`id` INT UNSIGNED NOT NULL DEFAULT '0',`online` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',`button_type` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`image_type` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`data` LONGTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`,`button_type`,`image_type`,`online`)) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_bin;");
$commands[] = array(1050, "CREATE TABLE IF NOT EXISTS `" . DBManager::RealEscape($_prefix) . "stats_aggs_goals_queries` (`year` smallint(5) unsigned NOT NULL DEFAULT '0',`month` tinyint(3) unsigned NOT NULL DEFAULT '0',`day` tinyint(3) unsigned NOT NULL DEFAULT '0',`goal` int(10) unsigned NOT NULL DEFAULT '0',`query` int(10) unsigned NOT NULL DEFAULT '0',`amount` int(10) unsigned NOT NULL DEFAULT '0',PRIMARY KEY (`year`,`month`,`day`,`goal`,`query`),KEY `target` (`goal`),KEY `query` (`query`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;");
$commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_browsers` ADD `pre_message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;");
$res = processCommandList($commands, $_link);
// import buttons
ServerManager::ImportButtons(LIVEZILLA_PATH . "banner/", $_prefix, $_link);
return $res;
}
<?php
if (!defined('MCR')) {
exit;
}
ob_start();
if (!empty($user)) {
if ($mode == 'control') {
include View::Get('side.html', 'admin/');
}
include View::Get('mini_profile.html');
} else {
if ($mode == 'register') {
$addition_events .= "BlockVisible('reg-box',true); BlockVisible('login-box',false);";
}
include View::Get('login.html');
}
$content_side .= ob_get_clean();
loadTool('monitoring.class.php');
$servManager = new ServerManager('serverstate/');
$content_servers = $servManager->Show('side');
unset($servManager);
public function ShowHolder($type = 'side', $server_prefix = '')
{
if (!ServerManager::getPageName($type)) {
return false;
}
ob_start();
$server_name = $this->name;
$server_info = $this->info;
// this->address - фактический адресс
$server_id = $this->id;
$server_pid = $server_prefix . $server_id;
$server_numpl = $this->numpl;
$server_slots = $this->slots;
if ((int) $this->slots != -1) {
$server_pl_inf = $this->numpl . '/' . $this->slots;
} else {
$server_pl_inf = $this->numpl;
}
switch ($type) {
case 'mon':
case 'side':
include $this->GetView('serverstate_' . $type . '.html');
break;
case 'game':
if ($this->online) {
include $this->GetView('serverstate_' . $type . '_online.html');
} else {
include $this->GetView('serverstate_' . $type . '_offline.html');
}
break;
default:
return false;
break;
}
return ob_get_clean();
}
}
}
}
}
}
}
}
}
}
}
} else {
Server::$Response->SetValidationError(AUTH_RESULT);
}
if (OperatorRequest::IsValidated() && !SERVERSETUP) {
if (LOGOFF || LOGIN) {
if (LOGOFF) {
Server::$Operators[CALLER_SYSTEM_ID]->GetExternalObjects();
}
Server::$Operators[CALLER_SYSTEM_ID]->Reposts = array();
}
Server::$Operators[CALLER_SYSTEM_ID]->Save();
}
if (LOGIN && DB_ACCESS_REQUIRED) {
require LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php";
$extension = !empty(Server::$Configuration->File["gl_db_ext"]) ? Server::$Configuration->File["gl_db_ext"] : "";
$res = ServerManager::ValidateDatabase(Server::$Configuration->File["gl_db_host"], Server::$Configuration->File["gl_db_user"], Server::$Configuration->File["gl_db_pass"], Server::$Configuration->File["gl_db_name"], Server::$Configuration->File["gl_db_prefix"], $extension, false, Server::$Configuration->File["gl_db_eng"]);
if (!empty($res)) {
Server::$Response->SetValidationError(LOGIN_REPLY_DB, $res);
}
}
$response = Server::$Response->GetXML(true);
static function UpdateConfiguration($id = 0)
{
if (OperatorRequest::IsValidated() && Is::Defined("VALIDATED_FULL_LOGIN") && OperatorRequest::IsAdministrator(true)) {
Logging::SecurityLog("ServerManager::UpdateConfiguration", "", CALLER_SYSTEM_ID);
if (Is::Defined("STATS_ACTIVE") && !empty($_POST["p_reset_stats"])) {
Server::$Statistic->ResetAll();
}
$int = 0;
if (DB_CONNECTION) {
DBManager::Execute(true, "UPDATE `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_TYPES . "` SET `delete`='1';");
DBManager::Execute(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;
DBManager::Execute(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;
DBManager::Execute(true, "DELETE FROM `" . DB_PREFIX . DATABASE_MAILBOXES . "`;");
while (!empty($_POST["p_cfg_es_i_" . $int])) {
$acc = new Mailbox($int, true);
$acc->Save();
$int++;
}
$int = 0;
DBManager::Execute(true, "DELETE FROM `" . DB_PREFIX . DATABASE_FEEDBACK_CRITERIA_CONFIG . "`;");
while (isset($_POST["p_cfg_fc_i_" . $int])) {
$fc = new FeedbackCriteria($int, true);
$fc->Save();
$int++;
}
DBManager::Execute(true, "DELETE FROM `" . DB_PREFIX . DATABASE_COMMERCIAL_CHAT_TYPES . "` WHERE `delete`='1';");
DBManager::Execute(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);
DBManager::Execute(true, "REPLACE INTO `" . DB_PREFIX . DATABASE_CONFIG . "` (`key`,`value`) VALUES ('" . DBManager::RealEscape($skey) . "','" . DBManager::RealEscape($value) . "');");
}
}
CacheManager::Flush();
}
if (isset($_POST["p_available"])) {
ServerManager::UpdateAvailability(!empty($_POST["p_available"]));
}
//$id = IOStruct::CreateFile($file,base64_decode($_POST["p_upload_value"]),true);
}
GeoTracking::SpanRemove(true);
CacheManager::Flush();
Server::$Response->SetStandardResponse($id, "");
}
protected static function tearDownHttpMockAfterClass()
{
static::$staticHttp->server->stop();
ServerManager::getInstance()->remove(static::$staticHttp->server);
}
<?php
header('Content-Type: text/html;charset=UTF-8');
require '../system.php';
loadTool('user.class.php');
loadTool('monitoring.class.php');
loadTool('catalog.class.php');
DBinit('news');
$news = '';
$page_title = 'Новостная лента';
$news_manager = new NewsManager($config['game_news'], 'launcher/news/', $config['s_root'] . 'index.php?');
$curlist = Filter::input('l', 'get', 'int');
if ($curlist <= 0) {
$curlist = 1;
}
$news = $news_manager->ShowNewsListing($curlist);
$servManager = new ServerManager('launcher/serverstate/');
$server_state_html = $servManager->Show('game');
unset($servManager);
include View::Get('index.html', 'launcher/');
