From 1d69debc7a54360b4682af43a5ad93420f5649ba Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Wed, 28 Jun 2023 13:24:15 +0300
Subject: feat: image field for maps

Former-commit-id: 374fecd1ef73854c96dd4b80c584ddb823e6e1ba
---
 backend/controllers/mapController.go | 8 ++++----
 backend/models/models.go             | 1 +
 2 files changed, 5 insertions(+), 4 deletions(-)

(limited to 'backend')

diff --git a/backend/controllers/mapController.go b/backend/controllers/mapController.go
index b5984dc..77f8e10 100644
--- a/backend/controllers/mapController.go
+++ b/backend/controllers/mapController.go
@@ -28,12 +28,12 @@ func FetchMapSummary(c *gin.Context) {
 	}
 	// Get map data
 	response.Map.ID = intID
-	sql := `SELECT m.id, g.name, c.name, m.name
+	sql := `SELECT m.id, g.name, c.name, m.name, m.image
 	FROM maps m
 	INNER JOIN games g ON m.game_id = g.id
 	INNER JOIN chapters c ON m.chapter_id = c.id
 	WHERE m.id = $1`
-	err = database.DB.QueryRow(sql, id).Scan(&response.Map.ID, &response.Map.GameName, &response.Map.ChapterName, &response.Map.MapName)
+	err = database.DB.QueryRow(sql, id).Scan(&response.Map.ID, &response.Map.GameName, &response.Map.ChapterName, &response.Map.MapName, &response.Map.Image)
 	if err != nil {
 		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
 		return
@@ -89,12 +89,12 @@ func FetchMapLeaderboards(c *gin.Context) {
 		return
 	}
 	mapData.ID = intID
-	sql := `SELECT g.name, c.name, m.name, is_disabled 
+	sql := `SELECT g.name, c.name, m.name, is_disabled, m.image
 	FROM maps m
 	INNER JOIN games g ON m.game_id = g.id
 	INNER JOIN chapters c ON m.chapter_id = c.id
 	WHERE m.id = $1`
-	err = database.DB.QueryRow(sql, id).Scan(&mapData.GameName, &mapData.ChapterName, &mapData.MapName, &isDisabled)
+	err = database.DB.QueryRow(sql, id).Scan(&mapData.GameName, &mapData.ChapterName, &mapData.MapName, &isDisabled, &mapData.Image)
 	if err != nil {
 		c.JSON(http.StatusBadRequest, models.ErrorResponse(err.Error()))
 		return
diff --git a/backend/models/models.go b/backend/models/models.go
index 0727468..7b8cbc4 100644
--- a/backend/models/models.go
+++ b/backend/models/models.go
@@ -23,6 +23,7 @@ type Map struct {
 	GameName    string `json:"game_name"`
 	ChapterName string `json:"chapter_name"`
 	MapName     string `json:"map_name"`
+	Image       string `json:"image"`
 }
 
 type MapShort struct {
-- 
cgit v1.2.3