include/notifier.php

   1 <?php
   2 require_once("boot.php");
   3 require_once('include/queue_fn.php');
   4 require_once('include/html2plain.php');
   5 require_once("include/Scrape.php");
   6 require_once('include/diaspora.php');
   7 require_once("include/ostatus.php");
   8 require_once('include/salmon.php');
   9
  10 /*
  11  * This file was at one time responsible for doing all deliveries, but this caused
  12  * big problems when the process was killed or stalled during the delivery process.
  13  * It now invokes separate queues that are delivering via delivery.php and pubsubpublish.php.
  14  */
  15
  16 /*
  17  * The notifier is typically called with:
  18  *
  19  *              proc_run(PRIORITY_HIGH, "include/notifier.php", COMMAND, ITEM_ID);
  20  *
  21  * where COMMAND is one of the following:
  22  *
  23  *              activity                                (in diaspora.php, dfrn_confirm.php, profiles.php)
  24  *              comment-import                  (in diaspora.php, items.php)
  25  *              comment-new                             (in item.php)
  26  *              drop                                    (in diaspora.php, items.php, photos.php)
  27  *              edit_post                               (in item.php)
  28  *              event                                   (in events.php)
  29  *              expire                                  (in items.php)
  30  *              like                                    (in like.php, poke.php)
  31  *              mail                                    (in message.php)
  32  *              suggest                                 (in fsuggest.php)
  33  *              tag                                             (in photos.php, poke.php, tagger.php)
  34  *              tgroup                                  (in items.php)
  35  *              wall-new                                (in photos.php, item.php)
  36  *              removeme                                (in Contact.php)
  37  *              relocate                                (in uimport.php)
  38  *
  39  * and ITEM_ID is the id of the item in the database that needs to be sent to others.
  40  */
  41
  42
  43 function notifier_run(&$argv, &$argc){
  44         global $a, $db;
  45
  46         if(is_null($a)){
  47                 $a = new App;
  48         }
  49
  50         if(is_null($db)) {
  51                 @include(".htconfig.php");
  52                 require_once("include/dba.php");
  53                 $db = new dba($db_host, $db_user, $db_pass, $db_data);
  54                         unset($db_host, $db_user, $db_pass, $db_data);
  55         }
  56
  57         require_once("include/session.php");
  58         require_once("include/datetime.php");
  59         require_once('include/items.php');
  60         require_once('include/bbcode.php');
  61         require_once('include/email.php');
  62         load_config('config');
  63         load_config('system');
  64
  65         load_hooks();
  66
  67         if($argc < 3)
  68                 return;
  69
  70         $a->set_baseurl(get_config('system','url'));
  71
  72         logger('notifier: invoked: ' . print_r($argv,true), LOGGER_DEBUG);
  73
  74         $cmd = $argv[1];
  75
  76         switch($cmd) {
  77                 case 'mail':
  78                 default:
  79                         $item_id = intval($argv[2]);
  80                         if(! $item_id){
  81                                 return;
  82                         }
  83                         break;
  84         }
  85
  86         $expire = false;
  87         $mail = false;
  88         $fsuggest = false;
  89         $relocate = false;
  90         $top_level = false;
  91         $recipients = array();
  92         $url_recipients = array();
  93
  94         $normal_mode = true;
  95
  96         if($cmd === 'mail') {
  97                 $normal_mode = false;
  98                 $mail = true;
  99                 $message = q("SELECT * FROM `mail` WHERE `id` = %d LIMIT 1",
 100                                 intval($item_id)
 101                 );
 102                 if(! count($message)){
 103                         return;
 104                 }
 105                 $uid = $message[0]['uid'];
 106                 $recipients[] = $message[0]['contact-id'];
 107                 $item = $message[0];
 108
 109         }
 110         elseif($cmd === 'expire') {
 111                 $normal_mode = false;
 112                 $expire = true;
 113                 $items = q("SELECT * FROM `item` WHERE `uid` = %d AND `wall` = 1
 114                         AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP() - INTERVAL 10 MINUTE",
 115                         intval($item_id)
 116                 );
 117                 $uid = $item_id;
 118                 $item_id = 0;
 119                 if(! count($items))
 120                         return;
 121         }
 122         elseif($cmd === 'suggest') {
 123                 $normal_mode = false;
 124                 $fsuggest = true;
 125
 126                 $suggest = q("SELECT * FROM `fsuggest` WHERE `id` = %d LIMIT 1",
 127                         intval($item_id)
 128                 );
 129                 if(! count($suggest))
 130                         return;
 131                 $uid = $suggest[0]['uid'];
 132                 $recipients[] = $suggest[0]['cid'];
 133                 $item = $suggest[0];
 134         } elseif($cmd === 'removeme') {
 135                 $r = q("SELECT `contact`.*, `user`.`pubkey` AS `upubkey`, `user`.`prvkey` AS `uprvkey`,
 136                                 `user`.`timezone`, `user`.`nickname`, `user`.`sprvkey`, `user`.`spubkey`,
 137                                 `user`.`page-flags`, `user`.`prvnets`, `user`.`account-type`, `user`.`guid`
 138                         FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
 139                                 WHERE `contact`.`uid` = %d AND `contact`.`self` LIMIT 1",
 140                                 intval($item_id));
 141                 if (!$r)
 142                         return;
 143
 144                 $user = $r[0];
 145
 146                 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `self` LIMIT 1", intval($item_id));
 147                 if (!$r)
 148                         return;
 149
 150                 $self = $r[0];
 151
 152                 $r = q("SELECT * FROM `contact` WHERE NOT `self` AND `uid` = %d", intval($item_id));
 153                 if(!$r)
 154                         return;
 155
 156                 require_once('include/Contact.php');
 157                 foreach($r as $contact) {
 158                         terminate_friendship($user, $self, $contact);
 159                 }
 160                 return;
 161         } elseif($cmd === 'relocate') {
 162                 $normal_mode = false;
 163                 $relocate = true;
 164                 $uid = $item_id;
 165
 166                 $recipients_relocate = q("SELECT * FROM contact WHERE uid = %d  AND self = 0 AND network = '%s'" , intval($uid), NETWORK_DFRN);
 167         } else {
 168                 // find ancestors
 169                 $r = q("SELECT * FROM `item` WHERE `id` = %d and visible = 1 and moderated = 0 LIMIT 1",
 170                         intval($item_id)
 171                 );
 172
 173                 if((! dbm::is_result($r)) || (! intval($r[0]['parent']))) {
 174                         return;
 175                 }
 176
 177                 $target_item = $r[0];
 178                 $parent_id = intval($r[0]['parent']);
 179                 $uid = $r[0]['uid'];
 180                 $updated = $r[0]['edited'];
 181
 182                 $items = q("SELECT `item`.*, `sign`.`signed_text`,`sign`.`signature`,`sign`.`signer`
 183                         FROM `item` LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id` WHERE `parent` = %d and visible = 1 and moderated = 0 ORDER BY `id` ASC",
 184                         intval($parent_id)
 185                 );
 186
 187                 if(! count($items)) {
 188                         return;
 189                 }
 190
 191                 // avoid race condition with deleting entries
 192
 193                 if($items[0]['deleted']) {
 194                         foreach($items as $item)
 195                                 $item['deleted'] = 1;
 196                 }
 197
 198                 if((count($items) == 1) && ($items[0]['id'] === $target_item['id']) && ($items[0]['uri'] === $items[0]['parent-uri'])) {
 199                         logger('notifier: top level post');
 200                         $top_level = true;
 201                 }
 202
 203         }
 204
 205         $r = q("SELECT `contact`.*, `user`.`pubkey` AS `upubkey`, `user`.`prvkey` AS `uprvkey`,
 206                 `user`.`timezone`, `user`.`nickname`, `user`.`sprvkey`, `user`.`spubkey`,
 207                 `user`.`page-flags`, `user`.`prvnets`, `user`.`account-type`
 208                 FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
 209                 WHERE `contact`.`uid` = %d AND `contact`.`self` = 1 LIMIT 1",
 210                 intval($uid)
 211         );
 212
 213         if(! dbm::is_result($r))
 214                 return;
 215
 216         $owner = $r[0];
 217
 218         $walltowall = ((($top_level) && ($owner['id'] != $items[0]['contact-id'])) ? true : false);
 219
 220         $hub = get_config('system','huburl');
 221
 222         // If this is a public conversation, notify the feed hub
 223         $public_message = true;
 224
 225         // Do a PuSH
 226         $push_notify = false;
 227
 228         // fill this in with a single salmon slap if applicable
 229         $slap = '';
 230
 231         if(! ($mail || $fsuggest || $relocate)) {
 232
 233                 $slap = ostatus::salmon($target_item,$owner);
 234
 235                 require_once('include/group.php');
 236
 237                 $parent = $items[0];
 238
 239                 $thr_parent = q("SELECT `network`, `author-link`, `owner-link` FROM `item` WHERE `uri` = '%s' AND `uid` = %d",
 240                         dbesc($target_item["thr-parent"]), intval($target_item["uid"]));
 241
 242                 logger('Parent is '.$parent['network'].'. Thread parent is '.$thr_parent[0]['network'], LOGGER_DEBUG);
 243
 244                 // This is IMPORTANT!!!!
 245
 246                 // We will only send a "notify owner to relay" or followup message if the referenced post
 247                 // originated on our system by virtue of having our hostname somewhere
 248                 // in the URI, AND it was a comment (not top_level) AND the parent originated elsewhere.
 249
 250                 // if $parent['wall'] == 1 we will already have the parent message in our array
 251                 // and we will relay the whole lot.
 252
 253                 // expire sends an entire group of expire messages and cannot be forwarded.
 254                 // However the conversation owner will be a part of the conversation and will
 255                 // be notified during this run.
 256                 // Other DFRN conversation members will be alerted during polled updates.
 257
 258
 259
 260                 // Diaspora members currently are not notified of expirations, and other networks have
 261                 // either limited or no ability to process deletions. We should at least fix Diaspora
 262                 // by stringing togther an array of retractions and sending them onward.
 263
 264
 265                 $localhost = str_replace('www.','',$a->get_hostname());
 266                 if(strpos($localhost,':'))
 267                         $localhost = substr($localhost,0,strpos($localhost,':'));
 268
 269                 /**
 270                  *
 271                  * Be VERY CAREFUL if you make any changes to the following several lines. Seemingly innocuous changes
 272                  * have been known to cause runaway conditions which affected several servers, along with
 273                  * permissions issues.
 274                  *
 275                  */
 276
 277                 $relay_to_owner = false;
 278
 279                 if(!$top_level && ($parent['wall'] == 0) && !$expire && (stristr($target_item['uri'],$localhost))) {
 280                         $relay_to_owner = true;
 281                 }
 282
 283
 284                 if(($cmd === 'uplink') && (intval($parent['forum_mode']) == 1) && !$top_level) {
 285                         $relay_to_owner = true;
 286                 }
 287
 288                 // until the 'origin' flag has been in use for several months
 289                 // we will just use it as a fallback test
 290                 // later we will be able to use it as the primary test of whether or not to relay.
 291
 292                 if(! $target_item['origin'])
 293                         $relay_to_owner = false;
 294
 295                 if($parent['origin'])
 296                         $relay_to_owner = false;
 297
 298                 if($relay_to_owner) {
 299                         logger('notifier: followup '.$target_item["guid"], LOGGER_DEBUG);
 300                         // local followup to remote post
 301                         $followup = true;
 302                         $public_message = false; // not public
 303                         $conversant_str = dbesc($parent['contact-id']);
 304                         $recipients = array($parent['contact-id']);
 305                         $recipients_followup  = array($parent['contact-id']);
 306
 307                         //if (!$target_item['private'] AND $target_item['wall'] AND
 308                         if (!$target_item['private'] AND
 309                                 (strlen($target_item['allow_cid'].$target_item['allow_gid'].
 310                                         $target_item['deny_cid'].$target_item['deny_gid']) == 0))
 311                                 $push_notify = true;
 312
 313                         if (($thr_parent AND ($thr_parent[0]['network'] == NETWORK_OSTATUS)) OR ($parent['network'] == NETWORK_OSTATUS)) {
 314
 315                                 $push_notify = true;
 316
 317                                 if ($parent["network"] == NETWORK_OSTATUS) {
 318                                         // Distribute the message to the DFRN contacts as if this wasn't a followup since OStatus can't relay comments
 319                                         // Currently it is work at progress
 320                                         $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `network` = '%s' AND NOT `blocked` AND NOT `pending` AND NOT `archive`",
 321                                                 intval($uid),
 322                                                 dbesc(NETWORK_DFRN)
 323                                         );
 324                                         if (dbm::is_result($r))
 325                                                 foreach($r as $rr)
 326                                                         $recipients_followup[] = $rr['id'];
 327                                 }
 328                         }
 329                         logger("Notify ".$target_item["guid"]." via PuSH: ".($push_notify?"Yes":"No"), LOGGER_DEBUG);
 330                 } else {
 331                         $followup = false;
 332
 333                         logger('Distributing directly '.$target_item["guid"], LOGGER_DEBUG);
 334
 335                         // don't send deletions onward for other people's stuff
 336
 337                         if($target_item['deleted'] && (! intval($target_item['wall']))) {
 338                                 logger('notifier: ignoring delete notification for non-wall item');
 339                                 return;
 340                         }
 341
 342                         if((strlen($parent['allow_cid']))
 343                                 || (strlen($parent['allow_gid']))
 344                                 || (strlen($parent['deny_cid']))
 345                                 || (strlen($parent['deny_gid']))) {
 346                                 $public_message = false; // private recipients, not public
 347                         }
 348
 349                         $allow_people = expand_acl($parent['allow_cid']);
 350                         $allow_groups = expand_groups(expand_acl($parent['allow_gid']),true);
 351                         $deny_people  = expand_acl($parent['deny_cid']);
 352                         $deny_groups  = expand_groups(expand_acl($parent['deny_gid']));
 353
 354                         // if our parent is a public forum (forum_mode == 1), uplink to the origional author causing
 355                         // a delivery fork. private groups (forum_mode == 2) do not uplink
 356
 357                         if((intval($parent['forum_mode']) == 1) && (! $top_level) && ($cmd !== 'uplink')) {
 358                                 proc_run(PRIORITY_HIGH,'include/notifier.php','uplink',$item_id);
 359                         }
 360
 361                         $conversants = array();
 362
 363                         foreach($items as $item) {
 364                                 $recipients[] = $item['contact-id'];
 365                                 $conversants[] = $item['contact-id'];
 366                                 // pull out additional tagged people to notify (if public message)
 367                                 if($public_message && strlen($item['inform'])) {
 368                                         $people = explode(',',$item['inform']);
 369                                         foreach($people as $person) {
 370                                                 if(substr($person,0,4) === 'cid:') {
 371                                                         $recipients[] = intval(substr($person,4));
 372                                                         $conversants[] = intval(substr($person,4));
 373                                                 }
 374                                                 else {
 375                                                         $url_recipients[] = substr($person,4);
 376                                                 }
 377                                         }
 378                                 }
 379                         }
 380
 381                         if (count($url_recipients))
 382                                 logger('notifier: '.$target_item["guid"].' url_recipients ' . print_r($url_recipients,true));
 383
 384                         $conversants = array_unique($conversants);
 385
 386
 387                         $recipients = array_unique(array_merge($recipients,$allow_people,$allow_groups));
 388                         $deny = array_unique(array_merge($deny_people,$deny_groups));
 389                         $recipients = array_diff($recipients,$deny);
 390
 391                         $conversant_str = dbesc(implode(', ',$conversants));
 392                 }
 393
 394                 // If the thread parent is OStatus then do some magic to distribute the messages.
 395                 // We have not only to look at the parent, since it could be a Friendica thread.
 396                 if (($thr_parent AND ($thr_parent[0]['network'] == NETWORK_OSTATUS)) OR ($parent['network'] == NETWORK_OSTATUS)) {
 397
 398                         logger('Some parent is OStatus for '.$target_item["guid"]." - Author: ".$thr_parent[0]['author-link']." - Owner: ".$thr_parent[0]['owner-link'], LOGGER_DEBUG);
 399
 400                         // Send a salmon to the parent author
 401                         $r = q("SELECT `notify` FROM `contact` WHERE `nurl`='%s' AND `uid` IN (0, %d) AND `notify` != ''",
 402                                 dbesc(normalise_link($thr_parent[0]['author-link'])),
 403                                 intval($uid));
 404                         if ($r)
 405                                 $probed_contact = $r[0];
 406                         else
 407                                 $probed_contact = probe_url($thr_parent[0]['author-link']);
 408
 409                         if ($probed_contact["notify"] != "") {
 410                                 logger('Notify parent author '.$probed_contact["url"].': '.$probed_contact["notify"]);
 411                                 $url_recipients[$probed_contact["notify"]] = $probed_contact["notify"];
 412                         }
 413
 414                         // Send a salmon to the parent owner
 415                         $r = q("SELECT `notify` FROM `contact` WHERE `nurl`='%s' AND `uid` IN (0, %d) AND `notify` != ''",
 416                                 dbesc(normalise_link($thr_parent[0]['owner-link'])),
 417                                 intval($uid));
 418                         if ($r)
 419                                 $probed_contact = $r[0];
 420                         else
 421                                 $probed_contact = probe_url($thr_parent[0]['owner-link']);
 422                         if ($probed_contact["notify"] != "") {
 423                                 logger('Notify parent owner '.$probed_contact["url"].': '.$probed_contact["notify"]);
 424                                 $url_recipients[$probed_contact["notify"]] = $probed_contact["notify"];
 425                         }
 426
 427                         // Send a salmon notification to every person we mentioned in the post
 428                         $arr = explode(',',$target_item['tag']);
 429                         foreach($arr as $x) {
 430                                 //logger('Checking tag '.$x, LOGGER_DEBUG);
 431                                 $matches = null;
 432                                 if(preg_match('/@\[url=([^\]]*)\]/',$x,$matches)) {
 433                                                 $probed_contact = probe_url($matches[1]);
 434                                         if ($probed_contact["notify"] != "") {
 435                                                 logger('Notify mentioned user '.$probed_contact["url"].': '.$probed_contact["notify"]);
 436                                                 $url_recipients[$probed_contact["notify"]] = $probed_contact["notify"];
 437                                         }
 438                                 }
 439                         }
 440
 441                         // It only makes sense to distribute answers to OStatus messages to Friendica and OStatus - but not Diaspora
 442                         $sql_extra = " AND `network` IN ('".NETWORK_OSTATUS."', '".NETWORK_DFRN."')";
 443                 } else
 444                         $sql_extra = " AND `network` IN ('".NETWORK_OSTATUS."', '".NETWORK_DFRN."', '".NETWORK_DIASPORA."', '".NETWORK_MAIL."', '".NETWORK_MAIL2."')";
 445
 446                 $r = q("SELECT * FROM `contact` WHERE `id` IN ($conversant_str) AND NOT `blocked` AND NOT `pending` AND NOT `archive`".$sql_extra);
 447
 448                 if (dbm::is_result($r))
 449                         $contacts = $r;
 450
 451         } else
 452                 $public_message = false;
 453
 454         // If this is a public message and pubmail is set on the parent, include all your email contacts
 455
 456         $mail_disabled = ((function_exists('imap_open') && (! get_config('system','imap_disabled'))) ? 0 : 1);
 457
 458         if(! $mail_disabled) {
 459                 if((! strlen($target_item['allow_cid'])) && (! strlen($target_item['allow_gid']))
 460                         && (! strlen($target_item['deny_cid'])) && (! strlen($target_item['deny_gid']))
 461                         && (intval($target_item['pubmail']))) {
 462                         $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `network` = '%s'",
 463                                 intval($uid),
 464                                 dbesc(NETWORK_MAIL)
 465                         );
 466                         if (dbm::is_result($r)) {
 467                                 foreach($r as $rr)
 468                                         $recipients[] = $rr['id'];
 469                         }
 470                 }
 471         }
 472
 473         if($followup)
 474                 $recip_str = implode(', ', $recipients_followup);
 475         else
 476                 $recip_str = implode(', ', $recipients);
 477
 478         if ($relocate)
 479                 $r = $recipients_relocate;
 480         else
 481                 $r = q("SELECT * FROM `contact` WHERE `id` IN (%s) AND NOT `blocked` AND NOT `pending` AND NOT `archive`",
 482                         dbesc($recip_str)
 483                 );
 484
 485
 486         $interval = ((get_config('system','delivery_interval') === false) ? 2 : intval(get_config('system','delivery_interval')));
 487
 488         // If we are using the worker we don't need a delivery interval
 489         if (get_config("system", "worker"))
 490                 $interval = false;
 491
 492         // delivery loop
 493
 494         if (dbm::is_result($r)) {
 495
 496                 foreach($r as $contact) {
 497                         if(!$contact['self']) {
 498                                 if(($contact['network'] === NETWORK_DIASPORA) && ($public_message))
 499                                         continue;
 500                                 q("INSERT INTO `deliverq` (`cmd`,`item`,`contact`) VALUES ('%s', %d, %d)",
 501                                         dbesc($cmd),
 502                                         intval($item_id),
 503                                         intval($contact['id'])
 504                                 );
 505                         }
 506                 }
 507
 508
 509                 // This controls the number of deliveries to execute with each separate delivery process.
 510                 // By default we'll perform one delivery per process. Assuming a hostile shared hosting
 511                 // provider, this provides the greatest chance of deliveries if processes start getting
 512                 // killed. We can also space them out with the delivery_interval to also help avoid them
 513                 // getting whacked.
 514
 515                 // If $deliveries_per_process > 1, we will chain this number of multiple deliveries
 516                 // together into a single process. This will reduce the overall number of processes
 517                 // spawned for each delivery, but they will run longer.
 518
 519                 // When using the workerqueue, we don't need this functionality.
 520
 521                 $deliveries_per_process = intval(get_config('system','delivery_batch_count'));
 522                 if (($deliveries_per_process <= 0) OR get_config("system", "worker"))
 523                         $deliveries_per_process = 1;
 524
 525                 $this_batch = array();
 526
 527                 for($x = 0; $x < count($r); $x ++) {
 528                         $contact = $r[$x];
 529
 530                         if($contact['self'])
 531                                 continue;
 532
 533                         logger("Deliver ".$target_item["guid"]." to ".$contact['url']." via network ".$contact['network'], LOGGER_DEBUG);
 534
 535                         // potentially more than one recipient. Start a new process and space them out a bit.
 536                         // we will deliver single recipient types of message and email recipients here.
 537
 538                         $this_batch[] = $contact['id'];
 539
 540                         if(count($this_batch) >= $deliveries_per_process) {
 541                                 proc_run(PRIORITY_HIGH,'include/delivery.php',$cmd,$item_id,$this_batch);
 542                                 $this_batch = array();
 543                                 if($interval)
 544                                         @time_sleep_until(microtime(true) + (float) $interval);
 545                         }
 546                         continue;
 547                 }
 548
 549                 // be sure to pick up any stragglers
 550                 if(count($this_batch))
 551                         proc_run(PRIORITY_HIGH,'include/delivery.php',$cmd,$item_id,$this_batch);
 552         }
 553
 554         // send salmon slaps to mentioned remote tags (@foo@example.com) in OStatus posts
 555         // They are especially used for notifications to OStatus users that don't follow us.
 556
 557         if($slap && count($url_recipients) && ($public_message || $push_notify) && $normal_mode) {
 558                 if(!get_config('system','dfrn_only')) {
 559                         foreach($url_recipients as $url) {
 560                                 if($url) {
 561                                         logger('notifier: urldelivery: ' . $url);
 562                                         $deliver_status = slapper($owner,$url,$slap);
 563                                         /// @TODO Redeliver/queue these items on failure, though there is no contact record
 564                                 }
 565                         }
 566                 }
 567         }
 568
 569
 570         if($public_message) {
 571
 572                 if (!$followup)
 573                         $r0 = diaspora::relay_list();
 574                 else
 575                         $r0 = array();
 576
 577                 $r1 = q("SELECT DISTINCT(`batch`), `id`, `name`,`network` FROM `contact` WHERE `network` = '%s'
 578                         AND `uid` = %d AND `rel` != %d AND NOT `blocked` AND NOT `pending` AND NOT `archive` GROUP BY `batch` ORDER BY rand()",
 579                         dbesc(NETWORK_DIASPORA),
 580                         intval($owner['uid']),
 581                         intval(CONTACT_IS_SHARING)
 582                 );
 583
 584                 $r2 = q("SELECT `id`, `name`,`network` FROM `contact`
 585                         WHERE `network` in ( '%s', '%s')  AND `uid` = %d AND NOT `blocked` AND NOT `pending` AND NOT `archive`
 586                         AND `rel` != %d order by rand() ",
 587                         dbesc(NETWORK_DFRN),
 588                         dbesc(NETWORK_MAIL2),
 589                         intval($owner['uid']),
 590                         intval(CONTACT_IS_SHARING)
 591                 );
 592
 593                 $r = array_merge($r2,$r1,$r0);
 594
 595                 if (dbm::is_result($r)) {
 596                         logger('pubdeliver '.$target_item["guid"].': '.print_r($r,true), LOGGER_DEBUG);
 597
 598                         // throw everything into the queue in case we get killed
 599
 600                         foreach($r as $rr) {
 601                                 if((! $mail) && (! $fsuggest) && (! $followup)) {
 602                                         q("INSERT INTO `deliverq` (`cmd`,`item`,`contact`) VALUES ('%s', %d, %d)
 603                                                 ON DUPLICATE KEY UPDATE `cmd` = '%s', `item` = %d, `contact` = %d",
 604                                                 dbesc($cmd), intval($item_id), intval($rr['id']),
 605                                                 dbesc($cmd), intval($item_id), intval($rr['id'])
 606                                         );
 607                                 }
 608                         }
 609
 610                         foreach($r as $rr) {
 611
 612                                 // except for Diaspora batch jobs
 613                                 // Don't deliver to folks who have already been delivered to
 614
 615                                 if(($rr['network'] !== NETWORK_DIASPORA) && (in_array($rr['id'],$conversants))) {
 616                                         logger('notifier: already delivered id=' . $rr['id']);
 617                                         continue;
 618                                 }
 619
 620                                 if((! $mail) && (! $fsuggest) && (! $followup)) {
 621                                         logger('notifier: delivery agent: '.$rr['name'].' '.$rr['id'].' '.$rr['network'].' '.$target_item["guid"]);
 622                                         proc_run(PRIORITY_HIGH,'include/delivery.php',$cmd,$item_id,$rr['id']);
 623                                         if($interval)
 624                                                 @time_sleep_until(microtime(true) + (float) $interval);
 625                                 }
 626                         }
 627                 }
 628
 629                 $push_notify = true;
 630
 631         }
 632
 633         // Notify PuSH subscribers (Used for OStatus distribution of regular posts)
 634         if($push_notify AND strlen($hub)) {
 635                 $hubs = explode(',', $hub);
 636                 if(count($hubs)) {
 637                         foreach($hubs as $h) {
 638                                 $h = trim($h);
 639                                 if(! strlen($h))
 640                                         continue;
 641
 642                                 if ($h === '[internal]') {
 643                                         // Set push flag for PuSH subscribers to this topic,
 644                                         // they will be notified in queue.php
 645                                         q("UPDATE `push_subscriber` SET `push` = 1 ".
 646                                           "WHERE `nickname` = '%s' AND `push` = 0", dbesc($owner['nickname']));
 647
 648                                         logger('Activating internal PuSH for item '.$item_id, LOGGER_DEBUG);
 649
 650                                 } else {
 651
 652                                         $params = 'hub.mode=publish&hub.url=' . urlencode( $a->get_baseurl() . '/dfrn_poll/' . $owner['nickname'] );
 653                                         post_url($h,$params);
 654                                         logger('publish for item '.$item_id.' ' . $h . ' ' . $params . ' returned ' . $a->get_curl_code());
 655                                 }
 656                                 if(count($hubs) > 1)
 657                                         sleep(7);                               // try and avoid multiple hubs responding at precisely the same time
 658                         }
 659                 }
 660
 661                 // Handling the pubsubhubbub requests
 662                 proc_run(PRIORITY_HIGH,'include/pubsubpublish.php');
 663         }
 664
 665         logger('notifier: calling hooks', LOGGER_DEBUG);
 666
 667         if($normal_mode)
 668                 call_hooks('notifier_normal',$target_item);
 669
 670         call_hooks('notifier_end',$target_item);
 671
 672         return;
 673 }
 674
 675
 676 if (array_search(__file__,get_included_files())===0){
 677         notifier_run($_SERVER["argv"],$_SERVER["argc"]);
 678         killme();
 679 }