Changeset 5750

Timestamp:

06/24/2007 05:58:38 AM (17 years ago)

Author:

markjaquith

Message:

Order pending posts nag by post_modified ASC, drafts by post_modified DESC

File:

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

trunk/wp-admin/includes/user.php

@@ -194 +194 @@
         $type_sql = " ( post_status = 'draft' OR post_status = 'pending' ) ";
 
+    $dir = ( 'pending' == $type ) ? 'ASC' : 'DESC';
+
     if( !$editable ) {
         $other_unpubs = '';
     } else {
         $editable = join(',', $editable);
-        $other_unpubs = $wpdb->get_results("SELECT ID, post_title, post_author FROM $wpdb->posts WHERE post_type = 'post' AND $type_sql AND post_author IN ($editable) AND post_author != '$user_id' ");
+        $other_unpubs = $wpdb->get_results("SELECT ID, post_title, post_author FROM $wpdb->posts WHERE post_type = 'post' AND $type_sql AND post_author IN ($editable) AND post_author != '$user_id' ORDER BY post_modified $dir");
     }
 
@@ -232 +234 @@
     global $wpdb;
     $user_id = (int) $user_id;
-    $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 = "SELECT ID, post_title FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'draft' AND post_author = $user_id ORDER BY post_modified DESC";
     $query = apply_filters('get_users_drafts', $query);
     return $wpdb->get_results( $query );