Fossil SCM
Show the number of pending subscriptions in the subscription stats.
Commit
02ad349134614040b040599d675375b41cfa0998dc9610c50685a3162011df5a
Parent
e5653a4ceb9049b…
1 file changed
+1
-1
+1
-1
| --- src/stat.c | ||
| +++ src/stat.c | ||
| @@ -112,11 +112,11 @@ | ||
| 112 | 112 | @ <tr><th>Subscribers:</th><td> |
| 113 | 113 | } |
| 114 | 114 | nSub = db_int(0, "SELECT count(*) FROM subscriber"); |
| 115 | 115 | nASub = db_int(0, "SELECT count(*) FROM subscriber WHERE sverified" |
| 116 | 116 | " AND NOT sdonotcall AND length(ssub)>1"); |
| 117 | - @ %,d(nASub) active, %,d(nSub) total | |
| 117 | + @ %,d(nASub) active, %,d(nSub-nASub) pending, %,d(nSub) total | |
| 118 | 118 | @ </td></tr> |
| 119 | 119 | } |
| 120 | 120 | |
| 121 | 121 | /* |
| 122 | 122 | ** WEBPAGE: stat |
| 123 | 123 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -112,11 +112,11 @@ | |
| 112 | @ <tr><th>Subscribers:</th><td> |
| 113 | } |
| 114 | nSub = db_int(0, "SELECT count(*) FROM subscriber"); |
| 115 | nASub = db_int(0, "SELECT count(*) FROM subscriber WHERE sverified" |
| 116 | " AND NOT sdonotcall AND length(ssub)>1"); |
| 117 | @ %,d(nASub) active, %,d(nSub) total |
| 118 | @ </td></tr> |
| 119 | } |
| 120 | |
| 121 | /* |
| 122 | ** WEBPAGE: stat |
| 123 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -112,11 +112,11 @@ | |
| 112 | @ <tr><th>Subscribers:</th><td> |
| 113 | } |
| 114 | nSub = db_int(0, "SELECT count(*) FROM subscriber"); |
| 115 | nASub = db_int(0, "SELECT count(*) FROM subscriber WHERE sverified" |
| 116 | " AND NOT sdonotcall AND length(ssub)>1"); |
| 117 | @ %,d(nASub) active, %,d(nSub-nASub) pending, %,d(nSub) total |
| 118 | @ </td></tr> |
| 119 | } |
| 120 | |
| 121 | /* |
| 122 | ** WEBPAGE: stat |
| 123 |