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