static bool BanUser(string name, int ipBan = 0)
{
try
{
MySqlCommand q = new MySqlCommand("UPDATE users SET Ban=1 WHERE Username=@Username;", SQL);
q.Parameters.AddWithValue("@Username", name);
q.ExecuteNonQuery();
Client c = ClientFromUsername(name);
if (ipBan == 1)
{
MySqlCommand q2 = new MySqlCommand(string.Empty, SQL);
q2.CommandText = "INSERT INTO ipbans VALUES (@ip);";
q2.Parameters.AddWithValue("@ip", c.EndPoint.Address.ToString());
q2.ExecuteNonQuery();
}
if (c != null)
c.Disconnect();
Console.WriteLine(name + " has been dealt with.");
return true;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
return false;
}
}