namespace Friendica\Model;
use Friendica\Core\Addon;
+use Friendica\Core\Config\Capability\IManageConfigValues;
use Friendica\Database\DBA;
use Friendica\DI;
use stdClass;
$logger->info('user statistics', $userStats);
- $posts = DBA::count('post-thread', ["EXISTS(SELECT `uri-id` FROM `post-user` WHERE NOT `deleted` AND `origin` AND `uri-id` = `post-thread`.`uri-id`)"]);
- $comments = DBA::count('post', ["NOT `deleted` AND `gravity` = ? AND EXISTS(SELECT `uri-id` FROM `post-user` WHERE `origin` AND `uri-id` = `post`.`uri-id`)", GRAVITY_COMMENT]);
- $config->set('nodeinfo', 'local_posts', $posts);
+ $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`)", 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 = [];
if (!empty($config->get('system', 'nodeinfo'))) {
$usage->users = [
return $services;
}
- public static function getOrganization(\Friendica\Core\Config\Capability\IManageConfigValues $config)
+ /**
+ * Gathers organization information and returns it as an array
+ *
+ * @param IManageConfigValues $config Configuration instance
+ * @return array Organization information
+ */
+ public static function getOrganization(IManageConfigValues $config): array
{
$organization = [
'name' => null,