feat: image field for maps

Former-commit-id: 374fecd1ef73854c96dd4b80c584ddb823e6e1ba

2 files changed, 5 insertions, 4 deletions

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 {