diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-08 00:34:17 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-08 03:24:08 +0100 |
| commit | 728053f727acc080a01c8b34ddb21ca740e926e7 (patch) | |
| tree | db25f2bd6f56e5286ecf96fa6666741ba911d3ef /database/sqlite | |
| parent | 596fb6394eb21a879bc7d4dc7f8ac4351a9bd163 (diff) | |
| download | eurephia-728053f727acc080a01c8b34ddb21ca740e926e7.tar.gz eurephia-728053f727acc080a01c8b34ddb21ca740e926e7.tar.xz eurephia-728053f727acc080a01c8b34ddb21ca740e926e7.zip | |
edb-sqlite: Update openvpn_users.last_accessed = now() on successful login
Diffstat (limited to 'database/sqlite')
| -rw-r--r-- | database/sqlite/edb-sqlite.c | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/database/sqlite/edb-sqlite.c b/database/sqlite/edb-sqlite.c index 4f4e486..27897f1 100644 --- a/database/sqlite/edb-sqlite.c +++ b/database/sqlite/edb-sqlite.c @@ -289,7 +289,20 @@ int eDBauth_user(eurephiaCTX *ctx, const int certid, const char *username, const uicid = -1; } else { + dbresult *upd = NULL; + uicid = atoi_nullsafe(sqlite_get_value(res, 0, 0)); + + // Update last accessed status + upd = sqlite_query(ctx, + "UPDATE openvpn_users SET last_accessed = CURRENT_TIMESTAMP" + " WHERE uid = %i", uid); + if( upd == NULL ) { + eurephia_log(ctx, LOG_ERROR, 0, + "Could not update last access status for uid %i", uid); + } else { + sqlite_free_results(upd); + } } } else { eurephia_log(ctx, LOG_WARNING, 0, "Authentication failed for user '%s'. " |