function statistics_title_list in Drupal 7

Same name and namespace in other branches

1. 8 core/modules/statistics/statistics.module \statistics_title_list()
2. 4 modules/statistics.module \statistics_title_list()
3. 5 modules/statistics/statistics.module \statistics_title_list()
4. 6 modules/statistics/statistics.module \statistics_title_list()

Returns the most viewed content of all time, today, or the last-viewed node.

Parameters

$dbfield: The database field to use, one of:

• 'totalcount': Integer that shows the top viewed content of all time.
• 'daycount': Integer that shows the top viewed content for today.
• 'timestamp': Integer that shows only the last viewed node.

$dbrows: The number of rows to be returned.

Return value

SelectQuery|FALSE A query result containing the node ID, title, user ID that owns the node, and the username for the selected node(s), or FALSE if the query could not be executed correctly.

1 call to statistics_title_list()

statistics_block_view in modules/statistics/statistics.module

Implements hook_block_view().

File

modules/statistics/statistics.module, line 280

Logs and displays access statistics for a site.

Code

function statistics_title_list($dbfield, $dbrows) {
  if (in_array($dbfield, array(
    'totalcount',
    'daycount',
    'timestamp',
  ))) {
    $query = db_select('node', 'n');
    $query
      ->addTag('node_access');
    $query
      ->join('node_counter', 's', 'n.nid = s.nid');
    $query
      ->join('users', 'u', 'n.uid = u.uid');
    return $query
      ->fields('n', array(
      'nid',
      'title',
    ))
      ->fields('u', array(
      'uid',
      'name',
    ))
      ->condition($dbfield, 0, '<>')
      ->condition('n.status', 1)
      ->orderBy($dbfield, 'DESC')
      ->range(0, $dbrows)
      ->execute();
  }
  return FALSE;
}