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

Timestamp:

02/28/2004 05:51:41 PM (21 years ago)

Author:

michelvaldrighi

Message:

added a timezone argument to get�_lastpost*()

File:

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

trunk/wp-includes/functions.php

@@ -96 +96 @@
 }
 
-function get_lastpostdate() {
+function get_lastpostdate($timezone = 'server') {
     global $tableposts, $cache_lastpostdate, $use_cache, $pagenow, $wpdb;
-    if ((!isset($cache_lastpostdate)) OR (!$use_cache)) {
-        $now = gmdate('Y-m-d H:i:s');
-        $lastpostdate = $wpdb->get_var("SELECT post_date FROM $tableposts WHERE post_date <= '$now' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1");
-        $cache_lastpostdate = $lastpostdate;
-    } else {
-        $lastpostdate = $cache_lastpostdate;
+    $add_seconds_blog = get_settings('gmt_offset') * 3600;
+    $add_seconds_server = date('Z');
+    $now = gmdate('Y-m-d H:i:s');
+    if ((!isset($cache_lastpostdate[$timezone])) OR (!$use_cache)) {
+        switch(strtolower($timezone)) {
+            case 'gmt':
+                $lastpostdate = $wpdb->get_var("SELECT post_date FROM $tableposts WHERE post_date <= '$now' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1");
+                break;
+            case 'blog':
+                $lastpostdate = $wpdb->get_var("SELECT DATE_ADD(post_date, INTERVAL '$add_seconds_blog' SECOND) FROM $tableposts WHERE post_date <= '$now' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1");
+                break;
+            case 'server':
+                $lastpostdate = $wpdb->get_var("SELECT DATE_ADD(post_date, INTERVAL '$add_seconds_server' SECOND) FROM $tableposts WHERE post_date <= '$now' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1");
+                break;
+        }
+        $cache_lastpostdate[$timezone] = $lastpostdate;
+    } else {
+        $lastpostdate = $cache_lastpostdate[$timezone];
     }
     return $lastpostdate;
 }
 
-function get_lastpostmodified() {
+function get_lastpostmodified($timezone = 'server') {
     global $tableposts, $cache_lastpostmodified, $use_cache, $pagenow, $wpdb;
-    if ((!isset($cache_lastpostmodified)) OR (!$use_cache)) {
-        $now = gmdate('Y-m-d H:i:s');
-        $lastpostmodified = $wpdb->get_var("SELECT post_modified FROM $tableposts WHERE post_modified <= '$now' AND post_status = 'publish' ORDER BY post_modified DESC LIMIT 1");
-        $cache_lastpostmodified = $lastpostmodified;
-    } else {
-        $lastpostmodified = $cache_lastpostmodified;
+    $add_seconds_blog = get_settings('gmt_offset') * 3600;
+    $add_seconds_server = date('Z');
+    $now = gmdate('Y-m-d H:i:s');
+    if ((!isset($cache_lastpostmodified[$timezone])) OR (!$use_cache)) {
+        switch($timezone) {
+            case 'gmt':
+                $lastpostmodified = $wpdb->get_var("SELECT post_modified FROM $tableposts WHERE post_modified <= '$now' AND post_status = 'publish' ORDER BY post_modified DESC LIMIT 1");
+                break;
+            case 'blog':
+                $lastpostmodified = $wpdb->get_var("SELECT DATE_ADD(post_modified, INTERVAL '$add_seconds_blog' SECOND) FROM $tableposts WHERE post_modified <= '$now' AND post_status = 'publish' ORDER BY post_modified DESC LIMIT 1");
+                break;
+            case 'server':
+                $lastpostmodified = $wpdb->get_var("SELECT DATE_ADD(post_modified, INTERVAL '$add_seconds_server' SECOND) FROM $tableposts WHERE post_modified <= '$now' AND post_status = 'publish' ORDER BY post_modified DESC LIMIT 1");
+                break;
+        }
+        $lastpostdate = get_lastpostdate($timezone);
+        if ($lastpostdate > $lastpostmodified) {
+            $lastpostmodified = $lastpostdate;
+        }
+        $cache_lastpostmodified[$timezone] = $lastpostmodified;
+    } else {
+        $lastpostmodified = $cache_lastpostmodified[$timezone];
     }
     return $lastpostmodified;