Fossil SCM
Fix the /forum page so that it links to the most recent post.
Commit
b0ae37c0391dc267daa9306491f0300b83ec82d7b877474ceeb106c682358178
Parent
09103fd2f0c7fca…
1 file changed
+3
-1
+3
-1
| --- src/forum.c | ||
| +++ src/forum.c | ||
| @@ -940,11 +940,13 @@ | ||
| 940 | 940 | db_prepare(&q, |
| 941 | 941 | "SELECT" |
| 942 | 942 | " julianday('now') - max(fmtime) AS a," /* 0 */ |
| 943 | 943 | " max(fmtime) - min(fmtime) AS b," /* 1 */ |
| 944 | 944 | " sum(fprev IS NULL) AS c," /* 2 */ |
| 945 | - " (SELECT substr(uuid,1,10) FROM blob WHERE rid=froot)," /* 3 */ | |
| 945 | + " (SELECT substr(uuid,1,10) FROM blob, forumpost AS z" /* 3 */ | |
| 946 | + " WHERE rid=z.fpid AND z.froot=x.froot" | |
| 947 | + " ORDER BY z.fmtime DESC LIMIT 1)," | |
| 946 | 948 | " (SELECT substr(comment,instr(comment,':')+2)" /* 4 */ |
| 947 | 949 | " FROM event WHERE objid=(SELECT fpid FROM forumpost AS y" |
| 948 | 950 | " WHERE y.froot=x.froot" |
| 949 | 951 | " ORDER BY fmtime DESC LIMIT 1))" |
| 950 | 952 | " FROM forumpost AS x" |
| 951 | 953 |
| --- src/forum.c | |
| +++ src/forum.c | |
| @@ -940,11 +940,13 @@ | |
| 940 | db_prepare(&q, |
| 941 | "SELECT" |
| 942 | " julianday('now') - max(fmtime) AS a," /* 0 */ |
| 943 | " max(fmtime) - min(fmtime) AS b," /* 1 */ |
| 944 | " sum(fprev IS NULL) AS c," /* 2 */ |
| 945 | " (SELECT substr(uuid,1,10) FROM blob WHERE rid=froot)," /* 3 */ |
| 946 | " (SELECT substr(comment,instr(comment,':')+2)" /* 4 */ |
| 947 | " FROM event WHERE objid=(SELECT fpid FROM forumpost AS y" |
| 948 | " WHERE y.froot=x.froot" |
| 949 | " ORDER BY fmtime DESC LIMIT 1))" |
| 950 | " FROM forumpost AS x" |
| 951 |
| --- src/forum.c | |
| +++ src/forum.c | |
| @@ -940,11 +940,13 @@ | |
| 940 | db_prepare(&q, |
| 941 | "SELECT" |
| 942 | " julianday('now') - max(fmtime) AS a," /* 0 */ |
| 943 | " max(fmtime) - min(fmtime) AS b," /* 1 */ |
| 944 | " sum(fprev IS NULL) AS c," /* 2 */ |
| 945 | " (SELECT substr(uuid,1,10) FROM blob, forumpost AS z" /* 3 */ |
| 946 | " WHERE rid=z.fpid AND z.froot=x.froot" |
| 947 | " ORDER BY z.fmtime DESC LIMIT 1)," |
| 948 | " (SELECT substr(comment,instr(comment,':')+2)" /* 4 */ |
| 949 | " FROM event WHERE objid=(SELECT fpid FROM forumpost AS y" |
| 950 | " WHERE y.froot=x.froot" |
| 951 | " ORDER BY fmtime DESC LIMIT 1))" |
| 952 | " FROM forumpost AS x" |
| 953 |