summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-12-02 10:50:39 +0100
committerYorhel <git@yorhel.nl>2022-12-02 10:50:41 +0100
commit4bfb246c93d41668ab8cd4221b0d645cfd43dd69 (patch)
treec2794e0506876cad8bced1e32c500994d8ea07d3 /sql
parent9d1c52b49f881188dbe6c0278ddb0fe0cdbb8a5b (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.sql2
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;