X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FModel%2FGServer.php;h=c4138cc2d01aba5f6eeb8670acf6d8018baf65f6;hb=40259c7f04e70e9c6488e7d17f01cb2033cb73e1;hp=c56e7701e0bbc225555a75a9c15485c3b8d0cf25;hpb=409d909d0f52395eae4bebf7960c368efed3865f;p=friendica.git diff --git a/src/Model/GServer.php b/src/Model/GServer.php index c56e7701e0..c4138cc2d0 100644 --- a/src/Model/GServer.php +++ b/src/Model/GServer.php @@ -1,6 +1,6 @@ '\_', '%' => '\%', '?' => '_', '*' => '%']); + + // The SUBSTRING_INDEX returns everything before the eventual third /, which effectively trims an + // eventual server path and keep only the server domain which we're matching against the pattern. + $sql = "SELECT `gserver`.*, COUNT(*) AS `contacts` + FROM `gserver` + LEFT JOIN `contact` ON `gserver`.`id` = `contact`.`gsid` + WHERE SUBSTRING_INDEX(`gserver`.`nurl`, '/', 3) LIKE ? + AND NOT `gserver`.`failed` + GROUP BY `gserver`.`id`"; + + $stmt = DI::dba()->p($sql, $likePattern); + + return DI::dba()->toArray($stmt); + } + /** * Checks if the given server is reachable * @@ -322,9 +350,9 @@ class GServer } // On a redirect follow the new host but mark the old one as failure - if ($curlResult->isSuccess() && (parse_url($url, PHP_URL_HOST) != parse_url($curlResult->getRedirectUrl(), PHP_URL_HOST))) { + if ($curlResult->isSuccess() && !empty($curlResult->getRedirectUrl()) && (parse_url($url, PHP_URL_HOST) != parse_url($curlResult->getRedirectUrl(), PHP_URL_HOST))) { $curlResult = DI::httpClient()->get($url, [HttpClientOptions::TIMEOUT => $xrd_timeout]); - if (parse_url($url, PHP_URL_HOST) != parse_url($curlResult->getRedirectUrl(), PHP_URL_HOST)) { + if (!empty($curlResult->getRedirectUrl()) && parse_url($url, PHP_URL_HOST) != parse_url($curlResult->getRedirectUrl(), PHP_URL_HOST)) { Logger::info('Found redirect. Mark old entry as failure', ['old' => $url, 'new' => $curlResult->getRedirectUrl()]); self::setFailure($url); self::detect($curlResult->getRedirectUrl(), $network, $only_nodeinfo); @@ -349,6 +377,12 @@ class GServer if (empty($nodeinfo['network']) || in_array($nodeinfo['network'], [Protocol::DFRN, Protocol::ZOT])) { if (!empty($nodeinfo['detection-method'])) { $serverdata['detection-method'] = $nodeinfo['detection-method']; + + foreach (['registered-users', 'active_users_monthly', 'active-halfyear-users', 'local-posts'] as $field) { + if (!empty($nodeinfo[$field])) { + $serverdata[$field] = $nodeinfo[$field]; + } + } } // Fetch the landing page, possibly it reveals some data @@ -361,7 +395,7 @@ class GServer $curlResult = DI::httpClient()->get($baseurl, [HttpClientOptions::TIMEOUT => $xrd_timeout]); if ($curlResult->isSuccess()) { - if ((parse_url($baseurl, PHP_URL_HOST) != parse_url($curlResult->getRedirectUrl(), PHP_URL_HOST))) { + if (!empty($curlResult->getRedirectUrl()) && (parse_url($baseurl, PHP_URL_HOST) != parse_url($curlResult->getRedirectUrl(), PHP_URL_HOST))) { Logger::info('Found redirect. Mark old entry as failure', ['old' => $url, 'new' => $curlResult->getRedirectUrl()]); self::setFailure($url); self::detect($curlResult->getRedirectUrl(), $network, $only_nodeinfo); @@ -441,6 +475,10 @@ class GServer $serverdata = self::detectGNUSocial($url, $serverdata); } + if (empty($serverdata['network'])) { + $serverdata = self::detectPumpIO($url, $serverdata); + } + $serverdata = array_merge($nodeinfo, $serverdata); } else { $serverdata = $nodeinfo; @@ -464,17 +502,21 @@ class GServer $serverdata['url'] = $url; $serverdata['nurl'] = Strings::normaliseLink($url); - // We take the highest number that we do find - $registeredUsers = $serverdata['registered-users'] ?? 0; + if (in_array($serverdata['network'], [Protocol::PHANTOM, Protocol::FEED])) { + $serverdata = self::detectNetworkViaContacts($url, $serverdata); + } - // On an active server there has to be at least a single user - if (($serverdata['network'] != Protocol::PHANTOM) && ($registeredUsers == 0)) { - $registeredUsers = 1; + if ($serverdata['network'] == Protocol::ACTIVITYPUB) { + $serverdata = self::fetchWeeklyUsage($url, $serverdata); } - if ($serverdata['network'] == Protocol::PHANTOM) { - $serverdata['registered-users'] = max($registeredUsers, 1); - $serverdata = self::detectNetworkViaContacts($url, $serverdata); + $serverdata['registered-users'] = $serverdata['registered-users'] ?? 0; + + // On an active server there has to be at least a single user + if (!in_array($serverdata['network'], [Protocol::PHANTOM, Protocol::FEED]) && ($serverdata['registered-users'] == 0)) { + $serverdata['registered-users'] = 1; + } elseif (in_array($serverdata['network'], [Protocol::PHANTOM, Protocol::FEED])) { + $serverdata['registered-users'] = 0; } $serverdata['next_contact'] = self::getNextUpdateDate(true); @@ -488,11 +530,6 @@ class GServer $ret = DBA::insert('gserver', $serverdata); $id = DBA::lastInsertId(); } else { - // Don't override the network with 'unknown' when there had been a valid entry before - if (($serverdata['network'] == Protocol::PHANTOM) && !empty($gserver['network'])) { - unset($serverdata['network']); - } - $ret = DBA::update('gserver', $serverdata, ['nurl' => $serverdata['nurl']]); $gserver = DBA::selectFirst('gserver', ['id'], ['nurl' => $serverdata['nurl']]); if (DBA::isResult($gserver)) { @@ -500,11 +537,12 @@ class GServer } } - if (!empty($serverdata['network']) && !empty($id) && ($serverdata['network'] != Protocol::PHANTOM)) { + // Count the number of known contacts from this server + if (!empty($id) && !in_array($serverdata['network'], [Protocol::PHANTOM, Protocol::FEED])) { $apcontacts = DBA::count('apcontact', ['gsid' => $id]); - $contacts = DBA::count('contact', ['uid' => 0, 'gsid' => $id]); - $max_users = max($apcontacts, $contacts, $registeredUsers, 1); - if ($max_users > $registeredUsers) { + $contacts = DBA::count('contact', ['uid' => 0, 'gsid' => $id, 'failed' => false]); + $max_users = max($apcontacts, $contacts); + if ($max_users > $serverdata['registered-users']) { Logger::info('Update registered users', ['id' => $id, 'url' => $serverdata['nurl'], 'registered-users' => $max_users]); DBA::update('gserver', ['registered-users' => $max_users], ['id' => $id]); } @@ -659,6 +697,21 @@ class GServer } } + if (!empty($data['total_users'])) { + $serverdata['registered-users'] = max($data['total_users'], 1); + } + + if (!empty($data['active_users_monthly'])) { + $serverdata['active-month-users'] = max($data['active_users_monthly'], 0); + } + + if (!empty($data['active_users_halfyear'])) { + $serverdata['active-halfyear-users'] = max($data['active_users_halfyear'], 0); + } + + if (!empty($data['local_posts'])) { + $serverdata['local-posts'] = max($data['local_posts'], 0); + } if (!empty($data['registrations_open'])) { $serverdata['register_policy'] = Register::OPEN; @@ -773,6 +826,22 @@ class GServer $server['registered-users'] = max($nodeinfo['usage']['users']['total'], 1); } + if (!empty($nodeinfo['usage']['users']['activeMonth'])) { + $server['active-month-users'] = max($nodeinfo['usage']['users']['activeMonth'], 0); + } + + if (!empty($nodeinfo['usage']['users']['activeHalfyear'])) { + $server['active-halfyear-users'] = max($nodeinfo['usage']['users']['activeHalfyear'], 0); + } + + if (!empty($nodeinfo['usage']['localPosts'])) { + $server['local-posts'] = max($nodeinfo['usage']['localPosts'], 0); + } + + if (!empty($nodeinfo['usage']['localComments'])) { + $server['local-comments'] = max($nodeinfo['usage']['localComments'], 0); + } + if (!empty($nodeinfo['protocols']['inbound']) && is_array($nodeinfo['protocols']['inbound'])) { $protocols = []; foreach ($nodeinfo['protocols']['inbound'] as $protocol) { @@ -850,6 +919,22 @@ class GServer $server['registered-users'] = max($nodeinfo['usage']['users']['total'], 1); } + if (!empty($nodeinfo['usage']['users']['activeMonth'])) { + $server['active-month-users'] = max($nodeinfo['usage']['users']['activeMonth'], 0); + } + + if (!empty($nodeinfo['usage']['users']['activeHalfyear'])) { + $server['active-halfyear-users'] = max($nodeinfo['usage']['users']['activeHalfyear'], 0); + } + + if (!empty($nodeinfo['usage']['localPosts'])) { + $server['local-posts'] = max($nodeinfo['usage']['localPosts'], 0); + } + + if (!empty($nodeinfo['usage']['localComments'])) { + $server['local-comments'] = max($nodeinfo['usage']['localComments'], 0); + } + if (!empty($nodeinfo['protocols'])) { $protocols = []; foreach ($nodeinfo['protocols'] as $protocol) { @@ -929,6 +1014,22 @@ class GServer $serverdata['registered-users'] = max($data['channels_total'], 1); } + if (!empty($data['channels_active_monthly'])) { + $serverdata['active-month-users'] = max($data['channels_active_monthly'], 0); + } + + if (!empty($data['channels_active_halfyear'])) { + $serverdata['active-halfyear-users'] = max($data['channels_active_halfyear'], 0); + } + + if (!empty($data['local_posts'])) { + $serverdata['local-posts'] = max($data['local_posts'], 0); + } + + if (!empty($data['local_comments'])) { + $serverdata['local-comments'] = max($data['local_comments'], 0); + } + if (!empty($data['register_policy'])) { switch ($data['register_policy']) { case 'REGISTER_OPEN': @@ -1022,16 +1123,18 @@ class GServer return $serverdata; } + $time = time(); foreach ($contacts as $contact) { - $probed = Contact::getByURL($contact); - if (!empty($probed) && in_array($probed['network'], Protocol::FEDERATED)) { + $probed = Contact::getByURL($contact, true); + if (!empty($probed) && !$probed['failed'] && in_array($probed['network'], Protocol::FEDERATED)) { $serverdata['network'] = $probed['network']; break; + } elseif ((time() - $time) > 10) { + // To reduce the stress on remote systems we probe a maximum of 10 seconds + break; } } - $serverdata['registered-users'] = max($serverdata['registered-users'], count($contacts), 1); - return $serverdata; } @@ -1178,6 +1281,38 @@ class GServer return $serverdata; } + private static function fetchWeeklyUsage(string $url, array $serverdata) { + $curlResult = DI::httpClient()->get($url . '/api/v1/instance/activity'); + + if (!$curlResult->isSuccess() || ($curlResult->getBody() == '')) { + return $serverdata; + } + + $data = json_decode($curlResult->getBody(), true); + if (empty($data)) { + return $serverdata; + } + + $current_week = []; + foreach ($data as $week) { + // Use only data from a full week + if (empty($week['week']) || (time() - $week['week']) < 7 * 24 * 60 * 60) { + continue; + } + + // Most likely the data is sorted correctly. But we better are safe than sorry + if (empty($current_week['week']) || ($current_week['week'] < $week['week'])) { + $current_week = $week; + } + } + + if (!empty($current_week['logins'])) { + $serverdata['active-week-users'] = max($current_week['logins'], 0); + } + + return $serverdata; + } + /** * Detects data from a given server url if it was a mastodon alike system * @@ -1339,7 +1474,57 @@ class GServer } return $val; - } + } + + /** + * Detect if the URL belongs to a pump.io server + * + * @param string $url URL of the given server + * @param array $serverdata array with server data + * + * @return array server data + */ + private static function detectPumpIO(string $url, array $serverdata) + { + $curlResult = DI::httpClient()->get($url . '/.well-known/host-meta.json'); + if (!$curlResult->isSuccess()) { + return $serverdata; + } + + $data = json_decode($curlResult->getBody(), true); + if (empty($data['links'])) { + return $serverdata; + + } + + // We are looking for some endpoints that are typical for pump.io + $trust = 0; + foreach ($data['links'] as $link) { + if (empty($link['rel'])) { + continue; + } + if (in_array($link['rel'], ['registration_endpoint', 'dialback', 'http://apinamespace.org/activitypub/whoami'])) { + ++$trust; + } + } + + if ($trust == 3) { + $serverdata['detection-method'] = self::DETECT_PUMPIO; + + $serverdata['platform'] = 'pumpio'; + $serverdata['version'] = ''; + $serverdata['network'] = Protocol::PUMPIO; + + $servers = $curlResult->getHeader('Server'); + foreach ($servers as $server) { + if (preg_match("#pump.io/(.*)\s#U", $server, $matches)) { + $serverdata['version'] = $matches[1]; + } + } + } + + return $serverdata; + } /** * Detect if the URL belongs to a GNU Social server @@ -1484,6 +1669,10 @@ class GServer return $serverdata; } + // Using only body information we cannot safely detect a lot of systems. + // So we define a list of platforms that we can detect safely. + $valid_platforms = ['friendica', 'friendika', 'diaspora', 'mastodon', 'hubzilla', 'misskey', 'peertube', 'wordpress', 'write.as']; + $doc = new DOMDocument(); @$doc->loadHTML($curlResult->getBody()); $xpath = new DOMXPath($doc); @@ -1533,11 +1722,8 @@ class GServer $serverdata['version'] = $version_part[1]; // We still do need a reliable test if some AP plugin is activated - if (DBA::exists('apcontact', ['baseurl' => $url])) { - $serverdata['network'] = Protocol::ACTIVITYPUB; - } else { - $serverdata['network'] = Protocol::FEED; - } + // By now we just check in a later process for some known contacts + $serverdata['network'] = Protocol::FEED; if ($serverdata['detection-method'] == self::DETECT_MANUAL) { $serverdata['detection-method'] = self::DETECT_BODY; @@ -1597,7 +1783,11 @@ class GServer } } - if (!empty($serverdata['network']) && ($serverdata['detection-method'] == self::DETECT_MANUAL)) { + if (!empty($serverdata['platform']) && in_array($serverdata['detection-method'], [self::DETECT_MANUAL, self::DETECT_BODY]) && !in_array($serverdata['platform'], $valid_platforms)) { + $serverdata['network'] = Protocol::PHANTOM; + $serverdata['version'] = ''; + $serverdata['detection-method'] = self::DETECT_MANUAL; + } elseif (!empty($serverdata['network']) && ($serverdata['detection-method'] == self::DETECT_MANUAL)) { $serverdata['detection-method'] = self::DETECT_BODY; }