"INSERT INTO Games (vid, fenStart, score, timeControl) " +
"VALUES (" + vid + ",'" + fen + "','*','" + timeControl + "')";
db.run(query, function(err) {
- if (!!err)
- return cb(err);
+ if (!!err)
+ return cb(err);
players.forEach((p,idx) => {
const color = (idx==0 ? "w" : "b");
query =
});
},
+ getPlayers: function(id, cb)
+ {
+ db.serialize(function() {
+ const query =
+ "SELECT id " +
+ "FROM Players " +
+ "WHERE gid = " + id;
+ db.all(query, (err,players) => {
+ return cb(err, players);
+ });
+ });
+ },
+
// obj can have fields move, fen and/or score
update: function(id, obj, cb)
{