X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=models%2FChallenge.js;fp=models%2FChallenge.js;h=96db0a2b431ad5237d8b08b4bcfceca3c4155212;hb=74ea2e8d9ec6980e2fb5a4f86afe33b4850e3d53;hp=e945daa5ad0b4c2b10a7da31b6cda119283541f4;hpb=ab4f4bf258ed68d8292b64d81babde03cddbae3c;p=vchess.git

diff --git a/models/Challenge.js b/models/Challenge.js
index e945daa5..96db0a2b 100644
--- a/models/Challenge.js
+++ b/models/Challenge.js
@@ -23,16 +23,17 @@ const ChallengeModel =
 	{
 		db.serialize(function() {
 			let query =
-				"INSERT INTO Challenges (added, uid, vid, nbPlayers, fen, mainTime, addTime) " +
-				"VALUES (" + Date.now() + "," + c.uid + "," + c.vid + "," + c.nbPlayers + "," +
-					c.fen + "," + c.mainTime + "," + c.increment + ")";
+				"INSERT INTO Challenges " +
+				"(added, uid, vid, nbPlayers, fen, mainTime, addTime) VALUES " +
+				"(" + Date.now() + "," + c.uid + "," + c.vid + "," + c.nbPlayers +
+					",'" + c.fen + "'," + c.mainTime + "," + c.increment + ")";
 			db.run(query, err => {
 				if (!!err)
 					return cb(err);
 				db.get("SELECT last_insert_rowid() AS rowid", (err2,lastId) => {
 					query =
 						"INSERT INTO WillPlay VALUES " +
-						"(" + lastId["rowid"] + "," + uid + ")";
+						"(" + lastId["rowid"] + "," + c.uid + ")";
 						db.run(query, (err,ret) => {
 							cb(err, lastId); //all we need is the challenge ID
 						});
@@ -64,6 +65,7 @@ const ChallengeModel =
 						return cb(err2);
 					const challenge = {
 						id: id,
+						uid: challengeInfo.uid,
 						vname: challengeInfo.name,
 						added: challengeInfo.added,
 						nbPlayers: challengeInfo.nbPlayers,