X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FUser.js;h=60584275713dbdefe177a5064bdb7749c3de402d;hb=ed9c9c3741ec8b03cf899eae529216a2520bba0d;hp=9e1adedb824f27330480fcca5b75883739c02f5e;hpb=36093ebabecde5a86451a4600babbecc971887c0;p=vchess.git

diff --git a/server/models/User.js b/server/models/User.js
index 9e1adedb..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;