CREATE TRIGGER prevent_brute_force AFTER INSERT ON login_att FOR EACH ROW BEGIN
    SELECT ip_add, was_success INTO @ip, @result FROM login_att ORDER BY login_att_id DESC LIMIT 1;
    SELECT ip_add INTO @check_ip FROM login_att WHERE login_att_time > DATE_SUB(NOW(), INTERVAL 3 MINUTE) AND ip_add = @ip HAVING COUNT(ip_add) > 4;
    IF @check_ip IS NOT NULL
    THEN
        IF @result = 0
        THEN
            INSERT INTO blacklisted_ips (ip_add) VALUES (@ip);
        END IF;
    END IF;
    SELECT username_att into @username_att FROM login_att WHERE login_att_time > DATE_SUB(NOW(), INTERVAL 2 MINUTE) AND was_success=0 HAVING COUNT(username_att) > 3;
    IF @username_att IS NOT NULL
    THEN
        INSERT INTO blacklisted_users (username) VALUES (@username_att);
    END IF;
END$$