From ae360114069da9ef567551dede7196d7831049c1 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Tue, 22 Oct 2024 11:31:03 +0300
Subject: backend: importance of || and &&

---
 backend/handlers/record.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'backend')

diff --git a/backend/handlers/record.go b/backend/handlers/record.go
index c720823..e43cc61 100644
--- a/backend/handlers/record.go
+++ b/backend/handlers/record.go
@@ -204,7 +204,7 @@ func CreateRecordWithDemo(c *gin.Context) {
 		// 	c.JSON(http.StatusOK, models.ErrorResponse(fmt.Sprintf("Partner SteamID from demo and request does not match! Check your submission and try again.\nDemo Partner SteamID: %s\nRequest Partner SteamID: %s", convertedPartnerSteamID, record.PartnerID)))
 		// 	return
 		// }
-		if convertedHostSteamID != user.(models.User).SteamID || convertedPartnerSteamID != user.(models.User).SteamID {
+		if convertedHostSteamID != user.(models.User).SteamID && convertedPartnerSteamID != user.(models.User).SteamID {
 			deleteFile(srv, hostDemoFileID)
 			deleteFile(srv, partnerDemoFileID)
 			c.JSON(http.StatusOK, models.ErrorResponse("You are permitted to only upload your own runs!"))
-- 
cgit v1.2.3


From 51fc58f03b7aa60ae59bfae4c385438425218c92 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Tue, 22 Oct 2024 17:40:30 +0300
Subject: backend: specify 250mb limit

---
 RULES.md        | 1 +
 backend/main.go | 2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)

(limited to 'backend')

diff --git a/RULES.md b/RULES.md
index 3645d8f..ffd344d 100644
--- a/RULES.md
+++ b/RULES.md
@@ -22,6 +22,7 @@ Both `.vtf` and `.vmt` files associated with these textures can be modified.
 - Proof of your run must be recorded using demos. To start recording, type `record <demoname>` when entering the map, or use the SAR plugin with the command `sar_record_at 0`.
 - A valid demo begins when the player can move and ends when the player touches the end flags.
 - For cooperative runs, both players must submit their demos.
+- For technical reasons, there is a 250 MB limit for demo files. If you have a demo file bigger than 250 MB that you need to submit, please contact an admin in the Discord server.
 
 ### Console Commands & Cheats
 
diff --git a/backend/main.go b/backend/main.go
index 26aa852..edbe7f8 100644
--- a/backend/main.go
+++ b/backend/main.go
@@ -47,6 +47,6 @@ func main() {
 	// router.NoRoute(func(c *gin.Context) {
 	// 	c.File("../frontend/build/index.html")
 	// })
-	router.MaxMultipartMemory = 500 << 20 // 500 mb limit for demos
+	router.MaxMultipartMemory = 250 << 20 // 250 mb limit for demos
 	router.Run(fmt.Sprintf(":%s", os.Getenv("PORT")))
 }
-- 
cgit v1.2.3


From dda495de3fd79e4a36713c6012820b7e3394d172 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Tue, 22 Oct 2024 18:38:51 +0300
Subject: docs: point to pektezoldev

---
 README.md                 | 2 +-
 backend/docs/docs.go      | 2 +-
 backend/docs/index.html   | 2 +-
 backend/docs/swagger.json | 2 +-
 backend/docs/swagger.yaml | 2 +-
 backend/main.go           | 2 +-
 6 files changed, 6 insertions(+), 6 deletions(-)

(limited to 'backend')

diff --git a/README.md b/README.md
index 5ff180e..6d1eef5 100644
--- a/README.md
+++ b/README.md
@@ -34,7 +34,7 @@ There's also discussion tabs for each map to act like forum pages in order to ta
 
 ## Documentation
 
-Full API documentation can be found at https://lp.ardapektezol.com/api/v1/
+Full API documentation can be found at https://lp.pektezol.dev/api/v1/
 
 ## License
 
diff --git a/backend/docs/docs.go b/backend/docs/docs.go
index 5327961..71bd68e 100644
--- a/backend/docs/docs.go
+++ b/backend/docs/docs.go
@@ -2218,7 +2218,7 @@ const docTemplate = `{
 // SwaggerInfo holds exported Swagger Info so clients can modify it
 var SwaggerInfo = &swag.Spec{
 	Version:          "1.0",
-	Host:             "lp.ardapektezol.com",
+	Host:             "lp.pektezol.dev",
 	BasePath:         "/api/v1",
 	Schemes:          []string{},
 	Title:            "Least Portals Hub",
diff --git a/backend/docs/index.html b/backend/docs/index.html
index 8d12274..f2b358d 100644
--- a/backend/docs/index.html
+++ b/backend/docs/index.html
@@ -17,7 +17,7 @@
   <script>
     window.onload = () => {
       window.ui = SwaggerUIBundle({
-        url: 'https://lp.ardapektezol.com/swagger.json',
+        url: 'https://lp.pektezol.dev/swagger.json',
         dom_id: '#swagger-ui',
       });
     };
diff --git a/backend/docs/swagger.json b/backend/docs/swagger.json
index 94a0213..879f35f 100644
--- a/backend/docs/swagger.json
+++ b/backend/docs/swagger.json
@@ -10,7 +10,7 @@
         },
         "version": "1.0"
     },
-    "host": "lp.ardapektezol.com",
+    "host": "lp.pektezol.dev",
     "basePath": "/api/v1",
     "paths": {
         "/chapters/{chapterid}": {
diff --git a/backend/docs/swagger.yaml b/backend/docs/swagger.yaml
index 26d28b1..2dee421 100644
--- a/backend/docs/swagger.yaml
+++ b/backend/docs/swagger.yaml
@@ -545,7 +545,7 @@ definitions:
       user_name:
         type: string
     type: object
-host: lp.ardapektezol.com
+host: lp.pektezol.dev
 info:
   contact: {}
   description: Backend API endpoints for Least Portals Hub.
diff --git a/backend/main.go b/backend/main.go
index edbe7f8..a1a4a20 100644
--- a/backend/main.go
+++ b/backend/main.go
@@ -20,7 +20,7 @@ import (
 //	@license.name	GNU Affero General Public License, Version 3
 //	@license.url	https://www.gnu.org/licenses/agpl-3.0.html
 
-// @host		lp.ardapektezol.com
+// @host		lp.pektezol.dev
 // @BasePath	/api/v1
 func main() {
 	err := godotenv.Load()
-- 
cgit v1.2.3


From c4ae6de3f8e1ef237cac51ec8a72fae5205eb304 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Tue, 22 Oct 2024 18:49:18 +0300
Subject: docs: url independent

---
 backend/docs/index.html | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'backend')

diff --git a/backend/docs/index.html b/backend/docs/index.html
index f2b358d..997b7d6 100644
--- a/backend/docs/index.html
+++ b/backend/docs/index.html
@@ -17,7 +17,7 @@
   <script>
     window.onload = () => {
       window.ui = SwaggerUIBundle({
-        url: 'https://lp.pektezol.dev/swagger.json',
+        url: '/swagger.json',
         dom_id: '#swagger-ui',
       });
     };
-- 
cgit v1.2.3


From 483dd529f156c9ae41405153c1df0a19cc1c66c8 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Thu, 24 Oct 2024 11:16:09 +0300
Subject: backend: fix wr deltas

---
 backend/handlers/user.go | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'backend')

diff --git a/backend/handlers/user.go b/backend/handlers/user.go
index 17a7819..ea96732 100644
--- a/backend/handlers/user.go
+++ b/backend/handlers/user.go
@@ -350,7 +350,7 @@ func Profile(c *gin.Context) {
 		records[len(records)-1].Scores = append(records[len(records)-1].Scores, score)
 	}
 	// Get multiplayer records
-	sql = `SELECT mp.id, m.game_id, m.chapter_id, mp.map_id, m."name", (SELECT mh.score_count FROM map_history mh WHERE mh.map_id = mp.map_id ORDER BY mh.score_count ASC LIMIT 1) AS wr_count,  mp.score_count, mp.score_time, CASE WHEN host_id = $1 THEN mp.host_demo_id WHEN partner_id = $1 THEN mp.partner_demo_id END demo_id, mp.record_date
+	sql = `SELECT mp.id, m.game_id, m.chapter_id, mp.map_id, m."name", (SELECT mh.score_count FROM map_history mh WHERE mh.map_id = mp.map_id AND mh.category_id = 1 ORDER BY mh.score_count ASC LIMIT 1) AS wr_count,  mp.score_count, mp.score_time, CASE WHEN host_id = $1 THEN mp.host_demo_id WHEN partner_id = $1 THEN mp.partner_demo_id END demo_id, mp.record_date
 	FROM records_mp mp INNER JOIN maps m ON mp.map_id = m.id WHERE (mp.host_id = $1 OR mp.partner_id = $1) AND mp.is_deleted = false ORDER BY mp.map_id, mp.score_count, mp.score_time`
 	rows, err = database.DB.Query(sql, user.(models.User).SteamID)
 	if err != nil {
@@ -672,7 +672,7 @@ func FetchUser(c *gin.Context) {
 	}
 	records := []ProfileRecords{}
 	// Get singleplayer records
-	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
+	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
 	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`
 	rows, err = database.DB.Query(sql, user.SteamID)
 	if err != nil {
@@ -728,7 +728,7 @@ func FetchUser(c *gin.Context) {
 		records[len(records)-1].Scores = append(records[len(records)-1].Scores, score)
 	}
 	// Get multiplayer records
-	sql = `SELECT mp.id, m.game_id, m.chapter_id, mp.map_id, m."name", (SELECT mh.score_count FROM map_history mh WHERE mh.map_id = mp.map_id ORDER BY mh.score_count ASC LIMIT 1) AS wr_count,  mp.score_count, mp.score_time, CASE WHEN host_id = $1 THEN mp.host_demo_id WHEN partner_id = $1 THEN mp.partner_demo_id END demo_id, mp.record_date
+	sql = `SELECT mp.id, m.game_id, m.chapter_id, mp.map_id, m."name", (SELECT mh.score_count FROM map_history mh WHERE mh.map_id = mp.map_id AND mh.category_id = 1 ORDER BY mh.score_count ASC LIMIT 1) AS wr_count,  mp.score_count, mp.score_time, CASE WHEN host_id = $1 THEN mp.host_demo_id WHEN partner_id = $1 THEN mp.partner_demo_id END demo_id, mp.record_date
 	FROM records_mp mp INNER JOIN maps m ON mp.map_id = m.id WHERE (mp.host_id = $1 OR mp.partner_id = $1) AND mp.is_deleted = false ORDER BY mp.map_id, mp.score_count, mp.score_time`
 	rows, err = database.DB.Query(sql, user.SteamID)
 	if err != nil {
-- 
cgit v1.2.3


From c987c7605784b720c2dc6e0f77a4df48715bc6a2 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Thu, 24 Oct 2024 11:41:32 +0300
Subject: backend: fix user completion count

---
 backend/handlers/user.go | 48 ++++++++++++++++++++++++------------------------
 1 file changed, 24 insertions(+), 24 deletions(-)

(limited to 'backend')

diff --git a/backend/handlers/user.go b/backend/handlers/user.go
index ea96732..dc058c8 100644
--- a/backend/handlers/user.go
+++ b/backend/handlers/user.go
@@ -98,19 +98,19 @@ func Profile(c *gin.Context) {
 	}
 	rankings.Overall.CompletionTotal = rankings.Singleplayer.CompletionTotal + rankings.Cooperative.CompletionTotal
 	// Get user completion count
-	sql = `SELECT 'records_sp' AS table_name, COUNT(sp.id)
-	FROM records_sp sp JOIN (
-    	SELECT mh.map_id, MIN(mh.score_count) AS min_score_count
-    	FROM public.map_history mh WHERE mh.category_id = 1 GROUP BY mh.map_id
-	) AS subquery_sp ON sp.map_id = subquery_sp.map_id AND sp.score_count = subquery_sp.min_score_count
-	WHERE sp.user_id = $1 AND sp.is_deleted = false
+	sql = `SELECT 'records_sp' AS table_name, COUNT(*) FROM (
+	    SELECT sp.map_id FROM records_sp sp JOIN (
+	        SELECT mh.map_id, MIN(mh.score_count) AS min_score_count FROM map_history mh WHERE mh.category_id = 1 GROUP BY mh.map_id
+	    ) AS subquery_sp ON sp.map_id = subquery_sp.map_id AND sp.score_count = subquery_sp.min_score_count
+	    WHERE sp.user_id = $1 AND sp.is_deleted = false GROUP BY sp.map_id
+	) AS unique_maps
 	UNION ALL
-	SELECT 'records_mp' AS table_name, COUNT(mp.id)
-	FROM public.records_mp mp JOIN (
-    	SELECT mh.map_id, MIN(mh.score_count) AS min_score_count
-    	FROM public.map_history mh WHERE mh.category_id = 1 GROUP BY mh.map_id
-	) AS subquery_mp ON mp.map_id = subquery_mp.map_id AND mp.score_count = subquery_mp.min_score_count
-	WHERE (mp.host_id = $1 OR mp.partner_id = $1) AND mp.is_deleted = false`
+	SELECT 'records_mp' AS table_name, COUNT(*) FROM (
+	    SELECT mp.map_id FROM records_mp mp JOIN (
+	        SELECT mh.map_id, MIN(mh.score_count) AS min_score_count FROM map_history mh WHERE mh.category_id = 1 GROUP BY mh.map_id
+	    ) AS subquery_mp ON mp.map_id = subquery_mp.map_id AND mp.score_count = subquery_mp.min_score_count
+	    WHERE (mp.host_id = $1 OR mp.partner_id = $1) AND mp.is_deleted = false GROUP BY mp.map_id
+	) AS unique_maps`
 	rows, err := database.DB.Query(sql, user.(models.User).SteamID)
 	if err != nil {
 		c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
@@ -476,19 +476,19 @@ func FetchUser(c *gin.Context) {
 	}
 	rankings.Overall.CompletionTotal = rankings.Singleplayer.CompletionTotal + rankings.Cooperative.CompletionTotal
 	// Get user completion count
-	sql = `SELECT 'records_sp' AS table_name, COUNT(sp.id)
-	FROM records_sp sp JOIN (
-    	SELECT mh.map_id, MIN(mh.score_count) AS min_score_count
-    	FROM public.map_history mh WHERE mh.category_id = 1 GROUP BY mh.map_id
-	) AS subquery_sp ON sp.map_id = subquery_sp.map_id AND sp.score_count = subquery_sp.min_score_count
-	WHERE sp.user_id = $1 AND sp.is_deleted = false
+	sql = `SELECT 'records_sp' AS table_name, COUNT(*) FROM (
+	    SELECT sp.map_id FROM records_sp sp JOIN (
+	        SELECT mh.map_id, MIN(mh.score_count) AS min_score_count FROM map_history mh WHERE mh.category_id = 1 GROUP BY mh.map_id
+	    ) AS subquery_sp ON sp.map_id = subquery_sp.map_id AND sp.score_count = subquery_sp.min_score_count
+	    WHERE sp.user_id = $1 AND sp.is_deleted = false GROUP BY sp.map_id
+	) AS unique_maps
 	UNION ALL
-	SELECT 'records_mp' AS table_name, COUNT(mp.id)
-	FROM public.records_mp mp JOIN (
-    	SELECT mh.map_id, MIN(mh.score_count) AS min_score_count
-    	FROM public.map_history mh WHERE mh.category_id = 1 GROUP BY mh.map_id
-	) AS subquery_mp ON mp.map_id = subquery_mp.map_id AND mp.score_count = subquery_mp.min_score_count
-	WHERE (mp.host_id = $1 OR mp.partner_id = $1) AND mp.is_deleted = false`
+	SELECT 'records_mp' AS table_name, COUNT(*) FROM (
+	    SELECT mp.map_id FROM records_mp mp JOIN (
+	        SELECT mh.map_id, MIN(mh.score_count) AS min_score_count FROM map_history mh WHERE mh.category_id = 1 GROUP BY mh.map_id
+	    ) AS subquery_mp ON mp.map_id = subquery_mp.map_id AND mp.score_count = subquery_mp.min_score_count
+	    WHERE (mp.host_id = $1 OR mp.partner_id = $1) AND mp.is_deleted = false GROUP BY mp.map_id
+	) AS unique_maps`
 	rows, err = database.DB.Query(sql, user.SteamID)
 	if err != nil {
 		c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
-- 
cgit v1.2.3