$GEM3 = _GetGemID($value['G3']); if ($GEM1 > 1) { $GEMrow .= $GEM1 . ":1 "; } if ($GEM2 > 1) { $GEMrow .= $GEM2 . ":1 "; } if ($GEM3 > 1) { $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 {
if (!isset($_SESSION['guid']) || !isset($_SESSION['realm']) || !isset($_SESSION['dumpID'])) { $realson = $L[58]; } else { if (preg_match('/[\'^?$%&*()}{@#~?><>,|=_+¬-]./', $CHAR_NAME)) { $realson = $L[52]; } else { if (strstr($CHAR_NAME, " ")) { $realson = $L[53]; } else { if (preg_match("/[0-9]/", $CHAR_NAME)) { $realson = $L[54]; } else { if (mb_strlen($CHAR_NAME, 'UTF-8') > 16 && mb_strlen($CHAR_NAME, 'UTF-8') > 1) { $realson = $L[55]; } else { if (_CheckCharacterName($DBUser, $DBPassword, $RealmID, $CHAR_NAME) > 0) { $realson = $L[56] . " '" . $CHAR_NAME . "' " . $L[57]; } else { if (!_ServerOn($SIP, $SPT)) { $realson = $L[119] . " '" . $SNA . "' <u>" . $L[119] . "!</u>"; } } } } } } } if (!empty($realson)) { _Migration_STEP2FORM($realson); } else { unset($_SESSION['STEP2']);
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 { if (mb_strlen($CHAR_NAME, 'UTF-8') > 16 && mb_strlen($CHAR_NAME, 'UTF-8') > 1) { $realson = $write[95]; } 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";
$GEM3 = _GetGemID($value['G3']); if ($GEM1 > 1) { $GEMrow .= $GEM1 . ":1 "; } if ($GEM2 > 1) { $GEMrow .= $GEM2 . ":1 "; } if ($GEM3 > 1) { $GEMrow .= $GEM3 . ":1 "; } } $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]);