Daylight saving time

Mixed forum with code snippets, guides and styles
Forum rules
Everything in this forum is for everybody
But support only for Donators!
User avatar
Stoker
Site Admin
Site Admin
Posts: 3502
Joined: 12 May 2008, 21:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark

Daylight saving time

Post by Stoker » 30 Oct 2011, 20:42

In some countries Daylight saving time is used.
In the spring we need to adjust our clock 1 hour forward.
In the autumn we need to adjust it 1 hour backwards.

We can do this in ACP under the Board settings.
But this only affects guests and people that registeres after we have changed this setting.
All our users will still be 1 hour off.

We can fix this by running a sql query in phpmyadmin.

Run this to disable Daylight saving time:

Code: Select all

UPDATE phpbb_users SET user_dst = '0' WHERE user_dst = '1' ;
Run this to enableDaylight saving time:

Code: Select all

UPDATE phpbb_users SET user_dst = '1' WHERE user_dst = '0' ;
Board rules! No PM support
Sure, I can install the Mod for you ;)
Like the site? Then buy me a bear


User avatar
Blackwolf
BBCoder IV
BBCoder IV
Posts: 272
Joined: 04 Dec 2010, 10:36
BBCodes: 101
Favourite BBCode: Dropcap
Favourite MOD: mchat
Location: Melbourne Australia

Daylight saving time

Post by Blackwolf » 10 Feb 2013, 10:14

Thanks for this. Implemented.....just need to remember to do it twice a year.
Ultimate Edition, Ultimate Edition Oz, Oz Unity

“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”

User avatar
Stoker
Site Admin
Site Admin
Posts: 3502
Joined: 12 May 2008, 21:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark

Daylight saving time

Post by Stoker » 10 Feb 2013, 11:12

There is mod for this with acp control. Its on phpbb.com
Board rules! No PM support
Sure, I can install the Mod for you ;)
Like the site? Then buy me a bear