summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-08-26 10:39:43 +0200
committerYorhel <git@yorhel.nl>2022-08-26 10:39:43 +0200
commit71afe313e98395fefc6528ef1fea69b799613310 (patch)
tree4aa8764a2da2238d93561e6b2ddf6013b38c06f6 /lib
parent007e7d1c6839c55f578a5db10c3536c12327f06b (diff)
SQL: Add formatting function for ipinfo values
Diffstat (limited to 'lib')
-rw-r--r--lib/VNWeb/Misc/Reports.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/Misc/Reports.pm b/lib/VNWeb/Misc/Reports.pm
index 9e2589e0..a031c76e 100644
--- a/lib/VNWeb/Misc/Reports.pm
+++ b/lib/VNWeb/Misc/Reports.pm
@@ -148,7 +148,7 @@ TUWF::get qr{/report/list}, sub {
my $cnt = tuwf->dbVali('SELECT count(*) FROM reports r WHERE', $where);
my $lst = tuwf->dbPagei({results => 25, page => $opt->{p}},
- 'SELECT r.id,', sql_totime('r.date'), 'as date, r.uid, ur.username, r.ip, r.reason, r.status, r.message, r.log
+ 'SELECT r.id,', sql_totime('r.date'), 'as date, r.uid, ur.username, fmtip(r.ip) as ip, r.reason, r.status, r.message, r.log
, r.object, r.objectnum, x.title, x.uid as by_uid,', sql_user('uo'), '
FROM reports r
LEFT JOIN item_info(r.object, r.objectnum) x ON true