Changeset 1799 for trunk/wp-includes/functions.php

Timestamp:

10/14/2004 08:27:56 AM (20 years ago)

Author:

saxmatt

Message:

Fix for bug 137. Patch from kelson.

File:

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

trunk/wp-includes/functions.php

@@ -140 +140 @@
     }
     return $lastpostmodified;
+}
+
+function get_lastcommentmodified($timezone = 'server') {
+    global $tablecomments, $cache_lastcommentmodified, $pagenow, $wpdb;
+    $add_seconds_blog = get_settings('gmt_offset') * 3600;
+    $add_seconds_server = date('Z');
+    $now = current_time('mysql', 1);
+    if ( !isset($cache_lastcommentmodified[$timezone]) ) {
+        switch(strtolower($timezone)) {
+            case 'gmt':
+                $lastcommentmodified = $wpdb->get_var("SELECT comment_date_gmt FROM $tablecomments WHERE comment_date_gmt <= '$now' ORDER BY comment_date_gmt DESC LIMIT 1");
+                break;
+            case 'blog':
+                $lastcommentmodified = $wpdb->get_var("SELECT comment_date FROM $tablecomments WHERE comment_date_gmt <= '$now' ORDER BY comment_date_gmt DESC LIMIT 1");
+                break;
+            case 'server':
+                $lastcommentmodified = $wpdb->get_var("SELECT DATE_ADD(comment_date_gmt, INTERVAL '$add_seconds_server' SECOND) FROM $tablecomments WHERE comment_date_gmt <= '$now' ORDER BY comment_date_gmt DESC LIMIT 1");
+                break;
+        }
+        $cache_lastcommentmodified[$timezone] = $lastcommentmodified;
+    } else {
+        $lastcommentmodified = $cache_lastcommentmodified[$timezone];
+    }
+    return $lastcommentmodified;
 }