modules/tracker/tracker.pages.inc

<?php
// $Id: tracker.pages.inc,v 1.27 2009/10/29 07:18:55 webchick Exp $

/**
 * @file
 * User page callbacks for the tracker module.
 */


/**
 * Menu callback; prints a listing of active nodes on the site.
 */
function tracker_page($account = NULL, $set_title = FALSE) {
  if ($account) {
    $query = db_select('tracker_user', 't')->extend('PagerDefault');
    $query->condition('t.uid', $account->uid);

    if ($set_title) {
      // When viewed from user/%user/track, display the name of the user
      // as page title -- the tab title remains Track so this needs to be done
      // here and not in the menu definition.
      drupal_set_title(format_username($account));
    }
  }
  else {
    $query = db_select('tracker_node', 't', array('target' => 'slave'))->extend('PagerDefault');
  }

  // This array acts as a placeholder for the data selected later
  // while keeping the correct order.
  $nodes = $query
    ->addTag('node_access')
    ->fields('t', array('nid', 'changed'))
    ->condition('t.published', 1)
    ->orderBy('t.changed', 'DESC')
    ->limit(25)
    ->execute()
    ->fetchAllAssoc('nid');

  if (!empty($nodes)) {
    // Now, get the data and put into the placeholder array
    $result = db_query('SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, l.comment_count FROM {node} n INNER JOIN {node_comment_statistics} l ON n.nid = l.nid INNER JOIN {users} u ON n.uid = u.uid WHERE n.nid IN (:nids)', array(':nids' => array_keys($nodes)), array('target' => 'slave'));
    foreach ($result as $node) {
      $node->last_activity = $nodes[$node->nid]->changed;
      $nodes[$node->nid] = $node;
    }

    // Finally display the data
    $rows = array();
    foreach ($nodes as $node) {
      // Determine the number of comments:
      $comments = 0;
      if ($node->comment_count) {
        $comments = $node->comment_count;

        if ($new = comment_num_new($node->nid)) {
          $comments .= '<br />';
          $comments .= l(format_plural($new, '1 new', '@count new'), 'node/'. $node->nid, array('fragment' => 'new'));
        }
      }

      $rows[] = array(
        check_plain(node_type_get_name($node->type)),
        l($node->title, 'node/' . $node->nid) . ' ' . theme('mark', array('type' => node_mark($node->nid, $node->changed))),
        theme('username', array('account' => $node)),
        array('class' => array('replies'), 'data' => $comments),
        t('!time ago', array('!time' => format_interval(REQUEST_TIME - $node->last_activity)))
      );
    }
  }
  else {
    $rows[] = array(array('data' => t('No posts available.'), 'colspan' => '5'));
  }

  $page['tracker'] = array(
    '#rows' => $rows,
    '#header' => array(t('Type'), t('Post'), t('Author'), t('Replies'), t('Last updated')),
    '#theme' => 'table',
    '#attached' => array(
      'css' => array(drupal_get_path('module', 'tracker') . '/tracker.css' => array('preprocess' => FALSE)),
    ),
  );
  $page['pager'] = array(
    '#theme' => 'pager',
    '#quantity' => 25,
    '#weight' => 10,
  );
  $page['#sorted'] = TRUE;

  return $page;
}
1	<?php
2	// $Id: tracker.pages.inc,v 1.27 2009/10/29 07:18:55 webchick Exp $
3
4	/**
5	* @file
6	* User page callbacks for the tracker module.
7	*/
8
9
10	/**
11	* Menu callback; prints a listing of active nodes on the site.
12	*/
13	function tracker_page($account = NULL, $set_title = FALSE) {
14	if ($account) {
15	$query = db_select('tracker_user', 't')->extend('PagerDefault');
16	$query->condition('t.uid', $account->uid);
17
18	if ($set_title) {
19	// When viewed from user/%user/track, display the name of the user
20	// as page title -- the tab title remains Track so this needs to be done
21	// here and not in the menu definition.
22	drupal_set_title(format_username($account));
23	}
24	}
25	else {
26	$query = db_select('tracker_node', 't', array('target' => 'slave'))->extend('PagerDefault');
27	}
28
29	// This array acts as a placeholder for the data selected later
30	// while keeping the correct order.
31	$nodes = $query
32	->addTag('node_access')
33	->fields('t', array('nid', 'changed'))
34	->condition('t.published', 1)
35	->orderBy('t.changed', 'DESC')
36	->limit(25)
37	->execute()
38	->fetchAllAssoc('nid');
39
40	if (!empty($nodes)) {
41	// Now, get the data and put into the placeholder array
42	$result = db_query('SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, l.comment_count FROM {node} n INNER JOIN {node_comment_statistics} l ON n.nid = l.nid INNER JOIN {users} u ON n.uid = u.uid WHERE n.nid IN (:nids)', array(':nids' => array_keys($nodes)), array('target' => 'slave'));
43	foreach ($result as $node) {
44	$node->last_activity = $nodes[$node->nid]->changed;
45	$nodes[$node->nid] = $node;
46	}
47
48	// Finally display the data
49	$rows = array();
50	foreach ($nodes as $node) {
51	// Determine the number of comments:
52	$comments = 0;
53	if ($node->comment_count) {
54	$comments = $node->comment_count;
55
56	if ($new = comment_num_new($node->nid)) {
57	$comments .= '<br />';
58	$comments .= l(format_plural($new, '1 new', '@count new'), 'node/'. $node->nid, array('fragment' => 'new'));
59	}
60	}
61
62	$rows[] = array(
63	check_plain(node_type_get_name($node->type)),
64	l($node->title, 'node/' . $node->nid) . ' ' . theme('mark', array('type' => node_mark($node->nid, $node->changed))),
65	theme('username', array('account' => $node)),
66	array('class' => array('replies'), 'data' => $comments),
67	t('!time ago', array('!time' => format_interval(REQUEST_TIME - $node->last_activity)))
68	);
69	}
70	}
71	else {
72	$rows[] = array(array('data' => t('No posts available.'), 'colspan' => '5'));
73	}
74
75	$page['tracker'] = array(
76	'#rows' => $rows,
77	'#header' => array(t('Type'), t('Post'), t('Author'), t('Replies'), t('Last updated')),
78	'#theme' => 'table',
79	'#attached' => array(
80	'css' => array(drupal_get_path('module', 'tracker') . '/tracker.css' => array('preprocess' => FALSE)),
81	),
82	);
83	$page['pager'] = array(
84	'#theme' => 'pager',
85	'#quantity' => 25,
86	'#weight' => 10,
87	);
88	$page['#sorted'] = TRUE;
89
90	return $page;
91	}