function comment_num_new

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).

Return value

The result or FALSE on error.

File

modules/comment/comment.module, line 1733

Enables users to comment on published content.

Code

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

  if ($user->uid) {
    // Retrieve the timestamp at which the current user last viewed this 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.
    return db_query('SELECT COUNT(cid) FROM {comment} WHERE nid = :nid AND created > :timestamp AND status = :status', array(
      ':nid' => $nid,
      ':timestamp' => $timestamp,
      ':status' => COMMENT_PUBLISHED,
    ))->fetchField();
  }
  else {
    return FALSE;
  }

}