$GEMrow .= $GEM3 . ":1 "; } } $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 = "")
} 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['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"); }
$realson = $L[119] . " '" . $SNA . "' <u>" . $L[119] . "!</u>"; } } } } } } } if (!empty($realson)) { _Migration_STEP2FORM($realson); } else { unset($_SESSION['STEP2']); $connection = _MySQLConnect(_HostDBSwitch($RealmID), $DBUser, $DBPassword, _CharacterDBSwitch($RealmID)); _updateCharacterName($connection, $CHAR_NAME, $GUID); _TalentsReset($connection, $GUID); _MoveToGMAccount($connection, $GUID); mysql_close($connection) or die(mysql_error()); $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB); _updateMigrationStatusAndCharacterName($connection, $ID, $CHAR_NAME, 0); mysql_close($connection) or die(mysql_error()); _PreparateMails(_LoadItemRoW($DBUser, $DBPassword, $ID), $CHAR_NAME, $TransferLetterTitle, $TransferLetterMessage, $SOAPUser, $SOAPPassword, $RealmID); echo _GDiv($L[51]); } } else { _Migration_STEP2FORM($L[56] . " '" . $CHAR_NAME . "' " . $L[57]); } function _Migration_STEP2FORM($TXT) { global $L; echo _RDiv($TXT) . "\n <div class = 'alert text-center'>" . $L[50] . "</div>\n <div class = 'text-center'>\n <br/>\n <form action = '" . $_SERVER['PHP_SELF'] . "' method = 'post' enctype = 'multipart/form-data'>\n <input class = 'clearfix' type = 'text' name = 'rename'>\n <p><button class = 'btn btn-primary' type = 'submit'>" . $L[146] . "</button></p>\n </form>\n </div>\n </div>"; }
} $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 = "")
include_once '../_core/_config.php'; include_once '../_core/_functions.php'; include_once '../_core/_dbfunctions.php'; ob_start(); session_start(); if (!isset($_POST['ID']) || !isset($_POST['R']) || !isset($_POST['GUID'])) { die($L[9]); } $ID = (int) $_POST['ID']; $RealmID = (int) $_POST['R']; $GUID = (int) $_POST['GUID']; if (!_doesRealmExists($RealmID, $DBUser, $DBPassword) || !_doesCharacterExistsOnAccount($DBUser, $DBPassword, $RealmID, $GUID)) { die($L[9]); } if (!_doesCharacterNotOnlineATM($DBUser, $DBPassword, $RealmID, $GUID)) { die($L[60]); } $connection = _MySQLConnect($AccountDBHost, $DBUser, $DBPassword, $AccountDB); if (!_isGMAllowed($connection)) { mysql_close($connection) or die(mysql_error()); die($L[224]); } if (!_getMigrationStatus($connection, $ID) == 0) { mysql_close($connection) or die(mysql_error()); die($L[225]); } mysql_close($connection) or die(mysql_error()); _PreparateMails(_LoadItemRoW($DBUser, $DBPassword, $ID), _GetCharacterNameAndDeleteMails($DBUser, $DBPassword, $RealmID, $GUID), $SOAPUser, $SOAPPassword, $RealmID); mysql_close($connection) or die(mysql_error()); ob_end_flush(); die($L[226]);