Changeset 1004

Timestamp:

03/25/2004 02:45:32 AM (20 years ago)

Author:

michelvaldrighi

Message:

now storing emailed posts as localtime+gmt

File:

• trunk/wp-mail.php (modified) (2 diffs)

trunk/wp-mail.php

@@ -108 +108 @@
                 $ddate_U = mktime($ddate_H, $ddate_i, $ddate_s, $ddate_m, $ddate_d, $ddate_Y);
 
-                $post_date = gmdate('Y-m-d H:i:s', $ddate_U);
+                $post_date = gmdate('Y-m-d H:i:s', $ddate_U + ($time_difference * 3600));
+                $post_date_gmt = gmdate('Y-m-d H:i:s', $ddate_U);
             }
         }
@@ -227 +228 @@
                 $content = addslashes(trim($content));
                 if($flat > 500) {
-                    $sql = "INSERT INTO $tableposts (post_author, post_date, post_content, post_title, post_category) VALUES ($post_author, '$post_date', '$content', '$post_title', $post_category)";
+                    $sql = "INSERT INTO $tableposts (post_author, post_date, post_date_gmt, post_content, post_title, post_category) VALUES ($post_author, '$post_date', '$post_date_gmt', '$content', '$post_title', $post_category)";
                 } else {
-                    $sql = "INSERT INTO $tableposts (post_author, post_date, post_content, post_title, post_category, post_lat, post_lon) VALUES ($post_author, '$post_date', '$content', '$post_title', $post_category, $flat, $flon)";
+                    $sql = "INSERT INTO $tableposts (post_author, post_date, post_date_gmt, post_content, post_title, post_category, post_lat, post_lon) VALUES ($post_author, '$post_date', '$post_date_gmt', '$content', '$post_title', $post_category, $flat, $flon)";
                 }
                 $result = $wpdb->query($sql);