View Full Version : Search by time zone
Ironduke
12-18-2008, 08:33 AM
Is there any way to perform a search by the time zone the user has selected?
vbplusme
12-18-2008, 10:00 AM
Probably have to go to the database to get it. The registration logs the time zone offset but you can figure out what timezone they are in from that ... An SQL query in phpmyadmin would look like:
SELECT `username`, `timezoneoffset` FROM `user` WHERE `timezoneoffset`='-12'
will get you all the users that have registered from Kwajelien timezone (mostly badboy spammers these days)
You could leave off the where clause and it would dump out all your members and the timezoneoffset they used to register.
You can get the actual time zones listing from timeanddate (http://www.timeanddate.com/library/abbreviations/timezones/)
HTH
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.