From e31c35899acf1c7e18ca54cf70ce3c06ef6a2d9f Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Wed, 5 Apr 2023 19:36:37 +0200 Subject: Remove chat log pages. The unread chat badge in the game lists should be enough. --- server.js | 13 ------------- 1 file changed, 13 deletions(-) (limited to 'server.js') diff --git a/server.js b/server.js index 48fa9ce..ef62317 100644 --- a/server.js +++ b/server.js @@ -657,16 +657,6 @@ app.get('/users', function (req, res) { res.render('user_list.pug', { user: req.user, user_list: rows }) }) -app.get('/chat', must_be_logged_in, function (req, res) { - let chat = SQL_SELECT_USER_CHAT_N.all(req.user.user_id, 12*20) - res.render('chat.pug', { user: req.user, chat: chat, page_size: 12 }) -}) - -app.get('/chat/all', must_be_logged_in, function (req, res) { - let chat = SQL_SELECT_USER_CHAT.all(req.user.user_id) - res.render('chat.pug', { user: req.user, chat: chat, page_size: 0 }) -}) - /* * CONTACTS */ @@ -1099,9 +1089,6 @@ load_rules() const SQL_INSERT_GAME = SQL("INSERT INTO games (owner_id,title_id,scenario,options,is_private,is_random,description) VALUES (?,?,?,?,?,?,?)") const SQL_DELETE_GAME = SQL("DELETE FROM games WHERE game_id=? AND owner_id=?") -const SQL_SELECT_USER_CHAT = SQL("SELECT game_id,unixepoch(time),name,message FROM game_chat_view WHERE game_id IN ( SELECT DISTINCT game_id FROM players WHERE user_id=? ) ORDER BY chat_id DESC").raw() -const SQL_SELECT_USER_CHAT_N = SQL("SELECT game_id,unixepoch(time),name,message FROM game_chat_view WHERE game_id IN ( SELECT DISTINCT game_id FROM players WHERE user_id=? ) ORDER BY chat_id DESC LIMIT ?").raw() - const SQL_SELECT_UNREAD_CHAT_GAMES = SQL("select game_id from unread_chats where user_id = ?").pluck() const SQL_INSERT_UNREAD_CHAT = SQL("insert or ignore into unread_chats (user_id,game_id) values (?,?)") const SQL_DELETE_UNREAD_CHAT = SQL("delete from unread_chats where user_id = ? and game_id = ?") -- cgit v1.2.3