X-Git-Url: https://git.auder.net/assets/current/git-logo.png?a=blobdiff_plain;f=server%2Fmodels%2FGame.js;h=94056c57a2491390dc63909ea13353f06e47b99c;hb=a9b131f10ee55bd96c60180c55666df4b1f4dc4d;hp=6f1513754adc03c5278556dd1ee324272af6731f;hpb=5d04793e1bce0d448b4ffc532f1e8eb47a72e972;p=vchess.git diff --git a/server/models/Game.js b/server/models/Game.js index 6f151375..94056c57 100644 --- a/server/models/Game.js +++ b/server/models/Game.js @@ -6,8 +6,7 @@ var db = require("../utils/database"); * vid: integer (variant id) * fenStart: varchar (initial position) * fen: varchar (current position) - * mainTime: integer - * addTime: integer (increment) + * timeControl: string * score: varchar (result) * * Structure table Players: @@ -27,13 +26,12 @@ var db = require("../utils/database"); const GameModel = { - // mainTime and increment in milliseconds - create: function(vid, fen, mainTime, increment, players, cb) + create: function(vid, fen, timeControl, players, cb) { - db.serialize({ + db.serialize(function() { let query = - "INSERT INTO Games (vid, fen, mainTime, addTime) " + - "VALUES (" + vid + ",'" + fen + "'," + mainTime + "," + increment + ")"; + "INSERT INTO Games (vid, fen, timeControl) " + + "VALUES (" + vid + ",'" + fen + "'," + timeControl + ")"; db.run(insertQuery, err => { if (!!err) return cb(err); @@ -41,7 +39,8 @@ const GameModel = players.forEach(p => { query = "INSERT INTO Players VALUES " + - "(" + lastId["rowid"] + "," + p.id + "," + p.color + "," + mainTime + ")"; + // Remaining time = -1 means "unstarted" + "(" + lastId["rowid"] + "," + p.id + "," + p.color + ", -1)"; db.run(query, cb); }); });