Show users in each time zone

[kakduman]

Is your feature request related to a problem? Please describe.

My server is currently hosted with Eastern Time and uses that for all announcements. I'm curious to see whether a different time zone is more popular on the server and whether we should switch to it.

I would like to be able to..

I'd like to be able to see a map similar to the geolocation map but for time zones. I'm not sure how difficult this might be to implement, though. A map is obviously not necessary; I mainly want to see the number of unique users from each time zone.

[AuroraLS3]

Is the geolocation map somehow unfit for this purpose (to get the general idea anyway) - I would much rather avoid dealing with timezones in all ways possible https://www.youtube.com/watch?v=-5wpm-gesOY

[kakduman]

I never knew timezones could be so complicated! Unfortunately, I cannot use the geolocation map to determine the best timezone for my server since I'm mainly considering having the server time in Pacific or Central Time instead of Eastern Time, all three of which are primarily in the U.S.

A crude geographical map similar to the one here or here is what I'm looking for rather than something that incorporates Daylight Savings Time and calculates the user's time. A table which shows the time zones and makes an educated guess toward the unique players in each one would also be fine. The feature isn't too necessary and we can continue to use Eastern Time if necessary. I see how this could be near impossible to implement.

I'm not too experienced with coding, but it's possible that the GeoIP database includes a method to get the time zone of users based on this link. If those timezones could be compiled into a table that shows the number of each users in each time zone (or timezone offset based on the language the website uses), it'd be really helpful!

Thanks for all the help!

[AuroraLS3]

The website you linked states GeoIP2 Precision web services except Country contain TimeZones, but Plan is using the Country database

[kakduman]

I see, would you please consider implementing a second GeoIP database that does contain timezones?

[AuroraLS3]

Looks like GeoLite2 City database would also have timezone available. I'll take it to consideration.

[AuroraLS3]

TODO

• Look into Geolite 2 City database
  • Does it have countries? (Can it replace the existing database?)
  • Does migration need deleting Country database file?
  • Is the license the same?
• Gathering
  • Modify GeolocationCache to store more information queried from the geolite database (not just country names, but country name and timezone too)
  • Add a timezone field to plan_geolocations table
  • Add it to table creation query
  • Add a patch that adds it to existing tables
  • Make default value null
  • I guess store timezone inside GeoInfo objects
  • Modify GeoInfo queries to include the timezone
  • Modify player join listeners to save timezone as well
• Visualization
  • Add a group by query that counts users in each timezone
  • Add a json endpoint for timezones
  • Mockup a timezone grouping rendering, either graph or a table. A bar graph might be the most optimal (on the server and network pages)
  • Wire together the json endpoint and the rendering
  • Add timezone to playercontainer and its query
  • Add timezone to player json endpoint
  • Render timezone on the player page
  • Copy the geolocation filter and change logic so that it is a timezone filter so that users in each timezone can be queried on query page
  • Add a placeholder for player timezone
• Rename Data_gathering.Geolocations to Data_gathering.Geological_information in the config
  • Change in both configs
  • Rename path in DataGatheringSettings
  • Add a config patch that moves the node