http://bbpress.org/forums/ bbPress support forums Tag: offset en Tue, 02 Dec 2008 22:01:10 +0000 http://bbpress.org/forums/topic/gmt-offset#post-15928 Fri, 02 May 2008 11:55:43 +0000 dangrey 15928@http://bbpress.org/forums/ <p>Hmmm, your fix caused a bit of breakage for me -- time zone is +1, but for some reason <em>two</em> hours were added to the time stamp, resulting in a "freshness" of -1 year! (i.e., the timestamp was now in the future.</p> <p>Setting my time offset in General Settings to zero results in the correct time (GMT+1) being shown (server is on UTC btw), but the freshness is still -1 year lol. </p> http://bbpress.org/forums/topic/gmt-offset#post-15926 Fri, 02 May 2008 11:13:52 +0000 dangrey 15926@http://bbpress.org/forums/ <p>"bb_current_time is in the functions file inside bb-includes directory. But you probably should touch that otherwise when you update bbpress, it will break again. :)"</p> <p>Tell me about it -- I've already hacked another core file which has to be re-tweaked every upgrade... </p> <p>BTW isn't this a bug really? </p> http://bbpress.org/forums/topic/gmt-offset#post-15922 Fri, 02 May 2008 00:42:54 +0000 scooter7978 15922@http://bbpress.org/forums/ <p>bb_current_time is in the functions file inside bb-includes directory. But you probably should touch that otherwise when you update bbpress, it will break again. :)</p> <p>The SQL I used was just an interval clause...i.e. if I was going to import my current forums I would use something like:</p> <p>SELECT ID, Body, DateCreated - interval '9 30' hour_minute FROM current_forum_whatever</p> <p>This takes the date field and drops 9.5 hours off, coincidentally, my time zone.</p> <p>You could probably adapt this to an 'update' statement to change what's already in your database, eg:</p> <p>UPDATE bb_topics SET DateCreated=(SELECT DateCreated - interval '9 30' hour_minute);</p> <p>I haven't tested it but it probably wouldn't be too far wrong. </p> http://bbpress.org/forums/topic/gmt-offset#post-15906 Thu, 01 May 2008 10:28:24 +0000 dangrey 15906@http://bbpress.org/forums/ <p>Where can I find the bb_current_time function?</p> <p>Also could you post the SQL statement you used to fix existing date fields in the db? Thanks. </p> http://bbpress.org/forums/topic/gmt-offset#post-15904 Thu, 01 May 2008 05:44:55 +0000 scooter7978 15904@http://bbpress.org/forums/ <p>On thinking about it a bit further, I went back to my SQL posts and kludged a statement which removes 9.5 hours from the various date fields that populate the bbpress database.</p> <p>On restoring everything back, it's ok now. </p> http://bbpress.org/forums/topic/gmt-offset#post-15903 Thu, 01 May 2008 05:01:28 +0000 scooter7978 15903@http://bbpress.org/forums/ <p>I've been playing with bbPress for a few days and noticed that when I started posting the time was set all wrong and the posts I imported were dated wrong (only ones from that day).</p> <p>Since I'm in South Australia (+9.5 GMT) I had set the gmt_offset option in the admin interface to 9.5 to accomodate my differences but it wouldn't set the post date/time to my timezone when posting.</p> <p>The only way around it was to modify the bb_current_time function and change this line:</p> <p>$d = gmdate('Y-m-d H:i:s');</p> <p>to this:</p> <p>$d = gmdate('Y-m-d H:i:s', time() + 3600*(bb_get_option('gmt_offset')+date("I")));</p> <p>So that it actually uses the GMT offset.</p> <p>Of course, doing this only means that current posts are displayed at the right time but previous ones are wrong because they're all set to the current time when posted and the system then adds 9.5hrs onto them when being read.</p> <p>I'm assuming either I've missed something in the config or the time option just isn't using the gmt_offset value from the db for anything.</p> <p>Can someone confirm or refute this please? I'd like to be able to change it back and do it the proper way if possible. </p>