From be7b028fb2d78c462d15dd2fbd05e548a99cb4ef Mon Sep 17 00:00:00 2001 From: Marcus Eggenberger Date: Sat, 29 Nov 2008 17:41:52 +0100 Subject: [PATCH] missing files --- src/core/SQL/SQLite/11/select_messagesAll.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 src/core/SQL/SQLite/11/select_messagesAll.sql diff --git a/src/core/SQL/SQLite/11/select_messagesAll.sql b/src/core/SQL/SQLite/11/select_messagesAll.sql new file mode 100644 index 00000000..52285aff --- /dev/null +++ b/src/core/SQL/SQLite/11/select_messagesAll.sql @@ -0,0 +1,8 @@ +SELECT messageid, bufferid, time, type, flags, sender, message +FROM backlog +JOIN sender ON backlog.senderid = sender.senderid +WHERE backlog.bufferid IN (SELECT bufferid FROM buffer WHERE userid = :userid) + AND backlog.messageid >= :firstmsg + AND backlog.messageid < :lastmsg +ORDER BY messageid DESC +LIMIT :limit -- 2.20.1