Fossil SCM
When computing the "Last Login" on the user list page, take the RCVFROM sync log into account.
Commit
46d5d638b110ea93dbb97d3402af3199e5bd5e77f10945462be55ec3b9dded6b
Parent
2fe385e4c32d28c…
1 file changed
+5
-1
+5
-1
| --- src/setup.c | ||
| +++ src/setup.c | ||
| @@ -207,11 +207,15 @@ | ||
| 207 | 207 | "CREATE TEMP TABLE lastAccess(uname TEXT PRIMARY KEY, atime REAL) WITHOUT ROWID;" |
| 208 | 208 | ); |
| 209 | 209 | if( db_table_exists("repository","accesslog") ){ |
| 210 | 210 | db_multi_exec( |
| 211 | 211 | "INSERT INTO lastAccess(uname, atime)" |
| 212 | - " SELECT uname, max(mtime) FROM accesslog WHERE success GROUP BY uname;" | |
| 212 | + " SELECT uname, max(mtime) FROM (" | |
| 213 | + " SELECT uname, mtime FROM accesslog WHERE success" | |
| 214 | + " UNION ALL" | |
| 215 | + " SELECT login AS uname, rcvfrom.mtime AS mtime FROM rcvfrom JOIN user USING(uid))" | |
| 216 | + " GROUP BY 1;" | |
| 213 | 217 | ); |
| 214 | 218 | } |
| 215 | 219 | db_prepare(&s, |
| 216 | 220 | "SELECT uid, login, cap, info, date(mtime,'unixepoch'), lower(login) AS sortkey, " |
| 217 | 221 | " CASE WHEN info LIKE '%%expires 20%%'" |
| 218 | 222 |
| --- src/setup.c | |
| +++ src/setup.c | |
| @@ -207,11 +207,15 @@ | |
| 207 | "CREATE TEMP TABLE lastAccess(uname TEXT PRIMARY KEY, atime REAL) WITHOUT ROWID;" |
| 208 | ); |
| 209 | if( db_table_exists("repository","accesslog") ){ |
| 210 | db_multi_exec( |
| 211 | "INSERT INTO lastAccess(uname, atime)" |
| 212 | " SELECT uname, max(mtime) FROM accesslog WHERE success GROUP BY uname;" |
| 213 | ); |
| 214 | } |
| 215 | db_prepare(&s, |
| 216 | "SELECT uid, login, cap, info, date(mtime,'unixepoch'), lower(login) AS sortkey, " |
| 217 | " CASE WHEN info LIKE '%%expires 20%%'" |
| 218 |
| --- src/setup.c | |
| +++ src/setup.c | |
| @@ -207,11 +207,15 @@ | |
| 207 | "CREATE TEMP TABLE lastAccess(uname TEXT PRIMARY KEY, atime REAL) WITHOUT ROWID;" |
| 208 | ); |
| 209 | if( db_table_exists("repository","accesslog") ){ |
| 210 | db_multi_exec( |
| 211 | "INSERT INTO lastAccess(uname, atime)" |
| 212 | " SELECT uname, max(mtime) FROM (" |
| 213 | " SELECT uname, mtime FROM accesslog WHERE success" |
| 214 | " UNION ALL" |
| 215 | " SELECT login AS uname, rcvfrom.mtime AS mtime FROM rcvfrom JOIN user USING(uid))" |
| 216 | " GROUP BY 1;" |
| 217 | ); |
| 218 | } |
| 219 | db_prepare(&s, |
| 220 | "SELECT uid, login, cap, info, date(mtime,'unixepoch'), lower(login) AS sortkey, " |
| 221 | " CASE WHEN info LIKE '%%expires 20%%'" |
| 222 |