} 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>";
}
}
}
$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 = "")
{
if (!_ServerOn($SIP, $SPT)) {
$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>";
