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