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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
b4602502114bef6035687e1695743ed7 |
User & Date: | drh 2018-08-10 20:30:29.449 |
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
Changes to src/email.c.
︙ | |||
1910 1911 1912 1913 1914 1915 1916 | 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 | - + | " FROM (SELECT group_concat(substr(tagname,5), ', ') AS x" " FROM tag, tagxref" " WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid" " AND tagxref.rid=blob.rid AND tagxref.tagtype>0))" " || ')' as comment," /* 2 */ " wantalert.eventId," /* 3 */ " wantalert.needMod" /* 4 */ |
︙ | |||
1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 | 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 | + | " substr(comment,instr(comment,':')+2)," /* 3 */ " (SELECT uuid FROM blob WHERE rid=forumpost.firt)," /* 4 */ " wantalert.needMod" /* 5 */ " FROM temp.wantalert, event, forumpost" " WHERE event.objid=substr(wantalert.eventId,2)+0" " AND eventId GLOB 'f*'" " AND forumpost.fpid=event.objid" " ORDER BY event.mtime" ); zFrom = db_get("email-self",0); zSub = db_get("email-subname",""); while( db_step(&q)==SQLITE_ROW ){ Manifest *pPost = manifest_get(db_column_int(&q,0), CFTYPE_FORUM, 0); const char *zIrt; const char *zUuid; |
︙ |