X-Git-Url: https://git.auder.net/variants/Checkered/style.css?a=blobdiff_plain;f=server%2Fmodels%2FGame.js;h=e60bfe5195ce88a3210d4df52c91fd2bb9f59c59;hb=2be5d6140901fc7bb2a33d672e52cfdc545a1912;hp=94056c57a2491390dc63909ea13353f06e47b99c;hpb=a9b131f10ee55bd96c60180c55666df4b1f4dc4d;p=vchess.git diff --git a/server/models/Game.js b/server/models/Game.js index 94056c57..e60bfe51 100644 --- a/server/models/Game.js +++ b/server/models/Game.js @@ -35,15 +35,14 @@ const GameModel = db.run(insertQuery, err => { if (!!err) return cb(err); - db.get("SELECT last_insert_rowid() AS rowid", (err2,lastId) => { - players.forEach(p => { - query = - "INSERT INTO Players VALUES " + - // Remaining time = -1 means "unstarted" - "(" + lastId["rowid"] + "," + p.id + "," + p.color + ", -1)"; - db.run(query, cb); - }); - }); + players.forEach(p => { + query = + "INSERT INTO Players VALUES " + + // Remaining time = -1 means "unstarted" + "(" + this.lastID + "," + p.id + "," + p.color + ", -1)"; + db.run(query); + }); + cb(null, {gid: this.lastID}); }); }); }, @@ -104,6 +103,7 @@ const GameModel = db.run(query, (err,gameIds) => { if (!!err) return cb(err); + gameIds = gameIds || []; //might be empty let gameArray = []; gameIds.forEach(gidRow => { GameModel.getOne(gidRow["gid"], (err2,game) => {