Code:
internal class ReviveCommand : Command
{
public ReviveCommand() : base("revive", 85) { }
protected override bool Process(Player player, RealmTime time, string[] args)
{
if (string.IsNullOrEmpty(args[0]))
{
player.SendHelp("Usage: /revive <accId> <fame>");
return false;
}
player.Manager.Database.DoActionAsync(db =>
{
var cmd = db.CreateQuery();
cmd.CommandText = "UPDATE characters SET dead=0 WHERE accId=@accId AND fame=@base";
cmd.Parameters.AddWithValue("@base", args[1]);
cmd.Parameters.AddWithValue("@accId", args[0]);
if (cmd.ExecuteNonQuery() == 0)
{
player.SendInfo("Could not revive. Make sure you wrote it right.");
}
else
player.SendInfo("Character Successfully Revived");
});
return true;
}
}