Changeset 5727

Timestamp:

06/19/2007 05:57:53 PM (17 years ago)

Author:

rob1n

Message:

Fix up wp_list_authors() SQL. fixes #4485

File:

• trunk/wp-includes/author-template.php (modified) (1 diff)

trunk/wp-includes/author-template.php

@@ -379 +379 @@
 
     $author_count = array();
-    foreach ((array) $wpdb->get_results("SELECT DISTINCT post_author, COUNT(ID) AS count FROM $wpdb->posts WHERE post_status = 'publish' GROUP BY post_author") as $row) {
+    foreach ((array) $wpdb->get_results("SELECT DISTINCT post_author, COUNT(ID) AS count FROM $wpdb->posts WHERE post_type = 'post' AND " . get_private_posts_cap_sql( 'post' ) . " GROUP BY post_author") as $row) {
         $author_count[$row->post_author] = $row->count;
     }