3 * @file src/Worker/Notifier.php
5 namespace Friendica\Worker;
8 use Friendica\Core\Config;
9 use Friendica\Core\Worker;
10 use Friendica\Database\DBM;
11 use Friendica\Network\Probe;
12 use Friendica\Object\Contact;
13 use Friendica\Protocol\Diaspora;
14 use Friendica\Protocol\OStatus;
17 require_once 'include/queue_fn.php';
18 require_once 'include/html2plain.php';
19 require_once 'include/salmon.php';
20 require_once 'include/datetime.php';
21 require_once 'include/items.php';
22 require_once 'include/bbcode.php';
23 require_once 'include/email.php';
26 * This file was at one time responsible for doing all deliveries, but this caused
27 * big problems when the process was killed or stalled during the delivery process.
28 * It now invokes separate queues that are delivering via delivery.php and pubsubpublish.php.
32 * The notifier is typically called with:
34 * Worker::add(PRIORITY_HIGH, "Notifier", COMMAND, ITEM_ID);
36 * where COMMAND is one of the following:
38 * activity (in diaspora.php, dfrn_confirm.php, profiles.php)
39 * comment-import (in diaspora.php, items.php)
40 * comment-new (in item.php)
41 * drop (in diaspora.php, items.php, photos.php)
42 * edit_post (in item.php)
43 * event (in events.php)
44 * expire (in items.php)
45 * like (in like.php, poke.php)
46 * mail (in message.php)
47 * suggest (in fsuggest.php)
48 * tag (in photos.php, poke.php, tagger.php)
49 * tgroup (in items.php)
50 * wall-new (in photos.php, item.php)
51 * removeme (in Contact.php)
52 * relocate (in uimport.php)
54 * and ITEM_ID is the id of the item in the database that needs to be sent to others.
58 public static function execute($cmd, $item_id) {
61 logger('notifier: invoked: '.$cmd.': '.$item_id, LOGGER_DEBUG);
68 $recipients = array();
69 $url_recipients = array();
73 if ($cmd === 'mail') {
76 $message = q("SELECT * FROM `mail` WHERE `id` = %d LIMIT 1",
79 if (! count($message)) {
82 $uid = $message[0]['uid'];
83 $recipients[] = $message[0]['contact-id'];
86 } elseif ($cmd === 'expire') {
89 $items = q("SELECT * FROM `item` WHERE `uid` = %d AND `wall` = 1
90 AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP() - INTERVAL 10 MINUTE",
95 if (! count($items)) {
98 } elseif ($cmd === 'suggest') {
102 $suggest = q("SELECT * FROM `fsuggest` WHERE `id` = %d LIMIT 1",
105 if (! count($suggest)) {
108 $uid = $suggest[0]['uid'];
109 $recipients[] = $suggest[0]['cid'];
111 } elseif ($cmd === 'removeme') {
112 $r = q("SELECT `contact`.*, `user`.`pubkey` AS `upubkey`, `user`.`prvkey` AS `uprvkey`,
113 `user`.`timezone`, `user`.`nickname`, `user`.`sprvkey`, `user`.`spubkey`,
114 `user`.`page-flags`, `user`.`prvnets`, `user`.`account-type`, `user`.`guid`
115 FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
116 WHERE `contact`.`uid` = %d AND `contact`.`self` LIMIT 1",
123 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `self` LIMIT 1", intval($item_id));
129 $r = q("SELECT * FROM `contact` WHERE NOT `self` AND `uid` = %d", intval($item_id));
133 require_once 'include/Contact.php';
134 foreach ($r as $contact) {
135 terminate_friendship($user, $self, $contact);
138 } elseif ($cmd === 'relocate') {
139 $normal_mode = false;
143 $recipients_relocate = q("SELECT * FROM `contact` WHERE `uid` = %d AND NOT `self` AND `network` IN ('%s', '%s')",
144 intval($uid), NETWORK_DFRN, NETWORK_DIASPORA);
147 $r = q("SELECT * FROM `item` WHERE `id` = %d AND visible = 1 AND moderated = 0 LIMIT 1",
151 if ((! DBM::is_result($r)) || (! intval($r[0]['parent']))) {
155 $target_item = $r[0];
156 $parent_id = intval($r[0]['parent']);
158 $updated = $r[0]['edited'];
160 $items = q("SELECT `item`.*, `sign`.`signed_text`,`sign`.`signature`,`sign`.`signer`
161 FROM `item` LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id` WHERE `parent` = %d AND visible = 1 AND moderated = 0 ORDER BY `id` ASC",
165 if (! count($items)) {
169 // avoid race condition with deleting entries
171 if ($items[0]['deleted']) {
172 foreach ($items as $item) {
173 $item['deleted'] = 1;
177 if ((count($items) == 1) && ($items[0]['id'] === $target_item['id']) && ($items[0]['uri'] === $items[0]['parent-uri'])) {
178 logger('notifier: top level post');
184 $r = q("SELECT `contact`.*, `user`.`pubkey` AS `upubkey`, `user`.`prvkey` AS `uprvkey`,
185 `user`.`timezone`, `user`.`nickname`, `user`.`sprvkey`, `user`.`spubkey`,
186 `user`.`page-flags`, `user`.`prvnets`, `user`.`account-type`
187 FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
188 WHERE `contact`.`uid` = %d AND `contact`.`self` = 1 LIMIT 1",
192 if (! DBM::is_result($r)) {
198 $walltowall = ((($top_level) && ($owner['id'] != $items[0]['contact-id'])) ? true : false);
200 // Should the post be transmitted to Diaspora?
201 $diaspora_delivery = true;
203 // If this is a public conversation, notify the feed hub
204 $public_message = true;
207 $push_notify = false;
209 // Deliver directly to a forum, don't PuSH
210 $direct_forum_delivery = false;
212 // fill this in with a single salmon slap if applicable
215 if (! ($mail || $fsuggest || $relocate)) {
217 $slap = OStatus::salmon($target_item, $owner);
219 require_once 'include/group.php';
223 $thr_parent = q("SELECT `network`, `author-link`, `owner-link` FROM `item` WHERE `uri` = '%s' AND `uid` = %d",
224 dbesc($target_item["thr-parent"]), intval($target_item["uid"]));
226 logger('GUID: '.$target_item["guid"].': Parent is '.$parent['network'].'. Thread parent is '.$thr_parent[0]['network'], LOGGER_DEBUG);
228 // This is IMPORTANT!!!!
230 // We will only send a "notify owner to relay" or followup message if the referenced post
231 // originated on our system by virtue of having our hostname somewhere
232 // in the URI, AND it was a comment (not top_level) AND the parent originated elsewhere.
234 // if $parent['wall'] == 1 we will already have the parent message in our array
235 // and we will relay the whole lot.
237 // expire sends an entire group of expire messages and cannot be forwarded.
238 // However the conversation owner will be a part of the conversation and will
239 // be notified during this run.
240 // Other DFRN conversation members will be alerted during polled updates.
244 // Diaspora members currently are not notified of expirations, and other networks have
245 // either limited or no ability to process deletions. We should at least fix Diaspora
246 // by stringing togther an array of retractions and sending them onward.
249 $localhost = str_replace('www.','',$a->get_hostname());
250 if (strpos($localhost,':')) {
251 $localhost = substr($localhost,0,strpos($localhost,':'));
255 * Be VERY CAREFUL if you make any changes to the following several lines. Seemingly innocuous changes
256 * have been known to cause runaway conditions which affected several servers, along with
257 * permissions issues.
261 $relay_to_owner = false;
263 if (!$top_level && ($parent['wall'] == 0) && !$expire && (stristr($target_item['uri'],$localhost))) {
264 $relay_to_owner = true;
268 if (($cmd === 'uplink') && (intval($parent['forum_mode']) == 1) && !$top_level) {
269 $relay_to_owner = true;
272 // until the 'origin' flag has been in use for several months
273 // we will just use it as a fallback test
274 // later we will be able to use it as the primary test of whether or not to relay.
276 if (! $target_item['origin']) {
277 $relay_to_owner = false;
279 if ($parent['origin']) {
280 $relay_to_owner = false;
283 // Special treatment for forum posts
284 if (($target_item['author-link'] != $target_item['owner-link']) &&
285 ($owner['id'] != $target_item['contact-id']) &&
286 ($target_item['uri'] === $target_item['parent-uri'])) {
288 $fields = array('forum', 'prv');
289 $condition = array('id' => $target_item['contact-id']);
290 $contact = dba::select('contact', $fields, $condition, array('limit' => 1));
291 if (!DBM::is_result($contact)) {
292 // Should never happen
296 // Is the post from a forum?
297 if ($contact['forum'] || $contact['prv']) {
298 $relay_to_owner = true;
299 $direct_forum_delivery = true;
302 if ($relay_to_owner) {
303 logger('notifier: followup '.$target_item["guid"], LOGGER_DEBUG);
304 // local followup to remote post
306 $public_message = false; // not public
307 $conversant_str = dbesc($parent['contact-id']);
308 $recipients = array($parent['contact-id']);
309 $recipients_followup = array($parent['contact-id']);
311 //if (!$target_item['private'] && $target_item['wall'] &&
312 if (!$target_item['private'] &&
313 (strlen($target_item['allow_cid'].$target_item['allow_gid'].
314 $target_item['deny_cid'].$target_item['deny_gid']) == 0))
317 if (($thr_parent && ($thr_parent[0]['network'] == NETWORK_OSTATUS)) || ($parent['network'] == NETWORK_OSTATUS)) {
321 if ($parent["network"] == NETWORK_OSTATUS) {
322 // Distribute the message to the DFRN contacts as if this wasn't a followup since OStatus can't relay comments
323 // Currently it is work at progress
324 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `network` = '%s' AND NOT `blocked` AND NOT `pending` AND NOT `archive`",
328 if (DBM::is_result($r)) {
329 foreach ($r as $rr) {
330 $recipients_followup[] = $rr['id'];
336 if ($direct_forum_delivery) {
337 $push_notify = false;
340 logger("Notify ".$target_item["guid"]." via PuSH: ".($push_notify?"Yes":"No"), LOGGER_DEBUG);
344 logger('Distributing directly '.$target_item["guid"], LOGGER_DEBUG);
346 // don't send deletions onward for other people's stuff
348 if ($target_item['deleted'] && (! intval($target_item['wall']))) {
349 logger('notifier: ignoring delete notification for non-wall item');
353 if ((strlen($parent['allow_cid']))
354 || (strlen($parent['allow_gid']))
355 || (strlen($parent['deny_cid']))
356 || (strlen($parent['deny_gid']))) {
357 $public_message = false; // private recipients, not public
360 $allow_people = expand_acl($parent['allow_cid']);
361 $allow_groups = expand_groups(expand_acl($parent['allow_gid']),true);
362 $deny_people = expand_acl($parent['deny_cid']);
363 $deny_groups = expand_groups(expand_acl($parent['deny_gid']));
365 // if our parent is a public forum (forum_mode == 1), uplink to the origional author causing
366 // a delivery fork. private groups (forum_mode == 2) do not uplink
368 if ((intval($parent['forum_mode']) == 1) && (! $top_level) && ($cmd !== 'uplink')) {
369 Worker::add($a->queue['priority'], 'Notifier', 'uplink', $item_id);
372 $conversants = array();
374 foreach ($items as $item) {
375 $recipients[] = $item['contact-id'];
376 $conversants[] = $item['contact-id'];
377 // pull out additional tagged people to notify (if public message)
378 if ($public_message && strlen($item['inform'])) {
379 $people = explode(',',$item['inform']);
380 foreach ($people as $person) {
381 if (substr($person,0,4) === 'cid:') {
382 $recipients[] = intval(substr($person,4));
383 $conversants[] = intval(substr($person,4));
385 $url_recipients[] = substr($person,4);
391 if (count($url_recipients))
392 logger('notifier: '.$target_item["guid"].' url_recipients ' . print_r($url_recipients,true));
394 $conversants = array_unique($conversants);
397 $recipients = array_unique(array_merge($recipients,$allow_people,$allow_groups));
398 $deny = array_unique(array_merge($deny_people,$deny_groups));
399 $recipients = array_diff($recipients,$deny);
401 $conversant_str = dbesc(implode(', ',$conversants));
404 // If the thread parent is OStatus then do some magic to distribute the messages.
405 // We have not only to look at the parent, since it could be a Friendica thread.
406 if (($thr_parent && ($thr_parent[0]['network'] == NETWORK_OSTATUS)) || ($parent['network'] == NETWORK_OSTATUS)) {
408 $diaspora_delivery = false;
410 logger('Some parent is OStatus for '.$target_item["guid"]." - Author: ".$thr_parent[0]['author-link']." - Owner: ".$thr_parent[0]['owner-link'], LOGGER_DEBUG);
412 // Send a salmon to the parent author
413 $r = q("SELECT `url`, `notify` FROM `contact` WHERE `nurl`='%s' AND `uid` IN (0, %d) AND `notify` != ''",
414 dbesc(normalise_link($thr_parent[0]['author-link'])),
416 if (DBM::is_result($r)) {
417 $probed_contact = $r[0];
419 $probed_contact = Probe::uri($thr_parent[0]['author-link']);
422 if ($probed_contact["notify"] != "") {
423 logger('Notify parent author '.$probed_contact["url"].': '.$probed_contact["notify"]);
424 $url_recipients[$probed_contact["notify"]] = $probed_contact["notify"];
427 // Send a salmon to the parent owner
428 $r = q("SELECT `url`, `notify` FROM `contact` WHERE `nurl`='%s' AND `uid` IN (0, %d) AND `notify` != ''",
429 dbesc(normalise_link($thr_parent[0]['owner-link'])),
431 if (DBM::is_result($r)) {
432 $probed_contact = $r[0];
434 $probed_contact = Probe::uri($thr_parent[0]['owner-link']);
437 if ($probed_contact["notify"] != "") {
438 logger('Notify parent owner '.$probed_contact["url"].': '.$probed_contact["notify"]);
439 $url_recipients[$probed_contact["notify"]] = $probed_contact["notify"];
442 // Send a salmon notification to every person we mentioned in the post
443 $arr = explode(',',$target_item['tag']);
444 foreach ($arr as $x) {
445 //logger('Checking tag '.$x, LOGGER_DEBUG);
447 if (preg_match('/@\[url=([^\]]*)\]/',$x,$matches)) {
448 $probed_contact = Probe::uri($matches[1]);
449 if ($probed_contact["notify"] != "") {
450 logger('Notify mentioned user '.$probed_contact["url"].': '.$probed_contact["notify"]);
451 $url_recipients[$probed_contact["notify"]] = $probed_contact["notify"];
456 // It only makes sense to distribute answers to OStatus messages to Friendica and OStatus - but not Diaspora
457 $sql_extra = " AND `network` IN ('".NETWORK_OSTATUS."', '".NETWORK_DFRN."')";
459 $sql_extra = " AND `network` IN ('".NETWORK_OSTATUS."', '".NETWORK_DFRN."', '".NETWORK_DIASPORA."', '".NETWORK_MAIL."', '".NETWORK_MAIL2."')";
462 $public_message = false;
465 // If this is a public message and pubmail is set on the parent, include all your email contacts
467 $mail_disabled = ((function_exists('imap_open') && (!Config::get('system','imap_disabled'))) ? 0 : 1);
469 if (! $mail_disabled) {
470 if ((! strlen($target_item['allow_cid'])) && (! strlen($target_item['allow_gid']))
471 && (! strlen($target_item['deny_cid'])) && (! strlen($target_item['deny_gid']))
472 && (intval($target_item['pubmail']))) {
473 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `network` = '%s'",
477 if (DBM::is_result($r)) {
478 foreach ($r as $rr) {
479 $recipients[] = $rr['id'];
486 $recip_str = implode(', ', $recipients_followup);
488 $recip_str = implode(', ', $recipients);
491 $r = $recipients_relocate;
493 $r = q("SELECT `id`, `url`, `network`, `self` FROM `contact`
494 WHERE `id` IN (%s) AND NOT `blocked` AND NOT `pending` AND NOT `archive`".$sql_extra,
501 if (DBM::is_result($r)) {
502 foreach ($r as $contact) {
503 if ($contact['self']) {
506 logger("Deliver ".$target_item["guid"]." to ".$contact['url']." via network ".$contact['network'], LOGGER_DEBUG);
508 Worker::add(array('priority' => $a->queue['priority'], 'created' => $a->queue['created'], 'dont_fork' => true),
509 'Delivery', $cmd, $item_id, (int)$contact['id']);
513 // send salmon slaps to mentioned remote tags (@foo@example.com) in OStatus posts
514 // They are especially used for notifications to OStatus users that don't follow us.
516 if ($slap && count($url_recipients) && ($public_message || $push_notify) && $normal_mode) {
517 if (!Config::get('system','dfrn_only')) {
518 foreach ($url_recipients as $url) {
520 logger('notifier: urldelivery: ' . $url);
521 $deliver_status = slapper($owner,$url,$slap);
522 /// @TODO Redeliver/queue these items on failure, though there is no contact record
529 if ($public_message) {
534 if ($diaspora_delivery) {
536 $r0 = Diaspora::relay_list();
539 $r1 = q("SELECT `batch`, ANY_VALUE(`id`) AS `id`, ANY_VALUE(`name`) AS `name`, ANY_VALUE(`network`) AS `network`
540 FROM `contact` WHERE `network` = '%s' AND `batch` != ''
541 AND `uid` = %d AND `rel` != %d AND NOT `blocked` AND NOT `pending` AND NOT `archive` GROUP BY `batch`",
542 dbesc(NETWORK_DIASPORA),
543 intval($owner['uid']),
544 intval(CONTACT_IS_SHARING)
548 $r2 = q("SELECT `id`, `name`,`network` FROM `contact`
549 WHERE `network` in ('%s', '%s') AND `uid` = %d AND NOT `blocked` AND NOT `pending` AND NOT `archive` AND `rel` != %d",
551 dbesc(NETWORK_MAIL2),
552 intval($owner['uid']),
553 intval(CONTACT_IS_SHARING)
556 $r = array_merge($r2,$r1,$r0);
558 if (DBM::is_result($r)) {
559 logger('pubdeliver '.$target_item["guid"].': '.print_r($r,true), LOGGER_DEBUG);
561 foreach ($r as $rr) {
563 // except for Diaspora batch jobs
564 // Don't deliver to folks who have already been delivered to
566 if (($rr['network'] !== NETWORK_DIASPORA) && (in_array($rr['id'],$conversants))) {
567 logger('notifier: already delivered id=' . $rr['id']);
571 if ((! $mail) && (! $fsuggest) && (! $followup)) {
572 logger('notifier: delivery agent: '.$rr['name'].' '.$rr['id'].' '.$rr['network'].' '.$target_item["guid"]);
573 Worker::add(array('priority' => $a->queue['priority'], 'created' => $a->queue['created'], 'dont_fork' => true),
574 'Delivery', $cmd, $item_id, (int)$rr['id']);
583 // Notify PuSH subscribers (Used for OStatus distribution of regular posts)
585 // Set push flag for PuSH subscribers to this topic,
586 // they will be notified in queue.php
587 q("UPDATE `push_subscriber` SET `push` = 1 ".
588 "WHERE `nickname` = '%s' AND `push` = 0", dbesc($owner['nickname']));
590 logger('Activating internal PuSH for item '.$item_id, LOGGER_DEBUG);
592 // Handling the pubsubhubbub requests
593 Worker::add(array('priority' => PRIORITY_HIGH, 'created' => $a->queue['created'], 'dont_fork' => true),
597 logger('notifier: calling hooks', LOGGER_DEBUG);
600 call_hooks('notifier_normal',$target_item);
603 call_hooks('notifier_end',$target_item);