public void OnCharacterListRequest(CharacterListRequestEvent e) { Server.Instance.Scheduler.RunTaskAsync( () => { ClientCharacterListResponsePacket response = new ClientCharacterListResponsePacket(); MySqlHandle mySqlHandle = Server.Instance.DatabaseManager.GetMySqlHandle(); try { mySqlHandle.Open(); List <CharacterInfo> characterInfos = mySqlHandle.CharactersGetCharacterInfos(e.Session.ActiveAccountInfo.AccountId); foreach (CharacterInfo characterInfo in characterInfos) { ClientCharacterListResponsePacket.CharacterData characterData = new ClientCharacterListResponsePacket.CharacterData(); characterData.CharacterInfo = characterInfo; response.CharacterDataList.Add(characterData); } mySqlHandle.Close(); } catch (Exception exc) { Server.Instance.LogDatabaseError(exc); } mySqlHandle.Free(); Server.Instance.SendGamePacket(response, ClientPacketId.MSG_CLIENT_CHARACTER_LIST_RESPONSE, e.Session.Address, e.Session.Port); } ); }
public void OnWorldCharacterDeleteRequestReceive(GamePacketReceiveEvent e) { if (e.Packet is WorldCharacterDeleteRequestPacket) { WorldCharacterDeleteRequestPacket request = (WorldCharacterDeleteRequestPacket)e.Packet; Session session = Server.Instance.SessionManager.GetSession(e.SourceAddress, e.SourcePort); if (session != null) { Server.Instance.Scheduler.RunTaskAsync( () => { long characterId = request.CharacterId; string name = String.Empty; bool isOwnedByRequester = false; MySqlHandle mySqlHandle = Server.Instance.DatabaseManager.GetMySqlHandle(); try { mySqlHandle.Open(); List <CharacterInfo> characterInfos = mySqlHandle.CharactersGetCharacterInfos(session.ActiveAccountInfo.AccountId); for (int i = 0; i < characterInfos.Count && !isOwnedByRequester; i++) { if (characterInfos[i].CharacterId == characterId) { isOwnedByRequester = true; name = characterInfos[i].Name; mySqlHandle.CharactersDeleteCharacter(characterId); } } mySqlHandle.Close(); } catch (Exception exc) { Server.Instance.LogDatabaseError(exc); } mySqlHandle.Free(); Server.Instance.Logger.Log("A client requested to delete a character. address=" + e.SourceAddress + " port=" + e.SourcePort + " name=" + name + " isOwnedByRequester=" + isOwnedByRequester); if (!isOwnedByRequester) { GeneralDisconnectNotifyPacket dcPacket = new GeneralDisconnectNotifyPacket(); dcPacket.DisconnectReason = DisconnectReason.CharacterNotFound; Server.Instance.SendGamePacket(dcPacket, GeneralPacketId.MSG_SERVER_DISCONNECT_NOTIFY, e.SourceAddress, e.SourcePort); } } ); } } }
public void OnWorldCharacterRenameRequestPacketReceive(GamePacketReceiveEvent e) { if (e.Packet is WorldCharacterRenameRequestPacket) { WorldCharacterRenameRequestPacket request = (WorldCharacterRenameRequestPacket)e.Packet; Session session = Server.Instance.SessionManager.GetSession(e.SourceAddress, e.SourcePort); if (session != null) { Server.Instance.Scheduler.RunTaskAsync( () => { ClientCharacterRenameResponsePacket response = new ClientCharacterRenameResponsePacket(); response.CharacterRenameResult = CharacterRenameResult.DenyInvalidCustomName; string oldName = String.Empty; string newName = request.NewName; long characterId = request.CharacterId; CharacterInfo characterInfo = null; MySqlHandle mySqlHandle = Server.Instance.DatabaseManager.GetMySqlHandle(); try { mySqlHandle.Open(); List <CharacterInfo> characterInfos = mySqlHandle.CharactersGetCharacterInfos(session.ActiveAccountInfo.AccountId); for (int i = 0; i < characterInfos.Count && characterInfo == null; i++) { if (characterInfos[i].CharacterId == characterId) { characterInfo = characterInfos[i]; } } if (characterInfo != null) { oldName = characterInfo.Name; bool success = mySqlHandle.CharactersSetPendingName(characterId, newName); if (success) { response.CharacterRenameResult = CharacterRenameResult.Allow; } else { response.CharacterRenameResult = CharacterRenameResult.DenyCustomNameTaken; mySqlHandle.CharactersUpdateLastLogout(characterId); } } mySqlHandle.Close(); } catch (Exception exc) { Server.Instance.LogDatabaseError(exc); } mySqlHandle.Free(); Server.Instance.SendGamePacket(response, ClientPacketId.MSG_CLIENT_CHARACTER_RENAME_RESPONSE, e.SourceAddress, e.SourcePort); Server.Instance.Scheduler.RunTask(() => Server.Instance.EventManager.Publish(new CharacterListRequestEvent(session))); Server.Instance.Logger.Log("A client requested to rename a character. address=" + e.SourceAddress + " port=" + e.SourcePort + " oldName=" + oldName + " newName=" + newName + " isOwnedByRequester=" + (characterInfo != null)); if (characterInfo != null) { GeneralDisconnectNotifyPacket dcPacket = new GeneralDisconnectNotifyPacket(); dcPacket.DisconnectReason = DisconnectReason.CharacterNotFound; Server.Instance.SendGamePacket(dcPacket, GeneralPacketId.MSG_SERVER_DISCONNECT_NOTIFY, e.SourceAddress, e.SourcePort); } } ); } } }
public void OnWorldLoginRequestPacketReceive(GamePacketReceiveEvent e) { if (e.Packet is WorldLoginRequestPacket) { WorldLoginRequestPacket request = (WorldLoginRequestPacket)e.Packet; Session session = Server.Instance.SessionManager.GetSession(e.SourceAddress, e.SourcePort); if (session != null) { Server.Instance.Scheduler.RunTaskAsync( () => { long characterId = request.CharacterId; CharacterInfo characterInfo = null; MySqlHandle mySqlHandle = Server.Instance.DatabaseManager.GetMySqlHandle(); try { mySqlHandle.Open(); List <CharacterInfo> characterInfos = mySqlHandle.CharactersGetCharacterInfos(session.ActiveAccountInfo.AccountId); for (int i = 0; i < characterInfos.Count && characterInfo == null; i++) { if (characterInfos[i].CharacterId == characterId) { characterInfo = characterInfos[i]; } } mySqlHandle.Close(); } catch (Exception exc) { Server.Instance.LogDatabaseError(exc); } mySqlHandle.Free(); if (characterInfo != null) { if (session.ActiveCharacterInfo == null || session.ActiveCharacterInfo.CharacterId == characterInfo.CharacterId) { if (characterInfo.ZoneId == 0) { characterInfo.ZoneId = 1000; } session.ActiveCharacterInfo = characterInfo; } ClientLoadStaticZonePacket response = new ClientLoadStaticZonePacket(); response.ZoneId = characterInfo.ZoneId; response.CloneId = characterInfo.CloneId; response.ZoneChecksum = Server.Instance.ZoneChecksumCache.GetZoneChecksum(characterInfo.ZoneId); response.EditorEnabled = (characterInfo.EditorLevel) > 0 ? (byte)1 : (byte)0; response.EditorLevel = characterInfo.EditorLevel; response.Position = characterInfo.Position; Server.Instance.SendGamePacket(response, ClientPacketId.MSG_CLIENT_LOAD_STATIC_ZONE, e.SourceAddress, e.SourcePort); } else { GeneralDisconnectNotifyPacket dcPacket = new GeneralDisconnectNotifyPacket(); dcPacket.DisconnectReason = DisconnectReason.CharacterNotFound; Server.Instance.SendGamePacket(dcPacket, GeneralPacketId.MSG_SERVER_DISCONNECT_NOTIFY, e.SourceAddress, e.SourcePort); } } ); } } }