diff options
| author |  Renard
| 2020-07-21 22:24:19 -0400 |
|---|---|---|
| committer | Renard
| 2020-07-21 22:24:19 -0400 |
| commit | 126fd50f95bca07514d7cdebe6d4bfc5a585693b (patch) | |
| tree | fad877c98b1a74de2883aab69684e4eb1f01388d | |
| parent | 5a9699fed69e7c302d6363d2a81039477554c739 (diff) | |
| download | weabot-126fd50f95bca07514d7cdebe6d4bfc5a585693b.tar.gz weabot-126fd50f95bca07514d7cdebe6d4bfc5a585693b.tar.xz weabot-126fd50f95bca07514d7cdebe6d4bfc5a585693b.zip | |
Mod API: Query fix
| -rw-r--r-- | cgi/modapi.py | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/cgi/modapi.py b/cgi/modapi.py index 00b4beb..0d082e9 100644 --- a/cgi/modapi.py +++ b/cgi/modapi.py @@ -62,9 +62,8 @@ def api_process(self, path_split): values['news'] = news elif method == 'reports': reports = FetchAll( - "SELECT * FROM `reports` ORDER BY `timestamp` DESC") + "SELECT id, timestamp, timestamp_formatted, postid, parentid, link, board, INET6_NTOA(ip) AS ip, reason, INET6_NTOA(repip) AS repip FROM `reports` ORDER BY `timestamp` DESC") values['reports'] = reports - values['keys'] = reports[0].keys() elif method == 'login': # testing username = formdata.get('username') |