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 // Shouldn't happen but we want to make absolutely sure it doesn't leak from a plugin.
1191 // Deactivated, since the bbcode parser can handle with it - and it destroys posts with some smileys that contain "<"
1192 //if((strpos($arr['body'],'<') !== false) || (strpos($arr['body'],'>') !== false))
1193 // $arr['body'] = strip_tags($arr['body']);
1196 if (version_compare(PHP_VERSION, '5.3.0', '>=')) {
1197 require_once('library/langdet/Text/LanguageDetect.php');
1198 $naked_body = preg_replace('/\[(.+?)\]/','',$arr['body']);
1199 $l = new Text_LanguageDetect;
1200 //$lng = $l->detectConfidence($naked_body);
1201 //$arr['postopts'] = (($lng['language']) ? 'lang=' . $lng['language'] . ';' . $lng['confidence'] : '');
1202 $lng = $l->detect($naked_body, 3);
1204 if (sizeof($lng) > 0) {
1207 foreach ($lng as $language => $score) {
1208 if ($postopts == "")
1209 $postopts = "lang=";
1213 $postopts .= $language.";".$score;
1215 $arr['postopts'] = $postopts;
1219 $arr['wall'] = ((x($arr,'wall')) ? intval($arr['wall']) : 0);
1220 $arr['uri'] = ((x($arr,'uri')) ? notags(trim($arr['uri'])) : random_string());
1221 $arr['extid'] = ((x($arr,'extid')) ? notags(trim($arr['extid'])) : '');
1222 $arr['author-name'] = ((x($arr,'author-name')) ? notags(trim($arr['author-name'])) : '');
1223 $arr['author-link'] = ((x($arr,'author-link')) ? notags(trim($arr['author-link'])) : '');
1224 $arr['author-avatar'] = ((x($arr,'author-avatar')) ? notags(trim($arr['author-avatar'])) : '');
1225 $arr['owner-name'] = ((x($arr,'owner-name')) ? notags(trim($arr['owner-name'])) : '');
1226 $arr['owner-link'] = ((x($arr,'owner-link')) ? notags(trim($arr['owner-link'])) : '');
1227 $arr['owner-avatar'] = ((x($arr,'owner-avatar')) ? notags(trim($arr['owner-avatar'])) : '');
1228 $arr['created'] = ((x($arr,'created') !== false) ? datetime_convert('UTC','UTC',$arr['created']) : datetime_convert());
1229 $arr['edited'] = ((x($arr,'edited') !== false) ? datetime_convert('UTC','UTC',$arr['edited']) : datetime_convert());
1230 $arr['commented'] = ((x($arr,'commented') !== false) ? datetime_convert('UTC','UTC',$arr['commented']) : datetime_convert());
1231 $arr['received'] = ((x($arr,'received') !== false) ? datetime_convert('UTC','UTC',$arr['received']) : datetime_convert());
1232 $arr['changed'] = ((x($arr,'changed') !== false) ? datetime_convert('UTC','UTC',$arr['changed']) : datetime_convert());
1233 $arr['title'] = ((x($arr,'title')) ? notags(trim($arr['title'])) : '');
1234 $arr['location'] = ((x($arr,'location')) ? notags(trim($arr['location'])) : '');
1235 $arr['coord'] = ((x($arr,'coord')) ? notags(trim($arr['coord'])) : '');
1236 $arr['last-child'] = ((x($arr,'last-child')) ? intval($arr['last-child']) : 0 );
1237 $arr['visible'] = ((x($arr,'visible') !== false) ? intval($arr['visible']) : 1 );
1238 $arr['deleted'] = 0;
1239 $arr['parent-uri'] = ((x($arr,'parent-uri')) ? notags(trim($arr['parent-uri'])) : '');
1240 $arr['verb'] = ((x($arr,'verb')) ? notags(trim($arr['verb'])) : '');
1241 $arr['object-type'] = ((x($arr,'object-type')) ? notags(trim($arr['object-type'])) : '');
1242 $arr['object'] = ((x($arr,'object')) ? trim($arr['object']) : '');
1243 $arr['target-type'] = ((x($arr,'target-type')) ? notags(trim($arr['target-type'])) : '');
1244 $arr['target'] = ((x($arr,'target')) ? trim($arr['target']) : '');
1245 $arr['plink'] = ((x($arr,'plink')) ? notags(trim($arr['plink'])) : '');
1246 $arr['allow_cid'] = ((x($arr,'allow_cid')) ? trim($arr['allow_cid']) : '');
1247 $arr['allow_gid'] = ((x($arr,'allow_gid')) ? trim($arr['allow_gid']) : '');
1248 $arr['deny_cid'] = ((x($arr,'deny_cid')) ? trim($arr['deny_cid']) : '');
1249 $arr['deny_gid'] = ((x($arr,'deny_gid')) ? trim($arr['deny_gid']) : '');
1250 $arr['private'] = ((x($arr,'private')) ? intval($arr['private']) : 0 );
1251 $arr['bookmark'] = ((x($arr,'bookmark')) ? intval($arr['bookmark']) : 0 );
1252 $arr['body'] = ((x($arr,'body')) ? trim($arr['body']) : '');
1253 $arr['tag'] = ((x($arr,'tag')) ? notags(trim($arr['tag'])) : '');
1254 $arr['attach'] = ((x($arr,'attach')) ? notags(trim($arr['attach'])) : '');
1255 $arr['app'] = ((x($arr,'app')) ? notags(trim($arr['app'])) : '');
1256 $arr['origin'] = ((x($arr,'origin')) ? intval($arr['origin']) : 0 );
1257 $arr['network'] = ((x($arr,'network')) ? trim($arr['network']) : '');
1258 $arr['guid'] = ((x($arr,'guid')) ? notags(trim($arr['guid'])) : get_guid(32, $arr['network']));
1259 $arr['postopts'] = ((x($arr,'postopts')) ? trim($arr['postopts']) : '');
1260 $arr['resource-id'] = ((x($arr,'resource-id')) ? trim($arr['resource-id']) : '');
1261 $arr['event-id'] = ((x($arr,'event-id')) ? intval($arr['event-id']) : 0 );
1262 $arr['inform'] = ((x($arr,'inform')) ? trim($arr['inform']) : '');
1263 $arr['file'] = ((x($arr,'file')) ? trim($arr['file']) : '');
1265 if ($arr['plink'] == "") {
1267 $arr['plink'] = $a->get_baseurl().'/display/'.urlencode($arr['guid']);
1270 if ($arr['network'] == "") {
1271 $r = q("SELECT `network` FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
1272 intval($arr['contact-id']),
1277 $arr['network'] = $r[0]["network"];
1279 // Fallback to friendica (why is it empty in some cases?)
1280 if ($arr['network'] == "")
1281 $arr['network'] = NETWORK_DFRN;
1283 logger("item_store: Set network to ".$arr["network"]." for ".$arr["uri"], LOGGER_DEBUG);
1286 if ($arr['guid'] != "") {
1287 // Checking if there is already an item with the same guid
1288 logger('checking for an item for user '.$arr['uid'].' on network '.$arr['network'].' with the guid '.$arr['guid'], LOGGER_DEBUG);
1289 $r = q("SELECT `guid` FROM `item` WHERE `guid` = '%s' AND `network` = '%s' AND `uid` = '%d' LIMIT 1",
1290 dbesc($arr['guid']), dbesc($arr['network']), intval($arr['uid']));
1293 logger('found item with guid '.$arr['guid'].' for user '.$arr['uid'].' on network '.$arr['network'], LOGGER_DEBUG);
1298 // Check for hashtags in the body and repair or add hashtag links
1299 item_body_set_hashtags($arr);
1301 $arr['thr-parent'] = $arr['parent-uri'];
1302 if($arr['parent-uri'] === $arr['uri']) {
1304 $parent_deleted = 0;
1305 $allow_cid = $arr['allow_cid'];
1306 $allow_gid = $arr['allow_gid'];
1307 $deny_cid = $arr['deny_cid'];
1308 $deny_gid = $arr['deny_gid'];
1309 $notify_type = 'wall-new';
1313 // find the parent and snarf the item id and ACLs
1314 // and anything else we need to inherit
1316 $r = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC LIMIT 1",
1317 dbesc($arr['parent-uri']),
1323 // is the new message multi-level threaded?
1324 // even though we don't support it now, preserve the info
1325 // and re-attach to the conversation parent.
1327 if($r[0]['uri'] != $r[0]['parent-uri']) {
1328 $arr['parent-uri'] = $r[0]['parent-uri'];
1329 $z = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `parent-uri` = '%s' AND `uid` = %d
1330 ORDER BY `id` ASC LIMIT 1",
1331 dbesc($r[0]['parent-uri']),
1332 dbesc($r[0]['parent-uri']),
1339 $parent_id = $r[0]['id'];
1340 $parent_deleted = $r[0]['deleted'];
1341 $allow_cid = $r[0]['allow_cid'];
1342 $allow_gid = $r[0]['allow_gid'];
1343 $deny_cid = $r[0]['deny_cid'];
1344 $deny_gid = $r[0]['deny_gid'];
1345 $arr['wall'] = $r[0]['wall'];
1346 $notify_type = 'comment-new';
1348 // if the parent is private, force privacy for the entire conversation
1349 // This differs from the above settings as it subtly allows comments from
1350 // email correspondents to be private even if the overall thread is not.
1352 if($r[0]['private'])
1353 $arr['private'] = $r[0]['private'];
1355 // Edge case. We host a public forum that was originally posted to privately.
1356 // The original author commented, but as this is a comment, the permissions
1357 // weren't fixed up so it will still show the comment as private unless we fix it here.
1359 if((intval($r[0]['forum_mode']) == 1) && (! $r[0]['private']))
1360 $arr['private'] = 0;
1363 // If its a post from myself then tag the thread as "mention"
1364 logger("item_store: Checking if parent ".$parent_id." has to be tagged as mention for user ".$arr['uid'], LOGGER_DEBUG);
1365 $u = q("select * from user where uid = %d limit 1", intval($arr['uid']));
1368 $self = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1369 logger("item_store: 'myself' is ".$self." for parent ".$parent_id." checking against ".$arr['author-link']." and ".$arr['owner-link'], LOGGER_DEBUG);
1370 if ((normalise_link($arr['author-link']) == $self) OR (normalise_link($arr['owner-link']) == $self)) {
1371 q("UPDATE `thread` SET `mention` = 1 WHERE `iid` = %d", intval($parent_id));
1372 logger("item_store: tagged thread ".$parent_id." as mention for user ".$self, LOGGER_DEBUG);
1378 // Allow one to see reply tweets from status.net even when
1379 // we don't have or can't see the original post.
1382 logger('item_store: $force_parent=true, reply converted to top-level post.');
1384 $arr['parent-uri'] = $arr['uri'];
1385 $arr['gravity'] = 0;
1388 logger('item_store: item parent was not found - ignoring item');
1392 $parent_deleted = 0;
1396 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `network` = '%s' AND `uid` = %d LIMIT 1",
1398 dbesc($arr['network']),
1401 if($r && count($r)) {
1402 logger('duplicated item with the same uri found. ' . print_r($arr,true));
1406 // Check for an existing post with the same content. There seems to be a problem with OStatus.
1407 $r = q("SELECT `id` FROM `item` WHERE `body` = '%s' AND `network` = '%s' AND `created` = '%s' AND `contact-id` = %d AND `uid` = %d LIMIT 1",
1408 dbesc($arr['body']),
1409 dbesc($arr['network']),
1410 dbesc($arr['created']),
1411 intval($arr['contact-id']),
1414 if($r && count($r)) {
1415 logger('duplicated item with the same body found. ' . print_r($arr,true));
1419 // Is this item available in the global items (with uid=0)?
1420 if ($arr["uid"] == 0) {
1421 $arr["global"] = true;
1423 q("UPDATE `item` SET `global` = 1 WHERE `guid` = '%s'", dbesc($arr["guid"]));
1425 $isglobal = q("SELECT `global` FROM `item` WHERE `uid` = 0 AND `guid` = '%s'", dbesc($arr["guid"]));
1427 $arr["global"] = (count($isglobal) > 0);
1430 // Fill the cache field
1431 put_item_in_cache($arr);
1433 call_hooks('post_remote',$arr);
1435 if(x($arr,'cancel')) {
1436 logger('item_store: post cancelled by plugin.');
1440 // Store the unescaped version
1445 logger('item_store: ' . print_r($arr,true), LOGGER_DATA);
1447 $r = dbq("INSERT INTO `item` (`"
1448 . implode("`, `", array_keys($arr))
1450 . implode("', '", array_values($arr))
1456 // find the item we just created
1457 $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = %d ORDER BY `id` ASC ",
1464 // Store the guid and other relevant data
1467 $current_post = $r[0]['id'];
1468 logger('item_store: created item ' . $current_post);
1470 // Set "success_update" and "last-item" to the date of the last time we heard from this contact
1471 // This can be used to filter for inactive contacts.
1472 // Only do this for public postings to avoid privacy problems, since poco data is public.
1473 // Don't set this value if it isn't from the owner (could be an author that we don't know)
1475 $update = (!$arr['private'] AND (($arr["author-link"] === $arr["owner-link"]) OR ($arr["parent-uri"] === $arr["uri"])));
1477 // Is it a forum? Then we don't care about the rules from above
1478 if (!$update AND ($arr["network"] == NETWORK_DFRN) AND ($arr["parent-uri"] === $arr["uri"])) {
1479 $isforum = q("SELECT `forum` FROM `contact` WHERE `id` = %d AND `forum`",
1480 intval($arr['contact-id']));
1486 q("UPDATE `contact` SET `success_update` = '%s', `last-item` = '%s' WHERE `id` = %d",
1487 dbesc($arr['received']),
1488 dbesc($arr['received']),
1489 intval($arr['contact-id'])
1492 logger('item_store: could not locate created item');
1496 logger('item_store: duplicated post occurred. Removing duplicates. uri = '.$arr['uri'].' uid = '.$arr['uid']);
1497 q("DELETE FROM `item` WHERE `uri` = '%s' AND `uid` = %d AND `id` != %d ",
1499 intval($arr['uid']),
1500 intval($current_post)
1504 if((! $parent_id) || ($arr['parent-uri'] === $arr['uri']))
1505 $parent_id = $current_post;
1507 if(strlen($allow_cid) || strlen($allow_gid) || strlen($deny_cid) || strlen($deny_gid))
1510 $private = $arr['private'];
1512 // Set parent id - and also make sure to inherit the parent's ACLs.
1514 $r = q("UPDATE `item` SET `parent` = %d, `allow_cid` = '%s', `allow_gid` = '%s',
1515 `deny_cid` = '%s', `deny_gid` = '%s', `private` = %d, `deleted` = %d WHERE `id` = %d",
1522 intval($parent_deleted),
1523 intval($current_post)
1526 // Complete ostatus threads
1527 if ($ostatus_conversation)
1528 complete_conversation($current_post, $ostatus_conversation);
1530 $arr['id'] = $current_post;
1531 $arr['parent'] = $parent_id;
1532 $arr['allow_cid'] = $allow_cid;
1533 $arr['allow_gid'] = $allow_gid;
1534 $arr['deny_cid'] = $deny_cid;
1535 $arr['deny_gid'] = $deny_gid;
1536 $arr['private'] = $private;
1537 $arr['deleted'] = $parent_deleted;
1539 // update the commented timestamp on the parent
1540 // Only update "commented" if it is really a comment
1541 if (($arr['verb'] == ACTIVITY_POST) OR !get_config("system", "like_no_comment"))
1542 q("UPDATE `item` SET `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
1543 dbesc(datetime_convert()),
1544 dbesc(datetime_convert()),
1548 q("UPDATE `item` SET `changed` = '%s' WHERE `id` = %d",
1549 dbesc(datetime_convert()),
1554 q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
1555 intval($current_post),
1556 dbesc($dsprsig->signed_text),
1557 dbesc($dsprsig->signature),
1558 dbesc($dsprsig->signer)
1564 * If this is now the last-child, force all _other_ children of this parent to *not* be last-child
1567 if($arr['last-child']) {
1568 $r = q("UPDATE `item` SET `last-child` = 0 WHERE `parent-uri` = '%s' AND `uid` = %d AND `id` != %d",
1570 intval($arr['uid']),
1571 intval($current_post)
1575 $deleted = tag_deliver($arr['uid'],$current_post);
1577 // current post can be deleted if is for a community page and no mention are
1579 if (!$deleted AND !$dontcache) {
1581 $r = q('SELECT * FROM `item` WHERE id = %d', intval($current_post));
1582 if (count($r) == 1) {
1583 call_hooks('post_remote_end', $r[0]);
1585 logger('item_store: new item not found in DB, id ' . $current_post);
1588 // Add every contact of the post to the global contact table
1591 create_tags_from_item($current_post);
1592 create_files_from_item($current_post);
1594 // Only check for notifications on start posts
1595 if ($arr['parent-uri'] === $arr['uri']) {
1596 add_thread($current_post);
1597 logger('item_store: Check notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1599 // Send a notification for every new post?
1600 $r = q("SELECT `notify_new_posts` FROM `contact` WHERE `id` = %d AND `uid` = %d AND `notify_new_posts` LIMIT 1",
1601 intval($arr['contact-id']),
1604 $send_notification = count($r);
1606 if (!$send_notification) {
1607 $tags = q("SELECT `url` FROM `term` WHERE `otype` = %d AND `oid` = %d AND `type` = %d AND `uid` = %d",
1608 intval(TERM_OBJ_POST), intval($current_post), intval(TERM_MENTION), intval($arr['uid']));
1611 foreach ($tags AS $tag) {
1612 $r = q("SELECT `id` FROM `contact` WHERE `nurl` = '%s' AND `uid` = %d AND `notify_new_posts`",
1613 normalise_link($tag["url"]), intval($arr['uid']));
1615 $send_notification = true;
1620 if ($send_notification) {
1621 logger('item_store: Send notification for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1622 $u = q("SELECT * FROM user WHERE uid = %d LIMIT 1",
1623 intval($arr['uid']));
1625 $item = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d",
1626 intval($current_post),
1632 require_once('include/enotify.php');
1634 'type' => NOTIFY_SHARE,
1635 'notify_flags' => $u[0]['notify-flags'],
1636 'language' => $u[0]['language'],
1637 'to_name' => $u[0]['username'],
1638 'to_email' => $u[0]['email'],
1639 'uid' => $u[0]['uid'],
1641 'link' => $a->get_baseurl().'/display/'.urlencode($arr['guid']),
1642 'source_name' => $item[0]['author-name'],
1643 'source_link' => $item[0]['author-link'],
1644 'source_photo' => $item[0]['author-avatar'],
1645 'verb' => ACTIVITY_TAG,
1647 'parent' => $arr['parent']
1649 logger('item_store: Notification sent for contact '.$arr['contact-id'].' and post '.$current_post, LOGGER_DEBUG);
1652 update_thread($parent_id);
1653 add_shadow_entry($arr);
1657 proc_run('php', "include/notifier.php", $notify_type, $current_post);
1659 return $current_post;
1662 function item_body_set_hashtags(&$item) {
1664 $tags = get_tags($item["body"]);
1670 // This sorting is important when there are hashtags that are part of other hashtags
1671 // Otherwise there could be problems with hashtags like #test and #test2
1676 $URLSearchString = "^\[\]";
1678 // All hashtags should point to the home server
1679 //$item["body"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1680 // "#[url=".$a->get_baseurl()."/search?tag=$2]$2[/url]", $item["body"]);
1682 //$item["tag"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1683 // "#[url=".$a->get_baseurl()."/search?tag=$2]$2[/url]", $item["tag"]);
1685 // mask hashtags inside of url, bookmarks and attachments to avoid urls in urls
1686 $item["body"] = preg_replace_callback("/\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1688 return("[url=".str_replace("#", "#", $match[1])."]".str_replace("#", "#", $match[2])."[/url]");
1691 $item["body"] = preg_replace_callback("/\[bookmark\=([$URLSearchString]*)\](.*?)\[\/bookmark\]/ism",
1693 return("[bookmark=".str_replace("#", "#", $match[1])."]".str_replace("#", "#", $match[2])."[/bookmark]");
1696 $item["body"] = preg_replace_callback("/\[attachment (.*)\](.*?)\[\/attachment\]/ism",
1698 return("[attachment ".str_replace("#", "#", $match[1])."]".$match[2]."[/attachment]");
1701 // Repair recursive urls
1702 $item["body"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
1703 "#$2", $item["body"]);
1706 foreach($tags as $tag) {
1707 if(strpos($tag,'#') !== 0)
1710 if(strpos($tag,'[url='))
1713 $basetag = str_replace('_',' ',substr($tag,1));
1715 $newtag = '#[url='.$a->get_baseurl().'/search?tag='.rawurlencode($basetag).']'.$basetag.'[/url]';
1717 $item["body"] = str_replace($tag, $newtag, $item["body"]);
1719 if(!stristr($item["tag"],"/search?tag=".$basetag."]".$basetag."[/url]")) {
1720 if(strlen($item["tag"]))
1721 $item["tag"] = ','.$item["tag"];
1722 $item["tag"] = $newtag.$item["tag"];
1726 // Convert back the masked hashtags
1727 $item["body"] = str_replace("#", "#", $item["body"]);
1730 function get_item_guid($id) {
1731 $r = q("SELECT `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($id));
1733 return($r[0]["guid"]);
1738 function get_item_id($guid, $uid = 0) {
1744 $uid == local_user();
1746 // Does the given user have this item?
1748 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1749 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1750 AND `item`.`guid` = '%s' AND `item`.`uid` = %d", dbesc($guid), intval($uid));
1753 $nick = $r[0]["nickname"];
1757 // Or is it anywhere on the server?
1759 $r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
1760 WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1761 AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = ''
1762 AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
1763 AND `item`.`private` = 0 AND `item`.`wall` = 1
1764 AND `item`.`guid` = '%s'", dbesc($guid));
1767 $nick = $r[0]["nickname"];
1770 return(array("nick" => $nick, "id" => $id));
1774 function get_item_contact($item,$contacts) {
1775 if(! count($contacts) || (! is_array($item)))
1777 foreach($contacts as $contact) {
1778 if($contact['id'] == $item['contact-id']) {
1780 break; // NOTREACHED
1787 * look for mention tags and setup a second delivery chain for forum/community posts if appropriate
1789 * @param int $item_id
1790 * @return bool true if item was deleted, else false
1792 function tag_deliver($uid,$item_id) {
1800 $u = q("select * from user where uid = %d limit 1",
1806 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1807 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1810 $i = q("select * from item where id = %d and uid = %d limit 1",
1819 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1821 // Diaspora uses their own hardwired link URL in @-tags
1822 // instead of the one we supply with webfinger
1824 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1826 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1828 foreach($matches as $mtch) {
1829 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1831 logger('tag_deliver: mention found: ' . $mtch[2]);
1837 if ( ($community_page || $prvgroup) &&
1838 (!$item['wall']) && (!$item['origin']) && ($item['id'] == $item['parent'])){
1839 // mmh.. no mention.. community page or private group... no wall.. no origin.. top-post (not a comment)
1841 logger("tag_deliver: no-mention top-level post to communuty or private group. delete.");
1842 q("DELETE FROM item WHERE id = %d and uid = %d",
1852 // send a notification
1854 // use a local photo if we have one
1856 $r = q("select * from contact where uid = %d and nurl = '%s' limit 1",
1857 intval($u[0]['uid']),
1858 dbesc(normalise_link($item['author-link']))
1860 $photo = (($r && count($r)) ? $r[0]['thumb'] : $item['author-avatar']);
1863 require_once('include/enotify.php');
1865 'type' => NOTIFY_TAGSELF,
1866 'notify_flags' => $u[0]['notify-flags'],
1867 'language' => $u[0]['language'],
1868 'to_name' => $u[0]['username'],
1869 'to_email' => $u[0]['email'],
1870 'uid' => $u[0]['uid'],
1872 'link' => $a->get_baseurl() . '/display/'.urlencode(get_item_guid($item['id'])),
1873 'source_name' => $item['author-name'],
1874 'source_link' => $item['author-link'],
1875 'source_photo' => $photo,
1876 'verb' => ACTIVITY_TAG,
1878 'parent' => $item['parent']
1882 $arr = array('item' => $item, 'user' => $u[0], 'contact' => $r[0]);
1884 call_hooks('tagged', $arr);
1886 if((! $community_page) && (! $prvgroup))
1890 // tgroup delivery - setup a second delivery chain
1891 // prevent delivery looping - only proceed
1892 // if the message originated elsewhere and is a top-level post
1894 if(($item['wall']) || ($item['origin']) || ($item['id'] != $item['parent']))
1897 // now change this copy of the post to a forum head message and deliver to all the tgroup members
1900 $c = q("select name, url, thumb from contact where self = 1 and uid = %d limit 1",
1901 intval($u[0]['uid'])
1906 // also reset all the privacy bits to the forum default permissions
1908 $private = ($u[0]['allow_cid'] || $u[0]['allow_gid'] || $u[0]['deny_cid'] || $u[0]['deny_gid']) ? 1 : 0;
1910 $forum_mode = (($prvgroup) ? 2 : 1);
1912 q("update item set wall = 1, origin = 1, forum_mode = %d, `owner-name` = '%s', `owner-link` = '%s', `owner-avatar` = '%s',
1913 `private` = %d, `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s' where id = %d",
1914 intval($forum_mode),
1915 dbesc($c[0]['name']),
1916 dbesc($c[0]['url']),
1917 dbesc($c[0]['thumb']),
1919 dbesc($u[0]['allow_cid']),
1920 dbesc($u[0]['allow_gid']),
1921 dbesc($u[0]['deny_cid']),
1922 dbesc($u[0]['deny_gid']),
1925 update_thread($item_id);
1927 proc_run('php','include/notifier.php','tgroup',$item_id);
1933 function tgroup_check($uid,$item) {
1939 // check that the message originated elsewhere and is a top-level post
1941 if(($item['wall']) || ($item['origin']) || ($item['uri'] != $item['parent-uri']))
1945 $u = q("select * from user where uid = %d limit 1",
1951 $community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
1952 $prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
1955 $link = normalise_link($a->get_baseurl() . '/profile/' . $u[0]['nickname']);
1957 // Diaspora uses their own hardwired link URL in @-tags
1958 // instead of the one we supply with webfinger
1960 $dlink = normalise_link($a->get_baseurl() . '/u/' . $u[0]['nickname']);
1962 $cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism',$item['body'],$matches,PREG_SET_ORDER);
1964 foreach($matches as $mtch) {
1965 if(link_compare($link,$mtch[1]) || link_compare($dlink,$mtch[1])) {
1967 logger('tgroup_check: mention found: ' . $mtch[2]);
1975 if((! $community_page) && (! $prvgroup))
1989 function dfrn_deliver($owner,$contact,$atom, $dissolve = false) {
1993 $idtosend = $orig_id = (($contact['dfrn-id']) ? $contact['dfrn-id'] : $contact['issued-id']);
1995 if($contact['duplex'] && $contact['dfrn-id'])
1996 $idtosend = '0:' . $orig_id;
1997 if($contact['duplex'] && $contact['issued-id'])
1998 $idtosend = '1:' . $orig_id;
2000 $rino = ((function_exists('mcrypt_encrypt')) ? 1 : 0);
2002 $rino_enable = get_config('system','rino_encrypt');
2007 $ssl_val = intval(get_config('system','ssl_policy'));
2011 case SSL_POLICY_FULL:
2012 $ssl_policy = 'full';
2014 case SSL_POLICY_SELFSIGN:
2015 $ssl_policy = 'self';
2017 case SSL_POLICY_NONE:
2019 $ssl_policy = 'none';
2023 $url = $contact['notify'] . '&dfrn_id=' . $idtosend . '&dfrn_version=' . DFRN_PROTOCOL_VERSION . (($rino) ? '&rino=1' : '');
2025 logger('dfrn_deliver: ' . $url);
2027 $xml = fetch_url($url);
2029 $curl_stat = $a->get_curl_code();
2031 return(-1); // timed out
2033 logger('dfrn_deliver: ' . $xml, LOGGER_DATA);
2038 if(strpos($xml,'<?xml') === false) {
2039 logger('dfrn_deliver: no valid XML returned');
2040 logger('dfrn_deliver: returned XML: ' . $xml, LOGGER_DATA);
2044 $res = parse_xml_string($xml);
2046 if((intval($res->status) != 0) || (! strlen($res->challenge)) || (! strlen($res->dfrn_id)))
2047 return (($res->status) ? $res->status : 3);
2049 $postvars = array();
2050 $sent_dfrn_id = hex2bin((string) $res->dfrn_id);
2051 $challenge = hex2bin((string) $res->challenge);
2052 $perm = (($res->perm) ? $res->perm : null);
2053 $dfrn_version = (float) (($res->dfrn_version) ? $res->dfrn_version : 2.0);
2054 $rino_allowed = ((intval($res->rino) === 1) ? 1 : 0);
2055 $page = (($owner['page-flags'] == PAGE_COMMUNITY) ? 1 : 0);
2057 if($owner['page-flags'] == PAGE_PRVGROUP)
2060 $final_dfrn_id = '';
2063 if((($perm == 'rw') && (! intval($contact['writable'])))
2064 || (($perm == 'r') && (intval($contact['writable'])))) {
2065 q("update contact set writable = %d where id = %d",
2066 intval(($perm == 'rw') ? 1 : 0),
2067 intval($contact['id'])
2069 $contact['writable'] = (string) 1 - intval($contact['writable']);
2073 if(($contact['duplex'] && strlen($contact['pubkey']))
2074 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
2075 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
2076 openssl_public_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['pubkey']);
2077 openssl_public_decrypt($challenge,$postvars['challenge'],$contact['pubkey']);
2080 openssl_private_decrypt($sent_dfrn_id,$final_dfrn_id,$contact['prvkey']);
2081 openssl_private_decrypt($challenge,$postvars['challenge'],$contact['prvkey']);
2084 $final_dfrn_id = substr($final_dfrn_id, 0, strpos($final_dfrn_id, '.'));
2086 if(strpos($final_dfrn_id,':') == 1)
2087 $final_dfrn_id = substr($final_dfrn_id,2);
2089 if($final_dfrn_id != $orig_id) {
2090 logger('dfrn_deliver: wrong dfrn_id.');
2091 // did not decode properly - cannot trust this site
2095 $postvars['dfrn_id'] = $idtosend;
2096 $postvars['dfrn_version'] = DFRN_PROTOCOL_VERSION;
2098 $postvars['dissolve'] = '1';
2101 if((($contact['rel']) && ($contact['rel'] != CONTACT_IS_SHARING) && (! $contact['blocked'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
2102 $postvars['data'] = $atom;
2103 $postvars['perm'] = 'rw';
2106 $postvars['data'] = str_replace('<dfrn:comment-allow>1','<dfrn:comment-allow>0',$atom);
2107 $postvars['perm'] = 'r';
2110 $postvars['ssl_policy'] = $ssl_policy;
2113 $postvars['page'] = $page;
2115 if($rino && $rino_allowed && (! $dissolve)) {
2116 $key = substr(random_string(),0,16);
2117 $data = bin2hex(aes_encrypt($postvars['data'],$key));
2118 $postvars['data'] = $data;
2119 logger('rino: sent key = ' . $key, LOGGER_DEBUG);
2122 if($dfrn_version >= 2.1) {
2123 if(($contact['duplex'] && strlen($contact['pubkey']))
2124 || ($owner['page-flags'] == PAGE_COMMUNITY && strlen($contact['pubkey']))
2125 || ($contact['rel'] == CONTACT_IS_SHARING && strlen($contact['pubkey']))) {
2127 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
2130 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
2134 if(($contact['duplex'] && strlen($contact['prvkey'])) || ($owner['page-flags'] == PAGE_COMMUNITY)) {
2135 openssl_private_encrypt($key,$postvars['key'],$contact['prvkey']);
2138 openssl_public_encrypt($key,$postvars['key'],$contact['pubkey']);
2142 logger('md5 rawkey ' . md5($postvars['key']));
2144 $postvars['key'] = bin2hex($postvars['key']);
2147 logger('dfrn_deliver: ' . "SENDING: " . print_r($postvars,true), LOGGER_DATA);
2149 $xml = post_url($contact['notify'],$postvars);
2151 logger('dfrn_deliver: ' . "RECEIVED: " . $xml, LOGGER_DATA);
2153 $curl_stat = $a->get_curl_code();
2154 if((! $curl_stat) || (! strlen($xml)))
2155 return(-1); // timed out
2157 if(($curl_stat == 503) && (stristr($a->get_curl_headers(),'retry-after')))
2160 if(strpos($xml,'<?xml') === false) {
2161 logger('dfrn_deliver: phase 2: no valid XML returned');
2162 logger('dfrn_deliver: phase 2: returned XML: ' . $xml, LOGGER_DATA);
2166 if($contact['term-date'] != '0000-00-00 00:00:00') {
2167 logger("dfrn_deliver: $url back from the dead - removing mark for death");
2168 require_once('include/Contact.php');
2169 unmark_for_death($contact);
2172 $res = parse_xml_string($xml);
2174 return $res->status;
2179 This function returns true if $update has an edited timestamp newer
2180 than $existing, i.e. $update contains new data which should override
2181 what's already there. If there is no timestamp yet, the update is
2182 assumed to be newer. If the update has no timestamp, the existing
2183 item is assumed to be up-to-date. If the timestamps are equal it
2184 assumes the update has been seen before and should be ignored.
2186 function edited_timestamp_is_newer($existing, $update) {
2187 if (!x($existing,'edited') || !$existing['edited']) {
2190 if (!x($update,'edited') || !$update['edited']) {
2193 $existing_edited = datetime_convert('UTC', 'UTC', $existing['edited']);
2194 $update_edited = datetime_convert('UTC', 'UTC', $update['edited']);
2195 return (strcmp($existing_edited, $update_edited) < 0);
2200 * consume_feed - process atom feed and update anything/everything we might need to update
2202 * $xml = the (atom) feed to consume - RSS isn't as fully supported but may work for simple feeds.
2204 * $importer = the contact_record (joined to user_record) of the local user who owns this relationship.
2205 * It is this person's stuff that is going to be updated.
2206 * $contact = the person who is sending us stuff. If not set, we MAY be processing a "follow" activity
2207 * from an external network and MAY create an appropriate contact record. Otherwise, we MUST
2208 * have a contact record.
2209 * $hub = should we find a hub declation in the feed, pass it back to our calling process, who might (or
2210 * might not) try and subscribe to it.
2211 * $datedir sorts in reverse order
2212 * $pass - by default ($pass = 0) we cannot guarantee that a parent item has been
2213 * imported prior to its children being seen in the stream unless we are certain
2214 * of how the feed is arranged/ordered.
2215 * With $pass = 1, we only pull parent items out of the stream.
2216 * With $pass = 2, we only pull children (comments/likes).
2218 * So running this twice, first with pass 1 and then with pass 2 will do the right
2219 * thing regardless of feed ordering. This won't be adequate in a fully-threaded
2220 * model where comments can have sub-threads. That would require some massive sorting
2221 * to get all the feed items into a mostly linear ordering, and might still require
2225 function consume_feed($xml,$importer,&$contact, &$hub, $datedir = 0, $pass = 0) {
2227 require_once('library/simplepie/simplepie.inc');
2228 require_once('include/contact_selectors.php');
2230 if(! strlen($xml)) {
2231 logger('consume_feed: empty input');
2235 // Test - remove before flight
2236 // if ($contact['network'] === NETWORK_OSTATUS) {
2237 // $tempfile = tempnam(get_temppath(), "ostatus");
2238 // file_put_contents($tempfile, $xml);
2241 $feed = new SimplePie();
2242 $feed->set_raw_data($xml);
2244 $feed->enable_order_by_date(true);
2246 $feed->enable_order_by_date(false);
2250 logger('consume_feed: Error parsing XML: ' . $feed->error());
2252 $permalink = $feed->get_permalink();
2254 // Check at the feed level for updated contact name and/or photo
2258 $photo_timestamp = '';
2261 $contact_updated = '';
2263 $hubs = $feed->get_links('hub');
2264 logger('consume_feed: hubs: ' . print_r($hubs,true), LOGGER_DATA);
2267 $hub = implode(',', $hubs);
2269 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
2271 $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
2273 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
2274 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
2275 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
2276 $new_name = $elems['name'][0]['data'];
2278 // Manually checking for changed contact names
2279 if (($new_name != $contact['name']) AND ($new_name != "") AND ($name_updated <= $contact['name-date'])) {
2280 $name_updated = date("c");
2281 $photo_timestamp = date("c");
2284 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
2285 if ($photo_timestamp == "")
2286 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
2287 $photo_url = $elems['link'][0]['attribs']['']['href'];
2290 if((x($rawtags[0]['child'], NAMESPACE_DFRN)) && (x($rawtags[0]['child'][NAMESPACE_DFRN],'birthday'))) {
2291 $birthday = datetime_convert('UTC','UTC', $rawtags[0]['child'][NAMESPACE_DFRN]['birthday'][0]['data']);
2295 if((is_array($contact)) && ($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $contact['avatar-date'])) {
2296 logger('consume_feed: Updating photo for '.$contact['name'].' from '.$photo_url.' uid: '.$contact['uid']);
2298 $contact_updated = $photo_timestamp;
2300 require_once("include/Photo.php");
2301 $photo_failure = false;
2302 $have_photo = false;
2304 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
2305 intval($contact['id']),
2306 intval($contact['uid'])
2309 $resource_id = $r[0]['resource-id'];
2313 $resource_id = photo_new_resource();
2316 $img_str = fetch_url($photo_url,true);
2317 // guess mimetype from headers or filename
2318 $type = guess_image_type($photo_url,true);
2321 $img = new Photo($img_str, $type);
2322 if($img->is_valid()) {
2324 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
2325 dbesc($resource_id),
2326 intval($contact['id']),
2327 intval($contact['uid'])
2331 $img->scaleImageSquare(175);
2333 $hash = $resource_id;
2334 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 4);
2336 $img->scaleImage(80);
2337 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 5);
2339 $img->scaleImage(48);
2340 $r = $img->store($contact['uid'], $contact['id'], $hash, basename($photo_url), 'Contact Photos', 6);
2344 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
2345 WHERE `uid` = %d AND `id` = %d",
2346 dbesc(datetime_convert()),
2347 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
2348 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
2349 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
2350 intval($contact['uid']),
2351 intval($contact['id'])
2356 if((is_array($contact)) && ($name_updated) && (strlen($new_name)) && ($name_updated > $contact['name-date'])) {
2357 if ($name_updated > $contact_updated)
2358 $contact_updated = $name_updated;
2360 $r = q("select * from contact where uid = %d and id = %d limit 1",
2361 intval($contact['uid']),
2362 intval($contact['id'])
2365 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
2366 dbesc(notags(trim($new_name))),
2367 dbesc(datetime_convert()),
2368 intval($contact['uid']),
2369 intval($contact['id'])
2372 // do our best to update the name on content items
2375 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
2376 dbesc(notags(trim($new_name))),
2377 dbesc($r[0]['name']),
2378 dbesc($r[0]['url']),
2379 intval($contact['uid'])
2384 if ($contact_updated AND $new_name AND $photo_url)
2385 poco_check($contact['url'], $new_name, NETWORK_DFRN, $photo_url, "", "", "", "", "", $contact_updated, 2, $contact['id'], $contact['uid']);
2387 if(strlen($birthday)) {
2388 if(substr($birthday,0,4) != $contact['bdyear']) {
2389 logger('consume_feed: updating birthday: ' . $birthday);
2393 * Add new birthday event for this person
2395 * $bdtext is just a readable placeholder in case the event is shared
2396 * with others. We will replace it during presentation to our $importer
2397 * to contain a sparkle link and perhaps a photo.
2401 $bdtext = sprintf( t('%s\'s birthday'), $contact['name']);
2402 $bdtext2 = sprintf( t('Happy Birthday %s'), ' [url=' . $contact['url'] . ']' . $contact['name'] . '[/url]' ) ;
2405 $r = q("INSERT INTO `event` (`uid`,`cid`,`created`,`edited`,`start`,`finish`,`summary`,`desc`,`type`)
2406 VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s' ) ",
2407 intval($contact['uid']),
2408 intval($contact['id']),
2409 dbesc(datetime_convert()),
2410 dbesc(datetime_convert()),
2411 dbesc(datetime_convert('UTC','UTC', $birthday)),
2412 dbesc(datetime_convert('UTC','UTC', $birthday . ' + 1 day ')),
2421 q("UPDATE `contact` SET `bdyear` = '%s' WHERE `uid` = %d AND `id` = %d",
2422 dbesc(substr($birthday,0,4)),
2423 intval($contact['uid']),
2424 intval($contact['id'])
2427 // This function is called twice without reloading the contact
2428 // Make sure we only create one event. This is why &$contact
2429 // is a reference var in this function
2431 $contact['bdyear'] = substr($birthday,0,4);
2435 $community_page = 0;
2436 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
2438 $community_page = intval($rawtags[0]['data']);
2440 if(is_array($contact) && intval($contact['forum']) != $community_page) {
2441 q("update contact set forum = %d where id = %d",
2442 intval($community_page),
2443 intval($contact['id'])
2445 $contact['forum'] = (string) $community_page;
2449 // process any deleted entries
2451 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
2452 if(is_array($del_entries) && count($del_entries) && $pass != 2) {
2453 foreach($del_entries as $dentry) {
2455 if(isset($dentry['attribs']['']['ref'])) {
2456 $uri = $dentry['attribs']['']['ref'];
2458 if(isset($dentry['attribs']['']['when'])) {
2459 $when = $dentry['attribs']['']['when'];
2460 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
2463 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
2465 if($deleted && is_array($contact)) {
2466 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN `contact` on `item`.`contact-id` = `contact`.`id`
2467 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
2469 intval($importer['uid']),
2470 intval($contact['id'])
2475 if(! $item['deleted'])
2476 logger('consume_feed: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
2478 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2479 $xo = parse_xml_string($item['object'],false);
2480 $xt = parse_xml_string($item['target'],false);
2481 if($xt->type === ACTIVITY_OBJ_NOTE) {
2482 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
2484 intval($importer['importer_uid'])
2488 // For tags, the owner cannot remove the tag on the author's copy of the post.
2490 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
2491 $author_remove = (($item['origin'] && $item['self']) ? true : false);
2492 $author_copy = (($item['origin']) ? true : false);
2494 if($owner_remove && $author_copy)
2496 if($author_remove || $owner_remove) {
2497 $tags = explode(',',$i[0]['tag']);
2500 foreach($tags as $tag)
2501 if(trim($tag) !== trim($xo->body))
2502 $newtags[] = trim($tag);
2504 q("update item set tag = '%s' where id = %d",
2505 dbesc(implode(',',$newtags)),
2508 create_tags_from_item($i[0]['id']);
2514 if($item['uri'] == $item['parent-uri']) {
2515 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2516 `body` = '', `title` = ''
2517 WHERE `parent-uri` = '%s' AND `uid` = %d",
2519 dbesc(datetime_convert()),
2520 dbesc($item['uri']),
2521 intval($importer['uid'])
2523 create_tags_from_itemuri($item['uri'], $importer['uid']);
2524 create_files_from_itemuri($item['uri'], $importer['uid']);
2525 update_thread_uri($item['uri'], $importer['uid']);
2528 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
2529 `body` = '', `title` = ''
2530 WHERE `uri` = '%s' AND `uid` = %d",
2532 dbesc(datetime_convert()),
2534 intval($importer['uid'])
2536 create_tags_from_itemuri($uri, $importer['uid']);
2537 create_files_from_itemuri($uri, $importer['uid']);
2538 if($item['last-child']) {
2539 // ensure that last-child is set in case the comment that had it just got wiped.
2540 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
2541 dbesc(datetime_convert()),
2542 dbesc($item['parent-uri']),
2543 intval($item['uid'])
2545 // who is the last child now?
2546 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `moderated` = 0 AND `uid` = %d
2547 ORDER BY `created` DESC LIMIT 1",
2548 dbesc($item['parent-uri']),
2549 intval($importer['uid'])
2552 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
2563 // Now process the feed
2565 if($feed->get_item_quantity()) {
2567 logger('consume_feed: feed item count = ' . $feed->get_item_quantity());
2569 // in inverse date order
2571 $items = array_reverse($feed->get_items());
2573 $items = $feed->get_items();
2576 foreach($items as $item) {
2579 $item_id = $item->get_id();
2580 $rawthread = $item->get_item_tags( NAMESPACE_THREAD,'in-reply-to');
2581 if(isset($rawthread[0]['attribs']['']['ref'])) {
2583 $parent_uri = $rawthread[0]['attribs']['']['ref'];
2586 if(($is_reply) && is_array($contact)) {
2591 // not allowed to post
2593 if($contact['rel'] == CONTACT_IS_FOLLOWER)
2597 // Have we seen it? If not, import it.
2599 $item_id = $item->get_id();
2600 $datarray = get_atom_elements($feed, $item, $contact);
2602 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2603 $datarray['author-name'] = $contact['name'];
2604 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2605 $datarray['author-link'] = $contact['url'];
2606 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2607 $datarray['author-avatar'] = $contact['thumb'];
2609 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2610 logger('consume_feed: no author information! ' . print_r($datarray,true));
2614 $force_parent = false;
2615 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2616 if($contact['network'] === NETWORK_OSTATUS)
2617 $force_parent = true;
2618 if(strlen($datarray['title']))
2619 unset($datarray['title']);
2620 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2621 dbesc(datetime_convert()),
2623 intval($importer['uid'])
2625 $datarray['last-child'] = 1;
2626 update_thread_uri($parent_uri, $importer['uid']);
2630 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2632 intval($importer['uid'])
2635 // Update content if 'updated' changes
2638 if (edited_timestamp_is_newer($r[0], $datarray)) {
2640 // do not accept (ignore) an earlier edit than one we currently have.
2641 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2644 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2645 dbesc($datarray['title']),
2646 dbesc($datarray['body']),
2647 dbesc($datarray['tag']),
2648 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2649 dbesc(datetime_convert()),
2651 intval($importer['uid'])
2653 create_tags_from_itemuri($item_id, $importer['uid']);
2654 update_thread_uri($item_id, $importer['uid']);
2657 // update last-child if it changes
2659 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2660 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
2661 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
2662 dbesc(datetime_convert()),
2664 intval($importer['uid'])
2666 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2667 intval($allow[0]['data']),
2668 dbesc(datetime_convert()),
2670 intval($importer['uid'])
2672 update_thread_uri($item_id, $importer['uid']);
2678 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2679 // one way feed - no remote comment ability
2680 $datarray['last-child'] = 0;
2682 $datarray['parent-uri'] = $parent_uri;
2683 $datarray['uid'] = $importer['uid'];
2684 $datarray['contact-id'] = $contact['id'];
2685 if((activity_match($datarray['verb'],ACTIVITY_LIKE)) || (activity_match($datarray['verb'],ACTIVITY_DISLIKE))) {
2686 $datarray['type'] = 'activity';
2687 $datarray['gravity'] = GRAVITY_LIKE;
2688 // only one like or dislike per person
2689 // splitted into two queries for performance issues
2690 $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",
2691 intval($datarray['uid']),
2692 intval($datarray['contact-id']),
2693 dbesc($datarray['verb']),
2699 $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",
2700 intval($datarray['uid']),
2701 intval($datarray['contact-id']),
2702 dbesc($datarray['verb']),
2709 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
2710 $xo = parse_xml_string($datarray['object'],false);
2711 $xt = parse_xml_string($datarray['target'],false);
2713 if($xt->type == ACTIVITY_OBJ_NOTE) {
2714 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
2716 intval($importer['importer_uid'])
2721 // extract tag, if not duplicate, add to parent item
2722 if($xo->id && $xo->content) {
2723 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
2724 if(! (stristr($r[0]['tag'],$newtag))) {
2725 q("UPDATE item SET tag = '%s' WHERE id = %d",
2726 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . $newtag),
2729 create_tags_from_item($r[0]['id']);
2735 $r = item_store($datarray,$force_parent);
2741 // Head post of a conversation. Have we seen it? If not, import it.
2743 $item_id = $item->get_id();
2745 $datarray = get_atom_elements($feed, $item, $contact);
2747 if(is_array($contact)) {
2748 if((! x($datarray,'author-name')) && ($contact['network'] != NETWORK_DFRN))
2749 $datarray['author-name'] = $contact['name'];
2750 if((! x($datarray,'author-link')) && ($contact['network'] != NETWORK_DFRN))
2751 $datarray['author-link'] = $contact['url'];
2752 if((! x($datarray,'author-avatar')) && ($contact['network'] != NETWORK_DFRN))
2753 $datarray['author-avatar'] = $contact['thumb'];
2756 if((! x($datarray,'author-name')) || (! x($datarray,'author-link'))) {
2757 logger('consume_feed: no author information! ' . print_r($datarray,true));
2761 // special handling for events
2763 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
2764 $ev = bbtoevent($datarray['body']);
2765 if(x($ev,'desc') && x($ev,'start')) {
2766 $ev['uid'] = $importer['uid'];
2767 $ev['uri'] = $item_id;
2768 $ev['edited'] = $datarray['edited'];
2769 $ev['private'] = $datarray['private'];
2771 if(is_array($contact))
2772 $ev['cid'] = $contact['id'];
2773 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2775 intval($importer['uid'])
2778 $ev['id'] = $r[0]['id'];
2779 $xyz = event_store($ev);
2784 if($contact['network'] === NETWORK_OSTATUS || stristr($contact['url'],'twitter.com')) {
2785 if(strlen($datarray['title']))
2786 unset($datarray['title']);
2787 $datarray['last-child'] = 1;
2791 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
2793 intval($importer['uid'])
2796 // Update content if 'updated' changes
2799 if (edited_timestamp_is_newer($r[0], $datarray)) {
2801 // do not accept (ignore) an earlier edit than one we currently have.
2802 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
2805 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2806 dbesc($datarray['title']),
2807 dbesc($datarray['body']),
2808 dbesc($datarray['tag']),
2809 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
2810 dbesc(datetime_convert()),
2812 intval($importer['uid'])
2814 create_tags_from_itemuri($item_id, $importer['uid']);
2815 update_thread_uri($item_id, $importer['uid']);
2818 // update last-child if it changes
2820 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
2821 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
2822 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
2823 intval($allow[0]['data']),
2824 dbesc(datetime_convert()),
2826 intval($importer['uid'])
2828 update_thread_uri($item_id, $importer['uid']);
2833 if(activity_match($datarray['verb'],ACTIVITY_FOLLOW)) {
2834 logger('consume-feed: New follower');
2835 new_follower($importer,$contact,$datarray,$item);
2838 if(activity_match($datarray['verb'],ACTIVITY_UNFOLLOW)) {
2839 lose_follower($importer,$contact,$datarray,$item);
2843 if(activity_match($datarray['verb'],ACTIVITY_REQ_FRIEND)) {
2844 logger('consume-feed: New friend request');
2845 new_follower($importer,$contact,$datarray,$item,true);
2848 if(activity_match($datarray['verb'],ACTIVITY_UNFRIEND)) {
2849 lose_sharer($importer,$contact,$datarray,$item);
2854 if(! is_array($contact))
2858 if(($contact['network'] === NETWORK_FEED) || (! strlen($contact['notify']))) {
2859 // one way feed - no remote comment ability
2860 $datarray['last-child'] = 0;
2862 if($contact['network'] === NETWORK_FEED)
2863 $datarray['private'] = 2;
2865 $datarray['parent-uri'] = $item_id;
2866 $datarray['uid'] = $importer['uid'];
2867 $datarray['contact-id'] = $contact['id'];
2869 if(! link_compare($datarray['owner-link'],$contact['url'])) {
2870 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
2871 // but otherwise there's a possible data mixup on the sender's system.
2872 // the tgroup delivery code called from item_store will correct it if it's a forum,
2873 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
2874 logger('consume_feed: Correcting item owner.', LOGGER_DEBUG);
2875 $datarray['owner-name'] = $contact['name'];
2876 $datarray['owner-link'] = $contact['url'];
2877 $datarray['owner-avatar'] = $contact['thumb'];
2880 // We've allowed "followers" to reach this point so we can decide if they are
2881 // posting an @-tag delivery, which followers are allowed to do for certain
2882 // page types. Now that we've parsed the post, let's check if it is legit. Otherwise ignore it.
2884 if(($contact['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['uid'],$datarray)))
2887 // This is my contact on another system, but it's really me.
2888 // Turn this into a wall post.
2889 $notify = item_is_remote_self($contact, $datarray);
2891 $r = item_store($datarray, false, $notify);
2892 logger('Stored - Contact '.$contact['url'].' Notify '.$notify.' return '.$r.' Item '.print_r($datarray, true), LOGGER_DEBUG);
2900 function item_is_remote_self($contact, &$datarray) {
2903 if (!$contact['remote_self'])
2906 // Prevent the forwarding of posts that are forwarded
2907 if ($datarray["extid"] == NETWORK_DFRN)
2910 // Prevent to forward already forwarded posts
2911 if ($datarray["app"] == $a->get_hostname())
2914 // Only forward posts
2915 if ($datarray["verb"] != ACTIVITY_POST)
2918 if (($contact['network'] != NETWORK_FEED) AND $datarray['private'])
2921 $datarray2 = $datarray;
2922 logger('remote-self start - Contact '.$contact['url'].' - '.$contact['remote_self'].' Item '.print_r($datarray, true), LOGGER_DEBUG);
2923 if ($contact['remote_self'] == 2) {
2924 $r = q("SELECT `id`,`url`,`name`,`thumb` FROM `contact` WHERE `uid` = %d AND `self`",
2925 intval($contact['uid']));
2927 $datarray['contact-id'] = $r[0]["id"];
2929 $datarray['owner-name'] = $r[0]["name"];
2930 $datarray['owner-link'] = $r[0]["url"];
2931 $datarray['owner-avatar'] = $r[0]["thumb"];
2933 $datarray['author-name'] = $datarray['owner-name'];
2934 $datarray['author-link'] = $datarray['owner-link'];
2935 $datarray['author-avatar'] = $datarray['owner-avatar'];
2938 if ($contact['network'] != NETWORK_FEED) {
2939 $datarray["guid"] = get_guid(32);
2940 unset($datarray["plink"]);
2941 $datarray["uri"] = item_new_uri($a->get_hostname(),$contact['uid']);
2942 $datarray["parent-uri"] = $datarray["uri"];
2943 $datarray["extid"] = $contact['network'];
2944 $urlpart = parse_url($datarray2['author-link']);
2945 $datarray["app"] = $urlpart["host"];
2947 $datarray['private'] = 0;
2950 //if (!isset($datarray["app"]) OR ($datarray["app"] == ""))
2951 // $datarray["app"] = network_to_name($contact['network']);
2953 if ($contact['network'] != NETWORK_FEED) {
2954 // Store the original post
2955 $r = item_store($datarray2, false, false);
2956 logger('remote-self post original item - Contact '.$contact['url'].' return '.$r.' Item '.print_r($datarray2, true), LOGGER_DEBUG);
2958 $datarray["app"] = "Feed";
2963 function local_delivery($importer,$data) {
2966 logger(__function__, LOGGER_TRACE);
2968 if($importer['readonly']) {
2969 // We aren't receiving stuff from this person. But we will quietly ignore them
2970 // rather than a blatant "go away" message.
2971 logger('local_delivery: ignoring');
2976 // Consume notification feed. This may differ from consuming a public feed in several ways
2977 // - might contain email or friend suggestions
2978 // - might contain remote followup to our message
2979 // - in which case we need to accept it and then notify other conversants
2980 // - we may need to send various email notifications
2982 $feed = new SimplePie();
2983 $feed->set_raw_data($data);
2984 $feed->enable_order_by_date(false);
2989 logger('local_delivery: Error parsing XML: ' . $feed->error());
2992 // Check at the feed level for updated contact name and/or photo
2996 $photo_timestamp = '';
2998 $contact_updated = '';
3001 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'owner');
3003 // Fallback should not be needed here. If it isn't DFRN it won't have DFRN updated tags
3005 // $rawtags = $feed->get_feed_tags( SIMPLEPIE_NAMESPACE_ATOM_10, 'author');
3008 $elems = $rawtags[0]['child'][SIMPLEPIE_NAMESPACE_ATOM_10];
3009 if($elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated']) {
3010 $name_updated = $elems['name'][0]['attribs'][NAMESPACE_DFRN]['updated'];
3011 $new_name = $elems['name'][0]['data'];
3013 // Manually checking for changed contact names
3014 if (($new_name != $importer['name']) AND ($new_name != "") AND ($name_updated <= $importer['name-date'])) {
3015 $name_updated = date("c");
3016 $photo_timestamp = date("c");
3019 if((x($elems,'link')) && ($elems['link'][0]['attribs']['']['rel'] === 'photo') && ($elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated'])) {
3020 if ($photo_timestamp == "")
3021 $photo_timestamp = datetime_convert('UTC','UTC',$elems['link'][0]['attribs'][NAMESPACE_DFRN]['updated']);
3022 $photo_url = $elems['link'][0]['attribs']['']['href'];
3026 if(($photo_timestamp) && (strlen($photo_url)) && ($photo_timestamp > $importer['avatar-date'])) {
3028 $contact_updated = $photo_timestamp;
3030 logger('local_delivery: Updating photo for ' . $importer['name']);
3031 require_once("include/Photo.php");
3032 $photo_failure = false;
3033 $have_photo = false;
3035 $r = q("SELECT `resource-id` FROM `photo` WHERE `contact-id` = %d AND `uid` = %d LIMIT 1",
3036 intval($importer['id']),
3037 intval($importer['importer_uid'])
3040 $resource_id = $r[0]['resource-id'];
3044 $resource_id = photo_new_resource();
3047 $img_str = fetch_url($photo_url,true);
3048 // guess mimetype from headers or filename
3049 $type = guess_image_type($photo_url,true);
3052 $img = new Photo($img_str, $type);
3053 if($img->is_valid()) {
3055 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `contact-id` = %d AND `uid` = %d",
3056 dbesc($resource_id),
3057 intval($importer['id']),
3058 intval($importer['importer_uid'])
3062 $img->scaleImageSquare(175);
3064 $hash = $resource_id;
3065 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 4);
3067 $img->scaleImage(80);
3068 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 5);
3070 $img->scaleImage(48);
3071 $r = $img->store($importer['importer_uid'], $importer['id'], $hash, basename($photo_url), 'Contact Photos', 6);
3075 q("UPDATE `contact` SET `avatar-date` = '%s', `photo` = '%s', `thumb` = '%s', `micro` = '%s'
3076 WHERE `uid` = %d AND `id` = %d",
3077 dbesc(datetime_convert()),
3078 dbesc($a->get_baseurl() . '/photo/' . $hash . '-4.'.$img->getExt()),
3079 dbesc($a->get_baseurl() . '/photo/' . $hash . '-5.'.$img->getExt()),
3080 dbesc($a->get_baseurl() . '/photo/' . $hash . '-6.'.$img->getExt()),
3081 intval($importer['importer_uid']),
3082 intval($importer['id'])
3087 if(($name_updated) && (strlen($new_name)) && ($name_updated > $importer['name-date'])) {
3088 if ($name_updated > $contact_updated)
3089 $contact_updated = $name_updated;
3091 $r = q("select * from contact where uid = %d and id = %d limit 1",
3092 intval($importer['importer_uid']),
3093 intval($importer['id'])
3096 $x = q("UPDATE `contact` SET `name` = '%s', `name-date` = '%s' WHERE `uid` = %d AND `id` = %d",
3097 dbesc(notags(trim($new_name))),
3098 dbesc(datetime_convert()),
3099 intval($importer['importer_uid']),
3100 intval($importer['id'])
3103 // do our best to update the name on content items
3106 q("update item set `author-name` = '%s' where `author-name` = '%s' and `author-link` = '%s' and uid = %d",
3107 dbesc(notags(trim($new_name))),
3108 dbesc($r[0]['name']),
3109 dbesc($r[0]['url']),
3110 intval($importer['importer_uid'])
3115 if ($contact_updated AND $new_name AND $photo_url)
3116 poco_check($importer['url'], $new_name, NETWORK_DFRN, $photo_url, "", "", "", "", "", $contact_updated, 2, $importer['id'], $importer['importer_uid']);
3118 // Currently unsupported - needs a lot of work
3119 $reloc = $feed->get_feed_tags( NAMESPACE_DFRN, 'relocate' );
3120 if(isset($reloc[0]['child'][NAMESPACE_DFRN])) {
3121 $base = $reloc[0]['child'][NAMESPACE_DFRN];
3123 $newloc['uid'] = $importer['importer_uid'];
3124 $newloc['cid'] = $importer['id'];
3125 $newloc['name'] = notags(unxmlify($base['name'][0]['data']));
3126 $newloc['photo'] = notags(unxmlify($base['photo'][0]['data']));
3127 $newloc['thumb'] = notags(unxmlify($base['thumb'][0]['data']));
3128 $newloc['micro'] = notags(unxmlify($base['micro'][0]['data']));
3129 $newloc['url'] = notags(unxmlify($base['url'][0]['data']));
3130 $newloc['request'] = notags(unxmlify($base['request'][0]['data']));
3131 $newloc['confirm'] = notags(unxmlify($base['confirm'][0]['data']));
3132 $newloc['notify'] = notags(unxmlify($base['notify'][0]['data']));
3133 $newloc['poll'] = notags(unxmlify($base['poll'][0]['data']));
3134 $newloc['sitepubkey'] = notags(unxmlify($base['sitepubkey'][0]['data']));
3135 /** relocated user must have original key pair */
3136 /*$newloc['pubkey'] = notags(unxmlify($base['pubkey'][0]['data']));
3137 $newloc['prvkey'] = notags(unxmlify($base['prvkey'][0]['data']));*/
3139 logger("items:relocate contact ".print_r($newloc, true).print_r($importer, true), LOGGER_DEBUG);
3142 $r = q("SELECT photo, url FROM contact WHERE id=%d AND uid=%d;",
3143 intval($importer['id']),
3144 intval($importer['importer_uid']));
3149 $x = q("UPDATE contact SET
3160 `site-pubkey` = '%s'
3161 WHERE id=%d AND uid=%d;",
3162 dbesc($newloc['name']),
3163 dbesc($newloc['photo']),
3164 dbesc($newloc['thumb']),
3165 dbesc($newloc['micro']),
3166 dbesc($newloc['url']),
3167 dbesc(normalise_link($newloc['url'])),
3168 dbesc($newloc['request']),
3169 dbesc($newloc['confirm']),
3170 dbesc($newloc['notify']),
3171 dbesc($newloc['poll']),
3172 dbesc($newloc['sitepubkey']),
3173 intval($importer['id']),
3174 intval($importer['importer_uid']));
3180 'owner-link' => array($old['url'], $newloc['url']),
3181 'author-link' => array($old['url'], $newloc['url']),
3182 'owner-avatar' => array($old['photo'], $newloc['photo']),
3183 'author-avatar' => array($old['photo'], $newloc['photo']),
3185 foreach ($fields as $n=>$f){
3186 $x = q("UPDATE `item` SET `%s`='%s' WHERE `%s`='%s' AND uid=%d",
3189 intval($importer['importer_uid']));
3195 // merge with current record, current contents have priority
3196 // update record, set url-updated
3197 // update profile photos
3203 // handle friend suggestion notification
3205 $sugg = $feed->get_feed_tags( NAMESPACE_DFRN, 'suggest' );
3206 if(isset($sugg[0]['child'][NAMESPACE_DFRN])) {
3207 $base = $sugg[0]['child'][NAMESPACE_DFRN];
3209 $fsugg['uid'] = $importer['importer_uid'];
3210 $fsugg['cid'] = $importer['id'];
3211 $fsugg['name'] = notags(unxmlify($base['name'][0]['data']));
3212 $fsugg['photo'] = notags(unxmlify($base['photo'][0]['data']));
3213 $fsugg['url'] = notags(unxmlify($base['url'][0]['data']));
3214 $fsugg['request'] = notags(unxmlify($base['request'][0]['data']));
3215 $fsugg['body'] = escape_tags(unxmlify($base['note'][0]['data']));
3217 // Does our member already have a friend matching this description?
3219 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `nurl` = '%s' AND `uid` = %d LIMIT 1",
3220 dbesc($fsugg['name']),
3221 dbesc(normalise_link($fsugg['url'])),
3222 intval($fsugg['uid'])
3227 // Do we already have an fcontact record for this person?
3230 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
3231 dbesc($fsugg['url']),
3232 dbesc($fsugg['name']),
3233 dbesc($fsugg['request'])
3238 // OK, we do. Do we already have an introduction for this person ?
3239 $r = q("select id from intro where uid = %d and fid = %d limit 1",
3240 intval($fsugg['uid']),
3247 $r = q("INSERT INTO `fcontact` ( `name`,`url`,`photo`,`request` ) VALUES ( '%s', '%s', '%s', '%s' ) ",
3248 dbesc($fsugg['name']),
3249 dbesc($fsugg['url']),
3250 dbesc($fsugg['photo']),
3251 dbesc($fsugg['request'])
3253 $r = q("SELECT * FROM `fcontact` WHERE `url` = '%s' AND `name` = '%s' AND `request` = '%s' LIMIT 1",
3254 dbesc($fsugg['url']),
3255 dbesc($fsugg['name']),
3256 dbesc($fsugg['request'])
3261 // database record did not get created. Quietly give up.
3266 $hash = random_string();
3268 $r = q("INSERT INTO `intro` ( `uid`, `fid`, `contact-id`, `note`, `hash`, `datetime`, `blocked` )
3269 VALUES( %d, %d, %d, '%s', '%s', '%s', %d )",
3270 intval($fsugg['uid']),
3272 intval($fsugg['cid']),
3273 dbesc($fsugg['body']),
3275 dbesc(datetime_convert()),
3280 'type' => NOTIFY_SUGGEST,
3281 'notify_flags' => $importer['notify-flags'],
3282 'language' => $importer['language'],
3283 'to_name' => $importer['username'],
3284 'to_email' => $importer['email'],
3285 'uid' => $importer['importer_uid'],
3287 'link' => $a->get_baseurl() . '/notifications/intros',
3288 'source_name' => $importer['name'],
3289 'source_link' => $importer['url'],
3290 'source_photo' => $importer['photo'],
3291 'verb' => ACTIVITY_REQ_FRIEND,
3300 $rawmail = $feed->get_feed_tags( NAMESPACE_DFRN, 'mail' );
3301 if(isset($rawmail[0]['child'][NAMESPACE_DFRN])) {
3303 logger('local_delivery: private message received');
3306 $base = $rawmail[0]['child'][NAMESPACE_DFRN];
3309 $msg['uid'] = $importer['importer_uid'];
3310 $msg['from-name'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['name'][0]['data']));
3311 $msg['from-photo'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['avatar'][0]['data']));
3312 $msg['from-url'] = notags(unxmlify($base['sender'][0]['child'][NAMESPACE_DFRN]['uri'][0]['data']));
3313 $msg['contact-id'] = $importer['id'];
3314 $msg['title'] = notags(unxmlify($base['subject'][0]['data']));
3315 $msg['body'] = escape_tags(unxmlify($base['content'][0]['data']));
3317 $msg['replied'] = 0;
3318 $msg['uri'] = notags(unxmlify($base['id'][0]['data']));
3319 $msg['parent-uri'] = notags(unxmlify($base['in-reply-to'][0]['data']));
3320 $msg['created'] = datetime_convert(notags(unxmlify('UTC','UTC',$base['sentdate'][0]['data'])));
3324 $r = dbq("INSERT INTO `mail` (`" . implode("`, `", array_keys($msg))
3325 . "`) VALUES ('" . implode("', '", array_values($msg)) . "')" );
3327 // send notifications.
3329 require_once('include/enotify.php');
3331 $notif_params = array(
3332 'type' => NOTIFY_MAIL,
3333 'notify_flags' => $importer['notify-flags'],
3334 'language' => $importer['language'],
3335 'to_name' => $importer['username'],
3336 'to_email' => $importer['email'],
3337 'uid' => $importer['importer_uid'],
3339 'source_name' => $msg['from-name'],
3340 'source_link' => $importer['url'],
3341 'source_photo' => $importer['thumb'],
3342 'verb' => ACTIVITY_POST,
3346 notification($notif_params);
3352 $community_page = 0;
3353 $rawtags = $feed->get_feed_tags( NAMESPACE_DFRN, 'community');
3355 $community_page = intval($rawtags[0]['data']);
3357 if(intval($importer['forum']) != $community_page) {
3358 q("update contact set forum = %d where id = %d",
3359 intval($community_page),
3360 intval($importer['id'])
3362 $importer['forum'] = (string) $community_page;
3365 logger('local_delivery: feed item count = ' . $feed->get_item_quantity());
3367 // process any deleted entries
3369 $del_entries = $feed->get_feed_tags(NAMESPACE_TOMB, 'deleted-entry');
3370 if(is_array($del_entries) && count($del_entries)) {
3371 foreach($del_entries as $dentry) {
3373 if(isset($dentry['attribs']['']['ref'])) {
3374 $uri = $dentry['attribs']['']['ref'];
3376 if(isset($dentry['attribs']['']['when'])) {
3377 $when = $dentry['attribs']['']['when'];
3378 $when = datetime_convert('UTC','UTC', $when, 'Y-m-d H:i:s');
3381 $when = datetime_convert('UTC','UTC','now','Y-m-d H:i:s');
3385 // check for relayed deletes to our conversation
3388 $r = q("select * from item where uri = '%s' and uid = %d limit 1",
3390 intval($importer['importer_uid'])
3393 $parent_uri = $r[0]['parent-uri'];
3394 if($r[0]['id'] != $r[0]['parent'])
3401 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3404 logger('local_delivery: possible community delete');
3407 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3409 // was the top-level post for this reply written by somebody on this site?
3410 // Specifically, the recipient?
3412 $is_a_remote_delete = false;
3414 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3415 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3416 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3417 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3418 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3419 AND `item`.`uid` = %d
3425 intval($importer['importer_uid'])
3428 $is_a_remote_delete = true;
3430 // Does this have the characteristics of a community or private group comment?
3431 // If it's a reply to a wall post on a community/prvgroup page it's a
3432 // valid community comment. Also forum_mode makes it valid for sure.
3433 // If neither, it's not.
3435 if($is_a_remote_delete && $community) {
3436 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3437 $is_a_remote_delete = false;
3438 logger('local_delivery: not a community delete');
3442 if($is_a_remote_delete) {
3443 logger('local_delivery: received remote delete');
3447 $r = q("SELECT `item`.*, `contact`.`self` FROM `item` INNER JOIN contact on `item`.`contact-id` = `contact`.`id`
3448 WHERE `uri` = '%s' AND `item`.`uid` = %d AND `contact-id` = %d AND NOT `item`.`file` LIKE '%%[%%' LIMIT 1",
3450 intval($importer['importer_uid']),
3451 intval($importer['id'])
3457 if($item['deleted'])
3460 logger('local_delivery: deleting item ' . $item['id'] . ' uri=' . $item['uri'], LOGGER_DEBUG);
3462 if(($item['verb'] === ACTIVITY_TAG) && ($item['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3463 $xo = parse_xml_string($item['object'],false);
3464 $xt = parse_xml_string($item['target'],false);
3466 if($xt->type === ACTIVITY_OBJ_NOTE) {
3467 $i = q("select * from `item` where uri = '%s' and uid = %d limit 1",
3469 intval($importer['importer_uid'])
3473 // For tags, the owner cannot remove the tag on the author's copy of the post.
3475 $owner_remove = (($item['contact-id'] == $i[0]['contact-id']) ? true: false);
3476 $author_remove = (($item['origin'] && $item['self']) ? true : false);
3477 $author_copy = (($item['origin']) ? true : false);
3479 if($owner_remove && $author_copy)
3481 if($author_remove || $owner_remove) {
3482 $tags = explode(',',$i[0]['tag']);
3485 foreach($tags as $tag)
3486 if(trim($tag) !== trim($xo->body))
3487 $newtags[] = trim($tag);
3489 q("update item set tag = '%s' where id = %d",
3490 dbesc(implode(',',$newtags)),
3493 create_tags_from_item($i[0]['id']);
3499 if($item['uri'] == $item['parent-uri']) {
3500 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3501 `body` = '', `title` = ''
3502 WHERE `parent-uri` = '%s' AND `uid` = %d",
3504 dbesc(datetime_convert()),
3505 dbesc($item['uri']),
3506 intval($importer['importer_uid'])
3508 create_tags_from_itemuri($item['uri'], $importer['importer_uid']);
3509 create_files_from_itemuri($item['uri'], $importer['importer_uid']);
3510 update_thread_uri($item['uri'], $importer['importer_uid']);
3513 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s',
3514 `body` = '', `title` = ''
3515 WHERE `uri` = '%s' AND `uid` = %d",
3517 dbesc(datetime_convert()),
3519 intval($importer['importer_uid'])
3521 create_tags_from_itemuri($uri, $importer['importer_uid']);
3522 create_files_from_itemuri($uri, $importer['importer_uid']);
3523 update_thread_uri($uri, $importer['importer_uid']);
3524 if($item['last-child']) {
3525 // ensure that last-child is set in case the comment that had it just got wiped.
3526 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
3527 dbesc(datetime_convert()),
3528 dbesc($item['parent-uri']),
3529 intval($item['uid'])
3531 // who is the last child now?
3532 $r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d
3533 ORDER BY `created` DESC LIMIT 1",
3534 dbesc($item['parent-uri']),
3535 intval($importer['importer_uid'])
3538 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
3543 // if this is a relayed delete, propagate it to other recipients
3545 if($is_a_remote_delete)
3546 proc_run('php',"include/notifier.php","drop",$item['id']);
3554 foreach($feed->get_items() as $item) {
3557 $item_id = $item->get_id();
3558 $rawthread = $item->get_item_tags( NAMESPACE_THREAD, 'in-reply-to');
3559 if(isset($rawthread[0]['attribs']['']['ref'])) {
3561 $parent_uri = $rawthread[0]['attribs']['']['ref'];
3567 if($importer['page-flags'] == PAGE_COMMUNITY || $importer['page-flags'] == PAGE_PRVGROUP ) {
3570 logger('local_delivery: possible community reply');
3573 $sql_extra = " and contact.self = 1 and item.wall = 1 ";
3575 // was the top-level post for this reply written by somebody on this site?
3576 // Specifically, the recipient?
3578 $is_a_remote_comment = false;
3579 $top_uri = $parent_uri;
3581 $r = q("select `item`.`parent-uri` from `item`
3582 WHERE `item`.`uri` = '%s'
3586 if($r && count($r)) {
3587 $top_uri = $r[0]['parent-uri'];
3589 // POSSIBLE CLEANUP --> Why select so many fields when only forum_mode and wall are used?
3590 $r = q("select `item`.`id`, `item`.`uri`, `item`.`tag`, `item`.`forum_mode`,`item`.`origin`,`item`.`wall`,
3591 `contact`.`name`, `contact`.`url`, `contact`.`thumb` from `item`
3592 INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
3593 WHERE `item`.`uri` = '%s' AND (`item`.`parent-uri` = '%s' or `item`.`thr-parent` = '%s')
3594 AND `item`.`uid` = %d
3600 intval($importer['importer_uid'])
3603 $is_a_remote_comment = true;
3606 // Does this have the characteristics of a community or private group comment?
3607 // If it's a reply to a wall post on a community/prvgroup page it's a
3608 // valid community comment. Also forum_mode makes it valid for sure.
3609 // If neither, it's not.
3611 if($is_a_remote_comment && $community) {
3612 if((! $r[0]['forum_mode']) && (! $r[0]['wall'])) {
3613 $is_a_remote_comment = false;
3614 logger('local_delivery: not a community reply');
3618 if($is_a_remote_comment) {
3619 logger('local_delivery: received remote comment');
3621 // remote reply to our post. Import and then notify everybody else.
3623 $datarray = get_atom_elements($feed, $item);
3625 $r = q("SELECT `id`, `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3627 intval($importer['importer_uid'])
3630 // Update content if 'updated' changes
3634 if (edited_timestamp_is_newer($r[0], $datarray)) {
3636 // do not accept (ignore) an earlier edit than one we currently have.
3637 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3640 logger('received updated comment' , LOGGER_DEBUG);
3641 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3642 dbesc($datarray['title']),
3643 dbesc($datarray['body']),
3644 dbesc($datarray['tag']),
3645 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3646 dbesc(datetime_convert()),
3648 intval($importer['importer_uid'])
3650 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3652 proc_run('php',"include/notifier.php","comment-import",$iid);
3661 $own = q("select name,url,thumb from contact where uid = %d and self = 1 limit 1",
3662 intval($importer['importer_uid'])
3666 $datarray['type'] = 'remote-comment';
3667 $datarray['wall'] = 1;
3668 $datarray['parent-uri'] = $parent_uri;
3669 $datarray['uid'] = $importer['importer_uid'];
3670 $datarray['owner-name'] = $own[0]['name'];
3671 $datarray['owner-link'] = $own[0]['url'];
3672 $datarray['owner-avatar'] = $own[0]['thumb'];
3673 $datarray['contact-id'] = $importer['id'];
3675 if(($datarray['verb'] === ACTIVITY_LIKE) || ($datarray['verb'] === ACTIVITY_DISLIKE)) {
3677 $datarray['type'] = 'activity';
3678 $datarray['gravity'] = GRAVITY_LIKE;
3679 $datarray['last-child'] = 0;
3680 // only one like or dislike per person
3681 // splitted into two queries for performance issues
3682 $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",
3683 intval($datarray['uid']),
3684 intval($datarray['contact-id']),
3685 dbesc($datarray['verb']),
3686 dbesc($datarray['parent-uri'])
3692 $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",
3693 intval($datarray['uid']),
3694 intval($datarray['contact-id']),
3695 dbesc($datarray['verb']),
3696 dbesc($datarray['parent-uri'])
3703 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3705 $xo = parse_xml_string($datarray['object'],false);
3706 $xt = parse_xml_string($datarray['target'],false);
3708 if(($xt->type == ACTIVITY_OBJ_NOTE) && ($xt->id)) {
3710 // fetch the parent item
3712 $tagp = q("select * from item where uri = '%s' and uid = %d limit 1",
3714 intval($importer['importer_uid'])
3719 // extract tag, if not duplicate, and this user allows tags, add to parent item
3721 if($xo->id && $xo->content) {
3722 $newtag = '#[url=' . $xo->id . ']'. $xo->content . '[/url]';
3723 if(! (stristr($tagp[0]['tag'],$newtag))) {
3724 $i = q("SELECT `blocktags` FROM `user` where `uid` = %d LIMIT 1",
3725 intval($importer['importer_uid'])
3727 if(count($i) && ! intval($i[0]['blocktags'])) {
3728 q("UPDATE item SET tag = '%s', `edited` = '%s', `changed` = '%s' WHERE id = %d",
3729 dbesc($tagp[0]['tag'] . (strlen($tagp[0]['tag']) ? ',' : '') . $newtag),
3730 intval($tagp[0]['id']),
3731 dbesc(datetime_convert()),
3732 dbesc(datetime_convert())
3734 create_tags_from_item($tagp[0]['id']);
3742 $posted_id = item_store($datarray);
3747 $datarray["id"] = $posted_id;
3749 $r = q("SELECT `parent`, `parent-uri` FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
3751 intval($importer['importer_uid'])
3754 $parent = $r[0]['parent'];
3755 $parent_uri = $r[0]['parent-uri'];
3759 $r1 = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `uid` = %d AND `parent` = %d",
3760 dbesc(datetime_convert()),
3761 intval($importer['importer_uid']),
3762 intval($r[0]['parent'])
3765 $r2 = q("UPDATE `item` SET `last-child` = 1, `changed` = '%s' WHERE `uid` = %d AND `id` = %d",
3766 dbesc(datetime_convert()),
3767 intval($importer['importer_uid']),
3772 if($posted_id && $parent) {
3774 proc_run('php',"include/notifier.php","comment-import","$posted_id");
3776 if((! $is_like) && (! $importer['self'])) {
3778 require_once('include/enotify.php');
3781 'type' => NOTIFY_COMMENT,
3782 'notify_flags' => $importer['notify-flags'],
3783 'language' => $importer['language'],
3784 'to_name' => $importer['username'],
3785 'to_email' => $importer['email'],
3786 'uid' => $importer['importer_uid'],
3787 'item' => $datarray,
3788 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3789 'source_name' => stripslashes($datarray['author-name']),
3790 'source_link' => $datarray['author-link'],
3791 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3792 ? $importer['thumb'] : $datarray['author-avatar']),
3793 'verb' => ACTIVITY_POST,
3795 'parent' => $parent,
3796 'parent_uri' => $parent_uri,
3808 // regular comment that is part of this total conversation. Have we seen it? If not, import it.
3810 $item_id = $item->get_id();
3811 $datarray = get_atom_elements($feed,$item);
3813 if($importer['rel'] == CONTACT_IS_FOLLOWER)
3816 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3818 intval($importer['importer_uid'])
3821 // Update content if 'updated' changes
3824 if (edited_timestamp_is_newer($r[0], $datarray)) {
3826 // do not accept (ignore) an earlier edit than one we currently have.
3827 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
3830 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3831 dbesc($datarray['title']),
3832 dbesc($datarray['body']),
3833 dbesc($datarray['tag']),
3834 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
3835 dbesc(datetime_convert()),
3837 intval($importer['importer_uid'])
3839 create_tags_from_itemuri($item_id, $importer['importer_uid']);
3842 // update last-child if it changes
3844 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
3845 if(($allow) && ($allow[0]['data'] != $r[0]['last-child'])) {
3846 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d",
3847 dbesc(datetime_convert()),
3849 intval($importer['importer_uid'])
3851 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
3852 intval($allow[0]['data']),
3853 dbesc(datetime_convert()),
3855 intval($importer['importer_uid'])
3861 $datarray['parent-uri'] = $parent_uri;
3862 $datarray['uid'] = $importer['importer_uid'];
3863 $datarray['contact-id'] = $importer['id'];
3864 if(($datarray['verb'] == ACTIVITY_LIKE) || ($datarray['verb'] == ACTIVITY_DISLIKE)) {
3865 $datarray['type'] = 'activity';
3866 $datarray['gravity'] = GRAVITY_LIKE;
3867 // only one like or dislike per person
3868 // splitted into two queries for performance issues
3869 $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",
3870 intval($datarray['uid']),
3871 intval($datarray['contact-id']),
3872 dbesc($datarray['verb']),
3878 $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",
3879 intval($datarray['uid']),
3880 intval($datarray['contact-id']),
3881 dbesc($datarray['verb']),
3889 if(($datarray['verb'] === ACTIVITY_TAG) && ($datarray['object-type'] === ACTIVITY_OBJ_TAGTERM)) {
3891 $xo = parse_xml_string($datarray['object'],false);
3892 $xt = parse_xml_string($datarray['target'],false);
3894 if($xt->type == ACTIVITY_OBJ_NOTE) {
3895 $r = q("select * from item where `uri` = '%s' AND `uid` = %d limit 1",
3897 intval($importer['importer_uid'])
3902 // extract tag, if not duplicate, add to parent item
3904 if(! (stristr($r[0]['tag'],trim($xo->content)))) {
3905 q("UPDATE item SET tag = '%s' WHERE id = %d",
3906 dbesc($r[0]['tag'] . (strlen($r[0]['tag']) ? ',' : '') . '#[url=' . $xo->id . ']'. $xo->content . '[/url]'),
3909 create_tags_from_item($r[0]['id']);
3915 $posted_id = item_store($datarray);
3917 // find out if our user is involved in this conversation and wants to be notified.
3919 if(!x($datarray['type']) || $datarray['type'] != 'activity') {
3921 $myconv = q("SELECT `author-link`, `author-avatar`, `parent` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `parent` != 0 AND `deleted` = 0",
3923 intval($importer['importer_uid'])
3926 if(count($myconv)) {
3927 $importer_url = $a->get_baseurl() . '/profile/' . $importer['nickname'];
3929 // first make sure this isn't our own post coming back to us from a wall-to-wall event
3930 if(! link_compare($datarray['author-link'],$importer_url)) {
3933 foreach($myconv as $conv) {
3935 // now if we find a match, it means we're in this conversation
3937 if(! link_compare($conv['author-link'],$importer_url))
3940 require_once('include/enotify.php');
3942 $conv_parent = $conv['parent'];
3945 'type' => NOTIFY_COMMENT,
3946 'notify_flags' => $importer['notify-flags'],
3947 'language' => $importer['language'],
3948 'to_name' => $importer['username'],
3949 'to_email' => $importer['email'],
3950 'uid' => $importer['importer_uid'],
3951 'item' => $datarray,
3952 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
3953 'source_name' => stripslashes($datarray['author-name']),
3954 'source_link' => $datarray['author-link'],
3955 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
3956 ? $importer['thumb'] : $datarray['author-avatar']),
3957 'verb' => ACTIVITY_POST,
3959 'parent' => $conv_parent,
3960 'parent_uri' => $parent_uri
3964 // only send one notification
3976 // Head post of a conversation. Have we seen it? If not, import it.
3979 $item_id = $item->get_id();
3980 $datarray = get_atom_elements($feed,$item);
3982 if((x($datarray,'object-type')) && ($datarray['object-type'] === ACTIVITY_OBJ_EVENT)) {
3983 $ev = bbtoevent($datarray['body']);
3984 if(x($ev,'desc') && x($ev,'start')) {
3985 $ev['cid'] = $importer['id'];
3986 $ev['uid'] = $importer['uid'];
3987 $ev['uri'] = $item_id;
3988 $ev['edited'] = $datarray['edited'];
3989 $ev['private'] = $datarray['private'];
3991 $r = q("SELECT * FROM `event` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
3993 intval($importer['uid'])
3996 $ev['id'] = $r[0]['id'];
3997 $xyz = event_store($ev);
4002 $r = q("SELECT `uid`, `last-child`, `edited`, `body` FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
4004 intval($importer['importer_uid'])
4007 // Update content if 'updated' changes
4010 if (edited_timestamp_is_newer($r[0], $datarray)) {
4012 // do not accept (ignore) an earlier edit than one we currently have.
4013 if(datetime_convert('UTC','UTC',$datarray['edited']) < $r[0]['edited'])
4016 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `edited` = '%s', `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
4017 dbesc($datarray['title']),
4018 dbesc($datarray['body']),
4019 dbesc($datarray['tag']),
4020 dbesc(datetime_convert('UTC','UTC',$datarray['edited'])),
4021 dbesc(datetime_convert()),
4023 intval($importer['importer_uid'])
4025 create_tags_from_itemuri($item_id, $importer['importer_uid']);
4026 update_thread_uri($item_id, $importer['importer_uid']);
4029 // update last-child if it changes
4031 $allow = $item->get_item_tags( NAMESPACE_DFRN, 'comment-allow');
4032 if($allow && $allow[0]['data'] != $r[0]['last-child']) {
4033 $r = q("UPDATE `item` SET `last-child` = %d , `changed` = '%s' WHERE `uri` = '%s' AND `uid` = %d",
4034 intval($allow[0]['data']),
4035 dbesc(datetime_convert()),
4037 intval($importer['importer_uid'])
4043 $datarray['parent-uri'] = $item_id;
4044 $datarray['uid'] = $importer['importer_uid'];
4045 $datarray['contact-id'] = $importer['id'];
4048 if(! link_compare($datarray['owner-link'],$importer['url'])) {
4049 // The item owner info is not our contact. It's OK and is to be expected if this is a tgroup delivery,
4050 // but otherwise there's a possible data mixup on the sender's system.
4051 // the tgroup delivery code called from item_store will correct it if it's a forum,
4052 // but we're going to unconditionally correct it here so that the post will always be owned by our contact.
4053 logger('local_delivery: Correcting item owner.', LOGGER_DEBUG);
4054 $datarray['owner-name'] = $importer['senderName'];
4055 $datarray['owner-link'] = $importer['url'];
4056 $datarray['owner-avatar'] = $importer['thumb'];
4059 if(($importer['rel'] == CONTACT_IS_FOLLOWER) && (! tgroup_check($importer['importer_uid'],$datarray)))
4062 // This is my contact on another system, but it's really me.
4063 // Turn this into a wall post.
4064 $notify = item_is_remote_self($importer, $datarray);
4066 $posted_id = item_store($datarray, false, $notify);
4068 if(stristr($datarray['verb'],ACTIVITY_POKE)) {
4069 $verb = urldecode(substr($datarray['verb'],strpos($datarray['verb'],'#')+1));
4072 $xo = parse_xml_string($datarray['object'],false);
4074 if(($xo->type == ACTIVITY_OBJ_PERSON) && ($xo->id)) {
4076 // somebody was poked/prodded. Was it me?
4078 $links = parse_xml_string("<links>".unxmlify($xo->link)."</links>",false);
4080 foreach($links->link as $l) {
4081 $atts = $l->attributes();
4082 switch($atts['rel']) {
4084 $Blink = $atts['href'];
4090 if($Blink && link_compare($Blink,$a->get_baseurl() . '/profile/' . $importer['nickname'])) {
4092 // send a notification
4093 require_once('include/enotify.php');
4096 'type' => NOTIFY_POKE,
4097 'notify_flags' => $importer['notify-flags'],
4098 'language' => $importer['language'],
4099 'to_name' => $importer['username'],
4100 'to_email' => $importer['email'],
4101 'uid' => $importer['importer_uid'],
4102 'item' => $datarray,
4103 'link' => $a->get_baseurl().'/display/'.urlencode(get_item_guid($posted_id)),
4104 'source_name' => stripslashes($datarray['author-name']),
4105 'source_link' => $datarray['author-link'],
4106 'source_photo' => ((link_compare($datarray['author-link'],$importer['url']))
4107 ? $importer['thumb'] : $datarray['author-avatar']),
4108 'verb' => $datarray['verb'],
4109 'otype' => 'person',
4110 'activity' => $verb,
4111 'parent' => $datarray['parent']
4127 function new_follower($importer,$contact,$datarray,$item,$sharing = false) {
4128 $url = notags(trim($datarray['author-link']));
4129 $name = notags(trim($datarray['author-name']));
4130 $photo = notags(trim($datarray['author-avatar']));
4132 $rawtag = $item->get_item_tags(NAMESPACE_ACTIVITY,'actor');
4133 if($rawtag && $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'])
4134 $nick = $rawtag[0]['child'][NAMESPACE_POCO]['preferredUsername'][0]['data'];
4136 if(is_array($contact)) {
4137 if(($contact['network'] == NETWORK_OSTATUS && $contact['rel'] == CONTACT_IS_SHARING)
4138 || ($sharing && $contact['rel'] == CONTACT_IS_FOLLOWER)) {
4139 $r = q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
4140 intval(CONTACT_IS_FRIEND),
4141 intval($contact['id']),
4142 intval($importer['uid'])
4145 // send email notification to owner?
4149 // create contact record
4151 $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `name`, `nick`, `photo`, `network`, `rel`,
4152 `blocked`, `readonly`, `pending`, `writable` )
4153 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, 0, 0, 1, 1 ) ",
4154 intval($importer['uid']),
4155 dbesc(datetime_convert()),
4157 dbesc(normalise_link($url)),
4161 dbesc(($sharing) ? NETWORK_ZOT : NETWORK_OSTATUS),
4162 intval(($sharing) ? CONTACT_IS_SHARING : CONTACT_IS_FOLLOWER)
4164 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `url` = '%s' AND `pending` = 1 LIMIT 1",
4165 intval($importer['uid']),
4169 $contact_record = $r[0];
4171 // create notification
4172 $hash = random_string();
4174 if(is_array($contact_record)) {
4175 $ret = q("INSERT INTO `intro` ( `uid`, `contact-id`, `blocked`, `knowyou`, `hash`, `datetime`)
4176 VALUES ( %d, %d, 0, 0, '%s', '%s' )",
4177 intval($importer['uid']),
4178 intval($contact_record['id']),
4180 dbesc(datetime_convert())
4184 $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
4185 intval($importer['uid'])
4190 if(intval($r[0]['def_gid'])) {
4191 require_once('include/group.php');
4192 group_add_member($r[0]['uid'],'',$contact_record['id'],$r[0]['def_gid']);
4195 if(($r[0]['notify-flags'] & NOTIFY_INTRO) &&
4196 in_array($r[0]['page-flags'], array(PAGE_NORMAL, PAGE_SOAPBOX, PAGE_FREELOVE))) {
4199 'type' => NOTIFY_INTRO,
4200 'notify_flags' => $r[0]['notify-flags'],
4201 'language' => $r[0]['language'],
4202 'to_name' => $r[0]['username'],
4203 'to_email' => $r[0]['email'],
4204 'uid' => $r[0]['uid'],
4205 'link' => $a->get_baseurl() . '/notifications/intro',
4206 'source_name' => ((strlen(stripslashes($contact_record['name']))) ? stripslashes($contact_record['name']) : t('[Name Withheld]')),
4207 'source_link' => $contact_record['url'],
4208 'source_photo' => $contact_record['photo'],
4209 'verb' => ($sharing ? ACTIVITY_FRIEND : ACTIVITY_FOLLOW),
4218 function lose_follower($importer,$contact,$datarray,$item) {
4220 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_SHARING)) {
4221 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
4222 intval(CONTACT_IS_SHARING),
4223 intval($contact['id'])
4227 contact_remove($contact['id']);
4231 function lose_sharer($importer,$contact,$datarray,$item) {
4233 if(($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_FOLLOWER)) {
4234 q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
4235 intval(CONTACT_IS_FOLLOWER),
4236 intval($contact['id'])
4240 contact_remove($contact['id']);
4245 function subscribe_to_hub($url,$importer,$contact,$hubmode = 'subscribe') {
4249 if(is_array($importer)) {
4250 $r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
4251 intval($importer['uid'])
4255 // Diaspora has different message-ids in feeds than they do
4256 // through the direct Diaspora protocol. If we try and use
4257 // the feed, we'll get duplicates. So don't.
4259 if((! count($r)) || $contact['network'] === NETWORK_DIASPORA)
4262 $push_url = get_config('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
4264 // Use a single verify token, even if multiple hubs
4266 $verify_token = ((strlen($contact['hub-verify'])) ? $contact['hub-verify'] : random_string());
4268 $params= 'hub.mode=' . $hubmode . '&hub.callback=' . urlencode($push_url) . '&hub.topic=' . urlencode($contact['poll']) . '&hub.verify=async&hub.verify_token=' . $verify_token;
4270 logger('subscribe_to_hub: ' . $hubmode . ' ' . $contact['name'] . ' to hub ' . $url . ' endpoint: ' . $push_url . ' with verifier ' . $verify_token);
4272 if(! strlen($contact['hub-verify'])) {
4273 $r = q("UPDATE `contact` SET `hub-verify` = '%s' WHERE `id` = %d",
4274 dbesc($verify_token),
4275 intval($contact['id'])
4279 post_url($url,$params);
4281 logger('subscribe_to_hub: returns: ' . $a->get_curl_code(), LOGGER_DEBUG);
4288 function atom_author($tag,$name,$uri,$h,$w,$photo) {
4292 $name = xmlify($name);
4293 $uri = xmlify($uri);
4296 $photo = xmlify($photo);
4300 $o .= "<name>$name</name>\r\n";
4301 $o .= "<uri>$uri</uri>\r\n";
4302 $o .= '<link rel="photo" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4303 $o .= '<link rel="avatar" type="image/jpeg" media:width="' . $w . '" media:height="' . $h . '" href="' . $photo . '" />' . "\r\n";
4305 call_hooks('atom_author', $o);
4307 $o .= "</$tag>\r\n";
4311 function atom_entry($item,$type,$author,$owner,$comment = false,$cid = 0) {
4315 if(! $item['parent'])
4318 if($item['deleted'])
4319 return '<at:deleted-entry ref="' . xmlify($item['uri']) . '" when="' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '" />' . "\r\n";
4322 if($item['allow_cid'] || $item['allow_gid'] || $item['deny_cid'] || $item['deny_gid'])
4323 $body = fix_private_photos($item['body'],$owner['uid'],$item,$cid);
4325 $body = $item['body'];
4328 $o = "\r\n\r\n<entry>\r\n";
4330 if(is_array($author))
4331 $o .= atom_author('author',$author['name'],$author['url'],80,80,$author['thumb']);
4333 $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']));
4334 if(strlen($item['owner-name']))
4335 $o .= atom_author('dfrn:owner',$item['owner-name'],$item['owner-link'],80,80,$item['owner-avatar']);
4337 if(($item['parent'] != $item['id']) || ($item['parent-uri'] !== $item['uri']) || (($item['thr-parent'] !== '') && ($item['thr-parent'] !== $item['uri']))) {
4338 $parent_item = (($item['thr-parent']) ? $item['thr-parent'] : $item['parent-uri']);
4339 $o .= '<thr:in-reply-to ref="' . xmlify($parent_item) . '" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['parent']) . '" />' . "\r\n";
4344 if ($item['title'] != "")
4345 $htmlbody = "[b]".$item['title']."[/b]\n\n".$htmlbody;
4347 $htmlbody = bbcode(bb_remove_share_information($htmlbody), false, false, 7);
4349 $o .= '<id>' . xmlify($item['uri']) . '</id>' . "\r\n";
4350 $o .= '<title>' . xmlify($item['title']) . '</title>' . "\r\n";
4351 $o .= '<published>' . xmlify(datetime_convert('UTC','UTC',$item['created'] . '+00:00',ATOM_TIME)) . '</published>' . "\r\n";
4352 $o .= '<updated>' . xmlify(datetime_convert('UTC','UTC',$item['edited'] . '+00:00',ATOM_TIME)) . '</updated>' . "\r\n";
4353 $o .= '<dfrn:env>' . base64url_encode($body, true) . '</dfrn:env>' . "\r\n";
4354 $o .= '<content type="' . $type . '" >' . xmlify((($type === 'html') ? $htmlbody : $body)) . '</content>' . "\r\n";
4355 $o .= '<link rel="alternate" type="text/html" href="' . xmlify($a->get_baseurl() . '/display/' . $owner['nickname'] . '/' . $item['id']) . '" />' . "\r\n";
4359 $o .= '<dfrn:comment-allow>' . intval($item['last-child']) . '</dfrn:comment-allow>' . "\r\n";
4361 if($item['location']) {
4362 $o .= '<dfrn:location>' . xmlify($item['location']) . '</dfrn:location>' . "\r\n";
4363 $o .= '<poco:address><poco:formatted>' . xmlify($item['location']) . '</poco:formatted></poco:address>' . "\r\n";
4367 $o .= '<georss:point>' . xmlify($item['coord']) . '</georss:point>' . "\r\n";
4369 if(($item['private']) || strlen($item['allow_cid']) || strlen($item['allow_gid']) || strlen($item['deny_cid']) || strlen($item['deny_gid']))
4370 $o .= '<dfrn:private>' . (($item['private']) ? $item['private'] : 1) . '</dfrn:private>' . "\r\n";
4373 $o .= '<dfrn:extid>' . xmlify($item['extid']) . '</dfrn:extid>' . "\r\n";
4374 if($item['bookmark'])
4375 $o .= '<dfrn:bookmark>true</dfrn:bookmark>' . "\r\n";
4378 $o .= '<statusnet:notice_info local_id="' . $item['id'] . '" source="' . xmlify($item['app']) . '" ></statusnet:notice_info>' . "\r\n";
4381 $o .= '<dfrn:diaspora_guid>' . $item['guid'] . '</dfrn:diaspora_guid>' . "\r\n";
4383 if($item['signed_text']) {
4384 $sign = base64_encode(json_encode(array('signed_text' => $item['signed_text'],'signature' => $item['signature'],'signer' => $item['signer'])));
4385 $o .= '<dfrn:diaspora_signature>' . xmlify($sign) . '</dfrn:diaspora_signature>' . "\r\n";
4388 $verb = construct_verb($item);
4389 $o .= '<as:verb>' . xmlify($verb) . '</as:verb>' . "\r\n";
4390 $actobj = construct_activity_object($item);
4393 $actarg = construct_activity_target($item);
4397 $tags = item_getfeedtags($item);
4399 foreach($tags as $t) {
4400 $o .= '<category scheme="X-DFRN:' . xmlify($t[0]) . ':' . xmlify($t[1]) . '" term="' . xmlify($t[2]) . '" />' . "\r\n";
4404 $o .= item_getfeedattach($item);
4406 $mentioned = get_mentions($item);
4410 call_hooks('atom_entry', $o);
4412 $o .= '</entry>' . "\r\n";
4417 function fix_private_photos($s, $uid, $item = null, $cid = 0) {
4419 if(get_config('system','disable_embedded'))
4424 logger('fix_private_photos: check for photos', LOGGER_DEBUG);
4425 $site = substr($a->get_baseurl(),strpos($a->get_baseurl(),'://'));
4430 $img_start = strpos($orig_body, '[img');
4431 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4432 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4433 while( ($img_st_close !== false) && ($img_len !== false) ) {
4435 $img_st_close++; // make it point to AFTER the closing bracket
4436 $image = substr($orig_body, $img_start + $img_st_close, $img_len);
4438 logger('fix_private_photos: found photo ' . $image, LOGGER_DEBUG);
4441 if(stristr($image , $site . '/photo/')) {
4442 // Only embed locally hosted photos
4444 $i = basename($image);
4445 $i = str_replace(array('.jpg','.png','.gif'),array('','',''),$i);
4446 $x = strpos($i,'-');
4449 $res = substr($i,$x+1);
4450 $i = substr($i,0,$x);
4451 $r = q("SELECT * FROM `photo` WHERE `resource-id` = '%s' AND `scale` = %d AND `uid` = %d",
4458 // Check to see if we should replace this photo link with an embedded image
4459 // 1. No need to do so if the photo is public
4460 // 2. If there's a contact-id provided, see if they're in the access list
4461 // for the photo. If so, embed it.
4462 // 3. Otherwise, if we have an item, see if the item permissions match the photo
4463 // permissions, regardless of order but first check to see if they're an exact
4464 // match to save some processing overhead.
4466 if(has_permissions($r[0])) {
4468 $recips = enumerate_permissions($r[0]);
4469 if(in_array($cid, $recips)) {
4474 if(compare_permissions($item,$r[0]))
4479 $data = $r[0]['data'];
4480 $type = $r[0]['type'];
4482 // If a custom width and height were specified, apply before embedding
4483 if(preg_match("/\[img\=([0-9]*)x([0-9]*)\]/is", substr($orig_body, $img_start, $img_st_close), $match)) {
4484 logger('fix_private_photos: scaling photo', LOGGER_DEBUG);
4486 $width = intval($match[1]);
4487 $height = intval($match[2]);
4489 $ph = new Photo($data, $type);
4490 if($ph->is_valid()) {
4491 $ph->scaleImage(max($width, $height));
4492 $data = $ph->imageString();
4493 $type = $ph->getType();
4497 logger('fix_private_photos: replacing photo', LOGGER_DEBUG);
4498 $image = 'data:' . $type . ';base64,' . base64_encode($data);
4499 logger('fix_private_photos: replaced: ' . $image, LOGGER_DATA);
4505 $new_body = $new_body . substr($orig_body, 0, $img_start + $img_st_close) . $image . '[/img]';
4506 $orig_body = substr($orig_body, $img_start + $img_st_close + $img_len + strlen('[/img]'));
4507 if($orig_body === false)
4510 $img_start = strpos($orig_body, '[img');
4511 $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
4512 $img_len = ($img_start !== false ? strpos(substr($orig_body, $img_start + $img_st_close + 1), '[/img]') : false);
4515 $new_body = $new_body . $orig_body;
4521 function has_permissions($obj) {
4522 if(($obj['allow_cid'] != '') || ($obj['allow_gid'] != '') || ($obj['deny_cid'] != '') || ($obj['deny_gid'] != ''))
4527 function compare_permissions($obj1,$obj2) {
4528 // first part is easy. Check that these are exactly the same.
4529 if(($obj1['allow_cid'] == $obj2['allow_cid'])
4530 && ($obj1['allow_gid'] == $obj2['allow_gid'])
4531 && ($obj1['deny_cid'] == $obj2['deny_cid'])
4532 && ($obj1['deny_gid'] == $obj2['deny_gid']))
4535 // This is harder. Parse all the permissions and compare the resulting set.
4537 $recipients1 = enumerate_permissions($obj1);
4538 $recipients2 = enumerate_permissions($obj2);
4541 if($recipients1 == $recipients2)
4546 // returns an array of contact-ids that are allowed to see this object
4548 function enumerate_permissions($obj) {
4549 require_once('include/group.php');
4550 $allow_people = expand_acl($obj['allow_cid']);
4551 $allow_groups = expand_groups(expand_acl($obj['allow_gid']));
4552 $deny_people = expand_acl($obj['deny_cid']);
4553 $deny_groups = expand_groups(expand_acl($obj['deny_gid']));
4554 $recipients = array_unique(array_merge($allow_people,$allow_groups));
4555 $deny = array_unique(array_merge($deny_people,$deny_groups));
4556 $recipients = array_diff($recipients,$deny);
4560 function item_getfeedtags($item) {
4563 $cnt = preg_match_all('|\#\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4565 for($x = 0; $x < $cnt; $x ++) {
4567 $ret[] = array('#',$matches[1][$x], $matches[2][$x]);
4571 $cnt = preg_match_all('|\@\[url\=(.*?)\](.*?)\[\/url\]|',$item['tag'],$matches);
4573 for($x = 0; $x < $cnt; $x ++) {
4575 $ret[] = array('@',$matches[1][$x], $matches[2][$x]);
4581 function item_getfeedattach($item) {
4583 $arr = explode('[/attach],',$item['attach']);
4585 foreach($arr as $r) {
4587 $cnt = preg_match('|\[attach\]href=\"(.*?)\" length=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"|',$r,$matches);
4589 $ret .= '<link rel="enclosure" href="' . xmlify($matches[1]) . '" type="' . xmlify($matches[3]) . '" ';
4590 if(intval($matches[2]))
4591 $ret .= 'length="' . intval($matches[2]) . '" ';
4592 if($matches[4] !== ' ')
4593 $ret .= 'title="' . xmlify(trim($matches[4])) . '" ';
4594 $ret .= ' />' . "\r\n";
4603 function item_expire($uid, $days, $network = "", $force = false) {
4605 if((! $uid) || ($days < 1))
4608 // $expire_network_only = save your own wall posts
4609 // and just expire conversations started by others
4611 $expire_network_only = get_pconfig($uid,'expire','network_only');
4612 $sql_extra = ((intval($expire_network_only)) ? " AND wall = 0 " : "");
4614 if ($network != "") {
4615 $sql_extra .= sprintf(" AND network = '%s' ", dbesc($network));
4616 // There is an index "uid_network_received" but not "uid_network_created"
4617 // This avoids the creation of another index just for one purpose.
4618 // And it doesn't really matter wether to look at "received" or "created"
4619 $range = "AND `received` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4621 $range = "AND `created` < UTC_TIMESTAMP() - INTERVAL %d DAY ";
4623 $r = q("SELECT * FROM `item`
4624 WHERE `uid` = %d $range
4635 $expire_items = get_pconfig($uid, 'expire','items');
4636 $expire_items = (($expire_items===false)?1:intval($expire_items)); // default if not set: 1
4638 // Forcing expiring of items - but not notes and marked items
4640 $expire_items = true;
4642 $expire_notes = get_pconfig($uid, 'expire','notes');
4643 $expire_notes = (($expire_notes===false)?1:intval($expire_notes)); // default if not set: 1
4645 $expire_starred = get_pconfig($uid, 'expire','starred');
4646 $expire_starred = (($expire_starred===false)?1:intval($expire_starred)); // default if not set: 1
4648 $expire_photos = get_pconfig($uid, 'expire','photos');
4649 $expire_photos = (($expire_photos===false)?0:intval($expire_photos)); // default if not set: 0
4651 logger('expire: # items=' . count($r). "; expire items: $expire_items, expire notes: $expire_notes, expire starred: $expire_starred, expire photos: $expire_photos");
4653 foreach($r as $item) {
4655 // don't expire filed items
4657 if(strpos($item['file'],'[') !== false)
4660 // Only expire posts, not photos and photo comments
4662 if($expire_photos==0 && strlen($item['resource-id']))
4664 if($expire_starred==0 && intval($item['starred']))
4666 if($expire_notes==0 && $item['type']=='note')
4668 if($expire_items==0 && $item['type']!='note')
4671 drop_item($item['id'],false);
4674 proc_run('php',"include/notifier.php","expire","$uid");
4679 function drop_items($items) {
4682 if(! local_user() && ! remote_user())
4686 foreach($items as $item) {
4687 $owner = drop_item($item,false);
4688 if($owner && ! $uid)
4693 // multiple threads may have been deleted, send an expire notification
4696 proc_run('php',"include/notifier.php","expire","$uid");
4700 function drop_item($id,$interactive = true) {
4704 // locate item to be deleted
4706 $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
4713 notice( t('Item not found.') . EOL);
4714 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4719 $owner = $item['uid'];
4723 // check if logged in user is either the author or owner of this item
4725 if(is_array($_SESSION['remote'])) {
4726 foreach($_SESSION['remote'] as $visitor) {
4727 if($visitor['uid'] == $item['uid'] && $visitor['cid'] == $item['contact-id']) {
4728 $cid = $visitor['cid'];
4735 if((local_user() == $item['uid']) || ($cid) || (! $interactive)) {
4737 // Check if we should do HTML-based delete confirmation
4738 if($_REQUEST['confirm']) {
4739 // <form> can't take arguments in its "action" parameter
4740 // so add any arguments as hidden inputs
4741 $query = explode_querystring($a->query_string);
4743 foreach($query['args'] as $arg) {
4744 if(strpos($arg, 'confirm=') === false) {
4745 $arg_parts = explode('=', $arg);
4746 $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
4750 return replace_macros(get_markup_template('confirm.tpl'), array(
4752 '$message' => t('Do you really want to delete this item?'),
4753 '$extra_inputs' => $inputs,
4754 '$confirm' => t('Yes'),
4755 '$confirm_url' => $query['base'],
4756 '$confirm_name' => 'confirmed',
4757 '$cancel' => t('Cancel'),
4760 // Now check how the user responded to the confirmation query
4761 if($_REQUEST['canceled']) {
4762 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4765 logger('delete item: ' . $item['id'], LOGGER_DEBUG);
4768 $r = q("UPDATE `item` SET `deleted` = 1, `title` = '', `body` = '', `edited` = '%s', `changed` = '%s' WHERE `id` = %d",
4769 dbesc(datetime_convert()),
4770 dbesc(datetime_convert()),
4773 create_tags_from_item($item['id']);
4774 create_files_from_item($item['id']);
4775 delete_thread($item['id'], $item['parent-uri']);
4777 // clean up categories and tags so they don't end up as orphans
4780 $cnt = preg_match_all('/<(.*?)>/',$item['file'],$matches,PREG_SET_ORDER);
4782 foreach($matches as $mtch) {
4783 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],true);
4789 $cnt = preg_match_all('/\[(.*?)\]/',$item['file'],$matches,PREG_SET_ORDER);
4791 foreach($matches as $mtch) {
4792 file_tag_unsave_file($item['uid'],$item['id'],$mtch[1],false);
4796 // If item is a link to a photo resource, nuke all the associated photos
4797 // (visitors will not have photo resources)
4798 // This only applies to photos uploaded from the photos page. Photos inserted into a post do not
4799 // generate a resource-id and therefore aren't intimately linked to the item.
4801 if(strlen($item['resource-id'])) {
4802 q("DELETE FROM `photo` WHERE `resource-id` = '%s' AND `uid` = %d ",
4803 dbesc($item['resource-id']),
4804 intval($item['uid'])
4806 // ignore the result
4809 // If item is a link to an event, nuke the event record.
4811 if(intval($item['event-id'])) {
4812 q("DELETE FROM `event` WHERE `id` = %d AND `uid` = %d",
4813 intval($item['event-id']),
4814 intval($item['uid'])
4816 // ignore the result
4819 // If item has attachments, drop them
4821 foreach(explode(",",$item['attach']) as $attach){
4822 preg_match("|attach/(\d+)|", $attach, $matches);
4823 q("DELETE FROM `attach` WHERE `id` = %d AND `uid` = %d",
4824 intval($matches[1]),
4827 // ignore the result
4831 // clean up item_id and sign meta-data tables
4834 // Old code - caused very long queries and warning entries in the mysql logfiles:
4836 $r = q("DELETE FROM item_id where iid in (select id from item where parent = %d and uid = %d)",
4837 intval($item['id']),
4838 intval($item['uid'])
4841 $r = q("DELETE FROM sign where iid in (select id from item where parent = %d and uid = %d)",
4842 intval($item['id']),
4843 intval($item['uid'])
4847 // The new code splits the queries since the mysql optimizer really has bad problems with subqueries
4849 // Creating list of parents
4850 $r = q("select id from item where parent = %d and uid = %d",
4851 intval($item['id']),
4852 intval($item['uid'])
4857 foreach ($r AS $row) {
4858 if ($parentid != "")
4861 $parentid .= $row["id"];
4865 if ($parentid != "") {
4866 $r = q("DELETE FROM item_id where iid in (%s)", dbesc($parentid));
4868 $r = q("DELETE FROM sign where iid in (%s)", dbesc($parentid));
4871 // If it's the parent of a comment thread, kill all the kids
4873 if($item['uri'] == $item['parent-uri']) {
4874 $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = ''
4875 WHERE `parent-uri` = '%s' AND `uid` = %d ",
4876 dbesc(datetime_convert()),
4877 dbesc(datetime_convert()),
4878 dbesc($item['parent-uri']),
4879 intval($item['uid'])
4881 create_tags_from_itemuri($item['parent-uri'], $item['uid']);
4882 create_files_from_itemuri($item['parent-uri'], $item['uid']);
4883 delete_thread_uri($item['parent-uri'], $item['uid']);
4884 // ignore the result
4887 // ensure that last-child is set in case the comment that had it just got wiped.
4888 q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
4889 dbesc(datetime_convert()),
4890 dbesc($item['parent-uri']),
4891 intval($item['uid'])
4893 // who is the last child now?
4894 $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",
4895 dbesc($item['parent-uri']),
4896 intval($item['uid'])
4899 q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
4904 // Add a relayable_retraction signature for Diaspora.
4905 store_diaspora_retract_sig($item, $a->user, $a->get_baseurl());
4908 $drop_id = intval($item['id']);
4910 // send the notification upstream/downstream as the case may be
4912 proc_run('php',"include/notifier.php","drop","$drop_id");
4916 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4922 notice( t('Permission denied.') . EOL);
4923 goaway($a->get_baseurl() . '/' . $_SESSION['return_url']);
4930 function first_post_date($uid,$wall = false) {
4931 $r = q("select id, created from item
4932 where uid = %d and wall = %d and deleted = 0 and visible = 1 AND moderated = 0
4934 order by created asc limit 1",
4936 intval($wall ? 1 : 0)
4939 // logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA);
4940 return substr(datetime_convert('',date_default_timezone_get(),$r[0]['created']),0,10);
4945 /* modified posted_dates() {below} to arrange the list in years */
4946 function list_post_dates($uid, $wall) {
4947 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
4949 $dthen = first_post_date($uid, $wall);
4953 // Set the start and end date to the beginning of the month
4954 $dnow = substr($dnow,0,8).'01';
4955 $dthen = substr($dthen,0,8).'01';
4959 // Starting with the current month, get the first and last days of every
4960 // month down to and including the month of the first post
4961 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
4962 $dyear = intval(substr($dnow,0,4));
4963 $dstart = substr($dnow,0,8) . '01';
4964 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
4965 $start_month = datetime_convert('','',$dstart,'Y-m-d');
4966 $end_month = datetime_convert('','',$dend,'Y-m-d');
4967 $str = day_translate(datetime_convert('','',$dnow,'F'));
4969 $ret[$dyear] = array();
4970 $ret[$dyear][] = array($str,$end_month,$start_month);
4971 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
4976 function posted_dates($uid,$wall) {
4977 $dnow = datetime_convert('',date_default_timezone_get(),'now','Y-m-d');
4979 $dthen = first_post_date($uid,$wall);
4983 // Set the start and end date to the beginning of the month
4984 $dnow = substr($dnow,0,8).'01';
4985 $dthen = substr($dthen,0,8).'01';
4988 // Starting with the current month, get the first and last days of every
4989 // month down to and including the month of the first post
4990 while(substr($dnow, 0, 7) >= substr($dthen, 0, 7)) {
4991 $dstart = substr($dnow,0,8) . '01';
4992 $dend = substr($dnow,0,8) . get_dim(intval($dnow),intval(substr($dnow,5)));
4993 $start_month = datetime_convert('','',$dstart,'Y-m-d');
4994 $end_month = datetime_convert('','',$dend,'Y-m-d');
4995 $str = day_translate(datetime_convert('','',$dnow,'F Y'));
4996 $ret[] = array($str,$end_month,$start_month);
4997 $dnow = datetime_convert('','',$dnow . ' -1 month', 'Y-m-d');
5003 function posted_date_widget($url,$uid,$wall) {
5006 if(! feature_enabled($uid,'archives'))
5009 // For former Facebook folks that left because of "timeline"
5011 /* if($wall && intval(get_pconfig($uid,'system','no_wall_archive_widget')))
5014 $visible_years = get_pconfig($uid,'system','archive_visible_years');
5015 if(! $visible_years)
5018 $ret = list_post_dates($uid,$wall);
5023 $cutoff_year = intval(datetime_convert('',date_default_timezone_get(),'now','Y')) - $visible_years;
5024 $cutoff = ((array_key_exists($cutoff_year,$ret))? true : false);
5026 $o = replace_macros(get_markup_template('posted_date_widget.tpl'),array(
5027 '$title' => t('Archives'),
5028 '$size' => $visible_years,
5029 '$cutoff_year' => $cutoff_year,
5030 '$cutoff' => $cutoff,
5033 '$showmore' => t('show more')
5039 function store_diaspora_retract_sig($item, $user, $baseurl) {
5040 // Note that we can't add a target_author_signature
5041 // if the comment was deleted by a remote user. That should be ok, because if a remote user is deleting
5042 // the comment, that means we're the home of the post, and Diaspora will only
5043 // check the parent_author_signature of retractions that it doesn't have to relay further
5045 // I don't think this function gets called for an "unlike," but I'll check anyway
5047 $enabled = intval(get_config('system','diaspora_enabled'));
5049 logger('drop_item: diaspora support disabled, not storing retraction signature', LOGGER_DEBUG);
5053 logger('drop_item: storing diaspora retraction signature');
5055 $signed_text = $item['guid'] . ';' . ( ($item['verb'] === ACTIVITY_LIKE) ? 'Like' : 'Comment');
5057 if(local_user() == $item['uid']) {
5059 $handle = $user['nickname'] . '@' . substr($baseurl, strpos($baseurl,'://') + 3);
5060 $authorsig = base64_encode(rsa_sign($signed_text,$user['prvkey'],'sha256'));
5063 $r = q("SELECT `nick`, `url` FROM `contact` WHERE `id` = '%d' LIMIT 1",
5064 $item['contact-id'] // If this function gets called, drop_item() has already checked remote_user() == $item['contact-id']
5067 // The below handle only works for NETWORK_DFRN. I think that's ok, because this function
5068 // only handles DFRN deletes
5069 $handle_baseurl_start = strpos($r['url'],'://') + 3;
5070 $handle_baseurl_length = strpos($r['url'],'/profile') - $handle_baseurl_start;
5071 $handle = $r['nick'] . '@' . substr($r['url'], $handle_baseurl_start, $handle_baseurl_length);
5077 q("insert into sign (`retract_iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
5078 intval($item['id']),
5079 dbesc($signed_text),