3 * @file src/Worker/Delivery.php
6 namespace Friendica\Worker;
9 use Friendica\Core\System;
10 use Friendica\Core\Config;
11 use Friendica\Database\DBM;
12 use Friendica\Model\Contact;
13 use Friendica\Protocol\Diaspora;
14 use Friendica\Protocol\DFRN;
15 use Friendica\Protocol\Email;
17 require_once 'include/queue_fn.php';
18 require_once 'include/html2plain.php';
19 require_once 'include/datetime.php';
20 require_once 'include/items.php';
21 require_once 'include/bbcode.php';
23 /// @todo This is some ugly code that needs to be split into several methods
26 public static function execute($cmd, $item_id, $contact_id) {
29 logger('delivery: invoked: '.$cmd.': '.$item_id.' to '.$contact_id, LOGGER_DEBUG);
36 $recipients = array();
37 $url_recipients = array();
42 $recipients[] = $contact_id;
44 if ($cmd === 'mail') {
47 $message = q("SELECT * FROM `mail` WHERE `id` = %d LIMIT 1",
50 if (!count($message)) {
53 $uid = $message[0]['uid'];
54 $recipients[] = $message[0]['contact-id'];
56 } elseif ($cmd === 'expire') {
59 $items = q("SELECT * FROM `item` WHERE `uid` = %d AND `wall` = 1
60 AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP() - INTERVAL 30 MINUTE",
68 } elseif ($cmd === 'suggest') {
72 $suggest = q("SELECT * FROM `fsuggest` WHERE `id` = %d LIMIT 1",
75 if (!count($suggest)) {
78 $uid = $suggest[0]['uid'];
79 $recipients[] = $suggest[0]['cid'];
81 } elseif ($cmd === 'relocate') {
87 $r = q("SELECT * FROM `item` WHERE `id` = %d AND visible = 1 AND moderated = 0 LIMIT 1",
91 if (!DBM::is_result($r) || !intval($r[0]['parent'])) {
96 $parent_id = intval($r[0]['parent']);
98 $updated = $r[0]['edited'];
100 $items = q("SELECT `item`.*, `sign`.`signed_text`,`sign`.`signature`,`sign`.`signer`
101 FROM `item` LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id` WHERE `parent` = %d AND visible = 1 AND moderated = 0 ORDER BY `id` ASC",
105 if (!count($items)) {
110 $contacts_arr = array();
111 foreach ($items as $item) {
112 if (!in_array($item['contact-id'],$contacts_arr)) {
113 $contacts_arr[] = intval($item['contact-id']);
116 if (count($contacts_arr)) {
117 $str_contacts = implode(',',$contacts_arr);
118 $icontacts = q("SELECT * FROM `contact`
119 WHERE `id` IN ( $str_contacts ) "
122 if ( !($icontacts && count($icontacts))) {
126 // avoid race condition with deleting entries
128 if ($items[0]['deleted']) {
129 foreach ($items as $item) {
130 $item['deleted'] = 1;
134 // When commenting too fast after delivery, a post wasn't recognized as top level post.
135 // The count then showed more than one entry. The additional check should help.
136 // The check for the "count" should be superfluous, but I'm not totally sure by now, so we keep it.
137 if ((($items[0]['id'] == $item_id) || (count($items) == 1)) && ($items[0]['uri'] === $items[0]['parent-uri'])) {
138 logger('delivery: top level post');
143 $r = q("SELECT `contact`.*, `user`.`prvkey` AS `uprvkey`,
144 `user`.`timezone`, `user`.`nickname`, `user`.`sprvkey`, `user`.`spubkey`,
145 `user`.`page-flags`, `user`.`account-type`, `user`.`prvnets`
146 FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
147 WHERE `contact`.`uid` = %d AND `contact`.`self` = 1 LIMIT 1",
151 if (!DBM::is_result($r)) {
157 $walltowall = (($top_level && ($owner['id'] != $items[0]['contact-id'])) ? true : false);
159 $public_message = true;
161 if (!($mail || $fsuggest || $relocate)) {
164 // This is IMPORTANT!!!!
166 // We will only send a "notify owner to relay" or followup message if the referenced post
167 // originated on our system by virtue of having our hostname somewhere
168 // in the URI, AND it was a comment (not top_level) AND the parent originated elsewhere.
169 // if $parent['wall'] == 1 we will already have the parent message in our array
170 // and we will relay the whole lot.
172 // expire sends an entire group of expire messages and cannot be forwarded.
173 // However the conversation owner will be a part of the conversation and will
174 // be notified during this run.
175 // Other DFRN conversation members will be alerted during polled updates.
177 // Diaspora members currently are not notified of expirations, and other networks have
178 // either limited or no ability to process deletions. We should at least fix Diaspora
179 // by stringing togther an array of retractions and sending them onward.
182 $localhost = $a->get_hostname();
183 if (strpos($localhost,':')) {
184 $localhost = substr($localhost,0,strpos($localhost,':'));
188 * Be VERY CAREFUL if you make any changes to the following line. Seemingly innocuous changes
189 * have been known to cause runaway conditions which affected several servers, along with
190 * permissions issues.
194 $relay_to_owner = false;
196 if (!$top_level && ($parent['wall'] == 0) && !$expire && stristr($target_item['uri'],$localhost)) {
197 $relay_to_owner = true;
200 if ($relay_to_owner) {
201 logger('followup '.$target_item["guid"], LOGGER_DEBUG);
202 // local followup to remote post
206 if ((strlen($parent['allow_cid']))
207 || (strlen($parent['allow_gid']))
208 || (strlen($parent['deny_cid']))
209 || (strlen($parent['deny_gid']))
210 || $parent["private"]) {
211 $public_message = false; // private recipients, not public
216 $r = q("SELECT * FROM `contact` WHERE `id` = %d AND `blocked` = 0 AND `pending` = 0",
220 if (DBM::is_result($r)) {
223 if ($contact['self']) {
228 logger("main delivery by delivery: followup=$followup mail=$mail fsuggest=$fsuggest relocate=$relocate - network ".$contact['network']);
230 switch($contact['network']) {
233 logger('notifier: '.$target_item["guid"].' dfrndelivery: '.$contact['name']);
236 $item['body'] = fix_private_photos($item['body'],$owner['uid'],null,$message[0]['contact-id']);
237 $atom = DFRN::mail($item, $owner);
238 } elseif ($fsuggest) {
239 $atom = DFRN::fsuggest($item, $owner);
240 q("DELETE FROM `fsuggest` WHERE `id` = %d LIMIT 1", intval($item['id']));
241 } elseif ($relocate) {
242 $atom = DFRN::relocate($owner, $uid);
243 } elseif ($followup) {
245 foreach ($items as $item) { // there is only one item
246 if (!$item['parent']) {
249 if ($item['id'] == $item_id) {
250 logger('followup: item: '. print_r($item,true), LOGGER_DATA);
254 $atom = DFRN::entries($msgitems,$owner);
257 foreach ($items as $item) {
258 if (!$item['parent']) {
262 // private emails may be in included in public conversations. Filter them.
263 if ($public_message && $item['private']) {
267 $item_contact = get_item_contact($item,$icontacts);
268 if (!$item_contact) {
273 if ($item_id == $item['id'] || $item['id'] == $item['parent']) {
274 $item["entry:comment-allow"] = true;
275 $item["entry:cid"] = (($top_level) ? $contact['id'] : 0);
279 $item["entry:comment-allow"] = true;
283 $atom = DFRN::entries($msgitems,$owner);
286 logger('notifier entry: '.$contact["url"].' '.$target_item["guid"].' entry: '.$atom, LOGGER_DEBUG);
288 logger('notifier: '.$atom, LOGGER_DATA);
289 $basepath = implode('/', array_slice(explode('/',$contact['url']),0,3));
291 // perform local delivery if we are on the same site
293 if (link_compare($basepath,System::baseUrl())) {
295 $nickname = basename($contact['url']);
296 if ($contact['issued-id']) {
297 $sql_extra = sprintf(" AND `dfrn-id` = '%s' ", dbesc($contact['issued-id']));
299 $sql_extra = sprintf(" AND `issued-id` = '%s' ", dbesc($contact['dfrn-id']));
302 $x = q("SELECT `contact`.*, `contact`.`uid` AS `importer_uid`,
303 `contact`.`pubkey` AS `cpubkey`,
304 `contact`.`prvkey` AS `cprvkey`,
305 `contact`.`thumb` AS `thumb`,
306 `contact`.`url` as `url`,
307 `contact`.`name` as `senderName`,
310 INNER JOIN `user` ON `contact`.`uid` = `user`.`uid`
311 WHERE `contact`.`blocked` = 0 AND `contact`.`pending` = 0
312 AND `contact`.`network` = '%s' AND `user`.`nickname` = '%s'
314 AND `user`.`account_expired` = 0 AND `user`.`account_removed` = 0 LIMIT 1",
319 if ($x && count($x)) {
320 $write_flag = ((($x[0]['rel']) && ($x[0]['rel'] != CONTACT_IS_SHARING)) ? true : false);
321 if ((($owner['page-flags'] == PAGE_COMMUNITY) || $write_flag) && !$x[0]['writable']) {
322 q("UPDATE `contact` SET `writable` = 1 WHERE `id` = %d",
325 $x[0]['writable'] = 1;
328 $ssl_policy = Config::get('system','ssl_policy');
329 fix_contact_ssl_policy($x[0],$ssl_policy);
331 // If we are setup as a soapbox we aren't accepting top level posts from this person
333 if (($x[0]['page-flags'] == PAGE_SOAPBOX) && $top_level) {
336 logger('mod-delivery: local delivery');
337 DFRN::import($atom, $x[0]);
342 if (!was_recently_delayed($contact['id'])) {
343 $deliver_status = DFRN::deliver($owner,$contact,$atom);
345 $deliver_status = (-1);
348 logger('notifier: dfrn_delivery to '.$contact["url"].' with guid '.$target_item["guid"].' returns '.$deliver_status);
350 if ($deliver_status < 0) {
351 logger('notifier: delivery failed: queuing message');
352 add_to_queue($contact['id'],NETWORK_DFRN,$atom);
354 // The message could not be delivered. We mark the contact as "dead"
355 Contact::markForArchival($contact);
357 // We successfully delivered a message, the contact is alive
358 Contact::unmarkForArchival($contact);
363 case NETWORK_OSTATUS:
364 // Do not send to otatus if we are not configured to send to public networks
365 if ($owner['prvnets']) {
368 if (Config::get('system','ostatus_disabled') || Config::get('system','dfrn_only')) {
372 // There is currently no code here to distribute anything to OStatus.
373 // This is done in "notifier.php" (See "url_recipients" and "push_notify")
378 if (Config::get('system','dfrn_only')) {
381 // WARNING: does not currently convert to RFC2047 header encodings, etc.
383 $addr = $contact['addr'];
384 if (!strlen($addr)) {
388 if ($cmd === 'wall-new' || $cmd === 'comment-new') {
391 if ($cmd === 'wall-new') {
394 $r = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
398 if (DBM::is_result($r))
405 $local_user = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
408 if (!count($local_user))
412 $r1 = q("SELECT * FROM `mailacct` WHERE `uid` = %d LIMIT 1",
415 if ($r1 && $r1[0]['reply_to'])
416 $reply_to = $r1[0]['reply_to'];
418 $subject = (($it['title']) ? Email::encodeHeader($it['title'],'UTF-8') : t("\x28no subject\x29")) ;
420 // only expose our real email address to true friends
422 if (($contact['rel'] == CONTACT_IS_FRIEND) && !$contact['blocked']) {
424 $headers = 'From: '.Email::encodeHeader($local_user[0]['username'],'UTF-8').' <'.$reply_to.'>'."\n";
425 $headers .= 'Sender: '.$local_user[0]['email']."\n";
427 $headers = 'From: '.Email::encodeHeader($local_user[0]['username'],'UTF-8').' <'.$local_user[0]['email'].'>'."\n";
430 $headers = 'From: '. Email::encodeHeader($local_user[0]['username'],'UTF-8') .' <'. t('noreply') .'@'.$a->get_hostname() .'>'. "\n";
434 // $headers .= 'Reply-to: '.$reply_to . "\n";
436 $headers .= 'Message-Id: <'. Email::iri2msgid($it['uri']).'>'. "\n";
438 //logger("Mail: uri: ".$it['uri']." parent-uri ".$it['parent-uri'], LOGGER_DEBUG);
439 //logger("Mail: Data: ".print_r($it, true), LOGGER_DEBUG);
440 //logger("Mail: Data: ".print_r($it, true), LOGGER_DATA);
442 if ($it['uri'] !== $it['parent-uri']) {
443 $headers .= "References: <".Email::iri2msgid($it["parent-uri"]).">";
445 // If Threading is enabled, write down the correct parent
446 if (($it["thr-parent"] != "") && ($it["thr-parent"] != $it["parent-uri"]))
447 $headers .= " <".Email::iri2msgid($it["thr-parent"]).">";
451 $r = q("SELECT `title` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
452 dbesc($it['parent-uri']),
455 if (DBM::is_result($r) && ($r[0]['title'] != '')) {
456 $subject = $r[0]['title'];
458 $r = q("SELECT `title` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d LIMIT 1",
459 dbesc($it['parent-uri']),
462 if (DBM::is_result($r) && ($r[0]['title'] != ''))
463 $subject = $r[0]['title'];
466 if (strncasecmp($subject,'RE:',3))
467 $subject = 'Re: '.$subject;
469 Email::send($addr, $subject, $headers, $it);
473 case NETWORK_DIASPORA:
475 $loc = 'public batch '.$contact['batch'];
477 $loc = $contact['name'];
479 logger('delivery: diaspora batch deliver: '.$loc);
481 if (Config::get('system','dfrn_only') || !Config::get('system','diaspora_enabled'))
485 Diaspora::sendMail($item,$owner,$contact);
492 if (!$contact['pubkey'] && !$public_message)
495 if (($target_item['deleted']) && (($target_item['uri'] === $target_item['parent-uri']) || $followup)) {
496 // top-level retraction
497 logger('diaspora retract: '.$loc);
498 Diaspora::sendRetraction($target_item,$owner,$contact,$public_message);
500 } elseif ($relocate) {
501 Diaspora::sendAccountMigration($owner, $contact, $uid);
503 } elseif ($followup) {
504 // send comments and likes to owner to relay
505 logger('diaspora followup: '.$loc);
506 Diaspora::sendFollowup($target_item,$owner,$contact,$public_message);
508 } elseif ($target_item['uri'] !== $target_item['parent-uri']) {
509 // we are the relay - send comments, likes and relayable_retractions to our conversants
510 logger('diaspora relay: '.$loc);
511 Diaspora::sendRelay($target_item,$owner,$contact,$public_message);
513 } elseif ($top_level && !$walltowall) {
514 // currently no workable solution for sending walltowall
515 logger('diaspora status: '.$loc);
516 Diaspora::sendStatus($target_item,$owner,$contact,$public_message);
520 logger('delivery: diaspora unknown mode: '.$contact['name']);