fix the timezone in D7.0.5

244 posts

good news for all to set the time zone for D7.0.5 this one working:

1)open /inc/header.inc.php

after <? add:

date_default_timezone_set('Europe/Rome');

Change Europe/Rome with your timezone (you can find supported timzone here: http://www.php.net/manual/en/timezones.php )

2) Open /inc/classes/BxDolDb.php

locate (around line 87):

mysql_query("SET sql_mode = ''", $this->link);

below this row add:

$this->res("SET time_zone = '+1:00'");

Change +1:00 with your timezone...

Save and upload all....test.

I tested try this and seems It work...

This trick simple set timezone per connection, not per host, in this way u can change timezone without change server's time, in php and even in mysql!

Quote · 9 Mar 2011

houstonlivelyBosun

6808 posts

As long as all your members live in the same time zone, you'll be OK. Members in all 24 time zones will see what the time is in the time zone that you specify....which is OK for local sites.... global sites... not so good.

Boonex really needs to fix this, so all members can see the time in their own time zone. Members need to be able to select their time zone in account settings. It's a lot of coding to do this right.

My opinions expressed on this site, in no way represent those of Boonex or Boonex employees.

Quote · 9 Mar 2011

futnaAdvanced

244 posts

But what about "RTL" ?!!!