From 08f3688efec9c41532ee10643594c76490f6d42d Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Thu, 4 May 2017 12:06:02 +0200 Subject: [server] Fix query parametrization --- .../src/main/java/org/openslx/bwlp/sat/database/mappers/DbUser.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbUser.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbUser.java index ac77c022..11e7bb43 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbUser.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbUser.java @@ -162,6 +162,7 @@ public class DbUser { + " (:userid, :firstname, :lastname, :email, :organizationid, UNIX_TIMESTAMP(), :canlogin, 0, 1)" + " ON DUPLICATE KEY UPDATE lastlogin = UNIX_TIMESTAMP(), email = VALUES(email)," + " firstname = VALUES(firstname), lastname = VALUES(lastname), organizationid = VALUES(organizationid)"); + insUpStmt.setBoolean("canlogin", RuntimeConfig.allowLoginByDefault()); } else { insUpStmt = connection.prepareStatement("INSERT INTO user" + " (userid, firstname, lastname, email, organizationid, canlogin, issuperuser, emailnotifications)" @@ -175,7 +176,6 @@ public class DbUser { insUpStmt.setString("lastname", ui.lastName); insUpStmt.setString("email", ui.eMail); insUpStmt.setString("organizationid", ui.organizationId); - insUpStmt.setBoolean("canlogin", RuntimeConfig.allowLoginByDefault()); insUpStmt.executeUpdate(); recheckLegacy = false; } -- cgit v1.2.3-55-g7522