X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=db.php;h=39ab45c5c3b563aec2f7cf7d6c336522ee1cee11;hp=f5f6673cde706add1050d499f3e6a3bf08cc49e5;hb=9122cf59b57c7405a14b5a61238667b98dd58150;hpb=9732aef914603924915bde24684f322843ead085 diff --git a/db.php b/db.php index f5f6673..39ab45c 100644 --- 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];