function spambot_account_ip_addresses

Same name and namespace in other branches

1. 8.x-1.x spambot.module \spambot_account_ip_addresses() 1 comment

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()

spambot_account_is_spammer in ./spambot.module

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

_spambot_user_spam_admin_form_submit_check in ./spambot.pages.inc

Do complex checking at this user account.

File

./spambot.module, line 521

Code

function spambot_account_ip_addresses($account) {
    $hostnames = array();
    // Retrieve IPs from node_spambot table.
    $items = db_select('node_spambot')->distinct()
        ->fields('node_spambot', array(
        'hostname',
    ))
        ->condition('uid', $account->uid, '=')
        ->execute()
        ->fetchCol();
    $hostnames = array_merge($hostnames, $items);
    // Retrieve IPs from any sessions which may still exist.
    $items = db_select('sessions')->distinct()
        ->fields('sessions', array(
        'hostname',
    ))
        ->condition('uid', $account->uid, '=')
        ->execute()
        ->fetchCol();
    $hostnames = array_merge($hostnames, $items);
    // Retrieve IPs from comments.
    if (module_exists('comment')) {
        $items = db_select('comment')->distinct()
            ->fields('comment', array(
            'hostname',
        ))
            ->condition('uid', $account->uid, '=')
            ->execute()
            ->fetchCol();
        $hostnames = array_merge($hostnames, $items);
    }
    // Retrieve IPs from statistics.
    if (module_exists('statistics')) {
        $items = db_select('accesslog')->distinct()
            ->fields('accesslog', array(
            'hostname',
        ))
            ->condition('uid', $account->uid, '=')
            ->execute()
            ->fetchCol();
        $hostnames = array_merge($hostnames, $items);
    }
    // Retrieve IPs from user stats.
    if (module_exists('user_stats')) {
        $items = db_select('user_stats_ips')->distinct()
            ->fields('user_stats_ips', array(
            'ip_address',
        ))
            ->condition('uid', $account->uid, '=')
            ->execute()
            ->fetchCol();
        $hostnames = array_merge($hostnames, $items);
    }
    // Retrieve IPs from IP address manager.
    if (module_exists('ip')) {
        $items = db_select('ip_tracker')->distinct()
            ->fields('ip_tracker', [
            'ip',
        ])
            ->condition('uid', $account->uid, '=')
            ->execute()
            ->fetchCol();
        $rows = array();
        foreach ($items as $row) {
            if (isset($row->ip)) {
                $row->ip = long2ip($row->ip);
                $rows[] = $row;
            }
        }
        $hostnames = array_merge($hostnames, $rows);
    }
    $hostnames = array_unique($hostnames);
    return $hostnames;
}