1 <?php

     2 /**

     3  * WordPress Comment Administration API.

     4  *

     5  * @package WordPress

     6  * @subpackage Administration

     7  */

     8 

     9 /**

    10  * {@internal Missing Short Description}}

    11  *

    12  * @since unknown

    13  * @uses $wpdb

    14  *

    15  * @param string $comment_author

    16  * @param string $comment_date

    17  * @return mixed Comment ID on success.

    18  */

    19 function comment_exists($comment_author, $comment_date) {

    20 	global $wpdb;

    21 

    22 	$comment_author = stripslashes($comment_author);

    23 	$comment_date = stripslashes($comment_date);

    24 

    25 	return $wpdb->get_var( $wpdb->prepare("SELECT comment_post_ID FROM $wpdb->comments

    26 			WHERE comment_author = %s AND comment_date = %s", $comment_author, $comment_date) );

    27 }

    28 

    29 /**

    30  * {@internal Missing Short Description}}

    31  *

    32  * @since unknown

    33  */

    34 function edit_comment() {

    35 

    36 	$comment_post_ID = (int) $_POST['comment_post_ID'];

    37 

    38 	if (!current_user_can( 'edit_post', $comment_post_ID ))

    39 		wp_die( __('You are not allowed to edit comments on this post, so you cannot edit this comment.' ));

    40 

    41 	$_POST['comment_author'] = $_POST['newcomment_author'];

    42 	$_POST['comment_author_email'] = $_POST['newcomment_author_email'];

    43 	$_POST['comment_author_url'] = $_POST['newcomment_author_url'];

    44 	$_POST['comment_approved'] = $_POST['comment_status'];

    45 	$_POST['comment_content'] = $_POST['content'];

    46 	$_POST['comment_ID'] = (int) $_POST['comment_ID'];

    47 

    48 	foreach ( array ('aa', 'mm', 'jj', 'hh', 'mn') as $timeunit ) {

    49 		if ( !empty( $_POST['hidden_' . $timeunit] ) && $_POST['hidden_' . $timeunit] != $_POST[$timeunit] ) {

    50 			$_POST['edit_date'] = '1';

    51 			break;

    52 		}

    53 	}

    54 

    55 	if (!empty ( $_POST['edit_date'] ) ) {

    56 		$aa = $_POST['aa'];

    57 		$mm = $_POST['mm'];

    58 		$jj = $_POST['jj'];

    59 		$hh = $_POST['hh'];

    60 		$mn = $_POST['mn'];

    61 		$ss = $_POST['ss'];

    62 		$jj = ($jj > 31 ) ? 31 : $jj;

    63 		$hh = ($hh > 23 ) ? $hh -24 : $hh;

    64 		$mn = ($mn > 59 ) ? $mn -60 : $mn;

    65 		$ss = ($ss > 59 ) ? $ss -60 : $ss;

    66 		$_POST['comment_date'] = "$aa-$mm-$jj $hh:$mn:$ss";

    67 	}

    68 

    69 	wp_update_comment( $_POST);

    70 }

    71 

    72 /**

    73  * {@internal Missing Short Description}}

    74  *

    75  * @since unknown

    76  *

    77  * @param unknown_type $id

    78  * @return unknown

    79  */

    80 function get_comment_to_edit( $id ) {

    81 	if ( !$comment = get_comment($id) )

    82 		return false;

    83 

    84 	$comment->comment_ID = (int) $comment->comment_ID;

    85 	$comment->comment_post_ID = (int) $comment->comment_post_ID;

    86 

    87 	$comment->comment_content = format_to_edit( $comment->comment_content );

    88 	$comment->comment_content = apply_filters( 'comment_edit_pre', $comment->comment_content);

    89 

    90 	$comment->comment_author = format_to_edit( $comment->comment_author );

    91 	$comment->comment_author_email = format_to_edit( $comment->comment_author_email );

    92 	$comment->comment_author_url = format_to_edit( $comment->comment_author_url );

    93 	$comment->comment_author_url = esc_url($comment->comment_author_url);

    94 

    95 	return $comment;

    96 }

    97 

    98 /**

    99  * {@internal Missing Short Description}}

   100  *

   101  * @since unknown

   102  * @uses $wpdb

   103  *

   104  * @param int $post_id Post ID

   105  * @return unknown

   106  */

   107 function get_pending_comments_num( $post_id ) {

   108 	global $wpdb;

   109 

   110 	$single = false;

   111 	if ( !is_array($post_id) ) {

   112 		$post_id = (array) $post_id;

   113 		$single = true;

   114 	}

   115 	$post_id = array_map('intval', $post_id);

   116 	$post_id = "'" . implode("', '", $post_id) . "'";

   117 

   118 	$pending = $wpdb->get_results( "SELECT comment_post_ID, COUNT(comment_ID) as num_comments FROM $wpdb->comments WHERE comment_post_ID IN ( $post_id ) AND comment_approved = '0' GROUP BY comment_post_ID", ARRAY_N );

   119 

   120 	if ( empty($pending) )

   121 		return 0;

   122 

   123 	if ( $single )

   124 		return $pending[0][1];

   125 

   126 	$pending_keyed = array();

   127 	foreach ( $pending as $pend )

   128 		$pending_keyed[$pend[0]] = $pend[1];

   129 

   130 	return $pending_keyed;

   131 }

   132 

   133 /**

   134  * Add avatars to relevant places in admin, or try to.

   135  *

   136  * @since unknown

   137  * @uses $comment

   138  *

   139  * @param string $name User name.

   140  * @return string Avatar with Admin name.

   141  */

   142 function floated_admin_avatar( $name ) {

   143 	global $comment;

   144 

   145 	$id = $avatar = false;

   146 	if ( $comment->comment_author_email )

   147 		$id = $comment->comment_author_email;

   148 	if ( $comment->user_id )

   149 		$id = $comment->user_id;

   150 

   151 	if ( $id )

   152 		$avatar = get_avatar( $id, 32 );

   153 

   154 	return "$avatar $name";

   155 }

   156 

   157 function enqueue_comment_hotkeys_js() {

   158 	if ( 'true' == get_user_option( 'comment_shortcuts' ) )

   159 		wp_enqueue_script( 'jquery-table-hotkeys' );

   160 }

   161 

   162 if ( is_admin() && isset($pagenow) && ('edit-comments.php' == $pagenow || 'edit.php' == $pagenow) ) {

   163 	if ( get_option('show_avatars') )

   164 		add_filter( 'comment_author', 'floated_admin_avatar' );

   165 }

   166 

   167 ?>