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]

Originally Posted by 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.

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]

Originally Posted by NeXuM

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.

Originally Posted by Boofo

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]

Originally Posted by 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!

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

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 ?