X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FChallenge.js;fp=server%2Fmodels%2FChallenge.js;h=2be700bd04f8152a1224183971f6929589a983a6;hb=51145f8c0e0595f195e26827e932306eb0083c10;hp=40d125c929b033283f64e9754c3cbdfa572a2755;hpb=1511c610b30e524a95c45c8fa263275ec3013101;p=vchess.git diff --git a/server/models/Challenge.js b/server/models/Challenge.js index 40d125c9..2be700bd 100644 --- a/server/models/Challenge.js +++ b/server/models/Challenge.js @@ -31,10 +31,10 @@ const ChallengeModel = db.serialize(function() { const query = "INSERT INTO Challenges " + - "(added, uid, " + (!!c.to ? "target, " : "") + + "(added, uid, " + (c.to ? "target, " : "") + "vid, randomness, fen, cadence) " + "VALUES " + - "(" + Date.now() + "," + c.uid + "," + (!!c.to ? c.to + "," : "") + + "(" + Date.now() + "," + c.uid + "," + (c.to ? c.to + "," : "") + c.vid + "," + c.randomness + ",'" + c.fen + "','" + c.cadence + "')"; db.run(query, function(err) { cb(err, {cid: this.lastID}); @@ -76,7 +76,7 @@ const ChallengeModel = "FROM Challenges " + "WHERE id = " + id + " " + // Condition: I'm the sender or the target - "AND (uid = " + uid + " OR to = " + uid + ")"; + "AND (uid = " + uid + " OR target = " + uid + ")"; db.get(query, (err,chall) => { if (!err && chall) ChallengeModel.remove(id);