From 6f28f28ecd899fd7f90df42528ef178a94f6677d Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sun, 24 Sep 2023 12:13:15 +0300
Subject: feat: removing (by flag) records (#56)

Former-commit-id: cc1bed84ee7ff9133192e1278c8315afee73d23a
---
 backend/handlers/map.go | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'backend/handlers/map.go')

diff --git a/backend/handlers/map.go b/backend/handlers/map.go
index 3bf14cd..faccee4 100644
--- a/backend/handlers/map.go
+++ b/backend/handlers/map.go
@@ -104,7 +104,7 @@ func FetchMapSummary(c *gin.Context) {
 		if response.Map.IsCoop {
 			sql = `SELECT count(*) FROM ( SELECT host_id, partner_id, score_count, score_time,
 				ROW_NUMBER() OVER (PARTITION BY host_id, partner_id ORDER BY score_count, score_time) AS rn
-				FROM records_mp WHERE map_id = $1
+				FROM records_mp WHERE map_id = $1 AND is_deleted = false
 				) sub WHERE sub.rn = 1 AND score_count = $2`
 			err = database.DB.QueryRow(sql, response.Map.ID, route.History.ScoreCount).Scan(&route.CompletionCount)
 			if err != nil {
@@ -114,7 +114,7 @@ func FetchMapSummary(c *gin.Context) {
 		} else {
 			sql = `SELECT count(*) FROM ( SELECT user_id, score_count, score_time, 
 				ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY score_count, score_time) AS rn
-				FROM records_sp WHERE map_id = $1
+				FROM records_sp WHERE map_id = $1 AND is_deleted = false
 				) sub WHERE rn = 1 AND score_count = $2`
 			err = database.DB.QueryRow(sql, response.Map.ID, route.History.ScoreCount).Scan(&route.CompletionCount)
 			if err != nil {
@@ -204,7 +204,7 @@ func FetchMapLeaderboards(c *gin.Context) {
 			record_date,
 			ROW_NUMBER() OVER (PARTITION BY host_id, partner_id ORDER BY score_count, score_time) AS rn
 		FROM records_mp
-		WHERE map_id = $1
+		WHERE map_id = $1 AND is_deleted = false
 	) sub
 	JOIN users AS host ON sub.host_id = host.steam_id 
 	JOIN users AS partner ON sub.partner_id = partner.steam_id 
@@ -255,7 +255,7 @@ func FetchMapLeaderboards(c *gin.Context) {
 		  SELECT id, user_id, score_count, score_time, demo_id, record_date,
 				 ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY score_count, score_time) AS rn
 		  FROM records_sp
-		  WHERE map_id = $1
+		  WHERE map_id = $1 AND is_deleted = false
 		) sub
 		INNER JOIN users ON user_id = users.steam_id
 		WHERE rn = 1
-- 
cgit v1.2.3