123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388 |
- <?php
- function tracker_help($path, $arg) {
- switch ($path) {
- case 'admin/help#tracker':
- $output = '<h3>' . t('About') . '</h3>';
- $output .= '<p>' . t('The Tracker module displays the most recently added and updated content on your site, and allows you to follow new content created by each user. This module has no configuration options. For more information, see the online handbook entry for <a href="@tracker">Tracker module</a>.', array('@tracker' => 'http://drupal.org/documentation/modules/tracker/')) . '</p>';
- $output .= '<h3>' . t('Uses') . '</h3>';
- $output .= '<dl>';
- $output .= '<dt>' . t('Navigation') . '</dt>';
- $output .= '<dd>' . t('The Tracker module adds a new menu item to the Navigation menu, called <em>Recent content</em>. You can configure menu items via the <a href="@menus">Menus administration page</a>.', array('@menus' => url('admin/structure/menu'))) . '</dd>';
- $output .= '<dt>' . t('Tracking new and updated site content') . '</dt>';
- $output .= '<dd>' . t("The <a href='@recent'>Recent content</a> page shows new and updated content in reverse chronological order, listing the content type, title, author's name, number of comments, and time of last update. Content is considered updated when changes occur in the text, or when new comments are added. The <em>My recent content</em> tab limits the list to the currently logged-in user.", array('@recent' => url('tracker'))) . '</dd>';
- $output .= '<dt>' . t('Tracking user-specific content') . '</dt>';
- $output .= '<dd>' . t("To follow a specific user's new and updated content, select the <em>Track</em> tab from the user's profile page.") . '</dd>';
- $output .= '</dl>';
- return $output;
- }
- }
- function tracker_menu() {
- $items['tracker'] = array(
- 'title' => 'Recent content',
- 'page callback' => 'tracker_page',
- 'access arguments' => array('access content'),
- 'weight' => 1,
- 'file' => 'tracker.pages.inc',
- );
- $items['tracker/all'] = array(
- 'title' => 'All recent content',
- 'type' => MENU_DEFAULT_LOCAL_TASK,
- );
- $items['tracker/%user_uid_optional'] = array(
- 'title' => 'My recent content',
- 'page callback' => 'tracker_page',
- 'access callback' => '_tracker_myrecent_access',
- 'access arguments' => array(1),
- 'page arguments' => array(1),
- 'type' => MENU_LOCAL_TASK,
- 'file' => 'tracker.pages.inc',
- );
- $items['user/%user/track'] = array(
- 'title' => 'Track',
- 'page callback' => 'tracker_page',
- 'page arguments' => array(1, TRUE),
- 'access callback' => '_tracker_user_access',
- 'access arguments' => array(1),
- 'type' => MENU_LOCAL_TASK,
- 'file' => 'tracker.pages.inc',
- );
- $items['user/%user/track/content'] = array(
- 'title' => 'Track content',
- 'type' => MENU_DEFAULT_LOCAL_TASK,
- );
- return $items;
- }
- function tracker_cron() {
- $max_nid = variable_get('tracker_index_nid', 0);
- $batch_size = variable_get('tracker_batch_size', 1000);
- if ($max_nid > 0) {
- $last_nid = FALSE;
- $result = db_query_range('SELECT nid, uid, status FROM {node} WHERE nid <= :max_nid ORDER BY nid DESC', 0, $batch_size, array(':max_nid' => $max_nid), array('target' => 'slave'));
- $count = 0;
- foreach ($result as $row) {
-
- $changed = _tracker_calculate_changed($row->nid);
-
- db_delete('tracker_node')
- ->condition('nid', $row->nid)
- ->execute();
- db_delete('tracker_user')
- ->condition('nid', $row->nid)
- ->execute();
-
- db_insert('tracker_node')
- ->fields(array(
- 'nid' => $row->nid,
- 'published' => $row->status,
- 'changed' => $changed,
- ))
- ->execute();
-
- db_insert('tracker_user')
- ->fields(array(
- 'nid' => $row->nid,
- 'published' => $row->status,
- 'changed' => $changed,
- 'uid' => $row->uid,
- ))
- ->execute();
- $query = db_select('comment', 'c', array('target' => 'slave'));
-
- $query->addExpression('0 + :changed', 'changed', array(':changed' => $changed));
- $query->addField('c', 'status', 'published');
- $query
- ->distinct()
- ->fields('c', array('uid', 'nid'))
- ->condition('c.nid', $row->nid)
- ->condition('c.uid', $row->uid, '<>')
- ->condition('c.status', COMMENT_PUBLISHED);
-
-
- db_insert('tracker_user')
- ->from($query)
- ->execute();
-
- $last_nid = $row->nid;
- $count++;
- }
- if ($last_nid !== FALSE) {
-
- variable_set('tracker_index_nid', $last_nid - 1);
- watchdog('tracker', 'Indexed %count content items for tracking.', array('%count' => $count));
- }
- else {
-
- variable_set('tracker_index_nid', 0);
- }
- }
- }
- function _tracker_myrecent_access($account) {
-
- return $account->uid && ($GLOBALS['user']->uid == $account->uid) && user_access('access content');
- }
- function _tracker_user_access($account) {
- return user_view_access($account) && user_access('access content');
- }
- function tracker_node_insert($node, $arg = 0) {
- _tracker_add($node->nid, $node->uid, $node->changed);
- }
- function tracker_node_update($node, $arg = 0) {
- _tracker_add($node->nid, $node->uid, $node->changed);
- }
- function tracker_node_delete($node, $arg = 0) {
- db_delete('tracker_node')
- ->condition('nid', $node->nid)
- ->execute();
- db_delete('tracker_user')
- ->condition('nid', $node->nid)
- ->execute();
- }
- function tracker_comment_update($comment) {
-
-
- if ($comment->status != COMMENT_PUBLISHED) {
- _tracker_remove($comment->nid, $comment->uid, $comment->changed);
- }
- }
- function tracker_comment_publish($comment) {
- _tracker_add($comment->nid, $comment->uid, $comment->changed);
- }
- function tracker_comment_unpublish($comment) {
- _tracker_remove($comment->nid, $comment->uid, $comment->changed);
- }
- function tracker_comment_delete($comment) {
- _tracker_remove($comment->nid, $comment->uid, $comment->changed);
- }
- function _tracker_add($nid, $uid, $changed) {
- $node = db_query('SELECT nid, status, uid, changed FROM {node} WHERE nid = :nid', array(':nid' => $nid))->fetchObject();
-
-
- $changed = max($node->changed, $changed);
-
- db_merge('tracker_node')
- ->key(array('nid' => $nid))
- ->fields(array(
- 'changed' => $changed,
- 'published' => $node->status,
- ))
- ->execute();
-
- db_merge('tracker_user')
- ->key(array(
- 'nid' => $nid,
- 'uid' => $uid,
- ))
- ->fields(array(
- 'changed' => $changed,
- 'published' => $node->status,
- ))
- ->execute();
-
- db_update('tracker_user')
- ->condition('nid', $nid)
- ->fields(array(
- 'changed' => $changed,
- 'published' => $node->status,
- ))
- ->execute();
- }
- function _tracker_calculate_changed($nid) {
- $changed = db_query('SELECT changed FROM {node} WHERE nid = :nid', array(':nid' => $nid), array('target' => 'slave'))->fetchField();
- $latest_comment = db_query_range('SELECT cid, changed FROM {comment} WHERE nid = :nid AND status = :status ORDER BY changed DESC', 0, 1, array(
- ':nid' => $nid,
- ':status' => COMMENT_PUBLISHED,
- ), array('target' => 'slave'))->fetchObject();
- if ($latest_comment && $latest_comment->changed > $changed) {
- $changed = $latest_comment->changed;
- }
- return $changed;
- }
- function _tracker_remove($nid, $uid = NULL, $changed = NULL) {
- $node = db_query('SELECT nid, status, uid, changed FROM {node} WHERE nid = :nid', array(':nid' => $nid))->fetchObject();
-
-
-
- $keep_subscription = FALSE;
- if ($node) {
-
- $keep_subscription = ($node->uid == $uid);
-
- if (!$keep_subscription) {
-
- $keep_subscription = db_query_range('SELECT COUNT(*) FROM {comment} WHERE nid = :nid AND uid = :uid AND status = :status', 0, 1, array(
- ':nid' => $nid,
- ':uid' => $uid,
- ':status' => COMMENT_PUBLISHED,
- ))->fetchField();
- }
-
- if (!$keep_subscription) {
- db_delete('tracker_user')
- ->condition('nid', $nid)
- ->condition('uid', $uid)
- ->execute();
- }
-
-
-
-
- $tracker_node = db_query('SELECT nid, changed FROM {tracker_node} WHERE nid = :nid', array(':nid' => $nid))->fetchObject();
- if ($tracker_node && $changed >= $tracker_node->changed) {
-
-
-
- $changed = _tracker_calculate_changed($nid);
-
-
- db_update('tracker_node')
- ->fields(array(
- 'changed' => $changed,
- 'published' => $node->status,
- ))
- ->condition('nid', $nid)
- ->execute();
- db_update('tracker_node')
- ->fields(array(
- 'changed' => $changed,
- 'published' => $node->status,
- ))
- ->condition('nid', $nid)
- ->execute();
- }
- }
- else {
-
- db_delete('tracker_node')
- ->condition('nid', $nid)
- ->execute();
- db_delete('tracker_user')
- ->condition('nid', $nid)
- ->execute();
- }
- }
|