From 2035828042e50f2c23f55d80b19fb898b170e6e5 Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Sun, 24 Jan 2021 19:55:29 +0000
Subject: revert externals/zotfeed functionality due to scaling issues. Save
 zotfeed consumers that are not our contacts in thread listeners

---
 include/items.php | 31 +++++--------------------------
 1 file changed, 5 insertions(+), 26 deletions(-)

(limited to 'include/items.php')

diff --git a/include/items.php b/include/items.php
index 7229b66eb..83108455f 100755
--- a/include/items.php
+++ b/include/items.php
@@ -4375,38 +4375,17 @@ function zot_feed($uid, $observer_hash, $arr) {
 	$item_normal = item_normal();
 
 	if (is_sys_channel($uid)) {
+
 		$nonsys_uids     = q("SELECT channel_id FROM channel WHERE channel_system = 0");
 		$nonsys_uids_str = ids_to_querystr($nonsys_uids, 'channel_id');
 
-		if ($arr['total']) {
-			$items = q("SELECT count(created) AS total FROM item
-				WHERE uid IN ( %s )
-				AND item_private = 0
-				$sql_extra $item_normal",
-				dbesc($nonsys_uids_str)
-			);
-			if ($items) {
-				return intval($items[0]['total']);
-			}
-			return 0;
-		}
-
-		$itemspage = (($uid) ? get_pconfig($uid, 'system', 'itemspage') : 30);
-		App::set_pager_itemspage(((intval($itemspage)) ? $itemspage : 30));
-		$pager_sql = sprintf(" LIMIT %d OFFSET %d ", intval(App::$pager['itemspage']), intval(App::$pager['start']));
-
-		$items = q("SELECT item.*, item.id AS item_id FROM item
+		$r = q("SELECT parent, postopts FROM item
 			WHERE uid IN ( %s )
 			AND item_private = 0
-			$item_normal $sql_extra
-			ORDER BY item.created DESC $pager_sql",
+			$item_normal
+			$sql_extra ORDER BY created ASC $limit",
 			dbesc($nonsys_uids_str)
 		);
-
-		xchan_query($items);
-		$items = fetch_post_tags($items, true);
-
-		return $items;
 	}
 	else {
 		$r = q("SELECT parent, postopts FROM item
@@ -4432,6 +4411,7 @@ function zot_feed($uid, $observer_hash, $arr) {
 
 		$parents_str = ids_to_querystr($parents, 'parent');
 		$sys_query   = ((is_sys_channel($uid)) ? $sql_extra : '');
+		$item_normal = item_normal();
 
 		$items = q("SELECT item.*, item.id AS item_id FROM item
 			WHERE item.parent IN ( %s ) $item_normal $sys_query ",
@@ -4456,7 +4436,6 @@ function zot_feed($uid, $observer_hash, $arr) {
 	return $result;
 }
 
-
 function items_fetch($arr,$channel = null,$observer_hash = null,$client_mode = CLIENT_MODE_NORMAL,$module = 'network') {
 
 	$result = array('success' => false);
-- 
cgit v1.2.3