diff options
author | Yorhel <git@yorhel.nl> | 2020-12-04 14:50:41 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-12-04 14:50:43 +0100 |
commit | 76a4f6c51e9e2a04f70a116cb48b62bdf4eb7bbe (patch) | |
tree | 333ee9431986da0109fd5861b712091e855a2bf2 /lib/VNWeb/Misc | |
parent | 93277e9450b096661a880aff5920a32ca38f7da8 (diff) |
HomePage: Include general discussions in "VN discussions" box
Totally forgot we had that section. https://vndb.org/t950.865
Diffstat (limited to 'lib/VNWeb/Misc')
-rw-r--r-- | lib/VNWeb/Misc/HomePage.pm | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/lib/VNWeb/Misc/HomePage.pm b/lib/VNWeb/Misc/HomePage.pm index ba1dedad..044303bb 100644 --- a/lib/VNWeb/Misc/HomePage.pm +++ b/lib/VNWeb/Misc/HomePage.pm @@ -115,7 +115,7 @@ sub recent_vn_posts_ { SELECT t.id, t.title, tp.num, tp.date, tp.uid FROM threads t JOIN threads_posts tp ON tp.tid = t.id AND tp.num = t.c_lastnum - WHERE EXISTS(SELECT 1 FROM threads_boards tb WHERE tb.tid = t.id AND tb.type IN(\'v\',\'p\')) + WHERE EXISTS(SELECT 1 FROM threads_boards tb WHERE tb.tid = t.id AND tb.type IN(\'v\',\'p\',\'ge\')) AND NOT t.hidden AND NOT t.private ORDER BY tp.date DESC LIMIT 10 ), wposts (id,title,num,date,uid) AS ( @@ -134,9 +134,7 @@ sub recent_vn_posts_ { ); enrich_boards undef, $lst; p_ class => 'mainopts', sub { - a_ href => '/t/v', 'VNs'; - b_ class => 'grayedout', '&'; - a_ href => '/t/p', 'Producers'; + a_ href => '/t/all', 'Forums'; b_ class => 'grayedout', '&'; a_ href => '/w?o=d&s=lastpost', 'Reviews'; }; |