{"id":452,"date":"2008-07-04T04:17:44","date_gmt":"2008-07-04T11:17:44","guid":{"rendered":"http:\/\/www.alephnaught.com\/Blog\/?p=452"},"modified":"2008-07-04T04:25:29","modified_gmt":"2008-07-04T11:25:29","slug":"patch-for-twitter-tools-plugins-timezone-problem","status":"publish","type":"post","link":"https:\/\/www.alephnaught.com\/Blog\/2008\/07\/04\/patch-for-twitter-tools-plugins-timezone-problem\/","title":{"rendered":"Patch for Twitter Tools plugin’s timezone problem"},"content":{"rendered":"
\n

Since I got an extra day off from work yesterday, I had some time to spend on solving a problem. I use Twitter Tools to display my five most recent tweets on my blog, as well as creating a digest post of my tweets every day, and a notification tweet of new posts to my blog. Its a really nice plugin and a good piece of work. But, it has a bug – Twitter returns tweets in UTC time, while some of the key comparisons inside Twitter Tools uses local time. This affected the digest posts; some tweets would appear on the wrong day.<\/p>\n

It was hard to find all the comparison items and get them converted to UTC time, so I decided to convert the tweet time to local time using the setting in the WordPress application. I’ve posted this patch to the WordPress support forum at http:\/\/wordpress.org\/support\/topic\/127916?replies=4#post-796201<\/a>. Here’s the patch as well (this patch only applies to the 1.2b1 version):<\/p>\n

*** twitter-tools.php.0\tSun Apr 13 20:07:12 2008\r\n--- twitter-tools.php\tThu Jul  3 13:06:44 2008\r\n***************\r\n*** 401,406 ****\r\n--- 401,409 ----\r\n\r\n  \tfunction add() {\r\n  \t\tglobal $wpdb, $aktt;\r\n+ \t\t\/\/ RLH: The next line corrects Twitter's UTC to WordPress timezone setting\r\n+ \t\t$this->tw_created_at = $this->tw_created_at + (get_option('gmt_offset') * 3600);\r\n+ \t\t\/\/ RLH: End changes\r\n   \t\t$wpdb->query(\"\r\n  \t\t\tINSERT\r\n  \t\t\tINTO $wpdb->aktt\r\n***************\r\n*** 1353,1358 ****\r\n--- 1356,1364 ----\r\n  {\r\n\r\n  \t$now = time();\r\n+ \t\/\/ RLH: Must shift \"now\" back to proper timezone to match WordPress\r\n+ \t$now = $now +  + (get_option('gmt_offset') * 3600);\r\n+ \t\/\/ RLH: End changes\r\n\r\n  \t$time = gmmktime(\r\n  \t\tsubstr($date, 11, 2)<\/span><\/pre>\n
I hope that helps make this plugin more effective.  Perhaps the author could eventually fix all the comparisons and we could go back to using UTC for everything, as I think that’s the right answer.  But, this works for now.<\/span><\/p>\n<\/div>\n
\n
\nTranslate<\/span><\/a>\"\"\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Since I got an extra day off from work yesterday, I had some time to spend on solving a problem. I use Twitter Tools to display my five most recent tweets on my blog, as well as creating a digest post of my tweets every day, and a notification tweet of new posts to my […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4],"tags":[207,142],"class_list":["post-452","post","type-post","status-publish","format-standard","hentry","category-computer","tag-twitter-tools","tag-wordpress"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t