From db665af84a047d290ea204a4c7a55115dd1fa728 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Thu, 24 Aug 2023 09:30:58 +0000
Subject: fix: change title handling and login not working (#49)

Former-commit-id: b18e6b1d7d5aa68d14d656167d0250a4881dc7a4
---
 backend/controllers/loginController.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'backend/controllers')

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) {
 			VALUES ($1, $2, $3, $4)`, steamID, user.PersonaName, user.AvatarFull, user.LocCountryCode)
 		}
 		moderator := false
-		rows, _ := database.DB.Query("SELECT title_name FROM titles WHERE user_id = $1", steamID)
+		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)
 		for rows.Next() {
 			var title string
 			rows.Scan(&title)
-- 
cgit v1.2.3