function FlushStatisticTable($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, $GMLevel, $TEXT1, $TEXT2, $TEXT3, $TEXT4, $TEXT5, $TEXT6, $TEXT7, $TEXT8, $TEXT9, $TEXT10, $TEXT11, $TEXT12, $TEXT13)
{
    if (_CheckGMAccess($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, $GMLevel)) {
        echo "<div align = right class = \"MythTable\" style = \"width: 100%; padding-right: 2px;font-family: 'Tahoma';\">" . $TEXT1 . "</div>\n            <br>";
        $connection = mysql_connect($AccountDBHost, $DBUser, $DBPassword);
        _SelectDB($AccountDB, $connection);
        $query = mysql_query("SELECT * FROM `account_transfer` WHERE `gmAccount` = " . $ID . " ORDER BY `id` DESC LIMIT 25;", $connection);
        mysql_close($connection);
    } else {
        echo "\n            <div align = right style = \"width: 100%; padding-right: 2px;font-family: 'Tahoma'; \">" . $TEXT2 . "</div>\n            <br>\n            <div style = \"font-size:17px\">" . $TEXT3 . "</div>\n            <div class = \"MythInput\">\n                <form action=\"" . $_SERVER["SCRIPT_NAME"] . "\" method=\"post\" enctype=\"multipart/form-data\">\n                    <input type=\"submit\" name = \"load\" value=\"" . $TEXT4 . "\"/>\n                </form>\n            </div>\n            <div align = right class = \"MythTable\" style = \"width: 100%; padding-right: 2px;font-family: 'Tahoma';\">" . $TEXT5 . "</div>";
        $connection = mysql_connect($AccountDBHost, $DBUser, $DBPassword);
        _SelectDB($AccountDB, $connection);
        $query = mysql_query("SELECT * FROM `account_transfer` WHERE `cAccount` = " . $ID . " ORDER BY `id` DESC LIMIT 25;", $connection);
        mysql_close($connection);
    }
    echo "\n            <div style = \"white-space: nowrap; border-top-width: 1px; border-top-style: solid; padding-top: 8px; margin-top: 8px;\">\n            <table width = 100% align = center >\n                <tr bgcolor = #FFEAC7>";
    if (_CheckGMAccess($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, $GMLevel)) {
        echo "\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>Server URL:             </td>\n                <td>Admin Options:          </td>\n            </tr>";
        while ($row = mysql_fetch_array($query)) {
            if ($row["cStatus"] == 0) {
                echo "\n                    <tr bgcolor = #FFFFCC>\n                        <td>" . $row["cNameNEW"] . " / " . $row["cNameOLD"] . "</td>\n                        <td>" . _CheckRealm($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $row["cRealm"]) . " / " . $row["oRealm"] . "</td>\n                        <td>" . $row["oRealmlist"] . "</td>\n                        <td>" . $row["oAccount"] . "</td>\n                        <td>" . base64_decode($row["oPassword"]) . "</td>\n                        <td>" . $row["oServer"] . "</td>\n                        <td align = center>\n                            <button name = \"Approve\" id = \"" . $row["id"] . "\" onclick = \"javascript:DoApprove('" . $row["id"] . "', '" . $row["cRealm"] . "', '" . $row["GUID"] . "');\" style = \"font-size:10px\"><font color = \"green\">" . $TEXT6 . "</font></button><br>\n                            <button name = \"Deny\" id = \"" . $row["id"] . "\" onclick = \"javascript:DoDeny('" . $row["id"] . "', '" . $row["cRealm"] . "', '" . $row["GUID"] . "');\" style = \"font-size:10px\"><font color = \"red\">" . $TEXT7 . "</font></button><br>\n                            <button name = \"Resend\" id = \"" . $row["id"] . "\" onclick = \"javascript:DoResend('" . $row["id"] . "', '" . $row["cRealm"] . "', '" . $row["GUID"] . "');\" style = \"font-size:10px\"><font color = \"purple\">Resend</font></button>\n                        </td>\n                    </tr>";
            }
        }
    } else {
        echo "\n                <td>No.:            </td>\n                <td>Character Name: </td>\n                <td>Realm:          </td>\n                <td>Status:         </td>\n                <td>Options:        </td>\n            </tr>";
        while ($row = mysql_fetch_array($query)) {
            echo "\n                    <tr bgcolor = #FFFFCC>\n                        <td align = center bgcolor = #FFEAC7>" . $row["id"] . "</td>\n                        <td>" . $row["cNameNEW"] . "</td>\n                        <td align = center>" . _CheckRealm($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $row["cRealm"]) . "</td>\n                        <td bgcolor = #FFEAC7 " . _CheckReason($row["cStatus"], $row["Reason"]) . ">" . _CheckStatus($row["cStatus"], $TEXT8, $TEXT9, $TEXT10, $TEXT11, $TEXT12, $row["Reason"]) . "</td>\n                        <td align = center>";
            if ($row["cStatus"] == 0) {
                echo "<button name = \"cancel\" id = \"" . $row["id"] . "\" onclick = \"javascript:DoCancel('" . $row["id"] . "', '" . $row["cRealm"] . "', '" . $row["GUID"] . "');\" style = \"font-size:10px\"><font color = \"purple\">" . $TEXT13 . "</button>";
            }
            echo "  </td>\n                    </tr>";
        }
    }
    echo "</table></div>";
}
示例#2
0
function AddComment($AccountDBHost, $DBUser, $DBPassword, $AccountDB, $ID, $REASON)
{
    $connection = mysql_connect($AccountDBHost, $DBUser, $DBPassword) or die(mysql_error());
    _SelectDB($AccountDB, $connection);
    $query = mysql_query("UPDATE `account_transfer` SET `Reason` = \"" . _X($REASON) . "\" WHERE `id` = " . (int) $ID . ";", $connection) or die(mysql_error());
    mysql_close($connection);
}
示例#3
0
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\">";
    $connection = mysql_connect($AccountDBHost, $DBUser, $DBPassword);
    _SelectDB($AccountDB, $connection);
    $result = mysql_query("SELECT `id`,`name` FROM `realmlist` WHERE `TransferAvailable` = 1;");
    mysql_close($connection);
    while ($row = mysql_fetch_array($result)) {
        echo "<option name=\"" . $row['id'] . "\">" . $row['name'] . "</option>";
    }
    echo "</select><tr><td>\n            <tr><td><div align = right class = \"MythTable\">" . $TEXT5 . "</div></td></tr>\n                <tr><td><b>Server URL: </b><input name=\"ServerUrl\" type=\"text\" size=\"60\" style = \"float: right;\"></td></tr>\n            <tr><td><div align = right class = \"MythTable\">" . $TEXT6 . "</div></td></tr>\n            </table>\n                <div class = \"MythInput\">\n                    <style = \"font-size:14px\">" . $TEXT7 . "</style>\n                    <input type=\"file\" name=\"file\" id=\"file\" />\n                    <input type=\"submit\" name=\"load\" value=\"" . $TEXT8 . "\" />\n                </div>\n        </form>";
}
示例#4
0
<?php

include_once "t_dbfunctions.php";
include_once "t_functions.php";
include_once "t_config.php";
if (isset($_POST['rename'])) {
    $CHAR_NAME = mb_convert_case(trim($_POST['rename']), MB_CASE_TITLE, 'UTF-8');
    $GUID = $_SESSION['guid'];
    $RealmID = $_SESSION['realm'];
    $ID = $_SESSION['dumpID'];
    $realson = "";
    $connection = mysql_connect($AccountDBHost, $DBUser, $DBPassword);
    _SelectDB($AccountDB, $connection);
    $result = mysql_query("SELECT `name`,`address`,`port` FROM `realmlist` WHERE `id` = " . $RealmID . ";", $connection) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $SPT = $row["port"];
    $SNA = $row["name"];
    $SIP = $row["address"];
    mysql_close($connection);
    if (!isset($_SESSION['guid']) || !isset($_SESSION['realm']) || !isset($_SESSION['dumpID']) || $_SESSION['STEP2'] != "YES") {
        $realson = $write[98];
    } else {
        if (preg_match('/[\'^?$%&*()}{@#~?><>,|=_+¬-]./', $CHAR_NAME)) {
            $realson = $write[92];
        } else {
            if (strstr($CHAR_NAME, " ")) {
                $realson = $write[93];
            } else {
                if (preg_match("/[0-9]/", $CHAR_NAME)) {
                    $realson = $write[94];
                } else {
     Step1Form($AccountDB, $AccountDBHost, $DBUser, $DBPassword, $write[70], $write[71], $write[72], $write[79], $write[74], $write[76], $write[63], $write[77], $realson);
 } else {
     $_SESSION['STEP2'] = "NO";
     $char_money = _MaxValue($json['uinf']['money'], $MaxMoney);
     $char_speccount = $json['uinf']['specs'];
     $char_gender = $json['uinf']['gender'] - 2 == 1 ? 1 : 0;
     $char_totalkills = $json['uinf']['kills'];
     $char_arenapoints = _MaxValue($json['uinf']['arenapoints'], $MaxAP);
     $char_honorpoints = _MaxValue($json['uinf']['honor'], $MaxHP);
     $INVrow = "";
     $GEMrow = "";
     $CURrow = "";
     $row = "";
     $QUERYFOREXECUTE = "";
     $connection = mysql_connect(_HostDBSwitch($CHAR_REALM), $DBUser, $DBPassword);
     _SelectDB(_CharacterDBSwitch($CHAR_REALM), $connection);
     mysql_query("\n            INSERT INTO `characters`(`guid`,`name`,`level`,`gender`,`totalHonorPoints`,`arenaPoints`,`totalKills`,`money`,`class`,`race`,`at_login`,`account`,`taximask`,`speccount`,`online`) VALUES (\n            " . $GUID . ",\"" . _X($CHAR_NAME) . "\"," . (int) $CharLevel . "," . (int) $char_gender . "," . (int) $char_honorpoints . "," . (int) $char_arenapoints . ",\n            " . (int) $char_totalkills . "," . (int) $char_money . "," . $ClassID . "," . $RaceID . ", 0x180, 1, \"0 0 0 0 0 0 0 0 0 0 0 0 0 0\"," . (int) $char_speccount . ", 0);", $connection);
     $QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n            INSERT INTO `character_transfer` VALUES (" . $GUID . "," . $CHAR_ACCOUNT_ID . "," . $GM_ACCOUNT_ID . "," . $ID . ");\n\n            UPDATE `characters` SET\n            `position_x`    = 5741.36,\n            `position_y`    = 626.982,\n            `position_z`    = 648.354,\n            `map`           = 571,\n            `health`        = 100,\n            `zone`          = 4395,\n            `cinematic`     = 1\n                WHERE `guid` = " . $GUID . ";";
     if ($char_speccount == 2) {
         LearnSeparateSpell(63644, $GUID, $connection);
         LearnSeparateSpell(63645, $GUID, $connection);
     }
     if ($ClassID == 6) {
         $QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n " . DeathKnightTransfer($GUID);
     }
     foreach ($json['glyphs'] as $key => $value) {
         $GlyphID1 = _GetGlyphID($value[0][0]);
         $GlyphID2 = _GetGlyphID($value[0][1]);
         $GlyphID3 = _GetGlyphID($value[0][2]);
         $GlyphID4 = _GetGlyphID($value[1][0]);
         $GlyphID5 = _GetGlyphID($value[1][1]);
function _TalentsReset($DBHost, $DBUser, $DBPassword, $CharactersDB, $GUID)
{
    $connection = mysql_connect($DBHost, $DBUser, $DBPassword) or die(mysql_error());
    _SelectDB($CharactersDB, $connection);
    $query = mysql_query("UPDATE `characters` SET `at_login` = `at_login`|4|16 WHERE `guid` = " . $GUID . ";", $connection) or die(mysql_error());
    mysql_close($connection);
}