X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fselect_messagesForward.sql;h=d8e76e8c757e142a986f04620aa069927e989530;hb=76883c546324b1fb80f465421d4e3c7732505852;hp=e645e96b8608818bbb7e0dcbd00d0aad6ac4081c;hpb=097f625c4bd147f4127573ad8ab48555f9dc62d3;p=quassel.git 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