X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FGame.js;fp=server%2Fmodels%2FGame.js;h=f05d2fec82d8f8955feb93ba7503e39bfded4fdd;hp=0847c8111082b51229dcfe1f9bd5d066c637ef20;hb=81b71035639a4204bd7834c9185ea961755af1cf;hpb=e9d5a418a92f560cc6bd01c775a626590177f3d9 diff --git a/server/models/Game.js b/server/models/Game.js index 0847c811..f05d2fec 100644 --- a/server/models/Game.js +++ b/server/models/Game.js @@ -144,6 +144,7 @@ const GameModel = { "ORDER BY created DESC " + "LIMIT 20"; //TODO: 20 hard-coded... db.all(query, (err, games) => { + games = games || []; // Query players names let pids = {}; games.forEach(g => { @@ -151,6 +152,7 @@ const GameModel = { if (!pids[g.black]) pids[g.black] = true; }); UserModel.getByIds(Object.keys(pids), (err2, users) => { + users = users || []; let names = {}; users.forEach(u => { names[u.id] = u.name; }); cb( @@ -185,6 +187,7 @@ const GameModel = { "FROM Games " + "WHERE score = '*' AND (white = " + uid + " OR black = " + uid + ")"; db.all(query, (err, games) => { + games = games || []; // Get movesCount (could be done in // with next query) query = "SELECT gid, COUNT(*) AS nbMoves " + @@ -201,6 +204,7 @@ const GameModel = { if (!pids[g.black]) pids[g.black] = true; }); UserModel.getByIds(Object.keys(pids), (err2, users) => { + users = users || []; let names = {}; users.forEach(u => { names[u.id] = u.name; }); cb( @@ -254,6 +258,7 @@ const GameModel = { "ORDER BY created DESC " + "LIMIT 20"; db.all(query, (err, games) => { + games = games || []; // Query player names let pids = {}; games.forEach(g => { @@ -261,6 +266,7 @@ const GameModel = { if (!pids[g.black]) pids[g.black] = true; }); UserModel.getByIds(Object.keys(pids), (err2, users) => { + users = users || []; let names = {}; users.forEach(u => { names[u.id] = u.name; }); cb(