Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | On the Unknown Artifacts section of the /artifact_stats page, provide links to the RCVFROM table entry for each unknown artifact. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | 9f9ed245f963572a21d1469d7d5f5d16432ac9f9d3ae42ac377b8d4c4bae5875 |
| User & Date: | drh 2017-12-10 00:56:41 |
Context
|
2017-12-10
| ||
| 02:30 | Add the experimental /artifact_size_stats webpage. There are no links to this page, yet. check-in: 4439f15d user: drh tags: trunk | |
| 00:56 | On the Unknown Artifacts section of the /artifact_stats page, provide links to the RCVFROM table entry for each unknown artifact. check-in: 9f9ed245 user: drh tags: trunk | |
| 00:51 | Fix the sorttable.js module so that it works with more than one sortable table on the same screen. check-in: 23083200 user: drh tags: trunk | |
Changes
Changes to src/stat.c.
695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 |
@ </tbody></table>
db_finalize(&q);
if( db_exists("SELECT 1 FROM artstat WHERE atype='unknown'") ){
@ <h2>Unknown Artifacts</h2>
db_prepare(&q,
"SELECT artstat.id, blob.uuid, user.login,"
" datetime(rcvfrom.mtime), rcvfrom.ipaddr"
" FROM artstat JOIN blob ON artstat.id=blob.rid"
" LEFT JOIN rcvfrom USING(rcvid)"
" LEFT JOIN user USING(uid)"
" WHERE atype='unknown'"
);
@ <table class='sortable' border='1' \
@ data-column-types='ntttt' data-init-sort='0'>
@ <thead><tr>
@ <th>RecordID</th>
@ <th>Hash</th>
@ <th>User</th>
@ <th>Date</th>
@ <th>IP-Addr</th>
@ </tr></thead><tbody>
while( db_step(&q)==SQLITE_ROW ){
int rid = db_column_int(&q, 0);
const char *zHash = db_column_text(&q, 1);
const char *zUser = db_column_text(&q, 2);
const char *zDate = db_column_text(&q, 3);
const char *zIpAddr = db_column_text(&q, 4);
@ <tr><td>%d(rid)</td>
@ <td>%z(href("%R/info/%!S",zHash))%S(zHash)</a></td>
@ <td>%h(zUser)</td>
@ <td>%h(zDate)</td>
@ <td>%h(zIpAddr)</td></tr>
}
@ </tbody></table></div>
db_finalize(&q);
}
style_table_sorter();
style_footer();
}
|
| | | | |
695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 |
@ </tbody></table>
db_finalize(&q);
if( db_exists("SELECT 1 FROM artstat WHERE atype='unknown'") ){
@ <h2>Unknown Artifacts</h2>
db_prepare(&q,
"SELECT artstat.id, blob.uuid, user.login,"
" datetime(rcvfrom.mtime), rcvfrom.rcvid"
" FROM artstat JOIN blob ON artstat.id=blob.rid"
" LEFT JOIN rcvfrom USING(rcvid)"
" LEFT JOIN user USING(uid)"
" WHERE atype='unknown'"
);
@ <table class='sortable' border='1' \
@ data-column-types='ntttt' data-init-sort='0'>
@ <thead><tr>
@ <th>RecordID</th>
@ <th>Hash</th>
@ <th>User</th>
@ <th>Date</th>
@ <th>RcvID</th>
@ </tr></thead><tbody>
while( db_step(&q)==SQLITE_ROW ){
int rid = db_column_int(&q, 0);
const char *zHash = db_column_text(&q, 1);
const char *zUser = db_column_text(&q, 2);
const char *zDate = db_column_text(&q, 3);
int iRcvid = db_column_int(&q, 4);
@ <tr><td>%d(rid)</td>
@ <td>%z(href("%R/info/%!S",zHash))%S(zHash)</a></td>
@ <td>%h(zUser)</td>
@ <td>%h(zDate)</td>
@ <td>%z(href("%R/rcvfrom?rcvid=%d",iRcvid))%d(iRcvid)</a></td></tr>
}
@ </tbody></table></div>
db_finalize(&q);
}
style_table_sorter();
style_footer();
}
|