Changeset 5821

Timestamp:

07/29/2007 07:56:55 PM (17 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;
+}
+
 ?>