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: |
b4602502114bef6035687e1695743ed7 |
| 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
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;