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
|
import { Request, Response } from "express";
import { fiaTable, Helpers, makeQuery, tColors, waitForQueue } from "../../../helpers/helpersBack";
import startGame from "../startGame";
import { global } from "../index";
export default async function apiLogin(req: Request, res: Response) {
if (req.session === undefined) {
res.status(500);
res.send("");
return;
}
req.session.uid = req.session.id;
req.session.name = req.body.name;
if (global.stop === true) {
await waitForQueue();
}
global.stop = true;
let dbRes = (await makeQuery("SELECT * FROM `fia` WHERE `started`= 0 LIMIT 1", [])) as Array<fiaTable>,
row: fiaTable;
if (dbRes[0] === undefined) {
let color = Helpers.getRandomInt(0, 4);
row = {} as fiaTable;
row.data = [{
id: req.session.uid,
index: 0,
ready: false,
color: color,
name: req.body.name,
}];
req.session.color = color;
req.session.index = 0;
await makeQuery('INSERT INTO `fia`(`data`) VALUES (?)', [row.data]);
req.session.gid = (await makeQuery('SELECT `id` FROM `fia` WHERE `data`= ?', [row.data]))[0].id;
} else {
row = dbRes[0];
let playersColors: Array<tColors> = [],
colors = [...Array(4).keys()];
for (let playerData of row.data)
playersColors.push(playerData.color);
colors = colors.filter(el => !playersColors.includes(el));
let color = colors[Helpers.getRandomInt(0, colors.length)],
index = row.data.length;
row.data.push({
id: req.session.uid,
index: index,
ready: false,
color: color,
name: req.body.name,
});
req.session.gid = row.id;
req.session.index = index;
await makeQuery('UPDATE `fia` SET `data`= ? WHERE `id`= ?', [row.data, row.id]);
if (row.data.length >= 4)
startGame(req.session.gid);
}
await makeQuery("UPDATE `fia` SET `playersCount`=`playersCount`+1 WHERE `id`= ?", [req.session.gid]);
global.stop = false;
res.send(JSON.stringify({ data: row.data, uid: req.session.uid }));
}
|