Fossil SCM
On the /urllist webpage, show entries most recent first instead of most recent last.
Commit
f94f3e3a79992d2a1228db1f4f4a0936a5fdc9c5
Parent
74eec78b3b856a9…
1 file changed
+2
-2
+2
-2
| --- src/stat.c | ||
| +++ src/stat.c | ||
| @@ -252,11 +252,11 @@ | ||
| 252 | 252 | style_header("URLs and Checkouts"); |
| 253 | 253 | style_submenu_element("Stat", "Repository Stats", "stat"); |
| 254 | 254 | @ <div class="section">URLs</div> |
| 255 | 255 | @ <table border="0" width='100%%'> |
| 256 | 256 | db_prepare(&q, "SELECT substr(name,9), datetime(mtime,'unixepoch')" |
| 257 | - " FROM config WHERE name GLOB 'baseurl:*' ORDER BY 2"); | |
| 257 | + " FROM config WHERE name GLOB 'baseurl:*' ORDER BY 2 DESC"); | |
| 258 | 258 | cnt = 0; |
| 259 | 259 | while( db_step(&q)==SQLITE_ROW ){ |
| 260 | 260 | @ <tr><td width='100%%'>%h(db_column_text(&q,0))</td> |
| 261 | 261 | @ <td><nobr>%h(db_column_text(&q,1))</nobr></td></tr> |
| 262 | 262 | cnt++; |
| @@ -267,11 +267,11 @@ | ||
| 267 | 267 | } |
| 268 | 268 | @ </table> |
| 269 | 269 | @ <div class="section">Checkouts</div> |
| 270 | 270 | @ <table border="0" width='100%%'> |
| 271 | 271 | db_prepare(&q, "SELECT substr(name,7), datetime(mtime,'unixepoch')" |
| 272 | - " FROM config WHERE name GLOB 'ckout:*' ORDER BY 2"); | |
| 272 | + " FROM config WHERE name GLOB 'ckout:*' ORDER BY 2 DESC"); | |
| 273 | 273 | cnt = 0; |
| 274 | 274 | while( db_step(&q)==SQLITE_ROW ){ |
| 275 | 275 | @ <tr><td width='100%%'>%h(db_column_text(&q,0))</td> |
| 276 | 276 | @ <td><nobr>%h(db_column_text(&q,1))</nobr></td></tr> |
| 277 | 277 | cnt++; |
| 278 | 278 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -252,11 +252,11 @@ | |
| 252 | style_header("URLs and Checkouts"); |
| 253 | style_submenu_element("Stat", "Repository Stats", "stat"); |
| 254 | @ <div class="section">URLs</div> |
| 255 | @ <table border="0" width='100%%'> |
| 256 | db_prepare(&q, "SELECT substr(name,9), datetime(mtime,'unixepoch')" |
| 257 | " FROM config WHERE name GLOB 'baseurl:*' ORDER BY 2"); |
| 258 | cnt = 0; |
| 259 | while( db_step(&q)==SQLITE_ROW ){ |
| 260 | @ <tr><td width='100%%'>%h(db_column_text(&q,0))</td> |
| 261 | @ <td><nobr>%h(db_column_text(&q,1))</nobr></td></tr> |
| 262 | cnt++; |
| @@ -267,11 +267,11 @@ | |
| 267 | } |
| 268 | @ </table> |
| 269 | @ <div class="section">Checkouts</div> |
| 270 | @ <table border="0" width='100%%'> |
| 271 | db_prepare(&q, "SELECT substr(name,7), datetime(mtime,'unixepoch')" |
| 272 | " FROM config WHERE name GLOB 'ckout:*' ORDER BY 2"); |
| 273 | cnt = 0; |
| 274 | while( db_step(&q)==SQLITE_ROW ){ |
| 275 | @ <tr><td width='100%%'>%h(db_column_text(&q,0))</td> |
| 276 | @ <td><nobr>%h(db_column_text(&q,1))</nobr></td></tr> |
| 277 | cnt++; |
| 278 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -252,11 +252,11 @@ | |
| 252 | style_header("URLs and Checkouts"); |
| 253 | style_submenu_element("Stat", "Repository Stats", "stat"); |
| 254 | @ <div class="section">URLs</div> |
| 255 | @ <table border="0" width='100%%'> |
| 256 | db_prepare(&q, "SELECT substr(name,9), datetime(mtime,'unixepoch')" |
| 257 | " FROM config WHERE name GLOB 'baseurl:*' ORDER BY 2 DESC"); |
| 258 | cnt = 0; |
| 259 | while( db_step(&q)==SQLITE_ROW ){ |
| 260 | @ <tr><td width='100%%'>%h(db_column_text(&q,0))</td> |
| 261 | @ <td><nobr>%h(db_column_text(&q,1))</nobr></td></tr> |
| 262 | cnt++; |
| @@ -267,11 +267,11 @@ | |
| 267 | } |
| 268 | @ </table> |
| 269 | @ <div class="section">Checkouts</div> |
| 270 | @ <table border="0" width='100%%'> |
| 271 | db_prepare(&q, "SELECT substr(name,7), datetime(mtime,'unixepoch')" |
| 272 | " FROM config WHERE name GLOB 'ckout:*' ORDER BY 2 DESC"); |
| 273 | cnt = 0; |
| 274 | while( db_step(&q)==SQLITE_ROW ){ |
| 275 | @ <tr><td width='100%%'>%h(db_column_text(&q,0))</td> |
| 276 | @ <td><nobr>%h(db_column_text(&q,1))</nobr></td></tr> |
| 277 | cnt++; |
| 278 |