projects / quassel.git / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 5fcc2f0)
Ignore self messages
authorJanne Koschinski <janne@kuschku.de>
Sun, 18 Feb 2018 20:14:35 +0000 (21:14 +0100)
committerManuel Nickschas <sputnick@quassel-irc.org>
Wed, 28 Mar 2018 21:08:32 +0000 (23:08 +0200)
Closes GH-317.

src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql patch | blob | history
src/core/SQL/SQLite/select_buffer_bufferactivity.sql patch | blob | history

diff --git a/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql b/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql
index 3156485..2013c10 100644 (file)
--- a/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql
+++ b/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql
@@ -3,4 +3,5 @@ FROM
   (SELECT DISTINCT TYPE
    FROM backlog
    WHERE bufferid = :bufferid
   (SELECT DISTINCT TYPE
    FROM backlog
    WHERE bufferid = :bufferid
+     AND flags & 1 = 0
      AND messageid > :lastseenmsgid) t;
      AND messageid > :lastseenmsgid) t;
diff --git a/src/core/SQL/SQLite/select_buffer_bufferactivity.sql b/src/core/SQL/SQLite/select_buffer_bufferactivity.sql
index 3156485..2013c10 100644 (file)
--- a/src/core/SQL/SQLite/select_buffer_bufferactivity.sql
+++ b/src/core/SQL/SQLite/select_buffer_bufferactivity.sql
@@ -3,4 +3,5 @@ FROM
   (SELECT DISTINCT TYPE
    FROM backlog
    WHERE bufferid = :bufferid
   (SELECT DISTINCT TYPE
    FROM backlog
    WHERE bufferid = :bufferid
+     AND flags & 1 = 0
      AND messageid > :lastseenmsgid) t;
      AND messageid > :lastseenmsgid) t;
Quassel IRC