X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FGame.js;h=d72f51a18dc2458ed30bd3eca04e8516012c0e4a;hb=23ecf00824691b5622b468e0409fc543c87d75dc;hp=21ece2f181a872434662dedce1fa4b878acab835;hpb=fb68b0c2e3dae0be3e1f55b9516070c2731cf8d9;p=vchess.git diff --git a/server/models/Game.js b/server/models/Game.js index 21ece2f1..d72f51a1 100644 --- a/server/models/Game.js +++ b/server/models/Game.js @@ -91,11 +91,18 @@ const GameModel = db.all(query, (err2,players) => { if (light) { - const game = Object.assign({}, - gameInfo, - {players: players} - ); - cb(null, game); + query = + "SELECT COUNT(*) AS nbMoves " + + "FROM Moves " + + "WHERE gid = " + id; + db.get(query, (err,ret) => { + const game = Object.assign({}, + gameInfo, + {players: players}, + {movesCount: ret.nbMoves} + ); + cb(null, game); + }); } else { @@ -235,7 +242,7 @@ const GameModel = query += modifs + " WHERE id = " + id; db.run(query); } - let wrongMoveIndex = false; + // NOTE: move, chat and delchat are mutually exclusive if (obj.move) { // Security: only update moves if index is right @@ -263,6 +270,14 @@ const GameModel = + id + ",?,'" + obj.chat.name + "'," + Date.now() + ")"; db.run(query, obj.chat.msg); } + else if (obj.delchat) + { + query = + "DELETE " + + "FROM Chats " + + "WHERE gid = " + id; + db.run(query); + } }); },