Fossil SCM
Fix the computation of capabilities in the "Capability Summary" report so that it ignores the special users "nobody", "anonymous", "reader", and "developer".
Commit
63febeb7f4229aff7918a92ca9d374472d195e8952ce06b4373512bb01918327
Parent
1c15ebf8dd853aa…
1 file changed
+1
-1
+1
-1
| --- src/capabilities.c | ||
| +++ src/capabilities.c | ||
| @@ -364,11 +364,11 @@ | ||
| 364 | 364 | " FROM t LEFT JOIN user ON t.id=user.login" |
| 365 | 365 | " UNION ALL" |
| 366 | 366 | " SELECT 'New User Default', fullcap(%Q), 10, 1" |
| 367 | 367 | " UNION ALL" |
| 368 | 368 | " SELECT 'Regular User', fullcap(capunion(cap)), 20, count(*) FROM user" |
| 369 | - " WHERE cap NOT GLOB '*[as]*'" | |
| 369 | + " WHERE cap NOT GLOB '*[as]*' AND login NOT IN (SELECT id FROM t)" | |
| 370 | 370 | " UNION ALL" |
| 371 | 371 | " SELECT 'Adminstrator', fullcap(capunion(cap)), 30, count(*) FROM user" |
| 372 | 372 | " WHERE cap GLOB '*[as]*'" |
| 373 | 373 | " ORDER BY 3 ASC", |
| 374 | 374 | db_get("default-perms","") |
| 375 | 375 |
| --- src/capabilities.c | |
| +++ src/capabilities.c | |
| @@ -364,11 +364,11 @@ | |
| 364 | " FROM t LEFT JOIN user ON t.id=user.login" |
| 365 | " UNION ALL" |
| 366 | " SELECT 'New User Default', fullcap(%Q), 10, 1" |
| 367 | " UNION ALL" |
| 368 | " SELECT 'Regular User', fullcap(capunion(cap)), 20, count(*) FROM user" |
| 369 | " WHERE cap NOT GLOB '*[as]*'" |
| 370 | " UNION ALL" |
| 371 | " SELECT 'Adminstrator', fullcap(capunion(cap)), 30, count(*) FROM user" |
| 372 | " WHERE cap GLOB '*[as]*'" |
| 373 | " ORDER BY 3 ASC", |
| 374 | db_get("default-perms","") |
| 375 |
| --- src/capabilities.c | |
| +++ src/capabilities.c | |
| @@ -364,11 +364,11 @@ | |
| 364 | " FROM t LEFT JOIN user ON t.id=user.login" |
| 365 | " UNION ALL" |
| 366 | " SELECT 'New User Default', fullcap(%Q), 10, 1" |
| 367 | " UNION ALL" |
| 368 | " SELECT 'Regular User', fullcap(capunion(cap)), 20, count(*) FROM user" |
| 369 | " WHERE cap NOT GLOB '*[as]*' AND login NOT IN (SELECT id FROM t)" |
| 370 | " UNION ALL" |
| 371 | " SELECT 'Adminstrator', fullcap(capunion(cap)), 30, count(*) FROM user" |
| 372 | " WHERE cap GLOB '*[as]*'" |
| 373 | " ORDER BY 3 ASC", |
| 374 | db_get("default-perms","") |
| 375 |