1 (edited by ingram 2008-10-03 14:01)

Topic: Allowing DST by default

My forum members claim to say that they have time back by 1hr, i found out that it's due to DST. How to (mass-)fix that?

I added it to Feature requests because of requesting it as a feature or atleast default-tick.

2 (edited by Slavok 2008-10-06 07:24)

Re: Allowing DST by default

You can fix it via your SQL-console.

  • Make a dump of your DB.

  • SQL-statement will look like:
    UPDATE <DB_PREFIX>_users
    SET dst = 1
    WHERE id in (<list of id>)
    If you want to change dst setting for all users, execute this SQL without WHERE-statement

Re: Allowing DST by default

I have this problem too, I think it is because the server is in a different time zone to the users

Would it not make more sense to adjust the time according to the clock of the local PC with client side javascript - so Pun would output something like

Post_time=now()-1.23 hours

and the browser would display something relevant without all the users having to select a timezone at all.

It seems kind of poor to me that we force everyone to select a timezone but then still get it wrong for a couple of weeks every year because different countries switch DST on different days

Re: Allowing DST by default

Good idea.
But I'd better compare the server's time and user's local time (via JS) and would display a dialog to the user to confirm timezone settings update.
This will be a good extension for 1.3 :-)

Carpe diem