Check-in [1e82c4aa85]
Not logged in
Overview

SHA1 Hash:1e82c4aa850e1b39add61dd40e99d2383404e153
Date: 2008-10-26 02:35:04
User: drh
Comment:Fix the "number of tickets" counter on the "stats" webpage.
Timelines: ancestors | descendants | both | trunk
Other Links: files | ZIP archive | manifest

Tags And Properties
Changes
[hide diffs]

Modified src/stat.c from [b7851e999c] to [3af9e4ec2b].

@@ -79,11 +79,11 @@
   @ <tr><th>Number&nbsp;Of&nbsp;Wiki&nbsp;Pages:</th><td>
   n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'wiki-*'");
   @ %d(n)
   @ </td></tr>
   @ <tr><th>Number&nbsp;Of&nbsp;Tickets:</th><td>
-  n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'ticket-*'");
+  n = db_int(0, "SELECT count(*) FROM tag WHERE +tagname GLOB 'tkt-*'");
   @ %d(n)
   @ </td></tr>
   @ <tr><th>Duration&nbsp;Of&nbsp;Project:</th><td>
   n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event) + 0.99");
   @ %d(n) days