diff options
Diffstat (limited to 'backend')
| -rw-r--r-- | backend/controllers/loginController.go | 2 | ||||
| -rw-r--r-- | backend/middleware/auth.go | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/backend/controllers/loginController.go b/backend/controllers/loginController.go index e907b22..cc7a803 100644 --- a/backend/controllers/loginController.go +++ b/backend/controllers/loginController.go | |||
| @@ -60,7 +60,7 @@ func Login(c *gin.Context) { | |||
| 60 | VALUES ($1, $2, $3, $4)`, steamID, user.PersonaName, user.AvatarFull, user.LocCountryCode) | 60 | VALUES ($1, $2, $3, $4)`, steamID, user.PersonaName, user.AvatarFull, user.LocCountryCode) |
| 61 | } | 61 | } |
| 62 | moderator := false | 62 | moderator := false |
| 63 | rows, _ := database.DB.Query("SELECT title_name FROM titles WHERE user_id = $1", steamID) | 63 | rows, _ := database.DB.Query("SELECT title_name FROM titles t INNER JOIN user_titles ut ON t.id=ut.title_id WHERE ut.user_id = $1", steamID) |
| 64 | for rows.Next() { | 64 | for rows.Next() { |
| 65 | var title string | 65 | var title string |
| 66 | rows.Scan(&title) | 66 | rows.Scan(&title) |
diff --git a/backend/middleware/auth.go b/backend/middleware/auth.go index 0744b3d..6a057da 100644 --- a/backend/middleware/auth.go +++ b/backend/middleware/auth.go | |||
| @@ -45,7 +45,7 @@ func CheckAuth(c *gin.Context) { | |||
| 45 | } | 45 | } |
| 46 | // Get user titles from DB | 46 | // Get user titles from DB |
| 47 | user.Titles = []string{} | 47 | user.Titles = []string{} |
| 48 | rows, _ := database.DB.Query(`SELECT t.title_name FROM titles t WHERE t.user_id = $1`, user.SteamID) | 48 | rows, _ := database.DB.Query(`SELECT title_name FROM titles t INNER JOIN user_titles ut ON t.id=ut.title_id WHERE ut.user_id = $1`, user.SteamID) |
| 49 | for rows.Next() { | 49 | for rows.Next() { |
| 50 | var title string | 50 | var title string |
| 51 | rows.Scan(&title) | 51 | rows.Scan(&title) |