From 1242cb0134ee9008b613a56957dbf7fe3f4b6b3d Mon Sep 17 00:00:00 2001 From: Stefan Schantl Date: Mon, 13 Apr 2020 09:45:39 +0200 Subject: [PATCH] ovpnclients.dat: Convert timestamps into localtime. Signed-off-by: Stefan Schantl Signed-off-by: Arne Fitzenreiter --- html/cgi-bin/logs.cgi/ovpnclients.dat | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/html/cgi-bin/logs.cgi/ovpnclients.dat b/html/cgi-bin/logs.cgi/ovpnclients.dat index 33d6d87176..cf3e0e7bc0 100755 --- a/html/cgi-bin/logs.cgi/ovpnclients.dat +++ b/html/cgi-bin/logs.cgi/ovpnclients.dat @@ -123,7 +123,7 @@ my $database_query = qq( if ($cgiparams{'CONNECTION_NAME'}) { $database_query = qq( - SELECT * FROM sessions + SELECT common_name, DATETIME(connected_at, 'localtime'), DATETIME(disconnected_at, 'localtime'), bytes_received, bytes_sent FROM sessions WHERE common_name = '$cgiparams{"CONNECTION_NAME"}' AND ( -- 2.39.2