function acquai_spi_get_last_nodes in Acquia Connector 7.2

Same name and namespace in other branches

1. 6.2 acquia_spi/acquia_spi.module \acquai_spi_get_last_nodes()

Get last 15 nodes created--this can be useful to determine if you have some sort of spamme on your site

Parameters

n/a:

Return value

array of the details of last 15 nodes created

1 call to acquai_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 1102

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

Code

function acquai_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;
}