diff options
author | Yorhel <git@yorhel.nl> | 2022-12-02 10:50:39 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-12-02 10:50:41 +0100 |
commit | 4bfb246c93d41668ab8cd4221b0d645cfd43dd69 (patch) | |
tree | c2794e0506876cad8bced1e32c500994d8ea07d3 /sql | |
parent | 9d1c52b49f881188dbe6c0278ddb0fe0cdbb8a5b (diff) |
API2: Also update last used date on first use
So it doesn't show "never used" for tokens used on the same day as
creation.
Diffstat (limited to 'sql')
-rw-r--r-- | sql/func.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/func.sql b/sql/func.sql index e2d7a5d4..09df64d2 100644 --- a/sql/func.sql +++ b/sql/func.sql @@ -756,7 +756,7 @@ CREATE OR REPLACE FUNCTION user_validate_session(vndbid, bytea, session_type) RE -- Update last use date for api2 sessions UPDATE sessions SET expires = NOW() WHERE uid = $1 AND token = $2 AND type = $3 AND $3 = 'api2' - AND expires::date < 'today'::date; + AND (expires = added OR expires::date < 'today'::date); SELECT * FROM sessions WHERE uid = $1 AND token = $2 AND type = $3 $$ LANGUAGE SQL SECURITY DEFINER; |