X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FModel%2FNodeinfo.php;h=d2e168fa5961788641f32905e84fe7a7158ec8b8;hb=33eda87bc45fe2b7cd9c001bd76cb0821bd9303e;hp=6d9c77154a17b720c570f3ab04663c05e39b7b94;hpb=03038e7a3bb74bdab497d26b7f829a5c3036d1c2;p=friendica.git

diff --git a/src/Model/Nodeinfo.php b/src/Model/Nodeinfo.php
index 6d9c77154a..d2e168fa59 100644
--- a/src/Model/Nodeinfo.php
+++ b/src/Model/Nodeinfo.php
@@ -1,4 +1,23 @@
 <?php
+/**
+ * @copyright Copyright (C) 2020, Friendica
+ *
+ * @license GNU AGPL version 3 or any later version
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ *
+ */
 
 namespace Friendica\Model;
 
@@ -24,20 +43,7 @@ class Nodeinfo
 		// If the addon 'statistics_json' is enabled then disable it and activate nodeinfo.
 		if (Addon::isEnabled('statistics_json')) {
 			$config->set('system', 'nodeinfo', true);
-
-			$addon = 'statistics_json';
-			$addons = $config->get('system', 'addon');
-
-			if ($addons) {
-				$addons_arr = explode(',', str_replace(' ', '', $addons));
-
-				$idx = array_search($addon, $addons_arr);
-				if ($idx !== false) {
-					unset($addons_arr[$idx]);
-					Addon::uninstall($addon);
-					$config->set('system', 'addon', implode(', ', $addons_arr));
-				}
-			}
+			Addon::uninstall('statistics_json');
 		}
 
 		if (empty($config->get('system', 'nodeinfo'))) {
@@ -52,12 +58,15 @@ class Nodeinfo
 
 		$logger->debug('user statistics', $userStats);
 
-		$local_posts = DBA::count('thread', ["`wall` AND NOT `deleted` AND `uid` != 0"]);
-		$config->set('nodeinfo', 'local_posts', $local_posts);
-		$logger->debug('thread statistics', ['local_posts' => $local_posts]);
-
-		$local_comments = DBA::count('item', ["`origin` AND `id` != `parent` AND NOT `deleted` AND `uid` != 0"]);
-		$config->set('nodeinfo', 'local_comments', $local_comments);
-		$logger->debug('item statistics', ['local_comments' => $local_comments]);
+		$items = DBA::p("SELECT COUNT(*) AS `total`, `gravity` FROM `item` WHERE `origin` AND NOT `deleted` AND `uid` != 0 AND `gravity` IN (?, ?) GROUP BY `gravity`",
+			GRAVITY_PARENT, GRAVITY_COMMENT);
+		while ($item = DBA::fetch($items)) {
+			if ($item['gravity'] == GRAVITY_PARENT) {
+				$config->set('nodeinfo', 'local_posts', $item['total']);
+			} elseif ($item['gravity'] == GRAVITY_COMMENT) {
+				$config->set('nodeinfo', 'local_comments', $item['total']);
+			}
+		}
+		DBA::close($items);
 	}
 }