Fossil

Check-in [b4602502]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Be sure to send forum event notifications in chronological order.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: b4602502114bef6035687e1695743ed7132a1d584e37ab709d247204c83f3799
User & Date: drh 2018-08-10 20:30:29
Context
2018-08-10
23:28
Try to put the human name of the person who posted on the From: line of email notifications for new forum posts. check-in: ad419331 user: drh tags: trunk
20:30
Be sure to send forum event notifications in chronological order. check-in: b4602502 user: drh tags: trunk
17:08
Also remember the name the user for webmail. check-in: 800cd27d user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/email.c.

  1910   1910       "      FROM (SELECT group_concat(substr(tagname,5), ', ') AS x"
  1911   1911       "              FROM tag, tagxref"
  1912   1912       "             WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid"
  1913   1913       "               AND tagxref.rid=blob.rid AND tagxref.tagtype>0))"
  1914   1914       "  || ')' as comment,"       /* 2 */
  1915   1915       " wantalert.eventId,"        /* 3 */
  1916   1916       " wantalert.needMod"         /* 4 */
  1917         -    " FROM temp.wantalert CROSS JOIN event CROSS JOIN blob"
         1917  +    " FROM temp.wantalert, event, blob"
  1918   1918       " WHERE blob.rid=event.objid"
  1919   1919       "   AND event.objid=substr(wantalert.eventId,2)+0"
  1920   1920       "   AND (%d OR eventId NOT GLOB 'f*')"
  1921   1921       " ORDER BY event.mtime",
  1922   1922       doDigest
  1923   1923     );
  1924   1924     memset(&anchor, 0, sizeof(anchor));
................................................................................
  1979   1979       " substr(comment,instr(comment,':')+2),"                /* 3 */
  1980   1980       " (SELECT uuid FROM blob WHERE rid=forumpost.firt),"    /* 4 */
  1981   1981       " wantalert.needMod"                                    /* 5 */
  1982   1982       " FROM temp.wantalert, event, forumpost"
  1983   1983       " WHERE event.objid=substr(wantalert.eventId,2)+0"
  1984   1984       "   AND eventId GLOB 'f*'"
  1985   1985       "   AND forumpost.fpid=event.objid"
         1986  +    " ORDER BY event.mtime"
  1986   1987     );
  1987   1988     zFrom = db_get("email-self",0);
  1988   1989     zSub = db_get("email-subname","");
  1989   1990     while( db_step(&q)==SQLITE_ROW ){
  1990   1991       Manifest *pPost = manifest_get(db_column_int(&q,0), CFTYPE_FORUM, 0);
  1991   1992       const char *zIrt;
  1992   1993       const char *zUuid;