Example #1
0
                $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 {
Example #2
0
 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']);
Example #3
0
 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";
Example #4
0
     $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]);