last activity of forums based on update column

(which percolates upward, unlike before)

1 files 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)