Changeset 3202 for trunk/wp-includes/template-functions-general.php

Timestamp:

11/23/2005 07:57:58 AM (21 years ago)

Author:

matt

Message:

Don't show 0 as a month.

File:

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

trunk/wp-includes/template-functions-general.php

@@ -324 +324 @@
 
         if ( 'monthly' == $type ) {
-                $arcresults = $wpdb->get_results("SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM $wpdb->posts WHERE post_date < '$now' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC" . $limit);
+                $arcresults = $wpdb->get_results("SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM $wpdb->posts WHERE post_date < '$now' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC" . $limit);
                 if ( $arcresults ) {
                         $afterafter = $after;
@@ -339 +339 @@
                 }
         } elseif ( 'daily' == $type ) {
-                $arcresults = $wpdb->get_results("SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, DAYOFMONTH(post_date) AS `dayofmonth` FROM $wpdb->posts WHERE post_date < '$now' AND post_status = 'publish' ORDER BY post_date DESC" . $limit);
+                $arcresults = $wpdb->get_results("SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, DAYOFMONTH(post_date) AS `dayofmonth` FROM $wpdb->posts WHERE post_date < '$now' AND post_date != '0000-00-00 00:00:00' AND post_status = 'publish' ORDER BY post_date DESC" . $limit);
                 if ( $arcresults ) {
                         foreach ( $arcresults as $arcresult ) {