Fossil SCM
Be sure to send forum event notifications in chronological order.
Commit
b4602502114bef6035687e1695743ed7132a1d584e37ab709d247204c83f3799
Parent
800cd27da76b31a…
1 file changed
+2
-1
+2
-1
| --- src/email.c | ||
| +++ src/email.c | ||
| @@ -1912,11 +1912,11 @@ | ||
| 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 |
| @@ -1981,10 +1981,11 @@ | ||
| 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 |
| --- src/email.c | |
| +++ src/email.c | |
| @@ -1912,11 +1912,11 @@ | |
| 1912 | " WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid" |
| 1913 | " AND tagxref.rid=blob.rid AND tagxref.tagtype>0))" |
| 1914 | " || ')' as comment," /* 2 */ |
| 1915 | " wantalert.eventId," /* 3 */ |
| 1916 | " wantalert.needMod" /* 4 */ |
| 1917 | " FROM temp.wantalert CROSS JOIN event CROSS JOIN blob" |
| 1918 | " WHERE blob.rid=event.objid" |
| 1919 | " AND event.objid=substr(wantalert.eventId,2)+0" |
| 1920 | " AND (%d OR eventId NOT GLOB 'f*')" |
| 1921 | " ORDER BY event.mtime", |
| 1922 | doDigest |
| @@ -1981,10 +1981,11 @@ | |
| 1981 | " wantalert.needMod" /* 5 */ |
| 1982 | " FROM temp.wantalert, event, forumpost" |
| 1983 | " WHERE event.objid=substr(wantalert.eventId,2)+0" |
| 1984 | " AND eventId GLOB 'f*'" |
| 1985 | " AND forumpost.fpid=event.objid" |
| 1986 | ); |
| 1987 | zFrom = db_get("email-self",0); |
| 1988 | zSub = db_get("email-subname",""); |
| 1989 | while( db_step(&q)==SQLITE_ROW ){ |
| 1990 | Manifest *pPost = manifest_get(db_column_int(&q,0), CFTYPE_FORUM, 0); |
| 1991 |
| --- src/email.c | |
| +++ src/email.c | |
| @@ -1912,11 +1912,11 @@ | |
| 1912 | " WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid" |
| 1913 | " AND tagxref.rid=blob.rid AND tagxref.tagtype>0))" |
| 1914 | " || ')' as comment," /* 2 */ |
| 1915 | " wantalert.eventId," /* 3 */ |
| 1916 | " wantalert.needMod" /* 4 */ |
| 1917 | " FROM temp.wantalert, event, blob" |
| 1918 | " WHERE blob.rid=event.objid" |
| 1919 | " AND event.objid=substr(wantalert.eventId,2)+0" |
| 1920 | " AND (%d OR eventId NOT GLOB 'f*')" |
| 1921 | " ORDER BY event.mtime", |
| 1922 | doDigest |
| @@ -1981,10 +1981,11 @@ | |
| 1981 | " wantalert.needMod" /* 5 */ |
| 1982 | " FROM temp.wantalert, event, forumpost" |
| 1983 | " WHERE event.objid=substr(wantalert.eventId,2)+0" |
| 1984 | " AND eventId GLOB 'f*'" |
| 1985 | " AND forumpost.fpid=event.objid" |
| 1986 | " ORDER BY event.mtime" |
| 1987 | ); |
| 1988 | zFrom = db_get("email-self",0); |
| 1989 | zSub = db_get("email-subname",""); |
| 1990 | while( db_step(&q)==SQLITE_ROW ){ |
| 1991 | Manifest *pPost = manifest_get(db_column_int(&q,0), CFTYPE_FORUM, 0); |
| 1992 |