7 files changed, 34 insertions, 34 deletions

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..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.ardapektezol.com/swagger.json',
+        url: '/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/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!"))
diff --git a/backend/handlers/user.go b/backend/handlers/user.go
index 17a7819..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()))
@@ -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 {
@@ -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()))
@@ -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 {
diff --git a/backend/main.go b/backend/main.go
index 26aa852..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()
@@ -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")))
 }