X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FForum.pm;h=f06848de982c5e8da0391b5c27ec3bf5ae9733ab;hp=bf7dc3ca8f11b76788ef52aa4cc8bbc2b4e72582;hb=aa93c4baf476e9fa421e1a5ce0d97e9527d33417;hpb=612f5232bc9d8966b209da8f04cf0fb5619f867e

diff --git a/lib/NDWeb/Controller/Forum.pm b/lib/NDWeb/Controller/Forum.pm
index bf7dc3c..f06848d 100644
--- a/lib/NDWeb/Controller/Forum.pm
+++ b/lib/NDWeb/Controller/Forum.pm
@@ -73,7 +73,8 @@ FROM forum_categories fc
 	JOIN users u ON u.uid = ft.uid
 	LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1)
 		ftv ON ftv.ftid = ft.ftid
-WHERE COALESCE(ft.mtime > ftv.time,TRUE)
+WHERE ft.mtime > NOW() - '50 days'::interval
+	AND COALESCE(ft.mtime > ftv.time,TRUE)
 	AND ft.ftid IN (SELECT ftid FROM forum_posts WHERE ftid = ft.ftid)
 	AND ((fbid > 0 AND
 			fb.fbid IN (SELECT fbid FROM forum_access WHERE gid IN (SELECT groups($1))))