From 2f7bc2a8e8daf338621736b78916f07af254ba68 Mon Sep 17 00:00:00 2001 From: TOW Date: Fri, 29 Mar 2019 09:04:27 -0300 Subject: api/last debiera retornar todos los Ășltimos posts --- cgi/api.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'cgi') diff --git a/cgi/api.py b/cgi/api.py index 8960578..86ada3a 100644 --- a/cgi/api.py +++ b/cgi/api.py @@ -72,7 +72,7 @@ def api_process(self, path_split): if limit > 50: raise APIError, "Maximum limit is 50" - sql = "SELECT posts.id, boards.dir, timestamp, timestamp_formatted, posts.name, tripcode, email, posts.subject, posts.message, file, file_size, image_height, image_width, thumb, thumb_width, thumb_height, parentid FROM posts INNER JOIN boards ON boardid = boards.id WHERE timestamp > %d AND IS_DELETED = 0 AND email NOT LIKE '%%sage%%' AND boards.secret = 0 ORDER BY timestamp DESC LIMIT %d" % (since, limit) + sql = "SELECT posts.id, boards.dir, timestamp, timestamp_formatted, posts.name, tripcode, email, posts.subject, posts.message, file, file_size, image_height, image_width, thumb, thumb_width, thumb_height, parentid FROM posts INNER JOIN boards ON boardid = boards.id WHERE timestamp > %d AND IS_DELETED = 0 AND boards.secret = 0 ORDER BY timestamp DESC LIMIT %d" % (since, limit) values['posts'] = FetchAll(sql) for post in values['posts']: -- cgit v1.2.1-18-gbd029