Auxilium_Server.Program.BanUser C# (CSharp) Method

BanUser() static private method

static private BanUser ( string name, int ipBan ) : bool
name string
ipBan int
return bool
        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;
            }
        }