Use UTC now() instead of regular now(). We are global, baby!

diff --git a/xonstat/views/main.py b/xonstat/views/main.py
index 3e353b35195c4cf4514b200a7f5e49f901779712..22b12918eeeae7df0baa3fbc31978eb54e779a14 100755 (executable)
--- a/xonstat/views/main.py
+++ b/xonstat/views/main.py
@@ -24,7 +24,7 @@ def main_index(request):
             filter(Player.player_id == PlayerGameStat.player_id).\
             filter(Player.player_id > 2).\
             filter(PlayerGameStat.create_dt > 
-                    (datetime.now() - timedelta(days=leaderboard_lifetime))).\
+                    (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\
             order_by(expr.desc(func.sum(PlayerGameStat.alivetime))).\
             group_by(Player.nick).\
             group_by(Player.player_id).all()[0:10]
@@ -40,7 +40,7 @@ def main_index(request):
             func.count()).\
             filter(Game.server_id==Server.server_id).\
             filter(Game.create_dt > 
-                (datetime.now() - timedelta(days=leaderboard_lifetime))).\
+                (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\
             order_by(expr.desc(func.count(Game.game_id))).\
             group_by(Server.server_id).\
             group_by(Server.name).all()[0:10]
@@ -53,7 +53,7 @@ def main_index(request):
             func.count()).\
             filter(Map.map_id==Game.map_id).\
             filter(Game.create_dt > 
-                (datetime.now() - timedelta(days=leaderboard_lifetime))).\
+                (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\
             order_by(expr.desc(func.count())).\
             group_by(Game.map_id).\
             group_by(Map.name).all()[0:10]

diff --git a/xonstat/views/server.py b/xonstat/views/server.py
index e9b4ce5795042a341683d266ac275c12faca516e..8e4a7c6d976f8c536bca8a4f80dc7b0b4d966b79 100755 (executable)
--- a/xonstat/views/server.py
+++ b/xonstat/views/server.py
@@ -57,7 +57,7 @@ def server_info(request):
                 filter(Map.map_id==Game.map_id).\\r
                 filter(Game.server_id==server.server_id).\\r
                 filter(Game.create_dt > \r
-                    (datetime.now() - timedelta(days=leaderboard_lifetime))).\\r
+                    (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\\r
                 order_by(expr.desc(func.count())).\\r
                 group_by(Game.map_id).\\r
                 group_by(Map.name).all()[0:10]\r
@@ -73,7 +73,7 @@ def server_info(request):
                 filter(Game.server_id == server.server_id).\\r
                 filter(Player.player_id > 2).\\r
                 filter(PlayerGameStat.create_dt > \r
-                        (datetime.now() - timedelta(days=leaderboard_lifetime))).\\r
+                        (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\\r
                 order_by(expr.desc(func.sum(PlayerGameStat.score))).\\r
                 group_by(Player.nick).\\r
                 group_by(Player.player_id).all()[0:10]\r
@@ -92,7 +92,7 @@ def server_info(request):
                 filter(Game.server_id == server.server_id).\\r
                 filter(Player.player_id > 2).\\r
                 filter(PlayerGameStat.create_dt > \r
-                        (datetime.now() - timedelta(days=leaderboard_lifetime))).\\r
+                        (datetime.utcnow() - timedelta(days=leaderboard_lifetime))).\\r
                 order_by(expr.desc(func.sum(PlayerGameStat.alivetime))).\\r
                 group_by(Player.nick).\\r
                 group_by(Player.player_id).all()[0:10]\r

diff --git a/xonstat/views/submission.py b/xonstat/views/submission.py
index 96bd85e3ec41e8427d58ad3058b8534ab73d4239..031955a8e31a7584200efe3e03e1548930a28a40 100755 (executable)
--- a/xonstat/views/submission.py
+++ b/xonstat/views/submission.py
@@ -280,7 +280,7 @@ def create_player_game_stat(session=None, player=None,
     seq = Sequence('player_game_stats_player_game_stat_id_seq')\r
     pgstat_id = session.execute(seq)\r
     pgstat = PlayerGameStat(player_game_stat_id=pgstat_id, \r
-            create_dt=datetime.datetime.now())\r
+            create_dt=datetime.datetime.utcnow())\r
 \r
     # set player id from player record\r
     pgstat.player_id = player.player_id\r