aboutsummaryrefslogtreecommitdiff
path: root/backend/handlers/user.go
diff options
context:
space:
mode:
Diffstat (limited to 'backend/handlers/user.go')
-rw-r--r--backend/handlers/user.go2
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 {