<?php
/**
- * @copyright Copyright (C) 2020, Friendica
+ * @copyright Copyright (C) 2010-2022, the Friendica project
*
* @license GNU AGPL version 3 or any later version
*
namespace Friendica\Model;
use Friendica\Core\Addon;
+use Friendica\Core\Config\Capability\IManageConfigValues;
use Friendica\Database\DBA;
use Friendica\DI;
+use Friendica\Model\Item;
use stdClass;
/**
$config->set('nodeinfo', 'active_users_monthly', $userStats['active_users_monthly']);
$config->set('nodeinfo', 'active_users_weekly', $userStats['active_users_weekly']);
- $logger->debug('user statistics', $userStats);
+ $logger->info('user statistics', $userStats);
- $items = DBA::p("SELECT COUNT(*) AS `total`, `gravity` FROM `post-view` 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);
+ $posts = DBA::count('post-thread', ["`uri-id` IN (SELECT `uri-id` FROM `post-user` WHERE NOT `deleted` AND `origin`)"]);
+ $comments = DBA::count('post', ["NOT `deleted` AND `gravity` = ? AND `uri-id` IN (SELECT `uri-id` FROM `post-user` WHERE `origin`)", Item::GRAVITY_COMMENT]);
+ $config->set('nodeinfo', 'local_posts', $posts);
+ $config->set('nodeinfo', 'local_comments', $comments);
+
+ $logger->info('User actitivy', ['posts' => $posts, 'comments' => $comments]);
}
/**
$config = DI::config();
$usage = new stdClass();
+ $usage->users = new \stdClass;
if (!empty($config->get('system', 'nodeinfo'))) {
- $usage->users = [
- 'total' => intval($config->get('nodeinfo', 'total_users')),
- 'activeHalfyear' => intval($config->get('nodeinfo', 'active_users_halfyear')),
- 'activeMonth' => intval($config->get('nodeinfo', 'active_users_monthly'))
- ];
+ $usage->users->total = intval($config->get('nodeinfo', 'total_users'));
+ $usage->users->activeHalfyear = intval($config->get('nodeinfo', 'active_users_halfyear'));
+ $usage->users->activeMonth = intval($config->get('nodeinfo', 'active_users_monthly'));
$usage->localPosts = intval($config->get('nodeinfo', 'local_posts'));
$usage->localComments = intval($config->get('nodeinfo', 'local_comments'));
if ($version2) {
- $usage->users['activeWeek'] = intval($config->get('nodeinfo', 'active_users_weekly'));
+ $usage->users->activeWeek = intval($config->get('nodeinfo', 'active_users_weekly'));
}
}
*
* @return array with supported services
*/
- public static function getServices()
+ public static function getServices(): array
{
$services = [
'inbound' => [],
return $services;
}
- public static function getOrganization($config)
+ /**
+ * Gathers organization information and returns it as an array
+ *
+ * @param IManageConfigValues $config Configuration instance
+ * @return array Organization information
+ * @throws \Exception
+ */
+ public static function getOrganization(IManageConfigValues $config): array
{
- $organization = ['name' => null, 'contact' => null, 'account' => null];
-
- if (!empty($config->get('config', 'admin_email'))) {
- $adminList = explode(',', str_replace(' ', '', $config->get('config', 'admin_email')));
- $organization['contact'] = $adminList[0];
- $administrator = User::getByEmail($adminList[0], ['username', 'nickname']);
- if (!empty($administrator)) {
- $organization['name'] = $administrator['username'];
- $organization['account'] = DI::baseUrl()->get() . '/profile/' . $administrator['nickname'];
- }
- }
+ $administrator = User::getFirstAdmin(['username', 'email', 'nickname']);
- return $organization;
+ return [
+ 'name' => $administrator['username'] ?? null,
+ 'contact' => $administrator['email'] ?? null,
+ 'account' => $administrator['nickname'] ?? '' ? DI::baseUrl()->get() . '/profile/' . $administrator['nickname'] : null,
+ ];
}
}