diff options
| author | Dennis Kobert <dennis@kobert.dev> | 2021-02-19 10:34:37 +0000 |
|---|---|---|
| committer | Dennis Kobert <dennis@kobert.dev> | 2021-02-19 10:34:37 +0000 |
| commit | bc5da83a645c22e10971455b1a180cf62684b275 (patch) | |
| tree | 3c0b7e38de935978aad83cb0ebb866c9611f53b1 /src/database.rs | |
| parent | 5ae2fdf0e941b3ce13ad35363398782381179dad (diff) | |
Use the provided username
Diffstat (limited to 'src/database.rs')
| -rw-r--r-- | src/database.rs | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/database.rs b/src/database.rs index ecb88d0..a5204a1 100644 --- a/src/database.rs +++ b/src/database.rs @@ -156,9 +156,9 @@ pub async fn match_users(lobby: String, names: &[&str]) -> Result<String, Error> JOIN suser USING (user_id) JOIN track USING (track_id) JOIN lobby USING (lobby_id) - WHERE suser.user_name IN (SELECT * FROM users) AND token = $1 + WHERE suser.user_name IN (SELECT user_name FROM users) AND token = $1 GROUP BY track_id - HAVING COUNT(track_id) = (SELECT COUNT(*) FROM users) + ---HAVING COUNT(track_id) = (SELECT COUNT(*) FROM users) ORDER BY SUM(score) DESC ) AS _ USING (track_id) ; |