X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Ffunctions%2Funread_posts.sql;h=12a69ae3e6a6dba2373317826fb5219a7b62793b;hp=9c0023a2969084a0d6cc2ec36655201f8e57ec33;hb=aa93c4baf476e9fa421e1a5ce0d97e9527d33417;hpb=612f5232bc9d8966b209da8f04cf0fb5619f867e

diff --git a/database/functions/unread_posts.sql b/database/functions/unread_posts.sql
index 9c0023a..12a69ae 100644
--- a/database/functions/unread_posts.sql
+++ b/database/functions/unread_posts.sql
@@ -7,7 +7,8 @@ FROM(
 	FROM forum_threads ft
 		LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1)
 			ftv USING (ftid)
-	WHERE COALESCE(ft.mtime > ftv.time,TRUE)
+	WHERE ft.mtime > NOW() - '50 days'::interval
+		AND COALESCE(ft.mtime > ftv.time,TRUE)
 		AND ((fbid > 0 AND
 				fbid IN (SELECT fbid FROM forum_access WHERE gid IN (SELECT groups($1)))
 			) OR ft.ftid IN (SELECT ftid FROM forum_priv_access WHERE uid = $1)