function acquia_spi_get_last_nodes in Acquia Connector 7.3

Get last 15 nodes created.

This can be useful to determine if you have some sort of spam on your site.

Return value

array The details of last 15 nodes created

1 call to acquia_spi_get_last_nodes()

acquia_spi_get in acquia_spi/acquia_spi.module

Gather site profile information about this site.

File

acquia_spi/acquia_spi.module, line 1199

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

Code

function acquia_spi_get_last_nodes() {
  $last_five_nodes = array();
  $result = db_select('node', 'n')
    ->fields('n', array(
    'title',
    'type',
    'nid',
    'created',
  ))
    ->condition('n.created', REQUEST_TIME - 3600, '>')
    ->orderBy('n.created', 'DESC')
    ->range(0, 15)
    ->execute();
  $count = 0;
  foreach ($result as $record) {
    $last_five_nodes[$count]['url'] = drupal_get_path_alias('node/' . $record->nid);
    $last_five_nodes[$count]['title'] = $record->title;
    $last_five_nodes[$count]['type'] = $record->type;
    $last_five_nodes[$count]['created'] = $record->created;
    $count++;
  }
  return $last_five_nodes;
}