}
$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 = "")
{
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\">";
} 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>";
}
