Changeset 1000 for trunk/wp-blog-header.php

Timestamp:

03/25/2004 02:15:36 AM (21 years ago)

Author:

michelvaldrighi

Message:

back to localtime, also using :59 instead of :00 should be better and still make use of mysql's query cache

File:

• trunk/wp-blog-header.php (modified) (6 diffs)

trunk/wp-blog-header.php

@@ -117 +117 @@
 $add_hours = intval($time_difference);
 $add_minutes = intval(60 * ($time_difference - $add_hours));
-$wp_posts_post_date_field = "DATE_ADD(post_date, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)";
+$wp_posts_post_date_field = "post_date"; // "DATE_ADD(post_date, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)";
 
 // if a month is specified in the querystring, load that month
 if ($m != '') {
     $m = ''.intval($m);
-    $where .= " AND YEAR($wp_posts_post_date_field)=".substr($m,0,4);
+    $where .= ' AND YEAR(post_date)='.substr($m,0,4);
     if (strlen($m)>5)
-        $where .= " AND MONTH($wp_posts_post_date_field)=".substr($m,4,2);
+        $where .= ' AND MONTH(post_date)='.substr($m,4,2);
     if (strlen($m)>7)
-        $where .= " AND DAYOFMONTH($wp_posts_post_date_field)=".substr($m,6,2);
+        $where .= ' AND DAYOFMONTH(post_date)='.substr($m,6,2);
     if (strlen($m)>9)
-        $where .= " AND HOUR($wp_posts_post_date_field.)=".substr($m,8,2);
+        $where .= ' AND HOUR(post_date.)='.substr($m,8,2);
     if (strlen($m)>11)
-        $where .= " AND MINUTE($wp_posts_post_date_field)=".substr($m,10,2);
+        $where .= ' AND MINUTE(post_date)='.substr($m,10,2);
     if (strlen($m)>13)
-        $where .= " AND SECOND($wp_posts_post_date_field)=".substr($m,12,2);
+        $where .= ' AND SECOND(post_date)='.substr($m,12,2);
 
 }
@@ -138 +138 @@
 if ($year != '') {
     $year = '' . intval($year);
-    $where .= " AND YEAR($wp_posts_post_date_field)='$year'";
+    $where .= " AND YEAR(post_date)='$year'";
 }
 
 if ($monthnum != '') {
     $monthnum = '' . intval($monthnum);
-    $where .= " AND MONTH($wp_posts_post_date_field)='$monthnum'";
+    $where .= " AND MONTH(post_date)='$monthnum'";
 }
 
 if ($day != '') {
     $day = '' . intval($day);
-    $where .= " AND DAYOFMONTH($wp_posts_post_date_field)='$day'";
+    $where .= " AND DAYOFMONTH(post_date)='$day'";
 }
 
@@ -158 +158 @@
 if ($w != '') {
     $w = ''.intval($w);
-    $where .= " AND WEEK($wp_posts_post_date_field, 1)='$w'";
+    $where .= " AND WEEK(post_date, 1)='$w'";
 }
 
@@ -338 +338 @@
         $lastpostdate = mysql2date('U',$lastpostdate);
         $otherdate = date('Y-m-d H:i:s', ($lastpostdate - (($posts_per_page-1) * 86400)));
-        $where .= " AND $wp_posts_post_date_field > '$otherdate'";
+        $where .= " AND post_date > '$otherdate'";
     }
 }
@@ -357 +357 @@
         $startdate = date('Y-m-d H:i:s', ($lastpostdate - (($poststart -1) * 86400)));
         $otherdate = date('Y-m-d H:i:s', ($lastpostdate - (($postend -1) * 86400)));
-        $where .= " AND $wp_posts_post_date_field > '$otherdate' AND $wp_posts_post_date_field < '$startdate'";
+        $where .= " AND post_date > '$otherdate' AND post_date < '$startdate'";
     }
 } else {
@@ -388 +388 @@
 }
 
-$now = gmdate('Y-m-d H:i:00');
+$now = gmdate('Y-m-d H:i:59', time() + ($time_difference * 3600));
 
 if ($pagenow != 'post.php' && $pagenow != 'edit.php') {