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