LAYOUT: last login and logout text where displayed incorrectly sometimes

[e-DoKo.git] / db.php

diff --git a/db.php b/db.php
index f5f6673cde706add1050d499f3e6a3bf08cc49e5..39ab45c5c3b563aec2f7cf7d6c336522ee1cee11 100644 (file)
--- a/db.php
+++ b/db.php
@@ -609,7 +609,7 @@ function DB_get_user_timezone($userid)
   if($r)
     return $r[0];
   else
-    return 0;
+    return "Europe/London";
 }
 
 function DB_insert_comment($comment,$playid,$userid)
@@ -723,7 +723,8 @@ function DB_get_hashes_by_session($session,$user)
   $result = mysql_query("SELECT Hand.hash FROM Hand".
                        " LEFT JOIN Game ON Game.id=Hand.game_id ".
                        " WHERE Game.session=".DB_quote_smart($session).
-                       " AND Hand.user_id=".DB_quote_smart($user));
+                       " AND Hand.user_id=".DB_quote_smart($user).
+                       " ORDER BY Game.create_date ASC");
   while($t = mysql_fetch_array($result,MYSQL_NUM))
     $r[] = $t[0];