1 Topic by mhozhabri (edited by mhozhabri 2013-10-21 16:07)

  • Registered: 2013-07-12
  • Posts: 30

Topic: (solved)please help (Daylight saving time (advance times by 1 hour).)

hello
i use pun bb 1.4.2
i ticked Daylight saving time (advance times by 1 hour). in settings. but now, i don't want use it. how can change this option (not checked) for all users?
because is not automatic and in summer must back 1 hour
my gmt is +3.5 and all users use this time zone
thanks for help

2 Reply by Trace

  • Trace
  • Trace
  • PunBB senior member
  • Offline
  • Registered: 2012-07-01
  • Posts: 560

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

Try make this query:

UPDATE `DATABASE_NAME`.`pun_config` SET `conf_value` = '0' WHERE `TABLEPREFIKS_config`.`conf_name` = 'o_default_dst';

But change DATABASE_NAME and TABLEPREFIKS to your values.

  • Registered: 2013-07-12
  • Posts: 30

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

how can run this code?
thanks very much

4 Reply by Trace

  • Trace
  • Trace
  • PunBB senior member
  • Offline
  • Registered: 2012-07-01
  • Posts: 560

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

In phpMyAdmin, if you use MySQL engine.

  • Registered: 2013-07-12
  • Posts: 30

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

hello
i can't run query
my host company say: this query is incorrect, table pun_config don't exist
but i tick this in settings. i want change dst for all user. thanks

6 Reply by Trace

  • Trace
  • Trace
  • PunBB senior member
  • Offline
  • Registered: 2012-07-01
  • Posts: 560

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

Replace "pun_" in above code with your table prefix.

  • Registered: 2013-07-12
  • Posts: 30

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

no, it's not work. i want change dst for all user

  • From: Ukraine
  • Registered: 2008-10-31
  • Posts: 762

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

Its bad idea changing DST for all users.

9 Reply by Trace

  • Trace
  • Trace
  • PunBB senior member
  • Offline
  • Registered: 2012-07-01
  • Posts: 560

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

It must work. Give me your database name and your table prefixes.

@dimkalinux
I agree. This also regards to forums which are targeted only for a specified country (e.x. France, Russia, Poland, Germany), because today there is a lot of emigrations.
It would be nice if someone (I won't say who I mean big_smile) create an extension which display a new page instead of forum when the administrator want it where user can confrim changing DST or cancel it. Do you mean what I wrote?

  • Registered: 2013-07-12
  • Posts: 30

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

dbname: tbcforum
table prefix:forum_
thanks very much

11 Reply by Trace

  • Trace
  • Trace
  • PunBB senior member
  • Offline
  • Registered: 2012-07-01
  • Posts: 560

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

UPDATE `tbcforum`.`forum_config` SET `conf_value` = '0' WHERE `forum_config`.`conf_name` = 'o_default_dst';
  • Registered: 2013-07-12
  • Posts: 30

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

hello
i run this but don't work for all user
please help

  • Registered: 2013-07-12
  • Posts: 30

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

hello
please answer
i can not change dst for all user att one time

14 Reply by keeshii (edited by keeshii 2013-10-20 21:54)

  • keeshii
  • Extension Developer
  • Offline
  • From: Poland
  • Registered: 2013-04-04
  • Posts: 170

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

I will try to write an extension for that. Just a little more patience smile

EDIT. ok, implemented:
http://punbb.informer.com/forums/topic/ … ezone-001/

After intallation all users from server's timezone will have activated the option "Use the timezone settings of the server". When you change the timezone/dst in administration panel, it will affect those users.

In my opinion this is the best solution, because not all users must shere the same timezone as you.

enjoy smile

If you want to contact me quickly - send e-mail, not PM.
<?php $t='<?php $t=%c%s%c; printf($t,39,$t,39,10);%c'; printf($t,39,$t,39,10);
  • Registered: 2013-07-12
  • Posts: 30

Re: (solved)please help (Daylight saving time (advance times by 1 hour).)

thanks very very much