From 64e2e072294563b7c834382c2de631687f235fe8 Mon Sep 17 00:00:00 2001
From: Frédéric Guillot <contact@fredericguillot.com>
Date: Mon, 24 Feb 2014 18:08:58 -0500
Subject: Improve timezone pull-request and settings page

---
 models/config.php | 6 ++++++
 models/schema.php | 5 +----
 2 files changed, 7 insertions(+), 4 deletions(-)

(limited to 'models')

diff --git a/models/config.php b/models/config.php
index f4d34986..a00d0b7e 100644
--- a/models/config.php
+++ b/models/config.php
@@ -9,6 +9,12 @@ class Config extends Base
 {
     const TABLE = 'config';
 
+    public function getTimezones()
+    {
+        $timezones = \timezone_identifiers_list();
+        return array_combine(array_values($timezones), $timezones);
+    }
+
     public function getLanguages()
     {
         $languages = array(
diff --git a/models/schema.php b/models/schema.php
index 3704aad1..66571bbe 100644
--- a/models/schema.php
+++ b/models/schema.php
@@ -4,10 +4,7 @@ namespace Schema;
 
 function version_4($pdo)
 {
-    $pdo->exec('ALTER TABLE config ADD column timezone TEXT');
-
-    //set default timezone to UTC
-    $pdo->exec('UPDATE config SET timezone = \'UTC\'');
+    $pdo->exec("ALTER TABLE config ADD column timezone TEXT DEFAULT 'UTC'");
 }
 
 function version_3($pdo)
-- 
cgit v1.2.3