projects
/
vchess.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Finished basic chat implementation
[vchess.git]
/
routes
/
all.js
diff --git
a/routes/all.js
b/routes/all.js
index
b966532
..
d5b4e56
100644
(file)
--- a/
routes/all.js
+++ b/
routes/all.js
@@
-74,7
+74,8
@@
router.post("/problems/:variant([a-zA-Z0-9]+)", (req,res) => {
const instructions = sanitizeHtml(req.body["instructions"]);
const solution = sanitizeHtml(req.body["solution"]);
db.serialize(function() {
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();
});
stmt.run(timestamp, vname, fen, instructions, solution);
stmt.finalize();
});