X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FUser.js;h=d91045b7c8b5cbd04205bb8b19c5b24ac5546e2e;hp=8a97d572da8799395fcdfc915042a3bdc91660a3;hb=323de224a70234975f325a15003a8b10b1a021d9;hpb=dd10eb93984e629c4ee5a07cd3b875fdb20f0460 diff --git a/server/models/User.js b/server/models/User.js index 8a97d572..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); @@ -58,7 +58,7 @@ const UserModel = { }); }, - getBio: function(id) { + getBio: function(id, cb) { db.serialize(function() { const query = "SELECT bio " + @@ -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); }); },