src/Protocol/PortableContact.php

   1 <?php
   2 /**
   3  * @file src/Protocol/PortableContact.php
   4  *
   5  * @todo Move GNU Social URL schemata (http://server.tld/user/number) to http://server.tld/username
   6  * @todo Fetch profile data from profile page for Redmatrix users
   7  * @todo Detect if it is a forum
   8  */
   9
  10 namespace Friendica\Protocol;
  11
  12 use Friendica\Core\Config;
  13 use Friendica\Core\Worker;
  14 use Friendica\Database\DBM;
  15 use Friendica\Model\GContact;
  16 use Friendica\Model\Profile;
  17 use Friendica\Network\Probe;
  18 use dba;
  19 use DOMDocument;
  20 use DOMXPath;
  21 use Exception;
  22
  23 require_once 'include/dba.php';
  24 require_once 'include/datetime.php';
  25 require_once 'include/network.php';
  26 require_once 'include/html2bbcode.php';
  27
  28 class PortableContact
  29 {
  30         /**
  31          * @brief Fetch POCO data
  32          *
  33          * @param integer $cid  Contact ID
  34          * @param integer $uid  User ID
  35          * @param integer $zcid Global Contact ID
  36          * @param integer $url  POCO address that should be polled
  37          *
  38          * Given a contact-id (minimum), load the PortableContacts friend list for that contact,
  39          * and add the entries to the gcontact (Global Contact) table, or update existing entries
  40          * if anything (name or photo) has changed.
  41          * We use normalised urls for comparison which ignore http vs https and www.domain vs domain
  42          *
  43          * Once the global contact is stored add (if necessary) the contact linkage which associates
  44          * the given uid, cid to the global contact entry. There can be many uid/cid combinations
  45          * pointing to the same global contact id.
  46          *
  47          */
  48         public static function loadWorker($cid, $uid = 0, $zcid = 0, $url = null)
  49         {
  50                 // Call the function "load" via the worker
  51                 Worker::add(PRIORITY_LOW, "DiscoverPoCo", "load", (int)$cid, (int)$uid, (int)$zcid, $url);
  52         }
  53
  54         /**
  55          * @brief Fetch POCO data from the worker
  56          *
  57          * @param integer $cid  Contact ID
  58          * @param integer $uid  User ID
  59          * @param integer $zcid Global Contact ID
  60          * @param integer $url  POCO address that should be polled
  61          *
  62          */
  63         public static function load($cid, $uid, $zcid, $url)
  64         {
  65                 $a = get_app();
  66
  67                 if ($cid) {
  68                         if (!$url || !$uid) {
  69                                 $r = dba::select('contact', ['poco', 'uid'], ['id' => $cid], ['limit' => 1]);
  70                                 if (DBM::is_result($r)) {
  71                                         $url = $r['poco'];
  72                                         $uid = $r['uid'];
  73                                 }
  74                         }
  75                         if (!$uid) {
  76                                 return;
  77                         }
  78                 }
  79
  80                 if (!$url) {
  81                         return;
  82                 }
  83
  84                 $url = $url . (($uid) ? '/@me/@all?fields=displayName,urls,photos,updated,network,aboutMe,currentLocation,tags,gender,contactType,generation' : '?fields=displayName,urls,photos,updated,network,aboutMe,currentLocation,tags,gender,contactType,generation') ;
  85
  86                 logger('load: ' . $url, LOGGER_DEBUG);
  87
  88                 $s = fetch_url($url);
  89
  90                 logger('load: returns ' . $s, LOGGER_DATA);
  91
  92                 logger('load: return code: ' . $a->get_curl_code(), LOGGER_DEBUG);
  93
  94                 if (($a->get_curl_code() > 299) || (! $s)) {
  95                         return;
  96                 }
  97
  98                 $j = json_decode($s);
  99
 100                 logger('load: json: ' . print_r($j, true), LOGGER_DATA);
 101
 102                 if (! isset($j->entry)) {
 103                         return;
 104                 }
 105
 106                 $total = 0;
 107                 foreach ($j->entry as $entry) {
 108                         $total ++;
 109                         $profile_url = '';
 110                         $profile_photo = '';
 111                         $connect_url = '';
 112                         $name = '';
 113                         $network = '';
 114                         $updated = NULL_DATE;
 115                         $location = '';
 116                         $about = '';
 117                         $keywords = '';
 118                         $gender = '';
 119                         $contact_type = -1;
 120                         $generation = 0;
 121
 122                         $name = $entry->displayName;
 123
 124                         if (isset($entry->urls)) {
 125                                 foreach ($entry->urls as $url) {
 126                                         if ($url->type == 'profile') {
 127                                                 $profile_url = $url->value;
 128                                                 continue;
 129                                         }
 130                                         if ($url->type == 'webfinger') {
 131                                                 $connect_url = str_replace('acct:', '', $url->value);
 132                                                 continue;
 133                                         }
 134                                 }
 135                         }
 136                         if (isset($entry->photos)) {
 137                                 foreach ($entry->photos as $photo) {
 138                                         if ($photo->type == 'profile') {
 139                                                 $profile_photo = $photo->value;
 140                                                 continue;
 141                                         }
 142                                 }
 143                         }
 144
 145                         if (isset($entry->updated)) {
 146                                 $updated = date("Y-m-d H:i:s", strtotime($entry->updated));
 147                         }
 148
 149                         if (isset($entry->network)) {
 150                                 $network = $entry->network;
 151                         }
 152
 153                         if (isset($entry->currentLocation)) {
 154                                 $location = $entry->currentLocation;
 155                         }
 156
 157                         if (isset($entry->aboutMe)) {
 158                                 $about = html2bbcode($entry->aboutMe);
 159                         }
 160
 161                         if (isset($entry->gender)) {
 162                                 $gender = $entry->gender;
 163                         }
 164
 165                         if (isset($entry->generation) && ($entry->generation > 0)) {
 166                                 $generation = ++$entry->generation;
 167                         }
 168
 169                         if (isset($entry->tags)) {
 170                                 foreach ($entry->tags as $tag) {
 171                                         $keywords = implode(", ", $tag);
 172                                 }
 173                         }
 174
 175                         if (isset($entry->contactType) && ($entry->contactType >= 0)) {
 176                                 $contact_type = $entry->contactType;
 177                         }
 178
 179                         $gcontact = array("url" => $profile_url,
 180                                         "name" => $name,
 181                                         "network" => $network,
 182                                         "photo" => $profile_photo,
 183                                         "about" => $about,
 184                                         "location" => $location,
 185                                         "gender" => $gender,
 186                                         "keywords" => $keywords,
 187                                         "connect" => $connect_url,
 188                                         "updated" => $updated,
 189                                         "contact-type" => $contact_type,
 190                                         "generation" => $generation);
 191
 192                         try {
 193                                 $gcontact = GContact::sanitize($gcontact);
 194                                 $gcid = GContact::update($gcontact);
 195
 196                                 GContact::link($gcid, $uid, $cid, $zcid);
 197                         } catch (Exception $e) {
 198                                 logger($e->getMessage(), LOGGER_DEBUG);
 199                         }
 200                 }
 201                 logger("load: loaded $total entries", LOGGER_DEBUG);
 202
 203                 $condition = ["`cid` = ? AND `uid` = ? AND `zcid` = ? AND `updated` < UTC_TIMESTAMP - INTERVAL 2 DAY", $cid, $uid, $zcid];
 204                 dba::delete('glink', $condition);
 205         }
 206
 207         public static function reachable($profile, $server = "", $network = "", $force = false)
 208         {
 209                 if ($server == "") {
 210                         $server = self::detectServer($profile);
 211                 }
 212
 213                 if ($server == "") {
 214                         return true;
 215                 }
 216
 217                 return self::checkServer($server, $network, $force);
 218         }
 219
 220         public static function detectServer($profile)
 221         {
 222                 // Try to detect the server path based upon some known standard paths
 223                 $server_url = "";
 224
 225                 if ($server_url == "") {
 226                         $friendica = preg_replace("=(https?://)(.*)/profile/(.*)=ism", "$1$2", $profile);
 227                         if ($friendica != $profile) {
 228                                 $server_url = $friendica;
 229                                 $network = NETWORK_DFRN;
 230                         }
 231                 }
 232
 233                 if ($server_url == "") {
 234                         $diaspora = preg_replace("=(https?://)(.*)/u/(.*)=ism", "$1$2", $profile);
 235                         if ($diaspora != $profile) {
 236                                 $server_url = $diaspora;
 237                                 $network = NETWORK_DIASPORA;
 238                         }
 239                 }
 240
 241                 if ($server_url == "") {
 242                         $red = preg_replace("=(https?://)(.*)/channel/(.*)=ism", "$1$2", $profile);
 243                         if ($red != $profile) {
 244                                 $server_url = $red;
 245                                 $network = NETWORK_DIASPORA;
 246                         }
 247                 }
 248
 249                 // Mastodon
 250                 if ($server_url == "") {
 251                         $mastodon = preg_replace("=(https?://)(.*)/users/(.*)=ism", "$1$2", $profile);
 252                         if ($mastodon != $profile) {
 253                                 $server_url = $mastodon;
 254                                 $network = NETWORK_OSTATUS;
 255                         }
 256                 }
 257
 258                 // Numeric OStatus variant
 259                 if ($server_url == "") {
 260                         $ostatus = preg_replace("=(https?://)(.*)/user/(.*)=ism", "$1$2", $profile);
 261                         if ($ostatus != $profile) {
 262                                 $server_url = $ostatus;
 263                                 $network = NETWORK_OSTATUS;
 264                         }
 265                 }
 266
 267                 // Wild guess
 268                 if ($server_url == "") {
 269                         $base = preg_replace("=(https?://)(.*?)/(.*)=ism", "$1$2", $profile);
 270                         if ($base != $profile) {
 271                                 $server_url = $base;
 272                                 $network = NETWORK_PHANTOM;
 273                         }
 274                 }
 275
 276                 if ($server_url == "") {
 277                         return "";
 278                 }
 279
 280                 $r = q(
 281                         "SELECT `id` FROM `gserver` WHERE `nurl` = '%s' AND `last_contact` > `last_failure`",
 282                         dbesc(normalise_link($server_url))
 283                 );
 284
 285                 if (DBM::is_result($r)) {
 286                         return $server_url;
 287                 }
 288
 289                 // Fetch the host-meta to check if this really is a server
 290                 $serverret = z_fetch_url($server_url."/.well-known/host-meta");
 291                 if (!$serverret["success"]) {
 292                         return "";
 293                 }
 294
 295                 return $server_url;
 296         }
 297
 298         public static function alternateOStatusUrl($url)
 299         {
 300                 return(preg_match("=https?://.+/user/\d+=ism", $url, $matches));
 301         }
 302
 303         public static function lastUpdated($profile, $force = false)
 304         {
 305                 $gcontacts = q(
 306                         "SELECT * FROM `gcontact` WHERE `nurl` = '%s'",
 307                         dbesc(normalise_link($profile))
 308                 );
 309
 310                 if (!DBM::is_result($gcontacts)) {
 311                         return false;
 312                 }
 313
 314                 $contact = array("url" => $profile);
 315
 316                 if ($gcontacts[0]["created"] <= NULL_DATE) {
 317                         $contact['created'] = datetime_convert();
 318                 }
 319
 320                 if ($force) {
 321                         $server_url = normalise_link(self::detectServer($profile));
 322                 }
 323
 324                 if (($server_url == '') && ($gcontacts[0]["server_url"] != "")) {
 325                         $server_url = $gcontacts[0]["server_url"];
 326                 }
 327
 328                 if (!$force && (($server_url == '') || ($gcontacts[0]["server_url"] == $gcontacts[0]["nurl"]))) {
 329                         $server_url = normalise_link(self::detectServer($profile));
 330                 }
 331
 332                 if (!in_array($gcontacts[0]["network"], array(NETWORK_DFRN, NETWORK_DIASPORA, NETWORK_FEED, NETWORK_OSTATUS, ""))) {
 333                         logger("Profile ".$profile.": Network type ".$gcontacts[0]["network"]." can't be checked", LOGGER_DEBUG);
 334                         return false;
 335                 }
 336
 337                 if ($server_url != "") {
 338                         if (!self::checkServer($server_url, $gcontacts[0]["network"], $force)) {
 339                                 if ($force) {
 340                                         $fields = ['last_failure' => datetime_convert()];
 341                                         dba::update('gcontact', $fields, ['nurl' => normalise_link($profile)]);
 342                                 }
 343
 344                                 logger("Profile ".$profile.": Server ".$server_url." wasn't reachable.", LOGGER_DEBUG);
 345                                 return false;
 346                         }
 347                         $contact['server_url'] = $server_url;
 348                 }
 349
 350                 if (in_array($gcontacts[0]["network"], array("", NETWORK_FEED))) {
 351                         $server = q(
 352                                 "SELECT `network` FROM `gserver` WHERE `nurl` = '%s' AND `network` != ''",
 353                                 dbesc(normalise_link($server_url))
 354                         );
 355
 356                         if ($server) {
 357                                 $contact['network'] = $server[0]["network"];
 358                         } else {
 359                                 return false;
 360                         }
 361                 }
 362
 363                 // noscrape is really fast so we don't cache the call.
 364                 if (($server_url != "") && ($gcontacts[0]["nick"] != "")) {
 365                         //  Use noscrape if possible
 366                         $server = q("SELECT `noscrape`, `network` FROM `gserver` WHERE `nurl` = '%s' AND `noscrape` != ''", dbesc(normalise_link($server_url)));
 367
 368                         if ($server) {
 369                                 $noscraperet = z_fetch_url($server[0]["noscrape"]."/".$gcontacts[0]["nick"]);
 370
 371                                 if ($noscraperet["success"] && ($noscraperet["body"] != "")) {
 372                                         $noscrape = json_decode($noscraperet["body"], true);
 373
 374                                         if (is_array($noscrape)) {
 375                                                 $contact["network"] = $server[0]["network"];
 376
 377                                                 if (isset($noscrape["fn"])) {
 378                                                         $contact["name"] = $noscrape["fn"];
 379                                                 }
 380                                                 if (isset($noscrape["comm"])) {
 381                                                         $contact["community"] = $noscrape["comm"];
 382                                                 }
 383                                                 if (isset($noscrape["tags"])) {
 384                                                         $keywords = implode(" ", $noscrape["tags"]);
 385                                                         if ($keywords != "") {
 386                                                                 $contact["keywords"] = $keywords;
 387                                                         }
 388                                                 }
 389
 390                                                 $location = Profile::formatLocation($noscrape);
 391                                                 if ($location) {
 392                                                         $contact["location"] = $location;
 393                                                 }
 394                                                 if (isset($noscrape["dfrn-notify"])) {
 395                                                         $contact["notify"] = $noscrape["dfrn-notify"];
 396                                                 }
 397                                                 // Remove all fields that are not present in the gcontact table
 398                                                 unset($noscrape["fn"]);
 399                                                 unset($noscrape["key"]);
 400                                                 unset($noscrape["homepage"]);
 401                                                 unset($noscrape["comm"]);
 402                                                 unset($noscrape["tags"]);
 403                                                 unset($noscrape["locality"]);
 404                                                 unset($noscrape["region"]);
 405                                                 unset($noscrape["country-name"]);
 406                                                 unset($noscrape["contacts"]);
 407                                                 unset($noscrape["dfrn-request"]);
 408                                                 unset($noscrape["dfrn-confirm"]);
 409                                                 unset($noscrape["dfrn-notify"]);
 410                                                 unset($noscrape["dfrn-poll"]);
 411
 412                                                 // Set the date of the last contact
 413                                                 /// @todo By now the function "update_gcontact" doesn't work with this field
 414                                                 //$contact["last_contact"] = datetime_convert();
 415
 416                                                 $contact = array_merge($contact, $noscrape);
 417
 418                                                 GContact::update($contact);
 419
 420                                                 if (trim($noscrape["updated"]) != "") {
 421                                                         $fields = ['last_contact' => datetime_convert()];
 422                                                         dba::update('gcontact', $fields, ['nurl' => normalise_link($profile)]);
 423
 424                                                         logger("Profile ".$profile." was last updated at ".$noscrape["updated"]." (noscrape)", LOGGER_DEBUG);
 425
 426                                                         return $noscrape["updated"];
 427                                                 }
 428                                         }
 429                                 }
 430                         }
 431                 }
 432
 433                 // If we only can poll the feed, then we only do this once a while
 434                 if (!$force && !self::updateNeeded($gcontacts[0]["created"], $gcontacts[0]["updated"], $gcontacts[0]["last_failure"], $gcontacts[0]["last_contact"])) {
 435                         logger("Profile ".$profile." was last updated at ".$gcontacts[0]["updated"]." (cached)", LOGGER_DEBUG);
 436
 437                         GContact::update($contact);
 438                         return $gcontacts[0]["updated"];
 439                 }
 440
 441                 $data = Probe::uri($profile);
 442
 443                 // Is the profile link the alternate OStatus link notation? (http://domain.tld/user/4711)
 444                 // Then check the other link and delete this one
 445                 if (($data["network"] == NETWORK_OSTATUS) && self::alternateOStatusUrl($profile)
 446                         && (normalise_link($profile) == normalise_link($data["alias"]))
 447                         && (normalise_link($profile) != normalise_link($data["url"]))
 448                 ) {
 449                         // Delete the old entry
 450                         dba::delete('gcontact', ['nurl' => normalise_link($profile)]);
 451
 452                         $gcontact = array_merge($gcontacts[0], $data);
 453
 454                         $gcontact["server_url"] = $data["baseurl"];
 455
 456                         try {
 457                                 $gcontact = GContact::sanitize($gcontact);
 458                                 GContact::update($gcontact);
 459
 460                                 self::lastUpdated($data["url"], $force);
 461                         } catch (Exception $e) {
 462                                 logger($e->getMessage(), LOGGER_DEBUG);
 463                         }
 464
 465                         logger("Profile ".$profile." was deleted", LOGGER_DEBUG);
 466                         return false;
 467                 }
 468
 469                 if (($data["poll"] == "") || (in_array($data["network"], array(NETWORK_FEED, NETWORK_PHANTOM)))) {
 470                         $fields = ['last_failure' => datetime_convert()];
 471                         dba::update('gcontact', $fields, ['nurl' => normalise_link($profile)]);
 472
 473                         logger("Profile ".$profile." wasn't reachable (profile)", LOGGER_DEBUG);
 474                         return false;
 475                 }
 476
 477                 $contact = array_merge($contact, $data);
 478
 479                 $contact["server_url"] = $data["baseurl"];
 480
 481                 GContact::update($contact);
 482
 483                 $feedret = z_fetch_url($data["poll"]);
 484
 485                 if (!$feedret["success"]) {
 486                         $fields = ['last_failure' => datetime_convert()];
 487                         dba::update('gcontact', $fields, ['nurl' => normalise_link($profile)]);
 488
 489                         logger("Profile ".$profile." wasn't reachable (no feed)", LOGGER_DEBUG);
 490                         return false;
 491                 }
 492
 493                 $doc = new DOMDocument();
 494                 @$doc->loadXML($feedret["body"]);
 495
 496                 $xpath = new DOMXPath($doc);
 497                 $xpath->registerNamespace('atom', "http://www.w3.org/2005/Atom");
 498
 499                 $entries = $xpath->query('/atom:feed/atom:entry');
 500
 501                 $last_updated = "";
 502
 503                 foreach ($entries as $entry) {
 504                         $published = $xpath->query('atom:published/text()', $entry)->item(0)->nodeValue;
 505                         $updated = $xpath->query('atom:updated/text()', $entry)->item(0)->nodeValue;
 506
 507                         if ($last_updated < $published)
 508                                 $last_updated = $published;
 509
 510                         if ($last_updated < $updated)
 511                                 $last_updated = $updated;
 512                 }
 513
 514                 // Maybe there aren't any entries. Then check if it is a valid feed
 515                 if ($last_updated == "") {
 516                         if ($xpath->query('/atom:feed')->length > 0) {
 517                                 $last_updated = NULL_DATE;
 518                         }
 519                 }
 520                 $fields = ['updated' => DBM::date($last_updated), 'last_contact' => DBM::date()];
 521                 dba::update('gcontact', $fields, ['nurl' => normalise_link($profile)]);
 522
 523                 if (($gcontacts[0]["generation"] == 0)) {
 524                         $fields = ['generation' => 9];
 525                         dba::update('gcontact', $fields, ['nurl' => normalise_link($profile)]);
 526                 }
 527
 528                 logger("Profile ".$profile." was last updated at ".$last_updated, LOGGER_DEBUG);
 529
 530                 return($last_updated);
 531         }
 532
 533         public static function updateNeeded($created, $updated, $last_failure, $last_contact)
 534         {
 535                 $now = strtotime(datetime_convert());
 536
 537                 if ($updated > $last_contact) {
 538                         $contact_time = strtotime($updated);
 539                 } else {
 540                         $contact_time = strtotime($last_contact);
 541                 }
 542
 543                 $failure_time = strtotime($last_failure);
 544                 $created_time = strtotime($created);
 545
 546                 // If there is no "created" time then use the current time
 547                 if ($created_time <= 0) {
 548                         $created_time = $now;
 549                 }
 550
 551                 // If the last contact was less than 24 hours then don't update
 552                 if (($now - $contact_time) < (60 * 60 * 24)) {
 553                         return false;
 554                 }
 555
 556                 // If the last failure was less than 24 hours then don't update
 557                 if (($now - $failure_time) < (60 * 60 * 24)) {
 558                         return false;
 559                 }
 560
 561                 // If the last contact was less than a week ago and the last failure is older than a week then don't update
 562                 //if ((($now - $contact_time) < (60 * 60 * 24 * 7)) && ($contact_time > $failure_time))
 563                 //      return false;
 564
 565                 // If the last contact time was more than a week ago and the contact was created more than a week ago, then only try once a week
 566                 if ((($now - $contact_time) > (60 * 60 * 24 * 7)) && (($now - $created_time) > (60 * 60 * 24 * 7)) && (($now - $failure_time) < (60 * 60 * 24 * 7))) {
 567                         return false;
 568                 }
 569
 570                 // If the last contact time was more than a month ago and the contact was created more than a month ago, then only try once a month
 571                 if ((($now - $contact_time) > (60 * 60 * 24 * 30)) && (($now - $created_time) > (60 * 60 * 24 * 30)) && (($now - $failure_time) < (60 * 60 * 24 * 30))) {
 572                         return false;
 573                 }
 574
 575                 return true;
 576         }
 577
 578         public static function toBoolean($val)
 579         {
 580                 if (($val == "true") || ($val == 1)) {
 581                         return true;
 582                 } elseif (($val == "false") || ($val == 0)) {
 583                         return false;
 584                 }
 585
 586                 return $val;
 587         }
 588
 589         /**
 590          * @brief Detect server type (Hubzilla or Friendica) via the poco data
 591          *
 592          * @param object $data POCO data
 593          * @return array Server data
 594          */
 595         public static function detectPocoData($data)
 596         {
 597                 $server = false;
 598
 599                 if (!isset($data->entry)) {
 600                         return false;
 601                 }
 602
 603                 if (count($data->entry) == 0) {
 604                         return false;
 605                 }
 606
 607                 if (!isset($data->entry[0]->urls)) {
 608                         return false;
 609                 }
 610
 611                 if (count($data->entry[0]->urls) == 0) {
 612                         return false;
 613                 }
 614
 615                 foreach ($data->entry[0]->urls as $url) {
 616                         if ($url->type == 'zot') {
 617                                 $server = array();
 618                                 $server["platform"] = 'Hubzilla';
 619                                 $server["network"] = NETWORK_DIASPORA;
 620                                 return $server;
 621                         }
 622                 }
 623                 return false;
 624         }
 625
 626         /**
 627          * @brief Detect server type by using the nodeinfo data
 628          *
 629          * @param string $server_url address of the server
 630          * @return array Server data
 631          */
 632         public static function fetchNodeinfo($server_url)
 633         {
 634                 $serverret = z_fetch_url($server_url."/.well-known/nodeinfo");
 635                 if (!$serverret["success"]) {
 636                         return false;
 637                 }
 638
 639                 $nodeinfo = json_decode($serverret['body']);
 640
 641                 if (!is_object($nodeinfo)) {
 642                         return false;
 643                 }
 644
 645                 if (!is_array($nodeinfo->links)) {
 646                         return false;
 647                 }
 648
 649                 $nodeinfo_url = '';
 650
 651                 foreach ($nodeinfo->links as $link) {
 652                         if ($link->rel == 'http://nodeinfo.diaspora.software/ns/schema/1.0') {
 653                                 $nodeinfo_url = $link->href;
 654                         }
 655                 }
 656
 657                 if ($nodeinfo_url == '') {
 658                         return false;
 659                 }
 660
 661                 // When the nodeinfo url isn't on the same host, then there is obviously something wrong
 662                 if (parse_url($server_url, PHP_URL_HOST) != parse_url($nodeinfo_url, PHP_URL_HOST)) {
 663                         return false;
 664                 }
 665
 666                 $serverret = z_fetch_url($nodeinfo_url);
 667                 if (!$serverret["success"]) {
 668                         return false;
 669                 }
 670
 671                 $nodeinfo = json_decode($serverret['body']);
 672
 673                 if (!is_object($nodeinfo)) {
 674                         return false;
 675                 }
 676
 677                 $server = array();
 678
 679                 $server['register_policy'] = REGISTER_CLOSED;
 680
 681                 if (is_bool($nodeinfo->openRegistrations) && $nodeinfo->openRegistrations) {
 682                         $server['register_policy'] = REGISTER_OPEN;
 683                 }
 684
 685                 if (is_object($nodeinfo->software)) {
 686                         if (isset($nodeinfo->software->name)) {
 687                                 $server['platform'] = $nodeinfo->software->name;
 688                         }
 689
 690                         if (isset($nodeinfo->software->version)) {
 691                                 $server['version'] = $nodeinfo->software->version;
 692                                 // Version numbers on Nodeinfo are presented with additional info, e.g.:
 693                                 // 0.6.3.0-p1702cc1c, 0.6.99.0-p1b9ab160 or 3.4.3-2-1191.
 694                                 $server['version'] = preg_replace("=(.+)-(.{4,})=ism", "$1", $server['version']);
 695                         }
 696                 }
 697
 698                 if (is_object($nodeinfo->metadata)) {
 699                         if (isset($nodeinfo->metadata->nodeName)) {
 700                                 $server['site_name'] = $nodeinfo->metadata->nodeName;
 701                         }
 702                 }
 703
 704                 if (!empty($nodeinfo->usage->users->total)) {
 705                         $server['registered-users'] = $nodeinfo->usage->users->total;
 706                 }
 707
 708                 $diaspora = false;
 709                 $friendica = false;
 710                 $gnusocial = false;
 711
 712                 if (is_array($nodeinfo->protocols->inbound)) {
 713                         foreach ($nodeinfo->protocols->inbound as $inbound) {
 714                                 if ($inbound == 'diaspora') {
 715                                         $diaspora = true;
 716                                 }
 717                                 if ($inbound == 'friendica') {
 718                                         $friendica = true;
 719                                 }
 720                                 if ($inbound == 'gnusocial') {
 721                                         $gnusocial = true;
 722                                 }
 723                         }
 724                 }
 725
 726                 if ($gnusocial) {
 727                         $server['network'] = NETWORK_OSTATUS;
 728                 }
 729                 if ($diaspora) {
 730                         $server['network'] = NETWORK_DIASPORA;
 731                 }
 732                 if ($friendica) {
 733                         $server['network'] = NETWORK_DFRN;
 734                 }
 735
 736                 if (!$server) {
 737                         return false;
 738                 }
 739
 740                 return $server;
 741         }
 742
 743         /**
 744          * @brief Detect server type (Hubzilla or Friendica) via the front page body
 745          *
 746          * @param string $body Front page of the server
 747          * @return array Server data
 748          */
 749         public static function detectServerType($body)
 750         {
 751                 $server = false;
 752
 753                 $doc = new DOMDocument();
 754                 @$doc->loadHTML($body);
 755                 $xpath = new DOMXPath($doc);
 756
 757                 $list = $xpath->query("//meta[@name]");
 758
 759                 foreach ($list as $node) {
 760                         $attr = array();
 761                         if ($node->attributes->length) {
 762                                 foreach ($node->attributes as $attribute) {
 763                                         $attr[$attribute->name] = $attribute->value;
 764                                 }
 765                         }
 766                         if ($attr['name'] == 'generator') {
 767                                 $version_part = explode(" ", $attr['content']);
 768                                 if (count($version_part) == 2) {
 769                                         if (in_array($version_part[0], array("Friendika", "Friendica"))) {
 770                                                 $server = array();
 771                                                 $server["platform"] = $version_part[0];
 772                                                 $server["version"] = $version_part[1];
 773                                                 $server["network"] = NETWORK_DFRN;
 774                                         }
 775                                 }
 776                         }
 777                 }
 778
 779                 if (!$server) {
 780                         $list = $xpath->query("//meta[@property]");
 781
 782                         foreach ($list as $node) {
 783                                 $attr = array();
 784                                 if ($node->attributes->length) {
 785                                         foreach ($node->attributes as $attribute) {
 786                                                 $attr[$attribute->name] = $attribute->value;
 787                                         }
 788                                 }
 789                                 if ($attr['property'] == 'generator' && in_array($attr['content'], array("hubzilla", "BlaBlaNet"))) {
 790                                         $server = array();
 791                                         $server["platform"] = $attr['content'];
 792                                         $server["version"] = "";
 793                                         $server["network"] = NETWORK_DIASPORA;
 794                                 }
 795                         }
 796                 }
 797
 798                 if (!$server) {
 799                         return false;
 800                 }
 801
 802                 $server["site_name"] = $xpath->evaluate("//head/title/text()")->item(0)->nodeValue;
 803                 return $server;
 804         }
 805
 806         public static function checkServer($server_url, $network = "", $force = false)
 807         {
 808                 // Unify the server address
 809                 $server_url = trim($server_url, "/");
 810                 $server_url = str_replace("/index.php", "", $server_url);
 811
 812                 if ($server_url == "") {
 813                         return false;
 814                 }
 815
 816                 $servers = dba::select('gserver', [], ['nurl' => normalise_link($server_url)], ['limit' => 1]);
 817                 if (DBM::is_result($servers)) {
 818                         if ($servers["created"] <= NULL_DATE) {
 819                                 $fields = ['created' => datetime_convert()];
 820                                 $condition = ['nurl' => normalise_link($server_url)];
 821                                 dba::update('gserver', $fields, $condition);
 822                         }
 823                         $poco = $servers["poco"];
 824                         $noscrape = $servers["noscrape"];
 825
 826                         if ($network == "") {
 827                                 $network = $servers["network"];
 828                         }
 829
 830                         $last_contact = $servers["last_contact"];
 831                         $last_failure = $servers["last_failure"];
 832                         $version = $servers["version"];
 833                         $platform = $servers["platform"];
 834                         $site_name = $servers["site_name"];
 835                         $info = $servers["info"];
 836                         $register_policy = $servers["register_policy"];
 837                         $registered_users = $servers["registered-users"];
 838
 839                         if (!$force && !self::updateNeeded($servers["created"], "", $last_failure, $last_contact)) {
 840                                 logger("Use cached data for server ".$server_url, LOGGER_DEBUG);
 841                                 return ($last_contact >= $last_failure);
 842                         }
 843                 } else {
 844                         $poco = "";
 845                         $noscrape = "";
 846                         $version = "";
 847                         $platform = "";
 848                         $site_name = "";
 849                         $info = "";
 850                         $register_policy = -1;
 851                         $registered_users = 0;
 852
 853                         $last_contact = NULL_DATE;
 854                         $last_failure = NULL_DATE;
 855                 }
 856                 logger("Server ".$server_url." is outdated or unknown. Start discovery. Force: ".$force." Created: ".$servers["created"]." Failure: ".$last_failure." Contact: ".$last_contact, LOGGER_DEBUG);
 857
 858                 $failure = false;
 859                 $possible_failure = false;
 860                 $orig_last_failure = $last_failure;
 861                 $orig_last_contact = $last_contact;
 862
 863                 // Check if the page is accessible via SSL.
 864                 $orig_server_url = $server_url;
 865                 $server_url = str_replace("http://", "https://", $server_url);
 866
 867                 // We set the timeout to 20 seconds since this operation should be done in no time if the server was vital
 868                 $serverret = z_fetch_url($server_url."/.well-known/host-meta", false, $redirects, array('timeout' => 20));
 869
 870                 // Quit if there is a timeout.
 871                 // But we want to make sure to only quit if we are mostly sure that this server url fits.
 872                 if (DBM::is_result($servers) && ($orig_server_url == $server_url) &&
 873                         ($serverret['errno'] == CURLE_OPERATION_TIMEDOUT)) {
 874                         logger("Connection to server ".$server_url." timed out.", LOGGER_DEBUG);
 875                         dba::update('gserver', array('last_failure' => datetime_convert()), array('nurl' => normalise_link($server_url)));
 876                         return false;
 877                 }
 878
 879                 // Maybe the page is unencrypted only?
 880                 $xmlobj = @simplexml_load_string($serverret["body"], 'SimpleXMLElement', 0, "http://docs.oasis-open.org/ns/xri/xrd-1.0");
 881                 if (!$serverret["success"] || ($serverret["body"] == "") || (@sizeof($xmlobj) == 0) || !is_object($xmlobj)) {
 882                         $server_url = str_replace("https://", "http://", $server_url);
 883
 884                         // We set the timeout to 20 seconds since this operation should be done in no time if the server was vital
 885                         $serverret = z_fetch_url($server_url."/.well-known/host-meta", false, $redirects, array('timeout' => 20));
 886
 887                         // Quit if there is a timeout
 888                         if ($serverret['errno'] == CURLE_OPERATION_TIMEDOUT) {
 889                                 logger("Connection to server ".$server_url." timed out.", LOGGER_DEBUG);
 890                                 dba::update('gserver', array('last_failure' => datetime_convert()), array('nurl' => normalise_link($server_url)));
 891                                 return false;
 892                         }
 893
 894                         $xmlobj = @simplexml_load_string($serverret["body"], 'SimpleXMLElement', 0, "http://docs.oasis-open.org/ns/xri/xrd-1.0");
 895                 }
 896
 897                 if (!$serverret["success"] || ($serverret["body"] == "") || (sizeof($xmlobj) == 0) || !is_object($xmlobj)) {
 898                         // Workaround for bad configured servers (known nginx problem)
 899                         if (!in_array($serverret["debug"]["http_code"], array("403", "404"))) {
 900                                 $failure = true;
 901                         }
 902                         $possible_failure = true;
 903                 }
 904
 905                 // If the server has no possible failure we reset the cached data
 906                 if (!$possible_failure) {
 907                         $version = "";
 908                         $platform = "";
 909                         $site_name = "";
 910                         $info = "";
 911                         $register_policy = -1;
 912                 }
 913
 914                 if (!$failure) {
 915                         // This will be too low, but better than no value at all.
 916                         $registered_users = dba::count('gcontact', ['server_url' => normalise_link($server_url)]);
 917
 918                         // Every server has got an admin account at least
 919                         if ($registered_users == 0) {
 920                                 $registered_users = 1;
 921                         }
 922                 }
 923
 924                 // Look for poco
 925                 if (!$failure) {
 926                         $serverret = z_fetch_url($server_url."/poco");
 927                         if ($serverret["success"]) {
 928                                 $data = json_decode($serverret["body"]);
 929                                 if (isset($data->totalResults)) {
 930                                         $registered_users = $data->totalResults;
 931                                         $poco = $server_url."/poco";
 932                                         $server = self::detectPocoData($data);
 933                                         if ($server) {
 934                                                 $platform = $server['platform'];
 935                                                 $network = $server['network'];
 936                                                 $version = '';
 937                                                 $site_name = '';
 938                                         }
 939                                 }
 940                                 // There are servers out there who don't return 404 on a failure
 941                                 // We have to be sure that don't misunderstand this
 942                                 if (is_null($data)) {
 943                                         $poco = "";
 944                                         $noscrape = "";
 945                                         $network = "";
 946                                 }
 947                         }
 948                 }
 949
 950                 if (!$failure) {
 951                         // Test for Diaspora, Hubzilla, Mastodon or older Friendica servers
 952                         $serverret = z_fetch_url($server_url);
 953
 954                         if (!$serverret["success"] || ($serverret["body"] == "")) {
 955                                 $failure = true;
 956                         } else {
 957                                 $server = self::detectServerType($serverret["body"]);
 958                                 if ($server) {
 959                                         $platform = $server['platform'];
 960                                         $network = $server['network'];
 961                                         $version = $server['version'];
 962                                         $site_name = $server['site_name'];
 963                                 }
 964
 965                                 $lines = explode("\n", $serverret["header"]);
 966                                 if (count($lines)) {
 967                                         foreach ($lines as $line) {
 968                                                 $line = trim($line);
 969                                                 if (stristr($line, 'X-Diaspora-Version:')) {
 970                                                         $platform = "Diaspora";
 971                                                         $version = trim(str_replace("X-Diaspora-Version:", "", $line));
 972                                                         $version = trim(str_replace("x-diaspora-version:", "", $version));
 973                                                         $network = NETWORK_DIASPORA;
 974                                                         $versionparts = explode("-", $version);
 975                                                         $version = $versionparts[0];
 976                                                 }
 977
 978                                                 if (stristr($line, 'Server: Mastodon')) {
 979                                                         $platform = "Mastodon";
 980                                                         $network = NETWORK_OSTATUS;
 981                                                 }
 982                                         }
 983                                 }
 984                         }
 985                 }
 986
 987                 if (!$failure && ($poco == "")) {
 988                         // Test for Statusnet
 989                         // Will also return data for Friendica and GNU Social - but it will be overwritten later
 990                         // The "not implemented" is a special treatment for really, really old Friendica versions
 991                         $serverret = z_fetch_url($server_url."/api/statusnet/version.json");
 992                         if ($serverret["success"] && ($serverret["body"] != '{"error":"not implemented"}') &&
 993                                 ($serverret["body"] != '') && (strlen($serverret["body"]) < 30)) {
 994                                 $platform = "StatusNet";
 995                                 // Remove junk that some GNU Social servers return
 996                                 $version = str_replace(chr(239).chr(187).chr(191), "", $serverret["body"]);
 997                                 $version = trim($version, '"');
 998                                 $network = NETWORK_OSTATUS;
 999                         }
1000
1001                         // Test for GNU Social
1002                         $serverret = z_fetch_url($server_url."/api/gnusocial/version.json");
1003                         if ($serverret["success"] && ($serverret["body"] != '{"error":"not implemented"}') &&
1004                                 ($serverret["body"] != '') && (strlen($serverret["body"]) < 30)) {
1005                                 $platform = "GNU Social";
1006                                 // Remove junk that some GNU Social servers return
1007                                 $version = str_replace(chr(239).chr(187).chr(191), "", $serverret["body"]);
1008                                 $version = trim($version, '"');
1009                                 $network = NETWORK_OSTATUS;
1010                         }
1011
1012                         // Test for Mastodon
1013                         $orig_version = $version;
1014                         $serverret = z_fetch_url($server_url."/api/v1/instance");
1015                         if ($serverret["success"] && ($serverret["body"] != '')) {
1016                                 $data = json_decode($serverret["body"]);
1017
1018                                 if (isset($data->version)) {
1019                                         $platform = "Mastodon";
1020                                         $version = $data->version;
1021                                         $site_name = $data->title;
1022                                         $info = $data->description;
1023                                         $network = NETWORK_OSTATUS;
1024                                 }
1025                                 if (!empty($data->stats->user_count)) {
1026                                         $registered_users = $data->stats->user_count;
1027                                 }
1028                         }
1029                         if (strstr($orig_version.$version, 'Pleroma')) {
1030                                 $platform = 'Pleroma';
1031                                 $version = trim(str_replace('Pleroma', '', $version));
1032                         }
1033                 }
1034
1035                 if (!$failure) {
1036                         // Test for Hubzilla and Red
1037                         $serverret = z_fetch_url($server_url."/siteinfo.json");
1038                         if ($serverret["success"]) {
1039                                 $data = json_decode($serverret["body"]);
1040                                 if (isset($data->url)) {
1041                                         $platform = $data->platform;
1042                                         $version = $data->version;
1043                                         $network = NETWORK_DIASPORA;
1044                                 }
1045                                 if (!empty($data->site_name)) {
1046                                         $site_name = $data->site_name;
1047                                 }
1048                                 if (!empty($data->channels_total)) {
1049                                         $registered_users = $data->channels_total;
1050                                 }
1051                                 switch ($data->register_policy) {
1052                                         case "REGISTER_OPEN":
1053                                                 $register_policy = REGISTER_OPEN;
1054                                                 break;
1055                                         case "REGISTER_APPROVE":
1056                                                 $register_policy = REGISTER_APPROVE;
1057                                                 break;
1058                                         case "REGISTER_CLOSED":
1059                                         default:
1060                                                 $register_policy = REGISTER_CLOSED;
1061                                                 break;
1062                                 }
1063                         } else {
1064                                 // Test for Hubzilla, Redmatrix or Friendica
1065                                 $serverret = z_fetch_url($server_url."/api/statusnet/config.json");
1066                                 if ($serverret["success"]) {
1067                                         $data = json_decode($serverret["body"]);
1068                                         if (isset($data->site->server)) {
1069                                                 if (isset($data->site->platform)) {
1070                                                         $platform = $data->site->platform->PLATFORM_NAME;
1071                                                         $version = $data->site->platform->STD_VERSION;
1072                                                         $network = NETWORK_DIASPORA;
1073                                                 }
1074                                                 if (isset($data->site->BlaBlaNet)) {
1075                                                         $platform = $data->site->BlaBlaNet->PLATFORM_NAME;
1076                                                         $version = $data->site->BlaBlaNet->STD_VERSION;
1077                                                         $network = NETWORK_DIASPORA;
1078                                                 }
1079                                                 if (isset($data->site->hubzilla)) {
1080                                                         $platform = $data->site->hubzilla->PLATFORM_NAME;
1081                                                         $version = $data->site->hubzilla->RED_VERSION;
1082                                                         $network = NETWORK_DIASPORA;
1083                                                 }
1084                                                 if (isset($data->site->redmatrix)) {
1085                                                         if (isset($data->site->redmatrix->PLATFORM_NAME)) {
1086                                                                 $platform = $data->site->redmatrix->PLATFORM_NAME;
1087                                                         } elseif (isset($data->site->redmatrix->RED_PLATFORM)) {
1088                                                                 $platform = $data->site->redmatrix->RED_PLATFORM;
1089                                                         }
1090
1091                                                         $version = $data->site->redmatrix->RED_VERSION;
1092                                                         $network = NETWORK_DIASPORA;
1093                                                 }
1094                                                 if (isset($data->site->friendica)) {
1095                                                         $platform = $data->site->friendica->FRIENDICA_PLATFORM;
1096                                                         $version = $data->site->friendica->FRIENDICA_VERSION;
1097                                                         $network = NETWORK_DFRN;
1098                                                 }
1099
1100                                                 $site_name = $data->site->name;
1101
1102                                                 $data->site->closed = self::toBoolean($data->site->closed);
1103                                                 $data->site->private = self::toBoolean($data->site->private);
1104                                                 $data->site->inviteonly = self::toBoolean($data->site->inviteonly);
1105
1106                                                 if (!$data->site->closed && !$data->site->private and $data->site->inviteonly) {
1107                                                         $register_policy = REGISTER_APPROVE;
1108                                                 } elseif (!$data->site->closed && !$data->site->private) {
1109                                                         $register_policy = REGISTER_OPEN;
1110                                                 } else {
1111                                                         $register_policy = REGISTER_CLOSED;
1112                                                 }
1113                                         }
1114                                 }
1115                         }
1116                 }
1117
1118                 // Query statistics.json. Optional package for Diaspora, Friendica and Redmatrix
1119                 if (!$failure) {
1120                         $serverret = z_fetch_url($server_url."/statistics.json");
1121                         if ($serverret["success"]) {
1122                                 $data = json_decode($serverret["body"]);
1123
1124                                 if (isset($data->version)) {
1125                                         $version = $data->version;
1126                                         // Version numbers on statistics.json are presented with additional info, e.g.:
1127                                         // 0.6.3.0-p1702cc1c, 0.6.99.0-p1b9ab160 or 3.4.3-2-1191.
1128                                         $version = preg_replace("=(.+)-(.{4,})=ism", "$1", $version);
1129                                 }
1130
1131                                 if (!empty($data->name)) {
1132                                         $site_name = $data->name;
1133                                 }
1134
1135                                 if (!empty($data->network)) {
1136                                         $platform = $data->network;
1137                                 }
1138
1139                                 if ($platform == "Diaspora") {
1140                                         $network = NETWORK_DIASPORA;
1141                                 }
1142
1143                                 if ($data->registrations_open) {
1144                                         $register_policy = REGISTER_OPEN;
1145                                 } else {
1146                                         $register_policy = REGISTER_CLOSED;
1147                                 }
1148                         }
1149                 }
1150
1151                 // Query nodeinfo. Working for (at least) Diaspora and Friendica.
1152                 if (!$failure) {
1153                         $server = self::fetchNodeinfo($server_url);
1154                         if ($server) {
1155                                 $register_policy = $server['register_policy'];
1156
1157                                 if (isset($server['platform'])) {
1158                                         $platform = $server['platform'];
1159                                 }
1160
1161                                 if (isset($server['network'])) {
1162                                         $network = $server['network'];
1163                                 }
1164
1165                                 if (isset($server['version'])) {
1166                                         $version = $server['version'];
1167                                 }
1168
1169                                 if (isset($server['site_name'])) {
1170                                         $site_name = $server['site_name'];
1171                                 }
1172
1173                                 if (isset($server['registered-users'])) {
1174                                         $registered_users = $server['registered-users'];
1175                                 }
1176                         }
1177                 }
1178
1179                 // Check for noscrape
1180                 // Friendica servers could be detected as OStatus servers
1181                 if (!$failure && in_array($network, array(NETWORK_DFRN, NETWORK_OSTATUS))) {
1182                         $serverret = z_fetch_url($server_url."/friendica/json");
1183
1184                         if (!$serverret["success"]) {
1185                                 $serverret = z_fetch_url($server_url."/friendika/json");
1186                         }
1187
1188                         if ($serverret["success"]) {
1189                                 $data = json_decode($serverret["body"]);
1190
1191                                 if (isset($data->version)) {
1192                                         $network = NETWORK_DFRN;
1193
1194                                         $noscrape = $data->no_scrape_url;
1195                                         $version = $data->version;
1196                                         $site_name = $data->site_name;
1197                                         $info = $data->info;
1198                                         $register_policy_str = $data->register_policy;
1199                                         $platform = $data->platform;
1200
1201                                         switch ($register_policy_str) {
1202                                                 case "REGISTER_CLOSED":
1203                                                         $register_policy = REGISTER_CLOSED;
1204                                                         break;
1205                                                 case "REGISTER_APPROVE":
1206                                                         $register_policy = REGISTER_APPROVE;
1207                                                         break;
1208                                                 case "REGISTER_OPEN":
1209                                                         $register_policy = REGISTER_OPEN;
1210                                                         break;
1211                                         }
1212                                 }
1213                         }
1214                 }
1215
1216                 if ($possible_failure && !$failure) {
1217                         $failure = true;
1218                 }
1219
1220                 if ($failure) {
1221                         $last_contact = $orig_last_contact;
1222                         $last_failure = datetime_convert();
1223                 } else {
1224                         $last_contact = datetime_convert();
1225                         $last_failure = $orig_last_failure;
1226                 }
1227
1228                 if (($last_contact <= $last_failure) && !$failure) {
1229                         logger("Server ".$server_url." seems to be alive, but last contact wasn't set - could be a bug", LOGGER_DEBUG);
1230                 } elseif (($last_contact >= $last_failure) && $failure) {
1231                         logger("Server ".$server_url." seems to be dead, but last failure wasn't set - could be a bug", LOGGER_DEBUG);
1232                 }
1233
1234                 // Check again if the server exists
1235                 $found = dba::exists('gserver', array('nurl' => normalise_link($server_url)));
1236
1237                 $version = strip_tags($version);
1238                 $site_name = strip_tags($site_name);
1239                 $info = strip_tags($info);
1240                 $platform = strip_tags($platform);
1241
1242                 $fields = ['url' => $server_url, 'version' => $version,
1243                                 'site_name' => $site_name, 'info' => $info, 'register_policy' => $register_policy,
1244                                 'poco' => $poco, 'noscrape' => $noscrape, 'network' => $network,
1245                                 'platform' => $platform, 'registered-users' => $registered_users,
1246                                 'last_contact' => $last_contact, 'last_failure' => $last_failure];
1247
1248                 if ($found) {
1249                         dba::update('gserver', $fields, ['nurl' => normalise_link($server_url)]);
1250                 } elseif (!$failure) {
1251                         $fields['nurl'] = normalise_link($server_url);
1252                         $fields['created'] = datetime_convert();
1253                         dba::insert('gserver', $fields);
1254                 }
1255                 logger("End discovery for server " . $server_url, LOGGER_DEBUG);
1256
1257                 return !$failure;
1258         }
1259
1260         /**
1261          * @brief Returns a list of all known servers
1262          * @return array List of server urls
1263          */
1264         public static function serverlist()
1265         {
1266                 $r = q(
1267                         "SELECT `url`, `site_name` AS `displayName`, `network`, `platform`, `version` FROM `gserver`
1268                         WHERE `network` IN ('%s', '%s', '%s') AND `last_contact` > `last_failure`
1269                         ORDER BY `last_contact`
1270                         LIMIT 1000",
1271                         dbesc(NETWORK_DFRN),
1272                         dbesc(NETWORK_DIASPORA),
1273                         dbesc(NETWORK_OSTATUS)
1274                 );
1275
1276                 if (!DBM::is_result($r)) {
1277                         return false;
1278                 }
1279
1280                 return $r;
1281         }
1282
1283         /**
1284          * @brief Fetch server list from remote servers and adds them when they are new.
1285          *
1286          * @param string $poco URL to the POCO endpoint
1287          */
1288         public static function fetchServerlist($poco)
1289         {
1290                 $serverret = z_fetch_url($poco."/@server");
1291                 if (!$serverret["success"]) {
1292                         return;
1293                 }
1294                 $serverlist = json_decode($serverret['body']);
1295
1296                 if (!is_array($serverlist)) {
1297                         return;
1298                 }
1299
1300                 foreach ($serverlist as $server) {
1301                         $server_url = str_replace("/index.php", "", $server->url);
1302
1303                         $r = q("SELECT `nurl` FROM `gserver` WHERE `nurl` = '%s'", dbesc(normalise_link($server_url)));
1304                         if (!DBM::is_result($r)) {
1305                                 logger("Call server check for server ".$server_url, LOGGER_DEBUG);
1306                                 Worker::add(PRIORITY_LOW, "DiscoverPoCo", "server", $server_url);
1307                         }
1308                 }
1309         }
1310
1311         public static function discoverFederation()
1312         {
1313                 $last = Config::get('poco', 'last_federation_discovery');
1314
1315                 if ($last) {
1316                         $next = $last + (24 * 60 * 60);
1317                         if ($next > time()) {
1318                                 return;
1319                         }
1320                 }
1321
1322                 // Discover Friendica, Hubzilla and Diaspora servers
1323                 $serverdata = fetch_url("http://the-federation.info/pods.json");
1324
1325                 if ($serverdata) {
1326                         $servers = json_decode($serverdata);
1327
1328                         foreach ($servers->pods as $server) {
1329                                 Worker::add(PRIORITY_LOW, "DiscoverPoCo", "server", "https://".$server->host);
1330                         }
1331                 }
1332
1333                 // Disvover Mastodon servers
1334                 if (!Config::get('system', 'ostatus_disabled')) {
1335                         $accesstoken = Config::get('system', 'instances_social_key');
1336                         if (!empty($accesstoken)) {
1337                                 $api = 'https://instances.social/api/1.0/instances/list?count=0';
1338                                 $header = array('Authorization: Bearer '.$accesstoken);
1339                                 $serverdata = z_fetch_url($api, false, $redirects, ['headers' => $header]);
1340                                 if ($serverdata['success']) {
1341                                         $servers = json_decode($serverdata['body']);
1342                                         foreach ($servers->instances as $server) {
1343                                                 $url = (is_null($server->https_score) ? 'http' : 'https').'://'.$server->name;
1344                                                 Worker::add(PRIORITY_LOW, "DiscoverPoCo", "server", $url);
1345                                         }
1346                                 }
1347                         }
1348                 }
1349
1350                 // Currently disabled, since the service isn't available anymore.
1351                 // It is not removed since I hope that there will be a successor.
1352                 // Discover GNU Social Servers.
1353                 //if (!Config::get('system','ostatus_disabled')) {
1354                 //      $serverdata = "http://gstools.org/api/get_open_instances/";
1355
1356                 //      $result = z_fetch_url($serverdata);
1357                 //      if ($result["success"]) {
1358                 //              $servers = json_decode($result["body"]);
1359
1360                 //              foreach($servers->data as $server)
1361                 //                      self::checkServer($server->instance_address);
1362                 //      }
1363                 //}
1364
1365                 Config::set('poco', 'last_federation_discovery', time());
1366         }
1367
1368         public static function discoverSingleServer($id)
1369         {
1370                 $r = q("SELECT `poco`, `nurl`, `url`, `network` FROM `gserver` WHERE `id` = %d", intval($id));
1371                 if (!DBM::is_result($r)) {
1372                         return false;
1373                 }
1374
1375                 $server = $r[0];
1376
1377                 // Discover new servers out there (Works from Friendica version 3.5.2)
1378                 self::fetchServerlist($server["poco"]);
1379
1380                 // Fetch all users from the other server
1381                 $url = $server["poco"]."/?fields=displayName,urls,photos,updated,network,aboutMe,currentLocation,tags,gender,contactType,generation";
1382
1383                 logger("Fetch all users from the server ".$server["url"], LOGGER_DEBUG);
1384
1385                 $retdata = z_fetch_url($url);
1386                 if ($retdata["success"]) {
1387                         $data = json_decode($retdata["body"]);
1388
1389                         self::discoverServer($data, 2);
1390
1391                         if (Config::get('system', 'poco_discovery') > 1) {
1392                                 $timeframe = Config::get('system', 'poco_discovery_since');
1393                                 if ($timeframe == 0) {
1394                                         $timeframe = 30;
1395                                 }
1396
1397                                 $updatedSince = date("Y-m-d H:i:s", time() - $timeframe * 86400);
1398
1399                                 // Fetch all global contacts from the other server (Not working with Redmatrix and Friendica versions before 3.3)
1400                                 $url = $server["poco"]."/@global?updatedSince=".$updatedSince."&fields=displayName,urls,photos,updated,network,aboutMe,currentLocation,tags,gender,contactType,generation";
1401
1402                                 $success = false;
1403
1404                                 $retdata = z_fetch_url($url);
1405                                 if ($retdata["success"]) {
1406                                         logger("Fetch all global contacts from the server ".$server["nurl"], LOGGER_DEBUG);
1407                                         $success = self::discoverServer(json_decode($retdata["body"]));
1408                                 }
1409
1410                                 if (!$success && (Config::get('system', 'poco_discovery') > 2)) {
1411                                         logger("Fetch contacts from users of the server ".$server["nurl"], LOGGER_DEBUG);
1412                                         self::discoverServerUsers($data, $server);
1413                                 }
1414                         }
1415
1416                         $fields = ['last_poco_query' => datetime_convert()];
1417                         dba::update('gserver', $fields, ['nurl' => $server["nurl"]]);
1418
1419                         return true;
1420                 } else {
1421                         // If the server hadn't replied correctly, then force a sanity check
1422                         self::checkServer($server["url"], $server["network"], true);
1423
1424                         // If we couldn't reach the server, we will try it some time later
1425                         $fields = ['last_poco_query' => datetime_convert()];
1426                         dba::update('gserver', $fields, ['nurl' => $server["nurl"]]);
1427
1428                         return false;
1429                 }
1430         }
1431
1432         public static function discover($complete = false)
1433         {
1434                 // Update the server list
1435                 self::discoverFederation();
1436
1437                 $no_of_queries = 5;
1438
1439                 $requery_days = intval(Config::get("system", "poco_requery_days"));
1440
1441                 if ($requery_days == 0) {
1442                         $requery_days = 7;
1443                 }
1444                 $last_update = date("c", time() - (60 * 60 * 24 * $requery_days));
1445
1446                 $r = q("SELECT `id`, `url`, `network` FROM `gserver` WHERE `last_contact` >= `last_failure` AND `poco` != '' AND `last_poco_query` < '%s' ORDER BY RAND()", dbesc($last_update));
1447                 if (DBM::is_result($r)) {
1448                         foreach ($r as $server) {
1449                                 if (!self::checkServer($server["url"], $server["network"])) {
1450                                         // The server is not reachable? Okay, then we will try it later
1451                                         $fields = ['last_poco_query' => datetime_convert()];
1452                                         dba::update('gserver', $fields, ['nurl' => $server["nurl"]]);
1453                                         continue;
1454                                 }
1455
1456                                 logger('Update directory from server '.$server['url'].' with ID '.$server['id'], LOGGER_DEBUG);
1457                                 Worker::add(PRIORITY_LOW, "DiscoverPoCo", "update_server_directory", (int)$server['id']);
1458
1459                                 if (!$complete && (--$no_of_queries == 0)) {
1460                                         break;
1461                                 }
1462                         }
1463                 }
1464         }
1465
1466         public static function discoverServerUsers($data, $server)
1467         {
1468                 if (!isset($data->entry)) {
1469                         return;
1470                 }
1471
1472                 foreach ($data->entry as $entry) {
1473                         $username = "";
1474                         if (isset($entry->urls)) {
1475                                 foreach ($entry->urls as $url) {
1476                                         if ($url->type == 'profile') {
1477                                                 $profile_url = $url->value;
1478                                                 $urlparts = parse_url($profile_url);
1479                                                 $username = end(explode("/", $urlparts["path"]));
1480                                         }
1481                                 }
1482                         }
1483                         if ($username != "") {
1484                                 logger("Fetch contacts for the user ".$username." from the server ".$server["nurl"], LOGGER_DEBUG);
1485
1486                                 // Fetch all contacts from a given user from the other server
1487                                 $url = $server["poco"]."/".$username."/?fields=displayName,urls,photos,updated,network,aboutMe,currentLocation,tags,gender,contactType,generation";
1488
1489                                 $retdata = z_fetch_url($url);
1490                                 if ($retdata["success"]) {
1491                                         self::discoverServer(json_decode($retdata["body"]), 3);
1492                                 }
1493                         }
1494                 }
1495         }
1496
1497         public static function discoverServer($data, $default_generation = 0)
1498         {
1499                 if (!isset($data->entry) || !count($data->entry)) {
1500                         return false;
1501                 }
1502
1503                 $success = false;
1504
1505                 foreach ($data->entry as $entry) {
1506                         $profile_url = '';
1507                         $profile_photo = '';
1508                         $connect_url = '';
1509                         $name = '';
1510                         $network = '';
1511                         $updated = NULL_DATE;
1512                         $location = '';
1513                         $about = '';
1514                         $keywords = '';
1515                         $gender = '';
1516                         $contact_type = -1;
1517                         $generation = $default_generation;
1518
1519                         $name = $entry->displayName;
1520
1521                         if (isset($entry->urls)) {
1522                                 foreach ($entry->urls as $url) {
1523                                         if ($url->type == 'profile') {
1524                                                 $profile_url = $url->value;
1525                                                 continue;
1526                                         }
1527                                         if ($url->type == 'webfinger') {
1528                                                 $connect_url = str_replace('acct:' , '', $url->value);
1529                                                 continue;
1530                                         }
1531                                 }
1532                         }
1533
1534                         if (isset($entry->photos)) {
1535                                 foreach ($entry->photos as $photo) {
1536                                         if ($photo->type == 'profile') {
1537                                                 $profile_photo = $photo->value;
1538                                                 continue;
1539                                         }
1540                                 }
1541                         }
1542
1543                         if (isset($entry->updated)) {
1544                                 $updated = date("Y-m-d H:i:s", strtotime($entry->updated));
1545                         }
1546
1547                         if (isset($entry->network)) {
1548                                 $network = $entry->network;
1549                         }
1550
1551                         if (isset($entry->currentLocation)) {
1552                                 $location = $entry->currentLocation;
1553                         }
1554
1555                         if (isset($entry->aboutMe)) {
1556                                 $about = html2bbcode($entry->aboutMe);
1557                         }
1558
1559                         if (isset($entry->gender)) {
1560                                 $gender = $entry->gender;
1561                         }
1562
1563                         if (isset($entry->generation) && ($entry->generation > 0)) {
1564                                 $generation = ++$entry->generation;
1565                         }
1566
1567                         if (isset($entry->contactType) && ($entry->contactType >= 0)) {
1568                                 $contact_type = $entry->contactType;
1569                         }
1570
1571                         if (isset($entry->tags)) {
1572                                 foreach ($entry->tags as $tag) {
1573                                         $keywords = implode(", ", $tag);
1574                                 }
1575                         }
1576
1577                         if ($generation > 0) {
1578                                 $success = true;
1579
1580                                 logger("Store profile ".$profile_url, LOGGER_DEBUG);
1581
1582                                 $gcontact = array("url" => $profile_url,
1583                                                 "name" => $name,
1584                                                 "network" => $network,
1585                                                 "photo" => $profile_photo,
1586                                                 "about" => $about,
1587                                                 "location" => $location,
1588                                                 "gender" => $gender,
1589                                                 "keywords" => $keywords,
1590                                                 "connect" => $connect_url,
1591                                                 "updated" => $updated,
1592                                                 "contact-type" => $contact_type,
1593                                                 "generation" => $generation);
1594
1595                                 try {
1596                                         $gcontact = GContact::sanitize($gcontact);
1597                                         GContact::update($gcontact);
1598                                 } catch (Exception $e) {
1599                                         logger($e->getMessage(), LOGGER_DEBUG);
1600                                 }
1601
1602                                 logger("Done for profile ".$profile_url, LOGGER_DEBUG);
1603                         }
1604                 }
1605                 return $success;
1606         }
1607
1608 }