const db = new sqlite3.Database('db/vchess.sqlite');
const sanitizeHtml = require('sanitize-html');
+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) {
db.serialize(function() {
return next(err);
res.render('index', {
title: 'club',
- variantArray: variants, //JSON.stringify(variants)
+ variantArray: variants,
+ lang: selectLanguage(req, res),
+ languages: supportedLang,
});
});
});
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)
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();
});