Changeset 21610

Timestamp:

08/24/2012 08:50:22 PM (12 years ago)

Author:

nacin

Message:

Add 'order' to wp_get_archives(). props tar.gz. fixes #18832.

File:

• trunk/wp-includes/general-template.php (modified) (6 diffs)

trunk/wp-includes/general-template.php

@@ -870 +870 @@
         'format' => 'html', 'before' => '',
         'after' => '', 'show_post_count' => false,
-        'echo' => 1
+        'echo' => 1, 'order' => 'DESC',
     );
 
@@ -883 +883 @@
         $limit = ' LIMIT '.$limit;
     }
+
+    $order = strtoupper( $order );
+    if ( $order !== 'ASC' )
+        $order = 'DESC';
 
     // this is what will separate dates on weekly archive links
@@ -910 +914 @@
 
     if ( 'monthly' == $type ) {
-        $query = "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC $limit";
+        $query = "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date $order $limit";
         $key = md5($query);
         $cache = wp_cache_get( 'wp_get_archives' , 'general');
@@ -932 +936 @@
         }
     } elseif ('yearly' == $type) {
-        $query = "SELECT YEAR(post_date) AS `year`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date) ORDER BY post_date DESC $limit";
+        $query = "SELECT YEAR(post_date) AS `year`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date) ORDER BY post_date $order $limit";
         $key = md5($query);
         $cache = wp_cache_get( 'wp_get_archives' , 'general');
@@ -953 +957 @@
         }
     } elseif ( 'daily' == $type ) {
-        $query = "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, DAYOFMONTH(post_date) AS `dayofmonth`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date) ORDER BY post_date DESC $limit";
+        $query = "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, DAYOFMONTH(post_date) AS `dayofmonth`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date) ORDER BY post_date $order $limit";
         $key = md5($query);
         $cache = wp_cache_get( 'wp_get_archives' , 'general');
@@ -976 +980 @@
     } elseif ( 'weekly' == $type ) {
         $week = _wp_mysql_week( '`post_date`' );
-        $query = "SELECT DISTINCT $week AS `week`, YEAR( `post_date` ) AS `yr`, DATE_FORMAT( `post_date`, '%Y-%m-%d' ) AS `yyyymmdd`, count( `ID` ) AS `posts` FROM `$wpdb->posts` $join $where GROUP BY $week, YEAR( `post_date` ) ORDER BY `post_date` DESC $limit";
+        $query = "SELECT DISTINCT $week AS `week`, YEAR( `post_date` ) AS `yr`, DATE_FORMAT( `post_date`, '%Y-%m-%d' ) AS `yyyymmdd`, count( `ID` ) AS `posts` FROM `$wpdb->posts` $join $where GROUP BY $week, YEAR( `post_date` ) ORDER BY `post_date` $order $limit";
         $key = md5($query);
         $cache = wp_cache_get( 'wp_get_archives' , 'general');