From: Janne Koschinski <janne@kuschku.de>
Date: Sun, 18 Feb 2018 20:14:35 +0000 (+0100)
Subject: Ignore self messages
X-Git-Tag: travis-deploy-test~153
X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=commitdiff_plain;h=d639576f81d65d3b1dbfc710be2f726bed55ae50

Ignore self messages

Closes GH-317.
---

diff --git a/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql b/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql
index 3156485a..2013c105 100644
--- 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
+     AND flags & 1 = 0
      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 3156485a..2013c105 100644
--- 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
+     AND flags & 1 = 0
      AND messageid > :lastseenmsgid) t;