include/diaspora.php

   1 <?php
   2 /**
   3  * @file include/diaspora.php
   4  * @brief The implementation of the diaspora protocol
   5  *
   6  * The new protocol is described here: http://diaspora.github.io/diaspora_federation/index.html
   7  * Currently this implementation here interprets the old and the new protocol and sends the old one.
   8  * This will change in the future.
   9  */
  10
  11 use Friendica\App;
  12 use Friendica\Core\Config;
  13
  14 require_once 'include/items.php';
  15 require_once 'include/bb2diaspora.php';
  16 require_once 'include/probe.php';
  17 require_once 'include/Contact.php';
  18 require_once 'include/Photo.php';
  19 require_once 'include/socgraph.php';
  20 require_once 'include/group.php';
  21 require_once 'include/xml.php';
  22 require_once 'include/datetime.php';
  23 require_once 'include/queue_fn.php';
  24 require_once 'include/cache.php';
  25
  26 /**
  27  * @brief This class contain functions to create and send Diaspora XML files
  28  *
  29  */
  30 class Diaspora {
  31
  32         /**
  33          * @brief Return a list of relay servers
  34          *
  35          * This is an experimental Diaspora feature.
  36          *
  37          * @return array of relay servers
  38          */
  39         public static function relay_list() {
  40
  41                 $serverdata = get_config("system", "relay_server");
  42                 if ($serverdata == "")
  43                         return array();
  44
  45                 $relay = array();
  46
  47                 $servers = explode(",", $serverdata);
  48
  49                 foreach ($servers AS $server) {
  50                         $server = trim($server);
  51                         $addr = "relay@".str_replace("http://", "", normalise_link($server));
  52                         $batch = $server."/receive/public";
  53
  54                         $relais = q("SELECT `batch`, `id`, `name`,`network` FROM `contact` WHERE `uid` = 0 AND `batch` = '%s' AND `addr` = '%s' AND `nurl` = '%s' LIMIT 1",
  55                                         dbesc($batch), dbesc($addr), dbesc(normalise_link($server)));
  56
  57                         if (!$relais) {
  58                                 $r = q("INSERT INTO `contact` (`uid`, `created`, `name`, `nick`, `addr`, `url`, `nurl`, `batch`, `network`, `rel`, `blocked`, `pending`, `writable`, `name-date`, `uri-date`, `avatar-date`)
  59                                         VALUES (0, '%s', '%s', 'relay', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, '%s', '%s', '%s')",
  60                                         datetime_convert(),
  61                                         dbesc($addr),
  62                                         dbesc($addr),
  63                                         dbesc($server),
  64                                         dbesc(normalise_link($server)),
  65                                         dbesc($batch),
  66                                         dbesc(NETWORK_DIASPORA),
  67                                         intval(CONTACT_IS_FOLLOWER),
  68                                         dbesc(datetime_convert()),
  69                                         dbesc(datetime_convert()),
  70                                         dbesc(datetime_convert())
  71                                 );
  72
  73                                 $relais = q("SELECT `batch`, `id`, `name`,`network` FROM `contact` WHERE `uid` = 0 AND `batch` = '%s' LIMIT 1", dbesc($batch));
  74                                 if ($relais)
  75                                         $relay[] = $relais[0];
  76                         } else
  77                                 $relay[] = $relais[0];
  78                 }
  79
  80                 return $relay;
  81         }
  82
  83         /**
  84          * @brief repairs a signature that was double encoded
  85          *
  86          * The function is unused at the moment. It was copied from the old implementation.
  87          *
  88          * @param string $signature The signature
  89          * @param string $handle The handle of the signature owner
  90          * @param integer $level This value is only set inside this function to avoid endless loops
  91          *
  92          * @return string the repaired signature
  93          */
  94         private static function repair_signature($signature, $handle = "", $level = 1) {
  95
  96                 if ($signature == "")
  97                         return ($signature);
  98
  99                 if (base64_encode(base64_decode(base64_decode($signature))) == base64_decode($signature)) {
 100                         $signature = base64_decode($signature);
 101                         logger("Repaired double encoded signature from Diaspora/Hubzilla handle ".$handle." - level ".$level, LOGGER_DEBUG);
 102
 103                         // Do a recursive call to be able to fix even multiple levels
 104                         if ($level < 10)
 105                                 $signature = self::repair_signature($signature, $handle, ++$level);
 106                 }
 107
 108                 return($signature);
 109         }
 110
 111         /**
 112          * @brief verify the envelope and return the verified data
 113          *
 114          * @param string $envelope The magic envelope
 115          *
 116          * @return string verified data
 117          */
 118         private static function verify_magic_envelope($envelope) {
 119
 120                 $basedom = parse_xml_string($envelope, false);
 121
 122                 if (!is_object($basedom)) {
 123                         logger("Envelope is no XML file");
 124                         return false;
 125                 }
 126
 127                 $children = $basedom->children('http://salmon-protocol.org/ns/magic-env');
 128
 129                 if (sizeof($children) == 0) {
 130                         logger("XML has no children");
 131                         return false;
 132                 }
 133
 134                 $handle = "";
 135
 136                 $data = base64url_decode($children->data);
 137                 $type = $children->data->attributes()->type[0];
 138
 139                 $encoding = $children->encoding;
 140
 141                 $alg = $children->alg;
 142
 143                 $sig = base64url_decode($children->sig);
 144                 $key_id = $children->sig->attributes()->key_id[0];
 145                 if ($key_id != "")
 146                         $handle = base64url_decode($key_id);
 147
 148                 $b64url_data = base64url_encode($data);
 149                 $msg = str_replace(array("\n", "\r", " ", "\t"), array("", "", "", ""), $b64url_data);
 150
 151                 $signable_data = $msg.".".base64url_encode($type).".".base64url_encode($encoding).".".base64url_encode($alg);
 152
 153                 $key = self::key($handle);
 154
 155                 $verify = rsa_verify($signable_data, $sig, $key);
 156                 if (!$verify) {
 157                         logger('Message did not verify. Discarding.');
 158                         return false;
 159                 }
 160
 161                 return $data;
 162         }
 163
 164         /**
 165          * @brief encrypts data via AES
 166          *
 167          * @param string $key The AES key
 168          * @param string $iv The IV (is used for CBC encoding)
 169          * @param string $data The data that is to be encrypted
 170          *
 171          * @return string encrypted data
 172          */
 173         private static function aes_encrypt($key, $iv, $data) {
 174                 return openssl_encrypt($data, 'aes-256-cbc', str_pad($key, 32, "\0"), OPENSSL_RAW_DATA, str_pad($iv, 16, "\0"));
 175         }
 176
 177         /**
 178          * @brief decrypts data via AES
 179          *
 180          * @param string $key The AES key
 181          * @param string $iv The IV (is used for CBC encoding)
 182          * @param string $encrypted The encrypted data
 183          *
 184          * @return string decrypted data
 185          */
 186         private static function aes_decrypt($key, $iv, $encrypted) {
 187                 return openssl_decrypt($encrypted,'aes-256-cbc', str_pad($key, 32, "\0"), OPENSSL_RAW_DATA,str_pad($iv, 16, "\0"));
 188         }
 189
 190         /**
 191          * @brief: Decodes incoming Diaspora message in the new format
 192          *
 193          * @param array $importer Array of the importer user
 194          * @param string $raw raw post message
 195          *
 196          * @return array
 197          * 'message' -> decoded Diaspora XML message
 198          * 'author' -> author diaspora handle
 199          * 'key' -> author public key (converted to pkcs#8)
 200          */
 201         public static function decode_raw($importer, $raw) {
 202                 $data = json_decode($raw);
 203
 204                 // Is it a private post? Then decrypt the outer Salmon
 205                 if (is_object($data)) {
 206                         $encrypted_aes_key_bundle = base64_decode($data->aes_key);
 207                         $ciphertext = base64_decode($data->encrypted_magic_envelope);
 208
 209                         $outer_key_bundle = '';
 210                         @openssl_private_decrypt($encrypted_aes_key_bundle, $outer_key_bundle, $importer['prvkey']);
 211                         $j_outer_key_bundle = json_decode($outer_key_bundle);
 212
 213                         if (!is_object($j_outer_key_bundle)) {
 214                                 logger('Outer Salmon did not verify. Discarding.');
 215                                 http_status_exit(400);
 216                         }
 217
 218                         $outer_iv = base64_decode($j_outer_key_bundle->iv);
 219                         $outer_key = base64_decode($j_outer_key_bundle->key);
 220
 221                         $xml = diaspora::aes_decrypt($outer_key, $outer_iv, $ciphertext);
 222                 } else {
 223                         $xml = $raw;
 224                 }
 225
 226                 $basedom = parse_xml_string($xml);
 227
 228                 if (!is_object($basedom)) {
 229                         logger('Received data does not seem to be an XML. Discarding.');
 230                         http_status_exit(400);
 231                 }
 232
 233                 $base = $basedom->children(NAMESPACE_SALMON_ME);
 234
 235                 // Not sure if this cleaning is needed
 236                 $data = str_replace(array(" ", "\t", "\r", "\n"), array("", "", "", ""), $base->data);
 237
 238                 // Build the signed data
 239                 $type = $base->data[0]->attributes()->type[0];
 240                 $encoding = $base->encoding;
 241                 $alg = $base->alg;
 242                 $signed_data = $data.'.'.base64url_encode($type).'.'.base64url_encode($encoding).'.'.base64url_encode($alg);
 243
 244                 // This is the signature
 245                 $signature = base64url_decode($base->sig);
 246
 247                 // Get the senders' public key
 248                 $key_id = $base->sig[0]->attributes()->key_id[0];
 249                 $author_addr = base64_decode($key_id);
 250                 $key = diaspora::key($author_addr);
 251
 252                 $verify = rsa_verify($signed_data, $signature, $key);
 253                 if (!$verify) {
 254                         logger('Message did not verify. Discarding.');
 255                         http_status_exit(400);
 256                 }
 257
 258                 return array('message' => (string)base64url_decode($base->data),
 259                                 'author' => unxmlify($author_addr),
 260                                 'key' => (string)$key);
 261         }
 262
 263         /**
 264          * @brief: Decodes incoming Diaspora message in the deprecated format
 265          *
 266          * @param array $importer Array of the importer user
 267          * @param string $xml urldecoded Diaspora salmon
 268          *
 269          * @return array
 270          * 'message' -> decoded Diaspora XML message
 271          * 'author' -> author diaspora handle
 272          * 'key' -> author public key (converted to pkcs#8)
 273          */
 274         public static function decode($importer, $xml) {
 275
 276                 $public = false;
 277                 $basedom = parse_xml_string($xml);
 278
 279                 if (!is_object($basedom)) {
 280                         logger("XML is not parseable.");
 281                         return false;
 282                 }
 283                 $children = $basedom->children('https://joindiaspora.com/protocol');
 284
 285                 if ($children->header) {
 286                         $public = true;
 287                         $author_link = str_replace('acct:','',$children->header->author_id);
 288                 } else {
 289
 290                         $encrypted_header = json_decode(base64_decode($children->encrypted_header));
 291
 292                         $encrypted_aes_key_bundle = base64_decode($encrypted_header->aes_key);
 293                         $ciphertext = base64_decode($encrypted_header->ciphertext);
 294
 295                         $outer_key_bundle = '';
 296                         openssl_private_decrypt($encrypted_aes_key_bundle,$outer_key_bundle,$importer['prvkey']);
 297
 298                         $j_outer_key_bundle = json_decode($outer_key_bundle);
 299
 300                         $outer_iv = base64_decode($j_outer_key_bundle->iv);
 301                         $outer_key = base64_decode($j_outer_key_bundle->key);
 302
 303                         $decrypted = self::aes_decrypt($outer_key, $outer_iv, $ciphertext);
 304
 305                         logger('decrypted: '.$decrypted, LOGGER_DEBUG);
 306                         $idom = parse_xml_string($decrypted,false);
 307
 308                         $inner_iv = base64_decode($idom->iv);
 309                         $inner_aes_key = base64_decode($idom->aes_key);
 310
 311                         $author_link = str_replace('acct:','',$idom->author_id);
 312                 }
 313
 314                 $dom = $basedom->children(NAMESPACE_SALMON_ME);
 315
 316                 // figure out where in the DOM tree our data is hiding
 317
 318                 if ($dom->provenance->data)
 319                         $base = $dom->provenance;
 320                 elseif ($dom->env->data)
 321                         $base = $dom->env;
 322                 elseif ($dom->data)
 323                         $base = $dom;
 324
 325                 if (!$base) {
 326                         logger('unable to locate salmon data in xml');
 327                         http_status_exit(400);
 328                 }
 329
 330
 331                 // Stash the signature away for now. We have to find their key or it won't be good for anything.
 332                 $signature = base64url_decode($base->sig);
 333
 334                 // unpack the  data
 335
 336                 // strip whitespace so our data element will return to one big base64 blob
 337                 $data = str_replace(array(" ","\t","\r","\n"),array("","","",""),$base->data);
 338
 339
 340                 // stash away some other stuff for later
 341
 342                 $type = $base->data[0]->attributes()->type[0];
 343                 $keyhash = $base->sig[0]->attributes()->keyhash[0];
 344                 $encoding = $base->encoding;
 345                 $alg = $base->alg;
 346
 347
 348                 $signed_data = $data.'.'.base64url_encode($type).'.'.base64url_encode($encoding).'.'.base64url_encode($alg);
 349
 350
 351                 // decode the data
 352                 $data = base64url_decode($data);
 353
 354
 355                 if ($public)
 356                         $inner_decrypted = $data;
 357                 else {
 358
 359                         // Decode the encrypted blob
 360
 361                         $inner_encrypted = base64_decode($data);
 362                         $inner_decrypted = self::aes_decrypt($inner_aes_key, $inner_iv, $inner_encrypted);
 363                 }
 364
 365                 if (!$author_link) {
 366                         logger('Could not retrieve author URI.');
 367                         http_status_exit(400);
 368                 }
 369                 // Once we have the author URI, go to the web and try to find their public key
 370                 // (first this will look it up locally if it is in the fcontact cache)
 371                 // This will also convert diaspora public key from pkcs#1 to pkcs#8
 372
 373                 logger('Fetching key for '.$author_link);
 374                 $key = self::key($author_link);
 375
 376                 if (!$key) {
 377                         logger('Could not retrieve author key.');
 378                         http_status_exit(400);
 379                 }
 380
 381                 $verify = rsa_verify($signed_data,$signature,$key);
 382
 383                 if (!$verify) {
 384                         logger('Message did not verify. Discarding.');
 385                         http_status_exit(400);
 386                 }
 387
 388                 logger('Message verified.');
 389
 390                 return array('message' => (string)$inner_decrypted,
 391                                 'author' => unxmlify($author_link),
 392                                 'key' => (string)$key);
 393         }
 394
 395
 396         /**
 397          * @brief Dispatches public messages and find the fitting receivers
 398          *
 399          * @param array $msg The post that will be dispatched
 400          *
 401          * @return int The message id of the generated message, "true" or "false" if there was an error
 402          */
 403         public static function dispatch_public($msg) {
 404
 405                 $enabled = intval(get_config("system", "diaspora_enabled"));
 406                 if (!$enabled) {
 407                         logger("diaspora is disabled");
 408                         return false;
 409                 }
 410
 411                 if (!($postdata = self::valid_posting($msg))) {
 412                         logger("Invalid posting");
 413                         return false;
 414                 }
 415
 416                 $fields = $postdata['fields'];
 417
 418                 // Is it a an action (comment, like, ...) for our own post?
 419                 if (isset($fields->parent_guid) AND !$postdata["relayed"]) {
 420                         $guid = notags(unxmlify($fields->parent_guid));
 421                         $importer = self::importer_for_guid($guid);
 422                         if (is_array($importer)) {
 423                                 logger("delivering to origin: ".$importer["name"]);
 424                                 $message_id = self::dispatch($importer, $msg, $fields);
 425                                 return $message_id;
 426                         }
 427                 }
 428
 429                 // Now distribute it to the followers
 430                 $r = q("SELECT `user`.* FROM `user` WHERE `user`.`uid` IN
 431                         (SELECT `contact`.`uid` FROM `contact` WHERE `contact`.`network` = '%s' AND `contact`.`addr` = '%s')
 432                         AND NOT `account_expired` AND NOT `account_removed`",
 433                         dbesc(NETWORK_DIASPORA),
 434                         dbesc($msg["author"])
 435                 );
 436
 437                 if (dbm::is_result($r)) {
 438                         foreach ($r as $rr) {
 439                                 logger("delivering to: ".$rr["username"]);
 440                                 self::dispatch($rr, $msg, $fields);
 441                         }
 442                 } elseif (!Config::get('system', 'relay_subscribe', false)) {
 443                         logger("Unwanted message from ".$msg["author"]." send by ".$_SERVER["REMOTE_ADDR"]." with ".$_SERVER["HTTP_USER_AGENT"].": ".print_r($msg, true), LOGGER_DEBUG);
 444                 } else {
 445                         // Use a dummy importer to import the data for the public copy
 446                         $importer = array("uid" => 0, "page-flags" => PAGE_FREELOVE);
 447                         $message_id = self::dispatch($importer, $msg, $fields);
 448                 }
 449
 450                 return $message_id;
 451         }
 452
 453         /**
 454          * @brief Dispatches the different message types to the different functions
 455          *
 456          * @param array $importer Array of the importer user
 457          * @param array $msg The post that will be dispatched
 458          * @param object $fields SimpleXML object that contains the message
 459          *
 460          * @return int The message id of the generated message, "true" or "false" if there was an error
 461          */
 462         public static function dispatch($importer, $msg, $fields = null) {
 463
 464                 // The sender is the handle of the contact that sent the message.
 465                 // This will often be different with relayed messages (for example "like" and "comment")
 466                 $sender = $msg["author"];
 467
 468                 // This is only needed for private postings since this is already done for public ones before
 469                 if (is_null($fields)) {
 470                         if (!($postdata = self::valid_posting($msg))) {
 471                                 logger("Invalid posting");
 472                                 return false;
 473                         }
 474                         $fields = $postdata['fields'];
 475                 }
 476
 477                 $type = $fields->getName();
 478
 479                 logger("Received message type ".$type." from ".$sender." for user ".$importer["uid"], LOGGER_DEBUG);
 480
 481                 switch ($type) {
 482                         case "account_deletion":
 483                                 return self::receive_account_deletion($importer, $fields);
 484
 485                         case "comment":
 486                                 return self::receive_comment($importer, $sender, $fields, $msg["message"]);
 487
 488                         case "contact":
 489                                 return self::receive_contact_request($importer, $fields);
 490
 491                         case "conversation":
 492                                 return self::receive_conversation($importer, $msg, $fields);
 493
 494                         case "like":
 495                                 return self::receive_like($importer, $sender, $fields);
 496
 497                         case "message":
 498                                 return self::receive_message($importer, $fields);
 499
 500                         case "participation": // Not implemented
 501                                 return self::receive_participation($importer, $fields);
 502
 503                         case "photo": // Not implemented
 504                                 return self::receive_photo($importer, $fields);
 505
 506                         case "poll_participation": // Not implemented
 507                                 return self::receive_poll_participation($importer, $fields);
 508
 509                         case "profile":
 510                                 return self::receive_profile($importer, $fields);
 511
 512                         case "reshare":
 513                                 return self::receive_reshare($importer, $fields, $msg["message"]);
 514
 515                         case "retraction":
 516                                 return self::receive_retraction($importer, $sender, $fields);
 517
 518                         case "status_message":
 519                                 return self::receive_status_message($importer, $fields, $msg["message"]);
 520
 521                         default:
 522                                 logger("Unknown message type ".$type);
 523                                 return false;
 524                 }
 525
 526                 return true;
 527         }
 528
 529         /**
 530          * @brief Checks if a posting is valid and fetches the data fields.
 531          *
 532          * This function does not only check the signature.
 533          * It also does the conversion between the old and the new diaspora format.
 534          *
 535          * @param array $msg Array with the XML, the sender handle and the sender signature
 536          *
 537          * @return bool|array If the posting is valid then an array with an SimpleXML object is returned
 538          */
 539         private static function valid_posting($msg) {
 540
 541                 $data = parse_xml_string($msg["message"], false);
 542
 543                 if (!is_object($data)) {
 544                         logger("No valid XML ".$msg["message"], LOGGER_DEBUG);
 545                         return false;
 546                 }
 547
 548                 $first_child = $data->getName();
 549
 550                 // Is this the new or the old version?
 551                 if ($data->getName() == "XML") {
 552                         $oldXML = true;
 553                         foreach ($data->post->children() as $child)
 554                                 $element = $child;
 555                 } else {
 556                         $oldXML = false;
 557                         $element = $data;
 558                 }
 559
 560                 $type = $element->getName();
 561                 $orig_type = $type;
 562
 563                 logger("Got message type ".$type.": ".$msg["message"], LOGGER_DATA);
 564
 565                 // All retractions are handled identically from now on.
 566                 // In the new version there will only be "retraction".
 567                 if (in_array($type, array("signed_retraction", "relayable_retraction")))
 568                         $type = "retraction";
 569
 570                 if ($type == "request")
 571                         $type = "contact";
 572
 573                 $fields = new SimpleXMLElement("<".$type."/>");
 574
 575                 $signed_data = "";
 576
 577                 foreach ($element->children() AS $fieldname => $entry) {
 578                         if ($oldXML) {
 579                                 // Translation for the old XML structure
 580                                 if ($fieldname == "diaspora_handle") {
 581                                         $fieldname = "author";
 582                                 }
 583                                 if ($fieldname == "participant_handles") {
 584                                         $fieldname = "participants";
 585                                 }
 586                                 if (in_array($type, array("like", "participation"))) {
 587                                         if ($fieldname == "target_type") {
 588                                                 $fieldname = "parent_type";
 589                                         }
 590                                 }
 591                                 if ($fieldname == "sender_handle") {
 592                                         $fieldname = "author";
 593                                 }
 594                                 if ($fieldname == "recipient_handle") {
 595                                         $fieldname = "recipient";
 596                                 }
 597                                 if ($fieldname == "root_diaspora_id") {
 598                                         $fieldname = "root_author";
 599                                 }
 600                                 if ($type == "status_message") {
 601                                         if ($fieldname == "raw_message") {
 602                                                 $fieldname = "text";
 603                                         }
 604                                 }
 605                                 if ($type == "retraction") {
 606                                         if ($fieldname == "post_guid") {
 607                                                 $fieldname = "target_guid";
 608                                         }
 609                                         if ($fieldname == "type") {
 610                                                 $fieldname = "target_type";
 611                                         }
 612                                 }
 613                         }
 614
 615                         if (($fieldname == "author_signature") AND ($entry != ""))
 616                                 $author_signature = base64_decode($entry);
 617                         elseif (($fieldname == "parent_author_signature") AND ($entry != ""))
 618                                 $parent_author_signature = base64_decode($entry);
 619                         elseif (!in_array($fieldname, array("author_signature", "parent_author_signature", "target_author_signature"))) {
 620                                 if ($signed_data != "") {
 621                                         $signed_data .= ";";
 622                                         $signed_data_parent .= ";";
 623                                 }
 624
 625                                 $signed_data .= $entry;
 626                         }
 627                         if (!in_array($fieldname, array("parent_author_signature", "target_author_signature")) OR
 628                                 ($orig_type == "relayable_retraction"))
 629                                 xml::copy($entry, $fields, $fieldname);
 630                 }
 631
 632                 // This is something that shouldn't happen at all.
 633                 if (in_array($type, array("status_message", "reshare", "profile")))
 634                         if ($msg["author"] != $fields->author) {
 635                                 logger("Message handle is not the same as envelope sender. Quitting this message.");
 636                                 return false;
 637                         }
 638
 639                 // Only some message types have signatures. So we quit here for the other types.
 640                 if (!in_array($type, array("comment", "like"))) {
 641                         return array("fields" => $fields, "relayed" => false);
 642                 }
 643                 // No author_signature? This is a must, so we quit.
 644                 if (!isset($author_signature)) {
 645                         logger("No author signature for type ".$type." - Message: ".$msg["message"], LOGGER_DEBUG);
 646                         return false;
 647                 }
 648
 649                 if (isset($parent_author_signature)) {
 650                         $relayed = true;
 651
 652                         $key = self::key($msg["author"]);
 653
 654                         if (!rsa_verify($signed_data, $parent_author_signature, $key, "sha256")) {
 655                                 logger("No valid parent author signature for parent author ".$msg["author"]. " in type ".$type." - signed data: ".$signed_data." - Message: ".$msg["message"]." - Signature ".$parent_author_signature, LOGGER_DEBUG);
 656                                 return false;
 657                         }
 658                 } else {
 659                         $relayed = false;
 660                 }
 661
 662                 $key = self::key($fields->author);
 663
 664                 if (!rsa_verify($signed_data, $author_signature, $key, "sha256")) {
 665                         logger("No valid author signature for author ".$fields->author. " in type ".$type." - signed data: ".$signed_data." - Message: ".$msg["message"]." - Signature ".$author_signature, LOGGER_DEBUG);
 666                         return false;
 667                 } else {
 668                         return array("fields" => $fields, "relayed" => $relayed);
 669                 }
 670         }
 671
 672         /**
 673          * @brief Fetches the public key for a given handle
 674          *
 675          * @param string $handle The handle
 676          *
 677          * @return string The public key
 678          */
 679         private static function key($handle) {
 680                 $handle = strval($handle);
 681
 682                 logger("Fetching diaspora key for: ".$handle);
 683
 684                 $r = self::person_by_handle($handle);
 685                 if ($r)
 686                         return $r["pubkey"];
 687
 688                 return "";
 689         }
 690
 691         /**
 692          * @brief Fetches data for a given handle
 693          *
 694          * @param string $handle The handle
 695          *
 696          * @return array the queried data
 697          */
 698         public static function person_by_handle($handle) {
 699
 700                 $r = q("SELECT * FROM `fcontact` WHERE `network` = '%s' AND `addr` = '%s' LIMIT 1",
 701                         dbesc(NETWORK_DIASPORA),
 702                         dbesc($handle)
 703                 );
 704                 if ($r) {
 705                         $person = $r[0];
 706                         logger("In cache ".print_r($r,true), LOGGER_DEBUG);
 707
 708                         // update record occasionally so it doesn't get stale
 709                         $d = strtotime($person["updated"]." +00:00");
 710                         if ($d < strtotime("now - 14 days"))
 711                                 $update = true;
 712
 713                         if ($person["guid"] == "")
 714                                 $update = true;
 715                 }
 716
 717                 if (!$person OR $update) {
 718                         logger("create or refresh", LOGGER_DEBUG);
 719                         $r = probe_url($handle, PROBE_DIASPORA);
 720
 721                         // Note that Friendica contacts will return a "Diaspora person"
 722                         // if Diaspora connectivity is enabled on their server
 723                         if ($r AND ($r["network"] === NETWORK_DIASPORA)) {
 724                                 self::add_fcontact($r, $update);
 725                                 $person = $r;
 726                         }
 727                 }
 728                 return $person;
 729         }
 730
 731         /**
 732          * @brief Updates the fcontact table
 733          *
 734          * @param array $arr The fcontact data
 735          * @param bool $update Update or insert?
 736          *
 737          * @return string The id of the fcontact entry
 738          */
 739         private static function add_fcontact($arr, $update = false) {
 740
 741                 if ($update) {
 742                         $r = q("UPDATE `fcontact` SET
 743                                         `name` = '%s',
 744                                         `photo` = '%s',
 745                                         `request` = '%s',
 746                                         `nick` = '%s',
 747                                         `addr` = '%s',
 748                                         `guid` = '%s',
 749                                         `batch` = '%s',
 750                                         `notify` = '%s',
 751                                         `poll` = '%s',
 752                                         `confirm` = '%s',
 753                                         `alias` = '%s',
 754                                         `pubkey` = '%s',
 755                                         `updated` = '%s'
 756                                 WHERE `url` = '%s' AND `network` = '%s'",
 757                                         dbesc($arr["name"]),
 758                                         dbesc($arr["photo"]),
 759                                         dbesc($arr["request"]),
 760                                         dbesc($arr["nick"]),
 761                                         dbesc(strtolower($arr["addr"])),
 762                                         dbesc($arr["guid"]),
 763                                         dbesc($arr["batch"]),
 764                                         dbesc($arr["notify"]),
 765                                         dbesc($arr["poll"]),
 766                                         dbesc($arr["confirm"]),
 767                                         dbesc($arr["alias"]),
 768                                         dbesc($arr["pubkey"]),
 769                                         dbesc(datetime_convert()),
 770                                         dbesc($arr["url"]),
 771                                         dbesc($arr["network"])
 772                                 );
 773                 } else {
 774                         $r = q("INSERT INTO `fcontact` (`url`,`name`,`photo`,`request`,`nick`,`addr`, `guid`,
 775                                         `batch`, `notify`,`poll`,`confirm`,`network`,`alias`,`pubkey`,`updated`)
 776                                 VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
 777                                         dbesc($arr["url"]),
 778                                         dbesc($arr["name"]),
 779                                         dbesc($arr["photo"]),
 780                                         dbesc($arr["request"]),
 781                                         dbesc($arr["nick"]),
 782                                         dbesc($arr["addr"]),
 783                                         dbesc($arr["guid"]),
 784                                         dbesc($arr["batch"]),
 785                                         dbesc($arr["notify"]),
 786                                         dbesc($arr["poll"]),
 787                                         dbesc($arr["confirm"]),
 788                                         dbesc($arr["network"]),
 789                                         dbesc($arr["alias"]),
 790                                         dbesc($arr["pubkey"]),
 791                                         dbesc(datetime_convert())
 792                                 );
 793                 }
 794
 795                 return $r;
 796         }
 797
 798         /**
 799          * @brief get a handle (user@domain.tld) from a given contact id or gcontact id
 800          *
 801          * @param int $contact_id The id in the contact table
 802          * @param int $gcontact_id The id in the gcontact table
 803          *
 804          * @return string the handle
 805          */
 806         public static function handle_from_contact($contact_id, $gcontact_id = 0) {
 807                 $handle = false;
 808
 809                 logger("contact id is ".$contact_id." - gcontact id is ".$gcontact_id, LOGGER_DEBUG);
 810
 811                 if ($gcontact_id != 0) {
 812                         $r = q("SELECT `addr` FROM `gcontact` WHERE `id` = %d AND `addr` != ''",
 813                                 intval($gcontact_id));
 814
 815                         if (dbm::is_result($r)) {
 816                                 return strtolower($r[0]["addr"]);
 817                         }
 818                 }
 819
 820                 $r = q("SELECT `network`, `addr`, `self`, `url`, `nick` FROM `contact` WHERE `id` = %d",
 821                         intval($contact_id));
 822
 823                 if (dbm::is_result($r)) {
 824                         $contact = $r[0];
 825
 826                         logger("contact 'self' = ".$contact['self']." 'url' = ".$contact['url'], LOGGER_DEBUG);
 827
 828                         if ($contact['addr'] != "") {
 829                                 $handle = $contact['addr'];
 830                         } else {
 831                                 $baseurl_start = strpos($contact['url'],'://') + 3;
 832                                 $baseurl_length = strpos($contact['url'],'/profile') - $baseurl_start; // allows installations in a subdirectory--not sure how Diaspora will handle
 833                                 $baseurl = substr($contact['url'], $baseurl_start, $baseurl_length);
 834                                 $handle = $contact['nick'].'@'.$baseurl;
 835                         }
 836                 }
 837
 838                 return strtolower($handle);
 839         }
 840
 841         /**
 842          * @brief get a url (scheme://domain.tld/u/user) from a given Diaspora*
 843          * fcontact guid
 844          *
 845          * @param mixed $fcontact_guid Hexadecimal string guid
 846          *
 847          * @return string the contact url or null
 848          */
 849         public static function url_from_contact_guid($fcontact_guid) {
 850                 logger("fcontact guid is ".$fcontact_guid, LOGGER_DEBUG);
 851
 852                 $r = q("SELECT `url` FROM `fcontact` WHERE `url` != '' AND `network` = '%s' AND `guid` = '%s'",
 853                         dbesc(NETWORK_DIASPORA),
 854                         dbesc($fcontact_guid)
 855                 );
 856
 857                 if (dbm::is_result($r)) {
 858                         return $r[0]['url'];
 859                 }
 860
 861                 return null;
 862         }
 863
 864         /**
 865          * @brief Get a contact id for a given handle
 866          *
 867          * @param int $uid The user id
 868          * @param string $handle The handle in the format user@domain.tld
 869          *
 870          * @return The contact id
 871          */
 872         private static function contact_by_handle($uid, $handle) {
 873
 874                 // First do a direct search on the contact table
 875                 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `addr` = '%s' LIMIT 1",
 876                         intval($uid),
 877                         dbesc($handle)
 878                 );
 879
 880                 if (dbm::is_result($r)) {
 881                         return $r[0];
 882                 } else {
 883                         // We haven't found it?
 884                         // We use another function for it that will possibly create a contact entry
 885                         $cid = get_contact($handle, $uid);
 886
 887                         if ($cid > 0) {
 888                                 $r = q("SELECT * FROM `contact` WHERE `id` = %d LIMIT 1", intval($cid));
 889
 890                                 if (dbm::is_result($r)) {
 891                                         return $r[0];
 892                                 }
 893                         }
 894                 }
 895
 896                 $handle_parts = explode("@", $handle);
 897                 $nurl_sql = "%%://".$handle_parts[1]."%%/profile/".$handle_parts[0];
 898                 $r = q("SELECT * FROM `contact` WHERE `network` = '%s' AND `uid` = %d AND `nurl` LIKE '%s' LIMIT 1",
 899                         dbesc(NETWORK_DFRN),
 900                         intval($uid),
 901                         dbesc($nurl_sql)
 902                 );
 903                 if (dbm::is_result($r)) {
 904                         return $r[0];
 905                 }
 906
 907                 logger("Haven't found contact for user ".$uid." and handle ".$handle, LOGGER_DEBUG);
 908                 return false;
 909         }
 910
 911         /**
 912          * @brief Check if posting is allowed for this contact
 913          *
 914          * @param array $importer Array of the importer user
 915          * @param array $contact The contact that is checked
 916          * @param bool $is_comment Is the check for a comment?
 917          *
 918          * @return bool is the contact allowed to post?
 919          */
 920         private static function post_allow($importer, $contact, $is_comment = false) {
 921
 922                 // perhaps we were already sharing with this person. Now they're sharing with us.
 923                 // That makes us friends.
 924                 // Normally this should have handled by getting a request - but this could get lost
 925                 if ($contact["rel"] == CONTACT_IS_FOLLOWER && in_array($importer["page-flags"], array(PAGE_FREELOVE))) {
 926                         q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
 927                                 intval(CONTACT_IS_FRIEND),
 928                                 intval($contact["id"]),
 929                                 intval($importer["uid"])
 930                         );
 931                         $contact["rel"] = CONTACT_IS_FRIEND;
 932                         logger("defining user ".$contact["nick"]." as friend");
 933                 }
 934
 935                 // We don't seem to like that person
 936                 if ($contact["blocked"] || $contact["readonly"] || $contact["archive"]) {
 937                         return false;
 938                 // We are following this person? Then it is okay
 939                 } elseif (($contact["rel"] == CONTACT_IS_SHARING) || ($contact["rel"] == CONTACT_IS_FRIEND)) {
 940                         return true;
 941                 // Is it a post to a community? That's good
 942                 } elseif (($contact["rel"] == CONTACT_IS_FOLLOWER) && ($importer["page-flags"] == PAGE_COMMUNITY)) {
 943                         return true;
 944                 }
 945                 // Messages for the global users and comments are always accepted
 946                 if (($importer["uid"] == 0) || $is_comment) {
 947                         return true;
 948                 }
 949
 950                 return false;
 951         }
 952
 953         /**
 954          * @brief Fetches the contact id for a handle and checks if posting is allowed
 955          *
 956          * @param array $importer Array of the importer user
 957          * @param string $handle The checked handle in the format user@domain.tld
 958          * @param bool $is_comment Is the check for a comment?
 959          *
 960          * @return array The contact data
 961          */
 962         private static function allowed_contact_by_handle($importer, $handle, $is_comment = false) {
 963                 $contact = self::contact_by_handle($importer["uid"], $handle);
 964                 if (!$contact) {
 965                         logger("A Contact for handle ".$handle." and user ".$importer["uid"]." was not found");
 966                         // If a contact isn't found, we accept it anyway if it is a comment
 967                         if ($is_comment) {
 968                                 return $importer;
 969                         } else {
 970                                 return false;
 971                         }
 972                 }
 973
 974                 if (!self::post_allow($importer, $contact, $is_comment)) {
 975                         logger("The handle: ".$handle." is not allowed to post to user ".$importer["uid"]);
 976                         return false;
 977                 }
 978                 return $contact;
 979         }
 980
 981         /**
 982          * @brief Does the message already exists on the system?
 983          *
 984          * @param int $uid The user id
 985          * @param string $guid The guid of the message
 986          *
 987          * @return int|bool message id if the message already was stored into the system - or false.
 988          */
 989         private static function message_exists($uid, $guid) {
 990                 $r = q("SELECT `id` FROM `item` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
 991                         intval($uid),
 992                         dbesc($guid)
 993                 );
 994
 995                 if (dbm::is_result($r)) {
 996                         logger("message ".$guid." already exists for user ".$uid);
 997                         return $r[0]["id"];
 998                 }
 999
1000                 return false;
1001         }
1002
1003         /**
1004          * @brief Checks for links to posts in a message
1005          *
1006          * @param array $item The item array
1007          */
1008         private static function fetch_guid($item) {
1009                 preg_replace_callback("&\[url=/posts/([^\[\]]*)\](.*)\[\/url\]&Usi",
1010                         function ($match) use ($item){
1011                                 return(self::fetch_guid_sub($match, $item));
1012                         },$item["body"]);
1013         }
1014
1015         /**
1016          * @brief Checks for relative /people/* links in an item body to match local
1017          * contacts or prepends the remote host taken from the author link.
1018          *
1019          * @param string $body The item body to replace links from
1020          * @param string $author_link The author link for missing local contact fallback
1021          *
1022          * @return the replaced string
1023          */
1024         public function replace_people_guid($body, $author_link) {
1025                 $return = preg_replace_callback("&\[url=/people/([^\[\]]*)\](.*)\[\/url\]&Usi",
1026                         function ($match) use ($author_link) {
1027                                 // $match
1028                                 // 0 => '[url=/people/0123456789abcdef]Foo Bar[/url]'
1029                                 // 1 => '0123456789abcdef'
1030                                 // 2 => 'Foo Bar'
1031                                 $handle = self::url_from_contact_guid($match[1]);
1032
1033                                 if ($handle) {
1034                                         $return = '@[url='.$handle.']'.$match[2].'[/url]';
1035                                 } else {
1036                                         // No local match, restoring absolute remote URL from author scheme and host
1037                                         $author_url = parse_url($author_link);
1038                                         $return = '[url='.$author_url['scheme'].'://'.$author_url['host'].'/people/'.$match[1].']'.$match[2].'[/url]';
1039                                 }
1040
1041                                 return $return;
1042                         }, $body);
1043
1044                 return $return;
1045         }
1046
1047         /**
1048          * @brief sub function of "fetch_guid" which checks for links in messages
1049          *
1050          * @param array $match array containing a link that has to be checked for a message link
1051          * @param array $item The item array
1052          */
1053         private static function fetch_guid_sub($match, $item) {
1054                 if (!self::store_by_guid($match[1], $item["author-link"]))
1055                         self::store_by_guid($match[1], $item["owner-link"]);
1056         }
1057
1058         /**
1059          * @brief Fetches an item with a given guid from a given server
1060          *
1061          * @param string $guid the message guid
1062          * @param string $server The server address
1063          * @param int $uid The user id of the user
1064          *
1065          * @return int the message id of the stored message or false
1066          */
1067         private static function store_by_guid($guid, $server, $uid = 0) {
1068                 $serverparts = parse_url($server);
1069                 $server = $serverparts["scheme"]."://".$serverparts["host"];
1070
1071                 logger("Trying to fetch item ".$guid." from ".$server, LOGGER_DEBUG);
1072
1073                 $msg = self::message($guid, $server);
1074
1075                 if (!$msg)
1076                         return false;
1077
1078                 logger("Successfully fetched item ".$guid." from ".$server, LOGGER_DEBUG);
1079
1080                 // Now call the dispatcher
1081                 return self::dispatch_public($msg);
1082         }
1083
1084         /**
1085          * @brief Fetches a message from a server
1086          *
1087          * @param string $guid message guid
1088          * @param string $server The url of the server
1089          * @param int $level Endless loop prevention
1090          *
1091          * @return array
1092          *      'message' => The message XML
1093          *      'author' => The author handle
1094          *      'key' => The public key of the author
1095          */
1096         private static function message($guid, $server, $level = 0) {
1097
1098                 if ($level > 5)
1099                         return false;
1100
1101                 // This will work for new Diaspora servers and Friendica servers from 3.5
1102                 $source_url = $server."/fetch/post/".$guid;
1103                 logger("Fetch post from ".$source_url, LOGGER_DEBUG);
1104
1105                 $envelope = fetch_url($source_url);
1106                 if ($envelope) {
1107                         logger("Envelope was fetched.", LOGGER_DEBUG);
1108                         $x = self::verify_magic_envelope($envelope);
1109                         if (!$x)
1110                                 logger("Envelope could not be verified.", LOGGER_DEBUG);
1111                         else
1112                                 logger("Envelope was verified.", LOGGER_DEBUG);
1113                 } else
1114                         $x = false;
1115
1116                 // This will work for older Diaspora and Friendica servers
1117                 if (!$x) {
1118                         $source_url = $server."/p/".$guid.".xml";
1119                         logger("Fetch post from ".$source_url, LOGGER_DEBUG);
1120
1121                         $x = fetch_url($source_url);
1122                         if (!$x)
1123                                 return false;
1124                 }
1125
1126                 $source_xml = parse_xml_string($x, false);
1127
1128                 if (!is_object($source_xml))
1129                         return false;
1130
1131                 if ($source_xml->post->reshare) {
1132                         // Reshare of a reshare - old Diaspora version
1133                         logger("Message is a reshare", LOGGER_DEBUG);
1134                         return self::message($source_xml->post->reshare->root_guid, $server, ++$level);
1135                 } elseif ($source_xml->getName() == "reshare") {
1136                         // Reshare of a reshare - new Diaspora version
1137                         logger("Message is a new reshare", LOGGER_DEBUG);
1138                         return self::message($source_xml->root_guid, $server, ++$level);
1139                 }
1140
1141                 $author = "";
1142
1143                 // Fetch the author - for the old and the new Diaspora version
1144                 if ($source_xml->post->status_message->diaspora_handle)
1145                         $author = (string)$source_xml->post->status_message->diaspora_handle;
1146                 elseif ($source_xml->author AND ($source_xml->getName() == "status_message"))
1147                         $author = (string)$source_xml->author;
1148
1149                 // If this isn't a "status_message" then quit
1150                 if (!$author) {
1151                         logger("Message doesn't seem to be a status message", LOGGER_DEBUG);
1152                         return false;
1153                 }
1154
1155                 $msg = array("message" => $x, "author" => $author);
1156
1157                 $msg["key"] = self::key($msg["author"]);
1158
1159                 return $msg;
1160         }
1161
1162         /**
1163          * @brief Fetches the item record of a given guid
1164          *
1165          * @param int $uid The user id
1166          * @param string $guid message guid
1167          * @param string $author The handle of the item
1168          * @param array $contact The contact of the item owner
1169          *
1170          * @return array the item record
1171          */
1172         private static function parent_item($uid, $guid, $author, $contact) {
1173                 $r = q("SELECT `id`, `body`, `wall`, `uri`, `private`, `origin`,
1174                                 `author-name`, `author-link`, `author-avatar`,
1175                                 `owner-name`, `owner-link`, `owner-avatar`
1176                         FROM `item` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
1177                         intval($uid), dbesc($guid));
1178
1179                 if (!$r) {
1180                         $result = self::store_by_guid($guid, $contact["url"], $uid);
1181
1182                         if (!$result) {
1183                                 $person = self::person_by_handle($author);
1184                                 $result = self::store_by_guid($guid, $person["url"], $uid);
1185                         }
1186
1187                         if ($result) {
1188                                 logger("Fetched missing item ".$guid." - result: ".$result, LOGGER_DEBUG);
1189
1190                                 $r = q("SELECT `id`, `body`, `wall`, `uri`, `private`, `origin`,
1191                                                 `author-name`, `author-link`, `author-avatar`,
1192                                                 `owner-name`, `owner-link`, `owner-avatar`
1193                                         FROM `item` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
1194                                         intval($uid), dbesc($guid));
1195                         }
1196                 }
1197
1198                 if (!$r) {
1199                         logger("parent item not found: parent: ".$guid." - user: ".$uid);
1200                         return false;
1201                 } else {
1202                         logger("parent item found: parent: ".$guid." - user: ".$uid);
1203                         return $r[0];
1204                 }
1205         }
1206
1207         /**
1208          * @brief returns contact details
1209          *
1210          * @param array $contact The default contact if the person isn't found
1211          * @param array $person The record of the person
1212          * @param int $uid The user id
1213          *
1214          * @return array
1215          *      'cid' => contact id
1216          *      'network' => network type
1217          */
1218         private static function author_contact_by_url($contact, $person, $uid) {
1219
1220                 $r = q("SELECT `id`, `network`, `url` FROM `contact` WHERE `nurl` = '%s' AND `uid` = %d LIMIT 1",
1221                         dbesc(normalise_link($person["url"])), intval($uid));
1222                 if ($r) {
1223                         $cid = $r[0]["id"];
1224                         $network = $r[0]["network"];
1225
1226                         // We are receiving content from a user that possibly is about to be terminated
1227                         // This means the user is vital, so we remove a possible termination date.
1228                         unmark_for_death($r[0]);
1229                 } else {
1230                         $cid = $contact["id"];
1231                         $network = NETWORK_DIASPORA;
1232                 }
1233
1234                 return array("cid" => $cid, "network" => $network);
1235         }
1236
1237         /**
1238          * @brief Is the profile a hubzilla profile?
1239          *
1240          * @param string $url The profile link
1241          *
1242          * @return bool is it a hubzilla server?
1243          */
1244         public static function is_redmatrix($url) {
1245                 return(strstr($url, "/channel/"));
1246         }
1247
1248         /**
1249          * @brief Generate a post link with a given handle and message guid
1250          *
1251          * @param string $addr The user handle
1252          * @param string $guid message guid
1253          *
1254          * @return string the post link
1255          */
1256         private static function plink($addr, $guid) {
1257                 $r = q("SELECT `url`, `nick`, `network` FROM `fcontact` WHERE `addr`='%s' LIMIT 1", dbesc($addr));
1258
1259                 // Fallback
1260                 if (!$r)
1261                         return "https://".substr($addr,strpos($addr,"@")+1)."/posts/".$guid;
1262
1263                 // Friendica contacts are often detected as Diaspora contacts in the "fcontact" table
1264                 // So we try another way as well.
1265                 $s = q("SELECT `network` FROM `gcontact` WHERE `nurl`='%s' LIMIT 1", dbesc(normalise_link($r[0]["url"])));
1266                 if ($s)
1267                         $r[0]["network"] = $s[0]["network"];
1268
1269                 if ($r[0]["network"] == NETWORK_DFRN)
1270                         return(str_replace("/profile/".$r[0]["nick"]."/", "/display/".$guid, $r[0]["url"]."/"));
1271
1272                 if (self::is_redmatrix($r[0]["url"]))
1273                         return $r[0]["url"]."/?f=&mid=".$guid;
1274
1275                 return "https://".substr($addr,strpos($addr,"@")+1)."/posts/".$guid;
1276         }
1277
1278         /**
1279          * @brief Processes an account deletion
1280          *
1281          * @param array $importer Array of the importer user
1282          * @param object $data The message object
1283          *
1284          * @return bool Success
1285          */
1286         private static function receive_account_deletion($importer, $data) {
1287
1288                 /// @todo Account deletion should remove the contact from the global contacts as well
1289
1290                 $author = notags(unxmlify($data->author));
1291
1292                 $contact = self::contact_by_handle($importer["uid"], $author);
1293                 if (!$contact) {
1294                         logger("cannot find contact for author: ".$author);
1295                         return false;
1296                 }
1297
1298                 // We now remove the contact
1299                 contact_remove($contact["id"]);
1300                 return true;
1301         }
1302
1303         /**
1304          * @brief Fetch the uri from our database if we already have this item (maybe from ourselves)
1305          *
1306          * @param string $author Author handle
1307          * @param string $guid Message guid
1308          * @param boolean $onlyfound Only return uri when found in the database
1309          *
1310          * @return string The constructed uri or the one from our database
1311          */
1312         private static function get_uri_from_guid($author, $guid, $onlyfound = false) {
1313
1314                 $r = q("SELECT `uri` FROM `item` WHERE `guid` = '%s' LIMIT 1", dbesc($guid));
1315                 if (dbm::is_result($r)) {
1316                         return $r[0]["uri"];
1317                 } elseif (!$onlyfound) {
1318                         return $author.":".$guid;
1319                 }
1320
1321                 return "";
1322         }
1323
1324         /**
1325          * @brief Fetch the guid from our database with a given uri
1326          *
1327          * @param string $author Author handle
1328          * @param string $uri Message uri
1329          *
1330          * @return string The post guid
1331          */
1332         private static function get_guid_from_uri($uri, $uid) {
1333
1334                 $r = q("SELECT `guid` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1", dbesc($uri), intval($uid));
1335                 if (dbm::is_result($r)) {
1336                         return $r[0]["guid"];
1337                 } else {
1338                         return false;
1339                 }
1340         }
1341
1342         /**
1343          * @brief Find the best importer for a comment, like, ...
1344          *
1345          * @param string $guid The guid of the item
1346          *
1347          * @return array|boolean the origin owner of that post - or false
1348          */
1349         private static function importer_for_guid($guid) {
1350                 $item = dba::fetch_first("SELECT `uid` FROM `item` WHERE `origin` AND `guid` = ? LIMIT 1", $guid);
1351
1352                 if (dbm::is_result($item)) {
1353                         logger("Found user ".$item['uid']." as owner of item ".$guid, LOGGER_DEBUG);
1354                         $contact = dba::fetch_first("SELECT * FROM `contact` WHERE `self` AND `uid` = ?", $item['uid']);
1355                         if (dbm::is_result($contact)) {
1356                                 return $contact;
1357                         }
1358                 }
1359                 return false;
1360         }
1361
1362         /**
1363          * @brief Processes an incoming comment
1364          *
1365          * @param array $importer Array of the importer user
1366          * @param string $sender The sender of the message
1367          * @param object $data The message object
1368          * @param string $xml The original XML of the message
1369          *
1370          * @return int The message id of the generated comment or "false" if there was an error
1371          */
1372         private static function receive_comment($importer, $sender, $data, $xml) {
1373                 $author = notags(unxmlify($data->author));
1374                 $guid = notags(unxmlify($data->guid));
1375                 $parent_guid = notags(unxmlify($data->parent_guid));
1376                 $text = unxmlify($data->text);
1377
1378                 if (isset($data->created_at)) {
1379                         $created_at = datetime_convert("UTC", "UTC", notags(unxmlify($data->created_at)));
1380                 } else {
1381                         $created_at = datetime_convert();
1382                 }
1383
1384                 if (isset($data->thread_parent_guid)) {
1385                         $thread_parent_guid = notags(unxmlify($data->thread_parent_guid));
1386                         $thr_uri = self::get_uri_from_guid("", $thread_parent_guid, true);
1387                 } else {
1388                         $thr_uri = "";
1389                 }
1390
1391                 $contact = self::allowed_contact_by_handle($importer, $sender, true);
1392                 if (!$contact) {
1393                         return false;
1394                 }
1395
1396                 $message_id = self::message_exists($importer["uid"], $guid);
1397                 if ($message_id) {
1398                         return $message_id;
1399                 }
1400
1401                 $parent_item = self::parent_item($importer["uid"], $parent_guid, $author, $contact);
1402                 if (!$parent_item) {
1403                         return false;
1404                 }
1405
1406                 $person = self::person_by_handle($author);
1407                 if (!is_array($person)) {
1408                         logger("unable to find author details");
1409                         return false;
1410                 }
1411
1412                 // Fetch the contact id - if we know this contact
1413                 $author_contact = self::author_contact_by_url($contact, $person, $importer["uid"]);
1414
1415                 $datarray = array();
1416
1417                 $datarray["uid"] = $importer["uid"];
1418                 $datarray["contact-id"] = $author_contact["cid"];
1419                 $datarray["network"]  = $author_contact["network"];
1420
1421                 $datarray["author-name"] = $person["name"];
1422                 $datarray["author-link"] = $person["url"];
1423                 $datarray["author-avatar"] = ((x($person,"thumb")) ? $person["thumb"] : $person["photo"]);
1424
1425                 $datarray["owner-name"] = $contact["name"];
1426                 $datarray["owner-link"] = $contact["url"];
1427                 $datarray["owner-avatar"] = ((x($contact,"thumb")) ? $contact["thumb"] : $contact["photo"]);
1428
1429                 $datarray["guid"] = $guid;
1430                 $datarray["uri"] = self::get_uri_from_guid($author, $guid);
1431
1432                 $datarray["type"] = "remote-comment";
1433                 $datarray["verb"] = ACTIVITY_POST;
1434                 $datarray["gravity"] = GRAVITY_COMMENT;
1435
1436                 if ($thr_uri != "") {
1437                         $datarray["parent-uri"] = $thr_uri;
1438                 } else {
1439                         $datarray["parent-uri"] = $parent_item["uri"];
1440                 }
1441
1442                 $datarray["object-type"] = ACTIVITY_OBJ_COMMENT;
1443
1444                 $datarray["protocol"] = PROTOCOL_DIASPORA;
1445                 $datarray["source"] = $xml;
1446
1447                 $datarray["changed"] = $datarray["created"] = $datarray["edited"] = $created_at;
1448
1449                 $body = diaspora2bb($text);
1450
1451                 $datarray["body"] = self::replace_people_guid($body, $person["url"]);
1452
1453                 self::fetch_guid($datarray);
1454
1455                 $message_id = item_store($datarray);
1456
1457                 if ($message_id) {
1458                         logger("Stored comment ".$datarray["guid"]." with message id ".$message_id, LOGGER_DEBUG);
1459                 }
1460
1461                 // If we are the origin of the parent we store the original data and notify our followers
1462                 if ($message_id AND $parent_item["origin"]) {
1463
1464                         // Formerly we stored the signed text, the signature and the author in different fields.
1465                         // We now store the raw data so that we are more flexible.
1466                         q("INSERT INTO `sign` (`iid`,`signed_text`) VALUES (%d,'%s')",
1467                                 intval($message_id),
1468                                 dbesc(json_encode($data))
1469                         );
1470
1471                         // notify others
1472                         proc_run(PRIORITY_HIGH, "include/notifier.php", "comment-import", $message_id);
1473                 }
1474
1475                 return $message_id;
1476         }
1477
1478         /**
1479          * @brief processes and stores private messages
1480          *
1481          * @param array $importer Array of the importer user
1482          * @param array $contact The contact of the message
1483          * @param object $data The message object
1484          * @param array $msg Array of the processed message, author handle and key
1485          * @param object $mesg The private message
1486          * @param array $conversation The conversation record to which this message belongs
1487          *
1488          * @return bool "true" if it was successful
1489          */
1490         private static function receive_conversation_message($importer, $contact, $data, $msg, $mesg, $conversation) {
1491                 $author = notags(unxmlify($data->author));
1492                 $guid = notags(unxmlify($data->guid));
1493                 $subject = notags(unxmlify($data->subject));
1494
1495                 // "diaspora_handle" is the element name from the old version
1496                 // "author" is the element name from the new version
1497                 if ($mesg->author) {
1498                         $msg_author = notags(unxmlify($mesg->author));
1499                 } elseif ($mesg->diaspora_handle) {
1500                         $msg_author = notags(unxmlify($mesg->diaspora_handle));
1501                 } else {
1502                         return false;
1503                 }
1504
1505                 $msg_guid = notags(unxmlify($mesg->guid));
1506                 $msg_conversation_guid = notags(unxmlify($mesg->conversation_guid));
1507                 $msg_text = unxmlify($mesg->text);
1508                 $msg_created_at = datetime_convert("UTC", "UTC", notags(unxmlify($mesg->created_at)));
1509
1510                 if ($msg_conversation_guid != $guid) {
1511                         logger("message conversation guid does not belong to the current conversation.");
1512                         return false;
1513                 }
1514
1515                 $body = diaspora2bb($msg_text);
1516                 $message_uri = $msg_author.":".$msg_guid;
1517
1518                 $person = self::person_by_handle($msg_author);
1519
1520                 $r = q("SELECT `id` FROM `mail` WHERE `uri` = '%s' LIMIT 1",
1521                         dbesc($message_uri)
1522                 );
1523                 if (dbm::is_result($r)) {
1524                         logger("duplicate message already delivered.", LOGGER_DEBUG);
1525                         return false;
1526                 }
1527
1528                 q("INSERT INTO `mail` (`uid`, `guid`, `convid`, `from-name`,`from-photo`,`from-url`,`contact-id`,`title`,`body`,`seen`,`reply`,`uri`,`parent-uri`,`created`)
1529                         VALUES (%d, '%s', %d, '%s', '%s', '%s', %d, '%s', '%s', %d, %d, '%s','%s','%s')",
1530                         intval($importer["uid"]),
1531                         dbesc($msg_guid),
1532                         intval($conversation["id"]),
1533                         dbesc($person["name"]),
1534                         dbesc($person["photo"]),
1535                         dbesc($person["url"]),
1536                         intval($contact["id"]),
1537                         dbesc($subject),
1538                         dbesc($body),
1539                         0,
1540                         0,
1541                         dbesc($message_uri),
1542                         dbesc($author.":".$guid),
1543                         dbesc($msg_created_at)
1544                 );
1545
1546                 q("UPDATE `conv` SET `updated` = '%s' WHERE `id` = %d",
1547                         dbesc(datetime_convert()),
1548                         intval($conversation["id"])
1549                 );
1550
1551                 notification(array(
1552                         "type" => NOTIFY_MAIL,
1553                         "notify_flags" => $importer["notify-flags"],
1554                         "language" => $importer["language"],
1555                         "to_name" => $importer["username"],
1556                         "to_email" => $importer["email"],
1557                         "uid" =>$importer["uid"],
1558                         "item" => array("subject" => $subject, "body" => $body),
1559                         "source_name" => $person["name"],
1560                         "source_link" => $person["url"],
1561                         "source_photo" => $person["thumb"],
1562                         "verb" => ACTIVITY_POST,
1563                         "otype" => "mail"
1564                 ));
1565                 return true;
1566         }
1567
1568         /**
1569          * @brief Processes new private messages (answers to private messages are processed elsewhere)
1570          *
1571          * @param array $importer Array of the importer user
1572          * @param array $msg Array of the processed message, author handle and key
1573          * @param object $data The message object
1574          *
1575          * @return bool Success
1576          */
1577         private static function receive_conversation($importer, $msg, $data) {
1578                 $author = notags(unxmlify($data->author));
1579                 $guid = notags(unxmlify($data->guid));
1580                 $subject = notags(unxmlify($data->subject));
1581                 $created_at = datetime_convert("UTC", "UTC", notags(unxmlify($data->created_at)));
1582                 $participants = notags(unxmlify($data->participants));
1583
1584                 $messages = $data->message;
1585
1586                 if (!count($messages)) {
1587                         logger("empty conversation");
1588                         return false;
1589                 }
1590
1591                 $contact = self::allowed_contact_by_handle($importer, $msg["author"], true);
1592                 if (!$contact)
1593                         return false;
1594
1595                 $conversation = null;
1596
1597                 $c = q("SELECT * FROM `conv` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
1598                         intval($importer["uid"]),
1599                         dbesc($guid)
1600                 );
1601                 if ($c)
1602                         $conversation = $c[0];
1603                 else {
1604                         $r = q("INSERT INTO `conv` (`uid`, `guid`, `creator`, `created`, `updated`, `subject`, `recips`)
1605                                 VALUES (%d, '%s', '%s', '%s', '%s', '%s', '%s')",
1606                                 intval($importer["uid"]),
1607                                 dbesc($guid),
1608                                 dbesc($author),
1609                                 dbesc($created_at),
1610                                 dbesc(datetime_convert()),
1611                                 dbesc($subject),
1612                                 dbesc($participants)
1613                         );
1614                         if ($r)
1615                                 $c = q("SELECT * FROM `conv` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
1616                                         intval($importer["uid"]),
1617                                         dbesc($guid)
1618                                 );
1619
1620                         if ($c)
1621                                 $conversation = $c[0];
1622                 }
1623                 if (!$conversation) {
1624                         logger("unable to create conversation.");
1625                         return;
1626                 }
1627
1628                 foreach ($messages as $mesg)
1629                         self::receive_conversation_message($importer, $contact, $data, $msg, $mesg, $conversation);
1630
1631                 return true;
1632         }
1633
1634         /**
1635          * @brief Creates the body for a "like" message
1636          *
1637          * @param array $contact The contact that send us the "like"
1638          * @param array $parent_item The item array of the parent item
1639          * @param string $guid message guid
1640          *
1641          * @return string the body
1642          */
1643         private static function construct_like_body($contact, $parent_item, $guid) {
1644                 $bodyverb = t('%1$s likes %2$s\'s %3$s');
1645
1646                 $ulink = "[url=".$contact["url"]."]".$contact["name"]."[/url]";
1647                 $alink = "[url=".$parent_item["author-link"]."]".$parent_item["author-name"]."[/url]";
1648                 $plink = "[url=".App::get_baseurl()."/display/".urlencode($guid)."]".t("status")."[/url]";
1649
1650                 return sprintf($bodyverb, $ulink, $alink, $plink);
1651         }
1652
1653         /**
1654          * @brief Creates a XML object for a "like"
1655          *
1656          * @param array $importer Array of the importer user
1657          * @param array $parent_item The item array of the parent item
1658          *
1659          * @return string The XML
1660          */
1661         private static function construct_like_object($importer, $parent_item) {
1662                 $objtype = ACTIVITY_OBJ_NOTE;
1663                 $link = '<link rel="alternate" type="text/html" href="'.App::get_baseurl()."/display/".$importer["nickname"]."/".$parent_item["id"].'" />';
1664                 $parent_body = $parent_item["body"];
1665
1666                 $xmldata = array("object" => array("type" => $objtype,
1667                                                 "local" => "1",
1668                                                 "id" => $parent_item["uri"],
1669                                                 "link" => $link,
1670                                                 "title" => "",
1671                                                 "content" => $parent_body));
1672
1673                 return xml::from_array($xmldata, $xml, true);
1674         }
1675
1676         /**
1677          * @brief Processes "like" messages
1678          *
1679          * @param array $importer Array of the importer user
1680          * @param string $sender The sender of the message
1681          * @param object $data The message object
1682          *
1683          * @return int The message id of the generated like or "false" if there was an error
1684          */
1685         private static function receive_like($importer, $sender, $data) {
1686                 $author = notags(unxmlify($data->author));
1687                 $guid = notags(unxmlify($data->guid));
1688                 $parent_guid = notags(unxmlify($data->parent_guid));
1689                 $parent_type = notags(unxmlify($data->parent_type));
1690                 $positive = notags(unxmlify($data->positive));
1691
1692                 // likes on comments aren't supported by Diaspora - only on posts
1693                 // But maybe this will be supported in the future, so we will accept it.
1694                 if (!in_array($parent_type, array("Post", "Comment")))
1695                         return false;
1696
1697                 $contact = self::allowed_contact_by_handle($importer, $sender, true);
1698                 if (!$contact)
1699                         return false;
1700
1701                 $message_id = self::message_exists($importer["uid"], $guid);
1702                 if ($message_id)
1703                         return $message_id;
1704
1705                 $parent_item = self::parent_item($importer["uid"], $parent_guid, $author, $contact);
1706                 if (!$parent_item)
1707                         return false;
1708
1709                 $person = self::person_by_handle($author);
1710                 if (!is_array($person)) {
1711                         logger("unable to find author details");
1712                         return false;
1713                 }
1714
1715                 // Fetch the contact id - if we know this contact
1716                 $author_contact = self::author_contact_by_url($contact, $person, $importer["uid"]);
1717
1718                 // "positive" = "false" would be a Dislike - wich isn't currently supported by Diaspora
1719                 // We would accept this anyhow.
1720                 if ($positive == "true")
1721                         $verb = ACTIVITY_LIKE;
1722                 else
1723                         $verb = ACTIVITY_DISLIKE;
1724
1725                 $datarray = array();
1726
1727                 $datarray["protocol"] = PROTOCOL_DIASPORA;
1728
1729                 $datarray["uid"] = $importer["uid"];
1730                 $datarray["contact-id"] = $author_contact["cid"];
1731                 $datarray["network"]  = $author_contact["network"];
1732
1733                 $datarray["author-name"] = $person["name"];
1734                 $datarray["author-link"] = $person["url"];
1735                 $datarray["author-avatar"] = ((x($person,"thumb")) ? $person["thumb"] : $person["photo"]);
1736
1737                 $datarray["owner-name"] = $contact["name"];
1738                 $datarray["owner-link"] = $contact["url"];
1739                 $datarray["owner-avatar"] = ((x($contact,"thumb")) ? $contact["thumb"] : $contact["photo"]);
1740
1741                 $datarray["guid"] = $guid;
1742                 $datarray["uri"] = self::get_uri_from_guid($author, $guid);
1743
1744                 $datarray["type"] = "activity";
1745                 $datarray["verb"] = $verb;
1746                 $datarray["gravity"] = GRAVITY_LIKE;
1747                 $datarray["parent-uri"] = $parent_item["uri"];
1748
1749                 $datarray["object-type"] = ACTIVITY_OBJ_NOTE;
1750                 $datarray["object"] = self::construct_like_object($importer, $parent_item);
1751
1752                 $datarray["body"] = self::construct_like_body($contact, $parent_item, $guid);
1753
1754                 $message_id = item_store($datarray);
1755
1756                 if ($message_id)
1757                         logger("Stored like ".$datarray["guid"]." with message id ".$message_id, LOGGER_DEBUG);
1758
1759                 // If we are the origin of the parent we store the original data and notify our followers
1760                 if ($message_id AND $parent_item["origin"]) {
1761
1762                         // Formerly we stored the signed text, the signature and the author in different fields.
1763                         // We now store the raw data so that we are more flexible.
1764                         q("INSERT INTO `sign` (`iid`,`signed_text`) VALUES (%d,'%s')",
1765                                 intval($message_id),
1766                                 dbesc(json_encode($data))
1767                         );
1768
1769                         // notify others
1770                         proc_run(PRIORITY_HIGH, "include/notifier.php", "comment-import", $message_id);
1771                 }
1772
1773                 return $message_id;
1774         }
1775
1776         /**
1777          * @brief Processes private messages
1778          *
1779          * @param array $importer Array of the importer user
1780          * @param object $data The message object
1781          *
1782          * @return bool Success?
1783          */
1784         private static function receive_message($importer, $data) {
1785                 $author = notags(unxmlify($data->author));
1786                 $guid = notags(unxmlify($data->guid));
1787                 $conversation_guid = notags(unxmlify($data->conversation_guid));
1788                 $text = unxmlify($data->text);
1789                 $created_at = datetime_convert("UTC", "UTC", notags(unxmlify($data->created_at)));
1790
1791                 $contact = self::allowed_contact_by_handle($importer, $author, true);
1792                 if (!$contact) {
1793                         return false;
1794                 }
1795
1796                 $conversation = null;
1797
1798                 $c = q("SELECT * FROM `conv` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
1799                         intval($importer["uid"]),
1800                         dbesc($conversation_guid)
1801                 );
1802                 if ($c) {
1803                         $conversation = $c[0];
1804                 } else {
1805                         logger("conversation not available.");
1806                         return false;
1807                 }
1808
1809                 $message_uri = $author.":".$guid;
1810
1811                 $person = self::person_by_handle($author);
1812                 if (!$person) {
1813                         logger("unable to find author details");
1814                         return false;
1815                 }
1816
1817                 $r = q("SELECT `id` FROM `mail` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
1818                         dbesc($message_uri),
1819                         intval($importer["uid"])
1820                 );
1821                 if (dbm::is_result($r)) {
1822                         logger("duplicate message already delivered.", LOGGER_DEBUG);
1823                         return false;
1824                 }
1825
1826                 $body = diaspora2bb($text);
1827
1828                 $body = self::replace_people_guid($body, $person["url"]);
1829
1830                 q("INSERT INTO `mail` (`uid`, `guid`, `convid`, `from-name`,`from-photo`,`from-url`,`contact-id`,`title`,`body`,`seen`,`reply`,`uri`,`parent-uri`,`created`)
1831                                 VALUES ( %d, '%s', %d, '%s', '%s', '%s', %d, '%s', '%s', %d, %d, '%s','%s','%s')",
1832                         intval($importer["uid"]),
1833                         dbesc($guid),
1834                         intval($conversation["id"]),
1835                         dbesc($person["name"]),
1836                         dbesc($person["photo"]),
1837                         dbesc($person["url"]),
1838                         intval($contact["id"]),
1839                         dbesc($conversation["subject"]),
1840                         dbesc($body),
1841                         0,
1842                         1,
1843                         dbesc($message_uri),
1844                         dbesc($author.":".$conversation["guid"]),
1845                         dbesc($created_at)
1846                 );
1847
1848                 q("UPDATE `conv` SET `updated` = '%s' WHERE `id` = %d",
1849                         dbesc(datetime_convert()),
1850                         intval($conversation["id"])
1851                 );
1852
1853                 return true;
1854         }
1855
1856         /**
1857          * @brief Processes participations - unsupported by now
1858          *
1859          * @param array $importer Array of the importer user
1860          * @param object $data The message object
1861          *
1862          * @return bool always true
1863          */
1864         private static function receive_participation($importer, $data) {
1865                 // I'm not sure if we can fully support this message type
1866                 return true;
1867         }
1868
1869         /**
1870          * @brief Processes photos - unneeded
1871          *
1872          * @param array $importer Array of the importer user
1873          * @param object $data The message object
1874          *
1875          * @return bool always true
1876          */
1877         private static function receive_photo($importer, $data) {
1878                 // There doesn't seem to be a reason for this function, since the photo data is transmitted in the status message as well
1879                 return true;
1880         }
1881
1882         /**
1883          * @brief Processes poll participations - unssupported
1884          *
1885          * @param array $importer Array of the importer user
1886          * @param object $data The message object
1887          *
1888          * @return bool always true
1889          */
1890         private static function receive_poll_participation($importer, $data) {
1891                 // We don't support polls by now
1892                 return true;
1893         }
1894
1895         /**
1896          * @brief Processes incoming profile updates
1897          *
1898          * @param array $importer Array of the importer user
1899          * @param object $data The message object
1900          *
1901          * @return bool Success
1902          */
1903         private static function receive_profile($importer, $data) {
1904                 $author = strtolower(notags(unxmlify($data->author)));
1905
1906                 $contact = self::contact_by_handle($importer["uid"], $author);
1907                 if (!$contact)
1908                         return false;
1909
1910                 $name = unxmlify($data->first_name).((strlen($data->last_name)) ? " ".unxmlify($data->last_name) : "");
1911                 $image_url = unxmlify($data->image_url);
1912                 $birthday = unxmlify($data->birthday);
1913                 $gender = unxmlify($data->gender);
1914                 $about = diaspora2bb(unxmlify($data->bio));
1915                 $location = diaspora2bb(unxmlify($data->location));
1916                 $searchable = (unxmlify($data->searchable) == "true");
1917                 $nsfw = (unxmlify($data->nsfw) == "true");
1918                 $tags = unxmlify($data->tag_string);
1919
1920                 $tags = explode("#", $tags);
1921
1922                 $keywords = array();
1923                 foreach ($tags as $tag) {
1924                         $tag = trim(strtolower($tag));
1925                         if ($tag != "")
1926                                 $keywords[] = $tag;
1927                 }
1928
1929                 $keywords = implode(", ", $keywords);
1930
1931                 $handle_parts = explode("@", $author);
1932                 $nick = $handle_parts[0];
1933
1934                 if ($name === "")
1935                         $name = $handle_parts[0];
1936
1937                 if ( preg_match("|^https?://|", $image_url) === 0)
1938                         $image_url = "http://".$handle_parts[1].$image_url;
1939
1940                 update_contact_avatar($image_url, $importer["uid"], $contact["id"]);
1941
1942                 // Generic birthday. We don't know the timezone. The year is irrelevant.
1943
1944                 $birthday = str_replace("1000", "1901", $birthday);
1945
1946                 if ($birthday != "")
1947                         $birthday = datetime_convert("UTC", "UTC", $birthday, "Y-m-d");
1948
1949                 // this is to prevent multiple birthday notifications in a single year
1950                 // if we already have a stored birthday and the 'm-d' part hasn't changed, preserve the entry, which will preserve the notify year
1951
1952                 if (substr($birthday,5) === substr($contact["bd"],5))
1953                         $birthday = $contact["bd"];
1954
1955                 $r = q("UPDATE `contact` SET `name` = '%s', `nick` = '%s', `addr` = '%s', `name-date` = '%s', `bd` = '%s',
1956                                 `location` = '%s', `about` = '%s', `keywords` = '%s', `gender` = '%s' WHERE `id` = %d AND `uid` = %d",
1957                         dbesc($name),
1958                         dbesc($nick),
1959                         dbesc($author),
1960                         dbesc(datetime_convert()),
1961                         dbesc($birthday),
1962                         dbesc($location),
1963                         dbesc($about),
1964                         dbesc($keywords),
1965                         dbesc($gender),
1966                         intval($contact["id"]),
1967                         intval($importer["uid"])
1968                 );
1969
1970                 $gcontact = array("url" => $contact["url"], "network" => NETWORK_DIASPORA, "generation" => 2,
1971                                         "photo" => $image_url, "name" => $name, "location" => $location,
1972                                         "about" => $about, "birthday" => $birthday, "gender" => $gender,
1973                                         "addr" => $author, "nick" => $nick, "keywords" => $keywords,
1974                                         "hide" => !$searchable, "nsfw" => $nsfw);
1975
1976                 $gcid = update_gcontact($gcontact);
1977
1978                 link_gcontact($gcid, $importer["uid"], $contact["id"]);
1979
1980                 logger("Profile of contact ".$contact["id"]." stored for user ".$importer["uid"], LOGGER_DEBUG);
1981
1982                 return true;
1983         }
1984
1985         /**
1986          * @brief Processes incoming friend requests
1987          *
1988          * @param array $importer Array of the importer user
1989          * @param array $contact The contact that send the request
1990          */
1991         private static function receive_request_make_friend($importer, $contact) {
1992
1993                 $a = get_app();
1994
1995                 if ($contact["rel"] == CONTACT_IS_FOLLOWER && in_array($importer["page-flags"], array(PAGE_FREELOVE))) {
1996                         q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
1997                                 intval(CONTACT_IS_FRIEND),
1998                                 intval($contact["id"]),
1999                                 intval($importer["uid"])
2000                         );
2001                 }
2002                 // send notification
2003
2004                 $r = q("SELECT `hide-friends` FROM `profile` WHERE `uid` = %d AND `is-default` = 1 LIMIT 1",
2005                         intval($importer["uid"])
2006                 );
2007
2008                 if ($r && !$r[0]["hide-friends"] && !$contact["hidden"] && intval(get_pconfig($importer["uid"], "system", "post_newfriend"))) {
2009
2010                         $self = q("SELECT * FROM `contact` WHERE `self` AND `uid` = %d LIMIT 1",
2011                                 intval($importer["uid"])
2012                         );
2013
2014                         // they are not CONTACT_IS_FOLLOWER anymore but that's what we have in the array
2015
2016                         if ($self && $contact["rel"] == CONTACT_IS_FOLLOWER) {
2017
2018                                 $arr = array();
2019                                 $arr["protocol"] = PROTOCOL_DIASPORA;
2020                                 $arr["uri"] = $arr["parent-uri"] = item_new_uri($a->get_hostname(), $importer["uid"]);
2021                                 $arr["uid"] = $importer["uid"];
2022                                 $arr["contact-id"] = $self[0]["id"];
2023                                 $arr["wall"] = 1;
2024                                 $arr["type"] = 'wall';
2025                                 $arr["gravity"] = 0;
2026                                 $arr["origin"] = 1;
2027                                 $arr["author-name"] = $arr["owner-name"] = $self[0]["name"];
2028                                 $arr["author-link"] = $arr["owner-link"] = $self[0]["url"];
2029                                 $arr["author-avatar"] = $arr["owner-avatar"] = $self[0]["thumb"];
2030                                 $arr["verb"] = ACTIVITY_FRIEND;
2031                                 $arr["object-type"] = ACTIVITY_OBJ_PERSON;
2032
2033                                 $A = "[url=".$self[0]["url"]."]".$self[0]["name"]."[/url]";
2034                                 $B = "[url=".$contact["url"]."]".$contact["name"]."[/url]";
2035                                 $BPhoto = "[url=".$contact["url"]."][img]".$contact["thumb"]."[/img][/url]";
2036                                 $arr["body"] = sprintf(t("%1$s is now friends with %2$s"), $A, $B)."\n\n\n".$Bphoto;
2037
2038                                 $arr["object"] = self::construct_new_friend_object($contact);
2039
2040                                 $arr["last-child"] = 1;
2041
2042                                 $arr["allow_cid"] = $user[0]["allow_cid"];
2043                                 $arr["allow_gid"] = $user[0]["allow_gid"];
2044                                 $arr["deny_cid"]  = $user[0]["deny_cid"];
2045                                 $arr["deny_gid"]  = $user[0]["deny_gid"];
2046
2047                                 $i = item_store($arr);
2048                                 if ($i)
2049                                         proc_run(PRIORITY_HIGH, "include/notifier.php", "activity", $i);
2050                         }
2051                 }
2052         }
2053
2054         /**
2055          * @brief Creates a XML object for a "new friend" message
2056          *
2057          * @param array $contact Array of the contact
2058          *
2059          * @return string The XML
2060          */
2061         private static function construct_new_friend_object($contact) {
2062                 $objtype = ACTIVITY_OBJ_PERSON;
2063                 $link = '<link rel="alternate" type="text/html" href="'.$contact["url"].'" />'."\n".
2064                         '<link rel="photo" type="image/jpeg" href="'.$contact["thumb"].'" />'."\n";
2065
2066                 $xmldata = array("object" => array("type" => $objtype,
2067                                                 "title" => $contact["name"],
2068                                                 "id" => $contact["url"]."/".$contact["name"],
2069                                                 "link" => $link));
2070
2071                 return xml::from_array($xmldata, $xml, true);
2072         }
2073
2074         /**
2075          * @brief Processes incoming sharing notification
2076          *
2077          * @param array $importer Array of the importer user
2078          * @param object $data The message object
2079          *
2080          * @return bool Success
2081          */
2082         private static function receive_contact_request($importer, $data) {
2083                 $author = unxmlify($data->author);
2084                 $recipient = unxmlify($data->recipient);
2085
2086                 if (!$author || !$recipient) {
2087                         return false;
2088                 }
2089
2090                 // the current protocol version doesn't know these fields
2091                 // That means that we will assume their existance
2092                 if (isset($data->following)) {
2093                         $following = (unxmlify($data->following) == "true");
2094                 } else {
2095                         $following = true;
2096                 }
2097
2098                 if (isset($data->sharing)) {
2099                         $sharing = (unxmlify($data->sharing) == "true");
2100                 } else {
2101                         $sharing = true;
2102                 }
2103
2104                 $contact = self::contact_by_handle($importer["uid"],$author);
2105
2106                 // perhaps we were already sharing with this person. Now they're sharing with us.
2107                 // That makes us friends.
2108                 if ($contact) {
2109                         if ($following AND $sharing) {
2110                                 logger("Author ".$author." (Contact ".$contact["id"].") wants to have a bidirectional conection.", LOGGER_DEBUG);
2111                                 self::receive_request_make_friend($importer, $contact);
2112
2113                                 // refetch the contact array
2114                                 $contact = self::contact_by_handle($importer["uid"],$author);
2115
2116                                 // If we are now friends, we are sending a share message.
2117                                 // Normally we needn't to do so, but the first message could have been vanished.
2118                                 if (in_array($contact["rel"], array(CONTACT_IS_FRIEND, CONTACT_IS_FOLLOWER))) {
2119                                         $u = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval($importer["uid"]));
2120                                         if ($u) {
2121                                                 logger("Sending share message to author ".$author." - Contact: ".$contact["id"]." - User: ".$importer["uid"], LOGGER_DEBUG);
2122                                                 $ret = self::send_share($u[0], $contact);
2123                                         }
2124                                 }
2125                                 return true;
2126                         } else { /// @todo Handle all possible variations of adding and retracting of permissions
2127                                 logger("Author ".$author." (Contact ".$contact["id"].") wants to change the relationship: Following: ".$following." - sharing: ".$sharing. "(By now unsupported)", LOGGER_DEBUG);
2128                                 return false;
2129                         }
2130                 }
2131
2132                 if (!$following AND $sharing AND in_array($importer["page-flags"], array(PAGE_SOAPBOX, PAGE_NORMAL))) {
2133                         logger("Author ".$author." wants to share with us - but doesn't want to listen. Request is ignored.", LOGGER_DEBUG);
2134                         return false;
2135                 } elseif (!$following AND !$sharing) {
2136                         logger("Author ".$author." doesn't want anything - and we don't know the author. Request is ignored.", LOGGER_DEBUG);
2137                         return false;
2138                 } elseif (!$following AND $sharing) {
2139                         logger("Author ".$author." wants to share with us.", LOGGER_DEBUG);
2140                 } elseif ($following AND $sharing) {
2141                         logger("Author ".$author." wants to have a bidirectional conection.", LOGGER_DEBUG);
2142                 } elseif ($following AND !$sharing) {
2143                         logger("Author ".$author." wants to listen to us.", LOGGER_DEBUG);
2144                 }
2145
2146                 $ret = self::person_by_handle($author);
2147
2148                 if (!$ret || ($ret["network"] != NETWORK_DIASPORA)) {
2149                         logger("Cannot resolve diaspora handle ".$author." for ".$recipient);
2150                         return false;
2151                 }
2152
2153                 $batch = (($ret["batch"]) ? $ret["batch"] : implode("/", array_slice(explode("/", $ret["url"]), 0, 3))."/receive/public");
2154
2155                 $r = q("INSERT INTO `contact` (`uid`, `network`,`addr`,`created`,`url`,`nurl`,`batch`,`name`,`nick`,`photo`,`pubkey`,`notify`,`poll`,`blocked`,`priority`)
2156                         VALUES (%d, '%s', '%s', '%s', '%s','%s','%s','%s','%s','%s','%s','%s','%s',%d,%d)",
2157                         intval($importer["uid"]),
2158                         dbesc($ret["network"]),
2159                         dbesc($ret["addr"]),
2160                         datetime_convert(),
2161                         dbesc($ret["url"]),
2162                         dbesc(normalise_link($ret["url"])),
2163                         dbesc($batch),
2164                         dbesc($ret["name"]),
2165                         dbesc($ret["nick"]),
2166                         dbesc($ret["photo"]),
2167                         dbesc($ret["pubkey"]),
2168                         dbesc($ret["notify"]),
2169                         dbesc($ret["poll"]),
2170                         1,
2171                         2
2172                 );
2173
2174                 // find the contact record we just created
2175
2176                 $contact_record = self::contact_by_handle($importer["uid"],$author);
2177
2178                 if (!$contact_record) {
2179                         logger("unable to locate newly created contact record.");
2180                         return;
2181                 }
2182
2183                 logger("Author ".$author." was added as contact number ".$contact_record["id"].".", LOGGER_DEBUG);
2184
2185                 $def_gid = get_default_group($importer['uid'], $ret["network"]);
2186
2187                 if (intval($def_gid))
2188                         group_add_member($importer["uid"], "", $contact_record["id"], $def_gid);
2189
2190                 update_contact_avatar($ret["photo"], $importer['uid'], $contact_record["id"], true);
2191
2192                 if ($importer["page-flags"] == PAGE_NORMAL) {
2193
2194                         logger("Sending intra message for author ".$author.".", LOGGER_DEBUG);
2195
2196                         $hash = random_string().(string)time();   // Generate a confirm_key
2197
2198                         $ret = q("INSERT INTO `intro` (`uid`, `contact-id`, `blocked`, `knowyou`, `note`, `hash`, `datetime`)
2199                                 VALUES (%d, %d, %d, %d, '%s', '%s', '%s')",
2200                                 intval($importer["uid"]),
2201                                 intval($contact_record["id"]),
2202                                 0,
2203                                 0,
2204                                 dbesc(t("Sharing notification from Diaspora network")),
2205                                 dbesc($hash),
2206                                 dbesc(datetime_convert())
2207                         );
2208                 } else {
2209
2210                         // automatic friend approval
2211
2212                         logger("Does an automatic friend approval for author ".$author.".", LOGGER_DEBUG);
2213
2214                         update_contact_avatar($contact_record["photo"],$importer["uid"],$contact_record["id"]);
2215
2216                         // technically they are sharing with us (CONTACT_IS_SHARING),
2217                         // but if our page-type is PAGE_COMMUNITY or PAGE_SOAPBOX
2218                         // we are going to change the relationship and make them a follower.
2219
2220                         if (($importer["page-flags"] == PAGE_FREELOVE) AND $sharing AND $following)
2221                                 $new_relation = CONTACT_IS_FRIEND;
2222                         elseif (($importer["page-flags"] == PAGE_FREELOVE) AND $sharing)
2223                                 $new_relation = CONTACT_IS_SHARING;
2224                         else
2225                                 $new_relation = CONTACT_IS_FOLLOWER;
2226
2227                         $r = q("UPDATE `contact` SET `rel` = %d,
2228                                 `name-date` = '%s',
2229                                 `uri-date` = '%s',
2230                                 `blocked` = 0,
2231                                 `pending` = 0,
2232                                 `writable` = 1
2233                                 WHERE `id` = %d
2234                                 ",
2235                                 intval($new_relation),
2236                                 dbesc(datetime_convert()),
2237                                 dbesc(datetime_convert()),
2238                                 intval($contact_record["id"])
2239                         );
2240
2241                         $u = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval($importer["uid"]));
2242                         if ($u) {
2243                                 logger("Sending share message (Relation: ".$new_relation.") to author ".$author." - Contact: ".$contact_record["id"]." - User: ".$importer["uid"], LOGGER_DEBUG);
2244                                 $ret = self::send_share($u[0], $contact_record);
2245
2246                                 // Send the profile data, maybe it weren't transmitted before
2247                                 self::send_profile($importer["uid"], array($contact_record));
2248                         }
2249                 }
2250
2251                 return true;
2252         }
2253
2254         /**
2255          * @brief Fetches a message with a given guid
2256          *
2257          * @param string $guid message guid
2258          * @param string $orig_author handle of the original post
2259          * @param string $author handle of the sharer
2260          *
2261          * @return array The fetched item
2262          */
2263         private static function original_item($guid, $orig_author, $author) {
2264
2265                 // Do we already have this item?
2266                 $r = q("SELECT `body`, `tag`, `app`, `created`, `object-type`, `uri`, `guid`,
2267                                 `author-name`, `author-link`, `author-avatar`
2268                                 FROM `item` WHERE `guid` = '%s' AND `visible` AND NOT `deleted` AND `body` != '' LIMIT 1",
2269                         dbesc($guid));
2270
2271                 if (dbm::is_result($r)) {
2272                         logger("reshared message ".$guid." already exists on system.");
2273
2274                         // Maybe it is already a reshared item?
2275                         // Then refetch the content, if it is a reshare from a reshare.
2276                         // If it is a reshared post from another network then reformat to avoid display problems with two share elements
2277                         if (self::is_reshare($r[0]["body"], true)) {
2278                                 $r = array();
2279                         } elseif (self::is_reshare($r[0]["body"], false)) {
2280                                 $r[0]["body"] = diaspora2bb(bb2diaspora($r[0]["body"]));
2281
2282                                 $r[0]["body"] = self::replace_people_guid($r[0]["body"], $r[0]["author-link"]);
2283
2284                                 // Add OEmbed and other information to the body
2285                                 $r[0]["body"] = add_page_info_to_body($r[0]["body"], false, true);
2286
2287                                 return $r[0];
2288                         } else {
2289                                 return $r[0];
2290                         }
2291                 }
2292
2293                 if (!dbm::is_result($r)) {
2294                         $server = "https://".substr($orig_author, strpos($orig_author, "@") + 1);
2295                         logger("1st try: reshared message ".$guid." will be fetched via SSL from the server ".$server);
2296                         $item_id = self::store_by_guid($guid, $server);
2297
2298                         if (!$item_id) {
2299                                 $server = "http://".substr($orig_author, strpos($orig_author, "@") + 1);
2300                                 logger("2nd try: reshared message ".$guid." will be fetched without SLL from the server ".$server);
2301                                 $item_id = self::store_by_guid($guid, $server);
2302                         }
2303
2304                         if ($item_id) {
2305                                 $r = q("SELECT `body`, `tag`, `app`, `created`, `object-type`, `uri`, `guid`,
2306                                                 `author-name`, `author-link`, `author-avatar`
2307                                         FROM `item` WHERE `id` = %d AND `visible` AND NOT `deleted` AND `body` != '' LIMIT 1",
2308                                         intval($item_id));
2309
2310                                 if (dbm::is_result($r)) {
2311                                         // If it is a reshared post from another network then reformat to avoid display problems with two share elements
2312                                         if (self::is_reshare($r[0]["body"], false)) {
2313                                                 $r[0]["body"] = diaspora2bb(bb2diaspora($r[0]["body"]));
2314                                                 $r[0]["body"] = self::replace_people_guid($r[0]["body"], $r[0]["author-link"]);
2315                                         }
2316
2317                                         return $r[0];
2318                                 }
2319
2320                         }
2321                 }
2322                 return false;
2323         }
2324
2325         /**
2326          * @brief Processes a reshare message
2327          *
2328          * @param array $importer Array of the importer user
2329          * @param object $data The message object
2330          * @param string $xml The original XML of the message
2331          *
2332          * @return int the message id
2333          */
2334         private static function receive_reshare($importer, $data, $xml) {
2335                 $author = notags(unxmlify($data->author));
2336                 $guid = notags(unxmlify($data->guid));
2337                 $created_at = datetime_convert("UTC", "UTC", notags(unxmlify($data->created_at)));
2338                 $root_author = notags(unxmlify($data->root_author));
2339                 $root_guid = notags(unxmlify($data->root_guid));
2340                 /// @todo handle unprocessed property "provider_display_name"
2341                 $public = notags(unxmlify($data->public));
2342
2343                 $contact = self::allowed_contact_by_handle($importer, $author, false);
2344                 if (!$contact) {
2345                         return false;
2346                 }
2347
2348                 $message_id = self::message_exists($importer["uid"], $guid);
2349                 if ($message_id) {
2350                         return $message_id;
2351                 }
2352
2353                 $original_item = self::original_item($root_guid, $root_author, $author);
2354                 if (!$original_item) {
2355                         return false;
2356                 }
2357
2358                 $orig_url = App::get_baseurl()."/display/".$original_item["guid"];
2359
2360                 $datarray = array();
2361
2362                 $datarray["uid"] = $importer["uid"];
2363                 $datarray["contact-id"] = $contact["id"];
2364                 $datarray["network"]  = NETWORK_DIASPORA;
2365
2366                 $datarray["author-name"] = $contact["name"];
2367                 $datarray["author-link"] = $contact["url"];
2368                 $datarray["author-avatar"] = ((x($contact,"thumb")) ? $contact["thumb"] : $contact["photo"]);
2369
2370                 $datarray["owner-name"] = $datarray["author-name"];
2371                 $datarray["owner-link"] = $datarray["author-link"];
2372                 $datarray["owner-avatar"] = $datarray["author-avatar"];
2373
2374                 $datarray["guid"] = $guid;
2375                 $datarray["uri"] = $datarray["parent-uri"] = self::get_uri_from_guid($author, $guid);
2376
2377                 $datarray["verb"] = ACTIVITY_POST;
2378                 $datarray["gravity"] = GRAVITY_PARENT;
2379
2380                 $datarray["protocol"] = PROTOCOL_DIASPORA;
2381                 $datarray["source"] = $xml;
2382
2383                 $prefix = share_header($original_item["author-name"], $original_item["author-link"], $original_item["author-avatar"],
2384                                         $original_item["guid"], $original_item["created"], $orig_url);
2385                 $datarray["body"] = $prefix.$original_item["body"]."[/share]";
2386
2387                 $datarray["tag"] = $original_item["tag"];
2388                 $datarray["app"]  = $original_item["app"];
2389
2390                 $datarray["plink"] = self::plink($author, $guid);
2391                 $datarray["private"] = (($public == "false") ? 1 : 0);
2392                 $datarray["changed"] = $datarray["created"] = $datarray["edited"] = $created_at;
2393
2394                 $datarray["object-type"] = $original_item["object-type"];
2395
2396                 self::fetch_guid($datarray);
2397                 $message_id = item_store($datarray);
2398
2399                 if ($message_id) {
2400                         logger("Stored reshare ".$datarray["guid"]." with message id ".$message_id, LOGGER_DEBUG);
2401                 }
2402
2403                 return $message_id;
2404         }
2405
2406         /**
2407          * @brief Processes retractions
2408          *
2409          * @param array $importer Array of the importer user
2410          * @param array $contact The contact of the item owner
2411          * @param object $data The message object
2412          *
2413          * @return bool success
2414          */
2415         private static function item_retraction($importer, $contact, $data) {
2416                 $author = notags(unxmlify($data->author));
2417                 $target_guid = notags(unxmlify($data->target_guid));
2418                 $target_type = notags(unxmlify($data->target_type));
2419
2420                 $person = self::person_by_handle($author);
2421                 if (!is_array($person)) {
2422                         logger("unable to find author detail for ".$author);
2423                         return false;
2424                 }
2425
2426                 if (!isset($contact["url"])) {
2427                         $contact["url"] = $person["url"];
2428                 }
2429
2430                 $r = q("SELECT `id`, `parent`, `parent-uri`, `author-link` FROM `item` WHERE `guid` = '%s' AND `uid` = %d AND NOT `file` LIKE '%%[%%' LIMIT 1",
2431                         dbesc($target_guid),
2432                         intval($importer["uid"])
2433                 );
2434                 if (!$r) {
2435                         logger("Target guid ".$target_guid." was not found for user ".$importer["uid"]);
2436                         return false;
2437                 }
2438
2439                 // Check if the sender is the thread owner
2440                 $p = q("SELECT `id`, `author-link`, `origin` FROM `item` WHERE `id` = %d",
2441                         intval($r[0]["parent"]));
2442
2443                 // Only delete it if the parent author really fits
2444                 if (!link_compare($p[0]["author-link"], $contact["url"]) AND !link_compare($r[0]["author-link"], $contact["url"])) {
2445                         logger("Thread author ".$p[0]["author-link"]." and item author ".$r[0]["author-link"]." don't fit to expected contact ".$contact["url"], LOGGER_DEBUG);
2446                         return false;
2447                 }
2448
2449                 // Currently we don't have a central deletion function that we could use in this case. The function "item_drop" doesn't work for that case
2450                 q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = '' WHERE `id` = %d",
2451                         dbesc(datetime_convert()),
2452                         dbesc(datetime_convert()),
2453                         intval($r[0]["id"])
2454                 );
2455                 delete_thread($r[0]["id"], $r[0]["parent-uri"]);
2456
2457                 logger("Deleted target ".$target_guid." (".$r[0]["id"].") from user ".$importer["uid"]." parent: ".$p[0]["id"], LOGGER_DEBUG);
2458
2459                 // Now check if the retraction needs to be relayed by us
2460                 if ($p[0]["origin"]) {
2461                         // notify others
2462                         proc_run(PRIORITY_HIGH, "include/notifier.php", "drop", $r[0]["id"]);
2463                 }
2464
2465                 return true;
2466         }
2467
2468         /**
2469          * @brief Receives retraction messages
2470          *
2471          * @param array $importer Array of the importer user
2472          * @param string $sender The sender of the message
2473          * @param object $data The message object
2474          *
2475          * @return bool Success
2476          */
2477         private static function receive_retraction($importer, $sender, $data) {
2478                 $target_type = notags(unxmlify($data->target_type));
2479
2480                 $contact = self::contact_by_handle($importer["uid"], $sender);
2481                 if (!$contact AND (in_array($target_type, array("Contact", "Person")))) {
2482                         logger("cannot find contact for sender: ".$sender." and user ".$importer["uid"]);
2483                         return false;
2484                 }
2485
2486                 logger("Got retraction for ".$target_type.", sender ".$sender." and user ".$importer["uid"], LOGGER_DEBUG);
2487
2488                 switch ($target_type) {
2489                         case "Comment":
2490                         case "Like":
2491                         case "Post": // "Post" will be supported in a future version
2492                         case "Reshare":
2493                         case "StatusMessage":
2494                                 return self::item_retraction($importer, $contact, $data);
2495
2496                         case "Contact":
2497                         case "Person":
2498                                 /// @todo What should we do with an "unshare"?
2499                                 // Removing the contact isn't correct since we still can read the public items
2500                                 contact_remove($contact["id"]);
2501                                 return true;
2502
2503                         default:
2504                                 logger("Unknown target type ".$target_type);
2505                                 return false;
2506                 }
2507                 return true;
2508         }
2509
2510         /**
2511          * @brief Receives status messages
2512          *
2513          * @param array $importer Array of the importer user
2514          * @param object $data The message object
2515          * @param string $xml The original XML of the message
2516          *
2517          * @return int The message id of the newly created item
2518          */
2519         private static function receive_status_message($importer, $data, $xml) {
2520                 $author = notags(unxmlify($data->author));
2521                 $guid = notags(unxmlify($data->guid));
2522                 $created_at = datetime_convert("UTC", "UTC", notags(unxmlify($data->created_at)));
2523                 $public = notags(unxmlify($data->public));
2524                 $text = unxmlify($data->text);
2525                 $provider_display_name = notags(unxmlify($data->provider_display_name));
2526
2527                 $contact = self::allowed_contact_by_handle($importer, $author, false);
2528                 if (!$contact) {
2529                         return false;
2530                 }
2531
2532                 $message_id = self::message_exists($importer["uid"], $guid);
2533                 if ($message_id) {
2534                         return $message_id;
2535                 }
2536
2537                 $address = array();
2538                 if ($data->location) {
2539                         foreach ($data->location->children() AS $fieldname => $data) {
2540                                 $address[$fieldname] = notags(unxmlify($data));
2541                         }
2542                 }
2543
2544                 $body = diaspora2bb($text);
2545
2546                 $datarray = array();
2547
2548                 // Attach embedded pictures to the body
2549                 if ($data->photo) {
2550                         foreach ($data->photo AS $photo) {
2551                                 $body = "[img]".unxmlify($photo->remote_photo_path).
2552                                         unxmlify($photo->remote_photo_name)."[/img]\n".$body;
2553                         }
2554
2555                         $datarray["object-type"] = ACTIVITY_OBJ_IMAGE;
2556                 } else {
2557                         $datarray["object-type"] = ACTIVITY_OBJ_NOTE;
2558
2559                         // Add OEmbed and other information to the body
2560                         if (!self::is_redmatrix($contact["url"])) {
2561                                 $body = add_page_info_to_body($body, false, true);
2562                         }
2563                 }
2564
2565                 /// @todo enable support for polls
2566                 //if ($data->poll) {
2567                 //      foreach ($data->poll AS $poll)
2568                 //              print_r($poll);
2569                 //      die("poll!\n");
2570                 //}
2571
2572                 /// @todo enable support for events
2573
2574                 $datarray["uid"] = $importer["uid"];
2575                 $datarray["contact-id"] = $contact["id"];
2576                 $datarray["network"] = NETWORK_DIASPORA;
2577
2578                 $datarray["author-name"] = $contact["name"];
2579                 $datarray["author-link"] = $contact["url"];
2580                 $datarray["author-avatar"] = ((x($contact,"thumb")) ? $contact["thumb"] : $contact["photo"]);
2581
2582                 $datarray["owner-name"] = $datarray["author-name"];
2583                 $datarray["owner-link"] = $datarray["author-link"];
2584                 $datarray["owner-avatar"] = $datarray["author-avatar"];
2585
2586                 $datarray["guid"] = $guid;
2587                 $datarray["uri"] = $datarray["parent-uri"] = self::get_uri_from_guid($author, $guid);
2588
2589                 $datarray["verb"] = ACTIVITY_POST;
2590                 $datarray["gravity"] = GRAVITY_PARENT;
2591
2592                 $datarray["protocol"] = PROTOCOL_DIASPORA;
2593                 $datarray["source"] = $xml;
2594
2595                 $datarray["body"] = self::replace_people_guid($body, $contact["url"]);
2596
2597                 if ($provider_display_name != "") {
2598                         $datarray["app"] = $provider_display_name;
2599                 }
2600
2601                 $datarray["plink"] = self::plink($author, $guid);
2602                 $datarray["private"] = (($public == "false") ? 1 : 0);
2603                 $datarray["changed"] = $datarray["created"] = $datarray["edited"] = $created_at;
2604
2605                 if (isset($address["address"])) {
2606                         $datarray["location"] = $address["address"];
2607                 }
2608
2609                 if (isset($address["lat"]) AND isset($address["lng"])) {
2610                         $datarray["coord"] = $address["lat"]." ".$address["lng"];
2611                 }
2612
2613                 self::fetch_guid($datarray);
2614                 $message_id = item_store($datarray);
2615
2616                 if ($message_id) {
2617                         logger("Stored item ".$datarray["guid"]." with message id ".$message_id, LOGGER_DEBUG);
2618                 }
2619
2620                 return $message_id;
2621         }
2622
2623         /* ************************************************************************************** *
2624          * Here are all the functions that are needed to transmit data with the Diaspora protocol *
2625          * ************************************************************************************** */
2626
2627         /**
2628          * @brief returnes the handle of a contact
2629          *
2630          * @param array $me contact array
2631          *
2632          * @return string the handle in the format user@domain.tld
2633          */
2634         private static function my_handle($contact) {
2635                 if ($contact["addr"] != "") {
2636                         return $contact["addr"];
2637                 }
2638
2639                 // Normally we should have a filled "addr" field - but in the past this wasn't the case
2640                 // So - just in case - we build the the address here.
2641                 if ($contact["nickname"] != "") {
2642                         $nick = $contact["nickname"];
2643                 } else {
2644                         $nick = $contact["nick"];
2645                 }
2646
2647                 return $nick."@".substr(App::get_baseurl(), strpos(App::get_baseurl(),"://") + 3);
2648         }
2649
2650         /**
2651          * @brief Creates the envelope for the "fetch" endpoint
2652          *
2653          * @param string $msg The message that is to be transmitted
2654          * @param array $user The record of the sender
2655          *
2656          * @return string The envelope
2657          */
2658
2659         public static function build_magic_envelope($msg, $user) {
2660
2661                 $b64url_data = base64url_encode($msg);
2662                 $data = str_replace(array("\n", "\r", " ", "\t"), array("", "", "", ""), $b64url_data);
2663
2664                 $key_id = base64url_encode(self::my_handle($user));
2665                 $type = "application/xml";
2666                 $encoding = "base64url";
2667                 $alg = "RSA-SHA256";
2668                 $signable_data = $data.".".base64url_encode($type).".".base64url_encode($encoding).".".base64url_encode($alg);
2669                 $signature = rsa_sign($signable_data, $user["prvkey"]);
2670                 $sig = base64url_encode($signature);
2671
2672                 $xmldata = array("me:env" => array("me:data" => $data,
2673                                                         "@attributes" => array("type" => $type),
2674                                                         "me:encoding" => $encoding,
2675                                                         "me:alg" => $alg,
2676                                                         "me:sig" => $sig,
2677                                                         "@attributes2" => array("key_id" => $key_id)));
2678
2679                 $namespaces = array("me" => "http://salmon-protocol.org/ns/magic-env");
2680
2681                 return xml::from_array($xmldata, $xml, false, $namespaces);
2682         }
2683
2684         /**
2685          * @brief Creates the envelope for a public message
2686          *
2687          * @param string $msg The message that is to be transmitted
2688          * @param array $user The record of the sender
2689          * @param array $contact Target of the communication
2690          * @param string $prvkey The private key of the sender
2691          * @param string $pubkey The public key of the receiver
2692          *
2693          * @return string The envelope
2694          */
2695         private static function build_public_message($msg, $user, $contact, $prvkey, $pubkey) {
2696
2697                 logger("Message: ".$msg, LOGGER_DATA);
2698
2699                 $handle = self::my_handle($user);
2700
2701                 $b64url_data = base64url_encode($msg);
2702
2703                 $data = str_replace(array("\n", "\r", " ", "\t"), array("", "", "", ""), $b64url_data);
2704
2705                 $type = "application/xml";
2706                 $encoding = "base64url";
2707                 $alg = "RSA-SHA256";
2708
2709                 $signable_data = $data.".".base64url_encode($type).".".base64url_encode($encoding).".".base64url_encode($alg);
2710
2711                 $signature = rsa_sign($signable_data,$prvkey);
2712                 $sig = base64url_encode($signature);
2713
2714                 $xmldata = array("diaspora" => array("header" => array("author_id" => $handle),
2715                                                         "me:env" => array("me:encoding" => $encoding,
2716                                                         "me:alg" => $alg,
2717                                                         "me:data" => $data,
2718                                                         "@attributes" => array("type" => $type),
2719                                                         "me:sig" => $sig)));
2720
2721                 $namespaces = array("" => "https://joindiaspora.com/protocol",
2722                                 "me" => "http://salmon-protocol.org/ns/magic-env");
2723
2724                 $magic_env = xml::from_array($xmldata, $xml, false, $namespaces);
2725
2726                 logger("magic_env: ".$magic_env, LOGGER_DATA);
2727                 return $magic_env;
2728         }
2729
2730         /**
2731          * @brief Creates the envelope for a private message
2732          *
2733          * @param string $msg The message that is to be transmitted
2734          * @param array $user The record of the sender
2735          * @param array $contact Target of the communication
2736          * @param string $prvkey The private key of the sender
2737          * @param string $pubkey The public key of the receiver
2738          *
2739          * @return string The envelope
2740          */
2741         private static function build_private_message($msg, $user, $contact, $prvkey, $pubkey) {
2742
2743                 logger("Message: ".$msg, LOGGER_DATA);
2744
2745                 // without a public key nothing will work
2746
2747                 if (!$pubkey) {
2748                         logger("pubkey missing: contact id: ".$contact["id"]);
2749                         return false;
2750                 }
2751
2752                 $inner_aes_key = openssl_random_pseudo_bytes(32);
2753                 $b_inner_aes_key = base64_encode($inner_aes_key);
2754                 $inner_iv = openssl_random_pseudo_bytes(16);
2755                 $b_inner_iv = base64_encode($inner_iv);
2756
2757                 $outer_aes_key = openssl_random_pseudo_bytes(32);
2758                 $b_outer_aes_key = base64_encode($outer_aes_key);
2759                 $outer_iv = openssl_random_pseudo_bytes(16);
2760                 $b_outer_iv = base64_encode($outer_iv);
2761
2762                 $handle = self::my_handle($user);
2763
2764                 $inner_encrypted = self::aes_encrypt($inner_aes_key, $inner_iv, $msg);
2765
2766                 $b64_data = base64_encode($inner_encrypted);
2767
2768
2769                 $b64url_data = base64url_encode($b64_data);
2770                 $data = str_replace(array("\n", "\r", " ", "\t"), array("", "", "", ""), $b64url_data);
2771
2772                 $type = "application/xml";
2773                 $encoding = "base64url";
2774                 $alg = "RSA-SHA256";
2775
2776                 $signable_data = $data.".".base64url_encode($type).".".base64url_encode($encoding).".".base64url_encode($alg);
2777
2778                 $signature = rsa_sign($signable_data,$prvkey);
2779                 $sig = base64url_encode($signature);
2780
2781                 $xmldata = array("decrypted_header" => array("iv" => $b_inner_iv,
2782                                                         "aes_key" => $b_inner_aes_key,
2783                                                         "author_id" => $handle));
2784
2785                 $decrypted_header = xml::from_array($xmldata, $xml, true);
2786
2787                 $ciphertext = self::aes_encrypt($outer_aes_key, $outer_iv, $decrypted_header);
2788
2789                 $outer_json = json_encode(array("iv" => $b_outer_iv, "key" => $b_outer_aes_key));
2790
2791                 $encrypted_outer_key_bundle = "";
2792                 openssl_public_encrypt($outer_json, $encrypted_outer_key_bundle, $pubkey);
2793
2794                 $b64_encrypted_outer_key_bundle = base64_encode($encrypted_outer_key_bundle);
2795
2796                 logger("outer_bundle: ".$b64_encrypted_outer_key_bundle." key: ".$pubkey, LOGGER_DATA);
2797
2798                 $encrypted_header_json_object = json_encode(array("aes_key" => base64_encode($encrypted_outer_key_bundle),
2799                                                                 "ciphertext" => base64_encode($ciphertext)));
2800                 $cipher_json = base64_encode($encrypted_header_json_object);
2801
2802                 $xmldata = array("diaspora" => array("encrypted_header" => $cipher_json,
2803                                                 "me:env" => array("me:encoding" => $encoding,
2804                                                                 "me:alg" => $alg,
2805                                                                 "me:data" => $data,
2806                                                                 "@attributes" => array("type" => $type),
2807                                                                 "me:sig" => $sig)));
2808
2809                 $namespaces = array("" => "https://joindiaspora.com/protocol",
2810                                 "me" => "http://salmon-protocol.org/ns/magic-env");
2811
2812                 $magic_env = xml::from_array($xmldata, $xml, false, $namespaces);
2813
2814                 logger("magic_env: ".$magic_env, LOGGER_DATA);
2815                 return $magic_env;
2816         }
2817
2818         /**
2819          * @brief Create the envelope for a message
2820          *
2821          * @param string $msg The message that is to be transmitted
2822          * @param array $user The record of the sender
2823          * @param array $contact Target of the communication
2824          * @param string $prvkey The private key of the sender
2825          * @param string $pubkey The public key of the receiver
2826          * @param bool $public Is the message public?
2827          *
2828          * @return string The message that will be transmitted to other servers
2829          */
2830         private static function build_message($msg, $user, $contact, $prvkey, $pubkey, $public = false) {
2831
2832                 if ($public)
2833                         $magic_env =  self::build_public_message($msg,$user,$contact,$prvkey,$pubkey);
2834                 else
2835                         $magic_env =  self::build_private_message($msg,$user,$contact,$prvkey,$pubkey);
2836
2837                 // The data that will be transmitted is double encoded via "urlencode", strange ...
2838                 $slap = "xml=".urlencode(urlencode($magic_env));
2839                 return $slap;
2840         }
2841
2842         /**
2843          * @brief Creates a signature for a message
2844          *
2845          * @param array $owner the array of the owner of the message
2846          * @param array $message The message that is to be signed
2847          *
2848          * @return string The signature
2849          */
2850         private static function signature($owner, $message) {
2851                 $sigmsg = $message;
2852                 unset($sigmsg["author_signature"]);
2853                 unset($sigmsg["parent_author_signature"]);
2854
2855                 $signed_text = implode(";", $sigmsg);
2856
2857                 return base64_encode(rsa_sign($signed_text, $owner["uprvkey"], "sha256"));
2858         }
2859
2860         /**
2861          * @brief Transmit a message to a target server
2862          *
2863          * @param array $owner the array of the item owner
2864          * @param array $contact Target of the communication
2865          * @param string $slap The message that is to be transmitted
2866          * @param bool $public_batch Is it a public post?
2867          * @param bool $queue_run Is the transmission called from the queue?
2868          * @param string $guid message guid
2869          *
2870          * @return int Result of the transmission
2871          */
2872         public static function transmit($owner, $contact, $slap, $public_batch, $queue_run=false, $guid = "") {
2873
2874                 $a = get_app();
2875
2876                 $enabled = intval(get_config("system", "diaspora_enabled"));
2877                 if (!$enabled)
2878                         return 200;
2879
2880                 $logid = random_string(4);
2881                 $dest_url = (($public_batch) ? $contact["batch"] : $contact["notify"]);
2882                 if (!$dest_url) {
2883                         logger("no url for contact: ".$contact["id"]." batch mode =".$public_batch);
2884                         return 0;
2885                 }
2886
2887                 logger("transmit: ".$logid."-".$guid." ".$dest_url);
2888
2889                 if (!$queue_run && was_recently_delayed($contact["id"])) {
2890                         $return_code = 0;
2891                 } else {
2892                         if (!intval(get_config("system", "diaspora_test"))) {
2893                                 post_url($dest_url."/", $slap);
2894                                 $return_code = $a->get_curl_code();
2895                         } else {
2896                                 logger("test_mode");
2897                                 return 200;
2898                         }
2899                 }
2900
2901                 logger("transmit: ".$logid."-".$guid." returns: ".$return_code);
2902
2903                 if (!$return_code || (($return_code == 503) && (stristr($a->get_curl_headers(), "retry-after")))) {
2904                         logger("queue message");
2905
2906                         $r = q("SELECT `id` FROM `queue` WHERE `cid` = %d AND `network` = '%s' AND `content` = '%s' AND `batch` = %d LIMIT 1",
2907                                 intval($contact["id"]),
2908                                 dbesc(NETWORK_DIASPORA),
2909                                 dbesc($slap),
2910                                 intval($public_batch)
2911                         );
2912                         if ($r) {
2913                                 logger("add_to_queue ignored - identical item already in queue");
2914                         } else {
2915                                 // queue message for redelivery
2916                                 add_to_queue($contact["id"], NETWORK_DIASPORA, $slap, $public_batch);
2917
2918                                 // The message could not be delivered. We mark the contact as "dead"
2919                                 mark_for_death($contact);
2920                         }
2921                 } elseif (($return_code >= 200) AND ($return_code <= 299)) {
2922                         // We successfully delivered a message, the contact is alive
2923                         unmark_for_death($contact);
2924                 }
2925
2926                 return(($return_code) ? $return_code : (-1));
2927         }
2928
2929
2930         /**
2931          * @brief Build the post xml
2932          *
2933          * @param string $type The message type
2934          * @param array $message The message data
2935          *
2936          * @return string The post XML
2937          */
2938         public static function build_post_xml($type, $message) {
2939
2940                 $data = array("XML" => array("post" => array($type => $message)));
2941                 return xml::from_array($data, $xml);
2942         }
2943
2944         /**
2945          * @brief Builds and transmit messages
2946          *
2947          * @param array $owner the array of the item owner
2948          * @param array $contact Target of the communication
2949          * @param string $type The message type
2950          * @param array $message The message data
2951          * @param bool $public_batch Is it a public post?
2952          * @param string $guid message guid
2953          * @param bool $spool Should the transmission be spooled or transmitted?
2954          *
2955          * @return int Result of the transmission
2956          */
2957         private static function build_and_transmit($owner, $contact, $type, $message, $public_batch = false, $guid = "", $spool = false) {
2958
2959                 $msg = self::build_post_xml($type, $message);
2960
2961                 logger('message: '.$msg, LOGGER_DATA);
2962                 logger('send guid '.$guid, LOGGER_DEBUG);
2963
2964                 // Fallback if the private key wasn't transmitted in the expected field
2965                 if ($owner['uprvkey'] == "")
2966                         $owner['uprvkey'] = $owner['prvkey'];
2967
2968                 $slap = self::build_message($msg, $owner, $contact, $owner['uprvkey'], $contact['pubkey'], $public_batch);
2969
2970                 if ($spool) {
2971                         add_to_queue($contact['id'], NETWORK_DIASPORA, $slap, $public_batch);
2972                         return true;
2973                 } else
2974                         $return_code = self::transmit($owner, $contact, $slap, $public_batch, false, $guid);
2975
2976                 logger("guid: ".$item["guid"]." result ".$return_code, LOGGER_DEBUG);
2977
2978                 return $return_code;
2979         }
2980
2981         /**
2982          * @brief Sends a "share" message
2983          *
2984          * @param array $owner the array of the item owner
2985          * @param array $contact Target of the communication
2986          *
2987          * @return int The result of the transmission
2988          */
2989         public static function send_share($owner,$contact) {
2990
2991                 $message = array("sender_handle" => self::my_handle($owner),
2992                                 "recipient_handle" => $contact["addr"]);
2993
2994                 logger("Send share ".print_r($message, true), LOGGER_DEBUG);
2995
2996                 return self::build_and_transmit($owner, $contact, "request", $message);
2997         }
2998
2999         /**
3000          * @brief sends an "unshare"
3001          *
3002          * @param array $owner the array of the item owner
3003          * @param array $contact Target of the communication
3004          *
3005          * @return int The result of the transmission
3006          */
3007         public static function send_unshare($owner,$contact) {
3008
3009                 $message = array("post_guid" => $owner["guid"],
3010                                 "diaspora_handle" => self::my_handle($owner),
3011                                 "type" => "Person");
3012
3013                 logger("Send unshare ".print_r($message, true), LOGGER_DEBUG);
3014
3015                 return self::build_and_transmit($owner, $contact, "retraction", $message);
3016         }
3017
3018         /**
3019          * @brief Checks a message body if it is a reshare
3020          *
3021          * @param string $body The message body that is to be check
3022          * @param bool $complete Should it be a complete check or a simple check?
3023          *
3024          * @return array|bool Reshare details or "false" if no reshare
3025          */
3026         public static function is_reshare($body, $complete = true) {
3027                 $body = trim($body);
3028
3029                 // Skip if it isn't a pure repeated messages
3030                 // Does it start with a share?
3031                 if ((strpos($body, "[share") > 0) AND $complete)
3032                         return(false);
3033
3034                 // Does it end with a share?
3035                 if (strlen($body) > (strrpos($body, "[/share]") + 8))
3036                         return(false);
3037
3038                 $attributes = preg_replace("/\[share(.*?)\]\s?(.*?)\s?\[\/share\]\s?/ism","$1",$body);
3039                 // Skip if there is no shared message in there
3040                 if ($body == $attributes)
3041                         return(false);
3042
3043                 // If we don't do the complete check we quit here
3044                 if (!$complete)
3045                         return true;
3046
3047                 $guid = "";
3048                 preg_match("/guid='(.*?)'/ism", $attributes, $matches);
3049                 if ($matches[1] != "")
3050                         $guid = $matches[1];
3051
3052                 preg_match('/guid="(.*?)"/ism', $attributes, $matches);
3053                 if ($matches[1] != "")
3054                         $guid = $matches[1];
3055
3056                 if ($guid != "") {
3057                         $r = q("SELECT `contact-id` FROM `item` WHERE `guid` = '%s' AND `network` IN ('%s', '%s') LIMIT 1",
3058                                 dbesc($guid), NETWORK_DFRN, NETWORK_DIASPORA);
3059                         if ($r) {
3060                                 $ret= array();
3061                                 $ret["root_handle"] = self::handle_from_contact($r[0]["contact-id"]);
3062                                 $ret["root_guid"] = $guid;
3063                                 return($ret);
3064                         }
3065                 }
3066
3067                 $profile = "";
3068                 preg_match("/profile='(.*?)'/ism", $attributes, $matches);
3069                 if ($matches[1] != "")
3070                         $profile = $matches[1];
3071
3072                 preg_match('/profile="(.*?)"/ism', $attributes, $matches);
3073                 if ($matches[1] != "")
3074                         $profile = $matches[1];
3075
3076                 $ret= array();
3077
3078                 $ret["root_handle"] = preg_replace("=https?://(.*)/u/(.*)=ism", "$2@$1", $profile);
3079                 if (($ret["root_handle"] == $profile) OR ($ret["root_handle"] == ""))
3080                         return(false);
3081
3082                 $link = "";
3083                 preg_match("/link='(.*?)'/ism", $attributes, $matches);
3084                 if ($matches[1] != "")
3085                         $link = $matches[1];
3086
3087                 preg_match('/link="(.*?)"/ism', $attributes, $matches);
3088                 if ($matches[1] != "")
3089                         $link = $matches[1];
3090
3091                 $ret["root_guid"] = preg_replace("=https?://(.*)/posts/(.*)=ism", "$2", $link);
3092                 if (($ret["root_guid"] == $link) OR (trim($ret["root_guid"]) == ""))
3093                         return(false);
3094
3095                 return($ret);
3096         }
3097
3098         /**
3099          * @brief Create an event array
3100          *
3101          * @param integer $event_id The id of the event
3102          *
3103          * @return array with event data
3104          */
3105         private static function build_event($event_id) {
3106
3107                 $r = q("SELECT `guid`, `uid`, `start`, `finish`, `nofinish`, `summary`, `desc`, `location`, `adjust` FROM `event` WHERE `id` = %d", intval($event_id));
3108                 if (!dbm::is_result($r)) {
3109                         return array();
3110                 }
3111
3112                 $event = $r[0];
3113
3114                 $eventdata = array();
3115
3116                 $r = q("SELECT `timezone` FROM `user` WHERE `uid` = %d", intval($event['uid']));
3117                 if (!dbm::is_result($r)) {
3118                         return array();
3119                 }
3120
3121                 $user = $r[0];
3122
3123                 $r = q("SELECT `addr`, `nick` FROM `contact` WHERE `uid` = %d AND `self`", intval($event['uid']));
3124                 if (!dbm::is_result($r)) {
3125                         return array();
3126                 }
3127
3128                 $owner = $r[0];
3129
3130                 $eventdata['author'] = self::my_handle($owner);
3131
3132                 if ($event['guid']) {
3133                         $eventdata['guid'] = $event['guid'];
3134                 }
3135
3136                 $mask = 'Y-m-d\TH:i:s\Z';
3137
3138                 /// @todo - establish "all day" events in Friendica
3139                 $eventdata["all_day"] = "false";
3140
3141                 if (!$event['adjust']) {
3142                         $eventdata['timezone'] = $user['timezone'];
3143
3144                         if ($eventdata['timezone'] == "") {
3145                                 $eventdata['timezone'] = 'UTC';
3146                         }
3147                 }
3148
3149                 if ($event['start']) {
3150                         $eventdata['start'] = datetime_convert($eventdata['timezone'], "UTC", $event['start'], $mask);
3151                 }
3152                 if ($event['finish'] AND !$event['nofinish']) {
3153                         $eventdata['end'] = datetime_convert($eventdata['timezone'], "UTC", $event['finish'], $mask);
3154                 }
3155                 if ($event['summary']) {
3156                         $eventdata['summary'] = html_entity_decode(bb2diaspora($event['summary']));
3157                 }
3158                 if ($event['desc']) {
3159                         $eventdata['description'] = html_entity_decode(bb2diaspora($event['desc']));
3160                 }
3161                 if ($event['location']) {
3162                         $location = array();
3163                         $location["address"] = html_entity_decode(bb2diaspora($event['location']));
3164                         $location["lat"] = 0;
3165                         $location["lng"] = 0;
3166                         $eventdata['location'] = $location;
3167                 }
3168
3169                 return $eventdata;
3170         }
3171
3172         /**
3173          * @brief Create a post (status message or reshare)
3174          *
3175          * @param array $item The item that will be exported
3176          * @param array $owner the array of the item owner
3177          *
3178          * @return array
3179          * 'type' -> Message type ("status_message" or "reshare")
3180          * 'message' -> Array of XML elements of the status
3181          */
3182         public static function build_status($item, $owner) {
3183
3184                 $cachekey = "diaspora:build_status:".$item['guid'];
3185
3186                 $result = Cache::get($cachekey);
3187                 if (!is_null($result)) {
3188                         return $result;
3189                 }
3190
3191                 $myaddr = self::my_handle($owner);
3192
3193                 $public = (($item["private"]) ? "false" : "true");
3194
3195                 $created = datetime_convert("UTC", "UTC", $item["created"], 'Y-m-d\TH:i:s\Z');
3196
3197                 // Detect a share element and do a reshare
3198                 if (!$item['private'] AND ($ret = self::is_reshare($item["body"]))) {
3199                         $message = array("root_diaspora_id" => $ret["root_handle"],
3200                                         "root_guid" => $ret["root_guid"],
3201                                         "guid" => $item["guid"],
3202                                         "diaspora_handle" => $myaddr,
3203                                         "public" => $public,
3204                                         "created_at" => $created,
3205                                         "provider_display_name" => $item["app"]);
3206
3207                         $type = "reshare";
3208                 } else {
3209                         $title = $item["title"];
3210                         $body = $item["body"];
3211
3212                         // convert to markdown
3213                         $body = html_entity_decode(bb2diaspora($body));
3214
3215                         // Adding the title
3216                         if (strlen($title))
3217                                 $body = "## ".html_entity_decode($title)."\n\n".$body;
3218
3219                         if ($item["attach"]) {
3220                                 $cnt = preg_match_all('/href=\"(.*?)\"(.*?)title=\"(.*?)\"/ism', $item["attach"], $matches, PREG_SET_ORDER);
3221                                 if (cnt) {
3222                                         $body .= "\n".t("Attachments:")."\n";
3223                                         foreach ($matches as $mtch)
3224                                                 $body .= "[".$mtch[3]."](".$mtch[1].")\n";
3225                                 }
3226                         }
3227
3228                         $location = array();
3229
3230                         if ($item["location"] != "")
3231                                 $location["address"] = $item["location"];
3232
3233                         if ($item["coord"] != "") {
3234                                 $coord = explode(" ", $item["coord"]);
3235                                 $location["lat"] = $coord[0];
3236                                 $location["lng"] = $coord[1];
3237                         }
3238
3239                         $message = array("raw_message" => $body,
3240                                         "location" => $location,
3241                                         "guid" => $item["guid"],
3242                                         "diaspora_handle" => $myaddr,
3243                                         "public" => $public,
3244                                         "created_at" => $created,
3245                                         "provider_display_name" => $item["app"]);
3246
3247                         // Diaspora rejects messages when they contain a location without "lat" or "lng"
3248                         if (!isset($location["lat"]) OR !isset($location["lng"])) {
3249                                 unset($message["location"]);
3250                         }
3251
3252                         if ($item['event-id'] > 0) {
3253                                 $event = self::build_event($item['event-id']);
3254                                 if (count($event)) {
3255                                         $message['event'] = $event;
3256
3257                                         /// @todo Once Diaspora supports it, we will remove the body
3258                                         // $message['raw_message'] = '';
3259                                 }
3260                         }
3261
3262                         $type = "status_message";
3263                 }
3264
3265                 $msg = array("type" => $type, "message" => $message);
3266
3267                 Cache::set($cachekey, $msg, CACHE_QUARTER_HOUR);
3268
3269                 return $msg;
3270         }
3271
3272         /**
3273          * @brief Sends a post
3274          *
3275          * @param array $item The item that will be exported
3276          * @param array $owner the array of the item owner
3277          * @param array $contact Target of the communication
3278          * @param bool $public_batch Is it a public post?
3279          *
3280          * @return int The result of the transmission
3281          */
3282         public static function send_status($item, $owner, $contact, $public_batch = false) {
3283
3284                 $status = self::build_status($item, $owner);
3285
3286                 return self::build_and_transmit($owner, $contact, $status["type"], $status["message"], $public_batch, $item["guid"]);
3287         }
3288
3289         /**
3290          * @brief Creates a "like" object
3291          *
3292          * @param array $item The item that will be exported
3293          * @param array $owner the array of the item owner
3294          *
3295          * @return array The data for a "like"
3296          */
3297         private static function construct_like($item, $owner) {
3298
3299                 $p = q("SELECT `guid`, `uri`, `parent-uri` FROM `item` WHERE `uri` = '%s' LIMIT 1",
3300                         dbesc($item["thr-parent"]));
3301                 if (!dbm::is_result($p))
3302                         return false;
3303
3304                 $parent = $p[0];
3305
3306                 $target_type = ($parent["uri"] === $parent["parent-uri"] ? "Post" : "Comment");
3307                 if ($item['verb'] === ACTIVITY_LIKE) {
3308                         $positive = "true";
3309                 } elseif ($item['verb'] === ACTIVITY_DISLIKE) {
3310                         $positive = "false";
3311                 }
3312
3313                 return(array("positive" => $positive,
3314                                 "guid" => $item["guid"],
3315                                 "target_type" => $target_type,
3316                                 "parent_guid" => $parent["guid"],
3317                                 "author_signature" => "",
3318                                 "diaspora_handle" => self::my_handle($owner)));
3319         }
3320
3321         /**
3322          * @brief Creates an "EventParticipation" object
3323          *
3324          * @param array $item The item that will be exported
3325          * @param array $owner the array of the item owner
3326          *
3327          * @return array The data for an "EventParticipation"
3328          */
3329         private static function construct_attend($item, $owner) {
3330
3331                 $p = q("SELECT `guid`, `uri`, `parent-uri` FROM `item` WHERE `uri` = '%s' LIMIT 1",
3332                         dbesc($item["thr-parent"]));
3333                 if (!dbm::is_result($p))
3334                         return false;
3335
3336                 $parent = $p[0];
3337
3338                 switch ($item['verb']) {
3339                         case ACTIVITY_ATTEND:
3340                                 $attend_answer = 'accepted';
3341                                 break;
3342                         case ACTIVITY_ATTENDNO:
3343                                 $attend_answer = 'declined';
3344                                 break;
3345                         case ACTIVITY_ATTENDMAYBE:
3346                                 $attend_answer = 'tentative';
3347                                 break;
3348                         default:
3349                                 logger('Unknown verb '.$item['verb'].' in item '.$item['guid']);
3350                                 return false;
3351                 }
3352
3353                 return(array("author" => self::my_handle($owner),
3354                                 "guid" => $item["guid"],
3355                                 "parent_guid" => $parent["guid"],
3356                                 "status" => $attend_answer,
3357                                 "author_signature" => ""));
3358         }
3359
3360         /**
3361          * @brief Creates the object for a comment
3362          *
3363          * @param array $item The item that will be exported
3364          * @param array $owner the array of the item owner
3365          *
3366          * @return array The data for a comment
3367          */
3368         private static function construct_comment($item, $owner) {
3369
3370                 $cachekey = "diaspora:construct_comment:".$item['guid'];
3371
3372                 $result = Cache::get($cachekey);
3373                 if (!is_null($result)) {
3374                         return $result;
3375                 }
3376
3377                 $p = q("SELECT `guid` FROM `item` WHERE `parent` = %d AND `id` = %d LIMIT 1",
3378                         intval($item["parent"]),
3379                         intval($item["parent"])
3380                 );
3381
3382                 if (!dbm::is_result($p))
3383                         return false;
3384
3385                 $parent = $p[0];
3386
3387                 $text = html_entity_decode(bb2diaspora($item["body"]));
3388                 $created = datetime_convert("UTC", "UTC", $item["created"], 'Y-m-d\TH:i:s\Z');
3389
3390                 $comment = array("guid" => $item["guid"],
3391                                 "parent_guid" => $parent["guid"],
3392                                 "author_signature" => "",
3393                                 "text" => $text,
3394                                 /// @todo Currently disabled until Diaspora supports it: "created_at" => $created,
3395                                 "diaspora_handle" => self::my_handle($owner));
3396
3397                 // Send the thread parent guid only if it is a threaded comment
3398                 if ($item['thr-parent'] != $item['parent-uri']) {
3399                         $comment['thread_parent_guid'] = self::get_guid_from_uri($item['thr-parent'], $item['uid']);
3400                 }
3401
3402                 Cache::set($cachekey, $comment, CACHE_QUARTER_HOUR);
3403
3404                 return($comment);
3405         }
3406
3407         /**
3408          * @brief Send a like or a comment
3409          *
3410          * @param array $item The item that will be exported
3411          * @param array $owner the array of the item owner
3412          * @param array $contact Target of the communication
3413          * @param bool $public_batch Is it a public post?
3414          *
3415          * @return int The result of the transmission
3416          */
3417         public static function send_followup($item,$owner,$contact,$public_batch = false) {
3418
3419                 if (in_array($item['verb'], array(ACTIVITY_ATTEND, ACTIVITY_ATTENDNO, ACTIVITY_ATTENDMAYBE))) {
3420                         $message = self::construct_attend($item, $owner);
3421                         $type = "event_participation";
3422                 } elseif (in_array($item["verb"], array(ACTIVITY_LIKE, ACTIVITY_DISLIKE))) {
3423                         $message = self::construct_like($item, $owner);
3424                         $type = "like";
3425                 } else {
3426                         $message = self::construct_comment($item, $owner);
3427                         $type = "comment";
3428                 }
3429
3430                 if (!$message)
3431                         return false;
3432
3433                 $message["author_signature"] = self::signature($owner, $message);
3434
3435                 return self::build_and_transmit($owner, $contact, $type, $message, $public_batch, $item["guid"]);
3436         }
3437
3438         /**
3439          * @brief Creates a message from a signature record entry
3440          *
3441          * @param array $item The item that will be exported
3442          * @param array $signature The entry of the "sign" record
3443          *
3444          * @return string The message
3445          */
3446         private static function message_from_signature($item, $signature) {
3447
3448                 // Split the signed text
3449                 $signed_parts = explode(";", $signature['signed_text']);
3450
3451                 if ($item["deleted"])
3452                         $message = array("parent_author_signature" => "",
3453                                         "target_guid" => $signed_parts[0],
3454                                         "target_type" => $signed_parts[1],
3455                                         "sender_handle" => $signature['signer'],
3456                                         "target_author_signature" => $signature['signature']);
3457                 elseif ($item['verb'] === ACTIVITY_LIKE)
3458                         $message = array("positive" => $signed_parts[0],
3459                                         "guid" => $signed_parts[1],
3460                                         "target_type" => $signed_parts[2],
3461                                         "parent_guid" => $signed_parts[3],
3462                                         "parent_author_signature" => "",
3463                                         "author_signature" => $signature['signature'],
3464                                         "diaspora_handle" => $signed_parts[4]);
3465                 else {
3466                         // Remove the comment guid
3467                         $guid = array_shift($signed_parts);
3468
3469                         // Remove the parent guid
3470                         $parent_guid = array_shift($signed_parts);
3471
3472                         // Remove the handle
3473                         $handle = array_pop($signed_parts);
3474
3475                         // Glue the parts together
3476                         $text = implode(";", $signed_parts);
3477
3478                         $message = array("guid" => $guid,
3479                                         "parent_guid" => $parent_guid,
3480                                         "parent_author_signature" => "",
3481                                         "author_signature" => $signature['signature'],
3482                                         "text" => implode(";", $signed_parts),
3483                                         "diaspora_handle" => $handle);
3484                 }
3485                 return $message;
3486         }
3487
3488         /**
3489          * @brief Relays messages (like, comment, retraction) to other servers if we are the thread owner
3490          *
3491          * @param array $item The item that will be exported
3492          * @param array $owner the array of the item owner
3493          * @param array $contact Target of the communication
3494          * @param bool $public_batch Is it a public post?
3495          *
3496          * @return int The result of the transmission
3497          */
3498         public static function send_relay($item, $owner, $contact, $public_batch = false) {
3499
3500                 if ($item["deleted"])
3501                         return self::send_retraction($item, $owner, $contact, $public_batch, true);
3502                 elseif ($item['verb'] === ACTIVITY_LIKE)
3503                         $type = "like";
3504                 else
3505                         $type = "comment";
3506
3507                 logger("Got relayable data ".$type." for item ".$item["guid"]." (".$item["id"].")", LOGGER_DEBUG);
3508
3509                 // fetch the original signature
3510
3511                 $r = q("SELECT `signed_text`, `signature`, `signer` FROM `sign` WHERE `iid` = %d LIMIT 1",
3512                         intval($item["id"]));
3513
3514                 if (!$r) {
3515                         logger("Couldn't fetch signatur for item ".$item["guid"]." (".$item["id"].")", LOGGER_DEBUG);
3516                         return false;
3517                 }
3518
3519                 $signature = $r[0];
3520
3521                 // Old way - is used by the internal Friendica functions
3522                 /// @todo Change all signatur storing functions to the new format
3523                 if ($signature['signed_text'] AND $signature['signature'] AND $signature['signer'])
3524                         $message = self::message_from_signature($item, $signature);
3525                 else {// New way
3526                         $msg = json_decode($signature['signed_text'], true);
3527
3528                         $message = array();
3529                         if (is_array($msg)) {
3530                                 foreach ($msg AS $field => $data) {
3531                                         if (!$item["deleted"]) {
3532                                                 if ($field == "author")
3533                                                         $field = "diaspora_handle";
3534                                                 if ($field == "parent_type")
3535                                                         $field = "target_type";
3536                                         }
3537
3538                                         $message[$field] = $data;
3539                                 }
3540                         } else
3541                                 logger("Signature text for item ".$item["guid"]." (".$item["id"].") couldn't be extracted: ".$signature['signed_text'], LOGGER_DEBUG);
3542                 }
3543
3544                 $message["parent_author_signature"] = self::signature($owner, $message);
3545
3546                 logger("Relayed data ".print_r($message, true), LOGGER_DEBUG);
3547
3548                 return self::build_and_transmit($owner, $contact, $type, $message, $public_batch, $item["guid"]);
3549         }
3550
3551         /**
3552          * @brief Sends a retraction (deletion) of a message, like or comment
3553          *
3554          * @param array $item The item that will be exported
3555          * @param array $owner the array of the item owner
3556          * @param array $contact Target of the communication
3557          * @param bool $public_batch Is it a public post?
3558          * @param bool $relay Is the retraction transmitted from a relay?
3559          *
3560          * @return int The result of the transmission
3561          */
3562         public static function send_retraction($item, $owner, $contact, $public_batch = false, $relay = false) {
3563
3564                 $itemaddr = self::handle_from_contact($item["contact-id"], $item["gcontact-id"]);
3565
3566                 // Check whether the retraction is for a top-level post or whether it's a relayable
3567                 if ($item["uri"] !== $item["parent-uri"]) {
3568                         $msg_type = "relayable_retraction";
3569                         $target_type = (($item["verb"] === ACTIVITY_LIKE) ? "Like" : "Comment");
3570                 } else {
3571                         $msg_type = "signed_retraction";
3572                         $target_type = "StatusMessage";
3573                 }
3574
3575                 if ($relay AND ($item["uri"] !== $item["parent-uri"]))
3576                         $signature = "parent_author_signature";
3577                 else
3578                         $signature = "target_author_signature";
3579
3580                 $signed_text = $item["guid"].";".$target_type;
3581
3582                 $message = array("target_guid" => $item['guid'],
3583                                 "target_type" => $target_type,
3584                                 "sender_handle" => $itemaddr,
3585                                 $signature => base64_encode(rsa_sign($signed_text,$owner['uprvkey'],'sha256')));
3586
3587                 logger("Got message ".print_r($message, true), LOGGER_DEBUG);
3588
3589                 return self::build_and_transmit($owner, $contact, $msg_type, $message, $public_batch, $item["guid"]);
3590         }
3591
3592         /**
3593          * @brief Sends a mail
3594          *
3595          * @param array $item The item that will be exported
3596          * @param array $owner The owner
3597          * @param array $contact Target of the communication
3598          *
3599          * @return int The result of the transmission
3600          */
3601         public static function send_mail($item, $owner, $contact) {
3602
3603                 $myaddr = self::my_handle($owner);
3604
3605                 $r = q("SELECT * FROM `conv` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3606                         intval($item["convid"]),
3607                         intval($item["uid"])
3608                 );
3609
3610                 if (!dbm::is_result($r)) {
3611                         logger("conversation not found.");
3612                         return;
3613                 }
3614                 $cnv = $r[0];
3615
3616                 $conv = array(
3617                         "guid" => $cnv["guid"],
3618                         "subject" => $cnv["subject"],
3619                         "created_at" => datetime_convert("UTC", "UTC", $cnv['created'], 'Y-m-d\TH:i:s\Z'),
3620                         "diaspora_handle" => $cnv["creator"],
3621                         "participant_handles" => $cnv["recips"]
3622                 );
3623
3624                 $body = bb2diaspora($item["body"]);
3625                 $created = datetime_convert("UTC", "UTC", $item["created"], 'Y-m-d\TH:i:s\Z');
3626
3627                 $signed_text = $item["guid"].";".$cnv["guid"].";".$body.";".$created.";".$myaddr.";".$cnv['guid'];
3628                 $sig = base64_encode(rsa_sign($signed_text, $owner["uprvkey"], "sha256"));
3629
3630                 $msg = array(
3631                         "guid" => $item["guid"],
3632                         "parent_guid" => $cnv["guid"],
3633                         "parent_author_signature" => $sig,
3634                         "author_signature" => $sig,
3635                         "text" => $body,
3636                         "created_at" => $created,
3637                         "diaspora_handle" => $myaddr,
3638                         "conversation_guid" => $cnv["guid"]
3639                 );
3640
3641                 if ($item["reply"]) {
3642                         $message = $msg;
3643                         $type = "message";
3644                 } else {
3645                         $message = array("guid" => $cnv["guid"],
3646                                         "subject" => $cnv["subject"],
3647                                         "created_at" => datetime_convert("UTC", "UTC", $cnv['created'], 'Y-m-d\TH:i:s\Z'),
3648                                         "message" => $msg,
3649                                         "diaspora_handle" => $cnv["creator"],
3650                                         "participant_handles" => $cnv["recips"]);
3651
3652                         $type = "conversation";
3653                 }
3654
3655                 return self::build_and_transmit($owner, $contact, $type, $message, false, $item["guid"]);
3656         }
3657
3658         /**
3659          * @brief Sends profile data
3660          *
3661          * @param int $uid The user id
3662          */
3663         public static function send_profile($uid, $recips = false) {
3664
3665                 if (!$uid)
3666                         return;
3667
3668                 if (!$recips)
3669                         $recips = q("SELECT `id`,`name`,`network`,`pubkey`,`notify` FROM `contact` WHERE `network` = '%s'
3670                                 AND `uid` = %d AND `rel` != %d",
3671                                 dbesc(NETWORK_DIASPORA),
3672                                 intval($uid),
3673                                 intval(CONTACT_IS_SHARING)
3674                         );
3675                 if (!$recips)
3676                         return;
3677
3678                 $r = q("SELECT `profile`.`uid` AS `profile_uid`, `profile`.* , `user`.*, `user`.`prvkey` AS `uprvkey`, `contact`.`addr`
3679                         FROM `profile`
3680                         INNER JOIN `user` ON `profile`.`uid` = `user`.`uid`
3681                         INNER JOIN `contact` ON `profile`.`uid` = `contact`.`uid`
3682                         WHERE `user`.`uid` = %d AND `profile`.`is-default` AND `contact`.`self` LIMIT 1",
3683                         intval($uid)
3684                 );
3685
3686                 if (!$r)
3687                         return;
3688
3689                 $profile = $r[0];
3690
3691                 $handle = $profile["addr"];
3692                 $first = ((strpos($profile['name'],' ')
3693                         ? trim(substr($profile['name'],0,strpos($profile['name'],' '))) : $profile['name']));
3694                 $last = (($first === $profile['name']) ? '' : trim(substr($profile['name'], strlen($first))));
3695                 $large = App::get_baseurl().'/photo/custom/300/'.$profile['uid'].'.jpg';
3696                 $medium = App::get_baseurl().'/photo/custom/100/'.$profile['uid'].'.jpg';
3697                 $small = App::get_baseurl().'/photo/custom/50/'  .$profile['uid'].'.jpg';
3698                 $searchable = (($profile['publish'] && $profile['net-publish']) ? 'true' : 'false');
3699
3700                 if ($searchable === 'true') {
3701                         $dob = '1000-00-00';
3702
3703                         if (($profile['dob']) && ($profile['dob'] > '0001-01-01'))
3704                                 $dob = ((intval($profile['dob'])) ? intval($profile['dob']) : '1000') .'-'. datetime_convert('UTC','UTC',$profile['dob'],'m-d');
3705
3706                         $about = $profile['about'];
3707                         $about = strip_tags(bbcode($about));
3708
3709                         $location = formatted_location($profile);
3710                         $tags = '';
3711                         if ($profile['pub_keywords']) {
3712                                 $kw = str_replace(',',' ',$profile['pub_keywords']);
3713                                 $kw = str_replace('  ',' ',$kw);
3714                                 $arr = explode(' ',$profile['pub_keywords']);
3715                                 if (count($arr)) {
3716                                         for ($x = 0; $x < 5; $x ++) {
3717                                                 if (trim($arr[$x]))
3718                                                         $tags .= '#'. trim($arr[$x]) .' ';
3719                                         }
3720                                 }
3721                         }
3722                         $tags = trim($tags);
3723                 }
3724
3725                 $message = array("diaspora_handle" => $handle,
3726                                 "first_name" => $first,
3727                                 "last_name" => $last,
3728                                 "image_url" => $large,
3729                                 "image_url_medium" => $medium,
3730                                 "image_url_small" => $small,
3731                                 "birthday" => $dob,
3732                                 "gender" => $profile['gender'],
3733                                 "bio" => $about,
3734                                 "location" => $location,
3735                                 "searchable" => $searchable,
3736                                 "tag_string" => $tags);
3737
3738                 foreach ($recips as $recip) {
3739                         logger("Send updated profile data for user ".$uid." to contact ".$recip["id"], LOGGER_DEBUG);
3740                         self::build_and_transmit($profile, $recip, "profile", $message, false, "", true);
3741                 }
3742         }
3743
3744         /**
3745          * @brief Stores the signature for likes that are created on our system
3746          *
3747          * @param array $contact The contact array of the "like"
3748          * @param int $post_id The post id of the "like"
3749          *
3750          * @return bool Success
3751          */
3752         public static function store_like_signature($contact, $post_id) {
3753
3754                 // Is the contact the owner? Then fetch the private key
3755                 if (!$contact['self'] OR ($contact['uid'] == 0)) {
3756                         logger("No owner post, so not storing signature", LOGGER_DEBUG);
3757                         return false;
3758                 }
3759
3760                 $r = q("SELECT `prvkey` FROM `user` WHERE `uid` = %d LIMIT 1", intval($contact['uid']));
3761                 if (!dbm::is_result($r)) {
3762                         return false;
3763                 }
3764
3765                 $contact["uprvkey"] = $r[0]['prvkey'];
3766
3767                 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1", intval($post_id));
3768                 if (!dbm::is_result($r)) {
3769                         return false;
3770                 }
3771
3772                 if (!in_array($r[0]["verb"], array(ACTIVITY_LIKE, ACTIVITY_DISLIKE))) {
3773                         return false;
3774                 }
3775
3776                 $message = self::construct_like($r[0], $contact);
3777                 $message["author_signature"] = self::signature($contact, $message);
3778
3779                 // We now store the signature more flexible to dynamically support new fields.
3780                 // This will break Diaspora compatibility with Friendica versions prior to 3.5.
3781                 q("INSERT INTO `sign` (`iid`,`signed_text`) VALUES (%d,'%s')",
3782                         intval($message_id),
3783                         dbesc(json_encode($message))
3784                 );
3785
3786                 logger('Stored diaspora like signature');
3787                 return true;
3788         }
3789
3790         /**
3791          * @brief Stores the signature for comments that are created on our system
3792          *
3793          * @param array $item The item array of the comment
3794          * @param array $contact The contact array of the item owner
3795          * @param string $uprvkey The private key of the sender
3796          * @param int $message_id The message id of the comment
3797          *
3798          * @return bool Success
3799          */
3800         public static function store_comment_signature($item, $contact, $uprvkey, $message_id) {
3801
3802                 if ($uprvkey == "") {
3803                         logger('No private key, so not storing comment signature', LOGGER_DEBUG);
3804                         return false;
3805                 }
3806
3807                 $contact["uprvkey"] = $uprvkey;
3808
3809                 $message = self::construct_comment($item, $contact);
3810                 $message["author_signature"] = self::signature($contact, $message);
3811
3812                 // We now store the signature more flexible to dynamically support new fields.
3813                 // This will break Diaspora compatibility with Friendica versions prior to 3.5.
3814                 q("INSERT INTO `sign` (`iid`,`signed_text`) VALUES (%d,'%s')",
3815                         intval($message_id),
3816                         dbesc(json_encode($message))
3817                 );
3818
3819                 logger('Stored diaspora comment signature');
3820                 return true;
3821         }
3822 }