]> git.mxchange.org Git - friendica.git/blob - include/delivery.php
DB Version was forgotten ...
[friendica.git] / include / delivery.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/dfrn.php");
9
10 function delivery_run(&$argv, &$argc){
11         global $a, $db;
12
13         if(is_null($a)){
14                 $a = new App;
15         }
16
17         if(is_null($db)) {
18                 @include(".htconfig.php");
19                 require_once("include/dba.php");
20                 $db = new dba($db_host, $db_user, $db_pass, $db_data);
21                 unset($db_host, $db_user, $db_pass, $db_data);
22         }
23
24         require_once("include/session.php");
25         require_once("include/datetime.php");
26         require_once('include/items.php');
27         require_once('include/bbcode.php');
28         require_once('include/email.php');
29
30         load_config('config');
31         load_config('system');
32
33         load_hooks();
34
35         if($argc < 3)
36                 return;
37
38         $a->set_baseurl(get_config('system','url'));
39
40         logger('delivery: invoked: ' . print_r($argv,true), LOGGER_DEBUG);
41
42         $cmd        = $argv[1];
43         $item_id    = intval($argv[2]);
44
45         for($x = 3; $x < $argc; $x ++) {
46
47                 $contact_id = intval($argv[$x]);
48
49                 // Some other process may have delivered this item already.
50
51                 $r = q("SELECT * FROM `deliverq` WHERE `cmd` = '%s' AND `item` = %d AND `contact` = %d LIMIT 1",
52                         dbesc($cmd),
53                         dbesc($item_id),
54                         dbesc($contact_id)
55                 );
56                 if(! count($r)) {
57                         continue;
58                 }
59
60                 $maxsysload = intval(get_config('system','maxloadavg'));
61                 if($maxsysload < 1)
62                         $maxsysload = 50;
63
64                 $load = current_load();
65                 if($load) {
66                         if(intval($load) > $maxsysload) {
67                                 logger('system: load ' . $load . ' too high. Delivery deferred to next queue run.');
68                                 return;
69                         }
70                 }
71
72                 // It's ours to deliver. Remove it from the queue.
73
74                 q("DELETE FROM `deliverq` WHERE `cmd` = '%s' AND `item` = %d AND `contact` = %d",
75                         dbesc($cmd),
76                         dbesc($item_id),
77                         dbesc($contact_id)
78                 );
79
80                 if((! $item_id) || (! $contact_id))
81                         continue;
82
83                 $expire = false;
84                 $mail = false;
85                 $fsuggest = false;
86                 $relocate = false;
87                 $top_level = false;
88                 $recipients = array();
89                 $url_recipients = array();
90                 $followup = false;
91
92                 $normal_mode = true;
93
94                 $recipients[] = $contact_id;
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                 elseif($cmd === 'expire') {
110                         $normal_mode = false;
111                         $expire = true;
112                         $items = q("SELECT * FROM `item` WHERE `uid` = %d AND `wall` = 1
113                                 AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP() - INTERVAL 30 MINUTE",
114                                 intval($item_id)
115                         );
116                         $uid = $item_id;
117                         $item_id = 0;
118                         if(! count($items))
119                                 continue;
120                 }
121                 elseif($cmd === 'suggest') {
122                         $normal_mode = false;
123                         $fsuggest = true;
124
125                         $suggest = q("SELECT * FROM `fsuggest` WHERE `id` = %d LIMIT 1",
126                                 intval($item_id)
127                         );
128                         if(! count($suggest))
129                                 return;
130                         $uid = $suggest[0]['uid'];
131                         $recipients[] = $suggest[0]['cid'];
132                         $item = $suggest[0];
133                 } elseif($cmd === 'relocate') {
134                         $normal_mode = false;
135                         $relocate = true;
136                         $uid = $item_id;
137                 } else {
138                         // find ancestors
139                         $r = q("SELECT * FROM `item` WHERE `id` = %d and visible = 1 and moderated = 0 LIMIT 1",
140                                 intval($item_id)
141                         );
142
143                         if((! count($r)) || (! intval($r[0]['parent']))) {
144                                 continue;
145                         }
146
147                         $target_item = $r[0];
148                         $parent_id = intval($r[0]['parent']);
149                         $uid = $r[0]['uid'];
150                         $updated = $r[0]['edited'];
151
152                         $items = q("SELECT `item`.*, `sign`.`signed_text`,`sign`.`signature`,`sign`.`signer`
153                                 FROM `item` LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id` WHERE `parent` = %d and visible = 1 and moderated = 0 ORDER BY `id` ASC",
154                                 intval($parent_id)
155                         );
156
157                         if(! count($items)) {
158                                 continue;
159                         }
160
161                         $icontacts = null;
162                         $contacts_arr = array();
163                         foreach($items as $item)
164                                 if(! in_array($item['contact-id'],$contacts_arr))
165                                         $contacts_arr[] = intval($item['contact-id']);
166                         if(count($contacts_arr)) {
167                                 $str_contacts = implode(',',$contacts_arr);
168                                 $icontacts = q("SELECT * FROM `contact`
169                                         WHERE `id` IN ( $str_contacts ) "
170                                 );
171                         }
172                         if( ! ($icontacts && count($icontacts)))
173                                 continue;
174
175                         // avoid race condition with deleting entries
176
177                         if($items[0]['deleted']) {
178                                 foreach($items as $item)
179                                         $item['deleted'] = 1;
180                         }
181
182                         if((count($items) == 1) && ($items[0]['uri'] === $items[0]['parent-uri'])) {
183                                 logger('delivery: top level post');
184                                 $top_level = true;
185                         }
186                 }
187
188                 $r = q("SELECT `contact`.*, `user`.`pubkey` AS `upubkey`, `user`.`prvkey` AS `uprvkey`,
189                         `user`.`timezone`, `user`.`nickname`, `user`.`sprvkey`, `user`.`spubkey`,
190                         `user`.`page-flags`, `user`.`prvnets`
191                         FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
192                         WHERE `contact`.`uid` = %d AND `contact`.`self` = 1 LIMIT 1",
193                         intval($uid)
194                 );
195
196                 if(! count($r))
197                         continue;
198
199                 $owner = $r[0];
200
201                 $walltowall = ((($top_level) && ($owner['id'] != $items[0]['contact-id'])) ? true : false);
202
203                 $public_message = true;
204
205                 if(! ($mail || $fsuggest || $relocate)) {
206                         require_once('include/group.php');
207
208                         $parent = $items[0];
209
210                         // This is IMPORTANT!!!!
211
212                         // We will only send a "notify owner to relay" or followup message if the referenced post
213                         // originated on our system by virtue of having our hostname somewhere
214                         // in the URI, AND it was a comment (not top_level) AND the parent originated elsewhere.
215                         // if $parent['wall'] == 1 we will already have the parent message in our array
216                         // and we will relay the whole lot.
217
218                         // expire sends an entire group of expire messages and cannot be forwarded.
219                         // However the conversation owner will be a part of the conversation and will
220                         // be notified during this run.
221                         // Other DFRN conversation members will be alerted during polled updates.
222
223                         // Diaspora members currently are not notified of expirations, and other networks have
224                         // either limited or no ability to process deletions. We should at least fix Diaspora
225                         // by stringing togther an array of retractions and sending them onward.
226
227
228                         $localhost = $a->get_hostname();
229                         if(strpos($localhost,':'))
230                                 $localhost = substr($localhost,0,strpos($localhost,':'));
231
232                         /**
233                          *
234                          * Be VERY CAREFUL if you make any changes to the following line. Seemingly innocuous changes
235                          * have been known to cause runaway conditions which affected several servers, along with
236                          * permissions issues.
237                          *
238                          */
239
240                         $relay_to_owner = false;
241
242                         if((! $top_level) && ($parent['wall'] == 0) && (! $expire) && (stristr($target_item['uri'],$localhost))) {
243                                 $relay_to_owner = true;
244                         }
245
246                         if($relay_to_owner) {
247                                 logger('followup '.$target_item["guid"], LOGGER_DEBUG);
248                                 // local followup to remote post
249                                 $followup = true;
250                         }
251
252                         if((strlen($parent['allow_cid']))
253                                 || (strlen($parent['allow_gid']))
254                                 || (strlen($parent['deny_cid']))
255                                 || (strlen($parent['deny_gid']))) {
256                                 $public_message = false; // private recipients, not public
257                         }
258
259                 }
260
261                 $r = q("SELECT * FROM `contact` WHERE `id` = %d AND `blocked` = 0 AND `pending` = 0",
262                         intval($contact_id)
263                 );
264
265                 if(count($r))
266                         $contact = $r[0];
267
268                 if($contact['self'])
269                         continue;
270
271                 $deliver_status = 0;
272
273                 logger("main delivery by delivery: followup=$followup mail=$mail fsuggest=$fsuggest relocate=$relocate - network ".$contact['network']);
274
275                 switch($contact['network']) {
276
277                         case NETWORK_DFRN:
278                                 logger('notifier: '.$target_item["guid"].' dfrndelivery: ' . $contact['name']);
279
280                                 if ($mail) {
281                                         $item['body'] = fix_private_photos($item['body'],$owner['uid'],null,$message[0]['contact-id']);
282                                         $atom = dfrn::mail($item, $owner);
283                                 } elseif ($fsuggest) {
284                                         $atom = dfrn::fsuggest($item, $owner);
285                                         q("DELETE FROM `fsuggest` WHERE `id` = %d LIMIT 1", intval($item['id']));
286                                 } elseif ($relocate)
287                                         $atom = dfrn::relocate($owner, $uid);
288                                 elseif($followup) {
289                                         $msgitems = array();
290                                         foreach($items as $item) {  // there is only one item
291                                                 if(!$item['parent'])
292                                                         continue;
293                                                 if($item['id'] == $item_id) {
294                                                         logger('followup: item: ' . print_r($item,true), LOGGER_DATA);
295                                                         $msgitems[] = $item;
296                                                 }
297                                         }
298                                         $atom = dfrn::entries($msgitems,$owner);
299                                 } else {
300                                         $msgitems = array();
301                                         foreach($items as $item) {
302                                                 if(!$item['parent'])
303                                                         continue;
304
305                                                 // private emails may be in included in public conversations. Filter them.
306                                                 if(($public_message) && $item['private'])
307                                                         continue;
308
309                                                 $item_contact = get_item_contact($item,$icontacts);
310                                                 if(!$item_contact)
311                                                         continue;
312
313                                                 if($normal_mode) {
314                                                         if($item_id == $item['id'] || $item['id'] == $item['parent']) {
315                                                                 $item["entry:comment-allow"] = true;
316                                                                 $item["entry:cid"] = (($top_level) ? $contact['id'] : 0);
317                                                                 $msgitems[] = $item;
318                                                         }
319                                                 } else {
320                                                         $item["entry:comment-allow"] = true;
321                                                         $msgitems[] = $item;
322                                                 }
323                                         }
324                                         $atom = dfrn::entries($msgitems,$owner);
325                                 }
326
327                                 logger('notifier entry: '.$contact["url"].' '.$target_item["guid"].' entry: '.$atom, LOGGER_DEBUG);
328
329                                 logger('notifier: ' . $atom, LOGGER_DATA);
330                                 $basepath =  implode('/', array_slice(explode('/',$contact['url']),0,3));
331
332                                 // perform local delivery if we are on the same site
333
334                                 if(link_compare($basepath,$a->get_baseurl())) {
335
336                                         $nickname = basename($contact['url']);
337                                         if($contact['issued-id'])
338                                                 $sql_extra = sprintf(" AND `dfrn-id` = '%s' ", dbesc($contact['issued-id']));
339                                         else
340                                                 $sql_extra = sprintf(" AND `issued-id` = '%s' ", dbesc($contact['dfrn-id']));
341
342                                         $x = q("SELECT  `contact`.*, `contact`.`uid` AS `importer_uid`,
343                                                 `contact`.`pubkey` AS `cpubkey`,
344                                                 `contact`.`prvkey` AS `cprvkey`,
345                                                 `contact`.`thumb` AS `thumb`,
346                                                 `contact`.`url` as `url`,
347                                                 `contact`.`name` as `senderName`,
348                                                 `user`.*
349                                                 FROM `contact`
350                                                 INNER JOIN `user` ON `contact`.`uid` = `user`.`uid`
351                                                 WHERE `contact`.`blocked` = 0 AND `contact`.`pending` = 0
352                                                 AND `contact`.`network` = '%s' AND `user`.`nickname` = '%s'
353                                                 $sql_extra
354                                                 AND `user`.`account_expired` = 0 AND `user`.`account_removed` = 0 LIMIT 1",
355                                                 dbesc(NETWORK_DFRN),
356                                                 dbesc($nickname)
357                                         );
358
359                                         if($x && count($x)) {
360                                                 $write_flag = ((($x[0]['rel']) && ($x[0]['rel'] != CONTACT_IS_SHARING)) ? true : false);
361                                                 if((($owner['page-flags'] == PAGE_COMMUNITY) || ($write_flag)) && (! $x[0]['writable'])) {
362                                                         q("update contact set writable = 1 where id = %d",
363                                                                 intval($x[0]['id'])
364                                                         );
365                                                         $x[0]['writable'] = 1;
366                                                 }
367
368                                                 $ssl_policy = get_config('system','ssl_policy');
369                                                 fix_contact_ssl_policy($x[0],$ssl_policy);
370
371                                                 // If we are setup as a soapbox we aren't accepting top level posts from this person
372
373                                                 if (($x[0]['page-flags'] == PAGE_SOAPBOX) AND $top_level)
374                                                         break;
375
376                                                 logger('mod-delivery: local delivery');
377                                                 local_delivery($x[0],$atom);
378                                                 break;
379                                         }
380                                 }
381
382                                 if(! was_recently_delayed($contact['id']))
383                                         $deliver_status = dfrn::deliver($owner,$contact,$atom);
384                                 else
385                                         $deliver_status = (-1);
386
387                                 logger('notifier: dfrn_delivery to '.$contact["url"].' with guid '.$target_item["guid"].' returns '.$deliver_status);
388
389                                 if($deliver_status == (-1)) {
390                                         logger('notifier: delivery failed: queuing message');
391                                         add_to_queue($contact['id'],NETWORK_DFRN,$atom);
392                                 }
393                                 break;
394
395                         case NETWORK_OSTATUS:
396                                 // Do not send to otatus if we are not configured to send to public networks
397                                 if($owner['prvnets'])
398                                         break;
399                                 if(get_config('system','ostatus_disabled') || get_config('system','dfrn_only'))
400                                         break;
401
402                                 // There is currently no code here to distribute anything to OStatus.
403                                 // This is done in "notifier.php" (See "url_recipients" and "push_notify")
404                                 break;
405
406                         case NETWORK_MAIL:
407                         case NETWORK_MAIL2:
408
409                                 if(get_config('system','dfrn_only'))
410                                         break;
411                                 // WARNING: does not currently convert to RFC2047 header encodings, etc.
412
413                                 $addr = $contact['addr'];
414                                 if(! strlen($addr))
415                                         break;
416
417                                 if($cmd === 'wall-new' || $cmd === 'comment-new') {
418
419                                         $it = null;
420                                         if($cmd === 'wall-new')
421                                                 $it = $items[0];
422                                         else {
423                                                 $r = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
424                                                         intval($argv[2]),
425                                                         intval($uid)
426                                                 );
427                                                 if(count($r))
428                                                         $it = $r[0];
429                                         }
430                                         if(! $it)
431                                                 break;
432
433
434                                         $local_user = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
435                                                 intval($uid)
436                                         );
437                                         if(! count($local_user))
438                                                 break;
439
440                                         $reply_to = '';
441                                         $r1 = q("SELECT * FROM `mailacct` WHERE `uid` = %d LIMIT 1",
442                                                 intval($uid)
443                                         );
444                                         if($r1 && $r1[0]['reply_to'])
445                                                 $reply_to = $r1[0]['reply_to'];
446
447                                         $subject  = (($it['title']) ? email_header_encode($it['title'],'UTF-8') : t("\x28no subject\x29")) ;
448
449                                         // only expose our real email address to true friends
450
451                                         if(($contact['rel'] == CONTACT_IS_FRIEND) && (! $contact['blocked'])) {
452                                                 if($reply_to) {
453                                                         $headers  = 'From: '.email_header_encode($local_user[0]['username'],'UTF-8').' <'.$reply_to.'>'."\n";
454                                                         $headers .= 'Sender: '.$local_user[0]['email']."\n";
455                                                 } else
456                                                         $headers  = 'From: '.email_header_encode($local_user[0]['username'],'UTF-8').' <'.$local_user[0]['email'].'>'."\n";
457                                         } else
458                                                 $headers  = 'From: ' . email_header_encode($local_user[0]['username'],'UTF-8') . ' <' . t('noreply') . '@' . $a->get_hostname() . '>' . "\n";
459
460                                         //if($reply_to)
461                                         //      $headers .= 'Reply-to: ' . $reply_to . "\n";
462
463                                         $headers .= 'Message-Id: <' . iri2msgid($it['uri']). '>' . "\n";
464
465                                         //logger("Mail: uri: ".$it['uri']." parent-uri ".$it['parent-uri'], LOGGER_DEBUG);
466                                         //logger("Mail: Data: ".print_r($it, true), LOGGER_DEBUG);
467                                         //logger("Mail: Data: ".print_r($it, true), LOGGER_DATA);
468
469                                         if($it['uri'] !== $it['parent-uri']) {
470                                                 $headers .= "References: <".iri2msgid($it["parent-uri"]).">";
471
472                                                 // If Threading is enabled, write down the correct parent
473                                                 if (($it["thr-parent"] != "") and ($it["thr-parent"] != $it["parent-uri"]))
474                                                         $headers .= " <".iri2msgid($it["thr-parent"]).">";
475                                                 $headers .= "\n";
476
477                                                 if(!$it['title']) {
478                                                         $r = q("SELECT `title` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
479                                                                 dbesc($it['parent-uri']),
480                                                                 intval($uid));
481
482                                                         if(count($r) AND ($r[0]['title'] != ''))
483                                                                 $subject = $r[0]['title'];
484                                                         else {
485                                                                 $r = q("SELECT `title` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d LIMIT 1",
486                                                                         dbesc($it['parent-uri']),
487                                                                         intval($uid));
488
489                                                                 if(count($r) AND ($r[0]['title'] != ''))
490                                                                         $subject = $r[0]['title'];
491                                                         }
492                                                 }
493                                                 if(strncasecmp($subject,'RE:',3))
494                                                         $subject = 'Re: '.$subject;
495                                         }
496                                         email_send($addr, $subject, $headers, $it);
497                                 }
498                                 break;
499
500                         case NETWORK_DIASPORA:
501                                 if($public_message)
502                                         $loc = 'public batch ' . $contact['batch'];
503                                 else
504                                         $loc = $contact['name'];
505
506                                 logger('delivery: diaspora batch deliver: ' . $loc);
507
508                                 if(get_config('system','dfrn_only') || (!get_config('system','diaspora_enabled')))
509                                         break;
510
511                                 if($mail) {
512                                         diaspora_send_mail($item,$owner,$contact);
513                                         break;
514                                 }
515
516                                 if(!$normal_mode)
517                                         break;
518
519                                 if((! $contact['pubkey']) && (! $public_message))
520                                         break;
521
522                                 $unsupported_activities = array(ACTIVITY_DISLIKE, ACTIVITY_ATTEND, ACTIVITY_ATTENDNO, ACTIVITY_ATTENDMAYBE);
523
524                                 //don't transmit activities which are not supported by diaspora
525                                 foreach($unsupported_activities as $act) {
526                                         if(activity_match($target_item['verb'],$act)) {
527                                                 break 2;
528                                         }
529                                 }
530
531                                 if(($target_item['deleted']) && (($target_item['uri'] === $target_item['parent-uri']) || $followup)) {
532                                         // top-level retraction
533                                         logger('delivery: diaspora retract: ' . $loc);
534
535                                         diaspora_send_retraction($target_item,$owner,$contact,$public_message);
536                                         break;
537                                 } elseif($followup) {
538                                         // send comments and likes to owner to relay
539                                         diaspora_send_followup($target_item,$owner,$contact,$public_message);
540                                         break;
541                                 } elseif($target_item['uri'] !== $target_item['parent-uri']) {
542                                         // we are the relay - send comments, likes and relayable_retractions to our conversants
543                                         logger('delivery: diaspora relay: ' . $loc);
544
545                                         diaspora_send_relay($target_item,$owner,$contact,$public_message);
546                                         break;
547                                 } elseif(($top_level) && (! $walltowall)) {
548                                         // currently no workable solution for sending walltowall
549                                         logger('delivery: diaspora status: ' . $loc);
550                                         diaspora_send_status($target_item,$owner,$contact,$public_message);
551                                         break;
552                                 }
553
554                                 logger('delivery: diaspora unknown mode: ' . $contact['name']);
555
556                                 break;
557
558                         default:
559                                 break;
560                 }
561         }
562
563         return;
564 }
565
566 if (array_search(__file__,get_included_files())===0){
567   delivery_run($_SERVER["argv"],$_SERVER["argc"]);
568   killme();
569 }