diff options
author | Yorhel <git@yorhel.nl> | 2021-09-30 17:27:20 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-09-30 17:27:22 +0200 |
commit | d78d00e0622f631153ae650f26e882fdb6eed961 (patch) | |
tree | 0598b382610f0902600d75cfa51114508ad4b2a6 | |
parent | 64fe7331c1d6e3c217e20eff2512db4fe4e23d9b (diff) |
Keep an announcement on the homepage for at most 30 days
Instead of 60.
-rw-r--r-- | lib/VNWeb/Misc/HomePage.pm | 2 |
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' ); |