function comment_count_unpublished in Drupal 7

Returns a menu title which includes the number of unapproved comments.

1 string reference to 'comment_count_unpublished'

comment_menu in modules/comment/comment.module

Implements hook_menu().

File

modules/comment/comment.module, line 311

Enables users to comment on published content.

Code

function comment_count_unpublished() {
  $count = db_query('SELECT COUNT(cid) FROM {comment} WHERE status = :status', array(
    ':status' => COMMENT_NOT_PUBLISHED,
  ))
    ->fetchField();
  return t('Unapproved comments (@count)', array(
    '@count' => $count,
  ));
}