src/Protocol/DFRN.php

   1 <?php
   2 /**
   3  * @file include/dfrn.php
   4  * @brief The implementation of the dfrn protocol
   5  *
   6  * @see https://github.com/friendica/friendica/wiki/Protocol and
   7  * https://github.com/friendica/friendica/blob/master/spec/dfrn2.pdf
   8  */
   9 namespace Friendica\Protocol;
  10
  11 use DOMDocument;
  12 use DOMXPath;
  13 use Friendica\App;
  14 use Friendica\Content\OEmbed;
  15 use Friendica\Content\Text\BBCode;
  16 use Friendica\Content\Text\HTML;
  17 use Friendica\Core\Config;
  18 use Friendica\Core\Hook;
  19 use Friendica\Core\Logger;
  20 use Friendica\Core\Protocol;
  21 use Friendica\Core\System;
  22 use Friendica\Database\DBA;
  23 use Friendica\Model\Contact;
  24 use Friendica\Model\Conversation;
  25 use Friendica\Model\Event;
  26 use Friendica\Model\GContact;
  27 use Friendica\Model\Item;
  28 use Friendica\Model\Mail;
  29 use Friendica\Model\PermissionSet;
  30 use Friendica\Model\Profile;
  31 use Friendica\Model\User;
  32 use Friendica\Object\Image;
  33 use Friendica\Util\BaseURL;
  34 use Friendica\Util\Crypto;
  35 use Friendica\Util\DateTimeFormat;
  36 use Friendica\Util\Network;
  37 use Friendica\Util\Strings;
  38 use Friendica\Util\XML;
  39 use HTMLPurifier;
  40 use HTMLPurifier_Config;
  41
  42 /**
  43  * @brief This class contain functions to create and send DFRN XML files
  44  */
  45 class DFRN
  46 {
  47
  48         const TOP_LEVEL = 0;    // Top level posting
  49         const REPLY = 1;                // Regular reply that is stored locally
  50         const REPLY_RC = 2;     // Reply that will be relayed
  51
  52         /**
  53          * @brief Generates an array of contact and user for DFRN imports
  54          *
  55          * This array contains not only the receiver but also the sender of the message.
  56          *
  57          * @param integer $cid Contact id
  58          * @param integer $uid User id
  59          *
  60          * @return array importer
  61          * @throws \Exception
  62          */
  63         public static function getImporter($cid, $uid = 0)
  64         {
  65                 $condition = ['id' => $cid, 'blocked' => false, 'pending' => false];
  66                 $contact = DBA::selectFirst('contact', [], $condition);
  67                 if (!DBA::isResult($contact)) {
  68                         return [];
  69                 }
  70
  71                 $contact['cpubkey'] = $contact['pubkey'];
  72                 $contact['cprvkey'] = $contact['prvkey'];
  73                 $contact['senderName'] = $contact['name'];
  74
  75                 if ($uid != 0) {
  76                         $condition = ['uid' => $uid, 'account_expired' => false, 'account_removed' => false];
  77                         $user = DBA::selectFirst('user', [], $condition);
  78                         if (!DBA::isResult($user)) {
  79                                 return [];
  80                         }
  81
  82                         $user['importer_uid'] = $user['uid'];
  83                         $user['uprvkey'] = $user['prvkey'];
  84                 } else {
  85                         $user = ['importer_uid' => 0, 'uprvkey' => '', 'timezone' => 'UTC',
  86                                 'nickname' => '', 'sprvkey' => '', 'spubkey' => '',
  87                                 'page-flags' => 0, 'account-type' => 0, 'prvnets' => 0];
  88                 }
  89
  90                 return array_merge($contact, $user);
  91         }
  92
  93         /**
  94          * @brief Generates the atom entries for delivery.php
  95          *
  96          * This function is used whenever content is transmitted via DFRN.
  97          *
  98          * @param array $items Item elements
  99          * @param array $owner Owner record
 100          *
 101          * @return string DFRN entries
 102          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 103          * @throws \ImagickException
 104          * @todo  Find proper type-hints
 105          */
 106         public static function entries($items, $owner)
 107         {
 108                 $doc = new DOMDocument('1.0', 'utf-8');
 109                 $doc->formatOutput = true;
 110
 111                 $root = self::addHeader($doc, $owner, "dfrn:owner", "", false);
 112
 113                 if (! count($items)) {
 114                         return trim($doc->saveXML());
 115                 }
 116
 117                 foreach ($items as $item) {
 118                         // These values aren't sent when sending from the queue.
 119                         /// @todo Check if we can set these values from the queue or if they are needed at all.
 120                         $item["entry:comment-allow"] = defaults($item, "entry:comment-allow", true);
 121                         $item["entry:cid"] = defaults($item, "entry:cid", 0);
 122
 123                         $entry = self::entry($doc, "text", $item, $owner, $item["entry:comment-allow"], $item["entry:cid"]);
 124                         if (isset($entry)) {
 125                                 $root->appendChild($entry);
 126                         }
 127                 }
 128
 129                 return trim($doc->saveXML());
 130         }
 131
 132         /**
 133          * @brief Generate an atom feed for the given user
 134          *
 135          * This function is called when another server is pulling data from the user feed.
 136          *
 137          * @param string  $dfrn_id     DFRN ID from the requesting party
 138          * @param string  $owner_nick  Owner nick name
 139          * @param string  $last_update Date of the last update
 140          * @param int     $direction   Can be -1, 0 or 1.
 141          * @param boolean $onlyheader  Output only the header without content? (Default is "no")
 142          *
 143          * @return string DFRN feed entries
 144          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 145          * @throws \ImagickException
 146          */
 147         public static function feed($dfrn_id, $owner_nick, $last_update, $direction = 0, $onlyheader = false)
 148         {
 149                 $a = \get_app();
 150
 151                 $sitefeed    = ((strlen($owner_nick)) ? false : true); // not yet implemented, need to rewrite huge chunks of following logic
 152                 $public_feed = (($dfrn_id) ? false : true);
 153                 $starred     = false;   // not yet implemented, possible security issues
 154                 $converse    = false;
 155
 156                 if ($public_feed && $a->argc > 2) {
 157                         for ($x = 2; $x < $a->argc; $x++) {
 158                                 if ($a->argv[$x] == 'converse') {
 159                                         $converse = true;
 160                                 }
 161                                 if ($a->argv[$x] == 'starred') {
 162                                         $starred = true;
 163                                 }
 164                                 if ($a->argv[$x] == 'category' && $a->argc > ($x + 1) && strlen($a->argv[$x+1])) {
 165                                         $category = $a->argv[$x+1];
 166                                 }
 167                         }
 168                 }
 169
 170                 // default permissions - anonymous user
 171
 172                 $sql_extra = " AND NOT `item`.`private` ";
 173
 174                 $r = q(
 175                         "SELECT `contact`.*, `user`.`nickname`, `user`.`timezone`, `user`.`page-flags`, `user`.`account-type`
 176                         FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
 177                         WHERE `contact`.`self` AND `user`.`nickname` = '%s' LIMIT 1",
 178                         DBA::escape($owner_nick)
 179                 );
 180
 181                 if (! DBA::isResult($r)) {
 182                         Logger::log(sprintf('No contact found for nickname=%d', $owner_nick), Logger::WARNING);
 183                         exit();
 184                 }
 185
 186                 $owner = $r[0];
 187                 $owner_id = $owner['uid'];
 188
 189                 $sql_post_table = "";
 190
 191                 if (! $public_feed) {
 192                         switch ($direction) {
 193                                 case (-1):
 194                                         $sql_extra = sprintf(" AND `issued-id` = '%s' ", DBA::escape($dfrn_id));
 195                                         break;
 196                                 case 0:
 197                                         $sql_extra = sprintf(" AND `issued-id` = '%s' AND `duplex` = 1 ", DBA::escape($dfrn_id));
 198                                         break;
 199                                 case 1:
 200                                         $sql_extra = sprintf(" AND `dfrn-id` = '%s' AND `duplex` = 1 ", DBA::escape($dfrn_id));
 201                                         break;
 202                                 default:
 203                                         return false;
 204                                         break; // NOTREACHED
 205                         }
 206
 207                         $r = q(
 208                                 "SELECT * FROM `contact` WHERE NOT `blocked` AND `contact`.`uid` = %d $sql_extra LIMIT 1",
 209                                 intval($owner_id)
 210                         );
 211
 212                         if (! DBA::isResult($r)) {
 213                                 Logger::log(sprintf('No contact found for uid=%d', $owner_id), Logger::WARNING);
 214                                 exit();
 215                         }
 216
 217                         $contact = $r[0];
 218
 219                         $set = PermissionSet::get($owner_id, $contact['id']);
 220
 221                         if (!empty($set)) {
 222                                 $sql_extra = " AND `item`.`psid` IN (" . implode(',', $set) .")";
 223                         } else {
 224                                 $sql_extra = " AND NOT `item`.`private`";
 225                         }
 226                 }
 227
 228                 if ($public_feed) {
 229                         $sort = 'DESC';
 230                 } else {
 231                         $sort = 'ASC';
 232                 }
 233
 234                 if (! strlen($last_update)) {
 235                         $last_update = 'now -30 days';
 236                 }
 237
 238                 if (isset($category)) {
 239                         $sql_post_table = sprintf(
 240                                 "INNER JOIN (SELECT `oid` FROM `term` WHERE `term` = '%s' AND `otype` = %d AND `type` = %d AND `uid` = %d ORDER BY `tid` DESC) AS `term` ON `item`.`id` = `term`.`oid` ",
 241                                 DBA::escape(Strings::protectSprintf($category)),
 242                                 intval(TERM_OBJ_POST),
 243                                 intval(TERM_CATEGORY),
 244                                 intval($owner_id)
 245                         );
 246                 }
 247
 248                 if ($public_feed && ! $converse) {
 249                         $sql_extra .= " AND `contact`.`self` = 1 ";
 250                 }
 251
 252                 $check_date = DateTimeFormat::utc($last_update);
 253
 254                 $r = q(
 255                         "SELECT `item`.`id`
 256                         FROM `item` USE INDEX (`uid_wall_changed`) $sql_post_table
 257                         STRAIGHT_JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
 258                         WHERE `item`.`uid` = %d AND `item`.`wall` AND `item`.`changed` > '%s'
 259                         AND `item`.`visible` $sql_extra
 260                         ORDER BY `item`.`parent` ".$sort.", `item`.`created` ASC LIMIT 0, 300",
 261                         intval($owner_id),
 262                         DBA::escape($check_date),
 263                         DBA::escape($sort)
 264                 );
 265
 266                 $ids = [];
 267                 foreach ($r as $item) {
 268                         $ids[] = $item['id'];
 269                 }
 270
 271                 if (!empty($ids)) {
 272                         $ret = Item::select(Item::DELIVER_FIELDLIST, ['id' => $ids]);
 273                         $items = Item::inArray($ret);
 274                 } else {
 275                         $items = [];
 276                 }
 277
 278                 /*
 279                  * Will check further below if this actually returned results.
 280                  * We will provide an empty feed if that is the case.
 281                  */
 282
 283                 $doc = new DOMDocument('1.0', 'utf-8');
 284                 $doc->formatOutput = true;
 285
 286                 $alternatelink = $owner['url'];
 287
 288                 if (isset($category)) {
 289                         $alternatelink .= "/category/".$category;
 290                 }
 291
 292                 if ($public_feed) {
 293                         $author = "dfrn:owner";
 294                 } else {
 295                         $author = "author";
 296                 }
 297
 298                 $root = self::addHeader($doc, $owner, $author, $alternatelink, true);
 299
 300                 /// @TODO This hook can't work anymore
 301                 //      \Friendica\Core\Hook::callAll('atom_feed', $atom);
 302
 303                 if (!DBA::isResult($items) || $onlyheader) {
 304                         $atom = trim($doc->saveXML());
 305
 306                         Hook::callAll('atom_feed_end', $atom);
 307
 308                         return $atom;
 309                 }
 310
 311                 foreach ($items as $item) {
 312                         // prevent private email from leaking.
 313                         if ($item['network'] == Protocol::MAIL) {
 314                                 continue;
 315                         }
 316
 317                         // public feeds get html, our own nodes use bbcode
 318
 319                         if ($public_feed) {
 320                                 $type = 'html';
 321                                 // catch any email that's in a public conversation and make sure it doesn't leak
 322                                 if ($item['private']) {
 323                                         continue;
 324                                 }
 325                         } else {
 326                                 $type = 'text';
 327                         }
 328
 329                         $entry = self::entry($doc, $type, $item, $owner, true);
 330                         if (isset($entry)) {
 331                                 $root->appendChild($entry);
 332                         }
 333                 }
 334
 335                 $atom = trim($doc->saveXML());
 336
 337                 Hook::callAll('atom_feed_end', $atom);
 338
 339                 return $atom;
 340         }
 341
 342         /**
 343          * @brief Generate an atom entry for a given item id
 344          *
 345          * @param int     $item_id      The item id
 346          * @param boolean $conversation Show the conversation. If false show the single post.
 347          *
 348          * @return string DFRN feed entry
 349          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 350          * @throws \ImagickException
 351          */
 352         public static function itemFeed($item_id, $conversation = false)
 353         {
 354                 if ($conversation) {
 355                         $condition = ['parent' => $item_id];
 356                 } else {
 357                         $condition = ['id' => $item_id];
 358                 }
 359
 360                 $ret = Item::select(Item::DELIVER_FIELDLIST, $condition);
 361                 $items = Item::inArray($ret);
 362                 if (!DBA::isResult($items)) {
 363                         return '';
 364                 }
 365
 366                 $item = $items[0];
 367
 368                 if ($item['uid'] != 0) {
 369                         $owner = User::getOwnerDataById($item['uid']);
 370                         if (!$owner) {
 371                                 return '';
 372                         }
 373                 } else {
 374                         $owner = ['uid' => 0, 'nick' => 'feed-item'];
 375                 }
 376
 377                 $doc = new DOMDocument('1.0', 'utf-8');
 378                 $doc->formatOutput = true;
 379                 $type = 'html';
 380
 381                 if ($conversation) {
 382                         $root = $doc->createElementNS(NAMESPACE_ATOM1, 'feed');
 383                         $doc->appendChild($root);
 384
 385                         $root->setAttribute("xmlns:thr", NAMESPACE_THREAD);
 386                         $root->setAttribute("xmlns:at", NAMESPACE_TOMB);
 387                         $root->setAttribute("xmlns:media", NAMESPACE_MEDIA);
 388                         $root->setAttribute("xmlns:dfrn", NAMESPACE_DFRN);
 389                         $root->setAttribute("xmlns:activity", NAMESPACE_ACTIVITY);
 390                         $root->setAttribute("xmlns:georss", NAMESPACE_GEORSS);
 391                         $root->setAttribute("xmlns:poco", NAMESPACE_POCO);
 392                         $root->setAttribute("xmlns:ostatus", NAMESPACE_OSTATUS);
 393                         $root->setAttribute("xmlns:statusnet", NAMESPACE_STATUSNET);
 394
 395                         //$root = self::addHeader($doc, $owner, "dfrn:owner", "", false);
 396
 397                         foreach ($items as $item) {
 398                                 $entry = self::entry($doc, $type, $item, $owner, true, 0);
 399                                 if (isset($entry)) {
 400                                         $root->appendChild($entry);
 401                                 }
 402                         }
 403                 } else {
 404                         self::entry($doc, $type, $item, $owner, true, 0, true);
 405                 }
 406
 407                 $atom = trim($doc->saveXML());
 408                 return $atom;
 409         }
 410
 411         /**
 412          * @brief Create XML text for DFRN mails
 413          *
 414          * @param array $item  message elements
 415          * @param array $owner Owner record
 416          *
 417          * @return string DFRN mail
 418          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 419          * @todo  Find proper type-hints
 420          */
 421         public static function mail($item, $owner)
 422         {
 423                 $doc = new DOMDocument('1.0', 'utf-8');
 424                 $doc->formatOutput = true;
 425
 426                 $root = self::addHeader($doc, $owner, "dfrn:owner", "", false);
 427
 428                 $mail = $doc->createElement("dfrn:mail");
 429                 $sender = $doc->createElement("dfrn:sender");
 430
 431                 XML::addElement($doc, $sender, "dfrn:name", $owner['name']);
 432                 XML::addElement($doc, $sender, "dfrn:uri", $owner['url']);
 433                 XML::addElement($doc, $sender, "dfrn:avatar", $owner['thumb']);
 434
 435                 $mail->appendChild($sender);
 436
 437                 XML::addElement($doc, $mail, "dfrn:id", $item['uri']);
 438                 XML::addElement($doc, $mail, "dfrn:in-reply-to", $item['parent-uri']);
 439                 XML::addElement($doc, $mail, "dfrn:sentdate", DateTimeFormat::utc($item['created'] . '+00:00', DateTimeFormat::ATOM));
 440                 XML::addElement($doc, $mail, "dfrn:subject", $item['title']);
 441                 XML::addElement($doc, $mail, "dfrn:content", $item['body']);
 442
 443                 $root->appendChild($mail);
 444
 445                 return trim($doc->saveXML());
 446         }
 447
 448         /**
 449          * @brief Create XML text for DFRN friend suggestions
 450          *
 451          * @param array $item  suggestion elements
 452          * @param array $owner Owner record
 453          *
 454          * @return string DFRN suggestions
 455          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 456          * @todo  Find proper type-hints
 457          */
 458         public static function fsuggest($item, $owner)
 459         {
 460                 $doc = new DOMDocument('1.0', 'utf-8');
 461                 $doc->formatOutput = true;
 462
 463                 $root = self::addHeader($doc, $owner, "dfrn:owner", "", false);
 464
 465                 $suggest = $doc->createElement("dfrn:suggest");
 466
 467                 XML::addElement($doc, $suggest, "dfrn:url", $item['url']);
 468                 XML::addElement($doc, $suggest, "dfrn:name", $item['name']);
 469                 XML::addElement($doc, $suggest, "dfrn:photo", $item['photo']);
 470                 XML::addElement($doc, $suggest, "dfrn:request", $item['request']);
 471                 XML::addElement($doc, $suggest, "dfrn:note", $item['note']);
 472
 473                 $root->appendChild($suggest);
 474
 475                 return trim($doc->saveXML());
 476         }
 477
 478         /**
 479          * @brief Create XML text for DFRN relocations
 480          *
 481          * @param array $owner Owner record
 482          * @param int   $uid   User ID
 483          *
 484          * @return string DFRN relocations
 485          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 486          * @todo  Find proper type-hints
 487          */
 488         public static function relocate($owner, $uid)
 489         {
 490
 491                 /* get site pubkey. this could be a new installation with no site keys*/
 492                 $pubkey = Config::get('system', 'site_pubkey');
 493                 if (! $pubkey) {
 494                         $res = Crypto::newKeypair(1024);
 495                         Config::set('system', 'site_prvkey', $res['prvkey']);
 496                         Config::set('system', 'site_pubkey', $res['pubkey']);
 497                 }
 498
 499                 $rp = q(
 500                         "SELECT `resource-id` , `scale`, type FROM `photo`
 501                                 WHERE `profile` = 1 AND `uid` = %d ORDER BY scale;",
 502                         $uid
 503                 );
 504                 $photos = [];
 505                 $ext = Image::supportedTypes();
 506
 507                 foreach ($rp as $p) {
 508                         $photos[$p['scale']] = System::baseUrl().'/photo/'.$p['resource-id'].'-'.$p['scale'].'.'.$ext[$p['type']];
 509                 }
 510
 511
 512                 $doc = new DOMDocument('1.0', 'utf-8');
 513                 $doc->formatOutput = true;
 514
 515                 $root = self::addHeader($doc, $owner, "dfrn:owner", "", false);
 516
 517                 $relocate = $doc->createElement("dfrn:relocate");
 518
 519                 XML::addElement($doc, $relocate, "dfrn:url", $owner['url']);
 520                 XML::addElement($doc, $relocate, "dfrn:name", $owner['name']);
 521                 XML::addElement($doc, $relocate, "dfrn:addr", $owner['addr']);
 522                 XML::addElement($doc, $relocate, "dfrn:avatar", $owner['avatar']);
 523                 XML::addElement($doc, $relocate, "dfrn:photo", $photos[4]);
 524                 XML::addElement($doc, $relocate, "dfrn:thumb", $photos[5]);
 525                 XML::addElement($doc, $relocate, "dfrn:micro", $photos[6]);
 526                 XML::addElement($doc, $relocate, "dfrn:request", $owner['request']);
 527                 XML::addElement($doc, $relocate, "dfrn:confirm", $owner['confirm']);
 528                 XML::addElement($doc, $relocate, "dfrn:notify", $owner['notify']);
 529                 XML::addElement($doc, $relocate, "dfrn:poll", $owner['poll']);
 530                 XML::addElement($doc, $relocate, "dfrn:sitepubkey", Config::get('system', 'site_pubkey'));
 531
 532                 $root->appendChild($relocate);
 533
 534                 return trim($doc->saveXML());
 535         }
 536
 537         /**
 538          * @brief Adds the header elements for the DFRN protocol
 539          *
 540          * @param DOMDocument $doc           XML document
 541          * @param array       $owner         Owner record
 542          * @param string      $authorelement Element name for the author
 543          * @param string      $alternatelink link to profile or category
 544          * @param bool        $public        Is it a header for public posts?
 545          *
 546          * @return object XML root object
 547          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 548          * @todo  Find proper type-hints
 549          */
 550         private static function addHeader(DOMDocument $doc, $owner, $authorelement, $alternatelink = "", $public = false)
 551         {
 552
 553                 if ($alternatelink == "") {
 554                         $alternatelink = $owner['url'];
 555                 }
 556
 557                 $root = $doc->createElementNS(NAMESPACE_ATOM1, 'feed');
 558                 $doc->appendChild($root);
 559
 560                 $root->setAttribute("xmlns:thr", NAMESPACE_THREAD);
 561                 $root->setAttribute("xmlns:at", NAMESPACE_TOMB);
 562                 $root->setAttribute("xmlns:media", NAMESPACE_MEDIA);
 563                 $root->setAttribute("xmlns:dfrn", NAMESPACE_DFRN);
 564                 $root->setAttribute("xmlns:activity", NAMESPACE_ACTIVITY);
 565                 $root->setAttribute("xmlns:georss", NAMESPACE_GEORSS);
 566                 $root->setAttribute("xmlns:poco", NAMESPACE_POCO);
 567                 $root->setAttribute("xmlns:ostatus", NAMESPACE_OSTATUS);
 568                 $root->setAttribute("xmlns:statusnet", NAMESPACE_STATUSNET);
 569
 570                 XML::addElement($doc, $root, "id", System::baseUrl()."/profile/".$owner["nick"]);
 571                 XML::addElement($doc, $root, "title", $owner["name"]);
 572
 573                 $attributes = ["uri" => "https://friendi.ca", "version" => FRIENDICA_VERSION."-".DB_UPDATE_VERSION];
 574                 XML::addElement($doc, $root, "generator", FRIENDICA_PLATFORM, $attributes);
 575
 576                 $attributes = ["rel" => "license", "href" => "http://creativecommons.org/licenses/by/3.0/"];
 577                 XML::addElement($doc, $root, "link", "", $attributes);
 578
 579                 $attributes = ["rel" => "alternate", "type" => "text/html", "href" => $alternatelink];
 580                 XML::addElement($doc, $root, "link", "", $attributes);
 581
 582
 583                 if ($public) {
 584                         // DFRN itself doesn't uses this. But maybe someone else wants to subscribe to the public feed.
 585                         OStatus::hublinks($doc, $root, $owner["nick"]);
 586
 587                         $attributes = ["rel" => "salmon", "href" => System::baseUrl()."/salmon/".$owner["nick"]];
 588                         XML::addElement($doc, $root, "link", "", $attributes);
 589
 590                         $attributes = ["rel" => "http://salmon-protocol.org/ns/salmon-replies", "href" => System::baseUrl()."/salmon/".$owner["nick"]];
 591                         XML::addElement($doc, $root, "link", "", $attributes);
 592
 593                         $attributes = ["rel" => "http://salmon-protocol.org/ns/salmon-mention", "href" => System::baseUrl()."/salmon/".$owner["nick"]];
 594                         XML::addElement($doc, $root, "link", "", $attributes);
 595                 }
 596
 597                 // For backward compatibility we keep this element
 598                 if ($owner['page-flags'] == User::PAGE_FLAGS_COMMUNITY) {
 599                         XML::addElement($doc, $root, "dfrn:community", 1);
 600                 }
 601
 602                 // The former element is replaced by this one
 603                 XML::addElement($doc, $root, "dfrn:account_type", $owner["account-type"]);
 604
 605                 /// @todo We need a way to transmit the different page flags like "User::PAGE_FLAGS_PRVGROUP"
 606
 607                 XML::addElement($doc, $root, "updated", DateTimeFormat::utcNow(DateTimeFormat::ATOM));
 608
 609                 $author = self::addAuthor($doc, $owner, $authorelement, $public);
 610                 $root->appendChild($author);
 611
 612                 return $root;
 613         }
 614
 615         /**
 616          * @brief Adds the author element in the header for the DFRN protocol
 617          *
 618          * @param DOMDocument $doc           XML document
 619          * @param array       $owner         Owner record
 620          * @param string      $authorelement Element name for the author
 621          * @param boolean     $public        boolean
 622          *
 623          * @return \DOMElement XML author object
 624          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 625          * @todo  Find proper type-hints
 626          */
 627         private static function addAuthor(DOMDocument $doc, array $owner, $authorelement, $public)
 628         {
 629                 // Is the profile hidden or shouldn't be published in the net? Then add the "hide" element
 630                 $r = q(
 631                         "SELECT `id` FROM `profile` INNER JOIN `user` ON `user`.`uid` = `profile`.`uid`
 632                                 WHERE (`hidewall` OR NOT `net-publish`) AND `user`.`uid` = %d",
 633                         intval($owner['uid'])
 634                 );
 635                 if (DBA::isResult($r)) {
 636                         $hidewall = true;
 637                 } else {
 638                         $hidewall = false;
 639                 }
 640
 641                 $author = $doc->createElement($authorelement);
 642
 643                 $namdate = DateTimeFormat::utc($owner['name-date'].'+00:00', DateTimeFormat::ATOM);
 644                 $uridate = DateTimeFormat::utc($owner['uri-date'].'+00:00', DateTimeFormat::ATOM);
 645                 $picdate = DateTimeFormat::utc($owner['avatar-date'].'+00:00', DateTimeFormat::ATOM);
 646
 647                 $attributes = [];
 648
 649                 if (!$public || !$hidewall) {
 650                         $attributes = ["dfrn:updated" => $namdate];
 651                 }
 652
 653                 XML::addElement($doc, $author, "name", $owner["name"], $attributes);
 654                 XML::addElement($doc, $author, "uri", System::baseUrl().'/profile/'.$owner["nickname"], $attributes);
 655                 XML::addElement($doc, $author, "dfrn:handle", $owner["addr"], $attributes);
 656
 657                 $attributes = ["rel" => "photo", "type" => "image/jpeg",
 658                                         "media:width" => 300, "media:height" => 300, "href" => $owner['photo']];
 659
 660                 if (!$public || !$hidewall) {
 661                         $attributes["dfrn:updated"] = $picdate;
 662                 }
 663
 664                 XML::addElement($doc, $author, "link", "", $attributes);
 665
 666                 $attributes["rel"] = "avatar";
 667                 XML::addElement($doc, $author, "link", "", $attributes);
 668
 669                 if ($hidewall) {
 670                         XML::addElement($doc, $author, "dfrn:hide", "true");
 671                 }
 672
 673                 // The following fields will only be generated if the data isn't meant for a public feed
 674                 if ($public) {
 675                         return $author;
 676                 }
 677
 678                 $birthday = feed_birthday($owner['uid'], $owner['timezone']);
 679
 680                 if ($birthday) {
 681                         XML::addElement($doc, $author, "dfrn:birthday", $birthday);
 682                 }
 683
 684                 // Only show contact details when we are allowed to
 685                 $r = q(
 686                         "SELECT `profile`.`about`, `profile`.`name`, `profile`.`homepage`, `user`.`nickname`,
 687                                 `user`.`timezone`, `profile`.`locality`, `profile`.`region`, `profile`.`country-name`,
 688                                 `profile`.`pub_keywords`, `profile`.`xmpp`, `profile`.`dob`
 689                         FROM `profile`
 690                                 INNER JOIN `user` ON `user`.`uid` = `profile`.`uid`
 691                                 WHERE `profile`.`is-default` AND NOT `user`.`hidewall` AND `user`.`uid` = %d",
 692                         intval($owner['uid'])
 693                 );
 694                 if (DBA::isResult($r)) {
 695                         $profile = $r[0];
 696
 697                         XML::addElement($doc, $author, "poco:displayName", $profile["name"]);
 698                         XML::addElement($doc, $author, "poco:updated", $namdate);
 699
 700                         if (trim($profile["dob"]) > DBA::NULL_DATE) {
 701                                 XML::addElement($doc, $author, "poco:birthday", "0000-".date("m-d", strtotime($profile["dob"])));
 702                         }
 703
 704                         XML::addElement($doc, $author, "poco:note", $profile["about"]);
 705                         XML::addElement($doc, $author, "poco:preferredUsername", $profile["nickname"]);
 706
 707                         $savetz = date_default_timezone_get();
 708                         date_default_timezone_set($profile["timezone"]);
 709                         XML::addElement($doc, $author, "poco:utcOffset", date("P"));
 710                         date_default_timezone_set($savetz);
 711
 712                         if (trim($profile["homepage"]) != "") {
 713                                 $urls = $doc->createElement("poco:urls");
 714                                 XML::addElement($doc, $urls, "poco:type", "homepage");
 715                                 XML::addElement($doc, $urls, "poco:value", $profile["homepage"]);
 716                                 XML::addElement($doc, $urls, "poco:primary", "true");
 717                                 $author->appendChild($urls);
 718                         }
 719
 720                         if (trim($profile["pub_keywords"]) != "") {
 721                                 $keywords = explode(",", $profile["pub_keywords"]);
 722
 723                                 foreach ($keywords as $keyword) {
 724                                         XML::addElement($doc, $author, "poco:tags", trim($keyword));
 725                                 }
 726                         }
 727
 728                         if (trim($profile["xmpp"]) != "") {
 729                                 $ims = $doc->createElement("poco:ims");
 730                                 XML::addElement($doc, $ims, "poco:type", "xmpp");
 731                                 XML::addElement($doc, $ims, "poco:value", $profile["xmpp"]);
 732                                 XML::addElement($doc, $ims, "poco:primary", "true");
 733                                 $author->appendChild($ims);
 734                         }
 735
 736                         if (trim($profile["locality"].$profile["region"].$profile["country-name"]) != "") {
 737                                 $element = $doc->createElement("poco:address");
 738
 739                                 XML::addElement($doc, $element, "poco:formatted", Profile::formatLocation($profile));
 740
 741                                 if (trim($profile["locality"]) != "") {
 742                                         XML::addElement($doc, $element, "poco:locality", $profile["locality"]);
 743                                 }
 744
 745                                 if (trim($profile["region"]) != "") {
 746                                         XML::addElement($doc, $element, "poco:region", $profile["region"]);
 747                                 }
 748
 749                                 if (trim($profile["country-name"]) != "") {
 750                                         XML::addElement($doc, $element, "poco:country", $profile["country-name"]);
 751                                 }
 752
 753                                 $author->appendChild($element);
 754                         }
 755                 }
 756
 757                 return $author;
 758         }
 759
 760         /**
 761          * @brief Adds the author elements in the "entry" elements of the DFRN protocol
 762          *
 763          * @param DOMDocument $doc         XML document
 764          * @param string $element     Element name for the author
 765          * @param string $contact_url Link of the contact
 766          * @param array  $item        Item elements
 767          *
 768          * @return \DOMElement XML author object
 769          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 770          * @todo  Find proper type-hints
 771          */
 772         private static function addEntryAuthor(DOMDocument $doc, $element, $contact_url, $item)
 773         {
 774                 $author = $doc->createElement($element);
 775
 776                 $contact = Contact::getDetailsByURL($contact_url, $item["uid"]);
 777                 if (!empty($contact)) {
 778                         XML::addElement($doc, $author, "name", $contact["name"]);
 779                         XML::addElement($doc, $author, "uri", $contact["url"]);
 780                         XML::addElement($doc, $author, "dfrn:handle", $contact["addr"]);
 781
 782                         /// @Todo
 783                         /// - Check real image type and image size
 784                         /// - Check which of these boths elements we should use
 785                         $attributes = [
 786                                 "rel" => "photo",
 787                                 "type" => "image/jpeg",
 788                                 "media:width" => 80,
 789                                 "media:height" => 80,
 790                                 "href" => $contact["photo"]];
 791                         XML::addElement($doc, $author, "link", "", $attributes);
 792
 793                         $attributes = [
 794                                 "rel" => "avatar",
 795                                 "type" => "image/jpeg",
 796                                 "media:width" => 80,
 797                                 "media:height" => 80,
 798                                 "href" => $contact["photo"]];
 799                         XML::addElement($doc, $author, "link", "", $attributes);
 800                 }
 801
 802                 return $author;
 803         }
 804
 805         /**
 806          * @brief Adds the activity elements
 807          *
 808          * @param DOMDocument $doc      XML document
 809          * @param string      $element  Element name for the activity
 810          * @param string      $activity activity value
 811          *
 812          * @return \DOMElement XML activity object
 813          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 814          * @todo  Find proper type-hints
 815          */
 816         private static function createActivity(DOMDocument $doc, $element, $activity)
 817         {
 818                 if ($activity) {
 819                         $entry = $doc->createElement($element);
 820
 821                         $r = XML::parseString($activity, false);
 822                         if (!$r) {
 823                                 return false;
 824                         }
 825
 826                         if ($r->type) {
 827                                 XML::addElement($doc, $entry, "activity:object-type", $r->type);
 828                         }
 829
 830                         if ($r->id) {
 831                                 XML::addElement($doc, $entry, "id", $r->id);
 832                         }
 833
 834                         if ($r->title) {
 835                                 XML::addElement($doc, $entry, "title", $r->title);
 836                         }
 837
 838                         if ($r->link) {
 839                                 if (substr($r->link, 0, 1) == '<') {
 840                                         if (strstr($r->link, '&') && (! strstr($r->link, '&amp;'))) {
 841                                                 $r->link = str_replace('&', '&amp;', $r->link);
 842                                         }
 843
 844                                         $r->link = preg_replace('/\<link(.*?)\"\>/', '<link$1"/>', $r->link);
 845
 846                                         // XML does need a single element as root element so we add a dummy element here
 847                                         $data = XML::parseString("<dummy>" . $r->link . "</dummy>", false);
 848                                         if (is_object($data)) {
 849                                                 foreach ($data->link as $link) {
 850                                                         $attributes = [];
 851                                                         foreach ($link->attributes() as $parameter => $value) {
 852                                                                 $attributes[$parameter] = $value;
 853                                                         }
 854                                                         XML::addElement($doc, $entry, "link", "", $attributes);
 855                                                 }
 856                                         }
 857                                 } else {
 858                                         $attributes = ["rel" => "alternate", "type" => "text/html", "href" => $r->link];
 859                                         XML::addElement($doc, $entry, "link", "", $attributes);
 860                                 }
 861                         }
 862                         if ($r->content) {
 863                                 XML::addElement($doc, $entry, "content", BBCode::convert($r->content), ["type" => "html"]);
 864                         }
 865
 866                         return $entry;
 867                 }
 868
 869                 return false;
 870         }
 871
 872         /**
 873          * @brief Adds the elements for attachments
 874          *
 875          * @param object $doc  XML document
 876          * @param object $root XML root
 877          * @param array  $item Item element
 878          *
 879          * @return void XML attachment object
 880          * @todo  Find proper type-hints
 881          */
 882         private static function getAttachment($doc, $root, $item)
 883         {
 884                 $arr = explode('[/attach],', $item['attach']);
 885                 if (count($arr)) {
 886                         foreach ($arr as $r) {
 887                                 $matches = false;
 888                                 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|', $r, $matches);
 889                                 if ($cnt) {
 890                                         $attributes = ["rel" => "enclosure",
 891                                                         "href" => $matches[1],
 892                                                         "type" => $matches[3]];
 893
 894                                         if (intval($matches[2])) {
 895                                                 $attributes["length"] = intval($matches[2]);
 896                                         }
 897
 898                                         if (trim($matches[4]) != "") {
 899                                                 $attributes["title"] = trim($matches[4]);
 900                                         }
 901
 902                                         XML::addElement($doc, $root, "link", "", $attributes);
 903                                 }
 904                         }
 905                 }
 906         }
 907
 908         /**
 909          * @brief Adds the "entry" elements for the DFRN protocol
 910          *
 911          * @param DOMDocument $doc     XML document
 912          * @param string      $type    "text" or "html"
 913          * @param array       $item    Item element
 914          * @param array       $owner   Owner record
 915          * @param bool        $comment Trigger the sending of the "comment" element
 916          * @param int         $cid     Contact ID of the recipient
 917          * @param bool        $single  If set, the entry is created as an XML document with a single "entry" element
 918          *
 919          * @return null|\DOMElement XML entry object
 920          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
 921          * @throws \ImagickException
 922          * @todo  Find proper type-hints
 923          */
 924         private static function entry(DOMDocument $doc, $type, array $item, array $owner, $comment = false, $cid = 0, $single = false)
 925         {
 926                 $mentioned = [];
 927
 928                 if (!$item['parent']) {
 929                         Logger::notice('Item without parent found.', ['type' => $type, 'item' => $item]);
 930                         return null;
 931                 }
 932
 933                 if ($item['deleted']) {
 934                         $attributes = ["ref" => $item['uri'], "when" => DateTimeFormat::utc($item['edited'] . '+00:00', DateTimeFormat::ATOM)];
 935                         return XML::createElement($doc, "at:deleted-entry", "", $attributes);
 936                 }
 937
 938                 if (!$single) {
 939                         $entry = $doc->createElement("entry");
 940                 } else {
 941                         $entry = $doc->createElementNS(NAMESPACE_ATOM1, 'entry');
 942                         $doc->appendChild($entry);
 943
 944                         $entry->setAttribute("xmlns:thr", NAMESPACE_THREAD);
 945                         $entry->setAttribute("xmlns:at", NAMESPACE_TOMB);
 946                         $entry->setAttribute("xmlns:media", NAMESPACE_MEDIA);
 947                         $entry->setAttribute("xmlns:dfrn", NAMESPACE_DFRN);
 948                         $entry->setAttribute("xmlns:activity", NAMESPACE_ACTIVITY);
 949                         $entry->setAttribute("xmlns:georss", NAMESPACE_GEORSS);
 950                         $entry->setAttribute("xmlns:poco", NAMESPACE_POCO);
 951                         $entry->setAttribute("xmlns:ostatus", NAMESPACE_OSTATUS);
 952                         $entry->setAttribute("xmlns:statusnet", NAMESPACE_STATUSNET);
 953                 }
 954
 955                 if ($item['private']) {
 956                         $body = Item::fixPrivatePhotos($item['body'], $owner['uid'], $item, $cid);
 957                 } else {
 958                         $body = $item['body'];
 959                 }
 960
 961                 // Remove the abstract element. It is only locally important.
 962                 $body = BBCode::stripAbstract($body);
 963
 964                 $htmlbody = '';
 965                 if ($type == 'html') {
 966                         $htmlbody = $body;
 967
 968                         if ($item['title'] != "") {
 969                                 $htmlbody = "[b]" . $item['title'] . "[/b]\n\n" . $htmlbody;
 970                         }
 971
 972                         $htmlbody = BBCode::convert($htmlbody, false, 7);
 973                 }
 974
 975                 $author = self::addEntryAuthor($doc, "author", $item["author-link"], $item);
 976                 $entry->appendChild($author);
 977
 978                 $dfrnowner = self::addEntryAuthor($doc, "dfrn:owner", $item["owner-link"], $item);
 979                 $entry->appendChild($dfrnowner);
 980
 981                 if (($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
 982                         $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
 983                         $parent = Item::selectFirst(['guid', 'plink'], ['uri' => $parent_item, 'uid' => $item['uid']]);
 984                         $attributes = ["ref" => $parent_item, "type" => "text/html",
 985                                                 "href" => $parent['plink'],
 986                                                 "dfrn:diaspora_guid" => $parent['guid']];
 987                         XML::addElement($doc, $entry, "thr:in-reply-to", "", $attributes);
 988                 }
 989
 990                 // Add conversation data. This is used for OStatus
 991                 $conversation_href = System::baseUrl()."/display/".$item["parent-guid"];
 992                 $conversation_uri = $conversation_href;
 993
 994                 if (isset($parent_item)) {
 995                         $conversation = DBA::selectFirst('conversation', ['conversation-uri', 'conversation-href'], ['item-uri' => $item['parent-uri']]);
 996                         if (DBA::isResult($conversation)) {
 997                                 if ($conversation['conversation-uri'] != '') {
 998                                         $conversation_uri = $conversation['conversation-uri'];
 999                                 }
1000                                 if ($conversation['conversation-href'] != '') {
1001                                         $conversation_href = $conversation['conversation-href'];
1002                                 }
1003                         }
1004                 }
1005
1006                 $attributes = [
1007                                 "href" => $conversation_href,
1008                                 "ref" => $conversation_uri];
1009
1010                 XML::addElement($doc, $entry, "ostatus:conversation", $conversation_uri, $attributes);
1011
1012                 XML::addElement($doc, $entry, "id", $item["uri"]);
1013                 XML::addElement($doc, $entry, "title", $item["title"]);
1014
1015                 XML::addElement($doc, $entry, "published", DateTimeFormat::utc($item["created"] . "+00:00", DateTimeFormat::ATOM));
1016                 XML::addElement($doc, $entry, "updated", DateTimeFormat::utc($item["edited"] . "+00:00", DateTimeFormat::ATOM));
1017
1018                 // "dfrn:env" is used to read the content
1019                 XML::addElement($doc, $entry, "dfrn:env", Strings::base64UrlEncode($body, true));
1020
1021                 // The "content" field is not read by the receiver. We could remove it when the type is "text"
1022                 // We keep it at the moment, maybe there is some old version that doesn't read "dfrn:env"
1023                 XML::addElement($doc, $entry, "content", (($type == 'html') ? $htmlbody : $body), ["type" => $type]);
1024
1025                 // We save this value in "plink". Maybe we should read it from there as well?
1026                 XML::addElement(
1027                         $doc,
1028                         $entry,
1029                         "link",
1030                         "",
1031                         ["rel" => "alternate", "type" => "text/html",
1032                                  "href" => System::baseUrl() . "/display/" . $item["guid"]]
1033                 );
1034
1035                 // "comment-allow" is some old fashioned stuff for old Friendica versions.
1036                 // It is included in the rewritten code for completeness
1037                 if ($comment) {
1038                         XML::addElement($doc, $entry, "dfrn:comment-allow", 1);
1039                 }
1040
1041                 if ($item['location']) {
1042                         XML::addElement($doc, $entry, "dfrn:location", $item['location']);
1043                 }
1044
1045                 if ($item['coord']) {
1046                         XML::addElement($doc, $entry, "georss:point", $item['coord']);
1047                 }
1048
1049                 if ($item['private']) {
1050                         XML::addElement($doc, $entry, "dfrn:private", ($item['private'] ? $item['private'] : 1));
1051                 }
1052
1053                 if ($item['extid']) {
1054                         XML::addElement($doc, $entry, "dfrn:extid", $item['extid']);
1055                 }
1056
1057                 if ($item['post-type'] == Item::PT_PAGE) {
1058                         XML::addElement($doc, $entry, "dfrn:bookmark", "true");
1059                 }
1060
1061                 if ($item['app']) {
1062                         XML::addElement($doc, $entry, "statusnet:notice_info", "", ["local_id" => $item['id'], "source" => $item['app']]);
1063                 }
1064
1065                 XML::addElement($doc, $entry, "dfrn:diaspora_guid", $item["guid"]);
1066
1067                 // The signed text contains the content in Markdown, the sender handle and the signatur for the content
1068                 // It is needed for relayed comments to Diaspora.
1069                 if ($item['signed_text']) {
1070                         $sign = base64_encode(json_encode(['signed_text' => $item['signed_text'],'signature' => $item['signature'],'signer' => $item['signer']]));
1071                         XML::addElement($doc, $entry, "dfrn:diaspora_signature", $sign);
1072                 }
1073
1074                 XML::addElement($doc, $entry, "activity:verb", self::constructVerb($item));
1075
1076                 if ($item['object-type'] != "") {
1077                         XML::addElement($doc, $entry, "activity:object-type", $item['object-type']);
1078                 } elseif ($item['id'] == $item['parent']) {
1079                         XML::addElement($doc, $entry, "activity:object-type", ACTIVITY_OBJ_NOTE);
1080                 } else {
1081                         XML::addElement($doc, $entry, "activity:object-type", ACTIVITY_OBJ_COMMENT);
1082                 }
1083
1084                 $actobj = self::createActivity($doc, "activity:object", $item['object']);
1085                 if ($actobj) {
1086                         $entry->appendChild($actobj);
1087                 }
1088
1089                 $actarg = self::createActivity($doc, "activity:target", $item['target']);
1090                 if ($actarg) {
1091                         $entry->appendChild($actarg);
1092                 }
1093
1094                 $tags = Item::getFeedTags($item);
1095
1096                 /// @TODO Combine this with similar below if() block?
1097                 if (count($tags)) {
1098                         foreach ($tags as $t) {
1099                                 if (($type != 'html') || ($t[0] != "@")) {
1100                                         XML::addElement($doc, $entry, "category", "", ["scheme" => "X-DFRN:".$t[0].":".$t[1], "term" => $t[2]]);
1101                                 }
1102                         }
1103                 }
1104
1105                 if (count($tags)) {
1106                         foreach ($tags as $t) {
1107                                 if ($t[0] == "@") {
1108                                         $mentioned[$t[1]] = $t[1];
1109                                 }
1110                         }
1111                 }
1112
1113                 foreach ($mentioned as $mention) {
1114                         $condition = ['uid' => $owner["uid"], 'nurl' => Strings::normaliseLink($mention)];
1115                         $contact = DBA::selectFirst('contact', ['forum', 'prv'], $condition);
1116
1117                         if (DBA::isResult($contact) && ($contact["forum"] || $contact["prv"])) {
1118                                 XML::addElement(
1119                                         $doc,
1120                                         $entry,
1121                                         "link",
1122                                         "",
1123                                         ["rel" => "mentioned",
1124                                                         "ostatus:object-type" => ACTIVITY_OBJ_GROUP,
1125                                                         "href" => $mention]
1126                                 );
1127                         } else {
1128                                 XML::addElement(
1129                                         $doc,
1130                                         $entry,
1131                                         "link",
1132                                         "",
1133                                         ["rel" => "mentioned",
1134                                                         "ostatus:object-type" => ACTIVITY_OBJ_PERSON,
1135                                                         "href" => $mention]
1136                                 );
1137                         }
1138                 }
1139
1140                 self::getAttachment($doc, $entry, $item);
1141
1142                 return $entry;
1143         }
1144
1145         /**
1146          * @brief encrypts data via AES
1147          *
1148          * @param string $data The data that is to be encrypted
1149          * @param string $key  The AES key
1150          *
1151          * @return string encrypted data
1152          */
1153         private static function aesEncrypt($data, $key)
1154         {
1155                 return openssl_encrypt($data, 'aes-128-ecb', $key, OPENSSL_RAW_DATA);
1156         }
1157
1158         /**
1159          * @brief decrypts data via AES
1160          *
1161          * @param string $encrypted The encrypted data
1162          * @param string $key       The AES key
1163          *
1164          * @return string decrypted data
1165          */
1166         public static function aesDecrypt($encrypted, $key)
1167         {
1168                 return openssl_decrypt($encrypted, 'aes-128-ecb', $key, OPENSSL_RAW_DATA);
1169         }
1170
1171         /**
1172          * @brief Delivers the atom content to the contacts
1173          *
1174          * @param array  $owner    Owner record
1175          * @param array  $contact  Contact record of the receiver
1176          * @param string $atom     Content that will be transmitted
1177          * @param bool   $dissolve (to be documented)
1178          *
1179          * @param bool   $legacy_transport
1180          * @return int Deliver status. Negative values mean an error.
1181          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
1182          * @throws \ImagickException
1183          * @todo  Add array type-hint for $owner, $contact
1184          */
1185         public static function deliver($owner, $contact, $atom, $dissolve = false, $legacy_transport = false)
1186         {
1187                 // At first try the Diaspora transport layer
1188                 if (!$dissolve && !$legacy_transport) {
1189                         $curlResult = self::transmit($owner, $contact, $atom);
1190                         if ($curlResult >= 200) {
1191                                 Logger::log('Delivery via Diaspora transport layer was successful with status ' . $curlResult);
1192                                 return $curlResult;
1193                         }
1194                 }
1195
1196                 $idtosend = $orig_id = (($contact['dfrn-id']) ? $contact['dfrn-id'] : $contact['issued-id']);
1197
1198                 if ($contact['duplex'] && $contact['dfrn-id']) {
1199                         $idtosend = '0:' . $orig_id;
1200                 }
1201                 if ($contact['duplex'] && $contact['issued-id']) {
1202                         $idtosend = '1:' . $orig_id;
1203                 }
1204
1205                 $rino = Config::get('system', 'rino_encrypt');
1206                 $rino = intval($rino);
1207
1208                 Logger::log("Local rino version: ". $rino, Logger::DEBUG);
1209
1210                 $ssl_val = intval(Config::get('system', 'ssl_policy'));
1211
1212                 switch ($ssl_val) {
1213                         case BaseURL::SSL_POLICY_FULL:
1214                                 $ssl_policy = 'full';
1215                                 break;
1216                         case BaseURL::SSL_POLICY_SELFSIGN:
1217                                 $ssl_policy = 'self';
1218                                 break;
1219                         case BaseURL::SSL_POLICY_NONE:
1220                         default:
1221                                 $ssl_policy = 'none';
1222                                 break;
1223                 }
1224
1225                 $url = $contact['notify'] . '&dfrn_id=' . $idtosend . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . (($rino) ? '&rino='.$rino : '');
1226
1227                 Logger::log('dfrn_deliver: ' . $url);
1228
1229                 $curlResult = Network::curl($url);
1230
1231                 if ($curlResult->isTimeout()) {
1232                         return -2; // timed out
1233                 }
1234
1235                 $xml = $curlResult->getBody();
1236
1237                 $curl_stat = $curlResult->getReturnCode();
1238                 if (empty($curl_stat)) {
1239                         return -3; // timed out
1240                 }
1241
1242                 Logger::log('dfrn_deliver: ' . $xml, Logger::DATA);
1243
1244                 if (empty($xml)) {
1245                         return 3;
1246                 }
1247
1248                 if (strpos($xml, '<?xml') === false) {
1249                         Logger::log('dfrn_deliver: no valid XML returned');
1250                         Logger::log('dfrn_deliver: returned XML: ' . $xml, Logger::DATA);
1251                         return 3;
1252                 }
1253
1254                 $res = XML::parseString($xml);
1255
1256                 if (!is_object($res) || (intval($res->status) != 0) || !strlen($res->challenge) || !strlen($res->dfrn_id)) {
1257                         if (empty($res->status)) {
1258                                 $status = 3;
1259                         } else {
1260                                 $status = $res->status;
1261                         }
1262
1263                         return $status;
1264                 }
1265
1266                 $postvars     = [];
1267                 $sent_dfrn_id = hex2bin((string) $res->dfrn_id);
1268                 $challenge    = hex2bin((string) $res->challenge);
1269                 $perm         = (($res->perm) ? $res->perm : null);
1270                 $dfrn_version = (float) (($res->dfrn_version) ? $res->dfrn_version : 2.0);
1271                 $rino_remote_version = intval($res->rino);
1272                 $page         = (($owner['page-flags'] == User::PAGE_FLAGS_COMMUNITY) ? 1 : 0);
1273
1274                 Logger::log("Remote rino version: ".$rino_remote_version." for ".$contact["url"], Logger::DEBUG);
1275
1276                 if ($owner['page-flags'] == User::PAGE_FLAGS_PRVGROUP) {
1277                         $page = 2;
1278                 }
1279
1280                 $final_dfrn_id = '';
1281
1282                 if ($perm) {
1283                         if ((($perm == 'rw') && !intval($contact['writable']))
1284                                 || (($perm == 'r') && intval($contact['writable']))
1285                         ) {
1286                                 DBA::update('contact', ['writable' => ($perm == 'rw')], ['id' => $contact['id']]);
1287
1288                                 $contact['writable'] = (string) 1 - intval($contact['writable']);
1289                         }
1290                 }
1291
1292                 if (($contact['duplex'] && strlen($contact['pubkey']))
1293                         || ($owner['page-flags'] == User::PAGE_FLAGS_COMMUNITY && strlen($contact['pubkey']))
1294                         || ($contact['rel'] == Contact::SHARING && strlen($contact['pubkey']))
1295                 ) {
1296                         openssl_public_decrypt($sent_dfrn_id, $final_dfrn_id, $contact['pubkey']);
1297                         openssl_public_decrypt($challenge, $postvars['challenge'], $contact['pubkey']);
1298                 } else {
1299                         openssl_private_decrypt($sent_dfrn_id, $final_dfrn_id, $contact['prvkey']);
1300                         openssl_private_decrypt($challenge, $postvars['challenge'], $contact['prvkey']);
1301                 }
1302
1303                 $final_dfrn_id = substr($final_dfrn_id, 0, strpos($final_dfrn_id, '.'));
1304
1305                 if (strpos($final_dfrn_id, ':') == 1) {
1306                         $final_dfrn_id = substr($final_dfrn_id, 2);
1307                 }
1308
1309                 if ($final_dfrn_id != $orig_id) {
1310                         Logger::log('dfrn_deliver: wrong dfrn_id.');
1311                         // did not decode properly - cannot trust this site
1312                         return 3;
1313                 }
1314
1315                 $postvars['dfrn_id']      = $idtosend;
1316                 $postvars['dfrn_version'] = DFRN_PROTOCOL_VERSION;
1317                 if ($dissolve) {
1318                         $postvars['dissolve'] = '1';
1319                 }
1320
1321                 if ((($contact['rel']) && ($contact['rel'] != Contact::SHARING) && (! $contact['blocked'])) || ($owner['page-flags'] == User::PAGE_FLAGS_COMMUNITY)) {
1322                         $postvars['data'] = $atom;
1323                         $postvars['perm'] = 'rw';
1324                 } else {
1325                         $postvars['data'] = str_replace('<dfrn:comment-allow>1', '<dfrn:comment-allow>0', $atom);
1326                         $postvars['perm'] = 'r';
1327                 }
1328
1329                 $postvars['ssl_policy'] = $ssl_policy;
1330
1331                 if ($page) {
1332                         $postvars['page'] = $page;
1333                 }
1334
1335
1336                 if ($rino > 0 && $rino_remote_version > 0 && (! $dissolve)) {
1337                         Logger::log('rino version: '. $rino_remote_version);
1338
1339                         switch ($rino_remote_version) {
1340                                 case 1:
1341                                         $key = openssl_random_pseudo_bytes(16);
1342                                         $data = self::aesEncrypt($postvars['data'], $key);
1343                                         break;
1344
1345                                 default:
1346                                         Logger::log("rino: invalid requested version '$rino_remote_version'");
1347                                         return -8;
1348                         }
1349
1350                         $postvars['rino'] = $rino_remote_version;
1351                         $postvars['data'] = bin2hex($data);
1352
1353                         if ($dfrn_version >= 2.1) {
1354                                 if (($contact['duplex'] && strlen($contact['pubkey']))
1355                                         || ($owner['page-flags'] == User::PAGE_FLAGS_COMMUNITY && strlen($contact['pubkey']))
1356                                         || ($contact['rel'] == Contact::SHARING && strlen($contact['pubkey']))
1357                                 ) {
1358                                         openssl_public_encrypt($key, $postvars['key'], $contact['pubkey']);
1359                                 } else {
1360                                         openssl_private_encrypt($key, $postvars['key'], $contact['prvkey']);
1361                                 }
1362                         } else {
1363                                 if (($contact['duplex'] && strlen($contact['prvkey'])) || ($owner['page-flags'] == User::PAGE_FLAGS_COMMUNITY)) {
1364                                         openssl_private_encrypt($key, $postvars['key'], $contact['prvkey']);
1365                                 } else {
1366                                         openssl_public_encrypt($key, $postvars['key'], $contact['pubkey']);
1367                                 }
1368                         }
1369
1370                         Logger::log('md5 rawkey ' . md5($postvars['key']));
1371
1372                         $postvars['key'] = bin2hex($postvars['key']);
1373                 }
1374
1375
1376                 Logger::log('dfrn_deliver: ' . "SENDING: " . print_r($postvars, true), Logger::DATA);
1377
1378                 $postResult = Network::post($contact['notify'], $postvars);
1379
1380                 $xml = $postResult->getBody();
1381
1382                 Logger::log('dfrn_deliver: ' . "RECEIVED: " . $xml, Logger::DATA);
1383
1384                 $curl_stat = $postResult->getReturnCode();
1385                 if (empty($curl_stat) || empty($xml)) {
1386                         return -9; // timed out
1387                 }
1388
1389                 if (($curl_stat == 503) && stristr($postResult->getHeader(), 'retry-after')) {
1390                         return -10;
1391                 }
1392
1393                 if (strpos($xml, '<?xml') === false) {
1394                         Logger::log('dfrn_deliver: phase 2: no valid XML returned');
1395                         Logger::log('dfrn_deliver: phase 2: returned XML: ' . $xml, Logger::DATA);
1396                         return 3;
1397                 }
1398
1399                 $res = XML::parseString($xml);
1400
1401                 if (!isset($res->status)) {
1402                         return -11;
1403                 }
1404
1405                 // Possibly old servers had returned an empty value when everything was okay
1406                 if (empty($res->status)) {
1407                         $res->status = 200;
1408                 }
1409
1410                 if (!empty($res->message)) {
1411                         Logger::log('Delivery returned status '.$res->status.' - '.$res->message, Logger::DEBUG);
1412                 }
1413
1414                 return intval($res->status);
1415         }
1416
1417         /**
1418          * @brief Transmits atom content to the contacts via the Diaspora transport layer
1419          *
1420          * @param array  $owner   Owner record
1421          * @param array  $contact Contact record of the receiver
1422          * @param string $atom    Content that will be transmitted
1423          *
1424          * @param bool   $public_batch
1425          * @return int Deliver status. Negative values mean an error.
1426          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
1427          * @throws \ImagickException
1428          */
1429         public static function transmit($owner, $contact, $atom, $public_batch = false)
1430         {
1431                 if (!$public_batch) {
1432                         if (empty($contact['addr'])) {
1433                                 Logger::log('Empty contact handle for ' . $contact['id'] . ' - ' . $contact['url'] . ' - trying to update it.');
1434                                 if (Contact::updateFromProbe($contact['id'])) {
1435                                         $new_contact = DBA::selectFirst('contact', ['addr'], ['id' => $contact['id']]);
1436                                         $contact['addr'] = $new_contact['addr'];
1437                                 }
1438
1439                                 if (empty($contact['addr'])) {
1440                                         Logger::log('Unable to find contact handle for ' . $contact['id'] . ' - ' . $contact['url']);
1441                                         return -21;
1442                                 }
1443                         }
1444
1445                         $fcontact = Diaspora::personByHandle($contact['addr']);
1446                         if (empty($fcontact)) {
1447                                 Logger::log('Unable to find contact details for ' . $contact['id'] . ' - ' . $contact['addr']);
1448                                 return -22;
1449                         }
1450                         $pubkey = $fcontact['pubkey'];
1451                 } else {
1452                         $pubkey = '';
1453                 }
1454
1455                 $envelope = Diaspora::buildMessage($atom, $owner, $contact, $owner['uprvkey'], $pubkey, $public_batch);
1456
1457                 // Create the endpoint for public posts. This is some WIP and should later be added to the probing
1458                 if ($public_batch && empty($contact["batch"])) {
1459                         $parts = parse_url($contact["notify"]);
1460                         $path_parts = explode('/', $parts['path']);
1461                         array_pop($path_parts);
1462                         $parts['path'] =  implode('/', $path_parts);
1463                         $contact["batch"] = Network::unparseURL($parts);
1464                 }
1465
1466                 $dest_url = ($public_batch ? $contact["batch"] : $contact["notify"]);
1467
1468                 $content_type = ($public_batch ? "application/magic-envelope+xml" : "application/json");
1469
1470                 $postResult = Network::post($dest_url, $envelope, ["Content-Type: ".$content_type]);
1471                 $xml = $postResult->getBody();
1472
1473                 $curl_stat = $postResult->getReturnCode();
1474                 if (empty($curl_stat) || empty($xml)) {
1475                         Logger::log('Empty answer from ' . $contact['id'] . ' - ' . $dest_url);
1476                         return -9; // timed out
1477                 }
1478
1479                 if (($curl_stat == 503) && (stristr($postResult->getHeader(), 'retry-after'))) {
1480                         return -10;
1481                 }
1482
1483                 if (strpos($xml, '<?xml') === false) {
1484                         Logger::log('No valid XML returned from ' . $contact['id'] . ' - ' . $dest_url);
1485                         Logger::log('Returned XML: ' . $xml, Logger::DATA);
1486                         return 3;
1487                 }
1488
1489                 $res = XML::parseString($xml);
1490
1491                 if (empty($res->status)) {
1492                         return -23;
1493                 }
1494
1495                 if (!empty($res->message)) {
1496                         Logger::log('Transmit to ' . $dest_url . ' returned status '.$res->status.' - '.$res->message, Logger::DEBUG);
1497                 }
1498
1499                 return intval($res->status);
1500         }
1501
1502         /**
1503          * @brief Fetch the author data from head or entry items
1504          *
1505          * @param object $xpath     XPath object
1506          * @param object $context   In which context should the data be searched
1507          * @param array  $importer  Record of the importer user mixed with contact of the content
1508          * @param string $element   Element name from which the data is fetched
1509          * @param bool   $onlyfetch Should the data only be fetched or should it update the contact record as well
1510          * @param string $xml       optional, default empty
1511          *
1512          * @return array Relevant data of the author
1513          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
1514          * @throws \ImagickException
1515          * @todo  Find good type-hints for all parameter
1516          */
1517         private static function fetchauthor($xpath, $context, $importer, $element, $onlyfetch, $xml = "")
1518         {
1519                 $author = [];
1520                 $author["name"] = XML::getFirstNodeValue($xpath, $element."/atom:name/text()", $context);
1521                 $author["link"] = XML::getFirstNodeValue($xpath, $element."/atom:uri/text()", $context);
1522
1523                 $fields = ['id', 'uid', 'url', 'network', 'avatar-date', 'avatar', 'name-date', 'uri-date', 'addr',
1524                         'name', 'nick', 'about', 'location', 'keywords', 'xmpp', 'bdyear', 'bd', 'hidden', 'contact-type'];
1525                 $condition = ["`uid` = ? AND `nurl` = ? AND `network` != ?",
1526                         $importer["importer_uid"], Strings::normaliseLink($author["link"]), Protocol::STATUSNET];
1527                 $contact_old = DBA::selectFirst('contact', $fields, $condition);
1528
1529                 if (DBA::isResult($contact_old)) {
1530                         $author["contact-id"] = $contact_old["id"];
1531                         $author["network"] = $contact_old["network"];
1532                 } else {
1533                         if (!$onlyfetch) {
1534                                 Logger::debug("Contact ".$author["link"]." wasn't found for user ".$importer["importer_uid"]." XML: ".$xml);
1535                         }
1536
1537                         $author["contact-unknown"] = true;
1538                         $author["contact-id"] = $importer["id"];
1539                         $author["network"] = $importer["network"];
1540                         $onlyfetch = true;
1541                 }
1542
1543                 // Until now we aren't serving different sizes - but maybe later
1544                 $avatarlist = [];
1545                 /// @todo check if "avatar" or "photo" would be the best field in the specification
1546                 $avatars = $xpath->query($element . "/atom:link[@rel='avatar']", $context);
1547                 foreach ($avatars as $avatar) {
1548                         $href = "";
1549                         $width = 0;
1550                         foreach ($avatar->attributes as $attributes) {
1551                                 /// @TODO Rewrite these similar if() to one switch
1552                                 if ($attributes->name == "href") {
1553                                         $href = $attributes->textContent;
1554                                 }
1555                                 if ($attributes->name == "width") {
1556                                         $width = $attributes->textContent;
1557                                 }
1558                                 if ($attributes->name == "updated") {
1559                                         $author["avatar-date"] = $attributes->textContent;
1560                                 }
1561                         }
1562                         if (($width > 0) && ($href != "")) {
1563                                 $avatarlist[$width] = $href;
1564                         }
1565                 }
1566
1567                 if (count($avatarlist) > 0) {
1568                         krsort($avatarlist);
1569                         $author["avatar"] = current($avatarlist);
1570                 }
1571
1572                 if (empty($author['avatar']) && !empty($author['link'])) {
1573                         $cid = Contact::getIdForURL($author['link'], 0);
1574                         if (!empty($cid)) {
1575                                 $contact = DBA::selectFirst('contact', ['avatar'], ['id' => $cid]);
1576                                 if (DBA::isResult($contact)) {
1577                                         $author['avatar'] = $contact['avatar'];
1578                                 }
1579                         }
1580                 }
1581
1582                 if (empty($author['avatar'])) {
1583                         Logger::log('Empty author: ' . $xml);
1584                         $author['avatar'] = '';
1585                 }
1586
1587                 if (DBA::isResult($contact_old) && !$onlyfetch) {
1588                         Logger::log("Check if contact details for contact " . $contact_old["id"] . " (" . $contact_old["nick"] . ") have to be updated.", Logger::DEBUG);
1589
1590                         $poco = ["url" => $contact_old["url"]];
1591
1592                         // When was the last change to name or uri?
1593                         $name_element = $xpath->query($element . "/atom:name", $context)->item(0);
1594                         foreach ($name_element->attributes as $attributes) {
1595                                 if ($attributes->name == "updated") {
1596                                         $poco["name-date"] = $attributes->textContent;
1597                                 }
1598                         }
1599
1600                         $link_element = $xpath->query($element . "/atom:link", $context)->item(0);
1601                         foreach ($link_element->attributes as $attributes) {
1602                                 if ($attributes->name == "updated") {
1603                                         $poco["uri-date"] = $attributes->textContent;
1604                                 }
1605                         }
1606
1607                         // Update contact data
1608                         $value = XML::getFirstNodeValue($xpath, $element . "/dfrn:handle/text()", $context);
1609                         if ($value != "") {
1610                                 $poco["addr"] = $value;
1611                         }
1612
1613                         $value = XML::getFirstNodeValue($xpath, $element . "/poco:displayName/text()", $context);
1614                         if ($value != "") {
1615                                 $poco["name"] = $value;
1616                         }
1617
1618                         $value = XML::getFirstNodeValue($xpath, $element . "/poco:preferredUsername/text()", $context);
1619                         if ($value != "") {
1620                                 $poco["nick"] = $value;
1621                         }
1622
1623                         $value = XML::getFirstNodeValue($xpath, $element . "/poco:note/text()", $context);
1624                         if ($value != "") {
1625                                 $poco["about"] = $value;
1626                         }
1627
1628                         $value = XML::getFirstNodeValue($xpath, $element . "/poco:address/poco:formatted/text()", $context);
1629                         if ($value != "") {
1630                                 $poco["location"] = $value;
1631                         }
1632
1633                         /// @todo Only search for elements with "poco:type" = "xmpp"
1634                         $value = XML::getFirstNodeValue($xpath, $element . "/poco:ims/poco:value/text()", $context);
1635                         if ($value != "") {
1636                                 $poco["xmpp"] = $value;
1637                         }
1638
1639                         /// @todo Add support for the following fields that we don't support by now in the contact table:
1640                         /// - poco:utcOffset
1641                         /// - poco:urls
1642                         /// - poco:locality
1643                         /// - poco:region
1644                         /// - poco:country
1645
1646                         // If the "hide" element is present then the profile isn't searchable.
1647                         $hide = intval(XML::getFirstNodeValue($xpath, $element . "/dfrn:hide/text()", $context) == "true");
1648
1649                         Logger::log("Hidden status for contact " . $contact_old["url"] . ": " . $hide, Logger::DEBUG);
1650
1651                         // If the contact isn't searchable then set the contact to "hidden".
1652                         // Problem: This can be manually overridden by the user.
1653                         if ($hide) {
1654                                 $contact_old["hidden"] = true;
1655                         }
1656
1657                         // Save the keywords into the contact table
1658                         $tags = [];
1659                         $tagelements = $xpath->evaluate($element . "/poco:tags/text()", $context);
1660                         foreach ($tagelements as $tag) {
1661                                 $tags[$tag->nodeValue] = $tag->nodeValue;
1662                         }
1663
1664                         if (count($tags)) {
1665                                 $poco["keywords"] = implode(", ", $tags);
1666                         }
1667
1668                         // "dfrn:birthday" contains the birthday converted to UTC
1669                         $birthday = XML::getFirstNodeValue($xpath, $element . "/poco:birthday/text()", $context);
1670
1671                         if (strtotime($birthday) > time()) {
1672                                 $bd_timestamp = strtotime($birthday);
1673
1674                                 $poco["bdyear"] = date("Y", $bd_timestamp);
1675                         }
1676
1677                         // "poco:birthday" is the birthday in the format "yyyy-mm-dd"
1678                         $value = XML::getFirstNodeValue($xpath, $element . "/poco:birthday/text()", $context);
1679
1680                         if (!in_array($value, ["", "0000-00-00", DBA::NULL_DATE])) {
1681                                 $bdyear = date("Y");
1682                                 $value = str_replace(["0000", "0001"], $bdyear, $value);
1683
1684                                 if (strtotime($value) < time()) {
1685                                         $value = str_replace($bdyear, $bdyear + 1, $value);
1686                                 }
1687
1688                                 $poco["bd"] = $value;
1689                         }
1690
1691                         $contact = array_merge($contact_old, $poco);
1692
1693                         if ($contact_old["bdyear"] != $contact["bdyear"]) {
1694                                 Event::createBirthday($contact, $birthday);
1695                         }
1696
1697                         // Get all field names
1698                         $fields = [];
1699                         foreach ($contact_old as $field => $data) {
1700                                 $fields[$field] = $data;
1701                         }
1702
1703                         unset($fields["id"]);
1704                         unset($fields["uid"]);
1705                         unset($fields["url"]);
1706                         unset($fields["avatar-date"]);
1707                         unset($fields["avatar"]);
1708                         unset($fields["name-date"]);
1709                         unset($fields["uri-date"]);
1710
1711                         $update = false;
1712                         // Update check for this field has to be done differently
1713                         $datefields = ["name-date", "uri-date"];
1714                         foreach ($datefields as $field) {
1715                                 // The date fields arrives as '2018-07-17T10:44:45Z' - the database return '2018-07-17 10:44:45'
1716                                 // The fields have to be in the same format to be comparable, since strtotime does add timezones.
1717                                 $contact[$field] = DateTimeFormat::utc($contact[$field]);
1718
1719                                 if (strtotime($contact[$field]) > strtotime($contact_old[$field])) {
1720                                         Logger::log("Difference for contact " . $contact["id"] . " in field '" . $field . "'. New value: '" . $contact[$field] . "', old value '" . $contact_old[$field] . "'", Logger::DEBUG);
1721                                         $update = true;
1722                                 }
1723                         }
1724
1725                         foreach ($fields as $field => $data) {
1726                                 if ($contact[$field] != $contact_old[$field]) {
1727                                         Logger::log("Difference for contact " . $contact["id"] . " in field '" . $field . "'. New value: '" . $contact[$field] . "', old value '" . $contact_old[$field] . "'", Logger::DEBUG);
1728                                         $update = true;
1729                                 }
1730                         }
1731
1732                         if ($update) {
1733                                 Logger::log("Update contact data for contact " . $contact["id"] . " (" . $contact["nick"] . ")", Logger::DEBUG);
1734
1735                                 q(
1736                                         "UPDATE `contact` SET `name` = '%s', `nick` = '%s', `about` = '%s', `location` = '%s',
1737                                         `addr` = '%s', `keywords` = '%s', `bdyear` = '%s', `bd` = '%s', `hidden` = %d,
1738                                         `xmpp` = '%s', `name-date`  = '%s', `uri-date` = '%s'
1739                                         WHERE `id` = %d AND `network` = '%s'",
1740                                         DBA::escape($contact["name"]), DBA::escape($contact["nick"]), DBA::escape($contact["about"]),   DBA::escape($contact["location"]),
1741                                         DBA::escape($contact["addr"]), DBA::escape($contact["keywords"]), DBA::escape($contact["bdyear"]),
1742                                         DBA::escape($contact["bd"]), intval($contact["hidden"]), DBA::escape($contact["xmpp"]),
1743                                         DBA::escape(DateTimeFormat::utc($contact["name-date"])), DBA::escape(DateTimeFormat::utc($contact["uri-date"])),
1744                                         intval($contact["id"]), DBA::escape($contact["network"])
1745                                 );
1746                         }
1747
1748                         Contact::updateAvatar(
1749                                 $author['avatar'],
1750                                 $importer['importer_uid'],
1751                                 $contact['id'],
1752                                 (strtotime($contact['avatar-date']) > strtotime($contact_old['avatar-date']) || ($author['avatar'] != $contact_old['avatar']))
1753                         );
1754
1755                         /*
1756                          * The generation is a sign for the reliability of the provided data.
1757                          * It is used in the socgraph.php to prevent that old contact data
1758                          * that was relayed over several servers can overwrite contact
1759                          * data that we received directly.
1760                          */
1761
1762                         $poco["generation"] = 2;
1763                         $poco["photo"] = $author["avatar"];
1764                         $poco["hide"] = $hide;
1765                         $poco["contact-type"] = $contact["contact-type"];
1766                         $gcid = GContact::update($poco);
1767
1768                         GContact::link($gcid, $importer["importer_uid"], $contact["id"]);
1769                 }
1770
1771                 return $author;
1772         }
1773
1774         /**
1775          * @brief Transforms activity objects into an XML string
1776          *
1777          * @param object $xpath    XPath object
1778          * @param object $activity Activity object
1779          * @param string $element  element name
1780          *
1781          * @return string XML string
1782          * @todo Find good type-hints for all parameter
1783          */
1784         private static function transformActivity($xpath, $activity, $element)
1785         {
1786                 if (!is_object($activity)) {
1787                         return "";
1788                 }
1789
1790                 $obj_doc = new DOMDocument("1.0", "utf-8");
1791                 $obj_doc->formatOutput = true;
1792
1793                 $obj_element = $obj_doc->createElementNS(NAMESPACE_ATOM1, $element);
1794
1795                 $activity_type = $xpath->query("activity:object-type/text()", $activity)->item(0)->nodeValue;
1796                 XML::addElement($obj_doc, $obj_element, "type", $activity_type);
1797
1798                 $id = $xpath->query("atom:id", $activity)->item(0);
1799                 if (is_object($id)) {
1800                         $obj_element->appendChild($obj_doc->importNode($id, true));
1801                 }
1802
1803                 $title = $xpath->query("atom:title", $activity)->item(0);
1804                 if (is_object($title)) {
1805                         $obj_element->appendChild($obj_doc->importNode($title, true));
1806                 }
1807
1808                 $links = $xpath->query("atom:link", $activity);
1809                 if (is_object($links)) {
1810                         foreach ($links as $link) {
1811                                 $obj_element->appendChild($obj_doc->importNode($link, true));
1812                         }
1813                 }
1814
1815                 $content = $xpath->query("atom:content", $activity)->item(0);
1816                 if (is_object($content)) {
1817                         $obj_element->appendChild($obj_doc->importNode($content, true));
1818                 }
1819
1820                 $obj_doc->appendChild($obj_element);
1821
1822                 $objxml = $obj_doc->saveXML($obj_element);
1823
1824                 /// @todo This isn't totally clean. We should find a way to transform the namespaces
1825                 $objxml = str_replace("<".$element.' xmlns="http://www.w3.org/2005/Atom">', "<".$element.">", $objxml);
1826                 return($objxml);
1827         }
1828
1829         /**
1830          * @brief Processes the mail elements
1831          *
1832          * @param object $xpath    XPath object
1833          * @param object $mail     mail elements
1834          * @param array  $importer Record of the importer user mixed with contact of the content
1835          * @return void
1836          * @throws \Exception
1837          * @todo  Find good type-hints for all parameter
1838          */
1839         private static function processMail($xpath, $mail, $importer)
1840         {
1841                 Logger::log("Processing mails");
1842
1843                 $msg = [];
1844                 $msg["uid"] = $importer["importer_uid"];
1845                 $msg["from-name"] = $xpath->query("dfrn:sender/dfrn:name/text()", $mail)->item(0)->nodeValue;
1846                 $msg["from-url"] = $xpath->query("dfrn:sender/dfrn:uri/text()", $mail)->item(0)->nodeValue;
1847                 $msg["from-photo"] = $xpath->query("dfrn:sender/dfrn:avatar/text()", $mail)->item(0)->nodeValue;
1848                 $msg["contact-id"] = $importer["id"];
1849                 $msg["uri"] = $xpath->query("dfrn:id/text()", $mail)->item(0)->nodeValue;
1850                 $msg["parent-uri"] = $xpath->query("dfrn:in-reply-to/text()", $mail)->item(0)->nodeValue;
1851                 $msg["created"] = DateTimeFormat::utc($xpath->query("dfrn:sentdate/text()", $mail)->item(0)->nodeValue);
1852                 $msg["title"] = $xpath->query("dfrn:subject/text()", $mail)->item(0)->nodeValue;
1853                 $msg["body"] = $xpath->query("dfrn:content/text()", $mail)->item(0)->nodeValue;
1854
1855                 Mail::insert($msg);
1856         }
1857
1858         /**
1859          * @brief Processes the suggestion elements
1860          *
1861          * @param object $xpath      XPath object
1862          * @param object $suggestion suggestion elements
1863          * @param array  $importer   Record of the importer user mixed with contact of the content
1864          * @return boolean
1865          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
1866          * @todo  Find good type-hints for all parameter
1867          */
1868         private static function processSuggestion($xpath, $suggestion, $importer)
1869         {
1870                 Logger::log('Processing suggestions');
1871
1872                 /// @TODO Rewrite this to one statement
1873                 $suggest = [];
1874                 $suggest['uid'] = $importer['importer_uid'];
1875                 $suggest['cid'] = $importer['id'];
1876                 $suggest['url'] = $xpath->query('dfrn:url/text()', $suggestion)->item(0)->nodeValue;
1877                 $suggest['name'] = $xpath->query('dfrn:name/text()', $suggestion)->item(0)->nodeValue;
1878                 $suggest['photo'] = $xpath->query('dfrn:photo/text()', $suggestion)->item(0)->nodeValue;
1879                 $suggest['request'] = $xpath->query('dfrn:request/text()', $suggestion)->item(0)->nodeValue;
1880                 $suggest['body'] = $xpath->query('dfrn:note/text()', $suggestion)->item(0)->nodeValue;
1881
1882                 // Does our member already have a friend matching this description?
1883
1884                 /*
1885                  * The valid result means the friend we're about to send a friend
1886                  * suggestion already has them in their contact, which means no further
1887                  * action is required.
1888                  *
1889                  * @see https://github.com/friendica/friendica/pull/3254#discussion_r107315246
1890                  */
1891                 $condition = ['nurl' => Strings::normaliseLink($suggest['url']), 'uid' => $suggest['uid']];
1892                 if (DBA::exists('contact', $condition)) {
1893                         return false;
1894                 }
1895                 // Do we already have an fcontact record for this person?
1896
1897                 $fid = 0;
1898                 $fcontact = DBA::selectFirst('fcontact', ['id'], ['url' => $suggest['url']]);
1899                 if (DBA::isResult($fcontact)) {
1900                         $fid = $fcontact['id'];
1901
1902                         // OK, we do. Do we already have an introduction for this person?
1903                         if (DBA::exists('intro', ['uid' => $suggest['uid'], 'fid' => $fid])) {
1904                                 /*
1905                                  * The valid result means the friend we're about to send a friend
1906                                  * suggestion already has them in their contact, which means no further
1907                                  * action is required.
1908                                  *
1909                                  * @see https://github.com/friendica/friendica/pull/3254#discussion_r107315246
1910                                  */
1911                                 return false;
1912                         }
1913                 }
1914
1915                 if (!$fid) {
1916                         $fields = ['name' => $suggest['name'], 'url' => $suggest['url'],
1917                                 'photo' => $suggest['photo'], 'request' => $suggest['request']];
1918                         DBA::insert('fcontact', $fields);
1919                         $fid = DBA::lastInsertId();
1920                 }
1921
1922                 /*
1923                  * If no record in fcontact is found, below INSERT statement will not
1924                  * link an introduction to it.
1925                  */
1926                 if (empty($fid)) {
1927                         // Database record did not get created. Quietly give up.
1928                         exit();
1929                 }
1930
1931                 $hash = Strings::getRandomHex();
1932
1933                 $fields = ['uid' => $suggest['uid'], 'fid' => $fid, 'contact-id' => $suggest['cid'],
1934                         'note' => $suggest['body'], 'hash' => $hash, 'datetime' => DateTimeFormat::utcNow(), 'blocked' => false];
1935                 DBA::insert('intro', $fields);
1936
1937                 notification(
1938                         [
1939                                 'type'         => NOTIFY_SUGGEST,
1940                                 'notify_flags' => $importer['notify-flags'],
1941                                 'language'     => $importer['language'],
1942                                 'to_name'      => $importer['username'],
1943                                 'to_email'     => $importer['email'],
1944                                 'uid'          => $importer['importer_uid'],
1945                                 'item'         => $suggest,
1946                                 'link'         => System::baseUrl().'/notifications/intros',
1947                                 'source_name'  => $importer['name'],
1948                                 'source_link'  => $importer['url'],
1949                                 'source_photo' => $importer['photo'],
1950                                 'verb'         => ACTIVITY_REQ_FRIEND,
1951                                 'otype'        => 'intro']
1952                 );
1953
1954                 return true;
1955         }
1956
1957         /**
1958          * @brief Processes the relocation elements
1959          *
1960          * @param object $xpath      XPath object
1961          * @param object $relocation relocation elements
1962          * @param array  $importer   Record of the importer user mixed with contact of the content
1963          * @return boolean
1964          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
1965          * @throws \ImagickException
1966          * @todo  Find good type-hints for all parameter
1967          */
1968         private static function processRelocation($xpath, $relocation, $importer)
1969         {
1970                 Logger::log("Processing relocations");
1971
1972                 /// @TODO Rewrite this to one statement
1973                 $relocate = [];
1974                 $relocate["uid"] = $importer["importer_uid"];
1975                 $relocate["cid"] = $importer["id"];
1976                 $relocate["url"] = $xpath->query("dfrn:url/text()", $relocation)->item(0)->nodeValue;
1977                 $relocate["addr"] = $xpath->query("dfrn:addr/text()", $relocation)->item(0)->nodeValue;
1978                 $relocate["name"] = $xpath->query("dfrn:name/text()", $relocation)->item(0)->nodeValue;
1979                 $relocate["avatar"] = $xpath->query("dfrn:avatar/text()", $relocation)->item(0)->nodeValue;
1980                 $relocate["photo"] = $xpath->query("dfrn:photo/text()", $relocation)->item(0)->nodeValue;
1981                 $relocate["thumb"] = $xpath->query("dfrn:thumb/text()", $relocation)->item(0)->nodeValue;
1982                 $relocate["micro"] = $xpath->query("dfrn:micro/text()", $relocation)->item(0)->nodeValue;
1983                 $relocate["request"] = $xpath->query("dfrn:request/text()", $relocation)->item(0)->nodeValue;
1984                 $relocate["confirm"] = $xpath->query("dfrn:confirm/text()", $relocation)->item(0)->nodeValue;
1985                 $relocate["notify"] = $xpath->query("dfrn:notify/text()", $relocation)->item(0)->nodeValue;
1986                 $relocate["poll"] = $xpath->query("dfrn:poll/text()", $relocation)->item(0)->nodeValue;
1987                 $relocate["sitepubkey"] = $xpath->query("dfrn:sitepubkey/text()", $relocation)->item(0)->nodeValue;
1988
1989                 if (($relocate["avatar"] == "") && ($relocate["photo"] != "")) {
1990                         $relocate["avatar"] = $relocate["photo"];
1991                 }
1992
1993                 if ($relocate["addr"] == "") {
1994                         $relocate["addr"] = preg_replace("=(https?://)(.*)/profile/(.*)=ism", "$3@$2", $relocate["url"]);
1995                 }
1996
1997                 // update contact
1998                 $r = q(
1999                         "SELECT `photo`, `url` FROM `contact` WHERE `id` = %d AND `uid` = %d",
2000                         intval($importer["id"]),
2001                         intval($importer["importer_uid"])
2002                 );
2003
2004                 if (!DBA::isResult($r)) {
2005                         Logger::log("Query failed to execute, no result returned in " . __FUNCTION__);
2006                         return false;
2007                 }
2008
2009                 $old = $r[0];
2010
2011                 // Update the gcontact entry
2012                 $relocate["server_url"] = preg_replace("=(https?://)(.*)/profile/(.*)=ism", "$1$2", $relocate["url"]);
2013
2014                 $fields = ['name' => $relocate["name"], 'photo' => $relocate["avatar"],
2015                         'url' => $relocate["url"], 'nurl' => Strings::normaliseLink($relocate["url"]),
2016                         'addr' => $relocate["addr"], 'connect' => $relocate["addr"],
2017                         'notify' => $relocate["notify"], 'server_url' => $relocate["server_url"]];
2018                 DBA::update('gcontact', $fields, ['nurl' => Strings::normaliseLink($old["url"])]);
2019
2020                 // Update the contact table. We try to find every entry.
2021                 $fields = ['name' => $relocate["name"], 'avatar' => $relocate["avatar"],
2022                         'url' => $relocate["url"], 'nurl' => Strings::normaliseLink($relocate["url"]),
2023                         'addr' => $relocate["addr"], 'request' => $relocate["request"],
2024                         'confirm' => $relocate["confirm"], 'notify' => $relocate["notify"],
2025                         'poll' => $relocate["poll"], 'site-pubkey' => $relocate["sitepubkey"]];
2026                 $condition = ["(`id` = ?) OR (`nurl` = ?)", $importer["id"], Strings::normaliseLink($old["url"])];
2027
2028                 DBA::update('contact', $fields, $condition);
2029
2030                 Contact::updateAvatar($relocate["avatar"], $importer["importer_uid"], $importer["id"], true);
2031
2032                 Logger::log('Contacts are updated.');
2033
2034                 /// @TODO
2035                 /// merge with current record, current contents have priority
2036                 /// update record, set url-updated
2037                 /// update profile photos
2038                 /// schedule a scan?
2039                 return true;
2040         }
2041
2042         /**
2043          * @brief Updates an item
2044          *
2045          * @param array $current   the current item record
2046          * @param array $item      the new item record
2047          * @param array $importer  Record of the importer user mixed with contact of the content
2048          * @param int   $entrytype Is it a toplevel entry, a comment or a relayed comment?
2049          * @return mixed
2050          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
2051          * @todo  set proper type-hints (array?)
2052          */
2053         private static function updateContent($current, $item, $importer, $entrytype)
2054         {
2055                 $changed = false;
2056
2057                 if (self::isEditedTimestampNewer($current, $item)) {
2058                         // do not accept (ignore) an earlier edit than one we currently have.
2059                         if (DateTimeFormat::utc($item["edited"]) < $current["edited"]) {
2060                                 return false;
2061                         }
2062
2063                         $fields = ['title' => defaults($item, 'title', ''), 'body' => defaults($item, 'body', ''),
2064                                         'tag' => defaults($item, 'tag', ''), 'changed' => DateTimeFormat::utcNow(),
2065                                         'edited' => DateTimeFormat::utc($item["edited"])];
2066
2067                         $condition = ["`uri` = ? AND `uid` IN (0, ?)", $item["uri"], $importer["importer_uid"]];
2068                         Item::update($fields, $condition);
2069
2070                         $changed = true;
2071                 }
2072                 return $changed;
2073         }
2074
2075         /**
2076          * @brief Detects the entry type of the item
2077          *
2078          * @param array $importer Record of the importer user mixed with contact of the content
2079          * @param array $item     the new item record
2080          *
2081          * @return int Is it a toplevel entry, a comment or a relayed comment?
2082          * @throws \Exception
2083          * @todo  set proper type-hints (array?)
2084          */
2085         private static function getEntryType($importer, $item)
2086         {
2087                 if ($item["parent-uri"] != $item["uri"]) {
2088                         $community = false;
2089
2090                         if ($importer["page-flags"] == User::PAGE_FLAGS_COMMUNITY || $importer["page-flags"] == User::PAGE_FLAGS_PRVGROUP) {
2091                                 $sql_extra = "";
2092                                 $community = true;
2093                                 Logger::log("possible community action");
2094                         } else {
2095                                 $sql_extra = " AND `contact`.`self` AND `item`.`wall` ";
2096                         }
2097
2098                         // was the top-level post for this action written by somebody on this site?
2099                         // Specifically, the recipient?
2100
2101                         $is_a_remote_action = false;
2102
2103                         $parent = Item::selectFirst(['parent-uri'], ['uri' => $item["parent-uri"]]);
2104                         if (DBA::isResult($parent)) {
2105                                 $r = q(
2106                                         "SELECT `item`.`forum_mode`, `item`.`wall` FROM `item`
2107                                         INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
2108                                         WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' OR `item`.`thr-parent` = '%s')
2109                                         AND `item`.`uid` = %d
2110                                         $sql_extra
2111                                         LIMIT 1",
2112                                         DBA::escape($parent["parent-uri"]),
2113                                         DBA::escape($parent["parent-uri"]),
2114                                         DBA::escape($parent["parent-uri"]),
2115                                         intval($importer["importer_uid"])
2116                                 );
2117                                 if (DBA::isResult($r)) {
2118                                         $is_a_remote_action = true;
2119                                 }
2120                         }
2121
2122                         /*
2123                          * Does this have the characteristics of a community or private group action?
2124                          * If it's an action to a wall post on a community/prvgroup page it's a
2125                          * valid community action. Also forum_mode makes it valid for sure.
2126                          * If neither, it's not.
2127                          */
2128                         if ($is_a_remote_action && $community && (!$r[0]["forum_mode"]) && (!$r[0]["wall"])) {
2129                                 $is_a_remote_action = false;
2130                                 Logger::log("not a community action");
2131                         }
2132
2133                         if ($is_a_remote_action) {
2134                                 return DFRN::REPLY_RC;
2135                         } else {
2136                                 return DFRN::REPLY;
2137                         }
2138                 } else {
2139                         return DFRN::TOP_LEVEL;
2140                 }
2141         }
2142
2143         /**
2144          * @brief Send a "poke"
2145          *
2146          * @param array $item      The new item record
2147          * @param array $importer  Record of the importer user mixed with contact of the content
2148          * @return void
2149          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
2150          * @todo  set proper type-hints (array?)
2151          */
2152         private static function doPoke(array $item, array $importer)
2153         {
2154                 $verb = urldecode(substr($item["verb"], strpos($item["verb"], "#")+1));
2155                 if (!$verb) {
2156                         return;
2157                 }
2158                 $xo = XML::parseString($item["object"], false);
2159
2160                 if (($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
2161                         // somebody was poked/prodded. Was it me?
2162                         $Blink = '';
2163                         foreach ($xo->link as $l) {
2164                                 $atts = $l->attributes();
2165                                 switch ($atts["rel"]) {
2166                                         case "alternate":
2167                                                 $Blink = $atts["href"];
2168                                                 break;
2169                                         default:
2170                                                 break;
2171                                 }
2172                         }
2173
2174                         if ($Blink && Strings::compareLink($Blink, System::baseUrl() . "/profile/" . $importer["nickname"])) {
2175                                 $author = DBA::selectFirst('contact', ['name', 'thumb', 'url'], ['id' => $item['author-id']]);
2176
2177                                 $parent = Item::selectFirst(['id'], ['uri' => $item['parent-uri'], 'uid' => $importer["importer_uid"]]);
2178                                 $item["parent"] = $parent['id'];
2179
2180                                 // send a notification
2181                                 notification(
2182                                         [
2183                                         "type"         => NOTIFY_POKE,
2184                                         "notify_flags" => $importer["notify-flags"],
2185                                         "language"     => $importer["language"],
2186                                         "to_name"      => $importer["username"],
2187                                         "to_email"     => $importer["email"],
2188                                         "uid"          => $importer["importer_uid"],
2189                                         "item"         => $item,
2190                                         "link"         => System::baseUrl()."/display/".urlencode($item['guid']),
2191                                         "source_name"  => $author["name"],
2192                                         "source_link"  => $author["url"],
2193                                         "source_photo" => $author["thumb"],
2194                                         "verb"         => $item["verb"],
2195                                         "otype"        => "person",
2196                                         "activity"     => $verb,
2197                                         "parent"       => $item["parent"]]
2198                                 );
2199                         }
2200                 }
2201         }
2202
2203         /**
2204          * @brief Processes several actions, depending on the verb
2205          *
2206          * @param int   $entrytype Is it a toplevel entry, a comment or a relayed comment?
2207          * @param array $importer  Record of the importer user mixed with contact of the content
2208          * @param array $item      the new item record
2209          * @param bool  $is_like   Is the verb a "like"?
2210          *
2211          * @return bool Should the processing of the entries be continued?
2212          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
2213          * @todo  set proper type-hints (array?)
2214          */
2215         private static function processVerbs($entrytype, $importer, &$item, &$is_like)
2216         {
2217                 Logger::log("Process verb ".$item["verb"]." and object-type ".$item["object-type"]." for entrytype ".$entrytype, Logger::DEBUG);
2218
2219                 if (($entrytype == DFRN::TOP_LEVEL)) {
2220                         // The filling of the the "contact" variable is done for legcy reasons
2221                         // The functions below are partly used by ostatus.php as well - where we have this variable
2222                         $r = q("SELECT * FROM `contact` WHERE `id` = %d", intval($importer["id"]));
2223                         $contact = $r[0];
2224
2225                         // Big question: Do we need these functions? They were part of the "consume_feed" function.
2226                         // This function once was responsible for DFRN and OStatus.
2227                         if (activity_match($item["verb"], ACTIVITY_FOLLOW)) {
2228                                 Logger::log("New follower");
2229                                 Contact::addRelationship($importer, $contact, $item);
2230                                 return false;
2231                         }
2232                         if (activity_match($item["verb"], ACTIVITY_UNFOLLOW)) {
2233                                 Logger::log("Lost follower");
2234                                 Contact::removeFollower($importer, $contact, $item);
2235                                 return false;
2236                         }
2237                         if (activity_match($item["verb"], ACTIVITY_REQ_FRIEND)) {
2238                                 Logger::log("New friend request");
2239                                 Contact::addRelationship($importer, $contact, $item, true);
2240                                 return false;
2241                         }
2242                         if (activity_match($item["verb"], ACTIVITY_UNFRIEND)) {
2243                                 Logger::log("Lost sharer");
2244                                 Contact::removeSharer($importer, $contact, $item);
2245                                 return false;
2246                         }
2247                 } else {
2248                         if (($item["verb"] == ACTIVITY_LIKE)
2249                                 || ($item["verb"] == ACTIVITY_DISLIKE)
2250                                 || ($item["verb"] == ACTIVITY_ATTEND)
2251                                 || ($item["verb"] == ACTIVITY_ATTENDNO)
2252                                 || ($item["verb"] == ACTIVITY_ATTENDMAYBE)
2253                         ) {
2254                                 $is_like = true;
2255                                 $item["gravity"] = GRAVITY_ACTIVITY;
2256                                 // only one like or dislike per person
2257                                 // splitted into two queries for performance issues
2258                                 $condition = ['uid' => $item["uid"], 'author-id' => $item["author-id"], 'gravity' => GRAVITY_ACTIVITY,
2259                                         'verb' => $item["verb"], 'parent-uri' => $item["parent-uri"]];
2260                                 if (Item::exists($condition)) {
2261                                         return false;
2262                                 }
2263
2264                                 $condition = ['uid' => $item["uid"], 'author-id' => $item["author-id"], 'gravity' => GRAVITY_ACTIVITY,
2265                                         'verb' => $item["verb"], 'thr-parent' => $item["parent-uri"]];
2266                                 if (Item::exists($condition)) {
2267                                         return false;
2268                                 }
2269
2270                                 // The owner of an activity must be the author
2271                                 $item["owner-name"] = $item["author-name"];
2272                                 $item["owner-link"] = $item["author-link"];
2273                                 $item["owner-avatar"] = $item["author-avatar"];
2274                                 $item["owner-id"] = $item["author-id"];
2275                         } else {
2276                                 $is_like = false;
2277                         }
2278
2279                         if (($item["verb"] == ACTIVITY_TAG) && ($item["object-type"] == ACTIVITY_OBJ_TAGTERM)) {
2280                                 $xo = XML::parseString($item["object"], false);
2281                                 $xt = XML::parseString($item["target"], false);
2282
2283                                 if ($xt->type == ACTIVITY_OBJ_NOTE) {
2284                                         $item_tag = Item::selectFirst(['id', 'tag'], ['uri' => $xt->id, 'uid' => $importer["importer_uid"]]);
2285
2286                                         if (!DBA::isResult($item_tag)) {
2287                                                 Logger::log("Query failed to execute, no result returned in " . __FUNCTION__);
2288                                                 return false;
2289                                         }
2290
2291                                         // extract tag, if not duplicate, add to parent item
2292                                         if ($xo->content) {
2293                                                 if (!stristr($item_tag["tag"], trim($xo->content))) {
2294                                                         $tag = $item_tag["tag"] . (strlen($item_tag["tag"]) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
2295                                                         Item::update(['tag' => $tag], ['id' => $item_tag["id"]]);
2296                                                 }
2297                                         }
2298                                 }
2299                         }
2300                 }
2301                 return true;
2302         }
2303
2304         /**
2305          * @brief Processes the link elements
2306          *
2307          * @param object $links link elements
2308          * @param array  $item  the item record
2309          * @return void
2310          * @todo set proper type-hints
2311          */
2312         private static function parseLinks($links, &$item)
2313         {
2314                 $rel = "";
2315                 $href = "";
2316                 $type = "";
2317                 $length = "0";
2318                 $title = "";
2319                 foreach ($links as $link) {
2320                         foreach ($link->attributes as $attributes) {
2321                                 switch ($attributes->name) {
2322                                         case "href"  : $href   = $attributes->textContent; break;
2323                                         case "rel"   : $rel    = $attributes->textContent; break;
2324                                         case "type"  : $type   = $attributes->textContent; break;
2325                                         case "length": $length = $attributes->textContent; break;
2326                                         case "title" : $title  = $attributes->textContent; break;
2327                                 }
2328                         }
2329                         if (($rel != "") && ($href != "")) {
2330                                 switch ($rel) {
2331                                         case "alternate":
2332                                                 $item["plink"] = $href;
2333                                                 break;
2334                                         case "enclosure":
2335                                                 if (!empty($item["attach"])) {
2336                                                         $item["attach"] .= ",";
2337                                                 } else {
2338                                                         $item["attach"] = "";
2339                                                 }
2340
2341                                                 $item["attach"] .= '[attach]href="' . $href . '" length="' . $length . '" type="' . $type . '" title="' . $title . '"[/attach]';
2342                                                 break;
2343                                 }
2344                         }
2345                 }
2346         }
2347
2348         /**
2349          * @brief Processes the entry elements which contain the items and comments
2350          *
2351          * @param array  $header   Array of the header elements that always stay the same
2352          * @param object $xpath    XPath object
2353          * @param object $entry    entry elements
2354          * @param array  $importer Record of the importer user mixed with contact of the content
2355          * @param string $xml      xml
2356          * @return void
2357          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
2358          * @throws \ImagickException
2359          * @todo  Add type-hints
2360          */
2361         private static function processEntry($header, $xpath, $entry, $importer, $xml)
2362         {
2363                 Logger::log("Processing entries");
2364
2365                 $item = $header;
2366
2367                 $item["protocol"] = Conversation::PARCEL_DFRN;
2368
2369                 $item["source"] = $xml;
2370
2371                 // Get the uri
2372                 $item["uri"] = XML::getFirstNodeValue($xpath, "atom:id/text()", $entry);
2373
2374                 $item["edited"] = XML::getFirstNodeValue($xpath, "atom:updated/text()", $entry);
2375
2376                 $current = Item::selectFirst(['id', 'uid', 'edited', 'body'],
2377                         ['uri' => $item["uri"], 'uid' => $importer["importer_uid"]]
2378                 );
2379                 // Is there an existing item?
2380                 if (DBA::isResult($current) && !self::isEditedTimestampNewer($current, $item)) {
2381                         Logger::log("Item ".$item["uri"]." (".$item['edited'].") already existed.", Logger::DEBUG);
2382                         return;
2383                 }
2384
2385                 // Fetch the owner
2386                 $owner = self::fetchauthor($xpath, $entry, $importer, "dfrn:owner", true, $xml);
2387
2388                 $owner_unknown = (isset($owner["contact-unknown"]) && $owner["contact-unknown"]);
2389
2390                 $item["owner-name"] = $owner["name"];
2391                 $item["owner-link"] = $owner["link"];
2392                 $item["owner-avatar"] = $owner["avatar"];
2393                 $item["owner-id"] = Contact::getIdForURL($owner["link"], 0);
2394
2395                 // fetch the author
2396                 $author = self::fetchauthor($xpath, $entry, $importer, "atom:author", true, $xml);
2397
2398                 $item["author-name"] = $author["name"];
2399                 $item["author-link"] = $author["link"];
2400                 $item["author-avatar"] = $author["avatar"];
2401                 $item["author-id"] = Contact::getIdForURL($author["link"], 0);
2402
2403                 $item["title"] = XML::getFirstNodeValue($xpath, "atom:title/text()", $entry);
2404
2405                 $item["created"] = XML::getFirstNodeValue($xpath, "atom:published/text()", $entry);
2406
2407                 $item["body"] = XML::getFirstNodeValue($xpath, "dfrn:env/text()", $entry);
2408                 $item["body"] = str_replace([' ',"\t","\r","\n"], ['','','',''], $item["body"]);
2409                 // make sure nobody is trying to sneak some html tags by us
2410                 $item["body"] = Strings::escapeTags(Strings::base64UrlDecode($item["body"]));
2411
2412                 $item["body"] = BBCode::limitBodySize($item["body"]);
2413
2414                 /// @todo Do we really need this check for HTML elements? (It was copied from the old function)
2415                 if ((strpos($item['body'], '<') !== false) && (strpos($item['body'], '>') !== false)) {
2416                         $base_url = \get_app()->getBaseURL();
2417                         $item['body'] = HTML::relToAbs($item['body'], $base_url);
2418
2419                         $item['body'] = HTML::toBBCodeVideo($item['body']);
2420
2421                         $item['body'] = OEmbed::HTML2BBCode($item['body']);
2422
2423                         $config = HTMLPurifier_Config::createDefault();
2424                         $config->set('Cache.DefinitionImpl', null);
2425
2426                         // we shouldn't need a whitelist, because the bbcode converter
2427                         // will strip out any unsupported tags.
2428
2429                         $purifier = new HTMLPurifier($config);
2430                         $item['body'] = $purifier->purify($item['body']);
2431
2432                         $item['body'] = @HTML::toBBCode($item['body']);
2433                 }
2434
2435                 /// @todo We should check for a repeated post and if we know the repeated author.
2436
2437                 // We don't need the content element since "dfrn:env" is always present
2438                 //$item["body"] = $xpath->query("atom:content/text()", $entry)->item(0)->nodeValue;
2439
2440                 $item["location"] = XML::getFirstNodeValue($xpath, "dfrn:location/text()", $entry);
2441
2442                 $item["coord"] = XML::getFirstNodeValue($xpath, "georss:point", $entry);
2443
2444                 $item["private"] = XML::getFirstNodeValue($xpath, "dfrn:private/text()", $entry);
2445
2446                 $item["extid"] = XML::getFirstNodeValue($xpath, "dfrn:extid/text()", $entry);
2447
2448                 if (XML::getFirstNodeValue($xpath, "dfrn:bookmark/text()", $entry) == "true") {
2449                         $item["post-type"] = Item::PT_PAGE;
2450                 }
2451
2452                 $notice_info = $xpath->query("statusnet:notice_info", $entry);
2453                 if ($notice_info && ($notice_info->length > 0)) {
2454                         foreach ($notice_info->item(0)->attributes as $attributes) {
2455                                 if ($attributes->name == "source") {
2456                                         $item["app"] = strip_tags($attributes->textContent);
2457                                 }
2458                         }
2459                 }
2460
2461                 $item["guid"] = XML::getFirstNodeValue($xpath, "dfrn:diaspora_guid/text()", $entry);
2462
2463                 // We store the data from "dfrn:diaspora_signature" in a different table, this is done in "Item::insert"
2464                 $dsprsig = XML::unescape(XML::getFirstNodeValue($xpath, "dfrn:diaspora_signature/text()", $entry));
2465                 if ($dsprsig != "") {
2466                         $item["dsprsig"] = $dsprsig;
2467                 }
2468
2469                 $item["verb"] = XML::getFirstNodeValue($xpath, "activity:verb/text()", $entry);
2470
2471                 if (XML::getFirstNodeValue($xpath, "activity:object-type/text()", $entry) != "") {
2472                         $item["object-type"] = XML::getFirstNodeValue($xpath, "activity:object-type/text()", $entry);
2473                 }
2474
2475                 $object = $xpath->query("activity:object", $entry)->item(0);
2476                 $item["object"] = self::transformActivity($xpath, $object, "object");
2477
2478                 if (trim($item["object"]) != "") {
2479                         $r = XML::parseString($item["object"], false);
2480                         if (isset($r->type)) {
2481                                 $item["object-type"] = $r->type;
2482                         }
2483                 }
2484
2485                 $target = $xpath->query("activity:target", $entry)->item(0);
2486                 $item["target"] = self::transformActivity($xpath, $target, "target");
2487
2488                 $categories = $xpath->query("atom:category", $entry);
2489                 if ($categories) {
2490                         foreach ($categories as $category) {
2491                                 $term = "";
2492                                 $scheme = "";
2493                                 foreach ($category->attributes as $attributes) {
2494                                         if ($attributes->name == "term") {
2495                                                 $term = $attributes->textContent;
2496                                         }
2497
2498                                         if ($attributes->name == "scheme") {
2499                                                 $scheme = $attributes->textContent;
2500                                         }
2501                                 }
2502
2503                                 if (($term != "") && ($scheme != "")) {
2504                                         $parts = explode(":", $scheme);
2505                                         if ((count($parts) >= 4) && (array_shift($parts) == "X-DFRN")) {
2506                                                 $termhash = array_shift($parts);
2507                                                 $termurl = implode(":", $parts);
2508
2509                                                 if (!empty($item["tag"])) {
2510                                                         $item["tag"] .= ",";
2511                                                 } else {
2512                                                         $item["tag"] = "";
2513                                                 }
2514
2515                                                 $item["tag"] .= $termhash . "[url=" . $termurl . "]" . $term . "[/url]";
2516                                         }
2517                                 }
2518                         }
2519                 }
2520
2521                 $links = $xpath->query("atom:link", $entry);
2522                 if ($links) {
2523                         self::parseLinks($links, $item);
2524                 }
2525
2526                 $item['conversation-uri'] = XML::getFirstNodeValue($xpath, 'ostatus:conversation/text()', $entry);
2527
2528                 $conv = $xpath->query('ostatus:conversation', $entry);
2529                 if (is_object($conv->item(0))) {
2530                         foreach ($conv->item(0)->attributes as $attributes) {
2531                                 if ($attributes->name == "ref") {
2532                                         $item['conversation-uri'] = $attributes->textContent;
2533                                 }
2534                                 if ($attributes->name == "href") {
2535                                         $item['conversation-href'] = $attributes->textContent;
2536                                 }
2537                         }
2538                 }
2539
2540                 // Is it a reply or a top level posting?
2541                 $item["parent-uri"] = $item["uri"];
2542
2543                 $inreplyto = $xpath->query("thr:in-reply-to", $entry);
2544                 if (is_object($inreplyto->item(0))) {
2545                         foreach ($inreplyto->item(0)->attributes as $attributes) {
2546                                 if ($attributes->name == "ref") {
2547                                         $item["parent-uri"] = $attributes->textContent;
2548                                 }
2549                         }
2550                 }
2551
2552                 // Get the type of the item (Top level post, reply or remote reply)
2553                 $entrytype = self::getEntryType($importer, $item);
2554
2555                 // Now assign the rest of the values that depend on the type of the message
2556                 if (in_array($entrytype, [DFRN::REPLY, DFRN::REPLY_RC])) {
2557                         if (!isset($item["object-type"])) {
2558                                 $item["object-type"] = ACTIVITY_OBJ_COMMENT;
2559                         }
2560
2561                         if ($item["contact-id"] != $owner["contact-id"]) {
2562                                 $item["contact-id"] = $owner["contact-id"];
2563                         }
2564
2565                         if (($item["network"] != $owner["network"]) && ($owner["network"] != "")) {
2566                                 $item["network"] = $owner["network"];
2567                         }
2568
2569                         if ($item["contact-id"] != $author["contact-id"]) {
2570                                 $item["contact-id"] = $author["contact-id"];
2571                         }
2572
2573                         if (($item["network"] != $author["network"]) && ($author["network"] != "")) {
2574                                 $item["network"] = $author["network"];
2575                         }
2576                 }
2577
2578                 if ($entrytype == DFRN::REPLY_RC) {
2579                         $item["wall"] = 1;
2580                 } elseif ($entrytype == DFRN::TOP_LEVEL) {
2581                         if (!isset($item["object-type"])) {
2582                                 $item["object-type"] = ACTIVITY_OBJ_NOTE;
2583                         }
2584
2585                         // Is it an event?
2586                         if (($item["object-type"] == ACTIVITY_OBJ_EVENT) && !$owner_unknown) {
2587                                 Logger::log("Item ".$item["uri"]." seems to contain an event.", Logger::DEBUG);
2588                                 $ev = Event::fromBBCode($item["body"]);
2589                                 if ((!empty($ev['desc']) || !empty($ev['summary'])) && !empty($ev['start'])) {
2590                                         Logger::log("Event in item ".$item["uri"]." was found.", Logger::DEBUG);
2591                                         $ev["cid"]     = $importer["id"];
2592                                         $ev["uid"]     = $importer["importer_uid"];
2593                                         $ev["uri"]     = $item["uri"];
2594                                         $ev["edited"]  = $item["edited"];
2595                                         $ev["private"] = $item["private"];
2596                                         $ev["guid"]    = $item["guid"];
2597                                         $ev["plink"]   = $item["plink"];
2598
2599                                         $condition = ['uri' => $item["uri"], 'uid' => $importer["importer_uid"]];
2600                                         $event = DBA::selectFirst('event', ['id'], $condition);
2601                                         if (DBA::isResult($event)) {
2602                                                 $ev["id"] = $event["id"];
2603                                         }
2604
2605                                         $event_id = Event::store($ev);
2606                                         Logger::log("Event ".$event_id." was stored", Logger::DEBUG);
2607                                         return;
2608                                 }
2609                         }
2610                 }
2611
2612                 if (!self::processVerbs($entrytype, $importer, $item, $is_like)) {
2613                         Logger::log("Exiting because 'processVerbs' told us so", Logger::DEBUG);
2614                         return;
2615                 }
2616
2617                 // This check is done here to be able to receive connection requests in "processVerbs"
2618                 if (($entrytype == DFRN::TOP_LEVEL) && $owner_unknown) {
2619                         Logger::log("Item won't be stored because user " . $importer["importer_uid"] . " doesn't follow " . $item["owner-link"] . ".", Logger::DEBUG);
2620                         return;
2621                 }
2622
2623
2624                 // Update content if 'updated' changes
2625                 if (DBA::isResult($current)) {
2626                         if (self::updateContent($current, $item, $importer, $entrytype)) {
2627                                 Logger::log("Item ".$item["uri"]." was updated.", Logger::DEBUG);
2628                         } else {
2629                                 Logger::log("Item " . $item["uri"] . " already existed.", Logger::DEBUG);
2630                         }
2631                         return;
2632                 }
2633
2634                 if (in_array($entrytype, [DFRN::REPLY, DFRN::REPLY_RC])) {
2635                         $posted_id = Item::insert($item);
2636                         if ($posted_id) {
2637                                 Logger::log("Reply from contact ".$item["contact-id"]." was stored with id ".$posted_id, Logger::DEBUG);
2638
2639                                 if ($item['uid'] == 0) {
2640                                         Item::distribute($posted_id);
2641                                 }
2642
2643                                 return true;
2644                         }
2645                 } else { // $entrytype == DFRN::TOP_LEVEL
2646                         if (($importer["uid"] == 0) && ($importer["importer_uid"] != 0)) {
2647                                 Logger::log("Contact ".$importer["id"]." isn't known to user ".$importer["importer_uid"].". The post will be ignored.", Logger::DEBUG);
2648                                 return;
2649                         }
2650                         if (!Strings::compareLink($item["owner-link"], $importer["url"])) {
2651                                 /*
2652                                  * The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
2653                                  * but otherwise there's a possible data mixup on the sender's system.
2654                                  * the tgroup delivery code called from Item::insert will correct it if it's a forum,
2655                                  * but we're going to unconditionally correct it here so that the post will always be owned by our contact.
2656                                  */
2657                                 Logger::log('Correcting item owner.', Logger::DEBUG);
2658                                 $item["owner-link"] = $importer["url"];
2659                                 $item["owner-id"] = Contact::getIdForURL($importer["url"], 0);
2660                         }
2661
2662                         if (($importer["rel"] == Contact::FOLLOWER) && (!self::tgroupCheck($importer["importer_uid"], $item))) {
2663                                 Logger::log("Contact ".$importer["id"]." is only follower and tgroup check was negative.", Logger::DEBUG);
2664                                 return;
2665                         }
2666
2667                         // This is my contact on another system, but it's really me.
2668                         // Turn this into a wall post.
2669                         $notify = Item::isRemoteSelf($importer, $item);
2670
2671                         $posted_id = Item::insert($item, false, $notify);
2672
2673                         if ($notify) {
2674                                 $posted_id = $notify;
2675                         }
2676
2677                         Logger::log("Item was stored with id ".$posted_id, Logger::DEBUG);
2678
2679                         if ($item['uid'] == 0) {
2680                                 Item::distribute($posted_id);
2681                         }
2682
2683                         if (stristr($item["verb"], ACTIVITY_POKE)) {
2684                                 $item['id'] = $posted_id;
2685                                 self::doPoke($item, $importer);
2686                         }
2687                 }
2688         }
2689
2690         /**
2691          * @brief Deletes items
2692          *
2693          * @param object $xpath    XPath object
2694          * @param object $deletion deletion elements
2695          * @param array  $importer Record of the importer user mixed with contact of the content
2696          * @return void
2697          * @throws \Exception
2698          * @todo  set proper type-hints
2699          */
2700         private static function processDeletion($xpath, $deletion, $importer)
2701         {
2702                 Logger::log("Processing deletions");
2703                 $uri = null;
2704
2705                 foreach ($deletion->attributes as $attributes) {
2706                         if ($attributes->name == "ref") {
2707                                 $uri = $attributes->textContent;
2708                         }
2709                 }
2710
2711                 if (!$uri || !$importer["id"]) {
2712                         return false;
2713                 }
2714
2715                 $condition = ['uri' => $uri, 'uid' => $importer["importer_uid"]];
2716                 $item = Item::selectFirst(['id', 'parent', 'contact-id', 'file', 'deleted'], $condition);
2717                 if (!DBA::isResult($item)) {
2718                         Logger::log("Item with uri " . $uri . " for user " . $importer["importer_uid"] . " wasn't found.", Logger::DEBUG);
2719                         return;
2720                 }
2721
2722                 if (strstr($item['file'], '[')) {
2723                         Logger::log("Item with uri " . $uri . " for user " . $importer["importer_uid"] . " is filed. So it won't be deleted.", Logger::DEBUG);
2724                         return;
2725                 }
2726
2727                 // When it is a starting post it has to belong to the person that wants to delete it
2728                 if (($item['id'] == $item['parent']) && ($item['contact-id'] != $importer["id"])) {
2729                         Logger::log("Item with uri " . $uri . " don't belong to contact " . $importer["id"] . " - ignoring deletion.", Logger::DEBUG);
2730                         return;
2731                 }
2732
2733                 // Comments can be deleted by the thread owner or comment owner
2734                 if (($item['id'] != $item['parent']) && ($item['contact-id'] != $importer["id"])) {
2735                         $condition = ['id' => $item['parent'], 'contact-id' => $importer["id"]];
2736                         if (!Item::exists($condition)) {
2737                                 Logger::log("Item with uri " . $uri . " wasn't found or mustn't be deleted by contact " . $importer["id"] . " - ignoring deletion.", Logger::DEBUG);
2738                                 return;
2739                         }
2740                 }
2741
2742                 if ($item["deleted"]) {
2743                         return;
2744                 }
2745
2746                 Logger::log('deleting item '.$item['id'].' uri='.$uri, Logger::DEBUG);
2747
2748                 Item::delete(['id' => $item['id']]);
2749         }
2750
2751         /**
2752          * @brief Imports a DFRN message
2753          *
2754          * @param string $xml          The DFRN message
2755          * @param array  $importer     Record of the importer user mixed with contact of the content
2756          * @param bool   $sort_by_date Is used when feeds are polled
2757          * @return integer Import status
2758          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
2759          * @throws \ImagickException
2760          * @todo  set proper type-hints
2761          */
2762         public static function import($xml, $importer, $sort_by_date = false)
2763         {
2764                 if ($xml == "") {
2765                         return 400;
2766                 }
2767
2768                 $doc = new DOMDocument();
2769                 @$doc->loadXML($xml);
2770
2771                 $xpath = new DOMXPath($doc);
2772                 $xpath->registerNamespace("atom", NAMESPACE_ATOM1);
2773                 $xpath->registerNamespace("thr", NAMESPACE_THREAD);
2774                 $xpath->registerNamespace("at", NAMESPACE_TOMB);
2775                 $xpath->registerNamespace("media", NAMESPACE_MEDIA);
2776                 $xpath->registerNamespace("dfrn", NAMESPACE_DFRN);
2777                 $xpath->registerNamespace("activity", NAMESPACE_ACTIVITY);
2778                 $xpath->registerNamespace("georss", NAMESPACE_GEORSS);
2779                 $xpath->registerNamespace("poco", NAMESPACE_POCO);
2780                 $xpath->registerNamespace("ostatus", NAMESPACE_OSTATUS);
2781                 $xpath->registerNamespace("statusnet", NAMESPACE_STATUSNET);
2782
2783                 $header = [];
2784                 $header["uid"] = $importer["importer_uid"];
2785                 $header["network"] = Protocol::DFRN;
2786                 $header["wall"] = 0;
2787                 $header["origin"] = 0;
2788                 $header["contact-id"] = $importer["id"];
2789
2790                 // Update the contact table if the data has changed
2791
2792                 // The "atom:author" is only present in feeds
2793                 if ($xpath->query("/atom:feed/atom:author")->length > 0) {
2794                         self::fetchauthor($xpath, $doc->firstChild, $importer, "atom:author", false, $xml);
2795                 }
2796
2797                 // Only the "dfrn:owner" in the head section contains all data
2798                 if ($xpath->query("/atom:feed/dfrn:owner")->length > 0) {
2799                         self::fetchauthor($xpath, $doc->firstChild, $importer, "dfrn:owner", false, $xml);
2800                 }
2801
2802                 Logger::log("Import DFRN message for user " . $importer["importer_uid"] . " from contact " . $importer["id"], Logger::DEBUG);
2803
2804                 // is it a public forum? Private forums aren't exposed with this method
2805                 $forum = intval(XML::getFirstNodeValue($xpath, "/atom:feed/dfrn:community/text()"));
2806
2807                 // The account type is new since 3.5.1
2808                 if ($xpath->query("/atom:feed/dfrn:account_type")->length > 0) {
2809                         // Hint: We are using separate update calls for uid=0 and uid!=0 since a combined call is bad for the database performance
2810
2811                         $accounttype = intval(XML::getFirstNodeValue($xpath, "/atom:feed/dfrn:account_type/text()"));
2812
2813                         if ($accounttype != $importer["contact-type"]) {
2814                                 DBA::update('contact', ['contact-type' => $accounttype], ['id' => $importer['id']]);
2815
2816                                 // Updating the public contact as well
2817                                 DBA::update('contact', ['contact-type' => $accounttype], ['uid' => 0, 'nurl' => $importer['nurl']]);
2818                         }
2819                         // A forum contact can either have set "forum" or "prv" - but not both
2820                         if ($accounttype == User::ACCOUNT_TYPE_COMMUNITY) {
2821                                 // It's a forum, so either set the public or private forum flag
2822                                 $condition = ['(`forum` != ? OR `prv` != ?) AND `id` = ?', $forum, !$forum, $importer['id']];
2823                                 DBA::update('contact', ['forum' => $forum, 'prv' => !$forum], $condition);
2824
2825                                 // Updating the public contact as well
2826                                 $condition = ['(`forum` != ? OR `prv` != ?) AND `uid` = 0 AND `nurl` = ?', $forum, !$forum, $importer['nurl']];
2827                                 DBA::update('contact', ['forum' => $forum, 'prv' => !$forum], $condition);
2828                         } else {
2829                                 // It's not a forum, so remove the flags
2830                                 $condition = ['(`forum` OR `prv`) AND `id` = ?', $importer['id']];
2831                                 DBA::update('contact', ['forum' => false, 'prv' => false], $condition);
2832
2833                                 // Updating the public contact as well
2834                                 $condition = ['(`forum` OR `prv`) AND `uid` = 0 AND `nurl` = ?', $importer['nurl']];
2835                                 DBA::update('contact', ['forum' => false, 'prv' => false], $condition);
2836                         }
2837                 } elseif ($forum != $importer["forum"]) { // Deprecated since 3.5.1
2838                         $condition = ['`forum` != ? AND `id` = ?', $forum, $importer["id"]];
2839                         DBA::update('contact', ['forum' => $forum], $condition);
2840
2841                         // Updating the public contact as well
2842                         $condition = ['`forum` != ? AND `uid` = 0 AND `nurl` = ?', $forum, $importer['nurl']];
2843                         DBA::update('contact', ['forum' => $forum], $condition);
2844                 }
2845
2846
2847                 // We are processing relocations even if we are ignoring a contact
2848                 $relocations = $xpath->query("/atom:feed/dfrn:relocate");
2849                 foreach ($relocations as $relocation) {
2850                         self::processRelocation($xpath, $relocation, $importer);
2851                 }
2852
2853                 if (($importer["uid"] != 0) && !$importer["readonly"]) {
2854                         $mails = $xpath->query("/atom:feed/dfrn:mail");
2855                         foreach ($mails as $mail) {
2856                                 self::processMail($xpath, $mail, $importer);
2857                         }
2858
2859                         $suggestions = $xpath->query("/atom:feed/dfrn:suggest");
2860                         foreach ($suggestions as $suggestion) {
2861                                 self::processSuggestion($xpath, $suggestion, $importer);
2862                         }
2863                 }
2864
2865                 $deletions = $xpath->query("/atom:feed/at:deleted-entry");
2866                 foreach ($deletions as $deletion) {
2867                         self::processDeletion($xpath, $deletion, $importer);
2868                 }
2869
2870                 if (!$sort_by_date) {
2871                         $entries = $xpath->query("/atom:feed/atom:entry");
2872                         foreach ($entries as $entry) {
2873                                 self::processEntry($header, $xpath, $entry, $importer, $xml);
2874                         }
2875                 } else {
2876                         $newentries = [];
2877                         $entries = $xpath->query("/atom:feed/atom:entry");
2878                         foreach ($entries as $entry) {
2879                                 $created = XML::getFirstNodeValue($xpath, "atom:published/text()", $entry);
2880                                 $newentries[strtotime($created)] = $entry;
2881                         }
2882
2883                         // Now sort after the publishing date
2884                         ksort($newentries);
2885
2886                         foreach ($newentries as $entry) {
2887                                 self::processEntry($header, $xpath, $entry, $importer, $xml);
2888                         }
2889                 }
2890                 Logger::log("Import done for user " . $importer["importer_uid"] . " from contact " . $importer["id"], Logger::DEBUG);
2891                 return 200;
2892         }
2893
2894         /**
2895          * @param App    $a            App
2896          * @param string $contact_nick contact nickname
2897          * @throws \Friendica\Network\HTTPException\InternalServerErrorException
2898          */
2899         public static function autoRedir(App $a, $contact_nick)
2900         {
2901                 // prevent looping
2902                 if (!empty($_REQUEST['redir'])) {
2903                         return;
2904                 }
2905
2906                 if ((! $contact_nick) || ($contact_nick === $a->user['nickname'])) {
2907                         return;
2908                 }
2909
2910                 if (local_user()) {
2911                         // We need to find out if $contact_nick is a user on this hub, and if so, if I
2912                         // am a contact of that user. However, that user may have other contacts with the
2913                         // same nickname as me on other hubs or other networks. Exclude these by requiring
2914                         // that the contact have a local URL. I will be the only person with my nickname at
2915                         // this URL, so if a result is found, then I am a contact of the $contact_nick user.
2916                         //
2917                         // We also have to make sure that I'm a legitimate contact--I'm not blocked or pending.
2918
2919                         $baseurl = System::baseUrl();
2920                         $domain_st = strpos($baseurl, "://");
2921                         if ($domain_st === false) {
2922                                 return;
2923                         }
2924                         $baseurl = substr($baseurl, $domain_st + 3);
2925                         $nurl = Strings::normaliseLink($baseurl);
2926
2927                         /// @todo Why is there a query for "url" *and* "nurl"? Especially this normalising is strange.
2928                         $r = q("SELECT `id` FROM `contact` WHERE `uid` = (SELECT `uid` FROM `user` WHERE `nickname` = '%s' LIMIT 1)
2929                                         AND `nick` = '%s' AND NOT `self` AND (`url` LIKE '%%%s%%' OR `nurl` LIKE '%%%s%%') AND NOT `blocked` AND NOT `pending` LIMIT 1",
2930                                 DBA::escape($contact_nick),
2931                                 DBA::escape($a->user['nickname']),
2932                                 DBA::escape($baseurl),
2933                                 DBA::escape($nurl)
2934                         );
2935                         if ((! DBA::isResult($r)) || $r[0]['id'] == remote_user()) {
2936                                 return;
2937                         }
2938
2939                         $r = q("SELECT * FROM contact WHERE nick = '%s'
2940                                         AND network = '%s' AND uid = %d  AND url LIKE '%%%s%%' LIMIT 1",
2941                                 DBA::escape($contact_nick),
2942                                 DBA::escape(Protocol::DFRN),
2943                                 intval(local_user()),
2944                                 DBA::escape($baseurl)
2945                         );
2946                         if (! DBA::isResult($r)) {
2947                                 return;
2948                         }
2949
2950                         $cid = $r[0]['id'];
2951
2952                         $dfrn_id = (($r[0]['issued-id']) ? $r[0]['issued-id'] : $r[0]['dfrn-id']);
2953
2954                         if ($r[0]['duplex'] && $r[0]['issued-id']) {
2955                                 $orig_id = $r[0]['issued-id'];
2956                                 $dfrn_id = '1:' . $orig_id;
2957                         }
2958                         if ($r[0]['duplex'] && $r[0]['dfrn-id']) {
2959                                 $orig_id = $r[0]['dfrn-id'];
2960                                 $dfrn_id = '0:' . $orig_id;
2961                         }
2962
2963                         // ensure that we've got a valid ID. There may be some edge cases with forums and non-duplex mode
2964                         // that may have triggered some of the "went to {profile/intro} and got an RSS feed" issues
2965
2966                         if (strlen($dfrn_id) < 3) {
2967                                 return;
2968                         }
2969
2970                         $sec = Strings::getRandomHex();
2971
2972                         DBA::insert('profile_check', ['uid' => local_user(), 'cid' => $cid, 'dfrn_id' => $dfrn_id, 'sec' => $sec, 'expire' => time() + 45]);
2973
2974                         $url = curPageURL();
2975
2976                         Logger::log('auto_redir: ' . $r[0]['name'] . ' ' . $sec, Logger::DEBUG);
2977                         $dest = (($url) ? '&destination_url=' . $url : '');
2978                         System::externalRedirect($r[0]['poll'] . '?dfrn_id=' . $dfrn_id
2979                                 . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . '&type=profile&sec=' . $sec . $dest);
2980                 }
2981
2982                 return;
2983         }
2984
2985         /**
2986          * @brief Returns the activity verb
2987          *
2988          * @param array $item Item array
2989          *
2990          * @return string activity verb
2991          */
2992         private static function constructVerb(array $item)
2993         {
2994                 if ($item['verb']) {
2995                         return $item['verb'];
2996                 }
2997                 return ACTIVITY_POST;
2998         }
2999
3000         private static function tgroupCheck($uid, $item)
3001         {
3002                 $mention = false;
3003
3004                 // check that the message originated elsewhere and is a top-level post
3005
3006                 if ($item['wall'] || $item['origin'] || ($item['uri'] != $item['parent-uri'])) {
3007                         return false;
3008                 }
3009
3010                 $user = DBA::selectFirst('user', ['page-flags', 'nickname'], ['uid' => $uid]);
3011                 if (!DBA::isResult($user)) {
3012                         return false;
3013                 }
3014
3015                 $community_page = ($user['page-flags'] == User::PAGE_FLAGS_COMMUNITY);
3016                 $prvgroup = ($user['page-flags'] == User::PAGE_FLAGS_PRVGROUP);
3017
3018                 $link = Strings::normaliseLink(System::baseUrl() . '/profile/' . $user['nickname']);
3019
3020                 /*
3021                  * Diaspora uses their own hardwired link URL in @-tags
3022                  * instead of the one we supply with webfinger
3023                  */
3024                 $dlink = Strings::normaliseLink(System::baseUrl() . '/u/' . $user['nickname']);
3025
3026                 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism', $item['body'], $matches, PREG_SET_ORDER);
3027                 if ($cnt) {
3028                         foreach ($matches as $mtch) {
3029                                 if (Strings::compareLink($link, $mtch[1]) || Strings::compareLink($dlink, $mtch[1])) {
3030                                         $mention = true;
3031                                         Logger::log('mention found: ' . $mtch[2]);
3032                                 }
3033                         }
3034                 }
3035
3036                 if (!$mention) {
3037                         return false;
3038                 }
3039
3040                 return $community_page || $prvgroup;
3041         }
3042
3043         /**
3044          * This function returns true if $update has an edited timestamp newer
3045          * than $existing, i.e. $update contains new data which should override
3046          * what's already there.  If there is no timestamp yet, the update is
3047          * assumed to be newer.  If the update has no timestamp, the existing
3048          * item is assumed to be up-to-date.  If the timestamps are equal it
3049          * assumes the update has been seen before and should be ignored.
3050          *
3051          * @param $existing
3052          * @param $update
3053          * @return bool
3054          * @throws \Exception
3055          */
3056         private static function isEditedTimestampNewer($existing, $update)
3057         {
3058                 if (empty($existing['edited'])) {
3059                         return true;
3060                 }
3061                 if (empty($update['edited'])) {
3062                         return false;
3063                 }
3064
3065                 $existing_edited = DateTimeFormat::utc($existing['edited']);
3066                 $update_edited = DateTimeFormat::utc($update['edited']);
3067
3068                 return (strcmp($existing_edited, $update_edited) < 0);
3069         }
3070 }