public bool isBanned(string ipAddress, string machineID, out string Reason) { Reason = ""; Database Database = new Database(false, true); Database.addParameterWithValue("ip", ipAddress); Database.addParameterWithValue("machineid", machineID); Database.Open(); if (Database.Ready) { Reason = Database.getString("SELECT reason FROM moderation_bans WHERE ip = @ip OR machineid = @machineid AND expires > NOW() LIMIT 1"); } return (Reason.Length > 0); }
/// <summary> /// Retrieves the username of a user, when only the user ID is known. /// </summary> /// <param name="userID">The user ID of the user to get the username of.</param> public string getUsername(int userID) { Database Database = new Database(false, true); Database.addParameterWithValue("userid", userID); Database.Open(); return Database.getString("SELECT username FROM users WHERE id = @userid"); }
/// <summary> /// Returns true if the given user is (still) banned. If so, then the ban reason is passed through the out Reason string. /// </summary> /// <param name="userID">The database ID of the user to check.</param> /// <param name="Reason">A string that should be passed with the out parameter and which will contain the banreason if banned.</param> public bool isBanned(int userID, out string Reason) { Reason = ""; Database Database = new Database(false, true); Database.addParameterWithValue("userid", userID); Database.Open(); if (Database.Ready) { Reason = Database.getString("SELECT reason FROM moderation_bans WHERE userid = @userid AND expires > NOW() LIMIT 1"); } return (Reason.Length > 0); }