// mainTime and increment in milliseconds
create: function(vid, fen, mainTime, increment, players, cb)
{
- db.serialize({
+ db.serialize(function() {
let query =
"INSERT INTO Games (vid, fen, mainTime, addTime) " +
"VALUES (" + vid + ",'" + fen + "'," + mainTime + "," + increment + ")";
});
},
- getByUser: function(uid, cb)
+ getByUser: function(uid, excluded, cb)
{
db.serialize(function() {
// Next query is fine because a player appear at most once in a game
const query =
"SELECT gid " +
"FROM Players " +
- "WHERE uid = " + uid;
+ "WHERE uid " + (excluded ? "<>" : "=") + " " + uid;
db.run(query, (err,gameIds) => {
if (!!err)
return cb(err);