diff options
Diffstat (limited to 'apioforum/forum.py')
| -rw-r--r-- | apioforum/forum.py | 8 |
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) |