From 4f227e1d0ad24aadfc7e1169e4f62f516ec62810 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Thu, 11 Jan 2024 18:23:06 +0100 Subject: Send chat message when a user leaves games by deleting their account. --- server.js | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'server.js') diff --git a/server.js b/server.js index 7006aab..aba9aa3 100644 --- a/server.js +++ b/server.js @@ -577,6 +577,10 @@ app.get("/delete-account", must_be_logged_in, function (req, res) { res.render("delete_account.pug", { user: req.user }) }) +const SQL_SELECT_GAME_ROLE_FOR_DELETED_USER = SQL(` + select game_id, role from players where user_id = ? and game_id in (select game_id from games where status <= 1) + `) + app.post("/delete-account", must_be_logged_in, function (req, res) { let password = req.body.password // Get full user record including password and salt @@ -584,6 +588,11 @@ app.post("/delete-account", must_be_logged_in, function (req, res) { let hash = hash_password(password, user.salt) if (hash !== user.password) return res.render("delete_account.pug", { user: req.user, flash: "Wrong password!" }) + + let list = SQL_SELECT_GAME_ROLE_FOR_DELETED_USER.all(req.user.user_id) + for (let item of list) + send_chat_message(item.game_id, null, null, `${user.name} (${item.role}) left the game.`) + SQL_DELETE_USER.run(req.user.user_id) return res.send("Goodbye!") }) -- cgit v1.2.3