Differences From:
File
src/tagview.c
part of check-in
[3984b1b2c1]
- Make the info web page handle symbolic tags as well as UUIDs. Start trying
to make the currently-disabled tagview page more useful.
by
eric on
2008-08-04 20:46:52.
[view]
To:
File
src/tagview.c
part of check-in
[070e63db33]
- Merge old tagview branch into this branch
by
eric on
2008-08-17 20:53:20.
[view]
@@ -61,9 +61,9 @@
" linktagname(t.tagname) AS 'Name',"
" DATETIME(tx.mtime) AS 'Timestamp',"
" linkuuid(b.uuid) AS 'Version'"
" FROM tag t, tagxref tx, blob b "
- " WHERE t.tagid=tx.tagid AND tx.srcid=b.rid"
+ " WHERE t.tagid=tx.tagid AND tx.rid=b.rid"
" AND tx.tagtype!=0 %s "
TAGVIEW_DEFAULT_FILTER
" ORDER BY tx.mtime DESC %s",
zLikeClause, zLimit
@@ -106,9 +106,9 @@
" linktagname(t.tagname) AS 'Tag Name',"
" DATETIME(tx.mtime) AS 'Timestamp',"
" linkuuid(b.uuid) AS 'Version'"
" FROM tag t, tagxref tx, blob b"
- " WHERE t.tagid=%d AND t.tagid=tx.tagid AND tx.srcid=b.rid "
+ " WHERE t.tagid=%d AND t.tagid=tx.tagid AND tx.rid=b.rid "
TAGVIEW_DEFAULT_FILTER
" ORDER BY tx.mtime DESC",
tagid
);
@@ -127,9 +127,9 @@
" linktagid(t.tagid) AS 'Tag ID',"
" DATETIME(tx.mtime) AS 'Timestamp',"
" linkuuid(b.uuid) AS 'Version'"
" FROM tag t, tagxref tx, blob b "
- " WHERE t.tagname='%q' AND t.tagid=tx.tagid AND tx.srcid=b.rid "
+ " WHERE t.tagname='%q' AND t.tagid=tx.tagid AND tx.rid=b.rid "
TAGVIEW_DEFAULT_FILTER
" ORDER BY tx.mtime DESC",
tagname);
db_generic_query_view(zSql, 1);