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 = esc_url($comment->comment_author_url);
|
---|
93 | $comment->comment_author_url = format_to_edit( $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 | ?>
|
---|