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;

Impressum / About Us