'fieldset', '#title' => t('Update options'), '#attributes' => array('class' => array('container-inline')), ); if ($arg == 'approval') { $options['publish'] = t('Publish the selected comments'); } else { $options['unpublish'] = t('Unpublish the selected comments'); } $options['delete'] = t('Delete the selected comments'); $form['options']['operation'] = array( '#type' => 'select', '#title' => t('Operation'), '#title_display' => 'invisible', '#options' => $options, '#default_value' => 'publish', ); $form['options']['submit'] = array( '#type' => 'submit', '#value' => t('Update'), ); // Load the comments that need to be displayed. $status = ($arg == 'approval') ? COMMENT_NOT_PUBLISHED : COMMENT_PUBLISHED; $header = array( 'subject' => array('data' => t('Subject'), 'field' => 'subject'), 'author' => array('data' => t('Author'), 'field' => 'name'), 'posted_in' => array('data' => t('Posted in'), 'field' => 'node_title'), 'changed' => array('data' => t('Updated'), 'field' => 'c.changed', 'sort' => 'desc'), 'operations' => array('data' => t('Operations')), ); $query = db_select('comment', 'c')->extend('PagerDefault')->extend('TableSort'); $query->join('node', 'n', 'n.nid = c.nid'); $query->addField('n', 'title', 'node_title'); $query->addTag('node_access'); $result = $query ->fields('c', array('cid', 'subject', 'name', 'changed')) ->condition('c.status', $status) ->limit(50) ->orderByHeader($header) ->execute(); $cids = array(); // We collect a sorted list of node_titles during the query to attach to the // comments later. foreach ($result as $row) { $cids[] = $row->cid; $node_titles[] = $row->node_title; } $comments = comment_load_multiple($cids); // Build a table listing the appropriate comments. $options = array(); $destination = drupal_get_destination(); foreach ($comments as $comment) { // Remove the first node title from the node_titles array and attach to // the comment. $comment->node_title = array_shift($node_titles); $comment_body = field_get_items('comment', $comment, 'comment_body'); $options[$comment->cid] = array( 'subject' => array( 'data' => array( '#type' => 'link', '#title' => $comment->subject, '#href' => 'comment/' . $comment->cid, '#options' => array('attributes' => array('title' => truncate_utf8($comment_body[0]['value'], 128)), 'fragment' => 'comment-' . $comment->cid), ), ), 'author' => theme('username', array('account' => $comment)), 'posted_in' => array( 'data' => array( '#type' => 'link', '#title' => $comment->node_title, '#href' => 'node/' . $comment->nid, ), ), 'changed' => format_date($comment->changed, 'short'), 'operations' => array( 'data' => array( '#type' => 'link', '#title' => t('edit'), '#href' => 'comment/' . $comment->cid . '/edit', '#options' => array('query' => $destination), ), ), ); } $form['comments'] = array( '#type' => 'tableselect', '#header' => $header, '#options' => $options, '#empty' => t('No comments available.'), ); $form['pager'] = array('#theme' => 'pager'); return $form; } /** * Validate comment_admin_overview form submissions. */ function comment_admin_overview_validate($form, &$form_state) { $form_state['values']['comments'] = array_diff($form_state['values']['comments'], array(0)); // We can't execute any 'Update options' if no comments were selected. if (count($form_state['values']['comments']) == 0) { form_set_error('', t('Select one or more comments to perform the update on.')); } } /** * Process comment_admin_overview form submissions. * * Execute the chosen 'Update option' on the selected comments, such as * publishing, unpublishing or deleting. */ function comment_admin_overview_submit($form, &$form_state) { $operation = $form_state['values']['operation']; $cids = $form_state['values']['comments']; if ($operation == 'delete') { comment_delete_multiple($cids); } else { foreach ($cids as $cid => $value) { $comment = comment_load($value); if ($operation == 'unpublish') { $comment->status = COMMENT_NOT_PUBLISHED; } elseif ($operation == 'publish') { $comment->status = COMMENT_PUBLISHED; } comment_save($comment); } } drupal_set_message(t('The update has been performed.')); $form_state['redirect'] = 'admin/content/comment'; cache_clear_all(); } /** * List the selected comments and verify that the admin wants to delete them. * * @param $form_state * An associative array containing the current state of the form. * @return * TRUE if the comments should be deleted, FALSE otherwise. * @ingroup forms * @see comment_multiple_delete_confirm_submit() */ function comment_multiple_delete_confirm($form, &$form_state) { $edit = $form_state['input']; $form['comments'] = array( '#prefix' => '', '#tree' => TRUE, ); // array_filter() returns only elements with actual values. $comment_counter = 0; foreach (array_filter($edit['comments']) as $cid => $value) { $comment = comment_load($cid); if (is_object($comment) && is_numeric($comment->cid)) { $subject = db_query('SELECT subject FROM {comment} WHERE cid = :cid', array(':cid' => $cid))->fetchField(); $form['comments'][$cid] = array('#type' => 'hidden', '#value' => $cid, '#prefix' => '
  • ', '#suffix' => check_plain($subject) . '
  • '); $comment_counter++; } } $form['operation'] = array('#type' => 'hidden', '#value' => 'delete'); if (!$comment_counter) { drupal_set_message(t('There do not appear to be any comments to delete, or your selected comment was deleted by another administrator.')); drupal_goto('admin/content/comment'); } else { return confirm_form($form, t('Are you sure you want to delete these comments and all their children?'), 'admin/content/comment', t('This action cannot be undone.'), t('Delete comments'), t('Cancel')); } } /** * Process comment_multiple_delete_confirm form submissions. */ function comment_multiple_delete_confirm_submit($form, &$form_state) { if ($form_state['values']['confirm']) { comment_delete_multiple(array_keys($form_state['values']['comments'])); cache_clear_all(); $count = count($form_state['values']['comments']); watchdog('content', 'Deleted @count comments.', array('@count' => $count)); drupal_set_message(format_plural($count, 'Deleted 1 comment.', 'Deleted @count comments.')); } $form_state['redirect'] = 'admin/content/comment'; } /** * Page callback for comment deletions. */ function comment_confirm_delete_page($cid) { if ($comment = comment_load($cid)) { return drupal_get_form('comment_confirm_delete', $comment); } return MENU_NOT_FOUND; } /** * Form builder; Builds the confirmation form for deleting a single comment. * * @ingroup forms * @see comment_confirm_delete_submit() */ function comment_confirm_delete($form, &$form_state, $comment) { $form['#comment'] = $comment; // Always provide entity id in the same form key as in the entity edit form. $form['cid'] = array('#type' => 'value', '#value' => $comment->cid); return confirm_form( $form, t('Are you sure you want to delete the comment %title?', array('%title' => $comment->subject)), 'node/' . $comment->nid, t('Any replies to this comment will be lost. This action cannot be undone.'), t('Delete'), t('Cancel'), 'comment_confirm_delete'); } /** * Process comment_confirm_delete form submissions. */ function comment_confirm_delete_submit($form, &$form_state) { $comment = $form['#comment']; // Delete the comment and its replies. comment_delete($comment->cid); drupal_set_message(t('The comment and all its replies have been deleted.')); watchdog('content', 'Deleted comment @cid and its replies.', array('@cid' => $comment->cid)); // Clear the cache so an anonymous user sees that his comment was deleted. cache_clear_all(); $form_state['redirect'] = "node/$comment->nid"; }