change timezone for ALL members

[NeXuM]

I have just changed the default timezone of my forum. But i have 20,000 registered members. I would like to change the timezone for all of them

could anyone give me a SQL command to set the timezone of ALL my members to UTC +1h00

thanks a lot!

[BirdOPrey5]

UPDATE user SET `timezoneoffset` = 1
Be sure to use the prefix in front of 'user' if your forum uses prefixes.
ALWAYS Backup your table /database before making such a change.
This will change it for every member of your forum- don't you have members that are not in your timezone?

[Boofo]

Changing the forum timezone will not affect your members timezones. It only affects unregistered/not logged in users. There is nothing you need to do.

[NeXuM]

Changing the forum timezone will not affect your members timezones. It only affects unregistered/not logged in users. There is nothing you need to do.
I don't want to change the timezone only for unregistered/not logged in users. I also want to change it for all members registered on my forum

UPDATE user SET `timezoneoffset` = 1
where to i define the timezone ?

[Boofo]

If they are not all from the same timezone you are probably going to piss a bunch of them off.

[BirdOPrey5]

I don't want to change the timezone only for unregistered/not logged in users. I also want to change it for all members registered on my forum


where to i define the timezone ?

the timezoneoffset = 1 is 'defining' the offset as +1... if it was +8 it would be timezoneoffset = 8... for me, east coast usa, it's timezoneoffset = -5.

If they are not all from the same timezone you are probably going to piss a bunch of them off.

This... The timezone is supposed to be locally set by your users to their time... there should never be a reason to change this unless a large geographical area voted themselves into a new time zone.

[NeXuM]

hi again,

i have one more question

how can i enable the option "automatically switch to daylight saving time" for all users of the forum with a sql command ?

thanks!

[BirdOPrey5]

That's a tough one, I don't see any field for this in the database :(

[Boofo]

hi again,

i have one more question

how can i enable the option "automatically switch to daylight saving time" for all users of the forum with a sql command ?

thanks!

I'm not sure if this is what you are looking for or not. But if you do use it, make sure the backup the db first as I can not guarantee anything. Also, if you do try it. let me know if it does what you are wanting. The thread for this is at the following URL:

http://www.vbulletin.com/forum/showthread.php?197826-Updating-Options-en-masse&p=1197837&viewfull=1#post1197837

UPDATE user SET options=options + 128 WHERE NOT(options & 128)

[NeXuM]

On: UPDATE user SET options=options + 64 WHERE NOT(options & 64);
looks like what i need

but will it alter other options set by 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. ;)