function user_update_7002

Convert user time zones from time zone offsets to time zone names.

Related topics

File

modules/user/user.install, line 488

Code

function user_update_7002(&$sandbox) {
    $sandbox['#finished'] = 0;
    // Multi-part update.
    if (!isset($sandbox['user_from'])) {
        db_change_field('users', 'timezone', 'timezone', array(
            'type' => 'varchar',
            'length' => 32,
            'not null' => FALSE,
        ));
        $sandbox['user_from'] = 0;
        $sandbox['user_count'] = db_query("SELECT COUNT(uid) FROM {users}")->fetchField();
        $sandbox['user_not_migrated'] = 0;
    }
    else {
        $timezones = system_time_zones();
        // Update this many per page load.
        $count = 10000;
        $contributed_date_module = db_field_exists('users', 'timezone_name');
        $contributed_event_module = db_field_exists('users', 'timezone_id');
        $results = db_query_range("SELECT uid FROM {users} ORDER BY uid", $sandbox['user_from'], $count);
        foreach ($results as $account) {
            $timezone = NULL;
            // If the contributed Date module has created a users.timezone_name
            // column, use this data to set each user's time zone.
            if ($contributed_date_module) {
                $date_timezone = db_query("SELECT timezone_name FROM {users} WHERE uid = :uid", array(
                    ':uid' => $account->uid,
                ))
                    ->fetchField();
                if (isset($timezones[$date_timezone])) {
                    $timezone = $date_timezone;
                }
            }
            // If the contributed Event module has stored user time zone information
            // use that information to update the user accounts.
            if (!$timezone && $contributed_event_module) {
                try {
                    $event_timezone = db_query("SELECT t.name FROM {users} u LEFT JOIN {event_timezones} t ON u.timezone_id = t.timezone WHERE u.uid = :uid", array(
                        ':uid' => $account->uid,
                    ))
                        ->fetchField();
                    $event_timezone = str_replace(' ', '_', $event_timezone);
                    if (isset($timezones[$event_timezone])) {
                        $timezone = $event_timezone;
                    }
                } catch (PDOException $e) {
                    // Ignore error if event_timezones table does not exist or unexpected
                    // schema found.
                }
            }
            if ($timezone) {
                db_update('users')->fields(array(
                    'timezone' => $timezone,
                ))
                    ->condition('uid', $account->uid)
                    ->execute();
            }
            else {
                $sandbox['user_not_migrated']++;
                db_update('users')->fields(array(
                    'timezone' => NULL,
                ))
                    ->condition('uid', $account->uid)
                    ->execute();
            }
            $sandbox['user_from']++;
        }
        $sandbox['#finished'] = $sandbox['user_from'] / $sandbox['user_count'];
        if ($sandbox['user_from'] == $sandbox['user_count']) {
            if ($sandbox['user_not_migrated'] > 0) {
                variable_set('empty_timezone_message', 1);
                drupal_set_message(format_string('Some user time zones have been emptied and need to be set to the correct values. Use the new <a href="@config-url">time zone options</a> to choose whether to remind users at login to set the correct time zone.', array(
                    '@config-url' => url('admin/config/regional/settings'),
                )), 'warning');
            }
            return t('Migrated user time zones');
        }
    }
}