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 $atom .= replace_macros($feed_template, array(
167 '$version' => xmlify(FRIENDICA_VERSION),
168 '$feed_id' => xmlify($a->get_baseurl() . '/profile/' . $owner_nick),
169 '$feed_title' => xmlify($owner['name']),
170 '$feed_updated' => xmlify(datetime_convert('UTC', 'UTC', 'now' , ATOM_TIME)) ,
172 '$salmon' => $salmon,
173 '$name' => xmlify($owner['name']),
174 '$profile_page' => xmlify($owner['url']),
175 '$photo' => xmlify($owner['photo']),
176 '$thumb' => xmlify($owner['thumb']),
177 '$picdate' => xmlify(datetime_convert('UTC','UTC',$owner['avatar-date'] . '+00:00' , ATOM_TIME)) ,
178 '$uridate' => xmlify(datetime_convert('UTC','UTC',$owner['uri-date'] . '+00:00' , ATOM_TIME)) ,
179 '$namdate' => xmlify(datetime_convert('UTC','UTC',$owner['name-date'] . '+00:00' , ATOM_TIME)) ,
180 '$birthday' => ((strlen($birthday)) ? '<dfrn:birthday>' . xmlify($birthday) . '</dfrn:birthday>' : ''),
181 '$community' => (($owner['page-flags'] == PAGE_COMMUNITY) ? '<dfrn:community>1</dfrn:community>' : '')
184 call_hooks('atom_feed', $atom);
186 if(! count($items)) {
188 call_hooks('atom_feed_end', $atom);
190 $atom .= '</feed>' . "\r\n";
194 foreach($items as $item) {
196 // prevent private email from leaking.
197 if($item['network'] === NETWORK_MAIL)
200 // public feeds get html, our own nodes use bbcode
204 // catch any email that's in a public conversation and make sure it doesn't leak
212 $atom .= atom_entry($item,$type,null,$owner,true);
215 call_hooks('atom_feed_end', $atom);
217 $atom .= '</feed>' . "\r\n";
223 function construct_verb($item) {
225 return $item['verb'];
226 return ACTIVITY_POST;
229 function construct_activity_object($item) {
231 if($item['object']) {
232 $o = '<as:object>' . "\r\n";
233 $r = parse_xml_string($item['object'],false);
239 $o .= '<as:object-type>' . xmlify($r->type) . '</as:object-type>' . "\r\n";
241 $o .= '<id>' . xmlify($r->id) . '</id>' . "\r\n";
243 $o .= '<title>' . xmlify($r->title) . '</title>' . "\r\n";
245 if(substr($r->link,0,1) === '<') {
246 // patch up some facebook "like" activity objects that got stored incorrectly
247 // for a couple of months prior to 9-Jun-2011 and generated bad XML.
248 // we can probably remove this hack here and in the following function in a few months time.
249 if(strstr($r->link,'&') && (! strstr($r->link,'&')))
250 $r->link = str_replace('&','&', $r->link);
251 $r->link = preg_replace('/\<link(.*?)\"\>/','<link$1"/>',$r->link);
255 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($r->link) . '" />' . "\r\n";
258 $o .= '<content type="html" >' . xmlify(bbcode($r->content)) . '</content>' . "\r\n";
259 $o .= '</as:object>' . "\r\n";
266 function construct_activity_target($item) {
268 if($item['target']) {
269 $o = '<as:target>' . "\r\n";
270 $r = parse_xml_string($item['target'],false);
274 $o .= '<as:object-type>' . xmlify($r->type) . '</as:object-type>' . "\r\n";
276 $o .= '<id>' . xmlify($r->id) . '</id>' . "\r\n";
278 $o .= '<title>' . xmlify($r->title) . '</title>' . "\r\n";
280 if(substr($r->link,0,1) === '<') {
281 if(strstr($r->link,'&') && (! strstr($r->link,'&')))
282 $r->link = str_replace('&','&', $r->link);
283 $r->link = preg_replace('/\<link(.*?)\"\>/','<link$1"/>',$r->link);
287 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($r->link) . '" />' . "\r\n";
290 $o .= '<content type="html" >' . xmlify(bbcode($r->content)) . '</content>' . "\r\n";
291 $o .= '</as:target>' . "\r\n";
300 * The purpose of this function is to apply system message length limits to
301 * imported messages without including any embedded photos in the length
303 if(! function_exists('limit_body_size')) {
304 function limit_body_size($body) {
306 // logger('limit_body_size: start', LOGGER_DEBUG);
308 $maxlen = get_max_import_size();
310 // If the length of the body, including the embedded images, is smaller
311 // than the maximum, then don't waste time looking for the images
312 if($maxlen && (strlen($body) > $maxlen)) {
314 logger('limit_body_size: the total body length exceeds the limit', LOGGER_DEBUG);
321 $img_start = strpos($orig_body, '[img');
322 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
323 $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
324 while(($img_st_close !== false) && ($img_end !== false)) {
326 $img_st_close++; // make it point to AFTER the closing bracket
327 $img_end += $img_start;
328 $img_end += strlen('[/img]');
330 if(! strcmp(substr($orig_body, $img_start + $img_st_close, 5), 'data:')) {
331 // This is an embedded image
333 if( ($textlen + $img_start) > $maxlen ) {
334 if($textlen < $maxlen) {
335 logger('limit_body_size: the limit happens before an embedded image', LOGGER_DEBUG);
336 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
341 $new_body = $new_body . substr($orig_body, 0, $img_start);
342 $textlen += $img_start;
345 $new_body = $new_body . substr($orig_body, $img_start, $img_end - $img_start);
349 if( ($textlen + $img_end) > $maxlen ) {
350 if($textlen < $maxlen) {
351 logger('limit_body_size: the limit happens before the end of a non-embedded image', LOGGER_DEBUG);
352 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
357 $new_body = $new_body . substr($orig_body, 0, $img_end);
358 $textlen += $img_end;
361 $orig_body = substr($orig_body, $img_end);
363 if($orig_body === false) // in case the body ends on a closing image tag
366 $img_start = strpos($orig_body, '[img');
367 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
368 $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
371 if( ($textlen + strlen($orig_body)) > $maxlen) {
372 if($textlen < $maxlen) {
373 logger('limit_body_size: the limit happens after the end of the last image', LOGGER_DEBUG);
374 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
379 logger('limit_body_size: the text size with embedded images extracted did not violate the limit', LOGGER_DEBUG);
380 $new_body = $new_body . $orig_body;
381 $textlen += strlen($orig_body);
390 function title_is_body($title, $body) {
392 $title = strip_tags($title);
393 $title = trim($title);
394 $title = html_entity_decode($title, ENT_QUOTES, 'UTF-8');
395 $title = str_replace(array("\n", "\r", "\t", " "), array("","","",""), $title);
397 $body = strip_tags($body);
399 $body = html_entity_decode($body, ENT_QUOTES, 'UTF-8');
400 $body = str_replace(array("\n", "\r", "\t", " "), array("","","",""), $body);
402 if (strlen($title) < strlen($body))
403 $body = substr($body, 0, strlen($title));
405 if (($title != $body) and (substr($title, -3) == "...")) {
406 $pos = strrpos($title, "...");
408 $title = substr($title, 0, $pos);
409 $body = substr($body, 0, $pos);
413 return($title == $body);
418 function get_atom_elements($feed, $item, $contact = array()) {
420 require_once('library/HTMLPurifier.auto.php');
421 require_once('include/html2bbcode.php');
423 $best_photo = array();
427 $author = $item->get_author();
429 $res['author-name'] = unxmlify($author->get_name());
430 $res['author-link'] = unxmlify($author->get_link());
433 $res['author-name'] = unxmlify($feed->get_title());
434 $res['author-link'] = unxmlify($feed->get_permalink());
436 $res['uri'] = unxmlify($item->get_id());
437 $res['title'] = unxmlify($item->get_title());
438 $res['body'] = unxmlify($item->get_content());
439 $res['plink'] = unxmlify($item->get_link(0));
441 if (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND strstr($res['plink'], ".app.net/")) {
442 logger("get_atom_elements: detected app.net posting: ".print_r($res, true), LOGGER_DEBUG);
444 $res['body'] = nl2br($res['body']);
447 // removing the content of the title if its identically to the body
448 // This helps with auto generated titles e.g. from tumblr
449 if (title_is_body($res["title"], $res["body"]))
453 $base_url = implode('/', array_slice(explode('/',$res['plink']),0,3));
457 // look for a photo. We should check media size and find the best one,
458 // but for now let's just find any author photo
460 $rawauthor = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'author');
462 if($rawauthor && $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
463 $base = $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
464 foreach($base as $link) {
465 if(!x($res, 'author-avatar') || !$res['author-avatar']) {
466 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
467 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
472 $rawactor = $item->get_item_tags(NAMESPACE_ACTIVITY, 'actor');
474 if($rawactor && activity_match($rawactor[0]['child'][NAMESPACE_ACTIVITY]['object-type'][0]['data'],ACTIVITY_OBJ_PERSON)) {
475 $base = $rawactor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
476 if($base && count($base)) {
477 foreach($base as $link) {
478 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
479 $res['author-link'] = unxmlify($link['attribs']['']['href']);
480 if(!x($res, 'author-avatar') || !$res['author-avatar']) {
481 if($link['attribs']['']['rel'] === 'avatar' || $link['attribs']['']['rel'] === 'photo')
482 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
488 // No photo/profile-link on the item - look at the feed level
490 if((! (x($res,'author-link'))) || (! (x($res,'author-avatar')))) {
491 $rawauthor = $feed->get_feed_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'author');
492 if($rawauthor && $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
493 $base = $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
494 foreach($base as $link) {
495 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
496 $res['author-link'] = unxmlify($link['attribs']['']['href']);
497 if(! $res['author-avatar']) {
498 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
499 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
504 $rawactor = $feed->get_feed_tags(NAMESPACE_ACTIVITY, 'subject');
506 if($rawactor && activity_match($rawactor[0]['child'][NAMESPACE_ACTIVITY]['object-type'][0]['data'],ACTIVITY_OBJ_PERSON)) {
507 $base = $rawactor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
509 if($base && count($base)) {
510 foreach($base as $link) {
511 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
512 $res['author-link'] = unxmlify($link['attribs']['']['href']);
513 if(! (x($res,'author-avatar'))) {
514 if($link['attribs']['']['rel'] === 'avatar' || $link['attribs']['']['rel'] === 'photo')
515 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
522 $apps = $item->get_item_tags(NAMESPACE_STATUSNET,'notice_info');
523 if($apps && $apps[0]['attribs']['']['source']) {
524 $res['app'] = strip_tags(unxmlify($apps[0]['attribs']['']['source']));
525 if($res['app'] === 'web')
526 $res['app'] = 'OStatus';
529 // base64 encoded json structure representing Diaspora signature
531 $dsig = $item->get_item_tags(NAMESPACE_DFRN,'diaspora_signature');
533 $res['dsprsig'] = unxmlify($dsig[0]['data']);
536 $dguid = $item->get_item_tags(NAMESPACE_DFRN,'diaspora_guid');
538 $res['guid'] = unxmlify($dguid[0]['data']);
540 $bm = $item->get_item_tags(NAMESPACE_DFRN,'bookmark');
542 $res['bookmark'] = ((unxmlify($bm[0]['data']) === 'true') ? 1 : 0);
546 * If there's a copy of the body content which is guaranteed to have survived mangling in transit, use it.
549 $have_real_body = false;
551 $rawenv = $item->get_item_tags(NAMESPACE_DFRN, 'env');
553 $have_real_body = true;
554 $res['body'] = $rawenv[0]['data'];
555 $res['body'] = str_replace(array(' ',"\t","\r","\n"), array('','','',''),$res['body']);
556 // make sure nobody is trying to sneak some html tags by us
557 $res['body'] = notags(base64url_decode($res['body']));
561 $res['body'] = limit_body_size($res['body']);
563 // It isn't certain at this point whether our content is plaintext or html and we'd be foolish to trust
564 // the content type. Our own network only emits text normally, though it might have been converted to
565 // html if we used a pubsubhubbub transport. But if we see even one html tag in our text, we will
566 // have to assume it is all html and needs to be purified.
568 // It doesn't matter all that much security wise - because before this content is used anywhere, we are
569 // going to escape any tags we find regardless, but this lets us import a limited subset of html from
570 // the wild, by sanitising it and converting supported tags to bbcode before we rip out any remaining
573 if((strpos($res['body'],'<') !== false) && (strpos($res['body'],'>') !== false)) {
575 $res['body'] = reltoabs($res['body'],$base_url);
577 $res['body'] = html2bb_video($res['body']);
579 $res['body'] = oembed_html2bbcode($res['body']);
581 $config = HTMLPurifier_Config::createDefault();
582 $config->set('Cache.DefinitionImpl', null);
584 // we shouldn't need a whitelist, because the bbcode converter
585 // will strip out any unsupported tags.
587 $purifier = new HTMLPurifier($config);
588 $res['body'] = $purifier->purify($res['body']);
590 $res['body'] = @html2bbcode($res['body']);
594 elseif(! $have_real_body) {
596 // it's not one of our messages and it has no tags
597 // so it's probably just text. We'll escape it just to be safe.
599 $res['body'] = escape_tags($res['body']);
603 // this tag is obsolete but we keep it for really old sites
605 $allow = $item->get_item_tags(NAMESPACE_DFRN,'comment-allow');
606 if($allow && $allow[0]['data'] == 1)
607 $res['last-child'] = 1;
609 $res['last-child'] = 0;
611 $private = $item->get_item_tags(NAMESPACE_DFRN,'private');
612 if($private && intval($private[0]['data']) > 0)
613 $res['private'] = intval($private[0]['data']);
617 $extid = $item->get_item_tags(NAMESPACE_DFRN,'extid');
618 if($extid && $extid[0]['data'])
619 $res['extid'] = $extid[0]['data'];
621 $rawlocation = $item->get_item_tags(NAMESPACE_DFRN, 'location');
623 $res['location'] = unxmlify($rawlocation[0]['data']);
626 $rawcreated = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'published');
628 $res['created'] = unxmlify($rawcreated[0]['data']);
631 $rawedited = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'updated');
633 $res['edited'] = unxmlify($rawedited[0]['data']);
635 if((x($res,'edited')) && (! (x($res,'created'))))
636 $res['created'] = $res['edited'];
638 if(! $res['created'])
639 $res['created'] = $item->get_date('c');
642 $res['edited'] = $item->get_date('c');
645 // Disallow time travelling posts
647 $d1 = strtotime($res['created']);
648 $d2 = strtotime($res['edited']);
649 $d3 = strtotime('now');
652 $res['created'] = datetime_convert();
654 $res['edited'] = datetime_convert();
656 $rawowner = $item->get_item_tags(NAMESPACE_DFRN, 'owner');
657 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['name'][0]['data'])
658 $res['owner-name'] = unxmlify($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['name'][0]['data']);
659 elseif($rawowner[0]['child'][NAMESPACE_DFRN]['name'][0]['data'])
660 $res['owner-name'] = unxmlify($rawowner[0]['child'][NAMESPACE_DFRN]['name'][0]['data']);
661 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['uri'][0]['data'])
662 $res['owner-link'] = unxmlify($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['uri'][0]['data']);
663 elseif($rawowner[0]['child'][NAMESPACE_DFRN]['uri'][0]['data'])
664 $res['owner-link'] = unxmlify($rawowner[0]['child'][NAMESPACE_DFRN]['uri'][0]['data']);
666 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
667 $base = $rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
669 foreach($base as $link) {
670 if(!x($res, 'owner-avatar') || !$res['owner-avatar']) {
671 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
672 $res['owner-avatar'] = unxmlify($link['attribs']['']['href']);
677 $rawgeo = $item->get_item_tags(NAMESPACE_GEORSS,'point');
679 $res['coord'] = unxmlify($rawgeo[0]['data']);
681 if ($contact["network"] == NETWORK_FEED) {
682 $res['verb'] = ACTIVITY_POST;
683 $res['object-type'] = ACTIVITY_OBJ_NOTE;
686 $rawverb = $item->get_item_tags(NAMESPACE_ACTIVITY, 'verb');
688 // select between supported verbs
691 $res['verb'] = unxmlify($rawverb[0]['data']);
694 // translate OStatus unfollow to activity streams if it happened to get selected
696 if((x($res,'verb')) && ($res['verb'] === 'http://ostatus.org/schema/1.0/unfollow'))
697 $res['verb'] = ACTIVITY_UNFOLLOW;
699 $cats = $item->get_categories();
702 foreach($cats as $cat) {
703 $term = $cat->get_term();
705 $term = $cat->get_label();
706 $scheme = $cat->get_scheme();
707 if($scheme && $term && stristr($scheme,'X-DFRN:'))
708 $tag_arr[] = substr($scheme,7,1) . '[url=' . unxmlify(substr($scheme,9)) . ']' . unxmlify($term) . '[/url]';
710 $tag_arr[] = notags(trim($term));
712 $res['tag'] = implode(',', $tag_arr);
715 $attach = $item->get_enclosures();
718 foreach($attach as $att) {
719 $len = intval($att->get_length());
720 $link = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_link()))));
721 $title = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_title()))));
722 $type = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_type()))));
723 if(strpos($type,';'))
724 $type = substr($type,0,strpos($type,';'));
725 if((! $link) || (strpos($link,'http') !== 0))
731 $type = 'application/octet-stream';
733 $att_arr[] = '[attach]href="' . $link . '" length="' . $len . '" type="' . $type . '" title="' . $title . '"[/attach]';
735 $res['attach'] = implode(',', $att_arr);
738 $rawobj = $item->get_item_tags(NAMESPACE_ACTIVITY, 'object');
741 $res['object'] = '<object>' . "\n";
742 $child = $rawobj[0]['child'];
743 if($child[NAMESPACE_ACTIVITY]['object-type'][0]['data']) {
744 $res['object-type'] = $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'];
745 $res['object'] .= '<type>' . $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'] . '</type>' . "\n";
747 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'id') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'])
748 $res['object'] .= '<id>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'] . '</id>' . "\n";
749 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'link') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['link'])
750 $res['object'] .= '<link>' . encode_rel_links($child[SIMPLEPIE_NAMESPACE_ATOM_10]['link']) . '</link>' . "\n";
751 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'title') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'])
752 $res['object'] .= '<title>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'] . '</title>' . "\n";
753 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'content') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data']) {
754 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data'];
756 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['summary'][0]['data'];
757 // preserve a copy of the original body content in case we later need to parse out any microformat information, e.g. events
758 $res['object'] .= '<orig>' . xmlify($body) . '</orig>' . "\n";
759 if((strpos($body,'<') !== false) || (strpos($body,'>') !== false)) {
761 $body = html2bb_video($body);
763 $config = HTMLPurifier_Config::createDefault();
764 $config->set('Cache.DefinitionImpl', null);
766 $purifier = new HTMLPurifier($config);
767 $body = $purifier->purify($body);
768 $body = html2bbcode($body);
771 $res['object'] .= '<content>' . $body . '</content>' . "\n";
774 $res['object'] .= '</object>' . "\n";
777 $rawobj = $item->get_item_tags(NAMESPACE_ACTIVITY, 'target');
780 $res['target'] = '<target>' . "\n";
781 $child = $rawobj[0]['child'];
782 if($child[NAMESPACE_ACTIVITY]['object-type'][0]['data']) {
783 $res['target'] .= '<type>' . $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'] . '</type>' . "\n";
785 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'id') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'])
786 $res['target'] .= '<id>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'] . '</id>' . "\n";
787 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'link') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['link'])
788 $res['target'] .= '<link>' . encode_rel_links($child[SIMPLEPIE_NAMESPACE_ATOM_10]['link']) . '</link>' . "\n";
789 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'data') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'])
790 $res['target'] .= '<title>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'] . '</title>' . "\n";
791 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'data') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data']) {
792 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data'];
794 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['summary'][0]['data'];
795 // preserve a copy of the original body content in case we later need to parse out any microformat information, e.g. events
796 $res['target'] .= '<orig>' . xmlify($body) . '</orig>' . "\n";
797 if((strpos($body,'<') !== false) || (strpos($body,'>') !== false)) {
799 $body = html2bb_video($body);
801 $config = HTMLPurifier_Config::createDefault();
802 $config->set('Cache.DefinitionImpl', null);
804 $purifier = new HTMLPurifier($config);
805 $body = $purifier->purify($body);
806 $body = html2bbcode($body);
809 $res['target'] .= '<content>' . $body . '</content>' . "\n";
812 $res['target'] .= '</target>' . "\n";
815 // This is some experimental stuff. By now retweets are shown with "RT:"
816 // But: There is data so that the message could be shown similar to native retweets
817 // There is some better way to parse this array - but it didn't worked for me.
818 $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"];
819 if (is_array($child)) {
820 logger('get_atom_elements: Looking for status.net repeated message');
822 $message = $child["http://activitystrea.ms/spec/1.0/"]["object"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["content"][0]["data"];
823 $orig_uri = $child["http://activitystrea.ms/spec/1.0/"]["object"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["id"][0]["data"];
824 $author = $child[SIMPLEPIE_NAMESPACE_ATOM_10]["author"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10];
825 $uri = $author["uri"][0]["data"];
826 $name = $author["name"][0]["data"];
827 $avatar = @array_shift($author["link"][2]["attribs"]);
828 $avatar = $avatar["href"];
830 if (($name != "") and ($uri != "") and ($avatar != "") and ($message != "")) {
831 logger('get_atom_elements: fixing sender of repeated message.');
833 if (!intval(get_config('system','wall-to-wall_share'))) {
834 $prefix = "[share author='".str_replace("'", "'",$name).
836 "' avatar='".$avatar.
837 "' link='".$orig_uri."']";
839 $res["body"] = $prefix.html2bbcode($message)."[/share]";
841 $res["owner-name"] = $res["author-name"];
842 $res["owner-link"] = $res["author-link"];
843 $res["owner-avatar"] = $res["author-avatar"];
845 $res["author-name"] = $name;
846 $res["author-link"] = $uri;
847 $res["author-avatar"] = $avatar;
849 $res["body"] = html2bbcode($message);
854 // Search for ostatus conversation url
855 $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"];
857 if (is_array($links)) {
858 foreach ($links as $link) {
859 $conversation = array_shift($link["attribs"]);
861 if ($conversation["rel"] == "ostatus:conversation") {
862 $res["ostatus_conversation"] = $conversation["href"];
863 logger('get_atom_elements: found conversation url '.$res["ostatus_conversation"]);
868 if (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND $contact['fetch_further_information']) {
869 $res["body"] = $res["title"].add_page_info($res['plink']);
871 $res["object-type"] = ACTIVITY_OBJ_BOOKMARK;
872 } elseif (isset($contact["network"]) AND ($contact["network"] == NETWORK_OSTATUS))
873 $res["body"] = add_page_info_to_body($res["body"]);
874 elseif (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND strstr($res['plink'], ".app.net/")) {
875 $res["body"] = add_page_info_to_body($res["body"]);
878 $arr = array('feed' => $feed, 'item' => $item, 'result' => $res);
880 call_hooks('parse_atom', $arr);
885 function add_page_info($url, $no_photos = false, $photo = "") {
886 require_once("mod/parse_url.php");
888 $data = parseurl_getsiteinfo($url, true);
890 logger('add_page_info: fetch page info for '.$url.' '.print_r($data, true), LOGGER_DEBUG);
892 // It maybe is a rich content, but if it does have everything that a link has,
893 // then treat it that way
894 if (($data["type"] == "rich") AND is_string($data["title"]) AND
895 is_string($data["text"]) AND (sizeof($data["images"]) > 0))
896 $data["type"] = "link";
898 if ((($data["type"] != "link") AND ($data["type"] != "video") AND ($data["type"] != "photo")) OR ($data["title"] == $url))
901 if ($no_photos AND ($data["type"] == "photo"))
904 if (($data["type"] != "photo") AND is_string($data["title"]))
905 $text .= "[bookmark=".$url."]".trim($data["title"])."[/bookmark]";
907 if (($data["type"] != "video") AND ($photo != ""))
908 $text .= '[img]'.$photo.'[/img]';
909 elseif (($data["type"] != "video") AND (sizeof($data["images"]) > 0)) {
910 $imagedata = $data["images"][0];
911 $text .= '[img]'.$imagedata["src"].'[/img]';
914 if (($data["type"] != "photo") AND is_string($data["text"]))
915 $text .= "[quote]".$data["text"]."[/quote]";
917 return("\n[class=type-".$data["type"]."]".$text."[/class]");
920 function add_page_info_to_body($body, $texturl = false, $no_photos = false) {
922 logger('add_page_info_to_body: fetch page info for body '.$body, LOGGER_DEBUG);
924 $URLSearchString = "^\[\]";
926 // Adding these spaces is a quick hack due to my problems with regular expressions :)
927 preg_match("/[^!#@]\[url\]([$URLSearchString]*)\[\/url\]/ism", " ".$body, $matches);
930 preg_match("/[^!#@]\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism", " ".$body, $matches);
932 // Convert urls without bbcode elements
933 if (!$matches AND $texturl) {
934 preg_match("/([^\]\='".'"'."]|^)(https?\:\/\/[a-zA-Z0-9\:\/\-\?\&\;\.\=\_\~\#\%\$\!\+\,]+)/ism", " ".$body, $matches);
936 // Yeah, a hack. I really hate regular expressions :)
938 $matches[1] = $matches[2];
942 $footer = add_page_info($matches[1], $no_photos);
944 // Remove the link from the body if the link is attached at the end of the post
945 if (isset($footer) AND (trim($footer) != "") AND (strpos($footer, $matches[1]))) {
946 $removedlink = trim(str_replace($matches[1], "", $body));
947 if (($removedlink == "") OR strstr($body, $removedlink))
948 $body = $removedlink;
950 $url = str_replace(array('/', '.'), array('\/', '\.'), $matches[1]);
951 $removedlink = preg_replace("/\[url\=".$url."\](.*?)\[\/url\]/ism", '', $body);
952 if (($removedlink == "") OR strstr($body, $removedlink))
953 $body = $removedlink;
956 // Add the page information to the bottom
957 if (isset($footer) AND (trim($footer) != ""))
963 function encode_rel_links($links) {
965 if(! ((is_array($links)) && (count($links))))
967 foreach($links as $link) {
969 if($link['attribs']['']['rel'])
970 $o .= 'rel="' . $link['attribs']['']['rel'] . '" ';
971 if($link['attribs']['']['type'])
972 $o .= 'type="' . $link['attribs']['']['type'] . '" ';
973 if($link['attribs']['']['href'])
974 $o .= 'href="' . $link['attribs']['']['href'] . '" ';
975 if( (x($link['attribs'],NAMESPACE_MEDIA)) && $link['attribs'][NAMESPACE_MEDIA]['width'])
976 $o .= 'media:width="' . $link['attribs'][NAMESPACE_MEDIA]['width'] . '" ';
977 if( (x($link['attribs'],NAMESPACE_MEDIA)) && $link['attribs'][NAMESPACE_MEDIA]['height'])
978 $o .= 'media:height="' . $link['attribs'][NAMESPACE_MEDIA]['height'] . '" ';
986 function item_store($arr,$force_parent = false) {
988 // If a Diaspora signature structure was passed in, pull it out of the
989 // item array and set it aside for later storage.
992 if(x($arr,'dsprsig')) {
993 $dsprsig = json_decode(base64_decode($arr['dsprsig']));
994 unset($arr['dsprsig']);
997 // if an OStatus conversation url was passed in, it is stored and then
998 // removed from the array.
999 $ostatus_conversation = null;
1001 if (isset($arr["ostatus_conversation"])) {
1002 $ostatus_conversation = $arr["ostatus_conversation"];
1003 unset($arr["ostatus_conversation"]);
1006 if(x($arr, 'gravity'))
1007 $arr['gravity'] = intval($arr['gravity']);
1008 elseif($arr['parent-uri'] === $arr['uri'])
1009 $arr['gravity'] = 0;
1010 elseif(activity_match($arr['verb'],ACTIVITY_POST))
1011 $arr['gravity'] = 6;
1013 $arr['gravity'] = 6; // extensible catchall
1015 if(! x($arr,'type'))
1016 $arr['type'] = 'remote';
1020 /* check for create date and expire time */
1021 $uid = intval($arr['uid']);
1022 $r = q("SELECT expire FROM user WHERE uid = %d", $uid);
1024 $expire_interval = $r[0]['expire'];
1025 if ($expire_interval>0) {
1026 $expire_date = new DateTime( '- '.$expire_interval.' days', new DateTimeZone('UTC'));
1027 $created_date = new DateTime($arr['created'], new DateTimeZone('UTC'));
1028 if ($created_date < $expire_date) {
1029 logger('item-store: item created ('.$arr['created'].') before expiration time ('.$expire_date->format(DateTime::W3C).'). ignored. ' . print_r($arr,true), LOGGER_DEBUG);
1035 // If there is no guid then take the same guid that was taken before for the same uri
1036 if ((trim($arr['guid']) == "") AND (trim($arr['uri']) != "")) {
1037 logger('item_store: checking for an existing guid for uri '.$arr['uri'], LOGGER_DEBUG);
1038 $r = q("SELECT `guid` FROM `item` WHERE `uri` = '%s' AND `guid` != '' LIMIT 1",
1039 dbesc(trim($arr['uri']))
1043 $arr['guid'] = $r[0]["guid"];
1044 logger('item_store: found guid '.$arr['guid'].' for uri '.$arr['uri'], LOGGER_DEBUG);
1048 // Shouldn't happen but we want to make absolutely sure it doesn't leak from a plugin.
1049 // Deactivated, since the bbcode parser can handle with it - and it destroys posts with some smileys that contain "<"
1050 //if((strpos($arr['body'],'<') !== false) || (strpos($arr['body'],'>') !== false))
1051 // $arr['body'] = strip_tags($arr['body']);
1054 if (version_compare(PHP_VERSION, '5.3.0', '>=')) {
1055 require_once('library/langdet/Text/LanguageDetect.php');
1056 $naked_body = preg_replace('/\[(.+?)\]/','',$arr['body']);
1057 $l = new Text_LanguageDetect;
1058 //$lng = $l->detectConfidence($naked_body);
1059 //$arr['postopts'] = (($lng['language']) ? 'lang=' . $lng['language'] . ';' . $lng['confidence'] : '');
1060 $lng = $l->detect($naked_body, 3);
1062 if (sizeof($lng) > 0) {
1065 foreach ($lng as $language => $score) {
1066 if ($postopts == "")
1067 $postopts = "lang=";
1071 $postopts .= $language.";".$score;
1073 $arr['postopts'] = $postopts;
1077 $arr['wall'] = ((x($arr,'wall')) ? intval($arr['wall']) : 0);
1078 $arr['uri'] = ((x($arr,'uri')) ? notags(trim($arr['uri'])) : random_string());
1079 $arr['extid'] = ((x($arr,'extid')) ? notags(trim($arr['extid'])) : '');
1080 $arr['author-name'] = ((x($arr,'author-name')) ? notags(trim($arr['author-name'])) : '');
1081 $arr['author-link'] = ((x($arr,'author-link')) ? notags(trim($arr['author-link'])) : '');
1082 $arr['author-avatar'] = ((x($arr,'author-avatar')) ? notags(trim($arr['author-avatar'])) : '');
1083 $arr['owner-name'] = ((x($arr,'owner-name')) ? notags(trim($arr['owner-name'])) : '');
1084 $arr['owner-link'] = ((x($arr,'owner-link')) ? notags(trim($arr['owner-link'])) : '');
1085 $arr['owner-avatar'] = ((x($arr,'owner-avatar')) ? notags(trim($arr['owner-avatar'])) : '');
1086 $arr['created'] = ((x($arr,'created') !== false) ? datetime_convert('UTC','UTC',$arr['created']) : datetime_convert());
1087 $arr['edited'] = ((x($arr,'edited') !== false) ? datetime_convert('UTC','UTC',$arr['edited']) : datetime_convert());
1088 $arr['commented'] = datetime_convert();
1089 $arr['received'] = datetime_convert();
1090 $arr['changed'] = datetime_convert();
1091 $arr['title'] = ((x($arr,'title')) ? notags(trim($arr['title'])) : '');
1092 $arr['location'] = ((x($arr,'location')) ? notags(trim($arr['location'])) : '');
1093 $arr['coord'] = ((x($arr,'coord')) ? notags(trim($arr['coord'])) : '');
1094 $arr['last-child'] = ((x($arr,'last-child')) ? intval($arr['last-child']) : 0 );
1095 $arr['visible'] = ((x($arr,'visible') !== false) ? intval($arr['visible']) : 1 );
1096 $arr['deleted'] = 0;
1097 $arr['parent-uri'] = ((x($arr,'parent-uri')) ? notags(trim($arr['parent-uri'])) : '');
1098 $arr['verb'] = ((x($arr,'verb')) ? notags(trim($arr['verb'])) : '');
1099 $arr['object-type'] = ((x($arr,'object-type')) ? notags(trim($arr['object-type'])) : '');
1100 $arr['object'] = ((x($arr,'object')) ? trim($arr['object']) : '');
1101 $arr['target-type'] = ((x($arr,'target-type')) ? notags(trim($arr['target-type'])) : '');
1102 $arr['target'] = ((x($arr,'target')) ? trim($arr['target']) : '');
1103 $arr['plink'] = ((x($arr,'plink')) ? notags(trim($arr['plink'])) : '');
1104 $arr['allow_cid'] = ((x($arr,'allow_cid')) ? trim($arr['allow_cid']) : '');
1105 $arr['allow_gid'] = ((x($arr,'allow_gid')) ? trim($arr['allow_gid']) : '');
1106 $arr['deny_cid'] = ((x($arr,'deny_cid')) ? trim($arr['deny_cid']) : '');
1107 $arr['deny_gid'] = ((x($arr,'deny_gid')) ? trim($arr['deny_gid']) : '');
1108 $arr['private'] = ((x($arr,'private')) ? intval($arr['private']) : 0 );
1109 $arr['bookmark'] = ((x($arr,'bookmark')) ? intval($arr['bookmark']) : 0 );
1110 $arr['body'] = ((x($arr,'body')) ? trim($arr['body']) : '');
1111 $arr['tag'] = ((x($arr,'tag')) ? notags(trim($arr['tag'])) : '');
1112 $arr['attach'] = ((x($arr,'attach')) ? notags(trim($arr['attach'])) : '');
1113 $arr['app'] = ((x($arr,'app')) ? notags(trim($arr['app'])) : '');
1114 $arr['origin'] = ((x($arr,'origin')) ? intval($arr['origin']) : 0 );
1115 $arr['guid'] = ((x($arr,'guid')) ? notags(trim($arr['guid'])) : get_guid(30));
1116 $arr['network'] = ((x($arr,'network')) ? trim($arr['network']) : '');
1118 if ($arr['plink'] == "") {
1120 $arr['plink'] = $a->get_baseurl().'/display/'.urlencode($arr['guid']);
1123 if ($arr['network'] == "") {
1124 $r = q("SELECT `network` FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
1125 intval($arr['contact-id']),
1130 $arr['network'] = $r[0]["network"];
1132 // Fallback to friendica (why is it empty in some cases?)
1133 if ($arr['network'] == "")
1134 $arr['network'] = NETWORK_DFRN;
1136 logger("item_store: Set network to ".$arr["network"]." for ".$arr["uri"], LOGGER_DEBUG);
1139 $arr['thr-parent'] = $arr['parent-uri'];
1140 if($arr['parent-uri'] === $arr['uri']) {
1142 $parent_deleted = 0;
1143 $allow_cid = $arr['allow_cid'];
1144 $allow_gid = $arr['allow_gid'];
1145 $deny_cid = $arr['deny_cid'];
1146 $deny_gid = $arr['deny_gid'];
1150 // find the parent and snarf the item id and ACLs
1151 // and anything else we need to inherit
1153 $r = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC LIMIT 1",
1154 dbesc($arr['parent-uri']),
1160 // is the new message multi-level threaded?
1161 // even though we don't support it now, preserve the info
1162 // and re-attach to the conversation parent.
1164 if($r[0]['uri'] != $r[0]['parent-uri']) {
1165 $arr['parent-uri'] = $r[0]['parent-uri'];
1166 $z = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `parent-uri` = '%s' AND `uid` = %d
1167 ORDER BY `id` ASC LIMIT 1",
1168 dbesc($r[0]['parent-uri']),
1169 dbesc($r[0]['parent-uri']),
1176 $parent_id = $r[0]['id'];
1177 $parent_deleted = $r[0]['deleted'];
1178 $allow_cid = $r[0]['allow_cid'];
1179 $allow_gid = $r[0]['allow_gid'];
1180 $deny_cid = $r[0]['deny_cid'];
1181 $deny_gid = $r[0]['deny_gid'];
1182 $arr['wall'] = $r[0]['wall'];
1184 // if the parent is private, force privacy for the entire conversation
1185 // This differs from the above settings as it subtly allows comments from
1186 // email correspondents to be private even if the overall thread is not.
1188 if($r[0]['private'])
1189 $arr['private'] = $r[0]['private'];
1191 // Edge case. We host a public forum that was originally posted to privately.
1192 // The original author commented, but as this is a comment, the permissions
1193 // weren't fixed up so it will still show the comment as private unless we fix it here.
1195 if((intval($r[0]['forum_mode']) == 1) && (! $r[0]['private']))
1196 $arr['private'] = 0;
1199 // If its a post from myself then tag the thread as "mention"
1200 logger("item_store: Checking if parent ".$parent_id." has to be tagged as mention for user ".$arr['uid'], LOGGER_DEBUG);
1201 $u = q("select * from user where uid = %d limit 1", intval($arr['uid']));
1204 $self = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1205 logger("item_store: 'myself' is ".$self." for parent ".$parent_id." checking against ".$arr['author-link']." and ".$arr['owner-link'], LOGGER_DEBUG);
1206 if ((normalise_link($arr['author-link']) == $self) OR (normalise_link($arr['owner-link']) == $self)) {
1207 q("UPDATE `thread` SET `mention` = 1 WHERE `iid` = %d", intval($parent_id));
1208 logger("item_store: tagged thread ".$parent_id." as mention for user ".$self, LOGGER_DEBUG);
1214 // Allow one to see reply tweets from status.net even when
1215 // we don't have or can't see the original post.
1218 logger('item_store: $force_parent=true, reply converted to top-level post.');
1220 $arr['parent-uri'] = $arr['uri'];
1221 $arr['gravity'] = 0;
1224 logger('item_store: item parent was not found - ignoring item');
1228 $parent_deleted = 0;
1232 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
1236 if($r && count($r)) {
1237 logger('item-store: duplicate item ignored. ' . print_r($arr,true));
1241 call_hooks('post_remote',$arr);
1243 if(x($arr,'cancel')) {
1244 logger('item_store: post cancelled by plugin.');
1250 logger('item_store: ' . print_r($arr,true), LOGGER_DATA);
1252 $r = dbq("INSERT INTO `item` (`"
1253 . implode("`, `", array_keys($arr))
1255 . implode("', '", array_values($arr))
1258 // find the item we just created
1260 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC ",
1261 $arr['uri'], // already dbesc'd
1266 $current_post = $r[0]['id'];
1267 logger('item_store: created item ' . $current_post);
1269 // Only check for notifications on start posts
1270 if ($arr['parent-uri'] === $arr['uri']) {
1271 add_thread($r[0]['id']);
1272 logger('item_store: Check notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1274 // Send a notification for every new post?
1275 $r = q("SELECT `notify_new_posts` FROM `contact` WHERE `id` = %d AND `uid` = %d AND `notify_new_posts` LIMIT 1",
1276 intval($arr['contact-id']),
1281 logger('item_store: Send notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1282 $u = q("SELECT * FROM user WHERE uid = %d LIMIT 1",
1283 intval($arr['uid']));
1285 $item = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d",
1286 intval($current_post),
1292 require_once('include/enotify.php');
1294 'type' => NOTIFY_SHARE,
1295 'notify_flags' => $u[0]['notify-flags'],
1296 'language' => $u[0]['language'],
1297 'to_name' => $u[0]['username'],
1298 'to_email' => $u[0]['email'],
1299 'uid' => $u[0]['uid'],
1301 'link' => $a->get_baseurl().'/display/'.urlencode($arr['guid']),
1302 'source_name' => $item[0]['author-name'],
1303 'source_link' => $item[0]['author-link'],
1304 'source_photo' => $item[0]['author-avatar'],
1305 'verb' => ACTIVITY_TAG,
1308 logger('item_store: Notification sent for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1313 logger('item_store: could not locate created item');
1317 logger('item_store: duplicated post occurred. Removing duplicates.');
1318 q("DELETE FROM `item` WHERE `uri` = '%s' AND `uid` = %d AND `id` != %d ",
1320 intval($arr['uid']),
1321 intval($current_post)
1325 if((! $parent_id) || ($arr['parent-uri'] === $arr['uri']))
1326 $parent_id = $current_post;
1328 if(strlen($allow_cid) || strlen($allow_gid) || strlen($deny_cid) || strlen($deny_gid))
1331 $private = $arr['private'];
1333 // Set parent id - and also make sure to inherit the parent's ACLs.
1335 $r = q("UPDATE `item` SET `parent` = %d, `allow_cid` = '%s', `allow_gid` = '%s',
1336 `deny_cid` = '%s', `deny_gid` = '%s', `private` = %d, `deleted` = %d WHERE `id` = %d",
1343 intval($parent_deleted),
1344 intval($current_post)
1347 // Complete ostatus threads
1348 if ($ostatus_conversation)
1349 complete_conversation($current_post, $ostatus_conversation);
1351 $arr['id'] = $current_post;
1352 $arr['parent'] = $parent_id;
1353 $arr['allow_cid'] = $allow_cid;
1354 $arr['allow_gid'] = $allow_gid;
1355 $arr['deny_cid'] = $deny_cid;
1356 $arr['deny_gid'] = $deny_gid;
1357 $arr['private'] = $private;
1358 $arr['deleted'] = $parent_deleted;
1360 // update the commented timestamp on the parent
1362 q("UPDATE `item` set `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
1363 dbesc(datetime_convert()),
1364 dbesc(datetime_convert()),
1367 update_thread($parent_id);
1370 q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
1371 intval($current_post),
1372 dbesc($dsprsig->signed_text),
1373 dbesc($dsprsig->signature),
1374 dbesc($dsprsig->signer)
1380 * If this is now the last-child, force all _other_ children of this parent to *not* be last-child
1383 if($arr['last-child']) {
1384 $r = q("UPDATE `item` SET `last-child` = 0 WHERE `parent-uri` = '%s' AND `uid` = %d AND `id` != %d",
1386 intval($arr['uid']),
1387 intval($current_post)
1391 $deleted = tag_deliver($arr['uid'],$current_post);
1393 // current post can be deleted if is for a communuty page and no mention are
1397 // Store the fresh generated item into the cache
1398 $cachefile = get_cachefile($arr["guid"]."-".hash("md5", $arr['body']));
1400 if (($cachefile != '') AND !file_exists($cachefile)) {
1401 $s = prepare_text($arr['body']);
1403 $stamp1 = microtime(true);
1404 file_put_contents($cachefile, $s);
1405 $a->save_timestamp($stamp1, "file");
1406 logger('item_store: put item '.$current_post.' into cachefile '.$cachefile);
1409 $r = q('SELECT * FROM `item` WHERE id = %d', intval($current_post));
1410 if (count($r) == 1) {
1411 call_hooks('post_remote_end', $r[0]);
1413 logger('item_store: new item not found in DB, id ' . $current_post);
1417 create_tags_from_item($current_post);
1418 create_files_from_item($current_post);
1420 return $current_post;
1423 function get_item_guid($id) {
1424 $r = q("SELECT `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($id));
1426 return($r[0]["guid"]);
1431 function get_item_id($guid, $uid = 0) {
1437 $uid == local_user();
1439 // Does the given user have this item?
1441 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1442 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1443 AND `item`.`guid` = '%s' AND `item`.`uid` = %d", dbesc($guid), intval($uid));
1446 $nick = $r[0]["nickname"];
1450 // Or is it anywhere on the server?
1452 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1453 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1454 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = ''
1455 AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
1456 AND `item`.`private` = 0 AND `item`.`wall` = 1
1457 AND `item`.`guid` = '%s'", dbesc($guid));
1460 $nick = $r[0]["nickname"];
1463 return(array("nick" => $nick, "id" => $id));
1467 function get_item_contact($item,$contacts) {
1468 if(! count($contacts) || (! is_array($item)))
1470 foreach($contacts as $contact) {
1471 if($contact['id'] == $item['contact-id']) {
1473 break; // NOTREACHED
1480 * look for mention tags and setup a second delivery chain for forum/community posts if appropriate
1482 * @param int $item_id
1483 * @return bool true if item was deleted, else false
1485 function tag_deliver($uid,$item_id) {
1493 $u = q("select * from user where uid = %d limit 1",
1499 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1500 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1503 $i = q("select * from item where id = %d and uid = %d limit 1",
1512 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1514 // Diaspora uses their own hardwired link URL in @-tags
1515 // instead of the one we supply with webfinger
1517 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1519 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1521 foreach($matches as $mtch) {
1522 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1524 logger('tag_deliver: mention found: ' . $mtch[2]);
1530 if ( ($community_page || $prvgroup) &&
1531 (!$item['wall']) && (!$item['origin']) && ($item['id'] == $item['parent'])){
1532 // mmh.. no mention.. community page or private group... no wall.. no origin.. top-post (not a comment)
1534 logger("tag_deliver: no-mention top-level post to communuty or private group. delete.");
1535 q("DELETE FROM item WHERE id = %d and uid = %d",
1545 // send a notification
1547 // use a local photo if we have one
1549 $r = q("select * from contact where uid = %d and nurl = '%s' limit 1",
1550 intval($u[0]['uid']),
1551 dbesc(normalise_link($item['author-link']))
1553 $photo = (($r && count($r)) ? $r[0]['thumb'] : $item['author-avatar']);
1556 require_once('include/enotify.php');
1558 'type' => NOTIFY_TAGSELF,
1559 'notify_flags' => $u[0]['notify-flags'],
1560 'language' => $u[0]['language'],
1561 'to_name' => $u[0]['username'],
1562 'to_email' => $u[0]['email'],
1563 'uid' => $u[0]['uid'],
1565 'link' => $a->get_baseurl() . '/display/'.urlencode(get_item_guid($item['id'])),
1566 'source_name' => $item['author-name'],
1567 'source_link' => $item['author-link'],
1568 'source_photo' => $photo,
1569 'verb' => ACTIVITY_TAG,
1574 $arr = array('item' => $item, 'user' => $u[0], 'contact' => $r[0]);
1576 call_hooks('tagged', $arr);
1578 if((! $community_page) && (! $prvgroup))
1582 // tgroup delivery - setup a second delivery chain
1583 // prevent delivery looping - only proceed
1584 // if the message originated elsewhere and is a top-level post
1586 if(($item['wall']) || ($item['origin']) || ($item['id'] != $item['parent']))
1589 // now change this copy of the post to a forum head message and deliver to all the tgroup members
1592 $c = q("select name, url, thumb from contact where self = 1 and uid = %d limit 1",
1593 intval($u[0]['uid'])
1598 // also reset all the privacy bits to the forum default permissions
1600 $private = ($u[0]['allow_cid'] || $u[0]['allow_gid'] || $u[0]['deny_cid'] || $u[0]['deny_gid']) ? 1 : 0;
1602 $forum_mode = (($prvgroup) ? 2 : 1);
1604 q("update item set wall = 1, origin = 1, forum_mode = %d, `owner-name` = '%s', `owner-link` = '%s', `owner-avatar` = '%s',
1605 `private` = %d, `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s' where id = %d",
1606 intval($forum_mode),
1607 dbesc($c[0]['name']),
1608 dbesc($c[0]['url']),
1609 dbesc($c[0]['thumb']),
1611 dbesc($u[0]['allow_cid']),
1612 dbesc($u[0]['allow_gid']),
1613 dbesc($u[0]['deny_cid']),
1614 dbesc($u[0]['deny_gid']),
1617 update_thread($item_id);
1619 proc_run('php','include/notifier.php','tgroup',$item_id);
1625 function tgroup_check($uid,$item) {
1631 // check that the message originated elsewhere and is a top-level post
1633 if(($item['wall']) || ($item['origin']) || ($item['uri'] != $item['parent-uri']))
1637 $u = q("select * from user where uid = %d limit 1",
1643 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1644 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1647 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1649 // Diaspora uses their own hardwired link URL in @-tags
1650 // instead of the one we supply with webfinger
1652 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1654 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1656 foreach($matches as $mtch) {
1657 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1659 logger('tgroup_check: mention found: ' . $mtch[2]);
1667 if((! $community_page) && (! $prvgroup))
1681 function dfrn_deliver($owner,$contact,$atom, $dissolve = false) {
1685 $idtosend = $orig_id = (($contact['dfrn-id']) ? $contact['dfrn-id'] : $contact['issued-id']);
1687 if($contact['duplex'] && $contact['dfrn-id'])
1688 $idtosend = '0:' . $orig_id;
1689 if($contact['duplex'] && $contact['issued-id'])
1690 $idtosend = '1:' . $orig_id;
1692 $rino = ((function_exists('mcrypt_encrypt')) ? 1 : 0);
1694 $rino_enable = get_config('system','rino_encrypt');
1699 $ssl_val = intval(get_config('system','ssl_policy'));
1703 case SSL_POLICY_FULL:
1704 $ssl_policy = 'full';
1706 case SSL_POLICY_SELFSIGN:
1707 $ssl_policy = 'self';
1709 case SSL_POLICY_NONE:
1711 $ssl_policy = 'none';
1715 $url = $contact['notify'] . '&dfrn_id=' . $idtosend . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . (($rino) ? '&rino=1' : '');
1717 logger('dfrn_deliver: ' . $url);
1719 $xml = fetch_url($url);
1721 $curl_stat = $a->get_curl_code();
1723 return(-1); // timed out
1725 logger('dfrn_deliver: ' . $xml, LOGGER_DATA);
1730 if(strpos($xml,'<?xml') === false) {
1731 logger('dfrn_deliver: no valid XML returned');
1732 logger('dfrn_deliver: returned XML: ' . $xml, LOGGER_DATA);
1736 $res = parse_xml_string($xml);
1738 if((intval($res->status) != 0) || (! strlen($res->challenge)) || (! strlen($res->dfrn_id)))
1739 return (($res->status) ? $res->status : 3);
1741 $postvars = array();
1742 $sent_dfrn_id = hex2bin((string) $res->dfrn_id);
1743 $challenge = hex2bin((string) $res->challenge);
1744 $perm = (($res->perm) ? $res->perm : null);
1745 $dfrn_version = (float) (($res->dfrn_version) ? $res->dfrn_version : 2.0);
1746 $rino_allowed = ((intval($res->rino) === 1) ? 1 : 0);
1747 $page = (($owner['page-flags'] == PAGE_COMMUNITY) ? 1 : 0);
1749 if($owner['page-flags'] == PAGE_PRVGROUP)
1752 $final_dfrn_id = '';
1755 if((($perm == 'rw') && (! intval($contact['writable'])))
1756 || (($perm == 'r') && (intval($contact['writable'])))) {
1757 q("update contact set writable = %d where id = %d",
1758 intval(($perm == 'rw') ? 1 : 0),
1759 intval($contact['id'])
1761 $contact['writable'] = (string) 1 - intval($contact['writable']);
1765 if(($contact['duplex'] && strlen($contact['pubkey']))
1766 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1767 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1768 openssl_public_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['pubkey']);
1769 openssl_public_decrypt($challenge,$postvars['challenge'],$contact['pubkey']);
1772 openssl_private_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['prvkey']);
1773 openssl_private_decrypt($challenge,$postvars['challenge'],$contact['prvkey']);
1776 $final_dfrn_id = substr($final_dfrn_id, 0, strpos($final_dfrn_id, '.'));
1778 if(strpos($final_dfrn_id,':') == 1)
1779 $final_dfrn_id = substr($final_dfrn_id,2);
1781 if($final_dfrn_id != $orig_id) {
1782 logger('dfrn_deliver: wrong dfrn_id.');
1783 // did not decode properly - cannot trust this site
1787 $postvars['dfrn_id'] = $idtosend;
1788 $postvars['dfrn_version'] = DFRN_PROTOCOL_VERSION;
1790 $postvars['dissolve'] = '1';
1793 if((($contact['rel']) && ($contact['rel'] != CONTACT_IS_SHARING) && (! $contact['blocked'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
1794 $postvars['data'] = $atom;
1795 $postvars['perm'] = 'rw';
1798 $postvars['data'] = str_replace('<dfrn:comment-allow>1','<dfrn:comment-allow>0',$atom);
1799 $postvars['perm'] = 'r';
1802 $postvars['ssl_policy'] = $ssl_policy;
1805 $postvars['page'] = $page;
1807 if($rino && $rino_allowed && (! $dissolve)) {
1808 $key = substr(random_string(),0,16);
1809 $data = bin2hex(aes_encrypt($postvars['data'],$key));
1810 $postvars['data'] = $data;
1811 logger('rino: sent key = ' . $key, LOGGER_DEBUG);
1814 if($dfrn_version >= 2.1) {
1815 if(($contact['duplex'] && strlen($contact['pubkey']))
1816 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1817 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1819 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
1822 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
1826 if(($contact['duplex'] && strlen($contact['prvkey'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
1827 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
1830 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
1834 logger('md5 rawkey ' . md5($postvars['key']));
1836 $postvars['key'] = bin2hex($postvars['key']);
1839 logger('dfrn_deliver: ' . "SENDING: " . print_r($postvars,true), LOGGER_DATA);
1841 $xml = post_url($contact['notify'],$postvars);
1843 logger('dfrn_deliver: ' . "RECEIVED: " . $xml, LOGGER_DATA);
1845 $curl_stat = $a->get_curl_code();
1846 if((! $curl_stat) || (! strlen($xml)))
1847 return(-1); // timed out
1849 if(($curl_stat == 503) && (stristr($a->get_curl_headers(),'retry-after')))
1852 if(strpos($xml,'<?xml') === false) {
1853 logger('dfrn_deliver: phase 2: no valid XML returned');
1854 logger('dfrn_deliver: phase 2: returned XML: ' . $xml, LOGGER_DATA);
1858 if($contact['term-date'] != '0000-00-00 00:00:00') {
1859 logger("dfrn_deliver: $url back from the dead - removing mark for death");
1860 require_once('include/Contact.php');
1861 unmark_for_death($contact);
1864 $res = parse_xml_string($xml);
1866 return $res->status;
1871 This function returns true if $update has an edited timestamp newer
1872 than $existing, i.e. $update contains new data which should override
1873 what's already there. If there is no timestamp yet, the update is
1874 assumed to be newer. If the update has no timestamp, the existing
1875 item is assumed to be up-to-date. If the timestamps are equal it
1876 assumes the update has been seen before and should be ignored.
1878 function edited_timestamp_is_newer($existing, $update) {
1879 if (!x($existing,'edited') || !$existing['edited']) {
1882 if (!x($update,'edited') || !$update['edited']) {
1885 $existing_edited = datetime_convert('UTC', 'UTC', $existing['edited']);
1886 $update_edited = datetime_convert('UTC', 'UTC', $update['edited']);
1887 return (strcmp($existing_edited, $update_edited) < 0);
1892 * consume_feed - process atom feed and update anything/everything we might need to update
1894 * $xml = the (atom) feed to consume - RSS isn't as fully supported but may work for simple feeds.
1896 * $importer = the contact_record (joined to user_record) of the local user who owns this relationship.
1897 * It is this person's stuff that is going to be updated.
1898 * $contact = the person who is sending us stuff. If not set, we MAY be processing a "follow" activity
1899 * from an external network and MAY create an appropriate contact record. Otherwise, we MUST
1900 * have a contact record.
1901 * $hub = should we find a hub declation in the feed, pass it back to our calling process, who might (or
1902 * might not) try and subscribe to it.
1903 * $datedir sorts in reverse order
1904 * $pass - by default ($pass = 0) we cannot guarantee that a parent item has been
1905 * imported prior to its children being seen in the stream unless we are certain
1906 * of how the feed is arranged/ordered.
1907 * With $pass = 1, we only pull parent items out of the stream.
1908 * With $pass = 2, we only pull children (comments/likes).
1910 * So running this twice, first with pass 1 and then with pass 2 will do the right
1911 * thing regardless of feed ordering. This won't be adequate in a fully-threaded
1912 * model where comments can have sub-threads. That would require some massive sorting
1913 * to get all the feed items into a mostly linear ordering, and might still require
1917 function consume_feed($xml,$importer,&$contact, &$hub, $datedir = 0, $pass = 0) {
1919 require_once('library/simplepie/simplepie.inc');
1921 if(! strlen($xml)) {
1922 logger('consume_feed: empty input');
1926 $feed = new SimplePie();
1927 $feed->set_raw_data($xml);
1929 $feed->enable_order_by_date(true);
1931 $feed->enable_order_by_date(false);
1935 logger('consume_feed: Error parsing XML: ' . $feed->error());
1937 $permalink = $feed->get_permalink();
1939 // Check at the feed level for updated contact name and/or photo
1943 $photo_timestamp = '';
1947 $hubs = $feed->get_links('hub');
1948 logger('consume_feed: hubs: ' . print_r($hubs,true), LOGGER_DATA);
1951 $hub = implode(',', $hubs);
1953 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
1955 $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
1957 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
1958 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
1959 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
1960 $new_name = $elems['name'][0]['data'];
1962 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
1963 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
1964 $photo_url = $elems['link'][0]['attribs']['']['href'];
1967 if((x($rawtags[0]['child'], NAMESPACE_DFRN)) && (x($rawtags[0]['child'][NAMESPACE_DFRN],'birthday'))) {
1968 $birthday = datetime_convert('UTC','UTC', $rawtags[0]['child'][NAMESPACE_DFRN]['birthday'][0]['data']);
1972 if((is_array($contact)) && ($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $contact['avatar-date'])) {
1973 logger('consume_feed: Updating photo for ' . $contact['name']);
1974 require_once("include/Photo.php");
1975 $photo_failure = false;
1976 $have_photo = false;
1978 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
1979 intval($contact['id']),
1980 intval($contact['uid'])
1983 $resource_id = $r[0]['resource-id'];
1987 $resource_id = photo_new_resource();
1990 $img_str = fetch_url($photo_url,true);
1991 // guess mimetype from headers or filename
1992 $type = guess_image_type($photo_url,true);
1995 $img = new Photo($img_str, $type);
1996 if($img->is_valid()) {
1998 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
1999 dbesc($resource_id),
2000 intval($contact['id']),
2001 intval($contact['uid'])
2005 $img->scaleImageSquare(175);
2007 $hash = $resource_id;
2008 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2010 $img->scaleImage(80);
2011 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2013 $img->scaleImage(48);
2014 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2018 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2019 WHERE `uid` = %d AND `id` = %d",
2020 dbesc(datetime_convert()),
2021 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2022 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2023 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2024 intval($contact['uid']),
2025 intval($contact['id'])
2030 if((is_array($contact)) && ($name_updated) && (strlen($new_name)) && ($name_updated > $contact['name-date'])) {
2031 $r = q("select * from contact where uid = %d and id = %d limit 1",
2032 intval($contact['uid']),
2033 intval($contact['id'])
2036 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2037 dbesc(notags(trim($new_name))),
2038 dbesc(datetime_convert()),
2039 intval($contact['uid']),
2040 intval($contact['id'])
2043 // do our best to update the name on content items
2046 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2047 dbesc(notags(trim($new_name))),
2048 dbesc($r[0]['name']),
2049 dbesc($r[0]['url']),
2050 intval($contact['uid'])
2055 if(strlen($birthday)) {
2056 if(substr($birthday,0,4) != $contact['bdyear']) {
2057 logger('consume_feed: updating birthday: ' . $birthday);
2061 * Add new birthday event for this person
2063 * $bdtext is just a readable placeholder in case the event is shared
2064 * with others. We will replace it during presentation to our $importer
2065 * to contain a sparkle link and perhaps a photo.
2069 $bdtext = sprintf( t('%s\'s birthday'), $contact['name']);
2070 $bdtext2 = sprintf( t('Happy Birthday %s'), ' [url=' . $contact['url'] . ']' . $contact['name'] . '[/url]' ) ;
2073 $r = q("INSERT INTO `event` (`uid`,`cid`,`created`,`edited`,`start`,`finish`,`summary`,`desc`,`type`)
2074 VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) ",
2075 intval($contact['uid']),
2076 intval($contact['id']),
2077 dbesc(datetime_convert()),
2078 dbesc(datetime_convert()),
2079 dbesc(datetime_convert('UTC','UTC', $birthday)),
2080 dbesc(datetime_convert('UTC','UTC', $birthday . ' + 1 day ')),
2089 q("UPDATE `contact` SET `bdyear` = '%s' WHERE `uid` = %d AND `id` = %d",
2090 dbesc(substr($birthday,0,4)),
2091 intval($contact['uid']),
2092 intval($contact['id'])
2095 // This function is called twice without reloading the contact
2096 // Make sure we only create one event. This is why &$contact
2097 // is a reference var in this function
2099 $contact['bdyear'] = substr($birthday,0,4);
2104 $community_page = 0;
2105 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2107 $community_page = intval($rawtags[0]['data']);
2109 if(is_array($contact) && intval($contact['forum']) != $community_page) {
2110 q("update contact set forum = %d where id = %d",
2111 intval($community_page),
2112 intval($contact['id'])
2114 $contact['forum'] = (string) $community_page;
2118 // process any deleted entries
2120 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2121 if(is_array($del_entries) && count($del_entries) && $pass != 2) {
2122 foreach($del_entries as $dentry) {
2124 if(isset($dentry['attribs']['']['ref'])) {
2125 $uri = $dentry['attribs']['']['ref'];
2127 if(isset($dentry['attribs']['']['when'])) {
2128 $when = $dentry['attribs']['']['when'];
2129 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2132 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2134 if($deleted && is_array($contact)) {
2135 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN `contact` on `item`.`contact-id` = `contact`.`id`
2136 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
2138 intval($importer['uid']),
2139 intval($contact['id'])
2144 if(! $item['deleted'])
2145 logger('consume_feed: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
2147 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2148 $xo = parse_xml_string($item['object'],false);
2149 $xt = parse_xml_string($item['target'],false);
2150 if($xt->type === ACTIVITY_OBJ_NOTE) {
2151 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
2153 intval($importer['importer_uid'])
2157 // For tags, the owner cannot remove the tag on the author's copy of the post.
2159 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
2160 $author_remove = (($item['origin'] && $item['self']) ? true : false);
2161 $author_copy = (($item['origin']) ? true : false);
2163 if($owner_remove && $author_copy)
2165 if($author_remove || $owner_remove) {
2166 $tags = explode(',',$i[0]['tag']);
2169 foreach($tags as $tag)
2170 if(trim($tag) !== trim($xo->body))
2171 $newtags[] = trim($tag);
2173 q("update item set tag = '%s' where id = %d",
2174 dbesc(implode(',',$newtags)),
2177 create_tags_from_item($i[0]['id']);
2183 if($item['uri'] == $item['parent-uri']) {
2184 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2185 `body` = '', `title` = ''
2186 WHERE `parent-uri` = '%s' AND `uid` = %d",
2188 dbesc(datetime_convert()),
2189 dbesc($item['uri']),
2190 intval($importer['uid'])
2192 create_tags_from_itemuri($item['uri'], $importer['uid']);
2193 create_files_from_itemuri($item['uri'], $importer['uid']);
2194 update_thread_uri($item['uri'], $importer['uid']);
2197 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2198 `body` = '', `title` = ''
2199 WHERE `uri` = '%s' AND `uid` = %d",
2201 dbesc(datetime_convert()),
2203 intval($importer['uid'])
2205 create_tags_from_itemuri($uri, $importer['uid']);
2206 create_files_from_itemuri($uri, $importer['uid']);
2207 if($item['last-child']) {
2208 // ensure that last-child is set in case the comment that had it just got wiped.
2209 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
2210 dbesc(datetime_convert()),
2211 dbesc($item['parent-uri']),
2212 intval($item['uid'])
2214 // who is the last child now?
2215 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `moderated` = 0 AND `uid` = %d
2216 ORDER BY `created` DESC LIMIT 1",
2217 dbesc($item['parent-uri']),
2218 intval($importer['uid'])
2221 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
2232 // Now process the feed
2234 if($feed->get_item_quantity()) {
2236 logger('consume_feed: feed item count = ' . $feed->get_item_quantity());
2238 // in inverse date order
2240 $items = array_reverse($feed->get_items());
2242 $items = $feed->get_items();
2245 foreach($items as $item) {
2248 $item_id = $item->get_id();
2249 $rawthread = $item->get_item_tags( NAMESPACE_THREAD,'in-reply-to');
2250 if(isset($rawthread[0]['attribs']['']['ref'])) {
2252 $parent_uri = $rawthread[0]['attribs']['']['ref'];
2255 if(($is_reply) && is_array($contact)) {
2260 // not allowed to post
2262 if($contact['rel'] == CONTACT_IS_FOLLOWER)
2266 // Have we seen it? If not, import it.
2268 $item_id = $item->get_id();
2269 $datarray = get_atom_elements($feed, $item, $contact);
2271 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2272 $datarray['author-name'] = $contact['name'];
2273 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2274 $datarray['author-link'] = $contact['url'];
2275 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2276 $datarray['author-avatar'] = $contact['thumb'];
2278 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2279 logger('consume_feed: no author information! ' . print_r($datarray,true));
2283 $force_parent = false;
2284 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2285 if($contact['network'] === NETWORK_OSTATUS)
2286 $force_parent = true;
2287 if(strlen($datarray['title']))
2288 unset($datarray['title']);
2289 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2290 dbesc(datetime_convert()),
2292 intval($importer['uid'])
2294 $datarray['last-child'] = 1;
2295 update_thread_uri($parent_uri, $importer['uid']);
2299 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2301 intval($importer['uid'])
2304 // Update content if 'updated' changes
2307 if (edited_timestamp_is_newer($r[0], $datarray)) {
2309 // do not accept (ignore) an earlier edit than one we currently have.
2310 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2313 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2314 dbesc($datarray['title']),
2315 dbesc($datarray['body']),
2316 dbesc($datarray['tag']),
2317 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2318 dbesc(datetime_convert()),
2320 intval($importer['uid'])
2322 create_tags_from_itemuri($item_id, $importer['uid']);
2323 update_thread_uri($item_id, $importer['uid']);
2326 // update last-child if it changes
2328 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2329 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
2330 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2331 dbesc(datetime_convert()),
2333 intval($importer['uid'])
2335 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2336 intval($allow[0]['data']),
2337 dbesc(datetime_convert()),
2339 intval($importer['uid'])
2341 update_thread_uri($item_id, $importer['uid']);
2347 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2348 // one way feed - no remote comment ability
2349 $datarray['last-child'] = 0;
2351 $datarray['parent-uri'] = $parent_uri;
2352 $datarray['uid'] = $importer['uid'];
2353 $datarray['contact-id'] = $contact['id'];
2354 if((activity_match($datarray['verb'],ACTIVITY_LIKE)) || (activity_match($datarray['verb'],ACTIVITY_DISLIKE))) {
2355 $datarray['type'] = 'activity';
2356 $datarray['gravity'] = GRAVITY_LIKE;
2357 // only one like or dislike per person
2358 // splitted into two queries for performance issues
2359 $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",
2360 intval($datarray['uid']),
2361 intval($datarray['contact-id']),
2362 dbesc($datarray['verb']),
2368 $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",
2369 intval($datarray['uid']),
2370 intval($datarray['contact-id']),
2371 dbesc($datarray['verb']),
2378 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2379 $xo = parse_xml_string($datarray['object'],false);
2380 $xt = parse_xml_string($datarray['target'],false);
2382 if($xt->type == ACTIVITY_OBJ_NOTE) {
2383 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
2385 intval($importer['importer_uid'])
2390 // extract tag, if not duplicate, add to parent item
2391 if($xo->id && $xo->content) {
2392 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
2393 if(! (stristr($r[0]['tag'],$newtag))) {
2394 q("UPDATE item SET tag = '%s' WHERE id = %d",
2395 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . $newtag),
2398 create_tags_from_item($r[0]['id']);
2404 $r = item_store($datarray,$force_parent);
2410 // Head post of a conversation. Have we seen it? If not, import it.
2412 $item_id = $item->get_id();
2414 $datarray = get_atom_elements($feed, $item, $contact);
2416 if(is_array($contact)) {
2417 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2418 $datarray['author-name'] = $contact['name'];
2419 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2420 $datarray['author-link'] = $contact['url'];
2421 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2422 $datarray['author-avatar'] = $contact['thumb'];
2425 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2426 logger('consume_feed: no author information! ' . print_r($datarray,true));
2430 // special handling for events
2432 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
2433 $ev = bbtoevent($datarray['body']);
2434 if(x($ev,'desc') && x($ev,'start')) {
2435 $ev['uid'] = $importer['uid'];
2436 $ev['uri'] = $item_id;
2437 $ev['edited'] = $datarray['edited'];
2438 $ev['private'] = $datarray['private'];
2440 if(is_array($contact))
2441 $ev['cid'] = $contact['id'];
2442 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2444 intval($importer['uid'])
2447 $ev['id'] = $r[0]['id'];
2448 $xyz = event_store($ev);
2453 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2454 if(strlen($datarray['title']))
2455 unset($datarray['title']);
2456 $datarray['last-child'] = 1;
2460 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2462 intval($importer['uid'])
2465 // Update content if 'updated' changes
2468 if (edited_timestamp_is_newer($r[0], $datarray)) {
2470 // do not accept (ignore) an earlier edit than one we currently have.
2471 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2474 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2475 dbesc($datarray['title']),
2476 dbesc($datarray['body']),
2477 dbesc($datarray['tag']),
2478 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2479 dbesc(datetime_convert()),
2481 intval($importer['uid'])
2483 create_tags_from_itemuri($item_id, $importer['uid']);
2484 update_thread_uri($item_id, $importer['uid']);
2487 // update last-child if it changes
2489 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2490 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
2491 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2492 intval($allow[0]['data']),
2493 dbesc(datetime_convert()),
2495 intval($importer['uid'])
2497 update_thread_uri($item_id, $importer['uid']);
2502 if(activity_match($datarray['verb'],ACTIVITY_FOLLOW)) {
2503 logger('consume-feed: New follower');
2504 new_follower($importer,$contact,$datarray,$item);
2507 if(activity_match($datarray['verb'],ACTIVITY_UNFOLLOW)) {
2508 lose_follower($importer,$contact,$datarray,$item);
2512 if(activity_match($datarray['verb'],ACTIVITY_REQ_FRIEND)) {
2513 logger('consume-feed: New friend request');
2514 new_follower($importer,$contact,$datarray,$item,true);
2517 if(activity_match($datarray['verb'],ACTIVITY_UNFRIEND)) {
2518 lose_sharer($importer,$contact,$datarray,$item);
2523 if(! is_array($contact))
2527 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2528 // one way feed - no remote comment ability
2529 $datarray['last-child'] = 0;
2531 if($contact['network'] === NETWORK_FEED)
2532 $datarray['private'] = 2;
2534 // This is my contact on another system, but it's really me.
2535 // Turn this into a wall post.
2537 if($contact['remote_self']) {
2538 $datarray['wall'] = 1;
2539 if($contact['network'] === NETWORK_FEED) {
2540 $datarray['private'] = 0;
2544 $datarray['parent-uri'] = $item_id;
2545 $datarray['uid'] = $importer['uid'];
2546 $datarray['contact-id'] = $contact['id'];
2548 if(! link_compare($datarray['owner-link'],$contact['url'])) {
2549 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
2550 // but otherwise there's a possible data mixup on the sender's system.
2551 // the tgroup delivery code called from item_store will correct it if it's a forum,
2552 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
2553 logger('consume_feed: Correcting item owner.', LOGGER_DEBUG);
2554 $datarray['owner-name'] = $contact['name'];
2555 $datarray['owner-link'] = $contact['url'];
2556 $datarray['owner-avatar'] = $contact['thumb'];
2559 // We've allowed "followers" to reach this point so we can decide if they are
2560 // posting an @-tag delivery, which followers are allowed to do for certain
2561 // page types. Now that we've parsed the post, let's check if it is legit. Otherwise ignore it.
2563 if(($contact['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['uid'],$datarray)))
2567 $r = item_store($datarray);
2575 function local_delivery($importer,$data) {
2578 logger(__function__, LOGGER_TRACE);
2580 if($importer['readonly']) {
2581 // We aren't receiving stuff from this person. But we will quietly ignore them
2582 // rather than a blatant "go away" message.
2583 logger('local_delivery: ignoring');
2588 // Consume notification feed. This may differ from consuming a public feed in several ways
2589 // - might contain email or friend suggestions
2590 // - might contain remote followup to our message
2591 // - in which case we need to accept it and then notify other conversants
2592 // - we may need to send various email notifications
2594 $feed = new SimplePie();
2595 $feed->set_raw_data($data);
2596 $feed->enable_order_by_date(false);
2601 logger('local_delivery: Error parsing XML: ' . $feed->error());
2604 // Check at the feed level for updated contact name and/or photo
2608 $photo_timestamp = '';
2612 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2614 // Fallback should not be needed here. If it isn't DFRN it won't have DFRN updated tags
2616 // $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2619 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2620 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2621 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2622 $new_name = $elems['name'][0]['data'];
2624 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2625 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2626 $photo_url = $elems['link'][0]['attribs']['']['href'];
2630 if(($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $importer['avatar-date'])) {
2631 logger('local_delivery: Updating photo for ' . $importer['name']);
2632 require_once("include/Photo.php");
2633 $photo_failure = false;
2634 $have_photo = false;
2636 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2637 intval($importer['id']),
2638 intval($importer['importer_uid'])
2641 $resource_id = $r[0]['resource-id'];
2645 $resource_id = photo_new_resource();
2648 $img_str = fetch_url($photo_url,true);
2649 // guess mimetype from headers or filename
2650 $type = guess_image_type($photo_url,true);
2653 $img = new Photo($img_str, $type);
2654 if($img->is_valid()) {
2656 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2657 dbesc($resource_id),
2658 intval($importer['id']),
2659 intval($importer['importer_uid'])
2663 $img->scaleImageSquare(175);
2665 $hash = $resource_id;
2666 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2668 $img->scaleImage(80);
2669 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2671 $img->scaleImage(48);
2672 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2676 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2677 WHERE `uid` = %d AND `id` = %d",
2678 dbesc(datetime_convert()),
2679 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2680 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2681 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2682 intval($importer['importer_uid']),
2683 intval($importer['id'])
2688 if(($name_updated) && (strlen($new_name)) && ($name_updated > $importer['name-date'])) {
2689 $r = q("select * from contact where uid = %d and id = %d limit 1",
2690 intval($importer['importer_uid']),
2691 intval($importer['id'])
2694 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2695 dbesc(notags(trim($new_name))),
2696 dbesc(datetime_convert()),
2697 intval($importer['importer_uid']),
2698 intval($importer['id'])
2701 // do our best to update the name on content items
2704 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2705 dbesc(notags(trim($new_name))),
2706 dbesc($r[0]['name']),
2707 dbesc($r[0]['url']),
2708 intval($importer['importer_uid'])
2715 // Currently unsupported - needs a lot of work
2716 $reloc = $feed->get_feed_tags( NAMESPACE_DFRN, 'relocate' );
2717 if(isset($reloc[0]['child'][NAMESPACE_DFRN])) {
2718 $base = $reloc[0]['child'][NAMESPACE_DFRN];
2720 $newloc['uid'] = $importer['importer_uid'];
2721 $newloc['cid'] = $importer['id'];
2722 $newloc['name'] = notags(unxmlify($base['name'][0]['data']));
2723 $newloc['photo'] = notags(unxmlify($base['photo'][0]['data']));
2724 $newloc['thumb'] = notags(unxmlify($base['thumb'][0]['data']));
2725 $newloc['micro'] = notags(unxmlify($base['micro'][0]['data']));
2726 $newloc['url'] = notags(unxmlify($base['url'][0]['data']));
2727 $newloc['request'] = notags(unxmlify($base['request'][0]['data']));
2728 $newloc['confirm'] = notags(unxmlify($base['confirm'][0]['data']));
2729 $newloc['notify'] = notags(unxmlify($base['notify'][0]['data']));
2730 $newloc['poll'] = notags(unxmlify($base['poll'][0]['data']));
2731 $newloc['sitepubkey'] = notags(unxmlify($base['sitepubkey'][0]['data']));
2732 /** relocated user must have original key pair */
2733 /*$newloc['pubkey'] = notags(unxmlify($base['pubkey'][0]['data']));
2734 $newloc['prvkey'] = notags(unxmlify($base['prvkey'][0]['data']));*/
2736 logger("items:relocate contact ".print_r($newloc, true).print_r($importer, true), LOGGER_DEBUG);
2739 $r = q("SELECT photo, url FROM contact WHERE id=%d AND uid=%d;",
2740 intval($importer['id']),
2741 intval($importer['importer_uid']));
2746 $x = q("UPDATE contact SET
2756 `site-pubkey` = '%s'
2757 WHERE id=%d AND uid=%d;",
2758 dbesc($newloc['name']),
2759 dbesc($newloc['photo']),
2760 dbesc($newloc['thumb']),
2761 dbesc($newloc['micro']),
2762 dbesc($newloc['url']),
2763 dbesc($newloc['request']),
2764 dbesc($newloc['confirm']),
2765 dbesc($newloc['notify']),
2766 dbesc($newloc['poll']),
2767 dbesc($newloc['sitepubkey']),
2768 intval($importer['id']),
2769 intval($importer['importer_uid']));
2775 'owner-link' => array($old['url'], $newloc['url']),
2776 'author-link' => array($old['url'], $newloc['url']),
2777 'owner-avatar' => array($old['photo'], $newloc['photo']),
2778 'author-avatar' => array($old['photo'], $newloc['photo']),
2780 foreach ($fields as $n=>$f){
2781 $x = q("UPDATE `item` SET `%s`='%s' WHERE `%s`='%s' AND uid=%d",
2784 intval($importer['importer_uid']));
2790 // merge with current record, current contents have priority
2791 // update record, set url-updated
2792 // update profile photos
2798 // handle friend suggestion notification
2800 $sugg = $feed->get_feed_tags( NAMESPACE_DFRN, 'suggest' );
2801 if(isset($sugg[0]['child'][NAMESPACE_DFRN])) {
2802 $base = $sugg[0]['child'][NAMESPACE_DFRN];
2804 $fsugg['uid'] = $importer['importer_uid'];
2805 $fsugg['cid'] = $importer['id'];
2806 $fsugg['name'] = notags(unxmlify($base['name'][0]['data']));
2807 $fsugg['photo'] = notags(unxmlify($base['photo'][0]['data']));
2808 $fsugg['url'] = notags(unxmlify($base['url'][0]['data']));
2809 $fsugg['request'] = notags(unxmlify($base['request'][0]['data']));
2810 $fsugg['body'] = escape_tags(unxmlify($base['note'][0]['data']));
2812 // Does our member already have a friend matching this description?
2814 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `nurl` = '%s' AND `uid` = %d LIMIT 1",
2815 dbesc($fsugg['name']),
2816 dbesc(normalise_link($fsugg['url'])),
2817 intval($fsugg['uid'])
2822 // Do we already have an fcontact record for this person?
2825 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
2826 dbesc($fsugg['url']),
2827 dbesc($fsugg['name']),
2828 dbesc($fsugg['request'])
2833 // OK, we do. Do we already have an introduction for this person ?
2834 $r = q("select id from intro where uid = %d and fid = %d limit 1",
2835 intval($fsugg['uid']),
2842 $r = q("INSERT INTO `fcontact` ( `name`,`url`,`photo`,`request` ) VALUES ( '%s', '%s', '%s', '%s' ) ",
2843 dbesc($fsugg['name']),
2844 dbesc($fsugg['url']),
2845 dbesc($fsugg['photo']),
2846 dbesc($fsugg['request'])
2848 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
2849 dbesc($fsugg['url']),
2850 dbesc($fsugg['name']),
2851 dbesc($fsugg['request'])
2856 // database record did not get created. Quietly give up.
2861 $hash = random_string();
2863 $r = q("INSERT INTO `intro` ( `uid`, `fid`, `contact-id`, `note`, `hash`, `datetime`, `blocked` )
2864 VALUES( %d, %d, %d, '%s', '%s', '%s', %d )",
2865 intval($fsugg['uid']),
2867 intval($fsugg['cid']),
2868 dbesc($fsugg['body']),
2870 dbesc(datetime_convert()),
2875 'type' => NOTIFY_SUGGEST,
2876 'notify_flags' => $importer['notify-flags'],
2877 'language' => $importer['language'],
2878 'to_name' => $importer['username'],
2879 'to_email' => $importer['email'],
2880 'uid' => $importer['importer_uid'],
2882 'link' => $a->get_baseurl() . '/notifications/intros',
2883 'source_name' => $importer['name'],
2884 'source_link' => $importer['url'],
2885 'source_photo' => $importer['photo'],
2886 'verb' => ACTIVITY_REQ_FRIEND,
2895 $rawmail = $feed->get_feed_tags( NAMESPACE_DFRN, 'mail' );
2896 if(isset($rawmail[0]['child'][NAMESPACE_DFRN])) {
2898 logger('local_delivery: private message received');
2901 $base = $rawmail[0]['child'][NAMESPACE_DFRN];
2904 $msg['uid'] = $importer['importer_uid'];
2905 $msg['from-name'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['name'][0]['data']));
2906 $msg['from-photo'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['avatar'][0]['data']));
2907 $msg['from-url'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['uri'][0]['data']));
2908 $msg['contact-id'] = $importer['id'];
2909 $msg['title'] = notags(unxmlify($base['subject'][0]['data']));
2910 $msg['body'] = escape_tags(unxmlify($base['content'][0]['data']));
2912 $msg['replied'] = 0;
2913 $msg['uri'] = notags(unxmlify($base['id'][0]['data']));
2914 $msg['parent-uri'] = notags(unxmlify($base['in-reply-to'][0]['data']));
2915 $msg['created'] = datetime_convert(notags(unxmlify('UTC','UTC',$base['sentdate'][0]['data'])));
2919 $r = dbq("INSERT INTO `mail` (`" . implode("`, `", array_keys($msg))
2920 . "`) VALUES ('" . implode("', '", array_values($msg)) . "')" );
2922 // send notifications.
2924 require_once('include/enotify.php');
2926 $notif_params = array(
2927 'type' => NOTIFY_MAIL,
2928 'notify_flags' => $importer['notify-flags'],
2929 'language' => $importer['language'],
2930 'to_name' => $importer['username'],
2931 'to_email' => $importer['email'],
2932 'uid' => $importer['importer_uid'],
2934 'source_name' => $msg['from-name'],
2935 'source_link' => $importer['url'],
2936 'source_photo' => $importer['thumb'],
2937 'verb' => ACTIVITY_POST,
2941 notification($notif_params);
2947 $community_page = 0;
2948 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2950 $community_page = intval($rawtags[0]['data']);
2952 if(intval($importer['forum']) != $community_page) {
2953 q("update contact set forum = %d where id = %d",
2954 intval($community_page),
2955 intval($importer['id'])
2957 $importer['forum'] = (string) $community_page;
2960 logger('local_delivery: feed item count = ' . $feed->get_item_quantity());
2962 // process any deleted entries
2964 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2965 if(is_array($del_entries) && count($del_entries)) {
2966 foreach($del_entries as $dentry) {
2968 if(isset($dentry['attribs']['']['ref'])) {
2969 $uri = $dentry['attribs']['']['ref'];
2971 if(isset($dentry['attribs']['']['when'])) {
2972 $when = $dentry['attribs']['']['when'];
2973 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2976 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2980 // check for relayed deletes to our conversation
2983 $r = q("select * from item where uri = '%s' and uid = %d limit 1",
2985 intval($importer['importer_uid'])
2988 $parent_uri = $r[0]['parent-uri'];
2989 if($r[0]['id'] != $r[0]['parent'])
2996 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
2999 logger('local_delivery: possible community delete');
3002 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3004 // was the top-level post for this reply written by somebody on this site?
3005 // Specifically, the recipient?
3007 $is_a_remote_delete = false;
3009 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3010 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3011 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3012 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3013 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3014 AND `item`.`uid` = %d
3020 intval($importer['importer_uid'])
3023 $is_a_remote_delete = true;
3025 // Does this have the characteristics of a community or private group comment?
3026 // If it's a reply to a wall post on a community/prvgroup page it's a
3027 // valid community comment. Also forum_mode makes it valid for sure.
3028 // If neither, it's not.
3030 if($is_a_remote_delete && $community) {
3031 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3032 $is_a_remote_delete = false;
3033 logger('local_delivery: not a community delete');
3037 if($is_a_remote_delete) {
3038 logger('local_delivery: received remote delete');
3042 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN contact on `item`.`contact-id` = `contact`.`id`
3043 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
3045 intval($importer['importer_uid']),
3046 intval($importer['id'])
3052 if($item['deleted'])
3055 logger('local_delivery: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
3057 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3058 $xo = parse_xml_string($item['object'],false);
3059 $xt = parse_xml_string($item['target'],false);
3061 if($xt->type === ACTIVITY_OBJ_NOTE) {
3062 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
3064 intval($importer['importer_uid'])
3068 // For tags, the owner cannot remove the tag on the author's copy of the post.
3070 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
3071 $author_remove = (($item['origin'] && $item['self']) ? true : false);
3072 $author_copy = (($item['origin']) ? true : false);
3074 if($owner_remove && $author_copy)
3076 if($author_remove || $owner_remove) {
3077 $tags = explode(',',$i[0]['tag']);
3080 foreach($tags as $tag)
3081 if(trim($tag) !== trim($xo->body))
3082 $newtags[] = trim($tag);
3084 q("update item set tag = '%s' where id = %d",
3085 dbesc(implode(',',$newtags)),
3088 create_tags_from_item($i[0]['id']);
3094 if($item['uri'] == $item['parent-uri']) {
3095 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3096 `body` = '', `title` = ''
3097 WHERE `parent-uri` = '%s' AND `uid` = %d",
3099 dbesc(datetime_convert()),
3100 dbesc($item['uri']),
3101 intval($importer['importer_uid'])
3103 create_tags_from_itemuri($item['uri'], $importer['importer_uid']);
3104 create_files_from_itemuri($item['uri'], $importer['importer_uid']);
3105 update_thread_uri($item['uri'], $importer['importer_uid']);
3108 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3109 `body` = '', `title` = ''
3110 WHERE `uri` = '%s' AND `uid` = %d",
3112 dbesc(datetime_convert()),
3114 intval($importer['importer_uid'])
3116 create_tags_from_itemuri($uri, $importer['importer_uid']);
3117 create_files_from_itemuri($uri, $importer['importer_uid']);
3118 update_thread_uri($uri, $importer['importer_uid']);
3119 if($item['last-child']) {
3120 // ensure that last-child is set in case the comment that had it just got wiped.
3121 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
3122 dbesc(datetime_convert()),
3123 dbesc($item['parent-uri']),
3124 intval($item['uid'])
3126 // who is the last child now?
3127 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d
3128 ORDER BY `created` DESC LIMIT 1",
3129 dbesc($item['parent-uri']),
3130 intval($importer['importer_uid'])
3133 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
3138 // if this is a relayed delete, propagate it to other recipients
3140 if($is_a_remote_delete)
3141 proc_run('php',"include/notifier.php","drop",$item['id']);
3149 foreach($feed->get_items() as $item) {
3152 $item_id = $item->get_id();
3153 $rawthread = $item->get_item_tags( NAMESPACE_THREAD, 'in-reply-to');
3154 if(isset($rawthread[0]['attribs']['']['ref'])) {
3156 $parent_uri = $rawthread[0]['attribs']['']['ref'];
3162 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3165 logger('local_delivery: possible community reply');
3168 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3170 // was the top-level post for this reply written by somebody on this site?
3171 // Specifically, the recipient?
3173 $is_a_remote_comment = false;
3174 $top_uri = $parent_uri;
3176 $r = q("select `item`.`parent-uri` from `item`
3177 WHERE `item`.`uri` = '%s'
3181 if($r && count($r)) {
3182 $top_uri = $r[0]['parent-uri'];
3184 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3185 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3186 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3187 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3188 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3189 AND `item`.`uid` = %d
3195 intval($importer['importer_uid'])
3198 $is_a_remote_comment = true;
3201 // Does this have the characteristics of a community or private group comment?
3202 // If it's a reply to a wall post on a community/prvgroup page it's a
3203 // valid community comment. Also forum_mode makes it valid for sure.
3204 // If neither, it's not.
3206 if($is_a_remote_comment && $community) {
3207 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3208 $is_a_remote_comment = false;
3209 logger('local_delivery: not a community reply');
3213 if($is_a_remote_comment) {
3214 logger('local_delivery: received remote comment');
3216 // remote reply to our post. Import and then notify everybody else.
3218 $datarray = get_atom_elements($feed, $item);
3220 $r = q("SELECT `id`, `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3222 intval($importer['importer_uid'])
3225 // Update content if 'updated' changes
3229 if (edited_timestamp_is_newer($r[0], $datarray)) {
3231 // do not accept (ignore) an earlier edit than one we currently have.
3232 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3235 logger('received updated comment' , LOGGER_DEBUG);
3236 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3237 dbesc($datarray['title']),
3238 dbesc($datarray['body']),
3239 dbesc($datarray['tag']),
3240 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3241 dbesc(datetime_convert()),
3243 intval($importer['importer_uid'])
3245 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3247 proc_run('php',"include/notifier.php","comment-import",$iid);
3256 $own = q("select name,url,thumb from contact where uid = %d and self = 1 limit 1",
3257 intval($importer['importer_uid'])
3261 $datarray['type'] = 'remote-comment';
3262 $datarray['wall'] = 1;
3263 $datarray['parent-uri'] = $parent_uri;
3264 $datarray['uid'] = $importer['importer_uid'];
3265 $datarray['owner-name'] = $own[0]['name'];
3266 $datarray['owner-link'] = $own[0]['url'];
3267 $datarray['owner-avatar'] = $own[0]['thumb'];
3268 $datarray['contact-id'] = $importer['id'];
3270 if(($datarray['verb'] === ACTIVITY_LIKE) || ($datarray['verb'] === ACTIVITY_DISLIKE)) {
3272 $datarray['type'] = 'activity';
3273 $datarray['gravity'] = GRAVITY_LIKE;
3274 $datarray['last-child'] = 0;
3275 // only one like or dislike per person
3276 // splitted into two queries for performance issues
3277 $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",
3278 intval($datarray['uid']),
3279 intval($datarray['contact-id']),
3280 dbesc($datarray['verb']),
3281 dbesc($datarray['parent-uri'])
3287 $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",
3288 intval($datarray['uid']),
3289 intval($datarray['contact-id']),
3290 dbesc($datarray['verb']),
3291 dbesc($datarray['parent-uri'])
3298 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3300 $xo = parse_xml_string($datarray['object'],false);
3301 $xt = parse_xml_string($datarray['target'],false);
3303 if(($xt->type == ACTIVITY_OBJ_NOTE) && ($xt->id)) {
3305 // fetch the parent item
3307 $tagp = q("select * from item where uri = '%s' and uid = %d limit 1",
3309 intval($importer['importer_uid'])
3314 // extract tag, if not duplicate, and this user allows tags, add to parent item
3316 if($xo->id && $xo->content) {
3317 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
3318 if(! (stristr($tagp[0]['tag'],$newtag))) {
3319 $i = q("SELECT `blocktags` FROM `user` where `uid` = %d LIMIT 1",
3320 intval($importer['importer_uid'])
3322 if(count($i) && ! intval($i[0]['blocktags'])) {
3323 q("UPDATE item SET tag = '%s', `edited` = '%s', `changed` = '%s' WHERE id = %d",
3324 dbesc($tagp[0]['tag'] . (strlen($tagp[0]['tag']) ? ',' : '') . $newtag),
3325 intval($tagp[0]['id']),
3326 dbesc(datetime_convert()),
3327 dbesc(datetime_convert())
3329 create_tags_from_item($tagp[0]['id']);
3337 $posted_id = item_store($datarray);
3341 $r = q("SELECT `parent`, `parent-uri` FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3343 intval($importer['importer_uid'])
3346 $parent = $r[0]['parent'];
3347 $parent_uri = $r[0]['parent-uri'];
3351 $r1 = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `uid` = %d AND `parent` = %d",
3352 dbesc(datetime_convert()),
3353 intval($importer['importer_uid']),
3354 intval($r[0]['parent'])
3357 $r2 = q("UPDATE `item` SET `last-child` = 1, `changed` = '%s' WHERE `uid` = %d AND `id` = %d",
3358 dbesc(datetime_convert()),
3359 intval($importer['importer_uid']),
3364 if($posted_id && $parent) {
3366 proc_run('php',"include/notifier.php","comment-import","$posted_id");
3368 if((! $is_like) && (! $importer['self'])) {
3370 require_once('include/enotify.php');
3373 'type' => NOTIFY_COMMENT,
3374 'notify_flags' => $importer['notify-flags'],
3375 'language' => $importer['language'],
3376 'to_name' => $importer['username'],
3377 'to_email' => $importer['email'],
3378 'uid' => $importer['importer_uid'],
3379 'item' => $datarray,
3380 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3381 'source_name' => stripslashes($datarray['author-name']),
3382 'source_link' => $datarray['author-link'],
3383 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3384 ? $importer['thumb'] : $datarray['author-avatar']),
3385 'verb' => ACTIVITY_POST,
3387 'parent' => $parent,
3388 'parent_uri' => $parent_uri,
3400 // regular comment that is part of this total conversation. Have we seen it? If not, import it.
3402 $item_id = $item->get_id();
3403 $datarray = get_atom_elements($feed,$item);
3405 if($importer['rel'] == CONTACT_IS_FOLLOWER)
3408 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3410 intval($importer['importer_uid'])
3413 // Update content if 'updated' changes
3416 if (edited_timestamp_is_newer($r[0], $datarray)) {
3418 // do not accept (ignore) an earlier edit than one we currently have.
3419 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3422 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3423 dbesc($datarray['title']),
3424 dbesc($datarray['body']),
3425 dbesc($datarray['tag']),
3426 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3427 dbesc(datetime_convert()),
3429 intval($importer['importer_uid'])
3431 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3434 // update last-child if it changes
3436 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3437 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
3438 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
3439 dbesc(datetime_convert()),
3441 intval($importer['importer_uid'])
3443 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3444 intval($allow[0]['data']),
3445 dbesc(datetime_convert()),
3447 intval($importer['importer_uid'])
3453 $datarray['parent-uri'] = $parent_uri;
3454 $datarray['uid'] = $importer['importer_uid'];
3455 $datarray['contact-id'] = $importer['id'];
3456 if(($datarray['verb'] == ACTIVITY_LIKE) || ($datarray['verb'] == ACTIVITY_DISLIKE)) {
3457 $datarray['type'] = 'activity';
3458 $datarray['gravity'] = GRAVITY_LIKE;
3459 // only one like or dislike per person
3460 // splitted into two queries for performance issues
3461 $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",
3462 intval($datarray['uid']),
3463 intval($datarray['contact-id']),
3464 dbesc($datarray['verb']),
3470 $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",
3471 intval($datarray['uid']),
3472 intval($datarray['contact-id']),
3473 dbesc($datarray['verb']),
3481 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3483 $xo = parse_xml_string($datarray['object'],false);
3484 $xt = parse_xml_string($datarray['target'],false);
3486 if($xt->type == ACTIVITY_OBJ_NOTE) {
3487 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
3489 intval($importer['importer_uid'])
3494 // extract tag, if not duplicate, add to parent item
3496 if(! (stristr($r[0]['tag'],trim($xo->content)))) {
3497 q("UPDATE item SET tag = '%s' WHERE id = %d",
3498 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]'),
3501 create_tags_from_item($r[0]['id']);
3507 $posted_id = item_store($datarray);
3509 // find out if our user is involved in this conversation and wants to be notified.
3511 if(!x($datarray['type']) || $datarray['type'] != 'activity') {
3513 $myconv = q("SELECT `author-link`, `author-avatar`, `parent` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `parent` != 0 AND `deleted` = 0",
3515 intval($importer['importer_uid'])
3518 if(count($myconv)) {
3519 $importer_url = $a->get_baseurl() . '/profile/' . $importer['nickname'];
3521 // first make sure this isn't our own post coming back to us from a wall-to-wall event
3522 if(! link_compare($datarray['author-link'],$importer_url)) {
3525 foreach($myconv as $conv) {
3527 // now if we find a match, it means we're in this conversation
3529 if(! link_compare($conv['author-link'],$importer_url))
3532 require_once('include/enotify.php');
3534 $conv_parent = $conv['parent'];
3537 'type' => NOTIFY_COMMENT,
3538 'notify_flags' => $importer['notify-flags'],
3539 'language' => $importer['language'],
3540 'to_name' => $importer['username'],
3541 'to_email' => $importer['email'],
3542 'uid' => $importer['importer_uid'],
3543 'item' => $datarray,
3544 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3545 'source_name' => stripslashes($datarray['author-name']),
3546 'source_link' => $datarray['author-link'],
3547 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3548 ? $importer['thumb'] : $datarray['author-avatar']),
3549 'verb' => ACTIVITY_POST,
3551 'parent' => $conv_parent,
3552 'parent_uri' => $parent_uri
3556 // only send one notification
3568 // Head post of a conversation. Have we seen it? If not, import it.
3571 $item_id = $item->get_id();
3572 $datarray = get_atom_elements($feed,$item);
3574 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
3575 $ev = bbtoevent($datarray['body']);
3576 if(x($ev,'desc') && x($ev,'start')) {
3577 $ev['cid'] = $importer['id'];
3578 $ev['uid'] = $importer['uid'];
3579 $ev['uri'] = $item_id;
3580 $ev['edited'] = $datarray['edited'];
3581 $ev['private'] = $datarray['private'];
3583 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3585 intval($importer['uid'])
3588 $ev['id'] = $r[0]['id'];
3589 $xyz = event_store($ev);
3594 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3596 intval($importer['importer_uid'])
3599 // Update content if 'updated' changes
3602 if (edited_timestamp_is_newer($r[0], $datarray)) {
3604 // do not accept (ignore) an earlier edit than one we currently have.
3605 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3608 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3609 dbesc($datarray['title']),
3610 dbesc($datarray['body']),
3611 dbesc($datarray['tag']),
3612 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3613 dbesc(datetime_convert()),
3615 intval($importer['importer_uid'])
3617 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3618 update_thread_uri($item_id, $importer['importer_uid']);
3621 // update last-child if it changes
3623 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3624 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
3625 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3626 intval($allow[0]['data']),
3627 dbesc(datetime_convert()),
3629 intval($importer['importer_uid'])
3635 // This is my contact on another system, but it's really me.
3636 // Turn this into a wall post.
3638 if($importer['remote_self'])
3639 $datarray['wall'] = 1;
3641 $datarray['parent-uri'] = $item_id;
3642 $datarray['uid'] = $importer['importer_uid'];
3643 $datarray['contact-id'] = $importer['id'];
3646 if(! link_compare($datarray['owner-link'],$importer['url'])) {
3647 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
3648 // but otherwise there's a possible data mixup on the sender's system.
3649 // the tgroup delivery code called from item_store will correct it if it's a forum,
3650 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
3651 logger('local_delivery: Correcting item owner.', LOGGER_DEBUG);
3652 $datarray['owner-name'] = $importer['senderName'];
3653 $datarray['owner-link'] = $importer['url'];
3654 $datarray['owner-avatar'] = $importer['thumb'];
3657 if(($importer['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['importer_uid'],$datarray)))
3660 $posted_id = item_store($datarray);
3662 if(stristr($datarray['verb'],ACTIVITY_POKE)) {
3663 $verb = urldecode(substr($datarray['verb'],strpos($datarray['verb'],'#')+1));
3666 $xo = parse_xml_string($datarray['object'],false);
3668 if(($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
3670 // somebody was poked/prodded. Was it me?
3672 $links = parse_xml_string("<links>".unxmlify($xo->link)."</links>",false);
3674 foreach($links->link as $l) {
3675 $atts = $l->attributes();
3676 switch($atts['rel']) {
3678 $Blink = $atts['href'];
3684 if($Blink && link_compare($Blink,$a->get_baseurl() . '/profile/' . $importer['nickname'])) {
3686 // send a notification
3687 require_once('include/enotify.php');
3690 'type' => NOTIFY_POKE,
3691 'notify_flags' => $importer['notify-flags'],
3692 'language' => $importer['language'],
3693 'to_name' => $importer['username'],
3694 'to_email' => $importer['email'],
3695 'uid' => $importer['importer_uid'],
3696 'item' => $datarray,
3697 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3698 'source_name' => stripslashes($datarray['author-name']),
3699 'source_link' => $datarray['author-link'],
3700 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3701 ? $importer['thumb'] : $datarray['author-avatar']),
3702 'verb' => $datarray['verb'],
3703 'otype' => 'person',
3704 'activity' => $verb,
3721 function new_follower($importer,$contact,$datarray,$item,$sharing = false) {
3722 $url = notags(trim($datarray['author-link']));
3723 $name = notags(trim($datarray['author-name']));
3724 $photo = notags(trim($datarray['author-avatar']));
3726 $rawtag = $item->get_item_tags(NAMESPACE_ACTIVITY,'actor');
3727 if($rawtag && $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'])
3728 $nick = $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'];
3730 if(is_array($contact)) {
3731 if(($contact['network'] == NETWORK_OSTATUS && $contact['rel'] == CONTACT_IS_SHARING)
3732 || ($sharing && $contact['rel'] == CONTACT_IS_FOLLOWER)) {
3733 $r = q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
3734 intval(CONTACT_IS_FRIEND),
3735 intval($contact['id']),
3736 intval($importer['uid'])
3739 // send email notification to owner?
3743 // create contact record
3745 $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `name`, `nick`, `photo`, `network`, `rel`,
3746 `blocked`, `readonly`, `pending`, `writable` )
3747 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, 1 ) ",
3748 intval($importer['uid']),
3749 dbesc(datetime_convert()),
3751 dbesc(normalise_link($url)),
3755 dbesc(($sharing) ? NETWORK_ZOT : NETWORK_OSTATUS),
3756 intval(($sharing) ? CONTACT_IS_SHARING : CONTACT_IS_FOLLOWER)
3758 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `url` = '%s' AND `pending` = 1 LIMIT 1",
3759 intval($importer['uid']),
3763 $contact_record = $r[0];
3765 // create notification
3766 $hash = random_string();
3768 if(is_array($contact_record)) {
3769 $ret = q("INSERT INTO `intro` ( `uid`, `contact-id`, `blocked`, `knowyou`, `hash`, `datetime`)
3770 VALUES ( %d, %d, 0, 0, '%s', '%s' )",
3771 intval($importer['uid']),
3772 intval($contact_record['id']),
3774 dbesc(datetime_convert())
3777 $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
3778 intval($importer['uid'])
3783 if(intval($r[0]['def_gid'])) {
3784 require_once('include/group.php');
3785 group_add_member($r[0]['uid'],'',$contact_record['id'],$r[0]['def_gid']);
3788 if(($r[0]['notify-flags'] & NOTIFY_INTRO) &&
3789 (($r[0]['page-flags'] == PAGE_NORMAL) OR ($r[0]['page-flags'] == PAGE_SOAPBOX))) {
3790 $email_tpl = get_intltext_template('follow_notify_eml.tpl');
3791 $email = replace_macros($email_tpl, array(
3792 '$requestor' => ((strlen($name)) ? $name : t('[Name Withheld]')),
3794 '$myname' => $r[0]['username'],
3795 '$siteurl' => $a->get_baseurl(),
3796 '$sitename' => $a->config['sitename']
3798 $res = mail($r[0]['email'],
3799 email_header_encode((($sharing) ? t('A new person is sharing with you at ') : t("You have a new follower at ")) . $a->config['sitename'],'UTF-8'),
3801 'From: ' . 'Administrator' . '@' . $_SERVER['SERVER_NAME'] . "\n"
3802 . 'Content-type: text/plain; charset=UTF-8' . "\n"
3803 . 'Content-transfer-encoding: 8bit' );
3810 function lose_follower($importer,$contact,$datarray,$item) {
3812 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_SHARING)) {
3813 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
3814 intval(CONTACT_IS_SHARING),
3815 intval($contact['id'])
3819 contact_remove($contact['id']);
3823 function lose_sharer($importer,$contact,$datarray,$item) {
3825 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_FOLLOWER)) {
3826 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
3827 intval(CONTACT_IS_FOLLOWER),
3828 intval($contact['id'])
3832 contact_remove($contact['id']);
3837 function subscribe_to_hub($url,$importer,$contact,$hubmode = 'subscribe') {
3841 if(is_array($importer)) {
3842 $r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
3843 intval($importer['uid'])
3847 // Diaspora has different message-ids in feeds than they do
3848 // through the direct Diaspora protocol. If we try and use
3849 // the feed, we'll get duplicates. So don't.
3851 if((! count($r)) || $contact['network'] === NETWORK_DIASPORA)
3854 $push_url = get_config('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
3856 // Use a single verify token, even if multiple hubs
3858 $verify_token = ((strlen($contact['hub-verify'])) ? $contact['hub-verify'] : random_string());
3860 $params= 'hub.mode=' . $hubmode . '&hub.callback=' . urlencode($push_url) . '&hub.topic=' . urlencode($contact['poll']) . '&hub.verify=async&hub.verify_token=' . $verify_token;
3862 logger('subscribe_to_hub: ' . $hubmode . ' ' . $contact['name'] . ' to hub ' . $url . ' endpoint: ' . $push_url . ' with verifier ' . $verify_token);
3864 if(! strlen($contact['hub-verify'])) {
3865 $r = q("UPDATE `contact` SET `hub-verify` = '%s' WHERE `id` = %d",
3866 dbesc($verify_token),
3867 intval($contact['id'])
3871 post_url($url,$params);
3873 logger('subscribe_to_hub: returns: ' . $a->get_curl_code(), LOGGER_DEBUG);
3880 function atom_author($tag,$name,$uri,$h,$w,$photo) {
3884 $name = xmlify($name);
3885 $uri = xmlify($uri);
3888 $photo = xmlify($photo);
3892 $o .= "<name>$name</name>\r\n";
3893 $o .= "<uri>$uri</uri>\r\n";
3894 $o .= '<link rel="photo" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
3895 $o .= '<link rel="avatar" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
3897 call_hooks('atom_author', $o);
3899 $o .= "</$tag>\r\n";
3903 function atom_entry($item,$type,$author,$owner,$comment = false,$cid = 0) {
3907 if(! $item['parent'])
3910 if($item['deleted'])
3911 return '<at:deleted-entry ref="' . xmlify($item['uri']) . '" when="' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '" />' . "\r\n";
3914 if($item['allow_cid'] || $item['allow_gid'] || $item['deny_cid'] || $item['deny_gid'])
3915 $body = fix_private_photos($item['body'],$owner['uid'],$item,$cid);
3917 $body = $item['body'];
3919 $o = "\r\n\r\n<entry>\r\n";
3921 if(is_array($author))
3922 $o .= atom_author('author',$author['name'],$author['url'],80,80,$author['thumb']);
3924 $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']));
3925 if(strlen($item['owner-name']))
3926 $o .= atom_author('dfrn:owner',$item['owner-name'],$item['owner-link'],80,80,$item['owner-avatar']);
3928 if(($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
3929 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
3930 $o .= '<thr:in-reply-to ref="' . xmlify($parent_item) . '" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['parent']) . '" />' . "\r\n";
3933 $o .= '<id>' . xmlify($item['uri']) . '</id>' . "\r\n";
3934 $o .= '<title>' . xmlify($item['title']) . '</title>' . "\r\n";
3935 $o .= '<published>' . xmlify(datetime_convert('UTC','UTC',$item['created'] . '+00:00',ATOM_TIME)) . '</published>' . "\r\n";
3936 $o .= '<updated>' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '</updated>' . "\r\n";
3937 $o .= '<dfrn:env>' . base64url_encode($body, true) . '</dfrn:env>' . "\r\n";
3938 $o .= '<content type="' . $type . '" >' . xmlify((($type === 'html') ? bbcode($body) : $body)) . '</content>' . "\r\n";
3939 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['id']) . '" />' . "\r\n";
3941 $o .= '<dfrn:comment-allow>' . intval($item['last-child']) . '</dfrn:comment-allow>' . "\r\n";
3943 if($item['location']) {
3944 $o .= '<dfrn:location>' . xmlify($item['location']) . '</dfrn:location>' . "\r\n";
3945 $o .= '<poco:address><poco:formatted>' . xmlify($item['location']) . '</poco:formatted></poco:address>' . "\r\n";
3949 $o .= '<georss:point>' . xmlify($item['coord']) . '</georss:point>' . "\r\n";
3951 if(($item['private']) || strlen($item['allow_cid']) || strlen($item['allow_gid']) || strlen($item['deny_cid']) || strlen($item['deny_gid']))
3952 $o .= '<dfrn:private>' . (($item['private']) ? $item['private'] : 1) . '</dfrn:private>' . "\r\n";
3955 $o .= '<dfrn:extid>' . xmlify($item['extid']) . '</dfrn:extid>' . "\r\n";
3956 if($item['bookmark'])
3957 $o .= '<dfrn:bookmark>true</dfrn:bookmark>' . "\r\n";
3960 $o .= '<statusnet:notice_info local_id="' . $item['id'] . '" source="' . xmlify($item['app']) . '" ></statusnet:notice_info>' . "\r\n";
3963 $o .= '<dfrn:diaspora_guid>' . $item['guid'] . '</dfrn:diaspora_guid>' . "\r\n";
3965 if($item['signed_text']) {
3966 $sign = base64_encode(json_encode(array('signed_text' => $item['signed_text'],'signature' => $item['signature'],'signer' => $item['signer'])));
3967 $o .= '<dfrn:diaspora_signature>' . xmlify($sign) . '</dfrn:diaspora_signature>' . "\r\n";
3970 $verb = construct_verb($item);
3971 $o .= '<as:verb>' . xmlify($verb) . '</as:verb>' . "\r\n";
3972 $actobj = construct_activity_object($item);
3975 $actarg = construct_activity_target($item);
3979 $tags = item_getfeedtags($item);
3981 foreach($tags as $t) {
3982 $o .= '<category scheme="X-DFRN:' . xmlify($t[0]) . ':' . xmlify($t[1]) . '" term="' . xmlify($t[2]) . '" />' . "\r\n";
3986 $o .= item_getfeedattach($item);
3988 $mentioned = get_mentions($item);
3992 call_hooks('atom_entry', $o);
3994 $o .= '</entry>' . "\r\n";
3999 function fix_private_photos($s, $uid, $item = null, $cid = 0) {
4001 if(get_config('system','disable_embedded'))
4006 logger('fix_private_photos: check for photos', LOGGER_DEBUG);
4007 $site = substr($a->get_baseurl(),strpos($a->get_baseurl(),'://'));
4012 $img_start = strpos($orig_body, '[img');
4013 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4014 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4015 while( ($img_st_close !== false) && ($img_len !== false) ) {
4017 $img_st_close++; // make it point to AFTER the closing bracket
4018 $image = substr($orig_body, $img_start + $img_st_close, $img_len);
4020 logger('fix_private_photos: found photo ' . $image, LOGGER_DEBUG);
4023 if(stristr($image , $site . '/photo/')) {
4024 // Only embed locally hosted photos
4026 $i = basename($image);
4027 $i = str_replace(array('.jpg','.png','.gif'),array('','',''),$i);
4028 $x = strpos($i,'-');
4031 $res = substr($i,$x+1);
4032 $i = substr($i,0,$x);
4033 $r = q("SELECT * FROM `photo` WHERE `resource-id` = '%s' AND `scale` = %d AND `uid` = %d",
4040 // Check to see if we should replace this photo link with an embedded image
4041 // 1. No need to do so if the photo is public
4042 // 2. If there's a contact-id provided, see if they're in the access list
4043 // for the photo. If so, embed it.
4044 // 3. Otherwise, if we have an item, see if the item permissions match the photo
4045 // permissions, regardless of order but first check to see if they're an exact
4046 // match to save some processing overhead.
4048 if(has_permissions($r[0])) {
4050 $recips = enumerate_permissions($r[0]);
4051 if(in_array($cid, $recips)) {
4056 if(compare_permissions($item,$r[0]))
4061 $data = $r[0]['data'];
4062 $type = $r[0]['type'];
4064 // If a custom width and height were specified, apply before embedding
4065 if(preg_match("/\[img\=([0-9]*)x([0-9]*)\]/is", substr($orig_body, $img_start, $img_st_close), $match)) {
4066 logger('fix_private_photos: scaling photo', LOGGER_DEBUG);
4068 $width = intval($match[1]);
4069 $height = intval($match[2]);
4071 $ph = new Photo($data, $type);
4072 if($ph->is_valid()) {
4073 $ph->scaleImage(max($width, $height));
4074 $data = $ph->imageString();
4075 $type = $ph->getType();
4079 logger('fix_private_photos: replacing photo', LOGGER_DEBUG);
4080 $image = 'data:' . $type . ';base64,' . base64_encode($data);
4081 logger('fix_private_photos: replaced: ' . $image, LOGGER_DATA);
4087 $new_body = $new_body . substr($orig_body, 0, $img_start + $img_st_close) . $image . '[/img]';
4088 $orig_body = substr($orig_body, $img_start + $img_st_close + $img_len + strlen('[/img]'));
4089 if($orig_body === false)
4092 $img_start = strpos($orig_body, '[img');
4093 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4094 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4097 $new_body = $new_body . $orig_body;
4103 function has_permissions($obj) {
4104 if(($obj['allow_cid'] != '') || ($obj['allow_gid'] != '') || ($obj['deny_cid'] != '') || ($obj['deny_gid'] != ''))
4109 function compare_permissions($obj1,$obj2) {
4110 // first part is easy. Check that these are exactly the same.
4111 if(($obj1['allow_cid'] == $obj2['allow_cid'])
4112 && ($obj1['allow_gid'] == $obj2['allow_gid'])
4113 && ($obj1['deny_cid'] == $obj2['deny_cid'])
4114 && ($obj1['deny_gid'] == $obj2['deny_gid']))
4117 // This is harder. Parse all the permissions and compare the resulting set.
4119 $recipients1 = enumerate_permissions($obj1);
4120 $recipients2 = enumerate_permissions($obj2);
4123 if($recipients1 == $recipients2)
4128 // returns an array of contact-ids that are allowed to see this object
4130 function enumerate_permissions($obj) {
4131 require_once('include/group.php');
4132 $allow_people = expand_acl($obj['allow_cid']);
4133 $allow_groups = expand_groups(expand_acl($obj['allow_gid']));
4134 $deny_people = expand_acl($obj['deny_cid']);
4135 $deny_groups = expand_groups(expand_acl($obj['deny_gid']));
4136 $recipients = array_unique(array_merge($allow_people,$allow_groups));
4137 $deny = array_unique(array_merge($deny_people,$deny_groups));
4138 $recipients = array_diff($recipients,$deny);
4142 function item_getfeedtags($item) {
4145 $cnt = preg_match_all('|\#\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4147 for($x = 0; $x < $cnt; $x ++) {
4149 $ret[] = array('#',$matches[1][$x], $matches[2][$x]);
4153 $cnt = preg_match_all('|\@\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4155 for($x = 0; $x < $cnt; $x ++) {
4157 $ret[] = array('@',$matches[1][$x], $matches[2][$x]);
4163 function item_getfeedattach($item) {
4165 $arr = explode('[/attach],',$item['attach']);
4167 foreach($arr as $r) {
4169 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|',$r,$matches);
4171 $ret .= '<link rel="enclosure" href="' . xmlify($matches[1]) . '" type="' . xmlify($matches[3]) . '" ';
4172 if(intval($matches[2]))
4173 $ret .= 'length="' . intval($matches[2]) . '" ';
4174 if($matches[4] !== ' ')
4175 $ret .= 'title="' . xmlify(trim($matches[4])) . '" ';
4176 $ret .= ' />' . "\r\n";
4185 function item_expire($uid, $days, $network = "", $force = false) {
4187 if((! $uid) || ($days < 1))
4190 // $expire_network_only = save your own wall posts
4191 // and just expire conversations started by others
4193 $expire_network_only = get_pconfig($uid,'expire','network_only');
4194 $sql_extra = ((intval($expire_network_only)) ? " AND wall = 0 " : "");
4196 if ($network != "") {
4197 $sql_extra .= sprintf(" AND network = '%s' ", dbesc($network));
4198 // There is an index "uid_network_received" but not "uid_network_created"
4199 // This avoids the creation of another index just for one purpose.
4200 // And it doesn't really matter wether to look at "received" or "created"
4201 $range = "AND `received` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4203 $range = "AND `created` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4205 $r = q("SELECT * FROM `item`
4206 WHERE `uid` = %d $range
4217 $expire_items = get_pconfig($uid, 'expire','items');
4218 $expire_items = (($expire_items===false)?1:intval($expire_items)); // default if not set: 1
4220 // Forcing expiring of items - but not notes and marked items
4222 $expire_items = true;
4224 $expire_notes = get_pconfig($uid, 'expire','notes');
4225 $expire_notes = (($expire_notes===false)?1:intval($expire_notes)); // default if not set: 1
4227 $expire_starred = get_pconfig($uid, 'expire','starred');
4228 $expire_starred = (($expire_starred===false)?1:intval($expire_starred)); // default if not set: 1
4230 $expire_photos = get_pconfig($uid, 'expire','photos');
4231 $expire_photos = (($expire_photos===false)?0:intval($expire_photos)); // default if not set: 0
4233 logger('expire: # items=' . count($r). "; expire items: $expire_items, expire notes: $expire_notes, expire starred: $expire_starred, expire photos: $expire_photos");
4235 foreach($r as $item) {
4237 // don't expire filed items
4239 if(strpos($item['file'],'[') !== false)
4242 // Only expire posts, not photos and photo comments
4244 if($expire_photos==0 && strlen($item['resource-id']))
4246 if($expire_starred==0 && intval($item['starred']))
4248 if($expire_notes==0 && $item['type']=='note')
4250 if($expire_items==0 && $item['type']!='note')
4253 drop_item($item['id'],false);
4256 proc_run('php',"include/notifier.php","expire","$uid");
4261 function drop_items($items) {
4264 if(! local_user() && ! remote_user())
4268 foreach($items as $item) {
4269 $owner = drop_item($item,false);
4270 if($owner && ! $uid)
4275 // multiple threads may have been deleted, send an expire notification
4278 proc_run('php',"include/notifier.php","expire","$uid");
4282 function drop_item($id,$interactive = true) {
4286 // locate item to be deleted
4288 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
4295 notice( t('Item not found.') . EOL);
4296 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4301 $owner = $item['uid'];
4305 // check if logged in user is either the author or owner of this item
4307 if(is_array($_SESSION['remote'])) {
4308 foreach($_SESSION['remote'] as $visitor) {
4309 if($visitor['uid'] == $item['uid'] && $visitor['cid'] == $item['contact-id']) {
4310 $cid = $visitor['cid'];
4317 if((local_user() == $item['uid']) || ($cid) || (! $interactive)) {
4319 // Check if we should do HTML-based delete confirmation
4320 if($_REQUEST['confirm']) {
4321 // <form> can't take arguments in its "action" parameter
4322 // so add any arguments as hidden inputs
4323 $query = explode_querystring($a->query_string);
4325 foreach($query['args'] as $arg) {
4326 if(strpos($arg, 'confirm=') === false) {
4327 $arg_parts = explode('=', $arg);
4328 $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
4332 return replace_macros(get_markup_template('confirm.tpl'), array(
4334 '$message' => t('Do you really want to delete this item?'),
4335 '$extra_inputs' => $inputs,
4336 '$confirm' => t('Yes'),
4337 '$confirm_url' => $query['base'],
4338 '$confirm_name' => 'confirmed',
4339 '$cancel' => t('Cancel'),
4342 // Now check how the user responded to the confirmation query
4343 if($_REQUEST['canceled']) {
4344 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4347 logger('delete item: ' . $item['id'], LOGGER_DEBUG);
4350 $r = q("UPDATE `item` SET `deleted` = 1, `title` = '', `body` = '', `edited` = '%s', `changed` = '%s' WHERE `id` = %d",
4351 dbesc(datetime_convert()),
4352 dbesc(datetime_convert()),
4355 create_tags_from_item($item['id']);
4356 create_files_from_item($item['id']);
4357 delete_thread($item['id']);
4359 // clean up categories and tags so they don't end up as orphans
4362 $cnt = preg_match_all('/<(.*?)>/',$item['file'],$matches,PREG_SET_ORDER);
4364 foreach($matches as $mtch) {
4365 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],true);
4371 $cnt = preg_match_all('/\[(.*?)\]/',$item['file'],$matches,PREG_SET_ORDER);
4373 foreach($matches as $mtch) {
4374 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],false);
4378 // If item is a link to a photo resource, nuke all the associated photos
4379 // (visitors will not have photo resources)
4380 // This only applies to photos uploaded from the photos page. Photos inserted into a post do not
4381 // generate a resource-id and therefore aren't intimately linked to the item.
4383 if(strlen($item['resource-id'])) {
4384 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `uid` = %d ",
4385 dbesc($item['resource-id']),
4386 intval($item['uid'])
4388 // ignore the result
4391 // If item is a link to an event, nuke the event record.
4393 if(intval($item['event-id'])) {
4394 q("DELETE FROM `event` WHERE `id` = %d AND `uid` = %d",
4395 intval($item['event-id']),
4396 intval($item['uid'])
4398 // ignore the result
4401 // clean up item_id and sign meta-data tables
4404 // Old code - caused very long queries and warning entries in the mysql logfiles:
4406 $r = q("DELETE FROM item_id where iid in (select id from item where parent = %d and uid = %d)",
4407 intval($item['id']),
4408 intval($item['uid'])
4411 $r = q("DELETE FROM sign where iid in (select id from item where parent = %d and uid = %d)",
4412 intval($item['id']),
4413 intval($item['uid'])
4417 // The new code splits the queries since the mysql optimizer really has bad problems with subqueries
4419 // Creating list of parents
4420 $r = q("select id from item where parent = %d and uid = %d",
4421 intval($item['id']),
4422 intval($item['uid'])
4427 foreach ($r AS $row) {
4428 if ($parentid != "")
4431 $parentid .= $row["id"];
4435 if ($parentid != "") {
4436 $r = q("DELETE FROM item_id where iid in (%s)", dbesc($parentid));
4438 $r = q("DELETE FROM sign where iid in (%s)", dbesc($parentid));
4441 // If it's the parent of a comment thread, kill all the kids
4443 if($item['uri'] == $item['parent-uri']) {
4444 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = ''
4445 WHERE `parent-uri` = '%s' AND `uid` = %d ",
4446 dbesc(datetime_convert()),
4447 dbesc(datetime_convert()),
4448 dbesc($item['parent-uri']),
4449 intval($item['uid'])
4451 create_tags_from_item($item['parent-uri'], $item['uid']);
4452 create_files_from_item($item['parent-uri'], $item['uid']);
4453 delete_thread_uri($item['parent-uri'], $item['uid']);
4454 // ignore the result
4457 // ensure that last-child is set in case the comment that had it just got wiped.
4458 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
4459 dbesc(datetime_convert()),
4460 dbesc($item['parent-uri']),
4461 intval($item['uid'])
4463 // who is the last child now?
4464 $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",
4465 dbesc($item['parent-uri']),
4466 intval($item['uid'])
4469 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
4474 // Add a relayable_retraction signature for Diaspora.
4475 store_diaspora_retract_sig($item, $a->user, $a->get_baseurl());
4477 $drop_id = intval($item['id']);
4479 // send the notification upstream/downstream as the case may be
4481 proc_run('php',"include/notifier.php","drop","$drop_id");
4485 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4491 notice( t('Permission denied.') . EOL);
4492 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4499 function first_post_date($uid,$wall = false) {
4500 $r = q("select id, created from item
4501 where uid = %d and wall = %d and deleted = 0 and visible = 1 AND moderated = 0
4503 order by created asc limit 1",
4505 intval($wall ? 1 : 0)
4508 // logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA);
4509 return substr(datetime_convert('',date_default_timezone_get(),$r[0]['created']),0,10);
4514 function posted_dates($uid,$wall) {
4515 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
4517 $dthen = first_post_date($uid,$wall);
4521 // If it's near the end of a long month, backup to the 28th so that in
4522 // consecutive loops we'll always get a whole month difference.
4524 if(intval(substr($dnow,8)) > 28)
4525 $dnow = substr($dnow,0,8) . '28';
4526 if(intval(substr($dthen,8)) > 28)
4527 $dnow = substr($dthen,0,8) . '28';
4530 // Starting with the current month, get the first and last days of every
4531 // month down to and including the month of the first post
4532 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
4533 $dstart = substr($dnow,0,8) . '01';
4534 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
4535 $start_month = datetime_convert('','',$dstart,'Y-m-d');
4536 $end_month = datetime_convert('','',$dend,'Y-m-d');
4537 $str = day_translate(datetime_convert('','',$dnow,'F Y'));
4538 $ret[] = array($str,$end_month,$start_month);
4539 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
4545 function posted_date_widget($url,$uid,$wall) {
4548 if(! feature_enabled($uid,'archives'))
4551 // For former Facebook folks that left because of "timeline"
4553 /* if($wall && intval(get_pconfig($uid,'system','no_wall_archive_widget')))
4556 $ret = posted_dates($uid,$wall);
4560 $o = replace_macros(get_markup_template('posted_date_widget.tpl'),array(
4561 '$title' => t('Archives'),
4562 '$size' => ((count($ret) > 6) ? 6 : count($ret)),
4569 function store_diaspora_retract_sig($item, $user, $baseurl) {
4570 // Note that we can't add a target_author_signature
4571 // if the comment was deleted by a remote user. That should be ok, because if a remote user is deleting
4572 // the comment, that means we're the home of the post, and Diaspora will only
4573 // check the parent_author_signature of retractions that it doesn't have to relay further
4575 // I don't think this function gets called for an "unlike," but I'll check anyway
4577 $enabled = intval(get_config('system','diaspora_enabled'));
4579 logger('drop_item: diaspora support disabled, not storing retraction signature', LOGGER_DEBUG);
4583 logger('drop_item: storing diaspora retraction signature');
4585 $signed_text = $item['guid'] . ';' . ( ($item['verb'] === ACTIVITY_LIKE) ? 'Like' : 'Comment');
4587 if(local_user() == $item['uid']) {
4589 $handle = $user['nickname'] . '@' . substr($baseurl, strpos($baseurl,'://') + 3);
4590 $authorsig = base64_encode(rsa_sign($signed_text,$user['prvkey'],'sha256'));
4593 $r = q("SELECT `nick`, `url` FROM `contact` WHERE `id` = '%d' LIMIT 1",
4594 $item['contact-id'] // If this function gets called, drop_item() has already checked remote_user() == $item['contact-id']
4597 // The below handle only works for NETWORK_DFRN. I think that's ok, because this function
4598 // only handles DFRN deletes
4599 $handle_baseurl_start = strpos($r['url'],'://') + 3;
4600 $handle_baseurl_length = strpos($r['url'],'/profile') - $handle_baseurl_start;
4601 $handle = $r['nick'] . '@' . substr($r['url'], $handle_baseurl_start, $handle_baseurl_length);
4607 q("insert into sign (`retract_iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
4608 intval($item['id']),
4609 dbesc($signed_text),