X-Git-Url: https://git.auder.net/css/rpsls.css?a=blobdiff_plain;f=server%2Fmodels%2FUser.js;h=60584275713dbdefe177a5064bdb7749c3de402d;hb=ed9c9c3741ec8b03cf899eae529216a2520bba0d;hp=9401133aa7a34c66cc2be7c862665da7738e52f6;hpb=1f49533df1dafc5f83b815a9c89b8ccaccde2d6d;p=vchess.git diff --git a/server/models/User.js b/server/models/User.js index 9401133a..60584275 100644 --- a/server/models/User.js +++ b/server/models/User.js @@ -63,14 +63,14 @@ const UserModel = }); }, - getByName: function(names, cb) { - db.serialize(function() { - const query = - "SELECT id + getByIds: function(ids, cb) { + db.serialize(function() { + const query = + "SELECT id, name " + "FROM Users " + - "WHERE name IN ('" + names.join("','") + "')";; - db.all(query, cb); - }); + "WHERE id IN (" + ids + ")"; + db.all(query, cb); + }); }, ///////// @@ -124,6 +124,15 @@ const UserModel = db.run(query, cb); }); }, + + ///////////////// + // NOTIFICATIONS + + tryNotify: function(oppId, gid, vname, message) + { + // TODO: send email to oppId (request...) with title + // "vchess.club - vname" and content "message" + } } module.exports = UserModel;