diff options
Diffstat (limited to 'backend/handlers')
| -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 { |