const timestamp = Date.now();
// Sanitize them
const fen = req.body["fen"];
- if (!fen.match(/^[a-zA-Z0-9 /]*$/))
+ if (!fen.match(/^[a-zA-Z0-9, /-]*$/))
return res.json({errmsg: "Bad characters in FEN string"});
const instructions = sanitizeHtml(req.body["instructions"]);
const solution = sanitizeHtml(req.body["solution"]);
db.serialize(function() {
- let stmt = db.prepare("INSERT INTO Problems VALUES (?,?,?,?,?)");
+ let stmt = db.prepare("INSERT INTO Problems " +
+ "(added,variant,fen,instructions,solution) VALUES (?,?,?,?,?)");
stmt.run(timestamp, vname, fen, instructions, solution);
stmt.finalize();
});