From: Michael Andreen <harv@ruin.nu>
Date: Tue, 23 Jun 2020 11:12:55 +0000 (+0200)
Subject: No need to show old sticky announcements on main page anymore
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=48df392b0817ea813443309eecc5949550095155

No need to show old sticky announcements on main page anymore
---

diff --git a/lib/NDWeb/Controller/Members.pm b/lib/NDWeb/Controller/Members.pm
index b885745..33fdc5c 100644
--- a/lib/NDWeb/Controller/Members.pm
+++ b/lib/NDWeb/Controller/Members.pm
@@ -78,7 +78,7 @@ ORDER BY landing_tick DESC
 			LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1) ftv ON ftv.ftid = ft.ftid
 		WHERE ft.fbid = 1
 		GROUP BY ft.ftid, ft.subject,ft.sticky,u.username
-		HAVING count(NULLIF(COALESCE(ft.sticky OR fp.time > ftv.time,TRUE),FALSE)) >= 1
+		HAVING count(NULLIF(COALESCE(fp.time > ftv.time,TRUE),FALSE)) >= 1
 		ORDER BY sticky DESC,last_post DESC
 		});
 	$announcements->execute($c->user->id);