Fossil SCM

Fix the "number of tickets" counter on the "stats" webpage.

drh 2008-10-26 02:35 trunk
Commit 1e82c4aa850e1b39add61dd40e99d2383404e153
1 file changed +1 -1
+1 -1
--- src/stat.c
+++ src/stat.c
@@ -79,11 +79,11 @@
7979
@ <tr><th>Number&nbsp;Of&nbsp;Wiki&nbsp;Pages:</th><td>
8080
n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'wiki-*'");
8181
@ %d(n)
8282
@ </td></tr>
8383
@ <tr><th>Number&nbsp;Of&nbsp;Tickets:</th><td>
84
- n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'ticket-*'");
84
+ n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'tkt-*'");
8585
@ %d(n)
8686
@ </td></tr>
8787
@ <tr><th>Duration&nbsp;Of&nbsp;Project:</th><td>
8888
n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event) + 0.99");
8989
@ %d(n) days
9090
--- src/stat.c
+++ src/stat.c
@@ -79,11 +79,11 @@
79 @ <tr><th>Number&nbsp;Of&nbsp;Wiki&nbsp;Pages:</th><td>
80 n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'wiki-*'");
81 @ %d(n)
82 @ </td></tr>
83 @ <tr><th>Number&nbsp;Of&nbsp;Tickets:</th><td>
84 n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'ticket-*'");
85 @ %d(n)
86 @ </td></tr>
87 @ <tr><th>Duration&nbsp;Of&nbsp;Project:</th><td>
88 n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event) + 0.99");
89 @ %d(n) days
90
--- src/stat.c
+++ src/stat.c
@@ -79,11 +79,11 @@
79 @ <tr><th>Number&nbsp;Of&nbsp;Wiki&nbsp;Pages:</th><td>
80 n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'wiki-*'");
81 @ %d(n)
82 @ </td></tr>
83 @ <tr><th>Number&nbsp;Of&nbsp;Tickets:</th><td>
84 n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'tkt-*'");
85 @ %d(n)
86 @ </td></tr>
87 @ <tr><th>Duration&nbsp;Of&nbsp;Project:</th><td>
88 n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event) + 0.99");
89 @ %d(n) days
90

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button