Enables users to comment on published content.
When enabled, the Drupal comment module creates a discussion
board for each Drupal node. Users can post comments to discuss
a forum topic, weblog post, story, collaborative book page, etc.
View source
- <?php
-
- * @file
- * Enables users to comment on published content.
- *
- * When enabled, the Drupal comment module creates a discussion
- * board for each Drupal node. Users can post comments to discuss
- * a forum topic, weblog post, story, collaborative book page, etc.
- */
-
- * Comment is awaiting approval.
- */
- define('COMMENT_NOT_PUBLISHED', 0);
-
- * Comment is published.
- */
- define('COMMENT_PUBLISHED', 1);
-
- * Comments are displayed in a flat list - expanded.
- */
- define('COMMENT_MODE_FLAT', 0);
-
- * Comments are displayed as a threaded list - expanded.
- */
- define('COMMENT_MODE_THREADED', 1);
-
- * Anonymous posters cannot enter their contact information.
- */
- define('COMMENT_ANONYMOUS_MAYNOT_CONTACT', 0);
-
- * Anonymous posters may leave their contact information.
- */
- define('COMMENT_ANONYMOUS_MAY_CONTACT', 1);
-
- * Anonymous posters are required to leave their contact information.
- */
- define('COMMENT_ANONYMOUS_MUST_CONTACT', 2);
-
- * Comment form should be displayed on a separate page.
- */
- define('COMMENT_FORM_SEPARATE_PAGE', 0);
-
- * Comment form should be shown below post or list of comments.
- */
- define('COMMENT_FORM_BELOW', 1);
-
- * Comments for this node are hidden.
- */
- define('COMMENT_NODE_HIDDEN', 0);
-
- * Comments for this node are closed.
- */
- define('COMMENT_NODE_CLOSED', 1);
-
- * Comments for this node are open.
- */
- define('COMMENT_NODE_OPEN', 2);
-
- * Implements hook_help().
- */
- function comment_help($path, $arg) {
- switch ($path) {
- case 'admin/help#comment':
- $output = '<h3>' . t('About') . '</h3>';
- $output .= '<p>' . t('The Comment module allows users to comment on site content, set commenting defaults and permissions, and moderate comments. For more information, see the online handbook entry for <a href="@comment">Comment module</a>.', array('@comment' => 'http://drupal.org/documentation/modules/comment/')) . '</p>';
- $output .= '<h3>' . t('Uses') . '</h3>';
- $output .= '<dl>';
- $output .= '<dt>' . t('Default and custom settings') . '</dt>';
- $output .= '<dd>' . t("Each <a href='@content-type'>content type</a> can have its own default comment settings configured as: <em>Open</em> to allow new comments, <em>Hidden</em> to hide existing comments and prevent new comments, or <em>Closed</em> to view existing comments, but prevent new comments. These defaults will apply to all new content created (changes to the settings on existing content must be done manually). Other comment settings can also be customized per content type, and can be overridden for any given item of content. When a comment has no replies, it remains editable by its author, as long as the author has a user account and is logged in.", array('@content-type' => url('admin/structure/types'))) . '</dd>';
- $output .= '<dt>' . t('Comment approval') . '</dt>';
- $output .= '<dd>' . t("Comments from users who have the <em>Skip comment approval</em> permission are published immediately. All other comments are placed in the <a href='@comment-approval'>Unapproved comments</a> queue, until a user who has permission to <em>Administer comments</em> publishes or deletes them. Published comments can be bulk managed on the <a href='@admin-comment'>Published comments</a> administration page.", array('@comment-approval' => url('admin/content/comment/approval'), '@admin-comment' => url('admin/content/comment'))) . '</dd>';
- $output .= '</dl>';
- return $output;
- }
- }
-
- * Implements hook_entity_info().
- */
- function comment_entity_info() {
- $return = array(
- 'comment' => array(
- 'label' => t('Comment'),
- 'base table' => 'comment',
- 'uri callback' => 'comment_uri',
- 'fieldable' => TRUE,
- 'controller class' => 'CommentController',
- 'entity keys' => array(
- 'id' => 'cid',
- 'bundle' => 'node_type',
- 'label' => 'subject',
- 'language' => 'language',
- ),
- 'bundles' => array(),
- 'view modes' => array(
- 'full' => array(
- 'label' => t('Full comment'),
- 'custom settings' => FALSE,
- ),
- ),
- 'static cache' => FALSE,
- ),
- );
-
- foreach (node_type_get_names() as $type => $name) {
- $return['comment']['bundles']['comment_node_' . $type] = array(
- 'label' => t('@node_type comment', array('@node_type' => $name)),
-
-
- 'node bundle' => $type,
- 'admin' => array(
-
-
-
-
-
-
- 'path' => 'admin/structure/types/manage/%comment_node_type/comment',
- 'bundle argument' => 4,
- 'real path' => 'admin/structure/types/manage/' . str_replace('_', '-', $type) . '/comment',
- 'access arguments' => array('administer content types'),
- ),
- );
- }
-
- return $return;
- }
-
- * Menu loader callback for Field UI paths.
- *
- * Return a comment bundle name from a node type in the URL.
- */
- function comment_node_type_load($name) {
- if ($type = node_type_get_type(strtr($name, array('-' => '_')))) {
- return 'comment_node_' . $type->type;
- }
- }
-
- * Implements callback_entity_info_uri().
- */
- function comment_uri($comment) {
- return array(
- 'path' => 'comment/' . $comment->cid,
- 'options' => array('fragment' => 'comment-' . $comment->cid),
- );
- }
-
- * Implements hook_field_extra_fields().
- */
- function comment_field_extra_fields() {
- $return = array();
-
- foreach (node_type_get_types() as $type) {
- if (variable_get('comment_subject_field_' . $type->type, 1) == 1) {
- $return['comment']['comment_node_' . $type->type] = array(
- 'form' => array(
- 'author' => array(
- 'label' => t('Author'),
- 'description' => t('Author textfield'),
- 'weight' => -2,
- ),
- 'subject' => array(
- 'label' => t('Subject'),
- 'description' => t('Subject textfield'),
- 'weight' => -1,
- ),
- ),
- );
- }
- }
-
- return $return;
- }
-
- * Implements hook_theme().
- */
- function comment_theme() {
- return array(
- 'comment_block' => array(
- 'variables' => array(),
- ),
- 'comment_preview' => array(
- 'variables' => array('comment' => NULL),
- ),
- 'comment' => array(
- 'template' => 'comment',
- 'render element' => 'elements',
- ),
- 'comment_post_forbidden' => array(
- 'variables' => array('node' => NULL),
- ),
- 'comment_wrapper' => array(
- 'template' => 'comment-wrapper',
- 'render element' => 'content',
- ),
- );
- }
-
- * Implements hook_menu().
- */
- function comment_menu() {
- $items['admin/content/comment'] = array(
- 'title' => 'Comments',
- 'description' => 'List and edit site comments and the comment approval queue.',
- 'page callback' => 'comment_admin',
- 'access arguments' => array('administer comments'),
- 'type' => MENU_LOCAL_TASK | MENU_NORMAL_ITEM,
- 'file' => 'comment.admin.inc',
- );
-
- $items['admin/content/comment/new'] = array(
- 'title' => 'Published comments',
- 'type' => MENU_DEFAULT_LOCAL_TASK,
- 'weight' => -10,
- );
- $items['admin/content/comment/approval'] = array(
- 'title' => 'Unapproved comments',
- 'title callback' => 'comment_count_unpublished',
- 'page arguments' => array('approval'),
- 'access arguments' => array('administer comments'),
- 'type' => MENU_LOCAL_TASK,
- );
- $items['comment/%'] = array(
- 'title' => 'Comment permalink',
- 'page callback' => 'comment_permalink',
- 'page arguments' => array(1),
- 'access arguments' => array('access comments'),
- );
- $items['comment/%/view'] = array(
- 'title' => 'View comment',
- 'type' => MENU_DEFAULT_LOCAL_TASK,
- 'weight' => -10,
- );
-
-
- $items['comment/%comment/edit'] = array(
- 'title' => 'Edit',
- 'page callback' => 'comment_edit_page',
- 'page arguments' => array(1),
- 'access callback' => 'comment_access',
- 'access arguments' => array('edit', 1),
- 'type' => MENU_LOCAL_TASK,
- 'weight' => 0,
- );
- $items['comment/%/approve'] = array(
- 'title' => 'Approve',
- 'page callback' => 'comment_approve',
- 'page arguments' => array(1),
- 'access arguments' => array('administer comments'),
- 'file' => 'comment.pages.inc',
- 'weight' => 1,
- );
- $items['comment/%/delete'] = array(
- 'title' => 'Delete',
- 'page callback' => 'comment_confirm_delete_page',
- 'page arguments' => array(1),
- 'access arguments' => array('administer comments'),
- 'type' => MENU_LOCAL_TASK,
- 'file' => 'comment.admin.inc',
- 'weight' => 2,
- );
- $items['comment/reply/%node'] = array(
- 'title' => 'Add new comment',
- 'page callback' => 'comment_reply',
- 'page arguments' => array(2),
- 'access callback' => 'node_access',
- 'access arguments' => array('view', 2),
- 'file' => 'comment.pages.inc',
- );
-
- return $items;
- }
-
- * Implements hook_menu_alter().
- */
- function comment_menu_alter(&$items) {
-
- $items['admin/content']['description'] = 'Administer content and comments.';
-
-
-
- $items['admin/structure/types/manage/%comment_node_type/comment/fields']['title'] = 'Comment fields';
- $items['admin/structure/types/manage/%comment_node_type/comment/fields']['weight'] = 3;
- $items['admin/structure/types/manage/%comment_node_type/comment/display']['title'] = 'Comment display';
- $items['admin/structure/types/manage/%comment_node_type/comment/display']['weight'] = 4;
- }
-
- * Returns a menu title which includes the number of unapproved comments.
- */
- 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));
- }
-
- * Implements hook_node_type_insert().
- *
- * Creates a comment body field for a node type created while the comment module
- * is enabled. For node types created before the comment module is enabled,
- * hook_modules_enabled() serves to create the body fields.
- *
- * @see comment_modules_enabled()
- */
- function comment_node_type_insert($info) {
- _comment_body_field_create($info);
- }
-
- * Implements hook_node_type_update().
- */
- function comment_node_type_update($info) {
- if (!empty($info->old_type) && $info->type != $info->old_type) {
- field_attach_rename_bundle('comment', 'comment_node_' . $info->old_type, 'comment_node_' . $info->type);
- }
- }
-
- * Implements hook_node_type_delete().
- */
- function comment_node_type_delete($info) {
- field_attach_delete_bundle('comment', 'comment_node_' . $info->type);
- $settings = array(
- 'comment',
- 'comment_default_mode',
- 'comment_default_per_page',
- 'comment_anonymous',
- 'comment_subject_field',
- 'comment_preview',
- 'comment_form_location',
- );
- foreach ($settings as $setting) {
- variable_del($setting . '_' . $info->type);
- }
- }
-
-
- * Creates a comment_body field instance for a given node type.
- */
- function _comment_body_field_create($info) {
-
- if (!field_read_field('comment_body', array('include_inactive' => TRUE))) {
- $field = array(
- 'field_name' => 'comment_body',
- 'type' => 'text_long',
- 'entity_types' => array('comment'),
- );
- field_create_field($field);
- }
-
- if (!field_read_instance('comment', 'comment_body', 'comment_node_' . $info->type, array('include_inactive' => TRUE))) {
- field_attach_create_bundle('comment', 'comment_node_' . $info->type);
-
- $instance = array(
- 'field_name' => 'comment_body',
- 'label' => 'Comment',
- 'entity_type' => 'comment',
- 'bundle' => 'comment_node_' . $info->type,
- 'settings' => array('text_processing' => 1),
- 'required' => TRUE,
- 'display' => array(
- 'default' => array(
- 'label' => 'hidden',
- 'type' => 'text_default',
- 'weight' => 0,
- ),
- ),
- );
- field_create_instance($instance);
- }
- }
-
- * Implements hook_permission().
- */
- function comment_permission() {
- return array(
- 'administer comments' => array(
- 'title' => t('Administer comments and comment settings'),
- ),
- 'access comments' => array(
- 'title' => t('View comments'),
- ),
- 'post comments' => array(
- 'title' => t('Post comments'),
- ),
- 'skip comment approval' => array(
- 'title' => t('Skip comment approval'),
- ),
- 'edit own comments' => array(
- 'title' => t('Edit own comments'),
- ),
- );
- }
-
- * Implements hook_block_info().
- */
- function comment_block_info() {
- $blocks['recent']['info'] = t('Recent comments');
- $blocks['recent']['properties']['administrative'] = TRUE;
-
- return $blocks;
- }
-
- * Implements hook_block_configure().
- */
- function comment_block_configure($delta = '') {
- $form['comment_block_count'] = array(
- '#type' => 'select',
- '#title' => t('Number of recent comments'),
- '#default_value' => variable_get('comment_block_count', 10),
- '#options' => drupal_map_assoc(array(2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 25, 30)),
- );
-
- return $form;
- }
-
- * Implements hook_block_save().
- */
- function comment_block_save($delta = '', $edit = array()) {
- variable_set('comment_block_count', (int) $edit['comment_block_count']);
- }
-
- * Implements hook_block_view().
- *
- * Generates a block with the most recent comments.
- */
- function comment_block_view($delta = '') {
- if (user_access('access comments')) {
- $block['subject'] = t('Recent comments');
- $block['content'] = theme('comment_block');
-
- return $block;
- }
- }
-
- * Redirects comment links to the correct page depending on comment settings.
- *
- * Since comments are paged there is no way to guarantee which page a comment
- * appears on. Comment paging and threading settings may be changed at any time.
- * With threaded comments, an individual comment may move between pages as
- * comments can be added either before or after it in the overall discussion.
- * Therefore we use a central routing function for comment links, which
- * calculates the page number based on current comment settings and returns
- * the full comment view with the pager set dynamically.
- *
- * @param $cid
- * A comment identifier.
- * @return
- * The comment listing set to the page on which the comment appears.
- */
- function comment_permalink($cid) {
- if (($comment = comment_load($cid)) && ($node = node_load($comment->nid))) {
-
-
- $page = comment_get_display_page($comment->cid, $node->type);
-
-
-
- $_GET['q'] = 'node/' . $node->nid;
- $_GET['page'] = $page;
-
-
- return menu_execute_active_handler('node/' . $node->nid, FALSE);
- }
- drupal_not_found();
- }
-
- * Find the most recent comments that are available to the current user.
- *
- * @param integer $number
- * (optional) The maximum number of comments to find. Defaults to 10.
- *
- * @return
- * An array of comment objects or an empty array if there are no recent
- * comments visible to the current user.
- */
- function comment_get_recent($number = 10) {
- $query = db_select('comment', 'c');
- $query->innerJoin('node', 'n', 'n.nid = c.nid');
- $query->addTag('node_access');
- $comments = $query
- ->fields('c')
- ->condition('c.status', COMMENT_PUBLISHED)
- ->condition('n.status', NODE_PUBLISHED)
- ->orderBy('c.created', 'DESC')
-
-
- ->orderBy('c.cid', 'DESC')
- ->range(0, $number)
- ->execute()
- ->fetchAll();
-
- return $comments ? $comments : array();
- }
-
- * Calculate page number for first new comment.
- *
- * @param $num_comments
- * Number of comments.
- * @param $new_replies
- * Number of new replies.
- * @param $node
- * The first new comment node.
- * @return
- * "page=X" if the page number is greater than zero; empty string otherwise.
- */
- function comment_new_page_count($num_comments, $new_replies, $node) {
- $mode = variable_get('comment_default_mode_' . $node->type, COMMENT_MODE_THREADED);
- $comments_per_page = variable_get('comment_default_per_page_' . $node->type, 50);
- $pagenum = NULL;
- $flat = $mode == COMMENT_MODE_FLAT ? TRUE : FALSE;
- if ($num_comments <= $comments_per_page) {
-
- $pageno = 0;
- }
- elseif ($flat) {
-
- $count = $num_comments - $new_replies;
- $pageno = $count / $comments_per_page;
- }
- else {
-
-
-
-
- $unread_threads_query = db_select('comment')
- ->fields('comment', array('thread'))
- ->condition('nid', $node->nid)
- ->condition('status', COMMENT_PUBLISHED)
- ->orderBy('created', 'DESC')
- ->orderBy('cid', 'DESC')
- ->range(0, $new_replies);
-
-
- $first_thread = db_select($unread_threads_query, 'thread')
- ->fields('thread', array('thread'))
- ->orderBy('SUBSTRING(thread, 1, (LENGTH(thread) - 1))')
- ->range(0, 1)
- ->execute()
- ->fetchField();
-
-
- $first_thread = substr($first_thread, 0, -1);
-
-
- $count = db_query('SELECT COUNT(*) FROM {comment} WHERE nid = :nid AND status = :status AND SUBSTRING(thread, 1, (LENGTH(thread) - 1)) < :thread', array(
- ':status' => COMMENT_PUBLISHED,
- ':nid' => $node->nid,
- ':thread' => $first_thread,
- ))->fetchField();
-
- $pageno = $count / $comments_per_page;
- }
-
- if ($pageno >= 1) {
- $pagenum = array('page' => intval($pageno));
- }
-
- return $pagenum;
- }
-
- * Returns HTML for a list of recent comments to be displayed in the comment block.
- *
- * @ingroup themeable
- */
- function theme_comment_block() {
- $items = array();
- $number = variable_get('comment_block_count', 10);
- foreach (comment_get_recent($number) as $comment) {
- $items[] = l($comment->subject, 'comment/' . $comment->cid, array('fragment' => 'comment-' . $comment->cid)) . ' <span>' . t('@time ago', array('@time' => format_interval(REQUEST_TIME - $comment->changed))) . '</span>';
- }
-
- if ($items) {
- return theme('item_list', array('items' => $items));
- }
- else {
- return t('No comments available.');
- }
- }
-
- * Implements hook_node_view().
- */
- function comment_node_view($node, $view_mode) {
- $links = array();
-
- if ($node->comment != COMMENT_NODE_HIDDEN) {
- if ($view_mode == 'rss') {
-
- $node->rss_elements[] = array(
- 'key' => 'comments',
- 'value' => url('node/' . $node->nid, array('fragment' => 'comments', 'absolute' => TRUE))
- );
- }
- elseif ($view_mode == 'teaser') {
-
-
-
- if (user_access('access comments')) {
- if (!empty($node->comment_count)) {
- $links['comment-comments'] = array(
- 'title' => format_plural($node->comment_count, '1 comment', '@count comments'),
- 'href' => "node/$node->nid",
- 'attributes' => array('title' => t('Jump to the first comment of this posting.')),
- 'fragment' => 'comments',
- 'html' => TRUE,
- );
-
- if ($new = comment_num_new($node->nid)) {
- $links['comment-new-comments'] = array(
- 'title' => format_plural($new, '1 new comment', '@count new comments'),
- 'href' => "node/$node->nid",
- 'query' => comment_new_page_count($node->comment_count, $new, $node),
- 'attributes' => array('title' => t('Jump to the first new comment of this posting.')),
- 'fragment' => 'new',
- 'html' => TRUE,
- );
- }
- }
- }
- if ($node->comment == COMMENT_NODE_OPEN) {
- if (user_access('post comments')) {
- $links['comment-add'] = array(
- 'title' => t('Add new comment'),
- 'href' => "comment/reply/$node->nid",
- 'attributes' => array('title' => t('Add a new comment to this page.')),
- 'fragment' => 'comment-form',
- );
- }
- else {
- $links['comment_forbidden'] = array(
- 'title' => theme('comment_post_forbidden', array('node' => $node)),
- 'html' => TRUE,
- );
- }
- }
- }
- elseif ($view_mode != 'search_index' && $view_mode != 'search_result') {
-
-
-
-
- if ($node->comment == COMMENT_NODE_OPEN) {
- $comment_form_location = variable_get('comment_form_location_' . $node->type, COMMENT_FORM_BELOW);
- if (user_access('post comments')) {
-
-
- if ($comment_form_location == COMMENT_FORM_SEPARATE_PAGE || (!empty($node->comment_count) && user_access('access comments'))) {
- $links['comment-add'] = array(
- 'title' => t('Add new comment'),
- 'attributes' => array('title' => t('Share your thoughts and opinions related to this posting.')),
- 'href' => "node/$node->nid",
- 'fragment' => 'comment-form',
- );
- if ($comment_form_location == COMMENT_FORM_SEPARATE_PAGE) {
- $links['comment-add']['href'] = "comment/reply/$node->nid";
- }
- }
- }
- else {
- $links['comment_forbidden'] = array(
- 'title' => theme('comment_post_forbidden', array('node' => $node)),
- 'html' => TRUE,
- );
- }
- }
- }
-
- $node->content['links']['comment'] = array(
- '#theme' => 'links__node__comment',
- '#links' => $links,
- '#attributes' => array('class' => array('links', 'inline')),
- );
-
-
-
-
-
- if ($node->comment && $view_mode == 'full' && node_is_page($node) && empty($node->in_preview)) {
- $node->content['comments'] = comment_node_page_additions($node);
- }
- }
- }
-
- * Build the comment-related elements for node detail pages.
- *
- * @param $node
- * A node object.
- */
- function comment_node_page_additions($node) {
- $additions = array();
-
-
-
-
- if (($node->comment_count && user_access('access comments')) || user_access('administer comments')) {
- $mode = variable_get('comment_default_mode_' . $node->type, COMMENT_MODE_THREADED);
- $comments_per_page = variable_get('comment_default_per_page_' . $node->type, 50);
- if ($cids = comment_get_thread($node, $mode, $comments_per_page)) {
- $comments = comment_load_multiple($cids);
- comment_prepare_thread($comments);
- $build = comment_view_multiple($comments, $node);
- $build['pager']['#theme'] = 'pager';
- $additions['comments'] = $build;
- }
- }
-
-
- if (user_access('post comments') && $node->comment == COMMENT_NODE_OPEN && (variable_get('comment_form_location_' . $node->type, COMMENT_FORM_BELOW) == COMMENT_FORM_BELOW)) {
- $build = drupal_get_form("comment_node_{$node->type}_form", (object) array('nid' => $node->nid));
- $additions['comment_form'] = $build;
- }
-
- if ($additions) {
- $additions += array(
- '#theme' => 'comment_wrapper__node_' . $node->type,
- '#node' => $node,
- 'comments' => array(),
- 'comment_form' => array(),
- );
- }
-
- return $additions;
- }
-
- * Retrieve comments for a thread.
- *
- * @param $node
- * The node whose comment(s) needs rendering.
- * @param $mode
- * The comment display mode; COMMENT_MODE_FLAT or COMMENT_MODE_THREADED.
- * @param $comments_per_page
- * The amount of comments to display per page.
- *
- * To display threaded comments in the correct order we keep a 'thread' field
- * and order by that value. This field keeps this data in
- * a way which is easy to update and convenient to use.
- *
- * A "thread" value starts at "1". If we add a child (A) to this comment,
- * we assign it a "thread" = "1.1". A child of (A) will have "1.1.1". Next
- * brother of (A) will get "1.2". Next brother of the parent of (A) will get
- * "2" and so on.
- *
- * First of all note that the thread field stores the depth of the comment:
- * depth 0 will be "X", depth 1 "X.X", depth 2 "X.X.X", etc.
- *
- * Now to get the ordering right, consider this example:
- *
- * 1
- * 1.1
- * 1.1.1
- * 1.2
- * 2
- *
- * If we "ORDER BY thread ASC" we get the above result, and this is the
- * natural order sorted by time. However, if we "ORDER BY thread DESC"
- * we get:
- *
- * 2
- * 1.2
- * 1.1.1
- * 1.1
- * 1
- *
- * Clearly, this is not a natural way to see a thread, and users will get
- * confused. The natural order to show a thread by time desc would be:
- *
- * 2
- * 1
- * 1.2
- * 1.1
- * 1.1.1
- *
- * which is what we already did before the standard pager patch. To achieve
- * this we simply add a "/" at the end of each "thread" value. This way, the
- * thread fields will look like this:
- *
- * 1/
- * 1.1/
- * 1.1.1/
- * 1.2/
- * 2/
- *
- * we add "/" since this char is, in ASCII, higher than every number, so if
- * now we "ORDER BY thread DESC" we get the correct order. However this would
- * spoil the reverse ordering, "ORDER BY thread ASC" -- here, we do not need
- * to consider the trailing "/" so we use a substring only.
- */
- function comment_get_thread($node, $mode, $comments_per_page) {
- $query = db_select('comment', 'c')->extend('PagerDefault');
- $query->addField('c', 'cid');
- $query
- ->condition('c.nid', $node->nid)
- ->addTag('node_access')
- ->addTag('comment_filter')
- ->addMetaData('node', $node)
- ->limit($comments_per_page);
-
- $count_query = db_select('comment', 'c');
- $count_query->addExpression('COUNT(*)');
- $count_query
- ->condition('c.nid', $node->nid)
- ->addTag('node_access')
- ->addTag('comment_filter')
- ->addMetaData('node', $node);
-
- if (!user_access('administer comments')) {
- $query->condition('c.status', COMMENT_PUBLISHED);
- $count_query->condition('c.status', COMMENT_PUBLISHED);
- }
- if ($mode === COMMENT_MODE_FLAT) {
- $query->orderBy('c.cid', 'ASC');
- }
- else {
-
-
-
- $query->addExpression('SUBSTRING(c.thread, 1, (LENGTH(c.thread) - 1))', 'torder');
- $query->orderBy('torder', 'ASC');
- }
-
- $query->setCountQuery($count_query);
- $cids = $query->execute()->fetchCol();
-
- return $cids;
- }
-
- * Loop over comment thread, noting indentation level.
- *
- * @param array $comments
- * An array of comment objects, keyed by cid.
- * @return
- * The $comments argument is altered by reference with indentation information.
- */
- function comment_prepare_thread(&$comments) {
-
- $first_new = TRUE;
-
-
- $divs = 0;
-
- foreach ($comments as $key => $comment) {
- if ($first_new && $comment->new != MARK_READ) {
-
-
- $first_new = FALSE;
- $comment->first_new = TRUE;
- }
-
-
-
- $comment->depth = count(explode('.', $comment->thread)) - 1;
- if ($comment->depth > $divs) {
- $comment->divs = 1;
- $divs++;
- }
- else {
- $comment->divs = $comment->depth - $divs;
- while ($comment->depth < $divs) {
- $divs--;
- }
- }
- $comments[$key] = $comment;
- }
-
-
- $comments[$key]->divs_final = $divs;
- }
-
- * Generate an array for rendering the given comment.
- *
- * @param $comment
- * A comment object.
- * @param $node
- * The node the comment is attached to.
- * @param $view_mode
- * View mode, e.g. 'full', 'teaser'...
- * @param $langcode
- * (optional) A language code to use for rendering. Defaults to the global
- * content language of the current request.
- *
- * @return
- * An array as expected by drupal_render().
- */
- function comment_view($comment, $node, $view_mode = 'full', $langcode = NULL) {
- if (!isset($langcode)) {
- $langcode = $GLOBALS['language_content']->language;
- }
-
-
- comment_build_content($comment, $node, $view_mode, $langcode);
-
- $build = $comment->content;
-
- unset($comment->content);
-
- $build += array(
- '#theme' => 'comment__node_' . $node->type,
- '#comment' => $comment,
- '#node' => $node,
- '#view_mode' => $view_mode,
- '#language' => $langcode,
- );
-
- if (empty($comment->in_preview)) {
- $prefix = '';
- $is_threaded = isset($comment->divs) && variable_get('comment_default_mode_' . $node->type, COMMENT_MODE_THREADED) == COMMENT_MODE_THREADED;
-
-
- if (!empty($comment->first_new)) {
- $prefix .= "<a id=\"new\"></a>\n";
- }
-
-
- if ($is_threaded) {
- $prefix .= $comment->divs <= 0 ? str_repeat('</div>', abs($comment->divs)) : "\n" . '<div class="indented">';
- }
-
-
- $prefix .= "<a id=\"comment-$comment->cid\"></a>\n";
- $build['#prefix'] = $prefix;
-
-
- if ($is_threaded && !empty($comment->divs_final)) {
- $build['#suffix'] = str_repeat('</div>', $comment->divs_final);
- }
- }
-
-
- $type = 'comment';
- drupal_alter(array('comment_view', 'entity_view'), $build, $type);
-
- return $build;
- }
-
- * Builds a structured array representing the comment's content.
- *
- * The content built for the comment (field values, comments, file attachments or
- * other comment components) will vary depending on the $view_mode parameter.
- *
- * @param $comment
- * A comment object.
- * @param $node
- * The node the comment is attached to.
- * @param $view_mode
- * View mode, e.g. 'full', 'teaser'...
- * @param $langcode
- * (optional) A language code to use for rendering. Defaults to the global
- * content language of the current request.
- */
- function comment_build_content($comment, $node, $view_mode = 'full', $langcode = NULL) {
- if (!isset($langcode)) {
- $langcode = $GLOBALS['language_content']->language;
- }
-
-
- $comment->content = array();
-
-
- $context = array(
- 'entity_type' => 'comment',
- 'entity' => $comment,
- 'langcode' => $langcode,
- );
- drupal_alter('entity_view_mode', $view_mode, $context);
-
-
- field_attach_prepare_view('comment', array($comment->cid => $comment), $view_mode, $langcode);
- entity_prepare_view('comment', array($comment->cid => $comment), $langcode);
- $comment->content += field_attach_view('comment', $comment, $view_mode, $langcode);
-
- $comment->content['links'] = array(
- '#theme' => 'links__comment',
- '#pre_render' => array('drupal_pre_render_links'),
- '#attributes' => array('class' => array('links', 'inline')),
- );
- if (empty($comment->in_preview)) {
- $comment->content['links']['comment'] = array(
- '#theme' => 'links__comment__comment',
- '#links' => comment_links($comment, $node),
- '#attributes' => array('class' => array('links', 'inline')),
- );
- }
-
-
- module_invoke_all('comment_view', $comment, $view_mode, $langcode);
- module_invoke_all('entity_view', $comment, 'comment', $view_mode, $langcode);
-
-
-
- $comment->content += array('#view_mode' => $view_mode);
- }
-
- * Helper function, build links for an individual comment.
- *
- * Adds reply, edit, delete etc. depending on the current user permissions.
- *
- * @param $comment
- * The comment object.
- * @param $node
- * The node the comment is attached to.
- * @return
- * A structured array of links.
- */
- function comment_links($comment, $node) {
- $links = array();
- if ($node->comment == COMMENT_NODE_OPEN) {
- if (user_access('administer comments') && user_access('post comments')) {
- $links['comment-delete'] = array(
- 'title' => t('delete'),
- 'href' => "comment/$comment->cid/delete",
- 'html' => TRUE,
- );
- $links['comment-edit'] = array(
- 'title' => t('edit'),
- 'href' => "comment/$comment->cid/edit",
- 'html' => TRUE,
- );
- $links['comment-reply'] = array(
- 'title' => t('reply'),
- 'href' => "comment/reply/$comment->nid/$comment->cid",
- 'html' => TRUE,
- );
- if ($comment->status == COMMENT_NOT_PUBLISHED) {
- $links['comment-approve'] = array(
- 'title' => t('approve'),
- 'href' => "comment/$comment->cid/approve",
- 'html' => TRUE,
- 'query' => array('token' => drupal_get_token("comment/$comment->cid/approve")),
- );
- }
- }
- elseif (user_access('post comments')) {
- if (comment_access('edit', $comment)) {
- $links['comment-edit'] = array(
- 'title' => t('edit'),
- 'href' => "comment/$comment->cid/edit",
- 'html' => TRUE,
- );
- }
- $links['comment-reply'] = array(
- 'title' => t('reply'),
- 'href' => "comment/reply/$comment->nid/$comment->cid",
- 'html' => TRUE,
- );
- }
- else {
- $links['comment_forbidden']['title'] = theme('comment_post_forbidden', array('node' => $node));
- $links['comment_forbidden']['html'] = TRUE;
- }
- }
- return $links;
- }
-
- * Construct a drupal_render() style array from an array of loaded comments.
- *
- * @param $comments
- * An array of comments as returned by comment_load_multiple().
- * @param $node
- * The node the comments are attached to.
- * @param $view_mode
- * View mode, e.g. 'full', 'teaser'...
- * @param $weight
- * An integer representing the weight of the first comment in the list.
- * @param $langcode
- * A string indicating the language field values are to be shown in. If no
- * language is provided the current content language is used.
- *
- * @return
- * An array in the format expected by drupal_render().
- */
- function comment_view_multiple($comments, $node, $view_mode = 'full', $weight = 0, $langcode = NULL) {
- field_attach_prepare_view('comment', $comments, $view_mode, $langcode);
- entity_prepare_view('comment', $comments, $langcode);
-
- $build = array(
- '#sorted' => TRUE,
- );
- foreach ($comments as $comment) {
- $build[$comment->cid] = comment_view($comment, $node, $view_mode, $langcode);
- $build[$comment->cid]['#weight'] = $weight;
- $weight++;
- }
- return $build;
- }
-
- * Implements hook_form_FORM_ID_alter().
- */
- function comment_form_node_type_form_alter(&$form, $form_state) {
- if (isset($form['type'])) {
- $form['comment'] = array(
- '#type' => 'fieldset',
- '#title' => t('Comment settings'),
- '#collapsible' => TRUE,
- '#collapsed' => TRUE,
- '#group' => 'additional_settings',
- '#attributes' => array(
- 'class' => array('comment-node-type-settings-form'),
- ),
- '#attached' => array(
- 'js' => array(drupal_get_path('module', 'comment') . '/comment-node-form.js'),
- ),
- );
-
-
-
- $form['comment']['comment'] = array(
- '#type' => 'select',
- '#title' => t('Default comment setting for new content'),
- '#default_value' => variable_get('comment_' . $form['#node_type']->type, COMMENT_NODE_OPEN),
- '#options' => array(
- COMMENT_NODE_OPEN => t('Open'),
- COMMENT_NODE_CLOSED => t('Closed'),
- COMMENT_NODE_HIDDEN => t('Hidden'),
- ),
- );
- $form['comment']['comment_default_mode'] = array(
- '#type' => 'checkbox',
- '#title' => t('Threading'),
- '#default_value' => variable_get('comment_default_mode_' . $form['#node_type']->type, COMMENT_MODE_THREADED),
- '#description' => t('Show comment replies in a threaded list.'),
- );
- $form['comment']['comment_default_per_page'] = array(
- '#type' => 'select',
- '#title' => t('Comments per page'),
- '#default_value' => variable_get('comment_default_per_page_' . $form['#node_type']->type, 50),
- '#options' => _comment_per_page(),
- );
- $form['comment']['comment_anonymous'] = array(
- '#type' => 'select',
- '#title' => t('Anonymous commenting'),
- '#default_value' => variable_get('comment_anonymous_' . $form['#node_type']->type, COMMENT_ANONYMOUS_MAYNOT_CONTACT),
- '#options' => array(
- COMMENT_ANONYMOUS_MAYNOT_CONTACT => t('Anonymous posters may not enter their contact information'),
- COMMENT_ANONYMOUS_MAY_CONTACT => t('Anonymous posters may leave their contact information'),
- COMMENT_ANONYMOUS_MUST_CONTACT => t('Anonymous posters must leave their contact information'),
- ),
- '#access' => user_access('post comments', drupal_anonymous_user()),
- );
- $form['comment']['comment_subject_field'] = array(
- '#type' => 'checkbox',
- '#title' => t('Allow comment title'),
- '#default_value' => variable_get('comment_subject_field_' . $form['#node_type']->type, 1),
- );
- $form['comment']['comment_form_location'] = array(
- '#type' => 'checkbox',
- '#title' => t('Show reply form on the same page as comments'),
- '#default_value' => variable_get('comment_form_location_' . $form['#node_type']->type, COMMENT_FORM_BELOW),
- );
- $form['comment']['comment_preview'] = array(
- '#type' => 'radios',
- '#title' => t('Preview comment'),
- '#default_value' => variable_get('comment_preview_' . $form['#node_type']->type, DRUPAL_OPTIONAL),
- '#options' => array(
- DRUPAL_DISABLED => t('Disabled'),
- DRUPAL_OPTIONAL => t('Optional'),
- DRUPAL_REQUIRED => t('Required'),
- ),
- );
- }
- }
-
- * Implements hook_form_BASE_FORM_ID_alter().
- */
- function comment_form_node_form_alter(&$form, $form_state) {
- $node = $form['#node'];
- $form['comment_settings'] = array(
- '#type' => 'fieldset',
- '#access' => user_access('administer comments'),
- '#title' => t('Comment settings'),
- '#collapsible' => TRUE,
- '#collapsed' => TRUE,
- '#group' => 'additional_settings',
- '#attributes' => array(
- 'class' => array('comment-node-settings-form'),
- ),
- '#attached' => array(
- 'js' => array(drupal_get_path('module', 'comment') . '/comment-node-form.js'),
- ),
- '#weight' => 30,
- );
- $comment_count = isset($node->nid) ? db_query('SELECT comment_count FROM {node_comment_statistics} WHERE nid = :nid', array(':nid' => $node->nid))->fetchField() : 0;
- $comment_settings = ($node->comment == COMMENT_NODE_HIDDEN && empty($comment_count)) ? COMMENT_NODE_CLOSED : $node->comment;
- $form['comment_settings']['comment'] = array(
- '#type' => 'radios',
- '#title' => t('Comments'),
- '#title_display' => 'invisible',
- '#parents' => array('comment'),
- '#default_value' => $comment_settings,
- '#options' => array(
- COMMENT_NODE_OPEN => t('Open'),
- COMMENT_NODE_CLOSED => t('Closed'),
- COMMENT_NODE_HIDDEN => t('Hidden'),
- ),
- COMMENT_NODE_OPEN => array(
- '#description' => t('Users with the "Post comments" permission can post comments.'),
- ),
- COMMENT_NODE_CLOSED => array(
- '#description' => t('Users cannot post comments, but existing comments will be displayed.'),
- ),
- COMMENT_NODE_HIDDEN => array(
- '#description' => t('Comments are hidden from view.'),
- ),
- );
-
-
- if (empty($comment_count)) {
- $form['comment_settings']['comment'][COMMENT_NODE_HIDDEN]['#access'] = FALSE;
-
- $form['comment_settings']['comment'][COMMENT_NODE_CLOSED]['#description'] = t('Users cannot post comments.');
- }
- }
-
- * Implements hook_node_load().
- */
- function comment_node_load($nodes, $types) {
- $comments_enabled = array();
-
-
-
- foreach ($nodes as $node) {
-
- if ($node->comment != COMMENT_NODE_HIDDEN) {
- $comments_enabled[] = $node->nid;
- }
- else {
- $node->cid = 0;
- $node->last_comment_timestamp = $node->created;
- $node->last_comment_name = '';
- $node->last_comment_uid = $node->uid;
- $node->comment_count = 0;
- }
- }
-
-
- if (!empty($comments_enabled)) {
- $result = db_query('SELECT nid, cid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count FROM {node_comment_statistics} WHERE nid IN (:comments_enabled)', array(':comments_enabled' => $comments_enabled));
- foreach ($result as $record) {
- $nodes[$record->nid]->cid = $record->cid;
- $nodes[$record->nid]->last_comment_timestamp = $record->last_comment_timestamp;
- $nodes[$record->nid]->last_comment_name = $record->last_comment_name;
- $nodes[$record->nid]->last_comment_uid = $record->last_comment_uid;
- $nodes[$record->nid]->comment_count = $record->comment_count;
- }
- }
- }
-
- * Implements hook_node_prepare().
- */
- function comment_node_prepare($node) {
- if (!isset($node->comment)) {
- $node->comment = variable_get("comment_$node->type", COMMENT_NODE_OPEN);
- }
- }
-
- * Implements hook_node_insert().
- */
- function comment_node_insert($node) {
-
-
- if (variable_get('comment_maintain_node_statistics', TRUE)) {
- db_insert('node_comment_statistics')
- ->fields(array(
- 'nid' => $node->nid,
- 'cid' => 0,
- 'last_comment_timestamp' => $node->changed,
- 'last_comment_name' => NULL,
- 'last_comment_uid' => $node->uid,
- 'comment_count' => 0,
- ))
- ->execute();
- }
- }
-
- * Implements hook_node_delete().
- */
- function comment_node_delete($node) {
- $cids = db_query('SELECT cid FROM {comment} WHERE nid = :nid', array(':nid' => $node->nid))->fetchCol();
- comment_delete_multiple($cids);
- db_delete('node_comment_statistics')
- ->condition('nid', $node->nid)
- ->execute();
- }
-
- * Implements hook_node_update_index().
- */
- function comment_node_update_index($node) {
- $index_comments = &drupal_static(__FUNCTION__);
-
- if ($index_comments === NULL) {
-
- $perms = array('access comments' => array(), 'search content' => array());
- $result = db_query("SELECT rid, permission FROM {role_permission} WHERE permission IN ('access comments', 'search content')");
- foreach ($result as $record) {
- $perms[$record->permission][$record->rid] = $record->rid;
- }
-
-
-
- $index_comments = TRUE;
- foreach ($perms['search content'] as $rid) {
- if (!isset($perms['access comments'][$rid]) && ($rid <= DRUPAL_AUTHENTICATED_RID || !isset($perms['access comments'][DRUPAL_AUTHENTICATED_RID]))) {
- $index_comments = FALSE;
- break;
- }
- }
- }
-
- if ($index_comments) {
- $mode = variable_get('comment_default_mode_' . $node->type, COMMENT_MODE_THREADED);
- $comments_per_page = variable_get('comment_default_per_page_' . $node->type, 50);
- if ($node->comment && $cids = comment_get_thread($node, $mode, $comments_per_page)) {
- $comments = comment_load_multiple($cids);
- comment_prepare_thread($comments);
- $build = comment_view_multiple($comments, $node);
- return drupal_render($build);
- }
- }
- return '';
- }
-
- * Implements hook_update_index().
- */
- function comment_update_index() {
-
- variable_set('node_cron_comments_scale', 1.0 / max(1, db_query('SELECT MAX(comment_count) FROM {node_comment_statistics}')->fetchField()));
- }
-
- * Implements hook_node_search_result().
- *
- * Formats a comment count string and returns it, for display with search
- * results.
- */
- function comment_node_search_result($node) {
-
- if (user_access('access comments') && $node->comment != COMMENT_NODE_HIDDEN) {
- $comments = db_query('SELECT comment_count FROM {node_comment_statistics} WHERE nid = :nid', array('nid' => $node->nid))->fetchField();
-
-
- if ($node->comment != COMMENT_NODE_CLOSED || $comments > 0) {
- return array('comment' => format_plural($comments, '1 comment', '@count comments'));
- }
- }
- }
-
- * Implements hook_user_cancel().
- */
- function comment_user_cancel($edit, $account, $method) {
- switch ($method) {
- case 'user_cancel_block_unpublish':
- $comments = comment_load_multiple(array(), array('uid' => $account->uid));
- foreach ($comments as $comment) {
- $comment->status = 0;
- comment_save($comment);
- }
- break;
-
- case 'user_cancel_reassign':
- $comments = comment_load_multiple(array(), array('uid' => $account->uid));
- foreach ($comments as $comment) {
- $comment->uid = 0;
- comment_save($comment);
- }
- break;
- }
- }
-
- * Implements hook_user_delete().
- */
- function comment_user_delete($account) {
- $cids = db_query('SELECT c.cid FROM {comment} c WHERE uid = :uid', array(':uid' => $account->uid))->fetchCol();
- comment_delete_multiple($cids);
- }
-
- * Determines whether the current user has access to a particular comment.
- *
- * Authenticated users can edit their comments as long they have not been
- * replied to. This prevents people from changing or revising their statements
- * based on the replies to their posts.
- *
- * @param $op
- * The operation that is to be performed on the comment. Only 'edit' is
- * recognized now.
- * @param $comment
- * The comment object.
- * @return
- * TRUE if the current user has acces to the comment, FALSE otherwise.
- */
- function comment_access($op, $comment) {
- global $user;
-
- if ($op == 'edit') {
- return ($user->uid && $user->uid == $comment->uid && $comment->status == COMMENT_PUBLISHED && user_access('edit own comments')) || user_access('administer comments');
- }
- }
-
- * Accepts a submission of new or changed comment content.
- *
- * @param $comment
- * A comment object.
- */
- function comment_save($comment) {
- global $user;
-
- $transaction = db_transaction();
- try {
- $defaults = array(
- 'mail' => '',
- 'homepage' => '',
- 'name' => '',
- 'status' => user_access('skip comment approval') ? COMMENT_PUBLISHED : COMMENT_NOT_PUBLISHED,
- );
- foreach ($defaults as $key => $default) {
- if (!isset($comment->$key)) {
- $comment->$key = $default;
- }
- }
-
- if (!isset($comment->node_type)) {
- $node = node_load($comment->nid);
- $comment->node_type = 'comment_node_' . $node->type;
- }
-
-
- if (!empty($comment->cid) && !isset($comment->original)) {
- $comment->original = entity_load_unchanged('comment', $comment->cid);
- }
-
- field_attach_presave('comment', $comment);
-
-
- module_invoke_all('comment_presave', $comment);
- module_invoke_all('entity_presave', $comment, 'comment');
-
- if ($comment->cid) {
-
- drupal_write_record('comment', $comment, 'cid');
-
-
-
- db_ignore_slave();
-
-
- _comment_update_node_statistics($comment->nid);
-
- field_attach_update('comment', $comment);
-
- module_invoke_all('comment_update', $comment);
- module_invoke_all('entity_update', $comment, 'comment');
- }
- else {
-
-
- if (!empty($comment->thread)) {
-
- $thread = $comment->thread;
- }
- elseif ($comment->pid == 0) {
-
-
- $max = db_query('SELECT MAX(thread) FROM {comment} WHERE nid = :nid', array(':nid' => $comment->nid))->fetchField();
-
- $max = rtrim($max, '/');
-
- $parts = explode('.', $max);
- $firstsegment = $parts[0];
-
- $thread = int2vancode(vancode2int($firstsegment) + 1) . '/';
- }
- else {
-
-
-
-
- $parent = comment_load($comment->pid);
-
- $parent->thread = (string) rtrim((string) $parent->thread, '/');
-
- $max = db_query("SELECT MAX(thread) FROM {comment} WHERE thread LIKE :thread AND nid = :nid", array(
- ':thread' => $parent->thread . '.%',
- ':nid' => $comment->nid,
- ))->fetchField();
-
- if ($max == '') {
-
- $thread = $parent->thread . '.' . int2vancode(0) . '/';
- }
- else {
-
- $max = rtrim($max, '/');
-
- $parts = explode('.', $max);
- $parent_depth = count(explode('.', $parent->thread));
- $last = $parts[$parent_depth];
-
- $thread = $parent->thread . '.' . int2vancode(vancode2int($last) + 1) . '/';
- }
- }
-
- if (empty($comment->created)) {
- $comment->created = REQUEST_TIME;
- }
-
- if (empty($comment->changed)) {
- $comment->changed = $comment->created;
- }
-
- if ($comment->uid === $user->uid && isset($user->name)) {
- $comment->name = $user->name;
- }
-
-
- if (empty($comment->pid)) {
- $comment->pid = 0;
- }
-
-
- $comment->thread = $thread;
- $comment->hostname = ip_address();
-
- drupal_write_record('comment', $comment);
-
-
-
- db_ignore_slave();
-
-
- _comment_update_node_statistics($comment->nid);
-
- field_attach_insert('comment', $comment);
-
-
- module_invoke_all('comment_insert', $comment);
- module_invoke_all('entity_insert', $comment, 'comment');
- }
- if ($comment->status == COMMENT_PUBLISHED) {
- module_invoke_all('comment_publish', $comment);
- }
- unset($comment->original);
- }
- catch (Exception $e) {
- $transaction->rollback('comment');
- watchdog_exception('comment', $e);
- throw $e;
- }
-
- }
-
- * Delete a comment and all its replies.
- *
- * @param $cid
- * The comment to delete.
- */
- function comment_delete($cid) {
- comment_delete_multiple(array($cid));
- }
-
- * Delete comments and all their replies.
- *
- * @param $cids
- * The comment to delete.
- */
- function comment_delete_multiple($cids) {
- $comments = comment_load_multiple($cids);
- if ($comments) {
- $transaction = db_transaction();
- try {
-
- db_delete('comment')
- ->condition('cid', array_keys($comments), 'IN')
- ->execute();
- foreach ($comments as $comment) {
- field_attach_delete('comment', $comment);
- module_invoke_all('comment_delete', $comment);
- module_invoke_all('entity_delete', $comment, 'comment');
-
-
- $child_cids = db_query('SELECT cid FROM {comment} WHERE pid = :cid', array(':cid' => $comment->cid))->fetchCol();
- comment_delete_multiple($child_cids);
- _comment_update_node_statistics($comment->nid);
- }
- }
- catch (Exception $e) {
- $transaction->rollback();
- watchdog_exception('comment', $e);
- throw $e;
- }
- }
- }
-
- * Load comments from the database.
- *
- * @param $cids
- * An array of comment IDs.
- * @param $conditions
- * (deprecated) An associative array of conditions on the {comments}
- * table, where the keys are the database fields and the values are the
- * values those fields must have. Instead, it is preferable to use
- * EntityFieldQuery to retrieve a list of entity IDs loadable by
- * this function.
- * @param $reset
- * Whether to reset the internal static entity cache. Note that the static
- * cache is disabled in comment_entity_info() by default.
- *
- * @return
- * An array of comment objects, indexed by comment ID.
- *
- * @see entity_load()
- * @see EntityFieldQuery
- *
- * @todo Remove $conditions in Drupal 8.
- */
- function comment_load_multiple($cids = array(), $conditions = array(), $reset = FALSE) {
- return entity_load('comment', $cids, $conditions, $reset);
- }
-
- * Load the entire comment by cid.
- *
- * @param $cid
- * The identifying comment id.
- * @param $reset
- * Whether to reset the internal static entity cache. Note that the static
- * cache is disabled in comment_entity_info() by default.
- *
- * @return
- * The comment object.
- */
- function comment_load($cid, $reset = FALSE) {
- $comment = comment_load_multiple(array($cid), array(), $reset);
- return $comment ? $comment[$cid] : FALSE;
- }
-
- * Controller class for comments.
- *
- * This extends the DrupalDefaultEntityController class, adding required
- * special handling for comment objects.
- */
- class CommentController extends DrupalDefaultEntityController {
-
- protected function buildQuery($ids, $conditions = array(), $revision_id = FALSE) {
- $query = parent::buildQuery($ids, $conditions, $revision_id);
-
- $query->innerJoin('node', 'n', 'base.nid = n.nid');
- $query->addField('n', 'type', 'node_type');
- $query->innerJoin('users', 'u', 'base.uid = u.uid');
- $query->addField('u', 'name', 'registered_name');
- $query->fields('u', array('uid', 'signature', 'signature_format', 'picture'));
- return $query;
- }
-
- protected function attachLoad(&$comments, $revision_id = FALSE) {
-
- foreach ($comments as $key => $comment) {
- $comment->name = $comment->uid ? $comment->registered_name : $comment->name;
- $comment->new = node_mark($comment->nid, $comment->changed);
- $comment->node_type = 'comment_node_' . $comment->node_type;
- $comments[$key] = $comment;
- }
- parent::attachLoad($comments, $revision_id);
- }
- }
-
- * Get number of new comments for current user and specified node.
- *
- * @param $nid
- * Node-id to count comments for.
- * @param $timestamp
- * Time to count from (defaults to time of last user access
- * to node).
- * @return The result or FALSE on error.
- */
- function comment_num_new($nid, $timestamp = 0) {
- global $user;
-
- if ($user->uid) {
-
- if (!$timestamp) {
- $timestamp = node_last_viewed($nid);
- }
- $timestamp = ($timestamp > NODE_NEW_LIMIT ? $timestamp : NODE_NEW_LIMIT);
-
-
- 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;
- }
-
- }
-
- * Get the display ordinal for a comment, starting from 0.
- *
- * Count the number of comments which appear before the comment we want to
- * display, taking into account display settings and threading.
- *
- * @param $cid
- * The comment ID.
- * @param $node_type
- * The node type of the comment's parent.
- * @return
- * The display ordinal for the comment.
- * @see comment_get_display_page()
- */
- function comment_get_display_ordinal($cid, $node_type) {
-
-
- $query = db_select('comment', 'c1');
- $query->innerJoin('comment', 'c2', 'c2.nid = c1.nid');
- $query->addExpression('COUNT(*)', 'count');
- $query->condition('c2.cid', $cid);
- if (!user_access('administer comments')) {
- $query->condition('c1.status', COMMENT_PUBLISHED);
- }
- $mode = variable_get('comment_default_mode_' . $node_type, COMMENT_MODE_THREADED);
-
- if ($mode == COMMENT_MODE_FLAT) {
-
-
-
- $query->condition('c1.cid', $cid, '<');
- }
- else {
-
-
-
- $query->where('SUBSTRING(c1.thread, 1, (LENGTH(c1.thread) -1)) < SUBSTRING(c2.thread, 1, (LENGTH(c2.thread) -1))');
- }
-
- return $query->execute()->fetchField();
- }
-
- * Return the page number for a comment.
- *
- * Finds the correct page number for a comment taking into account display
- * and paging settings.
- *
- * @param $cid
- * The comment ID.
- * @param $node_type
- * The node type the comment is attached to.
- * @return
- * The page number.
- */
- function comment_get_display_page($cid, $node_type) {
- $ordinal = comment_get_display_ordinal($cid, $node_type);
- $comments_per_page = variable_get('comment_default_per_page_' . $node_type, 50);
- return floor($ordinal / $comments_per_page);
- }
-
- * Page callback for comment editing.
- */
- function comment_edit_page($comment) {
- drupal_set_title(t('Edit comment %comment', array('%comment' => $comment->subject)), PASS_THROUGH);
- $node = node_load($comment->nid);
- return drupal_get_form("comment_node_{$node->type}_form", $comment);
- }
-
- * Implements hook_forms().
- */
- function comment_forms() {
- $forms = array();
- foreach (node_type_get_types() as $type) {
- $forms["comment_node_{$type->type}_form"]['callback'] = 'comment_form';
- }
- return $forms;
- }
-
- * Generate the basic commenting form, for appending to a node or display on a separate page.
- *
- * @see comment_form_validate()
- * @see comment_form_submit()
- *
- * @ingroup forms
- */
- function comment_form($form, &$form_state, $comment) {
- global $user;
-
-
-
-
- if (!isset($form_state['comment'])) {
- $defaults = array(
- 'name' => '',
- 'mail' => '',
- 'homepage' => '',
- 'subject' => '',
- 'comment' => '',
- 'cid' => NULL,
- 'pid' => NULL,
- 'language' => LANGUAGE_NONE,
- 'uid' => 0,
- );
- foreach ($defaults as $key => $value) {
- if (!isset($comment->$key)) {
- $comment->$key = $value;
- }
- }
- $form_state['comment'] = $comment;
- }
- else {
- $comment = $form_state['comment'];
- }
-
- $node = node_load($comment->nid);
- $form['#node'] = $node;
-
-
- $form['#id'] = drupal_html_id('comment_form');
- $form['#attributes']['class'][] = 'comment-form';
- $form['#theme'] = array('comment_form__node_' . $node->type, 'comment_form');
-
- $anonymous_contact = variable_get('comment_anonymous_' . $node->type, COMMENT_ANONYMOUS_MAYNOT_CONTACT);
- $is_admin = (!empty($comment->cid) && user_access('administer comments'));
-
- if (!$user->uid && $anonymous_contact != COMMENT_ANONYMOUS_MAYNOT_CONTACT) {
- $form['#attached']['library'][] = array('system', 'jquery.cookie');
- $form['#attributes']['class'][] = 'user-info-from-cookie';
- }
-
-
-
- if (empty($comment->cid) && empty($comment->pid)) {
- $form['#action'] = url('comment/reply/' . $comment->nid);
- }
-
- if (isset($form_state['comment_preview'])) {
- $form += $form_state['comment_preview'];
- }
-
-
- if ($is_admin) {
- $form['author'] = array(
- '#type' => 'fieldset',
- '#title' => t('Administration'),
- '#collapsible' => TRUE,
- '#collapsed' => TRUE,
- '#weight' => -2,
- );
- }
- else {
-
- $form['author'] = array(
- '#weight' => -2,
- );
- }
-
-
- if ($is_admin) {
- $author = (!$comment->uid && $comment->name ? $comment->name : $comment->registered_name);
- $status = (isset($comment->status) ? $comment->status : COMMENT_NOT_PUBLISHED);
- $date = (!empty($comment->date) ? $comment->date : format_date($comment->created, 'custom', 'Y-m-d H:i O'));
- }
- else {
- if ($user->uid) {
- $author = $user->name;
- }
- else {
- $author = ($comment->name ? $comment->name : '');
- }
- $status = (user_access('skip comment approval') ? COMMENT_PUBLISHED : COMMENT_NOT_PUBLISHED);
- $date = '';
- }
-
-
- if ($is_admin) {
- $form['author']['name'] = array(
- '#type' => 'textfield',
- '#title' => t('Authored by'),
- '#default_value' => $author,
- '#maxlength' => 60,
- '#size' => 30,
- '#description' => t('Leave blank for %anonymous.', array('%anonymous' => variable_get('anonymous', t('Anonymous')))),
- '#autocomplete_path' => 'user/autocomplete',
- );
- }
- elseif ($user->uid) {
- $form['author']['_author'] = array(
- '#type' => 'item',
- '#title' => t('Your name'),
- '#markup' => theme('username', array('account' => $user)),
- );
- $form['author']['name'] = array(
- '#type' => 'value',
- '#value' => $author,
- );
- }
- else {
- $form['author']['name'] = array(
- '#type' => 'textfield',
- '#title' => t('Your name'),
- '#default_value' => $author,
- '#required' => (!$user->uid && $anonymous_contact == COMMENT_ANONYMOUS_MUST_CONTACT),
- '#maxlength' => 60,
- '#size' => 30,
- );
- }
-
-
- $form['author']['mail'] = array(
- '#type' => 'textfield',
- '#title' => t('E-mail'),
- '#default_value' => $comment->mail,
- '#required' => (!$user->uid && $anonymous_contact == COMMENT_ANONYMOUS_MUST_CONTACT),
- '#maxlength' => 64,
- '#size' => 30,
- '#description' => t('The content of this field is kept private and will not be shown publicly.'),
- '#access' => $is_admin || (!$user->uid && $anonymous_contact != COMMENT_ANONYMOUS_MAYNOT_CONTACT),
- );
- $form['author']['homepage'] = array(
- '#type' => 'textfield',
- '#title' => t('Homepage'),
- '#default_value' => $comment->homepage,
- '#maxlength' => 255,
- '#size' => 30,
- '#access' => $is_admin || (!$user->uid && $anonymous_contact != COMMENT_ANONYMOUS_MAYNOT_CONTACT),
- );
-
-
- $form['author']['date'] = array(
- '#type' => 'textfield',
- '#title' => t('Authored on'),
- '#default_value' => $date,
- '#maxlength' => 25,
- '#size' => 20,
- '#access' => $is_admin,
- );
- $form['author']['status'] = array(
- '#type' => 'radios',
- '#title' => t('Status'),
- '#default_value' => $status,
- '#options' => array(
- COMMENT_PUBLISHED => t('Published'),
- COMMENT_NOT_PUBLISHED => t('Not published'),
- ),
- '#access' => $is_admin,
- );
-
- $form['subject'] = array(
- '#type' => 'textfield',
- '#title' => t('Subject'),
- '#maxlength' => 64,
- '#default_value' => $comment->subject,
- '#access' => variable_get('comment_subject_field_' . $node->type, 1) == 1,
- '#weight' => -1,
- );
-
-
- $form['is_anonymous'] = array(
- '#type' => 'value',
- '#value' => ($comment->cid ? !$comment->uid : !$user->uid),
- );
-
-
- foreach (array('cid', 'pid', 'nid', 'language', 'uid') as $key) {
- $form[$key] = array('#type' => 'value', '#value' => $comment->$key);
- }
- $form['node_type'] = array('#type' => 'value', '#value' => 'comment_node_' . $node->type);
-
-
-
- $form['actions'] = array('#type' => 'actions');
- $form['actions']['submit'] = array(
- '#type' => 'submit',
- '#value' => t('Save'),
- '#access' => ($comment->cid && user_access('administer comments')) || variable_get('comment_preview_' . $node->type, DRUPAL_OPTIONAL) != DRUPAL_REQUIRED || isset($form_state['comment_preview']),
- '#weight' => 19,
- );
- $form['actions']['preview'] = array(
- '#type' => 'submit',
- '#value' => t('Preview'),
- '#access' => (variable_get('comment_preview_' . $node->type, DRUPAL_OPTIONAL) != DRUPAL_DISABLED),
- '#weight' => 20,
- '#submit' => array('comment_form_build_preview'),
- );
-
-
- $comment->node_type = 'comment_node_' . $node->type;
- $langcode = entity_language('comment', $comment);
- field_attach_form('comment', $comment, $form, $form_state, $langcode);
-
- return $form;
- }
-
- * Build a preview from submitted form values.
- */
- function comment_form_build_preview($form, &$form_state) {
- $comment = comment_form_submit_build_comment($form, $form_state);
- $form_state['comment_preview'] = comment_preview($comment);
- $form_state['rebuild'] = TRUE;
- }
-
- * Generate a comment preview.
- */
- function comment_preview($comment) {
- global $user;
-
- drupal_set_title(t('Preview comment'), PASS_THROUGH);
-
- $node = node_load($comment->nid);
-
- if (!form_get_errors()) {
- $comment_body = field_get_items('comment', $comment, 'comment_body');
- $comment->format = $comment_body[0]['format'];
-
- if (!empty($comment->name)) {
- $account = user_load_by_name($comment->name);
- }
- elseif ($user->uid && empty($comment->is_anonymous)) {
- $account = $user;
- }
-
- if (!empty($account->uid)) {
- $comment->uid = $account->uid;
- $comment->name = check_plain($account->name);
- $comment->signature = $account->signature;
- $comment->signature_format = $account->signature_format;
- $comment->picture = $account->picture;
- }
- elseif (empty($comment->name)) {
- $comment->name = variable_get('anonymous', t('Anonymous'));
- }
-
- $comment->created = !empty($comment->created) ? $comment->created : REQUEST_TIME;
- $comment->changed = REQUEST_TIME;
- $comment->in_preview = TRUE;
- $comment_build = comment_view($comment, $node);
- $comment_build['#weight'] = -100;
-
- $form['comment_preview'] = $comment_build;
- }
-
- if ($comment->pid) {
- $build = array();
- if ($comments = comment_load_multiple(array($comment->pid), array('status' => COMMENT_PUBLISHED))) {
- $parent_comment = $comments[$comment->pid];
- $build = comment_view($parent_comment, $node);
- }
- }
- else {
- $build = node_view($node);
- }
-
- $form['comment_output_below'] = $build;
- $form['comment_output_below']['#weight'] = 100;
-
- return $form;
- }
-
- * Validate comment form submissions.
- */
- function comment_form_validate($form, &$form_state) {
- global $user;
-
- entity_form_field_validate('comment', $form, $form_state);
-
- if (!empty($form_state['values']['cid'])) {
-
- $account = user_load_by_name($form_state['values']['name']);
- $form_state['values']['uid'] = $account ? $account->uid : 0;
-
- if ($form_state['values']['date'] && strtotime($form_state['values']['date']) === FALSE) {
- form_set_error('date', t('You have to specify a valid date.'));
- }
- if ($form_state['values']['name'] && !$form_state['values']['is_anonymous'] && !$account) {
- form_set_error('name', t('You have to specify a valid author.'));
- }
- }
- elseif ($form_state['values']['is_anonymous']) {
-
-
-
- if ($form_state['values']['name']) {
- $query = db_select('users', 'u');
- $query->addField('u', 'uid', 'uid');
- $taken = $query
- ->condition('name', db_like($form_state['values']['name']), 'LIKE')
- ->countQuery()
- ->execute()
- ->fetchField();
- if ($taken) {
- form_set_error('name', t('The name you used belongs to a registered user.'));
- }
- }
- }
- if ($form_state['values']['mail'] && !valid_email_address($form_state['values']['mail'])) {
- form_set_error('mail', t('The e-mail address you specified is not valid.'));
- }
- if ($form_state['values']['homepage'] && !valid_url($form_state['values']['homepage'], TRUE)) {
- form_set_error('homepage', t('The URL of your homepage is not valid. Remember that it must be fully qualified, i.e. of the form <code>http://example.com/directory</code>.'));
- }
- }
-
- * Prepare a comment for submission.
- */
- function comment_submit($comment) {
-
- if (is_array($comment)) {
- $comment += array('subject' => '');
- $comment = (object) $comment;
- }
-
- if (empty($comment->date)) {
- $comment->date = 'now';
- }
- $comment->created = strtotime($comment->date);
- $comment->changed = REQUEST_TIME;
-
-
-
- if (!$comment->is_anonymous && !empty($comment->name) && ($account = user_load_by_name($comment->name))) {
- $comment->uid = $account->uid;
- }
-
-
- if ($comment->is_anonymous && (!isset($comment->name) || $comment->name === '')) {
- $comment->name = variable_get('anonymous', t('Anonymous'));
- }
-
-
- if (trim($comment->subject) == '') {
-
-
-
-
- $field = field_info_field('comment_body');
- $langcode = field_is_translatable('comment', $field) ? entity_language('comment', $comment) : LANGUAGE_NONE;
- $comment_body = $comment->comment_body[$langcode][0];
- if (isset($comment_body['format'])) {
- $comment_text = check_markup($comment_body['value'], $comment_body['format']);
- }
- else {
- $comment_text = check_plain($comment_body['value']);
- }
- $comment->subject = truncate_utf8(trim(decode_entities(strip_tags($comment_text))), 29, TRUE);
-
-
- if ($comment->subject == '') {
- $comment->subject = t('(No subject)');
- }
- }
- return $comment;
- }
-
- * Updates the form state's comment entity by processing this submission's values.
- *
- * This is the default builder function for the comment form. It is called
- * during the "Save" and "Preview" submit handlers to retrieve the entity to
- * save or preview. This function can also be called by a "Next" button of a
- * wizard to update the form state's entity with the current step's values
- * before proceeding to the next step.
- *
- * @see comment_form()
- */
- function comment_form_submit_build_comment($form, &$form_state) {
- $comment = $form_state['comment'];
- entity_form_submit_build_entity('comment', $comment, $form, $form_state);
- comment_submit($comment);
- return $comment;
- }
-
- * Process comment form submissions; prepare the comment, store it, and set a redirection target.
- */
- function comment_form_submit($form, &$form_state) {
- $node = node_load($form_state['values']['nid']);
- $comment = comment_form_submit_build_comment($form, $form_state);
- if (user_access('post comments') && (user_access('administer comments') || $node->comment == COMMENT_NODE_OPEN)) {
-
- if (user_is_anonymous()) {
- user_cookie_save(array_intersect_key($form_state['values'], array_flip(array('name', 'mail', 'homepage'))));
- }
-
- comment_save($comment);
- $form_state['values']['cid'] = $comment->cid;
-
-
- watchdog('content', 'Comment posted: %subject.', array('%subject' => $comment->subject), WATCHDOG_NOTICE, l(t('view'), 'comment/' . $comment->cid, array('fragment' => 'comment-' . $comment->cid)));
-
-
- if ($comment->status == COMMENT_NOT_PUBLISHED) {
- if (!user_access('administer comments')) {
- drupal_set_message(t('Your comment has been queued for review by site administrators and will be published after approval.'));
- }
- }
- else {
- drupal_set_message(t('Your comment has been posted.'));
- }
- $query = array();
-
- $page = comment_get_display_page($comment->cid, $node->type);
- if ($page > 0) {
- $query['page'] = $page;
- }
-
- $redirect = array('node/' . $node->nid, array('query' => $query, 'fragment' => 'comment-' . $comment->cid));
- }
- else {
- watchdog('content', 'Comment: unauthorized comment submitted or comment submitted to a closed post %subject.', array('%subject' => $comment->subject), WATCHDOG_WARNING);
- drupal_set_message(t('Comment: unauthorized comment submitted or comment submitted to a closed post %subject.', array('%subject' => $comment->subject)), 'error');
-
- $redirect = 'node/' . $node->nid;
- }
- $form_state['redirect'] = $redirect;
-
-
- cache_clear_all();
- }
-
- * Process variables for comment.tpl.php.
- *
- * @see comment.tpl.php
- */
- function template_preprocess_comment(&$variables) {
- $comment = $variables['elements']['#comment'];
- $node = $variables['elements']['#node'];
- $variables['comment'] = $comment;
- $variables['node'] = $node;
- $variables['author'] = theme('username', array('account' => $comment));
-
- $variables['created'] = format_date($comment->created);
-
-
- if ($comment->changed == $comment->created) {
- $variables['changed'] = $variables['created'];
- }
- else {
- $variables['changed'] = format_date($comment->changed);
- }
-
- $variables['new'] = !empty($comment->new) ? t('new') : '';
- $variables['picture'] = theme_get_setting('toggle_comment_user_picture') ? theme('user_picture', array('account' => $comment)) : '';
- $variables['signature'] = $comment->signature;
-
- $uri = entity_uri('comment', $comment);
- $uri['options'] += array('attributes' => array('class' => 'permalink', 'rel' => 'bookmark'));
-
- $variables['title'] = l($comment->subject, $uri['path'], $uri['options']);
- $variables['permalink'] = l(t('Permalink'), $uri['path'], $uri['options']);
- $variables['submitted'] = t('Submitted by !username on !datetime', array('!username' => $variables['author'], '!datetime' => $variables['created']));
-
-
- field_attach_preprocess('comment', $comment, $variables['elements'], $variables);
-
-
- foreach (element_children($variables['elements']) as $key) {
- $variables['content'][$key] = $variables['elements'][$key];
- }
-
-
- if (isset($comment->in_preview)) {
- $variables['status'] = 'comment-preview';
- }
- else {
- $variables['status'] = ($comment->status == COMMENT_NOT_PUBLISHED) ? 'comment-unpublished' : 'comment-published';
- }
-
-
-
-
- if ($variables['status'] != 'comment-published') {
- $variables['classes_array'][] = $variables['status'];
- }
- if ($variables['new']) {
- $variables['classes_array'][] = 'comment-new';
- }
- if (!$comment->uid) {
- $variables['classes_array'][] = 'comment-by-anonymous';
- }
- else {
- if ($comment->uid == $variables['node']->uid) {
- $variables['classes_array'][] = 'comment-by-node-author';
- }
- if ($comment->uid == $variables['user']->uid) {
- $variables['classes_array'][] = 'comment-by-viewer';
- }
- }
- }
-
- * Returns HTML for a "you can't post comments" notice.
- *
- * @param $variables
- * An associative array containing:
- * - node: The comment node.
- *
- * @ingroup themeable
- */
- function theme_comment_post_forbidden($variables) {
- $node = $variables['node'];
- global $user;
-
-
-
- $authenticated_post_comments = &drupal_static(__FUNCTION__, NULL);
-
- if (!$user->uid) {
- if (!isset($authenticated_post_comments)) {
-
-
- $comment_roles = user_roles(TRUE, 'post comments');
- $authenticated_post_comments = isset($comment_roles[DRUPAL_AUTHENTICATED_RID]);
- }
-
- if ($authenticated_post_comments) {
-
-
- if (variable_get('comment_form_location_' . $node->type, COMMENT_FORM_BELOW) == COMMENT_FORM_SEPARATE_PAGE) {
- $destination = array('destination' => "comment/reply/$node->nid#comment-form");
- }
- else {
- $destination = array('destination' => "node/$node->nid#comment-form");
- }
-
- if (variable_get('user_register', USER_REGISTER_VISITORS_ADMINISTRATIVE_APPROVAL)) {
-
- return t('<a href="@login">Log in</a> or <a href="@register">register</a> to post comments', array('@login' => url('user/login', array('query' => $destination)), '@register' => url('user/register', array('query' => $destination))));
- }
- else {
-
- return t('<a href="@login">Log in</a> to post comments', array('@login' => url('user/login', array('query' => $destination))));
- }
- }
- }
- }
-
- * Process variables for comment-wrapper.tpl.php.
- *
- * @see comment-wrapper.tpl.php
- */
- function template_preprocess_comment_wrapper(&$variables) {
-
- $variables['node'] = $variables['content']['#node'];
- $variables['display_mode'] = variable_get('comment_default_mode_' . $variables['node']->type, COMMENT_MODE_THREADED);
-
- $variables['content'] += array('comment_form' => array());
- }
-
- * Return an array of viewing modes for comment listings.
- *
- * We can't use a global variable array because the locale system
- * is not initialized yet when the comment module is loaded.
- */
- function _comment_get_modes() {
- return array(
- COMMENT_MODE_FLAT => t('Flat list'),
- COMMENT_MODE_THREADED => t('Threaded list')
- );
- }
-
- * Return an array of "comments per page" settings from which the user
- * can choose.
- */
- function _comment_per_page() {
- return drupal_map_assoc(array(10, 30, 50, 70, 90, 150, 200, 250, 300));
- }
-
- * Updates the comment statistics for a given node. This should be called any
- * time a comment is added, deleted, or updated.
- *
- * The following fields are contained in the node_comment_statistics table.
- * - last_comment_timestamp: the timestamp of the last comment for this node or the node create stamp if no comments exist for the node.
- * - last_comment_name: the name of the anonymous poster for the last comment
- * - last_comment_uid: the uid of the poster for the last comment for this node or the node authors uid if no comments exists for the node.
- * - comment_count: the total number of approved/published comments on this node.
- */
- function _comment_update_node_statistics($nid) {
-
-
- if (!variable_get('comment_maintain_node_statistics', TRUE)) {
- return;
- }
-
- $count = db_query('SELECT COUNT(cid) FROM {comment} WHERE nid = :nid AND status = :status', array(
- ':nid' => $nid,
- ':status' => COMMENT_PUBLISHED,
- ))->fetchField();
-
- if ($count > 0) {
-
- $last_reply = db_query_range('SELECT cid, name, changed, uid FROM {comment} WHERE nid = :nid AND status = :status ORDER BY cid DESC', 0, 1, array(
- ':nid' => $nid,
- ':status' => COMMENT_PUBLISHED,
- ))->fetchObject();
- db_update('node_comment_statistics')
- ->fields(array(
- 'cid' => $last_reply->cid,
- 'comment_count' => $count,
- 'last_comment_timestamp' => $last_reply->changed,
- 'last_comment_name' => $last_reply->uid ? '' : $last_reply->name,
- 'last_comment_uid' => $last_reply->uid,
- ))
- ->condition('nid', $nid)
- ->execute();
- }
- else {
-
- $node = db_query('SELECT uid, created FROM {node} WHERE nid = :nid', array(':nid' => $nid))->fetchObject();
- db_update('node_comment_statistics')
- ->fields(array(
- 'cid' => 0,
- 'comment_count' => 0,
- 'last_comment_timestamp' => $node->created,
- 'last_comment_name' => '',
- 'last_comment_uid' => $node->uid,
- ))
- ->condition('nid', $nid)
- ->execute();
- }
- }
-
- * Generate vancode.
- *
- * Consists of a leading character indicating length, followed by N digits
- * with a numerical value in base 36. Vancodes can be sorted as strings
- * without messing up numerical order.
- *
- * It goes:
- * 00, 01, 02, ..., 0y, 0z,
- * 110, 111, ... , 1zy, 1zz,
- * 2100, 2101, ..., 2zzy, 2zzz,
- * 31000, 31001, ...
- */
- function int2vancode($i = 0) {
- $num = base_convert((int) $i, 10, 36);
- $length = strlen($num);
-
- return chr($length + ord('0') - 1) . $num;
- }
-
- * Decode vancode back to an integer.
- */
- function vancode2int($c = '00') {
- return base_convert(substr($c, 1), 36, 10);
- }
-
- * Implements hook_action_info().
- */
- function comment_action_info() {
- return array(
- 'comment_publish_action' => array(
- 'label' => t('Publish comment'),
- 'type' => 'comment',
- 'configurable' => FALSE,
- 'behavior' => array('changes_property'),
- 'triggers' => array('comment_presave', 'comment_insert', 'comment_update'),
- ),
- 'comment_unpublish_action' => array(
- 'label' => t('Unpublish comment'),
- 'type' => 'comment',
- 'configurable' => FALSE,
- 'behavior' => array('changes_property'),
- 'triggers' => array('comment_presave', 'comment_insert', 'comment_update'),
- ),
- 'comment_unpublish_by_keyword_action' => array(
- 'label' => t('Unpublish comment containing keyword(s)'),
- 'type' => 'comment',
- 'configurable' => TRUE,
- 'behavior' => array('changes_property'),
- 'triggers' => array('comment_presave', 'comment_insert', 'comment_update'),
- ),
- 'comment_save_action' => array(
- 'label' => t('Save comment'),
- 'type' => 'comment',
- 'configurable' => FALSE,
- 'triggers' => array('comment_insert', 'comment_update'),
- ),
- );
- }
-
- * Publishes a comment.
- *
- * @param $comment
- * An optional comment object.
- * @param array $context
- * Array with components:
- * - 'cid': Comment ID. Required if $comment is not given.
- *
- * @ingroup actions
- */
- function comment_publish_action($comment, $context = array()) {
- if (isset($comment->subject)) {
- $subject = $comment->subject;
- $comment->status = COMMENT_PUBLISHED;
- }
- else {
- $cid = $context['cid'];
- $subject = db_query('SELECT subject FROM {comment} WHERE cid = :cid', array(':cid' => $cid))->fetchField();
- db_update('comment')
- ->fields(array('status' => COMMENT_PUBLISHED))
- ->condition('cid', $cid)
- ->execute();
- }
- watchdog('action', 'Published comment %subject.', array('%subject' => $subject));
- }
-
- * Unpublishes a comment.
- *
- * @param $comment
- * An optional comment object.
- * @param array $context
- * Array with components:
- * - 'cid': Comment ID. Required if $comment is not given.
- *
- * @ingroup actions
- */
- function comment_unpublish_action($comment, $context = array()) {
- if (isset($comment->subject)) {
- $subject = $comment->subject;
- $comment->status = COMMENT_NOT_PUBLISHED;
- }
- else {
- $cid = $context['cid'];
- $subject = db_query('SELECT subject FROM {comment} WHERE cid = :cid', array(':cid' => $cid))->fetchField();
- db_update('comment')
- ->fields(array('status' => COMMENT_NOT_PUBLISHED))
- ->condition('cid', $cid)
- ->execute();
- }
- watchdog('action', 'Unpublished comment %subject.', array('%subject' => $subject));
- }
-
- * Unpublishes a comment if it contains certain keywords.
- *
- * @param $comment
- * Comment object to modify.
- * @param array $context
- * Array with components:
- * - 'keywords': Keywords to look for. If the comment contains at least one
- * of the keywords, it is unpublished.
- *
- * @ingroup actions
- * @see comment_unpublish_by_keyword_action_form()
- * @see comment_unpublish_by_keyword_action_submit()
- */
- function comment_unpublish_by_keyword_action($comment, $context) {
- foreach ($context['keywords'] as $keyword) {
- $text = drupal_render($comment);
- if (strpos($text, $keyword) !== FALSE) {
- $comment->status = COMMENT_NOT_PUBLISHED;
- watchdog('action', 'Unpublished comment %subject.', array('%subject' => $comment->subject));
- break;
- }
- }
- }
-
- * Form builder; Prepare a form for blacklisted keywords.
- *
- * @ingroup forms
- * @see comment_unpublish_by_keyword_action()
- * @see comment_unpublish_by_keyword_action_submit()
- */
- function comment_unpublish_by_keyword_action_form($context) {
- $form['keywords'] = array(
- '#title' => t('Keywords'),
- '#type' => 'textarea',
- '#description' => t('The comment will be unpublished if it contains any of the phrases above. Use a case-sensitive, comma-separated list of phrases. Example: funny, bungee jumping, "Company, Inc."'),
- '#default_value' => isset($context['keywords']) ? drupal_implode_tags($context['keywords']) : '',
- );
-
- return $form;
- }
-
- * Process comment_unpublish_by_keyword_action_form form submissions.
- *
- * @see comment_unpublish_by_keyword_action()
- */
- function comment_unpublish_by_keyword_action_submit($form, $form_state) {
- return array('keywords' => drupal_explode_tags($form_state['values']['keywords']));
- }
-
- * Saves a comment.
- *
- * @ingroup actions
- */
- function comment_save_action($comment) {
- comment_save($comment);
- cache_clear_all();
- watchdog('action', 'Saved comment %title', array('%title' => $comment->subject));
- }
-
- * Implements hook_ranking().
- */
- function comment_ranking() {
- return array(
- 'comments' => array(
- 'title' => t('Number of comments'),
- 'join' => array(
- 'type' => 'LEFT',
- 'table' => 'node_comment_statistics',
- 'alias' => 'node_comment_statistics',
- 'on' => 'node_comment_statistics.nid = i.sid',
- ),
-
- 'score' => '2.0 - 2.0 / (1.0 + node_comment_statistics.comment_count * CAST(:scale AS DECIMAL))',
- 'arguments' => array(':scale' => variable_get('node_cron_comments_scale', 0)),
- ),
- );
- }
-
- * Implements hook_rdf_mapping().
- */
- function comment_rdf_mapping() {
- return array(
- array(
- 'type' => 'comment',
- 'bundle' => RDF_DEFAULT_BUNDLE,
- 'mapping' => array(
- 'rdftype' => array('sioc:Post', 'sioct:Comment'),
- 'title' => array(
- 'predicates' => array('dc:title'),
- ),
- 'created' => array(
- 'predicates' => array('dc:date', 'dc:created'),
- 'datatype' => 'xsd:dateTime',
- 'callback' => 'date_iso8601',
- ),
- 'changed' => array(
- 'predicates' => array('dc:modified'),
- 'datatype' => 'xsd:dateTime',
- 'callback' => 'date_iso8601',
- ),
- 'comment_body' => array(
- 'predicates' => array('content:encoded'),
- ),
- 'pid' => array(
- 'predicates' => array('sioc:reply_of'),
- 'type' => 'rel',
- ),
- 'uid' => array(
- 'predicates' => array('sioc:has_creator'),
- 'type' => 'rel',
- ),
- 'name' => array(
- 'predicates' => array('foaf:name'),
- ),
- ),
- ),
- );
- }
-
- * Implements hook_file_download_access().
- */
- function comment_file_download_access($field, $entity_type, $entity) {
- if ($entity_type == 'comment') {
- if (user_access('access comments') && $entity->status == COMMENT_PUBLISHED || user_access('administer comments')) {
- $node = node_load($entity->nid);
- return node_access('view', $node);
- }
- return FALSE;
- }
- }
-