change timezone for ALL members

[Boofo]

Shouldn't touch anything else. I have run it in the past but never checked to see if it did what I was hoping for. Please let me know your results.

[NeXuM]

Looks like it worked ! thanks !

[Boofo]

First, what changed? And second, what is the "DST Currently On/Off" setting for the user in the Admin CP profile. Did that change with the query?

[NeXuM]

yes, all of my users seem to have "DST Auto-Correct" ON, and when they connect the DST goes on since we are currently in the DST period

[Boofo]

DST Auto Correct is always like that. You need to look at the "Is DST currently in effect" setting in the Admin CP user's profile (under Time Options) to see the setting I am referring to.

[NeXuM]

DST Auto Correct is always like that. You need to look at the "Is DST currently in effect" setting in the Admin CP user's profile (under Time Options) to see the setting I am referring to.

My problem was that "DST auto correct" was disabled for all members (i modified the register page and took it out by error) so with the SQL command i posted earlier it switched it back on for all members. And the other option about DST currently in effect switched ON after the modification since we are currently in DST period

[Boofo]

Ok, you lost me there. The "DST currently in effect" is off on my site with new registrations. At least in the Admin CP, as that option is not available to users when they register. Or maybe I'm not understanding what is going on. I know that if I register someone through the Admin CP, I have to turn the currently in effect to ON, as it is OFF by default, no matter what the DST is at the time. Did the query I gave you set that to ON for all users? I ran it but it never changed the default in the Admin CP user profile if I made a new user. It confuses the hell out of me.