Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Enhance the /wcontent page to show a sortable list of wiki pages together with the number of versions and the time of last change. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
81c22bc6b8605da5cb8aa113c6f9605e |
| User & Date: | drh 2018-12-11 16:28:58.754 |
Context
|
2018-12-11
| ||
| 18:55 | On the /wiki page, put text to show that the page has been deleted. ... (check-in: c7a7a56117 user: drh tags: trunk) | |
| 16:28 | Enhance the /wcontent page to show a sortable list of wiki pages together with the number of versions and the time of last change. ... (check-in: 81c22bc6b8 user: drh tags: trunk) | |
|
2018-12-07
| ||
| 19:36 | Reworded 2 references to 40-character artifact IDs, since those particular IDs may now be longer than 40 characters. ... (check-in: 565c21739c user: stephan tags: trunk) | |
Changes
Changes to src/branch.c.
| ︙ | ︙ | |||
18 19 20 21 22 23 24 | ** This file contains code used to create new branches within a repository. */ #include "config.h" #include "branch.h" #include <assert.h> /* | | | 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
** This file contains code used to create new branches within a repository.
*/
#include "config.h"
#include "branch.h"
#include <assert.h>
/*
** fossil branch new NAME BASIS ?OPTIONS?
** argv0 argv1 argv2 argv3 argv4
*/
void branch_new(void){
int rootid; /* RID of the root check-in - what we branch off of */
int brid; /* RID of the branch check-in */
int noSign; /* True if the branch is unsigned */
int i; /* Loop counter */
|
| ︙ | ︙ | |||
433 434 435 436 437 438 439 |
brlist_create_temp_table();
db_prepare(&q, "SELECT * FROM tmp_brlist ORDER BY mtime DESC");
rNow = db_double(0.0, "SELECT julianday('now')");
@ <div class="brlist">
@ <table class='sortable' data-column-types='tkNtt' data-init-sort='2'>
@ <thead><tr>
@ <th>Branch Name</th>
| | | 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 |
brlist_create_temp_table();
db_prepare(&q, "SELECT * FROM tmp_brlist ORDER BY mtime DESC");
rNow = db_double(0.0, "SELECT julianday('now')");
@ <div class="brlist">
@ <table class='sortable' data-column-types='tkNtt' data-init-sort='2'>
@ <thead><tr>
@ <th>Branch Name</th>
@ <th>Last Change</th>
@ <th>Check-ins</th>
@ <th>Status</th>
@ <th>Resolution</th>
@ </tr></thead><tbody>
while( db_step(&q)==SQLITE_ROW ){
const char *zBranch = db_column_text(&q, 0);
double rMtime = db_column_double(&q, 1);
|
| ︙ | ︙ |
Changes to src/wiki.c.
| ︙ | ︙ | |||
932 933 934 935 936 937 938 | @ <pre> manifest_destroy(pW1); manifest_destroy(pW2); style_footer(); } /* | | | | > > > < > | < | | > | > > > | > > | > > | < > | > > > > | < > > > > > | > | > > > > | > > | | > | > > > > > > < > | 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 |
@ <pre>
manifest_destroy(pW1);
manifest_destroy(pW2);
style_footer();
}
/*
** A query that returns information about all wiki pages.
**
** wname Name of the wiki page
** wsort Sort names by this label
** wrid rid of the most recent version of the page
** wmtime time most recent version was created
** wcnt Number of versions of this wiki page
**
** The wrid value is zero for deleted wiki pages.
*/
static const char listAllWikiPages[] =
@ SELECT
@ substr(tag.tagname, 6) AS wname,
@ lower(substr(tag.tagname, 6)) AS sortname,
@ tagxref.value+0 AS wrid,
@ max(tagxref.mtime) AS wmtime,
@ count(*) AS wcnt
@ FROM
@ tag,
@ tagxref
@ WHERE
@ tag.tagname GLOB 'wiki-*'
@ AND tagxref.tagid=tag.tagid
@ GROUP BY 1
@ ORDER BY 2;
;
/*
** WEBPAGE: wcontent
**
** all=1 Show deleted pages
**
** List all available wiki pages with date created and last modified.
*/
void wcontent_page(void){
Stmt q;
double rNow;
int showAll = P("all")!=0;
login_check_credentials();
if( !g.perm.RdWiki ){ login_needed(g.anon.RdWiki); return; }
style_header("Available Wiki Pages");
if( showAll ){
style_submenu_element("Active", "%s/wcontent", g.zTop);
}else{
style_submenu_element("All", "%s/wcontent?all=1", g.zTop);
}
wiki_standard_submenu(W_ALL_BUT(W_LIST));
db_prepare(&q, listAllWikiPages/*works-like:""*/);
@ <div class="brlist">
@ <table class='sortable' data-column-types='tKN' data-init-sort='1'>
@ <thead><tr>
@ <th>Name</th>
@ <th>Last Change</th>
@ <th>Versions</th>
@ </tr></thead><tbody>
rNow = db_double(0.0, "SELECT julianday('now')");
while( db_step(&q)==SQLITE_ROW ){
const char *zWName = db_column_text(&q, 0);
const char *zSort = db_column_text(&q, 1);
int wrid = db_column_int(&q, 2);
double rWmtime = db_column_double(&q, 3);
sqlite3_int64 iMtime = (sqlite3_int64)(rWmtime*86400.0);
char *zAge;
int wcnt = db_column_int(&q, 4);
if( wrid==0 ){
if( !showAll ) continue;
@ <tr><td data-sortkey="%h(zSort)">\
@ %z(href("%R/whistory?name=%T",zWName))<s>%h(zWName)</s></a></td>
}else{
@ <tr><td data=sortkey='%h(zSort)">\
@ %z(href("%R/wiki?name=%T",zWName))%h(zWName)</a></td>
}
zAge = human_readable_age(rNow - rWmtime);
@ <td data-sortkey="%016llx(iMtime)">%s(zAge)</td>
fossil_free(zAge);
@ <td>%z(href("%R/whistory?name=%T",zWName))%d(wcnt)</a></td>
@ </tr>
}
@ </tbody></table></div>
db_finalize(&q);
style_table_sorter();
style_footer();
}
/*
** WEBPAGE: wfind
**
** URL: /wfind?title=TITLE
|
| ︙ | ︙ |