Changeset 3528 for trunk/wp-admin/admin-db.php

Timestamp:

02/14/2006 06:23:03 AM (19 years ago)

Author:

ryan

Message:

Don't show private and draft pages in post lists. fixes #2442

File:

• trunk/wp-admin/admin-db.php (modified) (2 diffs)

trunk/wp-admin/admin-db.php

@@ -4 +4 @@
     global $wpdb;
     $user_id = (int) $user_id;
-    $query = "SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'draft' AND post_author = $user_id ORDER BY ID DESC";
+    $query = "SELECT ID, post_title FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'draft' AND post_author = $user_id ORDER BY ID DESC";
     $query = apply_filters('get_users_drafts', $query);
     return $wpdb->get_results( $query );
@@ -20 +20 @@
     } else {
         $editable = join(',', $editable);
-        $other_drafts = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'draft' AND post_author IN ($editable) AND post_author != '$user_id' ");
+        $other_drafts = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'draft' AND post_author IN ($editable) AND post_author != '$user_id' ");
     }