public override Packet OnPacketReceive(Packet receivedPacket) { ClientPacketUpdatePet clientPacketUpdatePet = receivedPacket as ClientPacketUpdatePet; ConsoleHelper.Write("Receive - ClientPacketUpdatePet"); PLFPet pet = clientPacketUpdatePet.PetProfile; //insert new profile into DB MySqlCommand updatePetCommand = new MySqlCommand(); updatePetCommand.Connection = Program.mySQLManager.MySQLConnection.MysqlConnection; updatePetCommand.CommandText = $"UPDATE `T_Pet` SET `petType`='{(int)pet.PetType}',`petName`='{pet.PetName.ToSQL()}' WHERE `petID`='{pet.PetID}'"; ServerPacketConfirmation serverPacketConfirmation; try { updatePetCommand.ExecuteNonQuery(); serverPacketConfirmation = new ServerPacketConfirmation(true, NetworkError.NONE); } catch (Exception e) { serverPacketConfirmation = new ServerPacketConfirmation(false, NetworkError.GLOBAL_UNKNOWN); Console.WriteLine(e.Message); } ConsoleHelper.Write("Send - ServerPacketConfirmation"); return(serverPacketConfirmation); }
/// <summary> /// Updates the pet. /// </summary> /// <returns>The pet.</returns> /// <param name="pet">Pet.</param> public static ServerPacketConfirmation UpdatePet(PLFPet pet) { //create new client packet update pet ClientPacketUpdatePet clientPacketUpdatePet = new ClientPacketUpdatePet(0, pet); //send packet to the server ServerPacketConfirmation serverPacketConfirmation = TCPClient.SendPacket(clientPacketUpdatePet) as ServerPacketConfirmation; //if no answer if (serverPacketConfirmation == null) { return(new ServerPacketConfirmation(false, NetworkError.SERVER_UNAVAILABLE)); } return(serverPacketConfirmation); }