3 require_once('include/bbcode.php');
4 require_once('include/oembed.php');
5 require_once('include/salmon.php');
6 require_once('include/crypto.php');
7 require_once('include/Photo.php');
8 require_once('include/tags.php');
9 require_once('include/files.php');
10 require_once('include/text.php');
11 require_once('include/email.php');
12 require_once('include/ostatus_conversation.php');
13 require_once('include/threads.php');
14 require_once('include/socgraph.php');
16 function get_feed_for(&$a, $dfrn_id, $owner_nick, $last_update, $direction = 0) {
19 $sitefeed = ((strlen($owner_nick)) ? false : true); // not yet implemented, need to rewrite huge chunks of following logic
20 $public_feed = (($dfrn_id) ? false : true);
21 $starred = false; // not yet implemented, possible security issues
24 if($public_feed && $a->argc > 2) {
25 for($x = 2; $x < $a->argc; $x++) {
26 if($a->argv[$x] == 'converse')
28 if($a->argv[$x] == 'starred')
30 if($a->argv[$x] === 'category' && $a->argc > ($x + 1) && strlen($a->argv[$x+1]))
31 $category = $a->argv[$x+1];
37 // default permissions - anonymous user
39 $sql_extra = " AND `allow_cid` = '' AND `allow_gid` = '' AND `deny_cid` = '' AND `deny_gid` = '' ";
41 $r = q("SELECT `contact`.*, `user`.`uid` AS `user_uid`, `user`.`nickname`, `user`.`timezone`, `user`.`page-flags`
42 FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
43 WHERE `contact`.`self` = 1 AND `user`.`nickname` = '%s' LIMIT 1",
51 $owner_id = $owner['user_uid'];
52 $owner_nick = $owner['nickname'];
54 $birthday = feed_birthday($owner_id,$owner['timezone']);
63 $sql_extra = sprintf(" AND `issued-id` = '%s' ", dbesc($dfrn_id));
67 $sql_extra = sprintf(" AND `issued-id` = '%s' AND `duplex` = 1 ", dbesc($dfrn_id));
68 $my_id = '1:' . $dfrn_id;
71 $sql_extra = sprintf(" AND `dfrn-id` = '%s' AND `duplex` = 1 ", dbesc($dfrn_id));
72 $my_id = '0:' . $dfrn_id;
79 $r = q("SELECT * FROM `contact` WHERE `blocked` = 0 AND `pending` = 0 AND `contact`.`uid` = %d $sql_extra LIMIT 1",
87 require_once('include/security.php');
88 $groups = init_groups_visitor($contact['id']);
91 for($x = 0; $x < count($groups); $x ++)
92 $groups[$x] = '<' . intval($groups[$x]) . '>' ;
93 $gs = implode('|', $groups);
96 $gs = '<<>>' ; // Impossible to match
98 $sql_extra = sprintf("
99 AND ( `allow_cid` = '' OR `allow_cid` REGEXP '<%d>' )
100 AND ( `deny_cid` = '' OR NOT `deny_cid` REGEXP '<%d>' )
101 AND ( `allow_gid` = '' OR `allow_gid` REGEXP '%s' )
102 AND ( `deny_gid` = '' OR NOT `deny_gid` REGEXP '%s')
104 intval($contact['id']),
105 intval($contact['id']),
116 if(! strlen($last_update))
117 $last_update = 'now -30 days';
119 if(isset($category)) {
120 $sql_post_table = sprintf("INNER JOIN (SELECT `oid` FROM `term` WHERE `term` = '%s' AND `otype` = %d AND `type` = %d AND `uid` = %d ORDER BY `tid` DESC) AS `term` ON `item`.`id` = `term`.`oid` ",
121 dbesc(protect_sprintf($category)), intval(TERM_OBJ_POST), intval(TERM_CATEGORY), intval($owner_id));
122 //$sql_extra .= file_tag_file_query('item',$category,'category');
127 $sql_extra .= " AND `contact`.`self` = 1 ";
130 $check_date = datetime_convert('UTC','UTC',$last_update,'Y-m-d H:i:s');
132 // AND ( `item`.`edited` > '%s' OR `item`.`changed` > '%s' )
133 // dbesc($check_date),
135 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
136 `contact`.`name`, `contact`.`network`, `contact`.`photo`, `contact`.`url`,
137 `contact`.`name-date`, `contact`.`uri-date`, `contact`.`avatar-date`,
138 `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
139 `contact`.`id` AS `contact-id`, `contact`.`uid` AS `contact-uid`,
140 `sign`.`signed_text`, `sign`.`signature`, `sign`.`signer`
141 FROM `item` $sql_post_table
142 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
143 AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
144 LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id`
145 WHERE `item`.`uid` = %d AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`parent` != 0
146 AND `item`.`wall` = 1 AND `item`.`changed` > '%s'
148 ORDER BY `parent` %s, `created` ASC LIMIT 0, 300",
154 // Will check further below if this actually returned results.
155 // We will provide an empty feed if that is the case.
159 $feed_template = get_markup_template(($dfrn_id) ? 'atom_feed_dfrn.tpl' : 'atom_feed.tpl');
163 $hubxml = feed_hublinks();
165 $salmon = feed_salmonlinks($owner_nick);
167 $alternatelink = $owner['url'];
170 $alternatelink .= "/category/".$category;
172 $atom .= replace_macros($feed_template, array(
173 '$version' => xmlify(FRIENDICA_VERSION),
174 '$feed_id' => xmlify($a->get_baseurl() . '/profile/' . $owner_nick),
175 '$feed_title' => xmlify($owner['name']),
176 '$feed_updated' => xmlify(datetime_convert('UTC', 'UTC', 'now' , ATOM_TIME)) ,
178 '$salmon' => $salmon,
179 '$alternatelink' => xmlify($alternatelink),
180 '$name' => xmlify($owner['name']),
181 '$profile_page' => xmlify($owner['url']),
182 '$photo' => xmlify($owner['photo']),
183 '$thumb' => xmlify($owner['thumb']),
184 '$picdate' => xmlify(datetime_convert('UTC','UTC',$owner['avatar-date'] . '+00:00' , ATOM_TIME)) ,
185 '$uridate' => xmlify(datetime_convert('UTC','UTC',$owner['uri-date'] . '+00:00' , ATOM_TIME)) ,
186 '$namdate' => xmlify(datetime_convert('UTC','UTC',$owner['name-date'] . '+00:00' , ATOM_TIME)) ,
187 '$birthday' => ((strlen($birthday)) ? '<dfrn:birthday>' . xmlify($birthday) . '</dfrn:birthday>' : ''),
188 '$community' => (($owner['page-flags'] == PAGE_COMMUNITY) ? '<dfrn:community>1</dfrn:community>' : '')
191 call_hooks('atom_feed', $atom);
193 if(! count($items)) {
195 call_hooks('atom_feed_end', $atom);
197 $atom .= '</feed>' . "\r\n";
201 foreach($items as $item) {
203 // prevent private email from leaking.
204 if($item['network'] === NETWORK_MAIL)
207 // public feeds get html, our own nodes use bbcode
211 // catch any email that's in a public conversation and make sure it doesn't leak
219 $atom .= atom_entry($item,$type,null,$owner,true);
222 call_hooks('atom_feed_end', $atom);
224 $atom .= '</feed>' . "\r\n";
230 function construct_verb($item) {
232 return $item['verb'];
233 return ACTIVITY_POST;
236 function construct_activity_object($item) {
238 if($item['object']) {
239 $o = '<as:object>' . "\r\n";
240 $r = parse_xml_string($item['object'],false);
246 $o .= '<as:object-type>' . xmlify($r->type) . '</as:object-type>' . "\r\n";
248 $o .= '<id>' . xmlify($r->id) . '</id>' . "\r\n";
250 $o .= '<title>' . xmlify($r->title) . '</title>' . "\r\n";
252 if(substr($r->link,0,1) === '<') {
253 // patch up some facebook "like" activity objects that got stored incorrectly
254 // for a couple of months prior to 9-Jun-2011 and generated bad XML.
255 // we can probably remove this hack here and in the following function in a few months time.
256 if(strstr($r->link,'&') && (! strstr($r->link,'&')))
257 $r->link = str_replace('&','&', $r->link);
258 $r->link = preg_replace('/\<link(.*?)\"\>/','<link$1"/>',$r->link);
262 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($r->link) . '" />' . "\r\n";
265 $o .= '<content type="html" >' . xmlify(bbcode($r->content)) . '</content>' . "\r\n";
266 $o .= '</as:object>' . "\r\n";
273 function construct_activity_target($item) {
275 if($item['target']) {
276 $o = '<as:target>' . "\r\n";
277 $r = parse_xml_string($item['target'],false);
281 $o .= '<as:object-type>' . xmlify($r->type) . '</as:object-type>' . "\r\n";
283 $o .= '<id>' . xmlify($r->id) . '</id>' . "\r\n";
285 $o .= '<title>' . xmlify($r->title) . '</title>' . "\r\n";
287 if(substr($r->link,0,1) === '<') {
288 if(strstr($r->link,'&') && (! strstr($r->link,'&')))
289 $r->link = str_replace('&','&', $r->link);
290 $r->link = preg_replace('/\<link(.*?)\"\>/','<link$1"/>',$r->link);
294 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($r->link) . '" />' . "\r\n";
297 $o .= '<content type="html" >' . xmlify(bbcode($r->content)) . '</content>' . "\r\n";
298 $o .= '</as:target>' . "\r\n";
307 * The purpose of this function is to apply system message length limits to
308 * imported messages without including any embedded photos in the length
310 if(! function_exists('limit_body_size')) {
311 function limit_body_size($body) {
313 // logger('limit_body_size: start', LOGGER_DEBUG);
315 $maxlen = get_max_import_size();
317 // If the length of the body, including the embedded images, is smaller
318 // than the maximum, then don't waste time looking for the images
319 if($maxlen && (strlen($body) > $maxlen)) {
321 logger('limit_body_size: the total body length exceeds the limit', LOGGER_DEBUG);
328 $img_start = strpos($orig_body, '[img');
329 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
330 $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
331 while(($img_st_close !== false) && ($img_end !== false)) {
333 $img_st_close++; // make it point to AFTER the closing bracket
334 $img_end += $img_start;
335 $img_end += strlen('[/img]');
337 if(! strcmp(substr($orig_body, $img_start + $img_st_close, 5), 'data:')) {
338 // This is an embedded image
340 if( ($textlen + $img_start) > $maxlen ) {
341 if($textlen < $maxlen) {
342 logger('limit_body_size: the limit happens before an embedded image', LOGGER_DEBUG);
343 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
348 $new_body = $new_body . substr($orig_body, 0, $img_start);
349 $textlen += $img_start;
352 $new_body = $new_body . substr($orig_body, $img_start, $img_end - $img_start);
356 if( ($textlen + $img_end) > $maxlen ) {
357 if($textlen < $maxlen) {
358 logger('limit_body_size: the limit happens before the end of a non-embedded image', LOGGER_DEBUG);
359 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
364 $new_body = $new_body . substr($orig_body, 0, $img_end);
365 $textlen += $img_end;
368 $orig_body = substr($orig_body, $img_end);
370 if($orig_body === false) // in case the body ends on a closing image tag
373 $img_start = strpos($orig_body, '[img');
374 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
375 $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
378 if( ($textlen + strlen($orig_body)) > $maxlen) {
379 if($textlen < $maxlen) {
380 logger('limit_body_size: the limit happens after the end of the last image', LOGGER_DEBUG);
381 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
386 logger('limit_body_size: the text size with embedded images extracted did not violate the limit', LOGGER_DEBUG);
387 $new_body = $new_body . $orig_body;
388 $textlen += strlen($orig_body);
397 function title_is_body($title, $body) {
399 $title = strip_tags($title);
400 $title = trim($title);
401 $title = html_entity_decode($title, ENT_QUOTES, 'UTF-8');
402 $title = str_replace(array("\n", "\r", "\t", " "), array("","","",""), $title);
404 $body = strip_tags($body);
406 $body = html_entity_decode($body, ENT_QUOTES, 'UTF-8');
407 $body = str_replace(array("\n", "\r", "\t", " "), array("","","",""), $body);
409 if (strlen($title) < strlen($body))
410 $body = substr($body, 0, strlen($title));
412 if (($title != $body) and (substr($title, -3) == "...")) {
413 $pos = strrpos($title, "...");
415 $title = substr($title, 0, $pos);
416 $body = substr($body, 0, $pos);
420 return($title == $body);
425 function get_atom_elements($feed, $item, $contact = array()) {
427 require_once('library/HTMLPurifier.auto.php');
428 require_once('include/html2bbcode.php');
430 $best_photo = array();
434 $author = $item->get_author();
436 $res['author-name'] = unxmlify($author->get_name());
437 $res['author-link'] = unxmlify($author->get_link());
440 $res['author-name'] = unxmlify($feed->get_title());
441 $res['author-link'] = unxmlify($feed->get_permalink());
443 $res['uri'] = unxmlify($item->get_id());
444 $res['title'] = unxmlify($item->get_title());
445 $res['body'] = unxmlify($item->get_content());
446 $res['plink'] = unxmlify($item->get_link(0));
448 if (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND strstr($res['plink'], ".app.net/")) {
449 logger("get_atom_elements: detected app.net posting: ".print_r($res, true), LOGGER_DEBUG);
451 $res['body'] = nl2br($res['body']);
454 // removing the content of the title if its identically to the body
455 // This helps with auto generated titles e.g. from tumblr
456 if (title_is_body($res["title"], $res["body"]))
460 $base_url = implode('/', array_slice(explode('/',$res['plink']),0,3));
464 // look for a photo. We should check media size and find the best one,
465 // but for now let's just find any author photo
467 $rawauthor = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'author');
469 if($rawauthor && $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
470 $base = $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
471 foreach($base as $link) {
472 if(!x($res, 'author-avatar') || !$res['author-avatar']) {
473 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
474 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
479 $rawactor = $item->get_item_tags(NAMESPACE_ACTIVITY, 'actor');
481 if($rawactor && activity_match($rawactor[0]['child'][NAMESPACE_ACTIVITY]['object-type'][0]['data'],ACTIVITY_OBJ_PERSON)) {
482 $base = $rawactor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
483 if($base && count($base)) {
484 foreach($base as $link) {
485 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
486 $res['author-link'] = unxmlify($link['attribs']['']['href']);
487 if(!x($res, 'author-avatar') || !$res['author-avatar']) {
488 if($link['attribs']['']['rel'] === 'avatar' || $link['attribs']['']['rel'] === 'photo')
489 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
495 // No photo/profile-link on the item - look at the feed level
497 if((! (x($res,'author-link'))) || (! (x($res,'author-avatar')))) {
498 $rawauthor = $feed->get_feed_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'author');
499 if($rawauthor && $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
500 $base = $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
501 foreach($base as $link) {
502 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
503 $res['author-link'] = unxmlify($link['attribs']['']['href']);
504 if(! $res['author-avatar']) {
505 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
506 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
511 $rawactor = $feed->get_feed_tags(NAMESPACE_ACTIVITY, 'subject');
513 if($rawactor && activity_match($rawactor[0]['child'][NAMESPACE_ACTIVITY]['object-type'][0]['data'],ACTIVITY_OBJ_PERSON)) {
514 $base = $rawactor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
516 if($base && count($base)) {
517 foreach($base as $link) {
518 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
519 $res['author-link'] = unxmlify($link['attribs']['']['href']);
520 if(! (x($res,'author-avatar'))) {
521 if($link['attribs']['']['rel'] === 'avatar' || $link['attribs']['']['rel'] === 'photo')
522 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
529 $apps = $item->get_item_tags(NAMESPACE_STATUSNET,'notice_info');
530 if($apps && $apps[0]['attribs']['']['source']) {
531 $res['app'] = strip_tags(unxmlify($apps[0]['attribs']['']['source']));
532 if($res['app'] === 'web')
533 $res['app'] = 'OStatus';
536 // base64 encoded json structure representing Diaspora signature
538 $dsig = $item->get_item_tags(NAMESPACE_DFRN,'diaspora_signature');
540 $res['dsprsig'] = unxmlify($dsig[0]['data']);
543 $dguid = $item->get_item_tags(NAMESPACE_DFRN,'diaspora_guid');
545 $res['guid'] = unxmlify($dguid[0]['data']);
547 $bm = $item->get_item_tags(NAMESPACE_DFRN,'bookmark');
549 $res['bookmark'] = ((unxmlify($bm[0]['data']) === 'true') ? 1 : 0);
553 * If there's a copy of the body content which is guaranteed to have survived mangling in transit, use it.
556 $have_real_body = false;
558 $rawenv = $item->get_item_tags(NAMESPACE_DFRN, 'env');
560 $have_real_body = true;
561 $res['body'] = $rawenv[0]['data'];
562 $res['body'] = str_replace(array(' ',"\t","\r","\n"), array('','','',''),$res['body']);
563 // make sure nobody is trying to sneak some html tags by us
564 $res['body'] = notags(base64url_decode($res['body']));
568 $res['body'] = limit_body_size($res['body']);
570 // It isn't certain at this point whether our content is plaintext or html and we'd be foolish to trust
571 // the content type. Our own network only emits text normally, though it might have been converted to
572 // html if we used a pubsubhubbub transport. But if we see even one html tag in our text, we will
573 // have to assume it is all html and needs to be purified.
575 // It doesn't matter all that much security wise - because before this content is used anywhere, we are
576 // going to escape any tags we find regardless, but this lets us import a limited subset of html from
577 // the wild, by sanitising it and converting supported tags to bbcode before we rip out any remaining
580 if((strpos($res['body'],'<') !== false) && (strpos($res['body'],'>') !== false)) {
582 $res['body'] = reltoabs($res['body'],$base_url);
584 $res['body'] = html2bb_video($res['body']);
586 $res['body'] = oembed_html2bbcode($res['body']);
588 $config = HTMLPurifier_Config::createDefault();
589 $config->set('Cache.DefinitionImpl', null);
591 // we shouldn't need a whitelist, because the bbcode converter
592 // will strip out any unsupported tags.
594 $purifier = new HTMLPurifier($config);
595 $res['body'] = $purifier->purify($res['body']);
597 $res['body'] = @html2bbcode($res['body']);
601 elseif(! $have_real_body) {
603 // it's not one of our messages and it has no tags
604 // so it's probably just text. We'll escape it just to be safe.
606 $res['body'] = escape_tags($res['body']);
610 // this tag is obsolete but we keep it for really old sites
612 $allow = $item->get_item_tags(NAMESPACE_DFRN,'comment-allow');
613 if($allow && $allow[0]['data'] == 1)
614 $res['last-child'] = 1;
616 $res['last-child'] = 0;
618 $private = $item->get_item_tags(NAMESPACE_DFRN,'private');
619 if($private && intval($private[0]['data']) > 0)
620 $res['private'] = intval($private[0]['data']);
624 $extid = $item->get_item_tags(NAMESPACE_DFRN,'extid');
625 if($extid && $extid[0]['data'])
626 $res['extid'] = $extid[0]['data'];
628 $rawlocation = $item->get_item_tags(NAMESPACE_DFRN, 'location');
630 $res['location'] = unxmlify($rawlocation[0]['data']);
633 $rawcreated = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'published');
635 $res['created'] = unxmlify($rawcreated[0]['data']);
638 $rawedited = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'updated');
640 $res['edited'] = unxmlify($rawedited[0]['data']);
642 if((x($res,'edited')) && (! (x($res,'created'))))
643 $res['created'] = $res['edited'];
645 if(! $res['created'])
646 $res['created'] = $item->get_date('c');
649 $res['edited'] = $item->get_date('c');
652 // Disallow time travelling posts
654 $d1 = strtotime($res['created']);
655 $d2 = strtotime($res['edited']);
656 $d3 = strtotime('now');
659 $res['created'] = datetime_convert();
661 $res['edited'] = datetime_convert();
663 $rawowner = $item->get_item_tags(NAMESPACE_DFRN, 'owner');
664 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['name'][0]['data'])
665 $res['owner-name'] = unxmlify($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['name'][0]['data']);
666 elseif($rawowner[0]['child'][NAMESPACE_DFRN]['name'][0]['data'])
667 $res['owner-name'] = unxmlify($rawowner[0]['child'][NAMESPACE_DFRN]['name'][0]['data']);
668 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['uri'][0]['data'])
669 $res['owner-link'] = unxmlify($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['uri'][0]['data']);
670 elseif($rawowner[0]['child'][NAMESPACE_DFRN]['uri'][0]['data'])
671 $res['owner-link'] = unxmlify($rawowner[0]['child'][NAMESPACE_DFRN]['uri'][0]['data']);
673 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
674 $base = $rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
676 foreach($base as $link) {
677 if(!x($res, 'owner-avatar') || !$res['owner-avatar']) {
678 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
679 $res['owner-avatar'] = unxmlify($link['attribs']['']['href']);
684 $rawgeo = $item->get_item_tags(NAMESPACE_GEORSS,'point');
686 $res['coord'] = unxmlify($rawgeo[0]['data']);
688 if ($contact["network"] == NETWORK_FEED) {
689 $res['verb'] = ACTIVITY_POST;
690 $res['object-type'] = ACTIVITY_OBJ_NOTE;
693 $rawverb = $item->get_item_tags(NAMESPACE_ACTIVITY, 'verb');
695 // select between supported verbs
698 $res['verb'] = unxmlify($rawverb[0]['data']);
701 // translate OStatus unfollow to activity streams if it happened to get selected
703 if((x($res,'verb')) && ($res['verb'] === 'http://ostatus.org/schema/1.0/unfollow'))
704 $res['verb'] = ACTIVITY_UNFOLLOW;
706 $cats = $item->get_categories();
709 foreach($cats as $cat) {
710 $term = $cat->get_term();
712 $term = $cat->get_label();
713 $scheme = $cat->get_scheme();
714 if($scheme && $term && stristr($scheme,'X-DFRN:'))
715 $tag_arr[] = substr($scheme,7,1) . '[url=' . unxmlify(substr($scheme,9)) . ']' . unxmlify($term) . '[/url]';
717 $tag_arr[] = notags(trim($term));
719 $res['tag'] = implode(',', $tag_arr);
722 $attach = $item->get_enclosures();
725 foreach($attach as $att) {
726 $len = intval($att->get_length());
727 $link = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_link()))));
728 $title = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_title()))));
729 $type = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_type()))));
730 if(strpos($type,';'))
731 $type = substr($type,0,strpos($type,';'));
732 if((! $link) || (strpos($link,'http') !== 0))
738 $type = 'application/octet-stream';
740 $att_arr[] = '[attach]href="' . $link . '" length="' . $len . '" type="' . $type . '" title="' . $title . '"[/attach]';
742 $res['attach'] = implode(',', $att_arr);
745 $rawobj = $item->get_item_tags(NAMESPACE_ACTIVITY, 'object');
748 $res['object'] = '<object>' . "\n";
749 $child = $rawobj[0]['child'];
750 if($child[NAMESPACE_ACTIVITY]['object-type'][0]['data']) {
751 $res['object-type'] = $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'];
752 $res['object'] .= '<type>' . $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'] . '</type>' . "\n";
754 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'id') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'])
755 $res['object'] .= '<id>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'] . '</id>' . "\n";
756 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'link') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['link'])
757 $res['object'] .= '<link>' . encode_rel_links($child[SIMPLEPIE_NAMESPACE_ATOM_10]['link']) . '</link>' . "\n";
758 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'title') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'])
759 $res['object'] .= '<title>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'] . '</title>' . "\n";
760 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'content') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data']) {
761 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data'];
763 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['summary'][0]['data'];
764 // preserve a copy of the original body content in case we later need to parse out any microformat information, e.g. events
765 $res['object'] .= '<orig>' . xmlify($body) . '</orig>' . "\n";
766 if((strpos($body,'<') !== false) || (strpos($body,'>') !== false)) {
768 $body = html2bb_video($body);
770 $config = HTMLPurifier_Config::createDefault();
771 $config->set('Cache.DefinitionImpl', null);
773 $purifier = new HTMLPurifier($config);
774 $body = $purifier->purify($body);
775 $body = html2bbcode($body);
778 $res['object'] .= '<content>' . $body . '</content>' . "\n";
781 $res['object'] .= '</object>' . "\n";
784 $rawobj = $item->get_item_tags(NAMESPACE_ACTIVITY, 'target');
787 $res['target'] = '<target>' . "\n";
788 $child = $rawobj[0]['child'];
789 if($child[NAMESPACE_ACTIVITY]['object-type'][0]['data']) {
790 $res['target'] .= '<type>' . $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'] . '</type>' . "\n";
792 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'id') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'])
793 $res['target'] .= '<id>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'] . '</id>' . "\n";
794 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'link') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['link'])
795 $res['target'] .= '<link>' . encode_rel_links($child[SIMPLEPIE_NAMESPACE_ATOM_10]['link']) . '</link>' . "\n";
796 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'data') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'])
797 $res['target'] .= '<title>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'] . '</title>' . "\n";
798 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'data') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data']) {
799 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data'];
801 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['summary'][0]['data'];
802 // preserve a copy of the original body content in case we later need to parse out any microformat information, e.g. events
803 $res['target'] .= '<orig>' . xmlify($body) . '</orig>' . "\n";
804 if((strpos($body,'<') !== false) || (strpos($body,'>') !== false)) {
806 $body = html2bb_video($body);
808 $config = HTMLPurifier_Config::createDefault();
809 $config->set('Cache.DefinitionImpl', null);
811 $purifier = new HTMLPurifier($config);
812 $body = $purifier->purify($body);
813 $body = html2bbcode($body);
816 $res['target'] .= '<content>' . $body . '</content>' . "\n";
819 $res['target'] .= '</target>' . "\n";
822 // This is some experimental stuff. By now retweets are shown with "RT:"
823 // But: There is data so that the message could be shown similar to native retweets
824 // There is some better way to parse this array - but it didn't worked for me.
825 $child = $item->feed->data["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["feed"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["entry"][0]["child"]["http://activitystrea.ms/spec/1.0/"][object][0]["child"];
826 if (is_array($child)) {
827 logger('get_atom_elements: Looking for status.net repeated message');
829 $message = $child["http://activitystrea.ms/spec/1.0/"]["object"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["content"][0]["data"];
830 $orig_uri = $child["http://activitystrea.ms/spec/1.0/"]["object"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["id"][0]["data"];
831 $author = $child[SIMPLEPIE_NAMESPACE_ATOM_10]["author"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10];
832 $uri = $author["uri"][0]["data"];
833 $name = $author["name"][0]["data"];
834 $avatar = @array_shift($author["link"][2]["attribs"]);
835 $avatar = $avatar["href"];
837 if (($name != "") and ($uri != "") and ($avatar != "") and ($message != "")) {
838 logger('get_atom_elements: fixing sender of repeated message.');
840 if (!intval(get_config('system','wall-to-wall_share'))) {
841 $prefix = "[share author='".str_replace("'", "'",$name).
843 "' avatar='".$avatar.
844 "' link='".$orig_uri."']";
846 $res["body"] = $prefix.html2bbcode($message)."[/share]";
848 $res["owner-name"] = $res["author-name"];
849 $res["owner-link"] = $res["author-link"];
850 $res["owner-avatar"] = $res["author-avatar"];
852 $res["author-name"] = $name;
853 $res["author-link"] = $uri;
854 $res["author-avatar"] = $avatar;
856 $res["body"] = html2bbcode($message);
861 // Search for ostatus conversation url
862 $links = $item->feed->data["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["feed"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["entry"][0]["child"]["http://www.w3.org/2005/Atom"]["link"];
864 if (is_array($links)) {
865 foreach ($links as $link) {
866 $conversation = array_shift($link["attribs"]);
868 if ($conversation["rel"] == "ostatus:conversation") {
869 $res["ostatus_conversation"] = $conversation["href"];
870 logger('get_atom_elements: found conversation url '.$res["ostatus_conversation"]);
875 if (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND $contact['fetch_further_information']) {
878 // Handle enclosures and treat them as preview picture
880 foreach ($attach AS $attachment)
881 if ($attachment->type == "image/jpeg")
882 $preview = $attachment->link;
884 $res["body"] = $res["title"].add_page_info($res['plink'], false, $preview, ($contact['fetch_further_information'] == 2), $contact['ffi_keyword_blacklist']);
885 $res["tag"] = add_page_keywords($res['plink'], false, $preview, ($contact['fetch_further_information'] == 2), $contact['ffi_keyword_blacklist']);
887 $res["object-type"] = ACTIVITY_OBJ_BOOKMARK;
888 unset($res["attach"]);
889 } elseif (isset($contact["network"]) AND ($contact["network"] == NETWORK_OSTATUS))
890 $res["body"] = add_page_info_to_body($res["body"]);
891 elseif (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND strstr($res['plink'], ".app.net/")) {
892 $res["body"] = add_page_info_to_body($res["body"]);
895 $arr = array('feed' => $feed, 'item' => $item, 'result' => $res);
897 call_hooks('parse_atom', $arr);
902 function add_page_info_data($data) {
903 call_hooks('page_info_data', $data);
905 // It maybe is a rich content, but if it does have everything that a link has,
906 // then treat it that way
907 if (($data["type"] == "rich") AND is_string($data["title"]) AND
908 is_string($data["text"]) AND (sizeof($data["images"]) > 0))
909 $data["type"] = "link";
911 if ((($data["type"] != "link") AND ($data["type"] != "video") AND ($data["type"] != "photo")) OR ($data["title"] == $url))
914 if ($no_photos AND ($data["type"] == "photo"))
917 // If the link contains BBCode stuff, make a short link out of this to avoid parsing problems
918 if (strpos($data["url"], '[') OR strpos($data["url"], ']')) {
919 require_once("include/network.php");
920 $data["url"] = short_link($data["url"]);
923 if (($data["type"] != "photo") AND is_string($data["title"]))
924 $text .= "[bookmark=".$data["url"]."]".trim($data["title"])."[/bookmark]";
926 if (($data["type"] != "video") AND ($photo != ""))
927 $text .= '[img]'.$photo.'[/img]';
928 elseif (($data["type"] != "video") AND (sizeof($data["images"]) > 0)) {
929 $imagedata = $data["images"][0];
930 $text .= '[img]'.$imagedata["src"].'[/img]';
933 if (($data["type"] != "photo") AND is_string($data["text"]))
934 $text .= "[quote]".$data["text"]."[/quote]";
937 if (isset($data["keywords"]) AND count($data["keywords"])) {
940 foreach ($data["keywords"] AS $keyword) {
941 $hashtag = str_replace(array(" ", "+", "/", ".", "#", "'"),
942 array("","", "", "", "", ""), $keyword);
943 $hashtags .= "#[url=".$a->get_baseurl()."/search?tag=".rawurlencode($hashtag)."]".$hashtag."[/url] ";
947 return("\n[class=type-".$data["type"]."]".$text."[/class]".$hashtags);
950 function query_page_info($url, $no_photos = false, $photo = "", $keywords = false, $keyword_blacklist = "") {
951 require_once("mod/parse_url.php");
953 $data = Cache::get("parse_url:".$url);
955 $data = parseurl_getsiteinfo($url, true);
956 Cache::set("parse_url:".$url,serialize($data));
958 $data = unserialize($data);
961 $data["images"][0]["src"] = $photo;
963 logger('fetch page info for '.$url.' '.print_r($data, true), LOGGER_DEBUG);
965 if (!$keywords AND isset($data["keywords"]))
966 unset($data["keywords"]);
968 if (($keyword_blacklist != "") AND isset($data["keywords"])) {
969 $list = explode(",", $keyword_blacklist);
970 foreach ($list AS $keyword) {
971 $keyword = trim($keyword);
972 $index = array_search($keyword, $data["keywords"]);
973 if ($index !== false)
974 unset($data["keywords"][$index]);
981 function add_page_keywords($url, $no_photos = false, $photo = "", $keywords = false, $keyword_blacklist = "") {
982 $data = query_page_info($url, $no_photos, $photo, $keywords, $keyword_blacklist);
985 if (isset($data["keywords"]) AND count($data["keywords"])) {
987 foreach ($data["keywords"] AS $keyword) {
988 $hashtag = str_replace(array(" ", "+", "/", ".", "#", "'"),
989 array("","", "", "", "", ""), $keyword);
994 $tags .= "#[url=".$a->get_baseurl()."/search?tag=".rawurlencode($hashtag)."]".$hashtag."[/url]";
1001 function add_page_info($url, $no_photos = false, $photo = "", $keywords = false, $keyword_blacklist = "") {
1002 $data = query_page_info($url, $no_photos, $photo, $keywords, $keyword_blacklist);
1004 $text = add_page_info_data($data);
1009 function add_page_info_to_body($body, $texturl = false, $no_photos = false) {
1011 logger('add_page_info_to_body: fetch page info for body '.$body, LOGGER_DEBUG);
1013 $URLSearchString = "^\[\]";
1015 // Adding these spaces is a quick hack due to my problems with regular expressions :)
1016 preg_match("/[^!#@]\[url\]([$URLSearchString]*)\[\/url\]/ism", " ".$body, $matches);
1019 preg_match("/[^!#@]\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism", " ".$body, $matches);
1021 // Convert urls without bbcode elements
1022 if (!$matches AND $texturl) {
1023 preg_match("/([^\]\='".'"'."]|^)(https?\:\/\/[a-zA-Z0-9\:\/\-\?\&\;\.\=\_\~\#\%\$\!\+\,]+)/ism", " ".$body, $matches);
1025 // Yeah, a hack. I really hate regular expressions :)
1027 $matches[1] = $matches[2];
1031 $footer = add_page_info($matches[1], $no_photos);
1033 // Remove the link from the body if the link is attached at the end of the post
1034 if (isset($footer) AND (trim($footer) != "") AND (strpos($footer, $matches[1]))) {
1035 $removedlink = trim(str_replace($matches[1], "", $body));
1036 if (($removedlink == "") OR strstr($body, $removedlink))
1037 $body = $removedlink;
1039 $url = str_replace(array('/', '.'), array('\/', '\.'), $matches[1]);
1040 $removedlink = preg_replace("/\[url\=".$url."\](.*?)\[\/url\]/ism", '', $body);
1041 if (($removedlink == "") OR strstr($body, $removedlink))
1042 $body = $removedlink;
1045 // Add the page information to the bottom
1046 if (isset($footer) AND (trim($footer) != ""))
1052 function encode_rel_links($links) {
1054 if(! ((is_array($links)) && (count($links))))
1056 foreach($links as $link) {
1058 if($link['attribs']['']['rel'])
1059 $o .= 'rel="' . $link['attribs']['']['rel'] . '" ';
1060 if($link['attribs']['']['type'])
1061 $o .= 'type="' . $link['attribs']['']['type'] . '" ';
1062 if($link['attribs']['']['href'])
1063 $o .= 'href="' . $link['attribs']['']['href'] . '" ';
1064 if( (x($link['attribs'],NAMESPACE_MEDIA)) && $link['attribs'][NAMESPACE_MEDIA]['width'])
1065 $o .= 'media:width="' . $link['attribs'][NAMESPACE_MEDIA]['width'] . '" ';
1066 if( (x($link['attribs'],NAMESPACE_MEDIA)) && $link['attribs'][NAMESPACE_MEDIA]['height'])
1067 $o .= 'media:height="' . $link['attribs'][NAMESPACE_MEDIA]['height'] . '" ';
1068 $o .= ' />' . "\n" ;
1075 function item_store($arr,$force_parent = false, $notify = false, $dontcache = false) {
1077 // If it is a posting where users should get notifications, then define it as wall posting
1080 $arr['type'] = 'wall';
1082 $arr['last-child'] = 1;
1083 $arr['network'] = NETWORK_DFRN;
1086 // If a Diaspora signature structure was passed in, pull it out of the
1087 // item array and set it aside for later storage.
1090 if(x($arr,'dsprsig')) {
1091 $dsprsig = json_decode(base64_decode($arr['dsprsig']));
1092 unset($arr['dsprsig']);
1095 // if an OStatus conversation url was passed in, it is stored and then
1096 // removed from the array.
1097 $ostatus_conversation = null;
1099 if (isset($arr["ostatus_conversation"])) {
1100 $ostatus_conversation = $arr["ostatus_conversation"];
1101 unset($arr["ostatus_conversation"]);
1104 if(x($arr, 'gravity'))
1105 $arr['gravity'] = intval($arr['gravity']);
1106 elseif($arr['parent-uri'] === $arr['uri'])
1107 $arr['gravity'] = 0;
1108 elseif(activity_match($arr['verb'],ACTIVITY_POST))
1109 $arr['gravity'] = 6;
1111 $arr['gravity'] = 6; // extensible catchall
1113 if(! x($arr,'type'))
1114 $arr['type'] = 'remote';
1118 /* check for create date and expire time */
1119 $uid = intval($arr['uid']);
1120 $r = q("SELECT expire FROM user WHERE uid = %d", $uid);
1122 $expire_interval = $r[0]['expire'];
1123 if ($expire_interval>0) {
1124 $expire_date = new DateTime( '- '.$expire_interval.' days', new DateTimeZone('UTC'));
1125 $created_date = new DateTime($arr['created'], new DateTimeZone('UTC'));
1126 if ($created_date < $expire_date) {
1127 logger('item-store: item created ('.$arr['created'].') before expiration time ('.$expire_date->format(DateTime::W3C).'). ignored. ' . print_r($arr,true), LOGGER_DEBUG);
1133 // If there is no guid then take the same guid that was taken before for the same uri
1134 if ((trim($arr['guid']) == "") AND (trim($arr['uri']) != "")) {
1135 logger('item_store: checking for an existing guid for uri '.$arr['uri'], LOGGER_DEBUG);
1136 $r = q("SELECT `guid` FROM `item` WHERE `uri` = '%s' AND `guid` != '' LIMIT 1",
1137 dbesc(trim($arr['uri']))
1141 $arr['guid'] = $r[0]["guid"];
1142 logger('item_store: found guid '.$arr['guid'].' for uri '.$arr['uri'], LOGGER_DEBUG);
1146 // Shouldn't happen but we want to make absolutely sure it doesn't leak from a plugin.
1147 // Deactivated, since the bbcode parser can handle with it - and it destroys posts with some smileys that contain "<"
1148 //if((strpos($arr['body'],'<') !== false) || (strpos($arr['body'],'>') !== false))
1149 // $arr['body'] = strip_tags($arr['body']);
1152 if (version_compare(PHP_VERSION, '5.3.0', '>=')) {
1153 require_once('library/langdet/Text/LanguageDetect.php');
1154 $naked_body = preg_replace('/\[(.+?)\]/','',$arr['body']);
1155 $l = new Text_LanguageDetect;
1156 //$lng = $l->detectConfidence($naked_body);
1157 //$arr['postopts'] = (($lng['language']) ? 'lang=' . $lng['language'] . ';' . $lng['confidence'] : '');
1158 $lng = $l->detect($naked_body, 3);
1160 if (sizeof($lng) > 0) {
1163 foreach ($lng as $language => $score) {
1164 if ($postopts == "")
1165 $postopts = "lang=";
1169 $postopts .= $language.";".$score;
1171 $arr['postopts'] = $postopts;
1175 $arr['wall'] = ((x($arr,'wall')) ? intval($arr['wall']) : 0);
1176 $arr['uri'] = ((x($arr,'uri')) ? notags(trim($arr['uri'])) : random_string());
1177 $arr['extid'] = ((x($arr,'extid')) ? notags(trim($arr['extid'])) : '');
1178 $arr['author-name'] = ((x($arr,'author-name')) ? notags(trim($arr['author-name'])) : '');
1179 $arr['author-link'] = ((x($arr,'author-link')) ? notags(trim($arr['author-link'])) : '');
1180 $arr['author-avatar'] = ((x($arr,'author-avatar')) ? notags(trim($arr['author-avatar'])) : '');
1181 $arr['owner-name'] = ((x($arr,'owner-name')) ? notags(trim($arr['owner-name'])) : '');
1182 $arr['owner-link'] = ((x($arr,'owner-link')) ? notags(trim($arr['owner-link'])) : '');
1183 $arr['owner-avatar'] = ((x($arr,'owner-avatar')) ? notags(trim($arr['owner-avatar'])) : '');
1184 $arr['created'] = ((x($arr,'created') !== false) ? datetime_convert('UTC','UTC',$arr['created']) : datetime_convert());
1185 $arr['edited'] = ((x($arr,'edited') !== false) ? datetime_convert('UTC','UTC',$arr['edited']) : datetime_convert());
1186 $arr['commented'] = datetime_convert();
1187 $arr['received'] = datetime_convert();
1188 $arr['changed'] = datetime_convert();
1189 $arr['title'] = ((x($arr,'title')) ? notags(trim($arr['title'])) : '');
1190 $arr['location'] = ((x($arr,'location')) ? notags(trim($arr['location'])) : '');
1191 $arr['coord'] = ((x($arr,'coord')) ? notags(trim($arr['coord'])) : '');
1192 $arr['last-child'] = ((x($arr,'last-child')) ? intval($arr['last-child']) : 0 );
1193 $arr['visible'] = ((x($arr,'visible') !== false) ? intval($arr['visible']) : 1 );
1194 $arr['deleted'] = 0;
1195 $arr['parent-uri'] = ((x($arr,'parent-uri')) ? notags(trim($arr['parent-uri'])) : '');
1196 $arr['verb'] = ((x($arr,'verb')) ? notags(trim($arr['verb'])) : '');
1197 $arr['object-type'] = ((x($arr,'object-type')) ? notags(trim($arr['object-type'])) : '');
1198 $arr['object'] = ((x($arr,'object')) ? trim($arr['object']) : '');
1199 $arr['target-type'] = ((x($arr,'target-type')) ? notags(trim($arr['target-type'])) : '');
1200 $arr['target'] = ((x($arr,'target')) ? trim($arr['target']) : '');
1201 $arr['plink'] = ((x($arr,'plink')) ? notags(trim($arr['plink'])) : '');
1202 $arr['allow_cid'] = ((x($arr,'allow_cid')) ? trim($arr['allow_cid']) : '');
1203 $arr['allow_gid'] = ((x($arr,'allow_gid')) ? trim($arr['allow_gid']) : '');
1204 $arr['deny_cid'] = ((x($arr,'deny_cid')) ? trim($arr['deny_cid']) : '');
1205 $arr['deny_gid'] = ((x($arr,'deny_gid')) ? trim($arr['deny_gid']) : '');
1206 $arr['private'] = ((x($arr,'private')) ? intval($arr['private']) : 0 );
1207 $arr['bookmark'] = ((x($arr,'bookmark')) ? intval($arr['bookmark']) : 0 );
1208 $arr['body'] = ((x($arr,'body')) ? trim($arr['body']) : '');
1209 $arr['tag'] = ((x($arr,'tag')) ? notags(trim($arr['tag'])) : '');
1210 $arr['attach'] = ((x($arr,'attach')) ? notags(trim($arr['attach'])) : '');
1211 $arr['app'] = ((x($arr,'app')) ? notags(trim($arr['app'])) : '');
1212 $arr['origin'] = ((x($arr,'origin')) ? intval($arr['origin']) : 0 );
1213 $arr['guid'] = ((x($arr,'guid')) ? notags(trim($arr['guid'])) : get_guid(30));
1214 $arr['network'] = ((x($arr,'network')) ? trim($arr['network']) : '');
1215 $arr['postopts'] = ((x($arr,'postopts')) ? trim($arr['postopts']) : '');
1216 $arr['resource-id'] = ((x($arr,'resource-id')) ? trim($arr['resource-id']) : '');
1217 $arr['event-id'] = ((x($arr,'event-id')) ? intval($arr['event-id']) : 0 );
1218 $arr['inform'] = ((x($arr,'inform')) ? trim($arr['inform']) : '');
1219 $arr['file'] = ((x($arr,'file')) ? trim($arr['file']) : '');
1221 if ($arr['plink'] == "") {
1223 $arr['plink'] = $a->get_baseurl().'/display/'.urlencode($arr['guid']);
1226 if ($arr['network'] == "") {
1227 $r = q("SELECT `network` FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
1228 intval($arr['contact-id']),
1233 $arr['network'] = $r[0]["network"];
1235 // Fallback to friendica (why is it empty in some cases?)
1236 if ($arr['network'] == "")
1237 $arr['network'] = NETWORK_DFRN;
1239 logger("item_store: Set network to ".$arr["network"]." for ".$arr["uri"], LOGGER_DEBUG);
1242 $arr['thr-parent'] = $arr['parent-uri'];
1243 if($arr['parent-uri'] === $arr['uri']) {
1245 $parent_deleted = 0;
1246 $allow_cid = $arr['allow_cid'];
1247 $allow_gid = $arr['allow_gid'];
1248 $deny_cid = $arr['deny_cid'];
1249 $deny_gid = $arr['deny_gid'];
1250 $notify_type = 'wall-new';
1254 // find the parent and snarf the item id and ACLs
1255 // and anything else we need to inherit
1257 $r = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC LIMIT 1",
1258 dbesc($arr['parent-uri']),
1264 // is the new message multi-level threaded?
1265 // even though we don't support it now, preserve the info
1266 // and re-attach to the conversation parent.
1268 if($r[0]['uri'] != $r[0]['parent-uri']) {
1269 $arr['parent-uri'] = $r[0]['parent-uri'];
1270 $z = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `parent-uri` = '%s' AND `uid` = %d
1271 ORDER BY `id` ASC LIMIT 1",
1272 dbesc($r[0]['parent-uri']),
1273 dbesc($r[0]['parent-uri']),
1280 $parent_id = $r[0]['id'];
1281 $parent_deleted = $r[0]['deleted'];
1282 $allow_cid = $r[0]['allow_cid'];
1283 $allow_gid = $r[0]['allow_gid'];
1284 $deny_cid = $r[0]['deny_cid'];
1285 $deny_gid = $r[0]['deny_gid'];
1286 $arr['wall'] = $r[0]['wall'];
1287 $notify_type = 'comment-new';
1289 // if the parent is private, force privacy for the entire conversation
1290 // This differs from the above settings as it subtly allows comments from
1291 // email correspondents to be private even if the overall thread is not.
1293 if($r[0]['private'])
1294 $arr['private'] = $r[0]['private'];
1296 // Edge case. We host a public forum that was originally posted to privately.
1297 // The original author commented, but as this is a comment, the permissions
1298 // weren't fixed up so it will still show the comment as private unless we fix it here.
1300 if((intval($r[0]['forum_mode']) == 1) && (! $r[0]['private']))
1301 $arr['private'] = 0;
1304 // If its a post from myself then tag the thread as "mention"
1305 logger("item_store: Checking if parent ".$parent_id." has to be tagged as mention for user ".$arr['uid'], LOGGER_DEBUG);
1306 $u = q("select * from user where uid = %d limit 1", intval($arr['uid']));
1309 $self = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1310 logger("item_store: 'myself' is ".$self." for parent ".$parent_id." checking against ".$arr['author-link']." and ".$arr['owner-link'], LOGGER_DEBUG);
1311 if ((normalise_link($arr['author-link']) == $self) OR (normalise_link($arr['owner-link']) == $self)) {
1312 q("UPDATE `thread` SET `mention` = 1 WHERE `iid` = %d", intval($parent_id));
1313 logger("item_store: tagged thread ".$parent_id." as mention for user ".$self, LOGGER_DEBUG);
1319 // Allow one to see reply tweets from status.net even when
1320 // we don't have or can't see the original post.
1323 logger('item_store: $force_parent=true, reply converted to top-level post.');
1325 $arr['parent-uri'] = $arr['uri'];
1326 $arr['gravity'] = 0;
1329 logger('item_store: item parent was not found - ignoring item');
1333 $parent_deleted = 0;
1337 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
1341 if($r && count($r)) {
1342 logger('item-store: duplicate item ignored. ' . print_r($arr,true));
1346 call_hooks('post_remote',$arr);
1348 if(x($arr,'cancel')) {
1349 logger('item_store: post cancelled by plugin.');
1353 // Store the unescaped version
1358 logger('item_store: ' . print_r($arr,true), LOGGER_DATA);
1360 $r = dbq("INSERT INTO `item` (`"
1361 . implode("`, `", array_keys($arr))
1363 . implode("', '", array_values($arr))
1369 // find the item we just created
1370 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC ",
1376 $current_post = $r[0]['id'];
1377 logger('item_store: created item ' . $current_post);
1379 // Add every contact to the global contact table
1380 // Contacts from the statusnet connector are also added since you could add them in OStatus as well.
1381 if (!$arr['private'] AND in_array($arr["network"],
1382 array(NETWORK_DFRN, NETWORK_DIASPORA, NETWORK_OSTATUS, NETWORK_STATUSNET, ""))) {
1383 poco_check($arr["author-link"], $arr["author-name"], $arr["network"], $arr["author-avatar"], "", "", "", "", "", $arr["received"], $arr["contact-id"], $arr["uid"]);
1385 // Maybe its a body with a shared item? Then extract a global contact from it.
1386 poco_contact_from_body($arr["body"], $arr["received"], $arr["contact-id"], $arr["uid"]);
1389 // Set "success_update" to the date of the last time we heard from this contact
1390 // This can be used to filter for inactive contacts and poco.
1391 // Only do this for public postings to avoid privacy problems, since poco data is public.
1392 // Don't set this value if it isn't from the owner (could be an author that we don't know)
1393 if (!$arr['private'] AND (($arr["author-link"] === $arr["owner-link"]) OR ($arr["parent-uri"] === $arr["uri"])))
1394 q("UPDATE `contact` SET `success_update` = '%s' WHERE `id` = %d",
1395 dbesc($arr['received']),
1396 intval($arr['contact-id'])
1399 // Only check for notifications on start posts
1400 if ($arr['parent-uri'] === $arr['uri']) {
1401 add_thread($r[0]['id']);
1402 logger('item_store: Check notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1404 // Send a notification for every new post?
1405 $r = q("SELECT `notify_new_posts` FROM `contact` WHERE `id` = %d AND `uid` = %d AND `notify_new_posts` LIMIT 1",
1406 intval($arr['contact-id']),
1411 logger('item_store: Send notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1412 $u = q("SELECT * FROM user WHERE uid = %d LIMIT 1",
1413 intval($arr['uid']));
1415 $item = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d",
1416 intval($current_post),
1422 require_once('include/enotify.php');
1424 'type' => NOTIFY_SHARE,
1425 'notify_flags' => $u[0]['notify-flags'],
1426 'language' => $u[0]['language'],
1427 'to_name' => $u[0]['username'],
1428 'to_email' => $u[0]['email'],
1429 'uid' => $u[0]['uid'],
1431 'link' => $a->get_baseurl().'/display/'.urlencode($arr['guid']),
1432 'source_name' => $item[0]['author-name'],
1433 'source_link' => $item[0]['author-link'],
1434 'source_photo' => $item[0]['author-avatar'],
1435 'verb' => ACTIVITY_TAG,
1438 logger('item_store: Notification sent for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1443 logger('item_store: could not locate created item');
1447 logger('item_store: duplicated post occurred. Removing duplicates.');
1448 q("DELETE FROM `item` WHERE `uri` = '%s' AND `uid` = %d AND `id` != %d ",
1450 intval($arr['uid']),
1451 intval($current_post)
1455 if((! $parent_id) || ($arr['parent-uri'] === $arr['uri']))
1456 $parent_id = $current_post;
1458 if(strlen($allow_cid) || strlen($allow_gid) || strlen($deny_cid) || strlen($deny_gid))
1461 $private = $arr['private'];
1463 // Set parent id - and also make sure to inherit the parent's ACLs.
1465 $r = q("UPDATE `item` SET `parent` = %d, `allow_cid` = '%s', `allow_gid` = '%s',
1466 `deny_cid` = '%s', `deny_gid` = '%s', `private` = %d, `deleted` = %d WHERE `id` = %d",
1473 intval($parent_deleted),
1474 intval($current_post)
1477 // Complete ostatus threads
1478 if ($ostatus_conversation)
1479 complete_conversation($current_post, $ostatus_conversation);
1481 $arr['id'] = $current_post;
1482 $arr['parent'] = $parent_id;
1483 $arr['allow_cid'] = $allow_cid;
1484 $arr['allow_gid'] = $allow_gid;
1485 $arr['deny_cid'] = $deny_cid;
1486 $arr['deny_gid'] = $deny_gid;
1487 $arr['private'] = $private;
1488 $arr['deleted'] = $parent_deleted;
1490 // update the commented timestamp on the parent
1492 q("UPDATE `item` set `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
1493 dbesc(datetime_convert()),
1494 dbesc(datetime_convert()),
1497 update_thread($parent_id);
1500 q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
1501 intval($current_post),
1502 dbesc($dsprsig->signed_text),
1503 dbesc($dsprsig->signature),
1504 dbesc($dsprsig->signer)
1510 * If this is now the last-child, force all _other_ children of this parent to *not* be last-child
1513 if($arr['last-child']) {
1514 $r = q("UPDATE `item` SET `last-child` = 0 WHERE `parent-uri` = '%s' AND `uid` = %d AND `id` != %d",
1516 intval($arr['uid']),
1517 intval($current_post)
1521 $deleted = tag_deliver($arr['uid'],$current_post);
1523 // current post can be deleted if is for a communuty page and no mention are
1525 if (!$deleted AND !$dontcache) {
1527 // Store the fresh generated item into the cache
1528 $cachefile = get_cachefile(urlencode($arr["guid"])."-".hash("md5", $arr['body']));
1530 if (($cachefile != '') AND !file_exists($cachefile)) {
1531 $s = prepare_text($arr['body']);
1533 $stamp1 = microtime(true);
1534 file_put_contents($cachefile, $s);
1535 $a->save_timestamp($stamp1, "file");
1536 logger('item_store: put item '.$current_post.' into cachefile '.$cachefile);
1539 $r = q('SELECT * FROM `item` WHERE id = %d', intval($current_post));
1540 if (count($r) == 1) {
1541 call_hooks('post_remote_end', $r[0]);
1543 logger('item_store: new item not found in DB, id ' . $current_post);
1547 create_tags_from_item($current_post, $dontcache);
1548 create_files_from_item($current_post);
1551 proc_run('php', "include/notifier.php", $notify_type, $current_post);
1553 return $current_post;
1556 function get_item_guid($id) {
1557 $r = q("SELECT `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($id));
1559 return($r[0]["guid"]);
1564 function get_item_id($guid, $uid = 0) {
1570 $uid == local_user();
1572 // Does the given user have this item?
1574 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1575 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1576 AND `item`.`guid` = '%s' AND `item`.`uid` = %d", dbesc($guid), intval($uid));
1579 $nick = $r[0]["nickname"];
1583 // Or is it anywhere on the server?
1585 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1586 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1587 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = ''
1588 AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
1589 AND `item`.`private` = 0 AND `item`.`wall` = 1
1590 AND `item`.`guid` = '%s'", dbesc($guid));
1593 $nick = $r[0]["nickname"];
1596 return(array("nick" => $nick, "id" => $id));
1600 function get_item_contact($item,$contacts) {
1601 if(! count($contacts) || (! is_array($item)))
1603 foreach($contacts as $contact) {
1604 if($contact['id'] == $item['contact-id']) {
1606 break; // NOTREACHED
1613 * look for mention tags and setup a second delivery chain for forum/community posts if appropriate
1615 * @param int $item_id
1616 * @return bool true if item was deleted, else false
1618 function tag_deliver($uid,$item_id) {
1626 $u = q("select * from user where uid = %d limit 1",
1632 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1633 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1636 $i = q("select * from item where id = %d and uid = %d limit 1",
1645 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1647 // Diaspora uses their own hardwired link URL in @-tags
1648 // instead of the one we supply with webfinger
1650 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1652 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1654 foreach($matches as $mtch) {
1655 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1657 logger('tag_deliver: mention found: ' . $mtch[2]);
1663 if ( ($community_page || $prvgroup) &&
1664 (!$item['wall']) && (!$item['origin']) && ($item['id'] == $item['parent'])){
1665 // mmh.. no mention.. community page or private group... no wall.. no origin.. top-post (not a comment)
1667 logger("tag_deliver: no-mention top-level post to communuty or private group. delete.");
1668 q("DELETE FROM item WHERE id = %d and uid = %d",
1678 // send a notification
1680 // use a local photo if we have one
1682 $r = q("select * from contact where uid = %d and nurl = '%s' limit 1",
1683 intval($u[0]['uid']),
1684 dbesc(normalise_link($item['author-link']))
1686 $photo = (($r && count($r)) ? $r[0]['thumb'] : $item['author-avatar']);
1689 require_once('include/enotify.php');
1691 'type' => NOTIFY_TAGSELF,
1692 'notify_flags' => $u[0]['notify-flags'],
1693 'language' => $u[0]['language'],
1694 'to_name' => $u[0]['username'],
1695 'to_email' => $u[0]['email'],
1696 'uid' => $u[0]['uid'],
1698 'link' => $a->get_baseurl() . '/display/'.urlencode(get_item_guid($item['id'])),
1699 'source_name' => $item['author-name'],
1700 'source_link' => $item['author-link'],
1701 'source_photo' => $photo,
1702 'verb' => ACTIVITY_TAG,
1704 'parent' => $item['parent']
1708 $arr = array('item' => $item, 'user' => $u[0], 'contact' => $r[0]);
1710 call_hooks('tagged', $arr);
1712 if((! $community_page) && (! $prvgroup))
1716 // tgroup delivery - setup a second delivery chain
1717 // prevent delivery looping - only proceed
1718 // if the message originated elsewhere and is a top-level post
1720 if(($item['wall']) || ($item['origin']) || ($item['id'] != $item['parent']))
1723 // now change this copy of the post to a forum head message and deliver to all the tgroup members
1726 $c = q("select name, url, thumb from contact where self = 1 and uid = %d limit 1",
1727 intval($u[0]['uid'])
1732 // also reset all the privacy bits to the forum default permissions
1734 $private = ($u[0]['allow_cid'] || $u[0]['allow_gid'] || $u[0]['deny_cid'] || $u[0]['deny_gid']) ? 1 : 0;
1736 $forum_mode = (($prvgroup) ? 2 : 1);
1738 q("update item set wall = 1, origin = 1, forum_mode = %d, `owner-name` = '%s', `owner-link` = '%s', `owner-avatar` = '%s',
1739 `private` = %d, `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s' where id = %d",
1740 intval($forum_mode),
1741 dbesc($c[0]['name']),
1742 dbesc($c[0]['url']),
1743 dbesc($c[0]['thumb']),
1745 dbesc($u[0]['allow_cid']),
1746 dbesc($u[0]['allow_gid']),
1747 dbesc($u[0]['deny_cid']),
1748 dbesc($u[0]['deny_gid']),
1751 update_thread($item_id);
1753 proc_run('php','include/notifier.php','tgroup',$item_id);
1759 function tgroup_check($uid,$item) {
1765 // check that the message originated elsewhere and is a top-level post
1767 if(($item['wall']) || ($item['origin']) || ($item['uri'] != $item['parent-uri']))
1771 $u = q("select * from user where uid = %d limit 1",
1777 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1778 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1781 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1783 // Diaspora uses their own hardwired link URL in @-tags
1784 // instead of the one we supply with webfinger
1786 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1788 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1790 foreach($matches as $mtch) {
1791 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1793 logger('tgroup_check: mention found: ' . $mtch[2]);
1801 if((! $community_page) && (! $prvgroup))
1815 function dfrn_deliver($owner,$contact,$atom, $dissolve = false) {
1819 $idtosend = $orig_id = (($contact['dfrn-id']) ? $contact['dfrn-id'] : $contact['issued-id']);
1821 if($contact['duplex'] && $contact['dfrn-id'])
1822 $idtosend = '0:' . $orig_id;
1823 if($contact['duplex'] && $contact['issued-id'])
1824 $idtosend = '1:' . $orig_id;
1826 $rino = ((function_exists('mcrypt_encrypt')) ? 1 : 0);
1828 $rino_enable = get_config('system','rino_encrypt');
1833 $ssl_val = intval(get_config('system','ssl_policy'));
1837 case SSL_POLICY_FULL:
1838 $ssl_policy = 'full';
1840 case SSL_POLICY_SELFSIGN:
1841 $ssl_policy = 'self';
1843 case SSL_POLICY_NONE:
1845 $ssl_policy = 'none';
1849 $url = $contact['notify'] . '&dfrn_id=' . $idtosend . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . (($rino) ? '&rino=1' : '');
1851 logger('dfrn_deliver: ' . $url);
1853 $xml = fetch_url($url);
1855 $curl_stat = $a->get_curl_code();
1857 return(-1); // timed out
1859 logger('dfrn_deliver: ' . $xml, LOGGER_DATA);
1864 if(strpos($xml,'<?xml') === false) {
1865 logger('dfrn_deliver: no valid XML returned');
1866 logger('dfrn_deliver: returned XML: ' . $xml, LOGGER_DATA);
1870 $res = parse_xml_string($xml);
1872 if((intval($res->status) != 0) || (! strlen($res->challenge)) || (! strlen($res->dfrn_id)))
1873 return (($res->status) ? $res->status : 3);
1875 $postvars = array();
1876 $sent_dfrn_id = hex2bin((string) $res->dfrn_id);
1877 $challenge = hex2bin((string) $res->challenge);
1878 $perm = (($res->perm) ? $res->perm : null);
1879 $dfrn_version = (float) (($res->dfrn_version) ? $res->dfrn_version : 2.0);
1880 $rino_allowed = ((intval($res->rino) === 1) ? 1 : 0);
1881 $page = (($owner['page-flags'] == PAGE_COMMUNITY) ? 1 : 0);
1883 if($owner['page-flags'] == PAGE_PRVGROUP)
1886 $final_dfrn_id = '';
1889 if((($perm == 'rw') && (! intval($contact['writable'])))
1890 || (($perm == 'r') && (intval($contact['writable'])))) {
1891 q("update contact set writable = %d where id = %d",
1892 intval(($perm == 'rw') ? 1 : 0),
1893 intval($contact['id'])
1895 $contact['writable'] = (string) 1 - intval($contact['writable']);
1899 if(($contact['duplex'] && strlen($contact['pubkey']))
1900 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1901 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1902 openssl_public_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['pubkey']);
1903 openssl_public_decrypt($challenge,$postvars['challenge'],$contact['pubkey']);
1906 openssl_private_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['prvkey']);
1907 openssl_private_decrypt($challenge,$postvars['challenge'],$contact['prvkey']);
1910 $final_dfrn_id = substr($final_dfrn_id, 0, strpos($final_dfrn_id, '.'));
1912 if(strpos($final_dfrn_id,':') == 1)
1913 $final_dfrn_id = substr($final_dfrn_id,2);
1915 if($final_dfrn_id != $orig_id) {
1916 logger('dfrn_deliver: wrong dfrn_id.');
1917 // did not decode properly - cannot trust this site
1921 $postvars['dfrn_id'] = $idtosend;
1922 $postvars['dfrn_version'] = DFRN_PROTOCOL_VERSION;
1924 $postvars['dissolve'] = '1';
1927 if((($contact['rel']) && ($contact['rel'] != CONTACT_IS_SHARING) && (! $contact['blocked'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
1928 $postvars['data'] = $atom;
1929 $postvars['perm'] = 'rw';
1932 $postvars['data'] = str_replace('<dfrn:comment-allow>1','<dfrn:comment-allow>0',$atom);
1933 $postvars['perm'] = 'r';
1936 $postvars['ssl_policy'] = $ssl_policy;
1939 $postvars['page'] = $page;
1941 if($rino && $rino_allowed && (! $dissolve)) {
1942 $key = substr(random_string(),0,16);
1943 $data = bin2hex(aes_encrypt($postvars['data'],$key));
1944 $postvars['data'] = $data;
1945 logger('rino: sent key = ' . $key, LOGGER_DEBUG);
1948 if($dfrn_version >= 2.1) {
1949 if(($contact['duplex'] && strlen($contact['pubkey']))
1950 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1951 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1953 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
1956 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
1960 if(($contact['duplex'] && strlen($contact['prvkey'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
1961 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
1964 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
1968 logger('md5 rawkey ' . md5($postvars['key']));
1970 $postvars['key'] = bin2hex($postvars['key']);
1973 logger('dfrn_deliver: ' . "SENDING: " . print_r($postvars,true), LOGGER_DATA);
1975 $xml = post_url($contact['notify'],$postvars);
1977 logger('dfrn_deliver: ' . "RECEIVED: " . $xml, LOGGER_DATA);
1979 $curl_stat = $a->get_curl_code();
1980 if((! $curl_stat) || (! strlen($xml)))
1981 return(-1); // timed out
1983 if(($curl_stat == 503) && (stristr($a->get_curl_headers(),'retry-after')))
1986 if(strpos($xml,'<?xml') === false) {
1987 logger('dfrn_deliver: phase 2: no valid XML returned');
1988 logger('dfrn_deliver: phase 2: returned XML: ' . $xml, LOGGER_DATA);
1992 if($contact['term-date'] != '0000-00-00 00:00:00') {
1993 logger("dfrn_deliver: $url back from the dead - removing mark for death");
1994 require_once('include/Contact.php');
1995 unmark_for_death($contact);
1998 $res = parse_xml_string($xml);
2000 return $res->status;
2005 This function returns true if $update has an edited timestamp newer
2006 than $existing, i.e. $update contains new data which should override
2007 what's already there. If there is no timestamp yet, the update is
2008 assumed to be newer. If the update has no timestamp, the existing
2009 item is assumed to be up-to-date. If the timestamps are equal it
2010 assumes the update has been seen before and should be ignored.
2012 function edited_timestamp_is_newer($existing, $update) {
2013 if (!x($existing,'edited') || !$existing['edited']) {
2016 if (!x($update,'edited') || !$update['edited']) {
2019 $existing_edited = datetime_convert('UTC', 'UTC', $existing['edited']);
2020 $update_edited = datetime_convert('UTC', 'UTC', $update['edited']);
2021 return (strcmp($existing_edited, $update_edited) < 0);
2026 * consume_feed - process atom feed and update anything/everything we might need to update
2028 * $xml = the (atom) feed to consume - RSS isn't as fully supported but may work for simple feeds.
2030 * $importer = the contact_record (joined to user_record) of the local user who owns this relationship.
2031 * It is this person's stuff that is going to be updated.
2032 * $contact = the person who is sending us stuff. If not set, we MAY be processing a "follow" activity
2033 * from an external network and MAY create an appropriate contact record. Otherwise, we MUST
2034 * have a contact record.
2035 * $hub = should we find a hub declation in the feed, pass it back to our calling process, who might (or
2036 * might not) try and subscribe to it.
2037 * $datedir sorts in reverse order
2038 * $pass - by default ($pass = 0) we cannot guarantee that a parent item has been
2039 * imported prior to its children being seen in the stream unless we are certain
2040 * of how the feed is arranged/ordered.
2041 * With $pass = 1, we only pull parent items out of the stream.
2042 * With $pass = 2, we only pull children (comments/likes).
2044 * So running this twice, first with pass 1 and then with pass 2 will do the right
2045 * thing regardless of feed ordering. This won't be adequate in a fully-threaded
2046 * model where comments can have sub-threads. That would require some massive sorting
2047 * to get all the feed items into a mostly linear ordering, and might still require
2051 function consume_feed($xml,$importer,&$contact, &$hub, $datedir = 0, $pass = 0) {
2053 require_once('library/simplepie/simplepie.inc');
2054 require_once('include/contact_selectors.php');
2056 if(! strlen($xml)) {
2057 logger('consume_feed: empty input');
2061 $feed = new SimplePie();
2062 $feed->set_raw_data($xml);
2064 $feed->enable_order_by_date(true);
2066 $feed->enable_order_by_date(false);
2070 logger('consume_feed: Error parsing XML: ' . $feed->error());
2072 $permalink = $feed->get_permalink();
2074 // Check at the feed level for updated contact name and/or photo
2078 $photo_timestamp = '';
2082 $hubs = $feed->get_links('hub');
2083 logger('consume_feed: hubs: ' . print_r($hubs,true), LOGGER_DATA);
2086 $hub = implode(',', $hubs);
2088 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2090 $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2092 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2093 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2094 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2095 $new_name = $elems['name'][0]['data'];
2097 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2098 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2099 $photo_url = $elems['link'][0]['attribs']['']['href'];
2102 if((x($rawtags[0]['child'], NAMESPACE_DFRN)) && (x($rawtags[0]['child'][NAMESPACE_DFRN],'birthday'))) {
2103 $birthday = datetime_convert('UTC','UTC', $rawtags[0]['child'][NAMESPACE_DFRN]['birthday'][0]['data']);
2107 if((is_array($contact)) && ($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $contact['avatar-date'])) {
2108 logger('consume_feed: Updating photo for '.$contact['name'].' from '.$photo_url.' uid: '.$contact['uid']);
2109 require_once("include/Photo.php");
2110 $photo_failure = false;
2111 $have_photo = false;
2113 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2114 intval($contact['id']),
2115 intval($contact['uid'])
2118 $resource_id = $r[0]['resource-id'];
2122 $resource_id = photo_new_resource();
2125 $img_str = fetch_url($photo_url,true);
2126 // guess mimetype from headers or filename
2127 $type = guess_image_type($photo_url,true);
2130 $img = new Photo($img_str, $type);
2131 if($img->is_valid()) {
2133 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2134 dbesc($resource_id),
2135 intval($contact['id']),
2136 intval($contact['uid'])
2140 $img->scaleImageSquare(175);
2142 $hash = $resource_id;
2143 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2145 $img->scaleImage(80);
2146 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2148 $img->scaleImage(48);
2149 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2153 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2154 WHERE `uid` = %d AND `id` = %d",
2155 dbesc(datetime_convert()),
2156 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2157 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2158 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2159 intval($contact['uid']),
2160 intval($contact['id'])
2165 if((is_array($contact)) && ($name_updated) && (strlen($new_name)) && ($name_updated > $contact['name-date'])) {
2166 $r = q("select * from contact where uid = %d and id = %d limit 1",
2167 intval($contact['uid']),
2168 intval($contact['id'])
2171 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2172 dbesc(notags(trim($new_name))),
2173 dbesc(datetime_convert()),
2174 intval($contact['uid']),
2175 intval($contact['id'])
2178 // do our best to update the name on content items
2181 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2182 dbesc(notags(trim($new_name))),
2183 dbesc($r[0]['name']),
2184 dbesc($r[0]['url']),
2185 intval($contact['uid'])
2190 if(strlen($birthday)) {
2191 if(substr($birthday,0,4) != $contact['bdyear']) {
2192 logger('consume_feed: updating birthday: ' . $birthday);
2196 * Add new birthday event for this person
2198 * $bdtext is just a readable placeholder in case the event is shared
2199 * with others. We will replace it during presentation to our $importer
2200 * to contain a sparkle link and perhaps a photo.
2204 $bdtext = sprintf( t('%s\'s birthday'), $contact['name']);
2205 $bdtext2 = sprintf( t('Happy Birthday %s'), ' [url=' . $contact['url'] . ']' . $contact['name'] . '[/url]' ) ;
2208 $r = q("INSERT INTO `event` (`uid`,`cid`,`created`,`edited`,`start`,`finish`,`summary`,`desc`,`type`)
2209 VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) ",
2210 intval($contact['uid']),
2211 intval($contact['id']),
2212 dbesc(datetime_convert()),
2213 dbesc(datetime_convert()),
2214 dbesc(datetime_convert('UTC','UTC', $birthday)),
2215 dbesc(datetime_convert('UTC','UTC', $birthday . ' + 1 day ')),
2224 q("UPDATE `contact` SET `bdyear` = '%s' WHERE `uid` = %d AND `id` = %d",
2225 dbesc(substr($birthday,0,4)),
2226 intval($contact['uid']),
2227 intval($contact['id'])
2230 // This function is called twice without reloading the contact
2231 // Make sure we only create one event. This is why &$contact
2232 // is a reference var in this function
2234 $contact['bdyear'] = substr($birthday,0,4);
2239 $community_page = 0;
2240 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2242 $community_page = intval($rawtags[0]['data']);
2244 if(is_array($contact) && intval($contact['forum']) != $community_page) {
2245 q("update contact set forum = %d where id = %d",
2246 intval($community_page),
2247 intval($contact['id'])
2249 $contact['forum'] = (string) $community_page;
2253 // process any deleted entries
2255 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2256 if(is_array($del_entries) && count($del_entries) && $pass != 2) {
2257 foreach($del_entries as $dentry) {
2259 if(isset($dentry['attribs']['']['ref'])) {
2260 $uri = $dentry['attribs']['']['ref'];
2262 if(isset($dentry['attribs']['']['when'])) {
2263 $when = $dentry['attribs']['']['when'];
2264 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2267 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2269 if($deleted && is_array($contact)) {
2270 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN `contact` on `item`.`contact-id` = `contact`.`id`
2271 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
2273 intval($importer['uid']),
2274 intval($contact['id'])
2279 if(! $item['deleted'])
2280 logger('consume_feed: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
2282 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2283 $xo = parse_xml_string($item['object'],false);
2284 $xt = parse_xml_string($item['target'],false);
2285 if($xt->type === ACTIVITY_OBJ_NOTE) {
2286 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
2288 intval($importer['importer_uid'])
2292 // For tags, the owner cannot remove the tag on the author's copy of the post.
2294 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
2295 $author_remove = (($item['origin'] && $item['self']) ? true : false);
2296 $author_copy = (($item['origin']) ? true : false);
2298 if($owner_remove && $author_copy)
2300 if($author_remove || $owner_remove) {
2301 $tags = explode(',',$i[0]['tag']);
2304 foreach($tags as $tag)
2305 if(trim($tag) !== trim($xo->body))
2306 $newtags[] = trim($tag);
2308 q("update item set tag = '%s' where id = %d",
2309 dbesc(implode(',',$newtags)),
2312 create_tags_from_item($i[0]['id']);
2318 if($item['uri'] == $item['parent-uri']) {
2319 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2320 `body` = '', `title` = ''
2321 WHERE `parent-uri` = '%s' AND `uid` = %d",
2323 dbesc(datetime_convert()),
2324 dbesc($item['uri']),
2325 intval($importer['uid'])
2327 create_tags_from_itemuri($item['uri'], $importer['uid']);
2328 create_files_from_itemuri($item['uri'], $importer['uid']);
2329 update_thread_uri($item['uri'], $importer['uid']);
2332 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2333 `body` = '', `title` = ''
2334 WHERE `uri` = '%s' AND `uid` = %d",
2336 dbesc(datetime_convert()),
2338 intval($importer['uid'])
2340 create_tags_from_itemuri($uri, $importer['uid']);
2341 create_files_from_itemuri($uri, $importer['uid']);
2342 if($item['last-child']) {
2343 // ensure that last-child is set in case the comment that had it just got wiped.
2344 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
2345 dbesc(datetime_convert()),
2346 dbesc($item['parent-uri']),
2347 intval($item['uid'])
2349 // who is the last child now?
2350 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `moderated` = 0 AND `uid` = %d
2351 ORDER BY `created` DESC LIMIT 1",
2352 dbesc($item['parent-uri']),
2353 intval($importer['uid'])
2356 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
2367 // Now process the feed
2369 if($feed->get_item_quantity()) {
2371 logger('consume_feed: feed item count = ' . $feed->get_item_quantity());
2373 // in inverse date order
2375 $items = array_reverse($feed->get_items());
2377 $items = $feed->get_items();
2380 foreach($items as $item) {
2383 $item_id = $item->get_id();
2384 $rawthread = $item->get_item_tags( NAMESPACE_THREAD,'in-reply-to');
2385 if(isset($rawthread[0]['attribs']['']['ref'])) {
2387 $parent_uri = $rawthread[0]['attribs']['']['ref'];
2390 if(($is_reply) && is_array($contact)) {
2395 // not allowed to post
2397 if($contact['rel'] == CONTACT_IS_FOLLOWER)
2401 // Have we seen it? If not, import it.
2403 $item_id = $item->get_id();
2404 $datarray = get_atom_elements($feed, $item, $contact);
2406 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2407 $datarray['author-name'] = $contact['name'];
2408 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2409 $datarray['author-link'] = $contact['url'];
2410 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2411 $datarray['author-avatar'] = $contact['thumb'];
2413 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2414 logger('consume_feed: no author information! ' . print_r($datarray,true));
2418 $force_parent = false;
2419 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2420 if($contact['network'] === NETWORK_OSTATUS)
2421 $force_parent = true;
2422 if(strlen($datarray['title']))
2423 unset($datarray['title']);
2424 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2425 dbesc(datetime_convert()),
2427 intval($importer['uid'])
2429 $datarray['last-child'] = 1;
2430 update_thread_uri($parent_uri, $importer['uid']);
2434 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2436 intval($importer['uid'])
2439 // Update content if 'updated' changes
2442 if (edited_timestamp_is_newer($r[0], $datarray)) {
2444 // do not accept (ignore) an earlier edit than one we currently have.
2445 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2448 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2449 dbesc($datarray['title']),
2450 dbesc($datarray['body']),
2451 dbesc($datarray['tag']),
2452 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2453 dbesc(datetime_convert()),
2455 intval($importer['uid'])
2457 create_tags_from_itemuri($item_id, $importer['uid']);
2458 update_thread_uri($item_id, $importer['uid']);
2461 // update last-child if it changes
2463 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2464 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
2465 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2466 dbesc(datetime_convert()),
2468 intval($importer['uid'])
2470 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2471 intval($allow[0]['data']),
2472 dbesc(datetime_convert()),
2474 intval($importer['uid'])
2476 update_thread_uri($item_id, $importer['uid']);
2482 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2483 // one way feed - no remote comment ability
2484 $datarray['last-child'] = 0;
2486 $datarray['parent-uri'] = $parent_uri;
2487 $datarray['uid'] = $importer['uid'];
2488 $datarray['contact-id'] = $contact['id'];
2489 if((activity_match($datarray['verb'],ACTIVITY_LIKE)) || (activity_match($datarray['verb'],ACTIVITY_DISLIKE))) {
2490 $datarray['type'] = 'activity';
2491 $datarray['gravity'] = GRAVITY_LIKE;
2492 // only one like or dislike per person
2493 // splitted into two queries for performance issues
2494 $r = q("select id from item where uid = %d and `contact-id` = %d and verb ='%s' and deleted = 0 and (`parent-uri` = '%s') limit 1",
2495 intval($datarray['uid']),
2496 intval($datarray['contact-id']),
2497 dbesc($datarray['verb']),
2503 $r = q("select id from item where uid = %d and `contact-id` = %d and verb ='%s' and deleted = 0 and (`thr-parent` = '%s') limit 1",
2504 intval($datarray['uid']),
2505 intval($datarray['contact-id']),
2506 dbesc($datarray['verb']),
2513 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2514 $xo = parse_xml_string($datarray['object'],false);
2515 $xt = parse_xml_string($datarray['target'],false);
2517 if($xt->type == ACTIVITY_OBJ_NOTE) {
2518 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
2520 intval($importer['importer_uid'])
2525 // extract tag, if not duplicate, add to parent item
2526 if($xo->id && $xo->content) {
2527 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
2528 if(! (stristr($r[0]['tag'],$newtag))) {
2529 q("UPDATE item SET tag = '%s' WHERE id = %d",
2530 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . $newtag),
2533 create_tags_from_item($r[0]['id']);
2539 $r = item_store($datarray,$force_parent);
2545 // Head post of a conversation. Have we seen it? If not, import it.
2547 $item_id = $item->get_id();
2549 $datarray = get_atom_elements($feed, $item, $contact);
2551 if(is_array($contact)) {
2552 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2553 $datarray['author-name'] = $contact['name'];
2554 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2555 $datarray['author-link'] = $contact['url'];
2556 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2557 $datarray['author-avatar'] = $contact['thumb'];
2560 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2561 logger('consume_feed: no author information! ' . print_r($datarray,true));
2565 // special handling for events
2567 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
2568 $ev = bbtoevent($datarray['body']);
2569 if(x($ev,'desc') && x($ev,'start')) {
2570 $ev['uid'] = $importer['uid'];
2571 $ev['uri'] = $item_id;
2572 $ev['edited'] = $datarray['edited'];
2573 $ev['private'] = $datarray['private'];
2575 if(is_array($contact))
2576 $ev['cid'] = $contact['id'];
2577 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2579 intval($importer['uid'])
2582 $ev['id'] = $r[0]['id'];
2583 $xyz = event_store($ev);
2588 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2589 if(strlen($datarray['title']))
2590 unset($datarray['title']);
2591 $datarray['last-child'] = 1;
2595 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2597 intval($importer['uid'])
2600 // Update content if 'updated' changes
2603 if (edited_timestamp_is_newer($r[0], $datarray)) {
2605 // do not accept (ignore) an earlier edit than one we currently have.
2606 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2609 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2610 dbesc($datarray['title']),
2611 dbesc($datarray['body']),
2612 dbesc($datarray['tag']),
2613 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2614 dbesc(datetime_convert()),
2616 intval($importer['uid'])
2618 create_tags_from_itemuri($item_id, $importer['uid']);
2619 update_thread_uri($item_id, $importer['uid']);
2622 // update last-child if it changes
2624 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2625 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
2626 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2627 intval($allow[0]['data']),
2628 dbesc(datetime_convert()),
2630 intval($importer['uid'])
2632 update_thread_uri($item_id, $importer['uid']);
2637 if(activity_match($datarray['verb'],ACTIVITY_FOLLOW)) {
2638 logger('consume-feed: New follower');
2639 new_follower($importer,$contact,$datarray,$item);
2642 if(activity_match($datarray['verb'],ACTIVITY_UNFOLLOW)) {
2643 lose_follower($importer,$contact,$datarray,$item);
2647 if(activity_match($datarray['verb'],ACTIVITY_REQ_FRIEND)) {
2648 logger('consume-feed: New friend request');
2649 new_follower($importer,$contact,$datarray,$item,true);
2652 if(activity_match($datarray['verb'],ACTIVITY_UNFRIEND)) {
2653 lose_sharer($importer,$contact,$datarray,$item);
2658 if(! is_array($contact))
2662 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2663 // one way feed - no remote comment ability
2664 $datarray['last-child'] = 0;
2666 if($contact['network'] === NETWORK_FEED)
2667 $datarray['private'] = 2;
2669 $datarray['parent-uri'] = $item_id;
2670 $datarray['uid'] = $importer['uid'];
2671 $datarray['contact-id'] = $contact['id'];
2673 if(! link_compare($datarray['owner-link'],$contact['url'])) {
2674 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
2675 // but otherwise there's a possible data mixup on the sender's system.
2676 // the tgroup delivery code called from item_store will correct it if it's a forum,
2677 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
2678 logger('consume_feed: Correcting item owner.', LOGGER_DEBUG);
2679 $datarray['owner-name'] = $contact['name'];
2680 $datarray['owner-link'] = $contact['url'];
2681 $datarray['owner-avatar'] = $contact['thumb'];
2684 // We've allowed "followers" to reach this point so we can decide if they are
2685 // posting an @-tag delivery, which followers are allowed to do for certain
2686 // page types. Now that we've parsed the post, let's check if it is legit. Otherwise ignore it.
2688 if(($contact['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['uid'],$datarray)))
2691 // This is my contact on another system, but it's really me.
2692 // Turn this into a wall post.
2693 $notify = item_is_remote_self($contact, $datarray);
2695 $r = item_store($datarray, false, $notify);
2696 logger('Stored - Contact '.$contact['url'].' Notify '.$notify.' return '.$r.' Item '.print_r($datarray, true), LOGGER_DEBUG);
2704 function item_is_remote_self($contact, &$datarray) {
2707 if (!$contact['remote_self'])
2710 // Prevent the forwarding of posts that are forwarded
2711 if ($datarray["extid"] == NETWORK_DFRN)
2714 // Prevent to forward already forwarded posts
2715 if ($datarray["app"] == $a->get_hostname())
2718 if (($contact['network'] != NETWORK_FEED) AND $datarray['private'])
2721 $datarray2 = $datarray;
2722 logger('remote-self start - Contact '.$contact['url'].' - '.$contact['remote_self'].' Item '.print_r($datarray, true), LOGGER_DEBUG);
2723 if ($contact['remote_self'] == 2) {
2724 $r = q("SELECT `id`,`url`,`name`,`thumb` FROM `contact` WHERE `uid` = %d AND `self`",
2725 intval($contact['uid']));
2727 $datarray['contact-id'] = $r[0]["id"];
2729 $datarray['owner-name'] = $r[0]["name"];
2730 $datarray['owner-link'] = $r[0]["url"];
2731 $datarray['owner-avatar'] = $r[0]["thumb"];
2733 $datarray['author-name'] = $datarray['owner-name'];
2734 $datarray['author-link'] = $datarray['owner-link'];
2735 $datarray['author-avatar'] = $datarray['owner-avatar'];
2738 if ($contact['network'] != NETWORK_FEED) {
2739 $datarray["guid"] = get_guid(32);
2740 unset($datarray["plink"]);
2741 $datarray["uri"] = item_new_uri($a->get_hostname(),$contact['uid']);
2742 $datarray["parent-uri"] = $datarray["uri"];
2743 $datarray["extid"] = $contact['network'];
2744 $urlpart = parse_url($datarray2['author-link']);
2745 $datarray["app"] = $urlpart["host"];
2747 $datarray['private'] = 0;
2750 //if (!isset($datarray["app"]) OR ($datarray["app"] == ""))
2751 // $datarray["app"] = network_to_name($contact['network']);
2753 if ($contact['network'] != NETWORK_FEED) {
2754 // Store the original post
2755 $r = item_store($datarray2, false, false);
2756 logger('remote-self post original item - Contact '.$contact['url'].' return '.$r.' Item '.print_r($datarray2, true), LOGGER_DEBUG);
2758 $datarray["app"] = "Feed";
2763 function local_delivery($importer,$data) {
2766 logger(__function__, LOGGER_TRACE);
2768 if($importer['readonly']) {
2769 // We aren't receiving stuff from this person. But we will quietly ignore them
2770 // rather than a blatant "go away" message.
2771 logger('local_delivery: ignoring');
2776 // Consume notification feed. This may differ from consuming a public feed in several ways
2777 // - might contain email or friend suggestions
2778 // - might contain remote followup to our message
2779 // - in which case we need to accept it and then notify other conversants
2780 // - we may need to send various email notifications
2782 $feed = new SimplePie();
2783 $feed->set_raw_data($data);
2784 $feed->enable_order_by_date(false);
2789 logger('local_delivery: Error parsing XML: ' . $feed->error());
2792 // Check at the feed level for updated contact name and/or photo
2796 $photo_timestamp = '';
2800 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2802 // Fallback should not be needed here. If it isn't DFRN it won't have DFRN updated tags
2804 // $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2807 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2808 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2809 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2810 $new_name = $elems['name'][0]['data'];
2812 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2813 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2814 $photo_url = $elems['link'][0]['attribs']['']['href'];
2818 if(($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $importer['avatar-date'])) {
2819 logger('local_delivery: Updating photo for ' . $importer['name']);
2820 require_once("include/Photo.php");
2821 $photo_failure = false;
2822 $have_photo = false;
2824 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2825 intval($importer['id']),
2826 intval($importer['importer_uid'])
2829 $resource_id = $r[0]['resource-id'];
2833 $resource_id = photo_new_resource();
2836 $img_str = fetch_url($photo_url,true);
2837 // guess mimetype from headers or filename
2838 $type = guess_image_type($photo_url,true);
2841 $img = new Photo($img_str, $type);
2842 if($img->is_valid()) {
2844 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2845 dbesc($resource_id),
2846 intval($importer['id']),
2847 intval($importer['importer_uid'])
2851 $img->scaleImageSquare(175);
2853 $hash = $resource_id;
2854 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2856 $img->scaleImage(80);
2857 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2859 $img->scaleImage(48);
2860 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2864 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2865 WHERE `uid` = %d AND `id` = %d",
2866 dbesc(datetime_convert()),
2867 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2868 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2869 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2870 intval($importer['importer_uid']),
2871 intval($importer['id'])
2876 if(($name_updated) && (strlen($new_name)) && ($name_updated > $importer['name-date'])) {
2877 $r = q("select * from contact where uid = %d and id = %d limit 1",
2878 intval($importer['importer_uid']),
2879 intval($importer['id'])
2882 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2883 dbesc(notags(trim($new_name))),
2884 dbesc(datetime_convert()),
2885 intval($importer['importer_uid']),
2886 intval($importer['id'])
2889 // do our best to update the name on content items
2892 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2893 dbesc(notags(trim($new_name))),
2894 dbesc($r[0]['name']),
2895 dbesc($r[0]['url']),
2896 intval($importer['importer_uid'])
2903 // Currently unsupported - needs a lot of work
2904 $reloc = $feed->get_feed_tags( NAMESPACE_DFRN, 'relocate' );
2905 if(isset($reloc[0]['child'][NAMESPACE_DFRN])) {
2906 $base = $reloc[0]['child'][NAMESPACE_DFRN];
2908 $newloc['uid'] = $importer['importer_uid'];
2909 $newloc['cid'] = $importer['id'];
2910 $newloc['name'] = notags(unxmlify($base['name'][0]['data']));
2911 $newloc['photo'] = notags(unxmlify($base['photo'][0]['data']));
2912 $newloc['thumb'] = notags(unxmlify($base['thumb'][0]['data']));
2913 $newloc['micro'] = notags(unxmlify($base['micro'][0]['data']));
2914 $newloc['url'] = notags(unxmlify($base['url'][0]['data']));
2915 $newloc['request'] = notags(unxmlify($base['request'][0]['data']));
2916 $newloc['confirm'] = notags(unxmlify($base['confirm'][0]['data']));
2917 $newloc['notify'] = notags(unxmlify($base['notify'][0]['data']));
2918 $newloc['poll'] = notags(unxmlify($base['poll'][0]['data']));
2919 $newloc['sitepubkey'] = notags(unxmlify($base['sitepubkey'][0]['data']));
2920 /** relocated user must have original key pair */
2921 /*$newloc['pubkey'] = notags(unxmlify($base['pubkey'][0]['data']));
2922 $newloc['prvkey'] = notags(unxmlify($base['prvkey'][0]['data']));*/
2924 logger("items:relocate contact ".print_r($newloc, true).print_r($importer, true), LOGGER_DEBUG);
2927 $r = q("SELECT photo, url FROM contact WHERE id=%d AND uid=%d;",
2928 intval($importer['id']),
2929 intval($importer['importer_uid']));
2934 $x = q("UPDATE contact SET
2944 `site-pubkey` = '%s'
2945 WHERE id=%d AND uid=%d;",
2946 dbesc($newloc['name']),
2947 dbesc($newloc['photo']),
2948 dbesc($newloc['thumb']),
2949 dbesc($newloc['micro']),
2950 dbesc($newloc['url']),
2951 dbesc($newloc['request']),
2952 dbesc($newloc['confirm']),
2953 dbesc($newloc['notify']),
2954 dbesc($newloc['poll']),
2955 dbesc($newloc['sitepubkey']),
2956 intval($importer['id']),
2957 intval($importer['importer_uid']));
2963 'owner-link' => array($old['url'], $newloc['url']),
2964 'author-link' => array($old['url'], $newloc['url']),
2965 'owner-avatar' => array($old['photo'], $newloc['photo']),
2966 'author-avatar' => array($old['photo'], $newloc['photo']),
2968 foreach ($fields as $n=>$f){
2969 $x = q("UPDATE `item` SET `%s`='%s' WHERE `%s`='%s' AND uid=%d",
2972 intval($importer['importer_uid']));
2978 // merge with current record, current contents have priority
2979 // update record, set url-updated
2980 // update profile photos
2986 // handle friend suggestion notification
2988 $sugg = $feed->get_feed_tags( NAMESPACE_DFRN, 'suggest' );
2989 if(isset($sugg[0]['child'][NAMESPACE_DFRN])) {
2990 $base = $sugg[0]['child'][NAMESPACE_DFRN];
2992 $fsugg['uid'] = $importer['importer_uid'];
2993 $fsugg['cid'] = $importer['id'];
2994 $fsugg['name'] = notags(unxmlify($base['name'][0]['data']));
2995 $fsugg['photo'] = notags(unxmlify($base['photo'][0]['data']));
2996 $fsugg['url'] = notags(unxmlify($base['url'][0]['data']));
2997 $fsugg['request'] = notags(unxmlify($base['request'][0]['data']));
2998 $fsugg['body'] = escape_tags(unxmlify($base['note'][0]['data']));
3000 // Does our member already have a friend matching this description?
3002 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `nurl` = '%s' AND `uid` = %d LIMIT 1",
3003 dbesc($fsugg['name']),
3004 dbesc(normalise_link($fsugg['url'])),
3005 intval($fsugg['uid'])
3010 // Do we already have an fcontact record for this person?
3013 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
3014 dbesc($fsugg['url']),
3015 dbesc($fsugg['name']),
3016 dbesc($fsugg['request'])
3021 // OK, we do. Do we already have an introduction for this person ?
3022 $r = q("select id from intro where uid = %d and fid = %d limit 1",
3023 intval($fsugg['uid']),
3030 $r = q("INSERT INTO `fcontact` ( `name`,`url`,`photo`,`request` ) VALUES ( '%s', '%s', '%s', '%s' ) ",
3031 dbesc($fsugg['name']),
3032 dbesc($fsugg['url']),
3033 dbesc($fsugg['photo']),
3034 dbesc($fsugg['request'])
3036 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
3037 dbesc($fsugg['url']),
3038 dbesc($fsugg['name']),
3039 dbesc($fsugg['request'])
3044 // database record did not get created. Quietly give up.
3049 $hash = random_string();
3051 $r = q("INSERT INTO `intro` ( `uid`, `fid`, `contact-id`, `note`, `hash`, `datetime`, `blocked` )
3052 VALUES( %d, %d, %d, '%s', '%s', '%s', %d )",
3053 intval($fsugg['uid']),
3055 intval($fsugg['cid']),
3056 dbesc($fsugg['body']),
3058 dbesc(datetime_convert()),
3063 'type' => NOTIFY_SUGGEST,
3064 'notify_flags' => $importer['notify-flags'],
3065 'language' => $importer['language'],
3066 'to_name' => $importer['username'],
3067 'to_email' => $importer['email'],
3068 'uid' => $importer['importer_uid'],
3070 'link' => $a->get_baseurl() . '/notifications/intros',
3071 'source_name' => $importer['name'],
3072 'source_link' => $importer['url'],
3073 'source_photo' => $importer['photo'],
3074 'verb' => ACTIVITY_REQ_FRIEND,
3083 $rawmail = $feed->get_feed_tags( NAMESPACE_DFRN, 'mail' );
3084 if(isset($rawmail[0]['child'][NAMESPACE_DFRN])) {
3086 logger('local_delivery: private message received');
3089 $base = $rawmail[0]['child'][NAMESPACE_DFRN];
3092 $msg['uid'] = $importer['importer_uid'];
3093 $msg['from-name'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['name'][0]['data']));
3094 $msg['from-photo'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['avatar'][0]['data']));
3095 $msg['from-url'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['uri'][0]['data']));
3096 $msg['contact-id'] = $importer['id'];
3097 $msg['title'] = notags(unxmlify($base['subject'][0]['data']));
3098 $msg['body'] = escape_tags(unxmlify($base['content'][0]['data']));
3100 $msg['replied'] = 0;
3101 $msg['uri'] = notags(unxmlify($base['id'][0]['data']));
3102 $msg['parent-uri'] = notags(unxmlify($base['in-reply-to'][0]['data']));
3103 $msg['created'] = datetime_convert(notags(unxmlify('UTC','UTC',$base['sentdate'][0]['data'])));
3107 $r = dbq("INSERT INTO `mail` (`" . implode("`, `", array_keys($msg))
3108 . "`) VALUES ('" . implode("', '", array_values($msg)) . "')" );
3110 // send notifications.
3112 require_once('include/enotify.php');
3114 $notif_params = array(
3115 'type' => NOTIFY_MAIL,
3116 'notify_flags' => $importer['notify-flags'],
3117 'language' => $importer['language'],
3118 'to_name' => $importer['username'],
3119 'to_email' => $importer['email'],
3120 'uid' => $importer['importer_uid'],
3122 'source_name' => $msg['from-name'],
3123 'source_link' => $importer['url'],
3124 'source_photo' => $importer['thumb'],
3125 'verb' => ACTIVITY_POST,
3129 notification($notif_params);
3135 $community_page = 0;
3136 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
3138 $community_page = intval($rawtags[0]['data']);
3140 if(intval($importer['forum']) != $community_page) {
3141 q("update contact set forum = %d where id = %d",
3142 intval($community_page),
3143 intval($importer['id'])
3145 $importer['forum'] = (string) $community_page;
3148 logger('local_delivery: feed item count = ' . $feed->get_item_quantity());
3150 // process any deleted entries
3152 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
3153 if(is_array($del_entries) && count($del_entries)) {
3154 foreach($del_entries as $dentry) {
3156 if(isset($dentry['attribs']['']['ref'])) {
3157 $uri = $dentry['attribs']['']['ref'];
3159 if(isset($dentry['attribs']['']['when'])) {
3160 $when = $dentry['attribs']['']['when'];
3161 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
3164 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
3168 // check for relayed deletes to our conversation
3171 $r = q("select * from item where uri = '%s' and uid = %d limit 1",
3173 intval($importer['importer_uid'])
3176 $parent_uri = $r[0]['parent-uri'];
3177 if($r[0]['id'] != $r[0]['parent'])
3184 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3187 logger('local_delivery: possible community delete');
3190 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3192 // was the top-level post for this reply written by somebody on this site?
3193 // Specifically, the recipient?
3195 $is_a_remote_delete = false;
3197 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3198 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3199 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3200 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3201 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3202 AND `item`.`uid` = %d
3208 intval($importer['importer_uid'])
3211 $is_a_remote_delete = true;
3213 // Does this have the characteristics of a community or private group comment?
3214 // If it's a reply to a wall post on a community/prvgroup page it's a
3215 // valid community comment. Also forum_mode makes it valid for sure.
3216 // If neither, it's not.
3218 if($is_a_remote_delete && $community) {
3219 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3220 $is_a_remote_delete = false;
3221 logger('local_delivery: not a community delete');
3225 if($is_a_remote_delete) {
3226 logger('local_delivery: received remote delete');
3230 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN contact on `item`.`contact-id` = `contact`.`id`
3231 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
3233 intval($importer['importer_uid']),
3234 intval($importer['id'])
3240 if($item['deleted'])
3243 logger('local_delivery: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
3245 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3246 $xo = parse_xml_string($item['object'],false);
3247 $xt = parse_xml_string($item['target'],false);
3249 if($xt->type === ACTIVITY_OBJ_NOTE) {
3250 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
3252 intval($importer['importer_uid'])
3256 // For tags, the owner cannot remove the tag on the author's copy of the post.
3258 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
3259 $author_remove = (($item['origin'] && $item['self']) ? true : false);
3260 $author_copy = (($item['origin']) ? true : false);
3262 if($owner_remove && $author_copy)
3264 if($author_remove || $owner_remove) {
3265 $tags = explode(',',$i[0]['tag']);
3268 foreach($tags as $tag)
3269 if(trim($tag) !== trim($xo->body))
3270 $newtags[] = trim($tag);
3272 q("update item set tag = '%s' where id = %d",
3273 dbesc(implode(',',$newtags)),
3276 create_tags_from_item($i[0]['id']);
3282 if($item['uri'] == $item['parent-uri']) {
3283 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3284 `body` = '', `title` = ''
3285 WHERE `parent-uri` = '%s' AND `uid` = %d",
3287 dbesc(datetime_convert()),
3288 dbesc($item['uri']),
3289 intval($importer['importer_uid'])
3291 create_tags_from_itemuri($item['uri'], $importer['importer_uid']);
3292 create_files_from_itemuri($item['uri'], $importer['importer_uid']);
3293 update_thread_uri($item['uri'], $importer['importer_uid']);
3296 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3297 `body` = '', `title` = ''
3298 WHERE `uri` = '%s' AND `uid` = %d",
3300 dbesc(datetime_convert()),
3302 intval($importer['importer_uid'])
3304 create_tags_from_itemuri($uri, $importer['importer_uid']);
3305 create_files_from_itemuri($uri, $importer['importer_uid']);
3306 update_thread_uri($uri, $importer['importer_uid']);
3307 if($item['last-child']) {
3308 // ensure that last-child is set in case the comment that had it just got wiped.
3309 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
3310 dbesc(datetime_convert()),
3311 dbesc($item['parent-uri']),
3312 intval($item['uid'])
3314 // who is the last child now?
3315 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d
3316 ORDER BY `created` DESC LIMIT 1",
3317 dbesc($item['parent-uri']),
3318 intval($importer['importer_uid'])
3321 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
3326 // if this is a relayed delete, propagate it to other recipients
3328 if($is_a_remote_delete)
3329 proc_run('php',"include/notifier.php","drop",$item['id']);
3337 foreach($feed->get_items() as $item) {
3340 $item_id = $item->get_id();
3341 $rawthread = $item->get_item_tags( NAMESPACE_THREAD, 'in-reply-to');
3342 if(isset($rawthread[0]['attribs']['']['ref'])) {
3344 $parent_uri = $rawthread[0]['attribs']['']['ref'];
3350 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3353 logger('local_delivery: possible community reply');
3356 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3358 // was the top-level post for this reply written by somebody on this site?
3359 // Specifically, the recipient?
3361 $is_a_remote_comment = false;
3362 $top_uri = $parent_uri;
3364 $r = q("select `item`.`parent-uri` from `item`
3365 WHERE `item`.`uri` = '%s'
3369 if($r && count($r)) {
3370 $top_uri = $r[0]['parent-uri'];
3372 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3373 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3374 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3375 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3376 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3377 AND `item`.`uid` = %d
3383 intval($importer['importer_uid'])
3386 $is_a_remote_comment = true;
3389 // Does this have the characteristics of a community or private group comment?
3390 // If it's a reply to a wall post on a community/prvgroup page it's a
3391 // valid community comment. Also forum_mode makes it valid for sure.
3392 // If neither, it's not.
3394 if($is_a_remote_comment && $community) {
3395 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3396 $is_a_remote_comment = false;
3397 logger('local_delivery: not a community reply');
3401 if($is_a_remote_comment) {
3402 logger('local_delivery: received remote comment');
3404 // remote reply to our post. Import and then notify everybody else.
3406 $datarray = get_atom_elements($feed, $item);
3408 $r = q("SELECT `id`, `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3410 intval($importer['importer_uid'])
3413 // Update content if 'updated' changes
3417 if (edited_timestamp_is_newer($r[0], $datarray)) {
3419 // do not accept (ignore) an earlier edit than one we currently have.
3420 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3423 logger('received updated comment' , LOGGER_DEBUG);
3424 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3425 dbesc($datarray['title']),
3426 dbesc($datarray['body']),
3427 dbesc($datarray['tag']),
3428 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3429 dbesc(datetime_convert()),
3431 intval($importer['importer_uid'])
3433 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3435 proc_run('php',"include/notifier.php","comment-import",$iid);
3444 $own = q("select name,url,thumb from contact where uid = %d and self = 1 limit 1",
3445 intval($importer['importer_uid'])
3449 $datarray['type'] = 'remote-comment';
3450 $datarray['wall'] = 1;
3451 $datarray['parent-uri'] = $parent_uri;
3452 $datarray['uid'] = $importer['importer_uid'];
3453 $datarray['owner-name'] = $own[0]['name'];
3454 $datarray['owner-link'] = $own[0]['url'];
3455 $datarray['owner-avatar'] = $own[0]['thumb'];
3456 $datarray['contact-id'] = $importer['id'];
3458 if(($datarray['verb'] === ACTIVITY_LIKE) || ($datarray['verb'] === ACTIVITY_DISLIKE)) {
3460 $datarray['type'] = 'activity';
3461 $datarray['gravity'] = GRAVITY_LIKE;
3462 $datarray['last-child'] = 0;
3463 // only one like or dislike per person
3464 // splitted into two queries for performance issues
3465 $r = q("select id from item where uid = %d and `contact-id` = %d and verb = '%s' and (`parent-uri` = '%s') and deleted = 0 limit 1",
3466 intval($datarray['uid']),
3467 intval($datarray['contact-id']),
3468 dbesc($datarray['verb']),
3469 dbesc($datarray['parent-uri'])
3475 $r = q("select id from item where uid = %d and `contact-id` = %d and verb = '%s' and (`thr-parent` = '%s') and deleted = 0 limit 1",
3476 intval($datarray['uid']),
3477 intval($datarray['contact-id']),
3478 dbesc($datarray['verb']),
3479 dbesc($datarray['parent-uri'])
3486 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3488 $xo = parse_xml_string($datarray['object'],false);
3489 $xt = parse_xml_string($datarray['target'],false);
3491 if(($xt->type == ACTIVITY_OBJ_NOTE) && ($xt->id)) {
3493 // fetch the parent item
3495 $tagp = q("select * from item where uri = '%s' and uid = %d limit 1",
3497 intval($importer['importer_uid'])
3502 // extract tag, if not duplicate, and this user allows tags, add to parent item
3504 if($xo->id && $xo->content) {
3505 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
3506 if(! (stristr($tagp[0]['tag'],$newtag))) {
3507 $i = q("SELECT `blocktags` FROM `user` where `uid` = %d LIMIT 1",
3508 intval($importer['importer_uid'])
3510 if(count($i) && ! intval($i[0]['blocktags'])) {
3511 q("UPDATE item SET tag = '%s', `edited` = '%s', `changed` = '%s' WHERE id = %d",
3512 dbesc($tagp[0]['tag'] . (strlen($tagp[0]['tag']) ? ',' : '') . $newtag),
3513 intval($tagp[0]['id']),
3514 dbesc(datetime_convert()),
3515 dbesc(datetime_convert())
3517 create_tags_from_item($tagp[0]['id']);
3525 $posted_id = item_store($datarray);
3529 $r = q("SELECT `parent`, `parent-uri` FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3531 intval($importer['importer_uid'])
3534 $parent = $r[0]['parent'];
3535 $parent_uri = $r[0]['parent-uri'];
3539 $r1 = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `uid` = %d AND `parent` = %d",
3540 dbesc(datetime_convert()),
3541 intval($importer['importer_uid']),
3542 intval($r[0]['parent'])
3545 $r2 = q("UPDATE `item` SET `last-child` = 1, `changed` = '%s' WHERE `uid` = %d AND `id` = %d",
3546 dbesc(datetime_convert()),
3547 intval($importer['importer_uid']),
3552 if($posted_id && $parent) {
3554 proc_run('php',"include/notifier.php","comment-import","$posted_id");
3556 if((! $is_like) && (! $importer['self'])) {
3558 require_once('include/enotify.php');
3561 'type' => NOTIFY_COMMENT,
3562 'notify_flags' => $importer['notify-flags'],
3563 'language' => $importer['language'],
3564 'to_name' => $importer['username'],
3565 'to_email' => $importer['email'],
3566 'uid' => $importer['importer_uid'],
3567 'item' => $datarray,
3568 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3569 'source_name' => stripslashes($datarray['author-name']),
3570 'source_link' => $datarray['author-link'],
3571 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3572 ? $importer['thumb'] : $datarray['author-avatar']),
3573 'verb' => ACTIVITY_POST,
3575 'parent' => $parent,
3576 'parent_uri' => $parent_uri,
3588 // regular comment that is part of this total conversation. Have we seen it? If not, import it.
3590 $item_id = $item->get_id();
3591 $datarray = get_atom_elements($feed,$item);
3593 if($importer['rel'] == CONTACT_IS_FOLLOWER)
3596 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3598 intval($importer['importer_uid'])
3601 // Update content if 'updated' changes
3604 if (edited_timestamp_is_newer($r[0], $datarray)) {
3606 // do not accept (ignore) an earlier edit than one we currently have.
3607 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3610 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3611 dbesc($datarray['title']),
3612 dbesc($datarray['body']),
3613 dbesc($datarray['tag']),
3614 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3615 dbesc(datetime_convert()),
3617 intval($importer['importer_uid'])
3619 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3622 // update last-child if it changes
3624 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3625 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
3626 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
3627 dbesc(datetime_convert()),
3629 intval($importer['importer_uid'])
3631 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3632 intval($allow[0]['data']),
3633 dbesc(datetime_convert()),
3635 intval($importer['importer_uid'])
3641 $datarray['parent-uri'] = $parent_uri;
3642 $datarray['uid'] = $importer['importer_uid'];
3643 $datarray['contact-id'] = $importer['id'];
3644 if(($datarray['verb'] == ACTIVITY_LIKE) || ($datarray['verb'] == ACTIVITY_DISLIKE)) {
3645 $datarray['type'] = 'activity';
3646 $datarray['gravity'] = GRAVITY_LIKE;
3647 // only one like or dislike per person
3648 // splitted into two queries for performance issues
3649 $r = q("select id from item where uid = %d and `contact-id` = %d and verb ='%s' and deleted = 0 and (`parent-uri` = '%s') limit 1",
3650 intval($datarray['uid']),
3651 intval($datarray['contact-id']),
3652 dbesc($datarray['verb']),
3658 $r = q("select id from item where uid = %d and `contact-id` = %d and verb ='%s' and deleted = 0 and (`thr-parent` = '%s') limit 1",
3659 intval($datarray['uid']),
3660 intval($datarray['contact-id']),
3661 dbesc($datarray['verb']),
3669 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3671 $xo = parse_xml_string($datarray['object'],false);
3672 $xt = parse_xml_string($datarray['target'],false);
3674 if($xt->type == ACTIVITY_OBJ_NOTE) {
3675 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
3677 intval($importer['importer_uid'])
3682 // extract tag, if not duplicate, add to parent item
3684 if(! (stristr($r[0]['tag'],trim($xo->content)))) {
3685 q("UPDATE item SET tag = '%s' WHERE id = %d",
3686 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]'),
3689 create_tags_from_item($r[0]['id']);
3695 $posted_id = item_store($datarray);
3697 // find out if our user is involved in this conversation and wants to be notified.
3699 if(!x($datarray['type']) || $datarray['type'] != 'activity') {
3701 $myconv = q("SELECT `author-link`, `author-avatar`, `parent` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `parent` != 0 AND `deleted` = 0",
3703 intval($importer['importer_uid'])
3706 if(count($myconv)) {
3707 $importer_url = $a->get_baseurl() . '/profile/' . $importer['nickname'];
3709 // first make sure this isn't our own post coming back to us from a wall-to-wall event
3710 if(! link_compare($datarray['author-link'],$importer_url)) {
3713 foreach($myconv as $conv) {
3715 // now if we find a match, it means we're in this conversation
3717 if(! link_compare($conv['author-link'],$importer_url))
3720 require_once('include/enotify.php');
3722 $conv_parent = $conv['parent'];
3725 'type' => NOTIFY_COMMENT,
3726 'notify_flags' => $importer['notify-flags'],
3727 'language' => $importer['language'],
3728 'to_name' => $importer['username'],
3729 'to_email' => $importer['email'],
3730 'uid' => $importer['importer_uid'],
3731 'item' => $datarray,
3732 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3733 'source_name' => stripslashes($datarray['author-name']),
3734 'source_link' => $datarray['author-link'],
3735 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3736 ? $importer['thumb'] : $datarray['author-avatar']),
3737 'verb' => ACTIVITY_POST,
3739 'parent' => $conv_parent,
3740 'parent_uri' => $parent_uri
3744 // only send one notification
3756 // Head post of a conversation. Have we seen it? If not, import it.
3759 $item_id = $item->get_id();
3760 $datarray = get_atom_elements($feed,$item);
3762 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
3763 $ev = bbtoevent($datarray['body']);
3764 if(x($ev,'desc') && x($ev,'start')) {
3765 $ev['cid'] = $importer['id'];
3766 $ev['uid'] = $importer['uid'];
3767 $ev['uri'] = $item_id;
3768 $ev['edited'] = $datarray['edited'];
3769 $ev['private'] = $datarray['private'];
3771 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3773 intval($importer['uid'])
3776 $ev['id'] = $r[0]['id'];
3777 $xyz = event_store($ev);
3782 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3784 intval($importer['importer_uid'])
3787 // Update content if 'updated' changes
3790 if (edited_timestamp_is_newer($r[0], $datarray)) {
3792 // do not accept (ignore) an earlier edit than one we currently have.
3793 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3796 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3797 dbesc($datarray['title']),
3798 dbesc($datarray['body']),
3799 dbesc($datarray['tag']),
3800 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3801 dbesc(datetime_convert()),
3803 intval($importer['importer_uid'])
3805 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3806 update_thread_uri($item_id, $importer['importer_uid']);
3809 // update last-child if it changes
3811 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3812 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
3813 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3814 intval($allow[0]['data']),
3815 dbesc(datetime_convert()),
3817 intval($importer['importer_uid'])
3823 $datarray['parent-uri'] = $item_id;
3824 $datarray['uid'] = $importer['importer_uid'];
3825 $datarray['contact-id'] = $importer['id'];
3828 if(! link_compare($datarray['owner-link'],$importer['url'])) {
3829 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
3830 // but otherwise there's a possible data mixup on the sender's system.
3831 // the tgroup delivery code called from item_store will correct it if it's a forum,
3832 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
3833 logger('local_delivery: Correcting item owner.', LOGGER_DEBUG);
3834 $datarray['owner-name'] = $importer['senderName'];
3835 $datarray['owner-link'] = $importer['url'];
3836 $datarray['owner-avatar'] = $importer['thumb'];
3839 if(($importer['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['importer_uid'],$datarray)))
3842 // This is my contact on another system, but it's really me.
3843 // Turn this into a wall post.
3844 $notify = item_is_remote_self($importer, $datarray);
3846 $posted_id = item_store($datarray, false, $notify);
3848 if(stristr($datarray['verb'],ACTIVITY_POKE)) {
3849 $verb = urldecode(substr($datarray['verb'],strpos($datarray['verb'],'#')+1));
3852 $xo = parse_xml_string($datarray['object'],false);
3854 if(($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
3856 // somebody was poked/prodded. Was it me?
3858 $links = parse_xml_string("<links>".unxmlify($xo->link)."</links>",false);
3860 foreach($links->link as $l) {
3861 $atts = $l->attributes();
3862 switch($atts['rel']) {
3864 $Blink = $atts['href'];
3870 if($Blink && link_compare($Blink,$a->get_baseurl() . '/profile/' . $importer['nickname'])) {
3872 // send a notification
3873 require_once('include/enotify.php');
3876 'type' => NOTIFY_POKE,
3877 'notify_flags' => $importer['notify-flags'],
3878 'language' => $importer['language'],
3879 'to_name' => $importer['username'],
3880 'to_email' => $importer['email'],
3881 'uid' => $importer['importer_uid'],
3882 'item' => $datarray,
3883 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3884 'source_name' => stripslashes($datarray['author-name']),
3885 'source_link' => $datarray['author-link'],
3886 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3887 ? $importer['thumb'] : $datarray['author-avatar']),
3888 'verb' => $datarray['verb'],
3889 'otype' => 'person',
3890 'activity' => $verb,
3907 function new_follower($importer,$contact,$datarray,$item,$sharing = false) {
3908 $url = notags(trim($datarray['author-link']));
3909 $name = notags(trim($datarray['author-name']));
3910 $photo = notags(trim($datarray['author-avatar']));
3912 $rawtag = $item->get_item_tags(NAMESPACE_ACTIVITY,'actor');
3913 if($rawtag && $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'])
3914 $nick = $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'];
3916 if(is_array($contact)) {
3917 if(($contact['network'] == NETWORK_OSTATUS && $contact['rel'] == CONTACT_IS_SHARING)
3918 || ($sharing && $contact['rel'] == CONTACT_IS_FOLLOWER)) {
3919 $r = q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
3920 intval(CONTACT_IS_FRIEND),
3921 intval($contact['id']),
3922 intval($importer['uid'])
3925 // send email notification to owner?
3929 // create contact record
3931 $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `name`, `nick`, `photo`, `network`, `rel`,
3932 `blocked`, `readonly`, `pending`, `writable` )
3933 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, 1 ) ",
3934 intval($importer['uid']),
3935 dbesc(datetime_convert()),
3937 dbesc(normalise_link($url)),
3941 dbesc(($sharing) ? NETWORK_ZOT : NETWORK_OSTATUS),
3942 intval(($sharing) ? CONTACT_IS_SHARING : CONTACT_IS_FOLLOWER)
3944 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `url` = '%s' AND `pending` = 1 LIMIT 1",
3945 intval($importer['uid']),
3949 $contact_record = $r[0];
3951 // create notification
3952 $hash = random_string();
3954 if(is_array($contact_record)) {
3955 $ret = q("INSERT INTO `intro` ( `uid`, `contact-id`, `blocked`, `knowyou`, `hash`, `datetime`)
3956 VALUES ( %d, %d, 0, 0, '%s', '%s' )",
3957 intval($importer['uid']),
3958 intval($contact_record['id']),
3960 dbesc(datetime_convert())
3964 $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
3965 intval($importer['uid'])
3970 if(intval($r[0]['def_gid'])) {
3971 require_once('include/group.php');
3972 group_add_member($r[0]['uid'],'',$contact_record['id'],$r[0]['def_gid']);
3975 if(($r[0]['notify-flags'] & NOTIFY_INTRO) &&
3976 (($r[0]['page-flags'] == PAGE_NORMAL) OR ($r[0]['page-flags'] == PAGE_SOAPBOX))) {
3981 'type' => NOTIFY_INTRO,
3982 'notify_flags' => $r[0]['notify-flags'],
3983 'language' => $r[0]['language'],
3984 'to_name' => $r[0]['username'],
3985 'to_email' => $r[0]['email'],
3986 'uid' => $r[0]['uid'],
3987 'link' => $a->get_baseurl() . '/notifications/intro',
3988 'source_name' => ((strlen(stripslashes($contact_record['name']))) ? stripslashes($contact_record['name']) : t('[Name Withheld]')),
3989 'source_link' => $contact_record['url'],
3990 'source_photo' => $contact_record['photo'],
3991 'verb' => ($sharing ? ACTIVITY_FRIEND : ACTIVITY_FOLLOW),
4001 function lose_follower($importer,$contact,$datarray,$item) {
4003 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_SHARING)) {
4004 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
4005 intval(CONTACT_IS_SHARING),
4006 intval($contact['id'])
4010 contact_remove($contact['id']);
4014 function lose_sharer($importer,$contact,$datarray,$item) {
4016 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_FOLLOWER)) {
4017 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
4018 intval(CONTACT_IS_FOLLOWER),
4019 intval($contact['id'])
4023 contact_remove($contact['id']);
4028 function subscribe_to_hub($url,$importer,$contact,$hubmode = 'subscribe') {
4032 if(is_array($importer)) {
4033 $r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
4034 intval($importer['uid'])
4038 // Diaspora has different message-ids in feeds than they do
4039 // through the direct Diaspora protocol. If we try and use
4040 // the feed, we'll get duplicates. So don't.
4042 if((! count($r)) || $contact['network'] === NETWORK_DIASPORA)
4045 $push_url = get_config('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
4047 // Use a single verify token, even if multiple hubs
4049 $verify_token = ((strlen($contact['hub-verify'])) ? $contact['hub-verify'] : random_string());
4051 $params= 'hub.mode=' . $hubmode . '&hub.callback=' . urlencode($push_url) . '&hub.topic=' . urlencode($contact['poll']) . '&hub.verify=async&hub.verify_token=' . $verify_token;
4053 logger('subscribe_to_hub: ' . $hubmode . ' ' . $contact['name'] . ' to hub ' . $url . ' endpoint: ' . $push_url . ' with verifier ' . $verify_token);
4055 if(! strlen($contact['hub-verify'])) {
4056 $r = q("UPDATE `contact` SET `hub-verify` = '%s' WHERE `id` = %d",
4057 dbesc($verify_token),
4058 intval($contact['id'])
4062 post_url($url,$params);
4064 logger('subscribe_to_hub: returns: ' . $a->get_curl_code(), LOGGER_DEBUG);
4071 function atom_author($tag,$name,$uri,$h,$w,$photo) {
4075 $name = xmlify($name);
4076 $uri = xmlify($uri);
4079 $photo = xmlify($photo);
4083 $o .= "<name>$name</name>\r\n";
4084 $o .= "<uri>$uri</uri>\r\n";
4085 $o .= '<link rel="photo" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4086 $o .= '<link rel="avatar" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4088 call_hooks('atom_author', $o);
4090 $o .= "</$tag>\r\n";
4094 function atom_entry($item,$type,$author,$owner,$comment = false,$cid = 0) {
4098 if(! $item['parent'])
4101 if($item['deleted'])
4102 return '<at:deleted-entry ref="' . xmlify($item['uri']) . '" when="' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '" />' . "\r\n";
4105 if($item['allow_cid'] || $item['allow_gid'] || $item['deny_cid'] || $item['deny_gid'])
4106 $body = fix_private_photos($item['body'],$owner['uid'],$item,$cid);
4108 $body = $item['body'];
4111 $o = "\r\n\r\n<entry>\r\n";
4113 if(is_array($author))
4114 $o .= atom_author('author',$author['name'],$author['url'],80,80,$author['thumb']);
4116 $o .= atom_author('author',(($item['author-name']) ? $item['author-name'] : $item['name']),(($item['author-link']) ? $item['author-link'] : $item['url']),80,80,(($item['author-avatar']) ? $item['author-avatar'] : $item['thumb']));
4117 if(strlen($item['owner-name']))
4118 $o .= atom_author('dfrn:owner',$item['owner-name'],$item['owner-link'],80,80,$item['owner-avatar']);
4120 if(($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
4121 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
4122 $o .= '<thr:in-reply-to ref="' . xmlify($parent_item) . '" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['parent']) . '" />' . "\r\n";
4127 if ($item['title'] != "")
4128 $htmlbody = "[b]".$item['title']."[/b]\n\n".$htmlbody;
4130 $htmlbody = bbcode(bb_remove_share_information($htmlbody), false, false, 7);
4132 $o .= '<id>' . xmlify($item['uri']) . '</id>' . "\r\n";
4133 $o .= '<title>' . xmlify($item['title']) . '</title>' . "\r\n";
4134 $o .= '<published>' . xmlify(datetime_convert('UTC','UTC',$item['created'] . '+00:00',ATOM_TIME)) . '</published>' . "\r\n";
4135 $o .= '<updated>' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '</updated>' . "\r\n";
4136 $o .= '<dfrn:env>' . base64url_encode($body, true) . '</dfrn:env>' . "\r\n";
4137 $o .= '<content type="' . $type . '" >' . xmlify((($type === 'html') ? $htmlbody : $body)) . '</content>' . "\r\n";
4138 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['id']) . '" />' . "\r\n";
4142 $o .= '<dfrn:comment-allow>' . intval($item['last-child']) . '</dfrn:comment-allow>' . "\r\n";
4144 if($item['location']) {
4145 $o .= '<dfrn:location>' . xmlify($item['location']) . '</dfrn:location>' . "\r\n";
4146 $o .= '<poco:address><poco:formatted>' . xmlify($item['location']) . '</poco:formatted></poco:address>' . "\r\n";
4150 $o .= '<georss:point>' . xmlify($item['coord']) . '</georss:point>' . "\r\n";
4152 if(($item['private']) || strlen($item['allow_cid']) || strlen($item['allow_gid']) || strlen($item['deny_cid']) || strlen($item['deny_gid']))
4153 $o .= '<dfrn:private>' . (($item['private']) ? $item['private'] : 1) . '</dfrn:private>' . "\r\n";
4156 $o .= '<dfrn:extid>' . xmlify($item['extid']) . '</dfrn:extid>' . "\r\n";
4157 if($item['bookmark'])
4158 $o .= '<dfrn:bookmark>true</dfrn:bookmark>' . "\r\n";
4161 $o .= '<statusnet:notice_info local_id="' . $item['id'] . '" source="' . xmlify($item['app']) . '" ></statusnet:notice_info>' . "\r\n";
4164 $o .= '<dfrn:diaspora_guid>' . $item['guid'] . '</dfrn:diaspora_guid>' . "\r\n";
4166 if($item['signed_text']) {
4167 $sign = base64_encode(json_encode(array('signed_text' => $item['signed_text'],'signature' => $item['signature'],'signer' => $item['signer'])));
4168 $o .= '<dfrn:diaspora_signature>' . xmlify($sign) . '</dfrn:diaspora_signature>' . "\r\n";
4171 $verb = construct_verb($item);
4172 $o .= '<as:verb>' . xmlify($verb) . '</as:verb>' . "\r\n";
4173 $actobj = construct_activity_object($item);
4176 $actarg = construct_activity_target($item);
4180 $tags = item_getfeedtags($item);
4182 foreach($tags as $t) {
4183 $o .= '<category scheme="X-DFRN:' . xmlify($t[0]) . ':' . xmlify($t[1]) . '" term="' . xmlify($t[2]) . '" />' . "\r\n";
4187 $o .= item_getfeedattach($item);
4189 $mentioned = get_mentions($item);
4193 call_hooks('atom_entry', $o);
4195 $o .= '</entry>' . "\r\n";
4200 function fix_private_photos($s, $uid, $item = null, $cid = 0) {
4202 if(get_config('system','disable_embedded'))
4207 logger('fix_private_photos: check for photos', LOGGER_DEBUG);
4208 $site = substr($a->get_baseurl(),strpos($a->get_baseurl(),'://'));
4213 $img_start = strpos($orig_body, '[img');
4214 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4215 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4216 while( ($img_st_close !== false) && ($img_len !== false) ) {
4218 $img_st_close++; // make it point to AFTER the closing bracket
4219 $image = substr($orig_body, $img_start + $img_st_close, $img_len);
4221 logger('fix_private_photos: found photo ' . $image, LOGGER_DEBUG);
4224 if(stristr($image , $site . '/photo/')) {
4225 // Only embed locally hosted photos
4227 $i = basename($image);
4228 $i = str_replace(array('.jpg','.png','.gif'),array('','',''),$i);
4229 $x = strpos($i,'-');
4232 $res = substr($i,$x+1);
4233 $i = substr($i,0,$x);
4234 $r = q("SELECT * FROM `photo` WHERE `resource-id` = '%s' AND `scale` = %d AND `uid` = %d",
4241 // Check to see if we should replace this photo link with an embedded image
4242 // 1. No need to do so if the photo is public
4243 // 2. If there's a contact-id provided, see if they're in the access list
4244 // for the photo. If so, embed it.
4245 // 3. Otherwise, if we have an item, see if the item permissions match the photo
4246 // permissions, regardless of order but first check to see if they're an exact
4247 // match to save some processing overhead.
4249 if(has_permissions($r[0])) {
4251 $recips = enumerate_permissions($r[0]);
4252 if(in_array($cid, $recips)) {
4257 if(compare_permissions($item,$r[0]))
4262 $data = $r[0]['data'];
4263 $type = $r[0]['type'];
4265 // If a custom width and height were specified, apply before embedding
4266 if(preg_match("/\[img\=([0-9]*)x([0-9]*)\]/is", substr($orig_body, $img_start, $img_st_close), $match)) {
4267 logger('fix_private_photos: scaling photo', LOGGER_DEBUG);
4269 $width = intval($match[1]);
4270 $height = intval($match[2]);
4272 $ph = new Photo($data, $type);
4273 if($ph->is_valid()) {
4274 $ph->scaleImage(max($width, $height));
4275 $data = $ph->imageString();
4276 $type = $ph->getType();
4280 logger('fix_private_photos: replacing photo', LOGGER_DEBUG);
4281 $image = 'data:' . $type . ';base64,' . base64_encode($data);
4282 logger('fix_private_photos: replaced: ' . $image, LOGGER_DATA);
4288 $new_body = $new_body . substr($orig_body, 0, $img_start + $img_st_close) . $image . '[/img]';
4289 $orig_body = substr($orig_body, $img_start + $img_st_close + $img_len + strlen('[/img]'));
4290 if($orig_body === false)
4293 $img_start = strpos($orig_body, '[img');
4294 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4295 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4298 $new_body = $new_body . $orig_body;
4304 function has_permissions($obj) {
4305 if(($obj['allow_cid'] != '') || ($obj['allow_gid'] != '') || ($obj['deny_cid'] != '') || ($obj['deny_gid'] != ''))
4310 function compare_permissions($obj1,$obj2) {
4311 // first part is easy. Check that these are exactly the same.
4312 if(($obj1['allow_cid'] == $obj2['allow_cid'])
4313 && ($obj1['allow_gid'] == $obj2['allow_gid'])
4314 && ($obj1['deny_cid'] == $obj2['deny_cid'])
4315 && ($obj1['deny_gid'] == $obj2['deny_gid']))
4318 // This is harder. Parse all the permissions and compare the resulting set.
4320 $recipients1 = enumerate_permissions($obj1);
4321 $recipients2 = enumerate_permissions($obj2);
4324 if($recipients1 == $recipients2)
4329 // returns an array of contact-ids that are allowed to see this object
4331 function enumerate_permissions($obj) {
4332 require_once('include/group.php');
4333 $allow_people = expand_acl($obj['allow_cid']);
4334 $allow_groups = expand_groups(expand_acl($obj['allow_gid']));
4335 $deny_people = expand_acl($obj['deny_cid']);
4336 $deny_groups = expand_groups(expand_acl($obj['deny_gid']));
4337 $recipients = array_unique(array_merge($allow_people,$allow_groups));
4338 $deny = array_unique(array_merge($deny_people,$deny_groups));
4339 $recipients = array_diff($recipients,$deny);
4343 function item_getfeedtags($item) {
4346 $cnt = preg_match_all('|\#\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4348 for($x = 0; $x < $cnt; $x ++) {
4350 $ret[] = array('#',$matches[1][$x], $matches[2][$x]);
4354 $cnt = preg_match_all('|\@\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4356 for($x = 0; $x < $cnt; $x ++) {
4358 $ret[] = array('@',$matches[1][$x], $matches[2][$x]);
4364 function item_getfeedattach($item) {
4366 $arr = explode('[/attach],',$item['attach']);
4368 foreach($arr as $r) {
4370 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|',$r,$matches);
4372 $ret .= '<link rel="enclosure" href="' . xmlify($matches[1]) . '" type="' . xmlify($matches[3]) . '" ';
4373 if(intval($matches[2]))
4374 $ret .= 'length="' . intval($matches[2]) . '" ';
4375 if($matches[4] !== ' ')
4376 $ret .= 'title="' . xmlify(trim($matches[4])) . '" ';
4377 $ret .= ' />' . "\r\n";
4386 function item_expire($uid, $days, $network = "", $force = false) {
4388 if((! $uid) || ($days < 1))
4391 // $expire_network_only = save your own wall posts
4392 // and just expire conversations started by others
4394 $expire_network_only = get_pconfig($uid,'expire','network_only');
4395 $sql_extra = ((intval($expire_network_only)) ? " AND wall = 0 " : "");
4397 if ($network != "") {
4398 $sql_extra .= sprintf(" AND network = '%s' ", dbesc($network));
4399 // There is an index "uid_network_received" but not "uid_network_created"
4400 // This avoids the creation of another index just for one purpose.
4401 // And it doesn't really matter wether to look at "received" or "created"
4402 $range = "AND `received` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4404 $range = "AND `created` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4406 $r = q("SELECT * FROM `item`
4407 WHERE `uid` = %d $range
4418 $expire_items = get_pconfig($uid, 'expire','items');
4419 $expire_items = (($expire_items===false)?1:intval($expire_items)); // default if not set: 1
4421 // Forcing expiring of items - but not notes and marked items
4423 $expire_items = true;
4425 $expire_notes = get_pconfig($uid, 'expire','notes');
4426 $expire_notes = (($expire_notes===false)?1:intval($expire_notes)); // default if not set: 1
4428 $expire_starred = get_pconfig($uid, 'expire','starred');
4429 $expire_starred = (($expire_starred===false)?1:intval($expire_starred)); // default if not set: 1
4431 $expire_photos = get_pconfig($uid, 'expire','photos');
4432 $expire_photos = (($expire_photos===false)?0:intval($expire_photos)); // default if not set: 0
4434 logger('expire: # items=' . count($r). "; expire items: $expire_items, expire notes: $expire_notes, expire starred: $expire_starred, expire photos: $expire_photos");
4436 foreach($r as $item) {
4438 // don't expire filed items
4440 if(strpos($item['file'],'[') !== false)
4443 // Only expire posts, not photos and photo comments
4445 if($expire_photos==0 && strlen($item['resource-id']))
4447 if($expire_starred==0 && intval($item['starred']))
4449 if($expire_notes==0 && $item['type']=='note')
4451 if($expire_items==0 && $item['type']!='note')
4454 drop_item($item['id'],false);
4457 proc_run('php',"include/notifier.php","expire","$uid");
4462 function drop_items($items) {
4465 if(! local_user() && ! remote_user())
4469 foreach($items as $item) {
4470 $owner = drop_item($item,false);
4471 if($owner && ! $uid)
4476 // multiple threads may have been deleted, send an expire notification
4479 proc_run('php',"include/notifier.php","expire","$uid");
4483 function drop_item($id,$interactive = true) {
4487 // locate item to be deleted
4489 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
4496 notice( t('Item not found.') . EOL);
4497 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4502 $owner = $item['uid'];
4506 // check if logged in user is either the author or owner of this item
4508 if(is_array($_SESSION['remote'])) {
4509 foreach($_SESSION['remote'] as $visitor) {
4510 if($visitor['uid'] == $item['uid'] && $visitor['cid'] == $item['contact-id']) {
4511 $cid = $visitor['cid'];
4518 if((local_user() == $item['uid']) || ($cid) || (! $interactive)) {
4520 // Check if we should do HTML-based delete confirmation
4521 if($_REQUEST['confirm']) {
4522 // <form> can't take arguments in its "action" parameter
4523 // so add any arguments as hidden inputs
4524 $query = explode_querystring($a->query_string);
4526 foreach($query['args'] as $arg) {
4527 if(strpos($arg, 'confirm=') === false) {
4528 $arg_parts = explode('=', $arg);
4529 $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
4533 return replace_macros(get_markup_template('confirm.tpl'), array(
4535 '$message' => t('Do you really want to delete this item?'),
4536 '$extra_inputs' => $inputs,
4537 '$confirm' => t('Yes'),
4538 '$confirm_url' => $query['base'],
4539 '$confirm_name' => 'confirmed',
4540 '$cancel' => t('Cancel'),
4543 // Now check how the user responded to the confirmation query
4544 if($_REQUEST['canceled']) {
4545 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4548 logger('delete item: ' . $item['id'], LOGGER_DEBUG);
4551 $r = q("UPDATE `item` SET `deleted` = 1, `title` = '', `body` = '', `edited` = '%s', `changed` = '%s' WHERE `id` = %d",
4552 dbesc(datetime_convert()),
4553 dbesc(datetime_convert()),
4556 create_tags_from_item($item['id']);
4557 create_files_from_item($item['id']);
4558 delete_thread($item['id'], $item['parent-uri']);
4560 // clean up categories and tags so they don't end up as orphans
4563 $cnt = preg_match_all('/<(.*?)>/',$item['file'],$matches,PREG_SET_ORDER);
4565 foreach($matches as $mtch) {
4566 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],true);
4572 $cnt = preg_match_all('/\[(.*?)\]/',$item['file'],$matches,PREG_SET_ORDER);
4574 foreach($matches as $mtch) {
4575 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],false);
4579 // If item is a link to a photo resource, nuke all the associated photos
4580 // (visitors will not have photo resources)
4581 // This only applies to photos uploaded from the photos page. Photos inserted into a post do not
4582 // generate a resource-id and therefore aren't intimately linked to the item.
4584 if(strlen($item['resource-id'])) {
4585 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `uid` = %d ",
4586 dbesc($item['resource-id']),
4587 intval($item['uid'])
4589 // ignore the result
4592 // If item is a link to an event, nuke the event record.
4594 if(intval($item['event-id'])) {
4595 q("DELETE FROM `event` WHERE `id` = %d AND `uid` = %d",
4596 intval($item['event-id']),
4597 intval($item['uid'])
4599 // ignore the result
4602 // clean up item_id and sign meta-data tables
4605 // Old code - caused very long queries and warning entries in the mysql logfiles:
4607 $r = q("DELETE FROM item_id where iid in (select id from item where parent = %d and uid = %d)",
4608 intval($item['id']),
4609 intval($item['uid'])
4612 $r = q("DELETE FROM sign where iid in (select id from item where parent = %d and uid = %d)",
4613 intval($item['id']),
4614 intval($item['uid'])
4618 // The new code splits the queries since the mysql optimizer really has bad problems with subqueries
4620 // Creating list of parents
4621 $r = q("select id from item where parent = %d and uid = %d",
4622 intval($item['id']),
4623 intval($item['uid'])
4628 foreach ($r AS $row) {
4629 if ($parentid != "")
4632 $parentid .= $row["id"];
4636 if ($parentid != "") {
4637 $r = q("DELETE FROM item_id where iid in (%s)", dbesc($parentid));
4639 $r = q("DELETE FROM sign where iid in (%s)", dbesc($parentid));
4642 // If it's the parent of a comment thread, kill all the kids
4644 if($item['uri'] == $item['parent-uri']) {
4645 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = ''
4646 WHERE `parent-uri` = '%s' AND `uid` = %d ",
4647 dbesc(datetime_convert()),
4648 dbesc(datetime_convert()),
4649 dbesc($item['parent-uri']),
4650 intval($item['uid'])
4652 create_tags_from_item($item['parent-uri'], $item['uid']);
4653 create_files_from_item($item['parent-uri'], $item['uid']);
4654 delete_thread_uri($item['parent-uri'], $item['uid']);
4655 // ignore the result
4658 // ensure that last-child is set in case the comment that had it just got wiped.
4659 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
4660 dbesc(datetime_convert()),
4661 dbesc($item['parent-uri']),
4662 intval($item['uid'])
4664 // who is the last child now?
4665 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d ORDER BY `edited` DESC LIMIT 1",
4666 dbesc($item['parent-uri']),
4667 intval($item['uid'])
4670 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
4675 // Add a relayable_retraction signature for Diaspora.
4676 store_diaspora_retract_sig($item, $a->user, $a->get_baseurl());
4678 $drop_id = intval($item['id']);
4680 // send the notification upstream/downstream as the case may be
4682 proc_run('php',"include/notifier.php","drop","$drop_id");
4686 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4692 notice( t('Permission denied.') . EOL);
4693 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4700 function first_post_date($uid,$wall = false) {
4701 $r = q("select id, created from item
4702 where uid = %d and wall = %d and deleted = 0 and visible = 1 AND moderated = 0
4704 order by created asc limit 1",
4706 intval($wall ? 1 : 0)
4709 // logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA);
4710 return substr(datetime_convert('',date_default_timezone_get(),$r[0]['created']),0,10);
4715 function posted_dates($uid,$wall) {
4716 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
4718 $dthen = first_post_date($uid,$wall);
4722 // Set the start and end date to the beginning of the month
4723 $dnow = substr($dnow,0,8).'01';
4724 $dthen = substr($dthen,0,8).'01';
4727 // Starting with the current month, get the first and last days of every
4728 // month down to and including the month of the first post
4729 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
4730 $dstart = substr($dnow,0,8) . '01';
4731 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
4732 $start_month = datetime_convert('','',$dstart,'Y-m-d');
4733 $end_month = datetime_convert('','',$dend,'Y-m-d');
4734 $str = day_translate(datetime_convert('','',$dnow,'F Y'));
4735 $ret[] = array($str,$end_month,$start_month);
4736 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
4742 function posted_date_widget($url,$uid,$wall) {
4745 if(! feature_enabled($uid,'archives'))
4748 // For former Facebook folks that left because of "timeline"
4750 /* if($wall && intval(get_pconfig($uid,'system','no_wall_archive_widget')))
4753 $ret = posted_dates($uid,$wall);
4757 $o = replace_macros(get_markup_template('posted_date_widget.tpl'),array(
4758 '$title' => t('Archives'),
4759 '$size' => ((count($ret) > 6) ? 6 : count($ret)),
4766 function store_diaspora_retract_sig($item, $user, $baseurl) {
4767 // Note that we can't add a target_author_signature
4768 // if the comment was deleted by a remote user. That should be ok, because if a remote user is deleting
4769 // the comment, that means we're the home of the post, and Diaspora will only
4770 // check the parent_author_signature of retractions that it doesn't have to relay further
4772 // I don't think this function gets called for an "unlike," but I'll check anyway
4774 $enabled = intval(get_config('system','diaspora_enabled'));
4776 logger('drop_item: diaspora support disabled, not storing retraction signature', LOGGER_DEBUG);
4780 logger('drop_item: storing diaspora retraction signature');
4782 $signed_text = $item['guid'] . ';' . ( ($item['verb'] === ACTIVITY_LIKE) ? 'Like' : 'Comment');
4784 if(local_user() == $item['uid']) {
4786 $handle = $user['nickname'] . '@' . substr($baseurl, strpos($baseurl,'://') + 3);
4787 $authorsig = base64_encode(rsa_sign($signed_text,$user['prvkey'],'sha256'));
4790 $r = q("SELECT `nick`, `url` FROM `contact` WHERE `id` = '%d' LIMIT 1",
4791 $item['contact-id'] // If this function gets called, drop_item() has already checked remote_user() == $item['contact-id']
4794 // The below handle only works for NETWORK_DFRN. I think that's ok, because this function
4795 // only handles DFRN deletes
4796 $handle_baseurl_start = strpos($r['url'],'://') + 3;
4797 $handle_baseurl_length = strpos($r['url'],'/profile') - $handle_baseurl_start;
4798 $handle = $r['nick'] . '@' . substr($r['url'], $handle_baseurl_start, $handle_baseurl_length);
4804 q("insert into sign (`retract_iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
4805 intval($item['id']),
4806 dbesc($signed_text),