X-Git-Url: https://git.auder.net/assets/current/git-favicon.png?a=blobdiff_plain;f=server%2Fmodels%2FGame.js;h=aec80a015d9d0106de3735fbf5bbcd5289893b90;hb=0d5335de5c94d780e03ac0aa3279b731c69455cc;hp=5f332b758db5cd185c2d8407a9f5654a8ac5625f;hpb=8be8238cbd8bd1eeeb4c101648d6902cae425f7b;p=vchess.git diff --git a/server/models/Game.js b/server/models/Game.js index 5f332b75..aec80a01 100644 --- a/server/models/Game.js +++ b/server/models/Game.js @@ -380,7 +380,7 @@ const GameModel = "FROM Games " + "WHERE id = " + id; db.get(query, (err2, ret2) => { - const daysTc = parseInt(ret2.cadence.match(/\(^[0-9]+\)/)[0]); + const daysTc = parseInt(ret2.cadence.match(/^[0-9]+/)[0]); if (Date.now() - ret.lastPlayed > daysTc * 24 * 3600 * 1000) finishAndSendQuery(); else cb({ errmsg: "Time not over" }); @@ -454,7 +454,7 @@ const GameModel = "SELECT gid, count(*) AS nbMoves, MAX(played) AS lastMaj " + "FROM Moves " + "GROUP BY gid"; - db.get(query, (err2, mstats) => { + db.all(query, (err2, mstats) => { // Reorganize moves data to avoid too many array lookups: let movesGroups = {}; mstats.forEach(ms => { @@ -464,18 +464,18 @@ const GameModel = }; }); // Remove games still not really started, - // with no action in the last 3 months: + // with no action in the last 2 weeks: let toRemove = []; games.forEach(g => { if ( ( !movesGroups[g.id] && - tsNow - g.created > 91*day + tsNow - g.created > 14*day ) || ( movesGroups[g.id].nbMoves == 1 && - tsNow - movesGroups[g.id].lastMaj > 91*day + tsNow - movesGroups[g.id].lastMaj > 14*day ) ) { toRemove.push(g.id);