X-Git-Url: https://git.auder.net/img/rock_paper_scissors_lizard_spock.gif?a=blobdiff_plain;f=server%2Fmodels%2FGame.js;h=94056c57a2491390dc63909ea13353f06e47b99c;hb=a9b131f10ee55bd96c60180c55666df4b1f4dc4d;hp=30d29c7317972b55886c6a9718cd4a2b5af5c298;hpb=88667455b8793075a0266d4477fa0f4d03257cb0;p=vchess.git diff --git a/server/models/Game.js b/server/models/Game.js index 30d29c73..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(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); }); });