Mostrar posts de las ultimas 24 hrs

1 files changed, 1 insertions, 1 deletions

diff --git a/cgi/manage.py b/cgi/manage.py
index 776747e..f5b417e 100644
--- a/cgi/manage.py
+++ b/cgi/manage.py
@@ -159,7 +159,7 @@ def manage(self, path_split):
           template_filename = "mod.html"
           template_values = {"mode": 2, "dir": board["dir"], "threads": threads}
       elif path_split[2] == "recent":
-          posts = FetchAll("SELECT posts.id, posts.subject, dir, parentid, file, thumb, timestamp_formatted, timestamp, posts.message, INET_NTOA(ip) AS ip, posts.name, email,  tripcode FROM posts INNER JOIN boards ON posts.boardid = boards.id ORDER BY timestamp DESC LIMIT 50")
+          posts = FetchAll("SELECT posts.id, posts.subject, dir, parentid, file, thumb, timestamp_formatted, timestamp, posts.message, INET_NTOA(ip) AS ip, posts.name, email,  tripcode FROM posts INNER JOIN boards ON posts.boardid = boards.id WHERE posts.timestamp > UNIX_TIMESTAMP() - 86400 ORDER BY timestamp DESC")
           template_filename = "recent.html"
           template_values = {"posts": posts}
       elif path_split[2] == 'staff':