
Originally Posted by
Anime
Not sure if this has already been released, but here it is.
Code:
internal class UnbanCommand : Command
{
public UnbanCommand() :
base("unban", permLevel: {Rank})
{
}
protected override bool Process(Player player, RealmTime time, string[] args)
{
var p = player.Manager.FindPlayer(args[0]);
player.Manager.Database.DoActionAsync(db =>
{
var cmd = db.CreateQuery();
cmd.CommandText = "UPDATE accounts SET banned=0 WHERE id=@accId;";
cmd.Parameters.AddWithValue("@accId", p.AccountId);
cmd.ExecuteNonQuery();
});
return true;
}
}
Just change the {Rank} to the rank you want it to have.
Pretty sure this wont work
Code:
internal class UnbanCommand : Command
{
public UnbanCommand() :
base("unban", permLevel: {Rank})
{
}
protected override bool Process(Player player, RealmTime time, string[] args)
{
var p = player.Manager.FindPlayer(args[0]);
player.Manager.Database.DoActionAsync(db =>
{
var cmd = db.CreateQuery();
cmd.CommandText = "UPDATE accounts SET banned=0 WHERE id=@accId;";
cmd.Parameters.AddWithValue("@accId", p.AccountId);
cmd.ExecuteNonQuery();
});
return true;
}
}
var p = player.Manager.FindPlayer(args[0]);
this will try to get a player from the ingame, and since he player is banned he cant be ingame.
using args[0] only though will work
Code:
internal class UnbanCommand : Command
{
public UnbanCommand() :
base("unban", permLevel: {Rank})
{
}
protected override bool Process(Player player, RealmTime time, string[] args)
{
player.Manager.Database.DoActionAsync(db =>
{
var cmd = db.CreateQuery();
cmd.CommandText = "UPDATE accounts SET banned=0 WHERE name=@Name;";
cmd.Parameters.AddWithValue("@Name", args[0]);
cmd.ExecuteNonQuery();
});
return true;
}
}
@
Anime