Changeset 365 for trunk/b2calendar.php

Timestamp:

09/10/2003 07:30:08 AM (22 years ago)

Author:

alex_t_king

Message:

added check for post_status to query that sees which days have posts

File:

• trunk/b2calendar.php (modified) (1 diff)

trunk/b2calendar.php

@@ -128 +128 @@
 $calendarmonthwithpost = 0;
 while($calendarmonthwithpost == 0) {
-    $arc_sql="SELECT DISTINCT YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date) AS dom FROM $tableposts WHERE MONTH(post_date) = '$thismonth' AND YEAR(post_date) = '$thisyear' ORDER BY post_date DESC";
+    $arc_sql="SELECT DISTINCT YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date) AS dom FROM $tableposts WHERE MONTH(post_date) = '$thismonth' AND YEAR(post_date) = '$thisyear' AND post_status = 'publish' ORDER BY post_date DESC";
     $querycount++;
     $arc_results = $wpdb->get_results($arc_sql);