Fossil SCM
For email alerts on forum posts that are in reply to a prior post that has been edited, make the In-Reply-To point to the Message-Id of the original unedited post. This should help avoid breaking threads in email readers for subscribers who do not receive notification of post edits. [https://www.fossil-scm.org/forum/info/db34def829be984c|bug report].
Commit
137cba6f1b81170d35627cd62d03759d15ad884ca5080ae52c102a91e3dd4be1
Parent
aad4c2485b70659…
1 file changed
+3
-1
+3
-1
| --- src/alerts.c | ||
| +++ src/alerts.c | ||
| @@ -2214,11 +2214,13 @@ | ||
| 2214 | 2214 | "SELECT" |
| 2215 | 2215 | " forumpost.fpid," /* 0 */ |
| 2216 | 2216 | " (SELECT uuid FROM blob WHERE rid=forumpost.fpid)," /* 1 */ |
| 2217 | 2217 | " datetime(event.mtime)," /* 2 */ |
| 2218 | 2218 | " substr(comment,instr(comment,':')+2)," /* 3 */ |
| 2219 | - " (SELECT uuid FROM blob WHERE rid=forumpost.firt)," /* 4 */ | |
| 2219 | + " (SELECT uuid FROM blob, forumpost AS irt" | |
| 2220 | + " WHERE irt.fpid=forumpost.firt" | |
| 2221 | + " AND blob.rid=coalesce(irt.fprev,irt.fpid))," /* 4 */ | |
| 2220 | 2222 | " wantalert.needMod," /* 5 */ |
| 2221 | 2223 | " coalesce(display_name(info),euser,user)," /* 6 */ |
| 2222 | 2224 | " forumpost.fprev IS NULL" /* 7 */ |
| 2223 | 2225 | " FROM temp.wantalert, event, forumpost" |
| 2224 | 2226 | " LEFT JOIN user ON (login=coalesce(euser,user))" |
| 2225 | 2227 |
| --- src/alerts.c | |
| +++ src/alerts.c | |
| @@ -2214,11 +2214,13 @@ | |
| 2214 | "SELECT" |
| 2215 | " forumpost.fpid," /* 0 */ |
| 2216 | " (SELECT uuid FROM blob WHERE rid=forumpost.fpid)," /* 1 */ |
| 2217 | " datetime(event.mtime)," /* 2 */ |
| 2218 | " substr(comment,instr(comment,':')+2)," /* 3 */ |
| 2219 | " (SELECT uuid FROM blob WHERE rid=forumpost.firt)," /* 4 */ |
| 2220 | " wantalert.needMod," /* 5 */ |
| 2221 | " coalesce(display_name(info),euser,user)," /* 6 */ |
| 2222 | " forumpost.fprev IS NULL" /* 7 */ |
| 2223 | " FROM temp.wantalert, event, forumpost" |
| 2224 | " LEFT JOIN user ON (login=coalesce(euser,user))" |
| 2225 |
| --- src/alerts.c | |
| +++ src/alerts.c | |
| @@ -2214,11 +2214,13 @@ | |
| 2214 | "SELECT" |
| 2215 | " forumpost.fpid," /* 0 */ |
| 2216 | " (SELECT uuid FROM blob WHERE rid=forumpost.fpid)," /* 1 */ |
| 2217 | " datetime(event.mtime)," /* 2 */ |
| 2218 | " substr(comment,instr(comment,':')+2)," /* 3 */ |
| 2219 | " (SELECT uuid FROM blob, forumpost AS irt" |
| 2220 | " WHERE irt.fpid=forumpost.firt" |
| 2221 | " AND blob.rid=coalesce(irt.fprev,irt.fpid))," /* 4 */ |
| 2222 | " wantalert.needMod," /* 5 */ |
| 2223 | " coalesce(display_name(info),euser,user)," /* 6 */ |
| 2224 | " forumpost.fprev IS NULL" /* 7 */ |
| 2225 | " FROM temp.wantalert, event, forumpost" |
| 2226 | " LEFT JOIN user ON (login=coalesce(euser,user))" |
| 2227 |