From mboxrd@z Thu Jan 1 00:00:00 1970 From: Stefan Schantl To: development@lists.ipfire.org Subject: [PATCH 08/19] ovpnclients.dat: Convert timestamps into localtime. Date: Mon, 13 Apr 2020 09:45:39 +0200 Message-ID: <20200413074550.2735-8-stefan.schantl@ipfire.org> In-Reply-To: <20200413074550.2735-1-stefan.schantl@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4274908987662593414==" List-Id: --===============4274908987662593414== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Signed-off-by: Stefan Schantl --- 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/ov= pnclients.dat index 33d6d8717..cf3e0e7bc 100755 --- a/html/cgi-bin/logs.cgi/ovpnclients.dat +++ b/html/cgi-bin/logs.cgi/ovpnclients.dat @@ -123,7 +123,7 @@ my $database_query =3D qq( =20 if ($cgiparams{'CONNECTION_NAME'}) { $database_query =3D qq( - SELECT * FROM sessions + SELECT common_name, DATETIME(connected_at, 'localtime'), DATETIME(disconne= cted_at, 'localtime'), bytes_received, bytes_sent FROM sessions WHERE common_name =3D '$cgiparams{"CONNECTION_NAME"}' AND ( --=20 2.26.0 --===============4274908987662593414==--