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/middleware/auth.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'backend/middleware')

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) {
 		}
 		// Get user titles from DB
 		user.Titles = []string{}
-		rows, _ := database.DB.Query(`SELECT t.title_name FROM titles t WHERE t.user_id = $1`, user.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`, user.SteamID)
 		for rows.Next() {
 			var title string
 			rows.Scan(&title)
-- 
cgit v1.2.3