function comment_new_page_count in Drupal 6

Same name and namespace in other branches

1. 7 modules/comment/comment.module \comment_new_page_count()

Calculate page number for first new comment.

Parameters

$num_comments: Number of comments.

$new_replies: Number of new replies.

$node: The first new comment node.

Return value

"page=X" if the page number is greater than zero; empty string otherwise.

4 calls to comment_new_page_count()

comment_form_submit in modules/comment/comment.module

Process comment form submissions; prepare the comment, store it, and set a redirection target.

comment_link in modules/comment/comment.module

Implementation of hook_link().

template_preprocess_forum_topic_list in modules/forum/forum.module

Preprocess variables to format the topic listing.

tracker_page in modules/tracker/tracker.pages.inc

Menu callback. Prints a listing of active nodes on the site.

File

modules/comment/comment.module, line 345

Enables users to comment on published content.

Code

function comment_new_page_count($num_comments, $new_replies, $node) {
  $comments_per_page = _comment_get_display_setting('comments_per_page', $node);
  $mode = _comment_get_display_setting('mode', $node);
  $order = _comment_get_display_setting('sort', $node);
  $pagenum = NULL;
  $flat = in_array($mode, array(
    COMMENT_MODE_FLAT_COLLAPSED,
    COMMENT_MODE_FLAT_EXPANDED,
  ));
  if ($num_comments <= $comments_per_page || $flat && $order == COMMENT_ORDER_NEWEST_FIRST) {

    // Only one page of comments or flat forum and newest first.
    // First new comment will always be on first page.
    $pageno = 0;
  }
  else {
    if ($flat) {

      // Flat comments and oldest first.
      $count = $num_comments - $new_replies;
    }
    else {

      // Threaded comments. See the documentation for comment_render().
      if ($order == COMMENT_ORDER_NEWEST_FIRST) {

        // Newest first: find the last thread with new comment
        $result = db_query('SELECT thread FROM (SELECT thread FROM {comments} WHERE nid = %d AND status = 0 ORDER BY timestamp DESC LIMIT %d) AS thread ORDER BY thread DESC LIMIT 1', $node->nid, $new_replies);
        $thread = db_result($result);
        $result_count = db_query("SELECT COUNT(*) FROM {comments} WHERE nid = %d AND status = 0 AND thread > '" . $thread . "'", $node->nid);
      }
      else {

        // Oldest first: find the first thread with new comment
        $result = db_query('SELECT thread FROM (SELECT thread FROM {comments} WHERE nid = %d AND status = 0 ORDER BY timestamp DESC LIMIT %d) AS thread ORDER BY SUBSTRING(thread, 1, (LENGTH(thread) - 1)) LIMIT 1', $node->nid, $new_replies);
        $thread = substr(db_result($result), 0, -1);
        $result_count = db_query("SELECT COUNT(*) FROM {comments} WHERE nid = %d AND status = 0 AND SUBSTRING(thread, 1, (LENGTH(thread) - 1)) < '" . $thread . "'", $node->nid);
      }
      $count = db_result($result_count);
    }
    $pageno = $count / $comments_per_page;
  }
  if ($pageno >= 1) {
    $pagenum = "page=" . intval($pageno);
  }
  return $pagenum;
}