aboutsummaryrefslogtreecommitdiffstats
path: root/include/items.php
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-07-29 20:31:02 -0700
committerfriendica <info@friendica.com>2013-07-29 20:31:02 -0700
commit79dacc3f1ad86aabfc78c0ecb8603720dedd4cfe (patch)
tree691b1c2642b6cdc59f2fb91f54534a6196cc5ed1 /include/items.php
parent7b3c29ebe69726f7d42c9327bebb2ea7251bccb4 (diff)
downloadvolse-hubzilla-79dacc3f1ad86aabfc78c0ecb8603720dedd4cfe.tar.gz
volse-hubzilla-79dacc3f1ad86aabfc78c0ecb8603720dedd4cfe.tar.bz2
volse-hubzilla-79dacc3f1ad86aabfc78c0ecb8603720dedd4cfe.zip
fix some weirdness on the zot feed
Diffstat (limited to 'include/items.php')
-rwxr-xr-xinclude/items.php33
1 files changed, 21 insertions, 12 deletions
diff --git a/include/items.php b/include/items.php
index b22c02955..2d0966518 100755
--- a/include/items.php
+++ b/include/items.php
@@ -4743,28 +4743,37 @@ function zot_feed($uid,$observer_xchan,$mindate) {
$sql_extra .= " and created > '$mindate' ";
-// FIXME
- // We probably should use two queries and pick up total conversations.
- // For now get a chunk of raw posts in ascending created order so that
- // hopefully the parent is imported before we see the kids.
- // This will fail if there are more than $limit kids and you didn't
- // receive the parent via direct delivery
-
- $limit = 200;
+ $limit = 50;
+ $items = array();
- $items = q("SELECT item.* from item
- WHERE uid = %d AND item_restrict = 0
+ $r = q("SELECT item.*, item.id as item_id from item
+ WHERE uid = %d AND item_restrict = 0 and id = parent
AND (item_flags & %d)
$sql_extra ORDER BY created ASC limit 0, $limit",
intval($uid),
intval(ITEM_WALL)
);
+ if($r) {
+
+ $parents_str = ids_to_querystr($r,'id');
+
+ $items = q("SELECT `item`.*, `item`.`id` AS `item_id` FROM `item`
+ WHERE `item`.`uid` = %d AND `item`.`item_restrict` = 0
+ AND `item`.`parent` IN ( %s ) ",
+ intval($uid),
+ dbesc($parents_str)
+ );
+
+ }
+
if($items) {
xchan_query($items);
$items = fetch_post_tags($items);
- } else {
- $items = array();
+ $items = conv_sort($items,'ascending');
+
}
+ else
+ $items = array();
foreach($items as $item)
$result[] = encode_item($item);