let router = express.Router();
const createError = require('http-errors');
const sqlite3 = require('sqlite3');//.verbose();
-const db = new sqlite3.Database('db/vchess.sqlite');
+const DbPath = __dirname.replace("/routes", "/db/vchess.sqlite");
+const db = new sqlite3.Database(DbPath);
const sanitizeHtml = require('sanitize-html');
+const MaxNbProblems = 20;
+
+const supportedLang = ["fr","en"];
+function selectLanguage(req, res)
+{
+ // If preferred language already set:
+ if (!!req.cookies["lang"])
+ return req.cookies["lang"];
+
+ // Else: search and set it
+ const langString = req.headers["accept-language"];
+ let langArray = langString
+ .replace(/;q=[0-9.]+/g, "") //priority
+ .replace(/-[A-Z]+/g, "") //region (skipped for now...)
+ .split(",") //may have some duplicates, but removal is too costly
+ let bestLang = "en"; //default: English
+ for (let lang of langArray)
+ {
+ if (supportedLang.includes(lang))
+ {
+ bestLang = lang;
+ break;
+ }
+ }
+ // Cookie expires in 183 days (expressed in milliseconds)
+ res.cookie('lang', bestLang, { maxAge: 183*24*3600*1000 });
+ return bestLang;
+}
// Home
router.get('/', function(req, res, next) {
return next(err);
res.render('index', {
title: 'club',
- variantArray: variants, //JSON.stringify(variants)
+ variantArray: variants,
+ lang: selectLanguage(req, res),
+ languages: supportedLang,
});
});
});
});
// Variant
-router.get("/:vname([a-zA-Z0-9]+)", (req,res,next) => {
- const vname = req.params["vname"];
+router.get("/:variant([a-zA-Z0-9]+)", (req,res,next) => {
+ const vname = req.params["variant"];
db.serialize(function() {
db.all("SELECT * FROM Variants WHERE name='" + vname + "'", (err,variant) => {
if (!!err)
return next(err);
if (!variant || variant.length==0)
return next(createError(404));
- // TODO (later...) get only n=100(?) most recent problems
- db.all("SELECT * FROM Problems WHERE variant='" + vname + "'",
- (err2,problems) => {
- if (!!err2)
- return next(err2);
- res.render('variant', {
- title: vname + ' Variant',
- variant: vname,
- problemArray: problems,
- });
- }
- );
+ // Get only N most recent problems
+ const query2 = "SELECT * FROM Problems " +
+ "WHERE variant='" + vname + "' " +
+ "ORDER BY added DESC " +
+ "LIMIT " + MaxNbProblems;
+ db.all(query2, (err2,problems) => {
+ if (!!err2)
+ return next(err2);
+ res.render('variant', {
+ title: vname + ' Variant',
+ variant: vname,
+ problemArray: problems,
+ lang: selectLanguage(req, res),
+ languages: supportedLang,
+ });
+ });
});
});
});
router.get("/rules/:variant([a-zA-Z0-9]+)", (req,res) => {
if (!req.xhr)
return res.json({errmsg: "Unauthorized access"});
- res.render("rules/" + req.params["variant"]);
+ const lang = selectLanguage(req, res);
+ res.render("rules/" + req.params["variant"] + "/" + lang);
});
-// Fetch 10 previous or next problems (AJAX)
+// Fetch N previous or next problems (AJAX)
router.get("/problems/:variant([a-zA-Z0-9]+)", (req,res) => {
if (!req.xhr)
return res.json({errmsg: "Unauthorized access"});
- // TODO: next or previous: in params + timedate (of current oldest or newest)
+ const vname = req.params["variant"];
+ const directionStr = (req.query.direction == "forward" ? ">" : "<");
+ const lastDt = req.query.last_dt;
+ if (!lastDt.match(/[0-9]+/))
+ return res.json({errmsg: "Bad timestamp"});
db.serialize(function() {
- //TODO
+ const query = "SELECT * FROM Problems " +
+ "WHERE variant='" + vname + "' " +
+ " AND added " + directionStr + " " + lastDt + " " +
+ "ORDER BY added " + (directionStr=="<" ? "DESC " : "") +
+ "LIMIT " + MaxNbProblems;
+ db.all(query, (err,problems) => {
+ if (!!err)
+ return res.json(err);
+ return res.json({problems: problems});
+ });
});
});
const fen = req.body["fen"];
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"]);
+ const instructions = sanitizeHtml(req.body["instructions"]).trim();
+ const solution = sanitizeHtml(req.body["solution"]).trim();
+ if (instructions.length == 0)
+ return res.json({errmsg: "Empty instructions"});
+ if (solution.length == 0)
+ return res.json({errmsg: "Empty 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();
});