diff options
| -rw-r--r-- | cgi/manage.py | 2 | ||||
| -rw-r--r-- | cgi/templates/manage/recent.html | 10 |
2 files changed, 5 insertions, 7 deletions
diff --git a/cgi/manage.py b/cgi/manage.py index f5b417e..7d569a1 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 WHERE posts.timestamp > UNIX_TIMESTAMP() - 86400 ORDER BY timestamp DESC") + 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, boards.name AS board_name 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': diff --git a/cgi/templates/manage/recent.html b/cgi/templates/manage/recent.html index 3fed05f..38d9a75 100644 --- a/cgi/templates/manage/recent.html +++ b/cgi/templates/manage/recent.html @@ -4,8 +4,6 @@ <div class="replymode">Lista de posts recientes</div> <table class="managertable"> <thead> - <th>ID</th> - <th>Board</th> <th>Archivo</th> <th>Timestamp</th> <th>Mensaje</th> @@ -15,8 +13,6 @@ <tbody> <?py for post in posts: ?> <tr> - <td>#{post['id']}</td> - <td>/#{post['dir']}/</td> <td> <?py if post['file']: ?><a href="/${post['dir']}/src/#{post['file']}" target="_blank"><img src="/${post['dir']}/mobile/${post['thumb']}" /></a> @@ -26,8 +22,9 @@ <div name="timestamp" data-ts="#{post['timestamp']}">#{post['timestamp_formatted']}</div> </td> <td> - <div style="display: block; margin-bottom: 0.5em; font-weight: bold;">#{post['subject']} <i>#{post['name']}</i> <code>#{post['email']}</code> - #{post['tripcode']} + <div class="recentPostHeader" style="display: block; margin-bottom: 0.5em;"> + #{post['id']} <b>#{post['subject']}</b> en <i>#{post['board_name']}</i></br> + <b>#{post['name']}</b> <code>#{post['email']} #{post['tripcode']}</code> </div> <div style="display: block">#{post['message']}</div> <?py if post['parentid'] != '0': ?> @@ -35,6 +32,7 @@ href="#{cgi_url}manage/mod/${post['dir']}?thread=#{post['parentid']}">Ver hilo completo</a> </div> <?py #endif ?> + <div name="timestamp" data-ts="#{post['timestamp']}">#{post['timestamp_formatted']}</div> </td> <td> <a href="#{cgi_url}manage/ipshow?ip=#{post['ip']}">#{post['ip']}</a> |