]> ruin.nu Git - ndwebbie.git/commitdiff
No need to show old sticky announcements on main page anymore
authorMichael Andreen <harv@ruin.nu>
Tue, 23 Jun 2020 11:12:55 +0000 (13:12 +0200)
committerMichael Andreen <harv@ruin.nu>
Tue, 23 Jun 2020 11:12:55 +0000 (13:12 +0200)
lib/NDWeb/Controller/Members.pm

index b88574505f2f2e677794889564e97c268fbc7c3b..33fdc5cb61243710e476d5822e7fb81faf75135d 100644 (file)
@@ -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);