liquid_feedback_core
changeset 106:4d121276bf04
Race condition fixed in "check_last_login"()
author | jbe |
---|---|
date | Sat Feb 05 16:18:07 2011 +0100 (2011-02-05) |
parents | 6bf35cfa3ba8 |
children | 53ae1d37e5de |
files | core.sql |
line diff
1.1 --- a/core.sql Sat Feb 05 16:06:19 2011 +0100 1.2 +++ b/core.sql Sat Feb 05 16:18:07 2011 +0100 1.3 @@ -2077,6 +2077,7 @@ 1.4 IF "system_setting_row"."member_ttl" NOTNULL THEN 1.5 UPDATE "member" SET "active" = FALSE 1.6 WHERE "active" = TRUE 1.7 + AND "last_login"::date < 'today' 1.8 AND "last_login_public" < 1.9 (now() - "system_setting_row"."member_ttl")::date; 1.10 END IF;