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>";
}
<?php

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 _FORM_ITEM_SHOP($SA, $RealmID, $DBUser, $DBPassword, $GUID, $ItemID, $MinPrice, $PriceX, $DisplayPrice, $ITEM_DISCOUNT_MODE, $DISCOUNT_CONF, $REALSON = "")
{
    global $L, $AccountDBHost, $AccountDB, $PageListRecordsAmmount;
    echo "\n        <fieldset>\n            <div class = 'text-center'>" . $REALSON . "\n                <h2>" . $L[82] . "</h2>";
    _FORM_CHAR_BLOCK($SA, null, true);
    echo "</fieldset>";
    $connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _WorldDBSwitch($RealmID));
    // -----------------------------------------------------------------
    if (isset($ItemID)) {
        $query = mysql_query("\n                SELECT\n                  `entry` AS `id`,\n                  `class`,\n                  `subclass`,\n                  `ItemLevel`,\n                  `RequiredLevel`,\n                  `Quality`,\n                  `name`\n                FROM `item_template`\n            WHERE `entry` = " . $ItemID . ";", $connection) or die(mysql_error());
        $QueryResult = mysql_fetch_array($query);
        if (!empty($QueryResult['id'])) {
            $PRICE = _CalculatePrise($QueryResult, $MinPrice, $PriceX);
            $DISCOUNT = null;
            if ($PRICE > 1 && $ITEM_DISCOUNT_MODE) {
                $DISCOUNT = round($PRICE - $PRICE * $DISCOUNT_CONF);
            }
            $_SESSION['TCA']['SItemPrice'] = isset($DISCOUNT) ? $DISCOUNT : $PRICE;
            $_SESSION['TCA']['SItemName'] = $QueryResult['name'];
            echo "\n                <fieldset class = 'text-center'>\n                <div style = 'width: 800px;' class = 'alert service alert-success'>\n                    <div class = 'service_icon'></div>\n                    <h4><a href = 'http://old.wowhead.com/item=" . $QueryResult['id'] . "' target = '_blank'></a></h4>\n                    <div class = 'service_desc'>" . _PRICE_STR($PRICE, true, isset($DISCOUNT) && $PRICE > $DISCOUNT ? $DISCOUNT : null) . "</div>\n                </div>\n                </fieldset></br>";
        }
    }
    // -----------------------------------------------------------------
    $ITEM_CLASS = _refleshSessionValue(isset($_SESSION['TCA']['ItemClass']) ? $_SESSION['TCA']['ItemClass'] : null, isset($_GET['C']) ? (int) $_GET['C'] : null, 2);
    if (!isset($_SESSION['TCA']['ItemClass']) || $_SESSION['TCA']['ItemClass'] != $ITEM_CLASS) {
        unset($_GET['page']);
        unset($_SESSION['TCA']['P']);
    }
    $_SESSION['TCA']['ItemClass'] = $ITEM_CLASS;
    $PAGE_INDEX = _refleshSessionValue(isset($_SESSION['TCA']['P']) ? $_SESSION['TCA']['P'] : null, isset($_GET['page']) ? (int) $_GET['page'] : null, 1);
    $PAGE_INDEX = $PAGE_INDEX < 1 ? 1 : $PAGE_INDEX;
    $_SESSION['TCA']['P'] = $PAGE_INDEX;
    if (isset($ITEM_CLASS) && $ITEM_CLASS === 7) {
        $ITEM_CLASS_Q_STR = isset($ITEM_CLASS) ? "WHERE `class` IN (5, 6, 7) ORDER BY `class`,`itemlevel`" : null;
    } else {
        $ITEM_CLASS_Q_STR = isset($ITEM_CLASS) ? "WHERE `class` = " . $ITEM_CLASS . " ORDER BY `itemlevel`" : null;
    }
    $query = mysql_query("\n            SELECT\n              `entry` AS `id`,\n              `class`,\n              `subclass`,\n              `ItemLevel`,\n              `RequiredLevel`,\n              `Quality`,\n              `name`\n            FROM `item_template` " . $ITEM_CLASS_Q_STR . "\n        DESC LIMIT " . ($PAGE_INDEX * $PageListRecordsAmmount - $PageListRecordsAmmount) . ", " . $PageListRecordsAmmount . ";", $connection) or die(mysql_error());
    mysql_close($connection);
    echo "\n            <fieldset class = 'text-center'>\n            <form action = " . $_SERVER['PHP_SELF'] . " method = 'POST'>\n            <div class = 'clearfix'>";
    if (isset($ItemID)) {
        echo "     \n                <input name = 'itemID' type = 'text' placeholder = '" . $L[19] . "'>\n            </div>\n            <p>\n                <button class = 'btn btn-primary' type = 'submit'>" . _getPriceButtonSTR(11) . "</button>\n            </p>\n            <input type = 'hidden' name = 'isItemSame' value = '" . $ItemID . "'/>";
    } else {
        echo "\n                <input name = 'itemID' type = 'text' placeholder = '" . $L[49] . "'>\n            </div>\n            <p>\n                <button class = 'btn btn-primary' type = 'submit'>" . $L[48] . "</button>\n            </p>";
    }
    echo "\n            </form>\n            </fieldset>\n            <ul class = 'nav nav-tabs'>\n                <li" . _getBISelector(2, $ITEM_CLASS) . "><a href = '?C=2'>" . $L[282] . "</a></li> <!-- Weapon -->\n                <li" . _getBISelector(4, $ITEM_CLASS) . "><a href = '?C=4'>" . $L[284] . "</a></li> <!-- Armor -->\n                <li" . _getBISelector(16, $ITEM_CLASS) . "><a href = '?C=16'>" . $L[296] . "</a></li> <!-- Glyph -->\n                <li" . _getBISelector(3, $ITEM_CLASS) . "><a href = '?C=3'>" . $L[283] . "</a></li> <!-- Gem -->\n                <li" . _getBISelector(9, $ITEM_CLASS) . "><a href = '?C=9'>" . $L[289] . "</a></li> <!-- Recipe -->\n\n                <li" . _getBISelector(0, $ITEM_CLASS) . "><a href = '?C=0'>" . $L[280] . "</a></li> <!-- Consumable -->\n                <li" . _getBISelector(1, $ITEM_CLASS) . "><a href = '?C=1'>" . $L[281] . "</a></li> <!-- Container --> \n                <li" . _getBISelector(7, $ITEM_CLASS, "title = '" . $L[285] . ", " . $L[286] . ", " . $L[287] . "' ") . "><a href = '?C=7'>" . $L[287] . "</a></li> <!-- Trade Goods -->\n                <li" . _getBISelector(12, $ITEM_CLASS) . "><a href = '?C=12'>" . $L[292] . "</a></li> <!-- Quest -->\n                <li" . _getBISelector(13, $ITEM_CLASS) . "><a href = '?C=13'>" . $L[293] . "</a></li> <!-- Key -->\n                <li" . _getBISelector(15, $ITEM_CLASS) . "><a href = '?C=15'>" . $L[295] . "</a></li> <!-- Miscellaneous -->\n            </ul>\n            " . _pushPageNav($PAGE_INDEX) . "\n            <table class = 'table table-condensed'>\n                <tr class = 'menuBar'>\n                    <td>" . $L[275] . "</td>\n                    <td>" . $L[64] . "</td>\n                    <td></td>\n                </tr>";
    while ($QueryResult = mysql_fetch_array($query)) {
        $PRICE = _CalculatePrise($QueryResult, $MinPrice, $PriceX);
        $DISCOUNT = null;
        if ($PRICE > 1 && $ITEM_DISCOUNT_MODE) {
            $DISCOUNT = round($PRICE - $PRICE * 0.1);
        }
        $class = isset($DISCOUNT) && $PRICE > $DISCOUNT ? "success" : "info";
        echo "\n                <tr class = '" . $class . "'>\n                <td><a href = 'http://" . _getWHLanguage() . "wowhead.com/item=" . $QueryResult['id'] . "' target = '_blank'></a></td>";
        if (isset($DISCOUNT) && $PRICE > $DISCOUNT) {
            echo "<td>" . _PRICE_STR($PRICE, true, $DISCOUNT) . "</td>";
        } else {
            echo "\n                <td>" . _PRICE_STR($PRICE, true) . "</td>";
        }
        echo "<td><a href = '" . _AddGETAtributeToURL("itemID", $QueryResult['id']) . "'>" . $L[299] . "</a></td>\n            </tr>";
    }
    echo "\n            </table>" . _pushPageNav($PAGE_INDEX);
}
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());
function _is_details_already_used($AccountDBHost, $AccountDB, $DBUser, $DBPassword, $D, $X)
{
    $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB);
    $query = mysql_query("SELECT `id` FROM `account` WHERE `" . $D . "` = '" . _X($X) . "';", $connection) or die(mysql_error());
    $result = mysql_num_rows($query);
    mysql_close($connection) or die(mysql_error());
    if ($result > 0) {
        return false;
    }
    return true;
}
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;
}
Exemple #9
0
        $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 = "")
{