aboutsummaryrefslogtreecommitdiffstats
path: root/Zotlabs/Module/Channel.php
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2018-02-11 19:36:37 -0800
committerzotlabs <mike@macgirvin.com>2018-02-11 19:36:37 -0800
commit0f8d2d4e58cd085de29c630babaf7df3a35393c3 (patch)
tree8da71ebff073f86212baf1a362063e8cdb86c4e7 /Zotlabs/Module/Channel.php
parent63107f5b2f5031a7cc971063b9344592cc2257e3 (diff)
parentba954b8cfeaf18477a5d7c17338efd909951744c (diff)
downloadvolse-hubzilla-0f8d2d4e58cd085de29c630babaf7df3a35393c3.tar.gz
volse-hubzilla-0f8d2d4e58cd085de29c630babaf7df3a35393c3.tar.bz2
volse-hubzilla-0f8d2d4e58cd085de29c630babaf7df3a35393c3.zip
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
Diffstat (limited to 'Zotlabs/Module/Channel.php')
-rw-r--r--Zotlabs/Module/Channel.php14
1 files changed, 7 insertions, 7 deletions
diff --git a/Zotlabs/Module/Channel.php b/Zotlabs/Module/Channel.php
index b7e18f954..3dab85410 100644
--- a/Zotlabs/Module/Channel.php
+++ b/Zotlabs/Module/Channel.php
@@ -204,7 +204,7 @@ class Channel extends \Zotlabs\Web\Controller {
$_SESSION['loadtime'] = datetime_convert();
}
else {
- $r = q("SELECT distinct parent AS item_id, created from item
+ $r = q("SELECT distinct parent AS item_id from item
left join abook on ( item.owner_xchan = abook.abook_xchan $abook_uids )
WHERE uid = %d $item_normal_update
AND item_wall = 1 $simple_update
@@ -249,13 +249,13 @@ class Channel extends \Zotlabs\Web\Controller {
}
}
else {
- $r = q("SELECT id AS item_id FROM item
- left join abook on item.author_xchan = abook.abook_xchan
- WHERE uid = %d $item_normal
- AND item_wall = 1 and item_thread_top = 1
- AND (abook_blocked = 0 or abook.abook_flags is null)
+ $r = q("SELECT item.parent AS item_id FROM item
+ left join abook on ( item.author_xchan = abook.abook_xchan $abook_uids )
+ WHERE true and uid = %d $item_normal
+ AND (abook.abook_blocked = 0 or abook.abook_flags is null)
+ AND item.item_wall = 1 AND item.item_thread_top = 1
$sql_extra $sql_extra2
- ORDER BY created DESC, id $pager_sql ",
+ ORDER BY created DESC $pager_sql ",
intval(\App::$profile['profile_uid'])
);
}