Changeset 19626

Timestamp:

12/22/2011 12:08:26 PM (13 years ago)

Author:

duck_

Message:

Show correct export date range for pages. The query should use provided $post_type instead of always 'post'. Props sorich87. Fixes #19312.

File:

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

trunk/wp-admin/export.php

@@ -96 +96 @@
 require_once ('admin-header.php');
 
-function export_date_options() {
+function export_date_options( $post_type = 'post' ) {
     global $wpdb, $wp_locale;
 
-    $months = $wpdb->get_results( "
+    $months = $wpdb->get_results( $wpdb->prepare( "
         SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month
         FROM $wpdb->posts
-        WHERE post_type = 'post' AND post_status != 'auto-draft'
+        WHERE post_type = %s AND post_status != 'auto-draft'
         ORDER BY post_date DESC
-    " );
+    ", $post_type ) );
 
     $month_count = count( $months );
@@ -183 +183 @@
         <select name="page_start_date">
             <option value="0"><?php _e( 'Start Date' ); ?></option>
-            <?php export_date_options(); ?>
+            <?php export_date_options( 'page' ); ?>
         </select>
         <select name="page_end_date">
             <option value="0"><?php _e( 'End Date' ); ?></option>
-            <?php export_date_options(); ?>
+            <?php export_date_options( 'page' ); ?>
         </select>
     </li>