X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FChallenge.js;h=8adf3cac1048791527cc0d1884df218fbdce19cc;hp=e977267275f54cf39494671aeda6222713c507c1;hb=36093ebabecde5a86451a4600babbecc971887c0;hpb=1f49533df1dafc5f83b815a9c89b8ccaccde2d6d

diff --git a/server/models/Challenge.js b/server/models/Challenge.js
index e9772672..8adf3cac 100644
--- a/server/models/Challenge.js
+++ b/server/models/Challenge.js
@@ -126,6 +126,15 @@ const ChallengeModel =
 		});
 	},
 
+  testfunc: function()
+  {
+    db.serialize(function() {
+      db.run("DELETE * FROM TableTest", (err,ret) => {
+        console.log(ret);
+      });
+    });
+  },
+
 	remove: function(id, uid)
 	{
 		db.serialize(function() {
@@ -133,10 +142,15 @@ const ChallengeModel =
 				"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);
+        }
+      });
 		});
 	},
 }