Changeset 5821

Timestamp:

07/29/2007 07:56:55 PM (19 years ago)

Author:

matt

Message:

Shows pending moderation comments in title and bold comment numbers with comments that need attention.

Location:

trunk/wp-admin

Files:

• edit-post-rows.php (modified) (1 diff)
• includes/comment.php (modified) (1 diff)

trunk/wp-admin/edit-post-rows.php

@@ -58 +58 @@
                 ?>
                 <td style="text-align: center">
-                        <?php comments_number("<a href='edit.php?p=$id&amp;c=1'>" . __('0') . '</a>', "<a href='edit.php?p=$id&amp;c=1'>" . __('1') . '</a>', "<a href='edit.php?p=$id&amp;c=1'>" . __('%') . '</a>') ?>
-                        </td>
+                <?php
+                $left = get_pending_comments_num( $post->ID );
+                $pending_phrase = sprintf( __('%s pending'), number_format( $left ) );
+                if ( $left )
+                        echo '<strong>';
+                comments_number("<a href='edit.php?p=$id&amp;c=1' title='$pending_phrase'>" . __('0') . '</a>', "<a href='edit.php?p=$id&amp;c=1' title='$pending_phrase'>" . __('1') . '</a>', "<a href='edit.php?p=$id&amp;c=1' title='$pending_phrase'>" . __('%') . '</a>');
+                if ( $left )
+                        echo '</strong>';
+                ?>
+                </td>
                 <?php
                 break;

trunk/wp-admin/includes/comment.php

@@ -59 +59 @@
 }
 
+function get_pending_comments_num( $post_id ) {
+        global $wpdb;
+        $post_id = (int) $post_id;
+        $pending = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = $post_id AND comment_approved = '0'" );
+        return $pending;
+}
+
 ?>