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