function _flushStatisticTable($connection, $GMLevel) { global $L; echo "<fieldset>"; if (_isGMAllowed($connection)) { $query = mysql_query("SELECT * FROM `account_transfer` WHERE `gmAccount` = " . _getAccountID() . " ORDER BY `id` DESC LIMIT 9;", $connection) or die(mysql_error()); echo _BDiv($L[27] . "\n <button class = 'btn btn-success'>" . $L[13] . "</button>\n <button class = 'btn btn-danger'>" . $L[14] . "</button>\n <button class = 'btn btn-warning'>" . $L[15] . "</button>\n " . $L[28]) . "\n <br/>\n <table class = 'table table-condensed'>\n <tr class = 'menuBar'>\n <td>'OUR' & 'OLD' Name: </td>\n <td>'OUR' & 'OLD' Realm: </td>\n <td>Realmlist: </td>\n <td>Account: </td>\n <td>Password: </td>\n <td>Admin Options: </td>\n </tr>"; while ($row = mysql_fetch_array($query)) { if ($row["cStatus"] == 0) { echo "\n <tr>\n <td>" . $row["cNameNEW"] . " / " . $row["cNameOLD"] . "</td>\n <td>" . _getRealmNameFromID($connection, $row["cRealm"]) . " / " . $row["oRealm"] . "</td>\n <td><a href = '" . $row["oServer"] . "'>" . $row["oRealmlist"] . "</a></td>\n <td>" . $row["oAccount"] . "</td>\n <td>" . base64_decode($row["oPassword"]) . "</td>\n <td width = 240px class = 'text-center'>\n <button class = 'btn btn-success' name = 'Approve' id = '" . $row["id"] . "' onclick = \"DoApprove('" . $row["id"] . "', '" . $row["cRealm"] . "', '" . $row["GUID"] . "');\">" . $L[13] . "</button>\n <button class = 'btn btn-danger' name = 'Deny' id = '" . $row["id"] . "' onclick = \"DoDeny('" . $row["id"] . "', '" . $row["cRealm"] . "', '" . $row["GUID"] . "');\">" . $L[14] . "</button>\n <button class = 'btn btn-warning' name = 'Resend' id = '" . $row["id"] . "' onclick = \"DoResend('" . $row["id"] . "', '" . $row["cRealm"] . "', '" . $row["GUID"] . "\");'>" . $L[15] . "</button>\n </td>\n </tr>"; } } } else { $query = mysql_query("SELECT * FROM `account_transfer` WHERE `cAccount` = " . _getAccountID() . " ORDER BY `id` DESC LIMIT 9;", $connection) or die(mysql_error()); echo _BDiv($L[25] . " <a href = 'v335.699.rar'>3.3.5a</a><br/>" . $L[26]) . "\n <div>\n <form action = '" . $_SERVER["SCRIPT_NAME"] . "' method = 'post' enctype = 'multipart/form-data'>\n <input type = 'submit' class = 'btn btn-info' name = 'load' value = '" . $L[10] . "'/>\n </form>\n </div>\n <table class = 'table table-condensed'>\n <tr class = 'menuBar'>\n <td># </td>\n <td>Character Name: </td>\n <td>Realm: </td>\n <td> </td>\n </tr>"; while ($row = mysql_fetch_array($query)) { echo "\n <tr class = 'tip " . _returnTABLEStatusSTR($row["cStatus"]) . "' title ='" . _returnStatusSTR($row["cStatus"], $row["Reason"]) . "'>\n <td class = 'text-center'>" . $row["id"] . "</td>\n <td class = 'text-center'>" . $row["cNameNEW"] . "</td>\n <td class = 'text-center'>" . _getRealmNameFromID($connection, $row["cRealm"]) . "</td>\n <td class = 'text-center'>"; if ($row["cStatus"] == 0) { echo "<button style = 'float: right;' class = 'btn btn-warning' name = 'cancel' id = '" . $row["id"] . "' onclick = \"DoCancel('" . $row["id"] . "', '" . $row["cRealm"] . "', '" . $row["GUID"] . "');\">" . $L[12] . "</button>"; } echo " </td>\n </tr>"; } } echo "</table>\n </fieldset>"; mysql_close($connection) or die(mysql_error()); }
function _PushCharactersTable($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $URL, $_80) { global $L; $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB); $REALM_ARRAY = array(); $CHAR_ARRAY = array(); $query = mysql_query("SELECT `id`,`name` FROM `realmlist`;", $connection) or die(mysql_error()); while ($result = mysql_fetch_array($query)) { $REALM_ARRAY[$result['name']] = $result['id']; } foreach ($REALM_ARRAY as $RealmName => $RealmID) { $connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID)); $query = mysql_query("SELECT `guid`,`name`,`level`,`race`,`class`,`gender` FROM `characters` WHERE `account` = " . (int) _getAccountID() . ";", $connection) or die(mysql_error()); while ($result = mysql_fetch_array($query)) { if ($_80 == 80 && $result['level'] < 80) { continue; } $CHAR_ARRAY[$RealmID . $result['guid']]['CharName'] = $result['name']; $CHAR_ARRAY[$RealmID . $result['guid']]['CharGUID'] = $result['guid']; $CHAR_ARRAY[$RealmID . $result['guid']]['CharClass'] = $result['class']; $CHAR_ARRAY[$RealmID . $result['guid']]['CharRace'] = $result['race']; $CHAR_ARRAY[$RealmID . $result['guid']]['CharLevel'] = $result['level']; $CHAR_ARRAY[$RealmID . $result['guid']]['CharGender'] = $result['gender']; $CHAR_ARRAY[$RealmID . $result['guid']]['RealmName'] = $RealmName; $CHAR_ARRAY[$RealmID . $result['guid']]['RealmID'] = $RealmID; } mysql_close($connection) or die(mysql_error()); } $TRIGGER = ""; $H2 = empty($CHAR_ARRAY) ? $L[62] : $L[61]; echo "\n <div class = 'text-center'>\n <h2>" . $H2 . "</h2>\n <fieldset>"; foreach ($CHAR_ARRAY as $key => $value) { if ($TRIGGER != $value['RealmID']) { echo "<legend>" . $value['RealmName'] . "</legend>"; $TRIGGER = $value['RealmID']; } echo "\n <a href = " . $URL . "?realmid=" . $value['RealmID'] . "&guid=" . $value['CharGUID'] . "><div style = 'width:273px;' class = 'charBox alert'>\n <table>\n <tr>\n <td width = '73'>\n <img class = 'img-rounded' src = '_template/img/_faces/" . _getAvatarPicString($value['CharLevel'], $value['CharGender'], $value['CharRace'], $value['CharClass']) . "'\n border = 'none'>\n </td>\n <td width = '200'>\n <h4>" . $value['CharName'] . "</h4>\n <span class = ''>" . _getCharacter_L_R_S_C_STR($value['CharLevel'], $value['CharGender'], $value['CharRace'], $value['CharClass']) . "</span><br/>\n </td>\n </tr>\n </table>\n </div></a>"; } echo "</fieldset>\n </div>"; }
include_once '_template/_header.php'; if (!_getUsername()) { Header('Location: index.php'); } $REALSON = null; $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB); $query = mysql_query("SELECT FROM_UNIXTIME(`bandate`) AS `BAN_DATE`, FROM_UNIXTIME(`unbandate`) AS `UNBAN_DATE`,`bannedby`,`banreason` FROM `account_banned` WHERE `id` = " . (int) _getAccountID() . " AND `active` = 1;", $connection) or die(mysql_error()); $result = mysql_fetch_array($query); if (!$result) { $_SESSION['TCA'] = false; echo _getAlreadyEffectSTR("<h2>" . $L[38] . "</h2>"); } else { if (isset($_SESSION['TCA']) && $_SESSION['TCA']) { if (_isEnoughMythCoins($PriceForUnban, $connection)) { _SpendMythCoins($PriceForUnban, 9, $_SESSION['AccountUN'], (int) _getAccountID(), 0, 0, !empty($result['bannedby']) ? $result['bannedby'] : "Server" . " : " . $result['banreason'], $connection); //_UnbanAccount($connection); $REALSON = _GDiv($L[17]); $_SESSION['TCA'] = false; } else { $REALSON = _RDiv($L[18]); } } else { $_SESSION['TCA'] = true; } echo "\n <div class = 'text-center'>" . $REALSON . "\n <h2>" . $L[94] . "</h2>\n </div>\n <fieldset>\n <div class = 'charBox alert alert-error'>\n <table>\n <tr>\n <td width = '73'>\n <img class = 'img-rounded' src = '_template/img/_faces/0-0-0-0.png' border = 'none'>\n </td>\n <td width = '340'>\n <h4>" . $result['banreason'] . "</h4>\n <span class = ''>" . $L[165] . "</span>" . _AU_BAN_AUTHOR_STR($result['bannedby']) . "<br/>\n <span class = ''>" . $L[166] . "</span>" . $result['BAN_DATE'] . "<br/>\n <span class = ''>" . $L[167] . "</span>" . $result['UNBAN_DATE'] . "\n </td>\n </tr>\n </table>\n </div>\n <div class = 'charBox alert alert-success'>\n <table>\n <tr>\n <td width = '73'>\n <img class = 'img-rounded' src = '_template/img/_faces/0-0-0-0.png' border = 'none'>\n </td>\n <td width = '340'>\n <h4>" . $result['banreason'] . "</h4>\n <span class = ''>" . $L[165] . "</span>" . _AU_BAN_AUTHOR_STR($result['bannedby']) . "<br/>\n <span class = ''>" . $L[166] . "</span>" . $result['BAN_DATE'] . "<br/>\n <span class = ''>" . $L[167] . "</span>" . $L[168] . "\n </td>\n </tr>\n </table>\n </div>\n </fieldset>\n <fieldset>\n <form action = " . $_SERVER['PHP_SELF'] . " method = 'POST'>\n " . _BDiv(_PRICE_STR($PriceForUnban)) . "\n <div class = 'text-center'>\n <button class = 'btn btn-primary' type = 'submit'>" . _getPriceButtonSTR($PriceForUnban) . "</button>\n </div>\n </form>\n </fieldset>"; } mysql_close($connection) or die(mysql_error()); include_once '_template/_footer.php'; ob_end_flush(); function _AU_BAN_AUTHOR_STR($X)
} else { $username = _Z($_POST['username']); $SHA1Password = SHA1Password($username, _Z($_POST['password'])); $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB); $query = mysql_query("SELECT `id`,`username` FROM `account` WHERE `username` = '" . _X($username) . "' AND `sha_pass_hash` = '" . _X($SHA1Password) . "';", $connection) or die(mysql_error()); $result = mysql_fetch_array($query); if (empty($result['username'])) { $REASON = _RDiv($L[157]); mysql_close($connection) or die(mysql_error()); } else { $_SESSION['AccountID'] = $result['id']; $_SESSION['AccountUN'] = strtoupper($result['username']); $query = mysql_query("SELECT `id` FROM `account_details` WHERE `id` = " . (int) _getAccountID() . ";", $connection) or die(mysql_error()); $result = mysql_fetch_array($query); if (empty($row[0])) { mysql_query("INSERT IGNORE INTO `account_details`(`id`) VALUES (" . (int) _getAccountID() . ");", $connection) or die(mysql_error()); } mysql_close($connection) or die(mysql_error()); Header('Location: _userside.php'); } } } ?> <div class = 'text-center'> <h2><?php echo $L[1]; ?> </h2> <?php echo $REASON; ?>
<div class = 'container'> <a class = 'brand' href = 'index.php'><?php echo $L[8]; ?> </a> <div class = 'nav-collapse'> <ul class = 'nav'> <li class = 'active'><a><?php echo mb_strtoupper(_getUsername() ? _getUsername() : $L[16], 'UTF-8'); ?> </a></li> <?php if (_getUsername()) { echo "\n <li><a href = '_userside.php'>" . $L[4] . "</a></li>\n <li><a href = '_logout.php'>" . $L[5] . "</a></li>"; $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB); $query = mysql_query("SELECT `myth_coins` FROM `account_details` WHERE `id` = " . _getAccountID() . " ;", $connection) or die(mysql_error()); $row = mysql_fetch_array($query); echo "<li><a href = '_acc_history.php'><i class = 'icon-white icon-fire'></i>" . $row[0] . " " . $L[37] . "</a></li>"; mysql_close($connection) or die(mysql_error()); } ?> <li><a href = '__online_statistic.php'><?php echo $L[250]; ?> </a></li> <li> <form style = 'display:inline; position:relative; left: 5px; top:5px;' id = 'LSF' method = 'post'> <div class = 'bfh-selectbox bfh-languages' data-language = '<?php echo _getAMLanguage(); ?> ' data-available = '<?php
if ($ItemID) { _sendQuestReward($GUID, $QuestID, $CharName, $ItemID, $RealmID, $DBUser, $DBPassword, $SOAPUser, $SOAPPassword); } $connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID)); mysql_query("INSERT INTO `character_queststatus_rewarded`(`guid`,`quest`) VALUES (" . $GUID . "," . $QuestID . ");", $connection) or die(mysql_error()); mysql_query("UPDATE `character_queststatus` SET `status` = 0 WHERE `guid` = " . $GUID . " AND `quest` = " . $QuestID . ";", $connection) or die(mysql_error()); mysql_close($connection); unset($_SESSION['pQuest']); unset($_SESSION['TCA']['qList']); } else { mysql_close($connection) or die(mysql_error()); $REALSON = _getNotEnoughtFireSTR(); } } if (_doesRealmExists($RealmID, $DBUser, $DBPassword)) { if (_doesCharacterExistsOnAccount($DBUser, $DBPassword, $RealmID, $GUID, _getAccountID())) { if (_doesCharacterNotOnlineATM($DBUser, $DBPassword, $RealmID, $GUID)) { if (!_doesCharacterHaveActiveQuests($GUID, $RealmID, $DBUser, $DBPassword)) { echo _getAlreadyEffectSTR($L[72]); } else { _FORM_QUEST_COMPLETE($SA ? $SA : _FORM_CHAR_ARRAY($AccountDBHost, $AccountDB, $DBUser, $DBPassword, $RealmID, $GUID), $RealmID, $AccountDBHost, $AccountDB, $DBUser, $DBPassword, $GUID, $PriceForInstantQuestComplete, $REALSON); } } else { echo _RDiv($L[60]); } } else { echo _RDiv($L[9]); } } else { echo _RDiv($L[9]); }
function _FORM_CHAR_ARRAY($AccountDBHost, $AccountDB, $DBUser, $DBPassword, $RealmID, $GUID) { $SA = null; $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB); $query = mysql_query("SELECT `name` FROM `realmlist` WHERE `id` = " . (int) $RealmID . ";", $connection) or die(mysql_error()); while ($result = mysql_fetch_array($query)) { $RealmName = $result['name']; } $connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID)); $query = mysql_query("SELECT `guid`,`name`,`level`,`race`,`class`,`gender`,`money`,`totalKills` FROM `characters` WHERE `account` = " . (int) _getAccountID() . " AND `guid` = " . $GUID . ";", $connection) or die(mysql_error()); while ($result = mysql_fetch_array($query)) { $SA['CharName'] = $result['name']; $SA['CharGUID'] = $result['guid']; $SA['CharClass'] = $result['class']; $SA['CharRace'] = $result['race']; $SA['CharLevel'] = $result['level']; $SA['CharGender'] = $result['gender']; $SA['CharMoney'] = $result['money']; $SA['CharHKills'] = $result['totalKills']; $SA['RealmName'] = $RealmName; $SA['RealmID'] = $RealmID; } mysql_close($connection) or die(mysql_error()); $_SESSION['TCA'] = $SA; return $SA; }
function _AH_FORM($connection, $ADMIN_MODE = false) { global $L; $RealmID = isset($_GET['R']) ? (int) $_GET['R'] : null; $PostQuery = isset($_POST['U']) ? trim($_POST['U']) : null; if (isset($PostQuery)) { $PostQuery = !empty($PostQuery) ? $PostQuery : null; } $Done = null; $H = $ADMIN_MODE ? $L[221] : $L[95]; $Q_STR = "SELECT DATE(`whenItDone`),`action`,`text`,`realmName`,`charName`,`myth_coins_spend`,`myth_coins_balance`,`IP`\n FROM `account_billing_history` "; _getRealmArray($connection); echo "\n <div class = 'text-center'>\n <h2>" . $H . "</h2>"; if ($ADMIN_MODE) { if (isset($PostQuery) && isset($_SESSION['R']['Username']) && $PostQuery === $_SESSION['R']['Username']) { $Done = true; } else { if (!isset($PostQuery) && isset($_SESSION['R']['Username'])) { $Done = true; } else { $_SESSION['R']['Username'] = isset($PostQuery) ? $PostQuery : null; } } if (!isset($Done) && isset($_SESSION['R']['Username'])) { $_SESSION['R']['ID'] = _lookForAccount($connection, $_SESSION['R']['Username']); } $PLACEHOLDER = isset($_SESSION['R']['ID']) ? $_SESSION['R']['Username'] : $L[219]; if (isset($_SESSION['R']['ID'])) { $InfoAccountQuery = mysql_query("SELECT\n `t2`.`myth_coins`,`t1`.`id`,`t1`.`email`,`t1`.`last_ip`,DATE(`t1`.`joindate`) AS `joindate`,DATE(`t1`.`last_login`) AS `last_login`\n FROM `account` `t1` LEFT JOIN `account_details` `t2` ON `t1`.`id` = `t2`.`id` WHERE `t1`.`id` = " . $_SESSION['R']['ID'] . ";", $connection) or die(mysql_error()); $InfoAccountResult = mysql_fetch_array($InfoAccountQuery); echo "\n <div class = 'modal hide' id = 'ModifyFirePoints'>\n <div class = 'modal-header'>\n <button type = 'button' class = 'close' data-dismiss = 'modal'>×</button>\n <h3>" . $_SESSION['R']['Username'] . "</h3>\n </div>\n <form action = " . $_SERVER['PHP_SELF'] . " method = 'POST'>\n <div class = 'modal-body'>\n <p class = 'text-center'>" . $L[253] . "</p>\n <input name = 'HowMuch' type = 'text' size = '60' placeholder = '" . $L[255] . "'>\n <input name = 'HowMuchReason' type = 'text' size = '100' placeholder = '" . $L[256] . "'>\n </div>\n <div class = 'modal-footer'>\n <a href = '#' class = 'btn' data-dismiss = 'modal'>" . $L[254] . "</a>\n <input class = 'btn' type = 'submit' value = '" . $L[146] . "' />\n </div>\n </form>\n </div>\n <div class = 'modal hide' id = 'AccountInfo'>\n <div class = 'modal-header'>\n <button type = 'button' class = 'close' data-dismiss = 'modal'>×</button>\n <h3>" . $_SESSION['R']['Username'] . "</h3>\n </div>\n <div class = 'modal-body'>\n <table class = 'table table-hover'>\n <tr class = 'menuBar'>\n <td>#</td>\n <td>" . $_SESSION['R']['ID'] . "</td>\n </tr><tr>\n <td>" . $L[271] . "</td>\n <td>" . $InfoAccountResult['email'] . "</td>\n </tr><tr>\n <td>" . $L[272] . "</td>\n <td>" . $InfoAccountResult['joindate'] . "</td>\n </tr><tr>\n <td>" . $L[273] . "</td>\n <td>" . $InfoAccountResult['last_login'] . "</td>\n </tr><tr>\n <td>" . $L[274] . "</td>\n <td>" . $InfoAccountResult['last_ip'] . "</td>\n </tr>\n </tr><tr>\n <td><i class = 'icon-fire'></i></td>\n <td>" . $InfoAccountResult['myth_coins'] . "</td>\n </tr>\n </table>\n </div>\n </div>\n <script>\n \$('ModifyFirePoints').click(function() {\n \$('#ModifyFirePoints').modal('toggle');\n })\n \$('AccountInfo').click(function() {\n \$('#AccountInfo').modal('toggle');\n })\n </script>"; } $D = !isset($_SESSION['R']['Username']) ? "disabled = 'disabled'" : ""; echo "\n <form action = " . $_SERVER['PHP_SELF'] . " method = 'POST'>\n <input name = 'U' type = 'text' size = '60' placeholder = '" . $PLACEHOLDER . "'>\n <input class = 'btn btn-info BillingB' type = 'submit' value = '" . $L[220] . "' />\n <a href = '?CL'><input class = 'btn btn-inverse BillingB' " . $D . " value = '" . $L[251] . "'/></a>\n <a class = 'btn BillingB' data-toggle = 'modal' href = '#ModifyFirePoints' " . $D . ">" . $L[252] . "<i class = 'icon-fire'></i></a>\n <a class = 'btn BillingB' data-toggle = 'modal' href = '#AccountInfo' " . $D . ">" . $L[261] . "</a>\n </form>"; $STR_P1 = isset($_SESSION['R']['ID']) ? "`id` = " . (int) $_SESSION['R']['ID'] : ""; $STR_P2 = _AH_REALMID(isset($RealmID) ? $RealmID : -1); if (!empty($STR_P1) || !empty($STR_P2)) { $Q_STR .= " WHERE "; } $Q_STR .= $STR_P1; if (!empty($STR_P1) && !empty($STR_P2)) { $Q_STR .= " AND "; } $Q_STR .= $STR_P2; } else { $Q_STR .= " WHERE `id` = " . (int) _getAccountID(); if (isset($RealmID)) { $Q_STR .= " AND "; } $Q_STR .= _AH_REALMID(isset($RealmID) ? $RealmID : -1); } $Q_STR .= " ORDER BY `whenItDone` DESC;"; echo "\n </div>\n <ul class = 'nav nav-tabs'>"; echo !isset($RealmID) ? "<li class = 'active'>" : "<li>"; echo "<a href = '?ALL'>" . $L[110] . "</a></li>"; foreach ($_SESSION['R']['W'] as $ID => $NA) { echo $RealmID === (int) $ID ? "<li class = 'active'>" : "<li>"; echo "<a href = '?R=" . $ID . "'>" . $NA['N'] . "</a></li>"; } echo "</ul>"; $query = mysql_query($Q_STR, $connection) or die(mysql_error()); $row_num = mysql_num_rows($query); if ($row_num < 1) { echo _getAlreadyEffectSTR("<h2>" . $L[163] . "</h2>"); } else { echo "\n <fieldset>\n <table class = 'table table-hover'>\n <tr class = 'menuBar'>\n <td>" . $L[140] . "</td>\n <td>" . $L[141] . "</td>\n <td>" . $L[119] . "</td>\n <td>" . $L[142] . "</td>\n <td>" . $L[64] . "</td>\n <td>" . $L[260] . "</td>\n <td>" . $L[143] . "</td>\n </tr>"; while ($result = mysql_fetch_array($query)) { if ($result['action'] === 14 && _isset($result['text'])) { $STR = explode('_REPLACE_', $result['text']); $result['text'] = $STR[0] . _getWHLanguage() . $STR[1]; } echo "<tr class = '" . _AH_TR_STR($result, $result['action']) . "'>\n <td>" . $result[0] . "</td>\n <td>" . _AH_STR($result['action'], !empty($result['text']) ? $result['text'] : "") . "</td>\n <td>" . $result['realmName'] . "</td>\n <td>" . $result['charName'] . "</td>\n <td>" . _AH_PRICE_STR($result['myth_coins_spend']) . "</td>\n <td>" . $result['myth_coins_balance'] . " <i class = 'icon-fire'></i></td>\n <td>" . $result['IP'] . "</td>\n </tr>"; } echo "\n </table>\n </fieldset>"; } }
$realson = null; while (!feof($fileopen)) { $buffer2 = fgets($fileopen); $buffer .= $buffer2; } fclose($fileopen); unlink($_FILE); $part = explode('"', $buffer); if (!isset($part[1]) || !isset($part[3]) || _CHECK_KEY($part[3]) != "v335.699") { return _Migration_STEP1FORM($AuthConnection, _RDiv($L[36])); } $DUMP = $part[1]; $REALM_NAME = $_POST['RealmlistList']; $DECODED_DUMP = _DECRYPT($DUMP); $CHAR_REALM = _getRealmID($AuthConnection, $REALM_NAME); $CHAR_ACCOUNT_ID = _getAccountID(); mysql_close($AuthConnection); $GM_ACCOUNT_ID = _CanOrNoTransferServer($DBUser, $DBPassword, $CHAR_REALM, $GMLevel); $AuthConnection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB); $json = json_decode(stripslashes($DECODED_DUMP), true); $CHAR_NAME = mb_convert_case(mb_strtolower($json['uinf']['name'], 'UTF-8'), MB_CASE_TITLE, 'UTF-8'); $O_REALMLIST = $json['ginf']['realmlist']; $O_REALM = $json['ginf']['realm']; $RaceID = _GetRaceID(strtoupper($json['uinf']['race'])); $ClassID = _GetClassID(strtoupper($json['uinf']['class'])); $CharLevel = _MaxValue($json['uinf']['level'], $MaxCL); $result = mysql_query("SELECT `address`,`port` FROM `realmlist` WHERE `id` = " . $CHAR_REALM . ";", $AuthConnection) or die(mysql_error()); $row = mysql_fetch_array($result); $SPT = $row['port']; $SIP = $row['address']; $AchievementsCount = 0;