X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2Fselect_buffer_bufferactivity.sql;h=53cff939196f955a4a71cb67ff5678fabd5b47a4;hb=68b12b0b035c460c7bab93959004bd83c0b160f2;hp=294a6ccb2042c06bc9175b1f2c816cf13af93e0e;hpb=e5d6f457a0f3eef578dcb9d7e4a3db61826dc232;p=quassel.git diff --git a/src/core/SQL/SQLite/select_buffer_bufferactivity.sql b/src/core/SQL/SQLite/select_buffer_bufferactivity.sql index 294a6ccb..53cff939 100644 --- a/src/core/SQL/SQLite/select_buffer_bufferactivity.sql +++ b/src/core/SQL/SQLite/select_buffer_bufferactivity.sql @@ -3,4 +3,6 @@ FROM (SELECT DISTINCT TYPE FROM backlog WHERE bufferid = :bufferid - AND messageid > :lastseenmsgid) t; \ No newline at end of file + AND flags & 32 = 0 + AND flags & 1 = 0 + AND messageid > :lastseenmsgid) t;