Differences From:
File
src/tagview.c
part of check-in
[7c281b629a]
- Prevent tag cancellations from showing in "fossil tag list" and
"fossil tag find", and also on the tagview web page, but make them
visible with "--raw" or on the RawTags webpage (admin only). Fixes
ticket f273b440c38eb8478822812e0730f0fc2c8b4c36.
by
eric on
2008-12-20 11:36:20.
[view]
To:
File
src/tagview.c
part of check-in
[b7f32a71ab]
- Add web-based branch color changer. Add the "branch list" command.
Simplifications to color propagation logic.
by
drh on
2009-01-20 22:21:24.
[view]
@@ -169,19 +169,21 @@
/*
** Generate a timeline for the chosen tag
*/
-void tagview_print_timeline(char const *pName, char const *pPrefix){
+void tagview_print_timeline(char const *zName, char const *zPrefix){
char *zSql;
Stmt q;
+ int tagid = db_int(0, "SELECT tagid FROM tag WHERE tagname='%q%q'",
+ zPrefix, zName);
zSql = mprintf("%s AND EXISTS (SELECT 1"
" FROM tagxref"
" WHERE tagxref.rid = event.objid"
" AND tagxref.tagtype > 0"
- " AND tagxref.tagid = (SELECT tagid FROM tag"
- " WHERE tagname = %Q||%Q))"
+ " AND tagxref.tagid = %d"
" ORDER BY 3 desc",
- timeline_query_for_www(), pPrefix, pName);
+ timeline_query_for_www(), tagid
+ );
db_prepare(&q, zSql);
free(zSql);
www_print_timeline(&q);
db_finalize(&q);