Fossil SCM
Update the /stat page to show forum statistics.
Commit
29141af7af66b7e8f0489e8fae462d02289c53f9c95a93c2c15a0b6a3f60d488
Parent
44545eef88e8253…
1 file changed
+12
-3
+12
-3
| --- src/stat.c | ||
| +++ src/stat.c | ||
| @@ -217,15 +217,24 @@ | ||
| 217 | 217 | @ <tr><th>Number Of Wiki Pages:</th><td> |
| 218 | 218 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 219 | 219 | " WHERE +tagname GLOB 'wiki-*'"); |
| 220 | 220 | @ %,d(n) |
| 221 | 221 | @ </td></tr> |
| 222 | - @ <tr><th>Number Of Tickets:</th><td> | |
| 223 | 222 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 224 | 223 | " WHERE +tagname GLOB 'tkt-*'"); |
| 225 | - @ %,d(n) | |
| 226 | - @ </td></tr> | |
| 224 | + if( n>0 ){ | |
| 225 | + @ <tr><th>Number Of Tickets:</th><td>%,d(n)</td></tr> | |
| 226 | + } | |
| 227 | + if( db_table_exists("repository","forumpost") ){ | |
| 228 | + n = db_int(0, "SELECT count(*) FROM forumpost/*scan*/"); | |
| 229 | + if( n>0 ){ | |
| 230 | + int nThread = db_int(0, "SELECT count(*) FROM forumpost" | |
| 231 | + " WHERE froot=fpid"); | |
| 232 | + @ <tr><th>Number Of Forum Posts:</th> | |
| 233 | + @ <td>%,d(n) on %d(nThread) threads</td></tr> | |
| 234 | + } | |
| 235 | + } | |
| 227 | 236 | } |
| 228 | 237 | @ <tr><th>Duration Of Project:</th><td> |
| 229 | 238 | n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event)" |
| 230 | 239 | " + 0.99"); |
| 231 | 240 | @ %,d(n) days or approximately %.2f(n/365.2425) years. |
| 232 | 241 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -217,15 +217,24 @@ | |
| 217 | @ <tr><th>Number Of Wiki Pages:</th><td> |
| 218 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 219 | " WHERE +tagname GLOB 'wiki-*'"); |
| 220 | @ %,d(n) |
| 221 | @ </td></tr> |
| 222 | @ <tr><th>Number Of Tickets:</th><td> |
| 223 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 224 | " WHERE +tagname GLOB 'tkt-*'"); |
| 225 | @ %,d(n) |
| 226 | @ </td></tr> |
| 227 | } |
| 228 | @ <tr><th>Duration Of Project:</th><td> |
| 229 | n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event)" |
| 230 | " + 0.99"); |
| 231 | @ %,d(n) days or approximately %.2f(n/365.2425) years. |
| 232 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -217,15 +217,24 @@ | |
| 217 | @ <tr><th>Number Of Wiki Pages:</th><td> |
| 218 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 219 | " WHERE +tagname GLOB 'wiki-*'"); |
| 220 | @ %,d(n) |
| 221 | @ </td></tr> |
| 222 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 223 | " WHERE +tagname GLOB 'tkt-*'"); |
| 224 | if( n>0 ){ |
| 225 | @ <tr><th>Number Of Tickets:</th><td>%,d(n)</td></tr> |
| 226 | } |
| 227 | if( db_table_exists("repository","forumpost") ){ |
| 228 | n = db_int(0, "SELECT count(*) FROM forumpost/*scan*/"); |
| 229 | if( n>0 ){ |
| 230 | int nThread = db_int(0, "SELECT count(*) FROM forumpost" |
| 231 | " WHERE froot=fpid"); |
| 232 | @ <tr><th>Number Of Forum Posts:</th> |
| 233 | @ <td>%,d(n) on %d(nThread) threads</td></tr> |
| 234 | } |
| 235 | } |
| 236 | } |
| 237 | @ <tr><th>Duration Of Project:</th><td> |
| 238 | n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event)" |
| 239 | " + 0.99"); |
| 240 | @ %,d(n) days or approximately %.2f(n/365.2425) years. |
| 241 |