aboutsummaryrefslogtreecommitdiffstats
path: root/include/message.php
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2016-09-24 19:02:37 +0200
committerMario Vavti <mario@mariovavti.com>2016-09-24 19:02:37 +0200
commit8333d41dbda035d8adf6a3be7e22c77c205071b4 (patch)
tree00822d593e143f77ebfbd111f4e9600c44265198 /include/message.php
parent46504581579c5ad06ae4d4e5962fbc4130b8b6e2 (diff)
downloadvolse-hubzilla-8333d41dbda035d8adf6a3be7e22c77c205071b4.tar.gz
volse-hubzilla-8333d41dbda035d8adf6a3be7e22c77c205071b4.tar.bz2
volse-hubzilla-8333d41dbda035d8adf6a3be7e22c77c205071b4.zip
fix issue #528
Diffstat (limited to 'include/message.php')
-rw-r--r--include/message.php20
1 files changed, 18 insertions, 2 deletions
diff --git a/include/message.php b/include/message.php
index 0ba1978f0..0829ebaaa 100644
--- a/include/message.php
+++ b/include/message.php
@@ -299,14 +299,30 @@ function private_messages_list($uid, $mailbox = '', $start = 0, $numitems = 0) {
break;
case 'combined':
- $sql = "SELECT * FROM ( SELECT * FROM mail WHERE channel_id = $local_channel ORDER BY created DESC $limit ) AS temp_table GROUP BY parent_mid ORDER BY created DESC";
+ $parents = q("SELECT parent_mid FROM mail WHERE mid = parent_mid AND channel_id = %d ORDER BY created DESC",
+ dbesc($local_channel)
+ );
+ //FIXME: We need the latest mail of a thread here. This query throws errors in postgres. We now look for the latest in php until somebody can fix this...
+ //$sql = "SELECT * FROM ( SELECT * FROM mail WHERE channel_id = $local_channel ORDER BY created DESC $limit ) AS temp_table GROUP BY parent_mid ORDER BY created DESC";
break;
}
}
- $r = q($sql);
+ if($parents) {
+ foreach($parents as $parent) {
+ $all[] = q("SELECT * FROM mail WHERE parent_mid = '%s' AND channel_id = %d ORDER BY created DESC",
+ dbesc($parent['parent_mid']),
+ dbesc($local_channel)
+ );
+ }
+ foreach($all as $single)
+ $r[] = $single[0];
+ }
+ else {
+ $r = q($sql);
+ }
if(! $r) {
return array();