Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Try again to provide better "(more context)" hyperlinks on the /thisdayinhistory page. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
273974a2e63c497e11412a9b10b697da |
| User & Date: | drh 2019-05-10 16:33:53 |
Context
|
2019-05-10
| ||
| 18:47 | Update the built-in SQLite to the 3.29.0 alpha, for testing of SQLite. check-in: 1bdebbe1 user: drh tags: trunk | |
| 16:33 | Try again to provide better "(more context)" hyperlinks on the /thisdayinhistory page. check-in: 273974a2 user: drh tags: trunk | |
| 16:26 | Improve the "more context" hyperlink on the /thisdayinhistory page. check-in: 97bc9c3a user: drh tags: trunk | |
Changes
Changes to src/timeline.c.
2823
2824
2825
2826
2827
2828
2829
2830
2831
2832
2833
2834
2835
2836
....
2838
2839
2840
2841
2842
2843
2844
2845
2846
2847
2848
2849
2850
2851
2852
2853
|
);
timeline_temp_table();
db_prepare(&q, "SELECT * FROM timeline ORDER BY sortby DESC /*scan*/");
for(i=0; i<sizeof(aYearsAgo)/sizeof(aYearsAgo[0]); i++){
int iAgo = aYearsAgo[i];
char *zThis = db_text(0, "SELECT date(%Q,'-%d years')", zToday, iAgo);
Blob sql;
if( strcmp(zThis, zStartOfProject)<0 ) break;
blob_init(&sql, 0, 0);
blob_append(&sql, "INSERT OR IGNORE INTO timeline ", -1);
blob_append(&sql, timeline_query_for_www(), -1);
blob_append_sql(&sql,
" AND %Q=date(event.mtime,toLocal()) "
" AND event.mtime BETWEEN julianday(%Q,'-1 day')"
................................................................................
zThis, zThis, zThis
);
db_multi_exec("DELETE FROM timeline; %s;", blob_sql_text(&sql));
blob_reset(&sql);
if( db_int(0, "SELECT count(*) FROM timeline")==0 ){
continue;
}
@ <h2>%d(iAgo) Year%s(iAgo>1?"s":"") Ago
@ <small>%z(href("%R/timeline?c=%s+23:59:59",zThis))(more context)</a>\
@ </small></h2>
www_print_timeline(&q, TIMELINE_GRAPH|TIMELINE_DISJOINT, 0, 0, 0, 0);
}
db_finalize(&q);
style_footer();
}
|
>
>
>
|
|
2823
2824
2825
2826
2827
2828
2829
2830
2831
2832
2833
2834
2835
2836
2837
....
2839
2840
2841
2842
2843
2844
2845
2846
2847
2848
2849
2850
2851
2852
2853
2854
2855
2856
|
);
timeline_temp_table();
db_prepare(&q, "SELECT * FROM timeline ORDER BY sortby DESC /*scan*/");
for(i=0; i<sizeof(aYearsAgo)/sizeof(aYearsAgo[0]); i++){
int iAgo = aYearsAgo[i];
char *zThis = db_text(0, "SELECT date(%Q,'-%d years')", zToday, iAgo);
Blob sql;
char *zId;
if( strcmp(zThis, zStartOfProject)<0 ) break;
blob_init(&sql, 0, 0);
blob_append(&sql, "INSERT OR IGNORE INTO timeline ", -1);
blob_append(&sql, timeline_query_for_www(), -1);
blob_append_sql(&sql,
" AND %Q=date(event.mtime,toLocal()) "
" AND event.mtime BETWEEN julianday(%Q,'-1 day')"
................................................................................
zThis, zThis, zThis
);
db_multi_exec("DELETE FROM timeline; %s;", blob_sql_text(&sql));
blob_reset(&sql);
if( db_int(0, "SELECT count(*) FROM timeline")==0 ){
continue;
}
zId = db_text(0, "SELECT timestamp FROM timeline"
" ORDER BY sortby DESC LIMIT 1");
@ <h2>%d(iAgo) Year%s(iAgo>1?"s":"") Ago
@ <small>%z(href("%R/timeline?c=%t",zId))(more context)</a>\
@ </small></h2>
www_print_timeline(&q, TIMELINE_GRAPH|TIMELINE_DISJOINT, 0, 0, 0, 0);
}
db_finalize(&q);
style_footer();
}
|