Changeset 10708

Timestamp:

03/04/2009 10:28:45 PM (16 years ago)

Author:

ryan

Message:

Fix calendar widget when there are no posts. Optimize query. Props Denis-de-Bernardy. fixes #6442

File:

• trunk/wp-includes/general-template.php (modified) (1 diff)

trunk/wp-includes/general-template.php

@@ -931 +931 @@
         $cache = array();
 
-    ob_start();
     // Quick check. If we have no posts at all, abort!
     if ( !$posts ) {
-        $gotsome = $wpdb->get_var("SELECT ID from $wpdb->posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1");
-        if ( !$gotsome )
+        $gotsome = $wpdb->get_var("SELECT 1 FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'publish' LIMIT 1");
+        if ( !$gotsome ) {
+            $cache[ $key ] = '';
+            wp_cache_set( 'get_calendar', $cache, 'calendar' );
             return;
-    }
-
+        }
+    }
+
+    ob_start();
     if ( isset($_GET['w']) )
         $w = ''.intval($_GET['w']);