public void Death(Account acc, Char chr, string killer)
{
MySqlCommand cmd = CreateQuery();
cmd.CommandText = @"UPDATE characters SET
dead=TRUE,
deathTime=NOW()
WHERE accId=@accId AND charId=@charId;";
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
cmd.Parameters.AddWithValue("@charId", chr.CharacterId);
cmd.ExecuteNonQuery();
bool firstBorn;
int finalFame = chr.FameStats.CalculateTotal(acc, chr, chr.CurrentFame, out firstBorn);
cmd = CreateQuery();
cmd.CommandText = @"UPDATE stats SET
fame=fame+@amount,
totalFame=totalFame+@amount
WHERE accId=@accId;";
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
cmd.Parameters.AddWithValue("@amount", finalFame);
cmd.ExecuteNonQuery();
if (acc.Guild.Id != 0)
{
cmd = CreateQuery();
cmd.CommandText = @"UPDATE guilds SET
guildFame=guildFame+@amount,
totalGuildFame=totalGuildFame+@amount
WHERE name=@name;";
cmd.Parameters.AddWithValue("@amount", finalFame);
cmd.Parameters.AddWithValue("@name", acc.Guild.Name);
cmd.ExecuteNonQuery();
cmd = CreateQuery();
cmd.CommandText = @"UPDATE accounts SET
guildFame=guildFame+@amount
WHERE id=@id;";
cmd.Parameters.AddWithValue("@amount", finalFame);
cmd.Parameters.AddWithValue("@id", acc.AccountId);
cmd.ExecuteNonQuery();
}
cmd = CreateQuery();
cmd.CommandText =
@"INSERT INTO death(accId, chrId, name, charType, tex1, tex2, items, fame, fameStats, totalFame, firstBorn, killer)
VALUES(@accId, @chrId, @name, @objType, @tex1, @tex2, @items, @fame, @fameStats, @totalFame, @firstBorn, @killer);";
cmd.Parameters.AddWithValue("@accId", acc.AccountId);
cmd.Parameters.AddWithValue("@chrId", chr.CharacterId);
cmd.Parameters.AddWithValue("@name", acc.Name);
cmd.Parameters.AddWithValue("@objType", chr.ObjectType);
cmd.Parameters.AddWithValue("@tex1", chr.Tex1);
cmd.Parameters.AddWithValue("@tex2", chr.Tex2);
cmd.Parameters.AddWithValue("@items", chr._Equipment);
cmd.Parameters.AddWithValue("@fame", chr.CurrentFame);
cmd.Parameters.AddWithValue("@fameStats", chr.PCStats);
cmd.Parameters.AddWithValue("@totalFame", finalFame);
cmd.Parameters.AddWithValue("@firstBorn", firstBorn);
cmd.Parameters.AddWithValue("@killer", killer);
cmd.ExecuteNonQuery();
}