summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-09-30 17:27:20 +0200
committerYorhel <git@yorhel.nl>2021-09-30 17:27:22 +0200
commitd78d00e0622f631153ae650f26e882fdb6eed961 (patch)
tree0598b382610f0902600d75cfa51114508ad4b2a6
parent64fe7331c1d6e3c217e20eff2512db4fe4e23d9b (diff)
Keep an announcement on the homepage for at most 30 days
Instead of 60.
-rw-r--r--lib/VNWeb/Misc/HomePage.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/Misc/HomePage.pm b/lib/VNWeb/Misc/HomePage.pm
index 0c2b409d..97d4b63b 100644
--- a/lib/VNWeb/Misc/HomePage.pm
+++ b/lib/VNWeb/Misc/HomePage.pm
@@ -70,7 +70,7 @@ sub recent_db_posts_ {
FROM threads t
JOIN threads_boards tb ON tb.tid = t.id AND tb.type = \'an\'
JOIN threads_posts tp ON tp.tid = t.id AND tp.num = 1
- WHERE NOT t.hidden AND NOT t.private AND tp.date >', sql_fromtime(time-2*30*24*3600), '
+ WHERE NOT t.hidden AND NOT t.private AND tp.date >', sql_fromtime(time-30*24*3600), '
ORDER BY tb.tid DESC
LIMIT 1+1'
);