X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=routes%2Fall.js;h=79f7c3d89905dc65729f9751f1ecbd1b1c2967ff;hb=e081ffe361b06ca74db0a36bf72dd73602abf57b;hp=3e6dd001df9b2771d2c78633f4fed2b3faec058b;hpb=15c1295af871a5f416b0e5b43127512c8095497a;p=vchess.git

diff --git a/routes/all.js b/routes/all.js
index 3e6dd001..79f7c3d8 100644
--- a/routes/all.js
+++ b/routes/all.js
@@ -1,31 +1,138 @@
-var express = require('express');
-var router = express.Router();
-var createError = require('http-errors');
+let express = require('express');
+let router = express.Router();
+const createError = require('http-errors');
+const sqlite3 = require('sqlite3');//.verbose();
+const DbPath = __dirname.replace("/routes", "/db/vchess.sqlite");
+const db = new sqlite3.Database(DbPath);
+const sanitizeHtml = require('sanitize-html');
+const MaxNbProblems = 20;
 
-const Variants = require("../variants");
+const supportedLang = ["en","es","fr"];
+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) {
-  res.render('index', {
-		title: 'club',
-		variantArray: Variants, //JSON.stringify(Variants)
+	db.serialize(function() {
+		db.all("SELECT * FROM Variants", (err,variants) => {
+			if (!!err)
+				return next(err);
+			res.render('index', {
+				title: 'club',
+				variantArray: variants,
+				lang: selectLanguage(req, res),
+				languages: supportedLang,
+			});
+		});
 	});
 });
 
 // Variant
-router.get("/:vname([a-zA-Z0-9]+)", (req,res,next) => {
-	const vname = req.params["vname"];
-	if (!Variants.some(v => { return (v.name == vname); }))
-		return next(createError(404));
-	res.render('variant', {
-		title: vname + ' Variant',
-		variant: 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));
+			// 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,
+				});
+			});
+		});
 	});
 });
 
 // Load a rules page (AJAX)
 router.get("/rules/:variant([a-zA-Z0-9]+)", (req,res) => {
-  res.render("rules/" + req.params["variant"]);
+	if (!req.xhr)
+		return res.json({errmsg: "Unauthorized access"});
+	const lang = selectLanguage(req, res);
+	res.render("rules/" + req.params["variant"] + "/" + lang);
+});
+
+// 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"});
+	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() {
+		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});
+		});
+	});
+});
+
+// Upload a problem (AJAX)
+router.post("/problems/:variant([a-zA-Z0-9]+)", (req,res) => {
+	if (!req.xhr)
+		return res.json({errmsg: "Unauthorized access"});
+	const vname = req.params["variant"];
+	const timestamp = Date.now();
+	// Sanitize them
+	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"]).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 " +
+			"(added,variant,fen,instructions,solution) VALUES (?,?,?,?,?)");
+		stmt.run(timestamp, vname, fen, instructions, solution);
+		stmt.finalize();
+	});
+  res.json({});
 });
 
 module.exports = router;