summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-09-20 08:23:24 +0200
committerYorhel <git@yorhel.nl>2020-09-20 08:23:24 +0200
commit509f0efc1ab11c187bc4b35980abd692306a6697 (patch)
tree6cd9af12b6b85114c1dc4ff10cfdf4cb476b255f
parent76181a765d26e6ddb27bdd6987ee1a436df2ff47 (diff)
Hide flagged reviews from the home page
-rw-r--r--lib/VNWeb/Misc/HomePage.pm3
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/VNWeb/Misc/HomePage.pm b/lib/VNWeb/Misc/HomePage.pm
index f71d776b..2ad4f85b 100644
--- a/lib/VNWeb/Misc/HomePage.pm
+++ b/lib/VNWeb/Misc/HomePage.pm
@@ -170,7 +170,7 @@ sub reviews_ {
FROM reviews w
JOIN vn v ON v.id = w.vid
LEFT JOIN users u ON u.id = w.uid
- WHERE ', $full ? '' : 'NOT', 'w.isfull
+ WHERE NOT w.c_flagged AND', $full ? '' : 'NOT', 'w.isfull
ORDER BY w.id DESC LIMIT 10'
);
h1_ sub {
@@ -194,6 +194,7 @@ sub recent_comments_ {
JOIN reviews_posts wp ON wp.id = w.id AND wp.num = w.c_lastnum
JOIN vn v ON v.id = w.vid
LEFT JOIN users u ON u.id = wp.uid
+ WHERE NOT w.c_flagged
ORDER BY wp.date DESC LIMIT 10'
);
h1_ sub {