diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2024-10-18 00:32:53 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2024-10-18 00:32:53 +0300 |
| commit | dfae82694ff1f099d7af7ac7f9241c7a585f5d51 (patch) | |
| tree | eb66f9a675cf873e707b7cc88bbb6aee3b59f9f4 | |
| parent | refactor: enable rankings cron, update website desc (diff) | |
| download | lphub-dfae82694ff1f099d7af7ac7f9241c7a585f5d51.tar.gz lphub-dfae82694ff1f099d7af7ac7f9241c7a585f5d51.tar.bz2 lphub-dfae82694ff1f099d7af7ac7f9241c7a585f5d51.zip | |
backend: check map wr count by cm category
| -rw-r--r-- | backend/handlers/user.go | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/backend/handlers/user.go b/backend/handlers/user.go index 45daa31..908063f 100644 --- a/backend/handlers/user.go +++ b/backend/handlers/user.go | |||
| @@ -294,7 +294,7 @@ func Profile(c *gin.Context) { | |||
| 294 | } | 294 | } |
| 295 | records := []ProfileRecords{} | 295 | records := []ProfileRecords{} |
| 296 | // Get singleplayer records | 296 | // Get singleplayer records |
| 297 | sql = `SELECT sp.id, m.game_id, m.chapter_id, sp.map_id, m."name", (SELECT mh.score_count FROM map_history mh WHERE mh.map_id = sp.map_id ORDER BY mh.score_count ASC LIMIT 1) AS wr_count, sp.score_count, sp.score_time, sp.demo_id, sp.record_date | 297 | sql = `SELECT sp.id, m.game_id, m.chapter_id, sp.map_id, m."name", (SELECT mh.score_count FROM map_history mh WHERE mh.map_id = sp.map_id AND mh.category_id = 1 ORDER BY mh.score_count ASC LIMIT 1) AS wr_count, sp.score_count, sp.score_time, sp.demo_id, sp.record_date |
| 298 | FROM records_sp sp INNER JOIN maps m ON sp.map_id = m.id WHERE sp.user_id = $1 AND sp.is_deleted = false ORDER BY sp.map_id, sp.score_count, sp.score_time` | 298 | FROM records_sp sp INNER JOIN maps m ON sp.map_id = m.id WHERE sp.user_id = $1 AND sp.is_deleted = false ORDER BY sp.map_id, sp.score_count, sp.score_time` |
| 299 | rows, err = database.DB.Query(sql, user.(models.User).SteamID) | 299 | rows, err = database.DB.Query(sql, user.(models.User).SteamID) |
| 300 | if err != nil { | 300 | if err != nil { |