1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
const express = require('express');
const bodyParser = require('body-parser');
const cookieParser = require('cookie-parser');
const uuidv4 = require('uuid')["v4"];
const Op = require('sequelize').Op;
const server = express();
server.use(cookieParser())
server.use(bodyParser.json());
function listen(port) {
server.listen(port, () => console.info(`Listening on port ${port}!`));
}
// Load a game and its routes
function load(gamePath, models, jwtFunctions, database) {
const game = require(gamePath);
game.setUpRoutes(server, models, jwtFunctions, database);
}
function setUpRoutes(models, jwtFunctions, database) {
// Route logger
server.use(function (req, res, next) {
console.debug(new Date(), req.method, req.originalUrl);
next()
})
// Static files
server.get('/', (req, res) => res.sendFile(__dirname + "/index.html"))
server.get('/highscore.js', (req, res) => res.sendFile(__dirname + "/highscores.js"))
server.get('/highscores', (req, res) => res.sendFile(__dirname + "/scores.html"))
// Sets a score
server.get('/setScore', async (req, res, next) => {
var results = await models.scores.findAll({
where: { uuid: { [Op.eq]: req.query.uuid } }
})
if(results.length > 0){
res.status(400).send("uuid already used")
return
}
models.scores.create({
game: req.query.game,
username: req.query.username,
score: req.query.score,
uuid: req.query.uuid
})
res.status(200).send("score saved")
})
// Gets all scores, grouped by game
server.get('/scores', async (req, res, next) => {
var games = await database.query(`SELECT DISTINCT game FROM scores`, { type: database.QueryTypes.SELECT });
var scoresByGames = {}
for (var i = 0; i < games.length; i++) {
scoresByGames[games[i].game] = await models.scores.findAll({ attributes: ["username", "score", "createdAt"], where: { game: { [Op.eq]: games[i].game } }, order: [['score', 'DESC']], limit: 15 }).map(x => x.get({ plain: true }))
};
res.status(200).send(scoresByGames);
})
// Gets a unique ID
server.get('/uuid', async (req, res) => {
var uuid;
while (true) {
uuid = uuidv4()
var result = await database.query(`SELECT uuid FROM scores where uuid = '${uuid}'`, { type: database.QueryTypes.SELECT });
if (result.length == 0) {
break;
}
}
res.status(200).send(uuid)
})
}
module.exports = {
listen,
setUpRoutes,
load
};
|
