3 require_once('include/bbcode.php');
4 require_once('include/oembed.php');
5 require_once('include/salmon.php');
6 require_once('include/crypto.php');
7 require_once('include/Photo.php');
8 require_once('include/tags.php');
9 require_once('include/files.php');
10 require_once('include/text.php');
11 require_once('include/email.php');
12 require_once('include/ostatus_conversation.php');
13 require_once('include/threads.php');
14 require_once('include/socgraph.php');
15 require_once('mod/share.php');
17 function get_feed_for(&$a, $dfrn_id, $owner_nick, $last_update, $direction = 0, $forpubsub = false) {
20 $sitefeed = ((strlen($owner_nick)) ? false : true); // not yet implemented, need to rewrite huge chunks of following logic
21 $public_feed = (($dfrn_id) ? false : true);
22 $starred = false; // not yet implemented, possible security issues
25 if($public_feed && $a->argc > 2) {
26 for($x = 2; $x < $a->argc; $x++) {
27 if($a->argv[$x] == 'converse')
29 if($a->argv[$x] == 'starred')
31 if($a->argv[$x] === 'category' && $a->argc > ($x + 1) && strlen($a->argv[$x+1]))
32 $category = $a->argv[$x+1];
38 // default permissions - anonymous user
40 $sql_extra = " AND `allow_cid` = '' AND `allow_gid` = '' AND `deny_cid` = '' AND `deny_gid` = '' ";
42 $r = q("SELECT `contact`.*, `user`.`uid` AS `user_uid`, `user`.`nickname`, `user`.`timezone`, `user`.`page-flags`
43 FROM `contact` INNER JOIN `user` ON `user`.`uid` = `contact`.`uid`
44 WHERE `contact`.`self` = 1 AND `user`.`nickname` = '%s' LIMIT 1",
52 $owner_id = $owner['user_uid'];
53 $owner_nick = $owner['nickname'];
55 $birthday = feed_birthday($owner_id,$owner['timezone']);
65 $sql_extra = sprintf(" AND `issued-id` = '%s' ", dbesc($dfrn_id));
69 $sql_extra = sprintf(" AND `issued-id` = '%s' AND `duplex` = 1 ", dbesc($dfrn_id));
70 $my_id = '1:' . $dfrn_id;
73 $sql_extra = sprintf(" AND `dfrn-id` = '%s' AND `duplex` = 1 ", dbesc($dfrn_id));
74 $my_id = '0:' . $dfrn_id;
81 $r = q("SELECT * FROM `contact` WHERE `blocked` = 0 AND `pending` = 0 AND `contact`.`uid` = %d $sql_extra LIMIT 1",
89 require_once('include/security.php');
90 $groups = init_groups_visitor($contact['id']);
93 for($x = 0; $x < count($groups); $x ++)
94 $groups[$x] = '<' . intval($groups[$x]) . '>' ;
95 $gs = implode('|', $groups);
98 $gs = '<<>>' ; // Impossible to match
100 $sql_extra = sprintf("
101 AND ( `allow_cid` = '' OR `allow_cid` REGEXP '<%d>' )
102 AND ( `deny_cid` = '' OR NOT `deny_cid` REGEXP '<%d>' )
103 AND ( `allow_gid` = '' OR `allow_gid` REGEXP '%s' )
104 AND ( `deny_gid` = '' OR NOT `deny_gid` REGEXP '%s')
106 intval($contact['id']),
107 intval($contact['id']),
118 // Include answers to status.net posts in pubsub feeds
120 $sql_post_table = "INNER JOIN `thread` ON `thread`.`iid` = `item`.`parent` ";
121 $visibility = sprintf("OR (`item`.`network` = '%s' AND `thread`.`network`='%s')",
122 dbesc(NETWORK_DFRN), dbesc(NETWORK_OSTATUS));
123 $date_field = "`received`";
124 $sql_order = "`item`.`received` DESC";
126 $date_field = "`changed`";
127 $sql_order = "`item`.`parent` ".$sort.", `item`.`created` ASC";
130 if(! strlen($last_update))
131 $last_update = 'now -30 days';
133 if(isset($category)) {
134 $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` ",
135 dbesc(protect_sprintf($category)), intval(TERM_OBJ_POST), intval(TERM_CATEGORY), intval($owner_id));
136 //$sql_extra .= file_tag_file_query('item',$category,'category');
141 $sql_extra .= " AND `contact`.`self` = 1 ";
144 $check_date = datetime_convert('UTC','UTC',$last_update,'Y-m-d H:i:s');
146 // AND ( `item`.`edited` > '%s' OR `item`.`changed` > '%s' )
147 // dbesc($check_date),
149 $r = q("SELECT STRAIGHT_JOIN `item`.*, `item`.`id` AS `item_id`,
150 `contact`.`name`, `contact`.`network`, `contact`.`photo`, `contact`.`url`,
151 `contact`.`name-date`, `contact`.`uri-date`, `contact`.`avatar-date`,
152 `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
153 `contact`.`id` AS `contact-id`, `contact`.`uid` AS `contact-uid`,
154 `sign`.`signed_text`, `sign`.`signature`, `sign`.`signer`
155 FROM `item` $sql_post_table
156 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
157 AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
158 LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id`
159 WHERE `item`.`uid` = %d AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`parent` != 0
160 AND ((`item`.`wall` = 1) $visibility) AND `item`.$date_field > '%s'
162 ORDER BY $sql_order LIMIT 0, 300",
168 // Will check further below if this actually returned results.
169 // We will provide an empty feed if that is the case.
173 $feed_template = get_markup_template(($dfrn_id) ? 'atom_feed_dfrn.tpl' : 'atom_feed.tpl');
177 $hubxml = feed_hublinks();
179 $salmon = feed_salmonlinks($owner_nick);
181 $alternatelink = $owner['url'];
184 $alternatelink .= "/category/".$category;
186 $atom .= replace_macros($feed_template, array(
187 '$version' => xmlify(FRIENDICA_VERSION),
188 '$feed_id' => xmlify($a->get_baseurl() . '/profile/' . $owner_nick),
189 '$feed_title' => xmlify($owner['name']),
190 '$feed_updated' => xmlify(datetime_convert('UTC', 'UTC', 'now' , ATOM_TIME)) ,
192 '$salmon' => $salmon,
193 '$alternatelink' => xmlify($alternatelink),
194 '$name' => xmlify($owner['name']),
195 '$profile_page' => xmlify($owner['url']),
196 '$photo' => xmlify($owner['photo']),
197 '$thumb' => xmlify($owner['thumb']),
198 '$picdate' => xmlify(datetime_convert('UTC','UTC',$owner['avatar-date'] . '+00:00' , ATOM_TIME)) ,
199 '$uridate' => xmlify(datetime_convert('UTC','UTC',$owner['uri-date'] . '+00:00' , ATOM_TIME)) ,
200 '$namdate' => xmlify(datetime_convert('UTC','UTC',$owner['name-date'] . '+00:00' , ATOM_TIME)) ,
201 '$birthday' => ((strlen($birthday)) ? '<dfrn:birthday>' . xmlify($birthday) . '</dfrn:birthday>' : ''),
202 '$community' => (($owner['page-flags'] == PAGE_COMMUNITY) ? '<dfrn:community>1</dfrn:community>' : '')
205 call_hooks('atom_feed', $atom);
207 if(! count($items)) {
209 call_hooks('atom_feed_end', $atom);
211 $atom .= '</feed>' . "\r\n";
215 foreach($items as $item) {
217 // prevent private email from leaking.
218 if($item['network'] === NETWORK_MAIL)
221 // public feeds get html, our own nodes use bbcode
225 // catch any email that's in a public conversation and make sure it doesn't leak
233 $atom .= atom_entry($item,$type,null,$owner,true);
236 call_hooks('atom_feed_end', $atom);
238 $atom .= '</feed>' . "\r\n";
244 function construct_verb($item) {
246 return $item['verb'];
247 return ACTIVITY_POST;
250 function construct_activity_object($item) {
252 if($item['object']) {
253 $o = '<as:object>' . "\r\n";
254 $r = parse_xml_string($item['object'],false);
260 $o .= '<as:object-type>' . xmlify($r->type) . '</as:object-type>' . "\r\n";
262 $o .= '<id>' . xmlify($r->id) . '</id>' . "\r\n";
264 $o .= '<title>' . xmlify($r->title) . '</title>' . "\r\n";
266 if(substr($r->link,0,1) === '<') {
267 // patch up some facebook "like" activity objects that got stored incorrectly
268 // for a couple of months prior to 9-Jun-2011 and generated bad XML.
269 // we can probably remove this hack here and in the following function in a few months time.
270 if(strstr($r->link,'&') && (! strstr($r->link,'&')))
271 $r->link = str_replace('&','&', $r->link);
272 $r->link = preg_replace('/\<link(.*?)\"\>/','<link$1"/>',$r->link);
276 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($r->link) . '" />' . "\r\n";
279 $o .= '<content type="html" >' . xmlify(bbcode($r->content)) . '</content>' . "\r\n";
280 $o .= '</as:object>' . "\r\n";
287 function construct_activity_target($item) {
289 if($item['target']) {
290 $o = '<as:target>' . "\r\n";
291 $r = parse_xml_string($item['target'],false);
295 $o .= '<as:object-type>' . xmlify($r->type) . '</as:object-type>' . "\r\n";
297 $o .= '<id>' . xmlify($r->id) . '</id>' . "\r\n";
299 $o .= '<title>' . xmlify($r->title) . '</title>' . "\r\n";
301 if(substr($r->link,0,1) === '<') {
302 if(strstr($r->link,'&') && (! strstr($r->link,'&')))
303 $r->link = str_replace('&','&', $r->link);
304 $r->link = preg_replace('/\<link(.*?)\"\>/','<link$1"/>',$r->link);
308 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($r->link) . '" />' . "\r\n";
311 $o .= '<content type="html" >' . xmlify(bbcode($r->content)) . '</content>' . "\r\n";
312 $o .= '</as:target>' . "\r\n";
321 * The purpose of this function is to apply system message length limits to
322 * imported messages without including any embedded photos in the length
324 if(! function_exists('limit_body_size')) {
325 function limit_body_size($body) {
327 // logger('limit_body_size: start', LOGGER_DEBUG);
329 $maxlen = get_max_import_size();
331 // If the length of the body, including the embedded images, is smaller
332 // than the maximum, then don't waste time looking for the images
333 if($maxlen && (strlen($body) > $maxlen)) {
335 logger('limit_body_size: the total body length exceeds the limit', LOGGER_DEBUG);
342 $img_start = strpos($orig_body, '[img');
343 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
344 $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
345 while(($img_st_close !== false) && ($img_end !== false)) {
347 $img_st_close++; // make it point to AFTER the closing bracket
348 $img_end += $img_start;
349 $img_end += strlen('[/img]');
351 if(! strcmp(substr($orig_body, $img_start + $img_st_close, 5), 'data:')) {
352 // This is an embedded image
354 if( ($textlen + $img_start) > $maxlen ) {
355 if($textlen < $maxlen) {
356 logger('limit_body_size: the limit happens before an embedded image', LOGGER_DEBUG);
357 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
362 $new_body = $new_body . substr($orig_body, 0, $img_start);
363 $textlen += $img_start;
366 $new_body = $new_body . substr($orig_body, $img_start, $img_end - $img_start);
370 if( ($textlen + $img_end) > $maxlen ) {
371 if($textlen < $maxlen) {
372 logger('limit_body_size: the limit happens before the end of a non-embedded image', LOGGER_DEBUG);
373 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
378 $new_body = $new_body . substr($orig_body, 0, $img_end);
379 $textlen += $img_end;
382 $orig_body = substr($orig_body, $img_end);
384 if($orig_body === false) // in case the body ends on a closing image tag
387 $img_start = strpos($orig_body, '[img');
388 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
389 $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
392 if( ($textlen + strlen($orig_body)) > $maxlen) {
393 if($textlen < $maxlen) {
394 logger('limit_body_size: the limit happens after the end of the last image', LOGGER_DEBUG);
395 $new_body = $new_body . substr($orig_body, 0, $maxlen - $textlen);
400 logger('limit_body_size: the text size with embedded images extracted did not violate the limit', LOGGER_DEBUG);
401 $new_body = $new_body . $orig_body;
402 $textlen += strlen($orig_body);
411 function title_is_body($title, $body) {
413 $title = strip_tags($title);
414 $title = trim($title);
415 $title = html_entity_decode($title, ENT_QUOTES, 'UTF-8');
416 $title = str_replace(array("\n", "\r", "\t", " "), array("","","",""), $title);
418 $body = strip_tags($body);
420 $body = html_entity_decode($body, ENT_QUOTES, 'UTF-8');
421 $body = str_replace(array("\n", "\r", "\t", " "), array("","","",""), $body);
423 if (strlen($title) < strlen($body))
424 $body = substr($body, 0, strlen($title));
426 if (($title != $body) and (substr($title, -3) == "...")) {
427 $pos = strrpos($title, "...");
429 $title = substr($title, 0, $pos);
430 $body = substr($body, 0, $pos);
434 return($title == $body);
439 function get_atom_elements($feed, $item, $contact = array()) {
441 require_once('library/HTMLPurifier.auto.php');
442 require_once('include/html2bbcode.php');
444 $best_photo = array();
448 $author = $item->get_author();
450 $res['author-name'] = unxmlify($author->get_name());
451 $res['author-link'] = unxmlify($author->get_link());
454 $res['author-name'] = unxmlify($feed->get_title());
455 $res['author-link'] = unxmlify($feed->get_permalink());
457 $res['uri'] = unxmlify($item->get_id());
458 $res['title'] = unxmlify($item->get_title());
459 $res['body'] = unxmlify($item->get_content());
460 $res['plink'] = unxmlify($item->get_link(0));
462 if (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND strstr($res['plink'], ".app.net/")) {
463 logger("get_atom_elements: detected app.net posting: ".print_r($res, true), LOGGER_DEBUG);
465 $res['body'] = nl2br($res['body']);
468 // removing the content of the title if its identically to the body
469 // This helps with auto generated titles e.g. from tumblr
470 if (title_is_body($res["title"], $res["body"]))
474 $base_url = implode('/', array_slice(explode('/',$res['plink']),0,3));
478 // look for a photo. We should check media size and find the best one,
479 // but for now let's just find any author photo
480 // Additionally we look for an alternate author link. On OStatus this one is the one we want.
482 // Search for ostatus conversation url
483 $authorlinks = $item->feed->data["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["feed"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["author"][0]["child"]["http://www.w3.org/2005/Atom"]["link"];
484 if (is_array($authorlinks)) {
485 foreach ($authorlinks as $link) {
486 $linkdata = array_shift($link["attribs"]);
488 if ($linkdata["rel"] == "alternate")
489 $res["author-link"] = $linkdata["href"];
493 $rawauthor = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'author');
495 if($rawauthor && $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
496 $base = $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
497 foreach($base as $link) {
498 if($link['attribs']['']['rel'] === 'alternate')
499 $res['author-link'] = unxmlify($link['attribs']['']['href']);
501 if(!x($res, 'author-avatar') || !$res['author-avatar']) {
502 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
503 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
508 $rawactor = $item->get_item_tags(NAMESPACE_ACTIVITY, 'actor');
510 if($rawactor && activity_match($rawactor[0]['child'][NAMESPACE_ACTIVITY]['object-type'][0]['data'],ACTIVITY_OBJ_PERSON)) {
511 $base = $rawactor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
512 if($base && count($base)) {
513 foreach($base as $link) {
514 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
515 $res['author-link'] = unxmlify($link['attribs']['']['href']);
516 if(!x($res, 'author-avatar') || !$res['author-avatar']) {
517 if($link['attribs']['']['rel'] === 'avatar' || $link['attribs']['']['rel'] === 'photo')
518 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
524 // No photo/profile-link on the item - look at the feed level
526 if((! (x($res,'author-link'))) || (! (x($res,'author-avatar')))) {
527 $rawauthor = $feed->get_feed_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'author');
528 if($rawauthor && $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
529 $base = $rawauthor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
530 foreach($base as $link) {
531 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
532 $res['author-link'] = unxmlify($link['attribs']['']['href']);
533 if(! $res['author-avatar']) {
534 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
535 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
540 $rawactor = $feed->get_feed_tags(NAMESPACE_ACTIVITY, 'subject');
542 if($rawactor && activity_match($rawactor[0]['child'][NAMESPACE_ACTIVITY]['object-type'][0]['data'],ACTIVITY_OBJ_PERSON)) {
543 $base = $rawactor[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
545 if($base && count($base)) {
546 foreach($base as $link) {
547 if($link['attribs']['']['rel'] === 'alternate' && (! $res['author-link']))
548 $res['author-link'] = unxmlify($link['attribs']['']['href']);
549 if(! (x($res,'author-avatar'))) {
550 if($link['attribs']['']['rel'] === 'avatar' || $link['attribs']['']['rel'] === 'photo')
551 $res['author-avatar'] = unxmlify($link['attribs']['']['href']);
558 $apps = $item->get_item_tags(NAMESPACE_STATUSNET,'notice_info');
559 if($apps && $apps[0]['attribs']['']['source']) {
560 $res['app'] = strip_tags(unxmlify($apps[0]['attribs']['']['source']));
561 if($res['app'] === 'web')
562 $res['app'] = 'OStatus';
565 // base64 encoded json structure representing Diaspora signature
567 $dsig = $item->get_item_tags(NAMESPACE_DFRN,'diaspora_signature');
569 $res['dsprsig'] = unxmlify($dsig[0]['data']);
572 $dguid = $item->get_item_tags(NAMESPACE_DFRN,'diaspora_guid');
574 $res['guid'] = unxmlify($dguid[0]['data']);
576 $bm = $item->get_item_tags(NAMESPACE_DFRN,'bookmark');
578 $res['bookmark'] = ((unxmlify($bm[0]['data']) === 'true') ? 1 : 0);
582 * If there's a copy of the body content which is guaranteed to have survived mangling in transit, use it.
585 $have_real_body = false;
587 $rawenv = $item->get_item_tags(NAMESPACE_DFRN, 'env');
589 $have_real_body = true;
590 $res['body'] = $rawenv[0]['data'];
591 $res['body'] = str_replace(array(' ',"\t","\r","\n"), array('','','',''),$res['body']);
592 // make sure nobody is trying to sneak some html tags by us
593 $res['body'] = notags(base64url_decode($res['body']));
597 $res['body'] = limit_body_size($res['body']);
599 // It isn't certain at this point whether our content is plaintext or html and we'd be foolish to trust
600 // the content type. Our own network only emits text normally, though it might have been converted to
601 // html if we used a pubsubhubbub transport. But if we see even one html tag in our text, we will
602 // have to assume it is all html and needs to be purified.
604 // It doesn't matter all that much security wise - because before this content is used anywhere, we are
605 // going to escape any tags we find regardless, but this lets us import a limited subset of html from
606 // the wild, by sanitising it and converting supported tags to bbcode before we rip out any remaining
609 if((strpos($res['body'],'<') !== false) && (strpos($res['body'],'>') !== false)) {
611 $res['body'] = reltoabs($res['body'],$base_url);
613 $res['body'] = html2bb_video($res['body']);
615 $res['body'] = oembed_html2bbcode($res['body']);
617 $config = HTMLPurifier_Config::createDefault();
618 $config->set('Cache.DefinitionImpl', null);
620 // we shouldn't need a whitelist, because the bbcode converter
621 // will strip out any unsupported tags.
623 $purifier = new HTMLPurifier($config);
624 $res['body'] = $purifier->purify($res['body']);
626 $res['body'] = @html2bbcode($res['body']);
630 elseif(! $have_real_body) {
632 // it's not one of our messages and it has no tags
633 // so it's probably just text. We'll escape it just to be safe.
635 $res['body'] = escape_tags($res['body']);
639 // this tag is obsolete but we keep it for really old sites
641 $allow = $item->get_item_tags(NAMESPACE_DFRN,'comment-allow');
642 if($allow && $allow[0]['data'] == 1)
643 $res['last-child'] = 1;
645 $res['last-child'] = 0;
647 $private = $item->get_item_tags(NAMESPACE_DFRN,'private');
648 if($private && intval($private[0]['data']) > 0)
649 $res['private'] = intval($private[0]['data']);
653 $extid = $item->get_item_tags(NAMESPACE_DFRN,'extid');
654 if($extid && $extid[0]['data'])
655 $res['extid'] = $extid[0]['data'];
657 $rawlocation = $item->get_item_tags(NAMESPACE_DFRN, 'location');
659 $res['location'] = unxmlify($rawlocation[0]['data']);
662 $rawcreated = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'published');
664 $res['created'] = unxmlify($rawcreated[0]['data']);
667 $rawedited = $item->get_item_tags(SIMPLEPIE_NAMESPACE_ATOM_10,'updated');
669 $res['edited'] = unxmlify($rawedited[0]['data']);
671 if((x($res,'edited')) && (! (x($res,'created'))))
672 $res['created'] = $res['edited'];
674 if(! $res['created'])
675 $res['created'] = $item->get_date('c');
678 $res['edited'] = $item->get_date('c');
681 // Disallow time travelling posts
683 $d1 = strtotime($res['created']);
684 $d2 = strtotime($res['edited']);
685 $d3 = strtotime('now');
688 $res['created'] = datetime_convert();
690 $res['edited'] = datetime_convert();
692 $rawowner = $item->get_item_tags(NAMESPACE_DFRN, 'owner');
693 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['name'][0]['data'])
694 $res['owner-name'] = unxmlify($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['name'][0]['data']);
695 elseif($rawowner[0]['child'][NAMESPACE_DFRN]['name'][0]['data'])
696 $res['owner-name'] = unxmlify($rawowner[0]['child'][NAMESPACE_DFRN]['name'][0]['data']);
697 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['uri'][0]['data'])
698 $res['owner-link'] = unxmlify($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['uri'][0]['data']);
699 elseif($rawowner[0]['child'][NAMESPACE_DFRN]['uri'][0]['data'])
700 $res['owner-link'] = unxmlify($rawowner[0]['child'][NAMESPACE_DFRN]['uri'][0]['data']);
702 if($rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link']) {
703 $base = $rawowner[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10]['link'];
705 foreach($base as $link) {
706 if(!x($res, 'owner-avatar') || !$res['owner-avatar']) {
707 if($link['attribs']['']['rel'] === 'photo' || $link['attribs']['']['rel'] === 'avatar')
708 $res['owner-avatar'] = unxmlify($link['attribs']['']['href']);
713 $rawgeo = $item->get_item_tags(NAMESPACE_GEORSS,'point');
715 $res['coord'] = unxmlify($rawgeo[0]['data']);
717 if ($contact["network"] == NETWORK_FEED) {
718 $res['verb'] = ACTIVITY_POST;
719 $res['object-type'] = ACTIVITY_OBJ_NOTE;
722 $rawverb = $item->get_item_tags(NAMESPACE_ACTIVITY, 'verb');
724 // select between supported verbs
727 $res['verb'] = unxmlify($rawverb[0]['data']);
730 // translate OStatus unfollow to activity streams if it happened to get selected
732 if((x($res,'verb')) && ($res['verb'] === 'http://ostatus.org/schema/1.0/unfollow'))
733 $res['verb'] = ACTIVITY_UNFOLLOW;
735 $cats = $item->get_categories();
738 foreach($cats as $cat) {
739 $term = $cat->get_term();
741 $term = $cat->get_label();
742 $scheme = $cat->get_scheme();
743 if($scheme && $term && stristr($scheme,'X-DFRN:'))
744 $tag_arr[] = substr($scheme,7,1) . '[url=' . unxmlify(substr($scheme,9)) . ']' . unxmlify($term) . '[/url]';
746 $tag_arr[] = notags(trim($term));
748 $res['tag'] = implode(',', $tag_arr);
751 $attach = $item->get_enclosures();
754 foreach($attach as $att) {
755 $len = intval($att->get_length());
756 $link = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_link()))));
757 $title = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_title()))));
758 $type = str_replace(array(',','"'),array('%2D','%22'),notags(trim(unxmlify($att->get_type()))));
759 if(strpos($type,';'))
760 $type = substr($type,0,strpos($type,';'));
761 if((! $link) || (strpos($link,'http') !== 0))
767 $type = 'application/octet-stream';
769 $att_arr[] = '[attach]href="' . $link . '" length="' . $len . '" type="' . $type . '" title="' . $title . '"[/attach]';
771 $res['attach'] = implode(',', $att_arr);
774 $rawobj = $item->get_item_tags(NAMESPACE_ACTIVITY, 'object');
777 $res['object'] = '<object>' . "\n";
778 $child = $rawobj[0]['child'];
779 if($child[NAMESPACE_ACTIVITY]['object-type'][0]['data']) {
780 $res['object-type'] = $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'];
781 $res['object'] .= '<type>' . $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'] . '</type>' . "\n";
783 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'id') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'])
784 $res['object'] .= '<id>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'] . '</id>' . "\n";
785 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'link') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['link'])
786 $res['object'] .= '<link>' . encode_rel_links($child[SIMPLEPIE_NAMESPACE_ATOM_10]['link']) . '</link>' . "\n";
787 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'title') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'])
788 $res['object'] .= '<title>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'] . '</title>' . "\n";
789 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'content') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data']) {
790 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data'];
792 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['summary'][0]['data'];
793 // preserve a copy of the original body content in case we later need to parse out any microformat information, e.g. events
794 $res['object'] .= '<orig>' . xmlify($body) . '</orig>' . "\n";
795 if((strpos($body,'<') !== false) || (strpos($body,'>') !== false)) {
797 $body = html2bb_video($body);
799 $config = HTMLPurifier_Config::createDefault();
800 $config->set('Cache.DefinitionImpl', null);
802 $purifier = new HTMLPurifier($config);
803 $body = $purifier->purify($body);
804 $body = html2bbcode($body);
807 $res['object'] .= '<content>' . $body . '</content>' . "\n";
810 $res['object'] .= '</object>' . "\n";
813 $rawobj = $item->get_item_tags(NAMESPACE_ACTIVITY, 'target');
816 $res['target'] = '<target>' . "\n";
817 $child = $rawobj[0]['child'];
818 if($child[NAMESPACE_ACTIVITY]['object-type'][0]['data']) {
819 $res['target'] .= '<type>' . $child[NAMESPACE_ACTIVITY]['object-type'][0]['data'] . '</type>' . "\n";
821 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'id') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'])
822 $res['target'] .= '<id>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['id'][0]['data'] . '</id>' . "\n";
823 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'link') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['link'])
824 $res['target'] .= '<link>' . encode_rel_links($child[SIMPLEPIE_NAMESPACE_ATOM_10]['link']) . '</link>' . "\n";
825 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'data') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'])
826 $res['target'] .= '<title>' . $child[SIMPLEPIE_NAMESPACE_ATOM_10]['title'][0]['data'] . '</title>' . "\n";
827 if(x($child[SIMPLEPIE_NAMESPACE_ATOM_10], 'data') && $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data']) {
828 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['content'][0]['data'];
830 $body = $child[SIMPLEPIE_NAMESPACE_ATOM_10]['summary'][0]['data'];
831 // preserve a copy of the original body content in case we later need to parse out any microformat information, e.g. events
832 $res['target'] .= '<orig>' . xmlify($body) . '</orig>' . "\n";
833 if((strpos($body,'<') !== false) || (strpos($body,'>') !== false)) {
835 $body = html2bb_video($body);
837 $config = HTMLPurifier_Config::createDefault();
838 $config->set('Cache.DefinitionImpl', null);
840 $purifier = new HTMLPurifier($config);
841 $body = $purifier->purify($body);
842 $body = html2bbcode($body);
845 $res['target'] .= '<content>' . $body . '</content>' . "\n";
848 $res['target'] .= '</target>' . "\n";
851 // This is some experimental stuff. By now retweets are shown with "RT:"
852 // But: There is data so that the message could be shown similar to native retweets
853 // There is some better way to parse this array - but it didn't worked for me.
854 $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"];
855 if (is_array($child)) {
856 logger('get_atom_elements: Looking for status.net repeated message');
858 $message = $child["http://activitystrea.ms/spec/1.0/"]["object"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["content"][0]["data"];
859 $orig_id = ostatus_convert_href($child["http://activitystrea.ms/spec/1.0/"]["object"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10]["id"][0]["data"]);
860 $author = $child[SIMPLEPIE_NAMESPACE_ATOM_10]["author"][0]["child"][SIMPLEPIE_NAMESPACE_ATOM_10];
861 $uri = $author["uri"][0]["data"];
862 $name = $author["name"][0]["data"];
863 $avatar = @array_shift($author["link"][2]["attribs"]);
864 $avatar = $avatar["href"];
866 if (($name != "") and ($uri != "") and ($avatar != "") and ($message != "")) {
867 logger('get_atom_elements: fixing sender of repeated message. '.$orig_id, LOGGER_DEBUG);
869 if (!intval(get_config('system','wall-to-wall_share'))) {
870 $prefix = share_header($name, $uri, $avatar, "", "", $orig_link);
872 $res["body"] = $prefix.html2bbcode($message)."[/share]";
874 $res["owner-name"] = $res["author-name"];
875 $res["owner-link"] = $res["author-link"];
876 $res["owner-avatar"] = $res["author-avatar"];
878 $res["author-name"] = $name;
879 $res["author-link"] = $uri;
880 $res["author-avatar"] = $avatar;
882 $res["body"] = html2bbcode($message);
887 // Search for ostatus conversation url
888 $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"];
890 if (is_array($links)) {
891 foreach ($links as $link) {
892 $conversation = array_shift($link["attribs"]);
894 if ($conversation["rel"] == "ostatus:conversation") {
895 $res["ostatus_conversation"] = ostatus_convert_href($conversation["href"]);
896 logger('get_atom_elements: found conversation url '.$res["ostatus_conversation"]);
897 } elseif ($conversation["rel"] == "alternate") {
898 $res["plink"] = $conversation["href"];
899 logger('get_atom_elements: found plink '.$res["plink"]);
904 if (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND $contact['fetch_further_information']) {
907 // Handle enclosures and treat them as preview picture
909 foreach ($attach AS $attachment)
910 if ($attachment->type == "image/jpeg")
911 $preview = $attachment->link;
913 $res["body"] = $res["title"].add_page_info($res['plink'], false, $preview, ($contact['fetch_further_information'] == 2), $contact['ffi_keyword_blacklist']);
914 $res["tag"] = add_page_keywords($res['plink'], false, $preview, ($contact['fetch_further_information'] == 2), $contact['ffi_keyword_blacklist']);
916 $res["object-type"] = ACTIVITY_OBJ_BOOKMARK;
917 unset($res["attach"]);
918 } elseif (isset($contact["network"]) AND ($contact["network"] == NETWORK_OSTATUS))
919 $res["body"] = add_page_info_to_body($res["body"]);
920 elseif (isset($contact["network"]) AND ($contact["network"] == NETWORK_FEED) AND strstr($res['plink'], ".app.net/")) {
921 $res["body"] = add_page_info_to_body($res["body"]);
924 $arr = array('feed' => $feed, 'item' => $item, 'result' => $res);
926 call_hooks('parse_atom', $arr);
931 function add_page_info_data($data) {
932 call_hooks('page_info_data', $data);
934 // It maybe is a rich content, but if it does have everything that a link has,
935 // then treat it that way
936 if (($data["type"] == "rich") AND is_string($data["title"]) AND
937 is_string($data["text"]) AND (sizeof($data["images"]) > 0))
938 $data["type"] = "link";
940 if ((($data["type"] != "link") AND ($data["type"] != "video") AND ($data["type"] != "photo")) OR ($data["title"] == $url))
943 if ($no_photos AND ($data["type"] == "photo"))
946 // If the link contains BBCode stuff, make a short link out of this to avoid parsing problems
947 if (strpos($data["url"], '[') OR strpos($data["url"], ']')) {
948 require_once("include/network.php");
949 $data["url"] = short_link($data["url"]);
952 if (($data["type"] != "photo") AND is_string($data["title"]))
953 $text .= "[bookmark=".$data["url"]."]".trim($data["title"])."[/bookmark]";
955 if (($data["type"] != "video") AND ($photo != ""))
956 $text .= '[img]'.$photo.'[/img]';
957 elseif (($data["type"] != "video") AND (sizeof($data["images"]) > 0)) {
958 $imagedata = $data["images"][0];
959 $text .= '[img]'.$imagedata["src"].'[/img]';
962 if (($data["type"] != "photo") AND is_string($data["text"]))
963 $text .= "[quote]".$data["text"]."[/quote]";
966 if (isset($data["keywords"]) AND count($data["keywords"])) {
969 foreach ($data["keywords"] AS $keyword) {
970 $hashtag = str_replace(array(" ", "+", "/", ".", "#", "'"),
971 array("","", "", "", "", ""), $keyword);
972 $hashtags .= "#[url=".$a->get_baseurl()."/search?tag=".rawurlencode($hashtag)."]".$hashtag."[/url] ";
976 return("\n[class=type-".$data["type"]."]".$text."[/class]".$hashtags);
979 function query_page_info($url, $no_photos = false, $photo = "", $keywords = false, $keyword_blacklist = "") {
980 require_once("mod/parse_url.php");
982 $data = Cache::get("parse_url:".$url);
984 $data = parseurl_getsiteinfo($url, true);
985 Cache::set("parse_url:".$url,serialize($data));
987 $data = unserialize($data);
990 $data["images"][0]["src"] = $photo;
992 logger('fetch page info for '.$url.' '.print_r($data, true), LOGGER_DEBUG);
994 if (!$keywords AND isset($data["keywords"]))
995 unset($data["keywords"]);
997 if (($keyword_blacklist != "") AND isset($data["keywords"])) {
998 $list = explode(",", $keyword_blacklist);
999 foreach ($list AS $keyword) {
1000 $keyword = trim($keyword);
1001 $index = array_search($keyword, $data["keywords"]);
1002 if ($index !== false)
1003 unset($data["keywords"][$index]);
1010 function add_page_keywords($url, $no_photos = false, $photo = "", $keywords = false, $keyword_blacklist = "") {
1011 $data = query_page_info($url, $no_photos, $photo, $keywords, $keyword_blacklist);
1014 if (isset($data["keywords"]) AND count($data["keywords"])) {
1016 foreach ($data["keywords"] AS $keyword) {
1017 $hashtag = str_replace(array(" ", "+", "/", ".", "#", "'"),
1018 array("","", "", "", "", ""), $keyword);
1023 $tags .= "#[url=".$a->get_baseurl()."/search?tag=".rawurlencode($hashtag)."]".$hashtag."[/url]";
1030 function add_page_info($url, $no_photos = false, $photo = "", $keywords = false, $keyword_blacklist = "") {
1031 $data = query_page_info($url, $no_photos, $photo, $keywords, $keyword_blacklist);
1033 $text = add_page_info_data($data);
1038 function add_page_info_to_body($body, $texturl = false, $no_photos = false) {
1040 logger('add_page_info_to_body: fetch page info for body '.$body, LOGGER_DEBUG);
1042 $URLSearchString = "^\[\]";
1044 // Adding these spaces is a quick hack due to my problems with regular expressions :)
1045 preg_match("/[^!#@]\[url\]([$URLSearchString]*)\[\/url\]/ism", " ".$body, $matches);
1048 preg_match("/[^!#@]\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism", " ".$body, $matches);
1050 // Convert urls without bbcode elements
1051 if (!$matches AND $texturl) {
1052 preg_match("/([^\]\='".'"'."]|^)(https?\:\/\/[a-zA-Z0-9\:\/\-\?\&\;\.\=\_\~\#\%\$\!\+\,]+)/ism", " ".$body, $matches);
1054 // Yeah, a hack. I really hate regular expressions :)
1056 $matches[1] = $matches[2];
1060 $footer = add_page_info($matches[1], $no_photos);
1062 // Remove the link from the body if the link is attached at the end of the post
1063 if (isset($footer) AND (trim($footer) != "") AND (strpos($footer, $matches[1]))) {
1064 $removedlink = trim(str_replace($matches[1], "", $body));
1065 if (($removedlink == "") OR strstr($body, $removedlink))
1066 $body = $removedlink;
1068 $url = str_replace(array('/', '.'), array('\/', '\.'), $matches[1]);
1069 $removedlink = preg_replace("/\[url\=".$url."\](.*?)\[\/url\]/ism", '', $body);
1070 if (($removedlink == "") OR strstr($body, $removedlink))
1071 $body = $removedlink;
1074 // Add the page information to the bottom
1075 if (isset($footer) AND (trim($footer) != ""))
1081 function encode_rel_links($links) {
1083 if(! ((is_array($links)) && (count($links))))
1085 foreach($links as $link) {
1087 if($link['attribs']['']['rel'])
1088 $o .= 'rel="' . $link['attribs']['']['rel'] . '" ';
1089 if($link['attribs']['']['type'])
1090 $o .= 'type="' . $link['attribs']['']['type'] . '" ';
1091 if($link['attribs']['']['href'])
1092 $o .= 'href="' . $link['attribs']['']['href'] . '" ';
1093 if( (x($link['attribs'],NAMESPACE_MEDIA)) && $link['attribs'][NAMESPACE_MEDIA]['width'])
1094 $o .= 'media:width="' . $link['attribs'][NAMESPACE_MEDIA]['width'] . '" ';
1095 if( (x($link['attribs'],NAMESPACE_MEDIA)) && $link['attribs'][NAMESPACE_MEDIA]['height'])
1096 $o .= 'media:height="' . $link['attribs'][NAMESPACE_MEDIA]['height'] . '" ';
1097 $o .= ' />' . "\n" ;
1102 function add_guid($item) {
1103 $r = q("SELECT `guid` FROM `guid` WHERE `guid` = '%s' LIMIT 1", dbesc($item["guid"]));
1107 q("INSERT INTO `guid` (`guid`,`plink`,`uri`,`network`) VALUES ('%s','%s','%s','%s')",
1108 dbesc($item["guid"]), dbesc($item["plink"]),
1109 dbesc($item["uri"]), dbesc($item["network"]));
1112 function item_store($arr,$force_parent = false, $notify = false, $dontcache = false) {
1114 // If it is a posting where users should get notifications, then define it as wall posting
1117 $arr['type'] = 'wall';
1119 $arr['last-child'] = 1;
1120 $arr['network'] = NETWORK_DFRN;
1123 // If a Diaspora signature structure was passed in, pull it out of the
1124 // item array and set it aside for later storage.
1127 if(x($arr,'dsprsig')) {
1128 $dsprsig = json_decode(base64_decode($arr['dsprsig']));
1129 unset($arr['dsprsig']);
1132 // Converting the plink
1133 if ($arr['network'] == NETWORK_OSTATUS) {
1134 if (isset($arr['plink']))
1135 $arr['plink'] = ostatus_convert_href($arr['plink']);
1136 elseif (isset($arr['uri']))
1137 $arr['plink'] = ostatus_convert_href($arr['uri']);
1140 // if an OStatus conversation url was passed in, it is stored and then
1141 // removed from the array.
1142 $ostatus_conversation = null;
1144 if (isset($arr["ostatus_conversation"])) {
1145 $ostatus_conversation = $arr["ostatus_conversation"];
1146 unset($arr["ostatus_conversation"]);
1149 if(x($arr, 'gravity'))
1150 $arr['gravity'] = intval($arr['gravity']);
1151 elseif($arr['parent-uri'] === $arr['uri'])
1152 $arr['gravity'] = 0;
1153 elseif(activity_match($arr['verb'],ACTIVITY_POST))
1154 $arr['gravity'] = 6;
1156 $arr['gravity'] = 6; // extensible catchall
1158 if(! x($arr,'type'))
1159 $arr['type'] = 'remote';
1163 /* check for create date and expire time */
1164 $uid = intval($arr['uid']);
1165 $r = q("SELECT expire FROM user WHERE uid = %d", intval($uid));
1167 $expire_interval = $r[0]['expire'];
1168 if ($expire_interval>0) {
1169 $expire_date = new DateTime( '- '.$expire_interval.' days', new DateTimeZone('UTC'));
1170 $created_date = new DateTime($arr['created'], new DateTimeZone('UTC'));
1171 if ($created_date < $expire_date) {
1172 logger('item-store: item created ('.$arr['created'].') before expiration time ('.$expire_date->format(DateTime::W3C).'). ignored. ' . print_r($arr,true), LOGGER_DEBUG);
1178 // If there is no guid then take the same guid that was taken before for the same uri
1179 if ((trim($arr['guid']) == "") AND (trim($arr['uri']) != "") AND (trim($arr['network']) != "")) {
1180 logger('item_store: checking for an existing guid for uri '.$arr['uri'], LOGGER_DEBUG);
1181 $r = q("SELECT `guid` FROM `guid` WHERE `uri` = '%s' AND `network` = '%s' LIMIT 1",
1182 dbesc(trim($arr['uri'])), dbesc(trim($arr['network'])));
1185 $arr['guid'] = $r[0]["guid"];
1186 logger('item_store: found guid '.$arr['guid'].' for uri '.$arr['uri'], LOGGER_DEBUG);
1190 // If there is no guid then take the same guid that was taken before for the same plink
1191 if ((trim($arr['guid']) == "") AND (trim($arr['plink']) != "") AND (trim($arr['network']) != "")) {
1192 logger('item_store: checking for an existing guid for plink '.$arr['plink'], LOGGER_DEBUG);
1193 $r = q("SELECT `guid` FROM `guid` WHERE `plink` = '%s' AND `network` = '%s' LIMIT 1",
1194 dbesc(trim($arr['plink'])), dbesc(trim($arr['network'])));
1197 $arr['guid'] = $r[0]["guid"];
1198 logger('item_store: found guid '.$arr['guid'].' for plink '.$arr['plink'], LOGGER_DEBUG);
1202 // Shouldn't happen but we want to make absolutely sure it doesn't leak from a plugin.
1203 // Deactivated, since the bbcode parser can handle with it - and it destroys posts with some smileys that contain "<"
1204 //if((strpos($arr['body'],'<') !== false) || (strpos($arr['body'],'>') !== false))
1205 // $arr['body'] = strip_tags($arr['body']);
1208 if (version_compare(PHP_VERSION, '5.3.0', '>=')) {
1209 require_once('library/langdet/Text/LanguageDetect.php');
1210 $naked_body = preg_replace('/\[(.+?)\]/','',$arr['body']);
1211 $l = new Text_LanguageDetect;
1212 //$lng = $l->detectConfidence($naked_body);
1213 //$arr['postopts'] = (($lng['language']) ? 'lang=' . $lng['language'] . ';' . $lng['confidence'] : '');
1214 $lng = $l->detect($naked_body, 3);
1216 if (sizeof($lng) > 0) {
1219 foreach ($lng as $language => $score) {
1220 if ($postopts == "")
1221 $postopts = "lang=";
1225 $postopts .= $language.";".$score;
1227 $arr['postopts'] = $postopts;
1231 $arr['wall'] = ((x($arr,'wall')) ? intval($arr['wall']) : 0);
1232 $arr['uri'] = ((x($arr,'uri')) ? notags(trim($arr['uri'])) : random_string());
1233 $arr['extid'] = ((x($arr,'extid')) ? notags(trim($arr['extid'])) : '');
1234 $arr['author-name'] = ((x($arr,'author-name')) ? notags(trim($arr['author-name'])) : '');
1235 $arr['author-link'] = ((x($arr,'author-link')) ? notags(trim($arr['author-link'])) : '');
1236 $arr['author-avatar'] = ((x($arr,'author-avatar')) ? notags(trim($arr['author-avatar'])) : '');
1237 $arr['owner-name'] = ((x($arr,'owner-name')) ? notags(trim($arr['owner-name'])) : '');
1238 $arr['owner-link'] = ((x($arr,'owner-link')) ? notags(trim($arr['owner-link'])) : '');
1239 $arr['owner-avatar'] = ((x($arr,'owner-avatar')) ? notags(trim($arr['owner-avatar'])) : '');
1240 $arr['created'] = ((x($arr,'created') !== false) ? datetime_convert('UTC','UTC',$arr['created']) : datetime_convert());
1241 $arr['edited'] = ((x($arr,'edited') !== false) ? datetime_convert('UTC','UTC',$arr['edited']) : datetime_convert());
1242 $arr['commented'] = ((x($arr,'commented') !== false) ? datetime_convert('UTC','UTC',$arr['commented']) : datetime_convert());
1243 $arr['received'] = ((x($arr,'received') !== false) ? datetime_convert('UTC','UTC',$arr['received']) : datetime_convert());
1244 $arr['changed'] = ((x($arr,'changed') !== false) ? datetime_convert('UTC','UTC',$arr['changed']) : datetime_convert());
1245 $arr['title'] = ((x($arr,'title')) ? notags(trim($arr['title'])) : '');
1246 $arr['location'] = ((x($arr,'location')) ? notags(trim($arr['location'])) : '');
1247 $arr['coord'] = ((x($arr,'coord')) ? notags(trim($arr['coord'])) : '');
1248 $arr['last-child'] = ((x($arr,'last-child')) ? intval($arr['last-child']) : 0 );
1249 $arr['visible'] = ((x($arr,'visible') !== false) ? intval($arr['visible']) : 1 );
1250 $arr['deleted'] = 0;
1251 $arr['parent-uri'] = ((x($arr,'parent-uri')) ? notags(trim($arr['parent-uri'])) : '');
1252 $arr['verb'] = ((x($arr,'verb')) ? notags(trim($arr['verb'])) : '');
1253 $arr['object-type'] = ((x($arr,'object-type')) ? notags(trim($arr['object-type'])) : '');
1254 $arr['object'] = ((x($arr,'object')) ? trim($arr['object']) : '');
1255 $arr['target-type'] = ((x($arr,'target-type')) ? notags(trim($arr['target-type'])) : '');
1256 $arr['target'] = ((x($arr,'target')) ? trim($arr['target']) : '');
1257 $arr['plink'] = ((x($arr,'plink')) ? notags(trim($arr['plink'])) : '');
1258 $arr['allow_cid'] = ((x($arr,'allow_cid')) ? trim($arr['allow_cid']) : '');
1259 $arr['allow_gid'] = ((x($arr,'allow_gid')) ? trim($arr['allow_gid']) : '');
1260 $arr['deny_cid'] = ((x($arr,'deny_cid')) ? trim($arr['deny_cid']) : '');
1261 $arr['deny_gid'] = ((x($arr,'deny_gid')) ? trim($arr['deny_gid']) : '');
1262 $arr['private'] = ((x($arr,'private')) ? intval($arr['private']) : 0 );
1263 $arr['bookmark'] = ((x($arr,'bookmark')) ? intval($arr['bookmark']) : 0 );
1264 $arr['body'] = ((x($arr,'body')) ? trim($arr['body']) : '');
1265 $arr['tag'] = ((x($arr,'tag')) ? notags(trim($arr['tag'])) : '');
1266 $arr['attach'] = ((x($arr,'attach')) ? notags(trim($arr['attach'])) : '');
1267 $arr['app'] = ((x($arr,'app')) ? notags(trim($arr['app'])) : '');
1268 $arr['origin'] = ((x($arr,'origin')) ? intval($arr['origin']) : 0 );
1269 $arr['network'] = ((x($arr,'network')) ? trim($arr['network']) : '');
1270 $arr['guid'] = ((x($arr,'guid')) ? notags(trim($arr['guid'])) : get_guid(32, $arr['network']));
1271 $arr['postopts'] = ((x($arr,'postopts')) ? trim($arr['postopts']) : '');
1272 $arr['resource-id'] = ((x($arr,'resource-id')) ? trim($arr['resource-id']) : '');
1273 $arr['event-id'] = ((x($arr,'event-id')) ? intval($arr['event-id']) : 0 );
1274 $arr['inform'] = ((x($arr,'inform')) ? trim($arr['inform']) : '');
1275 $arr['file'] = ((x($arr,'file')) ? trim($arr['file']) : '');
1277 if ($arr['plink'] == "") {
1279 $arr['plink'] = $a->get_baseurl().'/display/'.urlencode($arr['guid']);
1282 if ($arr['network'] == "") {
1283 $r = q("SELECT `network` FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
1284 intval($arr['contact-id']),
1289 $arr['network'] = $r[0]["network"];
1291 // Fallback to friendica (why is it empty in some cases?)
1292 if ($arr['network'] == "")
1293 $arr['network'] = NETWORK_DFRN;
1295 logger("item_store: Set network to ".$arr["network"]." for ".$arr["uri"], LOGGER_DEBUG);
1298 if ($arr['guid'] != "") {
1299 // Checking if there is already an item with the same guid
1300 logger('checking for an item for user '.$arr['uid'].' on network '.$arr['network'].' with the guid '.$arr['guid'], LOGGER_DEBUG);
1301 $r = q("SELECT `guid` FROM `item` WHERE `guid` = '%s' AND `network` = '%s' AND `uid` = '%d' LIMIT 1",
1302 dbesc($arr['guid']), dbesc($arr['network']), intval($arr['uid']));
1305 logger('found item with guid '.$arr['guid'].' for user '.$arr['uid'].' on network '.$arr['network'], LOGGER_DEBUG);
1310 // Check for hashtags in the body and repair or add hashtag links
1311 item_body_set_hashtags($arr);
1313 $arr['thr-parent'] = $arr['parent-uri'];
1314 if($arr['parent-uri'] === $arr['uri']) {
1316 $parent_deleted = 0;
1317 $allow_cid = $arr['allow_cid'];
1318 $allow_gid = $arr['allow_gid'];
1319 $deny_cid = $arr['deny_cid'];
1320 $deny_gid = $arr['deny_gid'];
1321 $notify_type = 'wall-new';
1325 // find the parent and snarf the item id and ACLs
1326 // and anything else we need to inherit
1328 $r = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC LIMIT 1",
1329 dbesc($arr['parent-uri']),
1335 // is the new message multi-level threaded?
1336 // even though we don't support it now, preserve the info
1337 // and re-attach to the conversation parent.
1339 if($r[0]['uri'] != $r[0]['parent-uri']) {
1340 $arr['parent-uri'] = $r[0]['parent-uri'];
1341 $z = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `parent-uri` = '%s' AND `uid` = %d
1342 ORDER BY `id` ASC LIMIT 1",
1343 dbesc($r[0]['parent-uri']),
1344 dbesc($r[0]['parent-uri']),
1351 $parent_id = $r[0]['id'];
1352 $parent_deleted = $r[0]['deleted'];
1353 $allow_cid = $r[0]['allow_cid'];
1354 $allow_gid = $r[0]['allow_gid'];
1355 $deny_cid = $r[0]['deny_cid'];
1356 $deny_gid = $r[0]['deny_gid'];
1357 $arr['wall'] = $r[0]['wall'];
1358 $notify_type = 'comment-new';
1360 // if the parent is private, force privacy for the entire conversation
1361 // This differs from the above settings as it subtly allows comments from
1362 // email correspondents to be private even if the overall thread is not.
1364 if($r[0]['private'])
1365 $arr['private'] = $r[0]['private'];
1367 // Edge case. We host a public forum that was originally posted to privately.
1368 // The original author commented, but as this is a comment, the permissions
1369 // weren't fixed up so it will still show the comment as private unless we fix it here.
1371 if((intval($r[0]['forum_mode']) == 1) && (! $r[0]['private']))
1372 $arr['private'] = 0;
1375 // If its a post from myself then tag the thread as "mention"
1376 logger("item_store: Checking if parent ".$parent_id." has to be tagged as mention for user ".$arr['uid'], LOGGER_DEBUG);
1377 $u = q("select * from user where uid = %d limit 1", intval($arr['uid']));
1380 $self = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1381 logger("item_store: 'myself' is ".$self." for parent ".$parent_id." checking against ".$arr['author-link']." and ".$arr['owner-link'], LOGGER_DEBUG);
1382 if ((normalise_link($arr['author-link']) == $self) OR (normalise_link($arr['owner-link']) == $self)) {
1383 q("UPDATE `thread` SET `mention` = 1 WHERE `iid` = %d", intval($parent_id));
1384 logger("item_store: tagged thread ".$parent_id." as mention for user ".$self, LOGGER_DEBUG);
1390 // Allow one to see reply tweets from status.net even when
1391 // we don't have or can't see the original post.
1394 logger('item_store: $force_parent=true, reply converted to top-level post.');
1396 $arr['parent-uri'] = $arr['uri'];
1397 $arr['gravity'] = 0;
1400 logger('item_store: item parent was not found - ignoring item');
1404 $parent_deleted = 0;
1408 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `network` = '%s' AND `uid` = %d LIMIT 1",
1410 dbesc($arr['network']),
1413 if($r && count($r)) {
1414 logger('duplicated item with the same uri found. ' . print_r($arr,true));
1418 $r = q("SELECT `id` FROM `item` WHERE `plink` = '%s' AND `network` = '%s' AND `uid` = %d LIMIT 1",
1419 dbesc($arr['plink']),
1420 dbesc($arr['network']),
1423 if($r && count($r)) {
1424 logger('duplicated item with the same plink found. ' . print_r($arr,true));
1428 // Check for an existing post with the same content. There seems to be a problem with OStatus.
1429 $r = q("SELECT `id` FROM `item` WHERE `body` = '%s' AND `network` = '%s' AND `created` = '%s' AND `contact-id` = %d AND `uid` = %d LIMIT 1",
1430 dbesc($arr['body']),
1431 dbesc($arr['network']),
1432 dbesc($arr['created']),
1433 intval($arr['contact-id']),
1436 if($r && count($r)) {
1437 logger('duplicated item with the same body found. ' . print_r($arr,true));
1441 // Is this item available in the global items (with uid=0)?
1442 if ($arr["uid"] == 0) {
1443 $arr["global"] = true;
1445 q("UPDATE `item` SET `global` = 1 WHERE `guid` = '%s'", dbesc($arr["guid"]));
1447 $isglobal = q("SELECT `global` FROM `item` WHERE `uid` = 0 AND `guid` = '%s'", dbesc($arr["guid"]));
1449 $arr["global"] = (count($isglobal) > 0);
1452 // Fill the cache field
1453 put_item_in_cache($arr);
1455 call_hooks('post_remote',$arr);
1457 if(x($arr,'cancel')) {
1458 logger('item_store: post cancelled by plugin.');
1462 // Store the unescaped version
1467 logger('item_store: ' . print_r($arr,true), LOGGER_DATA);
1469 $r = dbq("INSERT INTO `item` (`"
1470 . implode("`, `", array_keys($arr))
1472 . implode("', '", array_values($arr))
1478 // find the item we just created
1479 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC ",
1486 // Store the guid and other relevant data
1489 $current_post = $r[0]['id'];
1490 logger('item_store: created item ' . $current_post);
1492 // Set "success_update" and "last-item" to the date of the last time we heard from this contact
1493 // This can be used to filter for inactive contacts.
1494 // Only do this for public postings to avoid privacy problems, since poco data is public.
1495 // Don't set this value if it isn't from the owner (could be an author that we don't know)
1497 $update = (!$arr['private'] AND (($arr["author-link"] === $arr["owner-link"]) OR ($arr["parent-uri"] === $arr["uri"])));
1499 // Is it a forum? Then we don't care about the rules from above
1500 if (!$update AND ($arr["network"] == NETWORK_DFRN) AND ($arr["parent-uri"] === $arr["uri"])) {
1501 $isforum = q("SELECT `forum` FROM `contact` WHERE `id` = %d AND `forum`",
1502 intval($arr['contact-id']));
1508 q("UPDATE `contact` SET `success_update` = '%s', `last-item` = '%s' WHERE `id` = %d",
1509 dbesc($arr['received']),
1510 dbesc($arr['received']),
1511 intval($arr['contact-id'])
1514 logger('item_store: could not locate created item');
1518 logger('item_store: duplicated post occurred. Removing duplicates. uri = '.$arr['uri'].' uid = '.$arr['uid']);
1519 q("DELETE FROM `item` WHERE `uri` = '%s' AND `uid` = %d AND `id` != %d ",
1521 intval($arr['uid']),
1522 intval($current_post)
1526 if((! $parent_id) || ($arr['parent-uri'] === $arr['uri']))
1527 $parent_id = $current_post;
1529 if(strlen($allow_cid) || strlen($allow_gid) || strlen($deny_cid) || strlen($deny_gid))
1532 $private = $arr['private'];
1534 // Set parent id - and also make sure to inherit the parent's ACLs.
1536 $r = q("UPDATE `item` SET `parent` = %d, `allow_cid` = '%s', `allow_gid` = '%s',
1537 `deny_cid` = '%s', `deny_gid` = '%s', `private` = %d, `deleted` = %d WHERE `id` = %d",
1544 intval($parent_deleted),
1545 intval($current_post)
1548 // Complete ostatus threads
1549 if ($ostatus_conversation)
1550 complete_conversation($current_post, $ostatus_conversation);
1552 $arr['id'] = $current_post;
1553 $arr['parent'] = $parent_id;
1554 $arr['allow_cid'] = $allow_cid;
1555 $arr['allow_gid'] = $allow_gid;
1556 $arr['deny_cid'] = $deny_cid;
1557 $arr['deny_gid'] = $deny_gid;
1558 $arr['private'] = $private;
1559 $arr['deleted'] = $parent_deleted;
1561 // update the commented timestamp on the parent
1562 // Only update "commented" if it is really a comment
1563 if (($arr['verb'] == ACTIVITY_POST) OR !get_config("system", "like_no_comment"))
1564 q("UPDATE `item` SET `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
1565 dbesc(datetime_convert()),
1566 dbesc(datetime_convert()),
1570 q("UPDATE `item` SET `changed` = '%s' WHERE `id` = %d",
1571 dbesc(datetime_convert()),
1576 q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
1577 intval($current_post),
1578 dbesc($dsprsig->signed_text),
1579 dbesc($dsprsig->signature),
1580 dbesc($dsprsig->signer)
1586 * If this is now the last-child, force all _other_ children of this parent to *not* be last-child
1589 if($arr['last-child']) {
1590 $r = q("UPDATE `item` SET `last-child` = 0 WHERE `parent-uri` = '%s' AND `uid` = %d AND `id` != %d",
1592 intval($arr['uid']),
1593 intval($current_post)
1597 $deleted = tag_deliver($arr['uid'],$current_post);
1599 // current post can be deleted if is for a community page and no mention are
1601 if (!$deleted AND !$dontcache) {
1603 $r = q('SELECT * FROM `item` WHERE id = %d', intval($current_post));
1604 if (count($r) == 1) {
1605 call_hooks('post_remote_end', $r[0]);
1607 logger('item_store: new item not found in DB, id ' . $current_post);
1610 // Add every contact of the post to the global contact table
1613 create_tags_from_item($current_post);
1614 create_files_from_item($current_post);
1616 // Only check for notifications on start posts
1617 if ($arr['parent-uri'] === $arr['uri']) {
1618 add_thread($current_post);
1619 logger('item_store: Check notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1621 // Send a notification for every new post?
1622 $r = q("SELECT `notify_new_posts` FROM `contact` WHERE `id` = %d AND `uid` = %d AND `notify_new_posts` LIMIT 1",
1623 intval($arr['contact-id']),
1626 $send_notification = count($r);
1628 if (!$send_notification) {
1629 $tags = q("SELECT `url` FROM `term` WHERE `otype` = %d AND `oid` = %d AND `type` = %d AND `uid` = %d",
1630 intval(TERM_OBJ_POST), intval($current_post), intval(TERM_MENTION), intval($arr['uid']));
1633 foreach ($tags AS $tag) {
1634 $r = q("SELECT `id` FROM `contact` WHERE `nurl` = '%s' AND `uid` = %d AND `notify_new_posts`",
1635 normalise_link($tag["url"]), intval($arr['uid']));
1637 $send_notification = true;
1642 if ($send_notification) {
1643 logger('item_store: Send notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1644 $u = q("SELECT * FROM user WHERE uid = %d LIMIT 1",
1645 intval($arr['uid']));
1647 $item = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d",
1648 intval($current_post),
1654 require_once('include/enotify.php');
1656 'type' => NOTIFY_SHARE,
1657 'notify_flags' => $u[0]['notify-flags'],
1658 'language' => $u[0]['language'],
1659 'to_name' => $u[0]['username'],
1660 'to_email' => $u[0]['email'],
1661 'uid' => $u[0]['uid'],
1663 'link' => $a->get_baseurl().'/display/'.urlencode($arr['guid']),
1664 'source_name' => $item[0]['author-name'],
1665 'source_link' => $item[0]['author-link'],
1666 'source_photo' => $item[0]['author-avatar'],
1667 'verb' => ACTIVITY_TAG,
1669 'parent' => $arr['parent']
1671 logger('item_store: Notification sent for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1674 update_thread($parent_id);
1675 add_shadow_entry($arr);
1679 proc_run('php', "include/notifier.php", $notify_type, $current_post);
1681 return $current_post;
1684 function item_body_set_hashtags(&$item) {
1686 $tags = get_tags($item["body"]);
1692 // This sorting is important when there are hashtags that are part of other hashtags
1693 // Otherwise there could be problems with hashtags like #test and #test2
1698 $URLSearchString = "^\[\]";
1700 // All hashtags should point to the home server
1701 //$item["body"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1702 // "#[url=".$a->get_baseurl()."/search?tag=$2]$2[/url]", $item["body"]);
1704 //$item["tag"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1705 // "#[url=".$a->get_baseurl()."/search?tag=$2]$2[/url]", $item["tag"]);
1707 // mask hashtags inside of url, bookmarks and attachments to avoid urls in urls
1708 $item["body"] = preg_replace_callback("/\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1710 return("[url=".$match[1]."]".str_replace("#", "#", $match[2])."[/url]");
1713 $item["body"] = preg_replace_callback("/\[bookmark\=([$URLSearchString]*)\](.*?)\[\/bookmark\]/ism",
1715 return("[bookmark=".$match[1]."]".str_replace("#", "#", $match[2])."[/bookmark]");
1718 $item["body"] = preg_replace_callback("/\[attachment (.*)\](.*?)\[\/attachment\]/ism",
1720 return("[attachment ".str_replace("#", "#", $match[1])."]".$match[2]."[/attachment]");
1723 // Repair recursive urls
1724 $item["body"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1725 "#$2", $item["body"]);
1727 foreach($tags as $tag) {
1728 if(strpos($tag,'#') !== 0)
1731 if(strpos($tag,'[url='))
1734 $basetag = str_replace('_',' ',substr($tag,1));
1736 $newtag = '#[url='.$a->get_baseurl().'/search?tag='.rawurlencode($basetag).']'.$basetag.'[/url]';
1738 $item["body"] = str_replace($tag, $newtag, $item["body"]);
1740 if(!stristr($item["tag"],"/search?tag=".$basetag."]".$basetag."[/url]")) {
1741 if(strlen($item["tag"]))
1742 $item["tag"] = ','.$item["tag"];
1743 $item["tag"] = $newtag.$item["tag"];
1747 // Convert back the masked hashtags
1748 $item["body"] = str_replace("#", "#", $item["body"]);
1751 function get_item_guid($id) {
1752 $r = q("SELECT `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($id));
1754 return($r[0]["guid"]);
1759 function get_item_id($guid, $uid = 0) {
1765 $uid == local_user();
1767 // Does the given user have this item?
1769 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1770 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1771 AND `item`.`guid` = '%s' AND `item`.`uid` = %d", dbesc($guid), intval($uid));
1774 $nick = $r[0]["nickname"];
1778 // Or is it anywhere on the server?
1780 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1781 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1782 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = ''
1783 AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
1784 AND `item`.`private` = 0 AND `item`.`wall` = 1
1785 AND `item`.`guid` = '%s'", dbesc($guid));
1788 $nick = $r[0]["nickname"];
1791 return(array("nick" => $nick, "id" => $id));
1795 function get_item_contact($item,$contacts) {
1796 if(! count($contacts) || (! is_array($item)))
1798 foreach($contacts as $contact) {
1799 if($contact['id'] == $item['contact-id']) {
1801 break; // NOTREACHED
1808 * look for mention tags and setup a second delivery chain for forum/community posts if appropriate
1810 * @param int $item_id
1811 * @return bool true if item was deleted, else false
1813 function tag_deliver($uid,$item_id) {
1821 $u = q("select * from user where uid = %d limit 1",
1827 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1828 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1831 $i = q("select * from item where id = %d and uid = %d limit 1",
1840 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1842 // Diaspora uses their own hardwired link URL in @-tags
1843 // instead of the one we supply with webfinger
1845 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1847 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1849 foreach($matches as $mtch) {
1850 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1852 logger('tag_deliver: mention found: ' . $mtch[2]);
1858 if ( ($community_page || $prvgroup) &&
1859 (!$item['wall']) && (!$item['origin']) && ($item['id'] == $item['parent'])){
1860 // mmh.. no mention.. community page or private group... no wall.. no origin.. top-post (not a comment)
1862 logger("tag_deliver: no-mention top-level post to communuty or private group. delete.");
1863 q("DELETE FROM item WHERE id = %d and uid = %d",
1873 // send a notification
1875 // use a local photo if we have one
1877 $r = q("select * from contact where uid = %d and nurl = '%s' limit 1",
1878 intval($u[0]['uid']),
1879 dbesc(normalise_link($item['author-link']))
1881 $photo = (($r && count($r)) ? $r[0]['thumb'] : $item['author-avatar']);
1884 require_once('include/enotify.php');
1886 'type' => NOTIFY_TAGSELF,
1887 'notify_flags' => $u[0]['notify-flags'],
1888 'language' => $u[0]['language'],
1889 'to_name' => $u[0]['username'],
1890 'to_email' => $u[0]['email'],
1891 'uid' => $u[0]['uid'],
1893 'link' => $a->get_baseurl() . '/display/'.urlencode(get_item_guid($item['id'])),
1894 'source_name' => $item['author-name'],
1895 'source_link' => $item['author-link'],
1896 'source_photo' => $photo,
1897 'verb' => ACTIVITY_TAG,
1899 'parent' => $item['parent']
1903 $arr = array('item' => $item, 'user' => $u[0], 'contact' => $r[0]);
1905 call_hooks('tagged', $arr);
1907 if((! $community_page) && (! $prvgroup))
1911 // tgroup delivery - setup a second delivery chain
1912 // prevent delivery looping - only proceed
1913 // if the message originated elsewhere and is a top-level post
1915 if(($item['wall']) || ($item['origin']) || ($item['id'] != $item['parent']))
1918 // now change this copy of the post to a forum head message and deliver to all the tgroup members
1921 $c = q("select name, url, thumb from contact where self = 1 and uid = %d limit 1",
1922 intval($u[0]['uid'])
1927 // also reset all the privacy bits to the forum default permissions
1929 $private = ($u[0]['allow_cid'] || $u[0]['allow_gid'] || $u[0]['deny_cid'] || $u[0]['deny_gid']) ? 1 : 0;
1931 $forum_mode = (($prvgroup) ? 2 : 1);
1933 q("update item set wall = 1, origin = 1, forum_mode = %d, `owner-name` = '%s', `owner-link` = '%s', `owner-avatar` = '%s',
1934 `private` = %d, `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s' where id = %d",
1935 intval($forum_mode),
1936 dbesc($c[0]['name']),
1937 dbesc($c[0]['url']),
1938 dbesc($c[0]['thumb']),
1940 dbesc($u[0]['allow_cid']),
1941 dbesc($u[0]['allow_gid']),
1942 dbesc($u[0]['deny_cid']),
1943 dbesc($u[0]['deny_gid']),
1946 update_thread($item_id);
1948 proc_run('php','include/notifier.php','tgroup',$item_id);
1954 function tgroup_check($uid,$item) {
1960 // check that the message originated elsewhere and is a top-level post
1962 if(($item['wall']) || ($item['origin']) || ($item['uri'] != $item['parent-uri']))
1966 $u = q("select * from user where uid = %d limit 1",
1972 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1973 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1976 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1978 // Diaspora uses their own hardwired link URL in @-tags
1979 // instead of the one we supply with webfinger
1981 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1983 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1985 foreach($matches as $mtch) {
1986 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1988 logger('tgroup_check: mention found: ' . $mtch[2]);
1996 if((! $community_page) && (! $prvgroup))
2010 function dfrn_deliver($owner,$contact,$atom, $dissolve = false) {
2014 $idtosend = $orig_id = (($contact['dfrn-id']) ? $contact['dfrn-id'] : $contact['issued-id']);
2016 if($contact['duplex'] && $contact['dfrn-id'])
2017 $idtosend = '0:' . $orig_id;
2018 if($contact['duplex'] && $contact['issued-id'])
2019 $idtosend = '1:' . $orig_id;
2021 $rino = ((function_exists('mcrypt_encrypt')) ? 1 : 0);
2023 $rino_enable = get_config('system','rino_encrypt');
2028 $ssl_val = intval(get_config('system','ssl_policy'));
2032 case SSL_POLICY_FULL:
2033 $ssl_policy = 'full';
2035 case SSL_POLICY_SELFSIGN:
2036 $ssl_policy = 'self';
2038 case SSL_POLICY_NONE:
2040 $ssl_policy = 'none';
2044 $url = $contact['notify'] . '&dfrn_id=' . $idtosend . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . (($rino) ? '&rino=1' : '');
2046 logger('dfrn_deliver: ' . $url);
2048 $xml = fetch_url($url);
2050 $curl_stat = $a->get_curl_code();
2052 return(-1); // timed out
2054 logger('dfrn_deliver: ' . $xml, LOGGER_DATA);
2059 if(strpos($xml,'<?xml') === false) {
2060 logger('dfrn_deliver: no valid XML returned');
2061 logger('dfrn_deliver: returned XML: ' . $xml, LOGGER_DATA);
2065 $res = parse_xml_string($xml);
2067 if((intval($res->status) != 0) || (! strlen($res->challenge)) || (! strlen($res->dfrn_id)))
2068 return (($res->status) ? $res->status : 3);
2070 $postvars = array();
2071 $sent_dfrn_id = hex2bin((string) $res->dfrn_id);
2072 $challenge = hex2bin((string) $res->challenge);
2073 $perm = (($res->perm) ? $res->perm : null);
2074 $dfrn_version = (float) (($res->dfrn_version) ? $res->dfrn_version : 2.0);
2075 $rino_allowed = ((intval($res->rino) === 1) ? 1 : 0);
2076 $page = (($owner['page-flags'] == PAGE_COMMUNITY) ? 1 : 0);
2078 if($owner['page-flags'] == PAGE_PRVGROUP)
2081 $final_dfrn_id = '';
2084 if((($perm == 'rw') && (! intval($contact['writable'])))
2085 || (($perm == 'r') && (intval($contact['writable'])))) {
2086 q("update contact set writable = %d where id = %d",
2087 intval(($perm == 'rw') ? 1 : 0),
2088 intval($contact['id'])
2090 $contact['writable'] = (string) 1 - intval($contact['writable']);
2094 if(($contact['duplex'] && strlen($contact['pubkey']))
2095 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
2096 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
2097 openssl_public_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['pubkey']);
2098 openssl_public_decrypt($challenge,$postvars['challenge'],$contact['pubkey']);
2101 openssl_private_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['prvkey']);
2102 openssl_private_decrypt($challenge,$postvars['challenge'],$contact['prvkey']);
2105 $final_dfrn_id = substr($final_dfrn_id, 0, strpos($final_dfrn_id, '.'));
2107 if(strpos($final_dfrn_id,':') == 1)
2108 $final_dfrn_id = substr($final_dfrn_id,2);
2110 if($final_dfrn_id != $orig_id) {
2111 logger('dfrn_deliver: wrong dfrn_id.');
2112 // did not decode properly - cannot trust this site
2116 $postvars['dfrn_id'] = $idtosend;
2117 $postvars['dfrn_version'] = DFRN_PROTOCOL_VERSION;
2119 $postvars['dissolve'] = '1';
2122 if((($contact['rel']) && ($contact['rel'] != CONTACT_IS_SHARING) && (! $contact['blocked'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
2123 $postvars['data'] = $atom;
2124 $postvars['perm'] = 'rw';
2127 $postvars['data'] = str_replace('<dfrn:comment-allow>1','<dfrn:comment-allow>0',$atom);
2128 $postvars['perm'] = 'r';
2131 $postvars['ssl_policy'] = $ssl_policy;
2134 $postvars['page'] = $page;
2136 if($rino && $rino_allowed && (! $dissolve)) {
2137 $key = substr(random_string(),0,16);
2138 $data = bin2hex(aes_encrypt($postvars['data'],$key));
2139 $postvars['data'] = $data;
2140 logger('rino: sent key = ' . $key, LOGGER_DEBUG);
2143 if($dfrn_version >= 2.1) {
2144 if(($contact['duplex'] && strlen($contact['pubkey']))
2145 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
2146 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
2148 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
2151 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
2155 if(($contact['duplex'] && strlen($contact['prvkey'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
2156 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
2159 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
2163 logger('md5 rawkey ' . md5($postvars['key']));
2165 $postvars['key'] = bin2hex($postvars['key']);
2168 logger('dfrn_deliver: ' . "SENDING: " . print_r($postvars,true), LOGGER_DATA);
2170 $xml = post_url($contact['notify'],$postvars);
2172 logger('dfrn_deliver: ' . "RECEIVED: " . $xml, LOGGER_DATA);
2174 $curl_stat = $a->get_curl_code();
2175 if((! $curl_stat) || (! strlen($xml)))
2176 return(-1); // timed out
2178 if(($curl_stat == 503) && (stristr($a->get_curl_headers(),'retry-after')))
2181 if(strpos($xml,'<?xml') === false) {
2182 logger('dfrn_deliver: phase 2: no valid XML returned');
2183 logger('dfrn_deliver: phase 2: returned XML: ' . $xml, LOGGER_DATA);
2187 if($contact['term-date'] != '0000-00-00 00:00:00') {
2188 logger("dfrn_deliver: $url back from the dead - removing mark for death");
2189 require_once('include/Contact.php');
2190 unmark_for_death($contact);
2193 $res = parse_xml_string($xml);
2195 return $res->status;
2200 This function returns true if $update has an edited timestamp newer
2201 than $existing, i.e. $update contains new data which should override
2202 what's already there. If there is no timestamp yet, the update is
2203 assumed to be newer. If the update has no timestamp, the existing
2204 item is assumed to be up-to-date. If the timestamps are equal it
2205 assumes the update has been seen before and should be ignored.
2207 function edited_timestamp_is_newer($existing, $update) {
2208 if (!x($existing,'edited') || !$existing['edited']) {
2211 if (!x($update,'edited') || !$update['edited']) {
2214 $existing_edited = datetime_convert('UTC', 'UTC', $existing['edited']);
2215 $update_edited = datetime_convert('UTC', 'UTC', $update['edited']);
2216 return (strcmp($existing_edited, $update_edited) < 0);
2221 * consume_feed - process atom feed and update anything/everything we might need to update
2223 * $xml = the (atom) feed to consume - RSS isn't as fully supported but may work for simple feeds.
2225 * $importer = the contact_record (joined to user_record) of the local user who owns this relationship.
2226 * It is this person's stuff that is going to be updated.
2227 * $contact = the person who is sending us stuff. If not set, we MAY be processing a "follow" activity
2228 * from an external network and MAY create an appropriate contact record. Otherwise, we MUST
2229 * have a contact record.
2230 * $hub = should we find a hub declation in the feed, pass it back to our calling process, who might (or
2231 * might not) try and subscribe to it.
2232 * $datedir sorts in reverse order
2233 * $pass - by default ($pass = 0) we cannot guarantee that a parent item has been
2234 * imported prior to its children being seen in the stream unless we are certain
2235 * of how the feed is arranged/ordered.
2236 * With $pass = 1, we only pull parent items out of the stream.
2237 * With $pass = 2, we only pull children (comments/likes).
2239 * So running this twice, first with pass 1 and then with pass 2 will do the right
2240 * thing regardless of feed ordering. This won't be adequate in a fully-threaded
2241 * model where comments can have sub-threads. That would require some massive sorting
2242 * to get all the feed items into a mostly linear ordering, and might still require
2246 function consume_feed($xml,$importer,&$contact, &$hub, $datedir = 0, $pass = 0) {
2248 require_once('library/simplepie/simplepie.inc');
2249 require_once('include/contact_selectors.php');
2251 if(! strlen($xml)) {
2252 logger('consume_feed: empty input');
2256 // Test - remove before flight
2257 // if ($contact['network'] === NETWORK_OSTATUS) {
2258 // $tempfile = tempnam(get_temppath(), "ostatus");
2259 // file_put_contents($tempfile, $xml);
2262 $feed = new SimplePie();
2263 $feed->set_raw_data($xml);
2265 $feed->enable_order_by_date(true);
2267 $feed->enable_order_by_date(false);
2271 logger('consume_feed: Error parsing XML: ' . $feed->error());
2273 $permalink = $feed->get_permalink();
2275 // Check at the feed level for updated contact name and/or photo
2279 $photo_timestamp = '';
2282 $contact_updated = '';
2284 $hubs = $feed->get_links('hub');
2285 logger('consume_feed: hubs: ' . print_r($hubs,true), LOGGER_DATA);
2288 $hub = implode(',', $hubs);
2290 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2292 $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2294 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2295 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2296 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2297 $new_name = $elems['name'][0]['data'];
2299 // Manually checking for changed contact names
2300 if (($new_name != $contact['name']) AND ($new_name != "") AND ($name_updated <= $contact['name-date'])) {
2301 $name_updated = date("c");
2302 $photo_timestamp = date("c");
2305 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2306 if ($photo_timestamp == "")
2307 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2308 $photo_url = $elems['link'][0]['attribs']['']['href'];
2311 if((x($rawtags[0]['child'], NAMESPACE_DFRN)) && (x($rawtags[0]['child'][NAMESPACE_DFRN],'birthday'))) {
2312 $birthday = datetime_convert('UTC','UTC', $rawtags[0]['child'][NAMESPACE_DFRN]['birthday'][0]['data']);
2316 if((is_array($contact)) && ($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $contact['avatar-date'])) {
2317 logger('consume_feed: Updating photo for '.$contact['name'].' from '.$photo_url.' uid: '.$contact['uid']);
2319 $contact_updated = $photo_timestamp;
2321 require_once("include/Photo.php");
2322 $photo_failure = false;
2323 $have_photo = false;
2325 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2326 intval($contact['id']),
2327 intval($contact['uid'])
2330 $resource_id = $r[0]['resource-id'];
2334 $resource_id = photo_new_resource();
2337 $img_str = fetch_url($photo_url,true);
2338 // guess mimetype from headers or filename
2339 $type = guess_image_type($photo_url,true);
2342 $img = new Photo($img_str, $type);
2343 if($img->is_valid()) {
2345 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2346 dbesc($resource_id),
2347 intval($contact['id']),
2348 intval($contact['uid'])
2352 $img->scaleImageSquare(175);
2354 $hash = $resource_id;
2355 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2357 $img->scaleImage(80);
2358 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2360 $img->scaleImage(48);
2361 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2365 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2366 WHERE `uid` = %d AND `id` = %d",
2367 dbesc(datetime_convert()),
2368 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2369 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2370 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2371 intval($contact['uid']),
2372 intval($contact['id'])
2377 if((is_array($contact)) && ($name_updated) && (strlen($new_name)) && ($name_updated > $contact['name-date'])) {
2378 if ($name_updated > $contact_updated)
2379 $contact_updated = $name_updated;
2381 $r = q("select * from contact where uid = %d and id = %d limit 1",
2382 intval($contact['uid']),
2383 intval($contact['id'])
2386 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2387 dbesc(notags(trim($new_name))),
2388 dbesc(datetime_convert()),
2389 intval($contact['uid']),
2390 intval($contact['id'])
2393 // do our best to update the name on content items
2396 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2397 dbesc(notags(trim($new_name))),
2398 dbesc($r[0]['name']),
2399 dbesc($r[0]['url']),
2400 intval($contact['uid'])
2405 if ($contact_updated AND $new_name AND $photo_url)
2406 poco_check($contact['url'], $new_name, NETWORK_DFRN, $photo_url, "", "", "", "", "", $contact_updated, 2, $contact['id'], $contact['uid']);
2408 if(strlen($birthday)) {
2409 if(substr($birthday,0,4) != $contact['bdyear']) {
2410 logger('consume_feed: updating birthday: ' . $birthday);
2414 * Add new birthday event for this person
2416 * $bdtext is just a readable placeholder in case the event is shared
2417 * with others. We will replace it during presentation to our $importer
2418 * to contain a sparkle link and perhaps a photo.
2422 $bdtext = sprintf( t('%s\'s birthday'), $contact['name']);
2423 $bdtext2 = sprintf( t('Happy Birthday %s'), ' [url=' . $contact['url'] . ']' . $contact['name'] . '[/url]' ) ;
2426 $r = q("INSERT INTO `event` (`uid`,`cid`,`created`,`edited`,`start`,`finish`,`summary`,`desc`,`type`)
2427 VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) ",
2428 intval($contact['uid']),
2429 intval($contact['id']),
2430 dbesc(datetime_convert()),
2431 dbesc(datetime_convert()),
2432 dbesc(datetime_convert('UTC','UTC', $birthday)),
2433 dbesc(datetime_convert('UTC','UTC', $birthday . ' + 1 day ')),
2442 q("UPDATE `contact` SET `bdyear` = '%s' WHERE `uid` = %d AND `id` = %d",
2443 dbesc(substr($birthday,0,4)),
2444 intval($contact['uid']),
2445 intval($contact['id'])
2448 // This function is called twice without reloading the contact
2449 // Make sure we only create one event. This is why &$contact
2450 // is a reference var in this function
2452 $contact['bdyear'] = substr($birthday,0,4);
2456 $community_page = 0;
2457 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2459 $community_page = intval($rawtags[0]['data']);
2461 if(is_array($contact) && intval($contact['forum']) != $community_page) {
2462 q("update contact set forum = %d where id = %d",
2463 intval($community_page),
2464 intval($contact['id'])
2466 $contact['forum'] = (string) $community_page;
2470 // process any deleted entries
2472 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2473 if(is_array($del_entries) && count($del_entries) && $pass != 2) {
2474 foreach($del_entries as $dentry) {
2476 if(isset($dentry['attribs']['']['ref'])) {
2477 $uri = $dentry['attribs']['']['ref'];
2479 if(isset($dentry['attribs']['']['when'])) {
2480 $when = $dentry['attribs']['']['when'];
2481 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2484 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2486 if($deleted && is_array($contact)) {
2487 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN `contact` on `item`.`contact-id` = `contact`.`id`
2488 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
2490 intval($importer['uid']),
2491 intval($contact['id'])
2496 if(! $item['deleted'])
2497 logger('consume_feed: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
2499 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2500 $xo = parse_xml_string($item['object'],false);
2501 $xt = parse_xml_string($item['target'],false);
2502 if($xt->type === ACTIVITY_OBJ_NOTE) {
2503 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
2505 intval($importer['importer_uid'])
2509 // For tags, the owner cannot remove the tag on the author's copy of the post.
2511 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
2512 $author_remove = (($item['origin'] && $item['self']) ? true : false);
2513 $author_copy = (($item['origin']) ? true : false);
2515 if($owner_remove && $author_copy)
2517 if($author_remove || $owner_remove) {
2518 $tags = explode(',',$i[0]['tag']);
2521 foreach($tags as $tag)
2522 if(trim($tag) !== trim($xo->body))
2523 $newtags[] = trim($tag);
2525 q("update item set tag = '%s' where id = %d",
2526 dbesc(implode(',',$newtags)),
2529 create_tags_from_item($i[0]['id']);
2535 if($item['uri'] == $item['parent-uri']) {
2536 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2537 `body` = '', `title` = ''
2538 WHERE `parent-uri` = '%s' AND `uid` = %d",
2540 dbesc(datetime_convert()),
2541 dbesc($item['uri']),
2542 intval($importer['uid'])
2544 create_tags_from_itemuri($item['uri'], $importer['uid']);
2545 create_files_from_itemuri($item['uri'], $importer['uid']);
2546 update_thread_uri($item['uri'], $importer['uid']);
2549 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2550 `body` = '', `title` = ''
2551 WHERE `uri` = '%s' AND `uid` = %d",
2553 dbesc(datetime_convert()),
2555 intval($importer['uid'])
2557 create_tags_from_itemuri($uri, $importer['uid']);
2558 create_files_from_itemuri($uri, $importer['uid']);
2559 if($item['last-child']) {
2560 // ensure that last-child is set in case the comment that had it just got wiped.
2561 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
2562 dbesc(datetime_convert()),
2563 dbesc($item['parent-uri']),
2564 intval($item['uid'])
2566 // who is the last child now?
2567 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `moderated` = 0 AND `uid` = %d
2568 ORDER BY `created` DESC LIMIT 1",
2569 dbesc($item['parent-uri']),
2570 intval($importer['uid'])
2573 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
2584 // Now process the feed
2586 if($feed->get_item_quantity()) {
2588 logger('consume_feed: feed item count = ' . $feed->get_item_quantity());
2590 // in inverse date order
2592 $items = array_reverse($feed->get_items());
2594 $items = $feed->get_items();
2597 foreach($items as $item) {
2600 $item_id = $item->get_id();
2601 $rawthread = $item->get_item_tags( NAMESPACE_THREAD,'in-reply-to');
2602 if(isset($rawthread[0]['attribs']['']['ref'])) {
2604 $parent_uri = $rawthread[0]['attribs']['']['ref'];
2607 if(($is_reply) && is_array($contact)) {
2612 // not allowed to post
2614 if($contact['rel'] == CONTACT_IS_FOLLOWER)
2618 // Have we seen it? If not, import it.
2620 $item_id = $item->get_id();
2621 $datarray = get_atom_elements($feed, $item, $contact);
2623 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2624 $datarray['author-name'] = $contact['name'];
2625 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2626 $datarray['author-link'] = $contact['url'];
2627 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2628 $datarray['author-avatar'] = $contact['thumb'];
2630 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2631 logger('consume_feed: no author information! ' . print_r($datarray,true));
2635 $force_parent = false;
2636 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2637 if($contact['network'] === NETWORK_OSTATUS)
2638 $force_parent = true;
2639 if(strlen($datarray['title']))
2640 unset($datarray['title']);
2641 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2642 dbesc(datetime_convert()),
2644 intval($importer['uid'])
2646 $datarray['last-child'] = 1;
2647 update_thread_uri($parent_uri, $importer['uid']);
2651 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2653 intval($importer['uid'])
2656 // Update content if 'updated' changes
2659 if (edited_timestamp_is_newer($r[0], $datarray)) {
2661 // do not accept (ignore) an earlier edit than one we currently have.
2662 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2665 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2666 dbesc($datarray['title']),
2667 dbesc($datarray['body']),
2668 dbesc($datarray['tag']),
2669 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2670 dbesc(datetime_convert()),
2672 intval($importer['uid'])
2674 create_tags_from_itemuri($item_id, $importer['uid']);
2675 update_thread_uri($item_id, $importer['uid']);
2678 // update last-child if it changes
2680 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2681 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
2682 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2683 dbesc(datetime_convert()),
2685 intval($importer['uid'])
2687 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2688 intval($allow[0]['data']),
2689 dbesc(datetime_convert()),
2691 intval($importer['uid'])
2693 update_thread_uri($item_id, $importer['uid']);
2699 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2700 // one way feed - no remote comment ability
2701 $datarray['last-child'] = 0;
2703 $datarray['parent-uri'] = $parent_uri;
2704 $datarray['uid'] = $importer['uid'];
2705 $datarray['contact-id'] = $contact['id'];
2706 if((activity_match($datarray['verb'],ACTIVITY_LIKE)) || (activity_match($datarray['verb'],ACTIVITY_DISLIKE))) {
2707 $datarray['type'] = 'activity';
2708 $datarray['gravity'] = GRAVITY_LIKE;
2709 // only one like or dislike per person
2710 // splitted into two queries for performance issues
2711 $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",
2712 intval($datarray['uid']),
2713 intval($datarray['contact-id']),
2714 dbesc($datarray['verb']),
2720 $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",
2721 intval($datarray['uid']),
2722 intval($datarray['contact-id']),
2723 dbesc($datarray['verb']),
2730 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2731 $xo = parse_xml_string($datarray['object'],false);
2732 $xt = parse_xml_string($datarray['target'],false);
2734 if($xt->type == ACTIVITY_OBJ_NOTE) {
2735 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
2737 intval($importer['importer_uid'])
2742 // extract tag, if not duplicate, add to parent item
2743 if($xo->id && $xo->content) {
2744 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
2745 if(! (stristr($r[0]['tag'],$newtag))) {
2746 q("UPDATE item SET tag = '%s' WHERE id = %d",
2747 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . $newtag),
2750 create_tags_from_item($r[0]['id']);
2756 $r = item_store($datarray,$force_parent);
2762 // Head post of a conversation. Have we seen it? If not, import it.
2764 $item_id = $item->get_id();
2766 $datarray = get_atom_elements($feed, $item, $contact);
2768 if(is_array($contact)) {
2769 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2770 $datarray['author-name'] = $contact['name'];
2771 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2772 $datarray['author-link'] = $contact['url'];
2773 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2774 $datarray['author-avatar'] = $contact['thumb'];
2777 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2778 logger('consume_feed: no author information! ' . print_r($datarray,true));
2782 // special handling for events
2784 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
2785 $ev = bbtoevent($datarray['body']);
2786 if(x($ev,'desc') && x($ev,'start')) {
2787 $ev['uid'] = $importer['uid'];
2788 $ev['uri'] = $item_id;
2789 $ev['edited'] = $datarray['edited'];
2790 $ev['private'] = $datarray['private'];
2792 if(is_array($contact))
2793 $ev['cid'] = $contact['id'];
2794 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2796 intval($importer['uid'])
2799 $ev['id'] = $r[0]['id'];
2800 $xyz = event_store($ev);
2805 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2806 if(strlen($datarray['title']))
2807 unset($datarray['title']);
2808 $datarray['last-child'] = 1;
2812 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2814 intval($importer['uid'])
2817 // Update content if 'updated' changes
2820 if (edited_timestamp_is_newer($r[0], $datarray)) {
2822 // do not accept (ignore) an earlier edit than one we currently have.
2823 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2826 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2827 dbesc($datarray['title']),
2828 dbesc($datarray['body']),
2829 dbesc($datarray['tag']),
2830 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2831 dbesc(datetime_convert()),
2833 intval($importer['uid'])
2835 create_tags_from_itemuri($item_id, $importer['uid']);
2836 update_thread_uri($item_id, $importer['uid']);
2839 // update last-child if it changes
2841 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2842 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
2843 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2844 intval($allow[0]['data']),
2845 dbesc(datetime_convert()),
2847 intval($importer['uid'])
2849 update_thread_uri($item_id, $importer['uid']);
2854 if(activity_match($datarray['verb'],ACTIVITY_FOLLOW)) {
2855 logger('consume-feed: New follower');
2856 new_follower($importer,$contact,$datarray,$item);
2859 if(activity_match($datarray['verb'],ACTIVITY_UNFOLLOW)) {
2860 lose_follower($importer,$contact,$datarray,$item);
2864 if(activity_match($datarray['verb'],ACTIVITY_REQ_FRIEND)) {
2865 logger('consume-feed: New friend request');
2866 new_follower($importer,$contact,$datarray,$item,true);
2869 if(activity_match($datarray['verb'],ACTIVITY_UNFRIEND)) {
2870 lose_sharer($importer,$contact,$datarray,$item);
2875 if(! is_array($contact))
2879 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2880 // one way feed - no remote comment ability
2881 $datarray['last-child'] = 0;
2883 if($contact['network'] === NETWORK_FEED)
2884 $datarray['private'] = 2;
2886 $datarray['parent-uri'] = $item_id;
2887 $datarray['uid'] = $importer['uid'];
2888 $datarray['contact-id'] = $contact['id'];
2890 if(! link_compare($datarray['owner-link'],$contact['url'])) {
2891 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
2892 // but otherwise there's a possible data mixup on the sender's system.
2893 // the tgroup delivery code called from item_store will correct it if it's a forum,
2894 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
2895 logger('consume_feed: Correcting item owner.', LOGGER_DEBUG);
2896 $datarray['owner-name'] = $contact['name'];
2897 $datarray['owner-link'] = $contact['url'];
2898 $datarray['owner-avatar'] = $contact['thumb'];
2901 // We've allowed "followers" to reach this point so we can decide if they are
2902 // posting an @-tag delivery, which followers are allowed to do for certain
2903 // page types. Now that we've parsed the post, let's check if it is legit. Otherwise ignore it.
2905 if(($contact['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['uid'],$datarray)))
2908 // This is my contact on another system, but it's really me.
2909 // Turn this into a wall post.
2910 $notify = item_is_remote_self($contact, $datarray);
2912 $r = item_store($datarray, false, $notify);
2913 logger('Stored - Contact '.$contact['url'].' Notify '.$notify.' return '.$r.' Item '.print_r($datarray, true), LOGGER_DEBUG);
2921 function item_is_remote_self($contact, &$datarray) {
2924 if (!$contact['remote_self'])
2927 // Prevent the forwarding of posts that are forwarded
2928 if ($datarray["extid"] == NETWORK_DFRN)
2931 // Prevent to forward already forwarded posts
2932 if ($datarray["app"] == $a->get_hostname())
2935 // Only forward posts
2936 if ($datarray["verb"] != ACTIVITY_POST)
2939 if (($contact['network'] != NETWORK_FEED) AND $datarray['private'])
2942 $datarray2 = $datarray;
2943 logger('remote-self start - Contact '.$contact['url'].' - '.$contact['remote_self'].' Item '.print_r($datarray, true), LOGGER_DEBUG);
2944 if ($contact['remote_self'] == 2) {
2945 $r = q("SELECT `id`,`url`,`name`,`thumb` FROM `contact` WHERE `uid` = %d AND `self`",
2946 intval($contact['uid']));
2948 $datarray['contact-id'] = $r[0]["id"];
2950 $datarray['owner-name'] = $r[0]["name"];
2951 $datarray['owner-link'] = $r[0]["url"];
2952 $datarray['owner-avatar'] = $r[0]["thumb"];
2954 $datarray['author-name'] = $datarray['owner-name'];
2955 $datarray['author-link'] = $datarray['owner-link'];
2956 $datarray['author-avatar'] = $datarray['owner-avatar'];
2959 if ($contact['network'] != NETWORK_FEED) {
2960 $datarray["guid"] = get_guid(32);
2961 unset($datarray["plink"]);
2962 $datarray["uri"] = item_new_uri($a->get_hostname(),$contact['uid']);
2963 $datarray["parent-uri"] = $datarray["uri"];
2964 $datarray["extid"] = $contact['network'];
2965 $urlpart = parse_url($datarray2['author-link']);
2966 $datarray["app"] = $urlpart["host"];
2968 $datarray['private'] = 0;
2971 //if (!isset($datarray["app"]) OR ($datarray["app"] == ""))
2972 // $datarray["app"] = network_to_name($contact['network']);
2974 if ($contact['network'] != NETWORK_FEED) {
2975 // Store the original post
2976 $r = item_store($datarray2, false, false);
2977 logger('remote-self post original item - Contact '.$contact['url'].' return '.$r.' Item '.print_r($datarray2, true), LOGGER_DEBUG);
2979 $datarray["app"] = "Feed";
2984 function local_delivery($importer,$data) {
2987 logger(__function__, LOGGER_TRACE);
2989 if($importer['readonly']) {
2990 // We aren't receiving stuff from this person. But we will quietly ignore them
2991 // rather than a blatant "go away" message.
2992 logger('local_delivery: ignoring');
2997 // Consume notification feed. This may differ from consuming a public feed in several ways
2998 // - might contain email or friend suggestions
2999 // - might contain remote followup to our message
3000 // - in which case we need to accept it and then notify other conversants
3001 // - we may need to send various email notifications
3003 $feed = new SimplePie();
3004 $feed->set_raw_data($data);
3005 $feed->enable_order_by_date(false);
3010 logger('local_delivery: Error parsing XML: ' . $feed->error());
3013 // Check at the feed level for updated contact name and/or photo
3017 $photo_timestamp = '';
3019 $contact_updated = '';
3022 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
3024 // Fallback should not be needed here. If it isn't DFRN it won't have DFRN updated tags
3026 // $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
3029 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
3030 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
3031 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
3032 $new_name = $elems['name'][0]['data'];
3034 // Manually checking for changed contact names
3035 if (($new_name != $importer['name']) AND ($new_name != "") AND ($name_updated <= $importer['name-date'])) {
3036 $name_updated = date("c");
3037 $photo_timestamp = date("c");
3040 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
3041 if ($photo_timestamp == "")
3042 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
3043 $photo_url = $elems['link'][0]['attribs']['']['href'];
3047 if(($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $importer['avatar-date'])) {
3049 $contact_updated = $photo_timestamp;
3051 logger('local_delivery: Updating photo for ' . $importer['name']);
3052 require_once("include/Photo.php");
3053 $photo_failure = false;
3054 $have_photo = false;
3056 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
3057 intval($importer['id']),
3058 intval($importer['importer_uid'])
3061 $resource_id = $r[0]['resource-id'];
3065 $resource_id = photo_new_resource();
3068 $img_str = fetch_url($photo_url,true);
3069 // guess mimetype from headers or filename
3070 $type = guess_image_type($photo_url,true);
3073 $img = new Photo($img_str, $type);
3074 if($img->is_valid()) {
3076 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
3077 dbesc($resource_id),
3078 intval($importer['id']),
3079 intval($importer['importer_uid'])
3083 $img->scaleImageSquare(175);
3085 $hash = $resource_id;
3086 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 4);
3088 $img->scaleImage(80);
3089 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 5);
3091 $img->scaleImage(48);
3092 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 6);
3096 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
3097 WHERE `uid` = %d AND `id` = %d",
3098 dbesc(datetime_convert()),
3099 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
3100 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
3101 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
3102 intval($importer['importer_uid']),
3103 intval($importer['id'])
3108 if(($name_updated) && (strlen($new_name)) && ($name_updated > $importer['name-date'])) {
3109 if ($name_updated > $contact_updated)
3110 $contact_updated = $name_updated;
3112 $r = q("select * from contact where uid = %d and id = %d limit 1",
3113 intval($importer['importer_uid']),
3114 intval($importer['id'])
3117 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
3118 dbesc(notags(trim($new_name))),
3119 dbesc(datetime_convert()),
3120 intval($importer['importer_uid']),
3121 intval($importer['id'])
3124 // do our best to update the name on content items
3127 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
3128 dbesc(notags(trim($new_name))),
3129 dbesc($r[0]['name']),
3130 dbesc($r[0]['url']),
3131 intval($importer['importer_uid'])
3136 if ($contact_updated AND $new_name AND $photo_url)
3137 poco_check($importer['url'], $new_name, NETWORK_DFRN, $photo_url, "", "", "", "", "", $contact_updated, 2, $importer['id'], $importer['importer_uid']);
3139 // Currently unsupported - needs a lot of work
3140 $reloc = $feed->get_feed_tags( NAMESPACE_DFRN, 'relocate' );
3141 if(isset($reloc[0]['child'][NAMESPACE_DFRN])) {
3142 $base = $reloc[0]['child'][NAMESPACE_DFRN];
3144 $newloc['uid'] = $importer['importer_uid'];
3145 $newloc['cid'] = $importer['id'];
3146 $newloc['name'] = notags(unxmlify($base['name'][0]['data']));
3147 $newloc['photo'] = notags(unxmlify($base['photo'][0]['data']));
3148 $newloc['thumb'] = notags(unxmlify($base['thumb'][0]['data']));
3149 $newloc['micro'] = notags(unxmlify($base['micro'][0]['data']));
3150 $newloc['url'] = notags(unxmlify($base['url'][0]['data']));
3151 $newloc['request'] = notags(unxmlify($base['request'][0]['data']));
3152 $newloc['confirm'] = notags(unxmlify($base['confirm'][0]['data']));
3153 $newloc['notify'] = notags(unxmlify($base['notify'][0]['data']));
3154 $newloc['poll'] = notags(unxmlify($base['poll'][0]['data']));
3155 $newloc['sitepubkey'] = notags(unxmlify($base['sitepubkey'][0]['data']));
3156 /** relocated user must have original key pair */
3157 /*$newloc['pubkey'] = notags(unxmlify($base['pubkey'][0]['data']));
3158 $newloc['prvkey'] = notags(unxmlify($base['prvkey'][0]['data']));*/
3160 logger("items:relocate contact ".print_r($newloc, true).print_r($importer, true), LOGGER_DEBUG);
3163 $r = q("SELECT photo, url FROM contact WHERE id=%d AND uid=%d;",
3164 intval($importer['id']),
3165 intval($importer['importer_uid']));
3170 $x = q("UPDATE contact SET
3181 `site-pubkey` = '%s'
3182 WHERE id=%d AND uid=%d;",
3183 dbesc($newloc['name']),
3184 dbesc($newloc['photo']),
3185 dbesc($newloc['thumb']),
3186 dbesc($newloc['micro']),
3187 dbesc($newloc['url']),
3188 dbesc(normalise_link($newloc['url'])),
3189 dbesc($newloc['request']),
3190 dbesc($newloc['confirm']),
3191 dbesc($newloc['notify']),
3192 dbesc($newloc['poll']),
3193 dbesc($newloc['sitepubkey']),
3194 intval($importer['id']),
3195 intval($importer['importer_uid']));
3201 'owner-link' => array($old['url'], $newloc['url']),
3202 'author-link' => array($old['url'], $newloc['url']),
3203 'owner-avatar' => array($old['photo'], $newloc['photo']),
3204 'author-avatar' => array($old['photo'], $newloc['photo']),
3206 foreach ($fields as $n=>$f){
3207 $x = q("UPDATE `item` SET `%s`='%s' WHERE `%s`='%s' AND uid=%d",
3210 intval($importer['importer_uid']));
3216 // merge with current record, current contents have priority
3217 // update record, set url-updated
3218 // update profile photos
3224 // handle friend suggestion notification
3226 $sugg = $feed->get_feed_tags( NAMESPACE_DFRN, 'suggest' );
3227 if(isset($sugg[0]['child'][NAMESPACE_DFRN])) {
3228 $base = $sugg[0]['child'][NAMESPACE_DFRN];
3230 $fsugg['uid'] = $importer['importer_uid'];
3231 $fsugg['cid'] = $importer['id'];
3232 $fsugg['name'] = notags(unxmlify($base['name'][0]['data']));
3233 $fsugg['photo'] = notags(unxmlify($base['photo'][0]['data']));
3234 $fsugg['url'] = notags(unxmlify($base['url'][0]['data']));
3235 $fsugg['request'] = notags(unxmlify($base['request'][0]['data']));
3236 $fsugg['body'] = escape_tags(unxmlify($base['note'][0]['data']));
3238 // Does our member already have a friend matching this description?
3240 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `nurl` = '%s' AND `uid` = %d LIMIT 1",
3241 dbesc($fsugg['name']),
3242 dbesc(normalise_link($fsugg['url'])),
3243 intval($fsugg['uid'])
3248 // Do we already have an fcontact record for this person?
3251 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
3252 dbesc($fsugg['url']),
3253 dbesc($fsugg['name']),
3254 dbesc($fsugg['request'])
3259 // OK, we do. Do we already have an introduction for this person ?
3260 $r = q("select id from intro where uid = %d and fid = %d limit 1",
3261 intval($fsugg['uid']),
3268 $r = q("INSERT INTO `fcontact` ( `name`,`url`,`photo`,`request` ) VALUES ( '%s', '%s', '%s', '%s' ) ",
3269 dbesc($fsugg['name']),
3270 dbesc($fsugg['url']),
3271 dbesc($fsugg['photo']),
3272 dbesc($fsugg['request'])
3274 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
3275 dbesc($fsugg['url']),
3276 dbesc($fsugg['name']),
3277 dbesc($fsugg['request'])
3282 // database record did not get created. Quietly give up.
3287 $hash = random_string();
3289 $r = q("INSERT INTO `intro` ( `uid`, `fid`, `contact-id`, `note`, `hash`, `datetime`, `blocked` )
3290 VALUES( %d, %d, %d, '%s', '%s', '%s', %d )",
3291 intval($fsugg['uid']),
3293 intval($fsugg['cid']),
3294 dbesc($fsugg['body']),
3296 dbesc(datetime_convert()),
3301 'type' => NOTIFY_SUGGEST,
3302 'notify_flags' => $importer['notify-flags'],
3303 'language' => $importer['language'],
3304 'to_name' => $importer['username'],
3305 'to_email' => $importer['email'],
3306 'uid' => $importer['importer_uid'],
3308 'link' => $a->get_baseurl() . '/notifications/intros',
3309 'source_name' => $importer['name'],
3310 'source_link' => $importer['url'],
3311 'source_photo' => $importer['photo'],
3312 'verb' => ACTIVITY_REQ_FRIEND,
3321 $rawmail = $feed->get_feed_tags( NAMESPACE_DFRN, 'mail' );
3322 if(isset($rawmail[0]['child'][NAMESPACE_DFRN])) {
3324 logger('local_delivery: private message received');
3327 $base = $rawmail[0]['child'][NAMESPACE_DFRN];
3330 $msg['uid'] = $importer['importer_uid'];
3331 $msg['from-name'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['name'][0]['data']));
3332 $msg['from-photo'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['avatar'][0]['data']));
3333 $msg['from-url'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['uri'][0]['data']));
3334 $msg['contact-id'] = $importer['id'];
3335 $msg['title'] = notags(unxmlify($base['subject'][0]['data']));
3336 $msg['body'] = escape_tags(unxmlify($base['content'][0]['data']));
3338 $msg['replied'] = 0;
3339 $msg['uri'] = notags(unxmlify($base['id'][0]['data']));
3340 $msg['parent-uri'] = notags(unxmlify($base['in-reply-to'][0]['data']));
3341 $msg['created'] = datetime_convert(notags(unxmlify('UTC','UTC',$base['sentdate'][0]['data'])));
3345 $r = dbq("INSERT INTO `mail` (`" . implode("`, `", array_keys($msg))
3346 . "`) VALUES ('" . implode("', '", array_values($msg)) . "')" );
3348 // send notifications.
3350 require_once('include/enotify.php');
3352 $notif_params = array(
3353 'type' => NOTIFY_MAIL,
3354 'notify_flags' => $importer['notify-flags'],
3355 'language' => $importer['language'],
3356 'to_name' => $importer['username'],
3357 'to_email' => $importer['email'],
3358 'uid' => $importer['importer_uid'],
3360 'source_name' => $msg['from-name'],
3361 'source_link' => $importer['url'],
3362 'source_photo' => $importer['thumb'],
3363 'verb' => ACTIVITY_POST,
3367 notification($notif_params);
3373 $community_page = 0;
3374 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
3376 $community_page = intval($rawtags[0]['data']);
3378 if(intval($importer['forum']) != $community_page) {
3379 q("update contact set forum = %d where id = %d",
3380 intval($community_page),
3381 intval($importer['id'])
3383 $importer['forum'] = (string) $community_page;
3386 logger('local_delivery: feed item count = ' . $feed->get_item_quantity());
3388 // process any deleted entries
3390 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
3391 if(is_array($del_entries) && count($del_entries)) {
3392 foreach($del_entries as $dentry) {
3394 if(isset($dentry['attribs']['']['ref'])) {
3395 $uri = $dentry['attribs']['']['ref'];
3397 if(isset($dentry['attribs']['']['when'])) {
3398 $when = $dentry['attribs']['']['when'];
3399 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
3402 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
3406 // check for relayed deletes to our conversation
3409 $r = q("select * from item where uri = '%s' and uid = %d limit 1",
3411 intval($importer['importer_uid'])
3414 $parent_uri = $r[0]['parent-uri'];
3415 if($r[0]['id'] != $r[0]['parent'])
3422 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3425 logger('local_delivery: possible community delete');
3428 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3430 // was the top-level post for this reply written by somebody on this site?
3431 // Specifically, the recipient?
3433 $is_a_remote_delete = false;
3435 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3436 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3437 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3438 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3439 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3440 AND `item`.`uid` = %d
3446 intval($importer['importer_uid'])
3449 $is_a_remote_delete = true;
3451 // Does this have the characteristics of a community or private group comment?
3452 // If it's a reply to a wall post on a community/prvgroup page it's a
3453 // valid community comment. Also forum_mode makes it valid for sure.
3454 // If neither, it's not.
3456 if($is_a_remote_delete && $community) {
3457 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3458 $is_a_remote_delete = false;
3459 logger('local_delivery: not a community delete');
3463 if($is_a_remote_delete) {
3464 logger('local_delivery: received remote delete');
3468 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN contact on `item`.`contact-id` = `contact`.`id`
3469 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
3471 intval($importer['importer_uid']),
3472 intval($importer['id'])
3478 if($item['deleted'])
3481 logger('local_delivery: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
3483 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3484 $xo = parse_xml_string($item['object'],false);
3485 $xt = parse_xml_string($item['target'],false);
3487 if($xt->type === ACTIVITY_OBJ_NOTE) {
3488 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
3490 intval($importer['importer_uid'])
3494 // For tags, the owner cannot remove the tag on the author's copy of the post.
3496 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
3497 $author_remove = (($item['origin'] && $item['self']) ? true : false);
3498 $author_copy = (($item['origin']) ? true : false);
3500 if($owner_remove && $author_copy)
3502 if($author_remove || $owner_remove) {
3503 $tags = explode(',',$i[0]['tag']);
3506 foreach($tags as $tag)
3507 if(trim($tag) !== trim($xo->body))
3508 $newtags[] = trim($tag);
3510 q("update item set tag = '%s' where id = %d",
3511 dbesc(implode(',',$newtags)),
3514 create_tags_from_item($i[0]['id']);
3520 if($item['uri'] == $item['parent-uri']) {
3521 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3522 `body` = '', `title` = ''
3523 WHERE `parent-uri` = '%s' AND `uid` = %d",
3525 dbesc(datetime_convert()),
3526 dbesc($item['uri']),
3527 intval($importer['importer_uid'])
3529 create_tags_from_itemuri($item['uri'], $importer['importer_uid']);
3530 create_files_from_itemuri($item['uri'], $importer['importer_uid']);
3531 update_thread_uri($item['uri'], $importer['importer_uid']);
3534 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3535 `body` = '', `title` = ''
3536 WHERE `uri` = '%s' AND `uid` = %d",
3538 dbesc(datetime_convert()),
3540 intval($importer['importer_uid'])
3542 create_tags_from_itemuri($uri, $importer['importer_uid']);
3543 create_files_from_itemuri($uri, $importer['importer_uid']);
3544 update_thread_uri($uri, $importer['importer_uid']);
3545 if($item['last-child']) {
3546 // ensure that last-child is set in case the comment that had it just got wiped.
3547 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
3548 dbesc(datetime_convert()),
3549 dbesc($item['parent-uri']),
3550 intval($item['uid'])
3552 // who is the last child now?
3553 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d
3554 ORDER BY `created` DESC LIMIT 1",
3555 dbesc($item['parent-uri']),
3556 intval($importer['importer_uid'])
3559 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
3564 // if this is a relayed delete, propagate it to other recipients
3566 if($is_a_remote_delete)
3567 proc_run('php',"include/notifier.php","drop",$item['id']);
3575 foreach($feed->get_items() as $item) {
3578 $item_id = $item->get_id();
3579 $rawthread = $item->get_item_tags( NAMESPACE_THREAD, 'in-reply-to');
3580 if(isset($rawthread[0]['attribs']['']['ref'])) {
3582 $parent_uri = $rawthread[0]['attribs']['']['ref'];
3588 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3591 logger('local_delivery: possible community reply');
3594 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3596 // was the top-level post for this reply written by somebody on this site?
3597 // Specifically, the recipient?
3599 $is_a_remote_comment = false;
3600 $top_uri = $parent_uri;
3602 $r = q("select `item`.`parent-uri` from `item`
3603 WHERE `item`.`uri` = '%s'
3607 if($r && count($r)) {
3608 $top_uri = $r[0]['parent-uri'];
3610 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3611 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3612 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3613 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3614 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3615 AND `item`.`uid` = %d
3621 intval($importer['importer_uid'])
3624 $is_a_remote_comment = true;
3627 // Does this have the characteristics of a community or private group comment?
3628 // If it's a reply to a wall post on a community/prvgroup page it's a
3629 // valid community comment. Also forum_mode makes it valid for sure.
3630 // If neither, it's not.
3632 if($is_a_remote_comment && $community) {
3633 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3634 $is_a_remote_comment = false;
3635 logger('local_delivery: not a community reply');
3639 if($is_a_remote_comment) {
3640 logger('local_delivery: received remote comment');
3642 // remote reply to our post. Import and then notify everybody else.
3644 $datarray = get_atom_elements($feed, $item);
3646 $r = q("SELECT `id`, `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3648 intval($importer['importer_uid'])
3651 // Update content if 'updated' changes
3655 if (edited_timestamp_is_newer($r[0], $datarray)) {
3657 // do not accept (ignore) an earlier edit than one we currently have.
3658 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3661 logger('received updated comment' , LOGGER_DEBUG);
3662 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3663 dbesc($datarray['title']),
3664 dbesc($datarray['body']),
3665 dbesc($datarray['tag']),
3666 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3667 dbesc(datetime_convert()),
3669 intval($importer['importer_uid'])
3671 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3673 proc_run('php',"include/notifier.php","comment-import",$iid);
3682 $own = q("select name,url,thumb from contact where uid = %d and self = 1 limit 1",
3683 intval($importer['importer_uid'])
3687 $datarray['type'] = 'remote-comment';
3688 $datarray['wall'] = 1;
3689 $datarray['parent-uri'] = $parent_uri;
3690 $datarray['uid'] = $importer['importer_uid'];
3691 $datarray['owner-name'] = $own[0]['name'];
3692 $datarray['owner-link'] = $own[0]['url'];
3693 $datarray['owner-avatar'] = $own[0]['thumb'];
3694 $datarray['contact-id'] = $importer['id'];
3696 if(($datarray['verb'] === ACTIVITY_LIKE) || ($datarray['verb'] === ACTIVITY_DISLIKE)) {
3698 $datarray['type'] = 'activity';
3699 $datarray['gravity'] = GRAVITY_LIKE;
3700 $datarray['last-child'] = 0;
3701 // only one like or dislike per person
3702 // splitted into two queries for performance issues
3703 $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",
3704 intval($datarray['uid']),
3705 intval($datarray['contact-id']),
3706 dbesc($datarray['verb']),
3707 dbesc($datarray['parent-uri'])
3713 $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",
3714 intval($datarray['uid']),
3715 intval($datarray['contact-id']),
3716 dbesc($datarray['verb']),
3717 dbesc($datarray['parent-uri'])
3724 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3726 $xo = parse_xml_string($datarray['object'],false);
3727 $xt = parse_xml_string($datarray['target'],false);
3729 if(($xt->type == ACTIVITY_OBJ_NOTE) && ($xt->id)) {
3731 // fetch the parent item
3733 $tagp = q("select * from item where uri = '%s' and uid = %d limit 1",
3735 intval($importer['importer_uid'])
3740 // extract tag, if not duplicate, and this user allows tags, add to parent item
3742 if($xo->id && $xo->content) {
3743 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
3744 if(! (stristr($tagp[0]['tag'],$newtag))) {
3745 $i = q("SELECT `blocktags` FROM `user` where `uid` = %d LIMIT 1",
3746 intval($importer['importer_uid'])
3748 if(count($i) && ! intval($i[0]['blocktags'])) {
3749 q("UPDATE item SET tag = '%s', `edited` = '%s', `changed` = '%s' WHERE id = %d",
3750 dbesc($tagp[0]['tag'] . (strlen($tagp[0]['tag']) ? ',' : '') . $newtag),
3751 intval($tagp[0]['id']),
3752 dbesc(datetime_convert()),
3753 dbesc(datetime_convert())
3755 create_tags_from_item($tagp[0]['id']);
3763 $posted_id = item_store($datarray);
3768 $datarray["id"] = $posted_id;
3770 $r = q("SELECT `parent`, `parent-uri` FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3772 intval($importer['importer_uid'])
3775 $parent = $r[0]['parent'];
3776 $parent_uri = $r[0]['parent-uri'];
3780 $r1 = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `uid` = %d AND `parent` = %d",
3781 dbesc(datetime_convert()),
3782 intval($importer['importer_uid']),
3783 intval($r[0]['parent'])
3786 $r2 = q("UPDATE `item` SET `last-child` = 1, `changed` = '%s' WHERE `uid` = %d AND `id` = %d",
3787 dbesc(datetime_convert()),
3788 intval($importer['importer_uid']),
3793 if($posted_id && $parent) {
3795 proc_run('php',"include/notifier.php","comment-import","$posted_id");
3797 if((! $is_like) && (! $importer['self'])) {
3799 require_once('include/enotify.php');
3802 'type' => NOTIFY_COMMENT,
3803 'notify_flags' => $importer['notify-flags'],
3804 'language' => $importer['language'],
3805 'to_name' => $importer['username'],
3806 'to_email' => $importer['email'],
3807 'uid' => $importer['importer_uid'],
3808 'item' => $datarray,
3809 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3810 'source_name' => stripslashes($datarray['author-name']),
3811 'source_link' => $datarray['author-link'],
3812 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3813 ? $importer['thumb'] : $datarray['author-avatar']),
3814 'verb' => ACTIVITY_POST,
3816 'parent' => $parent,
3817 'parent_uri' => $parent_uri,
3829 // regular comment that is part of this total conversation. Have we seen it? If not, import it.
3831 $item_id = $item->get_id();
3832 $datarray = get_atom_elements($feed,$item);
3834 if($importer['rel'] == CONTACT_IS_FOLLOWER)
3837 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3839 intval($importer['importer_uid'])
3842 // Update content if 'updated' changes
3845 if (edited_timestamp_is_newer($r[0], $datarray)) {
3847 // do not accept (ignore) an earlier edit than one we currently have.
3848 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3851 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3852 dbesc($datarray['title']),
3853 dbesc($datarray['body']),
3854 dbesc($datarray['tag']),
3855 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3856 dbesc(datetime_convert()),
3858 intval($importer['importer_uid'])
3860 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3863 // update last-child if it changes
3865 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3866 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
3867 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
3868 dbesc(datetime_convert()),
3870 intval($importer['importer_uid'])
3872 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3873 intval($allow[0]['data']),
3874 dbesc(datetime_convert()),
3876 intval($importer['importer_uid'])
3882 $datarray['parent-uri'] = $parent_uri;
3883 $datarray['uid'] = $importer['importer_uid'];
3884 $datarray['contact-id'] = $importer['id'];
3885 if(($datarray['verb'] == ACTIVITY_LIKE) || ($datarray['verb'] == ACTIVITY_DISLIKE)) {
3886 $datarray['type'] = 'activity';
3887 $datarray['gravity'] = GRAVITY_LIKE;
3888 // only one like or dislike per person
3889 // splitted into two queries for performance issues
3890 $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",
3891 intval($datarray['uid']),
3892 intval($datarray['contact-id']),
3893 dbesc($datarray['verb']),
3899 $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",
3900 intval($datarray['uid']),
3901 intval($datarray['contact-id']),
3902 dbesc($datarray['verb']),
3910 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3912 $xo = parse_xml_string($datarray['object'],false);
3913 $xt = parse_xml_string($datarray['target'],false);
3915 if($xt->type == ACTIVITY_OBJ_NOTE) {
3916 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
3918 intval($importer['importer_uid'])
3923 // extract tag, if not duplicate, add to parent item
3925 if(! (stristr($r[0]['tag'],trim($xo->content)))) {
3926 q("UPDATE item SET tag = '%s' WHERE id = %d",
3927 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]'),
3930 create_tags_from_item($r[0]['id']);
3936 $posted_id = item_store($datarray);
3938 // find out if our user is involved in this conversation and wants to be notified.
3940 if(!x($datarray['type']) || $datarray['type'] != 'activity') {
3942 $myconv = q("SELECT `author-link`, `author-avatar`, `parent` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `parent` != 0 AND `deleted` = 0",
3944 intval($importer['importer_uid'])
3947 if(count($myconv)) {
3948 $importer_url = $a->get_baseurl() . '/profile/' . $importer['nickname'];
3950 // first make sure this isn't our own post coming back to us from a wall-to-wall event
3951 if(! link_compare($datarray['author-link'],$importer_url)) {
3954 foreach($myconv as $conv) {
3956 // now if we find a match, it means we're in this conversation
3958 if(! link_compare($conv['author-link'],$importer_url))
3961 require_once('include/enotify.php');
3963 $conv_parent = $conv['parent'];
3966 'type' => NOTIFY_COMMENT,
3967 'notify_flags' => $importer['notify-flags'],
3968 'language' => $importer['language'],
3969 'to_name' => $importer['username'],
3970 'to_email' => $importer['email'],
3971 'uid' => $importer['importer_uid'],
3972 'item' => $datarray,
3973 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3974 'source_name' => stripslashes($datarray['author-name']),
3975 'source_link' => $datarray['author-link'],
3976 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3977 ? $importer['thumb'] : $datarray['author-avatar']),
3978 'verb' => ACTIVITY_POST,
3980 'parent' => $conv_parent,
3981 'parent_uri' => $parent_uri
3985 // only send one notification
3997 // Head post of a conversation. Have we seen it? If not, import it.
4000 $item_id = $item->get_id();
4001 $datarray = get_atom_elements($feed,$item);
4003 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
4004 $ev = bbtoevent($datarray['body']);
4005 if(x($ev,'desc') && x($ev,'start')) {
4006 $ev['cid'] = $importer['id'];
4007 $ev['uid'] = $importer['uid'];
4008 $ev['uri'] = $item_id;
4009 $ev['edited'] = $datarray['edited'];
4010 $ev['private'] = $datarray['private'];
4012 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
4014 intval($importer['uid'])
4017 $ev['id'] = $r[0]['id'];
4018 $xyz = event_store($ev);
4023 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
4025 intval($importer['importer_uid'])
4028 // Update content if 'updated' changes
4031 if (edited_timestamp_is_newer($r[0], $datarray)) {
4033 // do not accept (ignore) an earlier edit than one we currently have.
4034 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
4037 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
4038 dbesc($datarray['title']),
4039 dbesc($datarray['body']),
4040 dbesc($datarray['tag']),
4041 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
4042 dbesc(datetime_convert()),
4044 intval($importer['importer_uid'])
4046 create_tags_from_itemuri($item_id, $importer['importer_uid']);
4047 update_thread_uri($item_id, $importer['importer_uid']);
4050 // update last-child if it changes
4052 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
4053 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
4054 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
4055 intval($allow[0]['data']),
4056 dbesc(datetime_convert()),
4058 intval($importer['importer_uid'])
4064 $datarray['parent-uri'] = $item_id;
4065 $datarray['uid'] = $importer['importer_uid'];
4066 $datarray['contact-id'] = $importer['id'];
4069 if(! link_compare($datarray['owner-link'],$importer['url'])) {
4070 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
4071 // but otherwise there's a possible data mixup on the sender's system.
4072 // the tgroup delivery code called from item_store will correct it if it's a forum,
4073 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
4074 logger('local_delivery: Correcting item owner.', LOGGER_DEBUG);
4075 $datarray['owner-name'] = $importer['senderName'];
4076 $datarray['owner-link'] = $importer['url'];
4077 $datarray['owner-avatar'] = $importer['thumb'];
4080 if(($importer['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['importer_uid'],$datarray)))
4083 // This is my contact on another system, but it's really me.
4084 // Turn this into a wall post.
4085 $notify = item_is_remote_self($importer, $datarray);
4087 $posted_id = item_store($datarray, false, $notify);
4089 if(stristr($datarray['verb'],ACTIVITY_POKE)) {
4090 $verb = urldecode(substr($datarray['verb'],strpos($datarray['verb'],'#')+1));
4093 $xo = parse_xml_string($datarray['object'],false);
4095 if(($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
4097 // somebody was poked/prodded. Was it me?
4099 $links = parse_xml_string("<links>".unxmlify($xo->link)."</links>",false);
4101 foreach($links->link as $l) {
4102 $atts = $l->attributes();
4103 switch($atts['rel']) {
4105 $Blink = $atts['href'];
4111 if($Blink && link_compare($Blink,$a->get_baseurl() . '/profile/' . $importer['nickname'])) {
4113 // send a notification
4114 require_once('include/enotify.php');
4117 'type' => NOTIFY_POKE,
4118 'notify_flags' => $importer['notify-flags'],
4119 'language' => $importer['language'],
4120 'to_name' => $importer['username'],
4121 'to_email' => $importer['email'],
4122 'uid' => $importer['importer_uid'],
4123 'item' => $datarray,
4124 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
4125 'source_name' => stripslashes($datarray['author-name']),
4126 'source_link' => $datarray['author-link'],
4127 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
4128 ? $importer['thumb'] : $datarray['author-avatar']),
4129 'verb' => $datarray['verb'],
4130 'otype' => 'person',
4131 'activity' => $verb,
4132 'parent' => $datarray['parent']
4148 function new_follower($importer,$contact,$datarray,$item,$sharing = false) {
4149 $url = notags(trim($datarray['author-link']));
4150 $name = notags(trim($datarray['author-name']));
4151 $photo = notags(trim($datarray['author-avatar']));
4153 $rawtag = $item->get_item_tags(NAMESPACE_ACTIVITY,'actor');
4154 if($rawtag && $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'])
4155 $nick = $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'];
4157 if(is_array($contact)) {
4158 if(($contact['network'] == NETWORK_OSTATUS && $contact['rel'] == CONTACT_IS_SHARING)
4159 || ($sharing && $contact['rel'] == CONTACT_IS_FOLLOWER)) {
4160 $r = q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
4161 intval(CONTACT_IS_FRIEND),
4162 intval($contact['id']),
4163 intval($importer['uid'])
4166 // send email notification to owner?
4170 // create contact record
4172 $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `name`, `nick`, `photo`, `network`, `rel`,
4173 `blocked`, `readonly`, `pending`, `writable` )
4174 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, 1 ) ",
4175 intval($importer['uid']),
4176 dbesc(datetime_convert()),
4178 dbesc(normalise_link($url)),
4182 dbesc(($sharing) ? NETWORK_ZOT : NETWORK_OSTATUS),
4183 intval(($sharing) ? CONTACT_IS_SHARING : CONTACT_IS_FOLLOWER)
4185 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `url` = '%s' AND `pending` = 1 LIMIT 1",
4186 intval($importer['uid']),
4190 $contact_record = $r[0];
4192 // create notification
4193 $hash = random_string();
4195 if(is_array($contact_record)) {
4196 $ret = q("INSERT INTO `intro` ( `uid`, `contact-id`, `blocked`, `knowyou`, `hash`, `datetime`)
4197 VALUES ( %d, %d, 0, 0, '%s', '%s' )",
4198 intval($importer['uid']),
4199 intval($contact_record['id']),
4201 dbesc(datetime_convert())
4205 $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
4206 intval($importer['uid'])
4211 if(intval($r[0]['def_gid'])) {
4212 require_once('include/group.php');
4213 group_add_member($r[0]['uid'],'',$contact_record['id'],$r[0]['def_gid']);
4216 if(($r[0]['notify-flags'] & NOTIFY_INTRO) &&
4217 in_array($r[0]['page-flags'], array(PAGE_NORMAL, PAGE_SOAPBOX, PAGE_FREELOVE))) {
4220 'type' => NOTIFY_INTRO,
4221 'notify_flags' => $r[0]['notify-flags'],
4222 'language' => $r[0]['language'],
4223 'to_name' => $r[0]['username'],
4224 'to_email' => $r[0]['email'],
4225 'uid' => $r[0]['uid'],
4226 'link' => $a->get_baseurl() . '/notifications/intro',
4227 'source_name' => ((strlen(stripslashes($contact_record['name']))) ? stripslashes($contact_record['name']) : t('[Name Withheld]')),
4228 'source_link' => $contact_record['url'],
4229 'source_photo' => $contact_record['photo'],
4230 'verb' => ($sharing ? ACTIVITY_FRIEND : ACTIVITY_FOLLOW),
4239 function lose_follower($importer,$contact,$datarray,$item) {
4241 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_SHARING)) {
4242 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
4243 intval(CONTACT_IS_SHARING),
4244 intval($contact['id'])
4248 contact_remove($contact['id']);
4252 function lose_sharer($importer,$contact,$datarray,$item) {
4254 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_FOLLOWER)) {
4255 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
4256 intval(CONTACT_IS_FOLLOWER),
4257 intval($contact['id'])
4261 contact_remove($contact['id']);
4266 function subscribe_to_hub($url,$importer,$contact,$hubmode = 'subscribe') {
4270 if(is_array($importer)) {
4271 $r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
4272 intval($importer['uid'])
4276 // Diaspora has different message-ids in feeds than they do
4277 // through the direct Diaspora protocol. If we try and use
4278 // the feed, we'll get duplicates. So don't.
4280 if((! count($r)) || $contact['network'] === NETWORK_DIASPORA)
4283 $push_url = get_config('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
4285 // Use a single verify token, even if multiple hubs
4287 $verify_token = ((strlen($contact['hub-verify'])) ? $contact['hub-verify'] : random_string());
4289 $params= 'hub.mode=' . $hubmode . '&hub.callback=' . urlencode($push_url) . '&hub.topic=' . urlencode($contact['poll']) . '&hub.verify=async&hub.verify_token=' . $verify_token;
4291 logger('subscribe_to_hub: ' . $hubmode . ' ' . $contact['name'] . ' to hub ' . $url . ' endpoint: ' . $push_url . ' with verifier ' . $verify_token);
4293 if(! strlen($contact['hub-verify'])) {
4294 $r = q("UPDATE `contact` SET `hub-verify` = '%s' WHERE `id` = %d",
4295 dbesc($verify_token),
4296 intval($contact['id'])
4300 post_url($url,$params);
4302 logger('subscribe_to_hub: returns: ' . $a->get_curl_code(), LOGGER_DEBUG);
4309 function atom_author($tag,$name,$uri,$h,$w,$photo) {
4313 $name = xmlify($name);
4314 $uri = xmlify($uri);
4317 $photo = xmlify($photo);
4321 $o .= "<name>$name</name>\r\n";
4322 $o .= "<uri>$uri</uri>\r\n";
4323 $o .= '<link rel="photo" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4324 $o .= '<link rel="avatar" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4326 call_hooks('atom_author', $o);
4328 $o .= "</$tag>\r\n";
4332 function atom_entry($item,$type,$author,$owner,$comment = false,$cid = 0) {
4336 if(! $item['parent'])
4339 if($item['deleted'])
4340 return '<at:deleted-entry ref="' . xmlify($item['uri']) . '" when="' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '" />' . "\r\n";
4343 if($item['allow_cid'] || $item['allow_gid'] || $item['deny_cid'] || $item['deny_gid'])
4344 $body = fix_private_photos($item['body'],$owner['uid'],$item,$cid);
4346 $body = $item['body'];
4349 $o = "\r\n\r\n<entry>\r\n";
4351 if(is_array($author))
4352 $o .= atom_author('author',$author['name'],$author['url'],80,80,$author['thumb']);
4354 $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']));
4355 if(strlen($item['owner-name']))
4356 $o .= atom_author('dfrn:owner',$item['owner-name'],$item['owner-link'],80,80,$item['owner-avatar']);
4358 if(($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
4359 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
4360 $o .= '<thr:in-reply-to ref="' . xmlify($parent_item) . '" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['parent']) . '" />' . "\r\n";
4365 if ($item['title'] != "")
4366 $htmlbody = "[b]".$item['title']."[/b]\n\n".$htmlbody;
4368 $htmlbody = bbcode(bb_remove_share_information($htmlbody), false, false, 7);
4370 $o .= '<id>' . xmlify($item['uri']) . '</id>' . "\r\n";
4371 $o .= '<title>' . xmlify($item['title']) . '</title>' . "\r\n";
4372 $o .= '<published>' . xmlify(datetime_convert('UTC','UTC',$item['created'] . '+00:00',ATOM_TIME)) . '</published>' . "\r\n";
4373 $o .= '<updated>' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '</updated>' . "\r\n";
4374 $o .= '<dfrn:env>' . base64url_encode($body, true) . '</dfrn:env>' . "\r\n";
4375 $o .= '<content type="' . $type . '" >' . xmlify((($type === 'html') ? $htmlbody : $body)) . '</content>' . "\r\n";
4376 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['id']) . '" />' . "\r\n";
4380 $o .= '<dfrn:comment-allow>' . intval($item['last-child']) . '</dfrn:comment-allow>' . "\r\n";
4382 if($item['location']) {
4383 $o .= '<dfrn:location>' . xmlify($item['location']) . '</dfrn:location>' . "\r\n";
4384 $o .= '<poco:address><poco:formatted>' . xmlify($item['location']) . '</poco:formatted></poco:address>' . "\r\n";
4388 $o .= '<georss:point>' . xmlify($item['coord']) . '</georss:point>' . "\r\n";
4390 if(($item['private']) || strlen($item['allow_cid']) || strlen($item['allow_gid']) || strlen($item['deny_cid']) || strlen($item['deny_gid']))
4391 $o .= '<dfrn:private>' . (($item['private']) ? $item['private'] : 1) . '</dfrn:private>' . "\r\n";
4394 $o .= '<dfrn:extid>' . xmlify($item['extid']) . '</dfrn:extid>' . "\r\n";
4395 if($item['bookmark'])
4396 $o .= '<dfrn:bookmark>true</dfrn:bookmark>' . "\r\n";
4399 $o .= '<statusnet:notice_info local_id="' . $item['id'] . '" source="' . xmlify($item['app']) . '" ></statusnet:notice_info>' . "\r\n";
4402 $o .= '<dfrn:diaspora_guid>' . $item['guid'] . '</dfrn:diaspora_guid>' . "\r\n";
4404 if($item['signed_text']) {
4405 $sign = base64_encode(json_encode(array('signed_text' => $item['signed_text'],'signature' => $item['signature'],'signer' => $item['signer'])));
4406 $o .= '<dfrn:diaspora_signature>' . xmlify($sign) . '</dfrn:diaspora_signature>' . "\r\n";
4409 $verb = construct_verb($item);
4410 $o .= '<as:verb>' . xmlify($verb) . '</as:verb>' . "\r\n";
4411 $actobj = construct_activity_object($item);
4414 $actarg = construct_activity_target($item);
4418 $tags = item_getfeedtags($item);
4420 foreach($tags as $t) {
4421 $o .= '<category scheme="X-DFRN:' . xmlify($t[0]) . ':' . xmlify($t[1]) . '" term="' . xmlify($t[2]) . '" />' . "\r\n";
4425 $o .= item_getfeedattach($item);
4427 $mentioned = get_mentions($item);
4431 call_hooks('atom_entry', $o);
4433 $o .= '</entry>' . "\r\n";
4438 function fix_private_photos($s, $uid, $item = null, $cid = 0) {
4440 if(get_config('system','disable_embedded'))
4445 logger('fix_private_photos: check for photos', LOGGER_DEBUG);
4446 $site = substr($a->get_baseurl(),strpos($a->get_baseurl(),'://'));
4451 $img_start = strpos($orig_body, '[img');
4452 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4453 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4454 while( ($img_st_close !== false) && ($img_len !== false) ) {
4456 $img_st_close++; // make it point to AFTER the closing bracket
4457 $image = substr($orig_body, $img_start + $img_st_close, $img_len);
4459 logger('fix_private_photos: found photo ' . $image, LOGGER_DEBUG);
4462 if(stristr($image , $site . '/photo/')) {
4463 // Only embed locally hosted photos
4465 $i = basename($image);
4466 $i = str_replace(array('.jpg','.png','.gif'),array('','',''),$i);
4467 $x = strpos($i,'-');
4470 $res = substr($i,$x+1);
4471 $i = substr($i,0,$x);
4472 $r = q("SELECT * FROM `photo` WHERE `resource-id` = '%s' AND `scale` = %d AND `uid` = %d",
4479 // Check to see if we should replace this photo link with an embedded image
4480 // 1. No need to do so if the photo is public
4481 // 2. If there's a contact-id provided, see if they're in the access list
4482 // for the photo. If so, embed it.
4483 // 3. Otherwise, if we have an item, see if the item permissions match the photo
4484 // permissions, regardless of order but first check to see if they're an exact
4485 // match to save some processing overhead.
4487 if(has_permissions($r[0])) {
4489 $recips = enumerate_permissions($r[0]);
4490 if(in_array($cid, $recips)) {
4495 if(compare_permissions($item,$r[0]))
4500 $data = $r[0]['data'];
4501 $type = $r[0]['type'];
4503 // If a custom width and height were specified, apply before embedding
4504 if(preg_match("/\[img\=([0-9]*)x([0-9]*)\]/is", substr($orig_body, $img_start, $img_st_close), $match)) {
4505 logger('fix_private_photos: scaling photo', LOGGER_DEBUG);
4507 $width = intval($match[1]);
4508 $height = intval($match[2]);
4510 $ph = new Photo($data, $type);
4511 if($ph->is_valid()) {
4512 $ph->scaleImage(max($width, $height));
4513 $data = $ph->imageString();
4514 $type = $ph->getType();
4518 logger('fix_private_photos: replacing photo', LOGGER_DEBUG);
4519 $image = 'data:' . $type . ';base64,' . base64_encode($data);
4520 logger('fix_private_photos: replaced: ' . $image, LOGGER_DATA);
4526 $new_body = $new_body . substr($orig_body, 0, $img_start + $img_st_close) . $image . '[/img]';
4527 $orig_body = substr($orig_body, $img_start + $img_st_close + $img_len + strlen('[/img]'));
4528 if($orig_body === false)
4531 $img_start = strpos($orig_body, '[img');
4532 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4533 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4536 $new_body = $new_body . $orig_body;
4542 function has_permissions($obj) {
4543 if(($obj['allow_cid'] != '') || ($obj['allow_gid'] != '') || ($obj['deny_cid'] != '') || ($obj['deny_gid'] != ''))
4548 function compare_permissions($obj1,$obj2) {
4549 // first part is easy. Check that these are exactly the same.
4550 if(($obj1['allow_cid'] == $obj2['allow_cid'])
4551 && ($obj1['allow_gid'] == $obj2['allow_gid'])
4552 && ($obj1['deny_cid'] == $obj2['deny_cid'])
4553 && ($obj1['deny_gid'] == $obj2['deny_gid']))
4556 // This is harder. Parse all the permissions and compare the resulting set.
4558 $recipients1 = enumerate_permissions($obj1);
4559 $recipients2 = enumerate_permissions($obj2);
4562 if($recipients1 == $recipients2)
4567 // returns an array of contact-ids that are allowed to see this object
4569 function enumerate_permissions($obj) {
4570 require_once('include/group.php');
4571 $allow_people = expand_acl($obj['allow_cid']);
4572 $allow_groups = expand_groups(expand_acl($obj['allow_gid']));
4573 $deny_people = expand_acl($obj['deny_cid']);
4574 $deny_groups = expand_groups(expand_acl($obj['deny_gid']));
4575 $recipients = array_unique(array_merge($allow_people,$allow_groups));
4576 $deny = array_unique(array_merge($deny_people,$deny_groups));
4577 $recipients = array_diff($recipients,$deny);
4581 function item_getfeedtags($item) {
4584 $cnt = preg_match_all('|\#\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4586 for($x = 0; $x < $cnt; $x ++) {
4588 $ret[] = array('#',$matches[1][$x], $matches[2][$x]);
4592 $cnt = preg_match_all('|\@\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4594 for($x = 0; $x < $cnt; $x ++) {
4596 $ret[] = array('@',$matches[1][$x], $matches[2][$x]);
4602 function item_getfeedattach($item) {
4604 $arr = explode('[/attach],',$item['attach']);
4606 foreach($arr as $r) {
4608 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|',$r,$matches);
4610 $ret .= '<link rel="enclosure" href="' . xmlify($matches[1]) . '" type="' . xmlify($matches[3]) . '" ';
4611 if(intval($matches[2]))
4612 $ret .= 'length="' . intval($matches[2]) . '" ';
4613 if($matches[4] !== ' ')
4614 $ret .= 'title="' . xmlify(trim($matches[4])) . '" ';
4615 $ret .= ' />' . "\r\n";
4624 function item_expire($uid, $days, $network = "", $force = false) {
4626 if((! $uid) || ($days < 1))
4629 // $expire_network_only = save your own wall posts
4630 // and just expire conversations started by others
4632 $expire_network_only = get_pconfig($uid,'expire','network_only');
4633 $sql_extra = ((intval($expire_network_only)) ? " AND wall = 0 " : "");
4635 if ($network != "") {
4636 $sql_extra .= sprintf(" AND network = '%s' ", dbesc($network));
4637 // There is an index "uid_network_received" but not "uid_network_created"
4638 // This avoids the creation of another index just for one purpose.
4639 // And it doesn't really matter wether to look at "received" or "created"
4640 $range = "AND `received` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4642 $range = "AND `created` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4644 $r = q("SELECT * FROM `item`
4645 WHERE `uid` = %d $range
4656 $expire_items = get_pconfig($uid, 'expire','items');
4657 $expire_items = (($expire_items===false)?1:intval($expire_items)); // default if not set: 1
4659 // Forcing expiring of items - but not notes and marked items
4661 $expire_items = true;
4663 $expire_notes = get_pconfig($uid, 'expire','notes');
4664 $expire_notes = (($expire_notes===false)?1:intval($expire_notes)); // default if not set: 1
4666 $expire_starred = get_pconfig($uid, 'expire','starred');
4667 $expire_starred = (($expire_starred===false)?1:intval($expire_starred)); // default if not set: 1
4669 $expire_photos = get_pconfig($uid, 'expire','photos');
4670 $expire_photos = (($expire_photos===false)?0:intval($expire_photos)); // default if not set: 0
4672 logger('expire: # items=' . count($r). "; expire items: $expire_items, expire notes: $expire_notes, expire starred: $expire_starred, expire photos: $expire_photos");
4674 foreach($r as $item) {
4676 // don't expire filed items
4678 if(strpos($item['file'],'[') !== false)
4681 // Only expire posts, not photos and photo comments
4683 if($expire_photos==0 && strlen($item['resource-id']))
4685 if($expire_starred==0 && intval($item['starred']))
4687 if($expire_notes==0 && $item['type']=='note')
4689 if($expire_items==0 && $item['type']!='note')
4692 drop_item($item['id'],false);
4695 proc_run('php',"include/notifier.php","expire","$uid");
4700 function drop_items($items) {
4703 if(! local_user() && ! remote_user())
4707 foreach($items as $item) {
4708 $owner = drop_item($item,false);
4709 if($owner && ! $uid)
4714 // multiple threads may have been deleted, send an expire notification
4717 proc_run('php',"include/notifier.php","expire","$uid");
4721 function drop_item($id,$interactive = true) {
4725 // locate item to be deleted
4727 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
4734 notice( t('Item not found.') . EOL);
4735 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4740 $owner = $item['uid'];
4744 // check if logged in user is either the author or owner of this item
4746 if(is_array($_SESSION['remote'])) {
4747 foreach($_SESSION['remote'] as $visitor) {
4748 if($visitor['uid'] == $item['uid'] && $visitor['cid'] == $item['contact-id']) {
4749 $cid = $visitor['cid'];
4756 if((local_user() == $item['uid']) || ($cid) || (! $interactive)) {
4758 // Check if we should do HTML-based delete confirmation
4759 if($_REQUEST['confirm']) {
4760 // <form> can't take arguments in its "action" parameter
4761 // so add any arguments as hidden inputs
4762 $query = explode_querystring($a->query_string);
4764 foreach($query['args'] as $arg) {
4765 if(strpos($arg, 'confirm=') === false) {
4766 $arg_parts = explode('=', $arg);
4767 $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
4771 return replace_macros(get_markup_template('confirm.tpl'), array(
4773 '$message' => t('Do you really want to delete this item?'),
4774 '$extra_inputs' => $inputs,
4775 '$confirm' => t('Yes'),
4776 '$confirm_url' => $query['base'],
4777 '$confirm_name' => 'confirmed',
4778 '$cancel' => t('Cancel'),
4781 // Now check how the user responded to the confirmation query
4782 if($_REQUEST['canceled']) {
4783 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4786 logger('delete item: ' . $item['id'], LOGGER_DEBUG);
4789 $r = q("UPDATE `item` SET `deleted` = 1, `title` = '', `body` = '', `edited` = '%s', `changed` = '%s' WHERE `id` = %d",
4790 dbesc(datetime_convert()),
4791 dbesc(datetime_convert()),
4794 create_tags_from_item($item['id']);
4795 create_files_from_item($item['id']);
4796 delete_thread($item['id'], $item['parent-uri']);
4798 // clean up categories and tags so they don't end up as orphans
4801 $cnt = preg_match_all('/<(.*?)>/',$item['file'],$matches,PREG_SET_ORDER);
4803 foreach($matches as $mtch) {
4804 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],true);
4810 $cnt = preg_match_all('/\[(.*?)\]/',$item['file'],$matches,PREG_SET_ORDER);
4812 foreach($matches as $mtch) {
4813 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],false);
4817 // If item is a link to a photo resource, nuke all the associated photos
4818 // (visitors will not have photo resources)
4819 // This only applies to photos uploaded from the photos page. Photos inserted into a post do not
4820 // generate a resource-id and therefore aren't intimately linked to the item.
4822 if(strlen($item['resource-id'])) {
4823 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `uid` = %d ",
4824 dbesc($item['resource-id']),
4825 intval($item['uid'])
4827 // ignore the result
4830 // If item is a link to an event, nuke the event record.
4832 if(intval($item['event-id'])) {
4833 q("DELETE FROM `event` WHERE `id` = %d AND `uid` = %d",
4834 intval($item['event-id']),
4835 intval($item['uid'])
4837 // ignore the result
4840 // If item has attachments, drop them
4842 foreach(explode(",",$item['attach']) as $attach){
4843 preg_match("|attach/(\d+)|", $attach, $matches);
4844 q("DELETE FROM `attach` WHERE `id` = %d AND `uid` = %d",
4845 intval($matches[1]),
4848 // ignore the result
4852 // clean up item_id and sign meta-data tables
4855 // Old code - caused very long queries and warning entries in the mysql logfiles:
4857 $r = q("DELETE FROM item_id where iid in (select id from item where parent = %d and uid = %d)",
4858 intval($item['id']),
4859 intval($item['uid'])
4862 $r = q("DELETE FROM sign where iid in (select id from item where parent = %d and uid = %d)",
4863 intval($item['id']),
4864 intval($item['uid'])
4868 // The new code splits the queries since the mysql optimizer really has bad problems with subqueries
4870 // Creating list of parents
4871 $r = q("select id from item where parent = %d and uid = %d",
4872 intval($item['id']),
4873 intval($item['uid'])
4878 foreach ($r AS $row) {
4879 if ($parentid != "")
4882 $parentid .= $row["id"];
4886 if ($parentid != "") {
4887 $r = q("DELETE FROM item_id where iid in (%s)", dbesc($parentid));
4889 $r = q("DELETE FROM sign where iid in (%s)", dbesc($parentid));
4892 // If it's the parent of a comment thread, kill all the kids
4894 if($item['uri'] == $item['parent-uri']) {
4895 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = ''
4896 WHERE `parent-uri` = '%s' AND `uid` = %d ",
4897 dbesc(datetime_convert()),
4898 dbesc(datetime_convert()),
4899 dbesc($item['parent-uri']),
4900 intval($item['uid'])
4902 create_tags_from_itemuri($item['parent-uri'], $item['uid']);
4903 create_files_from_itemuri($item['parent-uri'], $item['uid']);
4904 delete_thread_uri($item['parent-uri'], $item['uid']);
4905 // ignore the result
4908 // ensure that last-child is set in case the comment that had it just got wiped.
4909 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
4910 dbesc(datetime_convert()),
4911 dbesc($item['parent-uri']),
4912 intval($item['uid'])
4914 // who is the last child now?
4915 $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",
4916 dbesc($item['parent-uri']),
4917 intval($item['uid'])
4920 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
4925 // Add a relayable_retraction signature for Diaspora.
4926 store_diaspora_retract_sig($item, $a->user, $a->get_baseurl());
4929 $drop_id = intval($item['id']);
4931 // send the notification upstream/downstream as the case may be
4933 proc_run('php',"include/notifier.php","drop","$drop_id");
4937 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4943 notice( t('Permission denied.') . EOL);
4944 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4951 function first_post_date($uid,$wall = false) {
4952 $r = q("select id, created from item
4953 where uid = %d and wall = %d and deleted = 0 and visible = 1 AND moderated = 0
4955 order by created asc limit 1",
4957 intval($wall ? 1 : 0)
4960 // logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA);
4961 return substr(datetime_convert('',date_default_timezone_get(),$r[0]['created']),0,10);
4966 /* modified posted_dates() {below} to arrange the list in years */
4967 function list_post_dates($uid, $wall) {
4968 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
4970 $dthen = first_post_date($uid, $wall);
4974 // Set the start and end date to the beginning of the month
4975 $dnow = substr($dnow,0,8).'01';
4976 $dthen = substr($dthen,0,8).'01';
4980 // Starting with the current month, get the first and last days of every
4981 // month down to and including the month of the first post
4982 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
4983 $dyear = intval(substr($dnow,0,4));
4984 $dstart = substr($dnow,0,8) . '01';
4985 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
4986 $start_month = datetime_convert('','',$dstart,'Y-m-d');
4987 $end_month = datetime_convert('','',$dend,'Y-m-d');
4988 $str = day_translate(datetime_convert('','',$dnow,'F'));
4990 $ret[$dyear] = array();
4991 $ret[$dyear][] = array($str,$end_month,$start_month);
4992 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
4997 function posted_dates($uid,$wall) {
4998 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
5000 $dthen = first_post_date($uid,$wall);
5004 // Set the start and end date to the beginning of the month
5005 $dnow = substr($dnow,0,8).'01';
5006 $dthen = substr($dthen,0,8).'01';
5009 // Starting with the current month, get the first and last days of every
5010 // month down to and including the month of the first post
5011 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
5012 $dstart = substr($dnow,0,8) . '01';
5013 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
5014 $start_month = datetime_convert('','',$dstart,'Y-m-d');
5015 $end_month = datetime_convert('','',$dend,'Y-m-d');
5016 $str = day_translate(datetime_convert('','',$dnow,'F Y'));
5017 $ret[] = array($str,$end_month,$start_month);
5018 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
5024 function posted_date_widget($url,$uid,$wall) {
5027 if(! feature_enabled($uid,'archives'))
5030 // For former Facebook folks that left because of "timeline"
5032 /* if($wall && intval(get_pconfig($uid,'system','no_wall_archive_widget')))
5035 $visible_years = get_pconfig($uid,'system','archive_visible_years');
5036 if(! $visible_years)
5039 $ret = list_post_dates($uid,$wall);
5044 $cutoff_year = intval(datetime_convert('',date_default_timezone_get(),'now','Y')) - $visible_years;
5045 $cutoff = ((array_key_exists($cutoff_year,$ret))? true : false);
5047 $o = replace_macros(get_markup_template('posted_date_widget.tpl'),array(
5048 '$title' => t('Archives'),
5049 '$size' => $visible_years,
5050 '$cutoff_year' => $cutoff_year,
5051 '$cutoff' => $cutoff,
5054 '$showmore' => t('show more')
5060 function store_diaspora_retract_sig($item, $user, $baseurl) {
5061 // Note that we can't add a target_author_signature
5062 // if the comment was deleted by a remote user. That should be ok, because if a remote user is deleting
5063 // the comment, that means we're the home of the post, and Diaspora will only
5064 // check the parent_author_signature of retractions that it doesn't have to relay further
5066 // I don't think this function gets called for an "unlike," but I'll check anyway
5068 $enabled = intval(get_config('system','diaspora_enabled'));
5070 logger('drop_item: diaspora support disabled, not storing retraction signature', LOGGER_DEBUG);
5074 logger('drop_item: storing diaspora retraction signature');
5076 $signed_text = $item['guid'] . ';' . ( ($item['verb'] === ACTIVITY_LIKE) ? 'Like' : 'Comment');
5078 if(local_user() == $item['uid']) {
5080 $handle = $user['nickname'] . '@' . substr($baseurl, strpos($baseurl,'://') + 3);
5081 $authorsig = base64_encode(rsa_sign($signed_text,$user['prvkey'],'sha256'));
5084 $r = q("SELECT `nick`, `url` FROM `contact` WHERE `id` = '%d' LIMIT 1",
5085 $item['contact-id'] // If this function gets called, drop_item() has already checked remote_user() == $item['contact-id']
5088 // The below handle only works for NETWORK_DFRN. I think that's ok, because this function
5089 // only handles DFRN deletes
5090 $handle_baseurl_start = strpos($r['url'],'://') + 3;
5091 $handle_baseurl_length = strpos($r['url'],'/profile') - $handle_baseurl_start;
5092 $handle = $r['nick'] . '@' . substr($r['url'], $handle_baseurl_start, $handle_baseurl_length);
5098 q("insert into sign (`retract_iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
5099 intval($item['id']),
5100 dbesc($signed_text),