X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=routes%2Fall.js;h=7c2a6da9695d9b85e10896943d822a10a0ef827d;hp=79f7c3d89905dc65729f9751f1ecbd1b1c2967ff;hb=298c42e63ae321526693e9ce418c4113af36e025;hpb=067c675b75072c496f9665c4bf801cdc3d40398d

diff --git a/routes/all.js b/routes/all.js
index 79f7c3d8..7c2a6da9 100644
--- a/routes/all.js
+++ b/routes/all.js
@@ -1,138 +1,8 @@
-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;
+var router = require("express").Router();
 
-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) {
-	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("/: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) => {
-	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({});
-});
+router.use("/", require("./index"));
+router.use("/", require("./variant"));
+router.use("/", require("./problems"));
+router.use("/", require("./messages"));
 
 module.exports = router;