Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | When computing the "Last Login" on the user list page, take the RCVFROM sync log into account. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
46d5d638b110ea93dbb97d3402af3199 |
| User & Date: | drh 2017-07-01 17:23:04.016 |
Context
|
2017-07-01
| ||
| 17:54 | Add the "Last Change" activity report. check-in: b629647e82 user: drh tags: trunk | |
| 17:23 | When computing the "Last Login" on the user list page, take the RCVFROM sync log into account. check-in: 46d5d638b1 user: drh tags: trunk | |
| 16:41 | Prevent line breaks in the "Last Login" column of the user list. check-in: 2fe385e4c3 user: drh tags: trunk | |
Changes
Changes to src/setup.c.
| ︙ | ︙ | |||
205 206 207 208 209 210 211 |
@ <tbody>
db_multi_exec(
"CREATE TEMP TABLE lastAccess(uname TEXT PRIMARY KEY, atime REAL) WITHOUT ROWID;"
);
if( db_table_exists("repository","accesslog") ){
db_multi_exec(
"INSERT INTO lastAccess(uname, atime)"
| | > > > > | 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 |
@ <tbody>
db_multi_exec(
"CREATE TEMP TABLE lastAccess(uname TEXT PRIMARY KEY, atime REAL) WITHOUT ROWID;"
);
if( db_table_exists("repository","accesslog") ){
db_multi_exec(
"INSERT INTO lastAccess(uname, atime)"
" SELECT uname, max(mtime) FROM ("
" SELECT uname, mtime FROM accesslog WHERE success"
" UNION ALL"
" SELECT login AS uname, rcvfrom.mtime AS mtime FROM rcvfrom JOIN user USING(uid))"
" GROUP BY 1;"
);
}
db_prepare(&s,
"SELECT uid, login, cap, info, date(mtime,'unixepoch'), lower(login) AS sortkey, "
" CASE WHEN info LIKE '%%expires 20%%'"
" THEN substr(info,instr(lower(info),'expires')+8,10)"
" END AS exp,"
|
| ︙ | ︙ |