From 013319d7a4651d1708280f556e39c2f03839426a Mon Sep 17 00:00:00 2001 From: Maks Jopek Date: Sun, 25 Apr 2021 12:07:36 +0200 Subject: Almost going in a circle --- backend/ts/api/saveGameBoard.ts | 13 +++++++------ 1 file changed, 7 insertions(+), 6 deletions(-) (limited to 'backend/ts/api/saveGameBoard.ts') diff --git a/backend/ts/api/saveGameBoard.ts b/backend/ts/api/saveGameBoard.ts index 551c185..da31bdf 100644 --- a/backend/ts/api/saveGameBoard.ts +++ b/backend/ts/api/saveGameBoard.ts @@ -1,16 +1,17 @@ import { Request, Response } from "express"; -import { API_RES, makeQuery } from "../../../helpers/helpersBack"; +import { API_RES, makeQuery, nextTurnEndsAt } from "../../../helpers/helpersBack"; export default async function saveGameBoard(req: Request, res: Response) { - if(req.session === undefined || req.body.gameBoard === undefined) { + if (req.session === undefined || req.body.gameBoard === undefined) { res.status(400); res.send(API_RES.failure); return; } - await makeQuery("UPDATE `fia` SET `gameBoard` = ? WHERE `id` = ? ", [ - req.body.gameBoard, req.session.gid - ]); + let query = "UPDATE `fia` SET `currentPlayer` = IF(`currentPlayer` + 1 = `playersCount`, 0, `currentPlayer` + 1), " + + "`gameBoard` = ?, `timeTillTurnEnd` = ? WHERE `id` = ?" + await makeQuery(query, [req.body.gameBoard, nextTurnEndsAt(), req.session.gid]); res.send(API_RES.success); -} \ No newline at end of file +} +//UPDATE `fia` SET `currentPlayer` = IF( `currentPlayer` + 1 = `playersCount`, 0, `currentPlayer` + 1 ) WHERE `id` = 169 \ No newline at end of file -- cgit v1.3.1