X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fselect_messagesForward.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2Fselect_messagesForward.sql;h=d8e76e8c757e142a986f04620aa069927e989530;hp=e645e96b8608818bbb7e0dcbd00d0aad6ac4081c;hb=76883c546324b1fb80f465421d4e3c7732505852;hpb=145a52eb79fed146731f85c23b60f0609e40e785 diff --git a/src/core/SQL/PostgreSQL/select_messagesForward.sql b/src/core/SQL/PostgreSQL/select_messagesForward.sql index e645e96b..d8e76e8c 100644 --- a/src/core/SQL/PostgreSQL/select_messagesForward.sql +++ b/src/core/SQL/PostgreSQL/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 backlog.messageid >= $1 AND backlog.messageid < $2 AND bufferid = $3 - AND backlog.type & $4 != 0 - AND ($5 = 0 OR backlog.flags & $5 != 0) + AND ($4 <= 0 OR backlog.type & $4 != 0) + AND ($5 <= 0 OR backlog.flags & $5 != 0) ORDER BY messageid ASC LIMIT $6