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!
Post Reply
User avatar
Stoker
Site Admin
Site Admin
Posts: 3536
Joined: 12 May 2008, 23:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark
Contact:

Daylight saving time

Post by Stoker »

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
User avatar
Blackwolf
BBCoder IV
BBCoder IV
Posts: 272
Joined: 04 Dec 2010, 12:36
BBCodes: 101
Favourite BBCode: Dropcap
Favourite MOD: mchat
Location: Melbourne Australia

Daylight saving time

Post by Blackwolf »

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: 3536
Joined: 12 May 2008, 23:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark
Contact:

Daylight saving time

Post by Stoker »

There is mod for this with acp control. Its on phpbb.com
Board rules! No PM support
Post Reply