summaryrefslogtreecommitdiffstats
path: root/src/server/db.scm
diff options
context:
space:
mode:
authorThomas Hintz <t@thintz.com>2020-04-18 10:42:59 -0700
committerThomas Hintz <t@thintz.com>2020-04-18 10:42:59 -0700
commitb06d1b45136f73cb9ec616bb5f5f93f858e2f862 (patch)
tree71b1826a435a9be70aee8124d43fd724dbdcaef9 /src/server/db.scm
parentced8faf6f6d762b85121c01e1e4a26e2ceef85a3 (diff)
downloadfarm-b06d1b45136f73cb9ec616bb5f5f93f858e2f862.tar.gz
Hide completed games.
Diffstat (limited to 'src/server/db.scm')
-rw-r--r--src/server/db.scm4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/server/db.scm b/src/server/db.scm
index f461447..da3a800 100644
--- a/src/server/db.scm
+++ b/src/server/db.scm
@@ -130,5 +130,5 @@
(define (db-fetch-user-games user-id)
(with-db (db)
(query fetch-column
- (sql db "select game_id from user_games where user_id=?;")
- user-id)))
+ (sql db "select game_id from user_games join games on user_games.game_id=games.id where user_games.user_id=? and not games.status=?;")
+ user-id "finished")))