diff options
Diffstat (limited to 'database/sqlite/edb-sqlite.c')
| -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'. " |