Fossil

Check-in [b0ae37c0]
Login

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:b0ae37c0391dc267daa9306491f0300b83ec82d7b877474ceeb106c682358178
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

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