diff options
author | Mario <mario@mariovavti.com> | 2024-12-05 11:27:56 +0000 |
---|---|---|
committer | Mario <mario@mariovavti.com> | 2024-12-05 11:27:56 +0000 |
commit | 15b6353c1c970abbb5bf2d89a11a0812aab2414f (patch) | |
tree | 80b747cc18395acf04c04369ccb5d156edaba444 /Zotlabs/Module | |
parent | 1a86348a6c609bef630d630d12de39b9f171f3f7 (diff) | |
download | volse-hubzilla-15b6353c1c970abbb5bf2d89a11a0812aab2414f.tar.gz volse-hubzilla-15b6353c1c970abbb5bf2d89a11a0812aab2414f.tar.bz2 volse-hubzilla-15b6353c1c970abbb5bf2d89a11a0812aab2414f.zip |
filtering censored xchans in mod pubstream queries has possible performance issues. we will filter them in process_delivery() instead
Diffstat (limited to 'Zotlabs/Module')
-rw-r--r-- | Zotlabs/Module/Pubstream.php | 8 |
1 files changed, 0 insertions, 8 deletions
diff --git a/Zotlabs/Module/Pubstream.php b/Zotlabs/Module/Pubstream.php index 6d8edf4d8..234e73792 100644 --- a/Zotlabs/Module/Pubstream.php +++ b/Zotlabs/Module/Pubstream.php @@ -202,11 +202,9 @@ class Pubstream extends \Zotlabs\Web\Controller { if($mid) { $r = q("SELECT parent AS item_id FROM item left join abook on item.author_xchan = abook.abook_xchan - left join xchan on item.author_xchan = xchan.xchan_hash WHERE item.$identifier = '%s' and item.item_private = 0 $uids $site_firehose_sql $item_normal - and xchan.xchan_censored = 0 and (abook.abook_blocked = 0 or abook.abook_flags is null) $sql_extra $net_query2", dbesc($mid) @@ -216,11 +214,9 @@ class Pubstream extends \Zotlabs\Web\Controller { // Fetch a page full of parent items for this page $r = dbq("SELECT parent AS item_id FROM item left join abook on ( item.author_xchan = abook.abook_xchan $abook_uids ) - left join xchan on item.author_xchan = xchan.xchan_hash WHERE item.item_private = 0 $thread_top $uids $site_firehose_sql $item_normal - and xchan.xchan_censored = 0 and (abook.abook_blocked = 0 or abook.abook_flags is null) $sql_extra $net_query2 ORDER BY $ordering DESC $pager_sql " @@ -231,10 +227,8 @@ class Pubstream extends \Zotlabs\Web\Controller { if($mid) { $r = q("SELECT parent AS item_id FROM item left join abook on item.author_xchan = abook.abook_xchan - left join xchan on item.author_xchan = xchan.xchan_hash WHERE item.$identifier = '%s' and item.item_private = 0 $uids $site_firehose_sql $item_normal_update $simple_update - and xchan.xchan_censored = 0 and (abook.abook_blocked = 0 or abook.abook_flags is null) $sql_extra $net_query2", dbesc($mid) @@ -243,11 +237,9 @@ class Pubstream extends \Zotlabs\Web\Controller { else { $r = dbq("SELECT parent AS item_id FROM item left join abook on item.author_xchan = abook.abook_xchan - left join xchan on item.author_xchan = xchan.xchan_hash WHERE item.item_private = 0 $thread_top $uids $site_firehose_sql $item_normal_update $simple_update - and xchan.xchan_censored = 0 and (abook.abook_blocked = 0 or abook.abook_flags is null) $sql_extra $net_query2" ); |