ovpnclients.dat: Convert timestamps into localtime.

Signed-off-by: Stefan Schantl <stefan.schantl@ipfire.org>
Signed-off-by: Arne Fitzenreiter <arne_f@ipfire.org>

diff --git a/html/cgi-bin/logs.cgi/ovpnclients.dat b/html/cgi-bin/logs.cgi/ovpnclients.dat
index 33d6d871768b3ee14508c6a86559c699e1f3c540..cf3e0e7bc06c3d25884edd408491408db61224ff 100755 (executable)
--- 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 (