Changeset 10082 for trunk/wp-admin/includes/template.php

Timestamp:

12/06/2008 03:59:03 AM (17 years ago)

Author:

markjaquith

Message:

Cron order for single-post Edit Comments page. Remember Single Post when searching, switching comment statuses, and filtering comment types

File:

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

trunk/wp-admin/includes/template.php

@@ -1891 +1891 @@
         $approved = "( comment_approved = '0' OR comment_approved = '1' )";
 
-    if ( $post )
+    if ( $post ) {
         $post = " AND comment_post_ID = '$post'";
-    else
+        $orderby = "ORDER BY comment_date_gmt ASC LIMIT $start, $num";
+    } else {
         $post = '';
+        $orderby = "ORDER BY comment_date_gmt DESC LIMIT $start, $num";
+    }
 
     if ( 'comment' == $type )
@@ -1917 +1920 @@
             $approved
             $typesql
-            ORDER BY comment_date_gmt DESC LIMIT $start, $num");
+            $orderby");
     } else {
-        $comments = $wpdb->get_results( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->comments WHERE $approved $post $typesql ORDER BY comment_date_gmt DESC LIMIT $start, $num" );
+        $comments = $wpdb->get_results( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->comments WHERE $approved $post $typesql $orderby" );
     }