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');
15 function get_feed_for(&$a, $dfrn_id, $owner_nick, $last_update, $direction = 0) {
18 $sitefeed = ((strlen($owner_nick)) ? false : true); // not yet implemented, need to rewrite huge chunks of following logic
19 $public_feed = (($dfrn_id) ? false : true);
20 $starred = false; // not yet implemented, possible security issues
23 if($public_feed && $a->argc > 2) {
24 for($x = 2; $x < $a->argc; $x++) {
25 if($a->argv[$x] == 'converse')
27 if($a->argv[$x] == 'starred')
29 if($a->argv[$x] === 'category' && $a->argc > ($x + 1) && strlen($a->argv[$x+1]))
30 $category = $a->argv[$x+1];
36 // default permissions - anonymous user
38 $sql_extra = " AND `allow_cid` = '' AND `allow_gid` = '' AND `deny_cid` = '' AND `deny_gid` = '' ";
40 $r = q("SELECT `contact`.*, `user`.`uid` AS `user_uid`, `user`.`nickname`, `user`.`timezone`, `user`.`page-flags`
41 FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
42 WHERE `contact`.`self` = 1 AND `user`.`nickname` = '%s' LIMIT 1",
50 $owner_id = $owner['user_uid'];
51 $owner_nick = $owner['nickname'];
53 $birthday = feed_birthday($owner_id,$owner['timezone']);
62 $sql_extra = sprintf(" AND `issued-id` = '%s' ", dbesc($dfrn_id));
66 $sql_extra = sprintf(" AND `issued-id` = '%s' AND `duplex` = 1 ", dbesc($dfrn_id));
67 $my_id = '1:' . $dfrn_id;
70 $sql_extra = sprintf(" AND `dfrn-id` = '%s' AND `duplex` = 1 ", dbesc($dfrn_id));
71 $my_id = '0:' . $dfrn_id;
78 $r = q("SELECT * FROM `contact` WHERE `blocked` = 0 AND `pending` = 0 AND `contact`.`uid` = %d $sql_extra LIMIT 1",
86 require_once('include/security.php');
87 $groups = init_groups_visitor($contact['id']);
90 for($x = 0; $x < count($groups); $x ++)
91 $groups[$x] = '<' . intval($groups[$x]) . '>' ;
92 $gs = implode('|', $groups);
95 $gs = '<<>>' ; // Impossible to match
97 $sql_extra = sprintf("
98 AND ( `allow_cid` = '' OR `allow_cid` REGEXP '<%d>' )
99 AND ( `deny_cid` = '' OR NOT `deny_cid` REGEXP '<%d>' )
100 AND ( `allow_gid` = '' OR `allow_gid` REGEXP '%s' )
101 AND ( `deny_gid` = '' OR NOT `deny_gid` REGEXP '%s')
103 intval($contact['id']),
104 intval($contact['id']),
115 if(! strlen($last_update))
116 $last_update = 'now -30 days';
118 if(isset($category)) {
119 $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` ",
120 dbesc(protect_sprintf($category)), intval(TERM_OBJ_POST), intval(TERM_CATEGORY), intval($owner_id));
121 //$sql_extra .= file_tag_file_query('item',$category,'category');
126 $sql_extra .= " AND `contact`.`self` = 1 ";
129 $check_date = datetime_convert('UTC','UTC',$last_update,'Y-m-d H:i:s');
131 // AND ( `item`.`edited` > '%s' OR `item`.`changed` > '%s' )
132 // dbesc($check_date),
134 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
135 `contact`.`name`, `contact`.`network`, `contact`.`photo`, `contact`.`url`,
136 `contact`.`name-date`, `contact`.`uri-date`, `contact`.`avatar-date`,
137 `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
138 `contact`.`id` AS `contact-id`, `contact`.`uid` AS `contact-uid`,
139 `sign`.`signed_text`, `sign`.`signature`, `sign`.`signer`
140 FROM `item` $sql_post_table
141 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
142 AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
143 LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id`
144 WHERE `item`.`uid` = %d AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`parent` != 0
145 AND `item`.`wall` = 1 AND `item`.`changed` > '%s'
147 ORDER BY `parent` %s, `created` ASC LIMIT 0, 300",
153 // Will check further below if this actually returned results.
154 // We will provide an empty feed if that is the case.
158 $feed_template = get_markup_template(($dfrn_id) ? 'atom_feed_dfrn.tpl' : 'atom_feed.tpl');
162 $hubxml = feed_hublinks();
164 $salmon = feed_salmonlinks($owner_nick);
166 $alternatelink = $owner['url'];
169 $alternatelink .= "/category/".$category;
171 $atom .= replace_macros($feed_template, array(
172 '$version' => xmlify(FRIENDICA_VERSION),
173 '$feed_id' => xmlify($a->get_baseurl() . '/profile/' . $owner_nick),
174 '$feed_title' => xmlify($owner['name']),
175 '$feed_updated' => xmlify(datetime_convert('UTC', 'UTC', 'now' , ATOM_TIME)) ,
177 '$salmon' => $salmon,
178 '$alternatelink' => xmlify($alternatelink),
179 '$name' => xmlify($owner['name']),
180 '$profile_page' => xmlify($owner['url']),
181 '$photo' => xmlify($owner['photo']),
182 '$thumb' => xmlify($owner['thumb']),
183 '$picdate' => xmlify(datetime_convert('UTC','UTC',$owner['avatar-date'] . '+00:00' , ATOM_TIME)) ,
184 '$uridate' => xmlify(datetime_convert('UTC','UTC',$owner['uri-date'] . '+00:00' , ATOM_TIME)) ,
185 '$namdate' => xmlify(datetime_convert('UTC','UTC',$owner['name-date'] . '+00:00' , ATOM_TIME)) ,
186 '$birthday' => ((strlen($birthday)) ? '<dfrn:birthday>' . xmlify($birthday) . '</dfrn:birthday>' : ''),
187 '$community' => (($owner['page-flags'] == PAGE_COMMUNITY) ? '<dfrn:community>1</dfrn:community>' : '')
190 call_hooks('atom_feed', $atom);
192 if(! count($items)) {
194 call_hooks('atom_feed_end', $atom);
196 $atom .= '</feed>' . "\r\n";
200 foreach($items as $item) {
202 // prevent private email from leaking.
203 if($item['network'] === NETWORK_MAIL)
206 // public feeds get html, our own nodes use bbcode
210 // catch any email that's in a public conversation and make sure it doesn't leak
218 $atom .= atom_entry($item,$type,null,$owner,true);
221 call_hooks('atom_feed_end', $atom);
223 $atom .= '</feed>' . "\r\n";
229 function construct_verb($item) {
231 return $item['verb'];
232 return ACTIVITY_POST;
235 function construct_activity_object($item) {
237 if($item['object']) {
238 $o = '<as:object>' . "\r\n";
239 $r = parse_xml_string($item['object'],false);
245 $o .= '<as:object-type>' . xmlify($r->type) . '</as:object-type>' . "\r\n";
247 $o .= '<id>' . xmlify($r->id) . '</id>' . "\r\n";
249 $o .= '<title>' . xmlify($r->title) . '</title>' . "\r\n";
251 if(substr($r->link,0,1) === '<') {
252 // patch up some facebook "like" activity objects that got stored incorrectly
253 // for a couple of months prior to 9-Jun-2011 and generated bad XML.
254 // we can probably remove this hack here and in the following function in a few months time.
255 if(strstr($r->link,'&') && (! strstr($r->link,'&')))
256 $r->link = str_replace('&','&', $r->link);
257 $r->link = preg_replace('/\<link(.*?)\"\>/','<link$1"/>',$r->link);
261 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($r->link) . '" />' . "\r\n";
264 $o .= '<content type="html" >' . xmlify(bbcode($r->content)) . '</content>' . "\r\n";
265 $o .= '</as:object>' . "\r\n";
272 function construct_activity_target($item) {
274 if($item['target']) {
275 $o = '<as:target>' . "\r\n";
276 $r = parse_xml_string($item['target'],false);
280 $o .= '<as:object-type>' . xmlify($r->type) . '</as:object-type>' . "\r\n";
282 $o .= '<id>' . xmlify($r->id) . '</id>' . "\r\n";
284 $o .= '<title>' . xmlify($r->title) . '</title>' . "\r\n";
286 if(substr($r->link,0,1) === '<') {
287 if(strstr($r->link,'&') && (! strstr($r->link,'&')))
288 $r->link = str_replace('&','&', $r->link);
289 $r->link = preg_replace('/\<link(.*?)\"\>/','<link$1"/>',$r->link);
293 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($r->link) . '" />' . "\r\n";
296 $o .= '<content type="html" >' . xmlify(bbcode($r->content)) . '</content>' . "\r\n";
297 $o .= '</as:target>' . "\r\n";
306 * The purpose of this function is to apply system message length limits to
307 * imported messages without including any embedded photos in the length
309 if(! function_exists('limit_body_size')) {
310 function limit_body_size($body) {
312 // logger('limit_body_size: start', LOGGER_DEBUG);
314 $maxlen = get_max_import_size();
316 // If the length of the body, including the embedded images, is smaller
317 // than the maximum, then don't waste time looking for the images
318 if($maxlen && (strlen($body) > $maxlen)) {
320 logger('limit_body_size: the total body length exceeds the limit', LOGGER_DEBUG);
327 $img_start = strpos($orig_body, '[img');
328 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
329 $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
330 while(($img_st_close !== false) && ($img_end !== false)) {
332 $img_st_close++; // make it point to AFTER the closing bracket
333 $img_end += $img_start;
334 $img_end += strlen('[/img]');
336 if(! strcmp(substr($orig_body, $img_start + $img_st_close, 5), 'data:')) {
337 // This is an embedded image
339 if( ($textlen + $img_start) > $maxlen ) {
340 if($textlen < $maxlen) {
341 logger('limit_body_size: the limit happens before an embedded image', LOGGER_DEBUG);
342 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
347 $new_body = $new_body . substr($orig_body, 0, $img_start);
348 $textlen += $img_start;
351 $new_body = $new_body . substr($orig_body, $img_start, $img_end - $img_start);
355 if( ($textlen + $img_end) > $maxlen ) {
356 if($textlen < $maxlen) {
357 logger('limit_body_size: the limit happens before the end of a non-embedded image', LOGGER_DEBUG);
358 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
363 $new_body = $new_body . substr($orig_body, 0, $img_end);
364 $textlen += $img_end;
367 $orig_body = substr($orig_body, $img_end);
369 if($orig_body === false) // in case the body ends on a closing image tag
372 $img_start = strpos($orig_body, '[img');
373 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
374 $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
377 if( ($textlen + strlen($orig_body)) > $maxlen) {
378 if($textlen < $maxlen) {
379 logger('limit_body_size: the limit happens after the end of the last image', LOGGER_DEBUG);
380 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
385 logger('limit_body_size: the text size with embedded images extracted did not violate the limit', LOGGER_DEBUG);
386 $new_body = $new_body . $orig_body;
387 $textlen += strlen($orig_body);
396 function title_is_body($title, $body) {
398 $title = strip_tags($title);
399 $title = trim($title);
400 $title = html_entity_decode($title, ENT_QUOTES, 'UTF-8');
401 $title = str_replace(array("\n", "\r", "\t", " "), array("","","",""), $title);
403 $body = strip_tags($body);
405 $body = html_entity_decode($body, ENT_QUOTES, 'UTF-8');
406 $body = str_replace(array("\n", "\r", "\t", " "), array("","","",""), $body);
408 if (strlen($title) < strlen($body))
409 $body = substr($body, 0, strlen($title));
411 if (($title != $body) and (substr($title, -3) == "...")) {
412 $pos = strrpos($title, "...");
414 $title = substr($title, 0, $pos);
415 $body = substr($body, 0, $pos);
419 return($title == $body);
424 function get_atom_elements($feed, $item, $contact = array()) {
426 require_once('library/HTMLPurifier.auto.php');
427 require_once('include/html2bbcode.php');
429 $best_photo = array();
433 $author = $item->get_author();
435 $res['author-name'] = unxmlify($author->get_name());
436 $res['author-link'] = unxmlify($author->get_link());
439 $res['author-name'] = unxmlify($feed->get_title());
440 $res['author-link'] = unxmlify($feed->get_permalink());
442 $res['uri'] = unxmlify($item->get_id());
443 $res['title'] = unxmlify($item->get_title());
444 $res['body'] = unxmlify($item->get_content());
445 $res['plink'] = unxmlify($item->get_link(0));
447 if (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND strstr($res['plink'], ".app.net/")) {
448 logger("get_atom_elements: detected app.net posting: ".print_r($res, true), LOGGER_DEBUG);
450 $res['body'] = nl2br($res['body']);
453 // removing the content of the title if its identically to the body
454 // This helps with auto generated titles e.g. from tumblr
455 if (title_is_body($res["title"], $res["body"]))
459 $base_url = implode('/', array_slice(explode('/',$res['plink']),0,3));
463 // look for a photo. We should check media size and find the best one,
464 // but for now let's just find any author photo
466 $rawauthor = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'author');
468 if($rawauthor && $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
469 $base = $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
470 foreach($base as $link) {
471 if(!x($res, 'author-avatar') || !$res['author-avatar']) {
472 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
473 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
478 $rawactor = $item->get_item_tags(NAMESPACE_ACTIVITY, 'actor');
480 if($rawactor && activity_match($rawactor[0]['child'][NAMESPACE_ACTIVITY]['object-type'][0]['data'],ACTIVITY_OBJ_PERSON)) {
481 $base = $rawactor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
482 if($base && count($base)) {
483 foreach($base as $link) {
484 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
485 $res['author-link'] = unxmlify($link['attribs']['']['href']);
486 if(!x($res, 'author-avatar') || !$res['author-avatar']) {
487 if($link['attribs']['']['rel'] === 'avatar' || $link['attribs']['']['rel'] === 'photo')
488 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
494 // No photo/profile-link on the item - look at the feed level
496 if((! (x($res,'author-link'))) || (! (x($res,'author-avatar')))) {
497 $rawauthor = $feed->get_feed_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'author');
498 if($rawauthor && $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
499 $base = $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
500 foreach($base as $link) {
501 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
502 $res['author-link'] = unxmlify($link['attribs']['']['href']);
503 if(! $res['author-avatar']) {
504 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
505 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
510 $rawactor = $feed->get_feed_tags(NAMESPACE_ACTIVITY, 'subject');
512 if($rawactor && activity_match($rawactor[0]['child'][NAMESPACE_ACTIVITY]['object-type'][0]['data'],ACTIVITY_OBJ_PERSON)) {
513 $base = $rawactor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
515 if($base && count($base)) {
516 foreach($base as $link) {
517 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
518 $res['author-link'] = unxmlify($link['attribs']['']['href']);
519 if(! (x($res,'author-avatar'))) {
520 if($link['attribs']['']['rel'] === 'avatar' || $link['attribs']['']['rel'] === 'photo')
521 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
528 $apps = $item->get_item_tags(NAMESPACE_STATUSNET,'notice_info');
529 if($apps && $apps[0]['attribs']['']['source']) {
530 $res['app'] = strip_tags(unxmlify($apps[0]['attribs']['']['source']));
531 if($res['app'] === 'web')
532 $res['app'] = 'OStatus';
535 // base64 encoded json structure representing Diaspora signature
537 $dsig = $item->get_item_tags(NAMESPACE_DFRN,'diaspora_signature');
539 $res['dsprsig'] = unxmlify($dsig[0]['data']);
542 $dguid = $item->get_item_tags(NAMESPACE_DFRN,'diaspora_guid');
544 $res['guid'] = unxmlify($dguid[0]['data']);
546 $bm = $item->get_item_tags(NAMESPACE_DFRN,'bookmark');
548 $res['bookmark'] = ((unxmlify($bm[0]['data']) === 'true') ? 1 : 0);
552 * If there's a copy of the body content which is guaranteed to have survived mangling in transit, use it.
555 $have_real_body = false;
557 $rawenv = $item->get_item_tags(NAMESPACE_DFRN, 'env');
559 $have_real_body = true;
560 $res['body'] = $rawenv[0]['data'];
561 $res['body'] = str_replace(array(' ',"\t","\r","\n"), array('','','',''),$res['body']);
562 // make sure nobody is trying to sneak some html tags by us
563 $res['body'] = notags(base64url_decode($res['body']));
567 $res['body'] = limit_body_size($res['body']);
569 // It isn't certain at this point whether our content is plaintext or html and we'd be foolish to trust
570 // the content type. Our own network only emits text normally, though it might have been converted to
571 // html if we used a pubsubhubbub transport. But if we see even one html tag in our text, we will
572 // have to assume it is all html and needs to be purified.
574 // It doesn't matter all that much security wise - because before this content is used anywhere, we are
575 // going to escape any tags we find regardless, but this lets us import a limited subset of html from
576 // the wild, by sanitising it and converting supported tags to bbcode before we rip out any remaining
579 if((strpos($res['body'],'<') !== false) && (strpos($res['body'],'>') !== false)) {
581 $res['body'] = reltoabs($res['body'],$base_url);
583 $res['body'] = html2bb_video($res['body']);
585 $res['body'] = oembed_html2bbcode($res['body']);
587 $config = HTMLPurifier_Config::createDefault();
588 $config->set('Cache.DefinitionImpl', null);
590 // we shouldn't need a whitelist, because the bbcode converter
591 // will strip out any unsupported tags.
593 $purifier = new HTMLPurifier($config);
594 $res['body'] = $purifier->purify($res['body']);
596 $res['body'] = @html2bbcode($res['body']);
600 elseif(! $have_real_body) {
602 // it's not one of our messages and it has no tags
603 // so it's probably just text. We'll escape it just to be safe.
605 $res['body'] = escape_tags($res['body']);
609 // this tag is obsolete but we keep it for really old sites
611 $allow = $item->get_item_tags(NAMESPACE_DFRN,'comment-allow');
612 if($allow && $allow[0]['data'] == 1)
613 $res['last-child'] = 1;
615 $res['last-child'] = 0;
617 $private = $item->get_item_tags(NAMESPACE_DFRN,'private');
618 if($private && intval($private[0]['data']) > 0)
619 $res['private'] = intval($private[0]['data']);
623 $extid = $item->get_item_tags(NAMESPACE_DFRN,'extid');
624 if($extid && $extid[0]['data'])
625 $res['extid'] = $extid[0]['data'];
627 $rawlocation = $item->get_item_tags(NAMESPACE_DFRN, 'location');
629 $res['location'] = unxmlify($rawlocation[0]['data']);
632 $rawcreated = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'published');
634 $res['created'] = unxmlify($rawcreated[0]['data']);
637 $rawedited = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'updated');
639 $res['edited'] = unxmlify($rawedited[0]['data']);
641 if((x($res,'edited')) && (! (x($res,'created'))))
642 $res['created'] = $res['edited'];
644 if(! $res['created'])
645 $res['created'] = $item->get_date('c');
648 $res['edited'] = $item->get_date('c');
651 // Disallow time travelling posts
653 $d1 = strtotime($res['created']);
654 $d2 = strtotime($res['edited']);
655 $d3 = strtotime('now');
658 $res['created'] = datetime_convert();
660 $res['edited'] = datetime_convert();
662 $rawowner = $item->get_item_tags(NAMESPACE_DFRN, 'owner');
663 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['name'][0]['data'])
664 $res['owner-name'] = unxmlify($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['name'][0]['data']);
665 elseif($rawowner[0]['child'][NAMESPACE_DFRN]['name'][0]['data'])
666 $res['owner-name'] = unxmlify($rawowner[0]['child'][NAMESPACE_DFRN]['name'][0]['data']);
667 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['uri'][0]['data'])
668 $res['owner-link'] = unxmlify($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['uri'][0]['data']);
669 elseif($rawowner[0]['child'][NAMESPACE_DFRN]['uri'][0]['data'])
670 $res['owner-link'] = unxmlify($rawowner[0]['child'][NAMESPACE_DFRN]['uri'][0]['data']);
672 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
673 $base = $rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
675 foreach($base as $link) {
676 if(!x($res, 'owner-avatar') || !$res['owner-avatar']) {
677 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
678 $res['owner-avatar'] = unxmlify($link['attribs']['']['href']);
683 $rawgeo = $item->get_item_tags(NAMESPACE_GEORSS,'point');
685 $res['coord'] = unxmlify($rawgeo[0]['data']);
687 if ($contact["network"] == NETWORK_FEED) {
688 $res['verb'] = ACTIVITY_POST;
689 $res['object-type'] = ACTIVITY_OBJ_NOTE;
692 $rawverb = $item->get_item_tags(NAMESPACE_ACTIVITY, 'verb');
694 // select between supported verbs
697 $res['verb'] = unxmlify($rawverb[0]['data']);
700 // translate OStatus unfollow to activity streams if it happened to get selected
702 if((x($res,'verb')) && ($res['verb'] === 'http://ostatus.org/schema/1.0/unfollow'))
703 $res['verb'] = ACTIVITY_UNFOLLOW;
705 $cats = $item->get_categories();
708 foreach($cats as $cat) {
709 $term = $cat->get_term();
711 $term = $cat->get_label();
712 $scheme = $cat->get_scheme();
713 if($scheme && $term && stristr($scheme,'X-DFRN:'))
714 $tag_arr[] = substr($scheme,7,1) . '[url=' . unxmlify(substr($scheme,9)) . ']' . unxmlify($term) . '[/url]';
716 $tag_arr[] = notags(trim($term));
718 $res['tag'] = implode(',', $tag_arr);
721 $attach = $item->get_enclosures();
724 foreach($attach as $att) {
725 $len = intval($att->get_length());
726 $link = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_link()))));
727 $title = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_title()))));
728 $type = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_type()))));
729 if(strpos($type,';'))
730 $type = substr($type,0,strpos($type,';'));
731 if((! $link) || (strpos($link,'http') !== 0))
737 $type = 'application/octet-stream';
739 $att_arr[] = '[attach]href="' . $link . '" length="' . $len . '" type="' . $type . '" title="' . $title . '"[/attach]';
741 $res['attach'] = implode(',', $att_arr);
744 $rawobj = $item->get_item_tags(NAMESPACE_ACTIVITY, 'object');
747 $res['object'] = '<object>' . "\n";
748 $child = $rawobj[0]['child'];
749 if($child[NAMESPACE_ACTIVITY]['object-type'][0]['data']) {
750 $res['object-type'] = $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'];
751 $res['object'] .= '<type>' . $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'] . '</type>' . "\n";
753 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'id') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'])
754 $res['object'] .= '<id>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'] . '</id>' . "\n";
755 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'link') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['link'])
756 $res['object'] .= '<link>' . encode_rel_links($child[SIMPLEPIE_NAMESPACE_ATOM_10]['link']) . '</link>' . "\n";
757 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'title') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'])
758 $res['object'] .= '<title>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'] . '</title>' . "\n";
759 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'content') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data']) {
760 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data'];
762 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['summary'][0]['data'];
763 // preserve a copy of the original body content in case we later need to parse out any microformat information, e.g. events
764 $res['object'] .= '<orig>' . xmlify($body) . '</orig>' . "\n";
765 if((strpos($body,'<') !== false) || (strpos($body,'>') !== false)) {
767 $body = html2bb_video($body);
769 $config = HTMLPurifier_Config::createDefault();
770 $config->set('Cache.DefinitionImpl', null);
772 $purifier = new HTMLPurifier($config);
773 $body = $purifier->purify($body);
774 $body = html2bbcode($body);
777 $res['object'] .= '<content>' . $body . '</content>' . "\n";
780 $res['object'] .= '</object>' . "\n";
783 $rawobj = $item->get_item_tags(NAMESPACE_ACTIVITY, 'target');
786 $res['target'] = '<target>' . "\n";
787 $child = $rawobj[0]['child'];
788 if($child[NAMESPACE_ACTIVITY]['object-type'][0]['data']) {
789 $res['target'] .= '<type>' . $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'] . '</type>' . "\n";
791 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'id') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'])
792 $res['target'] .= '<id>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'] . '</id>' . "\n";
793 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'link') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['link'])
794 $res['target'] .= '<link>' . encode_rel_links($child[SIMPLEPIE_NAMESPACE_ATOM_10]['link']) . '</link>' . "\n";
795 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'data') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'])
796 $res['target'] .= '<title>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'] . '</title>' . "\n";
797 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'data') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data']) {
798 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data'];
800 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['summary'][0]['data'];
801 // preserve a copy of the original body content in case we later need to parse out any microformat information, e.g. events
802 $res['target'] .= '<orig>' . xmlify($body) . '</orig>' . "\n";
803 if((strpos($body,'<') !== false) || (strpos($body,'>') !== false)) {
805 $body = html2bb_video($body);
807 $config = HTMLPurifier_Config::createDefault();
808 $config->set('Cache.DefinitionImpl', null);
810 $purifier = new HTMLPurifier($config);
811 $body = $purifier->purify($body);
812 $body = html2bbcode($body);
815 $res['target'] .= '<content>' . $body . '</content>' . "\n";
818 $res['target'] .= '</target>' . "\n";
821 // This is some experimental stuff. By now retweets are shown with "RT:"
822 // But: There is data so that the message could be shown similar to native retweets
823 // There is some better way to parse this array - but it didn't worked for me.
824 $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"];
825 if (is_array($child)) {
826 logger('get_atom_elements: Looking for status.net repeated message');
828 $message = $child["http://activitystrea.ms/spec/1.0/"]["object"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["content"][0]["data"];
829 $orig_uri = $child["http://activitystrea.ms/spec/1.0/"]["object"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["id"][0]["data"];
830 $author = $child[SIMPLEPIE_NAMESPACE_ATOM_10]["author"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10];
831 $uri = $author["uri"][0]["data"];
832 $name = $author["name"][0]["data"];
833 $avatar = @array_shift($author["link"][2]["attribs"]);
834 $avatar = $avatar["href"];
836 if (($name != "") and ($uri != "") and ($avatar != "") and ($message != "")) {
837 logger('get_atom_elements: fixing sender of repeated message.');
839 if (!intval(get_config('system','wall-to-wall_share'))) {
840 $prefix = "[share author='".str_replace("'", "'",$name).
842 "' avatar='".$avatar.
843 "' link='".$orig_uri."']";
845 $res["body"] = $prefix.html2bbcode($message)."[/share]";
847 $res["owner-name"] = $res["author-name"];
848 $res["owner-link"] = $res["author-link"];
849 $res["owner-avatar"] = $res["author-avatar"];
851 $res["author-name"] = $name;
852 $res["author-link"] = $uri;
853 $res["author-avatar"] = $avatar;
855 $res["body"] = html2bbcode($message);
860 // Search for ostatus conversation url
861 $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"];
863 if (is_array($links)) {
864 foreach ($links as $link) {
865 $conversation = array_shift($link["attribs"]);
867 if ($conversation["rel"] == "ostatus:conversation") {
868 $res["ostatus_conversation"] = $conversation["href"];
869 logger('get_atom_elements: found conversation url '.$res["ostatus_conversation"]);
874 if (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND $contact['fetch_further_information']) {
875 $res["body"] = $res["title"].add_page_info($res['plink'], false, "", ($contact['fetch_further_information'] == 2));
877 $res["object-type"] = ACTIVITY_OBJ_BOOKMARK;
878 } elseif (isset($contact["network"]) AND ($contact["network"] == NETWORK_OSTATUS))
879 $res["body"] = add_page_info_to_body($res["body"]);
880 elseif (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND strstr($res['plink'], ".app.net/")) {
881 $res["body"] = add_page_info_to_body($res["body"]);
884 $arr = array('feed' => $feed, 'item' => $item, 'result' => $res);
886 call_hooks('parse_atom', $arr);
891 function add_page_info_data($data) {
892 call_hooks('page_info_data', $data);
894 // It maybe is a rich content, but if it does have everything that a link has,
895 // then treat it that way
896 if (($data["type"] == "rich") AND is_string($data["title"]) AND
897 is_string($data["text"]) AND (sizeof($data["images"]) > 0))
898 $data["type"] = "link";
900 if ((($data["type"] != "link") AND ($data["type"] != "video") AND ($data["type"] != "photo")) OR ($data["title"] == $url))
903 if ($no_photos AND ($data["type"] == "photo"))
906 if (($data["type"] != "photo") AND is_string($data["title"]))
907 $text .= "[bookmark=".$data["url"]."]".trim($data["title"])."[/bookmark]";
909 if (($data["type"] != "video") AND ($photo != ""))
910 $text .= '[img]'.$photo.'[/img]';
911 elseif (($data["type"] != "video") AND (sizeof($data["images"]) > 0)) {
912 $imagedata = $data["images"][0];
913 $text .= '[img]'.$imagedata["src"].'[/img]';
916 if (($data["type"] != "photo") AND is_string($data["text"]))
917 $text .= "[quote]".$data["text"]."[/quote]";
920 if (isset($data["keywords"]) AND count($data["keywords"])) {
923 foreach ($data["keywords"] AS $keyword) {
924 $hashtag = str_replace(" ", "", $keyword);
925 $hashtags .= "#[url=".$a->get_baseurl()."/search?tag=".rawurlencode($hashtag)."]".$hashtag."[/url] ";
929 return("\n[class=type-".$data["type"]."]".$text."[/class]".$hashtags);
932 function add_page_info($url, $no_photos = false, $photo = "", $keywords = false) {
933 require_once("mod/parse_url.php");
935 $data = parseurl_getsiteinfo($url, true);
937 logger('add_page_info: fetch page info for '.$url.' '.print_r($data, true), LOGGER_DEBUG);
939 if (!$keywords AND isset($data["keywords"]))
940 unset($data["keywords"]);
942 $text = add_page_info_data($data);
947 function add_page_info_to_body($body, $texturl = false, $no_photos = false) {
949 logger('add_page_info_to_body: fetch page info for body '.$body, LOGGER_DEBUG);
951 $URLSearchString = "^\[\]";
953 // Adding these spaces is a quick hack due to my problems with regular expressions :)
954 preg_match("/[^!#@]\[url\]([$URLSearchString]*)\[\/url\]/ism", " ".$body, $matches);
957 preg_match("/[^!#@]\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism", " ".$body, $matches);
959 // Convert urls without bbcode elements
960 if (!$matches AND $texturl) {
961 preg_match("/([^\]\='".'"'."]|^)(https?\:\/\/[a-zA-Z0-9\:\/\-\?\&\;\.\=\_\~\#\%\$\!\+\,]+)/ism", " ".$body, $matches);
963 // Yeah, a hack. I really hate regular expressions :)
965 $matches[1] = $matches[2];
969 $footer = add_page_info($matches[1], $no_photos);
971 // Remove the link from the body if the link is attached at the end of the post
972 if (isset($footer) AND (trim($footer) != "") AND (strpos($footer, $matches[1]))) {
973 $removedlink = trim(str_replace($matches[1], "", $body));
974 if (($removedlink == "") OR strstr($body, $removedlink))
975 $body = $removedlink;
977 $url = str_replace(array('/', '.'), array('\/', '\.'), $matches[1]);
978 $removedlink = preg_replace("/\[url\=".$url."\](.*?)\[\/url\]/ism", '', $body);
979 if (($removedlink == "") OR strstr($body, $removedlink))
980 $body = $removedlink;
983 // Add the page information to the bottom
984 if (isset($footer) AND (trim($footer) != ""))
990 function encode_rel_links($links) {
992 if(! ((is_array($links)) && (count($links))))
994 foreach($links as $link) {
996 if($link['attribs']['']['rel'])
997 $o .= 'rel="' . $link['attribs']['']['rel'] . '" ';
998 if($link['attribs']['']['type'])
999 $o .= 'type="' . $link['attribs']['']['type'] . '" ';
1000 if($link['attribs']['']['href'])
1001 $o .= 'href="' . $link['attribs']['']['href'] . '" ';
1002 if( (x($link['attribs'],NAMESPACE_MEDIA)) && $link['attribs'][NAMESPACE_MEDIA]['width'])
1003 $o .= 'media:width="' . $link['attribs'][NAMESPACE_MEDIA]['width'] . '" ';
1004 if( (x($link['attribs'],NAMESPACE_MEDIA)) && $link['attribs'][NAMESPACE_MEDIA]['height'])
1005 $o .= 'media:height="' . $link['attribs'][NAMESPACE_MEDIA]['height'] . '" ';
1006 $o .= ' />' . "\n" ;
1013 function item_store($arr,$force_parent = false, $notify = false) {
1015 // If it is a posting where users should get notifications, then define it as wall posting
1018 $arr['type'] = 'wall';
1020 $arr['last-child'] = 1;
1021 $arr['network'] = NETWORK_DFRN;
1024 // If a Diaspora signature structure was passed in, pull it out of the
1025 // item array and set it aside for later storage.
1028 if(x($arr,'dsprsig')) {
1029 $dsprsig = json_decode(base64_decode($arr['dsprsig']));
1030 unset($arr['dsprsig']);
1033 // if an OStatus conversation url was passed in, it is stored and then
1034 // removed from the array.
1035 $ostatus_conversation = null;
1037 if (isset($arr["ostatus_conversation"])) {
1038 $ostatus_conversation = $arr["ostatus_conversation"];
1039 unset($arr["ostatus_conversation"]);
1042 if(x($arr, 'gravity'))
1043 $arr['gravity'] = intval($arr['gravity']);
1044 elseif($arr['parent-uri'] === $arr['uri'])
1045 $arr['gravity'] = 0;
1046 elseif(activity_match($arr['verb'],ACTIVITY_POST))
1047 $arr['gravity'] = 6;
1049 $arr['gravity'] = 6; // extensible catchall
1051 if(! x($arr,'type'))
1052 $arr['type'] = 'remote';
1056 /* check for create date and expire time */
1057 $uid = intval($arr['uid']);
1058 $r = q("SELECT expire FROM user WHERE uid = %d", $uid);
1060 $expire_interval = $r[0]['expire'];
1061 if ($expire_interval>0) {
1062 $expire_date = new DateTime( '- '.$expire_interval.' days', new DateTimeZone('UTC'));
1063 $created_date = new DateTime($arr['created'], new DateTimeZone('UTC'));
1064 if ($created_date < $expire_date) {
1065 logger('item-store: item created ('.$arr['created'].') before expiration time ('.$expire_date->format(DateTime::W3C).'). ignored. ' . print_r($arr,true), LOGGER_DEBUG);
1071 // If there is no guid then take the same guid that was taken before for the same uri
1072 if ((trim($arr['guid']) == "") AND (trim($arr['uri']) != "")) {
1073 logger('item_store: checking for an existing guid for uri '.$arr['uri'], LOGGER_DEBUG);
1074 $r = q("SELECT `guid` FROM `item` WHERE `uri` = '%s' AND `guid` != '' LIMIT 1",
1075 dbesc(trim($arr['uri']))
1079 $arr['guid'] = $r[0]["guid"];
1080 logger('item_store: found guid '.$arr['guid'].' for uri '.$arr['uri'], LOGGER_DEBUG);
1084 // Shouldn't happen but we want to make absolutely sure it doesn't leak from a plugin.
1085 // Deactivated, since the bbcode parser can handle with it - and it destroys posts with some smileys that contain "<"
1086 //if((strpos($arr['body'],'<') !== false) || (strpos($arr['body'],'>') !== false))
1087 // $arr['body'] = strip_tags($arr['body']);
1090 if (version_compare(PHP_VERSION, '5.3.0', '>=')) {
1091 require_once('library/langdet/Text/LanguageDetect.php');
1092 $naked_body = preg_replace('/\[(.+?)\]/','',$arr['body']);
1093 $l = new Text_LanguageDetect;
1094 //$lng = $l->detectConfidence($naked_body);
1095 //$arr['postopts'] = (($lng['language']) ? 'lang=' . $lng['language'] . ';' . $lng['confidence'] : '');
1096 $lng = $l->detect($naked_body, 3);
1098 if (sizeof($lng) > 0) {
1101 foreach ($lng as $language => $score) {
1102 if ($postopts == "")
1103 $postopts = "lang=";
1107 $postopts .= $language.";".$score;
1109 $arr['postopts'] = $postopts;
1113 $arr['wall'] = ((x($arr,'wall')) ? intval($arr['wall']) : 0);
1114 $arr['uri'] = ((x($arr,'uri')) ? notags(trim($arr['uri'])) : random_string());
1115 $arr['extid'] = ((x($arr,'extid')) ? notags(trim($arr['extid'])) : '');
1116 $arr['author-name'] = ((x($arr,'author-name')) ? notags(trim($arr['author-name'])) : '');
1117 $arr['author-link'] = ((x($arr,'author-link')) ? notags(trim($arr['author-link'])) : '');
1118 $arr['author-avatar'] = ((x($arr,'author-avatar')) ? notags(trim($arr['author-avatar'])) : '');
1119 $arr['owner-name'] = ((x($arr,'owner-name')) ? notags(trim($arr['owner-name'])) : '');
1120 $arr['owner-link'] = ((x($arr,'owner-link')) ? notags(trim($arr['owner-link'])) : '');
1121 $arr['owner-avatar'] = ((x($arr,'owner-avatar')) ? notags(trim($arr['owner-avatar'])) : '');
1122 $arr['created'] = ((x($arr,'created') !== false) ? datetime_convert('UTC','UTC',$arr['created']) : datetime_convert());
1123 $arr['edited'] = ((x($arr,'edited') !== false) ? datetime_convert('UTC','UTC',$arr['edited']) : datetime_convert());
1124 $arr['commented'] = datetime_convert();
1125 $arr['received'] = datetime_convert();
1126 $arr['changed'] = datetime_convert();
1127 $arr['title'] = ((x($arr,'title')) ? notags(trim($arr['title'])) : '');
1128 $arr['location'] = ((x($arr,'location')) ? notags(trim($arr['location'])) : '');
1129 $arr['coord'] = ((x($arr,'coord')) ? notags(trim($arr['coord'])) : '');
1130 $arr['last-child'] = ((x($arr,'last-child')) ? intval($arr['last-child']) : 0 );
1131 $arr['visible'] = ((x($arr,'visible') !== false) ? intval($arr['visible']) : 1 );
1132 $arr['deleted'] = 0;
1133 $arr['parent-uri'] = ((x($arr,'parent-uri')) ? notags(trim($arr['parent-uri'])) : '');
1134 $arr['verb'] = ((x($arr,'verb')) ? notags(trim($arr['verb'])) : '');
1135 $arr['object-type'] = ((x($arr,'object-type')) ? notags(trim($arr['object-type'])) : '');
1136 $arr['object'] = ((x($arr,'object')) ? trim($arr['object']) : '');
1137 $arr['target-type'] = ((x($arr,'target-type')) ? notags(trim($arr['target-type'])) : '');
1138 $arr['target'] = ((x($arr,'target')) ? trim($arr['target']) : '');
1139 $arr['plink'] = ((x($arr,'plink')) ? notags(trim($arr['plink'])) : '');
1140 $arr['allow_cid'] = ((x($arr,'allow_cid')) ? trim($arr['allow_cid']) : '');
1141 $arr['allow_gid'] = ((x($arr,'allow_gid')) ? trim($arr['allow_gid']) : '');
1142 $arr['deny_cid'] = ((x($arr,'deny_cid')) ? trim($arr['deny_cid']) : '');
1143 $arr['deny_gid'] = ((x($arr,'deny_gid')) ? trim($arr['deny_gid']) : '');
1144 $arr['private'] = ((x($arr,'private')) ? intval($arr['private']) : 0 );
1145 $arr['bookmark'] = ((x($arr,'bookmark')) ? intval($arr['bookmark']) : 0 );
1146 $arr['body'] = ((x($arr,'body')) ? trim($arr['body']) : '');
1147 $arr['tag'] = ((x($arr,'tag')) ? notags(trim($arr['tag'])) : '');
1148 $arr['attach'] = ((x($arr,'attach')) ? notags(trim($arr['attach'])) : '');
1149 $arr['app'] = ((x($arr,'app')) ? notags(trim($arr['app'])) : '');
1150 $arr['origin'] = ((x($arr,'origin')) ? intval($arr['origin']) : 0 );
1151 $arr['guid'] = ((x($arr,'guid')) ? notags(trim($arr['guid'])) : get_guid(30));
1152 $arr['network'] = ((x($arr,'network')) ? trim($arr['network']) : '');
1154 if ($arr['plink'] == "") {
1156 $arr['plink'] = $a->get_baseurl().'/display/'.urlencode($arr['guid']);
1159 if ($arr['network'] == "") {
1160 $r = q("SELECT `network` FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
1161 intval($arr['contact-id']),
1166 $arr['network'] = $r[0]["network"];
1168 // Fallback to friendica (why is it empty in some cases?)
1169 if ($arr['network'] == "")
1170 $arr['network'] = NETWORK_DFRN;
1172 logger("item_store: Set network to ".$arr["network"]." for ".$arr["uri"], LOGGER_DEBUG);
1175 $arr['thr-parent'] = $arr['parent-uri'];
1176 if($arr['parent-uri'] === $arr['uri']) {
1178 $parent_deleted = 0;
1179 $allow_cid = $arr['allow_cid'];
1180 $allow_gid = $arr['allow_gid'];
1181 $deny_cid = $arr['deny_cid'];
1182 $deny_gid = $arr['deny_gid'];
1183 $notify_type = 'wall-new';
1187 // find the parent and snarf the item id and ACLs
1188 // and anything else we need to inherit
1190 $r = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC LIMIT 1",
1191 dbesc($arr['parent-uri']),
1197 // is the new message multi-level threaded?
1198 // even though we don't support it now, preserve the info
1199 // and re-attach to the conversation parent.
1201 if($r[0]['uri'] != $r[0]['parent-uri']) {
1202 $arr['parent-uri'] = $r[0]['parent-uri'];
1203 $z = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `parent-uri` = '%s' AND `uid` = %d
1204 ORDER BY `id` ASC LIMIT 1",
1205 dbesc($r[0]['parent-uri']),
1206 dbesc($r[0]['parent-uri']),
1213 $parent_id = $r[0]['id'];
1214 $parent_deleted = $r[0]['deleted'];
1215 $allow_cid = $r[0]['allow_cid'];
1216 $allow_gid = $r[0]['allow_gid'];
1217 $deny_cid = $r[0]['deny_cid'];
1218 $deny_gid = $r[0]['deny_gid'];
1219 $arr['wall'] = $r[0]['wall'];
1220 $notify_type = 'comment-new';
1222 // if the parent is private, force privacy for the entire conversation
1223 // This differs from the above settings as it subtly allows comments from
1224 // email correspondents to be private even if the overall thread is not.
1226 if($r[0]['private'])
1227 $arr['private'] = $r[0]['private'];
1229 // Edge case. We host a public forum that was originally posted to privately.
1230 // The original author commented, but as this is a comment, the permissions
1231 // weren't fixed up so it will still show the comment as private unless we fix it here.
1233 if((intval($r[0]['forum_mode']) == 1) && (! $r[0]['private']))
1234 $arr['private'] = 0;
1237 // If its a post from myself then tag the thread as "mention"
1238 logger("item_store: Checking if parent ".$parent_id." has to be tagged as mention for user ".$arr['uid'], LOGGER_DEBUG);
1239 $u = q("select * from user where uid = %d limit 1", intval($arr['uid']));
1242 $self = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1243 logger("item_store: 'myself' is ".$self." for parent ".$parent_id." checking against ".$arr['author-link']." and ".$arr['owner-link'], LOGGER_DEBUG);
1244 if ((normalise_link($arr['author-link']) == $self) OR (normalise_link($arr['owner-link']) == $self)) {
1245 q("UPDATE `thread` SET `mention` = 1 WHERE `iid` = %d", intval($parent_id));
1246 logger("item_store: tagged thread ".$parent_id." as mention for user ".$self, LOGGER_DEBUG);
1252 // Allow one to see reply tweets from status.net even when
1253 // we don't have or can't see the original post.
1256 logger('item_store: $force_parent=true, reply converted to top-level post.');
1258 $arr['parent-uri'] = $arr['uri'];
1259 $arr['gravity'] = 0;
1262 logger('item_store: item parent was not found - ignoring item');
1266 $parent_deleted = 0;
1270 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
1274 if($r && count($r)) {
1275 logger('item-store: duplicate item ignored. ' . print_r($arr,true));
1279 call_hooks('post_remote',$arr);
1281 if(x($arr,'cancel')) {
1282 logger('item_store: post cancelled by plugin.');
1288 logger('item_store: ' . print_r($arr,true), LOGGER_DATA);
1290 $r = dbq("INSERT INTO `item` (`"
1291 . implode("`, `", array_keys($arr))
1293 . implode("', '", array_values($arr))
1296 // find the item we just created
1298 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC ",
1299 $arr['uri'], // already dbesc'd
1304 $current_post = $r[0]['id'];
1305 logger('item_store: created item ' . $current_post);
1307 // Only check for notifications on start posts
1308 if ($arr['parent-uri'] === $arr['uri']) {
1309 add_thread($r[0]['id']);
1310 logger('item_store: Check notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1312 // Send a notification for every new post?
1313 $r = q("SELECT `notify_new_posts` FROM `contact` WHERE `id` = %d AND `uid` = %d AND `notify_new_posts` LIMIT 1",
1314 intval($arr['contact-id']),
1319 logger('item_store: Send notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1320 $u = q("SELECT * FROM user WHERE uid = %d LIMIT 1",
1321 intval($arr['uid']));
1323 $item = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d",
1324 intval($current_post),
1330 require_once('include/enotify.php');
1332 'type' => NOTIFY_SHARE,
1333 'notify_flags' => $u[0]['notify-flags'],
1334 'language' => $u[0]['language'],
1335 'to_name' => $u[0]['username'],
1336 'to_email' => $u[0]['email'],
1337 'uid' => $u[0]['uid'],
1339 'link' => $a->get_baseurl().'/display/'.urlencode($arr['guid']),
1340 'source_name' => $item[0]['author-name'],
1341 'source_link' => $item[0]['author-link'],
1342 'source_photo' => $item[0]['author-avatar'],
1343 'verb' => ACTIVITY_TAG,
1346 logger('item_store: Notification sent for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1351 logger('item_store: could not locate created item');
1355 logger('item_store: duplicated post occurred. Removing duplicates.');
1356 q("DELETE FROM `item` WHERE `uri` = '%s' AND `uid` = %d AND `id` != %d ",
1358 intval($arr['uid']),
1359 intval($current_post)
1363 if((! $parent_id) || ($arr['parent-uri'] === $arr['uri']))
1364 $parent_id = $current_post;
1366 if(strlen($allow_cid) || strlen($allow_gid) || strlen($deny_cid) || strlen($deny_gid))
1369 $private = $arr['private'];
1371 // Set parent id - and also make sure to inherit the parent's ACLs.
1373 $r = q("UPDATE `item` SET `parent` = %d, `allow_cid` = '%s', `allow_gid` = '%s',
1374 `deny_cid` = '%s', `deny_gid` = '%s', `private` = %d, `deleted` = %d WHERE `id` = %d",
1381 intval($parent_deleted),
1382 intval($current_post)
1385 // Complete ostatus threads
1386 if ($ostatus_conversation)
1387 complete_conversation($current_post, $ostatus_conversation);
1389 $arr['id'] = $current_post;
1390 $arr['parent'] = $parent_id;
1391 $arr['allow_cid'] = $allow_cid;
1392 $arr['allow_gid'] = $allow_gid;
1393 $arr['deny_cid'] = $deny_cid;
1394 $arr['deny_gid'] = $deny_gid;
1395 $arr['private'] = $private;
1396 $arr['deleted'] = $parent_deleted;
1398 // update the commented timestamp on the parent
1400 q("UPDATE `item` set `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
1401 dbesc(datetime_convert()),
1402 dbesc(datetime_convert()),
1405 update_thread($parent_id);
1408 q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
1409 intval($current_post),
1410 dbesc($dsprsig->signed_text),
1411 dbesc($dsprsig->signature),
1412 dbesc($dsprsig->signer)
1418 * If this is now the last-child, force all _other_ children of this parent to *not* be last-child
1421 if($arr['last-child']) {
1422 $r = q("UPDATE `item` SET `last-child` = 0 WHERE `parent-uri` = '%s' AND `uid` = %d AND `id` != %d",
1424 intval($arr['uid']),
1425 intval($current_post)
1429 $deleted = tag_deliver($arr['uid'],$current_post);
1431 // current post can be deleted if is for a communuty page and no mention are
1435 // Store the fresh generated item into the cache
1436 $cachefile = get_cachefile(urlencode($arr["guid"])."-".hash("md5", $arr['body']));
1438 if (($cachefile != '') AND !file_exists($cachefile)) {
1439 $s = prepare_text($arr['body']);
1441 $stamp1 = microtime(true);
1442 file_put_contents($cachefile, $s);
1443 $a->save_timestamp($stamp1, "file");
1444 logger('item_store: put item '.$current_post.' into cachefile '.$cachefile);
1447 $r = q('SELECT * FROM `item` WHERE id = %d', intval($current_post));
1448 if (count($r) == 1) {
1449 call_hooks('post_remote_end', $r[0]);
1451 logger('item_store: new item not found in DB, id ' . $current_post);
1455 create_tags_from_item($current_post);
1456 create_files_from_item($current_post);
1459 proc_run('php', "include/notifier.php", $notify_type, $current_post);
1461 return $current_post;
1464 function get_item_guid($id) {
1465 $r = q("SELECT `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($id));
1467 return($r[0]["guid"]);
1472 function get_item_id($guid, $uid = 0) {
1478 $uid == local_user();
1480 // Does the given user have this item?
1482 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1483 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1484 AND `item`.`guid` = '%s' AND `item`.`uid` = %d", dbesc($guid), intval($uid));
1487 $nick = $r[0]["nickname"];
1491 // Or is it anywhere on the server?
1493 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1494 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1495 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = ''
1496 AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
1497 AND `item`.`private` = 0 AND `item`.`wall` = 1
1498 AND `item`.`guid` = '%s'", dbesc($guid));
1501 $nick = $r[0]["nickname"];
1504 return(array("nick" => $nick, "id" => $id));
1508 function get_item_contact($item,$contacts) {
1509 if(! count($contacts) || (! is_array($item)))
1511 foreach($contacts as $contact) {
1512 if($contact['id'] == $item['contact-id']) {
1514 break; // NOTREACHED
1521 * look for mention tags and setup a second delivery chain for forum/community posts if appropriate
1523 * @param int $item_id
1524 * @return bool true if item was deleted, else false
1526 function tag_deliver($uid,$item_id) {
1534 $u = q("select * from user where uid = %d limit 1",
1540 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1541 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1544 $i = q("select * from item where id = %d and uid = %d limit 1",
1553 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1555 // Diaspora uses their own hardwired link URL in @-tags
1556 // instead of the one we supply with webfinger
1558 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1560 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1562 foreach($matches as $mtch) {
1563 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1565 logger('tag_deliver: mention found: ' . $mtch[2]);
1571 if ( ($community_page || $prvgroup) &&
1572 (!$item['wall']) && (!$item['origin']) && ($item['id'] == $item['parent'])){
1573 // mmh.. no mention.. community page or private group... no wall.. no origin.. top-post (not a comment)
1575 logger("tag_deliver: no-mention top-level post to communuty or private group. delete.");
1576 q("DELETE FROM item WHERE id = %d and uid = %d",
1586 // send a notification
1588 // use a local photo if we have one
1590 $r = q("select * from contact where uid = %d and nurl = '%s' limit 1",
1591 intval($u[0]['uid']),
1592 dbesc(normalise_link($item['author-link']))
1594 $photo = (($r && count($r)) ? $r[0]['thumb'] : $item['author-avatar']);
1597 require_once('include/enotify.php');
1599 'type' => NOTIFY_TAGSELF,
1600 'notify_flags' => $u[0]['notify-flags'],
1601 'language' => $u[0]['language'],
1602 'to_name' => $u[0]['username'],
1603 'to_email' => $u[0]['email'],
1604 'uid' => $u[0]['uid'],
1606 'link' => $a->get_baseurl() . '/display/'.urlencode(get_item_guid($item['id'])),
1607 'source_name' => $item['author-name'],
1608 'source_link' => $item['author-link'],
1609 'source_photo' => $photo,
1610 'verb' => ACTIVITY_TAG,
1612 'parent' => $item['parent']
1616 $arr = array('item' => $item, 'user' => $u[0], 'contact' => $r[0]);
1618 call_hooks('tagged', $arr);
1620 if((! $community_page) && (! $prvgroup))
1624 // tgroup delivery - setup a second delivery chain
1625 // prevent delivery looping - only proceed
1626 // if the message originated elsewhere and is a top-level post
1628 if(($item['wall']) || ($item['origin']) || ($item['id'] != $item['parent']))
1631 // now change this copy of the post to a forum head message and deliver to all the tgroup members
1634 $c = q("select name, url, thumb from contact where self = 1 and uid = %d limit 1",
1635 intval($u[0]['uid'])
1640 // also reset all the privacy bits to the forum default permissions
1642 $private = ($u[0]['allow_cid'] || $u[0]['allow_gid'] || $u[0]['deny_cid'] || $u[0]['deny_gid']) ? 1 : 0;
1644 $forum_mode = (($prvgroup) ? 2 : 1);
1646 q("update item set wall = 1, origin = 1, forum_mode = %d, `owner-name` = '%s', `owner-link` = '%s', `owner-avatar` = '%s',
1647 `private` = %d, `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s' where id = %d",
1648 intval($forum_mode),
1649 dbesc($c[0]['name']),
1650 dbesc($c[0]['url']),
1651 dbesc($c[0]['thumb']),
1653 dbesc($u[0]['allow_cid']),
1654 dbesc($u[0]['allow_gid']),
1655 dbesc($u[0]['deny_cid']),
1656 dbesc($u[0]['deny_gid']),
1659 update_thread($item_id);
1661 proc_run('php','include/notifier.php','tgroup',$item_id);
1667 function tgroup_check($uid,$item) {
1673 // check that the message originated elsewhere and is a top-level post
1675 if(($item['wall']) || ($item['origin']) || ($item['uri'] != $item['parent-uri']))
1679 $u = q("select * from user where uid = %d limit 1",
1685 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1686 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1689 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1691 // Diaspora uses their own hardwired link URL in @-tags
1692 // instead of the one we supply with webfinger
1694 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1696 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1698 foreach($matches as $mtch) {
1699 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1701 logger('tgroup_check: mention found: ' . $mtch[2]);
1709 if((! $community_page) && (! $prvgroup))
1723 function dfrn_deliver($owner,$contact,$atom, $dissolve = false) {
1727 $idtosend = $orig_id = (($contact['dfrn-id']) ? $contact['dfrn-id'] : $contact['issued-id']);
1729 if($contact['duplex'] && $contact['dfrn-id'])
1730 $idtosend = '0:' . $orig_id;
1731 if($contact['duplex'] && $contact['issued-id'])
1732 $idtosend = '1:' . $orig_id;
1734 $rino = ((function_exists('mcrypt_encrypt')) ? 1 : 0);
1736 $rino_enable = get_config('system','rino_encrypt');
1741 $ssl_val = intval(get_config('system','ssl_policy'));
1745 case SSL_POLICY_FULL:
1746 $ssl_policy = 'full';
1748 case SSL_POLICY_SELFSIGN:
1749 $ssl_policy = 'self';
1751 case SSL_POLICY_NONE:
1753 $ssl_policy = 'none';
1757 $url = $contact['notify'] . '&dfrn_id=' . $idtosend . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . (($rino) ? '&rino=1' : '');
1759 logger('dfrn_deliver: ' . $url);
1761 $xml = fetch_url($url);
1763 $curl_stat = $a->get_curl_code();
1765 return(-1); // timed out
1767 logger('dfrn_deliver: ' . $xml, LOGGER_DATA);
1772 if(strpos($xml,'<?xml') === false) {
1773 logger('dfrn_deliver: no valid XML returned');
1774 logger('dfrn_deliver: returned XML: ' . $xml, LOGGER_DATA);
1778 $res = parse_xml_string($xml);
1780 if((intval($res->status) != 0) || (! strlen($res->challenge)) || (! strlen($res->dfrn_id)))
1781 return (($res->status) ? $res->status : 3);
1783 $postvars = array();
1784 $sent_dfrn_id = hex2bin((string) $res->dfrn_id);
1785 $challenge = hex2bin((string) $res->challenge);
1786 $perm = (($res->perm) ? $res->perm : null);
1787 $dfrn_version = (float) (($res->dfrn_version) ? $res->dfrn_version : 2.0);
1788 $rino_allowed = ((intval($res->rino) === 1) ? 1 : 0);
1789 $page = (($owner['page-flags'] == PAGE_COMMUNITY) ? 1 : 0);
1791 if($owner['page-flags'] == PAGE_PRVGROUP)
1794 $final_dfrn_id = '';
1797 if((($perm == 'rw') && (! intval($contact['writable'])))
1798 || (($perm == 'r') && (intval($contact['writable'])))) {
1799 q("update contact set writable = %d where id = %d",
1800 intval(($perm == 'rw') ? 1 : 0),
1801 intval($contact['id'])
1803 $contact['writable'] = (string) 1 - intval($contact['writable']);
1807 if(($contact['duplex'] && strlen($contact['pubkey']))
1808 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1809 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1810 openssl_public_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['pubkey']);
1811 openssl_public_decrypt($challenge,$postvars['challenge'],$contact['pubkey']);
1814 openssl_private_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['prvkey']);
1815 openssl_private_decrypt($challenge,$postvars['challenge'],$contact['prvkey']);
1818 $final_dfrn_id = substr($final_dfrn_id, 0, strpos($final_dfrn_id, '.'));
1820 if(strpos($final_dfrn_id,':') == 1)
1821 $final_dfrn_id = substr($final_dfrn_id,2);
1823 if($final_dfrn_id != $orig_id) {
1824 logger('dfrn_deliver: wrong dfrn_id.');
1825 // did not decode properly - cannot trust this site
1829 $postvars['dfrn_id'] = $idtosend;
1830 $postvars['dfrn_version'] = DFRN_PROTOCOL_VERSION;
1832 $postvars['dissolve'] = '1';
1835 if((($contact['rel']) && ($contact['rel'] != CONTACT_IS_SHARING) && (! $contact['blocked'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
1836 $postvars['data'] = $atom;
1837 $postvars['perm'] = 'rw';
1840 $postvars['data'] = str_replace('<dfrn:comment-allow>1','<dfrn:comment-allow>0',$atom);
1841 $postvars['perm'] = 'r';
1844 $postvars['ssl_policy'] = $ssl_policy;
1847 $postvars['page'] = $page;
1849 if($rino && $rino_allowed && (! $dissolve)) {
1850 $key = substr(random_string(),0,16);
1851 $data = bin2hex(aes_encrypt($postvars['data'],$key));
1852 $postvars['data'] = $data;
1853 logger('rino: sent key = ' . $key, LOGGER_DEBUG);
1856 if($dfrn_version >= 2.1) {
1857 if(($contact['duplex'] && strlen($contact['pubkey']))
1858 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1859 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1861 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
1864 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
1868 if(($contact['duplex'] && strlen($contact['prvkey'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
1869 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
1872 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
1876 logger('md5 rawkey ' . md5($postvars['key']));
1878 $postvars['key'] = bin2hex($postvars['key']);
1881 logger('dfrn_deliver: ' . "SENDING: " . print_r($postvars,true), LOGGER_DATA);
1883 $xml = post_url($contact['notify'],$postvars);
1885 logger('dfrn_deliver: ' . "RECEIVED: " . $xml, LOGGER_DATA);
1887 $curl_stat = $a->get_curl_code();
1888 if((! $curl_stat) || (! strlen($xml)))
1889 return(-1); // timed out
1891 if(($curl_stat == 503) && (stristr($a->get_curl_headers(),'retry-after')))
1894 if(strpos($xml,'<?xml') === false) {
1895 logger('dfrn_deliver: phase 2: no valid XML returned');
1896 logger('dfrn_deliver: phase 2: returned XML: ' . $xml, LOGGER_DATA);
1900 if($contact['term-date'] != '0000-00-00 00:00:00') {
1901 logger("dfrn_deliver: $url back from the dead - removing mark for death");
1902 require_once('include/Contact.php');
1903 unmark_for_death($contact);
1906 $res = parse_xml_string($xml);
1908 return $res->status;
1913 This function returns true if $update has an edited timestamp newer
1914 than $existing, i.e. $update contains new data which should override
1915 what's already there. If there is no timestamp yet, the update is
1916 assumed to be newer. If the update has no timestamp, the existing
1917 item is assumed to be up-to-date. If the timestamps are equal it
1918 assumes the update has been seen before and should be ignored.
1920 function edited_timestamp_is_newer($existing, $update) {
1921 if (!x($existing,'edited') || !$existing['edited']) {
1924 if (!x($update,'edited') || !$update['edited']) {
1927 $existing_edited = datetime_convert('UTC', 'UTC', $existing['edited']);
1928 $update_edited = datetime_convert('UTC', 'UTC', $update['edited']);
1929 return (strcmp($existing_edited, $update_edited) < 0);
1934 * consume_feed - process atom feed and update anything/everything we might need to update
1936 * $xml = the (atom) feed to consume - RSS isn't as fully supported but may work for simple feeds.
1938 * $importer = the contact_record (joined to user_record) of the local user who owns this relationship.
1939 * It is this person's stuff that is going to be updated.
1940 * $contact = the person who is sending us stuff. If not set, we MAY be processing a "follow" activity
1941 * from an external network and MAY create an appropriate contact record. Otherwise, we MUST
1942 * have a contact record.
1943 * $hub = should we find a hub declation in the feed, pass it back to our calling process, who might (or
1944 * might not) try and subscribe to it.
1945 * $datedir sorts in reverse order
1946 * $pass - by default ($pass = 0) we cannot guarantee that a parent item has been
1947 * imported prior to its children being seen in the stream unless we are certain
1948 * of how the feed is arranged/ordered.
1949 * With $pass = 1, we only pull parent items out of the stream.
1950 * With $pass = 2, we only pull children (comments/likes).
1952 * So running this twice, first with pass 1 and then with pass 2 will do the right
1953 * thing regardless of feed ordering. This won't be adequate in a fully-threaded
1954 * model where comments can have sub-threads. That would require some massive sorting
1955 * to get all the feed items into a mostly linear ordering, and might still require
1959 function consume_feed($xml,$importer,&$contact, &$hub, $datedir = 0, $pass = 0) {
1961 require_once('library/simplepie/simplepie.inc');
1962 require_once('include/contact_selectors.php');
1964 if(! strlen($xml)) {
1965 logger('consume_feed: empty input');
1969 $feed = new SimplePie();
1970 $feed->set_raw_data($xml);
1972 $feed->enable_order_by_date(true);
1974 $feed->enable_order_by_date(false);
1978 logger('consume_feed: Error parsing XML: ' . $feed->error());
1980 $permalink = $feed->get_permalink();
1982 // Check at the feed level for updated contact name and/or photo
1986 $photo_timestamp = '';
1990 $hubs = $feed->get_links('hub');
1991 logger('consume_feed: hubs: ' . print_r($hubs,true), LOGGER_DATA);
1994 $hub = implode(',', $hubs);
1996 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
1998 $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2000 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2001 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2002 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2003 $new_name = $elems['name'][0]['data'];
2005 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2006 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2007 $photo_url = $elems['link'][0]['attribs']['']['href'];
2010 if((x($rawtags[0]['child'], NAMESPACE_DFRN)) && (x($rawtags[0]['child'][NAMESPACE_DFRN],'birthday'))) {
2011 $birthday = datetime_convert('UTC','UTC', $rawtags[0]['child'][NAMESPACE_DFRN]['birthday'][0]['data']);
2015 if((is_array($contact)) && ($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $contact['avatar-date'])) {
2016 logger('consume_feed: Updating photo for '.$contact['name'].' from '.$photo_url.' uid: '.$contact['uid']);
2017 require_once("include/Photo.php");
2018 $photo_failure = false;
2019 $have_photo = false;
2021 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2022 intval($contact['id']),
2023 intval($contact['uid'])
2026 $resource_id = $r[0]['resource-id'];
2030 $resource_id = photo_new_resource();
2033 $img_str = fetch_url($photo_url,true);
2034 // guess mimetype from headers or filename
2035 $type = guess_image_type($photo_url,true);
2038 $img = new Photo($img_str, $type);
2039 if($img->is_valid()) {
2041 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2042 dbesc($resource_id),
2043 intval($contact['id']),
2044 intval($contact['uid'])
2048 $img->scaleImageSquare(175);
2050 $hash = $resource_id;
2051 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2053 $img->scaleImage(80);
2054 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2056 $img->scaleImage(48);
2057 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2061 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2062 WHERE `uid` = %d AND `id` = %d",
2063 dbesc(datetime_convert()),
2064 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2065 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2066 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2067 intval($contact['uid']),
2068 intval($contact['id'])
2073 if((is_array($contact)) && ($name_updated) && (strlen($new_name)) && ($name_updated > $contact['name-date'])) {
2074 $r = q("select * from contact where uid = %d and id = %d limit 1",
2075 intval($contact['uid']),
2076 intval($contact['id'])
2079 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2080 dbesc(notags(trim($new_name))),
2081 dbesc(datetime_convert()),
2082 intval($contact['uid']),
2083 intval($contact['id'])
2086 // do our best to update the name on content items
2089 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2090 dbesc(notags(trim($new_name))),
2091 dbesc($r[0]['name']),
2092 dbesc($r[0]['url']),
2093 intval($contact['uid'])
2098 if(strlen($birthday)) {
2099 if(substr($birthday,0,4) != $contact['bdyear']) {
2100 logger('consume_feed: updating birthday: ' . $birthday);
2104 * Add new birthday event for this person
2106 * $bdtext is just a readable placeholder in case the event is shared
2107 * with others. We will replace it during presentation to our $importer
2108 * to contain a sparkle link and perhaps a photo.
2112 $bdtext = sprintf( t('%s\'s birthday'), $contact['name']);
2113 $bdtext2 = sprintf( t('Happy Birthday %s'), ' [url=' . $contact['url'] . ']' . $contact['name'] . '[/url]' ) ;
2116 $r = q("INSERT INTO `event` (`uid`,`cid`,`created`,`edited`,`start`,`finish`,`summary`,`desc`,`type`)
2117 VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) ",
2118 intval($contact['uid']),
2119 intval($contact['id']),
2120 dbesc(datetime_convert()),
2121 dbesc(datetime_convert()),
2122 dbesc(datetime_convert('UTC','UTC', $birthday)),
2123 dbesc(datetime_convert('UTC','UTC', $birthday . ' + 1 day ')),
2132 q("UPDATE `contact` SET `bdyear` = '%s' WHERE `uid` = %d AND `id` = %d",
2133 dbesc(substr($birthday,0,4)),
2134 intval($contact['uid']),
2135 intval($contact['id'])
2138 // This function is called twice without reloading the contact
2139 // Make sure we only create one event. This is why &$contact
2140 // is a reference var in this function
2142 $contact['bdyear'] = substr($birthday,0,4);
2147 $community_page = 0;
2148 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2150 $community_page = intval($rawtags[0]['data']);
2152 if(is_array($contact) && intval($contact['forum']) != $community_page) {
2153 q("update contact set forum = %d where id = %d",
2154 intval($community_page),
2155 intval($contact['id'])
2157 $contact['forum'] = (string) $community_page;
2161 // process any deleted entries
2163 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2164 if(is_array($del_entries) && count($del_entries) && $pass != 2) {
2165 foreach($del_entries as $dentry) {
2167 if(isset($dentry['attribs']['']['ref'])) {
2168 $uri = $dentry['attribs']['']['ref'];
2170 if(isset($dentry['attribs']['']['when'])) {
2171 $when = $dentry['attribs']['']['when'];
2172 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2175 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2177 if($deleted && is_array($contact)) {
2178 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN `contact` on `item`.`contact-id` = `contact`.`id`
2179 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
2181 intval($importer['uid']),
2182 intval($contact['id'])
2187 if(! $item['deleted'])
2188 logger('consume_feed: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
2190 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2191 $xo = parse_xml_string($item['object'],false);
2192 $xt = parse_xml_string($item['target'],false);
2193 if($xt->type === ACTIVITY_OBJ_NOTE) {
2194 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
2196 intval($importer['importer_uid'])
2200 // For tags, the owner cannot remove the tag on the author's copy of the post.
2202 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
2203 $author_remove = (($item['origin'] && $item['self']) ? true : false);
2204 $author_copy = (($item['origin']) ? true : false);
2206 if($owner_remove && $author_copy)
2208 if($author_remove || $owner_remove) {
2209 $tags = explode(',',$i[0]['tag']);
2212 foreach($tags as $tag)
2213 if(trim($tag) !== trim($xo->body))
2214 $newtags[] = trim($tag);
2216 q("update item set tag = '%s' where id = %d",
2217 dbesc(implode(',',$newtags)),
2220 create_tags_from_item($i[0]['id']);
2226 if($item['uri'] == $item['parent-uri']) {
2227 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2228 `body` = '', `title` = ''
2229 WHERE `parent-uri` = '%s' AND `uid` = %d",
2231 dbesc(datetime_convert()),
2232 dbesc($item['uri']),
2233 intval($importer['uid'])
2235 create_tags_from_itemuri($item['uri'], $importer['uid']);
2236 create_files_from_itemuri($item['uri'], $importer['uid']);
2237 update_thread_uri($item['uri'], $importer['uid']);
2240 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2241 `body` = '', `title` = ''
2242 WHERE `uri` = '%s' AND `uid` = %d",
2244 dbesc(datetime_convert()),
2246 intval($importer['uid'])
2248 create_tags_from_itemuri($uri, $importer['uid']);
2249 create_files_from_itemuri($uri, $importer['uid']);
2250 if($item['last-child']) {
2251 // ensure that last-child is set in case the comment that had it just got wiped.
2252 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
2253 dbesc(datetime_convert()),
2254 dbesc($item['parent-uri']),
2255 intval($item['uid'])
2257 // who is the last child now?
2258 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `moderated` = 0 AND `uid` = %d
2259 ORDER BY `created` DESC LIMIT 1",
2260 dbesc($item['parent-uri']),
2261 intval($importer['uid'])
2264 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
2275 // Now process the feed
2277 if($feed->get_item_quantity()) {
2279 logger('consume_feed: feed item count = ' . $feed->get_item_quantity());
2281 // in inverse date order
2283 $items = array_reverse($feed->get_items());
2285 $items = $feed->get_items();
2288 foreach($items as $item) {
2291 $item_id = $item->get_id();
2292 $rawthread = $item->get_item_tags( NAMESPACE_THREAD,'in-reply-to');
2293 if(isset($rawthread[0]['attribs']['']['ref'])) {
2295 $parent_uri = $rawthread[0]['attribs']['']['ref'];
2298 if(($is_reply) && is_array($contact)) {
2303 // not allowed to post
2305 if($contact['rel'] == CONTACT_IS_FOLLOWER)
2309 // Have we seen it? If not, import it.
2311 $item_id = $item->get_id();
2312 $datarray = get_atom_elements($feed, $item, $contact);
2314 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2315 $datarray['author-name'] = $contact['name'];
2316 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2317 $datarray['author-link'] = $contact['url'];
2318 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2319 $datarray['author-avatar'] = $contact['thumb'];
2321 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2322 logger('consume_feed: no author information! ' . print_r($datarray,true));
2326 $force_parent = false;
2327 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2328 if($contact['network'] === NETWORK_OSTATUS)
2329 $force_parent = true;
2330 if(strlen($datarray['title']))
2331 unset($datarray['title']);
2332 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2333 dbesc(datetime_convert()),
2335 intval($importer['uid'])
2337 $datarray['last-child'] = 1;
2338 update_thread_uri($parent_uri, $importer['uid']);
2342 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2344 intval($importer['uid'])
2347 // Update content if 'updated' changes
2350 if (edited_timestamp_is_newer($r[0], $datarray)) {
2352 // do not accept (ignore) an earlier edit than one we currently have.
2353 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2356 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2357 dbesc($datarray['title']),
2358 dbesc($datarray['body']),
2359 dbesc($datarray['tag']),
2360 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2361 dbesc(datetime_convert()),
2363 intval($importer['uid'])
2365 create_tags_from_itemuri($item_id, $importer['uid']);
2366 update_thread_uri($item_id, $importer['uid']);
2369 // update last-child if it changes
2371 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2372 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
2373 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2374 dbesc(datetime_convert()),
2376 intval($importer['uid'])
2378 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2379 intval($allow[0]['data']),
2380 dbesc(datetime_convert()),
2382 intval($importer['uid'])
2384 update_thread_uri($item_id, $importer['uid']);
2390 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2391 // one way feed - no remote comment ability
2392 $datarray['last-child'] = 0;
2394 $datarray['parent-uri'] = $parent_uri;
2395 $datarray['uid'] = $importer['uid'];
2396 $datarray['contact-id'] = $contact['id'];
2397 if((activity_match($datarray['verb'],ACTIVITY_LIKE)) || (activity_match($datarray['verb'],ACTIVITY_DISLIKE))) {
2398 $datarray['type'] = 'activity';
2399 $datarray['gravity'] = GRAVITY_LIKE;
2400 // only one like or dislike per person
2401 // splitted into two queries for performance issues
2402 $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",
2403 intval($datarray['uid']),
2404 intval($datarray['contact-id']),
2405 dbesc($datarray['verb']),
2411 $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",
2412 intval($datarray['uid']),
2413 intval($datarray['contact-id']),
2414 dbesc($datarray['verb']),
2421 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2422 $xo = parse_xml_string($datarray['object'],false);
2423 $xt = parse_xml_string($datarray['target'],false);
2425 if($xt->type == ACTIVITY_OBJ_NOTE) {
2426 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
2428 intval($importer['importer_uid'])
2433 // extract tag, if not duplicate, add to parent item
2434 if($xo->id && $xo->content) {
2435 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
2436 if(! (stristr($r[0]['tag'],$newtag))) {
2437 q("UPDATE item SET tag = '%s' WHERE id = %d",
2438 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . $newtag),
2441 create_tags_from_item($r[0]['id']);
2447 $r = item_store($datarray,$force_parent);
2453 // Head post of a conversation. Have we seen it? If not, import it.
2455 $item_id = $item->get_id();
2457 $datarray = get_atom_elements($feed, $item, $contact);
2459 if(is_array($contact)) {
2460 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2461 $datarray['author-name'] = $contact['name'];
2462 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2463 $datarray['author-link'] = $contact['url'];
2464 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2465 $datarray['author-avatar'] = $contact['thumb'];
2468 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2469 logger('consume_feed: no author information! ' . print_r($datarray,true));
2473 // special handling for events
2475 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
2476 $ev = bbtoevent($datarray['body']);
2477 if(x($ev,'desc') && x($ev,'start')) {
2478 $ev['uid'] = $importer['uid'];
2479 $ev['uri'] = $item_id;
2480 $ev['edited'] = $datarray['edited'];
2481 $ev['private'] = $datarray['private'];
2483 if(is_array($contact))
2484 $ev['cid'] = $contact['id'];
2485 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2487 intval($importer['uid'])
2490 $ev['id'] = $r[0]['id'];
2491 $xyz = event_store($ev);
2496 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2497 if(strlen($datarray['title']))
2498 unset($datarray['title']);
2499 $datarray['last-child'] = 1;
2503 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2505 intval($importer['uid'])
2508 // Update content if 'updated' changes
2511 if (edited_timestamp_is_newer($r[0], $datarray)) {
2513 // do not accept (ignore) an earlier edit than one we currently have.
2514 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2517 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2518 dbesc($datarray['title']),
2519 dbesc($datarray['body']),
2520 dbesc($datarray['tag']),
2521 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2522 dbesc(datetime_convert()),
2524 intval($importer['uid'])
2526 create_tags_from_itemuri($item_id, $importer['uid']);
2527 update_thread_uri($item_id, $importer['uid']);
2530 // update last-child if it changes
2532 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2533 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
2534 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2535 intval($allow[0]['data']),
2536 dbesc(datetime_convert()),
2538 intval($importer['uid'])
2540 update_thread_uri($item_id, $importer['uid']);
2545 if(activity_match($datarray['verb'],ACTIVITY_FOLLOW)) {
2546 logger('consume-feed: New follower');
2547 new_follower($importer,$contact,$datarray,$item);
2550 if(activity_match($datarray['verb'],ACTIVITY_UNFOLLOW)) {
2551 lose_follower($importer,$contact,$datarray,$item);
2555 if(activity_match($datarray['verb'],ACTIVITY_REQ_FRIEND)) {
2556 logger('consume-feed: New friend request');
2557 new_follower($importer,$contact,$datarray,$item,true);
2560 if(activity_match($datarray['verb'],ACTIVITY_UNFRIEND)) {
2561 lose_sharer($importer,$contact,$datarray,$item);
2566 if(! is_array($contact))
2570 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2571 // one way feed - no remote comment ability
2572 $datarray['last-child'] = 0;
2574 if($contact['network'] === NETWORK_FEED)
2575 $datarray['private'] = 2;
2577 $datarray['parent-uri'] = $item_id;
2578 $datarray['uid'] = $importer['uid'];
2579 $datarray['contact-id'] = $contact['id'];
2581 if(! link_compare($datarray['owner-link'],$contact['url'])) {
2582 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
2583 // but otherwise there's a possible data mixup on the sender's system.
2584 // the tgroup delivery code called from item_store will correct it if it's a forum,
2585 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
2586 logger('consume_feed: Correcting item owner.', LOGGER_DEBUG);
2587 $datarray['owner-name'] = $contact['name'];
2588 $datarray['owner-link'] = $contact['url'];
2589 $datarray['owner-avatar'] = $contact['thumb'];
2592 // We've allowed "followers" to reach this point so we can decide if they are
2593 // posting an @-tag delivery, which followers are allowed to do for certain
2594 // page types. Now that we've parsed the post, let's check if it is legit. Otherwise ignore it.
2596 if(($contact['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['uid'],$datarray)))
2599 // This is my contact on another system, but it's really me.
2600 // Turn this into a wall post.
2602 if($contact['remote_self'] AND (($contact['network'] === NETWORK_FEED) OR !$datarray['private'])) {
2603 logger('remote-self start - Contact '.$contact['url'].' - '.$contact['remote_self'].' Item '.print_r($datarray, true), LOGGER_DEBUG);
2604 if ($contact['remote_self'] == 1) {
2605 // Prevent that forwarded posts will be forwarded again
2606 $notify = (normalise_link($datarray['author-link']) == normalise_link($datarray['owner-link']));
2607 if ($datarray["app"] == $a->get_hostname())
2609 } elseif ($contact['remote_self'] == 2) {
2610 $r = q("SELECT `id`,`url`,`name`,`photo`,`network` FROM `contact` WHERE `uid` = %d AND `self`", intval($importer['uid']));
2612 $datarray['contact-id'] = $r[0]["id"];
2614 $datarray['owner-name'] = $r[0]["name"];
2615 $datarray['owner-link'] = $r[0]["url"];
2616 $datarray['owner-avatar'] = $r[0]["avatar"];
2618 $datarray['author-name'] = $datarray['owner-name'];
2619 $datarray['author-link'] = $datarray['owner-link'];
2620 $datarray['author-avatar'] = $datarray['owner-avatar'];
2625 if (!isset($datarray["app"]) OR ($datarray["app"] == ""))
2626 $datarray["app"] = network_to_name($contact['network']);
2628 if ($contact['network'] === NETWORK_FEED)
2629 $datarray['private'] = 0;
2631 $datarray2 = $datarray;
2633 // Create a new guid and uri and post it as a forwarded post
2634 $datarray2["guid"] = get_guid(32);
2635 unset($datarray2["plink"]);
2636 $datarray2["uri"] = item_new_uri($a->get_hostname(),$importer['uid']);
2637 $datarray2["parent-uri"] = $datarray2["uri"];
2638 $datarray2["extid"] = NETWORK_DFRN;
2639 $urlpart = parse_url($datarray['author-link']);
2640 $datarray2["app"] = $urlpart["host"];
2641 $r = q("SELECT `id`,`url`,`name`,`photo`,`network` FROM `contact` WHERE `uid` = %d AND `self`", intval($importer['uid']));
2643 $datarray2['contact-id'] = $r[0]["id"];
2645 $datarray2['owner-name'] = $r[0]["name"];
2646 $datarray2['owner-link'] = $r[0]["url"];
2647 $datarray2['owner-avatar'] = $r[0]["avatar"];
2649 $datarray2['author-name'] = $datarray2['owner-name'];
2650 $datarray2['author-link'] = $datarray2['owner-link'];
2651 $datarray2['author-avatar'] = $datarray2['owner-avatar'];
2654 // Store the forwarded post
2655 $r = item_store($datarray2, false, true);
2656 logger('remote-self forwarded post - Contact '.$contact['url'].' return '.$r.' Item '.print_r($datarray2, true), LOGGER_DEBUG);
2658 // Let the original item just be a regular item
2664 $r = item_store($datarray, false, $notify);
2665 logger('Stored - Contact '.$contact['url'].' Notify '.$notify.' return '.$r.' Item '.print_r($datarray, true), LOGGER_DEBUG);
2673 function local_delivery($importer,$data) {
2676 logger(__function__, LOGGER_TRACE);
2678 if($importer['readonly']) {
2679 // We aren't receiving stuff from this person. But we will quietly ignore them
2680 // rather than a blatant "go away" message.
2681 logger('local_delivery: ignoring');
2686 // Consume notification feed. This may differ from consuming a public feed in several ways
2687 // - might contain email or friend suggestions
2688 // - might contain remote followup to our message
2689 // - in which case we need to accept it and then notify other conversants
2690 // - we may need to send various email notifications
2692 $feed = new SimplePie();
2693 $feed->set_raw_data($data);
2694 $feed->enable_order_by_date(false);
2699 logger('local_delivery: Error parsing XML: ' . $feed->error());
2702 // Check at the feed level for updated contact name and/or photo
2706 $photo_timestamp = '';
2710 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2712 // Fallback should not be needed here. If it isn't DFRN it won't have DFRN updated tags
2714 // $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2717 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2718 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2719 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2720 $new_name = $elems['name'][0]['data'];
2722 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2723 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2724 $photo_url = $elems['link'][0]['attribs']['']['href'];
2728 if(($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $importer['avatar-date'])) {
2729 logger('local_delivery: Updating photo for ' . $importer['name']);
2730 require_once("include/Photo.php");
2731 $photo_failure = false;
2732 $have_photo = false;
2734 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2735 intval($importer['id']),
2736 intval($importer['importer_uid'])
2739 $resource_id = $r[0]['resource-id'];
2743 $resource_id = photo_new_resource();
2746 $img_str = fetch_url($photo_url,true);
2747 // guess mimetype from headers or filename
2748 $type = guess_image_type($photo_url,true);
2751 $img = new Photo($img_str, $type);
2752 if($img->is_valid()) {
2754 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2755 dbesc($resource_id),
2756 intval($importer['id']),
2757 intval($importer['importer_uid'])
2761 $img->scaleImageSquare(175);
2763 $hash = $resource_id;
2764 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2766 $img->scaleImage(80);
2767 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2769 $img->scaleImage(48);
2770 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2774 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2775 WHERE `uid` = %d AND `id` = %d",
2776 dbesc(datetime_convert()),
2777 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2778 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2779 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2780 intval($importer['importer_uid']),
2781 intval($importer['id'])
2786 if(($name_updated) && (strlen($new_name)) && ($name_updated > $importer['name-date'])) {
2787 $r = q("select * from contact where uid = %d and id = %d limit 1",
2788 intval($importer['importer_uid']),
2789 intval($importer['id'])
2792 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2793 dbesc(notags(trim($new_name))),
2794 dbesc(datetime_convert()),
2795 intval($importer['importer_uid']),
2796 intval($importer['id'])
2799 // do our best to update the name on content items
2802 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2803 dbesc(notags(trim($new_name))),
2804 dbesc($r[0]['name']),
2805 dbesc($r[0]['url']),
2806 intval($importer['importer_uid'])
2813 // Currently unsupported - needs a lot of work
2814 $reloc = $feed->get_feed_tags( NAMESPACE_DFRN, 'relocate' );
2815 if(isset($reloc[0]['child'][NAMESPACE_DFRN])) {
2816 $base = $reloc[0]['child'][NAMESPACE_DFRN];
2818 $newloc['uid'] = $importer['importer_uid'];
2819 $newloc['cid'] = $importer['id'];
2820 $newloc['name'] = notags(unxmlify($base['name'][0]['data']));
2821 $newloc['photo'] = notags(unxmlify($base['photo'][0]['data']));
2822 $newloc['thumb'] = notags(unxmlify($base['thumb'][0]['data']));
2823 $newloc['micro'] = notags(unxmlify($base['micro'][0]['data']));
2824 $newloc['url'] = notags(unxmlify($base['url'][0]['data']));
2825 $newloc['request'] = notags(unxmlify($base['request'][0]['data']));
2826 $newloc['confirm'] = notags(unxmlify($base['confirm'][0]['data']));
2827 $newloc['notify'] = notags(unxmlify($base['notify'][0]['data']));
2828 $newloc['poll'] = notags(unxmlify($base['poll'][0]['data']));
2829 $newloc['sitepubkey'] = notags(unxmlify($base['sitepubkey'][0]['data']));
2830 /** relocated user must have original key pair */
2831 /*$newloc['pubkey'] = notags(unxmlify($base['pubkey'][0]['data']));
2832 $newloc['prvkey'] = notags(unxmlify($base['prvkey'][0]['data']));*/
2834 logger("items:relocate contact ".print_r($newloc, true).print_r($importer, true), LOGGER_DEBUG);
2837 $r = q("SELECT photo, url FROM contact WHERE id=%d AND uid=%d;",
2838 intval($importer['id']),
2839 intval($importer['importer_uid']));
2844 $x = q("UPDATE contact SET
2854 `site-pubkey` = '%s'
2855 WHERE id=%d AND uid=%d;",
2856 dbesc($newloc['name']),
2857 dbesc($newloc['photo']),
2858 dbesc($newloc['thumb']),
2859 dbesc($newloc['micro']),
2860 dbesc($newloc['url']),
2861 dbesc($newloc['request']),
2862 dbesc($newloc['confirm']),
2863 dbesc($newloc['notify']),
2864 dbesc($newloc['poll']),
2865 dbesc($newloc['sitepubkey']),
2866 intval($importer['id']),
2867 intval($importer['importer_uid']));
2873 'owner-link' => array($old['url'], $newloc['url']),
2874 'author-link' => array($old['url'], $newloc['url']),
2875 'owner-avatar' => array($old['photo'], $newloc['photo']),
2876 'author-avatar' => array($old['photo'], $newloc['photo']),
2878 foreach ($fields as $n=>$f){
2879 $x = q("UPDATE `item` SET `%s`='%s' WHERE `%s`='%s' AND uid=%d",
2882 intval($importer['importer_uid']));
2888 // merge with current record, current contents have priority
2889 // update record, set url-updated
2890 // update profile photos
2896 // handle friend suggestion notification
2898 $sugg = $feed->get_feed_tags( NAMESPACE_DFRN, 'suggest' );
2899 if(isset($sugg[0]['child'][NAMESPACE_DFRN])) {
2900 $base = $sugg[0]['child'][NAMESPACE_DFRN];
2902 $fsugg['uid'] = $importer['importer_uid'];
2903 $fsugg['cid'] = $importer['id'];
2904 $fsugg['name'] = notags(unxmlify($base['name'][0]['data']));
2905 $fsugg['photo'] = notags(unxmlify($base['photo'][0]['data']));
2906 $fsugg['url'] = notags(unxmlify($base['url'][0]['data']));
2907 $fsugg['request'] = notags(unxmlify($base['request'][0]['data']));
2908 $fsugg['body'] = escape_tags(unxmlify($base['note'][0]['data']));
2910 // Does our member already have a friend matching this description?
2912 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `nurl` = '%s' AND `uid` = %d LIMIT 1",
2913 dbesc($fsugg['name']),
2914 dbesc(normalise_link($fsugg['url'])),
2915 intval($fsugg['uid'])
2920 // Do we already have an fcontact record for this person?
2923 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
2924 dbesc($fsugg['url']),
2925 dbesc($fsugg['name']),
2926 dbesc($fsugg['request'])
2931 // OK, we do. Do we already have an introduction for this person ?
2932 $r = q("select id from intro where uid = %d and fid = %d limit 1",
2933 intval($fsugg['uid']),
2940 $r = q("INSERT INTO `fcontact` ( `name`,`url`,`photo`,`request` ) VALUES ( '%s', '%s', '%s', '%s' ) ",
2941 dbesc($fsugg['name']),
2942 dbesc($fsugg['url']),
2943 dbesc($fsugg['photo']),
2944 dbesc($fsugg['request'])
2946 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
2947 dbesc($fsugg['url']),
2948 dbesc($fsugg['name']),
2949 dbesc($fsugg['request'])
2954 // database record did not get created. Quietly give up.
2959 $hash = random_string();
2961 $r = q("INSERT INTO `intro` ( `uid`, `fid`, `contact-id`, `note`, `hash`, `datetime`, `blocked` )
2962 VALUES( %d, %d, %d, '%s', '%s', '%s', %d )",
2963 intval($fsugg['uid']),
2965 intval($fsugg['cid']),
2966 dbesc($fsugg['body']),
2968 dbesc(datetime_convert()),
2973 'type' => NOTIFY_SUGGEST,
2974 'notify_flags' => $importer['notify-flags'],
2975 'language' => $importer['language'],
2976 'to_name' => $importer['username'],
2977 'to_email' => $importer['email'],
2978 'uid' => $importer['importer_uid'],
2980 'link' => $a->get_baseurl() . '/notifications/intros',
2981 'source_name' => $importer['name'],
2982 'source_link' => $importer['url'],
2983 'source_photo' => $importer['photo'],
2984 'verb' => ACTIVITY_REQ_FRIEND,
2993 $rawmail = $feed->get_feed_tags( NAMESPACE_DFRN, 'mail' );
2994 if(isset($rawmail[0]['child'][NAMESPACE_DFRN])) {
2996 logger('local_delivery: private message received');
2999 $base = $rawmail[0]['child'][NAMESPACE_DFRN];
3002 $msg['uid'] = $importer['importer_uid'];
3003 $msg['from-name'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['name'][0]['data']));
3004 $msg['from-photo'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['avatar'][0]['data']));
3005 $msg['from-url'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['uri'][0]['data']));
3006 $msg['contact-id'] = $importer['id'];
3007 $msg['title'] = notags(unxmlify($base['subject'][0]['data']));
3008 $msg['body'] = escape_tags(unxmlify($base['content'][0]['data']));
3010 $msg['replied'] = 0;
3011 $msg['uri'] = notags(unxmlify($base['id'][0]['data']));
3012 $msg['parent-uri'] = notags(unxmlify($base['in-reply-to'][0]['data']));
3013 $msg['created'] = datetime_convert(notags(unxmlify('UTC','UTC',$base['sentdate'][0]['data'])));
3017 $r = dbq("INSERT INTO `mail` (`" . implode("`, `", array_keys($msg))
3018 . "`) VALUES ('" . implode("', '", array_values($msg)) . "')" );
3020 // send notifications.
3022 require_once('include/enotify.php');
3024 $notif_params = array(
3025 'type' => NOTIFY_MAIL,
3026 'notify_flags' => $importer['notify-flags'],
3027 'language' => $importer['language'],
3028 'to_name' => $importer['username'],
3029 'to_email' => $importer['email'],
3030 'uid' => $importer['importer_uid'],
3032 'source_name' => $msg['from-name'],
3033 'source_link' => $importer['url'],
3034 'source_photo' => $importer['thumb'],
3035 'verb' => ACTIVITY_POST,
3039 notification($notif_params);
3045 $community_page = 0;
3046 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
3048 $community_page = intval($rawtags[0]['data']);
3050 if(intval($importer['forum']) != $community_page) {
3051 q("update contact set forum = %d where id = %d",
3052 intval($community_page),
3053 intval($importer['id'])
3055 $importer['forum'] = (string) $community_page;
3058 logger('local_delivery: feed item count = ' . $feed->get_item_quantity());
3060 // process any deleted entries
3062 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
3063 if(is_array($del_entries) && count($del_entries)) {
3064 foreach($del_entries as $dentry) {
3066 if(isset($dentry['attribs']['']['ref'])) {
3067 $uri = $dentry['attribs']['']['ref'];
3069 if(isset($dentry['attribs']['']['when'])) {
3070 $when = $dentry['attribs']['']['when'];
3071 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
3074 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
3078 // check for relayed deletes to our conversation
3081 $r = q("select * from item where uri = '%s' and uid = %d limit 1",
3083 intval($importer['importer_uid'])
3086 $parent_uri = $r[0]['parent-uri'];
3087 if($r[0]['id'] != $r[0]['parent'])
3094 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3097 logger('local_delivery: possible community delete');
3100 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3102 // was the top-level post for this reply written by somebody on this site?
3103 // Specifically, the recipient?
3105 $is_a_remote_delete = false;
3107 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3108 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3109 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3110 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3111 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3112 AND `item`.`uid` = %d
3118 intval($importer['importer_uid'])
3121 $is_a_remote_delete = true;
3123 // Does this have the characteristics of a community or private group comment?
3124 // If it's a reply to a wall post on a community/prvgroup page it's a
3125 // valid community comment. Also forum_mode makes it valid for sure.
3126 // If neither, it's not.
3128 if($is_a_remote_delete && $community) {
3129 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3130 $is_a_remote_delete = false;
3131 logger('local_delivery: not a community delete');
3135 if($is_a_remote_delete) {
3136 logger('local_delivery: received remote delete');
3140 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN contact on `item`.`contact-id` = `contact`.`id`
3141 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
3143 intval($importer['importer_uid']),
3144 intval($importer['id'])
3150 if($item['deleted'])
3153 logger('local_delivery: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
3155 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3156 $xo = parse_xml_string($item['object'],false);
3157 $xt = parse_xml_string($item['target'],false);
3159 if($xt->type === ACTIVITY_OBJ_NOTE) {
3160 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
3162 intval($importer['importer_uid'])
3166 // For tags, the owner cannot remove the tag on the author's copy of the post.
3168 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
3169 $author_remove = (($item['origin'] && $item['self']) ? true : false);
3170 $author_copy = (($item['origin']) ? true : false);
3172 if($owner_remove && $author_copy)
3174 if($author_remove || $owner_remove) {
3175 $tags = explode(',',$i[0]['tag']);
3178 foreach($tags as $tag)
3179 if(trim($tag) !== trim($xo->body))
3180 $newtags[] = trim($tag);
3182 q("update item set tag = '%s' where id = %d",
3183 dbesc(implode(',',$newtags)),
3186 create_tags_from_item($i[0]['id']);
3192 if($item['uri'] == $item['parent-uri']) {
3193 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3194 `body` = '', `title` = ''
3195 WHERE `parent-uri` = '%s' AND `uid` = %d",
3197 dbesc(datetime_convert()),
3198 dbesc($item['uri']),
3199 intval($importer['importer_uid'])
3201 create_tags_from_itemuri($item['uri'], $importer['importer_uid']);
3202 create_files_from_itemuri($item['uri'], $importer['importer_uid']);
3203 update_thread_uri($item['uri'], $importer['importer_uid']);
3206 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3207 `body` = '', `title` = ''
3208 WHERE `uri` = '%s' AND `uid` = %d",
3210 dbesc(datetime_convert()),
3212 intval($importer['importer_uid'])
3214 create_tags_from_itemuri($uri, $importer['importer_uid']);
3215 create_files_from_itemuri($uri, $importer['importer_uid']);
3216 update_thread_uri($uri, $importer['importer_uid']);
3217 if($item['last-child']) {
3218 // ensure that last-child is set in case the comment that had it just got wiped.
3219 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
3220 dbesc(datetime_convert()),
3221 dbesc($item['parent-uri']),
3222 intval($item['uid'])
3224 // who is the last child now?
3225 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d
3226 ORDER BY `created` DESC LIMIT 1",
3227 dbesc($item['parent-uri']),
3228 intval($importer['importer_uid'])
3231 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
3236 // if this is a relayed delete, propagate it to other recipients
3238 if($is_a_remote_delete)
3239 proc_run('php',"include/notifier.php","drop",$item['id']);
3247 foreach($feed->get_items() as $item) {
3250 $item_id = $item->get_id();
3251 $rawthread = $item->get_item_tags( NAMESPACE_THREAD, 'in-reply-to');
3252 if(isset($rawthread[0]['attribs']['']['ref'])) {
3254 $parent_uri = $rawthread[0]['attribs']['']['ref'];
3260 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3263 logger('local_delivery: possible community reply');
3266 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3268 // was the top-level post for this reply written by somebody on this site?
3269 // Specifically, the recipient?
3271 $is_a_remote_comment = false;
3272 $top_uri = $parent_uri;
3274 $r = q("select `item`.`parent-uri` from `item`
3275 WHERE `item`.`uri` = '%s'
3279 if($r && count($r)) {
3280 $top_uri = $r[0]['parent-uri'];
3282 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3283 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3284 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3285 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3286 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3287 AND `item`.`uid` = %d
3293 intval($importer['importer_uid'])
3296 $is_a_remote_comment = true;
3299 // Does this have the characteristics of a community or private group comment?
3300 // If it's a reply to a wall post on a community/prvgroup page it's a
3301 // valid community comment. Also forum_mode makes it valid for sure.
3302 // If neither, it's not.
3304 if($is_a_remote_comment && $community) {
3305 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3306 $is_a_remote_comment = false;
3307 logger('local_delivery: not a community reply');
3311 if($is_a_remote_comment) {
3312 logger('local_delivery: received remote comment');
3314 // remote reply to our post. Import and then notify everybody else.
3316 $datarray = get_atom_elements($feed, $item);
3318 $r = q("SELECT `id`, `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3320 intval($importer['importer_uid'])
3323 // Update content if 'updated' changes
3327 if (edited_timestamp_is_newer($r[0], $datarray)) {
3329 // do not accept (ignore) an earlier edit than one we currently have.
3330 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3333 logger('received updated comment' , LOGGER_DEBUG);
3334 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3335 dbesc($datarray['title']),
3336 dbesc($datarray['body']),
3337 dbesc($datarray['tag']),
3338 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3339 dbesc(datetime_convert()),
3341 intval($importer['importer_uid'])
3343 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3345 proc_run('php',"include/notifier.php","comment-import",$iid);
3354 $own = q("select name,url,thumb from contact where uid = %d and self = 1 limit 1",
3355 intval($importer['importer_uid'])
3359 $datarray['type'] = 'remote-comment';
3360 $datarray['wall'] = 1;
3361 $datarray['parent-uri'] = $parent_uri;
3362 $datarray['uid'] = $importer['importer_uid'];
3363 $datarray['owner-name'] = $own[0]['name'];
3364 $datarray['owner-link'] = $own[0]['url'];
3365 $datarray['owner-avatar'] = $own[0]['thumb'];
3366 $datarray['contact-id'] = $importer['id'];
3368 if(($datarray['verb'] === ACTIVITY_LIKE) || ($datarray['verb'] === ACTIVITY_DISLIKE)) {
3370 $datarray['type'] = 'activity';
3371 $datarray['gravity'] = GRAVITY_LIKE;
3372 $datarray['last-child'] = 0;
3373 // only one like or dislike per person
3374 // splitted into two queries for performance issues
3375 $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",
3376 intval($datarray['uid']),
3377 intval($datarray['contact-id']),
3378 dbesc($datarray['verb']),
3379 dbesc($datarray['parent-uri'])
3385 $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",
3386 intval($datarray['uid']),
3387 intval($datarray['contact-id']),
3388 dbesc($datarray['verb']),
3389 dbesc($datarray['parent-uri'])
3396 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3398 $xo = parse_xml_string($datarray['object'],false);
3399 $xt = parse_xml_string($datarray['target'],false);
3401 if(($xt->type == ACTIVITY_OBJ_NOTE) && ($xt->id)) {
3403 // fetch the parent item
3405 $tagp = q("select * from item where uri = '%s' and uid = %d limit 1",
3407 intval($importer['importer_uid'])
3412 // extract tag, if not duplicate, and this user allows tags, add to parent item
3414 if($xo->id && $xo->content) {
3415 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
3416 if(! (stristr($tagp[0]['tag'],$newtag))) {
3417 $i = q("SELECT `blocktags` FROM `user` where `uid` = %d LIMIT 1",
3418 intval($importer['importer_uid'])
3420 if(count($i) && ! intval($i[0]['blocktags'])) {
3421 q("UPDATE item SET tag = '%s', `edited` = '%s', `changed` = '%s' WHERE id = %d",
3422 dbesc($tagp[0]['tag'] . (strlen($tagp[0]['tag']) ? ',' : '') . $newtag),
3423 intval($tagp[0]['id']),
3424 dbesc(datetime_convert()),
3425 dbesc(datetime_convert())
3427 create_tags_from_item($tagp[0]['id']);
3435 $posted_id = item_store($datarray);
3439 $r = q("SELECT `parent`, `parent-uri` FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3441 intval($importer['importer_uid'])
3444 $parent = $r[0]['parent'];
3445 $parent_uri = $r[0]['parent-uri'];
3449 $r1 = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `uid` = %d AND `parent` = %d",
3450 dbesc(datetime_convert()),
3451 intval($importer['importer_uid']),
3452 intval($r[0]['parent'])
3455 $r2 = q("UPDATE `item` SET `last-child` = 1, `changed` = '%s' WHERE `uid` = %d AND `id` = %d",
3456 dbesc(datetime_convert()),
3457 intval($importer['importer_uid']),
3462 if($posted_id && $parent) {
3464 proc_run('php',"include/notifier.php","comment-import","$posted_id");
3466 if((! $is_like) && (! $importer['self'])) {
3468 require_once('include/enotify.php');
3471 'type' => NOTIFY_COMMENT,
3472 'notify_flags' => $importer['notify-flags'],
3473 'language' => $importer['language'],
3474 'to_name' => $importer['username'],
3475 'to_email' => $importer['email'],
3476 'uid' => $importer['importer_uid'],
3477 'item' => $datarray,
3478 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3479 'source_name' => stripslashes($datarray['author-name']),
3480 'source_link' => $datarray['author-link'],
3481 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3482 ? $importer['thumb'] : $datarray['author-avatar']),
3483 'verb' => ACTIVITY_POST,
3485 'parent' => $parent,
3486 'parent_uri' => $parent_uri,
3498 // regular comment that is part of this total conversation. Have we seen it? If not, import it.
3500 $item_id = $item->get_id();
3501 $datarray = get_atom_elements($feed,$item);
3503 if($importer['rel'] == CONTACT_IS_FOLLOWER)
3506 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3508 intval($importer['importer_uid'])
3511 // Update content if 'updated' changes
3514 if (edited_timestamp_is_newer($r[0], $datarray)) {
3516 // do not accept (ignore) an earlier edit than one we currently have.
3517 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3520 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3521 dbesc($datarray['title']),
3522 dbesc($datarray['body']),
3523 dbesc($datarray['tag']),
3524 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3525 dbesc(datetime_convert()),
3527 intval($importer['importer_uid'])
3529 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3532 // update last-child if it changes
3534 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3535 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
3536 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
3537 dbesc(datetime_convert()),
3539 intval($importer['importer_uid'])
3541 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3542 intval($allow[0]['data']),
3543 dbesc(datetime_convert()),
3545 intval($importer['importer_uid'])
3551 $datarray['parent-uri'] = $parent_uri;
3552 $datarray['uid'] = $importer['importer_uid'];
3553 $datarray['contact-id'] = $importer['id'];
3554 if(($datarray['verb'] == ACTIVITY_LIKE) || ($datarray['verb'] == ACTIVITY_DISLIKE)) {
3555 $datarray['type'] = 'activity';
3556 $datarray['gravity'] = GRAVITY_LIKE;
3557 // only one like or dislike per person
3558 // splitted into two queries for performance issues
3559 $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",
3560 intval($datarray['uid']),
3561 intval($datarray['contact-id']),
3562 dbesc($datarray['verb']),
3568 $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",
3569 intval($datarray['uid']),
3570 intval($datarray['contact-id']),
3571 dbesc($datarray['verb']),
3579 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3581 $xo = parse_xml_string($datarray['object'],false);
3582 $xt = parse_xml_string($datarray['target'],false);
3584 if($xt->type == ACTIVITY_OBJ_NOTE) {
3585 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
3587 intval($importer['importer_uid'])
3592 // extract tag, if not duplicate, add to parent item
3594 if(! (stristr($r[0]['tag'],trim($xo->content)))) {
3595 q("UPDATE item SET tag = '%s' WHERE id = %d",
3596 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]'),
3599 create_tags_from_item($r[0]['id']);
3605 $posted_id = item_store($datarray);
3607 // find out if our user is involved in this conversation and wants to be notified.
3609 if(!x($datarray['type']) || $datarray['type'] != 'activity') {
3611 $myconv = q("SELECT `author-link`, `author-avatar`, `parent` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `parent` != 0 AND `deleted` = 0",
3613 intval($importer['importer_uid'])
3616 if(count($myconv)) {
3617 $importer_url = $a->get_baseurl() . '/profile/' . $importer['nickname'];
3619 // first make sure this isn't our own post coming back to us from a wall-to-wall event
3620 if(! link_compare($datarray['author-link'],$importer_url)) {
3623 foreach($myconv as $conv) {
3625 // now if we find a match, it means we're in this conversation
3627 if(! link_compare($conv['author-link'],$importer_url))
3630 require_once('include/enotify.php');
3632 $conv_parent = $conv['parent'];
3635 'type' => NOTIFY_COMMENT,
3636 'notify_flags' => $importer['notify-flags'],
3637 'language' => $importer['language'],
3638 'to_name' => $importer['username'],
3639 'to_email' => $importer['email'],
3640 'uid' => $importer['importer_uid'],
3641 'item' => $datarray,
3642 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3643 'source_name' => stripslashes($datarray['author-name']),
3644 'source_link' => $datarray['author-link'],
3645 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3646 ? $importer['thumb'] : $datarray['author-avatar']),
3647 'verb' => ACTIVITY_POST,
3649 'parent' => $conv_parent,
3650 'parent_uri' => $parent_uri
3654 // only send one notification
3666 // Head post of a conversation. Have we seen it? If not, import it.
3669 $item_id = $item->get_id();
3670 $datarray = get_atom_elements($feed,$item);
3672 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
3673 $ev = bbtoevent($datarray['body']);
3674 if(x($ev,'desc') && x($ev,'start')) {
3675 $ev['cid'] = $importer['id'];
3676 $ev['uid'] = $importer['uid'];
3677 $ev['uri'] = $item_id;
3678 $ev['edited'] = $datarray['edited'];
3679 $ev['private'] = $datarray['private'];
3681 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3683 intval($importer['uid'])
3686 $ev['id'] = $r[0]['id'];
3687 $xyz = event_store($ev);
3692 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3694 intval($importer['importer_uid'])
3697 // Update content if 'updated' changes
3700 if (edited_timestamp_is_newer($r[0], $datarray)) {
3702 // do not accept (ignore) an earlier edit than one we currently have.
3703 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3706 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3707 dbesc($datarray['title']),
3708 dbesc($datarray['body']),
3709 dbesc($datarray['tag']),
3710 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3711 dbesc(datetime_convert()),
3713 intval($importer['importer_uid'])
3715 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3716 update_thread_uri($item_id, $importer['importer_uid']);
3719 // update last-child if it changes
3721 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3722 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
3723 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3724 intval($allow[0]['data']),
3725 dbesc(datetime_convert()),
3727 intval($importer['importer_uid'])
3733 $datarray['parent-uri'] = $item_id;
3734 $datarray['uid'] = $importer['importer_uid'];
3735 $datarray['contact-id'] = $importer['id'];
3738 if(! link_compare($datarray['owner-link'],$importer['url'])) {
3739 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
3740 // but otherwise there's a possible data mixup on the sender's system.
3741 // the tgroup delivery code called from item_store will correct it if it's a forum,
3742 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
3743 logger('local_delivery: Correcting item owner.', LOGGER_DEBUG);
3744 $datarray['owner-name'] = $importer['senderName'];
3745 $datarray['owner-link'] = $importer['url'];
3746 $datarray['owner-avatar'] = $importer['thumb'];
3749 if(($importer['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['importer_uid'],$datarray)))
3752 // This is my contact on another system, but it's really me.
3753 // Turn this into a wall post.
3755 if($importer['remote_self'] AND (($importer['network'] === NETWORK_FEED) OR !$datarray['private'])) {
3756 logger('remote-self start - Contact '.$importer['url'].' - '.$importer['remote_self'].' Item '.print_r($datarray, true), LOGGER_DEBUG);
3757 if ($importer['remote_self'] == 1) {
3758 // Prevent that forwarded posts will be forwarded again
3759 $notify = (normalise_link($datarray['author-link']) == normalise_link($datarray['owner-link']));
3760 if ($datarray["app"] == $a->get_hostname())
3762 } elseif ($importer['remote_self'] == 2) {
3763 $r = q("SELECT `id`,`url`,`name`,`photo`,`network` FROM `contact` WHERE `uid` = %d AND `self`",
3764 intval($importer['importer_uid']));
3766 $datarray['contact-id'] = $r[0]["id"];
3768 $datarray['owner-name'] = $r[0]["name"];
3769 $datarray['owner-link'] = $r[0]["url"];
3770 $datarray['owner-avatar'] = $r[0]["avatar"];
3772 $datarray['author-name'] = $datarray['owner-name'];
3773 $datarray['author-link'] = $datarray['owner-link'];
3774 $datarray['author-avatar'] = $datarray['owner-avatar'];
3779 //if (!isset($datarray["app"]) OR ($datarray["app"] == ""))
3780 // $datarray["app"] = network_to_name($importer['network']);
3782 if ($importer['network'] === NETWORK_FEED)
3783 $datarray['private'] = 0;
3785 $datarray2 = $datarray;
3786 // Create a new guid and uri and post it as a forwarded post
3787 $datarray2["guid"] = get_guid(32);
3788 unset($datarray2["plink"]);
3789 $datarray2["uri"] = item_new_uri($a->get_hostname(),$importer['uid']);
3790 $datarray2["parent-uri"] = $datarray2["uri"];
3791 $datarray2["extid"] = NETWORK_DFRN;
3792 $urlpart = parse_url($datarray['author-link']);
3793 $datarray2["app"] = $urlpart["host"];
3794 $r = q("SELECT `id`,`url`,`name`,`photo`,`network` FROM `contact` WHERE `uid` = %d AND `self`", intval($importer['uid']));
3796 $datarray2['contact-id'] = $r[0]["id"];
3798 $datarray2['owner-name'] = $r[0]["name"];
3799 $datarray2['owner-link'] = $r[0]["url"];
3800 $datarray2['owner-avatar'] = $r[0]["avatar"];
3802 $datarray2['author-name'] = $datarray2['owner-name'];
3803 $datarray2['author-link'] = $datarray2['owner-link'];
3804 $datarray2['author-avatar'] = $datarray2['owner-avatar'];
3807 // Store the forwarded post
3808 $r = item_store($datarray2, false, true);
3809 logger('remote-self forwarded post - Contact '.$importer['url'].' return '.$r.' Item '.print_r($datarray2, true), LOGGER_DEBUG);
3811 // Let the original item just be a regular item
3817 $posted_id = item_store($datarray, false, $notify);
3819 if(stristr($datarray['verb'],ACTIVITY_POKE)) {
3820 $verb = urldecode(substr($datarray['verb'],strpos($datarray['verb'],'#')+1));
3823 $xo = parse_xml_string($datarray['object'],false);
3825 if(($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
3827 // somebody was poked/prodded. Was it me?
3829 $links = parse_xml_string("<links>".unxmlify($xo->link)."</links>",false);
3831 foreach($links->link as $l) {
3832 $atts = $l->attributes();
3833 switch($atts['rel']) {
3835 $Blink = $atts['href'];
3841 if($Blink && link_compare($Blink,$a->get_baseurl() . '/profile/' . $importer['nickname'])) {
3843 // send a notification
3844 require_once('include/enotify.php');
3847 'type' => NOTIFY_POKE,
3848 'notify_flags' => $importer['notify-flags'],
3849 'language' => $importer['language'],
3850 'to_name' => $importer['username'],
3851 'to_email' => $importer['email'],
3852 'uid' => $importer['importer_uid'],
3853 'item' => $datarray,
3854 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3855 'source_name' => stripslashes($datarray['author-name']),
3856 'source_link' => $datarray['author-link'],
3857 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3858 ? $importer['thumb'] : $datarray['author-avatar']),
3859 'verb' => $datarray['verb'],
3860 'otype' => 'person',
3861 'activity' => $verb,
3878 function new_follower($importer,$contact,$datarray,$item,$sharing = false) {
3879 $url = notags(trim($datarray['author-link']));
3880 $name = notags(trim($datarray['author-name']));
3881 $photo = notags(trim($datarray['author-avatar']));
3883 $rawtag = $item->get_item_tags(NAMESPACE_ACTIVITY,'actor');
3884 if($rawtag && $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'])
3885 $nick = $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'];
3887 if(is_array($contact)) {
3888 if(($contact['network'] == NETWORK_OSTATUS && $contact['rel'] == CONTACT_IS_SHARING)
3889 || ($sharing && $contact['rel'] == CONTACT_IS_FOLLOWER)) {
3890 $r = q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
3891 intval(CONTACT_IS_FRIEND),
3892 intval($contact['id']),
3893 intval($importer['uid'])
3896 // send email notification to owner?
3900 // create contact record
3902 $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `name`, `nick`, `photo`, `network`, `rel`,
3903 `blocked`, `readonly`, `pending`, `writable` )
3904 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, 1 ) ",
3905 intval($importer['uid']),
3906 dbesc(datetime_convert()),
3908 dbesc(normalise_link($url)),
3912 dbesc(($sharing) ? NETWORK_ZOT : NETWORK_OSTATUS),
3913 intval(($sharing) ? CONTACT_IS_SHARING : CONTACT_IS_FOLLOWER)
3915 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `url` = '%s' AND `pending` = 1 LIMIT 1",
3916 intval($importer['uid']),
3920 $contact_record = $r[0];
3922 // create notification
3923 $hash = random_string();
3925 if(is_array($contact_record)) {
3926 $ret = q("INSERT INTO `intro` ( `uid`, `contact-id`, `blocked`, `knowyou`, `hash`, `datetime`)
3927 VALUES ( %d, %d, 0, 0, '%s', '%s' )",
3928 intval($importer['uid']),
3929 intval($contact_record['id']),
3931 dbesc(datetime_convert())
3935 $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
3936 intval($importer['uid'])
3941 if(intval($r[0]['def_gid'])) {
3942 require_once('include/group.php');
3943 group_add_member($r[0]['uid'],'',$contact_record['id'],$r[0]['def_gid']);
3946 if(($r[0]['notify-flags'] & NOTIFY_INTRO) &&
3947 (($r[0]['page-flags'] == PAGE_NORMAL) OR ($r[0]['page-flags'] == PAGE_SOAPBOX))) {
3952 'type' => NOTIFY_INTRO,
3953 'notify_flags' => $r[0]['notify-flags'],
3954 'language' => $r[0]['language'],
3955 'to_name' => $r[0]['username'],
3956 'to_email' => $r[0]['email'],
3957 'uid' => $r[0]['uid'],
3958 'link' => $a->get_baseurl() . '/notifications/intro',
3959 'source_name' => ((strlen(stripslashes($contact_record['name']))) ? stripslashes($contact_record['name']) : t('[Name Withheld]')),
3960 'source_link' => $contact_record['url'],
3961 'source_photo' => $contact_record['photo'],
3962 'verb' => ($sharing ? ACTIVITY_FRIEND : ACTIVITY_FOLLOW),
3972 function lose_follower($importer,$contact,$datarray,$item) {
3974 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_SHARING)) {
3975 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
3976 intval(CONTACT_IS_SHARING),
3977 intval($contact['id'])
3981 contact_remove($contact['id']);
3985 function lose_sharer($importer,$contact,$datarray,$item) {
3987 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_FOLLOWER)) {
3988 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
3989 intval(CONTACT_IS_FOLLOWER),
3990 intval($contact['id'])
3994 contact_remove($contact['id']);
3999 function subscribe_to_hub($url,$importer,$contact,$hubmode = 'subscribe') {
4003 if(is_array($importer)) {
4004 $r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
4005 intval($importer['uid'])
4009 // Diaspora has different message-ids in feeds than they do
4010 // through the direct Diaspora protocol. If we try and use
4011 // the feed, we'll get duplicates. So don't.
4013 if((! count($r)) || $contact['network'] === NETWORK_DIASPORA)
4016 $push_url = get_config('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
4018 // Use a single verify token, even if multiple hubs
4020 $verify_token = ((strlen($contact['hub-verify'])) ? $contact['hub-verify'] : random_string());
4022 $params= 'hub.mode=' . $hubmode . '&hub.callback=' . urlencode($push_url) . '&hub.topic=' . urlencode($contact['poll']) . '&hub.verify=async&hub.verify_token=' . $verify_token;
4024 logger('subscribe_to_hub: ' . $hubmode . ' ' . $contact['name'] . ' to hub ' . $url . ' endpoint: ' . $push_url . ' with verifier ' . $verify_token);
4026 if(! strlen($contact['hub-verify'])) {
4027 $r = q("UPDATE `contact` SET `hub-verify` = '%s' WHERE `id` = %d",
4028 dbesc($verify_token),
4029 intval($contact['id'])
4033 post_url($url,$params);
4035 logger('subscribe_to_hub: returns: ' . $a->get_curl_code(), LOGGER_DEBUG);
4042 function atom_author($tag,$name,$uri,$h,$w,$photo) {
4046 $name = xmlify($name);
4047 $uri = xmlify($uri);
4050 $photo = xmlify($photo);
4054 $o .= "<name>$name</name>\r\n";
4055 $o .= "<uri>$uri</uri>\r\n";
4056 $o .= '<link rel="photo" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4057 $o .= '<link rel="avatar" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4059 call_hooks('atom_author', $o);
4061 $o .= "</$tag>\r\n";
4065 function atom_entry($item,$type,$author,$owner,$comment = false,$cid = 0) {
4069 if(! $item['parent'])
4072 if($item['deleted'])
4073 return '<at:deleted-entry ref="' . xmlify($item['uri']) . '" when="' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '" />' . "\r\n";
4076 if($item['allow_cid'] || $item['allow_gid'] || $item['deny_cid'] || $item['deny_gid'])
4077 $body = fix_private_photos($item['body'],$owner['uid'],$item,$cid);
4079 $body = $item['body'];
4081 $o = "\r\n\r\n<entry>\r\n";
4083 if(is_array($author))
4084 $o .= atom_author('author',$author['name'],$author['url'],80,80,$author['thumb']);
4086 $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']));
4087 if(strlen($item['owner-name']))
4088 $o .= atom_author('dfrn:owner',$item['owner-name'],$item['owner-link'],80,80,$item['owner-avatar']);
4090 if(($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
4091 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
4092 $o .= '<thr:in-reply-to ref="' . xmlify($parent_item) . '" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['parent']) . '" />' . "\r\n";
4095 $o .= '<id>' . xmlify($item['uri']) . '</id>' . "\r\n";
4096 $o .= '<title>' . xmlify($item['title']) . '</title>' . "\r\n";
4097 $o .= '<published>' . xmlify(datetime_convert('UTC','UTC',$item['created'] . '+00:00',ATOM_TIME)) . '</published>' . "\r\n";
4098 $o .= '<updated>' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '</updated>' . "\r\n";
4099 $o .= '<dfrn:env>' . base64url_encode($body, true) . '</dfrn:env>' . "\r\n";
4100 $o .= '<content type="' . $type . '" >' . xmlify((($type === 'html') ? bbcode($body) : $body)) . '</content>' . "\r\n";
4101 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['id']) . '" />' . "\r\n";
4103 $o .= '<dfrn:comment-allow>' . intval($item['last-child']) . '</dfrn:comment-allow>' . "\r\n";
4105 if($item['location']) {
4106 $o .= '<dfrn:location>' . xmlify($item['location']) . '</dfrn:location>' . "\r\n";
4107 $o .= '<poco:address><poco:formatted>' . xmlify($item['location']) . '</poco:formatted></poco:address>' . "\r\n";
4111 $o .= '<georss:point>' . xmlify($item['coord']) . '</georss:point>' . "\r\n";
4113 if(($item['private']) || strlen($item['allow_cid']) || strlen($item['allow_gid']) || strlen($item['deny_cid']) || strlen($item['deny_gid']))
4114 $o .= '<dfrn:private>' . (($item['private']) ? $item['private'] : 1) . '</dfrn:private>' . "\r\n";
4117 $o .= '<dfrn:extid>' . xmlify($item['extid']) . '</dfrn:extid>' . "\r\n";
4118 if($item['bookmark'])
4119 $o .= '<dfrn:bookmark>true</dfrn:bookmark>' . "\r\n";
4122 $o .= '<statusnet:notice_info local_id="' . $item['id'] . '" source="' . xmlify($item['app']) . '" ></statusnet:notice_info>' . "\r\n";
4125 $o .= '<dfrn:diaspora_guid>' . $item['guid'] . '</dfrn:diaspora_guid>' . "\r\n";
4127 if($item['signed_text']) {
4128 $sign = base64_encode(json_encode(array('signed_text' => $item['signed_text'],'signature' => $item['signature'],'signer' => $item['signer'])));
4129 $o .= '<dfrn:diaspora_signature>' . xmlify($sign) . '</dfrn:diaspora_signature>' . "\r\n";
4132 $verb = construct_verb($item);
4133 $o .= '<as:verb>' . xmlify($verb) . '</as:verb>' . "\r\n";
4134 $actobj = construct_activity_object($item);
4137 $actarg = construct_activity_target($item);
4141 $tags = item_getfeedtags($item);
4143 foreach($tags as $t) {
4144 $o .= '<category scheme="X-DFRN:' . xmlify($t[0]) . ':' . xmlify($t[1]) . '" term="' . xmlify($t[2]) . '" />' . "\r\n";
4148 $o .= item_getfeedattach($item);
4150 $mentioned = get_mentions($item);
4154 call_hooks('atom_entry', $o);
4156 $o .= '</entry>' . "\r\n";
4161 function fix_private_photos($s, $uid, $item = null, $cid = 0) {
4163 if(get_config('system','disable_embedded'))
4168 logger('fix_private_photos: check for photos', LOGGER_DEBUG);
4169 $site = substr($a->get_baseurl(),strpos($a->get_baseurl(),'://'));
4174 $img_start = strpos($orig_body, '[img');
4175 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4176 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4177 while( ($img_st_close !== false) && ($img_len !== false) ) {
4179 $img_st_close++; // make it point to AFTER the closing bracket
4180 $image = substr($orig_body, $img_start + $img_st_close, $img_len);
4182 logger('fix_private_photos: found photo ' . $image, LOGGER_DEBUG);
4185 if(stristr($image , $site . '/photo/')) {
4186 // Only embed locally hosted photos
4188 $i = basename($image);
4189 $i = str_replace(array('.jpg','.png','.gif'),array('','',''),$i);
4190 $x = strpos($i,'-');
4193 $res = substr($i,$x+1);
4194 $i = substr($i,0,$x);
4195 $r = q("SELECT * FROM `photo` WHERE `resource-id` = '%s' AND `scale` = %d AND `uid` = %d",
4202 // Check to see if we should replace this photo link with an embedded image
4203 // 1. No need to do so if the photo is public
4204 // 2. If there's a contact-id provided, see if they're in the access list
4205 // for the photo. If so, embed it.
4206 // 3. Otherwise, if we have an item, see if the item permissions match the photo
4207 // permissions, regardless of order but first check to see if they're an exact
4208 // match to save some processing overhead.
4210 if(has_permissions($r[0])) {
4212 $recips = enumerate_permissions($r[0]);
4213 if(in_array($cid, $recips)) {
4218 if(compare_permissions($item,$r[0]))
4223 $data = $r[0]['data'];
4224 $type = $r[0]['type'];
4226 // If a custom width and height were specified, apply before embedding
4227 if(preg_match("/\[img\=([0-9]*)x([0-9]*)\]/is", substr($orig_body, $img_start, $img_st_close), $match)) {
4228 logger('fix_private_photos: scaling photo', LOGGER_DEBUG);
4230 $width = intval($match[1]);
4231 $height = intval($match[2]);
4233 $ph = new Photo($data, $type);
4234 if($ph->is_valid()) {
4235 $ph->scaleImage(max($width, $height));
4236 $data = $ph->imageString();
4237 $type = $ph->getType();
4241 logger('fix_private_photos: replacing photo', LOGGER_DEBUG);
4242 $image = 'data:' . $type . ';base64,' . base64_encode($data);
4243 logger('fix_private_photos: replaced: ' . $image, LOGGER_DATA);
4249 $new_body = $new_body . substr($orig_body, 0, $img_start + $img_st_close) . $image . '[/img]';
4250 $orig_body = substr($orig_body, $img_start + $img_st_close + $img_len + strlen('[/img]'));
4251 if($orig_body === false)
4254 $img_start = strpos($orig_body, '[img');
4255 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4256 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4259 $new_body = $new_body . $orig_body;
4265 function has_permissions($obj) {
4266 if(($obj['allow_cid'] != '') || ($obj['allow_gid'] != '') || ($obj['deny_cid'] != '') || ($obj['deny_gid'] != ''))
4271 function compare_permissions($obj1,$obj2) {
4272 // first part is easy. Check that these are exactly the same.
4273 if(($obj1['allow_cid'] == $obj2['allow_cid'])
4274 && ($obj1['allow_gid'] == $obj2['allow_gid'])
4275 && ($obj1['deny_cid'] == $obj2['deny_cid'])
4276 && ($obj1['deny_gid'] == $obj2['deny_gid']))
4279 // This is harder. Parse all the permissions and compare the resulting set.
4281 $recipients1 = enumerate_permissions($obj1);
4282 $recipients2 = enumerate_permissions($obj2);
4285 if($recipients1 == $recipients2)
4290 // returns an array of contact-ids that are allowed to see this object
4292 function enumerate_permissions($obj) {
4293 require_once('include/group.php');
4294 $allow_people = expand_acl($obj['allow_cid']);
4295 $allow_groups = expand_groups(expand_acl($obj['allow_gid']));
4296 $deny_people = expand_acl($obj['deny_cid']);
4297 $deny_groups = expand_groups(expand_acl($obj['deny_gid']));
4298 $recipients = array_unique(array_merge($allow_people,$allow_groups));
4299 $deny = array_unique(array_merge($deny_people,$deny_groups));
4300 $recipients = array_diff($recipients,$deny);
4304 function item_getfeedtags($item) {
4307 $cnt = preg_match_all('|\#\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4309 for($x = 0; $x < $cnt; $x ++) {
4311 $ret[] = array('#',$matches[1][$x], $matches[2][$x]);
4315 $cnt = preg_match_all('|\@\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4317 for($x = 0; $x < $cnt; $x ++) {
4319 $ret[] = array('@',$matches[1][$x], $matches[2][$x]);
4325 function item_getfeedattach($item) {
4327 $arr = explode('[/attach],',$item['attach']);
4329 foreach($arr as $r) {
4331 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|',$r,$matches);
4333 $ret .= '<link rel="enclosure" href="' . xmlify($matches[1]) . '" type="' . xmlify($matches[3]) . '" ';
4334 if(intval($matches[2]))
4335 $ret .= 'length="' . intval($matches[2]) . '" ';
4336 if($matches[4] !== ' ')
4337 $ret .= 'title="' . xmlify(trim($matches[4])) . '" ';
4338 $ret .= ' />' . "\r\n";
4347 function item_expire($uid, $days, $network = "", $force = false) {
4349 if((! $uid) || ($days < 1))
4352 // $expire_network_only = save your own wall posts
4353 // and just expire conversations started by others
4355 $expire_network_only = get_pconfig($uid,'expire','network_only');
4356 $sql_extra = ((intval($expire_network_only)) ? " AND wall = 0 " : "");
4358 if ($network != "") {
4359 $sql_extra .= sprintf(" AND network = '%s' ", dbesc($network));
4360 // There is an index "uid_network_received" but not "uid_network_created"
4361 // This avoids the creation of another index just for one purpose.
4362 // And it doesn't really matter wether to look at "received" or "created"
4363 $range = "AND `received` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4365 $range = "AND `created` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4367 $r = q("SELECT * FROM `item`
4368 WHERE `uid` = %d $range
4379 $expire_items = get_pconfig($uid, 'expire','items');
4380 $expire_items = (($expire_items===false)?1:intval($expire_items)); // default if not set: 1
4382 // Forcing expiring of items - but not notes and marked items
4384 $expire_items = true;
4386 $expire_notes = get_pconfig($uid, 'expire','notes');
4387 $expire_notes = (($expire_notes===false)?1:intval($expire_notes)); // default if not set: 1
4389 $expire_starred = get_pconfig($uid, 'expire','starred');
4390 $expire_starred = (($expire_starred===false)?1:intval($expire_starred)); // default if not set: 1
4392 $expire_photos = get_pconfig($uid, 'expire','photos');
4393 $expire_photos = (($expire_photos===false)?0:intval($expire_photos)); // default if not set: 0
4395 logger('expire: # items=' . count($r). "; expire items: $expire_items, expire notes: $expire_notes, expire starred: $expire_starred, expire photos: $expire_photos");
4397 foreach($r as $item) {
4399 // don't expire filed items
4401 if(strpos($item['file'],'[') !== false)
4404 // Only expire posts, not photos and photo comments
4406 if($expire_photos==0 && strlen($item['resource-id']))
4408 if($expire_starred==0 && intval($item['starred']))
4410 if($expire_notes==0 && $item['type']=='note')
4412 if($expire_items==0 && $item['type']!='note')
4415 drop_item($item['id'],false);
4418 proc_run('php',"include/notifier.php","expire","$uid");
4423 function drop_items($items) {
4426 if(! local_user() && ! remote_user())
4430 foreach($items as $item) {
4431 $owner = drop_item($item,false);
4432 if($owner && ! $uid)
4437 // multiple threads may have been deleted, send an expire notification
4440 proc_run('php',"include/notifier.php","expire","$uid");
4444 function drop_item($id,$interactive = true) {
4448 // locate item to be deleted
4450 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
4457 notice( t('Item not found.') . EOL);
4458 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4463 $owner = $item['uid'];
4467 // check if logged in user is either the author or owner of this item
4469 if(is_array($_SESSION['remote'])) {
4470 foreach($_SESSION['remote'] as $visitor) {
4471 if($visitor['uid'] == $item['uid'] && $visitor['cid'] == $item['contact-id']) {
4472 $cid = $visitor['cid'];
4479 if((local_user() == $item['uid']) || ($cid) || (! $interactive)) {
4481 // Check if we should do HTML-based delete confirmation
4482 if($_REQUEST['confirm']) {
4483 // <form> can't take arguments in its "action" parameter
4484 // so add any arguments as hidden inputs
4485 $query = explode_querystring($a->query_string);
4487 foreach($query['args'] as $arg) {
4488 if(strpos($arg, 'confirm=') === false) {
4489 $arg_parts = explode('=', $arg);
4490 $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
4494 return replace_macros(get_markup_template('confirm.tpl'), array(
4496 '$message' => t('Do you really want to delete this item?'),
4497 '$extra_inputs' => $inputs,
4498 '$confirm' => t('Yes'),
4499 '$confirm_url' => $query['base'],
4500 '$confirm_name' => 'confirmed',
4501 '$cancel' => t('Cancel'),
4504 // Now check how the user responded to the confirmation query
4505 if($_REQUEST['canceled']) {
4506 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4509 logger('delete item: ' . $item['id'], LOGGER_DEBUG);
4512 $r = q("UPDATE `item` SET `deleted` = 1, `title` = '', `body` = '', `edited` = '%s', `changed` = '%s' WHERE `id` = %d",
4513 dbesc(datetime_convert()),
4514 dbesc(datetime_convert()),
4517 create_tags_from_item($item['id']);
4518 create_files_from_item($item['id']);
4519 delete_thread($item['id']);
4521 // clean up categories and tags so they don't end up as orphans
4524 $cnt = preg_match_all('/<(.*?)>/',$item['file'],$matches,PREG_SET_ORDER);
4526 foreach($matches as $mtch) {
4527 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],true);
4533 $cnt = preg_match_all('/\[(.*?)\]/',$item['file'],$matches,PREG_SET_ORDER);
4535 foreach($matches as $mtch) {
4536 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],false);
4540 // If item is a link to a photo resource, nuke all the associated photos
4541 // (visitors will not have photo resources)
4542 // This only applies to photos uploaded from the photos page. Photos inserted into a post do not
4543 // generate a resource-id and therefore aren't intimately linked to the item.
4545 if(strlen($item['resource-id'])) {
4546 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `uid` = %d ",
4547 dbesc($item['resource-id']),
4548 intval($item['uid'])
4550 // ignore the result
4553 // If item is a link to an event, nuke the event record.
4555 if(intval($item['event-id'])) {
4556 q("DELETE FROM `event` WHERE `id` = %d AND `uid` = %d",
4557 intval($item['event-id']),
4558 intval($item['uid'])
4560 // ignore the result
4563 // clean up item_id and sign meta-data tables
4566 // Old code - caused very long queries and warning entries in the mysql logfiles:
4568 $r = q("DELETE FROM item_id where iid in (select id from item where parent = %d and uid = %d)",
4569 intval($item['id']),
4570 intval($item['uid'])
4573 $r = q("DELETE FROM sign where iid in (select id from item where parent = %d and uid = %d)",
4574 intval($item['id']),
4575 intval($item['uid'])
4579 // The new code splits the queries since the mysql optimizer really has bad problems with subqueries
4581 // Creating list of parents
4582 $r = q("select id from item where parent = %d and uid = %d",
4583 intval($item['id']),
4584 intval($item['uid'])
4589 foreach ($r AS $row) {
4590 if ($parentid != "")
4593 $parentid .= $row["id"];
4597 if ($parentid != "") {
4598 $r = q("DELETE FROM item_id where iid in (%s)", dbesc($parentid));
4600 $r = q("DELETE FROM sign where iid in (%s)", dbesc($parentid));
4603 // If it's the parent of a comment thread, kill all the kids
4605 if($item['uri'] == $item['parent-uri']) {
4606 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = ''
4607 WHERE `parent-uri` = '%s' AND `uid` = %d ",
4608 dbesc(datetime_convert()),
4609 dbesc(datetime_convert()),
4610 dbesc($item['parent-uri']),
4611 intval($item['uid'])
4613 create_tags_from_item($item['parent-uri'], $item['uid']);
4614 create_files_from_item($item['parent-uri'], $item['uid']);
4615 delete_thread_uri($item['parent-uri'], $item['uid']);
4616 // ignore the result
4619 // ensure that last-child is set in case the comment that had it just got wiped.
4620 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
4621 dbesc(datetime_convert()),
4622 dbesc($item['parent-uri']),
4623 intval($item['uid'])
4625 // who is the last child now?
4626 $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",
4627 dbesc($item['parent-uri']),
4628 intval($item['uid'])
4631 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
4636 // Add a relayable_retraction signature for Diaspora.
4637 store_diaspora_retract_sig($item, $a->user, $a->get_baseurl());
4639 $drop_id = intval($item['id']);
4641 // send the notification upstream/downstream as the case may be
4643 proc_run('php',"include/notifier.php","drop","$drop_id");
4647 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4653 notice( t('Permission denied.') . EOL);
4654 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4661 function first_post_date($uid,$wall = false) {
4662 $r = q("select id, created from item
4663 where uid = %d and wall = %d and deleted = 0 and visible = 1 AND moderated = 0
4665 order by created asc limit 1",
4667 intval($wall ? 1 : 0)
4670 // logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA);
4671 return substr(datetime_convert('',date_default_timezone_get(),$r[0]['created']),0,10);
4676 function posted_dates($uid,$wall) {
4677 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
4679 $dthen = first_post_date($uid,$wall);
4683 // Set the start and end date to the beginning of the month
4684 $dnow = substr($dnow,0,8).'01';
4685 $dthen = substr($dthen,0,8).'01';
4688 // Starting with the current month, get the first and last days of every
4689 // month down to and including the month of the first post
4690 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
4691 $dstart = substr($dnow,0,8) . '01';
4692 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
4693 $start_month = datetime_convert('','',$dstart,'Y-m-d');
4694 $end_month = datetime_convert('','',$dend,'Y-m-d');
4695 $str = day_translate(datetime_convert('','',$dnow,'F Y'));
4696 $ret[] = array($str,$end_month,$start_month);
4697 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
4703 function posted_date_widget($url,$uid,$wall) {
4706 if(! feature_enabled($uid,'archives'))
4709 // For former Facebook folks that left because of "timeline"
4711 /* if($wall && intval(get_pconfig($uid,'system','no_wall_archive_widget')))
4714 $ret = posted_dates($uid,$wall);
4718 $o = replace_macros(get_markup_template('posted_date_widget.tpl'),array(
4719 '$title' => t('Archives'),
4720 '$size' => ((count($ret) > 6) ? 6 : count($ret)),
4727 function store_diaspora_retract_sig($item, $user, $baseurl) {
4728 // Note that we can't add a target_author_signature
4729 // if the comment was deleted by a remote user. That should be ok, because if a remote user is deleting
4730 // the comment, that means we're the home of the post, and Diaspora will only
4731 // check the parent_author_signature of retractions that it doesn't have to relay further
4733 // I don't think this function gets called for an "unlike," but I'll check anyway
4735 $enabled = intval(get_config('system','diaspora_enabled'));
4737 logger('drop_item: diaspora support disabled, not storing retraction signature', LOGGER_DEBUG);
4741 logger('drop_item: storing diaspora retraction signature');
4743 $signed_text = $item['guid'] . ';' . ( ($item['verb'] === ACTIVITY_LIKE) ? 'Like' : 'Comment');
4745 if(local_user() == $item['uid']) {
4747 $handle = $user['nickname'] . '@' . substr($baseurl, strpos($baseurl,'://') + 3);
4748 $authorsig = base64_encode(rsa_sign($signed_text,$user['prvkey'],'sha256'));
4751 $r = q("SELECT `nick`, `url` FROM `contact` WHERE `id` = '%d' LIMIT 1",
4752 $item['contact-id'] // If this function gets called, drop_item() has already checked remote_user() == $item['contact-id']
4755 // The below handle only works for NETWORK_DFRN. I think that's ok, because this function
4756 // only handles DFRN deletes
4757 $handle_baseurl_start = strpos($r['url'],'://') + 3;
4758 $handle_baseurl_length = strpos($r['url'],'/profile') - $handle_baseurl_start;
4759 $handle = $r['nick'] . '@' . substr($r['url'], $handle_baseurl_start, $handle_baseurl_length);
4765 q("insert into sign (`retract_iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
4766 intval($item['id']),
4767 dbesc($signed_text),