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/'.$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/'.$u[0]['nickname'].'/'.$current_post,
1302 'link' => $a->get_baseurl().'/display/'.$arr['guid'],
1303 'source_name' => $item[0]['author-name'],
1304 'source_link' => $item[0]['author-link'],
1305 'source_photo' => $item[0]['author-avatar'],
1306 'verb' => ACTIVITY_TAG,
1309 logger('item_store: Notification sent for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1314 logger('item_store: could not locate created item');
1318 logger('item_store: duplicated post occurred. Removing duplicates.');
1319 q("DELETE FROM `item` WHERE `uri` = '%s' AND `uid` = %d AND `id` != %d ",
1321 intval($arr['uid']),
1322 intval($current_post)
1326 if((! $parent_id) || ($arr['parent-uri'] === $arr['uri']))
1327 $parent_id = $current_post;
1329 if(strlen($allow_cid) || strlen($allow_gid) || strlen($deny_cid) || strlen($deny_gid))
1332 $private = $arr['private'];
1334 // Set parent id - and also make sure to inherit the parent's ACLs.
1336 $r = q("UPDATE `item` SET `parent` = %d, `allow_cid` = '%s', `allow_gid` = '%s',
1337 `deny_cid` = '%s', `deny_gid` = '%s', `private` = %d, `deleted` = %d WHERE `id` = %d",
1344 intval($parent_deleted),
1345 intval($current_post)
1348 // Complete ostatus threads
1349 if ($ostatus_conversation)
1350 complete_conversation($current_post, $ostatus_conversation);
1352 $arr['id'] = $current_post;
1353 $arr['parent'] = $parent_id;
1354 $arr['allow_cid'] = $allow_cid;
1355 $arr['allow_gid'] = $allow_gid;
1356 $arr['deny_cid'] = $deny_cid;
1357 $arr['deny_gid'] = $deny_gid;
1358 $arr['private'] = $private;
1359 $arr['deleted'] = $parent_deleted;
1361 // update the commented timestamp on the parent
1363 q("UPDATE `item` set `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
1364 dbesc(datetime_convert()),
1365 dbesc(datetime_convert()),
1368 update_thread($parent_id);
1371 q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
1372 intval($current_post),
1373 dbesc($dsprsig->signed_text),
1374 dbesc($dsprsig->signature),
1375 dbesc($dsprsig->signer)
1381 * If this is now the last-child, force all _other_ children of this parent to *not* be last-child
1384 if($arr['last-child']) {
1385 $r = q("UPDATE `item` SET `last-child` = 0 WHERE `parent-uri` = '%s' AND `uid` = %d AND `id` != %d",
1387 intval($arr['uid']),
1388 intval($current_post)
1392 $deleted = tag_deliver($arr['uid'],$current_post);
1394 // current post can be deleted if is for a communuty page and no mention are
1398 // Store the fresh generated item into the cache
1399 $cachefile = get_cachefile($arr["guid"]."-".hash("md5", $arr['body']));
1401 if (($cachefile != '') AND !file_exists($cachefile)) {
1402 $s = prepare_text($arr['body']);
1404 $stamp1 = microtime(true);
1405 file_put_contents($cachefile, $s);
1406 $a->save_timestamp($stamp1, "file");
1407 logger('item_store: put item '.$current_post.' into cachefile '.$cachefile);
1410 $r = q('SELECT * FROM `item` WHERE id = %d', intval($current_post));
1411 if (count($r) == 1) {
1412 call_hooks('post_remote_end', $r[0]);
1414 logger('item_store: new item not found in DB, id ' . $current_post);
1418 create_tags_from_item($current_post);
1419 create_files_from_item($current_post);
1421 return $current_post;
1424 function get_item_guid($id) {
1425 $r = q("SELECT `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($id));
1427 return($r[0]["guid"]);
1432 function get_item_id($guid, $uid = 0) {
1438 $uid == local_user();
1440 // Does the given user have this item?
1442 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1443 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1444 AND `item`.`guid` = '%s' AND `item`.`uid` = %d", dbesc($guid), intval($uid));
1447 $nick = $r[0]["nickname"];
1451 // Or is it anywhere on the server?
1453 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1454 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1455 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = ''
1456 AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
1457 AND `item`.`private` = 0 AND `item`.`wall` = 1
1458 AND `item`.`guid` = '%s'", dbesc($guid));
1461 $nick = $r[0]["nickname"];
1464 return(array("nick" => $nick, "id" => $id));
1468 function get_item_contact($item,$contacts) {
1469 if(! count($contacts) || (! is_array($item)))
1471 foreach($contacts as $contact) {
1472 if($contact['id'] == $item['contact-id']) {
1474 break; // NOTREACHED
1481 * look for mention tags and setup a second delivery chain for forum/community posts if appropriate
1483 * @param int $item_id
1484 * @return bool true if item was deleted, else false
1486 function tag_deliver($uid,$item_id) {
1494 $u = q("select * from user where uid = %d limit 1",
1500 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1501 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1504 $i = q("select * from item where id = %d and uid = %d limit 1",
1513 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1515 // Diaspora uses their own hardwired link URL in @-tags
1516 // instead of the one we supply with webfinger
1518 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1520 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1522 foreach($matches as $mtch) {
1523 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1525 logger('tag_deliver: mention found: ' . $mtch[2]);
1531 if ( ($community_page || $prvgroup) &&
1532 (!$item['wall']) && (!$item['origin']) && ($item['id'] == $item['parent'])){
1533 // mmh.. no mention.. community page or private group... no wall.. no origin.. top-post (not a comment)
1535 logger("tag_deliver: no-mention top-level post to communuty or private group. delete.");
1536 q("DELETE FROM item WHERE id = %d and uid = %d",
1546 // send a notification
1548 // use a local photo if we have one
1550 $r = q("select * from contact where uid = %d and nurl = '%s' limit 1",
1551 intval($u[0]['uid']),
1552 dbesc(normalise_link($item['author-link']))
1554 $photo = (($r && count($r)) ? $r[0]['thumb'] : $item['author-avatar']);
1557 require_once('include/enotify.php');
1559 'type' => NOTIFY_TAGSELF,
1560 'notify_flags' => $u[0]['notify-flags'],
1561 'language' => $u[0]['language'],
1562 'to_name' => $u[0]['username'],
1563 'to_email' => $u[0]['email'],
1564 'uid' => $u[0]['uid'],
1566 //'link' => $a->get_baseurl() . '/display/' . $u[0]['nickname'] . '/' . $item['id'],
1567 'link' => $a->get_baseurl() . '/display/'.get_item_guid($item['id']),
1568 'source_name' => $item['author-name'],
1569 'source_link' => $item['author-link'],
1570 'source_photo' => $photo,
1571 'verb' => ACTIVITY_TAG,
1576 $arr = array('item' => $item, 'user' => $u[0], 'contact' => $r[0]);
1578 call_hooks('tagged', $arr);
1580 if((! $community_page) && (! $prvgroup))
1584 // tgroup delivery - setup a second delivery chain
1585 // prevent delivery looping - only proceed
1586 // if the message originated elsewhere and is a top-level post
1588 if(($item['wall']) || ($item['origin']) || ($item['id'] != $item['parent']))
1591 // now change this copy of the post to a forum head message and deliver to all the tgroup members
1594 $c = q("select name, url, thumb from contact where self = 1 and uid = %d limit 1",
1595 intval($u[0]['uid'])
1600 // also reset all the privacy bits to the forum default permissions
1602 $private = ($u[0]['allow_cid'] || $u[0]['allow_gid'] || $u[0]['deny_cid'] || $u[0]['deny_gid']) ? 1 : 0;
1604 $forum_mode = (($prvgroup) ? 2 : 1);
1606 q("update item set wall = 1, origin = 1, forum_mode = %d, `owner-name` = '%s', `owner-link` = '%s', `owner-avatar` = '%s',
1607 `private` = %d, `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s' where id = %d",
1608 intval($forum_mode),
1609 dbesc($c[0]['name']),
1610 dbesc($c[0]['url']),
1611 dbesc($c[0]['thumb']),
1613 dbesc($u[0]['allow_cid']),
1614 dbesc($u[0]['allow_gid']),
1615 dbesc($u[0]['deny_cid']),
1616 dbesc($u[0]['deny_gid']),
1619 update_thread($item_id);
1621 proc_run('php','include/notifier.php','tgroup',$item_id);
1627 function tgroup_check($uid,$item) {
1633 // check that the message originated elsewhere and is a top-level post
1635 if(($item['wall']) || ($item['origin']) || ($item['uri'] != $item['parent-uri']))
1639 $u = q("select * from user where uid = %d limit 1",
1645 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1646 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1649 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1651 // Diaspora uses their own hardwired link URL in @-tags
1652 // instead of the one we supply with webfinger
1654 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1656 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1658 foreach($matches as $mtch) {
1659 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1661 logger('tgroup_check: mention found: ' . $mtch[2]);
1669 if((! $community_page) && (! $prvgroup))
1683 function dfrn_deliver($owner,$contact,$atom, $dissolve = false) {
1687 $idtosend = $orig_id = (($contact['dfrn-id']) ? $contact['dfrn-id'] : $contact['issued-id']);
1689 if($contact['duplex'] && $contact['dfrn-id'])
1690 $idtosend = '0:' . $orig_id;
1691 if($contact['duplex'] && $contact['issued-id'])
1692 $idtosend = '1:' . $orig_id;
1694 $rino = ((function_exists('mcrypt_encrypt')) ? 1 : 0);
1696 $rino_enable = get_config('system','rino_encrypt');
1701 $ssl_val = intval(get_config('system','ssl_policy'));
1705 case SSL_POLICY_FULL:
1706 $ssl_policy = 'full';
1708 case SSL_POLICY_SELFSIGN:
1709 $ssl_policy = 'self';
1711 case SSL_POLICY_NONE:
1713 $ssl_policy = 'none';
1717 $url = $contact['notify'] . '&dfrn_id=' . $idtosend . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . (($rino) ? '&rino=1' : '');
1719 logger('dfrn_deliver: ' . $url);
1721 $xml = fetch_url($url);
1723 $curl_stat = $a->get_curl_code();
1725 return(-1); // timed out
1727 logger('dfrn_deliver: ' . $xml, LOGGER_DATA);
1732 if(strpos($xml,'<?xml') === false) {
1733 logger('dfrn_deliver: no valid XML returned');
1734 logger('dfrn_deliver: returned XML: ' . $xml, LOGGER_DATA);
1738 $res = parse_xml_string($xml);
1740 if((intval($res->status) != 0) || (! strlen($res->challenge)) || (! strlen($res->dfrn_id)))
1741 return (($res->status) ? $res->status : 3);
1743 $postvars = array();
1744 $sent_dfrn_id = hex2bin((string) $res->dfrn_id);
1745 $challenge = hex2bin((string) $res->challenge);
1746 $perm = (($res->perm) ? $res->perm : null);
1747 $dfrn_version = (float) (($res->dfrn_version) ? $res->dfrn_version : 2.0);
1748 $rino_allowed = ((intval($res->rino) === 1) ? 1 : 0);
1749 $page = (($owner['page-flags'] == PAGE_COMMUNITY) ? 1 : 0);
1751 if($owner['page-flags'] == PAGE_PRVGROUP)
1754 $final_dfrn_id = '';
1757 if((($perm == 'rw') && (! intval($contact['writable'])))
1758 || (($perm == 'r') && (intval($contact['writable'])))) {
1759 q("update contact set writable = %d where id = %d",
1760 intval(($perm == 'rw') ? 1 : 0),
1761 intval($contact['id'])
1763 $contact['writable'] = (string) 1 - intval($contact['writable']);
1767 if(($contact['duplex'] && strlen($contact['pubkey']))
1768 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1769 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1770 openssl_public_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['pubkey']);
1771 openssl_public_decrypt($challenge,$postvars['challenge'],$contact['pubkey']);
1774 openssl_private_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['prvkey']);
1775 openssl_private_decrypt($challenge,$postvars['challenge'],$contact['prvkey']);
1778 $final_dfrn_id = substr($final_dfrn_id, 0, strpos($final_dfrn_id, '.'));
1780 if(strpos($final_dfrn_id,':') == 1)
1781 $final_dfrn_id = substr($final_dfrn_id,2);
1783 if($final_dfrn_id != $orig_id) {
1784 logger('dfrn_deliver: wrong dfrn_id.');
1785 // did not decode properly - cannot trust this site
1789 $postvars['dfrn_id'] = $idtosend;
1790 $postvars['dfrn_version'] = DFRN_PROTOCOL_VERSION;
1792 $postvars['dissolve'] = '1';
1795 if((($contact['rel']) && ($contact['rel'] != CONTACT_IS_SHARING) && (! $contact['blocked'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
1796 $postvars['data'] = $atom;
1797 $postvars['perm'] = 'rw';
1800 $postvars['data'] = str_replace('<dfrn:comment-allow>1','<dfrn:comment-allow>0',$atom);
1801 $postvars['perm'] = 'r';
1804 $postvars['ssl_policy'] = $ssl_policy;
1807 $postvars['page'] = $page;
1809 if($rino && $rino_allowed && (! $dissolve)) {
1810 $key = substr(random_string(),0,16);
1811 $data = bin2hex(aes_encrypt($postvars['data'],$key));
1812 $postvars['data'] = $data;
1813 logger('rino: sent key = ' . $key, LOGGER_DEBUG);
1816 if($dfrn_version >= 2.1) {
1817 if(($contact['duplex'] && strlen($contact['pubkey']))
1818 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
1819 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
1821 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
1824 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
1828 if(($contact['duplex'] && strlen($contact['prvkey'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
1829 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
1832 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
1836 logger('md5 rawkey ' . md5($postvars['key']));
1838 $postvars['key'] = bin2hex($postvars['key']);
1841 logger('dfrn_deliver: ' . "SENDING: " . print_r($postvars,true), LOGGER_DATA);
1843 $xml = post_url($contact['notify'],$postvars);
1845 logger('dfrn_deliver: ' . "RECEIVED: " . $xml, LOGGER_DATA);
1847 $curl_stat = $a->get_curl_code();
1848 if((! $curl_stat) || (! strlen($xml)))
1849 return(-1); // timed out
1851 if(($curl_stat == 503) && (stristr($a->get_curl_headers(),'retry-after')))
1854 if(strpos($xml,'<?xml') === false) {
1855 logger('dfrn_deliver: phase 2: no valid XML returned');
1856 logger('dfrn_deliver: phase 2: returned XML: ' . $xml, LOGGER_DATA);
1860 if($contact['term-date'] != '0000-00-00 00:00:00') {
1861 logger("dfrn_deliver: $url back from the dead - removing mark for death");
1862 require_once('include/Contact.php');
1863 unmark_for_death($contact);
1866 $res = parse_xml_string($xml);
1868 return $res->status;
1873 This function returns true if $update has an edited timestamp newer
1874 than $existing, i.e. $update contains new data which should override
1875 what's already there. If there is no timestamp yet, the update is
1876 assumed to be newer. If the update has no timestamp, the existing
1877 item is assumed to be up-to-date. If the timestamps are equal it
1878 assumes the update has been seen before and should be ignored.
1880 function edited_timestamp_is_newer($existing, $update) {
1881 if (!x($existing,'edited') || !$existing['edited']) {
1884 if (!x($update,'edited') || !$update['edited']) {
1887 $existing_edited = datetime_convert('UTC', 'UTC', $existing['edited']);
1888 $update_edited = datetime_convert('UTC', 'UTC', $update['edited']);
1889 return (strcmp($existing_edited, $update_edited) < 0);
1894 * consume_feed - process atom feed and update anything/everything we might need to update
1896 * $xml = the (atom) feed to consume - RSS isn't as fully supported but may work for simple feeds.
1898 * $importer = the contact_record (joined to user_record) of the local user who owns this relationship.
1899 * It is this person's stuff that is going to be updated.
1900 * $contact = the person who is sending us stuff. If not set, we MAY be processing a "follow" activity
1901 * from an external network and MAY create an appropriate contact record. Otherwise, we MUST
1902 * have a contact record.
1903 * $hub = should we find a hub declation in the feed, pass it back to our calling process, who might (or
1904 * might not) try and subscribe to it.
1905 * $datedir sorts in reverse order
1906 * $pass - by default ($pass = 0) we cannot guarantee that a parent item has been
1907 * imported prior to its children being seen in the stream unless we are certain
1908 * of how the feed is arranged/ordered.
1909 * With $pass = 1, we only pull parent items out of the stream.
1910 * With $pass = 2, we only pull children (comments/likes).
1912 * So running this twice, first with pass 1 and then with pass 2 will do the right
1913 * thing regardless of feed ordering. This won't be adequate in a fully-threaded
1914 * model where comments can have sub-threads. That would require some massive sorting
1915 * to get all the feed items into a mostly linear ordering, and might still require
1919 function consume_feed($xml,$importer,&$contact, &$hub, $datedir = 0, $pass = 0) {
1921 require_once('library/simplepie/simplepie.inc');
1923 if(! strlen($xml)) {
1924 logger('consume_feed: empty input');
1928 $feed = new SimplePie();
1929 $feed->set_raw_data($xml);
1931 $feed->enable_order_by_date(true);
1933 $feed->enable_order_by_date(false);
1937 logger('consume_feed: Error parsing XML: ' . $feed->error());
1939 $permalink = $feed->get_permalink();
1941 // Check at the feed level for updated contact name and/or photo
1945 $photo_timestamp = '';
1949 $hubs = $feed->get_links('hub');
1950 logger('consume_feed: hubs: ' . print_r($hubs,true), LOGGER_DATA);
1953 $hub = implode(',', $hubs);
1955 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
1957 $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
1959 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
1960 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
1961 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
1962 $new_name = $elems['name'][0]['data'];
1964 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
1965 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
1966 $photo_url = $elems['link'][0]['attribs']['']['href'];
1969 if((x($rawtags[0]['child'], NAMESPACE_DFRN)) && (x($rawtags[0]['child'][NAMESPACE_DFRN],'birthday'))) {
1970 $birthday = datetime_convert('UTC','UTC', $rawtags[0]['child'][NAMESPACE_DFRN]['birthday'][0]['data']);
1974 if((is_array($contact)) && ($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $contact['avatar-date'])) {
1975 logger('consume_feed: Updating photo for ' . $contact['name']);
1976 require_once("include/Photo.php");
1977 $photo_failure = false;
1978 $have_photo = false;
1980 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
1981 intval($contact['id']),
1982 intval($contact['uid'])
1985 $resource_id = $r[0]['resource-id'];
1989 $resource_id = photo_new_resource();
1992 $img_str = fetch_url($photo_url,true);
1993 // guess mimetype from headers or filename
1994 $type = guess_image_type($photo_url,true);
1997 $img = new Photo($img_str, $type);
1998 if($img->is_valid()) {
2000 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2001 dbesc($resource_id),
2002 intval($contact['id']),
2003 intval($contact['uid'])
2007 $img->scaleImageSquare(175);
2009 $hash = $resource_id;
2010 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2012 $img->scaleImage(80);
2013 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2015 $img->scaleImage(48);
2016 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2020 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2021 WHERE `uid` = %d AND `id` = %d",
2022 dbesc(datetime_convert()),
2023 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2024 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2025 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2026 intval($contact['uid']),
2027 intval($contact['id'])
2032 if((is_array($contact)) && ($name_updated) && (strlen($new_name)) && ($name_updated > $contact['name-date'])) {
2033 $r = q("select * from contact where uid = %d and id = %d limit 1",
2034 intval($contact['uid']),
2035 intval($contact['id'])
2038 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2039 dbesc(notags(trim($new_name))),
2040 dbesc(datetime_convert()),
2041 intval($contact['uid']),
2042 intval($contact['id'])
2045 // do our best to update the name on content items
2048 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2049 dbesc(notags(trim($new_name))),
2050 dbesc($r[0]['name']),
2051 dbesc($r[0]['url']),
2052 intval($contact['uid'])
2057 if(strlen($birthday)) {
2058 if(substr($birthday,0,4) != $contact['bdyear']) {
2059 logger('consume_feed: updating birthday: ' . $birthday);
2063 * Add new birthday event for this person
2065 * $bdtext is just a readable placeholder in case the event is shared
2066 * with others. We will replace it during presentation to our $importer
2067 * to contain a sparkle link and perhaps a photo.
2071 $bdtext = sprintf( t('%s\'s birthday'), $contact['name']);
2072 $bdtext2 = sprintf( t('Happy Birthday %s'), ' [url=' . $contact['url'] . ']' . $contact['name'] . '[/url]' ) ;
2075 $r = q("INSERT INTO `event` (`uid`,`cid`,`created`,`edited`,`start`,`finish`,`summary`,`desc`,`type`)
2076 VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) ",
2077 intval($contact['uid']),
2078 intval($contact['id']),
2079 dbesc(datetime_convert()),
2080 dbesc(datetime_convert()),
2081 dbesc(datetime_convert('UTC','UTC', $birthday)),
2082 dbesc(datetime_convert('UTC','UTC', $birthday . ' + 1 day ')),
2091 q("UPDATE `contact` SET `bdyear` = '%s' WHERE `uid` = %d AND `id` = %d",
2092 dbesc(substr($birthday,0,4)),
2093 intval($contact['uid']),
2094 intval($contact['id'])
2097 // This function is called twice without reloading the contact
2098 // Make sure we only create one event. This is why &$contact
2099 // is a reference var in this function
2101 $contact['bdyear'] = substr($birthday,0,4);
2106 $community_page = 0;
2107 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2109 $community_page = intval($rawtags[0]['data']);
2111 if(is_array($contact) && intval($contact['forum']) != $community_page) {
2112 q("update contact set forum = %d where id = %d",
2113 intval($community_page),
2114 intval($contact['id'])
2116 $contact['forum'] = (string) $community_page;
2120 // process any deleted entries
2122 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2123 if(is_array($del_entries) && count($del_entries) && $pass != 2) {
2124 foreach($del_entries as $dentry) {
2126 if(isset($dentry['attribs']['']['ref'])) {
2127 $uri = $dentry['attribs']['']['ref'];
2129 if(isset($dentry['attribs']['']['when'])) {
2130 $when = $dentry['attribs']['']['when'];
2131 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2134 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2136 if($deleted && is_array($contact)) {
2137 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN `contact` on `item`.`contact-id` = `contact`.`id`
2138 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
2140 intval($importer['uid']),
2141 intval($contact['id'])
2146 if(! $item['deleted'])
2147 logger('consume_feed: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
2149 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2150 $xo = parse_xml_string($item['object'],false);
2151 $xt = parse_xml_string($item['target'],false);
2152 if($xt->type === ACTIVITY_OBJ_NOTE) {
2153 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
2155 intval($importer['importer_uid'])
2159 // For tags, the owner cannot remove the tag on the author's copy of the post.
2161 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
2162 $author_remove = (($item['origin'] && $item['self']) ? true : false);
2163 $author_copy = (($item['origin']) ? true : false);
2165 if($owner_remove && $author_copy)
2167 if($author_remove || $owner_remove) {
2168 $tags = explode(',',$i[0]['tag']);
2171 foreach($tags as $tag)
2172 if(trim($tag) !== trim($xo->body))
2173 $newtags[] = trim($tag);
2175 q("update item set tag = '%s' where id = %d",
2176 dbesc(implode(',',$newtags)),
2179 create_tags_from_item($i[0]['id']);
2185 if($item['uri'] == $item['parent-uri']) {
2186 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2187 `body` = '', `title` = ''
2188 WHERE `parent-uri` = '%s' AND `uid` = %d",
2190 dbesc(datetime_convert()),
2191 dbesc($item['uri']),
2192 intval($importer['uid'])
2194 create_tags_from_itemuri($item['uri'], $importer['uid']);
2195 create_files_from_itemuri($item['uri'], $importer['uid']);
2196 update_thread_uri($item['uri'], $importer['uid']);
2199 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2200 `body` = '', `title` = ''
2201 WHERE `uri` = '%s' AND `uid` = %d",
2203 dbesc(datetime_convert()),
2205 intval($importer['uid'])
2207 create_tags_from_itemuri($uri, $importer['uid']);
2208 create_files_from_itemuri($uri, $importer['uid']);
2209 if($item['last-child']) {
2210 // ensure that last-child is set in case the comment that had it just got wiped.
2211 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
2212 dbesc(datetime_convert()),
2213 dbesc($item['parent-uri']),
2214 intval($item['uid'])
2216 // who is the last child now?
2217 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `moderated` = 0 AND `uid` = %d
2218 ORDER BY `created` DESC LIMIT 1",
2219 dbesc($item['parent-uri']),
2220 intval($importer['uid'])
2223 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
2234 // Now process the feed
2236 if($feed->get_item_quantity()) {
2238 logger('consume_feed: feed item count = ' . $feed->get_item_quantity());
2240 // in inverse date order
2242 $items = array_reverse($feed->get_items());
2244 $items = $feed->get_items();
2247 foreach($items as $item) {
2250 $item_id = $item->get_id();
2251 $rawthread = $item->get_item_tags( NAMESPACE_THREAD,'in-reply-to');
2252 if(isset($rawthread[0]['attribs']['']['ref'])) {
2254 $parent_uri = $rawthread[0]['attribs']['']['ref'];
2257 if(($is_reply) && is_array($contact)) {
2262 // not allowed to post
2264 if($contact['rel'] == CONTACT_IS_FOLLOWER)
2268 // Have we seen it? If not, import it.
2270 $item_id = $item->get_id();
2271 $datarray = get_atom_elements($feed, $item, $contact);
2273 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2274 $datarray['author-name'] = $contact['name'];
2275 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2276 $datarray['author-link'] = $contact['url'];
2277 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2278 $datarray['author-avatar'] = $contact['thumb'];
2280 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2281 logger('consume_feed: no author information! ' . print_r($datarray,true));
2285 $force_parent = false;
2286 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2287 if($contact['network'] === NETWORK_OSTATUS)
2288 $force_parent = true;
2289 if(strlen($datarray['title']))
2290 unset($datarray['title']);
2291 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2292 dbesc(datetime_convert()),
2294 intval($importer['uid'])
2296 $datarray['last-child'] = 1;
2297 update_thread_uri($parent_uri, $importer['uid']);
2301 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2303 intval($importer['uid'])
2306 // Update content if 'updated' changes
2309 if (edited_timestamp_is_newer($r[0], $datarray)) {
2311 // do not accept (ignore) an earlier edit than one we currently have.
2312 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2315 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2316 dbesc($datarray['title']),
2317 dbesc($datarray['body']),
2318 dbesc($datarray['tag']),
2319 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2320 dbesc(datetime_convert()),
2322 intval($importer['uid'])
2324 create_tags_from_itemuri($item_id, $importer['uid']);
2325 update_thread_uri($item_id, $importer['uid']);
2328 // update last-child if it changes
2330 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2331 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
2332 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2333 dbesc(datetime_convert()),
2335 intval($importer['uid'])
2337 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2338 intval($allow[0]['data']),
2339 dbesc(datetime_convert()),
2341 intval($importer['uid'])
2343 update_thread_uri($item_id, $importer['uid']);
2349 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2350 // one way feed - no remote comment ability
2351 $datarray['last-child'] = 0;
2353 $datarray['parent-uri'] = $parent_uri;
2354 $datarray['uid'] = $importer['uid'];
2355 $datarray['contact-id'] = $contact['id'];
2356 if((activity_match($datarray['verb'],ACTIVITY_LIKE)) || (activity_match($datarray['verb'],ACTIVITY_DISLIKE))) {
2357 $datarray['type'] = 'activity';
2358 $datarray['gravity'] = GRAVITY_LIKE;
2359 // only one like or dislike per person
2360 // splitted into two queries for performance issues
2361 $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",
2362 intval($datarray['uid']),
2363 intval($datarray['contact-id']),
2364 dbesc($datarray['verb']),
2370 $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",
2371 intval($datarray['uid']),
2372 intval($datarray['contact-id']),
2373 dbesc($datarray['verb']),
2380 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2381 $xo = parse_xml_string($datarray['object'],false);
2382 $xt = parse_xml_string($datarray['target'],false);
2384 if($xt->type == ACTIVITY_OBJ_NOTE) {
2385 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
2387 intval($importer['importer_uid'])
2392 // extract tag, if not duplicate, add to parent item
2393 if($xo->id && $xo->content) {
2394 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
2395 if(! (stristr($r[0]['tag'],$newtag))) {
2396 q("UPDATE item SET tag = '%s' WHERE id = %d",
2397 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . $newtag),
2400 create_tags_from_item($r[0]['id']);
2406 $r = item_store($datarray,$force_parent);
2412 // Head post of a conversation. Have we seen it? If not, import it.
2414 $item_id = $item->get_id();
2416 $datarray = get_atom_elements($feed, $item, $contact);
2418 if(is_array($contact)) {
2419 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2420 $datarray['author-name'] = $contact['name'];
2421 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2422 $datarray['author-link'] = $contact['url'];
2423 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2424 $datarray['author-avatar'] = $contact['thumb'];
2427 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2428 logger('consume_feed: no author information! ' . print_r($datarray,true));
2432 // special handling for events
2434 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
2435 $ev = bbtoevent($datarray['body']);
2436 if(x($ev,'desc') && x($ev,'start')) {
2437 $ev['uid'] = $importer['uid'];
2438 $ev['uri'] = $item_id;
2439 $ev['edited'] = $datarray['edited'];
2440 $ev['private'] = $datarray['private'];
2442 if(is_array($contact))
2443 $ev['cid'] = $contact['id'];
2444 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2446 intval($importer['uid'])
2449 $ev['id'] = $r[0]['id'];
2450 $xyz = event_store($ev);
2455 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2456 if(strlen($datarray['title']))
2457 unset($datarray['title']);
2458 $datarray['last-child'] = 1;
2462 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2464 intval($importer['uid'])
2467 // Update content if 'updated' changes
2470 if (edited_timestamp_is_newer($r[0], $datarray)) {
2472 // do not accept (ignore) an earlier edit than one we currently have.
2473 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2476 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2477 dbesc($datarray['title']),
2478 dbesc($datarray['body']),
2479 dbesc($datarray['tag']),
2480 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2481 dbesc(datetime_convert()),
2483 intval($importer['uid'])
2485 create_tags_from_itemuri($item_id, $importer['uid']);
2486 update_thread_uri($item_id, $importer['uid']);
2489 // update last-child if it changes
2491 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2492 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
2493 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2494 intval($allow[0]['data']),
2495 dbesc(datetime_convert()),
2497 intval($importer['uid'])
2499 update_thread_uri($item_id, $importer['uid']);
2504 if(activity_match($datarray['verb'],ACTIVITY_FOLLOW)) {
2505 logger('consume-feed: New follower');
2506 new_follower($importer,$contact,$datarray,$item);
2509 if(activity_match($datarray['verb'],ACTIVITY_UNFOLLOW)) {
2510 lose_follower($importer,$contact,$datarray,$item);
2514 if(activity_match($datarray['verb'],ACTIVITY_REQ_FRIEND)) {
2515 logger('consume-feed: New friend request');
2516 new_follower($importer,$contact,$datarray,$item,true);
2519 if(activity_match($datarray['verb'],ACTIVITY_UNFRIEND)) {
2520 lose_sharer($importer,$contact,$datarray,$item);
2525 if(! is_array($contact))
2529 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2530 // one way feed - no remote comment ability
2531 $datarray['last-child'] = 0;
2533 if($contact['network'] === NETWORK_FEED)
2534 $datarray['private'] = 2;
2536 // This is my contact on another system, but it's really me.
2537 // Turn this into a wall post.
2539 if($contact['remote_self']) {
2540 $datarray['wall'] = 1;
2541 if($contact['network'] === NETWORK_FEED) {
2542 $datarray['private'] = 0;
2546 $datarray['parent-uri'] = $item_id;
2547 $datarray['uid'] = $importer['uid'];
2548 $datarray['contact-id'] = $contact['id'];
2550 if(! link_compare($datarray['owner-link'],$contact['url'])) {
2551 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
2552 // but otherwise there's a possible data mixup on the sender's system.
2553 // the tgroup delivery code called from item_store will correct it if it's a forum,
2554 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
2555 logger('consume_feed: Correcting item owner.', LOGGER_DEBUG);
2556 $datarray['owner-name'] = $contact['name'];
2557 $datarray['owner-link'] = $contact['url'];
2558 $datarray['owner-avatar'] = $contact['thumb'];
2561 // We've allowed "followers" to reach this point so we can decide if they are
2562 // posting an @-tag delivery, which followers are allowed to do for certain
2563 // page types. Now that we've parsed the post, let's check if it is legit. Otherwise ignore it.
2565 if(($contact['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['uid'],$datarray)))
2569 $r = item_store($datarray);
2577 function local_delivery($importer,$data) {
2580 logger(__function__, LOGGER_TRACE);
2582 if($importer['readonly']) {
2583 // We aren't receiving stuff from this person. But we will quietly ignore them
2584 // rather than a blatant "go away" message.
2585 logger('local_delivery: ignoring');
2590 // Consume notification feed. This may differ from consuming a public feed in several ways
2591 // - might contain email or friend suggestions
2592 // - might contain remote followup to our message
2593 // - in which case we need to accept it and then notify other conversants
2594 // - we may need to send various email notifications
2596 $feed = new SimplePie();
2597 $feed->set_raw_data($data);
2598 $feed->enable_order_by_date(false);
2603 logger('local_delivery: Error parsing XML: ' . $feed->error());
2606 // Check at the feed level for updated contact name and/or photo
2610 $photo_timestamp = '';
2614 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2616 // Fallback should not be needed here. If it isn't DFRN it won't have DFRN updated tags
2618 // $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2621 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2622 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2623 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2624 $new_name = $elems['name'][0]['data'];
2626 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2627 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2628 $photo_url = $elems['link'][0]['attribs']['']['href'];
2632 if(($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $importer['avatar-date'])) {
2633 logger('local_delivery: Updating photo for ' . $importer['name']);
2634 require_once("include/Photo.php");
2635 $photo_failure = false;
2636 $have_photo = false;
2638 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2639 intval($importer['id']),
2640 intval($importer['importer_uid'])
2643 $resource_id = $r[0]['resource-id'];
2647 $resource_id = photo_new_resource();
2650 $img_str = fetch_url($photo_url,true);
2651 // guess mimetype from headers or filename
2652 $type = guess_image_type($photo_url,true);
2655 $img = new Photo($img_str, $type);
2656 if($img->is_valid()) {
2658 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2659 dbesc($resource_id),
2660 intval($importer['id']),
2661 intval($importer['importer_uid'])
2665 $img->scaleImageSquare(175);
2667 $hash = $resource_id;
2668 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2670 $img->scaleImage(80);
2671 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2673 $img->scaleImage(48);
2674 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2678 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2679 WHERE `uid` = %d AND `id` = %d",
2680 dbesc(datetime_convert()),
2681 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2682 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2683 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2684 intval($importer['importer_uid']),
2685 intval($importer['id'])
2690 if(($name_updated) && (strlen($new_name)) && ($name_updated > $importer['name-date'])) {
2691 $r = q("select * from contact where uid = %d and id = %d limit 1",
2692 intval($importer['importer_uid']),
2693 intval($importer['id'])
2696 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2697 dbesc(notags(trim($new_name))),
2698 dbesc(datetime_convert()),
2699 intval($importer['importer_uid']),
2700 intval($importer['id'])
2703 // do our best to update the name on content items
2706 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2707 dbesc(notags(trim($new_name))),
2708 dbesc($r[0]['name']),
2709 dbesc($r[0]['url']),
2710 intval($importer['importer_uid'])
2717 // Currently unsupported - needs a lot of work
2718 $reloc = $feed->get_feed_tags( NAMESPACE_DFRN, 'relocate' );
2719 if(isset($reloc[0]['child'][NAMESPACE_DFRN])) {
2720 $base = $reloc[0]['child'][NAMESPACE_DFRN];
2722 $newloc['uid'] = $importer['importer_uid'];
2723 $newloc['cid'] = $importer['id'];
2724 $newloc['name'] = notags(unxmlify($base['name'][0]['data']));
2725 $newloc['photo'] = notags(unxmlify($base['photo'][0]['data']));
2726 $newloc['thumb'] = notags(unxmlify($base['thumb'][0]['data']));
2727 $newloc['micro'] = notags(unxmlify($base['micro'][0]['data']));
2728 $newloc['url'] = notags(unxmlify($base['url'][0]['data']));
2729 $newloc['request'] = notags(unxmlify($base['request'][0]['data']));
2730 $newloc['confirm'] = notags(unxmlify($base['confirm'][0]['data']));
2731 $newloc['notify'] = notags(unxmlify($base['notify'][0]['data']));
2732 $newloc['poll'] = notags(unxmlify($base['poll'][0]['data']));
2733 $newloc['sitepubkey'] = notags(unxmlify($base['sitepubkey'][0]['data']));
2734 /** relocated user must have original key pair */
2735 /*$newloc['pubkey'] = notags(unxmlify($base['pubkey'][0]['data']));
2736 $newloc['prvkey'] = notags(unxmlify($base['prvkey'][0]['data']));*/
2738 logger("items:relocate contact ".print_r($newloc, true).print_r($importer, true), LOGGER_DEBUG);
2741 $r = q("SELECT photo, url FROM contact WHERE id=%d AND uid=%d;",
2742 intval($importer['id']),
2743 intval($importer['importer_uid']));
2748 $x = q("UPDATE contact SET
2758 `site-pubkey` = '%s'
2759 WHERE id=%d AND uid=%d;",
2760 dbesc($newloc['name']),
2761 dbesc($newloc['photo']),
2762 dbesc($newloc['thumb']),
2763 dbesc($newloc['micro']),
2764 dbesc($newloc['url']),
2765 dbesc($newloc['request']),
2766 dbesc($newloc['confirm']),
2767 dbesc($newloc['notify']),
2768 dbesc($newloc['poll']),
2769 dbesc($newloc['sitepubkey']),
2770 intval($importer['id']),
2771 intval($importer['importer_uid']));
2777 'owner-link' => array($old['url'], $newloc['url']),
2778 'author-link' => array($old['url'], $newloc['url']),
2779 'owner-avatar' => array($old['photo'], $newloc['photo']),
2780 'author-avatar' => array($old['photo'], $newloc['photo']),
2782 foreach ($fields as $n=>$f){
2783 $x = q("UPDATE `item` SET `%s`='%s' WHERE `%s`='%s' AND uid=%d",
2786 intval($importer['importer_uid']));
2792 // merge with current record, current contents have priority
2793 // update record, set url-updated
2794 // update profile photos
2800 // handle friend suggestion notification
2802 $sugg = $feed->get_feed_tags( NAMESPACE_DFRN, 'suggest' );
2803 if(isset($sugg[0]['child'][NAMESPACE_DFRN])) {
2804 $base = $sugg[0]['child'][NAMESPACE_DFRN];
2806 $fsugg['uid'] = $importer['importer_uid'];
2807 $fsugg['cid'] = $importer['id'];
2808 $fsugg['name'] = notags(unxmlify($base['name'][0]['data']));
2809 $fsugg['photo'] = notags(unxmlify($base['photo'][0]['data']));
2810 $fsugg['url'] = notags(unxmlify($base['url'][0]['data']));
2811 $fsugg['request'] = notags(unxmlify($base['request'][0]['data']));
2812 $fsugg['body'] = escape_tags(unxmlify($base['note'][0]['data']));
2814 // Does our member already have a friend matching this description?
2816 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `nurl` = '%s' AND `uid` = %d LIMIT 1",
2817 dbesc($fsugg['name']),
2818 dbesc(normalise_link($fsugg['url'])),
2819 intval($fsugg['uid'])
2824 // Do we already have an fcontact record for this person?
2827 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
2828 dbesc($fsugg['url']),
2829 dbesc($fsugg['name']),
2830 dbesc($fsugg['request'])
2835 // OK, we do. Do we already have an introduction for this person ?
2836 $r = q("select id from intro where uid = %d and fid = %d limit 1",
2837 intval($fsugg['uid']),
2844 $r = q("INSERT INTO `fcontact` ( `name`,`url`,`photo`,`request` ) VALUES ( '%s', '%s', '%s', '%s' ) ",
2845 dbesc($fsugg['name']),
2846 dbesc($fsugg['url']),
2847 dbesc($fsugg['photo']),
2848 dbesc($fsugg['request'])
2850 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
2851 dbesc($fsugg['url']),
2852 dbesc($fsugg['name']),
2853 dbesc($fsugg['request'])
2858 // database record did not get created. Quietly give up.
2863 $hash = random_string();
2865 $r = q("INSERT INTO `intro` ( `uid`, `fid`, `contact-id`, `note`, `hash`, `datetime`, `blocked` )
2866 VALUES( %d, %d, %d, '%s', '%s', '%s', %d )",
2867 intval($fsugg['uid']),
2869 intval($fsugg['cid']),
2870 dbesc($fsugg['body']),
2872 dbesc(datetime_convert()),
2877 'type' => NOTIFY_SUGGEST,
2878 'notify_flags' => $importer['notify-flags'],
2879 'language' => $importer['language'],
2880 'to_name' => $importer['username'],
2881 'to_email' => $importer['email'],
2882 'uid' => $importer['importer_uid'],
2884 'link' => $a->get_baseurl() . '/notifications/intros',
2885 'source_name' => $importer['name'],
2886 'source_link' => $importer['url'],
2887 'source_photo' => $importer['photo'],
2888 'verb' => ACTIVITY_REQ_FRIEND,
2897 $rawmail = $feed->get_feed_tags( NAMESPACE_DFRN, 'mail' );
2898 if(isset($rawmail[0]['child'][NAMESPACE_DFRN])) {
2900 logger('local_delivery: private message received');
2903 $base = $rawmail[0]['child'][NAMESPACE_DFRN];
2906 $msg['uid'] = $importer['importer_uid'];
2907 $msg['from-name'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['name'][0]['data']));
2908 $msg['from-photo'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['avatar'][0]['data']));
2909 $msg['from-url'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['uri'][0]['data']));
2910 $msg['contact-id'] = $importer['id'];
2911 $msg['title'] = notags(unxmlify($base['subject'][0]['data']));
2912 $msg['body'] = escape_tags(unxmlify($base['content'][0]['data']));
2914 $msg['replied'] = 0;
2915 $msg['uri'] = notags(unxmlify($base['id'][0]['data']));
2916 $msg['parent-uri'] = notags(unxmlify($base['in-reply-to'][0]['data']));
2917 $msg['created'] = datetime_convert(notags(unxmlify('UTC','UTC',$base['sentdate'][0]['data'])));
2921 $r = dbq("INSERT INTO `mail` (`" . implode("`, `", array_keys($msg))
2922 . "`) VALUES ('" . implode("', '", array_values($msg)) . "')" );
2924 // send notifications.
2926 require_once('include/enotify.php');
2928 $notif_params = array(
2929 'type' => NOTIFY_MAIL,
2930 'notify_flags' => $importer['notify-flags'],
2931 'language' => $importer['language'],
2932 'to_name' => $importer['username'],
2933 'to_email' => $importer['email'],
2934 'uid' => $importer['importer_uid'],
2936 'source_name' => $msg['from-name'],
2937 'source_link' => $importer['url'],
2938 'source_photo' => $importer['thumb'],
2939 'verb' => ACTIVITY_POST,
2943 notification($notif_params);
2949 $community_page = 0;
2950 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2952 $community_page = intval($rawtags[0]['data']);
2954 if(intval($importer['forum']) != $community_page) {
2955 q("update contact set forum = %d where id = %d",
2956 intval($community_page),
2957 intval($importer['id'])
2959 $importer['forum'] = (string) $community_page;
2962 logger('local_delivery: feed item count = ' . $feed->get_item_quantity());
2964 // process any deleted entries
2966 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2967 if(is_array($del_entries) && count($del_entries)) {
2968 foreach($del_entries as $dentry) {
2970 if(isset($dentry['attribs']['']['ref'])) {
2971 $uri = $dentry['attribs']['']['ref'];
2973 if(isset($dentry['attribs']['']['when'])) {
2974 $when = $dentry['attribs']['']['when'];
2975 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2978 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2982 // check for relayed deletes to our conversation
2985 $r = q("select * from item where uri = '%s' and uid = %d limit 1",
2987 intval($importer['importer_uid'])
2990 $parent_uri = $r[0]['parent-uri'];
2991 if($r[0]['id'] != $r[0]['parent'])
2998 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3001 logger('local_delivery: possible community delete');
3004 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3006 // was the top-level post for this reply written by somebody on this site?
3007 // Specifically, the recipient?
3009 $is_a_remote_delete = false;
3011 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3012 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3013 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3014 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3015 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3016 AND `item`.`uid` = %d
3022 intval($importer['importer_uid'])
3025 $is_a_remote_delete = true;
3027 // Does this have the characteristics of a community or private group comment?
3028 // If it's a reply to a wall post on a community/prvgroup page it's a
3029 // valid community comment. Also forum_mode makes it valid for sure.
3030 // If neither, it's not.
3032 if($is_a_remote_delete && $community) {
3033 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3034 $is_a_remote_delete = false;
3035 logger('local_delivery: not a community delete');
3039 if($is_a_remote_delete) {
3040 logger('local_delivery: received remote delete');
3044 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN contact on `item`.`contact-id` = `contact`.`id`
3045 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
3047 intval($importer['importer_uid']),
3048 intval($importer['id'])
3054 if($item['deleted'])
3057 logger('local_delivery: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
3059 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3060 $xo = parse_xml_string($item['object'],false);
3061 $xt = parse_xml_string($item['target'],false);
3063 if($xt->type === ACTIVITY_OBJ_NOTE) {
3064 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
3066 intval($importer['importer_uid'])
3070 // For tags, the owner cannot remove the tag on the author's copy of the post.
3072 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
3073 $author_remove = (($item['origin'] && $item['self']) ? true : false);
3074 $author_copy = (($item['origin']) ? true : false);
3076 if($owner_remove && $author_copy)
3078 if($author_remove || $owner_remove) {
3079 $tags = explode(',',$i[0]['tag']);
3082 foreach($tags as $tag)
3083 if(trim($tag) !== trim($xo->body))
3084 $newtags[] = trim($tag);
3086 q("update item set tag = '%s' where id = %d",
3087 dbesc(implode(',',$newtags)),
3090 create_tags_from_item($i[0]['id']);
3096 if($item['uri'] == $item['parent-uri']) {
3097 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3098 `body` = '', `title` = ''
3099 WHERE `parent-uri` = '%s' AND `uid` = %d",
3101 dbesc(datetime_convert()),
3102 dbesc($item['uri']),
3103 intval($importer['importer_uid'])
3105 create_tags_from_itemuri($item['uri'], $importer['importer_uid']);
3106 create_files_from_itemuri($item['uri'], $importer['importer_uid']);
3107 update_thread_uri($item['uri'], $importer['importer_uid']);
3110 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3111 `body` = '', `title` = ''
3112 WHERE `uri` = '%s' AND `uid` = %d",
3114 dbesc(datetime_convert()),
3116 intval($importer['importer_uid'])
3118 create_tags_from_itemuri($uri, $importer['importer_uid']);
3119 create_files_from_itemuri($uri, $importer['importer_uid']);
3120 update_thread_uri($uri, $importer['importer_uid']);
3121 if($item['last-child']) {
3122 // ensure that last-child is set in case the comment that had it just got wiped.
3123 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
3124 dbesc(datetime_convert()),
3125 dbesc($item['parent-uri']),
3126 intval($item['uid'])
3128 // who is the last child now?
3129 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d
3130 ORDER BY `created` DESC LIMIT 1",
3131 dbesc($item['parent-uri']),
3132 intval($importer['importer_uid'])
3135 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
3140 // if this is a relayed delete, propagate it to other recipients
3142 if($is_a_remote_delete)
3143 proc_run('php',"include/notifier.php","drop",$item['id']);
3151 foreach($feed->get_items() as $item) {
3154 $item_id = $item->get_id();
3155 $rawthread = $item->get_item_tags( NAMESPACE_THREAD, 'in-reply-to');
3156 if(isset($rawthread[0]['attribs']['']['ref'])) {
3158 $parent_uri = $rawthread[0]['attribs']['']['ref'];
3164 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3167 logger('local_delivery: possible community reply');
3170 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3172 // was the top-level post for this reply written by somebody on this site?
3173 // Specifically, the recipient?
3175 $is_a_remote_comment = false;
3176 $top_uri = $parent_uri;
3178 $r = q("select `item`.`parent-uri` from `item`
3179 WHERE `item`.`uri` = '%s'
3183 if($r && count($r)) {
3184 $top_uri = $r[0]['parent-uri'];
3186 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3187 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3188 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3189 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3190 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3191 AND `item`.`uid` = %d
3197 intval($importer['importer_uid'])
3200 $is_a_remote_comment = true;
3203 // Does this have the characteristics of a community or private group comment?
3204 // If it's a reply to a wall post on a community/prvgroup page it's a
3205 // valid community comment. Also forum_mode makes it valid for sure.
3206 // If neither, it's not.
3208 if($is_a_remote_comment && $community) {
3209 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3210 $is_a_remote_comment = false;
3211 logger('local_delivery: not a community reply');
3215 if($is_a_remote_comment) {
3216 logger('local_delivery: received remote comment');
3218 // remote reply to our post. Import and then notify everybody else.
3220 $datarray = get_atom_elements($feed, $item);
3222 $r = q("SELECT `id`, `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3224 intval($importer['importer_uid'])
3227 // Update content if 'updated' changes
3231 if (edited_timestamp_is_newer($r[0], $datarray)) {
3233 // do not accept (ignore) an earlier edit than one we currently have.
3234 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3237 logger('received updated comment' , LOGGER_DEBUG);
3238 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3239 dbesc($datarray['title']),
3240 dbesc($datarray['body']),
3241 dbesc($datarray['tag']),
3242 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3243 dbesc(datetime_convert()),
3245 intval($importer['importer_uid'])
3247 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3249 proc_run('php',"include/notifier.php","comment-import",$iid);
3258 $own = q("select name,url,thumb from contact where uid = %d and self = 1 limit 1",
3259 intval($importer['importer_uid'])
3263 $datarray['type'] = 'remote-comment';
3264 $datarray['wall'] = 1;
3265 $datarray['parent-uri'] = $parent_uri;
3266 $datarray['uid'] = $importer['importer_uid'];
3267 $datarray['owner-name'] = $own[0]['name'];
3268 $datarray['owner-link'] = $own[0]['url'];
3269 $datarray['owner-avatar'] = $own[0]['thumb'];
3270 $datarray['contact-id'] = $importer['id'];
3272 if(($datarray['verb'] === ACTIVITY_LIKE) || ($datarray['verb'] === ACTIVITY_DISLIKE)) {
3274 $datarray['type'] = 'activity';
3275 $datarray['gravity'] = GRAVITY_LIKE;
3276 $datarray['last-child'] = 0;
3277 // only one like or dislike per person
3278 // splitted into two queries for performance issues
3279 $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",
3280 intval($datarray['uid']),
3281 intval($datarray['contact-id']),
3282 dbesc($datarray['verb']),
3283 dbesc($datarray['parent-uri'])
3289 $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",
3290 intval($datarray['uid']),
3291 intval($datarray['contact-id']),
3292 dbesc($datarray['verb']),
3293 dbesc($datarray['parent-uri'])
3300 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3302 $xo = parse_xml_string($datarray['object'],false);
3303 $xt = parse_xml_string($datarray['target'],false);
3305 if(($xt->type == ACTIVITY_OBJ_NOTE) && ($xt->id)) {
3307 // fetch the parent item
3309 $tagp = q("select * from item where uri = '%s' and uid = %d limit 1",
3311 intval($importer['importer_uid'])
3316 // extract tag, if not duplicate, and this user allows tags, add to parent item
3318 if($xo->id && $xo->content) {
3319 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
3320 if(! (stristr($tagp[0]['tag'],$newtag))) {
3321 $i = q("SELECT `blocktags` FROM `user` where `uid` = %d LIMIT 1",
3322 intval($importer['importer_uid'])
3324 if(count($i) && ! intval($i[0]['blocktags'])) {
3325 q("UPDATE item SET tag = '%s', `edited` = '%s', `changed` = '%s' WHERE id = %d",
3326 dbesc($tagp[0]['tag'] . (strlen($tagp[0]['tag']) ? ',' : '') . $newtag),
3327 intval($tagp[0]['id']),
3328 dbesc(datetime_convert()),
3329 dbesc(datetime_convert())
3331 create_tags_from_item($tagp[0]['id']);
3339 $posted_id = item_store($datarray);
3343 $r = q("SELECT `parent`, `parent-uri` FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3345 intval($importer['importer_uid'])
3348 $parent = $r[0]['parent'];
3349 $parent_uri = $r[0]['parent-uri'];
3353 $r1 = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `uid` = %d AND `parent` = %d",
3354 dbesc(datetime_convert()),
3355 intval($importer['importer_uid']),
3356 intval($r[0]['parent'])
3359 $r2 = q("UPDATE `item` SET `last-child` = 1, `changed` = '%s' WHERE `uid` = %d AND `id` = %d",
3360 dbesc(datetime_convert()),
3361 intval($importer['importer_uid']),
3366 if($posted_id && $parent) {
3368 proc_run('php',"include/notifier.php","comment-import","$posted_id");
3370 if((! $is_like) && (! $importer['self'])) {
3372 require_once('include/enotify.php');
3375 'type' => NOTIFY_COMMENT,
3376 'notify_flags' => $importer['notify-flags'],
3377 'language' => $importer['language'],
3378 'to_name' => $importer['username'],
3379 'to_email' => $importer['email'],
3380 'uid' => $importer['importer_uid'],
3381 'item' => $datarray,
3382 //'link' => $a->get_baseurl() . '/display/' . $importer['nickname'] . '/' . $posted_id,
3383 'link' => $a->get_baseurl().'/display/'.get_item_guid($posted_id),
3384 'source_name' => stripslashes($datarray['author-name']),
3385 'source_link' => $datarray['author-link'],
3386 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3387 ? $importer['thumb'] : $datarray['author-avatar']),
3388 'verb' => ACTIVITY_POST,
3390 'parent' => $parent,
3391 'parent_uri' => $parent_uri,
3403 // regular comment that is part of this total conversation. Have we seen it? If not, import it.
3405 $item_id = $item->get_id();
3406 $datarray = get_atom_elements($feed,$item);
3408 if($importer['rel'] == CONTACT_IS_FOLLOWER)
3411 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3413 intval($importer['importer_uid'])
3416 // Update content if 'updated' changes
3419 if (edited_timestamp_is_newer($r[0], $datarray)) {
3421 // do not accept (ignore) an earlier edit than one we currently have.
3422 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3425 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3426 dbesc($datarray['title']),
3427 dbesc($datarray['body']),
3428 dbesc($datarray['tag']),
3429 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3430 dbesc(datetime_convert()),
3432 intval($importer['importer_uid'])
3434 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3437 // update last-child if it changes
3439 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3440 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
3441 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
3442 dbesc(datetime_convert()),
3444 intval($importer['importer_uid'])
3446 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3447 intval($allow[0]['data']),
3448 dbesc(datetime_convert()),
3450 intval($importer['importer_uid'])
3456 $datarray['parent-uri'] = $parent_uri;
3457 $datarray['uid'] = $importer['importer_uid'];
3458 $datarray['contact-id'] = $importer['id'];
3459 if(($datarray['verb'] == ACTIVITY_LIKE) || ($datarray['verb'] == ACTIVITY_DISLIKE)) {
3460 $datarray['type'] = 'activity';
3461 $datarray['gravity'] = GRAVITY_LIKE;
3462 // only one like or dislike per person
3463 // splitted into two queries for performance issues
3464 $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",
3465 intval($datarray['uid']),
3466 intval($datarray['contact-id']),
3467 dbesc($datarray['verb']),
3473 $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",
3474 intval($datarray['uid']),
3475 intval($datarray['contact-id']),
3476 dbesc($datarray['verb']),
3484 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3486 $xo = parse_xml_string($datarray['object'],false);
3487 $xt = parse_xml_string($datarray['target'],false);
3489 if($xt->type == ACTIVITY_OBJ_NOTE) {
3490 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
3492 intval($importer['importer_uid'])
3497 // extract tag, if not duplicate, add to parent item
3499 if(! (stristr($r[0]['tag'],trim($xo->content)))) {
3500 q("UPDATE item SET tag = '%s' WHERE id = %d",
3501 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]'),
3504 create_tags_from_item($r[0]['id']);
3510 $posted_id = item_store($datarray);
3512 // find out if our user is involved in this conversation and wants to be notified.
3514 if(!x($datarray['type']) || $datarray['type'] != 'activity') {
3516 $myconv = q("SELECT `author-link`, `author-avatar`, `parent` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `parent` != 0 AND `deleted` = 0",
3518 intval($importer['importer_uid'])
3521 if(count($myconv)) {
3522 $importer_url = $a->get_baseurl() . '/profile/' . $importer['nickname'];
3524 // first make sure this isn't our own post coming back to us from a wall-to-wall event
3525 if(! link_compare($datarray['author-link'],$importer_url)) {
3528 foreach($myconv as $conv) {
3530 // now if we find a match, it means we're in this conversation
3532 if(! link_compare($conv['author-link'],$importer_url))
3535 require_once('include/enotify.php');
3537 $conv_parent = $conv['parent'];
3540 'type' => NOTIFY_COMMENT,
3541 'notify_flags' => $importer['notify-flags'],
3542 'language' => $importer['language'],
3543 'to_name' => $importer['username'],
3544 'to_email' => $importer['email'],
3545 'uid' => $importer['importer_uid'],
3546 'item' => $datarray,
3547 //'link' => $a->get_baseurl() . '/display/' . $importer['nickname'] . '/' . $posted_id,
3548 'link' => $a->get_baseurl().'/display/'.get_item_guid($posted_id),
3549 'source_name' => stripslashes($datarray['author-name']),
3550 'source_link' => $datarray['author-link'],
3551 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3552 ? $importer['thumb'] : $datarray['author-avatar']),
3553 'verb' => ACTIVITY_POST,
3555 'parent' => $conv_parent,
3556 'parent_uri' => $parent_uri
3560 // only send one notification
3572 // Head post of a conversation. Have we seen it? If not, import it.
3575 $item_id = $item->get_id();
3576 $datarray = get_atom_elements($feed,$item);
3578 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
3579 $ev = bbtoevent($datarray['body']);
3580 if(x($ev,'desc') && x($ev,'start')) {
3581 $ev['cid'] = $importer['id'];
3582 $ev['uid'] = $importer['uid'];
3583 $ev['uri'] = $item_id;
3584 $ev['edited'] = $datarray['edited'];
3585 $ev['private'] = $datarray['private'];
3587 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3589 intval($importer['uid'])
3592 $ev['id'] = $r[0]['id'];
3593 $xyz = event_store($ev);
3598 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3600 intval($importer['importer_uid'])
3603 // Update content if 'updated' changes
3606 if (edited_timestamp_is_newer($r[0], $datarray)) {
3608 // do not accept (ignore) an earlier edit than one we currently have.
3609 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3612 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3613 dbesc($datarray['title']),
3614 dbesc($datarray['body']),
3615 dbesc($datarray['tag']),
3616 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3617 dbesc(datetime_convert()),
3619 intval($importer['importer_uid'])
3621 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3622 update_thread_uri($item_id, $importer['importer_uid']);
3625 // update last-child if it changes
3627 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3628 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
3629 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3630 intval($allow[0]['data']),
3631 dbesc(datetime_convert()),
3633 intval($importer['importer_uid'])
3639 // This is my contact on another system, but it's really me.
3640 // Turn this into a wall post.
3642 if($importer['remote_self'])
3643 $datarray['wall'] = 1;
3645 $datarray['parent-uri'] = $item_id;
3646 $datarray['uid'] = $importer['importer_uid'];
3647 $datarray['contact-id'] = $importer['id'];
3650 if(! link_compare($datarray['owner-link'],$importer['url'])) {
3651 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
3652 // but otherwise there's a possible data mixup on the sender's system.
3653 // the tgroup delivery code called from item_store will correct it if it's a forum,
3654 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
3655 logger('local_delivery: Correcting item owner.', LOGGER_DEBUG);
3656 $datarray['owner-name'] = $importer['senderName'];
3657 $datarray['owner-link'] = $importer['url'];
3658 $datarray['owner-avatar'] = $importer['thumb'];
3661 if(($importer['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['importer_uid'],$datarray)))
3664 $posted_id = item_store($datarray);
3666 if(stristr($datarray['verb'],ACTIVITY_POKE)) {
3667 $verb = urldecode(substr($datarray['verb'],strpos($datarray['verb'],'#')+1));
3670 $xo = parse_xml_string($datarray['object'],false);
3672 if(($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
3674 // somebody was poked/prodded. Was it me?
3676 $links = parse_xml_string("<links>".unxmlify($xo->link)."</links>",false);
3678 foreach($links->link as $l) {
3679 $atts = $l->attributes();
3680 switch($atts['rel']) {
3682 $Blink = $atts['href'];
3688 if($Blink && link_compare($Blink,$a->get_baseurl() . '/profile/' . $importer['nickname'])) {
3690 // send a notification
3691 require_once('include/enotify.php');
3694 'type' => NOTIFY_POKE,
3695 'notify_flags' => $importer['notify-flags'],
3696 'language' => $importer['language'],
3697 'to_name' => $importer['username'],
3698 'to_email' => $importer['email'],
3699 'uid' => $importer['importer_uid'],
3700 'item' => $datarray,
3701 //'link' => $a->get_baseurl() . '/display/' . $importer['nickname'] . '/' . $posted_id,
3702 'link' => $a->get_baseurl().'/display/'.get_item_guid($posted_id),
3703 'source_name' => stripslashes($datarray['author-name']),
3704 'source_link' => $datarray['author-link'],
3705 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3706 ? $importer['thumb'] : $datarray['author-avatar']),
3707 'verb' => $datarray['verb'],
3708 'otype' => 'person',
3709 'activity' => $verb,
3726 function new_follower($importer,$contact,$datarray,$item,$sharing = false) {
3727 $url = notags(trim($datarray['author-link']));
3728 $name = notags(trim($datarray['author-name']));
3729 $photo = notags(trim($datarray['author-avatar']));
3731 $rawtag = $item->get_item_tags(NAMESPACE_ACTIVITY,'actor');
3732 if($rawtag && $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'])
3733 $nick = $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'];
3735 if(is_array($contact)) {
3736 if(($contact['network'] == NETWORK_OSTATUS && $contact['rel'] == CONTACT_IS_SHARING)
3737 || ($sharing && $contact['rel'] == CONTACT_IS_FOLLOWER)) {
3738 $r = q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
3739 intval(CONTACT_IS_FRIEND),
3740 intval($contact['id']),
3741 intval($importer['uid'])
3744 // send email notification to owner?
3748 // create contact record
3750 $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `name`, `nick`, `photo`, `network`, `rel`,
3751 `blocked`, `readonly`, `pending`, `writable` )
3752 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, 1 ) ",
3753 intval($importer['uid']),
3754 dbesc(datetime_convert()),
3756 dbesc(normalise_link($url)),
3760 dbesc(($sharing) ? NETWORK_ZOT : NETWORK_OSTATUS),
3761 intval(($sharing) ? CONTACT_IS_SHARING : CONTACT_IS_FOLLOWER)
3763 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `url` = '%s' AND `pending` = 1 LIMIT 1",
3764 intval($importer['uid']),
3768 $contact_record = $r[0];
3770 // create notification
3771 $hash = random_string();
3773 if(is_array($contact_record)) {
3774 $ret = q("INSERT INTO `intro` ( `uid`, `contact-id`, `blocked`, `knowyou`, `hash`, `datetime`)
3775 VALUES ( %d, %d, 0, 0, '%s', '%s' )",
3776 intval($importer['uid']),
3777 intval($contact_record['id']),
3779 dbesc(datetime_convert())
3782 $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
3783 intval($importer['uid'])
3788 if(intval($r[0]['def_gid'])) {
3789 require_once('include/group.php');
3790 group_add_member($r[0]['uid'],'',$contact_record['id'],$r[0]['def_gid']);
3793 if(($r[0]['notify-flags'] & NOTIFY_INTRO) &&
3794 (($r[0]['page-flags'] == PAGE_NORMAL) OR ($r[0]['page-flags'] == PAGE_SOAPBOX))) {
3795 $email_tpl = get_intltext_template('follow_notify_eml.tpl');
3796 $email = replace_macros($email_tpl, array(
3797 '$requestor' => ((strlen($name)) ? $name : t('[Name Withheld]')),
3799 '$myname' => $r[0]['username'],
3800 '$siteurl' => $a->get_baseurl(),
3801 '$sitename' => $a->config['sitename']
3803 $res = mail($r[0]['email'],
3804 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'),
3806 'From: ' . 'Administrator' . '@' . $_SERVER['SERVER_NAME'] . "\n"
3807 . 'Content-type: text/plain; charset=UTF-8' . "\n"
3808 . 'Content-transfer-encoding: 8bit' );
3815 function lose_follower($importer,$contact,$datarray,$item) {
3817 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_SHARING)) {
3818 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
3819 intval(CONTACT_IS_SHARING),
3820 intval($contact['id'])
3824 contact_remove($contact['id']);
3828 function lose_sharer($importer,$contact,$datarray,$item) {
3830 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_FOLLOWER)) {
3831 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
3832 intval(CONTACT_IS_FOLLOWER),
3833 intval($contact['id'])
3837 contact_remove($contact['id']);
3842 function subscribe_to_hub($url,$importer,$contact,$hubmode = 'subscribe') {
3846 if(is_array($importer)) {
3847 $r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
3848 intval($importer['uid'])
3852 // Diaspora has different message-ids in feeds than they do
3853 // through the direct Diaspora protocol. If we try and use
3854 // the feed, we'll get duplicates. So don't.
3856 if((! count($r)) || $contact['network'] === NETWORK_DIASPORA)
3859 $push_url = get_config('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
3861 // Use a single verify token, even if multiple hubs
3863 $verify_token = ((strlen($contact['hub-verify'])) ? $contact['hub-verify'] : random_string());
3865 $params= 'hub.mode=' . $hubmode . '&hub.callback=' . urlencode($push_url) . '&hub.topic=' . urlencode($contact['poll']) . '&hub.verify=async&hub.verify_token=' . $verify_token;
3867 logger('subscribe_to_hub: ' . $hubmode . ' ' . $contact['name'] . ' to hub ' . $url . ' endpoint: ' . $push_url . ' with verifier ' . $verify_token);
3869 if(! strlen($contact['hub-verify'])) {
3870 $r = q("UPDATE `contact` SET `hub-verify` = '%s' WHERE `id` = %d",
3871 dbesc($verify_token),
3872 intval($contact['id'])
3876 post_url($url,$params);
3878 logger('subscribe_to_hub: returns: ' . $a->get_curl_code(), LOGGER_DEBUG);
3885 function atom_author($tag,$name,$uri,$h,$w,$photo) {
3889 $name = xmlify($name);
3890 $uri = xmlify($uri);
3893 $photo = xmlify($photo);
3897 $o .= "<name>$name</name>\r\n";
3898 $o .= "<uri>$uri</uri>\r\n";
3899 $o .= '<link rel="photo" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
3900 $o .= '<link rel="avatar" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
3902 call_hooks('atom_author', $o);
3904 $o .= "</$tag>\r\n";
3908 function atom_entry($item,$type,$author,$owner,$comment = false,$cid = 0) {
3912 if(! $item['parent'])
3915 if($item['deleted'])
3916 return '<at:deleted-entry ref="' . xmlify($item['uri']) . '" when="' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '" />' . "\r\n";
3919 if($item['allow_cid'] || $item['allow_gid'] || $item['deny_cid'] || $item['deny_gid'])
3920 $body = fix_private_photos($item['body'],$owner['uid'],$item,$cid);
3922 $body = $item['body'];
3924 $o = "\r\n\r\n<entry>\r\n";
3926 if(is_array($author))
3927 $o .= atom_author('author',$author['name'],$author['url'],80,80,$author['thumb']);
3929 $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']));
3930 if(strlen($item['owner-name']))
3931 $o .= atom_author('dfrn:owner',$item['owner-name'],$item['owner-link'],80,80,$item['owner-avatar']);
3933 if(($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
3934 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
3935 $o .= '<thr:in-reply-to ref="' . xmlify($parent_item) . '" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['parent']) . '" />' . "\r\n";
3938 $o .= '<id>' . xmlify($item['uri']) . '</id>' . "\r\n";
3939 $o .= '<title>' . xmlify($item['title']) . '</title>' . "\r\n";
3940 $o .= '<published>' . xmlify(datetime_convert('UTC','UTC',$item['created'] . '+00:00',ATOM_TIME)) . '</published>' . "\r\n";
3941 $o .= '<updated>' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '</updated>' . "\r\n";
3942 $o .= '<dfrn:env>' . base64url_encode($body, true) . '</dfrn:env>' . "\r\n";
3943 $o .= '<content type="' . $type . '" >' . xmlify((($type === 'html') ? bbcode($body) : $body)) . '</content>' . "\r\n";
3944 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['id']) . '" />' . "\r\n";
3946 $o .= '<dfrn:comment-allow>' . intval($item['last-child']) . '</dfrn:comment-allow>' . "\r\n";
3948 if($item['location']) {
3949 $o .= '<dfrn:location>' . xmlify($item['location']) . '</dfrn:location>' . "\r\n";
3950 $o .= '<poco:address><poco:formatted>' . xmlify($item['location']) . '</poco:formatted></poco:address>' . "\r\n";
3954 $o .= '<georss:point>' . xmlify($item['coord']) . '</georss:point>' . "\r\n";
3956 if(($item['private']) || strlen($item['allow_cid']) || strlen($item['allow_gid']) || strlen($item['deny_cid']) || strlen($item['deny_gid']))
3957 $o .= '<dfrn:private>' . (($item['private']) ? $item['private'] : 1) . '</dfrn:private>' . "\r\n";
3960 $o .= '<dfrn:extid>' . xmlify($item['extid']) . '</dfrn:extid>' . "\r\n";
3961 if($item['bookmark'])
3962 $o .= '<dfrn:bookmark>true</dfrn:bookmark>' . "\r\n";
3965 $o .= '<statusnet:notice_info local_id="' . $item['id'] . '" source="' . xmlify($item['app']) . '" ></statusnet:notice_info>' . "\r\n";
3968 $o .= '<dfrn:diaspora_guid>' . $item['guid'] . '</dfrn:diaspora_guid>' . "\r\n";
3970 if($item['signed_text']) {
3971 $sign = base64_encode(json_encode(array('signed_text' => $item['signed_text'],'signature' => $item['signature'],'signer' => $item['signer'])));
3972 $o .= '<dfrn:diaspora_signature>' . xmlify($sign) . '</dfrn:diaspora_signature>' . "\r\n";
3975 $verb = construct_verb($item);
3976 $o .= '<as:verb>' . xmlify($verb) . '</as:verb>' . "\r\n";
3977 $actobj = construct_activity_object($item);
3980 $actarg = construct_activity_target($item);
3984 $tags = item_getfeedtags($item);
3986 foreach($tags as $t) {
3987 $o .= '<category scheme="X-DFRN:' . xmlify($t[0]) . ':' . xmlify($t[1]) . '" term="' . xmlify($t[2]) . '" />' . "\r\n";
3991 $o .= item_getfeedattach($item);
3993 $mentioned = get_mentions($item);
3997 call_hooks('atom_entry', $o);
3999 $o .= '</entry>' . "\r\n";
4004 function fix_private_photos($s, $uid, $item = null, $cid = 0) {
4006 if(get_config('system','disable_embedded'))
4011 logger('fix_private_photos: check for photos', LOGGER_DEBUG);
4012 $site = substr($a->get_baseurl(),strpos($a->get_baseurl(),'://'));
4017 $img_start = strpos($orig_body, '[img');
4018 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4019 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4020 while( ($img_st_close !== false) && ($img_len !== false) ) {
4022 $img_st_close++; // make it point to AFTER the closing bracket
4023 $image = substr($orig_body, $img_start + $img_st_close, $img_len);
4025 logger('fix_private_photos: found photo ' . $image, LOGGER_DEBUG);
4028 if(stristr($image , $site . '/photo/')) {
4029 // Only embed locally hosted photos
4031 $i = basename($image);
4032 $i = str_replace(array('.jpg','.png','.gif'),array('','',''),$i);
4033 $x = strpos($i,'-');
4036 $res = substr($i,$x+1);
4037 $i = substr($i,0,$x);
4038 $r = q("SELECT * FROM `photo` WHERE `resource-id` = '%s' AND `scale` = %d AND `uid` = %d",
4045 // Check to see if we should replace this photo link with an embedded image
4046 // 1. No need to do so if the photo is public
4047 // 2. If there's a contact-id provided, see if they're in the access list
4048 // for the photo. If so, embed it.
4049 // 3. Otherwise, if we have an item, see if the item permissions match the photo
4050 // permissions, regardless of order but first check to see if they're an exact
4051 // match to save some processing overhead.
4053 if(has_permissions($r[0])) {
4055 $recips = enumerate_permissions($r[0]);
4056 if(in_array($cid, $recips)) {
4061 if(compare_permissions($item,$r[0]))
4066 $data = $r[0]['data'];
4067 $type = $r[0]['type'];
4069 // If a custom width and height were specified, apply before embedding
4070 if(preg_match("/\[img\=([0-9]*)x([0-9]*)\]/is", substr($orig_body, $img_start, $img_st_close), $match)) {
4071 logger('fix_private_photos: scaling photo', LOGGER_DEBUG);
4073 $width = intval($match[1]);
4074 $height = intval($match[2]);
4076 $ph = new Photo($data, $type);
4077 if($ph->is_valid()) {
4078 $ph->scaleImage(max($width, $height));
4079 $data = $ph->imageString();
4080 $type = $ph->getType();
4084 logger('fix_private_photos: replacing photo', LOGGER_DEBUG);
4085 $image = 'data:' . $type . ';base64,' . base64_encode($data);
4086 logger('fix_private_photos: replaced: ' . $image, LOGGER_DATA);
4092 $new_body = $new_body . substr($orig_body, 0, $img_start + $img_st_close) . $image . '[/img]';
4093 $orig_body = substr($orig_body, $img_start + $img_st_close + $img_len + strlen('[/img]'));
4094 if($orig_body === false)
4097 $img_start = strpos($orig_body, '[img');
4098 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4099 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4102 $new_body = $new_body . $orig_body;
4108 function has_permissions($obj) {
4109 if(($obj['allow_cid'] != '') || ($obj['allow_gid'] != '') || ($obj['deny_cid'] != '') || ($obj['deny_gid'] != ''))
4114 function compare_permissions($obj1,$obj2) {
4115 // first part is easy. Check that these are exactly the same.
4116 if(($obj1['allow_cid'] == $obj2['allow_cid'])
4117 && ($obj1['allow_gid'] == $obj2['allow_gid'])
4118 && ($obj1['deny_cid'] == $obj2['deny_cid'])
4119 && ($obj1['deny_gid'] == $obj2['deny_gid']))
4122 // This is harder. Parse all the permissions and compare the resulting set.
4124 $recipients1 = enumerate_permissions($obj1);
4125 $recipients2 = enumerate_permissions($obj2);
4128 if($recipients1 == $recipients2)
4133 // returns an array of contact-ids that are allowed to see this object
4135 function enumerate_permissions($obj) {
4136 require_once('include/group.php');
4137 $allow_people = expand_acl($obj['allow_cid']);
4138 $allow_groups = expand_groups(expand_acl($obj['allow_gid']));
4139 $deny_people = expand_acl($obj['deny_cid']);
4140 $deny_groups = expand_groups(expand_acl($obj['deny_gid']));
4141 $recipients = array_unique(array_merge($allow_people,$allow_groups));
4142 $deny = array_unique(array_merge($deny_people,$deny_groups));
4143 $recipients = array_diff($recipients,$deny);
4147 function item_getfeedtags($item) {
4150 $cnt = preg_match_all('|\#\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4152 for($x = 0; $x < $cnt; $x ++) {
4154 $ret[] = array('#',$matches[1][$x], $matches[2][$x]);
4158 $cnt = preg_match_all('|\@\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4160 for($x = 0; $x < $cnt; $x ++) {
4162 $ret[] = array('@',$matches[1][$x], $matches[2][$x]);
4168 function item_getfeedattach($item) {
4170 $arr = explode('[/attach],',$item['attach']);
4172 foreach($arr as $r) {
4174 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|',$r,$matches);
4176 $ret .= '<link rel="enclosure" href="' . xmlify($matches[1]) . '" type="' . xmlify($matches[3]) . '" ';
4177 if(intval($matches[2]))
4178 $ret .= 'length="' . intval($matches[2]) . '" ';
4179 if($matches[4] !== ' ')
4180 $ret .= 'title="' . xmlify(trim($matches[4])) . '" ';
4181 $ret .= ' />' . "\r\n";
4190 function item_expire($uid, $days, $network = "", $force = false) {
4192 if((! $uid) || ($days < 1))
4195 // $expire_network_only = save your own wall posts
4196 // and just expire conversations started by others
4198 $expire_network_only = get_pconfig($uid,'expire','network_only');
4199 $sql_extra = ((intval($expire_network_only)) ? " AND wall = 0 " : "");
4201 if ($network != "") {
4202 $sql_extra .= sprintf(" AND network = '%s' ", dbesc($network));
4203 // There is an index "uid_network_received" but not "uid_network_created"
4204 // This avoids the creation of another index just for one purpose.
4205 // And it doesn't really matter wether to look at "received" or "created"
4206 $range = "AND `received` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4208 $range = "AND `created` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4210 $r = q("SELECT * FROM `item`
4211 WHERE `uid` = %d $range
4222 $expire_items = get_pconfig($uid, 'expire','items');
4223 $expire_items = (($expire_items===false)?1:intval($expire_items)); // default if not set: 1
4225 // Forcing expiring of items - but not notes and marked items
4227 $expire_items = true;
4229 $expire_notes = get_pconfig($uid, 'expire','notes');
4230 $expire_notes = (($expire_notes===false)?1:intval($expire_notes)); // default if not set: 1
4232 $expire_starred = get_pconfig($uid, 'expire','starred');
4233 $expire_starred = (($expire_starred===false)?1:intval($expire_starred)); // default if not set: 1
4235 $expire_photos = get_pconfig($uid, 'expire','photos');
4236 $expire_photos = (($expire_photos===false)?0:intval($expire_photos)); // default if not set: 0
4238 logger('expire: # items=' . count($r). "; expire items: $expire_items, expire notes: $expire_notes, expire starred: $expire_starred, expire photos: $expire_photos");
4240 foreach($r as $item) {
4242 // don't expire filed items
4244 if(strpos($item['file'],'[') !== false)
4247 // Only expire posts, not photos and photo comments
4249 if($expire_photos==0 && strlen($item['resource-id']))
4251 if($expire_starred==0 && intval($item['starred']))
4253 if($expire_notes==0 && $item['type']=='note')
4255 if($expire_items==0 && $item['type']!='note')
4258 drop_item($item['id'],false);
4261 proc_run('php',"include/notifier.php","expire","$uid");
4266 function drop_items($items) {
4269 if(! local_user() && ! remote_user())
4273 foreach($items as $item) {
4274 $owner = drop_item($item,false);
4275 if($owner && ! $uid)
4280 // multiple threads may have been deleted, send an expire notification
4283 proc_run('php',"include/notifier.php","expire","$uid");
4287 function drop_item($id,$interactive = true) {
4291 // locate item to be deleted
4293 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
4300 notice( t('Item not found.') . EOL);
4301 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4306 $owner = $item['uid'];
4310 // check if logged in user is either the author or owner of this item
4312 if(is_array($_SESSION['remote'])) {
4313 foreach($_SESSION['remote'] as $visitor) {
4314 if($visitor['uid'] == $item['uid'] && $visitor['cid'] == $item['contact-id']) {
4315 $cid = $visitor['cid'];
4322 if((local_user() == $item['uid']) || ($cid) || (! $interactive)) {
4324 // Check if we should do HTML-based delete confirmation
4325 if($_REQUEST['confirm']) {
4326 // <form> can't take arguments in its "action" parameter
4327 // so add any arguments as hidden inputs
4328 $query = explode_querystring($a->query_string);
4330 foreach($query['args'] as $arg) {
4331 if(strpos($arg, 'confirm=') === false) {
4332 $arg_parts = explode('=', $arg);
4333 $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
4337 return replace_macros(get_markup_template('confirm.tpl'), array(
4339 '$message' => t('Do you really want to delete this item?'),
4340 '$extra_inputs' => $inputs,
4341 '$confirm' => t('Yes'),
4342 '$confirm_url' => $query['base'],
4343 '$confirm_name' => 'confirmed',
4344 '$cancel' => t('Cancel'),
4347 // Now check how the user responded to the confirmation query
4348 if($_REQUEST['canceled']) {
4349 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4352 logger('delete item: ' . $item['id'], LOGGER_DEBUG);
4355 $r = q("UPDATE `item` SET `deleted` = 1, `title` = '', `body` = '', `edited` = '%s', `changed` = '%s' WHERE `id` = %d",
4356 dbesc(datetime_convert()),
4357 dbesc(datetime_convert()),
4360 create_tags_from_item($item['id']);
4361 create_files_from_item($item['id']);
4362 delete_thread($item['id']);
4364 // clean up categories and tags so they don't end up as orphans
4367 $cnt = preg_match_all('/<(.*?)>/',$item['file'],$matches,PREG_SET_ORDER);
4369 foreach($matches as $mtch) {
4370 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],true);
4376 $cnt = preg_match_all('/\[(.*?)\]/',$item['file'],$matches,PREG_SET_ORDER);
4378 foreach($matches as $mtch) {
4379 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],false);
4383 // If item is a link to a photo resource, nuke all the associated photos
4384 // (visitors will not have photo resources)
4385 // This only applies to photos uploaded from the photos page. Photos inserted into a post do not
4386 // generate a resource-id and therefore aren't intimately linked to the item.
4388 if(strlen($item['resource-id'])) {
4389 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `uid` = %d ",
4390 dbesc($item['resource-id']),
4391 intval($item['uid'])
4393 // ignore the result
4396 // If item is a link to an event, nuke the event record.
4398 if(intval($item['event-id'])) {
4399 q("DELETE FROM `event` WHERE `id` = %d AND `uid` = %d",
4400 intval($item['event-id']),
4401 intval($item['uid'])
4403 // ignore the result
4406 // clean up item_id and sign meta-data tables
4409 // Old code - caused very long queries and warning entries in the mysql logfiles:
4411 $r = q("DELETE FROM item_id where iid in (select id from item where parent = %d and uid = %d)",
4412 intval($item['id']),
4413 intval($item['uid'])
4416 $r = q("DELETE FROM sign where iid in (select id from item where parent = %d and uid = %d)",
4417 intval($item['id']),
4418 intval($item['uid'])
4422 // The new code splits the queries since the mysql optimizer really has bad problems with subqueries
4424 // Creating list of parents
4425 $r = q("select id from item where parent = %d and uid = %d",
4426 intval($item['id']),
4427 intval($item['uid'])
4432 foreach ($r AS $row) {
4433 if ($parentid != "")
4436 $parentid .= $row["id"];
4440 if ($parentid != "") {
4441 $r = q("DELETE FROM item_id where iid in (%s)", dbesc($parentid));
4443 $r = q("DELETE FROM sign where iid in (%s)", dbesc($parentid));
4446 // If it's the parent of a comment thread, kill all the kids
4448 if($item['uri'] == $item['parent-uri']) {
4449 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = ''
4450 WHERE `parent-uri` = '%s' AND `uid` = %d ",
4451 dbesc(datetime_convert()),
4452 dbesc(datetime_convert()),
4453 dbesc($item['parent-uri']),
4454 intval($item['uid'])
4456 create_tags_from_item($item['parent-uri'], $item['uid']);
4457 create_files_from_item($item['parent-uri'], $item['uid']);
4458 delete_thread_uri($item['parent-uri'], $item['uid']);
4459 // ignore the result
4462 // ensure that last-child is set in case the comment that had it just got wiped.
4463 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
4464 dbesc(datetime_convert()),
4465 dbesc($item['parent-uri']),
4466 intval($item['uid'])
4468 // who is the last child now?
4469 $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",
4470 dbesc($item['parent-uri']),
4471 intval($item['uid'])
4474 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
4479 // Add a relayable_retraction signature for Diaspora.
4480 store_diaspora_retract_sig($item, $a->user, $a->get_baseurl());
4482 $drop_id = intval($item['id']);
4484 // send the notification upstream/downstream as the case may be
4486 proc_run('php',"include/notifier.php","drop","$drop_id");
4490 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4496 notice( t('Permission denied.') . EOL);
4497 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4504 function first_post_date($uid,$wall = false) {
4505 $r = q("select id, created from item
4506 where uid = %d and wall = %d and deleted = 0 and visible = 1 AND moderated = 0
4508 order by created asc limit 1",
4510 intval($wall ? 1 : 0)
4513 // logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA);
4514 return substr(datetime_convert('',date_default_timezone_get(),$r[0]['created']),0,10);
4519 function posted_dates($uid,$wall) {
4520 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
4522 $dthen = first_post_date($uid,$wall);
4526 // If it's near the end of a long month, backup to the 28th so that in
4527 // consecutive loops we'll always get a whole month difference.
4529 if(intval(substr($dnow,8)) > 28)
4530 $dnow = substr($dnow,0,8) . '28';
4531 if(intval(substr($dthen,8)) > 28)
4532 $dnow = substr($dthen,0,8) . '28';
4535 // Starting with the current month, get the first and last days of every
4536 // month down to and including the month of the first post
4537 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
4538 $dstart = substr($dnow,0,8) . '01';
4539 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
4540 $start_month = datetime_convert('','',$dstart,'Y-m-d');
4541 $end_month = datetime_convert('','',$dend,'Y-m-d');
4542 $str = day_translate(datetime_convert('','',$dnow,'F Y'));
4543 $ret[] = array($str,$end_month,$start_month);
4544 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
4550 function posted_date_widget($url,$uid,$wall) {
4553 if(! feature_enabled($uid,'archives'))
4556 // For former Facebook folks that left because of "timeline"
4558 /* if($wall && intval(get_pconfig($uid,'system','no_wall_archive_widget')))
4561 $ret = posted_dates($uid,$wall);
4565 $o = replace_macros(get_markup_template('posted_date_widget.tpl'),array(
4566 '$title' => t('Archives'),
4567 '$size' => ((count($ret) > 6) ? 6 : count($ret)),
4574 function store_diaspora_retract_sig($item, $user, $baseurl) {
4575 // Note that we can't add a target_author_signature
4576 // if the comment was deleted by a remote user. That should be ok, because if a remote user is deleting
4577 // the comment, that means we're the home of the post, and Diaspora will only
4578 // check the parent_author_signature of retractions that it doesn't have to relay further
4580 // I don't think this function gets called for an "unlike," but I'll check anyway
4582 $enabled = intval(get_config('system','diaspora_enabled'));
4584 logger('drop_item: diaspora support disabled, not storing retraction signature', LOGGER_DEBUG);
4588 logger('drop_item: storing diaspora retraction signature');
4590 $signed_text = $item['guid'] . ';' . ( ($item['verb'] === ACTIVITY_LIKE) ? 'Like' : 'Comment');
4592 if(local_user() == $item['uid']) {
4594 $handle = $user['nickname'] . '@' . substr($baseurl, strpos($baseurl,'://') + 3);
4595 $authorsig = base64_encode(rsa_sign($signed_text,$user['prvkey'],'sha256'));
4598 $r = q("SELECT `nick`, `url` FROM `contact` WHERE `id` = '%d' LIMIT 1",
4599 $item['contact-id'] // If this function gets called, drop_item() has already checked remote_user() == $item['contact-id']
4602 // The below handle only works for NETWORK_DFRN. I think that's ok, because this function
4603 // only handles DFRN deletes
4604 $handle_baseurl_start = strpos($r['url'],'://') + 3;
4605 $handle_baseurl_length = strpos($r['url'],'/profile') - $handle_baseurl_start;
4606 $handle = $r['nick'] . '@' . substr($r['url'], $handle_baseurl_start, $handle_baseurl_length);
4612 q("insert into sign (`retract_iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
4613 intval($item['id']),
4614 dbesc($signed_text),