X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2Fselect_messagesForward.sql;h=e4e78193258f7f81dece7d638e3aad41c25c2cb0;hb=76883c546324b1fb80f465421d4e3c7732505852;hp=881bb9f6c965e50fdde3ecc51f5a8809284e9185;hpb=145a52eb79fed146731f85c23b60f0609e40e785;p=quassel.git diff --git a/src/core/SQL/SQLite/select_messagesForward.sql b/src/core/SQL/SQLite/select_messagesForward.sql index 881bb9f6..e4e78193 100644 --- a/src/core/SQL/SQLite/select_messagesForward.sql +++ b/src/core/SQL/SQLite/select_messagesForward.sql @@ -1,10 +1,10 @@ -SELECT messageid, time, type, flags, sender, senderprefixes, realname, avatarurl, message +SELECT messageid, time, type, flags, sender, senderprefixes, realname, avatarurl, message FROM backlog JOIN sender ON backlog.senderid = sender.senderid WHERE bufferid = :bufferid AND backlog.messageid >= :firstmsg AND backlog.messageid < :lastmsg - AND (:type = 0 OR backlog.type & :type != 0) - AND (:flags = 0 OR backlog.flags & :flags != 0) + AND (:type <= 0 OR backlog.type & :type != 0) + AND (:flags <= 0 OR backlog.flags & :flags != 0) ORDER BY messageid ASC LIMIT :limit