Rename dbesc to DBA::escape
[friendica.git/.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\DBA;
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\Map;
33 use Friendica\Util\Network;
34 use Friendica\Util\XML;
35 use SimpleXMLElement;
36
37 require_once 'include/dba.php';
38 require_once 'include/items.php';
39
40 /**
41  * @brief This class contain functions to create and send Diaspora XML files
42  *
43  */
44 class Diaspora
45 {
46         /**
47          * @brief Return a list of relay servers
48          *
49          * The list contains not only the official relays but also servers that we serve directly
50          *
51          * @param integer $item_id  The id of the item that is sent
52          * @param array   $contacts The previously fetched contacts
53          *
54          * @return array of relay servers
55          */
56         public static function relayList($item_id, array $contacts = [])
57         {
58                 $serverlist = [];
59
60                 // Fetching relay servers
61                 $serverdata = Config::get("system", "relay_server");
62
63                 if (!empty($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 (!DBA::isResult($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 (DBA::isResult($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 (DBA::isResult($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, array $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, array $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(array $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(array $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(array $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 (DBA::isResult($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 (!DBA::isResult($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 (!DBA::isResult($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 (DBA::isResult($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 (DBA::isResult($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                         DBA::escape(NETWORK_DIASPORA),
1020                         DBA::escape($fcontact_guid)
1021                 );
1022
1023                 if (DBA::isResult($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                 $cid = Contact::getIdForURL($handle, $uid);
1043                 if (!$cid) {
1044                         $handle_parts = explode("@", $handle);
1045                         $nurl_sql = "%%://" . $handle_parts[1] . "%%/profile/" . $handle_parts[0];
1046                         $cid = Contact::getIdForURL($nurl_sql, $uid);
1047                 }
1048
1049                 if (!$cid) {
1050                         logger("Haven't found a contact for user " . $uid . " and handle " . $handle, LOGGER_DEBUG);
1051                         return false;
1052                 }
1053
1054                 $contact = dba::selectFirst('contact', [], ['id' => $cid]);
1055                 if (!DBA::isResult($contact)) {
1056                         // This here shouldn't happen at all
1057                         logger("Haven't found a contact for user " . $uid . " and handle " . $handle, LOGGER_DEBUG);
1058                         return false;
1059                 }
1060
1061                 return $contact;
1062         }
1063
1064         /**
1065          * @brief Check if posting is allowed for this contact
1066          *
1067          * @param array $importer   Array of the importer user
1068          * @param array $contact    The contact that is checked
1069          * @param bool  $is_comment Is the check for a comment?
1070          *
1071          * @return bool is the contact allowed to post?
1072          */
1073         private static function postAllow(array $importer, array $contact, $is_comment = false)
1074         {
1075                 /*
1076                  * Perhaps we were already sharing with this person. Now they're sharing with us.
1077                  * That makes us friends.
1078                  * Normally this should have handled by getting a request - but this could get lost
1079                  */
1080                 // It is deactivated by now, due to side effects. See issue https://github.com/friendica/friendica/pull/4033
1081                 // It is not removed by now. Possibly the code is needed?
1082                 //if (!$is_comment && $contact["rel"] == CONTACT_IS_FOLLOWER && in_array($importer["page-flags"], array(PAGE_FREELOVE))) {
1083                 //      dba::update(
1084                 //              'contact',
1085                 //              array('rel' => CONTACT_IS_FRIEND, 'writable' => true),
1086                 //              array('id' => $contact["id"], 'uid' => $contact["uid"])
1087                 //      );
1088                 //
1089                 //      $contact["rel"] = CONTACT_IS_FRIEND;
1090                 //      logger("defining user ".$contact["nick"]." as friend");
1091                 //}
1092
1093                 // We don't seem to like that person
1094                 if ($contact["blocked"]) {
1095                         // Maybe blocked, don't accept.
1096                         return false;
1097                         // We are following this person?
1098                 } elseif (($contact["rel"] == CONTACT_IS_SHARING) || ($contact["rel"] == CONTACT_IS_FRIEND)) {
1099                         // Yes, then it is fine.
1100                         return true;
1101                         // Is it a post to a community?
1102                 } elseif (($contact["rel"] == CONTACT_IS_FOLLOWER) && in_array($importer["page-flags"], [PAGE_COMMUNITY, PAGE_PRVGROUP])) {
1103                         // That's good
1104                         return true;
1105                         // Is the message a global user or a comment?
1106                 } elseif (($importer["uid"] == 0) || $is_comment) {
1107                         // Messages for the global users and comments are always accepted
1108                         return true;
1109                 }
1110
1111                 return false;
1112         }
1113
1114         /**
1115          * @brief Fetches the contact id for a handle and checks if posting is allowed
1116          *
1117          * @param array  $importer   Array of the importer user
1118          * @param string $handle     The checked handle in the format user@domain.tld
1119          * @param bool   $is_comment Is the check for a comment?
1120          *
1121          * @return array The contact data
1122          */
1123         private static function allowedContactByHandle(array $importer, $handle, $is_comment = false)
1124         {
1125                 $contact = self::contactByHandle($importer["uid"], $handle);
1126                 if (!$contact) {
1127                         logger("A Contact for handle ".$handle." and user ".$importer["uid"]." was not found");
1128                         // If a contact isn't found, we accept it anyway if it is a comment
1129                         if ($is_comment && ($importer["uid"] != 0)) {
1130                                 return self::contactByHandle(0, $handle);
1131                         } elseif ($is_comment) {
1132                                 return $importer;
1133                         } else {
1134                                 return false;
1135                         }
1136                 }
1137
1138                 if (!self::postAllow($importer, $contact, $is_comment)) {
1139                         logger("The handle: ".$handle." is not allowed to post to user ".$importer["uid"]);
1140                         return false;
1141                 }
1142                 return $contact;
1143         }
1144
1145         /**
1146          * @brief Does the message already exists on the system?
1147          *
1148          * @param int    $uid  The user id
1149          * @param string $guid The guid of the message
1150          *
1151          * @return int|bool message id if the message already was stored into the system - or false.
1152          */
1153         private static function messageExists($uid, $guid)
1154         {
1155                 $item = Item::selectFirst(['id'], ['uid' => $uid, 'guid' => $guid]);
1156                 if (DBA::isResult($item)) {
1157                         logger("message ".$guid." already exists for user ".$uid);
1158                         return $item["id"];
1159                 }
1160
1161                 return false;
1162         }
1163
1164         /**
1165          * @brief Checks for links to posts in a message
1166          *
1167          * @param array $item The item array
1168          * @return void
1169          */
1170         private static function fetchGuid(array $item)
1171         {
1172                 $expression = "=diaspora://.*?/post/([0-9A-Za-z\-_@.:]{15,254}[0-9A-Za-z])=ism";
1173                 preg_replace_callback(
1174                         $expression,
1175                         function ($match) use ($item) {
1176                                 self::fetchGuidSub($match, $item);
1177                         },
1178                         $item["body"]
1179                 );
1180
1181                 preg_replace_callback(
1182                         "&\[url=/posts/([^\[\]]*)\](.*)\[\/url\]&Usi",
1183                         function ($match) use ($item) {
1184                                 self::fetchGuidSub($match, $item);
1185                         },
1186                         $item["body"]
1187                 );
1188         }
1189
1190         /**
1191          * @brief Checks for relative /people/* links in an item body to match local
1192          * contacts or prepends the remote host taken from the author link.
1193          *
1194          * @param string $body        The item body to replace links from
1195          * @param string $author_link The author link for missing local contact fallback
1196          *
1197          * @return string the replaced string
1198          */
1199         public static function replacePeopleGuid($body, $author_link)
1200         {
1201                 $return = preg_replace_callback(
1202                         "&\[url=/people/([^\[\]]*)\](.*)\[\/url\]&Usi",
1203                         function ($match) use ($author_link) {
1204                                 // $match
1205                                 // 0 => '[url=/people/0123456789abcdef]Foo Bar[/url]'
1206                                 // 1 => '0123456789abcdef'
1207                                 // 2 => 'Foo Bar'
1208                                 $handle = self::urlFromContactGuid($match[1]);
1209
1210                                 if ($handle) {
1211                                         $return = '@[url='.$handle.']'.$match[2].'[/url]';
1212                                 } else {
1213                                         // No local match, restoring absolute remote URL from author scheme and host
1214                                         $author_url = parse_url($author_link);
1215                                         $return = '[url='.$author_url['scheme'].'://'.$author_url['host'].'/people/'.$match[1].']'.$match[2].'[/url]';
1216                                 }
1217
1218                                 return $return;
1219                         },
1220                         $body
1221                 );
1222
1223                 return $return;
1224         }
1225
1226         /**
1227          * @brief sub function of "fetchGuid" which checks for links in messages
1228          *
1229          * @param array $match array containing a link that has to be checked for a message link
1230          * @param array $item  The item array
1231          * @return void
1232          */
1233         private static function fetchGuidSub($match, $item)
1234         {
1235                 if (!self::storeByGuid($match[1], $item["author-link"])) {
1236                         self::storeByGuid($match[1], $item["owner-link"]);
1237                 }
1238         }
1239
1240         /**
1241          * @brief Fetches an item with a given guid from a given server
1242          *
1243          * @param string $guid   the message guid
1244          * @param string $server The server address
1245          * @param int    $uid    The user id of the user
1246          *
1247          * @return int the message id of the stored message or false
1248          */
1249         private static function storeByGuid($guid, $server, $uid = 0)
1250         {
1251                 $serverparts = parse_url($server);
1252
1253                 if (empty($serverparts["host"]) || empty($serverparts["scheme"])) {
1254                         return false;
1255                 }
1256
1257                 $server = $serverparts["scheme"]."://".$serverparts["host"];
1258
1259                 logger("Trying to fetch item ".$guid." from ".$server, LOGGER_DEBUG);
1260
1261                 $msg = self::message($guid, $server);
1262
1263                 if (!$msg) {
1264                         return false;
1265                 }
1266
1267                 logger("Successfully fetched item ".$guid." from ".$server, LOGGER_DEBUG);
1268
1269                 // Now call the dispatcher
1270                 return self::dispatchPublic($msg);
1271         }
1272
1273         /**
1274          * @brief Fetches a message from a server
1275          *
1276          * @param string $guid   message guid
1277          * @param string $server The url of the server
1278          * @param int    $level  Endless loop prevention
1279          *
1280          * @return array
1281          *      'message' => The message XML
1282          *      'author' => The author handle
1283          *      'key' => The public key of the author
1284          */
1285         private static function message($guid, $server, $level = 0)
1286         {
1287                 if ($level > 5) {
1288                         return false;
1289                 }
1290
1291                 // This will work for new Diaspora servers and Friendica servers from 3.5
1292                 $source_url = $server."/fetch/post/".urlencode($guid);
1293
1294                 logger("Fetch post from ".$source_url, LOGGER_DEBUG);
1295
1296                 $envelope = Network::fetchUrl($source_url);
1297                 if ($envelope) {
1298                         logger("Envelope was fetched.", LOGGER_DEBUG);
1299                         $x = self::verifyMagicEnvelope($envelope);
1300                         if (!$x) {
1301                                 logger("Envelope could not be verified.", LOGGER_DEBUG);
1302                         } else {
1303                                 logger("Envelope was verified.", LOGGER_DEBUG);
1304                         }
1305                 } else {
1306                         $x = false;
1307                 }
1308
1309                 // This will work for older Diaspora and Friendica servers
1310                 if (!$x) {
1311                         $source_url = $server."/p/".urlencode($guid).".xml";
1312                         logger("Fetch post from ".$source_url, LOGGER_DEBUG);
1313
1314                         $x = Network::fetchUrl($source_url);
1315                         if (!$x) {
1316                                 return false;
1317                         }
1318                 }
1319
1320                 $source_xml = XML::parseString($x);
1321
1322                 if (!is_object($source_xml)) {
1323                         return false;
1324                 }
1325
1326                 if ($source_xml->post->reshare) {
1327                         // Reshare of a reshare - old Diaspora version
1328                         logger("Message is a reshare", LOGGER_DEBUG);
1329                         return self::message($source_xml->post->reshare->root_guid, $server, ++$level);
1330                 } elseif ($source_xml->getName() == "reshare") {
1331                         // Reshare of a reshare - new Diaspora version
1332                         logger("Message is a new reshare", LOGGER_DEBUG);
1333                         return self::message($source_xml->root_guid, $server, ++$level);
1334                 }
1335
1336                 $author = "";
1337
1338                 // Fetch the author - for the old and the new Diaspora version
1339                 if ($source_xml->post->status_message && $source_xml->post->status_message->diaspora_handle) {
1340                         $author = (string)$source_xml->post->status_message->diaspora_handle;
1341                 } elseif ($source_xml->author && ($source_xml->getName() == "status_message")) {
1342                         $author = (string)$source_xml->author;
1343                 }
1344
1345                 // If this isn't a "status_message" then quit
1346                 if (!$author) {
1347                         logger("Message doesn't seem to be a status message", LOGGER_DEBUG);
1348                         return false;
1349                 }
1350
1351                 $msg = ["message" => $x, "author" => $author];
1352
1353                 $msg["key"] = self::key($msg["author"]);
1354
1355                 return $msg;
1356         }
1357
1358         /**
1359          * @brief Fetches the item record of a given guid
1360          *
1361          * @param int    $uid     The user id
1362          * @param string $guid    message guid
1363          * @param string $author  The handle of the item
1364          * @param array  $contact The contact of the item owner
1365          *
1366          * @return array the item record
1367          */
1368         private static function parentItem($uid, $guid, $author, array $contact)
1369         {
1370                 $fields = ['id', 'parent', 'body', 'wall', 'uri', 'guid', 'private', 'origin',
1371                         'author-name', 'author-link', 'author-avatar',
1372                         'owner-name', 'owner-link', 'owner-avatar'];
1373                 $condition = ['uid' => $uid, 'guid' => $guid];
1374                 $item = Item::selectFirst($fields, $condition);
1375
1376                 if (!DBA::isResult($item)) {
1377                         $result = self::storeByGuid($guid, $contact["url"], $uid);
1378
1379                         if (!$result) {
1380                                 $person = self::personByHandle($author);
1381                                 $result = self::storeByGuid($guid, $person["url"], $uid);
1382                         }
1383
1384                         if ($result) {
1385                                 logger("Fetched missing item ".$guid." - result: ".$result, LOGGER_DEBUG);
1386
1387                                 $item = Item::selectFirst($fields, $condition);
1388                         }
1389                 }
1390
1391                 if (!DBA::isResult($item)) {
1392                         logger("parent item not found: parent: ".$guid." - user: ".$uid);
1393                         return false;
1394                 } else {
1395                         logger("parent item found: parent: ".$guid." - user: ".$uid);
1396                         return $item;
1397                 }
1398         }
1399
1400         /**
1401          * @brief returns contact details
1402          *
1403          * @param array $def_contact The default contact if the person isn't found
1404          * @param array $person      The record of the person
1405          * @param int   $uid         The user id
1406          *
1407          * @return array
1408          *      'cid' => contact id
1409          *      'network' => network type
1410          */
1411         private static function authorContactByUrl($def_contact, $person, $uid)
1412         {
1413                 $condition = ['nurl' => normalise_link($person["url"]), 'uid' => $uid];
1414                 $contact = DBA::selectFirst('contact', ['id', 'network'], $condition);
1415                 if (DBA::isResult($contact)) {
1416                         $cid = $contact["id"];
1417                         $network = $contact["network"];
1418                 } else {
1419                         $cid = $def_contact["id"];
1420                         $network = NETWORK_DIASPORA;
1421                 }
1422
1423                 return ["cid" => $cid, "network" => $network];
1424         }
1425
1426         /**
1427          * @brief Is the profile a hubzilla profile?
1428          *
1429          * @param string $url The profile link
1430          *
1431          * @return bool is it a hubzilla server?
1432          */
1433         public static function isRedmatrix($url)
1434         {
1435                 return(strstr($url, "/channel/"));
1436         }
1437
1438         /**
1439          * @brief Generate a post link with a given handle and message guid
1440          *
1441          * @param string $addr        The user handle
1442          * @param string $guid        message guid
1443          * @param string $parent_guid optional parent guid
1444          *
1445          * @return string the post link
1446          */
1447         private static function plink($addr, $guid, $parent_guid = '')
1448         {
1449                 $contact = Contact::getDetailsByAddr($addr);
1450
1451                 // Fallback
1452                 if (!$contact) {
1453                         if ($parent_guid != '') {
1454                                 return "https://" . substr($addr, strpos($addr, "@") + 1) . "/posts/" . $parent_guid . "#" . $guid;
1455                         } else {
1456                                 return "https://" . substr($addr, strpos($addr, "@") + 1) . "/posts/" . $guid;
1457                         }
1458                 }
1459
1460                 if ($contact["network"] == NETWORK_DFRN) {
1461                         return str_replace("/profile/" . $contact["nick"] . "/", "/display/" . $guid, $contact["url"] . "/");
1462                 }
1463
1464                 if (self::isRedmatrix($contact["url"])) {
1465                         return $contact["url"] . "/?f=&mid=" . $guid;
1466                 }
1467
1468                 if ($parent_guid != '') {
1469                         return "https://" . substr($addr, strpos($addr, "@") + 1) . "/posts/" . $parent_guid . "#" . $guid;
1470                 } else {
1471                         return "https://" . substr($addr, strpos($addr, "@") + 1) . "/posts/" . $guid;
1472                 }
1473         }
1474
1475         /**
1476          * @brief Receives account migration
1477          *
1478          * @param array  $importer Array of the importer user
1479          * @param object $data     The message object
1480          *
1481          * @return bool Success
1482          */
1483         private static function receiveAccountMigration(array $importer, $data)
1484         {
1485                 $old_handle = notags(unxmlify($data->author));
1486                 $new_handle = notags(unxmlify($data->profile->author));
1487                 $signature = notags(unxmlify($data->signature));
1488
1489                 $contact = self::contactByHandle($importer["uid"], $old_handle);
1490                 if (!$contact) {
1491                         logger("cannot find contact for sender: ".$old_handle." and user ".$importer["uid"]);
1492                         return false;
1493                 }
1494
1495                 logger("Got migration for ".$old_handle.", to ".$new_handle." with user ".$importer["uid"]);
1496
1497                 // Check signature
1498                 $signed_text = 'AccountMigration:'.$old_handle.':'.$new_handle;
1499                 $key = self::key($old_handle);
1500                 if (!Crypto::rsaVerify($signed_text, $signature, $key, "sha256")) {
1501                         logger('No valid signature for migration.');
1502                         return false;
1503                 }
1504
1505                 // Update the profile
1506                 self::receiveProfile($importer, $data->profile);
1507
1508                 // change the technical stuff in contact and gcontact
1509                 $data = Probe::uri($new_handle);
1510                 if ($data['network'] == NETWORK_PHANTOM) {
1511                         logger('Account for '.$new_handle." couldn't be probed.");
1512                         return false;
1513                 }
1514
1515                 $fields = ['url' => $data['url'], 'nurl' => normalise_link($data['url']),
1516                                 'name' => $data['name'], 'nick' => $data['nick'],
1517                                 'addr' => $data['addr'], 'batch' => $data['batch'],
1518                                 'notify' => $data['notify'], 'poll' => $data['poll'],
1519                                 'network' => $data['network']];
1520
1521                 DBA::update('contact', $fields, ['addr' => $old_handle]);
1522
1523                 $fields = ['url' => $data['url'], 'nurl' => normalise_link($data['url']),
1524                                 'name' => $data['name'], 'nick' => $data['nick'],
1525                                 'addr' => $data['addr'], 'connect' => $data['addr'],
1526                                 'notify' => $data['notify'], 'photo' => $data['photo'],
1527                                 'server_url' => $data['baseurl'], 'network' => $data['network']];
1528
1529                 DBA::update('gcontact', $fields, ['addr' => $old_handle]);
1530
1531                 logger('Contacts are updated.');
1532
1533                 return true;
1534         }
1535
1536         /**
1537          * @brief Processes an account deletion
1538          *
1539          * @param object $data     The message object
1540          *
1541          * @return bool Success
1542          */
1543         private static function receiveAccountDeletion($data)
1544         {
1545                 $author = notags(unxmlify($data->author));
1546
1547                 $contacts = DBA::select('contact', ['id'], ['addr' => $author]);
1548                 while ($contact = DBA::fetch($contacts)) {
1549                         Contact::remove($contact["id"]);
1550                 }
1551
1552                 DBA::delete('gcontact', ['addr' => $author]);
1553
1554                 logger('Removed contacts for ' . $author);
1555
1556                 return true;
1557         }
1558
1559         /**
1560          * @brief Fetch the uri from our database if we already have this item (maybe from ourselves)
1561          *
1562          * @param string  $author    Author handle
1563          * @param string  $guid      Message guid
1564          * @param boolean $onlyfound Only return uri when found in the database
1565          *
1566          * @return string The constructed uri or the one from our database
1567          */
1568         private static function getUriFromGuid($author, $guid, $onlyfound = false)
1569         {
1570                 $item = Item::selectFirst(['uri'], ['guid' => $guid]);
1571                 if (DBA::isResult($item)) {
1572                         return $item["uri"];
1573                 } elseif (!$onlyfound) {
1574                         $contact = Contact::getDetailsByAddr($author, 0);
1575                         if (!empty($contact['network'])) {
1576                                 $prefix = 'urn:X-' . $contact['network'] . ':';
1577                         } else {
1578                                 // This fallback should happen most unlikely
1579                                 $prefix = 'urn:X-dspr:';
1580                         }
1581
1582                         $author_parts = explode('@', $author);
1583
1584                         return $prefix . $author_parts[1] . ':' . $author_parts[0] . ':'. $guid;
1585                 }
1586
1587                 return "";
1588         }
1589
1590         /**
1591          * @brief Fetch the guid from our database with a given uri
1592          *
1593          * @param string $uri Message uri
1594          * @param string $uid Author handle
1595          *
1596          * @return string The post guid
1597          */
1598         private static function getGuidFromUri($uri, $uid)
1599         {
1600                 $item = Item::selectFirst(['guid'], ['uri' => $uri, 'uid' => $uid]);
1601                 if (DBA::isResult($item)) {
1602                         return $item["guid"];
1603                 } else {
1604                         return false;
1605                 }
1606         }
1607
1608         /**
1609          * @brief Find the best importer for a comment, like, ...
1610          *
1611          * @param string $guid The guid of the item
1612          *
1613          * @return array|boolean the origin owner of that post - or false
1614          */
1615         private static function importerForGuid($guid)
1616         {
1617                 $item = Item::selectFirst(['uid'], ['origin' => true, 'guid' => $guid]);
1618                 if (DBA::isResult($item)) {
1619                         logger("Found user ".$item['uid']." as owner of item ".$guid, LOGGER_DEBUG);
1620                         $contact = DBA::selectFirst('contact', [], ['self' => true, 'uid' => $item['uid']]);
1621                         if (DBA::isResult($contact)) {
1622                                 return $contact;
1623                         }
1624                 }
1625                 return false;
1626         }
1627
1628         /**
1629          * @brief Processes an incoming comment
1630          *
1631          * @param array  $importer Array of the importer user
1632          * @param string $sender   The sender of the message
1633          * @param object $data     The message object
1634          * @param string $xml      The original XML of the message
1635          *
1636          * @return int The message id of the generated comment or "false" if there was an error
1637          */
1638         private static function receiveComment(array $importer, $sender, $data, $xml)
1639         {
1640                 $author = notags(unxmlify($data->author));
1641                 $guid = notags(unxmlify($data->guid));
1642                 $parent_guid = notags(unxmlify($data->parent_guid));
1643                 $text = unxmlify($data->text);
1644
1645                 if (isset($data->created_at)) {
1646                         $created_at = DateTimeFormat::utc(notags(unxmlify($data->created_at)));
1647                 } else {
1648                         $created_at = DateTimeFormat::utcNow();
1649                 }
1650
1651                 if (isset($data->thread_parent_guid)) {
1652                         $thread_parent_guid = notags(unxmlify($data->thread_parent_guid));
1653                         $thr_uri = self::getUriFromGuid("", $thread_parent_guid, true);
1654                 } else {
1655                         $thr_uri = "";
1656                 }
1657
1658                 $contact = self::allowedContactByHandle($importer, $sender, true);
1659                 if (!$contact) {
1660                         return false;
1661                 }
1662
1663                 $message_id = self::messageExists($importer["uid"], $guid);
1664                 if ($message_id) {
1665                         return true;
1666                 }
1667
1668                 $parent_item = self::parentItem($importer["uid"], $parent_guid, $author, $contact);
1669                 if (!$parent_item) {
1670                         return false;
1671                 }
1672
1673                 $person = self::personByHandle($author);
1674                 if (!is_array($person)) {
1675                         logger("unable to find author details");
1676                         return false;
1677                 }
1678
1679                 // Fetch the contact id - if we know this contact
1680                 $author_contact = self::authorContactByUrl($contact, $person, $importer["uid"]);
1681
1682                 $datarray = [];
1683
1684                 $datarray["uid"] = $importer["uid"];
1685                 $datarray["contact-id"] = $author_contact["cid"];
1686                 $datarray["network"]  = $author_contact["network"];
1687
1688                 $datarray["author-link"] = $person["url"];
1689                 $datarray["author-id"] = Contact::getIdForURL($person["url"], 0);
1690
1691                 $datarray["owner-link"] = $contact["url"];
1692                 $datarray["owner-id"] = Contact::getIdForURL($contact["url"], 0);
1693
1694                 $datarray["guid"] = $guid;
1695                 $datarray["uri"] = self::getUriFromGuid($author, $guid);
1696
1697                 $datarray["verb"] = ACTIVITY_POST;
1698                 $datarray["gravity"] = GRAVITY_COMMENT;
1699
1700                 if ($thr_uri != "") {
1701                         $datarray["parent-uri"] = $thr_uri;
1702                 } else {
1703                         $datarray["parent-uri"] = $parent_item["uri"];
1704                 }
1705
1706                 $datarray["object-type"] = ACTIVITY_OBJ_COMMENT;
1707
1708                 $datarray["protocol"] = PROTOCOL_DIASPORA;
1709                 $datarray["source"] = $xml;
1710
1711                 $datarray["changed"] = $datarray["created"] = $datarray["edited"] = $created_at;
1712
1713                 $datarray["plink"] = self::plink($author, $guid, $parent_item['guid']);
1714
1715                 $body = Markdown::toBBCode($text);
1716
1717                 $datarray["body"] = self::replacePeopleGuid($body, $person["url"]);
1718
1719                 self::fetchGuid($datarray);
1720
1721                 // If we are the origin of the parent we store the original data.
1722                 // We notify our followers during the item storage.
1723                 if ($parent_item["origin"]) {
1724                         $datarray['diaspora_signed_text'] = json_encode($data);
1725                 }
1726
1727                 $message_id = Item::insert($datarray);
1728
1729                 if ($message_id <= 0) {
1730                         return false;
1731                 }
1732
1733                 if ($message_id) {
1734                         logger("Stored comment ".$datarray["guid"]." with message id ".$message_id, LOGGER_DEBUG);
1735                         if ($datarray['uid'] == 0) {
1736                                 Item::distribute($message_id, json_encode($data));
1737                         }
1738                 }
1739
1740                 return true;
1741         }
1742
1743         /**
1744          * @brief processes and stores private messages
1745          *
1746          * @param array  $importer     Array of the importer user
1747          * @param array  $contact      The contact of the message
1748          * @param object $data         The message object
1749          * @param array  $msg          Array of the processed message, author handle and key
1750          * @param object $mesg         The private message
1751          * @param array  $conversation The conversation record to which this message belongs
1752          *
1753          * @return bool "true" if it was successful
1754          */
1755         private static function receiveConversationMessage(array $importer, array $contact, $data, $msg, $mesg, $conversation)
1756         {
1757                 $author = notags(unxmlify($data->author));
1758                 $guid = notags(unxmlify($data->guid));
1759                 $subject = notags(unxmlify($data->subject));
1760
1761                 // "diaspora_handle" is the element name from the old version
1762                 // "author" is the element name from the new version
1763                 if ($mesg->author) {
1764                         $msg_author = notags(unxmlify($mesg->author));
1765                 } elseif ($mesg->diaspora_handle) {
1766                         $msg_author = notags(unxmlify($mesg->diaspora_handle));
1767                 } else {
1768                         return false;
1769                 }
1770
1771                 $msg_guid = notags(unxmlify($mesg->guid));
1772                 $msg_conversation_guid = notags(unxmlify($mesg->conversation_guid));
1773                 $msg_text = unxmlify($mesg->text);
1774                 $msg_created_at = DateTimeFormat::utc(notags(unxmlify($mesg->created_at)));
1775
1776                 if ($msg_conversation_guid != $guid) {
1777                         logger("message conversation guid does not belong to the current conversation.");
1778                         return false;
1779                 }
1780
1781                 $body = Markdown::toBBCode($msg_text);
1782                 $message_uri = $msg_author.":".$msg_guid;
1783
1784                 $person = self::personByHandle($msg_author);
1785
1786                 DBA::lock('mail');
1787
1788                 $r = q(
1789                         "SELECT `id` FROM `mail` WHERE `guid` = '%s' AND `uid` = %d LIMIT 1",
1790                         DBA::escape($msg_guid),
1791                         intval($importer["uid"])
1792                 );
1793                 if (DBA::isResult($r)) {
1794                         logger("duplicate message already delivered.", LOGGER_DEBUG);
1795                         return false;
1796                 }
1797
1798                 q(
1799                         "INSERT INTO `mail` (`uid`, `guid`, `convid`, `from-name`,`from-photo`,`from-url`,`contact-id`,`title`,`body`,`seen`,`reply`,`uri`,`parent-uri`,`created`)
1800                         VALUES (%d, '%s', %d, '%s', '%s', '%s', %d, '%s', '%s', %d, %d, '%s','%s','%s')",
1801                         intval($importer["uid"]),
1802                         DBA::escape($msg_guid),
1803                         intval($conversation["id"]),
1804                         DBA::escape($person["name"]),
1805                         DBA::escape($person["photo"]),
1806                         DBA::escape($person["url"]),
1807                         intval($contact["id"]),
1808                         DBA::escape($subject),
1809                         DBA::escape($body),
1810                         0,
1811                         0,
1812                         DBA::escape($message_uri),
1813                         DBA::escape($author.":".$guid),
1814                         DBA::escape($msg_created_at)
1815                 );
1816
1817                 DBA::unlock();
1818
1819                 DBA::update('conv', ['updated' => DateTimeFormat::utcNow()], ['id' => $conversation["id"]]);
1820
1821                 notification(
1822                         [
1823                         "type" => NOTIFY_MAIL,
1824                         "notify_flags" => $importer["notify-flags"],
1825                         "language" => $importer["language"],
1826                         "to_name" => $importer["username"],
1827                         "to_email" => $importer["email"],
1828                         "uid" =>$importer["uid"],
1829                         "item" => ["subject" => $subject, "body" => $body],
1830                         "source_name" => $person["name"],
1831                         "source_link" => $person["url"],
1832                         "source_photo" => $person["thumb"],
1833                         "verb" => ACTIVITY_POST,
1834                         "otype" => "mail"]
1835                 );
1836                 return true;
1837         }
1838
1839         /**
1840          * @brief Processes new private messages (answers to private messages are processed elsewhere)
1841          *
1842          * @param array  $importer Array of the importer user
1843          * @param array  $msg      Array of the processed message, author handle and key
1844          * @param object $data     The message object
1845          *
1846          * @return bool Success
1847          */
1848         private static function receiveConversation(array $importer, $msg, $data)
1849         {
1850                 $author = notags(unxmlify($data->author));
1851                 $guid = notags(unxmlify($data->guid));
1852                 $subject = notags(unxmlify($data->subject));
1853                 $created_at = DateTimeFormat::utc(notags(unxmlify($data->created_at)));
1854                 $participants = notags(unxmlify($data->participants));
1855
1856                 $messages = $data->message;
1857
1858                 if (!count($messages)) {
1859                         logger("empty conversation");
1860                         return false;
1861                 }
1862
1863                 $contact = self::allowedContactByHandle($importer, $msg["author"], true);
1864                 if (!$contact) {
1865                         return false;
1866                 }
1867
1868                 $conversation = null;
1869
1870                 $c = q(
1871                         "SELECT * FROM `conv` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
1872                         intval($importer["uid"]),
1873                         DBA::escape($guid)
1874                 );
1875                 if ($c)
1876                         $conversation = $c[0];
1877                 else {
1878                         $r = q(
1879                                 "INSERT INTO `conv` (`uid`, `guid`, `creator`, `created`, `updated`, `subject`, `recips`)
1880                                 VALUES (%d, '%s', '%s', '%s', '%s', '%s', '%s')",
1881                                 intval($importer["uid"]),
1882                                 DBA::escape($guid),
1883                                 DBA::escape($author),
1884                                 DBA::escape($created_at),
1885                                 DBA::escape(DateTimeFormat::utcNow()),
1886                                 DBA::escape($subject),
1887                                 DBA::escape($participants)
1888                         );
1889                         if ($r) {
1890                                 $c = q(
1891                                         "SELECT * FROM `conv` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
1892                                         intval($importer["uid"]),
1893                                         DBA::escape($guid)
1894                                 );
1895                         }
1896
1897                         if ($c) {
1898                                 $conversation = $c[0];
1899                         }
1900                 }
1901                 if (!$conversation) {
1902                         logger("unable to create conversation.");
1903                         return false;
1904                 }
1905
1906                 foreach ($messages as $mesg) {
1907                         self::receiveConversationMessage($importer, $contact, $data, $msg, $mesg, $conversation);
1908                 }
1909
1910                 return true;
1911         }
1912
1913         /**
1914          * @brief Processes "like" messages
1915          *
1916          * @param array  $importer Array of the importer user
1917          * @param string $sender   The sender of the message
1918          * @param object $data     The message object
1919          *
1920          * @return int The message id of the generated like or "false" if there was an error
1921          */
1922         private static function receiveLike(array $importer, $sender, $data)
1923         {
1924                 $author = notags(unxmlify($data->author));
1925                 $guid = notags(unxmlify($data->guid));
1926                 $parent_guid = notags(unxmlify($data->parent_guid));
1927                 $parent_type = notags(unxmlify($data->parent_type));
1928                 $positive = notags(unxmlify($data->positive));
1929
1930                 // likes on comments aren't supported by Diaspora - only on posts
1931                 // But maybe this will be supported in the future, so we will accept it.
1932                 if (!in_array($parent_type, ["Post", "Comment"])) {
1933                         return false;
1934                 }
1935
1936                 $contact = self::allowedContactByHandle($importer, $sender, true);
1937                 if (!$contact) {
1938                         return false;
1939                 }
1940
1941                 $message_id = self::messageExists($importer["uid"], $guid);
1942                 if ($message_id) {
1943                         return true;
1944                 }
1945
1946                 $parent_item = self::parentItem($importer["uid"], $parent_guid, $author, $contact);
1947                 if (!$parent_item) {
1948                         return false;
1949                 }
1950
1951                 $person = self::personByHandle($author);
1952                 if (!is_array($person)) {
1953                         logger("unable to find author details");
1954                         return false;
1955                 }
1956
1957                 // Fetch the contact id - if we know this contact
1958                 $author_contact = self::authorContactByUrl($contact, $person, $importer["uid"]);
1959
1960                 // "positive" = "false" would be a Dislike - wich isn't currently supported by Diaspora
1961                 // We would accept this anyhow.
1962                 if ($positive == "true") {
1963                         $verb = ACTIVITY_LIKE;
1964                 } else {
1965                         $verb = ACTIVITY_DISLIKE;
1966                 }
1967
1968                 $datarray = [];
1969
1970                 $datarray["protocol"] = PROTOCOL_DIASPORA;
1971
1972                 $datarray["uid"] = $importer["uid"];
1973                 $datarray["contact-id"] = $author_contact["cid"];
1974                 $datarray["network"]  = $author_contact["network"];
1975
1976                 $datarray["author-link"] = $person["url"];
1977                 $datarray["author-id"] = Contact::getIdForURL($person["url"], 0);
1978
1979                 $datarray["owner-link"] = $contact["url"];
1980                 $datarray["owner-id"] = Contact::getIdForURL($contact["url"], 0);
1981
1982                 $datarray["guid"] = $guid;
1983                 $datarray["uri"] = self::getUriFromGuid($author, $guid);
1984
1985                 $datarray["verb"] = $verb;
1986                 $datarray["gravity"] = GRAVITY_ACTIVITY;
1987                 $datarray["parent-uri"] = $parent_item["uri"];
1988
1989                 $datarray["object-type"] = ACTIVITY_OBJ_NOTE;
1990
1991                 $datarray["body"] = $verb;
1992
1993                 // Diaspora doesn't provide a date for likes
1994                 $datarray["changed"] = $datarray["created"] = $datarray["edited"] = DateTimeFormat::utcNow();
1995
1996                 // like on comments have the comment as parent. So we need to fetch the toplevel parent
1997                 if ($parent_item["id"] != $parent_item["parent"]) {
1998                         $toplevel = Item::selectFirst(['origin'], ['id' => $parent_item["parent"]]);
1999                         $origin = $toplevel["origin"];
2000                 } else {
2001                         $origin = $parent_item["origin"];
2002                 }
2003
2004                 // If we are the origin of the parent we store the original data.
2005                 // We notify our followers during the item storage.
2006                 if ($origin) {
2007                         $datarray['diaspora_signed_text'] = json_encode($data);
2008                 }
2009
2010                 $message_id = Item::insert($datarray);
2011
2012                 if ($message_id <= 0) {
2013                         return false;
2014                 }
2015
2016                 if ($message_id) {
2017                         logger("Stored like ".$datarray["guid"]." with message id ".$message_id, LOGGER_DEBUG);
2018                         if ($datarray['uid'] == 0) {
2019                                 Item::distribute($message_id, json_encode($data));
2020                         }
2021                 }
2022
2023                 return true;
2024         }
2025
2026         /**
2027          * @brief Processes private messages
2028          *
2029          * @param array  $importer Array of the importer user
2030          * @param object $data     The message object
2031          *
2032          * @return bool Success?
2033          */
2034         private static function receiveMessage(array $importer, $data)
2035         {
2036                 $author = notags(unxmlify($data->author));
2037                 $guid = notags(unxmlify($data->guid));
2038                 $conversation_guid = notags(unxmlify($data->conversation_guid));
2039                 $text = unxmlify($data->text);
2040                 $created_at = DateTimeFormat::utc(notags(unxmlify($data->created_at)));
2041
2042                 $contact = self::allowedContactByHandle($importer, $author, true);
2043                 if (!$contact) {
2044                         return false;
2045                 }
2046
2047                 $conversation = null;
2048
2049                 $c = q(
2050                         "SELECT * FROM `conv` WHERE `uid` = %d AND `guid` = '%s' LIMIT 1",
2051                         intval($importer["uid"]),
2052                         DBA::escape($conversation_guid)
2053                 );
2054                 if ($c) {
2055                         $conversation = $c[0];
2056                 } else {
2057                         logger("conversation not available.");
2058                         return false;
2059                 }
2060
2061                 $message_uri = $author.":".$guid;
2062
2063                 $person = self::personByHandle($author);
2064                 if (!$person) {
2065                         logger("unable to find author details");
2066                         return false;
2067                 }
2068
2069                 $body = Markdown::toBBCode($text);
2070
2071                 $body = self::replacePeopleGuid($body, $person["url"]);
2072
2073                 DBA::lock('mail');
2074
2075                 $r = q(
2076                         "SELECT `id` FROM `mail` WHERE `guid` = '%s' AND `uid` = %d LIMIT 1",
2077                         DBA::escape($guid),
2078                         intval($importer["uid"])
2079                 );
2080                 if (DBA::isResult($r)) {
2081                         logger("duplicate message already delivered.", LOGGER_DEBUG);
2082                         return false;
2083                 }
2084
2085                 q(
2086                         "INSERT INTO `mail` (`uid`, `guid`, `convid`, `from-name`,`from-photo`,`from-url`,`contact-id`,`title`,`body`,`seen`,`reply`,`uri`,`parent-uri`,`created`)
2087                                 VALUES ( %d, '%s', %d, '%s', '%s', '%s', %d, '%s', '%s', %d, %d, '%s','%s','%s')",
2088                         intval($importer["uid"]),
2089                         DBA::escape($guid),
2090                         intval($conversation["id"]),
2091                         DBA::escape($person["name"]),
2092                         DBA::escape($person["photo"]),
2093                         DBA::escape($person["url"]),
2094                         intval($contact["id"]),
2095                         DBA::escape($conversation["subject"]),
2096                         DBA::escape($body),
2097                         0,
2098                         1,
2099                         DBA::escape($message_uri),
2100                         DBA::escape($author.":".$conversation["guid"]),
2101                         DBA::escape($created_at)
2102                 );
2103
2104                 DBA::unlock();
2105
2106                 DBA::update('conv', ['updated' => DateTimeFormat::utcNow()], ['id' => $conversation["id"]]);
2107                 return true;
2108         }
2109
2110         /**
2111          * @brief Processes participations - unsupported by now
2112          *
2113          * @param array  $importer Array of the importer user
2114          * @param object $data     The message object
2115          *
2116          * @return bool always true
2117          */
2118         private static function receiveParticipation(array $importer, $data)
2119         {
2120                 $author = strtolower(notags(unxmlify($data->author)));
2121                 $parent_guid = notags(unxmlify($data->parent_guid));
2122
2123                 $contact_id = Contact::getIdForURL($author);
2124                 if (!$contact_id) {
2125                         logger('Contact not found: '.$author);
2126                         return false;
2127                 }
2128
2129                 $person = self::personByHandle($author);
2130                 if (!is_array($person)) {
2131                         logger("Person not found: ".$author);
2132                         return false;
2133                 }
2134
2135                 $item = Item::selectFirst(['id'], ['guid' => $parent_guid, 'origin' => true, 'private' => false]);
2136                 if (!DBA::isResult($item)) {
2137                         logger('Item not found, no origin or private: '.$parent_guid);
2138                         return false;
2139                 }
2140
2141                 $author_parts = explode('@', $author);
2142                 if (isset($author_parts[1])) {
2143                         $server = $author_parts[1];
2144                 } else {
2145                         // Should never happen
2146                         $server = $author;
2147                 }
2148
2149                 logger('Received participation for ID: '.$item['id'].' - Contact: '.$contact_id.' - Server: '.$server, LOGGER_DEBUG);
2150
2151                 if (!DBA::exists('participation', ['iid' => $item['id'], 'server' => $server])) {
2152                         DBA::insert('participation', ['iid' => $item['id'], 'cid' => $contact_id, 'fid' => $person['id'], 'server' => $server]);
2153                 }
2154
2155                 // Send all existing comments and likes to the requesting server
2156                 $comments = Item::select(['id', 'parent', 'verb', 'self'], ['parent' => $item['id']]);
2157                 while ($comment = Item::fetch($comments)) {
2158                         if ($comment['id'] == $comment['parent']) {
2159                                 continue;
2160                         }
2161                         if ($comment['verb'] == ACTIVITY_POST) {
2162                                 $cmd = $comment['self'] ? 'comment-new' : 'comment-import';
2163                         } else {
2164                                 $cmd = $comment['self'] ? 'like' : 'comment-import';
2165                         }
2166                         logger("Send ".$cmd." for item ".$comment['id']." to contact ".$contact_id, LOGGER_DEBUG);
2167                         Worker::add(PRIORITY_HIGH, 'Delivery', $cmd, $comment['id'], $contact_id);
2168                 }
2169                 DBA::close($comments);
2170
2171                 return true;
2172         }
2173
2174         /**
2175          * @brief Processes photos - unneeded
2176          *
2177          * @param array  $importer Array of the importer user
2178          * @param object $data     The message object
2179          *
2180          * @return bool always true
2181          */
2182         private static function receivePhoto(array $importer, $data)
2183         {
2184                 // There doesn't seem to be a reason for this function,
2185                 // since the photo data is transmitted in the status message as well
2186                 return true;
2187         }
2188
2189         /**
2190          * @brief Processes poll participations - unssupported
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 receivePollParticipation(array $importer, $data)
2198         {
2199                 // We don't support polls by now
2200                 return true;
2201         }
2202
2203         /**
2204          * @brief Processes incoming profile updates
2205          *
2206          * @param array  $importer Array of the importer user
2207          * @param object $data     The message object
2208          *
2209          * @return bool Success
2210          */
2211         private static function receiveProfile(array $importer, $data)
2212         {
2213                 $author = strtolower(notags(unxmlify($data->author)));
2214
2215                 $contact = self::contactByHandle($importer["uid"], $author);
2216                 if (!$contact) {
2217                         return false;
2218                 }
2219
2220                 $name = unxmlify($data->first_name).((strlen($data->last_name)) ? " ".unxmlify($data->last_name) : "");
2221                 $image_url = unxmlify($data->image_url);
2222                 $birthday = unxmlify($data->birthday);
2223                 $gender = unxmlify($data->gender);
2224                 $about = Markdown::toBBCode(unxmlify($data->bio));
2225                 $location = Markdown::toBBCode(unxmlify($data->location));
2226                 $searchable = (unxmlify($data->searchable) == "true");
2227                 $nsfw = (unxmlify($data->nsfw) == "true");
2228                 $tags = unxmlify($data->tag_string);
2229
2230                 $tags = explode("#", $tags);
2231
2232                 $keywords = [];
2233                 foreach ($tags as $tag) {
2234                         $tag = trim(strtolower($tag));
2235                         if ($tag != "") {
2236                                 $keywords[] = $tag;
2237                         }
2238                 }
2239
2240                 $keywords = implode(", ", $keywords);
2241
2242                 $handle_parts = explode("@", $author);
2243                 $nick = $handle_parts[0];
2244
2245                 if ($name === "") {
2246                         $name = $handle_parts[0];
2247                 }
2248
2249                 if (preg_match("|^https?://|", $image_url) === 0) {
2250                         $image_url = "http://".$handle_parts[1].$image_url;
2251                 }
2252
2253                 Contact::updateAvatar($image_url, $importer["uid"], $contact["id"]);
2254
2255                 // Generic birthday. We don't know the timezone. The year is irrelevant.
2256
2257                 $birthday = str_replace("1000", "1901", $birthday);
2258
2259                 if ($birthday != "") {
2260                         $birthday = DateTimeFormat::utc($birthday, "Y-m-d");
2261                 }
2262
2263                 // this is to prevent multiple birthday notifications in a single year
2264                 // if we already have a stored birthday and the 'm-d' part hasn't changed, preserve the entry, which will preserve the notify year
2265
2266                 if (substr($birthday, 5) === substr($contact["bd"], 5)) {
2267                         $birthday = $contact["bd"];
2268                 }
2269
2270                 $fields = ['name' => $name, 'location' => $location,
2271                         'name-date' => DateTimeFormat::utcNow(),
2272                         'about' => $about, 'gender' => $gender,
2273                         'addr' => $author, 'nick' => $nick,
2274                         'keywords' => $keywords];
2275
2276                 if (!empty($birthday)) {
2277                         $fields['bd'] = $birthday;
2278                 }
2279
2280                 DBA::update('contact', $fields, ['id' => $contact['id']]);
2281
2282                 $gcontact = ["url" => $contact["url"], "network" => NETWORK_DIASPORA, "generation" => 2,
2283                                         "photo" => $image_url, "name" => $name, "location" => $location,
2284                                         "about" => $about, "birthday" => $birthday, "gender" => $gender,
2285                                         "addr" => $author, "nick" => $nick, "keywords" => $keywords,
2286                                         "hide" => !$searchable, "nsfw" => $nsfw];
2287
2288                 $gcid = GContact::update($gcontact);
2289
2290                 GContact::link($gcid, $importer["uid"], $contact["id"]);
2291
2292                 logger("Profile of contact ".$contact["id"]." stored for user ".$importer["uid"], LOGGER_DEBUG);
2293
2294                 return true;
2295         }
2296
2297         /**
2298          * @brief Processes incoming friend requests
2299          *
2300          * @param array $importer Array of the importer user
2301          * @param array $contact  The contact that send the request
2302          * @return void
2303          */
2304         private static function receiveRequestMakeFriend(array $importer, array $contact)
2305         {
2306                 $a = get_app();
2307
2308                 if ($contact["rel"] == CONTACT_IS_SHARING) {
2309                         DBA::update(
2310                                 'contact',
2311                                 ['rel' => CONTACT_IS_FRIEND, 'writable' => true],
2312                                 ['id' => $contact["id"], 'uid' => $importer["uid"]]
2313                         );
2314                 }
2315         }
2316
2317         /**
2318          * @brief Processes incoming sharing notification
2319          *
2320          * @param array  $importer Array of the importer user
2321          * @param object $data     The message object
2322          *
2323          * @return bool Success
2324          */
2325         private static function receiveContactRequest(array $importer, $data)
2326         {
2327                 $author = unxmlify($data->author);
2328                 $recipient = unxmlify($data->recipient);
2329
2330                 if (!$author || !$recipient) {
2331                         return false;
2332                 }
2333
2334                 // the current protocol version doesn't know these fields
2335                 // That means that we will assume their existance
2336                 if (isset($data->following)) {
2337                         $following = (unxmlify($data->following) == "true");
2338                 } else {
2339                         $following = true;
2340                 }
2341
2342                 if (isset($data->sharing)) {
2343                         $sharing = (unxmlify($data->sharing) == "true");
2344                 } else {
2345                         $sharing = true;
2346                 }
2347
2348                 $contact = self::contactByHandle($importer["uid"], $author);
2349
2350                 // perhaps we were already sharing with this person. Now they're sharing with us.
2351                 // That makes us friends.
2352                 if ($contact) {
2353                         if ($following) {
2354                                 logger("Author ".$author." (Contact ".$contact["id"].") wants to follow us.", LOGGER_DEBUG);
2355                                 self::receiveRequestMakeFriend($importer, $contact);
2356
2357                                 // refetch the contact array
2358                                 $contact = self::contactByHandle($importer["uid"], $author);
2359
2360                                 // If we are now friends, we are sending a share message.
2361                                 // Normally we needn't to do so, but the first message could have been vanished.
2362                                 if (in_array($contact["rel"], [CONTACT_IS_FRIEND])) {
2363                                         $u = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval($importer["uid"]));
2364                                         if ($u) {
2365                                                 logger("Sending share message to author ".$author." - Contact: ".$contact["id"]." - User: ".$importer["uid"], LOGGER_DEBUG);
2366                                                 $ret = self::sendShare($u[0], $contact);
2367                                         }
2368                                 }
2369                                 return true;
2370                         } else {
2371                                 logger("Author ".$author." doesn't want to follow us anymore.", LOGGER_DEBUG);
2372                                 Contact::removeFollower($importer, $contact);
2373                                 return true;
2374                         }
2375                 }
2376
2377                 if (!$following && $sharing && in_array($importer["page-flags"], [PAGE_SOAPBOX, PAGE_NORMAL])) {
2378                         logger("Author ".$author." wants to share with us - but doesn't want to listen. Request is ignored.", LOGGER_DEBUG);
2379                         return false;
2380                 } elseif (!$following && !$sharing) {
2381                         logger("Author ".$author." doesn't want anything - and we don't know the author. Request is ignored.", LOGGER_DEBUG);
2382                         return false;
2383                 } elseif (!$following && $sharing) {
2384                         logger("Author ".$author." wants to share with us.", LOGGER_DEBUG);
2385                 } elseif ($following && $sharing) {
2386                         logger("Author ".$author." wants to have a bidirectional conection.", LOGGER_DEBUG);
2387                 } elseif ($following && !$sharing) {
2388                         logger("Author ".$author." wants to listen to us.", LOGGER_DEBUG);
2389                 }
2390
2391                 $ret = self::personByHandle($author);
2392
2393                 if (!$ret || ($ret["network"] != NETWORK_DIASPORA)) {
2394                         logger("Cannot resolve diaspora handle ".$author." for ".$recipient);
2395                         return false;
2396                 }
2397
2398                 $batch = (($ret["batch"]) ? $ret["batch"] : implode("/", array_slice(explode("/", $ret["url"]), 0, 3))."/receive/public");
2399
2400                 $r = q(
2401                         "INSERT INTO `contact` (`uid`, `network`,`addr`,`created`,`url`,`nurl`,`batch`,`name`,`nick`,`photo`,`pubkey`,`notify`,`poll`,`blocked`,`priority`)
2402                         VALUES (%d, '%s', '%s', '%s', '%s','%s','%s','%s','%s','%s','%s','%s','%s',%d,%d)",
2403                         intval($importer["uid"]),
2404                         DBA::escape($ret["network"]),
2405                         DBA::escape($ret["addr"]),
2406                         DateTimeFormat::utcNow(),
2407                         DBA::escape($ret["url"]),
2408                         DBA::escape(normalise_link($ret["url"])),
2409                         DBA::escape($batch),
2410                         DBA::escape($ret["name"]),
2411                         DBA::escape($ret["nick"]),
2412                         DBA::escape($ret["photo"]),
2413                         DBA::escape($ret["pubkey"]),
2414                         DBA::escape($ret["notify"]),
2415                         DBA::escape($ret["poll"]),
2416                         1,
2417                         2
2418                 );
2419
2420                 // find the contact record we just created
2421
2422                 $contact_record = self::contactByHandle($importer["uid"], $author);
2423
2424                 if (!$contact_record) {
2425                         logger("unable to locate newly created contact record.");
2426                         return;
2427                 }
2428
2429                 logger("Author ".$author." was added as contact number ".$contact_record["id"].".", LOGGER_DEBUG);
2430
2431                 Group::addMember(User::getDefaultGroup($importer['uid'], $ret["network"]), $contact_record['id']);
2432
2433                 Contact::updateAvatar($ret["photo"], $importer['uid'], $contact_record["id"], true);
2434
2435                 if (in_array($importer["page-flags"], [PAGE_NORMAL, PAGE_PRVGROUP])) {
2436                         logger("Sending intra message for author ".$author.".", LOGGER_DEBUG);
2437
2438                         $hash = random_string().(string)time();   // Generate a confirm_key
2439
2440                         $ret = q(
2441                                 "INSERT INTO `intro` (`uid`, `contact-id`, `blocked`, `knowyou`, `note`, `hash`, `datetime`)
2442                                 VALUES (%d, %d, %d, %d, '%s', '%s', '%s')",
2443                                 intval($importer["uid"]),
2444                                 intval($contact_record["id"]),
2445                                 0,
2446                                 0,
2447                                 DBA::escape(L10n::t("Sharing notification from Diaspora network")),
2448                                 DBA::escape($hash),
2449                                 DBA::escape(DateTimeFormat::utcNow())
2450                         );
2451                 } else {
2452                         // automatic friend approval
2453
2454                         logger("Does an automatic friend approval for author ".$author.".", LOGGER_DEBUG);
2455
2456                         Contact::updateAvatar($contact_record["photo"], $importer["uid"], $contact_record["id"]);
2457
2458                         // technically they are sharing with us (CONTACT_IS_SHARING),
2459                         // but if our page-type is PAGE_COMMUNITY or PAGE_SOAPBOX
2460                         // we are going to change the relationship and make them a follower.
2461
2462                         if (($importer["page-flags"] == PAGE_FREELOVE) && $sharing && $following) {
2463                                 $new_relation = CONTACT_IS_FRIEND;
2464                         } elseif (($importer["page-flags"] == PAGE_FREELOVE) && $sharing) {
2465                                 $new_relation = CONTACT_IS_SHARING;
2466                         } else {
2467                                 $new_relation = CONTACT_IS_FOLLOWER;
2468                         }
2469
2470                         $r = q(
2471                                 "UPDATE `contact` SET `rel` = %d,
2472                                 `name-date` = '%s',
2473                                 `uri-date` = '%s',
2474                                 `blocked` = 0,
2475                                 `pending` = 0,
2476                                 `writable` = 1
2477                                 WHERE `id` = %d
2478                                 ",
2479                                 intval($new_relation),
2480                                 DBA::escape(DateTimeFormat::utcNow()),
2481                                 DBA::escape(DateTimeFormat::utcNow()),
2482                                 intval($contact_record["id"])
2483                         );
2484
2485                         $u = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval($importer["uid"]));
2486                         if ($u) {
2487                                 logger("Sending share message (Relation: ".$new_relation.") to author ".$author." - Contact: ".$contact_record["id"]." - User: ".$importer["uid"], LOGGER_DEBUG);
2488                                 $ret = self::sendShare($u[0], $contact_record);
2489
2490                                 // Send the profile data, maybe it weren't transmitted before
2491                                 self::sendProfile($importer["uid"], [$contact_record]);
2492                         }
2493                 }
2494
2495                 return true;
2496         }
2497
2498         /**
2499          * @brief Fetches a message with a given guid
2500          *
2501          * @param string $guid        message guid
2502          * @param string $orig_author handle of the original post
2503          * @param string $author      handle of the sharer
2504          *
2505          * @return array The fetched item
2506          */
2507         public static function originalItem($guid, $orig_author)
2508         {
2509                 if (empty($guid)) {
2510                         logger('Empty guid. Quitting.');
2511                         return false;
2512                 }
2513
2514                 // Do we already have this item?
2515                 $fields = ['body', 'tag', 'app', 'created', 'object-type', 'uri', 'guid',
2516                         'author-name', 'author-link', 'author-avatar'];
2517                 $condition = ['guid' => $guid, 'visible' => true, 'deleted' => false, 'private' => false];
2518                 $item = Item::selectFirst($fields, $condition);
2519
2520                 if (DBA::isResult($item)) {
2521                         logger("reshared message ".$guid." already exists on system.");
2522
2523                         // Maybe it is already a reshared item?
2524                         // Then refetch the content, if it is a reshare from a reshare.
2525                         // If it is a reshared post from another network then reformat to avoid display problems with two share elements
2526                         if (self::isReshare($item["body"], true)) {
2527                                 $item = [];
2528                         } elseif (self::isReshare($item["body"], false) || strstr($item["body"], "[share")) {
2529                                 $item["body"] = Markdown::toBBCode(BBCode::toMarkdown($item["body"]));
2530
2531                                 $item["body"] = self::replacePeopleGuid($item["body"], $item["author-link"]);
2532
2533                                 // Add OEmbed and other information to the body
2534                                 $item["body"] = add_page_info_to_body($item["body"], false, true);
2535
2536                                 return $item;
2537                         } else {
2538                                 return $item;
2539                         }
2540                 }
2541
2542                 if (!DBA::isResult($item)) {
2543                         if (empty($orig_author)) {
2544                                 logger('Empty author for guid ' . $guid . '. Quitting.');
2545                                 return false;
2546                         }
2547
2548                         $server = "https://".substr($orig_author, strpos($orig_author, "@") + 1);
2549                         logger("1st try: reshared message ".$guid." will be fetched via SSL from the server ".$server);
2550                         $stored = self::storeByGuid($guid, $server);
2551
2552                         if (!$stored) {
2553                                 $server = "http://".substr($orig_author, strpos($orig_author, "@") + 1);
2554                                 logger("2nd try: reshared message ".$guid." will be fetched without SSL from the server ".$server);
2555                                 $stored = self::storeByGuid($guid, $server);
2556                         }
2557
2558                         if ($stored) {
2559                                 $fields = ['body', 'tag', 'app', 'created', 'object-type', 'uri', 'guid',
2560                                         'author-name', 'author-link', 'author-avatar'];
2561                                 $condition = ['guid' => $guid, 'visible' => true, 'deleted' => false, 'private' => false];
2562                                 $item = Item::selectFirst($fields, $condition);
2563
2564                                 if (DBA::isResult($item)) {
2565                                         // If it is a reshared post from another network then reformat to avoid display problems with two share elements
2566                                         if (self::isReshare($item["body"], false)) {
2567                                                 $item["body"] = Markdown::toBBCode(BBCode::toMarkdown($item["body"]));
2568                                                 $item["body"] = self::replacePeopleGuid($item["body"], $item["author-link"]);
2569                                         }
2570
2571                                         return $item;
2572                                 }
2573                         }
2574                 }
2575                 return false;
2576         }
2577
2578         /**
2579          * @brief Processes a reshare message
2580          *
2581          * @param array  $importer Array of the importer user
2582          * @param object $data     The message object
2583          * @param string $xml      The original XML of the message
2584          *
2585          * @return int the message id
2586          */
2587         private static function receiveReshare(array $importer, $data, $xml)
2588         {
2589                 $author = notags(unxmlify($data->author));
2590                 $guid = notags(unxmlify($data->guid));
2591                 $created_at = DateTimeFormat::utc(notags(unxmlify($data->created_at)));
2592                 $root_author = notags(unxmlify($data->root_author));
2593                 $root_guid = notags(unxmlify($data->root_guid));
2594                 /// @todo handle unprocessed property "provider_display_name"
2595                 $public = notags(unxmlify($data->public));
2596
2597                 $contact = self::allowedContactByHandle($importer, $author, false);
2598                 if (!$contact) {
2599                         return false;
2600                 }
2601
2602                 $message_id = self::messageExists($importer["uid"], $guid);
2603                 if ($message_id) {
2604                         return true;
2605                 }
2606
2607                 $original_item = self::originalItem($root_guid, $root_author);
2608                 if (!$original_item) {
2609                         return false;
2610                 }
2611
2612                 $orig_url = System::baseUrl()."/display/".$original_item["guid"];
2613
2614                 $datarray = [];
2615
2616                 $datarray["uid"] = $importer["uid"];
2617                 $datarray["contact-id"] = $contact["id"];
2618                 $datarray["network"]  = NETWORK_DIASPORA;
2619
2620                 $datarray["author-link"] = $contact["url"];
2621                 $datarray["author-id"] = Contact::getIdForURL($contact["url"], 0);
2622
2623                 $datarray["owner-link"] = $datarray["author-link"];
2624                 $datarray["owner-id"] = $datarray["author-id"];
2625
2626                 $datarray["guid"] = $guid;
2627                 $datarray["uri"] = $datarray["parent-uri"] = self::getUriFromGuid($author, $guid);
2628
2629                 $datarray["verb"] = ACTIVITY_POST;
2630                 $datarray["gravity"] = GRAVITY_PARENT;
2631
2632                 $datarray["protocol"] = PROTOCOL_DIASPORA;
2633                 $datarray["source"] = $xml;
2634
2635                 $prefix = share_header(
2636                         $original_item["author-name"],
2637                         $original_item["author-link"],
2638                         $original_item["author-avatar"],
2639                         $original_item["guid"],
2640                         $original_item["created"],
2641                         $orig_url
2642                 );
2643                 $datarray["body"] = $prefix.$original_item["body"]."[/share]";
2644
2645                 $datarray["tag"] = $original_item["tag"];
2646                 $datarray["app"]  = $original_item["app"];
2647
2648                 $datarray["plink"] = self::plink($author, $guid);
2649                 $datarray["private"] = (($public == "false") ? 1 : 0);
2650                 $datarray["changed"] = $datarray["created"] = $datarray["edited"] = $created_at;
2651
2652                 $datarray["object-type"] = $original_item["object-type"];
2653
2654                 self::fetchGuid($datarray);
2655                 $message_id = Item::insert($datarray);
2656
2657                 self::sendParticipation($contact, $datarray);
2658
2659                 if ($message_id) {
2660                         logger("Stored reshare ".$datarray["guid"]." with message id ".$message_id, LOGGER_DEBUG);
2661                         if ($datarray['uid'] == 0) {
2662                                 Item::distribute($message_id);
2663                         }
2664                         return true;
2665                 } else {
2666                         return false;
2667                 }
2668         }
2669
2670         /**
2671          * @brief Processes retractions
2672          *
2673          * @param array  $importer Array of the importer user
2674          * @param array  $contact  The contact of the item owner
2675          * @param object $data     The message object
2676          *
2677          * @return bool success
2678          */
2679         private static function itemRetraction(array $importer, array $contact, $data)
2680         {
2681                 $author = notags(unxmlify($data->author));
2682                 $target_guid = notags(unxmlify($data->target_guid));
2683                 $target_type = notags(unxmlify($data->target_type));
2684
2685                 $person = self::personByHandle($author);
2686                 if (!is_array($person)) {
2687                         logger("unable to find author detail for ".$author);
2688                         return false;
2689                 }
2690
2691                 if (empty($contact["url"])) {
2692                         $contact["url"] = $person["url"];
2693                 }
2694
2695                 // Fetch items that are about to be deleted
2696                 $fields = ['uid', 'id', 'parent', 'parent-uri', 'author-link', 'file'];
2697
2698                 // When we receive a public retraction, we delete every item that we find.
2699                 if ($importer['uid'] == 0) {
2700                         $condition = ['guid' => $target_guid, 'deleted' => false];
2701                 } else {
2702                         $condition = ['guid' => $target_guid, 'deleted' => false, 'uid' => $importer['uid']];
2703                 }
2704
2705                 $r = Item::select($fields, $condition);
2706                 if (!DBA::isResult($r)) {
2707                         logger("Target guid ".$target_guid." was not found on this system for user ".$importer['uid'].".");
2708                         return false;
2709                 }
2710
2711                 while ($item = Item::fetch($r)) {
2712                         if (strstr($item['file'], '[')) {
2713                                 logger("Target guid " . $target_guid . " for user " . $item['uid'] . " is filed. So it won't be deleted.", LOGGER_DEBUG);
2714                                 continue;
2715                         }
2716
2717                         // Fetch the parent item
2718                         $parent = Item::selectFirst(['author-link'], ['id' => $item["parent"]]);
2719
2720                         // Only delete it if the parent author really fits
2721                         if (!link_compare($parent["author-link"], $contact["url"]) && !link_compare($item["author-link"], $contact["url"])) {
2722                                 logger("Thread author ".$parent["author-link"]." and item author ".$item["author-link"]." don't fit to expected contact ".$contact["url"], LOGGER_DEBUG);
2723                                 continue;
2724                         }
2725
2726                         Item::delete(['id' => $item['id']]);
2727
2728                         logger("Deleted target ".$target_guid." (".$item["id"].") from user ".$item["uid"]." parent: ".$item["parent"], LOGGER_DEBUG);
2729                 }
2730
2731                 return true;
2732         }
2733
2734         /**
2735          * @brief Receives retraction messages
2736          *
2737          * @param array  $importer Array of the importer user
2738          * @param string $sender   The sender of the message
2739          * @param object $data     The message object
2740          *
2741          * @return bool Success
2742          */
2743         private static function receiveRetraction(array $importer, $sender, $data)
2744         {
2745                 $target_type = notags(unxmlify($data->target_type));
2746
2747                 $contact = self::contactByHandle($importer["uid"], $sender);
2748                 if (!$contact && (in_array($target_type, ["Contact", "Person"]))) {
2749                         logger("cannot find contact for sender: ".$sender." and user ".$importer["uid"]);
2750                         return false;
2751                 }
2752
2753                 if (!$contact) {
2754                         $contact = [];
2755                 }
2756
2757                 logger("Got retraction for ".$target_type.", sender ".$sender." and user ".$importer["uid"], LOGGER_DEBUG);
2758
2759                 switch ($target_type) {
2760                         case "Comment":
2761                         case "Like":
2762                         case "Post":
2763                         case "Reshare":
2764                         case "StatusMessage":
2765                                 return self::itemRetraction($importer, $contact, $data);
2766
2767                         case "PollParticipation":
2768                         case "Photo":
2769                                 // Currently unsupported
2770                                 break;
2771
2772                         default:
2773                                 logger("Unknown target type ".$target_type);
2774                                 return false;
2775                 }
2776                 return true;
2777         }
2778
2779         /**
2780          * @brief Receives status messages
2781          *
2782          * @param array  $importer Array of the importer user
2783          * @param object $data     The message object
2784          * @param string $xml      The original XML of the message
2785          *
2786          * @return int The message id of the newly created item
2787          */
2788         private static function receiveStatusMessage(array $importer, $data, $xml)
2789         {
2790                 $author = notags(unxmlify($data->author));
2791                 $guid = notags(unxmlify($data->guid));
2792                 $created_at = DateTimeFormat::utc(notags(unxmlify($data->created_at)));
2793                 $public = notags(unxmlify($data->public));
2794                 $text = unxmlify($data->text);
2795                 $provider_display_name = notags(unxmlify($data->provider_display_name));
2796
2797                 $contact = self::allowedContactByHandle($importer, $author, false);
2798                 if (!$contact) {
2799                         return false;
2800                 }
2801
2802                 $message_id = self::messageExists($importer["uid"], $guid);
2803                 if ($message_id) {
2804                         return true;
2805                 }
2806
2807                 $address = [];
2808                 if ($data->location) {
2809                         foreach ($data->location->children() as $fieldname => $data) {
2810                                 $address[$fieldname] = notags(unxmlify($data));
2811                         }
2812                 }
2813
2814                 $body = Markdown::toBBCode($text);
2815
2816                 $datarray = [];
2817
2818                 // Attach embedded pictures to the body
2819                 if ($data->photo) {
2820                         foreach ($data->photo as $photo) {
2821                                 $body = "[img]".unxmlify($photo->remote_photo_path).
2822                                         unxmlify($photo->remote_photo_name)."[/img]\n".$body;
2823                         }
2824
2825                         $datarray["object-type"] = ACTIVITY_OBJ_IMAGE;
2826                 } else {
2827                         $datarray["object-type"] = ACTIVITY_OBJ_NOTE;
2828
2829                         // Add OEmbed and other information to the body
2830                         if (!self::isRedmatrix($contact["url"])) {
2831                                 $body = add_page_info_to_body($body, false, true);
2832                         }
2833                 }
2834
2835                 /// @todo enable support for polls
2836                 //if ($data->poll) {
2837                 //      foreach ($data->poll AS $poll)
2838                 //              print_r($poll);
2839                 //      die("poll!\n");
2840                 //}
2841
2842                 /// @todo enable support for events
2843
2844                 $datarray["uid"] = $importer["uid"];
2845                 $datarray["contact-id"] = $contact["id"];
2846                 $datarray["network"] = NETWORK_DIASPORA;
2847
2848                 $datarray["author-link"] = $contact["url"];
2849                 $datarray["author-id"] = Contact::getIdForURL($contact["url"], 0);
2850
2851                 $datarray["owner-link"] = $datarray["author-link"];
2852                 $datarray["owner-id"] = $datarray["author-id"];
2853
2854                 $datarray["guid"] = $guid;
2855                 $datarray["uri"] = $datarray["parent-uri"] = self::getUriFromGuid($author, $guid);
2856
2857                 $datarray["verb"] = ACTIVITY_POST;
2858                 $datarray["gravity"] = GRAVITY_PARENT;
2859
2860                 $datarray["protocol"] = PROTOCOL_DIASPORA;
2861                 $datarray["source"] = $xml;
2862
2863                 $datarray["body"] = self::replacePeopleGuid($body, $contact["url"]);
2864
2865                 if ($provider_display_name != "") {
2866                         $datarray["app"] = $provider_display_name;
2867                 }
2868
2869                 $datarray["plink"] = self::plink($author, $guid);
2870                 $datarray["private"] = (($public == "false") ? 1 : 0);
2871                 $datarray["changed"] = $datarray["created"] = $datarray["edited"] = $created_at;
2872
2873                 if (isset($address["address"])) {
2874                         $datarray["location"] = $address["address"];
2875                 }
2876
2877                 if (isset($address["lat"]) && isset($address["lng"])) {
2878                         $datarray["coord"] = $address["lat"]." ".$address["lng"];
2879                 }
2880
2881                 self::fetchGuid($datarray);
2882                 $message_id = Item::insert($datarray);
2883
2884                 self::sendParticipation($contact, $datarray);
2885
2886                 if ($message_id) {
2887                         logger("Stored item ".$datarray["guid"]." with message id ".$message_id, LOGGER_DEBUG);
2888                         if ($datarray['uid'] == 0) {
2889                                 Item::distribute($message_id);
2890                         }
2891                         return true;
2892                 } else {
2893                         return false;
2894                 }
2895         }
2896
2897         /* ************************************************************************************** *
2898          * Here are all the functions that are needed to transmit data with the Diaspora protocol *
2899          * ************************************************************************************** */
2900
2901         /**
2902          * @brief returnes the handle of a contact
2903          *
2904          * @param array $contact contact array
2905          *
2906          * @return string the handle in the format user@domain.tld
2907          */
2908         private static function myHandle(array $contact)
2909         {
2910                 if (!empty($contact["addr"])) {
2911                         return $contact["addr"];
2912                 }
2913
2914                 // Normally we should have a filled "addr" field - but in the past this wasn't the case
2915                 // So - just in case - we build the the address here.
2916                 if ($contact["nickname"] != "") {
2917                         $nick = $contact["nickname"];
2918                 } else {
2919                         $nick = $contact["nick"];
2920                 }
2921
2922                 return $nick . "@" . substr(System::baseUrl(), strpos(System::baseUrl(), "://") + 3);
2923         }
2924
2925
2926         /**
2927          * @brief Creates the data for a private message in the new format
2928          *
2929          * @param string $msg     The message that is to be transmitted
2930          * @param array  $user    The record of the sender
2931          * @param array  $contact Target of the communication
2932          * @param string $prvkey  The private key of the sender
2933          * @param string $pubkey  The public key of the receiver
2934          *
2935          * @return string The encrypted data
2936          */
2937         public static function encodePrivateData($msg, array $user, array $contact, $prvkey, $pubkey)
2938         {
2939                 logger("Message: ".$msg, LOGGER_DATA);
2940
2941                 // without a public key nothing will work
2942                 if (!$pubkey) {
2943                         logger("pubkey missing: contact id: ".$contact["id"]);
2944                         return false;
2945                 }
2946
2947                 $aes_key = openssl_random_pseudo_bytes(32);
2948                 $b_aes_key = base64_encode($aes_key);
2949                 $iv = openssl_random_pseudo_bytes(16);
2950                 $b_iv = base64_encode($iv);
2951
2952                 $ciphertext = self::aesEncrypt($aes_key, $iv, $msg);
2953
2954                 $json = json_encode(["iv" => $b_iv, "key" => $b_aes_key]);
2955
2956                 $encrypted_key_bundle = "";
2957                 openssl_public_encrypt($json, $encrypted_key_bundle, $pubkey);
2958
2959                 $json_object = json_encode(
2960                         ["aes_key" => base64_encode($encrypted_key_bundle),
2961                                         "encrypted_magic_envelope" => base64_encode($ciphertext)]
2962                 );
2963
2964                 return $json_object;
2965         }
2966
2967         /**
2968          * @brief Creates the envelope for the "fetch" endpoint and for the new format
2969          *
2970          * @param string $msg  The message that is to be transmitted
2971          * @param array  $user The record of the sender
2972          *
2973          * @return string The envelope
2974          */
2975         public static function buildMagicEnvelope($msg, array $user)
2976         {
2977                 $b64url_data = base64url_encode($msg);
2978                 $data = str_replace(["\n", "\r", " ", "\t"], ["", "", "", ""], $b64url_data);
2979
2980                 $key_id = base64url_encode(self::myHandle($user));
2981                 $type = "application/xml";
2982                 $encoding = "base64url";
2983                 $alg = "RSA-SHA256";
2984                 $signable_data = $data.".".base64url_encode($type).".".base64url_encode($encoding).".".base64url_encode($alg);
2985
2986                 // Fallback if the private key wasn't transmitted in the expected field
2987                 if ($user['uprvkey'] == "") {
2988                         $user['uprvkey'] = $user['prvkey'];
2989                 }
2990
2991                 $signature = Crypto::rsaSign($signable_data, $user["uprvkey"]);
2992                 $sig = base64url_encode($signature);
2993
2994                 $xmldata = ["me:env" => ["me:data" => $data,
2995                                                         "@attributes" => ["type" => $type],
2996                                                         "me:encoding" => $encoding,
2997                                                         "me:alg" => $alg,
2998                                                         "me:sig" => $sig,
2999                                                         "@attributes2" => ["key_id" => $key_id]]];
3000
3001                 $namespaces = ["me" => "http://salmon-protocol.org/ns/magic-env"];
3002
3003                 return XML::fromArray($xmldata, $xml, false, $namespaces);
3004         }
3005
3006         /**
3007          * @brief Create the envelope for a message
3008          *
3009          * @param string $msg     The message that is to be transmitted
3010          * @param array  $user    The record of the sender
3011          * @param array  $contact Target of the communication
3012          * @param string $prvkey  The private key of the sender
3013          * @param string $pubkey  The public key of the receiver
3014          * @param bool   $public  Is the message public?
3015          *
3016          * @return string The message that will be transmitted to other servers
3017          */
3018         public static function buildMessage($msg, array $user, array $contact, $prvkey, $pubkey, $public = false)
3019         {
3020                 // The message is put into an envelope with the sender's signature
3021                 $envelope = self::buildMagicEnvelope($msg, $user);
3022
3023                 // Private messages are put into a second envelope, encrypted with the receivers public key
3024                 if (!$public) {
3025                         $envelope = self::encodePrivateData($envelope, $user, $contact, $prvkey, $pubkey);
3026                 }
3027
3028                 return $envelope;
3029         }
3030
3031         /**
3032          * @brief Creates a signature for a message
3033          *
3034          * @param array $owner   the array of the owner of the message
3035          * @param array $message The message that is to be signed
3036          *
3037          * @return string The signature
3038          */
3039         private static function signature($owner, $message)
3040         {
3041                 $sigmsg = $message;
3042                 unset($sigmsg["author_signature"]);
3043                 unset($sigmsg["parent_author_signature"]);
3044
3045                 $signed_text = implode(";", $sigmsg);
3046
3047                 return base64_encode(Crypto::rsaSign($signed_text, $owner["uprvkey"], "sha256"));
3048         }
3049
3050         /**
3051          * @brief Transmit a message to a target server
3052          *
3053          * @param array  $owner        the array of the item owner
3054          * @param array  $contact      Target of the communication
3055          * @param string $envelope     The message that is to be transmitted
3056          * @param bool   $public_batch Is it a public post?
3057          * @param bool   $queue_run    Is the transmission called from the queue?
3058          * @param string $guid         message guid
3059          *
3060          * @return int Result of the transmission
3061          */
3062         public static function transmit(array $owner, array $contact, $envelope, $public_batch, $queue_run = false, $guid = "", $no_queue = false)
3063         {
3064                 $a = get_app();
3065
3066                 $enabled = intval(Config::get("system", "diaspora_enabled"));
3067                 if (!$enabled) {
3068                         return 200;
3069                 }
3070
3071                 $logid = random_string(4);
3072
3073                 $dest_url = ($public_batch ? $contact["batch"] : $contact["notify"]);
3074
3075                 // We always try to use the data from the fcontact table.
3076                 // This is important for transmitting data to Friendica servers.
3077                 if (!empty($contact['addr'])) {
3078                         $fcontact = self::personByHandle($contact['addr']);
3079                         if (!empty($fcontact)) {
3080                                 $dest_url = ($public_batch ? $fcontact["batch"] : $fcontact["notify"]);
3081                         }
3082                 }
3083
3084                 if (!$dest_url) {
3085                         logger("no url for contact: ".$contact["id"]." batch mode =".$public_batch);
3086                         return 0;
3087                 }
3088
3089                 logger("transmit: ".$logid."-".$guid." ".$dest_url);
3090
3091                 if (!$queue_run && Queue::wasDelayed($contact["id"])) {
3092                         $return_code = 0;
3093                 } else {
3094                         if (!intval(Config::get("system", "diaspora_test"))) {
3095                                 $content_type = (($public_batch) ? "application/magic-envelope+xml" : "application/json");
3096
3097                                 Network::post($dest_url."/", $envelope, ["Content-Type: ".$content_type]);
3098                                 $return_code = $a->get_curl_code();
3099                         } else {
3100                                 logger("test_mode");
3101                                 return 200;
3102                         }
3103                 }
3104
3105                 logger("transmit: ".$logid."-".$guid." to ".$dest_url." returns: ".$return_code);
3106
3107                 if (!$return_code || (($return_code == 503) && (stristr($a->get_curl_headers(), "retry-after")))) {
3108                         if (!$no_queue && ($contact['contact-type'] != ACCOUNT_TYPE_RELAY)) {
3109                                 logger("queue message");
3110                                 // queue message for redelivery
3111                                 Queue::add($contact["id"], NETWORK_DIASPORA, $envelope, $public_batch, $guid);
3112                         }
3113
3114                         // The message could not be delivered. We mark the contact as "dead"
3115                         Contact::markForArchival($contact);
3116                 } elseif (($return_code >= 200) && ($return_code <= 299)) {
3117                         // We successfully delivered a message, the contact is alive
3118                         Contact::unmarkForArchival($contact);
3119                 }
3120
3121                 return $return_code ? $return_code : -1;
3122         }
3123
3124
3125         /**
3126          * @brief Build the post xml
3127          *
3128          * @param string $type    The message type
3129          * @param array  $message The message data
3130          *
3131          * @return string The post XML
3132          */
3133         public static function buildPostXml($type, $message)
3134         {
3135                 $data = [$type => $message];
3136
3137                 return XML::fromArray($data, $xml);
3138         }
3139
3140         /**
3141          * @brief Builds and transmit messages
3142          *
3143          * @param array  $owner        the array of the item owner
3144          * @param array  $contact      Target of the communication
3145          * @param string $type         The message type
3146          * @param array  $message      The message data
3147          * @param bool   $public_batch Is it a public post?
3148          * @param string $guid         message guid
3149          * @param bool   $spool        Should the transmission be spooled or transmitted?
3150          *
3151          * @return int Result of the transmission
3152          */
3153         private static function buildAndTransmit(array $owner, array $contact, $type, $message, $public_batch = false, $guid = "", $spool = false)
3154         {
3155                 $msg = self::buildPostXml($type, $message);
3156
3157                 logger('message: '.$msg, LOGGER_DATA);
3158                 logger('send guid '.$guid, LOGGER_DEBUG);
3159
3160                 // Fallback if the private key wasn't transmitted in the expected field
3161                 if (empty($owner['uprvkey'])) {
3162                         $owner['uprvkey'] = $owner['prvkey'];
3163                 }
3164
3165                 $envelope = self::buildMessage($msg, $owner, $contact, $owner['uprvkey'], $contact['pubkey'], $public_batch);
3166
3167                 if ($spool) {
3168                         Queue::add($contact['id'], NETWORK_DIASPORA, $envelope, $public_batch, $guid);
3169                         return true;
3170                 } else {
3171                         $return_code = self::transmit($owner, $contact, $envelope, $public_batch, false, $guid);
3172                 }
3173
3174                 logger("guid: ".$guid." result ".$return_code, LOGGER_DEBUG);
3175
3176                 return $return_code;
3177         }
3178
3179         /**
3180          * @brief sends a participation (Used to get all further updates)
3181          *
3182          * @param array $contact Target of the communication
3183          * @param array $item    Item array
3184          *
3185          * @return int The result of the transmission
3186          */
3187         private static function sendParticipation(array $contact, array $item)
3188         {
3189                 // Don't send notifications for private postings
3190                 if ($item['private']) {
3191                         return;
3192                 }
3193
3194                 $cachekey = "diaspora:sendParticipation:".$item['guid'];
3195
3196                 $result = Cache::get($cachekey);
3197                 if (!is_null($result)) {
3198                         return;
3199                 }
3200
3201                 // Fetch some user id to have a valid handle to transmit the participation.
3202                 // In fact it doesn't matter which user sends this - but it is needed by the protocol.
3203                 // If the item belongs to a user, we take this user id.
3204                 if ($item['uid'] == 0) {
3205                         $condition = ['verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false];
3206                         $first_user = DBA::selectFirst('user', ['uid'], $condition);
3207                         $owner = User::getOwnerDataById($first_user['uid']);
3208                 } else {
3209                         $owner = User::getOwnerDataById($item['uid']);
3210                 }
3211
3212                 $author = self::myHandle($owner);
3213
3214                 $message = ["author" => $author,
3215                                 "guid" => System::createGUID(32),
3216                                 "parent_type" => "Post",
3217                                 "parent_guid" => $item["guid"]];
3218
3219                 logger("Send participation for ".$item["guid"]." by ".$author, LOGGER_DEBUG);
3220
3221                 // It doesn't matter what we store, we only want to avoid sending repeated notifications for the same item
3222                 Cache::set($cachekey, $item["guid"], CACHE_QUARTER_HOUR);
3223
3224                 return self::buildAndTransmit($owner, $contact, "participation", $message);
3225         }
3226
3227         /**
3228          * @brief sends an account migration
3229          *
3230          * @param array $owner   the array of the item owner
3231          * @param array $contact Target of the communication
3232          * @param int   $uid     User ID
3233          *
3234          * @return int The result of the transmission
3235          */
3236         public static function sendAccountMigration(array $owner, array $contact, $uid)
3237         {
3238                 $old_handle = PConfig::get($uid, 'system', 'previous_addr');
3239                 $profile = self::createProfileData($uid);
3240
3241                 $signed_text = 'AccountMigration:'.$old_handle.':'.$profile['author'];
3242                 $signature = base64_encode(Crypto::rsaSign($signed_text, $owner["uprvkey"], "sha256"));
3243
3244                 $message = ["author" => $old_handle,
3245                                 "profile" => $profile,
3246                                 "signature" => $signature];
3247
3248                 logger("Send account migration ".print_r($message, true), LOGGER_DEBUG);
3249
3250                 return self::buildAndTransmit($owner, $contact, "account_migration", $message);
3251         }
3252
3253         /**
3254          * @brief Sends a "share" message
3255          *
3256          * @param array $owner   the array of the item owner
3257          * @param array $contact Target of the communication
3258          *
3259          * @return int The result of the transmission
3260          */
3261         public static function sendShare(array $owner, array $contact)
3262         {
3263                 /**
3264                  * @todo support the different possible combinations of "following" and "sharing"
3265                  * Currently, Diaspora only interprets the "sharing" field
3266                  *
3267                  * Before switching this code productive, we have to check all "sendShare" calls if "rel" is set correctly
3268                  */
3269
3270                 /*
3271                 switch ($contact["rel"]) {
3272                         case CONTACT_IS_FRIEND:
3273                                 $following = true;
3274                                 $sharing = true;
3275                         case CONTACT_IS_SHARING:
3276                                 $following = false;
3277                                 $sharing = true;
3278                         case CONTACT_IS_FOLLOWER:
3279                                 $following = true;
3280                                 $sharing = false;
3281                 }
3282                 */
3283
3284                 $message = ["author" => self::myHandle($owner),
3285                                 "recipient" => $contact["addr"],
3286                                 "following" => "true",
3287                                 "sharing" => "true"];
3288
3289                 logger("Send share ".print_r($message, true), LOGGER_DEBUG);
3290
3291                 return self::buildAndTransmit($owner, $contact, "contact", $message);
3292         }
3293
3294         /**
3295          * @brief sends an "unshare"
3296          *
3297          * @param array $owner   the array of the item owner
3298          * @param array $contact Target of the communication
3299          *
3300          * @return int The result of the transmission
3301          */
3302         public static function sendUnshare(array $owner, array $contact)
3303         {
3304                 $message = ["author" => self::myHandle($owner),
3305                                 "recipient" => $contact["addr"],
3306                                 "following" => "false",
3307                                 "sharing" => "false"];
3308
3309                 logger("Send unshare ".print_r($message, true), LOGGER_DEBUG);
3310
3311                 return self::buildAndTransmit($owner, $contact, "contact", $message);
3312         }
3313
3314         /**
3315          * @brief Checks a message body if it is a reshare
3316          *
3317          * @param string $body     The message body that is to be check
3318          * @param bool   $complete Should it be a complete check or a simple check?
3319          *
3320          * @return array|bool Reshare details or "false" if no reshare
3321          */
3322         public static function isReshare($body, $complete = true)
3323         {
3324                 $body = trim($body);
3325
3326                 // Skip if it isn't a pure repeated messages
3327                 // Does it start with a share?
3328                 if ((strpos($body, "[share") > 0) && $complete) {
3329                         return false;
3330                 }
3331
3332                 // Does it end with a share?
3333                 if (strlen($body) > (strrpos($body, "[/share]") + 8)) {
3334                         return false;
3335                 }
3336
3337                 $attributes = preg_replace("/\[share(.*?)\]\s?(.*?)\s?\[\/share\]\s?/ism", "$1", $body);
3338                 // Skip if there is no shared message in there
3339                 if ($body == $attributes) {
3340                         return false;
3341                 }
3342
3343                 // If we don't do the complete check we quit here
3344
3345                 $guid = "";
3346                 preg_match("/guid='(.*?)'/ism", $attributes, $matches);
3347                 if (!empty($matches[1])) {
3348                         $guid = $matches[1];
3349                 }
3350
3351                 preg_match('/guid="(.*?)"/ism', $attributes, $matches);
3352                 if (!empty($matches[1])) {
3353                         $guid = $matches[1];
3354                 }
3355
3356                 if (($guid != "") && $complete) {
3357                         $condition = ['guid' => $guid, 'network' => [NETWORK_DFRN, NETWORK_DIASPORA]];
3358                         $item = Item::selectFirst(['contact-id'], $condition);
3359                         if (DBA::isResult($item)) {
3360                                 $ret= [];
3361                                 $ret["root_handle"] = self::handleFromContact($item["contact-id"]);
3362                                 $ret["root_guid"] = $guid;
3363                                 return $ret;
3364                         } elseif ($complete) {
3365                                 // We are resharing something that isn't a DFRN or Diaspora post.
3366                                 // So we have to return "false" on "$complete" to not trigger a reshare.
3367                                 return false;
3368                         }
3369                 } elseif (($guid == "") && $complete) {
3370                         return false;
3371                 }
3372
3373                 $ret["root_guid"] = $guid;
3374
3375                 $profile = "";
3376                 preg_match("/profile='(.*?)'/ism", $attributes, $matches);
3377                 if (!empty($matches[1])) {
3378                         $profile = $matches[1];
3379                 }
3380
3381                 preg_match('/profile="(.*?)"/ism', $attributes, $matches);
3382                 if (!empty($matches[1])) {
3383                         $profile = $matches[1];
3384                 }
3385
3386                 $ret= [];
3387
3388                 if ($profile != "") {
3389                         if (Contact::getIdForURL($profile)) {
3390                                 $author = Contact::getDetailsByURL($profile);
3391                                 $ret["root_handle"] = $author['addr'];
3392                         }
3393                 }
3394
3395                 if (empty($ret) && !$complete) {
3396                         return true;
3397                 }
3398
3399                 return $ret;
3400         }
3401
3402         /**
3403          * @brief Create an event array
3404          *
3405          * @param integer $event_id The id of the event
3406          *
3407          * @return array with event data
3408          */
3409         private static function buildEvent($event_id)
3410         {
3411                 $r = q("SELECT `guid`, `uid`, `start`, `finish`, `nofinish`, `summary`, `desc`, `location`, `adjust` FROM `event` WHERE `id` = %d", intval($event_id));
3412                 if (!DBA::isResult($r)) {
3413                         return [];
3414                 }
3415
3416                 $event = $r[0];
3417
3418                 $eventdata = [];
3419
3420                 $r = q("SELECT `timezone` FROM `user` WHERE `uid` = %d", intval($event['uid']));
3421                 if (!DBA::isResult($r)) {
3422                         return [];
3423                 }
3424
3425                 $user = $r[0];
3426
3427                 $r = q("SELECT `addr`, `nick` FROM `contact` WHERE `uid` = %d AND `self`", intval($event['uid']));
3428                 if (!DBA::isResult($r)) {
3429                         return [];
3430                 }
3431
3432                 $owner = $r[0];
3433
3434                 $eventdata['author'] = self::myHandle($owner);
3435
3436                 if ($event['guid']) {
3437                         $eventdata['guid'] = $event['guid'];
3438                 }
3439
3440                 $mask = DateTimeFormat::ATOM;
3441
3442                 /// @todo - establish "all day" events in Friendica
3443                 $eventdata["all_day"] = "false";
3444
3445                 if (!$event['adjust']) {
3446                         $eventdata['timezone'] = $user['timezone'];
3447
3448                         if ($eventdata['timezone'] == "") {
3449                                 $eventdata['timezone'] = 'UTC';
3450                         }
3451                 }
3452
3453                 if ($event['start']) {
3454                         $eventdata['start'] = DateTimeFormat::convert($event['start'], "UTC", $eventdata['timezone'], $mask);
3455                 }
3456                 if ($event['finish'] && !$event['nofinish']) {
3457                         $eventdata['end'] = DateTimeFormat::convert($event['finish'], "UTC", $eventdata['timezone'], $mask);
3458                 }
3459                 if ($event['summary']) {
3460                         $eventdata['summary'] = html_entity_decode(BBCode::toMarkdown($event['summary']));
3461                 }
3462                 if ($event['desc']) {
3463                         $eventdata['description'] = html_entity_decode(BBCode::toMarkdown($event['desc']));
3464                 }
3465                 if ($event['location']) {
3466                         $event['location'] = preg_replace("/\[map\](.*?)\[\/map\]/ism", '$1', $event['location']);
3467                         $coord = Map::getCoordinates($event['location']);
3468
3469                         $location = [];
3470                         $location["address"] = html_entity_decode(BBCode::toMarkdown($event['location']));
3471                         if (!empty($coord['lat']) && !empty($coord['lon'])) {
3472                                 $location["lat"] = $coord['lat'];
3473                                 $location["lng"] = $coord['lon'];
3474                         } else {
3475                                 $location["lat"] = 0;
3476                                 $location["lng"] = 0;
3477                         }
3478                         $eventdata['location'] = $location;
3479                 }
3480
3481                 return $eventdata;
3482         }
3483
3484         /**
3485          * @brief Create a post (status message or reshare)
3486          *
3487          * @param array $item  The item that will be exported
3488          * @param array $owner the array of the item owner
3489          *
3490          * @return array
3491          * 'type' -> Message type ("status_message" or "reshare")
3492          * 'message' -> Array of XML elements of the status
3493          */
3494         public static function buildStatus(array $item, array $owner)
3495         {
3496                 $cachekey = "diaspora:buildStatus:".$item['guid'];
3497
3498                 $result = Cache::get($cachekey);
3499                 if (!is_null($result)) {
3500                         return $result;
3501                 }
3502
3503                 $myaddr = self::myHandle($owner);
3504
3505                 $public = (($item["private"]) ? "false" : "true");
3506
3507                 $created = DateTimeFormat::utc($item["created"], DateTimeFormat::ATOM);
3508
3509                 // Detect a share element and do a reshare
3510                 if (!$item['private'] && ($ret = self::isReshare($item["body"]))) {
3511                         $message = ["author" => $myaddr,
3512                                         "guid" => $item["guid"],
3513                                         "created_at" => $created,
3514                                         "root_author" => $ret["root_handle"],
3515                                         "root_guid" => $ret["root_guid"],
3516                                         "provider_display_name" => $item["app"],
3517                                         "public" => $public];
3518
3519                         $type = "reshare";
3520                 } else {
3521                         $title = $item["title"];
3522                         $body = $item["body"];
3523
3524                         if ($item['author-link'] != $item['owner-link']) {
3525                                 require_once 'mod/share.php';
3526                                 $body = share_header($item['author-name'], $item['author-link'], $item['author-avatar'],
3527                                         "", $item['created'], $item['plink']) . $body . '[/share]';
3528                         }
3529
3530                         // convert to markdown
3531                         $body = html_entity_decode(BBCode::toMarkdown($body));
3532
3533                         // Adding the title
3534                         if (strlen($title)) {
3535                                 $body = "## ".html_entity_decode($title)."\n\n".$body;
3536                         }
3537
3538                         if ($item["attach"]) {
3539                                 $cnt = preg_match_all('/href=\"(.*?)\"(.*?)title=\"(.*?)\"/ism', $item["attach"], $matches, PREG_SET_ORDER);
3540                                 if (cnt) {
3541                                         $body .= "\n".L10n::t("Attachments:")."\n";
3542                                         foreach ($matches as $mtch) {
3543                                                 $body .= "[".$mtch[3]."](".$mtch[1].")\n";
3544                                         }
3545                                 }
3546                         }
3547
3548                         $location = [];
3549
3550                         if ($item["location"] != "")
3551                                 $location["address"] = $item["location"];
3552
3553                         if ($item["coord"] != "") {
3554                                 $coord = explode(" ", $item["coord"]);
3555                                 $location["lat"] = $coord[0];
3556                                 $location["lng"] = $coord[1];
3557                         }
3558
3559                         $message = ["author" => $myaddr,
3560                                         "guid" => $item["guid"],
3561                                         "created_at" => $created,
3562                                         "public" => $public,
3563                                         "text" => $body,
3564                                         "provider_display_name" => $item["app"],
3565                                         "location" => $location];
3566
3567                         // Diaspora rejects messages when they contain a location without "lat" or "lng"
3568                         if (!isset($location["lat"]) || !isset($location["lng"])) {
3569                                 unset($message["location"]);
3570                         }
3571
3572                         if ($item['event-id'] > 0) {
3573                                 $event = self::buildEvent($item['event-id']);
3574                                 if (count($event)) {
3575                                         $message['event'] = $event;
3576
3577                                         if (!empty($event['location']['address']) &&
3578                                                 !empty($event['location']['lat']) &&
3579                                                 !empty($event['location']['lng'])) {
3580                                                 $message['location'] = $event['location'];
3581                                         }
3582
3583                                         /// @todo Once Diaspora supports it, we will remove the body and the location hack above
3584                                         // $message['text'] = '';
3585                                 }
3586                         }
3587
3588                         $type = "status_message";
3589                 }
3590
3591                 $msg = ["type" => $type, "message" => $message];
3592
3593                 Cache::set($cachekey, $msg, CACHE_QUARTER_HOUR);
3594
3595                 return $msg;
3596         }
3597
3598         /**
3599          * @brief Sends a post
3600          *
3601          * @param array $item         The item that will be exported
3602          * @param array $owner        the array of the item owner
3603          * @param array $contact      Target of the communication
3604          * @param bool  $public_batch Is it a public post?
3605          *
3606          * @return int The result of the transmission
3607          */
3608         public static function sendStatus(array $item, array $owner, array $contact, $public_batch = false)
3609         {
3610                 $status = self::buildStatus($item, $owner);
3611
3612                 return self::buildAndTransmit($owner, $contact, $status["type"], $status["message"], $public_batch, $item["guid"]);
3613         }
3614
3615         /**
3616          * @brief Creates a "like" object
3617          *
3618          * @param array $item  The item that will be exported
3619          * @param array $owner the array of the item owner
3620          *
3621          * @return array The data for a "like"
3622          */
3623         private static function constructLike(array $item, array $owner)
3624         {
3625                 $parent = Item::selectFirst(['guid', 'uri', 'parent-uri'], ['uri' => $item["thr-parent"]]);
3626                 if (!DBA::isResult($parent)) {
3627                         return false;
3628                 }
3629
3630                 $target_type = ($parent["uri"] === $parent["parent-uri"] ? "Post" : "Comment");
3631                 $positive = null;
3632                 if ($item['verb'] === ACTIVITY_LIKE) {
3633                         $positive = "true";
3634                 } elseif ($item['verb'] === ACTIVITY_DISLIKE) {
3635                         $positive = "false";
3636                 }
3637
3638                 return(["author" => self::myHandle($owner),
3639                                 "guid" => $item["guid"],
3640                                 "parent_guid" => $parent["guid"],
3641                                 "parent_type" => $target_type,
3642                                 "positive" => $positive,
3643                                 "author_signature" => ""]);
3644         }
3645
3646         /**
3647          * @brief Creates an "EventParticipation" object
3648          *
3649          * @param array $item  The item that will be exported
3650          * @param array $owner the array of the item owner
3651          *
3652          * @return array The data for an "EventParticipation"
3653          */
3654         private static function constructAttend(array $item, array $owner)
3655         {
3656                 $parent = Item::selectFirst(['guid', 'uri', 'parent-uri'], ['uri' => $item["thr-parent"]]);
3657                 if (!DBA::isResult($parent)) {
3658                         return false;
3659                 }
3660
3661                 switch ($item['verb']) {
3662                         case ACTIVITY_ATTEND:
3663                                 $attend_answer = 'accepted';
3664                                 break;
3665                         case ACTIVITY_ATTENDNO:
3666                                 $attend_answer = 'declined';
3667                                 break;
3668                         case ACTIVITY_ATTENDMAYBE:
3669                                 $attend_answer = 'tentative';
3670                                 break;
3671                         default:
3672                                 logger('Unknown verb '.$item['verb'].' in item '.$item['guid']);
3673                                 return false;
3674                 }
3675
3676                 return(["author" => self::myHandle($owner),
3677                                 "guid" => $item["guid"],
3678                                 "parent_guid" => $parent["guid"],
3679                                 "status" => $attend_answer,
3680                                 "author_signature" => ""]);
3681         }
3682
3683         /**
3684          * @brief Creates the object for a comment
3685          *
3686          * @param array $item  The item that will be exported
3687          * @param array $owner the array of the item owner
3688          *
3689          * @return array The data for a comment
3690          */
3691         private static function constructComment(array $item, array $owner)
3692         {
3693                 $cachekey = "diaspora:constructComment:".$item['guid'];
3694
3695                 $result = Cache::get($cachekey);
3696                 if (!is_null($result)) {
3697                         return $result;
3698                 }
3699
3700                 $parent = Item::selectFirst(['guid'], ['id' => $item["parent"], 'parent' => $item["parent"]]);
3701                 if (!DBA::isResult($parent)) {
3702                         return false;
3703                 }
3704
3705                 $text = html_entity_decode(BBCode::toMarkdown($item["body"]));
3706                 $created = DateTimeFormat::utc($item["created"], DateTimeFormat::ATOM);
3707
3708                 $comment = ["author" => self::myHandle($owner),
3709                                 "guid" => $item["guid"],
3710                                 "created_at" => $created,
3711                                 "parent_guid" => $parent["guid"],
3712                                 "text" => $text,
3713                                 "author_signature" => ""];
3714
3715                 // Send the thread parent guid only if it is a threaded comment
3716                 if ($item['thr-parent'] != $item['parent-uri']) {
3717                         $comment['thread_parent_guid'] = self::getGuidFromUri($item['thr-parent'], $item['uid']);
3718                 }
3719
3720                 Cache::set($cachekey, $comment, CACHE_QUARTER_HOUR);
3721
3722                 return($comment);
3723         }
3724
3725         /**
3726          * @brief Send a like or a comment
3727          *
3728          * @param array $item         The item that will be exported
3729          * @param array $owner        the array of the item owner
3730          * @param array $contact      Target of the communication
3731          * @param bool  $public_batch Is it a public post?
3732          *
3733          * @return int The result of the transmission
3734          */
3735         public static function sendFollowup(array $item, array $owner, array $contact, $public_batch = false)
3736         {
3737                 if (in_array($item['verb'], [ACTIVITY_ATTEND, ACTIVITY_ATTENDNO, ACTIVITY_ATTENDMAYBE])) {
3738                         $message = self::constructAttend($item, $owner);
3739                         $type = "event_participation";
3740                 } elseif (in_array($item["verb"], [ACTIVITY_LIKE, ACTIVITY_DISLIKE])) {
3741                         $message = self::constructLike($item, $owner);
3742                         $type = "like";
3743                 } else {
3744                         $message = self::constructComment($item, $owner);
3745                         $type = "comment";
3746                 }
3747
3748                 if (!$message) {
3749                         return false;
3750                 }
3751
3752                 $message["author_signature"] = self::signature($owner, $message);
3753
3754                 return self::buildAndTransmit($owner, $contact, $type, $message, $public_batch, $item["guid"]);
3755         }
3756
3757         /**
3758          * @brief Creates a message from a signature record entry
3759          *
3760          * @param array $item      The item that will be exported
3761          * @param array $signature The entry of the "sign" record
3762          *
3763          * @return string The message
3764          */
3765         private static function messageFromSignature(array $item, array $signature)
3766         {
3767                 // Split the signed text
3768                 $signed_parts = explode(";", $signature['signed_text']);
3769
3770                 if ($item["deleted"]) {
3771                         $message = ["author" => $signature['signer'],
3772                                         "target_guid" => $signed_parts[0],
3773                                         "target_type" => $signed_parts[1]];
3774                 } elseif (in_array($item["verb"], [ACTIVITY_LIKE, ACTIVITY_DISLIKE])) {
3775                         $message = ["author" => $signed_parts[4],
3776                                         "guid" => $signed_parts[1],
3777                                         "parent_guid" => $signed_parts[3],
3778                                         "parent_type" => $signed_parts[2],
3779                                         "positive" => $signed_parts[0],
3780                                         "author_signature" => $signature['signature'],
3781                                         "parent_author_signature" => ""];
3782                 } else {
3783                         // Remove the comment guid
3784                         $guid = array_shift($signed_parts);
3785
3786                         // Remove the parent guid
3787                         $parent_guid = array_shift($signed_parts);
3788
3789                         // Remove the handle
3790                         $handle = array_pop($signed_parts);
3791
3792                         // Glue the parts together
3793                         $text = implode(";", $signed_parts);
3794
3795                         $message = ["author" => $handle,
3796                                         "guid" => $guid,
3797                                         "parent_guid" => $parent_guid,
3798                                         "text" => implode(";", $signed_parts),
3799                                         "author_signature" => $signature['signature'],
3800                                         "parent_author_signature" => ""];
3801                 }
3802                 return $message;
3803         }
3804
3805         /**
3806          * @brief Relays messages (like, comment, retraction) to other servers if we are the thread owner
3807          *
3808          * @param array $item         The item that will be exported
3809          * @param array $owner        the array of the item owner
3810          * @param array $contact      Target of the communication
3811          * @param bool  $public_batch Is it a public post?
3812          *
3813          * @return int The result of the transmission
3814          */
3815         public static function sendRelay(array $item, array $owner, array $contact, $public_batch = false)
3816         {
3817                 if ($item["deleted"]) {
3818                         return self::sendRetraction($item, $owner, $contact, $public_batch, true);
3819                 } elseif (in_array($item["verb"], [ACTIVITY_LIKE, ACTIVITY_DISLIKE])) {
3820                         $type = "like";
3821                 } else {
3822                         $type = "comment";
3823                 }
3824
3825                 logger("Got relayable data ".$type." for item ".$item["guid"]." (".$item["id"].")", LOGGER_DEBUG);
3826
3827                 // fetch the original signature
3828
3829                 $r = q(
3830                         "SELECT `signed_text`, `signature`, `signer` FROM `sign` WHERE `iid` = %d LIMIT 1",
3831                         intval($item["id"])
3832                 );
3833
3834                 if (!$r) {
3835                         logger("Couldn't fetch signatur for item ".$item["guid"]." (".$item["id"].")", LOGGER_DEBUG);
3836                         return false;
3837                 }
3838
3839                 $signature = $r[0];
3840
3841                 // Old way - is used by the internal Friendica functions
3842                 /// @todo Change all signatur storing functions to the new format
3843                 if ($signature['signed_text'] && $signature['signature'] && $signature['signer']) {
3844                         $message = self::messageFromSignature($item, $signature);
3845                 } else {// New way
3846                         $msg = json_decode($signature['signed_text'], true);
3847
3848                         $message = [];
3849                         if (is_array($msg)) {
3850                                 foreach ($msg as $field => $data) {
3851                                         if (!$item["deleted"]) {
3852                                                 if ($field == "diaspora_handle") {
3853                                                         $field = "author";
3854                                                 }
3855                                                 if ($field == "target_type") {
3856                                                         $field = "parent_type";
3857                                                 }
3858                                         }
3859
3860                                         $message[$field] = $data;
3861                                 }
3862                         } else {
3863                                 logger("Signature text for item ".$item["guid"]." (".$item["id"].") couldn't be extracted: ".$signature['signed_text'], LOGGER_DEBUG);
3864                         }
3865                 }
3866
3867                 $message["parent_author_signature"] = self::signature($owner, $message);
3868
3869                 logger("Relayed data ".print_r($message, true), LOGGER_DEBUG);
3870
3871                 return self::buildAndTransmit($owner, $contact, $type, $message, $public_batch, $item["guid"]);
3872         }
3873
3874         /**
3875          * @brief Sends a retraction (deletion) of a message, like or comment
3876          *
3877          * @param array $item         The item that will be exported
3878          * @param array $owner        the array of the item owner
3879          * @param array $contact      Target of the communication
3880          * @param bool  $public_batch Is it a public post?
3881          * @param bool  $relay        Is the retraction transmitted from a relay?
3882          *
3883          * @return int The result of the transmission
3884          */
3885         public static function sendRetraction(array $item, array $owner, array $contact, $public_batch = false, $relay = false)
3886         {
3887                 $itemaddr = self::handleFromContact($item["contact-id"], $item["author-id"]);
3888
3889                 $msg_type = "retraction";
3890
3891                 if ($item['id'] == $item['parent']) {
3892                         $target_type = "Post";
3893                 } elseif (in_array($item["verb"], [ACTIVITY_LIKE, ACTIVITY_DISLIKE])) {
3894                         $target_type = "Like";
3895                 } else {
3896                         $target_type = "Comment";
3897                 }
3898
3899                 $message = ["author" => $itemaddr,
3900                                 "target_guid" => $item['guid'],
3901                                 "target_type" => $target_type];
3902
3903                 logger("Got message ".print_r($message, true), LOGGER_DEBUG);
3904
3905                 return self::buildAndTransmit($owner, $contact, $msg_type, $message, $public_batch, $item["guid"]);
3906         }
3907
3908         /**
3909          * @brief Sends a mail
3910          *
3911          * @param array $item    The item that will be exported
3912          * @param array $owner   The owner
3913          * @param array $contact Target of the communication
3914          *
3915          * @return int The result of the transmission
3916          */
3917         public static function sendMail(array $item, array $owner, array $contact)
3918         {
3919                 $myaddr = self::myHandle($owner);
3920
3921                 $r = q(
3922                         "SELECT * FROM `conv` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3923                         intval($item["convid"]),
3924                         intval($item["uid"])
3925                 );
3926
3927                 if (!DBA::isResult($r)) {
3928                         logger("conversation not found.");
3929                         return;
3930                 }
3931                 $cnv = $r[0];
3932
3933                 $conv = [
3934                         "author" => $cnv["creator"],
3935                         "guid" => $cnv["guid"],
3936                         "subject" => $cnv["subject"],
3937                         "created_at" => DateTimeFormat::utc($cnv['created'], DateTimeFormat::ATOM),
3938                         "participants" => $cnv["recips"]
3939                 ];
3940
3941                 $body = BBCode::toMarkdown($item["body"]);
3942                 $created = DateTimeFormat::utc($item["created"], DateTimeFormat::ATOM);
3943
3944                 $msg = [
3945                         "author" => $myaddr,
3946                         "guid" => $item["guid"],
3947                         "conversation_guid" => $cnv["guid"],
3948                         "text" => $body,
3949                         "created_at" => $created,
3950                 ];
3951
3952                 if ($item["reply"]) {
3953                         $message = $msg;
3954                         $type = "message";
3955                 } else {
3956                         $message = [
3957                                         "author" => $cnv["creator"],
3958                                         "guid" => $cnv["guid"],
3959                                         "subject" => $cnv["subject"],
3960                                         "created_at" => DateTimeFormat::utc($cnv['created'], DateTimeFormat::ATOM),
3961                                         "participants" => $cnv["recips"],
3962                                         "message" => $msg];
3963
3964                         $type = "conversation";
3965                 }
3966
3967                 return self::buildAndTransmit($owner, $contact, $type, $message, false, $item["guid"]);
3968         }
3969
3970         /**
3971          * @brief Split a name into first name and last name
3972          *
3973          * @param string $name The name
3974          *
3975          * @return array The array with "first" and "last"
3976          */
3977         public static function splitName($name) {
3978                 $name = trim($name);
3979
3980                 // Is the name longer than 64 characters? Then cut the rest of it.
3981                 if (strlen($name) > 64) {
3982                         if ((strpos($name, ' ') <= 64) && (strpos($name, ' ') !== false)) {
3983                                 $name = trim(substr($name, 0, strrpos(substr($name, 0, 65), ' ')));
3984                         } else {
3985                                 $name = substr($name, 0, 64);
3986                         }
3987                 }
3988
3989                 // Take the first word as first name
3990                 $first = ((strpos($name, ' ') ? trim(substr($name, 0, strpos($name, ' '))) : $name));
3991                 $last = (($first === $name) ? '' : trim(substr($name, strlen($first))));
3992                 if ((strlen($first) < 32) && (strlen($last) < 32)) {
3993                         return ['first' => $first, 'last' => $last];
3994                 }
3995
3996                 // Take the last word as last name
3997                 $first = ((strrpos($name, ' ') ? trim(substr($name, 0, strrpos($name, ' '))) : $name));
3998                 $last = (($first === $name) ? '' : trim(substr($name, strlen($first))));
3999
4000                 if ((strlen($first) < 32) && (strlen($last) < 32)) {
4001                         return ['first' => $first, 'last' => $last];
4002                 }
4003
4004                 // Take the first 32 characters if there is no space in the first 32 characters
4005                 if ((strpos($name, ' ') > 32) || (strpos($name, ' ') === false)) {
4006                         $first = substr($name, 0, 32);
4007                         $last = substr($name, 32);
4008                         return ['first' => $first, 'last' => $last];
4009                 }
4010
4011                 $first = trim(substr($name, 0, strrpos(substr($name, 0, 33), ' ')));
4012                 $last = (($first === $name) ? '' : trim(substr($name, strlen($first))));
4013
4014                 // Check if the last name is longer than 32 characters
4015                 if (strlen($last) > 32) {
4016                         if (strpos($last, ' ') <= 32) {
4017                                 $last = trim(substr($last, 0, strrpos(substr($last, 0, 33), ' ')));
4018                         } else {
4019                                 $last = substr($last, 0, 32);
4020                         }
4021                 }
4022
4023                 return ['first' => $first, 'last' => $last];
4024         }
4025
4026         /**
4027          * @brief Create profile data
4028          *
4029          * @param int $uid The user id
4030          *
4031          * @return array The profile data
4032          */
4033         private static function createProfileData($uid)
4034         {
4035                 $r = q(
4036                         "SELECT `profile`.`uid` AS `profile_uid`, `profile`.* , `user`.*, `user`.`prvkey` AS `uprvkey`, `contact`.`addr`
4037                         FROM `profile`
4038                         INNER JOIN `user` ON `profile`.`uid` = `user`.`uid`
4039                         INNER JOIN `contact` ON `profile`.`uid` = `contact`.`uid`
4040                         WHERE `user`.`uid` = %d AND `profile`.`is-default` AND `contact`.`self` LIMIT 1",
4041                         intval($uid)
4042                 );
4043
4044                 if (!$r) {
4045                         return [];
4046                 }
4047
4048                 $profile = $r[0];
4049                 $handle = $profile["addr"];
4050
4051                 $split_name = self::splitName($profile['name']);
4052                 $first = $split_name['first'];
4053                 $last = $split_name['last'];
4054
4055                 $large = System::baseUrl().'/photo/custom/300/'.$profile['uid'].'.jpg';
4056                 $medium = System::baseUrl().'/photo/custom/100/'.$profile['uid'].'.jpg';
4057                 $small = System::baseUrl().'/photo/custom/50/'  .$profile['uid'].'.jpg';
4058                 $searchable = (($profile['publish'] && $profile['net-publish']) ? 'true' : 'false');
4059
4060                 $dob = null;
4061                 $about = null;
4062                 $location = null;
4063                 $tags = null;
4064                 if ($searchable === 'true') {
4065                         $dob = '';
4066
4067                         if ($profile['dob'] && ($profile['dob'] > '0000-00-00')) {
4068                                 list($year, $month, $day) = sscanf($profile['dob'], '%4d-%2d-%2d');
4069                                 if ($year < 1004) {
4070                                         $year = 1004;
4071                                 }
4072                                 $dob = DateTimeFormat::utc($year . '-' . $month . '-'. $day, 'Y-m-d');
4073                         }
4074
4075                         $about = $profile['about'];
4076                         $about = strip_tags(BBCode::convert($about));
4077
4078                         $location = Profile::formatLocation($profile);
4079                         $tags = '';
4080                         if ($profile['pub_keywords']) {
4081                                 $kw = str_replace(',', ' ', $profile['pub_keywords']);
4082                                 $kw = str_replace('  ', ' ', $kw);
4083                                 $arr = explode(' ', $profile['pub_keywords']);
4084                                 if (count($arr)) {
4085                                         for ($x = 0; $x < 5; $x ++) {
4086                                                 if (trim($arr[$x])) {
4087                                                         $tags .= '#'. trim($arr[$x]) .' ';
4088                                                 }
4089                                         }
4090                                 }
4091                         }
4092                         $tags = trim($tags);
4093                 }
4094
4095                 return ["author" => $handle,
4096                                 "first_name" => $first,
4097                                 "last_name" => $last,
4098                                 "image_url" => $large,
4099                                 "image_url_medium" => $medium,
4100                                 "image_url_small" => $small,
4101                                 "birthday" => $dob,
4102                                 "gender" => $profile['gender'],
4103                                 "bio" => $about,
4104                                 "location" => $location,
4105                                 "searchable" => $searchable,
4106                                 "nsfw" => "false",
4107                                 "tag_string" => $tags];
4108         }
4109
4110         /**
4111          * @brief Sends profile data
4112          *
4113          * @param int  $uid    The user id
4114          * @param bool $recips optional, default false
4115          * @return void
4116          */
4117         public static function sendProfile($uid, $recips = false)
4118         {
4119                 if (!$uid) {
4120                         return;
4121                 }
4122
4123                 $owner = User::getOwnerDataById($uid);
4124                 if (!$owner) {
4125                         return;
4126                 }
4127
4128                 if (!$recips) {
4129                         $recips = q(
4130                                 "SELECT `id`,`name`,`network`,`pubkey`,`notify` FROM `contact` WHERE `network` = '%s'
4131                                 AND `uid` = %d AND `rel` != %d",
4132                                 DBA::escape(NETWORK_DIASPORA),
4133                                 intval($uid),
4134                                 intval(CONTACT_IS_SHARING)
4135                         );
4136                 }
4137
4138                 if (!$recips) {
4139                         return;
4140                 }
4141
4142                 $message = self::createProfileData($uid);
4143
4144                 foreach ($recips as $recip) {
4145                         logger("Send updated profile data for user ".$uid." to contact ".$recip["id"], LOGGER_DEBUG);
4146                         self::buildAndTransmit($owner, $recip, "profile", $message, false, "", false);
4147                 }
4148         }
4149
4150         /**
4151          * @brief Stores the signature for likes that are created on our system
4152          *
4153          * @param array $contact The contact array of the "like"
4154          * @param int   $post_id The post id of the "like"
4155          *
4156          * @return bool Success
4157          */
4158         public static function storeLikeSignature(array $contact, $post_id)
4159         {
4160                 // Is the contact the owner? Then fetch the private key
4161                 if (!$contact['self'] || ($contact['uid'] == 0)) {
4162                         logger("No owner post, so not storing signature", LOGGER_DEBUG);
4163                         return false;
4164                 }
4165
4166                 $r = q("SELECT `prvkey` FROM `user` WHERE `uid` = %d LIMIT 1", intval($contact['uid']));
4167                 if (!DBA::isResult($r)) {
4168                         return false;
4169                 }
4170
4171                 $contact["uprvkey"] = $r[0]['prvkey'];
4172
4173                 $item = Item::selectFirst([], ['id' => $post_id]);
4174                 if (!DBA::isResult($item)) {
4175                         return false;
4176                 }
4177
4178                 if (!in_array($item["verb"], [ACTIVITY_LIKE, ACTIVITY_DISLIKE])) {
4179                         return false;
4180                 }
4181
4182                 $message = self::constructLike($item, $contact);
4183                 if ($message === false) {
4184                         return false;
4185                 }
4186
4187                 $message["author_signature"] = self::signature($contact, $message);
4188
4189                 /*
4190                  * Now store the signature more flexible to dynamically support new fields.
4191                  * This will break Diaspora compatibility with Friendica versions prior to 3.5.
4192                  */
4193                 DBA::insert('sign', ['iid' => $post_id, 'signed_text' => json_encode($message)]);
4194
4195                 logger('Stored diaspora like signature');
4196                 return true;
4197         }
4198
4199         /**
4200          * @brief Stores the signature for comments that are created on our system
4201          *
4202          * @param array  $item       The item array of the comment
4203          * @param array  $contact    The contact array of the item owner
4204          * @param string $uprvkey    The private key of the sender
4205          * @param int    $message_id The message id of the comment
4206          *
4207          * @return bool Success
4208          */
4209         public static function storeCommentSignature(array $item, array $contact, $uprvkey, $message_id)
4210         {
4211                 if ($uprvkey == "") {
4212                         logger('No private key, so not storing comment signature', LOGGER_DEBUG);
4213                         return false;
4214                 }
4215
4216                 $contact["uprvkey"] = $uprvkey;
4217
4218                 $message = self::constructComment($item, $contact);
4219                 if ($message === false) {
4220                         return false;
4221                 }
4222
4223                 $message["author_signature"] = self::signature($contact, $message);
4224
4225                 /*
4226                  * Now store the signature more flexible to dynamically support new fields.
4227                  * This will break Diaspora compatibility with Friendica versions prior to 3.5.
4228                  */
4229                 DBA::insert('sign', ['iid' => $message_id, 'signed_text' => json_encode($message)]);
4230
4231                 logger('Stored diaspora comment signature');
4232                 return true;
4233         }
4234 }