diff options
author | David Sommerseth <dazo@users.sourceforge.net> | 2012-10-07 16:50:42 +0200 |
---|---|---|
committer | David Sommerseth <dazo@users.sourceforge.net> | 2012-10-08 02:18:14 +0200 |
commit | 3af4f9b2bacfc8383001bba95c4f3836a6cecca6 (patch) | |
tree | 7138162c2b371f2a1743b9cafc64fb5ed9a3f855 /database/sqlite/administration/firewalladmin.c | |
parent | 79b7a8c5ad5d4de6fc69d71585625b8a74198c47 (diff) | |
download | eurephia-3af4f9b2bacfc8383001bba95c4f3836a6cecca6.tar.gz eurephia-3af4f9b2bacfc8383001bba95c4f3836a6cecca6.tar.xz eurephia-3af4f9b2bacfc8383001bba95c4f3836a6cecca6.zip |
sqlite/admin: Report all timestamp fields with localtime instead of UTC/GMT
Made all SELECT queries which is used for reports to use the new 'locdt' SQL
function on timestamp fields. This converts the UTC/GMT timestamps stored in
the database to the correct timezone of the running admin client.
Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
Diffstat (limited to 'database/sqlite/administration/firewalladmin.c')
-rw-r--r-- | database/sqlite/administration/firewalladmin.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sqlite/administration/firewalladmin.c b/database/sqlite/administration/firewalladmin.c index fd34183..b10c5d0 100644 --- a/database/sqlite/administration/firewalladmin.c +++ b/database/sqlite/administration/firewalladmin.c @@ -81,7 +81,7 @@ xmlDoc *fwadmin_search(eurephiaCTX *ctx, eDBfieldMap *fmap) { "SELECT access_descr, fw_profile, accessprofile, " " uid, username, " " uac.certid, common_name, organisation, " - " email, lower(digest), c.registered, uicid " + " email, lower(digest), locdt(c.registered), uicid " " FROM openvpn_accesses" " LEFT JOIN openvpn_usercerts uac USING (accessprofile)" " LEFT JOIN openvpn_users USING (uid)" |