diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-09-19 14:25:08 +0200 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-09-19 14:25:08 +0200 |
| commit | d28d39cabd55b3de3258dabd3fbefe1976dc1bc1 (patch) | |
| tree | ecb5090a5f3994875fef668d39030ef5ff176095 /database/sqlite/eurephiadb-sqlite.c | |
| parent | 8b2c60cee562ed98596a228750f10f735725ac11 (diff) | |
| download | eurephia-d28d39cabd55b3de3258dabd3fbefe1976dc1bc1.tar.gz eurephia-d28d39cabd55b3de3258dabd3fbefe1976dc1bc1.tar.xz eurephia-d28d39cabd55b3de3258dabd3fbefe1976dc1bc1.zip | |
Added (untested) logging of time_duration into openvpn_lastlog.session_duration
Diffstat (limited to 'database/sqlite/eurephiadb-sqlite.c')
| -rw-r--r-- | database/sqlite/eurephiadb-sqlite.c | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/database/sqlite/eurephiadb-sqlite.c b/database/sqlite/eurephiadb-sqlite.c index f566320..67b22f4 100644 --- a/database/sqlite/eurephiadb-sqlite.c +++ b/database/sqlite/eurephiadb-sqlite.c @@ -581,7 +581,7 @@ int eDBregister_vpnmacaddr(eurephiaCTX *ctx, eurephiaSESSION *session, const cha // Register the user as logged out int eDBregister_logout(eurephiaCTX *ctx, eurephiaSESSION *skey, - const char *bytes_sent, const char *bytes_received) + const char *bytes_sent, const char *bytes_received, const char *duration) { dbresult *res = NULL; @@ -592,9 +592,10 @@ int eDBregister_logout(eurephiaCTX *ctx, eurephiaSESSION *skey, res = sqlite_query(ctx, "UPDATE openvpn_lastlog " " SET sessionstatus = 3, logout = CURRENT_TIMESTAMP, " - " bytes_sent = '%i', bytes_received = '%i' " + " bytes_sent = '%i', bytes_received = '%i', session_duration = '%i' " " WHERE sessionkey = '%q' AND sessionstatus = 2", - atoi_nullsafe(bytes_sent), atoi_nullsafe(bytes_received), skey->sessionkey); + atoi_nullsafe(bytes_sent), atoi_nullsafe(bytes_received), + atoi_nullsafe(duration), skey->sessionkey); if( res == NULL ) { eurephia_log(ctx, LOG_CRITICAL, 0, "Could not update lastlog with logout information (%s)", skey->sessionkey); |