change timezone for ALL members
 

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!

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?

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

where to i define the timezone ?

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

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.

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.

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!

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

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/showt...=1#post1197837

looks like what i need

but will it alter other options set by members ?