diff options
author | Yorhel <git@yorhel.nl> | 2020-09-20 08:23:24 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-09-20 08:23:24 +0200 |
commit | 509f0efc1ab11c187bc4b35980abd692306a6697 (patch) | |
tree | 6cd9af12b6b85114c1dc4ff10cfdf4cb476b255f | |
parent | 76181a765d26e6ddb27bdd6987ee1a436df2ff47 (diff) |
Hide flagged reviews from the home page
-rw-r--r-- | lib/VNWeb/Misc/HomePage.pm | 3 |
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 { |