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 // Check for hashtags in the body and repair or add hashtag links
1243 item_body_set_hashtags($arr);
1245 $arr['thr-parent'] = $arr['parent-uri'];
1246 if($arr['parent-uri'] === $arr['uri']) {
1248 $parent_deleted = 0;
1249 $allow_cid = $arr['allow_cid'];
1250 $allow_gid = $arr['allow_gid'];
1251 $deny_cid = $arr['deny_cid'];
1252 $deny_gid = $arr['deny_gid'];
1253 $notify_type = 'wall-new';
1257 // find the parent and snarf the item id and ACLs
1258 // and anything else we need to inherit
1260 $r = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC LIMIT 1",
1261 dbesc($arr['parent-uri']),
1267 // is the new message multi-level threaded?
1268 // even though we don't support it now, preserve the info
1269 // and re-attach to the conversation parent.
1271 if($r[0]['uri'] != $r[0]['parent-uri']) {
1272 $arr['parent-uri'] = $r[0]['parent-uri'];
1273 $z = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `parent-uri` = '%s' AND `uid` = %d
1274 ORDER BY `id` ASC LIMIT 1",
1275 dbesc($r[0]['parent-uri']),
1276 dbesc($r[0]['parent-uri']),
1283 $parent_id = $r[0]['id'];
1284 $parent_deleted = $r[0]['deleted'];
1285 $allow_cid = $r[0]['allow_cid'];
1286 $allow_gid = $r[0]['allow_gid'];
1287 $deny_cid = $r[0]['deny_cid'];
1288 $deny_gid = $r[0]['deny_gid'];
1289 $arr['wall'] = $r[0]['wall'];
1290 $notify_type = 'comment-new';
1292 // if the parent is private, force privacy for the entire conversation
1293 // This differs from the above settings as it subtly allows comments from
1294 // email correspondents to be private even if the overall thread is not.
1296 if($r[0]['private'])
1297 $arr['private'] = $r[0]['private'];
1299 // Edge case. We host a public forum that was originally posted to privately.
1300 // The original author commented, but as this is a comment, the permissions
1301 // weren't fixed up so it will still show the comment as private unless we fix it here.
1303 if((intval($r[0]['forum_mode']) == 1) && (! $r[0]['private']))
1304 $arr['private'] = 0;
1307 // If its a post from myself then tag the thread as "mention"
1308 logger("item_store: Checking if parent ".$parent_id." has to be tagged as mention for user ".$arr['uid'], LOGGER_DEBUG);
1309 $u = q("select * from user where uid = %d limit 1", intval($arr['uid']));
1312 $self = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1313 logger("item_store: 'myself' is ".$self." for parent ".$parent_id." checking against ".$arr['author-link']." and ".$arr['owner-link'], LOGGER_DEBUG);
1314 if ((normalise_link($arr['author-link']) == $self) OR (normalise_link($arr['owner-link']) == $self)) {
1315 q("UPDATE `thread` SET `mention` = 1 WHERE `iid` = %d", intval($parent_id));
1316 logger("item_store: tagged thread ".$parent_id." as mention for user ".$self, LOGGER_DEBUG);
1322 // Allow one to see reply tweets from status.net even when
1323 // we don't have or can't see the original post.
1326 logger('item_store: $force_parent=true, reply converted to top-level post.');
1328 $arr['parent-uri'] = $arr['uri'];
1329 $arr['gravity'] = 0;
1332 logger('item_store: item parent was not found - ignoring item');
1336 $parent_deleted = 0;
1340 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
1344 if($r && count($r)) {
1345 logger('item-store: duplicate item ignored. ' . print_r($arr,true));
1349 // Is this item available in the global items (with uid=0)?
1350 if ($arr["uid"] == 0) {
1351 $arr["global"] = true;
1353 q("UPDATE `item` SET `global` = 1 WHERE `guid` = '%s'", dbesc($arr["guid"]));
1355 $isglobal = q("SELECT `global` FROM `item` WHERE `uid` = 0 AND `guid` = '%s'", dbesc($arr["guid"]));
1357 $arr["global"] = (count($isglobal) > 0);
1360 // Fill the cache field
1361 put_item_in_cache($arr);
1363 call_hooks('post_remote',$arr);
1365 if(x($arr,'cancel')) {
1366 logger('item_store: post cancelled by plugin.');
1370 // Store the unescaped version
1375 logger('item_store: ' . print_r($arr,true), LOGGER_DATA);
1377 $r = dbq("INSERT INTO `item` (`"
1378 . implode("`, `", array_keys($arr))
1380 . implode("', '", array_values($arr))
1386 // find the item we just created
1387 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC ",
1393 $current_post = $r[0]['id'];
1394 logger('item_store: created item ' . $current_post);
1396 // Set "success_update" to the date of the last time we heard from this contact
1397 // This can be used to filter for inactive contacts and poco.
1398 // Only do this for public postings to avoid privacy problems, since poco data is public.
1399 // Don't set this value if it isn't from the owner (could be an author that we don't know)
1400 if (!$arr['private'] AND (($arr["author-link"] === $arr["owner-link"]) OR ($arr["parent-uri"] === $arr["uri"])))
1401 q("UPDATE `contact` SET `success_update` = '%s' WHERE `id` = %d",
1402 dbesc($arr['received']),
1403 intval($arr['contact-id'])
1406 logger('item_store: could not locate created item');
1410 logger('item_store: duplicated post occurred. Removing duplicates. uri = '.$arr['uri'].' uid = '.$arr['uid']);
1411 q("DELETE FROM `item` WHERE `uri` = '%s' AND `uid` = %d AND `id` != %d ",
1413 intval($arr['uid']),
1414 intval($current_post)
1418 if((! $parent_id) || ($arr['parent-uri'] === $arr['uri']))
1419 $parent_id = $current_post;
1421 if(strlen($allow_cid) || strlen($allow_gid) || strlen($deny_cid) || strlen($deny_gid))
1424 $private = $arr['private'];
1426 // Set parent id - and also make sure to inherit the parent's ACLs.
1428 $r = q("UPDATE `item` SET `parent` = %d, `allow_cid` = '%s', `allow_gid` = '%s',
1429 `deny_cid` = '%s', `deny_gid` = '%s', `private` = %d, `deleted` = %d WHERE `id` = %d",
1436 intval($parent_deleted),
1437 intval($current_post)
1440 // Complete ostatus threads
1441 if ($ostatus_conversation)
1442 complete_conversation($current_post, $ostatus_conversation);
1444 $arr['id'] = $current_post;
1445 $arr['parent'] = $parent_id;
1446 $arr['allow_cid'] = $allow_cid;
1447 $arr['allow_gid'] = $allow_gid;
1448 $arr['deny_cid'] = $deny_cid;
1449 $arr['deny_gid'] = $deny_gid;
1450 $arr['private'] = $private;
1451 $arr['deleted'] = $parent_deleted;
1453 // update the commented timestamp on the parent
1454 // Only update "commented" if it is really a comment
1455 if (($arr['verb'] == ACTIVITY_POST) OR !get_config("system", "like_no_comment"))
1456 q("UPDATE `item` SET `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
1457 dbesc(datetime_convert()),
1458 dbesc(datetime_convert()),
1462 q("UPDATE `item` SET `changed` = '%s' WHERE `id` = %d",
1463 dbesc(datetime_convert()),
1468 q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
1469 intval($current_post),
1470 dbesc($dsprsig->signed_text),
1471 dbesc($dsprsig->signature),
1472 dbesc($dsprsig->signer)
1478 * If this is now the last-child, force all _other_ children of this parent to *not* be last-child
1481 if($arr['last-child']) {
1482 $r = q("UPDATE `item` SET `last-child` = 0 WHERE `parent-uri` = '%s' AND `uid` = %d AND `id` != %d",
1484 intval($arr['uid']),
1485 intval($current_post)
1489 $deleted = tag_deliver($arr['uid'],$current_post);
1491 // current post can be deleted if is for a community page and no mention are
1493 if (!$deleted AND !$dontcache) {
1495 $r = q('SELECT * FROM `item` WHERE id = %d', intval($current_post));
1496 if (count($r) == 1) {
1497 call_hooks('post_remote_end', $r[0]);
1499 logger('item_store: new item not found in DB, id ' . $current_post);
1502 // Add every contact of the post to the global contact table
1505 create_tags_from_item($current_post);
1506 create_files_from_item($current_post);
1508 // Only check for notifications on start posts
1509 if ($arr['parent-uri'] === $arr['uri']) {
1510 add_thread($current_post);
1511 logger('item_store: Check notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1513 // Send a notification for every new post?
1514 $r = q("SELECT `notify_new_posts` FROM `contact` WHERE `id` = %d AND `uid` = %d AND `notify_new_posts` LIMIT 1",
1515 intval($arr['contact-id']),
1518 $send_notification = count($r);
1520 if (!$send_notification) {
1521 $tags = q("SELECT `url` FROM `term` WHERE `otype` = %d AND `oid` = %d AND `type` = %d AND `uid` = %d",
1522 intval(TERM_OBJ_POST), intval($current_post), intval(TERM_MENTION), intval($arr['uid']));
1525 foreach ($tags AS $tag) {
1526 $r = q("SELECT `id` FROM `contact` WHERE `nurl` = '%s' AND `uid` = %d AND `notify_new_posts`",
1527 normalise_link($tag["url"]), intval($arr['uid']));
1529 $send_notification = true;
1534 if ($send_notification) {
1535 logger('item_store: Send notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1536 $u = q("SELECT * FROM user WHERE uid = %d LIMIT 1",
1537 intval($arr['uid']));
1539 $item = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d",
1540 intval($current_post),
1546 require_once('include/enotify.php');
1548 'type' => NOTIFY_SHARE,
1549 'notify_flags' => $u[0]['notify-flags'],
1550 'language' => $u[0]['language'],
1551 'to_name' => $u[0]['username'],
1552 'to_email' => $u[0]['email'],
1553 'uid' => $u[0]['uid'],
1555 'link' => $a->get_baseurl().'/display/'.urlencode($arr['guid']),
1556 'source_name' => $item[0]['author-name'],
1557 'source_link' => $item[0]['author-link'],
1558 'source_photo' => $item[0]['author-avatar'],
1559 'verb' => ACTIVITY_TAG,
1562 logger('item_store: Notification sent for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1565 update_thread($parent_id);
1568 proc_run('php', "include/notifier.php", $notify_type, $current_post);
1570 return $current_post;
1573 function item_body_set_hashtags(&$item) {
1575 $tags = get_tags($item["body"]);
1581 // This sorting is important when there are hashtags that are part of other hashtags
1582 // Otherwise there could be problems with hashtags like #test and #test2
1587 $URLSearchString = "^\[\]";
1589 // All hashtags should point to the home server
1590 //$item["body"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1591 // "#[url=".$a->get_baseurl()."/search?tag=$2]$2[/url]", $item["body"]);
1593 //$item["tag"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1594 // "#[url=".$a->get_baseurl()."/search?tag=$2]$2[/url]", $item["tag"]);
1596 // mask hashtags inside of url, bookmarks and attachments to avoid urls in urls
1597 $item["body"] = preg_replace_callback("/\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1599 return("[url=".$match[1]."]".str_replace("#", "#", $match[2])."[/url]");
1602 $item["body"] = preg_replace_callback("/\[bookmark\=([$URLSearchString]*)\](.*?)\[\/bookmark\]/ism",
1604 return("[bookmark=".$match[1]."]".str_replace("#", "#", $match[2])."[/bookmark]");
1607 $item["body"] = preg_replace_callback("/\[attachment (.*)\](.*?)\[\/attachment\]/ism",
1609 return("[attachment ".str_replace("#", "#", $match[1])."]".$match[2]."[/attachment]");
1612 // Repair recursive urls
1613 $item["body"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1614 "#$2", $item["body"]);
1616 foreach($tags as $tag) {
1617 if(strpos($tag,'#') !== 0)
1620 if(strpos($tag,'[url='))
1623 $basetag = str_replace('_',' ',substr($tag,1));
1625 $newtag = '#[url='.$a->get_baseurl().'/search?tag='.rawurlencode($basetag).']'.$basetag.'[/url]';
1627 $item["body"] = str_replace($tag, $newtag, $item["body"]);
1629 if(!stristr($item["tag"],"/search?tag=".$basetag."]".$basetag."[/url]")) {
1630 if(strlen($item["tag"]))
1631 $item["tag"] = ','.$item["tag"];
1632 $item["tag"] = $newtag.$item["tag"];
1636 // Convert back the masked hashtags
1637 $item["body"] = str_replace("#", "#", $item["body"]);
1640 function get_item_guid($id) {
1641 $r = q("SELECT `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($id));
1643 return($r[0]["guid"]);
1648 function get_item_id($guid, $uid = 0) {
1654 $uid == local_user();
1656 // Does the given user have this item?
1658 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1659 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1660 AND `item`.`guid` = '%s' AND `item`.`uid` = %d", dbesc($guid), intval($uid));
1663 $nick = $r[0]["nickname"];
1667 // Or is it anywhere on the server?
1669 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1670 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1671 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = ''
1672 AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
1673 AND `item`.`private` = 0 AND `item`.`wall` = 1
1674 AND `item`.`guid` = '%s'", dbesc($guid));
1677 $nick = $r[0]["nickname"];
1680 return(array("nick" => $nick, "id" => $id));
1684 function get_item_contact($item,$contacts) {
1685 if(! count($contacts) || (! is_array($item)))
1687 foreach($contacts as $contact) {
1688 if($contact['id'] == $item['contact-id']) {
1690 break; // NOTREACHED
1697 * look for mention tags and setup a second delivery chain for forum/community posts if appropriate
1699 * @param int $item_id
1700 * @return bool true if item was deleted, else false
1702 function tag_deliver($uid,$item_id) {
1710 $u = q("select * from user where uid = %d limit 1",
1716 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1717 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1720 $i = q("select * from item where id = %d and uid = %d limit 1",
1729 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1731 // Diaspora uses their own hardwired link URL in @-tags
1732 // instead of the one we supply with webfinger
1734 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1736 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1738 foreach($matches as $mtch) {
1739 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1741 logger('tag_deliver: mention found: ' . $mtch[2]);
1747 if ( ($community_page || $prvgroup) &&
1748 (!$item['wall']) && (!$item['origin']) && ($item['id'] == $item['parent'])){
1749 // mmh.. no mention.. community page or private group... no wall.. no origin.. top-post (not a comment)
1751 logger("tag_deliver: no-mention top-level post to communuty or private group. delete.");
1752 q("DELETE FROM item WHERE id = %d and uid = %d",
1762 // send a notification
1764 // use a local photo if we have one
1766 $r = q("select * from contact where uid = %d and nurl = '%s' limit 1",
1767 intval($u[0]['uid']),
1768 dbesc(normalise_link($item['author-link']))
1770 $photo = (($r && count($r)) ? $r[0]['thumb'] : $item['author-avatar']);
1773 require_once('include/enotify.php');
1775 'type' => NOTIFY_TAGSELF,
1776 'notify_flags' => $u[0]['notify-flags'],
1777 'language' => $u[0]['language'],
1778 'to_name' => $u[0]['username'],
1779 'to_email' => $u[0]['email'],
1780 'uid' => $u[0]['uid'],
1782 'link' => $a->get_baseurl() . '/display/'.urlencode(get_item_guid($item['id'])),
1783 'source_name' => $item['author-name'],
1784 'source_link' => $item['author-link'],
1785 'source_photo' => $photo,
1786 'verb' => ACTIVITY_TAG,
1788 'parent' => $item['parent']
1792 $arr = array('item' => $item, 'user' => $u[0], 'contact' => $r[0]);
1794 call_hooks('tagged', $arr);
1796 if((! $community_page) && (! $prvgroup))
1800 // tgroup delivery - setup a second delivery chain
1801 // prevent delivery looping - only proceed
1802 // if the message originated elsewhere and is a top-level post
1804 if(($item['wall']) || ($item['origin']) || ($item['id'] != $item['parent']))
1807 // now change this copy of the post to a forum head message and deliver to all the tgroup members
1810 $c = q("select name, url, thumb from contact where self = 1 and uid = %d limit 1",
1811 intval($u[0]['uid'])
1816 // also reset all the privacy bits to the forum default permissions
1818 $private = ($u[0]['allow_cid'] || $u[0]['allow_gid'] || $u[0]['deny_cid'] || $u[0]['deny_gid']) ? 1 : 0;
1820 $forum_mode = (($prvgroup) ? 2 : 1);
1822 q("update item set wall = 1, origin = 1, forum_mode = %d, `owner-name` = '%s', `owner-link` = '%s', `owner-avatar` = '%s',
1823 `private` = %d, `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s' where id = %d",
1824 intval($forum_mode),
1825 dbesc($c[0]['name']),
1826 dbesc($c[0]['url']),
1827 dbesc($c[0]['thumb']),
1829 dbesc($u[0]['allow_cid']),
1830 dbesc($u[0]['allow_gid']),
1831 dbesc($u[0]['deny_cid']),
1832 dbesc($u[0]['deny_gid']),
1835 update_thread($item_id);
1837 proc_run('php','include/notifier.php','tgroup',$item_id);
1843 function tgroup_check($uid,$item) {
1849 // check that the message originated elsewhere and is a top-level post
1851 if(($item['wall']) || ($item['origin']) || ($item['uri'] != $item['parent-uri']))
1855 $u = q("select * from user where uid = %d limit 1",
1861 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1862 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1865 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1867 // Diaspora uses their own hardwired link URL in @-tags
1868 // instead of the one we supply with webfinger
1870 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1872 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1874 foreach($matches as $mtch) {
1875 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1877 logger('tgroup_check: mention found: ' . $mtch[2]);
1885 if((! $community_page) && (! $prvgroup))
1899 function dfrn_deliver($owner,$contact,$atom, $dissolve = false) {
1903 $idtosend = $orig_id = (($contact['dfrn-id']) ? $contact['dfrn-id'] : $contact['issued-id']);
1905 if($contact['duplex'] && $contact['dfrn-id'])
1906 $idtosend = '0:' . $orig_id;
1907 if($contact['duplex'] && $contact['issued-id'])
1908 $idtosend = '1:' . $orig_id;
1910 $rino = ((function_exists('mcrypt_encrypt')) ? 1 : 0);
1912 $rino_enable = get_config('system','rino_encrypt');
1917 $ssl_val = intval(get_config('system','ssl_policy'));
1921 case SSL_POLICY_FULL:
1922 $ssl_policy = 'full';
1924 case SSL_POLICY_SELFSIGN:
1925 $ssl_policy = 'self';
1927 case SSL_POLICY_NONE:
1929 $ssl_policy = 'none';
1933 $url = $contact['notify'] . '&dfrn_id=' . $idtosend . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . (($rino) ? '&rino=1' : '');
1935 logger('dfrn_deliver: ' . $url);
1937 $xml = fetch_url($url);
1939 $curl_stat = $a->get_curl_code();
1941 return(-1); // timed out
1943 logger('dfrn_deliver: ' . $xml, LOGGER_DATA);
1948 if(strpos($xml,'<?xml') === false) {
1949 logger('dfrn_deliver: no valid XML returned');
1950 logger('dfrn_deliver: returned XML: ' . $xml, LOGGER_DATA);
1954 $res = parse_xml_string($xml);
1956 if((intval($res->status) != 0) || (! strlen($res->challenge)) || (! strlen($res->dfrn_id)))
1957 return (($res->status) ? $res->status : 3);
1959 $postvars = array();
1960 $sent_dfrn_id = hex2bin((string) $res->dfrn_id);
1961 $challenge = hex2bin((string) $res->challenge);
1962 $perm = (($res->perm) ? $res->perm : null);
1963 $dfrn_version = (float) (($res->dfrn_version) ? $res->dfrn_version : 2.0);
1964 $rino_allowed = ((intval($res->rino) === 1) ? 1 : 0);
1965 $page = (($owner['page-flags'] == PAGE_COMMUNITY) ? 1 : 0);
1967 if($owner['page-flags'] == PAGE_PRVGROUP)
1970 $final_dfrn_id = '';
1973 if((($perm == 'rw') && (! intval($contact['writable'])))
1974 || (($perm == 'r') && (intval($contact['writable'])))) {
1975 q("update contact set writable = %d where id = %d",
1976 intval(($perm == 'rw') ? 1 : 0),
1977 intval($contact['id'])
1979 $contact['writable'] = (string) 1 - intval($contact['writable']);
1983 if(($contact['duplex'] && strlen($contact['pubkey']))
1984 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1985 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1986 openssl_public_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['pubkey']);
1987 openssl_public_decrypt($challenge,$postvars['challenge'],$contact['pubkey']);
1990 openssl_private_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['prvkey']);
1991 openssl_private_decrypt($challenge,$postvars['challenge'],$contact['prvkey']);
1994 $final_dfrn_id = substr($final_dfrn_id, 0, strpos($final_dfrn_id, '.'));
1996 if(strpos($final_dfrn_id,':') == 1)
1997 $final_dfrn_id = substr($final_dfrn_id,2);
1999 if($final_dfrn_id != $orig_id) {
2000 logger('dfrn_deliver: wrong dfrn_id.');
2001 // did not decode properly - cannot trust this site
2005 $postvars['dfrn_id'] = $idtosend;
2006 $postvars['dfrn_version'] = DFRN_PROTOCOL_VERSION;
2008 $postvars['dissolve'] = '1';
2011 if((($contact['rel']) && ($contact['rel'] != CONTACT_IS_SHARING) && (! $contact['blocked'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
2012 $postvars['data'] = $atom;
2013 $postvars['perm'] = 'rw';
2016 $postvars['data'] = str_replace('<dfrn:comment-allow>1','<dfrn:comment-allow>0',$atom);
2017 $postvars['perm'] = 'r';
2020 $postvars['ssl_policy'] = $ssl_policy;
2023 $postvars['page'] = $page;
2025 if($rino && $rino_allowed && (! $dissolve)) {
2026 $key = substr(random_string(),0,16);
2027 $data = bin2hex(aes_encrypt($postvars['data'],$key));
2028 $postvars['data'] = $data;
2029 logger('rino: sent key = ' . $key, LOGGER_DEBUG);
2032 if($dfrn_version >= 2.1) {
2033 if(($contact['duplex'] && strlen($contact['pubkey']))
2034 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
2035 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
2037 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
2040 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
2044 if(($contact['duplex'] && strlen($contact['prvkey'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
2045 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
2048 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
2052 logger('md5 rawkey ' . md5($postvars['key']));
2054 $postvars['key'] = bin2hex($postvars['key']);
2057 logger('dfrn_deliver: ' . "SENDING: " . print_r($postvars,true), LOGGER_DATA);
2059 $xml = post_url($contact['notify'],$postvars);
2061 logger('dfrn_deliver: ' . "RECEIVED: " . $xml, LOGGER_DATA);
2063 $curl_stat = $a->get_curl_code();
2064 if((! $curl_stat) || (! strlen($xml)))
2065 return(-1); // timed out
2067 if(($curl_stat == 503) && (stristr($a->get_curl_headers(),'retry-after')))
2070 if(strpos($xml,'<?xml') === false) {
2071 logger('dfrn_deliver: phase 2: no valid XML returned');
2072 logger('dfrn_deliver: phase 2: returned XML: ' . $xml, LOGGER_DATA);
2076 if($contact['term-date'] != '0000-00-00 00:00:00') {
2077 logger("dfrn_deliver: $url back from the dead - removing mark for death");
2078 require_once('include/Contact.php');
2079 unmark_for_death($contact);
2082 $res = parse_xml_string($xml);
2084 return $res->status;
2089 This function returns true if $update has an edited timestamp newer
2090 than $existing, i.e. $update contains new data which should override
2091 what's already there. If there is no timestamp yet, the update is
2092 assumed to be newer. If the update has no timestamp, the existing
2093 item is assumed to be up-to-date. If the timestamps are equal it
2094 assumes the update has been seen before and should be ignored.
2096 function edited_timestamp_is_newer($existing, $update) {
2097 if (!x($existing,'edited') || !$existing['edited']) {
2100 if (!x($update,'edited') || !$update['edited']) {
2103 $existing_edited = datetime_convert('UTC', 'UTC', $existing['edited']);
2104 $update_edited = datetime_convert('UTC', 'UTC', $update['edited']);
2105 return (strcmp($existing_edited, $update_edited) < 0);
2110 * consume_feed - process atom feed and update anything/everything we might need to update
2112 * $xml = the (atom) feed to consume - RSS isn't as fully supported but may work for simple feeds.
2114 * $importer = the contact_record (joined to user_record) of the local user who owns this relationship.
2115 * It is this person's stuff that is going to be updated.
2116 * $contact = the person who is sending us stuff. If not set, we MAY be processing a "follow" activity
2117 * from an external network and MAY create an appropriate contact record. Otherwise, we MUST
2118 * have a contact record.
2119 * $hub = should we find a hub declation in the feed, pass it back to our calling process, who might (or
2120 * might not) try and subscribe to it.
2121 * $datedir sorts in reverse order
2122 * $pass - by default ($pass = 0) we cannot guarantee that a parent item has been
2123 * imported prior to its children being seen in the stream unless we are certain
2124 * of how the feed is arranged/ordered.
2125 * With $pass = 1, we only pull parent items out of the stream.
2126 * With $pass = 2, we only pull children (comments/likes).
2128 * So running this twice, first with pass 1 and then with pass 2 will do the right
2129 * thing regardless of feed ordering. This won't be adequate in a fully-threaded
2130 * model where comments can have sub-threads. That would require some massive sorting
2131 * to get all the feed items into a mostly linear ordering, and might still require
2135 function consume_feed($xml,$importer,&$contact, &$hub, $datedir = 0, $pass = 0) {
2137 require_once('library/simplepie/simplepie.inc');
2138 require_once('include/contact_selectors.php');
2140 if(! strlen($xml)) {
2141 logger('consume_feed: empty input');
2145 $feed = new SimplePie();
2146 $feed->set_raw_data($xml);
2148 $feed->enable_order_by_date(true);
2150 $feed->enable_order_by_date(false);
2154 logger('consume_feed: Error parsing XML: ' . $feed->error());
2156 $permalink = $feed->get_permalink();
2158 // Check at the feed level for updated contact name and/or photo
2162 $photo_timestamp = '';
2165 $contact_updated = '';
2167 $hubs = $feed->get_links('hub');
2168 logger('consume_feed: hubs: ' . print_r($hubs,true), LOGGER_DATA);
2171 $hub = implode(',', $hubs);
2173 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2175 $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2177 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2178 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2179 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2180 $new_name = $elems['name'][0]['data'];
2182 // Manually checking for changed contact names
2183 if (($new_name != $contact['name']) AND ($new_name != "") AND ($name_updated <= $contact['name-date'])) {
2184 $name_updated = date("c");
2185 $photo_timestamp = date("c");
2188 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2189 if ($photo_timestamp == "")
2190 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2191 $photo_url = $elems['link'][0]['attribs']['']['href'];
2194 if((x($rawtags[0]['child'], NAMESPACE_DFRN)) && (x($rawtags[0]['child'][NAMESPACE_DFRN],'birthday'))) {
2195 $birthday = datetime_convert('UTC','UTC', $rawtags[0]['child'][NAMESPACE_DFRN]['birthday'][0]['data']);
2199 if((is_array($contact)) && ($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $contact['avatar-date'])) {
2200 logger('consume_feed: Updating photo for '.$contact['name'].' from '.$photo_url.' uid: '.$contact['uid']);
2202 $contact_updated = $photo_timestamp;
2204 require_once("include/Photo.php");
2205 $photo_failure = false;
2206 $have_photo = false;
2208 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2209 intval($contact['id']),
2210 intval($contact['uid'])
2213 $resource_id = $r[0]['resource-id'];
2217 $resource_id = photo_new_resource();
2220 $img_str = fetch_url($photo_url,true);
2221 // guess mimetype from headers or filename
2222 $type = guess_image_type($photo_url,true);
2225 $img = new Photo($img_str, $type);
2226 if($img->is_valid()) {
2228 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2229 dbesc($resource_id),
2230 intval($contact['id']),
2231 intval($contact['uid'])
2235 $img->scaleImageSquare(175);
2237 $hash = $resource_id;
2238 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2240 $img->scaleImage(80);
2241 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2243 $img->scaleImage(48);
2244 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2248 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2249 WHERE `uid` = %d AND `id` = %d",
2250 dbesc(datetime_convert()),
2251 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2252 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2253 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2254 intval($contact['uid']),
2255 intval($contact['id'])
2260 if((is_array($contact)) && ($name_updated) && (strlen($new_name)) && ($name_updated > $contact['name-date'])) {
2261 if ($name_updated > $contact_updated)
2262 $contact_updated = $name_updated;
2264 $r = q("select * from contact where uid = %d and id = %d limit 1",
2265 intval($contact['uid']),
2266 intval($contact['id'])
2269 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2270 dbesc(notags(trim($new_name))),
2271 dbesc(datetime_convert()),
2272 intval($contact['uid']),
2273 intval($contact['id'])
2276 // do our best to update the name on content items
2279 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2280 dbesc(notags(trim($new_name))),
2281 dbesc($r[0]['name']),
2282 dbesc($r[0]['url']),
2283 intval($contact['uid'])
2288 if ($contact_updated AND $new_name AND $photo_url)
2289 poco_check($contact['url'], $new_name, NETWORK_DFRN, $photo_url, "", "", "", "", "", $contact_updated, 2, $contact['id'], $contact['uid']);
2291 if(strlen($birthday)) {
2292 if(substr($birthday,0,4) != $contact['bdyear']) {
2293 logger('consume_feed: updating birthday: ' . $birthday);
2297 * Add new birthday event for this person
2299 * $bdtext is just a readable placeholder in case the event is shared
2300 * with others. We will replace it during presentation to our $importer
2301 * to contain a sparkle link and perhaps a photo.
2305 $bdtext = sprintf( t('%s\'s birthday'), $contact['name']);
2306 $bdtext2 = sprintf( t('Happy Birthday %s'), ' [url=' . $contact['url'] . ']' . $contact['name'] . '[/url]' ) ;
2309 $r = q("INSERT INTO `event` (`uid`,`cid`,`created`,`edited`,`start`,`finish`,`summary`,`desc`,`type`)
2310 VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) ",
2311 intval($contact['uid']),
2312 intval($contact['id']),
2313 dbesc(datetime_convert()),
2314 dbesc(datetime_convert()),
2315 dbesc(datetime_convert('UTC','UTC', $birthday)),
2316 dbesc(datetime_convert('UTC','UTC', $birthday . ' + 1 day ')),
2325 q("UPDATE `contact` SET `bdyear` = '%s' WHERE `uid` = %d AND `id` = %d",
2326 dbesc(substr($birthday,0,4)),
2327 intval($contact['uid']),
2328 intval($contact['id'])
2331 // This function is called twice without reloading the contact
2332 // Make sure we only create one event. This is why &$contact
2333 // is a reference var in this function
2335 $contact['bdyear'] = substr($birthday,0,4);
2339 $community_page = 0;
2340 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2342 $community_page = intval($rawtags[0]['data']);
2344 if(is_array($contact) && intval($contact['forum']) != $community_page) {
2345 q("update contact set forum = %d where id = %d",
2346 intval($community_page),
2347 intval($contact['id'])
2349 $contact['forum'] = (string) $community_page;
2353 // process any deleted entries
2355 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2356 if(is_array($del_entries) && count($del_entries) && $pass != 2) {
2357 foreach($del_entries as $dentry) {
2359 if(isset($dentry['attribs']['']['ref'])) {
2360 $uri = $dentry['attribs']['']['ref'];
2362 if(isset($dentry['attribs']['']['when'])) {
2363 $when = $dentry['attribs']['']['when'];
2364 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2367 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2369 if($deleted && is_array($contact)) {
2370 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN `contact` on `item`.`contact-id` = `contact`.`id`
2371 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
2373 intval($importer['uid']),
2374 intval($contact['id'])
2379 if(! $item['deleted'])
2380 logger('consume_feed: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
2382 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2383 $xo = parse_xml_string($item['object'],false);
2384 $xt = parse_xml_string($item['target'],false);
2385 if($xt->type === ACTIVITY_OBJ_NOTE) {
2386 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
2388 intval($importer['importer_uid'])
2392 // For tags, the owner cannot remove the tag on the author's copy of the post.
2394 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
2395 $author_remove = (($item['origin'] && $item['self']) ? true : false);
2396 $author_copy = (($item['origin']) ? true : false);
2398 if($owner_remove && $author_copy)
2400 if($author_remove || $owner_remove) {
2401 $tags = explode(',',$i[0]['tag']);
2404 foreach($tags as $tag)
2405 if(trim($tag) !== trim($xo->body))
2406 $newtags[] = trim($tag);
2408 q("update item set tag = '%s' where id = %d",
2409 dbesc(implode(',',$newtags)),
2412 create_tags_from_item($i[0]['id']);
2418 if($item['uri'] == $item['parent-uri']) {
2419 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2420 `body` = '', `title` = ''
2421 WHERE `parent-uri` = '%s' AND `uid` = %d",
2423 dbesc(datetime_convert()),
2424 dbesc($item['uri']),
2425 intval($importer['uid'])
2427 create_tags_from_itemuri($item['uri'], $importer['uid']);
2428 create_files_from_itemuri($item['uri'], $importer['uid']);
2429 update_thread_uri($item['uri'], $importer['uid']);
2432 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2433 `body` = '', `title` = ''
2434 WHERE `uri` = '%s' AND `uid` = %d",
2436 dbesc(datetime_convert()),
2438 intval($importer['uid'])
2440 create_tags_from_itemuri($uri, $importer['uid']);
2441 create_files_from_itemuri($uri, $importer['uid']);
2442 if($item['last-child']) {
2443 // ensure that last-child is set in case the comment that had it just got wiped.
2444 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
2445 dbesc(datetime_convert()),
2446 dbesc($item['parent-uri']),
2447 intval($item['uid'])
2449 // who is the last child now?
2450 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `moderated` = 0 AND `uid` = %d
2451 ORDER BY `created` DESC LIMIT 1",
2452 dbesc($item['parent-uri']),
2453 intval($importer['uid'])
2456 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
2467 // Now process the feed
2469 if($feed->get_item_quantity()) {
2471 logger('consume_feed: feed item count = ' . $feed->get_item_quantity());
2473 // in inverse date order
2475 $items = array_reverse($feed->get_items());
2477 $items = $feed->get_items();
2480 foreach($items as $item) {
2483 $item_id = $item->get_id();
2484 $rawthread = $item->get_item_tags( NAMESPACE_THREAD,'in-reply-to');
2485 if(isset($rawthread[0]['attribs']['']['ref'])) {
2487 $parent_uri = $rawthread[0]['attribs']['']['ref'];
2490 if(($is_reply) && is_array($contact)) {
2495 // not allowed to post
2497 if($contact['rel'] == CONTACT_IS_FOLLOWER)
2501 // Have we seen it? If not, import it.
2503 $item_id = $item->get_id();
2504 $datarray = get_atom_elements($feed, $item, $contact);
2506 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2507 $datarray['author-name'] = $contact['name'];
2508 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2509 $datarray['author-link'] = $contact['url'];
2510 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2511 $datarray['author-avatar'] = $contact['thumb'];
2513 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2514 logger('consume_feed: no author information! ' . print_r($datarray,true));
2518 $force_parent = false;
2519 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2520 if($contact['network'] === NETWORK_OSTATUS)
2521 $force_parent = true;
2522 if(strlen($datarray['title']))
2523 unset($datarray['title']);
2524 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2525 dbesc(datetime_convert()),
2527 intval($importer['uid'])
2529 $datarray['last-child'] = 1;
2530 update_thread_uri($parent_uri, $importer['uid']);
2534 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2536 intval($importer['uid'])
2539 // Update content if 'updated' changes
2542 if (edited_timestamp_is_newer($r[0], $datarray)) {
2544 // do not accept (ignore) an earlier edit than one we currently have.
2545 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2548 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2549 dbesc($datarray['title']),
2550 dbesc($datarray['body']),
2551 dbesc($datarray['tag']),
2552 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2553 dbesc(datetime_convert()),
2555 intval($importer['uid'])
2557 create_tags_from_itemuri($item_id, $importer['uid']);
2558 update_thread_uri($item_id, $importer['uid']);
2561 // update last-child if it changes
2563 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2564 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
2565 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2566 dbesc(datetime_convert()),
2568 intval($importer['uid'])
2570 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2571 intval($allow[0]['data']),
2572 dbesc(datetime_convert()),
2574 intval($importer['uid'])
2576 update_thread_uri($item_id, $importer['uid']);
2582 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2583 // one way feed - no remote comment ability
2584 $datarray['last-child'] = 0;
2586 $datarray['parent-uri'] = $parent_uri;
2587 $datarray['uid'] = $importer['uid'];
2588 $datarray['contact-id'] = $contact['id'];
2589 if((activity_match($datarray['verb'],ACTIVITY_LIKE)) || (activity_match($datarray['verb'],ACTIVITY_DISLIKE))) {
2590 $datarray['type'] = 'activity';
2591 $datarray['gravity'] = GRAVITY_LIKE;
2592 // only one like or dislike per person
2593 // splitted into two queries for performance issues
2594 $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",
2595 intval($datarray['uid']),
2596 intval($datarray['contact-id']),
2597 dbesc($datarray['verb']),
2603 $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",
2604 intval($datarray['uid']),
2605 intval($datarray['contact-id']),
2606 dbesc($datarray['verb']),
2613 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2614 $xo = parse_xml_string($datarray['object'],false);
2615 $xt = parse_xml_string($datarray['target'],false);
2617 if($xt->type == ACTIVITY_OBJ_NOTE) {
2618 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
2620 intval($importer['importer_uid'])
2625 // extract tag, if not duplicate, add to parent item
2626 if($xo->id && $xo->content) {
2627 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
2628 if(! (stristr($r[0]['tag'],$newtag))) {
2629 q("UPDATE item SET tag = '%s' WHERE id = %d",
2630 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . $newtag),
2633 create_tags_from_item($r[0]['id']);
2639 $r = item_store($datarray,$force_parent);
2645 // Head post of a conversation. Have we seen it? If not, import it.
2647 $item_id = $item->get_id();
2649 $datarray = get_atom_elements($feed, $item, $contact);
2651 if(is_array($contact)) {
2652 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2653 $datarray['author-name'] = $contact['name'];
2654 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2655 $datarray['author-link'] = $contact['url'];
2656 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2657 $datarray['author-avatar'] = $contact['thumb'];
2660 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2661 logger('consume_feed: no author information! ' . print_r($datarray,true));
2665 // special handling for events
2667 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
2668 $ev = bbtoevent($datarray['body']);
2669 if(x($ev,'desc') && x($ev,'start')) {
2670 $ev['uid'] = $importer['uid'];
2671 $ev['uri'] = $item_id;
2672 $ev['edited'] = $datarray['edited'];
2673 $ev['private'] = $datarray['private'];
2675 if(is_array($contact))
2676 $ev['cid'] = $contact['id'];
2677 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2679 intval($importer['uid'])
2682 $ev['id'] = $r[0]['id'];
2683 $xyz = event_store($ev);
2688 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2689 if(strlen($datarray['title']))
2690 unset($datarray['title']);
2691 $datarray['last-child'] = 1;
2695 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2697 intval($importer['uid'])
2700 // Update content if 'updated' changes
2703 if (edited_timestamp_is_newer($r[0], $datarray)) {
2705 // do not accept (ignore) an earlier edit than one we currently have.
2706 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2709 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2710 dbesc($datarray['title']),
2711 dbesc($datarray['body']),
2712 dbesc($datarray['tag']),
2713 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2714 dbesc(datetime_convert()),
2716 intval($importer['uid'])
2718 create_tags_from_itemuri($item_id, $importer['uid']);
2719 update_thread_uri($item_id, $importer['uid']);
2722 // update last-child if it changes
2724 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2725 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
2726 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2727 intval($allow[0]['data']),
2728 dbesc(datetime_convert()),
2730 intval($importer['uid'])
2732 update_thread_uri($item_id, $importer['uid']);
2737 if(activity_match($datarray['verb'],ACTIVITY_FOLLOW)) {
2738 logger('consume-feed: New follower');
2739 new_follower($importer,$contact,$datarray,$item);
2742 if(activity_match($datarray['verb'],ACTIVITY_UNFOLLOW)) {
2743 lose_follower($importer,$contact,$datarray,$item);
2747 if(activity_match($datarray['verb'],ACTIVITY_REQ_FRIEND)) {
2748 logger('consume-feed: New friend request');
2749 new_follower($importer,$contact,$datarray,$item,true);
2752 if(activity_match($datarray['verb'],ACTIVITY_UNFRIEND)) {
2753 lose_sharer($importer,$contact,$datarray,$item);
2758 if(! is_array($contact))
2762 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2763 // one way feed - no remote comment ability
2764 $datarray['last-child'] = 0;
2766 if($contact['network'] === NETWORK_FEED)
2767 $datarray['private'] = 2;
2769 $datarray['parent-uri'] = $item_id;
2770 $datarray['uid'] = $importer['uid'];
2771 $datarray['contact-id'] = $contact['id'];
2773 if(! link_compare($datarray['owner-link'],$contact['url'])) {
2774 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
2775 // but otherwise there's a possible data mixup on the sender's system.
2776 // the tgroup delivery code called from item_store will correct it if it's a forum,
2777 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
2778 logger('consume_feed: Correcting item owner.', LOGGER_DEBUG);
2779 $datarray['owner-name'] = $contact['name'];
2780 $datarray['owner-link'] = $contact['url'];
2781 $datarray['owner-avatar'] = $contact['thumb'];
2784 // We've allowed "followers" to reach this point so we can decide if they are
2785 // posting an @-tag delivery, which followers are allowed to do for certain
2786 // page types. Now that we've parsed the post, let's check if it is legit. Otherwise ignore it.
2788 if(($contact['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['uid'],$datarray)))
2791 // This is my contact on another system, but it's really me.
2792 // Turn this into a wall post.
2793 $notify = item_is_remote_self($contact, $datarray);
2795 $r = item_store($datarray, false, $notify);
2796 logger('Stored - Contact '.$contact['url'].' Notify '.$notify.' return '.$r.' Item '.print_r($datarray, true), LOGGER_DEBUG);
2804 function item_is_remote_self($contact, &$datarray) {
2807 if (!$contact['remote_self'])
2810 // Prevent the forwarding of posts that are forwarded
2811 if ($datarray["extid"] == NETWORK_DFRN)
2814 // Prevent to forward already forwarded posts
2815 if ($datarray["app"] == $a->get_hostname())
2818 // Only forward posts
2819 if ($datarray["verb"] != ACTIVITY_POST)
2822 if (($contact['network'] != NETWORK_FEED) AND $datarray['private'])
2825 $datarray2 = $datarray;
2826 logger('remote-self start - Contact '.$contact['url'].' - '.$contact['remote_self'].' Item '.print_r($datarray, true), LOGGER_DEBUG);
2827 if ($contact['remote_self'] == 2) {
2828 $r = q("SELECT `id`,`url`,`name`,`thumb` FROM `contact` WHERE `uid` = %d AND `self`",
2829 intval($contact['uid']));
2831 $datarray['contact-id'] = $r[0]["id"];
2833 $datarray['owner-name'] = $r[0]["name"];
2834 $datarray['owner-link'] = $r[0]["url"];
2835 $datarray['owner-avatar'] = $r[0]["thumb"];
2837 $datarray['author-name'] = $datarray['owner-name'];
2838 $datarray['author-link'] = $datarray['owner-link'];
2839 $datarray['author-avatar'] = $datarray['owner-avatar'];
2842 if ($contact['network'] != NETWORK_FEED) {
2843 $datarray["guid"] = get_guid(32);
2844 unset($datarray["plink"]);
2845 $datarray["uri"] = item_new_uri($a->get_hostname(),$contact['uid']);
2846 $datarray["parent-uri"] = $datarray["uri"];
2847 $datarray["extid"] = $contact['network'];
2848 $urlpart = parse_url($datarray2['author-link']);
2849 $datarray["app"] = $urlpart["host"];
2851 $datarray['private'] = 0;
2854 //if (!isset($datarray["app"]) OR ($datarray["app"] == ""))
2855 // $datarray["app"] = network_to_name($contact['network']);
2857 if ($contact['network'] != NETWORK_FEED) {
2858 // Store the original post
2859 $r = item_store($datarray2, false, false);
2860 logger('remote-self post original item - Contact '.$contact['url'].' return '.$r.' Item '.print_r($datarray2, true), LOGGER_DEBUG);
2862 $datarray["app"] = "Feed";
2867 function local_delivery($importer,$data) {
2870 logger(__function__, LOGGER_TRACE);
2872 if($importer['readonly']) {
2873 // We aren't receiving stuff from this person. But we will quietly ignore them
2874 // rather than a blatant "go away" message.
2875 logger('local_delivery: ignoring');
2880 // Consume notification feed. This may differ from consuming a public feed in several ways
2881 // - might contain email or friend suggestions
2882 // - might contain remote followup to our message
2883 // - in which case we need to accept it and then notify other conversants
2884 // - we may need to send various email notifications
2886 $feed = new SimplePie();
2887 $feed->set_raw_data($data);
2888 $feed->enable_order_by_date(false);
2893 logger('local_delivery: Error parsing XML: ' . $feed->error());
2896 // Check at the feed level for updated contact name and/or photo
2900 $photo_timestamp = '';
2902 $contact_updated = '';
2905 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2907 // Fallback should not be needed here. If it isn't DFRN it won't have DFRN updated tags
2909 // $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2912 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2913 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2914 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2915 $new_name = $elems['name'][0]['data'];
2917 // Manually checking for changed contact names
2918 if (($new_name != $importer['name']) AND ($new_name != "") AND ($name_updated <= $importer['name-date'])) {
2919 $name_updated = date("c");
2920 $photo_timestamp = date("c");
2923 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2924 if ($photo_timestamp == "")
2925 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2926 $photo_url = $elems['link'][0]['attribs']['']['href'];
2930 if(($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $importer['avatar-date'])) {
2932 $contact_updated = $photo_timestamp;
2934 logger('local_delivery: Updating photo for ' . $importer['name']);
2935 require_once("include/Photo.php");
2936 $photo_failure = false;
2937 $have_photo = false;
2939 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2940 intval($importer['id']),
2941 intval($importer['importer_uid'])
2944 $resource_id = $r[0]['resource-id'];
2948 $resource_id = photo_new_resource();
2951 $img_str = fetch_url($photo_url,true);
2952 // guess mimetype from headers or filename
2953 $type = guess_image_type($photo_url,true);
2956 $img = new Photo($img_str, $type);
2957 if($img->is_valid()) {
2959 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2960 dbesc($resource_id),
2961 intval($importer['id']),
2962 intval($importer['importer_uid'])
2966 $img->scaleImageSquare(175);
2968 $hash = $resource_id;
2969 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2971 $img->scaleImage(80);
2972 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2974 $img->scaleImage(48);
2975 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2979 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2980 WHERE `uid` = %d AND `id` = %d",
2981 dbesc(datetime_convert()),
2982 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2983 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2984 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2985 intval($importer['importer_uid']),
2986 intval($importer['id'])
2991 if(($name_updated) && (strlen($new_name)) && ($name_updated > $importer['name-date'])) {
2992 if ($name_updated > $contact_updated)
2993 $contact_updated = $name_updated;
2995 $r = q("select * from contact where uid = %d and id = %d limit 1",
2996 intval($importer['importer_uid']),
2997 intval($importer['id'])
3000 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
3001 dbesc(notags(trim($new_name))),
3002 dbesc(datetime_convert()),
3003 intval($importer['importer_uid']),
3004 intval($importer['id'])
3007 // do our best to update the name on content items
3010 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
3011 dbesc(notags(trim($new_name))),
3012 dbesc($r[0]['name']),
3013 dbesc($r[0]['url']),
3014 intval($importer['importer_uid'])
3019 if ($contact_updated AND $new_name AND $photo_url)
3020 poco_check($importer['url'], $new_name, NETWORK_DFRN, $photo_url, "", "", "", "", "", $contact_updated, 2, $importer['id'], $importer['importer_uid']);
3022 // Currently unsupported - needs a lot of work
3023 $reloc = $feed->get_feed_tags( NAMESPACE_DFRN, 'relocate' );
3024 if(isset($reloc[0]['child'][NAMESPACE_DFRN])) {
3025 $base = $reloc[0]['child'][NAMESPACE_DFRN];
3027 $newloc['uid'] = $importer['importer_uid'];
3028 $newloc['cid'] = $importer['id'];
3029 $newloc['name'] = notags(unxmlify($base['name'][0]['data']));
3030 $newloc['photo'] = notags(unxmlify($base['photo'][0]['data']));
3031 $newloc['thumb'] = notags(unxmlify($base['thumb'][0]['data']));
3032 $newloc['micro'] = notags(unxmlify($base['micro'][0]['data']));
3033 $newloc['url'] = notags(unxmlify($base['url'][0]['data']));
3034 $newloc['request'] = notags(unxmlify($base['request'][0]['data']));
3035 $newloc['confirm'] = notags(unxmlify($base['confirm'][0]['data']));
3036 $newloc['notify'] = notags(unxmlify($base['notify'][0]['data']));
3037 $newloc['poll'] = notags(unxmlify($base['poll'][0]['data']));
3038 $newloc['sitepubkey'] = notags(unxmlify($base['sitepubkey'][0]['data']));
3039 /** relocated user must have original key pair */
3040 /*$newloc['pubkey'] = notags(unxmlify($base['pubkey'][0]['data']));
3041 $newloc['prvkey'] = notags(unxmlify($base['prvkey'][0]['data']));*/
3043 logger("items:relocate contact ".print_r($newloc, true).print_r($importer, true), LOGGER_DEBUG);
3046 $r = q("SELECT photo, url FROM contact WHERE id=%d AND uid=%d;",
3047 intval($importer['id']),
3048 intval($importer['importer_uid']));
3053 $x = q("UPDATE contact SET
3064 `site-pubkey` = '%s'
3065 WHERE id=%d AND uid=%d;",
3066 dbesc($newloc['name']),
3067 dbesc($newloc['photo']),
3068 dbesc($newloc['thumb']),
3069 dbesc($newloc['micro']),
3070 dbesc($newloc['url']),
3071 dbesc(normalise_link($newloc['url'])),
3072 dbesc($newloc['request']),
3073 dbesc($newloc['confirm']),
3074 dbesc($newloc['notify']),
3075 dbesc($newloc['poll']),
3076 dbesc($newloc['sitepubkey']),
3077 intval($importer['id']),
3078 intval($importer['importer_uid']));
3084 'owner-link' => array($old['url'], $newloc['url']),
3085 'author-link' => array($old['url'], $newloc['url']),
3086 'owner-avatar' => array($old['photo'], $newloc['photo']),
3087 'author-avatar' => array($old['photo'], $newloc['photo']),
3089 foreach ($fields as $n=>$f){
3090 $x = q("UPDATE `item` SET `%s`='%s' WHERE `%s`='%s' AND uid=%d",
3093 intval($importer['importer_uid']));
3099 // merge with current record, current contents have priority
3100 // update record, set url-updated
3101 // update profile photos
3107 // handle friend suggestion notification
3109 $sugg = $feed->get_feed_tags( NAMESPACE_DFRN, 'suggest' );
3110 if(isset($sugg[0]['child'][NAMESPACE_DFRN])) {
3111 $base = $sugg[0]['child'][NAMESPACE_DFRN];
3113 $fsugg['uid'] = $importer['importer_uid'];
3114 $fsugg['cid'] = $importer['id'];
3115 $fsugg['name'] = notags(unxmlify($base['name'][0]['data']));
3116 $fsugg['photo'] = notags(unxmlify($base['photo'][0]['data']));
3117 $fsugg['url'] = notags(unxmlify($base['url'][0]['data']));
3118 $fsugg['request'] = notags(unxmlify($base['request'][0]['data']));
3119 $fsugg['body'] = escape_tags(unxmlify($base['note'][0]['data']));
3121 // Does our member already have a friend matching this description?
3123 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `nurl` = '%s' AND `uid` = %d LIMIT 1",
3124 dbesc($fsugg['name']),
3125 dbesc(normalise_link($fsugg['url'])),
3126 intval($fsugg['uid'])
3131 // Do we already have an fcontact record for this person?
3134 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
3135 dbesc($fsugg['url']),
3136 dbesc($fsugg['name']),
3137 dbesc($fsugg['request'])
3142 // OK, we do. Do we already have an introduction for this person ?
3143 $r = q("select id from intro where uid = %d and fid = %d limit 1",
3144 intval($fsugg['uid']),
3151 $r = q("INSERT INTO `fcontact` ( `name`,`url`,`photo`,`request` ) VALUES ( '%s', '%s', '%s', '%s' ) ",
3152 dbesc($fsugg['name']),
3153 dbesc($fsugg['url']),
3154 dbesc($fsugg['photo']),
3155 dbesc($fsugg['request'])
3157 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
3158 dbesc($fsugg['url']),
3159 dbesc($fsugg['name']),
3160 dbesc($fsugg['request'])
3165 // database record did not get created. Quietly give up.
3170 $hash = random_string();
3172 $r = q("INSERT INTO `intro` ( `uid`, `fid`, `contact-id`, `note`, `hash`, `datetime`, `blocked` )
3173 VALUES( %d, %d, %d, '%s', '%s', '%s', %d )",
3174 intval($fsugg['uid']),
3176 intval($fsugg['cid']),
3177 dbesc($fsugg['body']),
3179 dbesc(datetime_convert()),
3184 'type' => NOTIFY_SUGGEST,
3185 'notify_flags' => $importer['notify-flags'],
3186 'language' => $importer['language'],
3187 'to_name' => $importer['username'],
3188 'to_email' => $importer['email'],
3189 'uid' => $importer['importer_uid'],
3191 'link' => $a->get_baseurl() . '/notifications/intros',
3192 'source_name' => $importer['name'],
3193 'source_link' => $importer['url'],
3194 'source_photo' => $importer['photo'],
3195 'verb' => ACTIVITY_REQ_FRIEND,
3204 $rawmail = $feed->get_feed_tags( NAMESPACE_DFRN, 'mail' );
3205 if(isset($rawmail[0]['child'][NAMESPACE_DFRN])) {
3207 logger('local_delivery: private message received');
3210 $base = $rawmail[0]['child'][NAMESPACE_DFRN];
3213 $msg['uid'] = $importer['importer_uid'];
3214 $msg['from-name'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['name'][0]['data']));
3215 $msg['from-photo'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['avatar'][0]['data']));
3216 $msg['from-url'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['uri'][0]['data']));
3217 $msg['contact-id'] = $importer['id'];
3218 $msg['title'] = notags(unxmlify($base['subject'][0]['data']));
3219 $msg['body'] = escape_tags(unxmlify($base['content'][0]['data']));
3221 $msg['replied'] = 0;
3222 $msg['uri'] = notags(unxmlify($base['id'][0]['data']));
3223 $msg['parent-uri'] = notags(unxmlify($base['in-reply-to'][0]['data']));
3224 $msg['created'] = datetime_convert(notags(unxmlify('UTC','UTC',$base['sentdate'][0]['data'])));
3228 $r = dbq("INSERT INTO `mail` (`" . implode("`, `", array_keys($msg))
3229 . "`) VALUES ('" . implode("', '", array_values($msg)) . "')" );
3231 // send notifications.
3233 require_once('include/enotify.php');
3235 $notif_params = array(
3236 'type' => NOTIFY_MAIL,
3237 'notify_flags' => $importer['notify-flags'],
3238 'language' => $importer['language'],
3239 'to_name' => $importer['username'],
3240 'to_email' => $importer['email'],
3241 'uid' => $importer['importer_uid'],
3243 'source_name' => $msg['from-name'],
3244 'source_link' => $importer['url'],
3245 'source_photo' => $importer['thumb'],
3246 'verb' => ACTIVITY_POST,
3250 notification($notif_params);
3256 $community_page = 0;
3257 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
3259 $community_page = intval($rawtags[0]['data']);
3261 if(intval($importer['forum']) != $community_page) {
3262 q("update contact set forum = %d where id = %d",
3263 intval($community_page),
3264 intval($importer['id'])
3266 $importer['forum'] = (string) $community_page;
3269 logger('local_delivery: feed item count = ' . $feed->get_item_quantity());
3271 // process any deleted entries
3273 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
3274 if(is_array($del_entries) && count($del_entries)) {
3275 foreach($del_entries as $dentry) {
3277 if(isset($dentry['attribs']['']['ref'])) {
3278 $uri = $dentry['attribs']['']['ref'];
3280 if(isset($dentry['attribs']['']['when'])) {
3281 $when = $dentry['attribs']['']['when'];
3282 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
3285 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
3289 // check for relayed deletes to our conversation
3292 $r = q("select * from item where uri = '%s' and uid = %d limit 1",
3294 intval($importer['importer_uid'])
3297 $parent_uri = $r[0]['parent-uri'];
3298 if($r[0]['id'] != $r[0]['parent'])
3305 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3308 logger('local_delivery: possible community delete');
3311 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3313 // was the top-level post for this reply written by somebody on this site?
3314 // Specifically, the recipient?
3316 $is_a_remote_delete = false;
3318 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3319 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3320 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3321 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3322 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3323 AND `item`.`uid` = %d
3329 intval($importer['importer_uid'])
3332 $is_a_remote_delete = true;
3334 // Does this have the characteristics of a community or private group comment?
3335 // If it's a reply to a wall post on a community/prvgroup page it's a
3336 // valid community comment. Also forum_mode makes it valid for sure.
3337 // If neither, it's not.
3339 if($is_a_remote_delete && $community) {
3340 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3341 $is_a_remote_delete = false;
3342 logger('local_delivery: not a community delete');
3346 if($is_a_remote_delete) {
3347 logger('local_delivery: received remote delete');
3351 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN contact on `item`.`contact-id` = `contact`.`id`
3352 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
3354 intval($importer['importer_uid']),
3355 intval($importer['id'])
3361 if($item['deleted'])
3364 logger('local_delivery: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
3366 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3367 $xo = parse_xml_string($item['object'],false);
3368 $xt = parse_xml_string($item['target'],false);
3370 if($xt->type === ACTIVITY_OBJ_NOTE) {
3371 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
3373 intval($importer['importer_uid'])
3377 // For tags, the owner cannot remove the tag on the author's copy of the post.
3379 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
3380 $author_remove = (($item['origin'] && $item['self']) ? true : false);
3381 $author_copy = (($item['origin']) ? true : false);
3383 if($owner_remove && $author_copy)
3385 if($author_remove || $owner_remove) {
3386 $tags = explode(',',$i[0]['tag']);
3389 foreach($tags as $tag)
3390 if(trim($tag) !== trim($xo->body))
3391 $newtags[] = trim($tag);
3393 q("update item set tag = '%s' where id = %d",
3394 dbesc(implode(',',$newtags)),
3397 create_tags_from_item($i[0]['id']);
3403 if($item['uri'] == $item['parent-uri']) {
3404 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3405 `body` = '', `title` = ''
3406 WHERE `parent-uri` = '%s' AND `uid` = %d",
3408 dbesc(datetime_convert()),
3409 dbesc($item['uri']),
3410 intval($importer['importer_uid'])
3412 create_tags_from_itemuri($item['uri'], $importer['importer_uid']);
3413 create_files_from_itemuri($item['uri'], $importer['importer_uid']);
3414 update_thread_uri($item['uri'], $importer['importer_uid']);
3417 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3418 `body` = '', `title` = ''
3419 WHERE `uri` = '%s' AND `uid` = %d",
3421 dbesc(datetime_convert()),
3423 intval($importer['importer_uid'])
3425 create_tags_from_itemuri($uri, $importer['importer_uid']);
3426 create_files_from_itemuri($uri, $importer['importer_uid']);
3427 update_thread_uri($uri, $importer['importer_uid']);
3428 if($item['last-child']) {
3429 // ensure that last-child is set in case the comment that had it just got wiped.
3430 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
3431 dbesc(datetime_convert()),
3432 dbesc($item['parent-uri']),
3433 intval($item['uid'])
3435 // who is the last child now?
3436 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d
3437 ORDER BY `created` DESC LIMIT 1",
3438 dbesc($item['parent-uri']),
3439 intval($importer['importer_uid'])
3442 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
3447 // if this is a relayed delete, propagate it to other recipients
3449 if($is_a_remote_delete)
3450 proc_run('php',"include/notifier.php","drop",$item['id']);
3458 foreach($feed->get_items() as $item) {
3461 $item_id = $item->get_id();
3462 $rawthread = $item->get_item_tags( NAMESPACE_THREAD, 'in-reply-to');
3463 if(isset($rawthread[0]['attribs']['']['ref'])) {
3465 $parent_uri = $rawthread[0]['attribs']['']['ref'];
3471 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3474 logger('local_delivery: possible community reply');
3477 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3479 // was the top-level post for this reply written by somebody on this site?
3480 // Specifically, the recipient?
3482 $is_a_remote_comment = false;
3483 $top_uri = $parent_uri;
3485 $r = q("select `item`.`parent-uri` from `item`
3486 WHERE `item`.`uri` = '%s'
3490 if($r && count($r)) {
3491 $top_uri = $r[0]['parent-uri'];
3493 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3494 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3495 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3496 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3497 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3498 AND `item`.`uid` = %d
3504 intval($importer['importer_uid'])
3507 $is_a_remote_comment = true;
3510 // Does this have the characteristics of a community or private group comment?
3511 // If it's a reply to a wall post on a community/prvgroup page it's a
3512 // valid community comment. Also forum_mode makes it valid for sure.
3513 // If neither, it's not.
3515 if($is_a_remote_comment && $community) {
3516 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3517 $is_a_remote_comment = false;
3518 logger('local_delivery: not a community reply');
3522 if($is_a_remote_comment) {
3523 logger('local_delivery: received remote comment');
3525 // remote reply to our post. Import and then notify everybody else.
3527 $datarray = get_atom_elements($feed, $item);
3529 $r = q("SELECT `id`, `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3531 intval($importer['importer_uid'])
3534 // Update content if 'updated' changes
3538 if (edited_timestamp_is_newer($r[0], $datarray)) {
3540 // do not accept (ignore) an earlier edit than one we currently have.
3541 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3544 logger('received updated comment' , LOGGER_DEBUG);
3545 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3546 dbesc($datarray['title']),
3547 dbesc($datarray['body']),
3548 dbesc($datarray['tag']),
3549 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3550 dbesc(datetime_convert()),
3552 intval($importer['importer_uid'])
3554 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3556 proc_run('php',"include/notifier.php","comment-import",$iid);
3565 $own = q("select name,url,thumb from contact where uid = %d and self = 1 limit 1",
3566 intval($importer['importer_uid'])
3570 $datarray['type'] = 'remote-comment';
3571 $datarray['wall'] = 1;
3572 $datarray['parent-uri'] = $parent_uri;
3573 $datarray['uid'] = $importer['importer_uid'];
3574 $datarray['owner-name'] = $own[0]['name'];
3575 $datarray['owner-link'] = $own[0]['url'];
3576 $datarray['owner-avatar'] = $own[0]['thumb'];
3577 $datarray['contact-id'] = $importer['id'];
3579 if(($datarray['verb'] === ACTIVITY_LIKE) || ($datarray['verb'] === ACTIVITY_DISLIKE)) {
3581 $datarray['type'] = 'activity';
3582 $datarray['gravity'] = GRAVITY_LIKE;
3583 $datarray['last-child'] = 0;
3584 // only one like or dislike per person
3585 // splitted into two queries for performance issues
3586 $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",
3587 intval($datarray['uid']),
3588 intval($datarray['contact-id']),
3589 dbesc($datarray['verb']),
3590 dbesc($datarray['parent-uri'])
3596 $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",
3597 intval($datarray['uid']),
3598 intval($datarray['contact-id']),
3599 dbesc($datarray['verb']),
3600 dbesc($datarray['parent-uri'])
3607 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3609 $xo = parse_xml_string($datarray['object'],false);
3610 $xt = parse_xml_string($datarray['target'],false);
3612 if(($xt->type == ACTIVITY_OBJ_NOTE) && ($xt->id)) {
3614 // fetch the parent item
3616 $tagp = q("select * from item where uri = '%s' and uid = %d limit 1",
3618 intval($importer['importer_uid'])
3623 // extract tag, if not duplicate, and this user allows tags, add to parent item
3625 if($xo->id && $xo->content) {
3626 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
3627 if(! (stristr($tagp[0]['tag'],$newtag))) {
3628 $i = q("SELECT `blocktags` FROM `user` where `uid` = %d LIMIT 1",
3629 intval($importer['importer_uid'])
3631 if(count($i) && ! intval($i[0]['blocktags'])) {
3632 q("UPDATE item SET tag = '%s', `edited` = '%s', `changed` = '%s' WHERE id = %d",
3633 dbesc($tagp[0]['tag'] . (strlen($tagp[0]['tag']) ? ',' : '') . $newtag),
3634 intval($tagp[0]['id']),
3635 dbesc(datetime_convert()),
3636 dbesc(datetime_convert())
3638 create_tags_from_item($tagp[0]['id']);
3646 $posted_id = item_store($datarray);
3650 $r = q("SELECT `parent`, `parent-uri` FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3652 intval($importer['importer_uid'])
3655 $parent = $r[0]['parent'];
3656 $parent_uri = $r[0]['parent-uri'];
3660 $r1 = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `uid` = %d AND `parent` = %d",
3661 dbesc(datetime_convert()),
3662 intval($importer['importer_uid']),
3663 intval($r[0]['parent'])
3666 $r2 = q("UPDATE `item` SET `last-child` = 1, `changed` = '%s' WHERE `uid` = %d AND `id` = %d",
3667 dbesc(datetime_convert()),
3668 intval($importer['importer_uid']),
3673 if($posted_id && $parent) {
3675 proc_run('php',"include/notifier.php","comment-import","$posted_id");
3677 if((! $is_like) && (! $importer['self'])) {
3679 require_once('include/enotify.php');
3682 'type' => NOTIFY_COMMENT,
3683 'notify_flags' => $importer['notify-flags'],
3684 'language' => $importer['language'],
3685 'to_name' => $importer['username'],
3686 'to_email' => $importer['email'],
3687 'uid' => $importer['importer_uid'],
3688 'item' => $datarray,
3689 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3690 'source_name' => stripslashes($datarray['author-name']),
3691 'source_link' => $datarray['author-link'],
3692 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3693 ? $importer['thumb'] : $datarray['author-avatar']),
3694 'verb' => ACTIVITY_POST,
3696 'parent' => $parent,
3697 'parent_uri' => $parent_uri,
3709 // regular comment that is part of this total conversation. Have we seen it? If not, import it.
3711 $item_id = $item->get_id();
3712 $datarray = get_atom_elements($feed,$item);
3714 if($importer['rel'] == CONTACT_IS_FOLLOWER)
3717 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3719 intval($importer['importer_uid'])
3722 // Update content if 'updated' changes
3725 if (edited_timestamp_is_newer($r[0], $datarray)) {
3727 // do not accept (ignore) an earlier edit than one we currently have.
3728 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3731 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3732 dbesc($datarray['title']),
3733 dbesc($datarray['body']),
3734 dbesc($datarray['tag']),
3735 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3736 dbesc(datetime_convert()),
3738 intval($importer['importer_uid'])
3740 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3743 // update last-child if it changes
3745 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3746 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
3747 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
3748 dbesc(datetime_convert()),
3750 intval($importer['importer_uid'])
3752 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3753 intval($allow[0]['data']),
3754 dbesc(datetime_convert()),
3756 intval($importer['importer_uid'])
3762 $datarray['parent-uri'] = $parent_uri;
3763 $datarray['uid'] = $importer['importer_uid'];
3764 $datarray['contact-id'] = $importer['id'];
3765 if(($datarray['verb'] == ACTIVITY_LIKE) || ($datarray['verb'] == ACTIVITY_DISLIKE)) {
3766 $datarray['type'] = 'activity';
3767 $datarray['gravity'] = GRAVITY_LIKE;
3768 // only one like or dislike per person
3769 // splitted into two queries for performance issues
3770 $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",
3771 intval($datarray['uid']),
3772 intval($datarray['contact-id']),
3773 dbesc($datarray['verb']),
3779 $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",
3780 intval($datarray['uid']),
3781 intval($datarray['contact-id']),
3782 dbesc($datarray['verb']),
3790 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3792 $xo = parse_xml_string($datarray['object'],false);
3793 $xt = parse_xml_string($datarray['target'],false);
3795 if($xt->type == ACTIVITY_OBJ_NOTE) {
3796 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
3798 intval($importer['importer_uid'])
3803 // extract tag, if not duplicate, add to parent item
3805 if(! (stristr($r[0]['tag'],trim($xo->content)))) {
3806 q("UPDATE item SET tag = '%s' WHERE id = %d",
3807 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]'),
3810 create_tags_from_item($r[0]['id']);
3816 $posted_id = item_store($datarray);
3818 // find out if our user is involved in this conversation and wants to be notified.
3820 if(!x($datarray['type']) || $datarray['type'] != 'activity') {
3822 $myconv = q("SELECT `author-link`, `author-avatar`, `parent` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `parent` != 0 AND `deleted` = 0",
3824 intval($importer['importer_uid'])
3827 if(count($myconv)) {
3828 $importer_url = $a->get_baseurl() . '/profile/' . $importer['nickname'];
3830 // first make sure this isn't our own post coming back to us from a wall-to-wall event
3831 if(! link_compare($datarray['author-link'],$importer_url)) {
3834 foreach($myconv as $conv) {
3836 // now if we find a match, it means we're in this conversation
3838 if(! link_compare($conv['author-link'],$importer_url))
3841 require_once('include/enotify.php');
3843 $conv_parent = $conv['parent'];
3846 'type' => NOTIFY_COMMENT,
3847 'notify_flags' => $importer['notify-flags'],
3848 'language' => $importer['language'],
3849 'to_name' => $importer['username'],
3850 'to_email' => $importer['email'],
3851 'uid' => $importer['importer_uid'],
3852 'item' => $datarray,
3853 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3854 'source_name' => stripslashes($datarray['author-name']),
3855 'source_link' => $datarray['author-link'],
3856 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3857 ? $importer['thumb'] : $datarray['author-avatar']),
3858 'verb' => ACTIVITY_POST,
3860 'parent' => $conv_parent,
3861 'parent_uri' => $parent_uri
3865 // only send one notification
3877 // Head post of a conversation. Have we seen it? If not, import it.
3880 $item_id = $item->get_id();
3881 $datarray = get_atom_elements($feed,$item);
3883 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
3884 $ev = bbtoevent($datarray['body']);
3885 if(x($ev,'desc') && x($ev,'start')) {
3886 $ev['cid'] = $importer['id'];
3887 $ev['uid'] = $importer['uid'];
3888 $ev['uri'] = $item_id;
3889 $ev['edited'] = $datarray['edited'];
3890 $ev['private'] = $datarray['private'];
3892 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3894 intval($importer['uid'])
3897 $ev['id'] = $r[0]['id'];
3898 $xyz = event_store($ev);
3903 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3905 intval($importer['importer_uid'])
3908 // Update content if 'updated' changes
3911 if (edited_timestamp_is_newer($r[0], $datarray)) {
3913 // do not accept (ignore) an earlier edit than one we currently have.
3914 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3917 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3918 dbesc($datarray['title']),
3919 dbesc($datarray['body']),
3920 dbesc($datarray['tag']),
3921 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3922 dbesc(datetime_convert()),
3924 intval($importer['importer_uid'])
3926 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3927 update_thread_uri($item_id, $importer['importer_uid']);
3930 // update last-child if it changes
3932 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3933 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
3934 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3935 intval($allow[0]['data']),
3936 dbesc(datetime_convert()),
3938 intval($importer['importer_uid'])
3944 $datarray['parent-uri'] = $item_id;
3945 $datarray['uid'] = $importer['importer_uid'];
3946 $datarray['contact-id'] = $importer['id'];
3949 if(! link_compare($datarray['owner-link'],$importer['url'])) {
3950 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
3951 // but otherwise there's a possible data mixup on the sender's system.
3952 // the tgroup delivery code called from item_store will correct it if it's a forum,
3953 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
3954 logger('local_delivery: Correcting item owner.', LOGGER_DEBUG);
3955 $datarray['owner-name'] = $importer['senderName'];
3956 $datarray['owner-link'] = $importer['url'];
3957 $datarray['owner-avatar'] = $importer['thumb'];
3960 if(($importer['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['importer_uid'],$datarray)))
3963 // This is my contact on another system, but it's really me.
3964 // Turn this into a wall post.
3965 $notify = item_is_remote_self($importer, $datarray);
3967 $posted_id = item_store($datarray, false, $notify);
3969 if(stristr($datarray['verb'],ACTIVITY_POKE)) {
3970 $verb = urldecode(substr($datarray['verb'],strpos($datarray['verb'],'#')+1));
3973 $xo = parse_xml_string($datarray['object'],false);
3975 if(($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
3977 // somebody was poked/prodded. Was it me?
3979 $links = parse_xml_string("<links>".unxmlify($xo->link)."</links>",false);
3981 foreach($links->link as $l) {
3982 $atts = $l->attributes();
3983 switch($atts['rel']) {
3985 $Blink = $atts['href'];
3991 if($Blink && link_compare($Blink,$a->get_baseurl() . '/profile/' . $importer['nickname'])) {
3993 // send a notification
3994 require_once('include/enotify.php');
3997 'type' => NOTIFY_POKE,
3998 'notify_flags' => $importer['notify-flags'],
3999 'language' => $importer['language'],
4000 'to_name' => $importer['username'],
4001 'to_email' => $importer['email'],
4002 'uid' => $importer['importer_uid'],
4003 'item' => $datarray,
4004 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
4005 'source_name' => stripslashes($datarray['author-name']),
4006 'source_link' => $datarray['author-link'],
4007 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
4008 ? $importer['thumb'] : $datarray['author-avatar']),
4009 'verb' => $datarray['verb'],
4010 'otype' => 'person',
4011 'activity' => $verb,
4028 function new_follower($importer,$contact,$datarray,$item,$sharing = false) {
4029 $url = notags(trim($datarray['author-link']));
4030 $name = notags(trim($datarray['author-name']));
4031 $photo = notags(trim($datarray['author-avatar']));
4033 $rawtag = $item->get_item_tags(NAMESPACE_ACTIVITY,'actor');
4034 if($rawtag && $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'])
4035 $nick = $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'];
4037 if(is_array($contact)) {
4038 if(($contact['network'] == NETWORK_OSTATUS && $contact['rel'] == CONTACT_IS_SHARING)
4039 || ($sharing && $contact['rel'] == CONTACT_IS_FOLLOWER)) {
4040 $r = q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
4041 intval(CONTACT_IS_FRIEND),
4042 intval($contact['id']),
4043 intval($importer['uid'])
4046 // send email notification to owner?
4050 // create contact record
4052 $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `name`, `nick`, `photo`, `network`, `rel`,
4053 `blocked`, `readonly`, `pending`, `writable` )
4054 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, 1 ) ",
4055 intval($importer['uid']),
4056 dbesc(datetime_convert()),
4058 dbesc(normalise_link($url)),
4062 dbesc(($sharing) ? NETWORK_ZOT : NETWORK_OSTATUS),
4063 intval(($sharing) ? CONTACT_IS_SHARING : CONTACT_IS_FOLLOWER)
4065 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `url` = '%s' AND `pending` = 1 LIMIT 1",
4066 intval($importer['uid']),
4070 $contact_record = $r[0];
4072 // create notification
4073 $hash = random_string();
4075 if(is_array($contact_record)) {
4076 $ret = q("INSERT INTO `intro` ( `uid`, `contact-id`, `blocked`, `knowyou`, `hash`, `datetime`)
4077 VALUES ( %d, %d, 0, 0, '%s', '%s' )",
4078 intval($importer['uid']),
4079 intval($contact_record['id']),
4081 dbesc(datetime_convert())
4085 $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
4086 intval($importer['uid'])
4091 if(intval($r[0]['def_gid'])) {
4092 require_once('include/group.php');
4093 group_add_member($r[0]['uid'],'',$contact_record['id'],$r[0]['def_gid']);
4096 if(($r[0]['notify-flags'] & NOTIFY_INTRO) &&
4097 (($r[0]['page-flags'] == PAGE_NORMAL) OR ($r[0]['page-flags'] == PAGE_SOAPBOX))) {
4102 'type' => NOTIFY_INTRO,
4103 'notify_flags' => $r[0]['notify-flags'],
4104 'language' => $r[0]['language'],
4105 'to_name' => $r[0]['username'],
4106 'to_email' => $r[0]['email'],
4107 'uid' => $r[0]['uid'],
4108 'link' => $a->get_baseurl() . '/notifications/intro',
4109 'source_name' => ((strlen(stripslashes($contact_record['name']))) ? stripslashes($contact_record['name']) : t('[Name Withheld]')),
4110 'source_link' => $contact_record['url'],
4111 'source_photo' => $contact_record['photo'],
4112 'verb' => ($sharing ? ACTIVITY_FRIEND : ACTIVITY_FOLLOW),
4122 function lose_follower($importer,$contact,$datarray,$item) {
4124 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_SHARING)) {
4125 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
4126 intval(CONTACT_IS_SHARING),
4127 intval($contact['id'])
4131 contact_remove($contact['id']);
4135 function lose_sharer($importer,$contact,$datarray,$item) {
4137 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_FOLLOWER)) {
4138 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
4139 intval(CONTACT_IS_FOLLOWER),
4140 intval($contact['id'])
4144 contact_remove($contact['id']);
4149 function subscribe_to_hub($url,$importer,$contact,$hubmode = 'subscribe') {
4153 if(is_array($importer)) {
4154 $r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
4155 intval($importer['uid'])
4159 // Diaspora has different message-ids in feeds than they do
4160 // through the direct Diaspora protocol. If we try and use
4161 // the feed, we'll get duplicates. So don't.
4163 if((! count($r)) || $contact['network'] === NETWORK_DIASPORA)
4166 $push_url = get_config('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
4168 // Use a single verify token, even if multiple hubs
4170 $verify_token = ((strlen($contact['hub-verify'])) ? $contact['hub-verify'] : random_string());
4172 $params= 'hub.mode=' . $hubmode . '&hub.callback=' . urlencode($push_url) . '&hub.topic=' . urlencode($contact['poll']) . '&hub.verify=async&hub.verify_token=' . $verify_token;
4174 logger('subscribe_to_hub: ' . $hubmode . ' ' . $contact['name'] . ' to hub ' . $url . ' endpoint: ' . $push_url . ' with verifier ' . $verify_token);
4176 if(! strlen($contact['hub-verify'])) {
4177 $r = q("UPDATE `contact` SET `hub-verify` = '%s' WHERE `id` = %d",
4178 dbesc($verify_token),
4179 intval($contact['id'])
4183 post_url($url,$params);
4185 logger('subscribe_to_hub: returns: ' . $a->get_curl_code(), LOGGER_DEBUG);
4192 function atom_author($tag,$name,$uri,$h,$w,$photo) {
4196 $name = xmlify($name);
4197 $uri = xmlify($uri);
4200 $photo = xmlify($photo);
4204 $o .= "<name>$name</name>\r\n";
4205 $o .= "<uri>$uri</uri>\r\n";
4206 $o .= '<link rel="photo" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4207 $o .= '<link rel="avatar" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4209 call_hooks('atom_author', $o);
4211 $o .= "</$tag>\r\n";
4215 function atom_entry($item,$type,$author,$owner,$comment = false,$cid = 0) {
4219 if(! $item['parent'])
4222 if($item['deleted'])
4223 return '<at:deleted-entry ref="' . xmlify($item['uri']) . '" when="' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '" />' . "\r\n";
4226 if($item['allow_cid'] || $item['allow_gid'] || $item['deny_cid'] || $item['deny_gid'])
4227 $body = fix_private_photos($item['body'],$owner['uid'],$item,$cid);
4229 $body = $item['body'];
4232 $o = "\r\n\r\n<entry>\r\n";
4234 if(is_array($author))
4235 $o .= atom_author('author',$author['name'],$author['url'],80,80,$author['thumb']);
4237 $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']));
4238 if(strlen($item['owner-name']))
4239 $o .= atom_author('dfrn:owner',$item['owner-name'],$item['owner-link'],80,80,$item['owner-avatar']);
4241 if(($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
4242 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
4243 $o .= '<thr:in-reply-to ref="' . xmlify($parent_item) . '" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['parent']) . '" />' . "\r\n";
4248 if ($item['title'] != "")
4249 $htmlbody = "[b]".$item['title']."[/b]\n\n".$htmlbody;
4251 $htmlbody = bbcode(bb_remove_share_information($htmlbody), false, false, 7);
4253 $o .= '<id>' . xmlify($item['uri']) . '</id>' . "\r\n";
4254 $o .= '<title>' . xmlify($item['title']) . '</title>' . "\r\n";
4255 $o .= '<published>' . xmlify(datetime_convert('UTC','UTC',$item['created'] . '+00:00',ATOM_TIME)) . '</published>' . "\r\n";
4256 $o .= '<updated>' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '</updated>' . "\r\n";
4257 $o .= '<dfrn:env>' . base64url_encode($body, true) . '</dfrn:env>' . "\r\n";
4258 $o .= '<content type="' . $type . '" >' . xmlify((($type === 'html') ? $htmlbody : $body)) . '</content>' . "\r\n";
4259 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['id']) . '" />' . "\r\n";
4263 $o .= '<dfrn:comment-allow>' . intval($item['last-child']) . '</dfrn:comment-allow>' . "\r\n";
4265 if($item['location']) {
4266 $o .= '<dfrn:location>' . xmlify($item['location']) . '</dfrn:location>' . "\r\n";
4267 $o .= '<poco:address><poco:formatted>' . xmlify($item['location']) . '</poco:formatted></poco:address>' . "\r\n";
4271 $o .= '<georss:point>' . xmlify($item['coord']) . '</georss:point>' . "\r\n";
4273 if(($item['private']) || strlen($item['allow_cid']) || strlen($item['allow_gid']) || strlen($item['deny_cid']) || strlen($item['deny_gid']))
4274 $o .= '<dfrn:private>' . (($item['private']) ? $item['private'] : 1) . '</dfrn:private>' . "\r\n";
4277 $o .= '<dfrn:extid>' . xmlify($item['extid']) . '</dfrn:extid>' . "\r\n";
4278 if($item['bookmark'])
4279 $o .= '<dfrn:bookmark>true</dfrn:bookmark>' . "\r\n";
4282 $o .= '<statusnet:notice_info local_id="' . $item['id'] . '" source="' . xmlify($item['app']) . '" ></statusnet:notice_info>' . "\r\n";
4285 $o .= '<dfrn:diaspora_guid>' . $item['guid'] . '</dfrn:diaspora_guid>' . "\r\n";
4287 if($item['signed_text']) {
4288 $sign = base64_encode(json_encode(array('signed_text' => $item['signed_text'],'signature' => $item['signature'],'signer' => $item['signer'])));
4289 $o .= '<dfrn:diaspora_signature>' . xmlify($sign) . '</dfrn:diaspora_signature>' . "\r\n";
4292 $verb = construct_verb($item);
4293 $o .= '<as:verb>' . xmlify($verb) . '</as:verb>' . "\r\n";
4294 $actobj = construct_activity_object($item);
4297 $actarg = construct_activity_target($item);
4301 $tags = item_getfeedtags($item);
4303 foreach($tags as $t) {
4304 $o .= '<category scheme="X-DFRN:' . xmlify($t[0]) . ':' . xmlify($t[1]) . '" term="' . xmlify($t[2]) . '" />' . "\r\n";
4308 $o .= item_getfeedattach($item);
4310 $mentioned = get_mentions($item);
4314 call_hooks('atom_entry', $o);
4316 $o .= '</entry>' . "\r\n";
4321 function fix_private_photos($s, $uid, $item = null, $cid = 0) {
4323 if(get_config('system','disable_embedded'))
4328 logger('fix_private_photos: check for photos', LOGGER_DEBUG);
4329 $site = substr($a->get_baseurl(),strpos($a->get_baseurl(),'://'));
4334 $img_start = strpos($orig_body, '[img');
4335 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4336 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4337 while( ($img_st_close !== false) && ($img_len !== false) ) {
4339 $img_st_close++; // make it point to AFTER the closing bracket
4340 $image = substr($orig_body, $img_start + $img_st_close, $img_len);
4342 logger('fix_private_photos: found photo ' . $image, LOGGER_DEBUG);
4345 if(stristr($image , $site . '/photo/')) {
4346 // Only embed locally hosted photos
4348 $i = basename($image);
4349 $i = str_replace(array('.jpg','.png','.gif'),array('','',''),$i);
4350 $x = strpos($i,'-');
4353 $res = substr($i,$x+1);
4354 $i = substr($i,0,$x);
4355 $r = q("SELECT * FROM `photo` WHERE `resource-id` = '%s' AND `scale` = %d AND `uid` = %d",
4362 // Check to see if we should replace this photo link with an embedded image
4363 // 1. No need to do so if the photo is public
4364 // 2. If there's a contact-id provided, see if they're in the access list
4365 // for the photo. If so, embed it.
4366 // 3. Otherwise, if we have an item, see if the item permissions match the photo
4367 // permissions, regardless of order but first check to see if they're an exact
4368 // match to save some processing overhead.
4370 if(has_permissions($r[0])) {
4372 $recips = enumerate_permissions($r[0]);
4373 if(in_array($cid, $recips)) {
4378 if(compare_permissions($item,$r[0]))
4383 $data = $r[0]['data'];
4384 $type = $r[0]['type'];
4386 // If a custom width and height were specified, apply before embedding
4387 if(preg_match("/\[img\=([0-9]*)x([0-9]*)\]/is", substr($orig_body, $img_start, $img_st_close), $match)) {
4388 logger('fix_private_photos: scaling photo', LOGGER_DEBUG);
4390 $width = intval($match[1]);
4391 $height = intval($match[2]);
4393 $ph = new Photo($data, $type);
4394 if($ph->is_valid()) {
4395 $ph->scaleImage(max($width, $height));
4396 $data = $ph->imageString();
4397 $type = $ph->getType();
4401 logger('fix_private_photos: replacing photo', LOGGER_DEBUG);
4402 $image = 'data:' . $type . ';base64,' . base64_encode($data);
4403 logger('fix_private_photos: replaced: ' . $image, LOGGER_DATA);
4409 $new_body = $new_body . substr($orig_body, 0, $img_start + $img_st_close) . $image . '[/img]';
4410 $orig_body = substr($orig_body, $img_start + $img_st_close + $img_len + strlen('[/img]'));
4411 if($orig_body === false)
4414 $img_start = strpos($orig_body, '[img');
4415 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4416 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4419 $new_body = $new_body . $orig_body;
4425 function has_permissions($obj) {
4426 if(($obj['allow_cid'] != '') || ($obj['allow_gid'] != '') || ($obj['deny_cid'] != '') || ($obj['deny_gid'] != ''))
4431 function compare_permissions($obj1,$obj2) {
4432 // first part is easy. Check that these are exactly the same.
4433 if(($obj1['allow_cid'] == $obj2['allow_cid'])
4434 && ($obj1['allow_gid'] == $obj2['allow_gid'])
4435 && ($obj1['deny_cid'] == $obj2['deny_cid'])
4436 && ($obj1['deny_gid'] == $obj2['deny_gid']))
4439 // This is harder. Parse all the permissions and compare the resulting set.
4441 $recipients1 = enumerate_permissions($obj1);
4442 $recipients2 = enumerate_permissions($obj2);
4445 if($recipients1 == $recipients2)
4450 // returns an array of contact-ids that are allowed to see this object
4452 function enumerate_permissions($obj) {
4453 require_once('include/group.php');
4454 $allow_people = expand_acl($obj['allow_cid']);
4455 $allow_groups = expand_groups(expand_acl($obj['allow_gid']));
4456 $deny_people = expand_acl($obj['deny_cid']);
4457 $deny_groups = expand_groups(expand_acl($obj['deny_gid']));
4458 $recipients = array_unique(array_merge($allow_people,$allow_groups));
4459 $deny = array_unique(array_merge($deny_people,$deny_groups));
4460 $recipients = array_diff($recipients,$deny);
4464 function item_getfeedtags($item) {
4467 $cnt = preg_match_all('|\#\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4469 for($x = 0; $x < $cnt; $x ++) {
4471 $ret[] = array('#',$matches[1][$x], $matches[2][$x]);
4475 $cnt = preg_match_all('|\@\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4477 for($x = 0; $x < $cnt; $x ++) {
4479 $ret[] = array('@',$matches[1][$x], $matches[2][$x]);
4485 function item_getfeedattach($item) {
4487 $arr = explode('[/attach],',$item['attach']);
4489 foreach($arr as $r) {
4491 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|',$r,$matches);
4493 $ret .= '<link rel="enclosure" href="' . xmlify($matches[1]) . '" type="' . xmlify($matches[3]) . '" ';
4494 if(intval($matches[2]))
4495 $ret .= 'length="' . intval($matches[2]) . '" ';
4496 if($matches[4] !== ' ')
4497 $ret .= 'title="' . xmlify(trim($matches[4])) . '" ';
4498 $ret .= ' />' . "\r\n";
4507 function item_expire($uid, $days, $network = "", $force = false) {
4509 if((! $uid) || ($days < 1))
4512 // $expire_network_only = save your own wall posts
4513 // and just expire conversations started by others
4515 $expire_network_only = get_pconfig($uid,'expire','network_only');
4516 $sql_extra = ((intval($expire_network_only)) ? " AND wall = 0 " : "");
4518 if ($network != "") {
4519 $sql_extra .= sprintf(" AND network = '%s' ", dbesc($network));
4520 // There is an index "uid_network_received" but not "uid_network_created"
4521 // This avoids the creation of another index just for one purpose.
4522 // And it doesn't really matter wether to look at "received" or "created"
4523 $range = "AND `received` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4525 $range = "AND `created` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4527 $r = q("SELECT * FROM `item`
4528 WHERE `uid` = %d $range
4539 $expire_items = get_pconfig($uid, 'expire','items');
4540 $expire_items = (($expire_items===false)?1:intval($expire_items)); // default if not set: 1
4542 // Forcing expiring of items - but not notes and marked items
4544 $expire_items = true;
4546 $expire_notes = get_pconfig($uid, 'expire','notes');
4547 $expire_notes = (($expire_notes===false)?1:intval($expire_notes)); // default if not set: 1
4549 $expire_starred = get_pconfig($uid, 'expire','starred');
4550 $expire_starred = (($expire_starred===false)?1:intval($expire_starred)); // default if not set: 1
4552 $expire_photos = get_pconfig($uid, 'expire','photos');
4553 $expire_photos = (($expire_photos===false)?0:intval($expire_photos)); // default if not set: 0
4555 logger('expire: # items=' . count($r). "; expire items: $expire_items, expire notes: $expire_notes, expire starred: $expire_starred, expire photos: $expire_photos");
4557 foreach($r as $item) {
4559 // don't expire filed items
4561 if(strpos($item['file'],'[') !== false)
4564 // Only expire posts, not photos and photo comments
4566 if($expire_photos==0 && strlen($item['resource-id']))
4568 if($expire_starred==0 && intval($item['starred']))
4570 if($expire_notes==0 && $item['type']=='note')
4572 if($expire_items==0 && $item['type']!='note')
4575 drop_item($item['id'],false);
4578 proc_run('php',"include/notifier.php","expire","$uid");
4583 function drop_items($items) {
4586 if(! local_user() && ! remote_user())
4590 foreach($items as $item) {
4591 $owner = drop_item($item,false);
4592 if($owner && ! $uid)
4597 // multiple threads may have been deleted, send an expire notification
4600 proc_run('php',"include/notifier.php","expire","$uid");
4604 function drop_item($id,$interactive = true) {
4608 // locate item to be deleted
4610 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
4617 notice( t('Item not found.') . EOL);
4618 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4623 $owner = $item['uid'];
4627 // check if logged in user is either the author or owner of this item
4629 if(is_array($_SESSION['remote'])) {
4630 foreach($_SESSION['remote'] as $visitor) {
4631 if($visitor['uid'] == $item['uid'] && $visitor['cid'] == $item['contact-id']) {
4632 $cid = $visitor['cid'];
4639 if((local_user() == $item['uid']) || ($cid) || (! $interactive)) {
4641 // Check if we should do HTML-based delete confirmation
4642 if($_REQUEST['confirm']) {
4643 // <form> can't take arguments in its "action" parameter
4644 // so add any arguments as hidden inputs
4645 $query = explode_querystring($a->query_string);
4647 foreach($query['args'] as $arg) {
4648 if(strpos($arg, 'confirm=') === false) {
4649 $arg_parts = explode('=', $arg);
4650 $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
4654 return replace_macros(get_markup_template('confirm.tpl'), array(
4656 '$message' => t('Do you really want to delete this item?'),
4657 '$extra_inputs' => $inputs,
4658 '$confirm' => t('Yes'),
4659 '$confirm_url' => $query['base'],
4660 '$confirm_name' => 'confirmed',
4661 '$cancel' => t('Cancel'),
4664 // Now check how the user responded to the confirmation query
4665 if($_REQUEST['canceled']) {
4666 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4669 logger('delete item: ' . $item['id'], LOGGER_DEBUG);
4672 $r = q("UPDATE `item` SET `deleted` = 1, `title` = '', `body` = '', `edited` = '%s', `changed` = '%s' WHERE `id` = %d",
4673 dbesc(datetime_convert()),
4674 dbesc(datetime_convert()),
4677 create_tags_from_item($item['id']);
4678 create_files_from_item($item['id']);
4679 delete_thread($item['id'], $item['parent-uri']);
4681 // clean up categories and tags so they don't end up as orphans
4684 $cnt = preg_match_all('/<(.*?)>/',$item['file'],$matches,PREG_SET_ORDER);
4686 foreach($matches as $mtch) {
4687 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],true);
4693 $cnt = preg_match_all('/\[(.*?)\]/',$item['file'],$matches,PREG_SET_ORDER);
4695 foreach($matches as $mtch) {
4696 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],false);
4700 // If item is a link to a photo resource, nuke all the associated photos
4701 // (visitors will not have photo resources)
4702 // This only applies to photos uploaded from the photos page. Photos inserted into a post do not
4703 // generate a resource-id and therefore aren't intimately linked to the item.
4705 if(strlen($item['resource-id'])) {
4706 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `uid` = %d ",
4707 dbesc($item['resource-id']),
4708 intval($item['uid'])
4710 // ignore the result
4713 // If item is a link to an event, nuke the event record.
4715 if(intval($item['event-id'])) {
4716 q("DELETE FROM `event` WHERE `id` = %d AND `uid` = %d",
4717 intval($item['event-id']),
4718 intval($item['uid'])
4720 // ignore the result
4723 // clean up item_id and sign meta-data tables
4726 // Old code - caused very long queries and warning entries in the mysql logfiles:
4728 $r = q("DELETE FROM item_id where iid in (select id from item where parent = %d and uid = %d)",
4729 intval($item['id']),
4730 intval($item['uid'])
4733 $r = q("DELETE FROM sign where iid in (select id from item where parent = %d and uid = %d)",
4734 intval($item['id']),
4735 intval($item['uid'])
4739 // The new code splits the queries since the mysql optimizer really has bad problems with subqueries
4741 // Creating list of parents
4742 $r = q("select id from item where parent = %d and uid = %d",
4743 intval($item['id']),
4744 intval($item['uid'])
4749 foreach ($r AS $row) {
4750 if ($parentid != "")
4753 $parentid .= $row["id"];
4757 if ($parentid != "") {
4758 $r = q("DELETE FROM item_id where iid in (%s)", dbesc($parentid));
4760 $r = q("DELETE FROM sign where iid in (%s)", dbesc($parentid));
4763 // If it's the parent of a comment thread, kill all the kids
4765 if($item['uri'] == $item['parent-uri']) {
4766 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = ''
4767 WHERE `parent-uri` = '%s' AND `uid` = %d ",
4768 dbesc(datetime_convert()),
4769 dbesc(datetime_convert()),
4770 dbesc($item['parent-uri']),
4771 intval($item['uid'])
4773 create_tags_from_itemuri($item['parent-uri'], $item['uid']);
4774 create_files_from_itemuri($item['parent-uri'], $item['uid']);
4775 delete_thread_uri($item['parent-uri'], $item['uid']);
4776 // ignore the result
4779 // ensure that last-child is set in case the comment that had it just got wiped.
4780 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
4781 dbesc(datetime_convert()),
4782 dbesc($item['parent-uri']),
4783 intval($item['uid'])
4785 // who is the last child now?
4786 $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",
4787 dbesc($item['parent-uri']),
4788 intval($item['uid'])
4791 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
4796 // Add a relayable_retraction signature for Diaspora.
4797 store_diaspora_retract_sig($item, $a->user, $a->get_baseurl());
4799 $drop_id = intval($item['id']);
4801 // send the notification upstream/downstream as the case may be
4803 proc_run('php',"include/notifier.php","drop","$drop_id");
4807 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4813 notice( t('Permission denied.') . EOL);
4814 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4821 function first_post_date($uid,$wall = false) {
4822 $r = q("select id, created from item
4823 where uid = %d and wall = %d and deleted = 0 and visible = 1 AND moderated = 0
4825 order by created asc limit 1",
4827 intval($wall ? 1 : 0)
4830 // logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA);
4831 return substr(datetime_convert('',date_default_timezone_get(),$r[0]['created']),0,10);
4836 function posted_dates($uid,$wall) {
4837 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
4839 $dthen = first_post_date($uid,$wall);
4843 // Set the start and end date to the beginning of the month
4844 $dnow = substr($dnow,0,8).'01';
4845 $dthen = substr($dthen,0,8).'01';
4848 // Starting with the current month, get the first and last days of every
4849 // month down to and including the month of the first post
4850 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
4851 $dstart = substr($dnow,0,8) . '01';
4852 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
4853 $start_month = datetime_convert('','',$dstart,'Y-m-d');
4854 $end_month = datetime_convert('','',$dend,'Y-m-d');
4855 $str = day_translate(datetime_convert('','',$dnow,'F Y'));
4856 $ret[] = array($str,$end_month,$start_month);
4857 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
4863 function posted_date_widget($url,$uid,$wall) {
4866 if(! feature_enabled($uid,'archives'))
4869 // For former Facebook folks that left because of "timeline"
4871 /* if($wall && intval(get_pconfig($uid,'system','no_wall_archive_widget')))
4874 $ret = posted_dates($uid,$wall);
4878 $o = replace_macros(get_markup_template('posted_date_widget.tpl'),array(
4879 '$title' => t('Archives'),
4880 '$size' => ((count($ret) > 6) ? 6 : count($ret)),
4887 function store_diaspora_retract_sig($item, $user, $baseurl) {
4888 // Note that we can't add a target_author_signature
4889 // if the comment was deleted by a remote user. That should be ok, because if a remote user is deleting
4890 // the comment, that means we're the home of the post, and Diaspora will only
4891 // check the parent_author_signature of retractions that it doesn't have to relay further
4893 // I don't think this function gets called for an "unlike," but I'll check anyway
4895 $enabled = intval(get_config('system','diaspora_enabled'));
4897 logger('drop_item: diaspora support disabled, not storing retraction signature', LOGGER_DEBUG);
4901 logger('drop_item: storing diaspora retraction signature');
4903 $signed_text = $item['guid'] . ';' . ( ($item['verb'] === ACTIVITY_LIKE) ? 'Like' : 'Comment');
4905 if(local_user() == $item['uid']) {
4907 $handle = $user['nickname'] . '@' . substr($baseurl, strpos($baseurl,'://') + 3);
4908 $authorsig = base64_encode(rsa_sign($signed_text,$user['prvkey'],'sha256'));
4911 $r = q("SELECT `nick`, `url` FROM `contact` WHERE `id` = '%d' LIMIT 1",
4912 $item['contact-id'] // If this function gets called, drop_item() has already checked remote_user() == $item['contact-id']
4915 // The below handle only works for NETWORK_DFRN. I think that's ok, because this function
4916 // only handles DFRN deletes
4917 $handle_baseurl_start = strpos($r['url'],'://') + 3;
4918 $handle_baseurl_length = strpos($r['url'],'/profile') - $handle_baseurl_start;
4919 $handle = $r['nick'] . '@' . substr($r['url'], $handle_baseurl_start, $handle_baseurl_length);
4925 q("insert into sign (`retract_iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
4926 intval($item['id']),
4927 dbesc($signed_text),