X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2Finsert_message.sql;h=f7faa2950f1d20485d001a9d4488119f4c645ec9;hp=0a912998244e8e0f130b59dec8ab2b9bf64faf05;hb=092e6b212637ffbf68800584b7c1f32d1931b602;hpb=dba66762993507168b1a3de25cfd2d7bff0ff969;ds=sidebyside diff --git a/src/core/SQL/SQLite/insert_message.sql b/src/core/SQL/SQLite/insert_message.sql index 0a912998..f7faa295 100644 --- a/src/core/SQL/SQLite/insert_message.sql +++ b/src/core/SQL/SQLite/insert_message.sql @@ -1,2 +1,5 @@ INSERT INTO backlog (time, bufferid, type, flags, senderid, senderprefixes, message) -VALUES (:time, :bufferid, :type, :flags, (SELECT senderid FROM sender WHERE sender = :sender), :senderprefixes, :message) +VALUES (:time, :bufferid, :type, :flags, + (SELECT senderid FROM sender WHERE sender = :sender AND coalesce(realname, '') = coalesce(:realname, '') AND coalesce(avatarurl, '') = coalesce(:avatarurl, '')), + :senderprefixes, :message +)