"DELETE FROM Challenges " +
"WHERE id = " + id + " AND uid = " + uid;
db.run(query, (err,ret) => {
- if (!!err && query = //TODO
- "DELETE FROM WillPlay " +
- "WHERE cid = " + id;
- db.run(query);
+ if (!err && ret >= 1)
+ {
+ // Also remove matching WillPlay entries if a challenge was deleted
+ query =
+ "DELETE FROM WillPlay " +
+ "WHERE cid = " + id;
+ db.run(query);
+ }
+ });
});
},
}