From 614db226d628c2eddd58ba4df1dcfb479bffcb41 Mon Sep 17 00:00:00 2001 From: citrons Date: Mon, 16 Jun 2025 21:25:05 -0500 Subject: last activity of forums based on update column (which percolates upward, unlike before) --- apioforum/forum.py | 8 ++------ 1 file changed, 2 insertions(+), 6 deletions(-) diff --git a/apioforum/forum.py b/apioforum/forum.py index 9d4a3cd..c3bf1c0 100644 --- a/apioforum/forum.py +++ b/apioforum/forum.py @@ -212,19 +212,15 @@ def view_forum(forum,page=1): subforums_rows = db.execute(""" - SELECT max(threads.updated) as updated, forums.* FROM forums - LEFT OUTER JOIN threads ON threads.forum=forums.id + SELECT * FROM forums WHERE parent = ? AND unlisted = 0 - GROUP BY forums.id - ORDER BY forums.updated DESC + ORDER BY updated DESC """,(forum['id'],)).fetchall() unread_subforums = [] read_subforums = [] for s in subforums_rows: a={} a.update(s) - if a['updated'] is not None: - a['updated'] = datetime.datetime.fromisoformat(a['updated']) if has_permission(a['id'],g.user,"p_view_forum",login_required=False): if not read.is_read('forum', a['id']): unread_subforums.append(a) -- cgit v1.2.3