MyBB Community Forums

Full Version: Time Issue
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
So when I setup my forum a few months ago I selected the wrong time. It has now been brought to my attention with Daylight Savings. I corrected the time in the admin console but it hasnt made a difference. I am assuming that only affects new accounts.

I currently have 230 users. How do I make the change for them rather than having them go into their profile to change it?
By the way we are all based in Virginia under one timezone.
Run this SQL query:

UPDATE mybb_users SET timezone='-5', dst='0'
Where do you run that? Sorry I am new and currently browsing from a phone.
Go into your host panel and open up phpmyadmin. Go to your database and click "Query" or something like that. Paste the above into the text box and submit.
Apologies for hijacking the thread, but does that override user preferences? Or is it just something that effects the board default? If it overrides prefrences, it would irritate the hell out of my members Big Grin And sorry if it's a stupid question.
It sets all the users to that setting.
Thanks Paul! I got it fixed. You are the man!