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();