of course I do.Do you have access to phpMyAdmin?
Timezone and gender is stored in the xf_user table so a couple of SQL queries should sort that.
It could be an issue with the importer.But why won't XF keep the original timezone of user's profile when it imports from VB? Isn't that a bug?
So i set my board timezone to EST (GMT-5) and then import VB data. When I look at each user's info, their timezone is still set at Dublin which is default for Xenforo.
How do I mass change them.
Since my users are majority male, how do I mass change them to male?
UPDATE xf_user
SET gender = 'male'
UPDATE xf_user
SET timezone = 'America/New_York'
Q
Query for time zone:
Code:UPDATE xf_user SET timezone = 'America/New_York'
I tested these queries and they work.
UPDATE xf_user
SET timezone = 'Europe/Paris'
UPDATE xf_user
SET timezone = 'Europe/Berlin'
<select name="timezone" class="textCtrl" id="ctrl_timezone">
<option value="Pacific/Midway" >(UTC-11:00) American Samoa</option>
<option value="Pacific/Apia" >(UTC-11:00) Apia, Samoa</option>
<option value="Pacific/Honolulu" >(UTC-10:00) Hawaii</option>
<option value="Pacific/Marquesas" >(UTC-09:30) Marquesas Islands</option>
<option value="America/Anchorage" >(UTC-09:00) Alaska</option>
<option value="America/Los_Angeles" selected="selected">(UTC-08:00) Pacific Time (US & Canada)</option>
<option value="America/Santa_Isabel" >(UTC-08:00) Baja California</option>
<option value="America/Tijuana" >(UTC-08:00) Tijuana</option>
<option value="America/Denver" >(UTC-07:00) Mountain Time (US & Canada)</option>
<option value="America/Chihuahua" >(UTC-07:00) Chihuahua, La Paz, Mazatlan</option>
<option value="America/Phoenix" >(UTC-07:00) Arizona</option>
<option value="America/Chicago" >(UTC-06:00) Central Time (US & Canada)</option>
<option value="America/Belize" >(UTC-06:00) Saskatchewan, Central America</option>
<option value="America/Mexico_City" >(UTC-06:00) Guadalajara, Mexico City, Monterrey</option>
<option value="Pacific/Easter" >(UTC-06:00) Easter Island</option>
<option value="America/New_York" >(UTC-05:00) Eastern Time (US & Canada)</option>
<option value="America/Havana" >(UTC-05:00) Cuba</option>
<option value="America/Bogota" >(UTC-05:00) Bogota, Lima, Quito</option>
<option value="America/Caracas" >(UTC-04:30) Caracas</option>
<option value="America/Halifax" >(UTC-04:00) Atlantic Time (Canada)</option>
<option value="America/Goose_Bay" >(UTC-04:00) Atlantic Time (Goose Bay)</option>
<option value="America/Asuncion" >(UTC-04:00) Asuncion</option>
<option value="America/Santiago" >(UTC-04:00) Santiago</option>
<option value="America/Cuiaba" >(UTC-04:00) Cuiaba</option>
<option value="America/La_Paz" >(UTC-04:00) Georgetown, La Paz, Manaus, San Juan</option>
<option value="Atlantic/Stanley" >(UTC-04:00) Falkland Islands</option>
<option value="America/St_Johns" >(UTC-03:30) Newfoundland</option>
<option value="America/Argentina/Buenos_Aires" >(UTC-03:00) Buenos Aires</option>
<option value="America/Argentina/San_Luis" >(UTC-03:00) San Luis</option>
<option value="America/Argentina/Mendoza" >(UTC-03:00) Argentina, Cayenne, Fortaleza</option>
<option value="America/Godthab" >(UTC-03:00) Greenland</option>
<option value="America/Montevideo" >(UTC-03:00) Montevideo</option>
<option value="America/Sao_Paulo" >(UTC-03:00) Brasilia</option>
<option value="America/Miquelon" >(UTC-03:00) Saint Pierre and Miquelon</option>
<option value="America/Noronha" >(UTC-02:00) Mid-Atlantic</option>
<option value="Atlantic/Cape_Verde" >(UTC-01:00) Cape Verde Is.</option>
<option value="Atlantic/Azores" >(UTC-01:00) Azores</option>
<option value="Europe/London" >(UTC) Dublin, Edinburgh, Lisbon, London</option>
<option value="Africa/Casablanca" >(UTC) Casablanca</option>
<option value="Atlantic/Reykjavik" >(UTC) Monrovia, Reykjavik</option>
<option value="Europe/Amsterdam" >(UTC+01:00) Central European Time</option>
<option value="Africa/Algiers" >(UTC+01:00) West Central Africa</option>
<option value="Africa/Windhoek" >(UTC+01:00) Windhoek</option>
<option value="Africa/Tunis" >(UTC+01:00) Tunis</option>
<option value="Europe/Athens" >(UTC+02:00) Eastern European Time</option>
<option value="Africa/Johannesburg" >(UTC+02:00) South Africa Standard Time</option>
<option value="Asia/Amman" >(UTC+02:00) Amman</option>
<option value="Asia/Beirut" >(UTC+02:00) Beirut</option>
<option value="Africa/Cairo" >(UTC+02:00) Cairo</option>
<option value="Asia/Jerusalem" >(UTC+02:00) Jerusalem</option>
<option value="Europe/Minsk" >(UTC+02:00) Minsk</option>
<option value="Asia/Gaza" >(UTC+02:00) Gaza</option>
<option value="Asia/Damascus" >(UTC+02:00) Syria</option>
<option value="Africa/Nairobi" >(UTC+03:00) Nairobi, Baghdad, Kuwait, Qatar, Riyadh</option>
<option value="Europe/Kaliningrad" >(UTC+03:00) Kaliningrad</option>
<option value="Asia/Tehran" >(UTC+03:30) Tehran</option>
<option value="Europe/Moscow" >(UTC+04:00) Moscow, St. Petersburg, Volgograd</option>
<option value="Asia/Dubai" >(UTC+04:00) Abu Dhabi, Muscat, Tbilisi</option>
<option value="Asia/Yerevan" >(UTC+04:00) Yerevan</option>
<option value="Asia/Baku" >(UTC+04:00) Baku</option>
<option value="Indian/Mauritius" >(UTC+04:00) Mauritius</option>
<option value="Asia/Kabul" >(UTC+04:30) Kabul</option>
<option value="Asia/Tashkent" >(UTC+05:00) Tashkent, Karachi</option>
<option value="Asia/Kolkata" >(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi</option>
<option value="Asia/Kathmandu" >(UTC+05:45) Kathmandu</option>
<option value="Asia/Dhaka" >(UTC+06:00) Astana, Dhaka</option>
<option value="Asia/Yekaterinburg" >(UTC+06:00) Ekaterinburg</option>
<option value="Asia/Almaty" >(UTC+06:00) Almaty, Bishkek, Qyzylorda</option>
<option value="Asia/Rangoon" >(UTC+06:30) Yangon (Rangoon)</option>
<option value="Asia/Bangkok" >(UTC+07:00) Bangkok, Hanoi, Jakarta</option>
<option value="Asia/Novosibirsk" >(UTC+07:00) Novosibirsk</option>
<option value="Asia/Hong_Kong" >(UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi</option>
<option value="Asia/Krasnoyarsk" >(UTC+08:00) Krasnoyarsk</option>
<option value="Asia/Singapore" >(UTC+08:00) Kuala Lumpur, Singapore</option>
<option value="Australia/Perth" >(UTC+08:00) Perth</option>
<option value="Asia/Irkutsk" >(UTC+09:00) Irkutsk</option>
<option value="Asia/Tokyo" >(UTC+09:00) Osaka, Sapporo, Tokyo</option>
<option value="Asia/Seoul" >(UTC+09:00) Seoul</option>
<option value="Australia/Adelaide" >(UTC+09:30) Adelaide</option>
<option value="Australia/Darwin" >(UTC+09:30) Darwin</option>
<option value="Australia/Brisbane" >(UTC+10:00) Brisbane, Guam</option>
<option value="Australia/Sydney" >(UTC+10:00) Sydney, Melbourne, Hobart</option>
<option value="Asia/Yakutsk" >(UTC+10:00) Yakutsk</option>
<option value="Pacific/Noumea" >(UTC+11:00) Solomon Is., New Caledonia</option>
<option value="Asia/Vladivostok" >(UTC+11:00) Vladivostok</option>
<option value="Pacific/Norfolk" >(UTC+11:30) Norfolk Island</option>
<option value="Asia/Anadyr" >(UTC+12:00) Anadyr, Kamchatka</option>
<option value="Pacific/Auckland" >(UTC+12:00) Auckland, Wellington</option>
<option value="Pacific/Fiji" >(UTC+12:00) Fiji</option>
<option value="Asia/Magadan" >(UTC+12:00) Magadan</option>
<option value="Pacific/Chatham" >(UTC+12:45) Chatham Islands</option>
<option value="Pacific/Tongatapu" >(UTC+13:00) Nuku'alofa</option>
<option value="Pacific/Kiritimati" >(UTC+14:00) Kiritimati</option>
</select>
We use essential cookies to make this site work, and optional cookies to enhance your experience.