Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix the /forum page so that it links to the most recent post. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
b0ae37c0391dc267daa9306491f0300b |
| User & Date: | drh 2018-08-16 12:31:40 |
Context
|
2018-08-16
| ||
| 16:13 | Adjust the /forum page so that it for users without forum moderator privilege, it pretends that unmoderated posts do not exist, and for user with moderator privilege it paints an "Awaiting Moderator Approval" message on posts that need moderation. check-in: ef7f85ee user: drh tags: trunk | |
| 12:31 | Fix the /forum page so that it links to the most recent post. check-in: b0ae37c0 user: drh tags: trunk | |
| 07:21 | Improved locality of a variable. No functional change. check-in: 09103fd2 user: wyoung tags: trunk | |
Changes
Changes to src/forum.c.
938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 |
iCnt = 0;
if( db_table_exists("repository","forumpost") ){
db_prepare(&q,
"SELECT"
" julianday('now') - max(fmtime) AS a," /* 0 */
" max(fmtime) - min(fmtime) AS b," /* 1 */
" sum(fprev IS NULL) AS c," /* 2 */
" (SELECT substr(uuid,1,10) FROM blob WHERE rid=froot)," /* 3 */
" (SELECT substr(comment,instr(comment,':')+2)" /* 4 */
" FROM event WHERE objid=(SELECT fpid FROM forumpost AS y"
" WHERE y.froot=x.froot"
" ORDER BY fmtime DESC LIMIT 1))"
" FROM forumpost AS x"
" GROUP BY froot ORDER BY 1 LIMIT %d OFFSET %d;",
iLimit+1, iOfst
|
| > > |
938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 |
iCnt = 0;
if( db_table_exists("repository","forumpost") ){
db_prepare(&q,
"SELECT"
" julianday('now') - max(fmtime) AS a," /* 0 */
" max(fmtime) - min(fmtime) AS b," /* 1 */
" sum(fprev IS NULL) AS c," /* 2 */
" (SELECT substr(uuid,1,10) FROM blob, forumpost AS z" /* 3 */
" WHERE rid=z.fpid AND z.froot=x.froot"
" ORDER BY z.fmtime DESC LIMIT 1),"
" (SELECT substr(comment,instr(comment,':')+2)" /* 4 */
" FROM event WHERE objid=(SELECT fpid FROM forumpost AS y"
" WHERE y.froot=x.froot"
" ORDER BY fmtime DESC LIMIT 1))"
" FROM forumpost AS x"
" GROUP BY froot ORDER BY 1 LIMIT %d OFFSET %d;",
iLimit+1, iOfst
|