Co-ordinating Timezones

Pat M, known as 7Leven, is an intern at a company called ThoughtSTEM LLC in California. ThoughtSTEM is a company that for a while taught kids to program in the San Francisco area. They would use innovative and fun methods to teach the kids like helping them Mod in Minecraft. Currently, they are developing a video game by the name of CodeSpells. In the game the user, a wizard, uses code to make all their spells.

Pat helps run the forums, run contests for the forum users, and relays information to and from the users. There is also a monthly update where the users can talk to the developers over a live streaming service. 

There are many users from many different locations around the US and other countries. So keeping up with the time zones is difficult. As a result, he made an application with LiveCode that always has the correct timezone that correlates to the developers location. This application also counts down to the the time for the update livestream the application and opens the livestream in the user's default browser. 

The app connects to a MySQL database and gets the time of the update each month from that database. Pat created a second application that updates the database to which the users' applications connect.