X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FUser.js;h=60584275713dbdefe177a5064bdb7749c3de402d;hp=7a0f70a78ca30cdd00af2d6eb4654d703532d704;hb=ed9c9c3741ec8b03cf899eae529216a2520bba0d;hpb=bebcc8d45532e67902175f69084a08040f06855f diff --git a/server/models/User.js b/server/models/User.js index 7a0f70a7..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); + }); }, /////////