From f147fbcd423310c1002b463bf27dbaad5a95c050 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Wed, 12 Mar 2008 22:44:22 +0100 Subject: [PATCH] Bugfix, also show boards with no threads --- NDWeb/Pages/Forum.pm | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/NDWeb/Pages/Forum.pm b/NDWeb/Pages/Forum.pm index d494b25..2696dd7 100644 --- a/NDWeb/Pages/Forum.pm +++ b/NDWeb/Pages/Forum.pm @@ -254,12 +254,13 @@ sub render_body { }else{ #List boards $BODY->param(Overview => 1); my $boards = $DBH->prepare(q{SELECT fcid,category,fb.fbid AS id,fb.board - ,count(NULLIF(COALESCE(fp.time > ftv.time,TRUE),FALSE)) AS unread + ,count(NULLIF(COALESCE(fp.fpid::BOOLEAN,FALSE) + AND COALESCE(fp.time > ftv.time,TRUE),FALSE)) AS unread ,date_trunc('seconds',max(fp.time)::timestamp) as last_post FROM forum_categories JOIN forum_boards fb USING (fcid) - JOIN forum_threads ft USING (fbid) - JOIN forum_posts fp USING (ftid) + LEFT OUTER JOIN forum_threads ft USING (fbid) + LEFT OUTER JOIN forum_posts fp USING (ftid) LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1) ftv USING (ftid) WHERE EXISTS (SELECT fbid FROM forum_access WHERE fbid = fb.fbid AND gid IN (SELECT groups($1))) GROUP BY fcid,category,fb.fbid, fb.board -- 2.39.2