function acquia_spi_get_failed_logins in Acquia Connector 6.2

Same name and namespace in other branches

1. 7.3 acquia_spi/acquia_spi.module \acquia_spi_get_failed_logins()
2. 7.2 acquia_spi/acquia_spi.module \acquia_spi_get_failed_logins()

Get the information on failed logins in the last cron interval

Parameters

n/a:

Return value

array

1 call to acquia_spi_get_failed_logins()

acquia_spi_get in acquia_spi/acquia_spi.module

Gather site profile information about this site.

File

acquia_spi/acquia_spi.module, line 1180

Send site profile information (NSPI) and system data to Acquia Insight.

Code

function acquia_spi_get_failed_logins() {
  $last_logins = array();
  $cron_interval = variable_get('acquia_spi_cron_interval', 8 * 60 * 60);
  if (module_exists('dblog')) {
    $query = 'SELECT message, variables, timestamp FROM {watchdog} WHERE message LIKE "login attempt failed%" AND now()-timestamp > %s ORDER BY timestamp DESC';
    $results = db_query($query, $cron_interval);
    while ($result = db_fetch_array($results)) {
      $variables = unserialize($result['variables']);
      $last_logins['failed'][$result['timestamp']] = check_plain($variables['%user']);
    }
  }
  return $last_logins;
}