X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FUser.js;h=d91045b7c8b5cbd04205bb8b19c5b24ac5546e2e;hb=323de224a70234975f325a15003a8b10b1a021d9;hp=37df4e6c75f91beaeca754d17e603dfe116a0c09;hpb=80b38d463c0d5dacac93bc2aeb666bbb19781e1e;p=vchess.git diff --git a/server/models/User.js b/server/models/User.js index 37df4e6c..d91045b7 100644 --- a/server/models/User.js +++ b/server/models/User.js @@ -37,11 +37,11 @@ const UserModel = { }, // Find one user by id, name, email, or token - getOne: function(by, value, cb) { + getOne: function(by, value, fields, cb) { const delimiter = (typeof value === "string" ? "'" : ""); db.serialize(function() { const query = - "SELECT * " + + "SELECT " + fields + " " + "FROM Users " + "WHERE " + by + " = " + delimiter + value + delimiter; db.get(query, cb); @@ -107,7 +107,7 @@ const UserModel = { query = "UPDATE Users " + // Also empty the login token to invalidate future attempts - "SET loginToken = NULL" + + "SET loginToken = NULL, loginTime = NULL " + setSessionToken + " " + "WHERE id = " + id; db.run(query); @@ -139,7 +139,7 @@ const UserModel = { }, tryNotify: function(id, message) { - UserModel.getOne("id", id, (err,user) => { + UserModel.getOne("id", id, "name, email, notify", (err, user) => { if (!err && user.notify) UserModel.notify(user, message); }); },