Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add the Access-Log submenu button to the User List page. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e60a021167ceb530fde310a0e9384087 |
| User & Date: | drh 2015-11-17 19:58:58.480 |
Context
|
2015-11-17
| ||
| 23:22 | Show how to enable/disable the access-log and admin-log from their display pages. Add the "Stats" button to the Admin main menu. check-in: 3967d043e8 user: drh tags: trunk | |
| 19:58 | Add the Access-Log submenu button to the User List page. check-in: e60a021167 user: drh tags: trunk | |
| 19:52 | Revamp the user list setup page. Show the last change time and expiration date for each login. Make the user list sortable using javascript. check-in: 01b1319931 user: drh tags: trunk | |
Changes
Changes to src/setup.c.
| ︙ | ︙ | |||
151 152 153 154 155 156 157 158 159 160 161 162 163 164 |
login_check_credentials();
if( !g.perm.Admin ){
login_needed(0);
return;
}
style_submenu_element("Add", "Add User", "setup_uedit");
style_submenu_element("Help", "Help", "setup_ulist_notes");
style_header("User List");
@ <table border=1 cellpadding=2 cellspacing=0 class='userTable'>
@ <thead><tr><th>UID <th>Category <th>Capabilities <th>Info <th>Last Change</tr></thead>
@ <tbody>
db_prepare(&s,
"SELECT uid, login, cap, date(mtime,'unixepoch')"
| > | 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 |
login_check_credentials();
if( !g.perm.Admin ){
login_needed(0);
return;
}
style_submenu_element("Add", "Add User", "setup_uedit");
style_submenu_element("Log", "Access Log", "access_log");
style_submenu_element("Help", "Help", "setup_ulist_notes");
style_header("User List");
@ <table border=1 cellpadding=2 cellspacing=0 class='userTable'>
@ <thead><tr><th>UID <th>Category <th>Capabilities <th>Info <th>Last Change</tr></thead>
@ <tbody>
db_prepare(&s,
"SELECT uid, login, cap, date(mtime,'unixepoch')"
|
| ︙ | ︙ | |||
195 196 197 198 199 200 201 |
@ </tr>
}
db_finalize(&s);
@ </tbody></table>
@ <div class='section'>Users</div>
@ <table border=1 cellpadding=2 cellspacing=0 class='userTable' id='userlist'>
@ <thead><tr>
| | | 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 |
@ </tr>
}
db_finalize(&s);
@ </tbody></table>
@ <div class='section'>Users</div>
@ <table border=1 cellpadding=2 cellspacing=0 class='userTable' id='userlist'>
@ <thead><tr>
@ <th>ID<th>Login<th>Caps<th>Info<th>Date<th>Expire</tr></thead>
@ <tbody>
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"
" FROM user"
|
| ︙ | ︙ |