Changeset 2777

Timestamp:

08/12/2005 07:03:13 AM (20 years ago)

Author:

matt

Message:

Fixes #1575

File:

• branches/1.5/wp-includes/comment-functions.php (modified) (2 diffs)

branches/1.5/wp-includes/comment-functions.php

@@ -356 +356 @@
 
 function get_lastcommentmodified($timezone = 'server') {
-    global $tablecomments, $cache_lastcommentmodified, $pagenow, $wpdb;
+    global $cache_lastcommentmodified, $pagenow, $wpdb;
     $add_seconds_blog = get_settings('gmt_offset') * 3600;
     $add_seconds_server = date('Z');
@@ -363 +363 @@
         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");
+                $lastcommentmodified = $wpdb->get_var("SELECT comment_date_gmt FROM $wpdb->comments 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");
+                $lastcommentmodified = $wpdb->get_var("SELECT comment_date FROM $wpdb->comments 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");
+                $lastcommentmodified = $wpdb->get_var("SELECT DATE_ADD(comment_date_gmt, INTERVAL '$add_seconds_server' SECOND) FROM $wpdb->comments WHERE comment_date_gmt <= '$now' ORDER BY comment_date_gmt DESC LIMIT 1");
                 break;
         }