From 126fd50f95bca07514d7cdebe6d4bfc5a585693b Mon Sep 17 00:00:00 2001
From: Renard
Date: Tue, 21 Jul 2020 22:24:19 -0400
Subject: Mod API: Query fix

---
 cgi/modapi.py | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'cgi')

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')
-- 
cgit v1.2.1-18-gbd029