diff options
Diffstat (limited to '')
| -rw-r--r-- | backend/database/init.sql | 2 | ||||
| -rw-r--r-- | backend/handlers/login.go | 6 |
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 | ||
| 15 | CREATE TRIGGER "users" | 15 | CREATE TRIGGER "users" |
| 16 | AFTER INSERT OR UPDATE OR DELETE ON "users" | 16 | AFTER UPDATE OR DELETE ON "users" |
| 17 | FOR EACH ROW EXECUTE FUNCTION log_audit(); | 17 | FOR EACH ROW EXECUTE FUNCTION log_audit(); |
| 18 | 18 | ||
| 19 | CREATE TABLE games ( | 19 | CREATE 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) |