X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FGame.js;h=0e42292eae3a4c148fada807452aa198cc54f8a8;hp=ced561127f8cbbf7645bd532bb8e4eaff1c16ca8;hb=afc426016772300cc2812e8f96dd964bc6ae739d;hpb=f41ce5806b989c06091a403d7e26ff3c457650c9

diff --git a/server/models/Game.js b/server/models/Game.js
index ced56112..0e42292e 100644
--- a/server/models/Game.js
+++ b/server/models/Game.js
@@ -132,31 +132,24 @@ const GameModel =
   // obj can have fields move, fen and/or score
   update: function(id, obj)
   {
-
-
-
-console.log(id);
-    console.log(obj);
-
-
 		db.parallelize(function() {
       let query =
         "UPDATE Games " +
         "SET ";
       if (!!obj.fen)
-        query += "fen = " + obj.fen + ",";
+        query += "fen = '" + obj.fen + "',";
       if (!!obj.score)
-        query += "score = " + obj.score + ",";
+        query += "score = '" + obj.score + "',";
       query = query.slice(0,-1); //remove last comma
-      query += " WHERE gameId = " + id;
+      query += " WHERE id = " + id;
       db.run(query);
       if (!!obj.move)
       {
-        const m  =obj.move;
+        const m = obj.move;
         query =
           "INSERT INTO Moves (gid,squares,message,played,idx,color) VALUES " +
           "(" + id + ",'" + JSON.stringify(m.squares) + "','" + m.message +
-            "'" + m.played + "," + m.idx + ",'" + m.color + "')";
+            "'," + m.played + "," + m.idx + ",'" + m.color + "')";
         db.run(query);
       }
     });