aboutsummaryrefslogtreecommitdiff
path: root/backend
diff options
context:
space:
mode:
Diffstat (limited to 'backend')
-rw-r--r--backend/database/init.sql2
-rw-r--r--backend/handlers/login.go6
2 files changed, 6 insertions, 2 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 11ccd38..e238eae 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -13,7 +13,7 @@ CREATE TABLE users (
13); 13);
14 14
15CREATE TRIGGER "users" 15CREATE TRIGGER "users"
16AFTER INSERT OR UPDATE OR DELETE ON "users" 16AFTER UPDATE OR DELETE ON "users"
17FOR EACH ROW EXECUTE FUNCTION log_audit(); 17FOR EACH ROW EXECUTE FUNCTION log_audit();
18 18
19CREATE TABLE games ( 19CREATE TABLE games (
diff --git a/backend/handlers/login.go b/backend/handlers/login.go
index 51c90d0..777327c 100644
--- a/backend/handlers/login.go
+++ b/backend/handlers/login.go
@@ -58,8 +58,12 @@ func Login(c *gin.Context) {
58 user.LocCountryCode = "XX" 58 user.LocCountryCode = "XX"
59 } 59 }
60 // Insert new user to database 60 // Insert new user to database
61 database.DB.Exec(`INSERT INTO users (steam_id, user_name, avatar_link, country_code) 61 _, err = database.DB.Exec(`INSERT INTO users (steam_id, user_name, avatar_link, country_code)
62 VALUES ($1, $2, $3, $4)`, steamID, user.PersonaName, user.AvatarFull, user.LocCountryCode) 62 VALUES ($1, $2, $3, $4)`, steamID, user.PersonaName, user.AvatarFull, user.LocCountryCode)
63 if err != nil {
64 c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
65 return
66 }
63 } 67 }
64 moderator := false 68 moderator := false
65 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) 69 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)