Fossil SCM
In the previous check-in, fix the subscriber count after doing a purge.
Commit
8ccab68fc6f679d16f657660be3eb709c7494c85c00715701dac944559b99a19
Parent
8c40c38f5e52566…
1 file changed
+1
+1
| --- src/alerts.c | ||
| +++ src/alerts.c | ||
| @@ -1988,10 +1988,11 @@ | ||
| 1988 | 1988 | ); |
| 1989 | 1989 | nNewPending = db_int(0, "SELECT count(*) FROM subscriber" |
| 1990 | 1990 | " WHERE NOT sverified"); |
| 1991 | 1991 | nDel = nPending - nNewPending; |
| 1992 | 1992 | nPending = nNewPending; |
| 1993 | + nTotal -= nDel; | |
| 1993 | 1994 | } |
| 1994 | 1995 | if( nPending>0 ){ |
| 1995 | 1996 | @ <h1>%,d(nTotal) Subscribers, %,d(nPending) Pending</h1> |
| 1996 | 1997 | if( nDel==0 && 0<db_int(0,"SELECT count(*) FROM subscriber" |
| 1997 | 1998 | " WHERE NOT sverified AND mtime<0+strftime('%%s','now','-1 day')") |
| 1998 | 1999 |
| --- src/alerts.c | |
| +++ src/alerts.c | |
| @@ -1988,10 +1988,11 @@ | |
| 1988 | ); |
| 1989 | nNewPending = db_int(0, "SELECT count(*) FROM subscriber" |
| 1990 | " WHERE NOT sverified"); |
| 1991 | nDel = nPending - nNewPending; |
| 1992 | nPending = nNewPending; |
| 1993 | } |
| 1994 | if( nPending>0 ){ |
| 1995 | @ <h1>%,d(nTotal) Subscribers, %,d(nPending) Pending</h1> |
| 1996 | if( nDel==0 && 0<db_int(0,"SELECT count(*) FROM subscriber" |
| 1997 | " WHERE NOT sverified AND mtime<0+strftime('%%s','now','-1 day')") |
| 1998 |
| --- src/alerts.c | |
| +++ src/alerts.c | |
| @@ -1988,10 +1988,11 @@ | |
| 1988 | ); |
| 1989 | nNewPending = db_int(0, "SELECT count(*) FROM subscriber" |
| 1990 | " WHERE NOT sverified"); |
| 1991 | nDel = nPending - nNewPending; |
| 1992 | nPending = nNewPending; |
| 1993 | nTotal -= nDel; |
| 1994 | } |
| 1995 | if( nPending>0 ){ |
| 1996 | @ <h1>%,d(nTotal) Subscribers, %,d(nPending) Pending</h1> |
| 1997 | if( nDel==0 && 0<db_int(0,"SELECT count(*) FROM subscriber" |
| 1998 | " WHERE NOT sverified AND mtime<0+strftime('%%s','now','-1 day')") |
| 1999 |