Set default time offset for all users using MYSQL command

[vidan]

As seen on topic, anybody knows the command?

I want to set gmt+4
to ALL USERS.
not new registration, please help

[silverstorm]

running this query will set gmt+4 for ALL EXISTING USERS:

UPDATE user SET timezoneoffset=4;

note: you can set a default timezone in vb options for NEW USERS by
vBulletin Option->Date and Time option->Default Time Zone Offset