diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-08-24 09:30:58 +0000 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-08-24 09:31:18 +0000 |
| commit | db665af84a047d290ea204a4c7a55115dd1fa728 (patch) | |
| tree | bb61b211d9c633516e8056d3656c34d93d607887 | |
| parent | docs: update license name in disclaimer (diff) | |
| download | lphub-db665af84a047d290ea204a4c7a55115dd1fa728.tar.gz lphub-db665af84a047d290ea204a4c7a55115dd1fa728.tar.bz2 lphub-db665af84a047d290ea204a4c7a55115dd1fa728.zip | |
fix: change title handling and login not working (#49)
Former-commit-id: b18e6b1d7d5aa68d14d656167d0250a4881dc7a4
| -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) |