diff options
Diffstat (limited to 'database/sqlite/administration/useraccount.c')
| -rw-r--r-- | database/sqlite/administration/useraccount.c | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/database/sqlite/administration/useraccount.c b/database/sqlite/administration/useraccount.c index a989257..31d4af2 100644 --- a/database/sqlite/administration/useraccount.c +++ b/database/sqlite/administration/useraccount.c @@ -105,8 +105,8 @@ static xmlDoc *useracc_view(eurephiaCTX *ctx, unsigned int infoType, // Query the database, find the user defined in the user map uinf = sqlite_query_mapped(ctx, SQL_SELECT, - "SELECT users.username, users.activated, users.deactivated," - " users.last_accessed, users.uid," + "SELECT users.username, locdt(users.activated), locdt(users.deactivated)," + " locdt(users.last_accessed), users.uid," " (bl.username IS NOT NULL), opensess, logincount," " (at.attempts > 0)" " FROM openvpn_users users" @@ -181,7 +181,8 @@ static xmlDoc *useracc_view(eurephiaCTX *ctx, unsigned int infoType, // Extract certificate info qres = sqlite_query(ctx, "SELECT depth, lower(digest), common_name, organisation, email, " - " c.registered, c.certid, uc.accessprofile, access_descr," + " locdt(c.registered), c.certid," + " uc.accessprofile, access_descr," " fw_profile" " FROM openvpn_certificates c" " LEFT JOIN openvpn_usercerts uc ON (c.certid = uc.certid)" @@ -233,7 +234,8 @@ static xmlDoc *useracc_view(eurephiaCTX *ctx, unsigned int infoType, qres = sqlite_query(ctx, "SELECT llid, ll.certid,protocol,remotehost,remoteport,macaddr," " vpnipaddr, vpnipmask, sessionstatus, sessionkey," - " login, logout, session_duration, session_deleted," + " locdt(login), locdt(logout)," + " session_duration, locdt(session_deleted)," " bytes_sent, bytes_received, uicid, accessprofile," " access_descr, fw_profile, depth, lower(digest)," " common_name, organisation, email" @@ -308,7 +310,7 @@ static xmlDoc *useracc_view(eurephiaCTX *ctx, unsigned int infoType, xmlNode *atmpt = NULL; qres = sqlite_query(ctx, - "SELECT attempts, registered, last_attempt, atpid" + "SELECT attempts, locdt(registered), locdt(last_attempt), atpid" " FROM openvpn_attempts " " WHERE username = '%q'", username); @@ -342,7 +344,7 @@ static xmlDoc *useracc_view(eurephiaCTX *ctx, unsigned int infoType, xmlNode *atmpt = NULL; qres = sqlite_query(ctx, - "SELECT registered, last_accessed, blid" + "SELECT locdt(registered), locdt(last_accessed), blid" " FROM openvpn_blacklist " " WHERE username = '%q'", username); |