Changeset 6610

Timestamp:

01/14/2008 05:59:39 AM (17 years ago)

Author:

ryan

Message:

Eliminate comment_date_gmt <= now from get_lastcommentmodified() queries. fixes #5650

File:

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

trunk/wp-includes/comment.php

@@ -200 +200 @@
 function get_lastcommentmodified($timezone = 'server') {
     global $cache_lastcommentmodified, $wpdb;
+
+    if ( isset($cache_lastcommentmodified[$timezone]) )
+        return $cache_lastcommentmodified[$timezone];
+
     $add_seconds_server = date('Z');
-    $now = current_time('mysql', 1);
-    if ( !isset($cache_lastcommentmodified[$timezone]) ) {
-        switch ( strtolower($timezone)) {
-            case 'gmt':
-                $lastcommentmodified = $wpdb->get_var($wpdb->prepare("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_date_gmt <= %s AND comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1", $now));
-                break;
-            case 'blog':
-                $lastcommentmodified = $wpdb->get_var($wpdb->prepare("SELECT comment_date FROM $wpdb->comments WHERE comment_date_gmt <= %s AND comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1", $now));
-                break;
-            case 'server':
-                $lastcommentmodified = $wpdb->get_var($wpdb->prepare("SELECT DATE_ADD(comment_date_gmt, INTERVAL %s SECOND) FROM $wpdb->comments WHERE comment_date_gmt <= %s AND comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1", $add_seconds_server, $now));
-                break;
-        }
-        $cache_lastcommentmodified[$timezone] = $lastcommentmodified;
-    } else {
-        $lastcommentmodified = $cache_lastcommentmodified[$timezone];
-    }
+
+    switch ( strtolower($timezone)) {
+        case 'gmt':
+            $lastcommentmodified = $wpdb->get_var("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1");
+            break;
+        case 'blog':
+            $lastcommentmodified = $wpdb->get_var("SELECT comment_date FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1");
+            break;
+        case 'server':
+            $lastcommentmodified = $wpdb->get_var($wpdb->prepare("SELECT DATE_ADD(comment_date_gmt, INTERVAL %s SECOND) FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1", $add_seconds_server));
+            break;
+    }
+
+    $cache_lastcommentmodified[$timezone] = $lastcommentmodified;
+
     return $lastcommentmodified;
 }