X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FGame.js;h=fa4aea02c73e55b8be4eb887a2728773d3e833d0;hp=bc4ebdcaed751eb175fe66ca7789bad6606abc3c;hb=b7cbbda10f16c2419f9a4d49e219fcface5e5658;hpb=760adbcee11c8953d97514768a5d5382ef518953 diff --git a/server/models/Game.js b/server/models/Game.js index bc4ebdca..fa4aea02 100644 --- a/server/models/Game.js +++ b/server/models/Game.js @@ -29,9 +29,10 @@ const GameModel = { db.serialize(function() { let query = - "INSERT INTO Games (vid, fenStart, fen, score, timeControl, created)" + "INSERT INTO Games" + + " (vid, fenStart, fen, score, timeControl, created, drawOffer)" + " VALUES (" + vid + ",'" + fen + "','" + fen + "','*','" - + timeControl + "'," + Date.now() + ")"; + + timeControl + "'," + Date.now() + "," + false + ")"; db.run(query, function(err) { if (!!err) return cb(err); @@ -133,13 +134,15 @@ const GameModel = }); }, - // obj can have fields move, fen and/or score + // obj can have fields move, fen, drawOffer and/or score update: function(id, obj) { db.parallelize(function() { let query = "UPDATE Games " + "SET "; + if (!!obj.drawOffer) + query += "drawOffer = " + obj.drawOffer + ","; if (!!obj.fen) query += "fen = '" + obj.fen + "',"; if (!!obj.score)