Provide UI to remove blocks from flood

I would like this, too, my clients like to forget their passwords :-)

Got a custom module with view and Vbo. For any help let me know. Might upload it to github as well.

#2 any chance you can upload it somewhere, will save me the time of writing it ;-)

Hi

Sorry for the late reply. Providing an extra module. This module is a extension for flood_control module.
The zip file also contains a text file with exported view to manage user flood.
In the flood control tick the checkbox - Failed login (username only)- the module already contains the patch http://drupal.org/node/1825544.
In the view fields click the Bulk operations: User (User) | enable the unflood vbo.

For any enquiries please let me know.
Enjoy

https://drupal.org/project/flood_unblock

Maybe this module can do the things.

At the moment it can not. With the flood_unblock you can empty the flood table. This is all what it does.

The cbp module does this by way of deleting a blocked IP OR by setting a whitelist on an IP which you could then simply remove. It also has other features though, but it does have this functionality. It also clears the flood entries for a user if they use a "reset/one-time login" link as well. Oh, and it also uses this module as a dependency as well for the actual flood settings themselves since it does a good enough job with that.

So this doesn't get lost, here's my attempt to get a working filter. It didn't work. Maybe someone else can add the remaining parts, or maybe it isn't possible...

ERROR:

SQLSTATE[42000]: Syntax error or access violation: 1056 Can't group on 'flood_locked'

SELECT DISTINCT users.uid AS uid, users.name AS users_name, users.status AS users_status, users.created AS users_created, users.access AS users_access, flood.event AS flood_event, flood.identifier AS flood_identifier, COUNT(flood.identifier AND flood.timestamp > 1428607022) AS flood_locked
FROM 
{users} users
LEFT JOIN {flood} flood ON users.uid = flood.identifier
GROUP BY flood_locked, uid
HAVING (( (flood_locked < 3) ))

    $data['flood']['locked'] = array(
      'title' => t('Flood locked'),
      'help' => t('Whether or not a user is flood locked.'),
      'field' => array(
        'handler' => 'views_handler_field_flood_control_locked',
        'click sortable' => TRUE,
      ),
      'filter' => array(
        'handler' => 'views_handler_filter_flood_control_locked',
        'use equal' => 'FALSE',
      ),
      'sort' => array(
        'handler' => 'views_handler_sort',
      ),
    );

/**
 * @file
 * Definition of views_handler_filter_flood_control_locked.
 */

/**
 * Class views_handler_filter_flood_control_locked.
 */
class views_handler_filter_flood_control_locked extends views_handler_filter_boolean_operator {
  function query() {
    $this->ensure_my_table();

    // COUNT(flood.identifier AND flood.timestamp > {timestamp})
    $timestamp = REQUEST_TIME - variable_get('user_failed_login_user_window', 21600);
    $this->field_alias = $this->query->add_field(NULL, "{$this->table_alias}.identifier AND {$this->table_alias}.timestamp > $timestamp",
      $this->table_alias . '_' . $this->real_field,
      array('function' => 'count')
    );
    $this->query->add_groupby($this->field_alias);

    $operator = '>=';
    if (empty($this->value)) {
      $operator = '<';
    }
    $limit = variable_get('user_failed_login_user_limit', 5);
    $this->query->add_having_expression(NULL, "{$this->field_alias} $operator $limit");
  }
}

After #8, I figured out what was needed for the filter. Let's give the full patch a whirl.

Fixed a logic error in the conditional check inside flood_control_operations_unlock_flood()

#12 applied cleanly to the dev version and worked great! All that is required, is to add the VBO action to the Administration Users view when using Administration Views in combination with VBO as an example.

I close this because it is a request for the 7.x version.

The D7 version is still listed as supported, is there a particular reason why you're not willing to commit the patch?

This patch was customized so it can apply to dev versions downloaded from d.o.

Opened MR to easily merge this one, seems widely used in production

Thank you

Thanks, this is merged into the 7 dev version

Just in time for the D7 EOL. Impressive. Only took 11yrs to add...... to dev. Trying to figure out of the statement of "Better late than never" actually applies Lol

@crystaldawn : thanks for the feedback.

It may look like a joke that it took such a long time, but there is a reason for this.
For a long time, this module was maintained minimally. We only took over maintenance last year and started adding features and cleaning up the issue queue.

This simply adds a vbo action which we can add on admin users views. If I am not mistaken, this does not add any UI to see who is locked, we still need the other module "flood_unblock" on Drupal 7 in order to have the UI at "admin/config/system/flood-unblock".

Or am I missing something?