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);
}
