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());
}
}
$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)
{
global $L;
return empty($X) ? $L[39] : $X;
}
}
if (!isset($_POST['cur_password']) || !isset($_POST['new_password']) || !isset($_POST['new_password2']) || empty($_POST['cur_password']) || empty($_POST['new_password']) || empty($_POST['new_password2'])) {
$reason = _BDiv($L[214]);
} else {
if ($_POST['new_password'] !== $_POST['new_password2']) {
$reason = _RDiv($L[211]);
} else {
$SHA1Password = SHA1Password(_getUsername(), _Z($_POST['cur_password']));
$SHA1PasswordNEW = SHA1Password(_getUsername(), _Z($_POST['new_password']));
$connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB);
$query = mysql_query("SELECT `id` FROM `account` WHERE `username` = '" . _getUsername() . "' AND `sha_pass_hash` = '" . _X($SHA1Password) . "';", $connection) or die(mysql_error());
$result = mysql_fetch_array($query);
if (!empty($result['id'])) {
mysql_query("UPDATE `account` SET `sha_pass_hash` = '" . _X($SHA1PasswordNEW) . "',`sessionkey` = '',`v` = '',`s` = '' WHERE `username` = '" . _getUsername() . "';", $connection) or die(mysql_error());
_SpendMythCoins(0, 13, "", 0, "", 0, "", $connection);
$reason = _BDiv($L[213]);
mysql_close($connection) or die(mysql_error());
} else {
$reason = _RDiv($L[212]);
mysql_close($connection) or die(mysql_error());
}
}
}
?>
<div class = 'text-center'>
<h2><?php
echo $L[93];
?>
</h2>
<?php
echo $reason;
function _FORM_TO_CHAR_ACTIONS($CA, $HEADER, $REALSON = "", $PRICE, $NL = null, $NN = null, $NR = null, $NC = null, $C = null)
{
global $L;
echo "\n <form action = " . $_SERVER['PHP_SELF'] . " method = 'POST'>\n <fieldset>\n <div class = 'text-center'>" . $REALSON . "\n <h2>" . $HEADER . "</h2>\n <fieldset>";
_FORM_CHAR_BLOCK($CA, $L[114]);
_FORM_CHAR_BLOCK($CA, $L[115], true, $NL, $NN, $NR, $NC, $C);
echo "</fieldset>" . _BDiv(_PRICE_STR($PRICE)) . "\n <p><button class = 'btn btn-primary' type = 'submit'>" . _getPriceButtonSTR($PRICE) . "</button></p>\n </div>\n </fieldset>\n </form>";
}
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_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>";
}
