include/ostatus.php

   1 <?php
   2 /**
   3  * @file include/ostatus.php
   4  */
   5
   6 require_once("include/Contact.php");
   7 require_once("include/threads.php");
   8 require_once("include/html2bbcode.php");
   9 require_once("include/bbcode.php");
  10 require_once("include/items.php");
  11 require_once("mod/share.php");
  12 require_once("include/enotify.php");
  13 require_once("include/socgraph.php");
  14 require_once("include/Photo.php");
  15 require_once("include/Scrape.php");
  16 require_once("include/follow.php");
  17 require_once("include/api.php");
  18 require_once("mod/proxy.php");
  19 require_once("include/xml.php");
  20
  21 /**
  22  * @brief This class contain functions for the OStatus protocol
  23  *
  24  */
  25 class ostatus {
  26         const OSTATUS_DEFAULT_POLL_INTERVAL = 30; // given in minutes
  27         const OSTATUS_DEFAULT_POLL_TIMEFRAME = 1440; // given in minutes
  28         const OSTATUS_DEFAULT_POLL_TIMEFRAME_MENTIONS = 14400; // given in minutes
  29
  30         /**
  31          * @brief Fetches author data
  32          *
  33          * @param object $xpath The xpath object
  34          * @param object $context The xml context of the author detals
  35          * @param array $importer user record of the importing user
  36          * @param array $contact Called by reference, will contain the fetched contact
  37          * @param bool $onlyfetch Only fetch the header without updating the contact entries
  38          *
  39          * @return array Array of author related entries for the item
  40          * @todo Add type-hints
  41          */
  42         private function fetchauthor($xpath, $context, $importer, &$contact, $onlyfetch) {
  43
  44                 /// @TODO One statment is enough ...
  45                 $author = array();
  46                 $author["author-link"] = $xpath->evaluate('atom:author/atom:uri/text()', $context)->item(0)->nodeValue;
  47                 $author["author-name"] = $xpath->evaluate('atom:author/atom:name/text()', $context)->item(0)->nodeValue;
  48
  49                 $aliaslink = $author["author-link"];
  50
  51                 $alternate = $xpath->query("atom:author/atom:link[@rel='alternate']", $context)->item(0)->attributes;
  52                 if (is_object($alternate)) {
  53                         /// @TODO foreach() may only later work on objects that have iterator interface implemented, please check this
  54                         foreach ($alternate AS $attributes) {
  55                                 if ($attributes->name == "href") {
  56                                         $author["author-link"] = $attributes->textContent;
  57                                 }
  58                         }
  59                 }
  60
  61                 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `nurl` IN ('%s', '%s') AND `network` != '%s'",
  62                         intval($importer["uid"]), dbesc(normalise_link($author["author-link"])),
  63                         dbesc(normalise_link($aliaslink)), dbesc(NETWORK_STATUSNET));
  64                 if (dbm::is_result($r)) {
  65                         $contact = $r[0];
  66                         $author["contact-id"] = $r[0]["id"];
  67                 } else {
  68                         $author["contact-id"] = $contact["id"];
  69                 }
  70
  71                 $avatarlist = array();
  72                 $avatars = $xpath->query("atom:author/atom:link[@rel='avatar']", $context);
  73                 foreach ($avatars AS $avatar) {
  74                         $href = "";
  75                         $width = 0;
  76                         foreach ($avatar->attributes AS $attributes) {
  77                                 if ($attributes->name == "href") {
  78                                         $href = $attributes->textContent;
  79                                 }
  80                                 if ($attributes->name == "width") {
  81                                         $width = $attributes->textContent;
  82                                 }
  83                         }
  84                         if (($width > 0) AND ($href != "")) {
  85                                 $avatarlist[$width] = $href;
  86                         }
  87                 }
  88                 if (count($avatarlist) > 0) {
  89                         krsort($avatarlist);
  90                         $author["author-avatar"] = current($avatarlist);
  91                 }
  92
  93                 $displayname = $xpath->evaluate('atom:author/poco:displayName/text()', $context)->item(0)->nodeValue;
  94                 if ($displayname != "") {
  95                         $author["author-name"] = $displayname;
  96                 }
  97
  98                 $author["owner-name"] = $author["author-name"];
  99                 $author["owner-link"] = $author["author-link"];
 100                 $author["owner-avatar"] = $author["author-avatar"];
 101
 102                 // Only update the contacts if it is an OStatus contact
 103                 if (dbm::is_result($r) AND !$onlyfetch AND ($contact["network"] == NETWORK_OSTATUS)) {
 104
 105                         // Update contact data
 106
 107                         // This query doesn't seem to work
 108                         // $value = $xpath->query("atom:link[@rel='salmon']", $context)->item(0)->nodeValue;
 109                         // if ($value != "")
 110                         //      $contact["notify"] = $value;
 111
 112                         // This query doesn't seem to work as well - I hate these queries
 113                         // $value = $xpath->query("atom:link[@rel='self' and @type='application/atom+xml']", $context)->item(0)->nodeValue;
 114                         // if ($value != "")
 115                         //      $contact["poll"] = $value;
 116
 117                         $value = $xpath->evaluate('atom:author/atom:uri/text()', $context)->item(0)->nodeValue;
 118                         if ($value != "") {
 119                                 $contact["alias"] = $value;
 120                         }
 121
 122                         $value = $xpath->evaluate('atom:author/poco:displayName/text()', $context)->item(0)->nodeValue;
 123                         if ($value != "") {
 124                                 $contact["name"] = $value;
 125                         }
 126
 127                         $value = $xpath->evaluate('atom:author/poco:preferredUsername/text()', $context)->item(0)->nodeValue;
 128                         if ($value != "") {
 129                                 $contact["nick"] = $value;
 130                         }
 131
 132                         $value = $xpath->evaluate('atom:author/poco:note/text()', $context)->item(0)->nodeValue;
 133                         if ($value != "") {
 134                                 $contact["about"] = html2bbcode($value);
 135                         }
 136
 137                         $value = $xpath->evaluate('atom:author/poco:address/poco:formatted/text()', $context)->item(0)->nodeValue;
 138                         if ($value != "") {
 139                                 $contact["location"] = $value;
 140                         }
 141
 142                         if (($contact["name"] != $r[0]["name"]) OR ($contact["nick"] != $r[0]["nick"]) OR ($contact["about"] != $r[0]["about"]) OR
 143                                 ($contact["alias"] != $r[0]["alias"]) OR ($contact["location"] != $r[0]["location"])) {
 144
 145                                 logger("Update contact data for contact ".$contact["id"], LOGGER_DEBUG);
 146
 147                                 q("UPDATE `contact` SET `name` = '%s', `nick` = '%s', `alias` = '%s', `about` = '%s', `location` = '%s', `name-date` = '%s' WHERE `id` = %d",
 148                                         dbesc($contact["name"]), dbesc($contact["nick"]), dbesc($contact["alias"]),
 149                                         dbesc($contact["about"]), dbesc($contact["location"]),
 150                                         dbesc(datetime_convert()), intval($contact["id"]));
 151
 152                                 poco_check($contact["url"], $contact["name"], $contact["network"], $author["author-avatar"], $contact["about"], $contact["location"],
 153                                                         "", "", "", datetime_convert(), 2, $contact["id"], $contact["uid"]);
 154                         }
 155
 156                         if (isset($author["author-avatar"]) AND ($author["author-avatar"] != $r[0]['avatar'])) {
 157                                 logger("Update profile picture for contact ".$contact["id"], LOGGER_DEBUG);
 158
 159                                 update_contact_avatar($author["author-avatar"], $importer["uid"], $contact["id"]);
 160                         }
 161
 162                         // Ensure that we are having this contact (with uid=0)
 163                         $cid = get_contact($author["author-link"], 0);
 164
 165                         if ($cid) {
 166                                 // Update it with the current values
 167                                 q("UPDATE `contact` SET `url` = '%s', `name` = '%s', `nick` = '%s', `alias` = '%s',
 168                                                 `about` = '%s', `location` = '%s',
 169                                                 `success_update` = '%s', `last-update` = '%s'
 170                                         WHERE `id` = %d",
 171                                         dbesc($author["author-link"]), dbesc($contact["name"]), dbesc($contact["nick"]),
 172                                         dbesc($contact["alias"]), dbesc($contact["about"]), dbesc($contact["location"]),
 173                                         dbesc(datetime_convert()), dbesc(datetime_convert()), intval($cid));
 174
 175                                 // Update the avatar
 176                                 update_contact_avatar($author["author-avatar"], 0, $cid);
 177                         }
 178
 179                         $contact["generation"] = 2;
 180                         $contact["hide"] = false; // OStatus contacts are never hidden
 181                         $contact["photo"] = $author["author-avatar"];
 182                         update_gcontact($contact);
 183                 }
 184
 185                 return($author);
 186         }
 187
 188         /**
 189          * @brief Fetches author data from a given XML string
 190          *
 191          * @param string $xml The XML
 192          * @param array $importer user record of the importing user
 193          *
 194          * @return array Array of author related entries for the item
 195          * @todo add type-hints
 196          */
 197         public static function salmon_author($xml, $importer) {
 198
 199                 if ($xml == "") {
 200                         return;
 201                 }
 202
 203                 $doc = new DOMDocument();
 204                 $doc->loadXML($xml);
 205
 206                 $xpath = new DomXPath($doc);
 207                 $xpath->registerNamespace('atom', NAMESPACE_ATOM1);
 208                 $xpath->registerNamespace('thr', NAMESPACE_THREAD);
 209                 $xpath->registerNamespace('georss', NAMESPACE_GEORSS);
 210                 $xpath->registerNamespace('activity', NAMESPACE_ACTIVITY);
 211                 $xpath->registerNamespace('media', NAMESPACE_MEDIA);
 212                 $xpath->registerNamespace('poco', NAMESPACE_POCO);
 213                 $xpath->registerNamespace('ostatus', NAMESPACE_OSTATUS);
 214                 $xpath->registerNamespace('statusnet', NAMESPACE_STATUSNET);
 215
 216                 $entries = $xpath->query('/atom:entry');
 217
 218                 foreach ($entries AS $entry) {
 219                         // fetch the author
 220                         $author = self::fetchauthor($xpath, $entry, $importer, $contact, true);
 221                         return $author;
 222                 }
 223         }
 224
 225         /**
 226          * @brief Imports an XML string containing OStatus elements
 227          *
 228          * @param string $xml The XML
 229          * @param array $importer user record of the importing user
 230          * @param $contact
 231          * @param array $hub Called by reference, returns the fetched hub data
 232          * @todo Add missing-type hint + determine type for $contact
 233          */
 234         public static function import($xml,$importer,&$contact, &$hub) {
 235                 /// @todo this function is too long. It has to be split in many parts
 236
 237                 logger("Import OStatus message", LOGGER_DEBUG);
 238
 239                 if ($xml == "") {
 240                         return;
 241                 }
 242
 243                 //$tempfile = tempnam(get_temppath(), "import");
 244                 //file_put_contents($tempfile, $xml);
 245
 246                 $doc = new DOMDocument();
 247                 $doc->loadXML($xml);
 248
 249                 $xpath = new DomXPath($doc);
 250                 $xpath->registerNamespace('atom', NAMESPACE_ATOM1);
 251                 $xpath->registerNamespace('thr', NAMESPACE_THREAD);
 252                 $xpath->registerNamespace('georss', NAMESPACE_GEORSS);
 253                 $xpath->registerNamespace('activity', NAMESPACE_ACTIVITY);
 254                 $xpath->registerNamespace('media', NAMESPACE_MEDIA);
 255                 $xpath->registerNamespace('poco', NAMESPACE_POCO);
 256                 $xpath->registerNamespace('ostatus', NAMESPACE_OSTATUS);
 257                 $xpath->registerNamespace('statusnet', NAMESPACE_STATUSNET);
 258
 259                 $gub = "";
 260                 $hub_attributes = $xpath->query("/atom:feed/atom:link[@rel='hub']")->item(0)->attributes;
 261                 if (is_object($hub_attributes)) {
 262                         foreach ($hub_attributes AS $hub_attribute) {
 263                                 if ($hub_attribute->name == "href") {
 264                                         $hub = $hub_attribute->textContent;
 265                                         logger("Found hub ".$hub, LOGGER_DEBUG);
 266                                 }
 267                         }
 268                 }
 269
 270                 /// @TODO One statement is enough ...
 271                 $header = array();
 272                 $header["uid"] = $importer["uid"];
 273                 $header["network"] = NETWORK_OSTATUS;
 274                 $header["type"] = "remote";
 275                 $header["wall"] = 0;
 276                 $header["origin"] = 0;
 277                 $header["gravity"] = GRAVITY_PARENT;
 278
 279                 // it could either be a received post or a post we fetched by ourselves
 280                 // depending on that, the first node is different
 281                 $first_child = $doc->firstChild->tagName;
 282
 283                 if ($first_child == "feed") {
 284                         $entries = $xpath->query('/atom:feed/atom:entry');
 285                 } else {
 286                         $entries = $xpath->query('/atom:entry');
 287                 }
 288
 289                 $conversation = "";
 290                 $conversationlist = array();
 291                 $item_id = 0;
 292
 293                 // Reverse the order of the entries
 294                 $entrylist = array();
 295
 296                 foreach ($entries AS $entry)
 297                         $entrylist[] = $entry;
 298
 299                 foreach (array_reverse($entrylist) AS $entry) {
 300
 301                         $mention = false;
 302
 303                         // fetch the author
 304                         if ($first_child == "feed") {
 305                                 $author = self::fetchauthor($xpath, $doc->firstChild, $importer, $contact, false);
 306                         } else {
 307                                 $author = self::fetchauthor($xpath, $entry, $importer, $contact, false);
 308                         }
 309
 310                         $value = $xpath->evaluate('atom:author/poco:preferredUsername/text()', $context)->item(0)->nodeValue;
 311                         if ($value != "") {
 312                                 $nickname = $value;
 313                         } else {
 314                                 $nickname = $author["author-name"];
 315                         }
 316
 317                         $item = array_merge($header, $author);
 318
 319                         // Now get the item
 320                         $item["uri"] = $xpath->query('atom:id/text()', $entry)->item(0)->nodeValue;
 321
 322                         $r = q("SELECT `id` FROM `item` WHERE `uid` = %d AND `uri` = '%s'",
 323                                 intval($importer["uid"]), dbesc($item["uri"]));
 324                         if (dbm::is_result($r)) {
 325                                 logger("Item with uri ".$item["uri"]." for user ".$importer["uid"]." already existed under id ".$r[0]["id"], LOGGER_DEBUG);
 326                                 continue;
 327                         }
 328
 329                         $item["body"] = add_page_info_to_body(html2bbcode($xpath->query('atom:content/text()', $entry)->item(0)->nodeValue));
 330                         $item["object-type"] = $xpath->query('activity:object-type/text()', $entry)->item(0)->nodeValue;
 331
 332                         if (($item["object-type"] == ACTIVITY_OBJ_BOOKMARK) OR ($item["object-type"] == ACTIVITY_OBJ_EVENT)) {
 333                                 $item["title"] = $xpath->query('atom:title/text()', $entry)->item(0)->nodeValue;
 334                                 $item["body"] = $xpath->query('atom:summary/text()', $entry)->item(0)->nodeValue;
 335                         } elseif ($item["object-type"] == ACTIVITY_OBJ_QUESTION) {
 336                                 $item["title"] = $xpath->query('atom:title/text()', $entry)->item(0)->nodeValue;
 337                         }
 338
 339                         $item["object"] = $xml;
 340                         $item["verb"] = $xpath->query('activity:verb/text()', $entry)->item(0)->nodeValue;
 341
 342                         /// @TODO
 343                         /// Delete a message
 344                         if ($item["verb"] == "qvitter-delete-notice") {
 345                                 // ignore "Delete" messages (by now)
 346                                 logger("Ignore delete message ".print_r($item, true));
 347                                 continue;
 348                         }
 349
 350                         if ($item["verb"] == ACTIVITY_JOIN) {
 351                                 // ignore "Join" messages
 352                                 logger("Ignore join message ".print_r($item, true));
 353                                 continue;
 354                         }
 355
 356                         if ($item["verb"] == ACTIVITY_FOLLOW) {
 357                                 new_follower($importer, $contact, $item, $nickname);
 358                                 continue;
 359                         }
 360
 361                         if ($item["verb"] == NAMESPACE_OSTATUS."/unfollow") {
 362                                 lose_follower($importer, $contact, $item, $dummy);
 363                                 continue;
 364                         }
 365
 366                         if ($item["verb"] == ACTIVITY_FAVORITE) {
 367                                 $orig_uri = $xpath->query("activity:object/atom:id", $entry)->item(0)->nodeValue;
 368                                 logger("Favorite ".$orig_uri." ".print_r($item, true));
 369
 370                                 $item["verb"] = ACTIVITY_LIKE;
 371                                 $item["parent-uri"] = $orig_uri;
 372                                 $item["gravity"] = GRAVITY_LIKE;
 373                         }
 374
 375                         if ($item["verb"] == NAMESPACE_OSTATUS."/unfavorite") {
 376                                 // Ignore "Unfavorite" message
 377                                 logger("Ignore unfavorite message ".print_r($item, true));
 378                                 continue;
 379                         }
 380
 381                         // http://activitystrea.ms/schema/1.0/rsvp-yes
 382                         if (!in_array($item["verb"], array(ACTIVITY_POST, ACTIVITY_LIKE, ACTIVITY_SHARE))) {
 383                                 logger("Unhandled verb ".$item["verb"]." ".print_r($item, true));
 384                         }
 385
 386                         $item["created"] = $xpath->query('atom:published/text()', $entry)->item(0)->nodeValue;
 387                         $item["edited"] = $xpath->query('atom:updated/text()', $entry)->item(0)->nodeValue;
 388                         $conversation = $xpath->query('ostatus:conversation/text()', $entry)->item(0)->nodeValue;
 389
 390                         $related = "";
 391
 392                         $inreplyto = $xpath->query('thr:in-reply-to', $entry);
 393                         if (is_object($inreplyto->item(0))) {
 394                                 foreach ($inreplyto->item(0)->attributes AS $attributes) {
 395                                         if ($attributes->name == "ref") {
 396                                                 $item["parent-uri"] = $attributes->textContent;
 397                                         }
 398                                         if ($attributes->name == "href") {
 399                                                 $related = $attributes->textContent;
 400                                         }
 401                                 }
 402                         }
 403
 404                         $georsspoint = $xpath->query('georss:point', $entry);
 405                         if ($georsspoint)
 406                                 $item["coord"] = $georsspoint->item(0)->nodeValue;
 407
 408                         $categories = $xpath->query('atom:category', $entry);
 409                         if ($categories) {
 410                                 foreach ($categories AS $category) {
 411                                         foreach ($category->attributes AS $attributes)
 412                                                 if ($attributes->name == "term") {
 413                                                         $term = $attributes->textContent;
 414                                                         if(strlen($item["tag"]))
 415                                                                 $item["tag"] .= ',';
 416                                                         $item["tag"] .= "#[url=".App::get_baseurl()."/search?tag=".$term."]".$term."[/url]";
 417                                                 }
 418                                 }
 419                         }
 420
 421                         $self = "";
 422                         $enclosure = "";
 423
 424                         $links = $xpath->query('atom:link', $entry);
 425                         if ($links) {
 426                                 $rel = "";
 427                                 $href = "";
 428                                 $type = "";
 429                                 $length = "0";
 430                                 $title = "";
 431                                 foreach ($links AS $link) {
 432                                         foreach ($link->attributes AS $attributes) {
 433                                                 if ($attributes->name == "href")
 434                                                         $href = $attributes->textContent;
 435                                                 if ($attributes->name == "rel")
 436                                                         $rel = $attributes->textContent;
 437                                                 if ($attributes->name == "type")
 438                                                         $type = $attributes->textContent;
 439                                                 if ($attributes->name == "length")
 440                                                         $length = $attributes->textContent;
 441                                                 if ($attributes->name == "title")
 442                                                         $title = $attributes->textContent;
 443                                         }
 444                                         if (($rel != "") AND ($href != "")) {
 445                                                 switch($rel) {
 446                                                         case "alternate":
 447                                                                 $item["plink"] = $href;
 448                                                                 if (($item["object-type"] == ACTIVITY_OBJ_QUESTION) OR
 449                                                                         ($item["object-type"] == ACTIVITY_OBJ_EVENT))
 450                                                                         $item["body"] .= add_page_info($href);
 451                                                                 break;
 452                                                         case "ostatus:conversation":
 453                                                                 $conversation = $href;
 454                                                                 break;
 455                                                         case "enclosure":
 456                                                                 $enclosure = $href;
 457                                                                 if(strlen($item["attach"]))
 458                                                                         $item["attach"] .= ',';
 459
 460                                                                 $item["attach"] .= '[attach]href="'.$href.'" length="'.$length.'" type="'.$type.'" title="'.$title.'"[/attach]';
 461                                                                 break;
 462                                                         case "related":
 463                                                                 if ($item["object-type"] != ACTIVITY_OBJ_BOOKMARK) {
 464                                                                         if (!isset($item["parent-uri"]))
 465                                                                                 $item["parent-uri"] = $href;
 466
 467                                                                         if ($related == "")
 468                                                                                 $related = $href;
 469                                                                 } else
 470                                                                         $item["body"] .= add_page_info($href);
 471                                                                 break;
 472                                                         case "self":
 473                                                                 $self = $href;
 474                                                                 break;
 475                                                         case "mentioned":
 476                                                                 // Notification check
 477                                                                 if ($importer["nurl"] == normalise_link($href))
 478                                                                         $mention = true;
 479                                                                 break;
 480                                                 }
 481                                         }
 482                                 }
 483                         }
 484
 485                         $local_id = "";
 486                         $repeat_of = "";
 487
 488                         $notice_info = $xpath->query('statusnet:notice_info', $entry);
 489                         if ($notice_info AND ($notice_info->length > 0)) {
 490                                 foreach ($notice_info->item(0)->attributes AS $attributes) {
 491                                         if ($attributes->name == "source") {
 492                                                 $item["app"] = strip_tags($attributes->textContent);
 493                                         }
 494                                         if ($attributes->name == "local_id") {
 495                                                 $local_id = $attributes->textContent;
 496                                         }
 497                                         if ($attributes->name == "repeat_of") {
 498                                                 $repeat_of = $attributes->textContent;
 499                                         }
 500                                 }
 501                         }
 502
 503                         // Is it a repeated post?
 504                         if (($repeat_of != "") OR ($item["verb"] == ACTIVITY_SHARE)) {
 505                                 $activityobjects = $xpath->query('activity:object', $entry)->item(0);
 506
 507                                 if (is_object($activityobjects)) {
 508
 509                                         $orig_uri = $xpath->query("activity:object/atom:id", $activityobjects)->item(0)->nodeValue;
 510                                         if (!isset($orig_uri)) {
 511                                                 $orig_uri = $xpath->query('atom:id/text()', $activityobjects)->item(0)->nodeValue;
 512                                         }
 513
 514                                         $orig_links = $xpath->query("activity:object/atom:link[@rel='alternate']", $activityobjects);
 515                                         if ($orig_links AND ($orig_links->length > 0)) {
 516                                                 foreach ($orig_links->item(0)->attributes AS $attributes) {
 517                                                         if ($attributes->name == "href") {
 518                                                                 $orig_link = $attributes->textContent;
 519                                                         }
 520                                                 }
 521                                         }
 522
 523                                         if (!isset($orig_link)) {
 524                                                 $orig_link = $xpath->query("atom:link[@rel='alternate']", $activityobjects)->item(0)->nodeValue;
 525                                         }
 526
 527                                         if (!isset($orig_link)) {
 528                                                 $orig_link =  self::convert_href($orig_uri);
 529                                         }
 530
 531                                         $orig_body = $xpath->query('activity:object/atom:content/text()', $activityobjects)->item(0)->nodeValue;
 532
 533                                         if (!isset($orig_body)) {
 534                                                 $orig_body = $xpath->query('atom:content/text()', $activityobjects)->item(0)->nodeValue;
 535                                         }
 536
 537                                         $orig_created = $xpath->query('atom:published/text()', $activityobjects)->item(0)->nodeValue;
 538                                         $orig_edited = $xpath->query('atom:updated/text()', $activityobjects)->item(0)->nodeValue;
 539
 540                                         $orig_contact = $contact;
 541                                         $orig_author = self::fetchauthor($xpath, $activityobjects, $importer, $orig_contact, false);
 542
 543                                         $item["author-name"] = $orig_author["author-name"];
 544                                         $item["author-link"] = $orig_author["author-link"];
 545                                         $item["author-avatar"] = $orig_author["author-avatar"];
 546                                         $item["body"] = add_page_info_to_body(html2bbcode($orig_body));
 547                                         $item["created"] = $orig_created;
 548                                         $item["edited"] = $orig_edited;
 549
 550                                         $item["uri"] = $orig_uri;
 551                                         $item["plink"] = $orig_link;
 552
 553                                         $item["verb"] = $xpath->query('activity:verb/text()', $activityobjects)->item(0)->nodeValue;
 554
 555                                         $item["object-type"] = $xpath->query('activity:object/activity:object-type/text()', $activityobjects)->item(0)->nodeValue;
 556
 557                                         if (!isset($item["object-type"])) {
 558                                                 $item["object-type"] = $xpath->query('activity:object-type/text()', $activityobjects)->item(0)->nodeValue;
 559                                         }
 560                                 }
 561                         }
 562
 563                         //if ($enclosure != "")
 564                         //      $item["body"] .= add_page_info($enclosure);
 565
 566                         if (isset($item["parent-uri"])) {
 567                                 $r = q("SELECT `id` FROM `item` WHERE `uid` = %d AND `uri` = '%s'",
 568                                         intval($importer["uid"]), dbesc($item["parent-uri"]));
 569
 570                                 // Only fetch missing stuff if it is a comment or reshare.
 571                                 if (in_array($item["verb"], array(ACTIVITY_POST, ACTIVITY_SHARE)) AND
 572                                         !dbm::is_result($r) AND ($related != "")) {
 573                                         $reply_path = str_replace("/notice/", "/api/statuses/show/", $related).".atom";
 574
 575                                         if ($reply_path != $related) {
 576                                                 logger("Fetching related items for user ".$importer["uid"]." from ".$reply_path, LOGGER_DEBUG);
 577                                                 $reply_xml = fetch_url($reply_path);
 578
 579                                                 $reply_contact = $contact;
 580                                                 self::import($reply_xml,$importer,$reply_contact, $reply_hub);
 581
 582                                                 // After the import try to fetch the parent item again
 583                                                 $r = q("SELECT `id` FROM `item` WHERE `uid` = %d AND `uri` = '%s'",
 584                                                         intval($importer["uid"]), dbesc($item["parent-uri"]));
 585                                         }
 586                                 }
 587
 588                                 if (dbm::is_result($r)) {
 589                                         $item["type"] = 'remote-comment';
 590                                         $item["gravity"] = GRAVITY_COMMENT;
 591                                 }
 592                         } else {
 593                                 $item["parent-uri"] = $item["uri"];
 594                         }
 595
 596                         $item_id = self::completion($conversation, $importer["uid"], $item, $self);
 597
 598                         if (!$item_id) {
 599                                 logger("Error storing item", LOGGER_DEBUG);
 600                                 continue;
 601                         }
 602
 603                         logger("Item was stored with id ".$item_id, LOGGER_DEBUG);
 604                 }
 605         }
 606
 607         /**
 608          * @brief Create an url out of an uri
 609          *
 610          * @param string $href URI in the format "parameter1:parameter1:..."
 611          *
 612          * @return string URL in the format http(s)://....
 613          */
 614         public static function convert_href($href) {
 615                 $elements = explode(":",$href);
 616
 617                 if ((count($elements) <= 2) OR ($elements[0] != "tag")) {
 618                         return $href;
 619                 }
 620
 621                 $server = explode(",", $elements[1]);
 622                 $conversation = explode("=", $elements[2]);
 623
 624                 if ((count($elements) == 4) AND ($elements[2] == "post")) {
 625                         return "http://".$server[0]."/notice/".$elements[3];
 626                 }
 627
 628                 if ((count($conversation) != 2) OR ($conversation[1] =="")) {
 629                         return $href;
 630                 }
 631
 632                 if ($elements[3] == "objectType=thread") {
 633                         return "http://".$server[0]."/conversation/".$conversation[1];
 634                 } else {
 635                         return "http://".$server[0]."/notice/".$conversation[1];
 636                 }
 637
 638                 return $href;
 639         }
 640
 641         /**
 642          * @brief Checks if there are entries in conversations that aren't present on our side
 643          *
 644          * @param bool $mentions Fetch conversations where we are mentioned
 645          * @param bool $override Override the interval setting
 646          */
 647         public static function check_conversations($mentions = false, $override = false) {
 648                 $last = get_config('system','ostatus_last_poll');
 649
 650                 $poll_interval = intval(get_config('system','ostatus_poll_interval'));
 651                 if (!$poll_interval) {
 652                         $poll_interval = self::OSTATUS_DEFAULT_POLL_INTERVAL;
 653                 }
 654
 655                 // Don't poll if the interval is set negative
 656                 if (($poll_interval < 0) AND !$override) {
 657                         return;
 658                 }
 659
 660                 if (!$mentions) {
 661                         $poll_timeframe = intval(get_config('system','ostatus_poll_timeframe'));
 662                         if (!$poll_timeframe) {
 663                                 $poll_timeframe = self::OSTATUS_DEFAULT_POLL_TIMEFRAME;
 664                         }
 665                 } else {
 666                         $poll_timeframe = intval(get_config('system','ostatus_poll_timeframe'));
 667                         if (!$poll_timeframe) {
 668                                 $poll_timeframe = self::OSTATUS_DEFAULT_POLL_TIMEFRAME_MENTIONS;
 669                         }
 670                 }
 671
 672
 673                 if ($last AND !$override) {
 674                         $next = $last + ($poll_interval * 60);
 675                         if ($next > time()) {
 676                                 logger('poll interval not reached');
 677                                 return;
 678                         }
 679                 }
 680
 681                 logger('cron_start');
 682
 683                 $start = date("Y-m-d H:i:s", time() - ($poll_timeframe * 60));
 684
 685                 if ($mentions) {
 686                         $conversations = q("SELECT `term`.`oid`, `term`.`url`, `term`.`uid` FROM `term`
 687                                                 STRAIGHT_JOIN `thread` ON `thread`.`iid` = `term`.`oid` AND `thread`.`uid` = `term`.`uid`
 688                                                 WHERE `term`.`type` = 7 AND `term`.`term` > '%s' AND `thread`.`mention`
 689                                                 GROUP BY `term`.`url`, `term`.`uid` ORDER BY `term`.`term` DESC", dbesc($start));
 690                 } else {
 691                         $conversations = q("SELECT `oid`, `url`, `uid` FROM `term`
 692                                                 WHERE `type` = 7 AND `term` > '%s'
 693                                                 GROUP BY `url`, `uid` ORDER BY `term` DESC", dbesc($start));
 694                 }
 695
 696                 foreach ($conversations AS $conversation) {
 697                         self::completion($conversation['url'], $conversation['uid']);
 698                 }
 699
 700                 logger('cron_end');
 701
 702                 set_config('system','ostatus_last_poll', time());
 703         }
 704
 705         /**
 706          * @brief Updates the gcontact table with actor data from the conversation
 707          *
 708          * @param object $actor The actor object that contains the contact data
 709          * @todo Add type-hint
 710          */
 711         private function conv_fetch_actor($actor) {
 712
 713                 // We set the generation to "3" since the data here is not as reliable as the data we get on other occasions
 714                 $contact = array("network" => NETWORK_OSTATUS, "generation" => 3);
 715
 716                 if (isset($actor->url)) {
 717                         $contact["url"] = $actor->url;
 718                 }
 719
 720                 if (isset($actor->displayName)) {
 721                         $contact["name"] = $actor->displayName;
 722                 }
 723
 724                 if (isset($actor->portablecontacts_net->displayName)) {
 725                         $contact["name"] = $actor->portablecontacts_net->displayName;
 726                 }
 727
 728                 if (isset($actor->portablecontacts_net->preferredUsername)) {
 729                         $contact["nick"] = $actor->portablecontacts_net->preferredUsername;
 730                 }
 731
 732                 if (isset($actor->id)) {
 733                         $contact["alias"] = $actor->id;
 734                 }
 735
 736                 if (isset($actor->summary)) {
 737                         $contact["about"] = $actor->summary;
 738                 }
 739
 740                 if (isset($actor->portablecontacts_net->note)) {
 741                         $contact["about"] = $actor->portablecontacts_net->note;
 742                 }
 743
 744                 if (isset($actor->portablecontacts_net->addresses->formatted)) {
 745                         $contact["location"] = $actor->portablecontacts_net->addresses->formatted;
 746                 }
 747
 748
 749                 if (isset($actor->image->url)) {
 750                         $contact["photo"] = $actor->image->url;
 751                 }
 752
 753                 if (isset($actor->image->width)) {
 754                         $avatarwidth = $actor->image->width;
 755                 }
 756
 757                 if (is_array($actor->status_net->avatarLinks))
 758                         foreach ($actor->status_net->avatarLinks AS $avatar) {
 759                                 if ($avatarsize < $avatar->width) {
 760                                         $contact["photo"] = $avatar->url;
 761                                         $avatarsize = $avatar->width;
 762                                 }
 763                         }
 764
 765                 $contact["hide"] = false; // OStatus contacts are never hidden
 766                 update_gcontact($contact);
 767         }
 768
 769         /**
 770          * @brief Fetches the conversation url for a given item link or conversation id
 771          *
 772          * @param string $self The link to the posting
 773          * @param string $conversation_id The conversation id
 774          *
 775          * @return string The conversation url
 776          */
 777         private function fetch_conversation($self, $conversation_id = "") {
 778
 779                 if ($conversation_id != "") {
 780                         $elements = explode(":", $conversation_id);
 781
 782                         if ((count($elements) <= 2) OR ($elements[0] != "tag")) {
 783                                 return $conversation_id;
 784                         }
 785                 }
 786
 787                 if ($self == "") {
 788                         return "";
 789                 }
 790
 791                 $json = str_replace(".atom", ".json", $self);
 792
 793                 $raw = fetch_url($json);
 794                 if ($raw == "") {
 795                         return "";
 796                 }
 797
 798                 $data = json_decode($raw);
 799                 if (!is_object($data)) {
 800                         return "";
 801                 }
 802
 803                 $conversation_id = $data->statusnet_conversation_id;
 804
 805                 $pos = strpos($self, "/api/statuses/show/");
 806                 $base_url = substr($self, 0, $pos);
 807
 808                 return $base_url."/conversation/".$conversation_id;
 809         }
 810
 811         /**
 812          * @brief Fetches actor details of a given actor and user id
 813          *
 814          * @param string $actor The actor url
 815          * @param int $uid The user id
 816          * @param int $contact_id The default contact-id
 817          *
 818          * @return array Array with actor details
 819          */
 820         private function get_actor_details($actor, $uid, $contact_id) {
 821
 822                 $details = array();
 823
 824                 $contact = q("SELECT `id`, `rel`, `network` FROM `contact` WHERE `uid` = %d AND `nurl` = '%s' AND `network` != '%s'",
 825                                         $uid, normalise_link($actor), NETWORK_STATUSNET);
 826
 827                 if (!dbm::is_result($contact)) {
 828                         $contact = q("SELECT `id`, `rel`, `network` FROM `contact` WHERE `uid` = %d AND `alias` IN ('%s', '%s') AND `network` != '%s'",
 829                                         $uid, $actor, normalise_link($actor), NETWORK_STATUSNET);
 830                 }
 831
 832                 if (dbm::is_resul($contact)) {
 833                         logger("Found contact for url ".$actor, LOGGER_DEBUG);
 834                         $details["contact_id"] = $contact[0]["id"];
 835                         $details["network"] = $contact[0]["network"];
 836
 837                         $details["not_following"] = !in_array($contact[0]["rel"], array(CONTACT_IS_SHARING, CONTACT_IS_FRIEND));
 838                 } else {
 839                         logger("No contact found for user ".$uid." and url ".$actor, LOGGER_DEBUG);
 840
 841                         // Adding a global contact
 842                         /// @TODO Use this data for the post
 843                         $details["global_contact_id"] = get_contact($actor, 0);
 844
 845                         logger("Global contact ".$global_contact_id." found for url ".$actor, LOGGER_DEBUG);
 846
 847                         $details["contact_id"] = $contact_id;
 848                         $details["network"] = NETWORK_OSTATUS;
 849
 850                         $details["not_following"] = true;
 851                 }
 852
 853                 return $details;
 854         }
 855
 856         /**
 857          * @brief Stores an item and completes the thread
 858          *
 859          * @param string $conversation_url The URI of the conversation
 860          * @param integer $uid The user id
 861          * @param array $item Data of the item that is to be posted
 862          *
 863          * @return integer The item id of the posted item array
 864          * @todo Add type-hints
 865          */
 866         private function completion($conversation_url, $uid, $item = array(), $self = "") {
 867
 868                 /// @todo This function is totally ugly and has to be rewritten totally
 869
 870                 $item_stored = -1;
 871
 872                 $conversation_url = self::fetch_conversation($self, $conversation_url);
 873
 874                 // If the thread shouldn't be completed then store the item and go away
 875                 // Don't do a completion on liked content
 876                 if (((intval(get_config('system','ostatus_poll_interval')) == -2) AND (count($item) > 0)) OR
 877                         ($item["verb"] == ACTIVITY_LIKE) OR ($conversation_url == "")) {
 878                         $item_stored = item_store($item, true);
 879                         return($item_stored);
 880                 }
 881
 882                 // Get the parent
 883                 $parents = q("SELECT `item`.`id`, `item`.`parent`, `item`.`uri`, `item`.`contact-id`, `item`.`type`,
 884                                 `item`.`verb`, `item`.`visible` FROM `term`
 885                                 STRAIGHT_JOIN `item` AS `thritem` ON `thritem`.`parent` = `term`.`oid`
 886                                 STRAIGHT_JOIN `item` ON `item`.`parent` = `thritem`.`parent`
 887                                 WHERE `term`.`uid` = %d AND `term`.`otype` = %d AND `term`.`type` = %d AND `term`.`url` = '%s'",
 888                                 intval($uid), intval(TERM_OBJ_POST), intval(TERM_CONVERSATION), dbesc($conversation_url));
 889
 890 /*              2016-10-23: The old query will be kept until we are sure that the query above is a good and fast replacement
 891
 892                 $parents = q("SELECT `id`, `parent`, `uri`, `contact-id`, `type`, `verb`, `visible` FROM `item` WHERE `id` IN
 893                                 (SELECT `parent` FROM `item` WHERE `id` IN
 894                                         (SELECT `oid` FROM `term` WHERE `uid` = %d AND `otype` = %d AND `type` = %d AND `url` = '%s'))",
 895                                 intval($uid), intval(TERM_OBJ_POST), intval(TERM_CONVERSATION), dbesc($conversation_url));
 896 */
 897                 if (dbm::is_result($parents)) {
 898                         $parent = $parents[0];
 899                 } elseif (count($item) > 0) {
 900                         $parent = $item;
 901                         $parent["type"] = "remote";
 902                         $parent["verb"] = ACTIVITY_POST;
 903                         $parent["visible"] = 1;
 904                 } else {
 905                         // Preset the parent
 906                         $r = q("SELECT `id` FROM `contact` WHERE `self` AND `uid`=%d", $uid);
 907                         if (!dbm::is_result($r)) {
 908                                 return(-2);
 909                         }
 910
 911                         /// @TODO one statement is enough ...
 912                         $parent = array();
 913                         $parent["id"] = 0;
 914                         $parent["parent"] = 0;
 915                         $parent["uri"] = "";
 916                         $parent["contact-id"] = $r[0]["id"];
 917                         $parent["type"] = "remote";
 918                         $parent["verb"] = ACTIVITY_POST;
 919                         $parent["visible"] = 1;
 920                 }
 921
 922                 $conv = str_replace("/conversation/", "/api/statusnet/conversation/", $conversation_url).".as";
 923                 $pageno = 1;
 924                 $items = array();
 925
 926                 logger('fetching conversation url '.$conv.' (Self: '.$self.') for user '.$uid);
 927
 928                 do {
 929                         $conv_arr = z_fetch_url($conv."?page=".$pageno);
 930
 931                         // If it is a non-ssl site and there is an error, then try ssl or vice versa
 932                         if (!$conv_arr["success"] AND (substr($conv, 0, 7) == "http://")) {
 933                                 $conv = str_replace("http://", "https://", $conv);
 934                                 $conv_as = fetch_url($conv."?page=".$pageno);
 935                         } elseif (!$conv_arr["success"] AND (substr($conv, 0, 8) == "https://")) {
 936                                 $conv = str_replace("https://", "http://", $conv);
 937                                 $conv_as = fetch_url($conv."?page=".$pageno);
 938                         } else {
 939                                 $conv_as = $conv_arr["body"];
 940                         }
 941
 942                         $conv_as = str_replace(',"statusnet:notice_info":', ',"statusnet_notice_info":', $conv_as);
 943                         $conv_as = json_decode($conv_as);
 944
 945                         $no_of_items = sizeof($items);
 946
 947                         if (is_array($conv_as->items)) {
 948                                 foreach ($conv_as->items AS $single_item) {
 949                                         $items[$single_item->id] = $single_item;
 950                                 }
 951                         }
 952
 953                         if ($no_of_items == sizeof($items)) {
 954                                 break;
 955                         }
 956
 957                         $pageno++;
 958
 959                 } while (true);
 960
 961                 logger('fetching conversation done. Found '.count($items).' items');
 962
 963                 if (!sizeof($items)) {
 964                         if (count($item) > 0) {
 965                                 $item_stored = item_store($item, true);
 966
 967                                 if ($item_stored) {
 968                                         logger("Conversation ".$conversation_url." couldn't be fetched. Item uri ".$item["uri"]." stored: ".$item_stored, LOGGER_DEBUG);
 969                                         self::store_conversation($item_id, $conversation_url);
 970                                 }
 971
 972                                 return($item_stored);
 973                         } else {
 974                                 return(-3);
 975                         }
 976                 }
 977
 978                 $items = array_reverse($items);
 979
 980                 $r = q("SELECT `nurl` FROM `contact` WHERE `uid` = %d AND `self`", intval($uid));
 981
 982                 if (!dbm::is_result($r)) {
 983                         killme();
 984                 }
 985
 986                 $importer = $r[0];
 987
 988                 $new_parent = true;
 989
 990                 foreach ($items as $single_conv) {
 991
 992                         // Update the gcontact table
 993                         self::conv_fetch_actor($single_conv->actor);
 994
 995                         // Test - remove before flight
 996                         //$tempfile = tempnam(get_temppath(), "conversation");
 997                         //file_put_contents($tempfile, json_encode($single_conv));
 998
 999                         $mention = false;
1000
1001                         if (isset($single_conv->object->id)) {
1002                                 $single_conv->id = $single_conv->object->id;
1003                         }
1004
1005                         $plink = self::convert_href($single_conv->id);
1006                         if (isset($single_conv->object->url)) {
1007                                 $plink = self::convert_href($single_conv->object->url);
1008                         }
1009
1010                         if (!isset($single_conv->id)) {
1011                                 continue;
1012                         }
1013
1014                         logger("Got id ".$single_conv->id, LOGGER_DEBUG);
1015
1016                         if ($first_id == "") {
1017                                 $first_id = $single_conv->id;
1018
1019                                 // The first post of the conversation isn't our first post. There are three options:
1020                                 // 1. Our conversation hasn't the "real" thread starter
1021                                 // 2. This first post is a post inside our thread
1022                                 // 3. This first post is a post inside another thread
1023                                 if (($first_id != $parent["uri"]) AND ($parent["uri"] != "")) {
1024
1025                                         $new_parent = true;
1026
1027                                         $new_parents = q("SELECT `id`, `parent`, `uri`, `contact-id`, `type`, `verb`, `visible` FROM `item` WHERE `id` IN
1028                                                                 (SELECT `parent` FROM `item`
1029                                                                         WHERE `uid` = %d AND `uri` = '%s' AND `network` IN ('%s','%s')) LIMIT 1",
1030                                                 intval($uid), dbesc($first_id), dbesc(NETWORK_OSTATUS), dbesc(NETWORK_DFRN));
1031                                         if (dbm::is_result($new_parents)) {
1032                                                 if ($new_parents[0]["parent"] == $parent["parent"]) {
1033                                                         // Option 2: This post is already present inside our thread - but not as thread starter
1034                                                         logger("Option 2: uri present in our thread: ".$first_id, LOGGER_DEBUG);
1035                                                         $first_id = $parent["uri"];
1036                                                 } else {
1037                                                         // Option 3: Not so good. We have mixed parents. We have to see how to clean this up.
1038                                                         // For now just take the new parent.
1039                                                         $parent = $new_parents[0];
1040                                                         $first_id = $parent["uri"];
1041                                                         logger("Option 3: mixed parents for uri ".$first_id, LOGGER_DEBUG);
1042                                                 }
1043                                         } else {
1044                                                 // Option 1: We hadn't got the real thread starter
1045                                                 // We have to clean up our existing messages.
1046                                                 $parent["id"] = 0;
1047                                                 $parent["uri"] = $first_id;
1048                                                 logger("Option 1: we have a new parent: ".$first_id, LOGGER_DEBUG);
1049                                         }
1050                                 } elseif ($parent["uri"] == "") {
1051                                         $parent["id"] = 0;
1052                                         $parent["uri"] = $first_id;
1053                                 }
1054                         }
1055
1056                         $parent_uri = $parent["uri"];
1057
1058                         // "context" only seems to exist on older servers
1059                         if (isset($single_conv->context->inReplyTo->id)) {
1060                                 $parent_exists = q("SELECT `id` FROM `item` WHERE `uid` = %d AND `uri` = '%s' AND `network` IN ('%s','%s') LIMIT 1",
1061                                                         intval($uid), dbesc($single_conv->context->inReplyTo->id), dbesc(NETWORK_OSTATUS), dbesc(NETWORK_DFRN));
1062                                 if (dbm::is_result($parent_exists)) {
1063                                         $parent_uri = $single_conv->context->inReplyTo->id;
1064                                 }
1065                         }
1066
1067                         // This is the current way
1068                         if (isset($single_conv->object->inReplyTo->id)) {
1069                                 $parent_exists = q("SELECT `id` FROM `item` WHERE `uid` = %d AND `uri` = '%s' AND `network` IN ('%s','%s') LIMIT 1",
1070                                                         intval($uid), dbesc($single_conv->object->inReplyTo->id), dbesc(NETWORK_OSTATUS), dbesc(NETWORK_DFRN));
1071                                 if (dbm::is_result($parent_exists)) {
1072                                         $parent_uri = $single_conv->object->inReplyTo->id;
1073                                 }
1074                         }
1075
1076                         $message_exists = q("SELECT `id`, `parent`, `uri` FROM `item` WHERE `uid` = %d AND `uri` = '%s' AND `network` IN ('%s','%s') LIMIT 1",
1077                                                         intval($uid), dbesc($single_conv->id),
1078                                                         dbesc(NETWORK_OSTATUS), dbesc(NETWORK_DFRN));
1079                         if ($message_exists) {
1080                                 logger("Message ".$single_conv->id." already existed on the system", LOGGER_DEBUG);
1081
1082                                 if ($parent["id"] != 0) {
1083                                         $existing_message = $message_exists[0];
1084
1085                                         // We improved the way we fetch OStatus messages, this shouldn't happen very often now
1086                                         /// @TODO We have to change the shadow copies as well. This way here is really ugly.
1087                                         if ($existing_message["parent"] != $parent["id"]) {
1088                                                 logger('updating id '.$existing_message["id"].' with parent '.$existing_message["parent"].' to parent '.$parent["id"].' uri '.$parent["uri"].' thread '.$parent_uri, LOGGER_DEBUG);
1089
1090                                                 // Update the parent id of the selected item
1091                                                 $r = q("UPDATE `item` SET `parent` = %d, `parent-uri` = '%s' WHERE `id` = %d",
1092                                                         intval($parent["id"]), dbesc($parent["uri"]), intval($existing_message["id"]));
1093
1094                                                 // Update the parent uri in the thread - but only if it points to itself
1095                                                 $r = q("UPDATE `item` SET `thr-parent` = '%s' WHERE `id` = %d AND `uri` = `thr-parent`",
1096                                                         dbesc($parent_uri), intval($existing_message["id"]));
1097
1098                                                 // try to change all items of the same parent
1099                                                 $r = q("UPDATE `item` SET `parent` = %d, `parent-uri` = '%s' WHERE `parent` = %d",
1100                                                         intval($parent["id"]), dbesc($parent["uri"]), intval($existing_message["parent"]));
1101
1102                                                 // Update the parent uri in the thread - but only if it points to itself
1103                                                 $r = q("UPDATE `item` SET `thr-parent` = '%s' WHERE (`parent` = %d) AND (`uri` = `thr-parent`)",
1104                                                         dbesc($parent["uri"]), intval($existing_message["parent"]));
1105
1106                                                 // Now delete the thread
1107                                                 delete_thread($existing_message["parent"]);
1108                                         }
1109                                 }
1110
1111                                 // The item we are having on the system is the one that we wanted to store via the item array
1112                                 if (isset($item["uri"]) AND ($item["uri"] == $existing_message["uri"])) {
1113                                         $item = array();
1114                                         $item_stored = 0;
1115                                 }
1116
1117                                 continue;
1118                         }
1119
1120                         if (is_array($single_conv->to)) {
1121                                 foreach ($single_conv->to AS $to) {
1122                                         if ($importer["nurl"] == normalise_link($to->id)) {
1123                                                 $mention = true;
1124                                         }
1125                                 }
1126                         }
1127
1128                         $actor = $single_conv->actor->id;
1129                         if (isset($single_conv->actor->url)) {
1130                                 $actor = $single_conv->actor->url;
1131                         }
1132
1133                         $details = self::get_actor_details($actor, $uid, $parent["contact-id"]);
1134
1135                         // Do we only want to import threads that were started by our contacts?
1136                         if ($details["not_following"] AND $new_parent AND get_config('system','ostatus_full_threads')) {
1137                                 logger("Don't import uri ".$first_id." because user ".$uid." doesn't follow the person ".$actor, LOGGER_DEBUG);
1138                                 continue;
1139                         }
1140
1141                         /// @TODO One statment is okay (until if() )
1142                         $arr = array();
1143                         $arr["network"] = $details["network"];
1144                         $arr["uri"] = $single_conv->id;
1145                         $arr["plink"] = $plink;
1146                         $arr["uid"] = $uid;
1147                         $arr["contact-id"] = $details["contact_id"];
1148                         $arr["parent-uri"] = $parent_uri;
1149                         $arr["created"] = $single_conv->published;
1150                         $arr["edited"] = $single_conv->published;
1151                         $arr["owner-name"] = $single_conv->actor->displayName;
1152
1153                         if ($arr["owner-name"] == '') {
1154                                 $arr["owner-name"] = $single_conv->actor->contact->displayName;
1155                         }
1156                         if ($arr["owner-name"] == '') {
1157                                 $arr["owner-name"] = $single_conv->actor->portablecontacts_net->displayName;
1158                         }
1159
1160                         $arr["owner-link"] = $actor;
1161                         $arr["owner-avatar"] = $single_conv->actor->image->url;
1162                         $arr["author-name"] = $arr["owner-name"];
1163                         $arr["author-link"] = $actor;
1164                         $arr["author-avatar"] = $single_conv->actor->image->url;
1165                         $arr["body"] = add_page_info_to_body(html2bbcode($single_conv->content));
1166
1167                         if (isset($single_conv->status_net->notice_info->source)) {
1168                                 $arr["app"] = strip_tags($single_conv->status_net->notice_info->source);
1169                         } elseif (isset($single_conv->statusnet->notice_info->source)) {
1170                                 $arr["app"] = strip_tags($single_conv->statusnet->notice_info->source);
1171                         } elseif (isset($single_conv->statusnet_notice_info->source)) {
1172                                 $arr["app"] = strip_tags($single_conv->statusnet_notice_info->source);
1173                         } elseif (isset($single_conv->provider->displayName)) {
1174                                 $arr["app"] = $single_conv->provider->displayName;
1175                         } else {
1176                                 $arr["app"] = "OStatus";
1177                         }
1178
1179                         $arr["object"] = json_encode($single_conv);
1180                         $arr["verb"] = $parent["verb"];
1181                         $arr["visible"] = $parent["visible"];
1182                         $arr["location"] = $single_conv->location->displayName;
1183                         $arr["coord"] = trim($single_conv->location->lat." ".$single_conv->location->lon);
1184
1185                         // Is it a reshared item?
1186                         if (isset($single_conv->verb) AND ($single_conv->verb == "share") AND isset($single_conv->object)) {
1187                                 if (is_array($single_conv->object)) {
1188                                         $single_conv->object = $single_conv->object[0];
1189                                 }
1190
1191                                 logger("Found reshared item ".$single_conv->object->id);
1192
1193                                 // $single_conv->object->context->conversation;
1194
1195                                 if (isset($single_conv->object->object->id)) {
1196                                         $arr["uri"] = $single_conv->object->object->id;
1197                                 } else {
1198                                         $arr["uri"] = $single_conv->object->id;
1199                                 }
1200
1201                                 if (isset($single_conv->object->object->url)) {
1202                                         $plink = self::convert_href($single_conv->object->object->url);
1203                                 } else {
1204                                         $plink = self::convert_href($single_conv->object->url);
1205                                 }
1206
1207                                 if (isset($single_conv->object->object->content)) {
1208                                         $arr["body"] = add_page_info_to_body(html2bbcode($single_conv->object->object->content));
1209                                 } else {
1210                                         $arr["body"] = add_page_info_to_body(html2bbcode($single_conv->object->content));
1211                                 }
1212
1213                                 $arr["plink"] = $plink;
1214
1215                                 $arr["created"] = $single_conv->object->published;
1216                                 $arr["edited"] = $single_conv->object->published;
1217
1218                                 $arr["author-name"] = $single_conv->object->actor->displayName;
1219                                 if ($arr["owner-name"] == '') {
1220                                         $arr["author-name"] = $single_conv->object->actor->contact->displayName;
1221                                 }
1222
1223                                 $arr["author-link"] = $single_conv->object->actor->url;
1224                                 $arr["author-avatar"] = $single_conv->object->actor->image->url;
1225
1226                                 $arr["app"] = $single_conv->object->provider->displayName."#";
1227                                 //$arr["verb"] = $single_conv->object->verb;
1228
1229                                 $arr["location"] = $single_conv->object->location->displayName;
1230                                 $arr["coord"] = trim($single_conv->object->location->lat." ".$single_conv->object->location->lon);
1231                         }
1232
1233                         if ($arr["location"] == "") {
1234                                 unset($arr["location"]);
1235                         }
1236
1237                         if ($arr["coord"] == "") {
1238                                 unset($arr["coord"]);
1239                         }
1240
1241                         // Copy fields from given item array
1242                         if (isset($item["uri"]) AND (($item["uri"] == $arr["uri"]) OR ($item["uri"] ==  $single_conv->id))) {
1243                                 $copy_fields = array("owner-name", "owner-link", "owner-avatar", "author-name", "author-link", "author-avatar",
1244                                                         "gravity", "body", "object-type", "object", "verb", "created", "edited", "coord", "tag",
1245                                                         "title", "attach", "app", "type", "location", "contact-id", "uri");
1246                                 foreach ($copy_fields AS $field) {
1247                                         if (isset($item[$field])) {
1248                                                 $arr[$field] = $item[$field];
1249                                         }
1250                                 }
1251
1252                         }
1253
1254                         $newitem = item_store($arr);
1255                         if (!$newitem) {
1256                                 logger("Item wasn't stored ".print_r($arr, true), LOGGER_DEBUG);
1257                                 continue;
1258                         }
1259
1260                         if (isset($item["uri"]) AND ($item["uri"] == $arr["uri"])) {
1261                                 $item = array();
1262                                 $item_stored = $newitem;
1263                         }
1264
1265                         logger('Stored new item '.$plink.' for parent '.$arr["parent-uri"].' under id '.$newitem, LOGGER_DEBUG);
1266
1267                         // Add the conversation entry (but don't fetch the whole conversation)
1268                         self::store_conversation($newitem, $conversation_url);
1269
1270                         // If the newly created item is the top item then change the parent settings of the thread
1271                         // This shouldn't happen anymore. This is supposed to be absolote.
1272                         if ($arr["uri"] == $first_id) {
1273                                 logger('setting new parent to id '.$newitem);
1274                                 $new_parents = q("SELECT `id`, `uri`, `contact-id`, `type`, `verb`, `visible` FROM `item` WHERE `uid` = %d AND `id` = %d LIMIT 1",
1275                                         intval($uid), intval($newitem));
1276                                 if (dbm::is_result($new_parents)) {
1277                                         $parent = $new_parents[0];
1278                                 }
1279                         }
1280                 }
1281
1282                 if (($item_stored < 0) AND (count($item) > 0)) {
1283
1284                         if (get_config('system','ostatus_full_threads')) {
1285                                 $details = self::get_actor_details($item["owner-link"], $uid, $item["contact-id"]);
1286                                 if ($details["not_following"]) {
1287                                         logger("Don't import uri ".$item["uri"]." because user ".$uid." doesn't follow the person ".$item["owner-link"], LOGGER_DEBUG);
1288                                         return false;
1289                                 }
1290                         }
1291
1292                         $item_stored = item_store($item, true);
1293                         if ($item_stored) {
1294                                 logger("Uri ".$item["uri"]." wasn't found in conversation ".$conversation_url, LOGGER_DEBUG);
1295                                 self::store_conversation($item_stored, $conversation_url);
1296                         }
1297                 }
1298
1299                 return($item_stored);
1300         }
1301
1302         /**
1303          * @brief Stores conversation data into the database
1304          *
1305          * @param integer $itemid The id of the item
1306          * @param string $conversation_url The uri of the conversation
1307          */
1308         private function store_conversation($itemid, $conversation_url) {
1309
1310                 $conversation_url = self::convert_href($conversation_url);
1311
1312                 $messages = q("SELECT `uid`, `parent`, `created`, `received`, `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($itemid));
1313
1314                 if (!dbm::is_result($messages)) {
1315                         return;
1316                 }
1317
1318                 $message = $messages[0];
1319
1320                 // Store conversation url if not done before
1321                 $conversation = q("SELECT `url` FROM `term` WHERE `uid` = %d AND `oid` = %d AND `otype` = %d AND `type` = %d",
1322                         intval($message["uid"]), intval($itemid), intval(TERM_OBJ_POST), intval(TERM_CONVERSATION));
1323
1324                 if (!dbm::is_result($conversation)) {
1325                         $r = q("INSERT INTO `term` (`uid`, `oid`, `otype`, `type`, `term`, `url`, `created`, `received`, `guid`) VALUES (%d, %d, %d, %d, '%s', '%s', '%s', '%s', '%s')",
1326                                 intval($message["uid"]), intval($itemid), intval(TERM_OBJ_POST), intval(TERM_CONVERSATION),
1327                                 dbesc($message["created"]), dbesc($conversation_url), dbesc($message["created"]), dbesc($message["received"]), dbesc($message["guid"]));
1328                         logger('Storing conversation url '.$conversation_url.' for id '.$itemid);
1329                 }
1330         }
1331
1332         /**
1333          * @brief Checks if the current post is a reshare
1334          *
1335          * @param array $item The item array of thw post
1336          *
1337          * @return string The guid if the post is a reshare
1338          * @todo Add type-hints
1339          */
1340         private function get_reshared_guid($item) {
1341                 $body = trim($item["body"]);
1342
1343                 // Skip if it isn't a pure repeated messages
1344                 // Does it start with a share?
1345                 if (strpos($body, "[share") > 0) {
1346                         return("");
1347                 }
1348
1349                 // Does it end with a share?
1350                 if (strlen($body) > (strrpos($body, "[/share]") + 8)) {
1351                         return("");
1352                 }
1353
1354                 $attributes = preg_replace("/\[share(.*?)\]\s?(.*?)\s?\[\/share\]\s?/ism","$1",$body);
1355                 // Skip if there is no shared message in there
1356                 if ($body == $attributes) {
1357                         return(false);
1358                 }
1359
1360                 $guid = "";
1361                 preg_match("/guid='(.*?)'/ism", $attributes, $matches);
1362                 if ($matches[1] != "") {
1363                         $guid = $matches[1];
1364                 }
1365
1366                 preg_match('/guid="(.*?)"/ism', $attributes, $matches);
1367                 if ($matches[1] != "") {
1368                         $guid = $matches[1];
1369                 }
1370
1371                 return $guid;
1372         }
1373
1374         /**
1375          * @brief Cleans the body of a post if it contains picture links
1376          *
1377          * @param string $body The body
1378          *
1379          * @return string The cleaned body
1380          */
1381         private function format_picture_post($body) {
1382                 $siteinfo = get_attached_data($body);
1383
1384                 if (($siteinfo["type"] == "photo")) {
1385                         if (isset($siteinfo["preview"])) {
1386                                 $preview = $siteinfo["preview"];
1387                         } else {
1388                                 $preview = $siteinfo["image"];
1389                         }
1390
1391                         // Is it a remote picture? Then make a smaller preview here
1392                         $preview = proxy_url($preview, false, PROXY_SIZE_SMALL);
1393
1394                         // Is it a local picture? Then make it smaller here
1395                         $preview = str_replace(array("-0.jpg", "-0.png"), array("-2.jpg", "-2.png"), $preview);
1396                         $preview = str_replace(array("-1.jpg", "-1.png"), array("-2.jpg", "-2.png"), $preview);
1397
1398                         if (isset($siteinfo["url"])) {
1399                                 $url = $siteinfo["url"];
1400                         } else {
1401                                 $url = $siteinfo["image"];
1402                         }
1403
1404                         $body = trim($siteinfo["text"])." [url]".$url."[/url]\n[img]".$preview."[/img]";
1405                 }
1406
1407                 return $body;
1408         }
1409
1410         /**
1411          * @brief Adds the header elements to the XML document
1412          *
1413          * @param object $doc XML document
1414          * @param array $owner Contact data of the poster
1415          *
1416          * @return object header root element
1417          * @todo Add type-hints
1418          */
1419         private function add_header($doc, $owner) {
1420
1421                 $a = get_app();
1422
1423                 $root = $doc->createElementNS(NAMESPACE_ATOM1, 'feed');
1424                 $doc->appendChild($root);
1425
1426                 $root->setAttribute("xmlns:thr", NAMESPACE_THREAD);
1427                 $root->setAttribute("xmlns:georss", NAMESPACE_GEORSS);
1428                 $root->setAttribute("xmlns:activity", NAMESPACE_ACTIVITY);
1429                 $root->setAttribute("xmlns:media", NAMESPACE_MEDIA);
1430                 $root->setAttribute("xmlns:poco", NAMESPACE_POCO);
1431                 $root->setAttribute("xmlns:ostatus", NAMESPACE_OSTATUS);
1432                 $root->setAttribute("xmlns:statusnet", NAMESPACE_STATUSNET);
1433
1434                 $attributes = array("uri" => "https://friendi.ca", "version" => FRIENDICA_VERSION."-".DB_UPDATE_VERSION);
1435                 xml::add_element($doc, $root, "generator", FRIENDICA_PLATFORM, $attributes);
1436                 xml::add_element($doc, $root, "id", App::get_baseurl()."/profile/".$owner["nick"]);
1437                 xml::add_element($doc, $root, "title", sprintf("%s timeline", $owner["name"]));
1438                 xml::add_element($doc, $root, "subtitle", sprintf("Updates from %s on %s", $owner["name"], $a->config["sitename"]));
1439                 xml::add_element($doc, $root, "logo", $owner["photo"]);
1440                 xml::add_element($doc, $root, "updated", datetime_convert("UTC", "UTC", "now", ATOM_TIME));
1441
1442                 $author = self::add_author($doc, $owner);
1443                 $root->appendChild($author);
1444
1445                 $attributes = array("href" => $owner["url"], "rel" => "alternate", "type" => "text/html");
1446                 xml::add_element($doc, $root, "link", "", $attributes);
1447
1448                 /// @TODO We have to find out what this is
1449                 /// $attributes = array("href" => App::get_baseurl()."/sup",
1450                 ///             "rel" => "http://api.friendfeed.com/2008/03#sup",
1451                 ///             "type" => "application/json");
1452                 /// xml::add_element($doc, $root, "link", "", $attributes);
1453
1454                 self::hublinks($doc, $root);
1455
1456                 $attributes = array("href" => App::get_baseurl()."/salmon/".$owner["nick"], "rel" => "salmon");
1457                 xml::add_element($doc, $root, "link", "", $attributes);
1458
1459                 $attributes = array("href" => App::get_baseurl()."/salmon/".$owner["nick"], "rel" => "http://salmon-protocol.org/ns/salmon-replies");
1460                 xml::add_element($doc, $root, "link", "", $attributes);
1461
1462                 $attributes = array("href" => App::get_baseurl()."/salmon/".$owner["nick"], "rel" => "http://salmon-protocol.org/ns/salmon-mention");
1463                 xml::add_element($doc, $root, "link", "", $attributes);
1464
1465                 $attributes = array("href" => App::get_baseurl()."/api/statuses/user_timeline/".$owner["nick"].".atom",
1466                                 "rel" => "self", "type" => "application/atom+xml");
1467                 xml::add_element($doc, $root, "link", "", $attributes);
1468
1469                 return $root;
1470         }
1471
1472         /**
1473          * @brief Add the link to the push hubs to the XML document
1474          *
1475          * @param object $doc XML document
1476          * @param object $root XML root element where the hub links are added
1477          * @todo Add type-hints
1478          */
1479         public static function hublinks($doc, $root) {
1480                 $hub = get_config('system','huburl');
1481
1482                 $hubxml = '';
1483                 if (strlen($hub)) {
1484                         $hubs = explode(',', $hub);
1485                         if (count($hubs)) {
1486                                 foreach ($hubs as $h) {
1487                                         $h = trim($h);
1488                                         if (! strlen($h)) {
1489                                                 continue;
1490                                         }
1491                                         if ($h === '[internal]') {
1492                                                 $h = App::get_baseurl() . '/pubsubhubbub';
1493                                         }
1494                                         xml::add_element($doc, $root, "link", "", array("href" => $h, "rel" => "hub"));
1495                                 }
1496                         }
1497                 }
1498         }
1499
1500         /**
1501          * @brief Adds attachement data to the XML document
1502          *
1503          * @param object $doc XML document
1504          * @param object $root XML root element where the hub links are added
1505          * @param array $item Data of the item that is to be posted
1506          * @todo Add type-hints
1507          */
1508         private function get_attachment($doc, $root, $item) {
1509                 $o = "";
1510                 $siteinfo = get_attached_data($item["body"]);
1511
1512                 switch($siteinfo["type"]) {
1513                         case 'link':
1514                                 $attributes = array("rel" => "enclosure",
1515                                                 "href" => $siteinfo["url"],
1516                                                 "type" => "text/html; charset=UTF-8",
1517                                                 "length" => "",
1518                                                 "title" => $siteinfo["title"]);
1519                                 xml::add_element($doc, $root, "link", "", $attributes);
1520                                 break;
1521                         case 'photo':
1522                                 $imgdata = get_photo_info($siteinfo["image"]);
1523                                 $attributes = array("rel" => "enclosure",
1524                                                 "href" => $siteinfo["image"],
1525                                                 "type" => $imgdata["mime"],
1526                                                 "length" => intval($imgdata["size"]));
1527                                 xml::add_element($doc, $root, "link", "", $attributes);
1528                                 break;
1529                         case 'video':
1530                                 $attributes = array("rel" => "enclosure",
1531                                                 "href" => $siteinfo["url"],
1532                                                 "type" => "text/html; charset=UTF-8",
1533                                                 "length" => "",
1534                                                 "title" => $siteinfo["title"]);
1535                                 xml::add_element($doc, $root, "link", "", $attributes);
1536                                 break;
1537                         default:
1538                                 break;
1539                 }
1540
1541                 if (($siteinfo["type"] != "photo") AND isset($siteinfo["image"])) {
1542                         $photodata = get_photo_info($siteinfo["image"]);
1543
1544                         $attributes = array("rel" => "preview", "href" => $siteinfo["image"], "media:width" => $photodata[0], "media:height" => $photodata[1]);
1545                         xml::add_element($doc, $root, "link", "", $attributes);
1546                 }
1547
1548
1549                 $arr = explode('[/attach],',$item['attach']);
1550                 if (count($arr)) {
1551                         foreach ($arr as $r) {
1552                                 $matches = false;
1553                                 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|',$r,$matches);
1554                                 if ($cnt) {
1555                                         $attributes = array("rel" => "enclosure",
1556                                                         "href" => $matches[1],
1557                                                         "type" => $matches[3]);
1558
1559                                         if (intval($matches[2])) {
1560                                                 $attributes["length"] = intval($matches[2]);
1561                                         }
1562
1563                                         if (trim($matches[4]) != "") {
1564                                                 $attributes["title"] = trim($matches[4]);
1565                                         }
1566
1567                                         xml::add_element($doc, $root, "link", "", $attributes);
1568                                 }
1569                         }
1570                 }
1571         }
1572
1573         /**
1574          * @brief Adds the author element to the XML document
1575          *
1576          * @param object $doc XML document
1577          * @param array $owner Contact data of the poster
1578          *
1579          * @return object author element
1580          * @todo Add type-hints
1581          */
1582         private function add_author($doc, $owner) {
1583
1584                 $profile = null;
1585                 $r = q("SELECT `homepage` FROM `profile` WHERE `uid` = %d AND `is-default` LIMIT 1", intval($owner["uid"]));
1586                 if (dbm::is_result($r)) {
1587                         $profile = $r[0];
1588                 }
1589
1590                 $author = $doc->createElement("author");
1591                 xml::add_element($doc, $author, "activity:object-type", ACTIVITY_OBJ_PERSON);
1592                 xml::add_element($doc, $author, "uri", $owner["url"]);
1593                 xml::add_element($doc, $author, "name", $owner["name"]);
1594                 xml::add_element($doc, $author, "summary", bbcode($owner["about"], false, false, 7));
1595
1596                 $attributes = array("rel" => "alternate", "type" => "text/html", "href" => $owner["url"]);
1597                 xml::add_element($doc, $author, "link", "", $attributes);
1598
1599                 $attributes = array(
1600                                 "rel" => "avatar",
1601                                 "type" => "image/jpeg", // To-Do?
1602                                 "media:width" => 175,
1603                                 "media:height" => 175,
1604                                 "href" => $owner["photo"]);
1605                 xml::add_element($doc, $author, "link", "", $attributes);
1606
1607                 if (isset($owner["thumb"])) {
1608                         $attributes = array(
1609                                         "rel" => "avatar",
1610                                         "type" => "image/jpeg", // To-Do?
1611                                         "media:width" => 80,
1612                                         "media:height" => 80,
1613                                         "href" => $owner["thumb"]);
1614                         xml::add_element($doc, $author, "link", "", $attributes);
1615                 }
1616
1617                 xml::add_element($doc, $author, "poco:preferredUsername", $owner["nick"]);
1618                 xml::add_element($doc, $author, "poco:displayName", $owner["name"]);
1619                 xml::add_element($doc, $author, "poco:note", bbcode($owner["about"], false, false, 7));
1620
1621                 if (trim($owner["location"]) != "") {
1622                         $element = $doc->createElement("poco:address");
1623                         xml::add_element($doc, $element, "poco:formatted", $owner["location"]);
1624                         $author->appendChild($element);
1625                 }
1626
1627                 if (trim($profile["homepage"]) != "") {
1628                         $urls = $doc->createElement("poco:urls");
1629                         xml::add_element($doc, $urls, "poco:type", "homepage");
1630                         xml::add_element($doc, $urls, "poco:value", $profile["homepage"]);
1631                         xml::add_element($doc, $urls, "poco:primary", "true");
1632                         $author->appendChild($urls);
1633                 }
1634
1635                 if (count($profile)) {
1636                         xml::add_element($doc, $author, "followers", "", array("url" => App::get_baseurl()."/viewcontacts/".$owner["nick"]));
1637                         xml::add_element($doc, $author, "statusnet:profile_info", "", array("local_id" => $owner["uid"]));
1638                 }
1639
1640                 return $author;
1641         }
1642
1643         /**
1644          * @TODO Picture attachments should look like this:
1645          *      <a href="https://status.pirati.ca/attachment/572819" title="https://status.pirati.ca/file/heluecht-20151202T222602-rd3u49p.gif"
1646          *      class="attachment thumbnail" id="attachment-572819" rel="nofollow external">https://status.pirati.ca/attachment/572819</a>
1647          *
1648         */
1649
1650         /**
1651          * @brief Returns the given activity if present - otherwise returns the "post" activity
1652          *
1653          * @param array $item Data of the item that is to be posted
1654          *
1655          * @return string activity
1656          * @todo Add type-hints
1657          */
1658         function construct_verb($item) {
1659                 if ($item['verb']) {
1660                         return $item['verb'];
1661                 }
1662                 return ACTIVITY_POST;
1663         }
1664
1665         /**
1666          * @brief Returns the given object type if present - otherwise returns the "note" object type
1667          *
1668          * @param array $item Data of the item that is to be posted
1669          *
1670          * @return string Object type
1671          * @todo Add type-hints
1672          */
1673         function construct_objecttype($item) {
1674                 if (in_array($item['object-type'], array(ACTIVITY_OBJ_NOTE, ACTIVITY_OBJ_COMMENT))) {
1675                         return $item['object-type'];
1676                 };
1677                 return ACTIVITY_OBJ_NOTE;
1678         }
1679
1680         /**
1681          * @brief Adds an entry element to the XML document
1682          *
1683          * @param object $doc XML document
1684          * @param array $item Data of the item that is to be posted
1685          * @param array $owner Contact data of the poster
1686          * @param bool $toplevel
1687          *
1688          * @return object Entry element
1689          */
1690         private function entry($doc, $item, $owner, $toplevel = false) {
1691                 $repeated_guid = self::get_reshared_guid($item);
1692                 if ($repeated_guid != "")
1693                         $xml = self::reshare_entry($doc, $item, $owner, $repeated_guid, $toplevel);
1694
1695                 if ($xml)
1696                         return $xml;
1697
1698                 if ($item["verb"] == ACTIVITY_LIKE) {
1699                         return self::like_entry($doc, $item, $owner, $toplevel);
1700                 } elseif (in_array($item["verb"], array(ACTIVITY_FOLLOW, NAMESPACE_OSTATUS."/unfollow"))) {
1701                         return self::follow_entry($doc, $item, $owner, $toplevel);
1702                 } else {
1703                         return self::note_entry($doc, $item, $owner, $toplevel);
1704                 }
1705         }
1706
1707         /**
1708          * @brief Adds a source entry to the XML document
1709          *
1710          * @param object $doc XML document
1711          * @param array $contact Array of the contact that is added
1712          *
1713          * @return object Source element
1714          * @todo Add type-hints
1715          */
1716         private function source_entry($doc, $contact) {
1717                 $source = $doc->createElement("source");
1718                 xml::add_element($doc, $source, "id", $contact["poll"]);
1719                 xml::add_element($doc, $source, "title", $contact["name"]);
1720                 xml::add_element($doc, $source, "link", "", array("rel" => "alternate",
1721                                                                 "type" => "text/html",
1722                                                                 "href" => $contact["alias"]));
1723                 xml::add_element($doc, $source, "link", "", array("rel" => "self",
1724                                                                 "type" => "application/atom+xml",
1725                                                                 "href" => $contact["poll"]));
1726                 xml::add_element($doc, $source, "icon", $contact["photo"]);
1727                 xml::add_element($doc, $source, "updated", datetime_convert("UTC","UTC",$contact["success_update"]."+00:00",ATOM_TIME));
1728
1729                 return $source;
1730         }
1731
1732         /**
1733          * @brief Fetches contact data from the contact or the gcontact table
1734          *
1735          * @param string $url URL of the contact
1736          * @param array $owner Contact data of the poster
1737          *
1738          * @return array Contact array
1739          * @todo Add array type-hint for $owner
1740          */
1741         private function contact_entry($url, $owner) {
1742
1743                 $r = q("SELECT * FROM `contact` WHERE `nurl` = '%s' AND `uid` IN (0, %d) ORDER BY `uid` DESC LIMIT 1",
1744                         dbesc(normalise_link($url)), intval($owner["uid"]));
1745                 if (dbm::is_result($r)) {
1746                         $contact = $r[0];
1747                         $contact["uid"] = -1;
1748                 } else {
1749                         $r = q("SELECT * FROM `gcontact` WHERE `nurl` = '%s' LIMIT 1",
1750                                 dbesc(normalise_link($url)));
1751                         if (dbm::is_result($r)) {
1752                                 $contact = $r[0];
1753                                 $contact["uid"] = -1;
1754                                 $contact["success_update"] = $contact["updated"];
1755                         }
1756                 }
1757
1758                 if (!dbm::is_result($r)) {
1759                         $contact = $owner;
1760                 }
1761
1762                 if (!isset($contact["poll"])) {
1763                         $data = probe_url($url);
1764                         $contact["poll"] = $data["poll"];
1765
1766                         if (!$contact["alias"]) {
1767                                 $contact["alias"] = $data["alias"];
1768                         }
1769                 }
1770
1771                 if (!isset($contact["alias"])) {
1772                         $contact["alias"] = $contact["url"];
1773                 }
1774
1775                 return $contact;
1776         }
1777
1778         /**
1779          * @brief Adds an entry element with reshared content
1780          *
1781          * @param object $doc XML document
1782          * @param array $item Data of the item that is to be posted
1783          * @param array $owner Contact data of the poster
1784          * @param $repeated_guid
1785          * @param bool $toplevel Is it for en entry element (false) or a feed entry (true)?
1786          *
1787          * @return object Entry element
1788          * @todo Add type-hints
1789          */
1790         private function reshare_entry($doc, $item, $owner, $repeated_guid, $toplevel) {
1791
1792                 if (($item["id"] != $item["parent"]) AND (normalise_link($item["author-link"]) != normalise_link($owner["url"]))) {
1793                         logger("OStatus entry is from author ".$owner["url"]." - not from ".$item["author-link"].". Quitting.", LOGGER_DEBUG);
1794                 }
1795
1796                 $title = self::entry_header($doc, $entry, $owner, $toplevel);
1797
1798                 $r = q("SELECT * FROM `item` WHERE `uid` = %d AND `guid` = '%s' AND NOT `private` AND `network` IN ('%s', '%s', '%s') LIMIT 1",
1799                         intval($owner["uid"]), dbesc($repeated_guid),
1800                         dbesc(NETWORK_DFRN), dbesc(NETWORK_DIASPORA), dbesc(NETWORK_OSTATUS));
1801
1802                 if (!dbm::is_result($r)) {
1803                         return false;
1804                 }
1805
1806                 $repeated_item = $r[0];
1807
1808                 $contact = self::contact_entry($repeated_item['author-link'], $owner);
1809
1810                 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
1811
1812                 $title = $owner["nick"]." repeated a notice by ".$contact["nick"];
1813
1814                 self::entry_content($doc, $entry, $item, $owner, $title, ACTIVITY_SHARE, false);
1815
1816                 $as_object = $doc->createElement("activity:object");
1817
1818                 xml::add_element($doc, $as_object, "activity:object-type", NAMESPACE_ACTIVITY_SCHEMA."activity");
1819
1820                 self::entry_content($doc, $as_object, $repeated_item, $owner, "", "", false);
1821
1822                 $author = self::add_author($doc, $contact);
1823                 $as_object->appendChild($author);
1824
1825                 $as_object2 = $doc->createElement("activity:object");
1826
1827                 xml::add_element($doc, $as_object2, "activity:object-type", self::construct_objecttype($repeated_item));
1828
1829                 $title = sprintf("New comment by %s", $contact["nick"]);
1830
1831                 self::entry_content($doc, $as_object2, $repeated_item, $owner, $title);
1832
1833                 $as_object->appendChild($as_object2);
1834
1835                 self::entry_footer($doc, $as_object, $item, $owner, false);
1836
1837                 $source = self::source_entry($doc, $contact);
1838
1839                 $as_object->appendChild($source);
1840
1841                 $entry->appendChild($as_object);
1842
1843                 self::entry_footer($doc, $entry, $item, $owner);
1844
1845                 return $entry;
1846         }
1847
1848         /**
1849          * @brief Adds an entry element with a "like"
1850          *
1851          * @param object $doc XML document
1852          * @param array $item Data of the item that is to be posted
1853          * @param array $owner Contact data of the poster
1854          * @param bool $toplevel Is it for en entry element (false) or a feed entry (true)?
1855          *
1856          * @return object Entry element with "like"
1857          * @todo Add type-hints
1858          */
1859         private function like_entry($doc, $item, $owner, $toplevel) {
1860
1861                 if (($item["id"] != $item["parent"]) AND (normalise_link($item["author-link"]) != normalise_link($owner["url"]))) {
1862                         logger("OStatus entry is from author ".$owner["url"]." - not from ".$item["author-link"].". Quitting.", LOGGER_DEBUG);
1863                 }
1864
1865                 $title = self::entry_header($doc, $entry, $owner, $toplevel);
1866
1867                 $verb = NAMESPACE_ACTIVITY_SCHEMA."favorite";
1868                 self::entry_content($doc, $entry, $item, $owner, "Favorite", $verb, false);
1869
1870                 $as_object = $doc->createElement("activity:object");
1871
1872                 $parent = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `uid` = %d",
1873                         dbesc($item["thr-parent"]), intval($item["uid"]));
1874                 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
1875
1876                 xml::add_element($doc, $as_object, "activity:object-type", self::construct_objecttype($parent[0]));
1877
1878                 self::entry_content($doc, $as_object, $parent[0], $owner, "New entry");
1879
1880                 $entry->appendChild($as_object);
1881
1882                 self::entry_footer($doc, $entry, $item, $owner);
1883
1884                 return $entry;
1885         }
1886
1887         /**
1888          * @brief Adds the person object element to the XML document
1889          *
1890          * @param object $doc XML document
1891          * @param array $owner Contact data of the poster
1892          * @param array $contact Contact data of the target
1893          *
1894          * @return object author element
1895          * @todo Add type-hints
1896          */
1897         private function add_person_object($doc, $owner, $contact) {
1898
1899                 $object = $doc->createElement("activity:object");
1900                 xml::add_element($doc, $object, "activity:object-type", ACTIVITY_OBJ_PERSON);
1901
1902                 if ($contact['network'] == NETWORK_PHANTOM) {
1903                         xml::add_element($doc, $object, "id", $contact['url']);
1904                         return $object;
1905                 }
1906
1907                 xml::add_element($doc, $object, "id", $contact["alias"]);
1908                 xml::add_element($doc, $object, "title", $contact["nick"]);
1909
1910                 $attributes = array("rel" => "alternate", "type" => "text/html", "href" => $contact["url"]);
1911                 xml::add_element($doc, $object, "link", "", $attributes);
1912
1913                 $attributes = array(
1914                                 "rel" => "avatar",
1915                                 "type" => "image/jpeg", // To-Do?
1916                                 "media:width" => 175,
1917                                 "media:height" => 175,
1918                                 "href" => $contact["photo"]);
1919                 xml::add_element($doc, $object, "link", "", $attributes);
1920
1921                 xml::add_element($doc, $object, "poco:preferredUsername", $contact["nick"]);
1922                 xml::add_element($doc, $object, "poco:displayName", $contact["name"]);
1923
1924                 if (trim($contact["location"]) != "") {
1925                         $element = $doc->createElement("poco:address");
1926                         xml::add_element($doc, $element, "poco:formatted", $contact["location"]);
1927                         $object->appendChild($element);
1928                 }
1929
1930                 return $object;
1931         }
1932
1933         /**
1934          * @brief Adds a follow/unfollow entry element
1935          *
1936          * @param object $doc XML document
1937          * @param array $item Data of the follow/unfollow message
1938          * @param array $owner Contact data of the poster
1939          * @param bool $toplevel Is it for en entry element (false) or a feed entry (true)?
1940          *
1941          * @return object Entry element
1942          * @todo Add type-hints
1943          */
1944         private function follow_entry($doc, $item, $owner, $toplevel) {
1945
1946                 $item["id"] = $item["parent"] = 0;
1947                 $item["created"] = $item["edited"] = date("c");
1948                 $item["private"] = true;
1949
1950                 $contact = Probe::uri($item['follow']);
1951
1952                 if ($contact['alias'] == '') {
1953                         $contact['alias'] = $contact["url"];
1954                 } else {
1955                         $item['follow'] = $contact['alias'];
1956                 }
1957
1958                 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `nurl` = '%s'",
1959                         intval($owner['uid']), dbesc(normalise_link($contact["url"])));
1960
1961                 if (dbm::is_result($r)) {
1962                         $connect_id = $r[0]['id'];
1963                 } else {
1964                         $connect_id = 0;
1965                 }
1966
1967                 if ($item['verb'] == ACTIVITY_FOLLOW) {
1968                         $message = t('%s is now following %s.');
1969                         $title = t('following');
1970                         $action = "subscription";
1971                 } else {
1972                         $message = t('%s stopped following %s.');
1973                         $title = t('stopped following');
1974                         $action = "unfollow";
1975                 }
1976
1977                 $item["uri"] = $item['parent-uri'] = $item['thr-parent'] =
1978                                 'tag:'.get_app()->get_hostname().
1979                                 ','.date('Y-m-d').':'.$action.':'.$owner['uid'].
1980                                 ':person:'.$connect_id.':'.$item['created'];
1981
1982                 $item["body"] = sprintf($message, $owner["nick"], $contact["nick"]);
1983
1984                 self::entry_header($doc, $entry, $owner, $toplevel);
1985
1986                 self::entry_content($doc, $entry, $item, $owner, $title);
1987
1988                 $object = self::add_person_object($doc, $owner, $contact);
1989                 $entry->appendChild($object);
1990
1991                 self::entry_footer($doc, $entry, $item, $owner);
1992
1993                 return $entry;
1994         }
1995
1996         /**
1997          * @brief Adds a regular entry element
1998          *
1999          * @param object $doc XML document
2000          * @param array $item Data of the item that is to be posted
2001          * @param array $owner Contact data of the poster
2002          * @param bool $toplevel Is it for en entry element (false) or a feed entry (true)?
2003          *
2004          * @return object Entry element
2005          * @todo Add type-hints
2006          */
2007         private function note_entry($doc, $item, $owner, $toplevel) {
2008
2009                 if (($item["id"] != $item["parent"]) AND (normalise_link($item["author-link"]) != normalise_link($owner["url"]))) {
2010                         logger("OStatus entry is from author ".$owner["url"]." - not from ".$item["author-link"].". Quitting.", LOGGER_DEBUG);
2011                 }
2012
2013                 $title = self::entry_header($doc, $entry, $owner, $toplevel);
2014
2015                 xml::add_element($doc, $entry, "activity:object-type", ACTIVITY_OBJ_NOTE);
2016
2017                 self::entry_content($doc, $entry, $item, $owner, $title);
2018
2019                 self::entry_footer($doc, $entry, $item, $owner);
2020
2021                 return $entry;
2022         }
2023
2024         /**
2025          * @brief Adds a header element to the XML document
2026          *
2027          * @param object $doc XML document
2028          * @param object $entry The entry element where the elements are added
2029          * @param array $owner Contact data of the poster
2030          * @param bool $toplevel Is it for en entry element (false) or a feed entry (true)?
2031          *
2032          * @return string The title for the element
2033          * @todo Add type-hints
2034          */
2035         private function entry_header($doc, &$entry, $owner, $toplevel) {
2036                 /// @todo Check if this title stuff is really needed (I guess not)
2037                 if (!$toplevel) {
2038                         $entry = $doc->createElement("entry");
2039                         $title = sprintf("New note by %s", $owner["nick"]);
2040                 } else {
2041                         $entry = $doc->createElementNS(NAMESPACE_ATOM1, "entry");
2042
2043                         $entry->setAttribute("xmlns:thr", NAMESPACE_THREAD);
2044                         $entry->setAttribute("xmlns:georss", NAMESPACE_GEORSS);
2045                         $entry->setAttribute("xmlns:activity", NAMESPACE_ACTIVITY);
2046                         $entry->setAttribute("xmlns:media", NAMESPACE_MEDIA);
2047                         $entry->setAttribute("xmlns:poco", NAMESPACE_POCO);
2048                         $entry->setAttribute("xmlns:ostatus", NAMESPACE_OSTATUS);
2049                         $entry->setAttribute("xmlns:statusnet", NAMESPACE_STATUSNET);
2050
2051                         $author = self::add_author($doc, $owner);
2052                         $entry->appendChild($author);
2053
2054                         $title = sprintf("New comment by %s", $owner["nick"]);
2055                 }
2056                 return $title;
2057         }
2058
2059         /**
2060          * @brief Adds elements to the XML document
2061          *
2062          * @param object $doc XML document
2063          * @param object $entry Entry element where the content is added
2064          * @param array $item Data of the item that is to be posted
2065          * @param array $owner Contact data of the poster
2066          * @param string $title Title for the post
2067          * @param string $verb The activity verb
2068          * @param bool $complete Add the "status_net" element?
2069          * @todo Add type-hints
2070          */
2071         private function entry_content($doc, $entry, $item, $owner, $title, $verb = "", $complete = true) {
2072
2073                 if ($verb == "") {
2074                         $verb = self::construct_verb($item);
2075                 }
2076
2077                 xml::add_element($doc, $entry, "id", $item["uri"]);
2078                 xml::add_element($doc, $entry, "title", $title);
2079
2080                 $body = self::format_picture_post($item['body']);
2081
2082                 if ($item['title'] != "") {
2083                         $body = "[b]".$item['title']."[/b]\n\n".$body;
2084                 }
2085
2086                 $body = bbcode($body, false, false, 7);
2087
2088                 xml::add_element($doc, $entry, "content", $body, array("type" => "html"));
2089
2090                 xml::add_element($doc, $entry, "link", "", array("rel" => "alternate", "type" => "text/html",
2091                                                                 "href" => App::get_baseurl()."/display/".$item["guid"]));
2092
2093                 if ($complete AND ($item["id"] > 0))
2094                         xml::add_element($doc, $entry, "status_net", "", array("notice_id" => $item["id"]));
2095
2096                 xml::add_element($doc, $entry, "activity:verb", $verb);
2097
2098                 xml::add_element($doc, $entry, "published", datetime_convert("UTC","UTC",$item["created"]."+00:00",ATOM_TIME));
2099                 xml::add_element($doc, $entry, "updated", datetime_convert("UTC","UTC",$item["edited"]."+00:00",ATOM_TIME));
2100         }
2101
2102         /**
2103          * @brief Adds the elements at the foot of an entry to the XML document
2104          *
2105          * @param object $doc XML document
2106          * @param object $entry The entry element where the elements are added
2107          * @param array $item Data of the item that is to be posted
2108          * @param array $owner Contact data of the poster
2109          * @param $complete
2110          * @todo Add type-hints
2111          */
2112         private function entry_footer($doc, $entry, $item, $owner, $complete = true) {
2113
2114                 $mentioned = array();
2115
2116                 if (($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
2117                         $parent = q("SELECT `guid`, `author-link`, `owner-link` FROM `item` WHERE `id` = %d", intval($item["parent"]));
2118                         $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
2119
2120                         $attributes = array(
2121                                         "ref" => $parent_item,
2122                                         "type" => "text/html",
2123                                         "href" => App::get_baseurl()."/display/".$parent[0]["guid"]);
2124                         xml::add_element($doc, $entry, "thr:in-reply-to", "", $attributes);
2125
2126                         $attributes = array(
2127                                         "rel" => "related",
2128                                         "href" => App::get_baseurl()."/display/".$parent[0]["guid"]);
2129                         xml::add_element($doc, $entry, "link", "", $attributes);
2130
2131                         $mentioned[$parent[0]["author-link"]] = $parent[0]["author-link"];
2132                         $mentioned[$parent[0]["owner-link"]] = $parent[0]["owner-link"];
2133
2134                         $thrparent = q("SELECT `guid`, `author-link`, `owner-link` FROM `item` WHERE `uid` = %d AND `uri` = '%s'",
2135                                         intval($owner["uid"]),
2136                                         dbesc($parent_item));
2137                         if (dbm::is_result($thrparent)) {
2138                                 $mentioned[$thrparent[0]["author-link"]] = $thrparent[0]["author-link"];
2139                                 $mentioned[$thrparent[0]["owner-link"]] = $thrparent[0]["owner-link"];
2140                         }
2141                 }
2142
2143                 if (intval($item["parent"]) > 0) {
2144                         $conversation = App::get_baseurl()."/display/".$owner["nick"]."/".$item["parent"];
2145                         xml::add_element($doc, $entry, "link", "", array("rel" => "ostatus:conversation", "href" => $conversation));
2146                         xml::add_element($doc, $entry, "ostatus:conversation", $conversation);
2147                 }
2148
2149                 $tags = item_getfeedtags($item);
2150
2151                 if (count($tags)) {
2152                         foreach ($tags as $t) {
2153                                 if ($t[0] == "@") {
2154                                         $mentioned[$t[1]] = $t[1];
2155                                 }
2156                         }
2157                 }
2158
2159                 // Make sure that mentions are accepted (GNU Social has problems with mixing HTTP and HTTPS)
2160                 $newmentions = array();
2161                 foreach ($mentioned AS $mention) {
2162                         $newmentions[str_replace("http://", "https://", $mention)] = str_replace("http://", "https://", $mention);
2163                         $newmentions[str_replace("https://", "http://", $mention)] = str_replace("https://", "http://", $mention);
2164                 }
2165                 $mentioned = $newmentions;
2166
2167                 foreach ($mentioned AS $mention) {
2168                         $r = q("SELECT `forum`, `prv` FROM `contact` WHERE `uid` = %d AND `nurl` = '%s'",
2169                                 intval($owner["uid"]),
2170                                 dbesc(normalise_link($mention)));
2171                         if ($r[0]["forum"] OR $r[0]["prv"]) {
2172                                 xml::add_element($doc, $entry, "link", "", array("rel" => "mentioned",
2173                                                                                         "ostatus:object-type" => ACTIVITY_OBJ_GROUP,
2174                                                                                         "href" => $mention));
2175                         } else {
2176                                 xml::add_element($doc, $entry, "link", "", array("rel" => "mentioned",
2177                                                                                         "ostatus:object-type" => ACTIVITY_OBJ_PERSON,
2178                                                                                         "href" => $mention));
2179                         }
2180                 }
2181
2182                 if (!$item["private"]) {
2183                         xml::add_element($doc, $entry, "link", "", array("rel" => "ostatus:attention",
2184                                                                         "href" => "http://activityschema.org/collection/public"));
2185                         xml::add_element($doc, $entry, "link", "", array("rel" => "mentioned",
2186                                                                         "ostatus:object-type" => "http://activitystrea.ms/schema/1.0/collection",
2187                                                                         "href" => "http://activityschema.org/collection/public"));
2188                 }
2189
2190                 if (count($tags)) {
2191                         foreach ($tags as $t) {
2192                                 if ($t[0] != "@") {
2193                                         xml::add_element($doc, $entry, "category", "", array("term" => $t[2]));
2194                                 }
2195                         }
2196                 }
2197
2198                 self::get_attachment($doc, $entry, $item);
2199
2200                 if ($complete AND ($item["id"] > 0)) {
2201                         $app = $item["app"];
2202                         if ($app == "")
2203                                 $app = "web";
2204
2205                         $attributes = array("local_id" => $item["id"], "source" => $app);
2206
2207                         if (isset($parent["id"]))
2208                                 $attributes["repeat_of"] = $parent["id"];
2209
2210                         if ($item["coord"] != "")
2211                                 xml::add_element($doc, $entry, "georss:point", $item["coord"]);
2212
2213                         xml::add_element($doc, $entry, "statusnet:notice_info", "", $attributes);
2214                 }
2215         }
2216
2217         /**
2218          * @brief Creates the XML feed for a given nickname
2219          *
2220          * @param app $a The application class
2221          * @param string $owner_nick Nickname of the feed owner
2222          * @param string $last_update Date of the last update
2223          *
2224          * @return string XML feed
2225          */
2226         public static function feed(App $a, $owner_nick, $last_update) {
2227
2228                 $r = q("SELECT `contact`.*, `user`.`nickname`, `user`.`timezone`, `user`.`page-flags`
2229                                 FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
2230                                 WHERE `contact`.`self` AND `user`.`nickname` = '%s' LIMIT 1",
2231                                 dbesc($owner_nick));
2232                 if (!$r)
2233                         return;
2234
2235                 $owner = $r[0];
2236
2237                 if(!strlen($last_update))
2238                         $last_update = 'now -30 days';
2239
2240                 $check_date = datetime_convert('UTC','UTC',$last_update,'Y-m-d H:i:s');
2241                 $authorid = get_contact($owner["url"], 0);
2242
2243                 $items = q("SELECT `item`.*, `item`.`id` AS `item_id` FROM `item` USE INDEX (`uid_contactid_created`)
2244                                 STRAIGHT_JOIN `thread` ON `thread`.`iid` = `item`.`parent`
2245                                 WHERE `item`.`uid` = %d AND `item`.`contact-id` = %d AND
2246                                         `item`.`author-id` = %d AND `item`.`created` > '%s' AND
2247                                         NOT `item`.`deleted` AND NOT `item`.`private` AND
2248                                         `thread`.`network` IN ('%s', '%s')
2249                                 ORDER BY `item`.`created` DESC LIMIT 300",
2250                                 intval($owner["uid"]), intval($owner["id"]),
2251                                 intval($authorid), dbesc($check_date),
2252                                 dbesc(NETWORK_OSTATUS), dbesc(NETWORK_DFRN));
2253
2254 /*              2016-10-23: The old query will be kept until we are sure that the query above is a good and fast replacement
2255
2256                 $items = q("SELECT `item`.*, `item`.`id` AS `item_id` FROM `item`
2257                                 STRAIGHT_JOIN `thread` ON `thread`.`iid` = `item`.`parent`
2258                                 LEFT JOIN `item` AS `thritem` ON `thritem`.`uri`=`item`.`thr-parent` AND `thritem`.`uid`=`item`.`uid`
2259                                 WHERE `item`.`uid` = %d AND `item`.`received` > '%s' AND NOT `item`.`private` AND NOT `item`.`deleted`
2260                                         AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = '' AND `item`.`deny_cid`  = '' AND `item`.`deny_gid`  = ''
2261                                         AND ((`item`.`wall` AND (`item`.`parent` = `item`.`id`))
2262                                                 OR (`item`.`network` = '%s' AND ((`thread`.`network` IN ('%s', '%s')) OR (`thritem`.`network` IN ('%s', '%s')))) AND `thread`.`mention`)
2263                                         AND ((`item`.`owner-link` IN ('%s', '%s') AND (`item`.`parent` = `item`.`id`))
2264                                                 OR (`item`.`author-link` IN ('%s', '%s')))
2265                                 ORDER BY `item`.`id` DESC
2266                                 LIMIT 0, 300",
2267                                 intval($owner["uid"]), dbesc($check_date), dbesc(NETWORK_DFRN),
2268                                 //dbesc(NETWORK_OSTATUS), dbesc(NETWORK_OSTATUS),
2269                                 //dbesc(NETWORK_OSTATUS), dbesc(NETWORK_OSTATUS),
2270                                 dbesc(NETWORK_OSTATUS), dbesc(NETWORK_DFRN),
2271                                 dbesc(NETWORK_OSTATUS), dbesc(NETWORK_DFRN),
2272                                 dbesc($owner["nurl"]), dbesc(str_replace("http://", "https://", $owner["nurl"])),
2273                                 dbesc($owner["nurl"]), dbesc(str_replace("http://", "https://", $owner["nurl"]))
2274                         );
2275 */
2276                 $doc = new DOMDocument('1.0', 'utf-8');
2277                 $doc->formatOutput = true;
2278
2279                 $root = self::add_header($doc, $owner);
2280
2281                 foreach ($items AS $item) {
2282                         $entry = self::entry($doc, $item, $owner);
2283                         $root->appendChild($entry);
2284                 }
2285
2286                 return(trim($doc->saveXML()));
2287         }
2288
2289         /**
2290          * @brief Creates the XML for a salmon message
2291          *
2292          * @param array $item Data of the item that is to be posted
2293          * @param array $owner Contact data of the poster
2294          *
2295          * @return string XML for the salmon
2296          */
2297         public static function salmon($item,$owner) {
2298
2299                 $doc = new DOMDocument('1.0', 'utf-8');
2300                 $doc->formatOutput = true;
2301
2302                 $entry = self::entry($doc, $item, $owner, true);
2303
2304                 $doc->appendChild($entry);
2305
2306                 return(trim($doc->saveXML()));
2307         }
2308 }
2309 ?>