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>";
}
function _FORM_INSTANT_EXT_REPUTATION($SA, $RealmID, $DBUser, $DBPassword, $faction, $level, $PRICE, $REALSON = "")
{
$connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID));
$query = mysql_query("SELECT `faction`,`standing`,`flags` FROM `character_reputation` WHERE `guid` = " . $SA['CharGUID'] . " AND `flags` & 1;", $connection) or die(mysql_error());
while ($result = mysql_fetch_array($query)) {
$SA['ReputationList'][$result['faction']]['Level'] = $result['standing'];
$SA['ReputationList'][$result['faction']]['Flag'] = $result['flags'];
}
global $L;
echo "\n <form action = " . $_SERVER['PHP_SELF'] . " method = 'POST'>\n <fieldset>\n <div class = 'text-center'>" . $REALSON . "\n <h2>" . $L[88] . "</h2>\n <fieldset>";
_FORM_CHAR_BLOCK($SA, null, true);
include_once '_core/f_switch.php';
if (isset($faction) && isset($level)) {
$faction = mb_convert_case(_getFactionNameFromID($faction), MB_CASE_TITLE, 'UTF-8');
echo "<div class = 'alert service " . _getColorOfReputationBlock($level) . " reputationBlock'>\n <div class = 'service_icon'><img src = '_template/img/reputation.png'></div>\n <h4>" . $faction . " (" . $L[114] . ")</h4>\n <div class = 'service_desc'>" . _getReputationRank($level) . "</div>\n </div>\n <div class = 'alert service alert-success reputationBlock'>\n <div class = 'service_icon'><img src = '_template/img/reputation.png'></div>\n <h4>" . $faction . " (" . $L[115] . ")</h4>\n <div class = 'service_desc'>" . _getReputationRank(42001) . "</div>\n </div>";
}
echo "\n </fieldset>";
if (isset($faction) && isset($level)) {
echo "\n <fieldset>\n " . _BDiv(_PRICE_STR($PRICE)) . "\n <form action = " . $_SERVER['PHP_SELF'] . " method = 'POST'>\n <p><button class = 'btn btn-primary' type = 'submit'>" . _getPriceButtonSTR($PRICE) . "</button></p>\n <input type = 'hidden' name = '2nd_checker' value = '" . $faction . "' id = '2nd_checker' />\n </form>\n </div>\n </fieldset>";
} else {
echo "\n <legend>" . $L[81] . "</legend>\n <fieldset>";
if (isset($SA['ReputationList'])) {
foreach ($SA['ReputationList'] as $ID => $Array) {
$faction = mb_convert_case(_getFactionNameFromID($ID), MB_CASE_TITLE, 'UTF-8');
if ($faction < 0) {
continue;
}
echo "<a href = '_a_instant_exalted_reputation.php?faction=" . $ID . "&level=" . $Array['Level'] . "'><div class = 'alert service " . _getColorOfReputationBlock($Array['Level']) . "'>\n <div class = 'service_icon'><img src = '_template/img/reputation.png'></div>\n <h4>" . $faction . "</h4>\n <div class = 'service_desc'>" . _getReputationRank($Array['Level']) . "</div>\n </div></a>";
}
} else {
echo _getAlreadyEffectSTR("<h2>" . $L[270] . "</h2>");
}
echo "\n </fieldset>";
}
echo "</fieldset>\n </form>";
}
}
$QUERYFOREXECUTE_CON = new mysqli(_HostDBSwitch($CHAR_REALM), $DBUser, $DBPassword, _CharacterDBSwitch($CHAR_REALM));
mysqli_multi_query($QUERYFOREXECUTE_CON, $QUERYFOREXECUTE) or die(mysql_error());
$row = trim($INVrow . $GEMrow . $CURrow);
UpdateDumpITEMROW($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, $row);
if (_CheckCharacterName(_HostDBSwitch($CHAR_REALM), $DBUser, $DBPassword, _CharacterDBSwitch($CHAR_REALM), $CHAR_NAME) > 1) {
$_SESSION['guid'] = $GUID;
$_SESSION['realm'] = $CHAR_REALM;
$_SESSION['dumpID'] = $ID;
$_SESSION['STEP2'] = "YES";
include "step2.php";
} else {
UpdateDumpStatus($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, 0);
_PreparateMails($row, $CHAR_NAME, $TransferLetterTitle, $TransferLetterMessage, $SOAPUser, $SOAPPassword, _SOAPPSwitch($CHAR_REALM), _SOAPHSwitch($CHAR_REALM), _SOAPURISwitch($CHAR_REALM));
_TalentsReset(_HostDBSwitch($CHAR_REALM), $DBUser, $DBPassword, _CharacterDBSwitch($CHAR_REALM), $GUID);
MoveToGMAccount(_HostDBSwitch($CHAR_REALM), $DBUser, $DBPassword, _CharacterDBSwitch($CHAR_REALM), $GUID);
echo "<font color = \"green\">" . $write[91] . "</font>";
}
}
}
} else {
Step1Form($AccountDB, $AccountDBHost, $DBUser, $DBPassword, $write[70], $write[71], $write[72], $write[79], $write[74], $write[76], $write[63], $write[77]);
}
function CHECKDAY($TIME1, $TIME2)
{
$DIFF = floor(($TIME1 - $TIME2) / 86400);
return $DIFF;
}
function Step1Form($AccountDB, $AccountDBHost, $DBUser, $DBPassword, $TEXT1, $TEXT2, $TEXT3, $TEXT4, $TEXT5, $TEXT6, $TEXT7, $TEXT8, $REALSON = "")
{
echo $REALSON . "<div align = center class = \"MythTable\">" . $TEXT1 . "</div>\n <br>\n <form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"post\" enctype=\"multipart/form-data\">\n <table width=\"525px\">\n <tr><td><div align = right class = \"MythTable\">" . $TEXT2 . "</div></td></tr>\n <tr><td><b>Account: </b><input name=\"Account\" type=\"text\" size=\"32\" style = \"float: right;\"></td></tr>\n <tr><td><div align = right class = \"MythTable\">" . $TEXT3 . "</div></td></tr>\n <tr><td><b>Password: </b><input name=\"Password\" type=\"password\" size=\"32\" style = \"float: right;\"></tr>\n <tr><td><br></td></tr>\n <tr><td><div align = right class = \"MythTable\">" . $TEXT4 . "</div></td></tr>\n <tr><td><b>I want transfer to Realm: </b><select name=\"RealmlistList\">";
} else {
if (_CheckCharacterName(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $CHAR_NAME) > 0) {
$realson = $write[96] . $CHAR_NAME . $write[97];
} else {
if (!_ServerOn($SIP, $SPT)) {
$realson = "Realm: \"" . $SNA . "\" <u>OFFLINE!</u>";
}
}
}
}
}
}
}
if (!empty($realson)) {
Step2Form($realson, $write[90]);
} else {
$_SESSION['STEP2'] = "NO";
UpdateCharacterName(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $CHAR_NAME, $GUID);
_TalentsReset(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $GUID);
_PreparateMails(LoadItemRoW($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID), $CHAR_NAME, $TransferLetterTitle, $TransferLetterMessage, $SOAPUser, $SOAPPassword, _SOAPPSwitch($RealmID), _SOAPHSwitch($RealmID), _SOAPURISwitch($RealmID));
UpdateDumpSTATUSandNAME($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, $CHAR_NAME, 0);
MoveToGMAccount(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $GUID);
echo "<font color = \"green\">" . $write[91] . "</font>";
}
} else {
Step2Form("Character with same name \"" . $CHAR_NAME . "\" already exists!", $write[90]);
}
function Step2Form($TEXT1, $TEXT2)
{
echo "<div align = center style = \"padding-right: 2px;font-family: 'Tahoma'; color:#CC0000; font-size:15px;\"><b>" . $TEXT1 . "</b><br></div>\n <form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"post\" enctype=\"multipart/form-data\">\n <table width=\"650px\">\n <tr><td><div align = right class = \"MythTable\">" . $TEXT2 . "</div></td></tr>\n <tr><td>\n <div align = center class = \"MythInput\">\n <input type=\"text\" name=\"rename\" id=\"rename\">\n <button type=\"submit\" style = \"font-size:10px\">Submit</button>\n </div>\n </td></tr>\n </table>\n </form>";
}
<?php
ob_start();
session_start();
include_once "t_dbfunctions.php";
include_once "t_functions.php";
include_once "t_config.php";
if (isset($_POST['cancel']) && isset($_POST['RealmlistList']) && isset($_POST['GUID'])) {
$ACCOUNT_ID = _GetCharacterAccountID();
$ID = $_POST['cancel'];
$RealmID = $_POST['RealmlistList'];
$GUID = $_POST['GUID'];
if (_CheckCharacterOnlineStatus(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $GUID)) {
if (CheckTransferStatus($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID) == 0) {
if (!_CheckGMAccess($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ACCOUNT_ID, $GMLevel)) {
CancelORDenyCharacterTransfer(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $GUID, $STORAGE);
UpdateDumpStatus($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, 3);
ob_end_flush();
die("Transfer with ID: " . $ID . " Canceled");
} else {
die("ACCESS DENIED");
}
} else {
die("NOT \"IN PROGRESS\" STATUS");
}
} else {
die("LOG OFF WITH THIS CHARACTER! BEFORE MAKE ANY ACTIONS!");
}
} else {
die("SHIT HAPPENS, ERROR 30");
}
foreach ($_SESSION['R']['W'] as $ID => $NA) {
echo $RealmID === (int) $ID ? "<li class = 'active'>" : "<li>";
echo "<a href = '?page=_online.php&R=" . $ID . "'>" . $NA['N'] . "</a></li>";
}
echo "</ul>";
foreach ($_SESSION['R']['W'] as $ID => $NA) {
if (!isset($RealmID) || (int) $RealmID === (int) $ID) {
$_RealmID = isset($RealmID) ? $RealmID : (int) $ID;
$HCount = null;
$ACount = null;
$CCount = 0;
$MAX_ONLINE = _MaxOnlineForR($_RealmID);
$CUR_RATE = null;
$CUR_HORDE = null;
$CUR_ALLIANCE = null;
$connection = _MySQLConnect(_HostDBSwitch($_RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($_RealmID));
$query = mysql_query("SELECT `race`, COUNT(*) FROM `characters` WHERE `online` = 1 GROUP BY `race`;", $connection);
while ($result = mysql_fetch_array($query)) {
if (_isHorde((int) $result[0])) {
$HCount += (int) $result[1];
} else {
$ACount += (int) $result[1];
}
$CCount += (int) $result[1];
}
if ($CCount > 0) {
$CUR_RATE = $CCount / $MAX_ONLINE * 100;
$CUR_HORDE = $HCount / $CCount * 100;
$CUR_ALLIANCE = $ACount / $CCount * 100;
}
mysql_close($connection) or die(mysql_error());
<?php
ob_start();
session_start();
include_once "t_dbfunctions.php";
include_once "t_functions.php";
include_once "t_config.php";
if (isset($_POST['Resend']) && isset($_POST['RealmlistList']) && isset($_POST['GUID'])) {
$ACCOUNT_ID = _GetCharacterAccountID();
$ID = $_POST['Resend'];
$RealmID = $_POST['RealmlistList'];
$GUID = $_POST['GUID'];
if (_CheckCharacterOnlineStatus(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $GUID)) {
if (CheckTransferStatus($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID) == 0) {
if (_CheckGMAccess($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ACCOUNT_ID, $GMLevel)) {
_PreparateMails(LoadItemRoW($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID), _GetCharacterName(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $GUID), $TransferLetterTitle, $TransferLetterMessage, $SOAPUser, $SOAPPassword, _SOAPPSwitch($RealmID), _SOAPHSwitch($RealmID), _SOAPURISwitch($RealmID));
ob_end_flush();
die("ITEMS RE-SENDED");
} else {
die("ACCESS DENIED STATUS");
}
} else {
die("NOT \"IN PROGRESS\" STATUS");
}
} else {
die("LOG OFF WITH THIS CHARACTER! BEFORE MAKE ANY ACTIONS!");
}
} else {
die("SHIT HAPPENS, ERROR 30");
}
function _FORM_QUEST_COMPLETE($SA, $RealmID, $AccountDBHost, $AccountDB, $DBUser, $DBPassword, $GUID, $PRICE, $REALSON = "")
{
global $L;
$QueryString = "";
$connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID));
$query = mysql_query("SELECT `quest` FROM `character_queststatus` WHERE `status` = 3 AND `guid` = " . (int) $GUID . ";", $connection) or die(mysql_error());
while ($result = mysql_fetch_array($query)) {
$QueryString .= $result['quest'] . ", ";
}
$QueryString = substr($QueryString, 0, -2);
mysql_close($connection) or die(mysql_error());
if ($QueryString != "") {
$connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _WorldDBSwitch($RealmID));
$query = mysql_query("SELECT \n `Id` AS `id`,\n `RewardChoiceItemId1` AS `I1`,\n `RewardChoiceItemId2` AS `I2`,\n `RewardChoiceItemId3` AS `I3`,\n `RewardChoiceItemId4` AS `I4`,\n `RewardChoiceItemId5` AS `I5`,\n `RewardChoiceItemId6` AS `I6`\n FROM\n `quest_template` WHERE `Id` IN (" . $QueryString . ");", $connection) or die(mysql_error());
while ($result = mysql_fetch_array($query)) {
if ($result['I1'] < 1 && $result['I2'] < 1 && $result['I3'] < 1 && $result['I4'] < 1 && $result['I5'] < 1 && $result['I6'] < 1) {
$SA['qList'][$result['id']] = true;
} else {
$ID = $result['id'];
$i = 1;
foreach ($result as $ITEM) {
if ($ITEM === $ID) {
continue;
}
if ($ITEM < 1) {
continue;
}
if (isset($SA['qList'][$ID]) && in_array($ITEM, $SA['qList'][$ID])) {
continue;
}
$SA['qList'][$ID][$i] = $ITEM;
$i++;
}
}
}
mysql_close($connection) or die(mysql_error());
} else {
die("EXCEPTION QUESTLIST-CREATE");
}
$_SESSION['TCA'] = $SA;
echo "\n <fieldset>\n <form action = " . $_SERVER['PHP_SELF'] . " method = 'POST'>\n <div class = 'text-center'>" . $REALSON . "\n <h2>" . $L[89] . "</h2>\n <fieldset>";
_FORM_CHAR_BLOCK($SA, null, true);
echo "\n <div class = 'charBoxClean'>";
$STEP = null;
$BN = null;
if (isset($_SESSION['pQuest']) && isset($SA['qList'][$_SESSION['pQuest']]) && $SA['qList'][$_SESSION['pQuest']] != true) {
$STEP = 2;
$BN = $L[291];
$Q = $_SESSION['pQuest'];
echo "\n <ul class = 'nav nav-pills'>\n <li class = 'dropdown'>\n <a id = 'QuestSelector" . $STEP . "' class = 'dropdown-toggle' role = 'button' data-toggle = 'dropdown' href = '#'>" . $L[71] . ":<b class = 'caret'></b></a>\n <ul id = 'QuestSelectorList" . $STEP . "' class = 'dropdown-menu' role = 'menu'>";
foreach ($SA['qList'][$Q] as $ItemID) {
if ($ItemID < 2) {
continue;
}
echo "<li><a tabindex = '-1' href= '#' onclick = 'QuestJS(\$(this).html());'>" . $ItemID . "</a></li>";
}
echo "</ul>\n </li>\n </ul>";
} else {
$STEP = 1;
$BN = $L[290];
$DN = isset($_SESSION['pQuest']) ? $L[288] . $_SESSION['pQuest'] : $L[70];
echo "\n <ul class = 'nav nav-pills'>\n <li class = 'dropdown'>\n <a id = 'QuestSelector" . $STEP . "' class = 'dropdown-toggle' role = 'button' data-toggle = 'dropdown' href = '#'>" . $DN . ":<b class = 'caret'></b></a>\n <ul id = 'QuestSelectorList" . $STEP . "' class = 'dropdown-menu' role = 'menu'>";
foreach ($SA['qList'] as $QuestID => $ENABLED) {
echo "<li><a tabindex = '-1' href= '# ' onclick = 'QuestJS(\$(this).html());'>" . $QuestID . "</a></li>";
}
echo "</ul>\n </li>\n </ul>";
}
echo "\n </div>\n </fieldset>\n <br/>";
if (isset($_SESSION['pQuest'])) {
echo _BDiv(_PRICE_STR($PRICE));
echo "<input type = 'hidden' name = 'QuestList" . $STEP . "' value = '" . $_SESSION['pQuest'] . "'/>";
} else {
$BN = $L[146];
echo "<input type = 'hidden' name = 'QuestList" . $STEP . "' value = ''/>";
}
echo "<button class = 'btn btn-info' type = 'submit'>" . $BN . "</button>\n </div>\n </form>\n </fieldset>\n <script>\n \$('#QuestSelector" . $STEP . "').click(function() {\n \$('#QuestSelectorList" . $STEP . "').toggle();\n })\n function QuestJS(html) {\n \$('#QuestSelectorList" . $STEP . "').hide();\n \$('#QuestSelector" . $STEP . "').html(html);\n \$('input[name = \"QuestList" . $STEP . "\"]').val(\$('#QuestSelector" . $STEP . "').text());\n }\n </script>";
}
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;
}
$QUERYFOREXECUTE_CON = new mysqli(_HostDBSwitch($CHAR_REALM), $DBUser, $DBPassword, _CharacterDBSwitch($CHAR_REALM));
mysqli_multi_query($QUERYFOREXECUTE_CON, $QUERYFOREXECUTE) or die(mysqli_error($QUERYFOREXECUTE_CON));
$row = trim($INVrow . $GEMrow . $CURrow);
_DUMP_UpdateItemRow($DBUser, $DBPassword, $ID, $row);
if (_CheckCharacterName($DBUser, $DBPassword, $CHAR_REALM, $CHAR_NAME) > 1) {
$_SESSION['guid'] = $GUID;
$_SESSION['realm'] = $CHAR_REALM;
$_SESSION['dumpID'] = $ID;
$_SESSION['STEP2'] = 1;
include "step2.php";
} else {
$connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB);
_updateMigrationStatusAndCharacterName($connection, $ID, $CHAR_NAME, 0);
mysql_close($connection);
_PreparateMails($row, $CHAR_NAME, $SOAPUser, $SOAPPassword, $CHAR_REALM);
$connection = _MySQLConnect(_HostDBSwitch($CHAR_REALM), $DBUser, $DBPassword, _CharacterDBSwitch($CHAR_REALM));
_TalentsReset($connection, $GUID);
_MoveToGMAccount($connection, $GUID);
mysql_close($connection);
echo _GDiv($L[51]);
}
}
} else {
_Migration_STEP1FORM($AuthConnection);
}
function _CHECK_PLAYTIME($TIME1, $TIME2)
{
return floor(($TIME1 - $TIME2) / 86400);
}
function _Migration_STEP1FORM($connection, $REALSON = "")
{
function UPDATEReviewer($DBHost, $DBUser, $DBPassword, $AccountDB, $ACCOUNT_ID)
{
$Realm1 = CountQueue(_HostDBSwitch(1), $DBUser, $DBPassword, _CharacterDBSwitch(1), $ACCOUNT_ID);
$Realm2 = CountQueue(_HostDBSwitch(2), $DBUser, $DBPassword, _CharacterDBSwitch(2), $ACCOUNT_ID);
$Realm3 = CountQueue(_HostDBSwitch(3), $DBUser, $DBPassword, _CharacterDBSwitch(3), $ACCOUNT_ID);
$Realm4 = CountQueue(_HostDBSwitch(4), $DBUser, $DBPassword, _CharacterDBSwitch(4), $ACCOUNT_ID);
$Realm5 = CountQueue(_HostDBSwitch(5), $DBUser, $DBPassword, _CharacterDBSwitch(5), $ACCOUNT_ID);
$connection = mysql_connect($DBHost, $DBUser, $DBPassword) or die(mysql_error());
_SelectDB($AccountDB, $connection);
$query = mysql_query("UPDATE `account_transfer_queue` SET\n `Realm1` = " . $Realm1 . ",\n `Realm2` = " . $Realm2 . ",\n `Realm3` = " . $Realm3 . ",\n `Realm4` = " . $Realm4 . ",\n `Realm5` = " . $Realm5 . "\n WHERE `id` = " . $ACCOUNT_ID . ";", $connection) or die(mysql_error());
mysql_close($connection);
}
<?php
ob_start();
session_start();
include_once "t_dbfunctions.php";
include_once "t_functions.php";
include_once "t_config.php";
if (isset($_POST['Approve']) && isset($_POST['RealmlistList']) && isset($_POST['GUID'])) {
$ACCOUNT_ID = _GetCharacterAccountID();
$ID = $_POST['Approve'];
$RealmID = $_POST['RealmlistList'];
$GUID = $_POST['GUID'];
if (_CheckCharacterOnlineStatus(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $GUID)) {
if (CheckTransferStatus($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID) == 0) {
if (_CheckGMAccess($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ACCOUNT_ID, $GMLevel)) {
ApproveCharacterTransfer(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID), $GUID);
UpdateDumpStatus($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, 1);
} else {
die("ACCESS DENIED:");
}
} else {
die("NOT \"IN PROGRESS\" STATUS");
}
} else {
die("LOG OFF WITH THIS CHARACTER! BEFORE MAKE ANY ACTIONS!");
}
} else {
die("SHIT HAPPENS, ERROR 29");
}
ob_end_flush();