X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FChallenge.js;fp=server%2Fmodels%2FChallenge.js;h=c74762992e285c03144093e1eef09a97480df5fe;hb=2be5d6140901fc7bb2a33d672e52cfdc545a1912;hp=c988aba5cd76433cbec08514a6fff57b8ffad5a0;hpb=b4de2e730539cadbff94a42eccfb9cb046cbf810;p=vchess.git diff --git a/server/models/Challenge.js b/server/models/Challenge.js index c988aba5..c7476299 100644 --- a/server/models/Challenge.js +++ b/server/models/Challenge.js @@ -67,20 +67,27 @@ const ChallengeModel = }); }, - remove: function(id, uid, cb) + remove: function(id) { db.serialize(function() { - let query = + const query = + "DELETE FROM Challenges " + + "WHERE id = " + id; + db.run(query); + }); + }, + + safeRemove: function(id, uid, cb) + { + db.serialize(function() { + const query = "SELECT 1 " + "FROM Challenges " + "WHERE id = " + id + " AND uid = " + uid; db.get(query, (err,chall) => { if (!chall) return cb({errmsg: "Not your challenge"}); - query = - "DELETE FROM Challenges " + - "WHERE id = " + id; - db.run(query); + ChallengeModel.remove(id); cb(null); }); });