summaryrefslogtreecommitdiff
path: root/lib/VNWeb/Misc
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-12-04 14:50:41 +0100
committerYorhel <git@yorhel.nl>2020-12-04 14:50:43 +0100
commit76a4f6c51e9e2a04f70a116cb48b62bdf4eb7bbe (patch)
tree333ee9431986da0109fd5861b712091e855a2bf2 /lib/VNWeb/Misc
parent93277e9450b096661a880aff5920a32ca38f7da8 (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.pm6
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';
};