Home › API reference › comment.module

comment_num_new

  1. drupal
    1. 4.7
    2. 5 comment.module
    3. 6 comment.module
    4. 7 comment.module
Versions
4.7 – 7 comment_num_new($nid, $timestamp = 0)

get number of new comments for current user and specified node

Parameters

$nid node-id to count comments for

$timestamp time to count from (defaults to time of last user access to node)

▸ 3 functions call comment_num_new()

▾ 3 functions call comment_num_new()

comment_link in modules/comment.module
Implementation of hook_link().
forum_get_topics in modules/forum.module
tracker_page in modules/tracker.module
Menu callback. Prints a listing of active nodes on the site.

Code

modules/comment.module, line 1134

<?php
function comment_num_new($nid, $timestamp = 0) {
  global $user;

  if ($user->uid) {
    // Retrieve the timestamp at which the current user last viewed the
    // specified node.
    if (!$timestamp) {
      $timestamp = node_last_viewed($nid);
    }
    $timestamp = ($timestamp > NODE_NEW_LIMIT ? $timestamp : NODE_NEW_LIMIT);

    // Use the timestamp to retrieve the number of new comments.
    $result = db_result(db_query('SELECT COUNT(c.cid) FROM {node} n INNER JOIN {comments} c ON n.nid = c.nid WHERE n.nid = %d AND timestamp > %d AND c.status = %d', $nid, $timestamp, COMMENT_PUBLISHED));

    return $result;
  }
  else {
    return 0;
  }

}
?>