aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLibravatar bai 2020-07-28 05:42:39 -0400
committerLibravatar bai 2020-07-28 05:42:39 -0400
commitf71a7d75ddc0725fe15ae78ec44d54f69b32d771 (patch)
tree61e8801461598d10449843ceb78a709d8c9b6be4
parent109f8e55385fa37946fa7ad0ac90cc87d738a72c (diff)
downloadweabot-f71a7d75ddc0725fe15ae78ec44d54f69b32d771.tar.gz
weabot-f71a7d75ddc0725fe15ae78ec44d54f69b32d771.tar.xz
weabot-f71a7d75ddc0725fe15ae78ec44d54f69b32d771.zip
Arreglados IPs en manage->recycle bin
-rw-r--r--cgi/manage.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/cgi/manage.py b/cgi/manage.py
index f21e7e8..61cf95e 100644
--- a/cgi/manage.py
+++ b/cgi/manage.py
@@ -1117,7 +1117,7 @@ def manage(self, path_split):
# Table
if 'board' in self.formdata.keys() and self.formdata['board'] != 'all':
cboard = self.formdata['board']
- posts = FetchAll("SELECT posts.id, posts.timestamp, timestamp_formatted, IS_DELETED, INET6_NTOA(posts.ip) as ip, posts.message, dir, boardid FROM `posts` INNER JOIN `boards` ON boardid = boards.id WHERE `dir` = '%s' AND IS_DELETED %s ORDER BY `timestamp` DESC LIMIT %d, %d" % (
+ posts = FetchAll("SELECT posts.id, posts.timestamp, timestamp_formatted, IS_DELETED, INET6_NTOA(posts.ip) AS ip, posts.message, dir, boardid FROM `posts` INNER JOIN `boards` ON boardid = boards.id WHERE `dir` = '%s' AND IS_DELETED %s ORDER BY `timestamp` DESC LIMIT %d, %d" % (
_mysql.escape_string(self.formdata['board']), _mysql.escape_string(type_condition), currentpage*pagesize, pagesize))
try:
totals = FetchOne("SELECT COUNT(id) FROM `posts` WHERE IS_DELETED %s AND `boardid` = %s" % (
@@ -1126,7 +1126,7 @@ def manage(self, path_split):
skip = True
else:
cboard = 'all'
- posts = FetchAll("SELECT posts.id, posts.timestamp, timestamp_formatted, IS_DELETED, posts.ip, posts.message, dir FROM `posts` INNER JOIN `boards` ON boardid = boards.id WHERE IS_DELETED %s ORDER BY `timestamp` DESC LIMIT %d, %d" % (
+ posts = FetchAll("SELECT posts.id, posts.timestamp, timestamp_formatted, IS_DELETED, INET6_NTOA(posts.ip) AS ip, posts.message, dir FROM `posts` INNER JOIN `boards` ON boardid = boards.id WHERE IS_DELETED %s ORDER BY `timestamp` DESC LIMIT %d, %d" % (
_mysql.escape_string(type_condition), currentpage*pagesize, pagesize))
totals = FetchOne("SELECT COUNT(id) FROM `posts` WHERE IS_DELETED %s" %
_mysql.escape_string(type_condition), 0)