diff options
author | Tor Andersson <tor@ccxvii.net> | 2024-10-18 20:49:31 +0200 |
---|---|---|
committer | Tor Andersson <tor@ccxvii.net> | 2024-10-18 20:49:31 +0200 |
commit | e616cd369742b798bb7491c65e24c234dae0da06 (patch) | |
tree | 124991970adb6ed774078e5aae016f7cd007a4af /server.js | |
parent | 546dcc127754054347b08d74c945665cfe3c3f97 (diff) | |
download | server-e616cd369742b798bb7491c65e24c234dae0da06.tar.gz |
don't count future games against open game limit.
Diffstat (limited to 'server.js')
-rw-r--r-- | server.js | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -1385,7 +1385,7 @@ const SQL_DELETE_PLAYER_ROLE = SQL("DELETE FROM players WHERE game_id=? AND role const SQL_SELECT_PLAYER_VIEW = SQL("select * from player_view where game_id = ?") -const SQL_COUNT_OPEN_GAMES = SQL(`SELECT COUNT(*) FROM games WHERE owner_id=? AND status=${STATUS_OPEN}`).pluck() +const SQL_COUNT_OPEN_GAMES = SQL(`SELECT COUNT(*) FROM games WHERE owner_id=? AND status=${STATUS_OPEN} and not is_match`).pluck() const SQL_COUNT_ACTIVE_GAMES = SQL(` select count(*) from games where status < 2 and exists ( |