Location of "Time zone prompt" field in database

[hadoob024]

We had an issue where the "Time zone prompt" field got checked for all our users. This causes our system to crash. Where in the database is this field located so that I can update this value for all our users at once? I just had to manually update this setting for 100+ users because I couldn't figure out how to run an UPDATE script on our db because I can't find that field. Thanks in advance!

[kuske]

Just check the code of modules/Users/SetTimezone.php...

[hadoob024]

I'm looking at it now, but still can't see where that information is collected and stored.

[kuske]

Ok, did you see the setPreferences function?
That's exactly the functionality you need.
All these functions can bee found in modules/UserPrefences/UserPrefences.php.

The data is stored in an encoded field of the userprefences database table

[hadoob024]

Got it. Thanks. So basically, I need to create a new script that basically calls the setPreference() function.

Quick follow-up. Do you know what the value for $name would be? Is this the field name? Is that different from the name of the setting/preference? If I use Firebug on the page where I'm editing a user, I can see that the name for "Time zone prompt" is "ut". Is that the value that I pass as $name?

[kuske]

$current_user->setPreference('timezone',$timezone) sets the timezone of the current user.
$current_user->setPreference('ut',1) promts the user on next login to enter his timezone.
$timezone values can be found in /include/language/en_us.lang.php

[hadoob024]

Perfect! Thanks!