function spambot_account_ip_addresses in Spambot 8

Same name and namespace in other branches

1. 6.3 spambot.module \spambot_account_ip_addresses()
2. 7 spambot.module \spambot_account_ip_addresses()

Retrieves a list of IP addresses for an account.

Parameters

object $account: Account to retrieve IP addresses for.

Return value

array An array of IP addresses, or an empty array if none found

2 calls to spambot_account_ip_addresses()

SpambotUserspamForm::checkSubmit in src/Form/SpambotUserspamForm.php

Function provide functional for "Check" button.

spambot_account_is_spammer in ./spambot.module

Checks an account to see if it's a spammer.

File

./spambot.module, line 231

Main module file.

Code

function spambot_account_ip_addresses($account) {
  $hostnames = [];

  // Retrieve IPs from any sessions which may still exist in the CMS.
  $items = \Drupal::database()
    ->select('sessions')
    ->distinct()
    ->fields('sessions', [
    'hostname',
  ])
    ->condition('uid', $account
    ->id(), '=')
    ->execute()
    ->fetchCol();
  $hostnames = array_merge($hostnames, $items);

  // Retrieve IPs from comments.
  $module_handler = \Drupal::moduleHandler();
  if ($module_handler
    ->moduleExists('comment')) {
    $comment_cid = \Drupal::database()
      ->select('comment_entity_statistics')
      ->distinct()
      ->fields('comment_entity_statistics', [
      'cid',
    ])
      ->condition('last_comment_uid', $account
      ->id(), '=')
      ->execute()
      ->fetchCol();
    if ($comment_cid) {
      $items = \Drupal::database()
        ->select('comment_field_data')
        ->distinct()
        ->fields('comment_field_data', [
        'hostname',
      ])
        ->condition('cid', $comment_cid, 'IN')
        ->execute()
        ->fetchCol();
    }
    else {
      $items = [];
    }
    $hostnames = array_merge($hostnames, $items);
  }
  $hostnames = array_unique($hostnames);
  return $hostnames;
}