condition('uid', $account->uid, '=')
->countQuery()->execute()->fetchField();
if (module_exists('comment')) {
$comment_count = db_select('comment')->condition('uid', $account->uid, '=')
->countQuery()->execute()->fetchField();
$status = t('This account has @n nodes and @c comments.', array('@n' => $node_count, '@c' => $comment_count));
}
else {
$status = t('This account has @n nodes.', array('@n' => $node_count));
}
$form['check'] = array(
'#type' => 'submit',
'#value' => t('Check if this account matches a known spammer'),
);
$form['action'] = array(
'#type' => 'fieldset',
'#title' => t('Take action against this account'),
'#collapsible' => TRUE,
'#description' => $status,
);
$form['action']['unpublish_content'] = array(
'#type' => 'checkbox',
'#title' => t('Unpublish nodes and comments by this account'),
'#default_value' => TRUE,
);
$form['action']['delete_content'] = array(
'#type' => 'checkbox',
'#title' => t('Delete nodes and comments by this account'),
'#default_value' => FALSE,
);
$form['action']['report'] = array(
'#type' => 'fieldset',
'#title' => t('Report this account to www.stopforumspam.com'),
'#tree' => TRUE,
'#collapsible' => TRUE,
'#description' => t('An API key from www.stopforumspam.com is required to report spammers.
Select one or more posts below to report them to www.stopforumspam.com.'),
);
// Fetch a list of reportable nodes
$form['action']['report']['nids'] = array();
$result = db_select('node_spambot')->fields('node_spambot', array('nid', 'hostname'))->condition('uid', $account->uid)->orderBy('nid', 'DESC')->range(0, 20)->execute();
$nid_hostnames = array();
foreach ($result as $record) {
$nid_hostnames[$record->nid] = $record->hostname;
}
foreach ($nid_hostnames as $nid => $hostname) {
$node = node_load($nid);
if (!empty($node->nid)) {
$form['action']['report']['nids'][$nid] = array(
'#type' => 'checkbox',
'#title' => l(mb_strimwidth($node->title, 0, 128, '...'), 'node/' . $nid, array('attributes' => array('title' => mb_strimwidth($node->body['und'][0]['summary'] . "\n\n" . $node->body['und'][0]['value'], 0, 256, '...')))) . ' ' . t('(node, ip=@ip)', array('@ip' => $hostname)),
);
}
}
// Fetch a list of reportable comments
if (module_exists('comment')) {
$form['action']['report']['cids'] = array();
$result = db_select('comment')->fields('comment', array('cid'))->condition('uid', $account->uid)->orderBy('cid', 'DESC')->range(0, 20)->execute();
$cids = array();
foreach ($result as $record) {
$cids[$record->cid] = $record->cid;
}
foreach ($cids as $cid) {
$comment = comment_load($cid);
if (!empty($comment->cid)) {
$form['action']['report']['cids'][$cid] = array(
'#type' => 'checkbox',
'#title' => l(mb_strimwidth($comment->subject, 0, 128, '...'), 'node/' . $comment->nid, array('fragment' => 'comment-'. $comment->cid, 'attributes' => array('title' => mb_strimwidth($comment->comment_body['und'][0]['value'], 0, 256, '...')))) . ' ' . t('(comment, ip=@ip)', array('@ip' => $comment->hostname)),
);
}
}
}
$form['action']['block_user'] = array(
'#type' => 'checkbox',
'#title' => t('Block this account'),
'#default_value' => TRUE,
);
$form['action']['delete_user'] = array(
'#type' => 'checkbox',
'#title' => t('Delete this account'),
'#default_value' => FALSE,
);
$form['action']['action'] = array(
'#type' => 'submit',
'#value' => t('Take action'),
);
$form['uid'] = array('#type' => 'value', '#value' => $account->uid);
return $form;
}
function spambot_user_spam_admin_form_validate($form, &$form_state) {
$key_required = (!empty($form_state['values']['report']['nids']) && count(array_filter($form_state['values']['report']['nids']))) ? TRUE : FALSE;
if (module_exists('comment')) {
$key_required = (!empty($form_state['values']['report']['cids']) && count(array_filter($form_state['values']['report']['cids']))) || $key_required;
}
if ($key_required && (!variable_get('spambot_sfs_api_key', FALSE))) {
form_set_error('', t('To report spammers to www.stopforumspam.com, you need to register for an API key at www.stopforumspam.com and enter it into the !page.', array('!page' => l('spambot settings', 'admin/config/system/spambot'))));
}
}
function spambot_user_spam_admin_form_submit($form, &$form_state) {
$account = user_load($form_state['values']['uid']);
if ($form_state['values']['op'] == $form_state['values']['check']) {
// This is a more comprehensive check than the automated criteria checks.
// This tests everything.
$messages = array();
$service_down = FALSE;
// Check email and username
$request = array('email' => $account->mail, 'username' => $account->name);
$data = array();
if (spambot_sfs_request($request, $data)) {
if (!empty($data['email']['appears'])) {
$messages[] = t('This account\'s email address matches @num times: !link', array('!link' => l($request['email'], 'http://www.stopforumspam.com/search?q=' . $request['email']), '@num' => $data['email']['frequency']));
}
if (!empty($data['username']['appears'])) {
$messages[] = t('This account\'s username matches @num times: !link', array('!link' => l($request['username'], 'http://www.stopforumspam.com/search?q=' . $request['username']), '@num' => $data['username']['frequency']));
}
}
else {
drupal_set_message(t('Error contacting service.'), 'warning');
$service_down = TRUE;
}
// Check IP addresses
if (!$service_down) {
$ips = spambot_account_ip_addresses($account);
foreach ($ips as $ip) {
// Skip the loopback interface
if ($ip == '127.0.0.1') {
continue;
}
$request = array('ip' => $ip);
$data = array();
if (spambot_sfs_request($request, $data)) {
if (!empty($data['ip']['appears'])) {
$messages[] = t('An IP address !ip used by this account matches @num times.', array('!ip' => l($ip, 'http://www.stopforumspam.com/search?q=' . $ip), '@num' => $data['ip']['frequency']));
}
}
else {
drupal_set_message(t('Error contacting service.'), 'warning');
$service_down = TRUE;
break;
}
}
}
if (count($messages)) {
foreach ($messages as $message) {
drupal_set_message($message);
}
}
else {
drupal_set_message(t('No matches against known spammers found.'));
}
}
else if ($form_state['values']['op'] == $form_state['values']['action']) {
if ($account->uid == 1) {
drupal_set_message(t('Sorry, taking action against uid 1 is not allowed.'));
return;
}
// Block account
if (!empty($form_state['values']['block_user'])) {
if ($account->status) {
user_save($account, array('status' => 0));
drupal_set_message(t('Account blocked.'));
}
else {
drupal_set_message(t('This account is already blocked.'));
}
}
// Prepare some data
$nodes = db_select('node')->fields('node', array('nid'))
->condition('uid', $account->uid, '=')->orderBy('nid')->execute()->fetchCol();
$node_hostnames = array();
$result = db_select('node_spambot')->fields('node_spambot', array('nid', 'hostname'))->condition('uid', $account->uid)->orderBy('nid', 'DESC')->execute();
foreach ($result as $record) {
$node_hostnames[$record->nid] = $record->hostname;
}
$comments = array();
if (module_exists('comment')) {
$comments = db_select('comment')->fields('comment', array('cid'))
->condition('uid', $account->uid, '=')->orderBy('cid')->execute()->fetchCol();
}
// Report posts to www.stopforumspam.com
if (!empty($form_state['values']['report']['nids'])) {
foreach (array_filter($form_state['values']['report']['nids']) as $nid => $unused) {
$node = node_load($nid);
if (!empty($node->nid)) {
if (spambot_report_account($account, $node_hostnames[$nid], $node->title . "\n\n" . $node->body['und'][0]['summary'] . "\n\n" . $node->body['und'][0]['value'])) {
drupal_set_message(t('Node %title has been reported.', array('%title' => $node->title)));
}
else {
drupal_set_message(t('There was a problem reporting node %title.', array('%title' => $node->title)));
}
}
}
}
if (module_exists('comment') && !empty($form_state['values']['report']['cids'])) {
foreach (array_filter($form_state['values']['report']['cids']) as $cid => $unused) {
$comment = comment_load($cid);
if (!empty($comment->cid)) {
if (spambot_report_account($account, $comment->hostname, $comment->subject . "\n\n" . $comment->comment_body['und'][0]['value'])) {
drupal_set_message(t('Comment %title has been reported.', array('%title' => $comment->subject)));
}
else {
drupal_set_message(t('There was a problem reporting comment %title.', array('%title' => $comment->subject)));
}
}
}
}
// Delete nodes and content
if (!empty($form_state['values']['delete_content'])) {
node_delete_multiple($nodes);
if (count($comments)) {
comment_delete_multiple($comments);
}
drupal_set_message(t('Nodes and comments have been deleted.'));
}
else if (!empty($form_state['values']['unpublish_content'])) {
// Unpublish nodes and content
if (count($nodes)) {
module_load_include('inc', 'node', 'node.admin');
node_mass_update($nodes, array('status' => 0));
}
if (count($comments)) {
db_update('comment')->fields(array('status' => COMMENT_NOT_PUBLISHED))
->condition('uid', $account->uid)->execute();
cache_clear_all();
}
drupal_set_message(t('Nodes and comments have been unpublished.'));
}
// Delete user
if (!empty($form_state['values']['delete_user'])) {
// Redirect to user delete form
$form_state['redirect'] = 'user/' . $account->uid . '/cancel';
}
}
}