3 * @file src/Worker/Delivery.php
5 namespace Friendica\Worker;
7 use Friendica\Core\Config;
8 use Friendica\Core\L10n;
9 use Friendica\Core\System;
10 use Friendica\Database\DBM;
11 use Friendica\Model\Contact;
12 use Friendica\Model\Item;
13 use Friendica\Model\Queue;
14 use Friendica\Model\User;
15 use Friendica\Protocol\DFRN;
16 use Friendica\Protocol\Diaspora;
17 use Friendica\Protocol\Email;
20 require_once 'include/items.php';
22 /// @todo This is some ugly code that needs to be split into several methods
25 public static function execute($cmd, $item_id, $contact_id) {
28 logger('delivery: invoked: '.$cmd.': '.$item_id.' to '.$contact_id, LOGGER_DEBUG);
41 $recipients[] = $contact_id;
43 if ($cmd === 'mail') {
46 $message = q("SELECT * FROM `mail` WHERE `id` = %d LIMIT 1",
49 if (!count($message)) {
52 $uid = $message[0]['uid'];
53 $recipients[] = $message[0]['contact-id'];
55 } elseif ($cmd === 'suggest') {
59 $suggest = q("SELECT * FROM `fsuggest` WHERE `id` = %d LIMIT 1",
62 if (!count($suggest)) {
65 $uid = $suggest[0]['uid'];
66 $recipients[] = $suggest[0]['cid'];
68 } elseif ($cmd === 'relocate') {
74 $target_item = dba::fetch_first("SELECT `item`.*, `contact`.`uid` AS `cuid` FROM `item`
75 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
76 WHERE `item`.`id` = ? AND `visible` AND NOT `moderated`", $item_id);
78 if (!DBM::is_result($target_item) || !intval($target_item['parent'])) {
82 $parent_id = intval($target_item['parent']);
83 $uid = $target_item['cuid'];
84 $updated = $target_item['edited'];
86 $items = q("SELECT `item`.*, `sign`.`signed_text`,`sign`.`signature`,`sign`.`signer`
87 FROM `item` LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id` WHERE `parent` = %d AND visible = 1 AND moderated = 0 ORDER BY `id` ASC",
97 foreach ($items as $item) {
98 if (!in_array($item['contact-id'],$contacts_arr)) {
99 $contacts_arr[] = intval($item['contact-id']);
102 if (count($contacts_arr)) {
103 $str_contacts = implode(',',$contacts_arr);
104 $icontacts = q("SELECT * FROM `contact`
105 WHERE `id` IN ( $str_contacts ) "
108 if ( !($icontacts && count($icontacts))) {
112 // avoid race condition with deleting entries
114 if ($items[0]['deleted']) {
115 foreach ($items as $item) {
116 $item['deleted'] = 1;
120 // When commenting too fast after delivery, a post wasn't recognized as top level post.
121 // The count then showed more than one entry. The additional check should help.
122 // The check for the "count" should be superfluous, but I'm not totally sure by now, so we keep it.
123 if ((($items[0]['id'] == $item_id) || (count($items) == 1)) && ($items[0]['uri'] === $items[0]['parent-uri'])) {
124 logger('delivery: top level post');
129 $owner = User::getOwnerDataById($uid);
134 // We don't treat Forum posts as "wall-to-wall" to be able to post them via Diaspora
135 $walltowall = $top_level && ($owner['id'] != $items[0]['contact-id']) & ($owner['account-type'] != ACCOUNT_TYPE_COMMUNITY);
137 $public_message = true;
139 if (!$mail && !$fsuggest && !$relocate) {
142 // This is IMPORTANT!!!!
144 // We will only send a "notify owner to relay" or followup message if the referenced post
145 // originated on our system by virtue of having our hostname somewhere
146 // in the URI, AND it was a comment (not top_level) AND the parent originated elsewhere.
147 // if $parent['wall'] == 1 we will already have the parent message in our array
148 // and we will relay the whole lot.
150 $localhost = $a->get_hostname();
151 if (strpos($localhost,':')) {
152 $localhost = substr($localhost,0,strpos($localhost,':'));
156 * Be VERY CAREFUL if you make any changes to the following line. Seemingly innocuous changes
157 * have been known to cause runaway conditions which affected several servers, along with
158 * permissions issues.
162 $relay_to_owner = false;
164 if (!$top_level && ($parent['wall'] == 0) && stristr($target_item['uri'], $localhost)) {
165 $relay_to_owner = true;
168 if ($relay_to_owner) {
169 logger('followup '.$target_item["guid"], LOGGER_DEBUG);
170 // local followup to remote post
174 if (strlen($parent['allow_cid'])
175 || strlen($parent['allow_gid'])
176 || strlen($parent['deny_cid'])
177 || strlen($parent['deny_gid'])
178 || $parent["private"]) {
179 $public_message = false; // private recipients, not public
184 // We don't deliver our items to blocked or pending contacts, and not to ourselves either
185 $contact = dba::selectFirst('contact', [],
186 ['id' => $contact_id, 'blocked' => false, 'pending' => false, 'self' => false]
188 if (!DBM::is_result($contact)) {
194 // Transmit via Diaspora if not possible via Friendica
195 if (($item['uid'] == 0) && ($contact['network'] == NETWORK_DFRN)) {
196 $contact['network'] = NETWORK_DIASPORA;
199 logger("main delivery by delivery: followup=$followup mail=$mail fsuggest=$fsuggest relocate=$relocate - network ".$contact['network']);
201 switch ($contact['network']) {
204 logger('notifier: '.$target_item["guid"].' dfrndelivery: '.$contact['name']);
207 $item['body'] = Item::fixPrivatePhotos($item['body'], $owner['uid'], null, $item['contact-id']);
208 $atom = DFRN::mail($item, $owner);
209 } elseif ($fsuggest) {
210 $atom = DFRN::fsuggest($item, $owner);
211 q("DELETE FROM `fsuggest` WHERE `id` = %d LIMIT 1", intval($item['id']));
212 } elseif ($relocate) {
213 $atom = DFRN::relocate($owner, $uid);
214 } elseif ($followup) {
216 foreach ($items as $item) { // there is only one item
217 if (!$item['parent']) {
220 if ($item['id'] == $item_id) {
221 logger('followup: item: '. print_r($item,true), LOGGER_DATA);
225 $atom = DFRN::entries($msgitems,$owner);
228 foreach ($items as $item) {
229 if (!$item['parent']) {
233 // private emails may be in included in public conversations. Filter them.
234 if ($public_message && $item['private']) {
238 $item_contact = self::getItemContact($item,$icontacts);
239 if (!$item_contact) {
244 // Only add the parent when we don't delete other items.
245 if ($item_id == $item['id'] || (($item['id'] == $item['parent']) && ($cmd != 'drop'))) {
246 $item["entry:comment-allow"] = true;
247 $item["entry:cid"] = (($top_level) ? $contact['id'] : 0);
251 $item["entry:comment-allow"] = true;
255 $atom = DFRN::entries($msgitems,$owner);
258 logger('notifier entry: '.$contact["url"].' '.$target_item["guid"].' entry: '.$atom, LOGGER_DEBUG);
260 logger('notifier: '.$atom, LOGGER_DATA);
261 $basepath = implode('/', array_slice(explode('/',$contact['url']),0,3));
263 // perform local delivery if we are on the same site
265 if (link_compare($basepath,System::baseUrl())) {
266 $nickname = basename($contact['url']);
267 if ($contact['issued-id']) {
268 $sql_extra = sprintf(" AND `dfrn-id` = '%s' ", dbesc($contact['issued-id']));
270 $sql_extra = sprintf(" AND `issued-id` = '%s' ", dbesc($contact['dfrn-id']));
273 $x = q("SELECT `contact`.*, `contact`.`uid` AS `importer_uid`,
274 `contact`.`pubkey` AS `cpubkey`,
275 `contact`.`prvkey` AS `cprvkey`,
276 `contact`.`thumb` AS `thumb`,
277 `contact`.`url` as `url`,
278 `contact`.`name` as `senderName`,
281 INNER JOIN `user` ON `contact`.`uid` = `user`.`uid`
282 WHERE `contact`.`blocked` = 0 AND `contact`.`pending` = 0
283 AND `contact`.`network` = '%s' AND `user`.`nickname` = '%s'
285 AND `user`.`account_expired` = 0 AND `user`.`account_removed` = 0 LIMIT 1",
290 if ($x && count($x)) {
291 $write_flag = ((($x[0]['rel']) && ($x[0]['rel'] != CONTACT_IS_SHARING)) ? true : false);
292 if ((($owner['page-flags'] == PAGE_COMMUNITY) || $write_flag) && !$x[0]['writable']) {
293 q("UPDATE `contact` SET `writable` = 1 WHERE `id` = %d",
296 $x[0]['writable'] = 1;
299 $ssl_policy = Config::get('system','ssl_policy');
300 $x[0] = Contact::updateSslPolicy($x[0], $ssl_policy);
302 // If we are setup as a soapbox we aren't accepting top level posts from this person
304 if (($x[0]['page-flags'] == PAGE_SOAPBOX) && $top_level) {
307 logger('mod-delivery: local delivery');
308 DFRN::import($atom, $x[0]);
313 if (!Queue::wasDelayed($contact['id'])) {
314 $deliver_status = DFRN::deliver($owner, $contact, $atom);
316 $deliver_status = (-1);
319 logger('notifier: dfrn_delivery to '.$contact["url"].' with guid '.$target_item["guid"].' returns '.$deliver_status);
321 if ($deliver_status < 0) {
322 logger('notifier: delivery failed: queuing message');
323 Queue::add($contact['id'], NETWORK_DFRN, $atom, false, $target_item['guid']);
325 // The message could not be delivered. We mark the contact as "dead"
326 Contact::markForArchival($contact);
328 // We successfully delivered a message, the contact is alive
329 Contact::unmarkForArchival($contact);
334 case NETWORK_OSTATUS:
335 // Do not send to otatus if we are not configured to send to public networks
336 if ($owner['prvnets']) {
339 if (Config::get('system','ostatus_disabled') || Config::get('system','dfrn_only')) {
343 // There is currently no code here to distribute anything to OStatus.
344 // This is done in "notifier.php" (See "url_recipients" and "push_notify")
349 if (Config::get('system','dfrn_only')) {
352 // WARNING: does not currently convert to RFC2047 header encodings, etc.
354 $addr = $contact['addr'];
355 if (!strlen($addr)) {
359 if ($cmd === 'wall-new' || $cmd === 'comment-new') {
361 if ($cmd === 'wall-new') {
364 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
367 if (DBM::is_result($r)) {
375 $local_user = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
378 if (!count($local_user)) {
383 $r1 = q("SELECT * FROM `mailacct` WHERE `uid` = %d LIMIT 1",
386 if ($r1 && $r1[0]['reply_to']) {
387 $reply_to = $r1[0]['reply_to'];
390 $subject = (($it['title']) ? Email::encodeHeader($it['title'],'UTF-8') : L10n::t("\x28no subject\x29")) ;
392 // only expose our real email address to true friends
394 if (($contact['rel'] == CONTACT_IS_FRIEND) && !$contact['blocked']) {
396 $headers = 'From: '.Email::encodeHeader($local_user[0]['username'],'UTF-8').' <'.$reply_to.'>'."\n";
397 $headers .= 'Sender: '.$local_user[0]['email']."\n";
399 $headers = 'From: '.Email::encodeHeader($local_user[0]['username'],'UTF-8').' <'.$local_user[0]['email'].'>'."\n";
402 $headers = 'From: '. Email::encodeHeader($local_user[0]['username'],'UTF-8') .' <'. L10n::t('noreply') .'@'.$a->get_hostname() .'>'. "\n";
406 // $headers .= 'Reply-to: '.$reply_to . "\n";
408 $headers .= 'Message-Id: <'. Email::iri2msgid($it['uri']).'>'. "\n";
410 //logger("Mail: uri: ".$it['uri']." parent-uri ".$it['parent-uri'], LOGGER_DEBUG);
411 //logger("Mail: Data: ".print_r($it, true), LOGGER_DEBUG);
412 //logger("Mail: Data: ".print_r($it, true), LOGGER_DATA);
414 if ($it['uri'] !== $it['parent-uri']) {
415 $headers .= "References: <".Email::iri2msgid($it["parent-uri"]).">";
417 // If Threading is enabled, write down the correct parent
418 if (($it["thr-parent"] != "") && ($it["thr-parent"] != $it["parent-uri"])) {
419 $headers .= " <".Email::iri2msgid($it["thr-parent"]).">";
424 $r = q("SELECT `title` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
425 dbesc($it['parent-uri']),
428 if (DBM::is_result($r) && ($r[0]['title'] != '')) {
429 $subject = $r[0]['title'];
431 $r = q("SELECT `title` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d LIMIT 1",
432 dbesc($it['parent-uri']),
435 if (DBM::is_result($r) && ($r[0]['title'] != '')) {
436 $subject = $r[0]['title'];
440 if (strncasecmp($subject,'RE:',3)) {
441 $subject = 'Re: '.$subject;
444 Email::send($addr, $subject, $headers, $it);
448 case NETWORK_DIASPORA:
449 if ($public_message) {
450 $loc = 'public batch '.$contact['batch'];
452 $loc = $contact['name'];
455 logger('delivery: diaspora batch deliver: '.$loc);
457 if (Config::get('system','dfrn_only') || !Config::get('system','diaspora_enabled')) {
461 Diaspora::sendMail($item,$owner,$contact);
468 if (!$contact['pubkey'] && !$public_message) {
471 if (($target_item['deleted']) && (($target_item['uri'] === $target_item['parent-uri']) || $followup)) {
472 // top-level retraction
473 logger('diaspora retract: '.$loc);
474 Diaspora::sendRetraction($target_item,$owner,$contact,$public_message);
476 } elseif ($relocate) {
477 Diaspora::sendAccountMigration($owner, $contact, $uid);
479 } elseif ($followup) {
480 // send comments and likes to owner to relay
481 logger('diaspora followup: '.$loc);
482 Diaspora::sendFollowup($target_item,$owner,$contact,$public_message);
484 } elseif ($target_item['uri'] !== $target_item['parent-uri']) {
485 // we are the relay - send comments, likes and relayable_retractions to our conversants
486 logger('diaspora relay: '.$loc);
487 Diaspora::sendRelay($target_item,$owner,$contact,$public_message);
489 } elseif ($top_level && !$walltowall) {
490 // currently no workable solution for sending walltowall
491 logger('diaspora status: '.$loc);
492 Diaspora::sendStatus($target_item,$owner,$contact,$public_message);
496 logger('delivery: diaspora unknown mode: '.$contact['name']);
507 private static function getItemContact($item, $contacts)
509 if (!count($contacts) || !is_array($item)) {
512 foreach ($contacts as $contact) {
513 if ($contact['id'] == $item['contact-id']) {