$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]);
