$id = $DB->selectCell("SELECT `id` FROM `realmlist` ORDER BY `name`"); $_GET['realm'] = $id; } } if ($_GET['realm']) { $realm_info = get_realm_byid($_GET['realm']); $pathway_info[] = array('title' => $realm_info['name'], ''); $cc = 0; $rid = $realm_info['cloneid'] == -1 ? $realm_info['id'] : $realm_info['cloneid']; $rrealm_info = get_realm_byid($rid); AddMangosFields($rrealm_info['Version']); $charinfo_link = $rrealm_info['WowdCharInfoLink']; $faction_alliance = 0; $faction_horde = 0; $total = 0; if (check_port_status($rrealm_info['address'], $rrealm_info['port']) !== true) { output_message('alert', 'Realm <b>' . $rrealm_info['name'] . '</b> is offline <img src="images/downarrow2.gif" border="0" align="top">'); } else { if (!$rrealm_info['CharacterDatabaseInfo']) { output_message('alert', 'Check field <u>CharacterDatabaseInfo</u> in table `realmlist` for realm id=' . $realm_info['id']); } $wsdb_info = parse_worlddb_info($rrealm_info['CharacterDatabaseInfo']); if ($DB) { $query = $DB->select("SELECT c.*, a.* FROM " . $wsdb_info['db'] . ".`characters` as c, `account` as a \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE ((c.`online`='1') AND (c.`account`=a.`id`)) \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY c.`name`"); } $faction_alliance = 0; $faction_horde = 0; $total = 0; foreach ($query as $result) { if ($res_color == 1) { $res_color = 2;
$mangosALL = array('db_type' => 'mysql', 'db_host' => $realm_data_explode['3'], 'db_port' => $realm_data_explode['2'], 'db_username' => $realm_data_explode['0'], 'db_password' => $realm_data_explode['1'], 'db_name' => $realm_data_explode['4'], 'db_char' => $realm_data_explode['5'], 'db_encoding' => 'utf8'); unset($realm_data_explode); if ((int) $MW->getConfig->generic->use_alternate_mangosdb_port) { $mangosALL['db_port'] = (int) $MW->getConfig->generic->use_alternate_mangosdb_port; } $CHDB_EXTRA = DbSimple_Generic::connect("" . $mangosALL['db_type'] . "://" . $mangosALL['db_username'] . ":" . $mangosALL['db_password'] . "@" . $mangosALL['db_host'] . ":" . $mangosALL['db_port'] . "/" . $mangosALL['db_char'] . ""); if ($CHDB_EXTRA) { $CHDB_EXTRA->query("SET NAMES " . $mangosALL['db_encoding']); } unset($mangosALL); // Free up memory. $server = array(); $server['name'] = $data['name']; if ((int) $MW->getConfig->components->server_information->realm_status) { $checkaddress = (int) $MW->getConfig->generic->use_local_ip_port_test ? '127.0.0.1' : $data['address']; $server['realm_status'] = check_port_status($checkaddress, $data['port']) === true ? true : false; } $changerealmtoparam = array("changerealm_to" => $realmnow_arr['id']); if ((int) $MW->getConfig->components->server_information->online) { $server['playersonline'] = $CHDB_EXTRA->selectCell("SELECT count(1) FROM `characters` WHERE online=1"); $server['onlineurl'] = mw_url('server', 'playersonline', $changerealmtoparam); } if ((int) $MW->getConfig->components->left_section->Playermap) { $server['playermapurl'] = mw_url('server', 'playermap', $changerealmtoparam); } if ((int) $MW->getConfig->components->server_information->server_ip) { $server['server_ip'] = $data['address']; } if ((int) $MW->getConfig->components->server_information->type) { $server['type'] = $realm_type_def[$data['icon']]; }
<?php if (INCLUDED !== true) { exit; } // ==================== // $pathway_info[] = array('title' => 'GM Ticket Manager', 'link' => 'index.php?n=admin&sub=tickets'); // ==================== // ?> <?php $MANG = new Mangos(); $query = array(); $realm_info_new = get_realm_byid($user['cur_selected_realmd']); $cc = 0; if (!check_port_status($realm_info_new['address'], $realm_info_new['port']) === true) { output_message('alert', 'Realm <b>' . $realm_info_new['name'] . '</b> is offline <img src="templates/offlike/images/downarrow2.gif" border="0" align="top">'); } $action = array(); if ($project == "trinity") { $action = $CHDB->select("SELECT `guid`, `playerGuid`, `name`, `message`,`comment`, `assignedto` FROM `gm_tickets` WHERE `closed` = '0' ORDER BY `guid` "); $ticket = array(); $cc1 = 0; $result1 = array(); if (count($action) > 0) { foreach ($action as $result1) { if ($color == 1) { $color = 2; } else { $color = 1; }
if ($WSDB_EXTRA) { $WSDB_EXTRA->query("SET NAMES " . $mangosALL['db_encoding']); } $CHDB_EXTRA = DbSimple_Generic::connect("" . $mangosALL['db_type'] . "://" . $mangosALL['db_username'] . ":" . $mangosALL['db_password'] . "@" . $mangosALL['db_host'] . ":" . $mangosALL['db_port'] . "/" . $mangosALL['db_char'] . ""); if ($CHDB_EXTRA) { $CHDB_EXTRA->query("SET NAMES " . $mangosALL['db_encoding']); } $population = 0; if ($res_color == 1) { $res_color = 2; } else { $res_color = 1; } $realm_type = $realm_type_def[$result['icon']]; $realm_num = $result['id']; if (check_port_status($result['address'], $result['port']) === true) { $res_img = './templates/WotLK/images/uparrow2.gif'; if ($WSDB_EXTRA && $CHDB_EXTRA) { $population = $CHDB_EXTRA->selectCell("SELECT count(*) FROM `characters` WHERE online=1"); $uptime = time() - $DB->selectCell("SELECT starttime FROM uptime WHERE `realmid`='{$realm_num}' ORDER BY `starttime` DESC LIMIT 1"); } } else { $res_img = './templates/WotLK/images/downarrow2.gif'; $population_str = 'n/a'; $uptime = 0; } $items[$i]['res_color'] = $res_color; $items[$i]['img'] = $res_img; $items[$i]['name'] = $result['name']; $items[$i]['type'] = $realm_type; $items[$i]['pop'] = $population;
$CHDB = DbSimple_Generic::connect("" . $config['db_type'] . "://" . $CHDB_info['user'] . ":" . $CHDB_info['password'] . "@" . $CHDB_info['host'] . ":" . $CHDB_info['port'] . "/" . $CHDB_info['db'] . ""); if ($CHDB) { $CHDB->setErrorHandler('databaseErrorHandler'); } if ($CHDB) { $CHDB->query("SET NAMES " . $config['db_encoding']); } $error = false; $reason = 'You guilty'; $bantime = '30d'; $address = $realm_info['address']; $raport = $realm_info['raport']; if (check_port_status($realm_info['address'], $realm_info['port']) !== true) { // если сервер остановлен } else { if (check_port_status($address, $raport) !== true) { output_message('alert', ' Реалм <b>' . $realm_info['name'] . '</b> выключен либо не возможно соединится на порт RA <img src="images/downarrow2.gif" border="0" align="top">'); $error = true; } else { $result = $_POST['result']; $myuser = $user['username']; $rurl = str_replace("&", "_and_", $_SERVER["REQUEST_URI"]); if ($result) { $resultmsg = $_POST['resultmsg']; $mypass = $_POST['mypass']; $action = $_POST['action']; $type = $_POST['type']; $typeval = $_POST['typeval']; $reason = $_POST['reason']; $bantime = $_POST['bantime']; //Logs
// Establish the World DB connection $WDB_EXTRA = new Database($Realm_DB_Info['w_db_host'], $Realm_DB_Info['w_db_port'], $Realm_DB_Info['w_db_username'], $Realm_DB_Info['w_db_password'], $Realm_DB_Info['w_db_name']); // Free up memory unset($Realm_DB_Info); // $res_color is a template thing for blizzlike templates, // makes each row an offset color from the previous if ($res_color == 1) { $res_color = 2; } else { $res_color = 1; } // Define the realm type, and realm number $realm_type = $realm_type_def[$result['icon']]; $realm_num = $result['id']; // Check the realm status using the check_port_status function if (check_port_status($result['address'], $result['port'], 2) == TRUE) { // res image is the up arrow pretty much $res_img = 'Online'; // Get the server population $population = $CDB_EXTRA->count("SELECT COUNT(*) FROM `characters` WHERE online=1"); // Get the server uptime $start_time = $DB->selectCell("SELECT `starttime` FROM `uptime` WHERE `realmid`='" . $realm_num . "' ORDER BY `starttime` DESC LIMIT 1"); $uptime = time() - $start_time; } else { // Get the result image arrow $res_img = 'Offline'; $population = 0; $uptime = 0; } // Convert uptime into a days / hours / minutes format if ($uptime != 0) {
function completeOrder() { global $RA, $user, $DB, $WDB, $package, $lang; // Lets check to see if the realm is online before starting $realm = get_realm_byid($GLOBALS['cur_selected_realm']); if (!check_port_status($realm['address'], $realm['port'], 3)) { output_message('error', $lang['shop_realm_offline']); return FALSE; } // Second check to see if the user has enough points if ($package['wp_cost'] > $user['web_points']) { output_message('validation', $lang['not_enough_points']); return FALSE; } // Initiate the command array $command = array(); // If there is an item number for the selected package if ($package['item_number'] != 0) { $item_array = ''; $package_array = explode(',', $package['item_number']); foreach ($package_array as $a) { $item_array .= $a . ":" . $package['quanity'] . " "; } $command[] = "send items " . $_POST['char'] . " \"" . $lang["shop_mail_subject"] . "\" \"" . $lang["shop_mail_message"] . "\" " . $item_array; } // If there is an itemset for this package, we need to make a command for that as well if ($package['itemset'] != 0) { $qray = $WDB->select("SELECT `entry` FROM `item_template` WHERE `itemset`='" . $package['itemset'] . "'"); $items = ''; foreach ($qray as $d) { $items .= $d['entry'] . ":1 "; } $command[] = "send items " . $_POST['char'] . " \"" . $lang["shop_mail_subject"] . "\" \"" . $lang["shop_mail_message"] . "\" " . $items; } // If there is gold in this package, make a command for that if ($package['gold'] != 0) { $command[] = "send money " . $_POST['char'] . " \"" . $lang["shop_mail_subject"] . "\" \"" . $lang["shop_mail_message"] . "\" " . $package['gold']; } // === Send the command to the RA Class === // $send = $RA->send($command, $GLOBALS['cur_selected_realm']); // Catch the result of send. If its a 1 or 2, then the send wasnt successful if ($send == 1 || $send == 2) { output_message('error', $lang['shop_send_error']); return FALSE; } else { // Initiate our counts $success = 0; $total_commands = count($command); // Return will be in an array, so foreach array variable, we need the result foreach ($send as $report) { // If in the string, the characters name is listed, then its a success if (strpos($report, $_POST['char'])) { $success++; } } // If the success count is equal to the total amount of commands sent // Then all was successful if ($success == $total_commands) { output_message('success', 'Items Sent Successfully!'); // Update the DB, subtracting the cost of the package $DB->query("UPDATE `mw_account_extend` SET\r\n\t\t\t\t`web_points`=(`web_points` - " . $package['wp_cost'] . "), \r\n\t\t\t\t`points_spent`=(`points_spent` + " . $package['wp_cost'] . ") \r\n\t\t\t WHERE `account_id` = " . $user['id'] . " LIMIT 1"); } else { output_message('validation', $lang['shop_error']); } } }
include 'core/SDL/class.zone.php'; include 'core/SDL/class.character.php'; $Zone = new Zone(); $Character = new Character(); if (isset($_GET["page"])) { $pid = $_GET["page"]; } else { $pid = 1; } $limit = 100; $limitstart = ($pid - 1) * $limit; $res_info = array(); $query = array(); $realm_info = get_realm_byid($_COOKIE['cur_selected_realm']); $cc = 0; $Online_Check = check_port_status($realm_info['address'], $realm_info['port']); if ($Online_Check == TRUE) { $Count = $Character->getOnlineCount(); $numofpgs = $Count / $limit; if (gettype($Count / $limit) != "integer") { settype($numofpgs, "integer"); $numofpgs++; } $query = $Character->getOnlineList(0, $limitstart, $limit); } else { $numofpgs = 0; } foreach ($query as $result) { if ($res_color == 1) { $res_color = 2; } else {