Hi,

This can be a momentary solution for timezone:

Open /inc/header.inc.php

after <? add this line:

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

I'm trying it and seems it work...

Let me know

Hello!

Seems need to add something similar for MySQL because for queries using function NOW() may have another values.

Regard

Does not work for me.

Also LeonidS is correct. It will have no effect on any mysql queries using any mysql built in time and date functions.



To actually get dolphin to work correctly in various time zones, a option for timezone would need to be added to admin, and every date function throughout all the code in dolphin would need to be changed to adjust based on that setting, and all mysql queries will need to be rewritten.

It's a lot of work to add that feature.

Funny things is, alot of software already has this, but dolphin does not.

Nop, that dont work at all...

This is one of thing that i most talk on the forum last two month... Simply the Boonex team dont hear... And i think that many user of Dolphin script is not in the same country where is the server located, so this is one of the major mistake for Dolphin script, especialy like the Deano says: " Funny things is, alot of software already has this, but dolphin does not. " I dont see any sence from Boonex regarding this. And i promise, i will never mention this problem again since i am borring my self whith this question and regarding IP Black List in the admin part... No point any more, Boonex hear only what they like and that's how fix the thing's... Sad...

Hello avantguardia!

BoonEx team hears very well (http://www.boonex.com/trac/dolphin/ticket/600, http://www.boonex.com/trac/dolphin/ticket/1624), we know that it is important thing but as we explained many times - feature will require rewrtitting every query with time/date content. So it's deal only for 7.1 not for 7.0.

Regard

Actually as i think about this, this should be a per user option where the user selects the time zone they are in. So dolphin just stores everything as normal using the default date of the server, and when dates and times are displayed, they are displayed in the user prefered time zone.

Doing it that way will allow each member of the site regardless of where they are located to see the time and dates in there own time zone. This i believe is how it should be done.

Agre with you again...

I have to answer you LeonidS, no hard fillings please...

BoonEx team hears very well....

http://www.boonex.com/trac/dolphin/ticket/600 --- ticket opened 8 month ago... priority: MAJOR???

http://www.boonex.com/trac/dolphin/ticket/1624 --- ticket opened 1 week ago???... milestone changed from Dolphin 7.0 (Hookie) RC 4 to 7.1.???

Sorry LeonidS, this is very stupid for me, i dont in the programming language that much, but i do know some thing. If 8 month take to fix as you can see MAJOR problem... i dont have a word... I will equip every member of my site with calculator to calculate when they received message +9 hours...

Sorry again...

Regards.

I don't mean to jump on boonex's side on this one, but i do understand why this one was pushed to 7.1.

The date function alone is used in 187 dolphin source files appearing 1136 times. And that is just the php calls. This does not include any sql queries.

So the time involved in changing this is very extensive.

for people that have dedicated server:

http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html

This correct mysql timezone, always need the above change in php file!

good news for all...

I'm trying some trick and this work for all (dedicated + hosting)!

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 86):

$this->res("SET sql_mode = ''");

below this row add:

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

Change +1:00 with your timezone...

Save and upload all....test and let me know!

I haven't tested all but 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!

Let me know!

Dude you are officially my hero.  That worked like a treat! Thank you.

It worked for me!!!!!

Thanks a lot. I've been trying to fix this with my host for days. Yet, I did it myself in minutes.

Well done Thank you it works.

Thanks a lot luca!! Works perfect!!!

Ok, I'm lost. My server was set to the proper time zone but Dolphin always added an hour. (23:05 always shows as 00:05) I added your fix and it added another 5 hours. By changing it to -6:00 I was able to make the site show the correct time.

My question is why? Why doesn't Dolphin just reflect the time setup in the server as the default time? Why is it screwed up?

PS, my correct time zone is America/Denver (or mountain time)

No it doesnt work!!!

Error

Database query error

Fatal error: Call to a member function getParam() on a non-object in /home/***/***/inc/db.inc.php on line 83

It appeared to work, but I had a cron job report to say there was a non-object non-object in /inc/db.inc.php on line 83

I've since change my server time using WHM and also in mySql in select now(). Everything is correct... at least to MY timezone anyway. What's with Dolphin not originally opting for the user's timezone anyway? Yes, it'd be lots of work to correct all the instances now, but originally? Shame! Maybe in a future release.

Hi,

I am not a programmer, but surely if a member chooses their time zone on registration, with the default time zone being GMT, this can not be too difficult to write code for. All other major social networking software has this. By now you should be able to buy a module for this. So why doesn't someone design one for Boonex members?

I am in Australia so we are a day ahead of the USA.......frustrating!!!

Cheers

Because it can't be done with a module.

Adding timezone functions will require code rewrites to dolphin. Easy to do perhaps. But will require hours of work locating every location in dolphin where time is used to make changes. This of course will make upgrading dolphin a nightmare because the upgrade will destroy all of the code changes. So this is a feature that boonex themselves should do.

This i believe is a feature they have slated for version 7.1

THANKS ! ! ! !  WORK ! ! !

In addition to Luca's posts bove, you also need to change the timezone for the forums too, as this uses a different database connection.

For 7.0.2 do this...

edit

modules/boonex/forums/classes/Forum.php

Add to top of file...

date_default_timezone_set("Australia/Adelaide");

edit

modules/boonex/forums/classes/BxDB.php

find

mysql_query ("SET NAMES 'utf8'", $this->link);

add underneath

mysql_query ("SET time_z alt= '+9:30'", $this->link);

Now all posts made in forum will have correct timezone too.

/DM

Deano - the fix given by Luca actually works as it changes the timezone for SQL - no need to change all instances of now() - jut set time_zone for SQL connection once - when making the database connection. Fortunately Boonex use persistent database connections so it remains set.

To expand on this - all that needs to be added is one admin field - to set the default timezone, and a user selection in profile for users to set their timezone.

On my site I have added timezone selection automatically based on the users state - a field I already had available.

So in summary - no need to wait for Dolphin 7.1 - it's a relatively easy thing to add in - just a few lines of code - I say promote it back to 7.0.3 !!!!

/DM

I also get error messages in /inc/db.inc.php  on line 83 how to solve this problem?

 This not run for me :(

I need change the timedate for the Forum Pls

I need 7 Hours more :(

Could u Help me?

you need to go to VPS

agreed

this did not work for me hhmm

anyone else got anyother suggestions that may work

i get the database error like describbed above

I got the same problem:

Fatal error: Call to a member function getParam() on a non-object in /home/......./inc/db.inc.php on line 83

 Thank's a lot!  In 7.0.5. all is displaying correctly now. The Orca forums however did not change a bit ?!  Any ideas?

Regards,  Jarmo

In 7.0.5 on TDM Hosting this works fine!!!

VAI LUCA_IT!!!!!!!!!!!!!!!!

did somebody found any permanent solutionj for this including orca ? Im waiting for proper timezone setting in backend for a year and timezones tickets is always postponed from version to next version, I hope it gets fixed for real in 7.1 but as we have no info about 7.1 it can be done easily at end of a year as its massive update and I cant wait aniother year...

Here is my feedback on this trick!

I have two different dolphin community site, one based on 7.0.4 and one based on a fresh 7.0.5 version working on the SAME HOSTING PROVIDER better in the SAME SERVER (same s.o., same php configuration,same mysql)

So in 7.05. works like a charm (not tested yet forum), but on 7.0.4 message is DATABASE CONNECTION ERROR and nothing to do!

I finish this work, testing also forum connection, and give you guys my final feedback later

CUPIDO

UPDATE FINAL FEEDBACK!

After trying well on both versions, i can confirm that this trick about timezone is working properly on 7.0.4 and on 7.0.5 without problems.

By contrast, the connections to the forum does not work on both versions on the forum and the dates remain unchanged.

CUPIDO

Ciao Luca,

io ho Dolphin 7.0.6 e non riesco a trovare

$this->res("SET sql_mode = ''");

in

/inc/classes/BxDolDb.php

nei pressi della linea 86

For Dolphin 7.0.6

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 89):

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

below this row add:

mysql_query("SET time_zone = '+2:00'", $this->link);

So sorry. in my 7.0.5. Orca does NOT want to show the correct time.... it just keeps living 10 hours earlier than my users.....

Got it at last! This is a working scenario for this problem:

http://www.boonex.com/trac/dolphin/wiki/GenFAQ

And DO NOT forget to recompile languages after the change. It won't work otherwise....