]> git.mxchange.org Git - friendica.git/blob - mod/item.php
Merge remote-tracking branch 'upstream/develop' into 1508-random-becomes-guid
[friendica.git] / mod / item.php
1 <?php
2
3 /**
4  *
5  * This is the POST destination for most all locally posted
6  * text stuff. This function handles status, wall-to-wall status,
7  * local comments, and remote coments that are posted on this site
8  * (as opposed to being delivered in a feed).
9  * Also processed here are posts and comments coming through the
10  * statusnet/twitter API.
11  * All of these become an "item" which is our basic unit of
12  * information.
13  * Posts that originate externally or do not fall into the above
14  * posting categories go through item_store() instead of this function.
15  *
16  */
17
18 require_once('include/crypto.php');
19 require_once('include/enotify.php');
20 require_once('include/email.php');
21 require_once('library/langdet/Text/LanguageDetect.php');
22 require_once('include/tags.php');
23 require_once('include/files.php');
24 require_once('include/threads.php');
25 require_once('include/text.php');
26 require_once('include/items.php');
27 require_once('include/Scrape.php');
28
29 function item_post(&$a) {
30
31         if((! local_user()) && (! remote_user()) && (! x($_REQUEST,'commenter')))
32                 return;
33
34         require_once('include/security.php');
35
36         $uid = local_user();
37
38         if(x($_REQUEST,'dropitems')) {
39                 $arr_drop = explode(',',$_REQUEST['dropitems']);
40                 drop_items($arr_drop);
41                 $json = array('success' => 1);
42                 echo json_encode($json);
43                 killme();
44         }
45
46         call_hooks('post_local_start', $_REQUEST);
47 //      logger('postinput ' . file_get_contents('php://input'));
48         logger('postvars ' . print_r($_REQUEST,true), LOGGER_DATA);
49
50         $api_source = ((x($_REQUEST,'api_source') && $_REQUEST['api_source']) ? true : false);
51
52         $message_id = ((x($_REQUEST,'message_id') && $api_source)  ? strip_tags($_REQUEST['message_id'])       : '');
53
54         $return_path = ((x($_REQUEST,'return')) ? $_REQUEST['return'] : '');
55         $preview = ((x($_REQUEST,'preview')) ? intval($_REQUEST['preview']) : 0);
56
57
58         // Check for doubly-submitted posts, and reject duplicates
59         // Note that we have to ignore previews, otherwise nothing will post
60         // after it's been previewed
61         if(!$preview && x($_REQUEST['post_id_random'])) {
62                 if(x($_SESSION['post-random']) && $_SESSION['post-random'] == $_REQUEST['post_id_random']) {
63                         logger("item post: duplicate post", LOGGER_DEBUG);
64                         item_post_return($a->get_baseurl(), $api_source, $return_path);
65                 }
66                 else
67                         $_SESSION['post-random'] = $_REQUEST['post_id_random'];
68         }
69
70         /**
71          * Is this a reply to something?
72          */
73
74         $parent = ((x($_REQUEST,'parent')) ? intval($_REQUEST['parent']) : 0);
75         $parent_uri = ((x($_REQUEST,'parent_uri')) ? trim($_REQUEST['parent_uri']) : '');
76
77         $parent_item = null;
78         $parent_contact = null;
79         $thr_parent = '';
80         $parid = 0;
81         $r = false;
82         $objecttype = null;
83
84         if($parent || $parent_uri) {
85
86                 $objecttype = ACTIVITY_OBJ_COMMENT;
87
88                 if(! x($_REQUEST,'type'))
89                         $_REQUEST['type'] = 'net-comment';
90
91                 if($parent) {
92                         $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
93                                 intval($parent)
94                         );
95                 } elseif($parent_uri && local_user()) {
96                         // This is coming from an API source, and we are logged in
97                         $r = q("SELECT * FROM `item` WHERE `uri` = '%s' AND `uid` = %d LIMIT 1",
98                                 dbesc($parent_uri),
99                                 intval(local_user())
100                         );
101                 }
102
103                 // if this isn't the real parent of the conversation, find it
104                 if($r !== false && count($r)) {
105                         $parid = $r[0]['parent'];
106                         $parent_uri = $r[0]['uri'];
107                         if($r[0]['id'] != $r[0]['parent']) {
108                                 $r = q("SELECT * FROM `item` WHERE `id` = `parent` AND `parent` = %d LIMIT 1",
109                                         intval($parid)
110                                 );
111                         }
112                 }
113
114                 if(($r === false) || (! count($r))) {
115                         notice( t('Unable to locate original post.') . EOL);
116                         if(x($_REQUEST,'return'))
117                                 goaway($a->get_baseurl() . "/" . $return_path );
118                         killme();
119                 }
120                 $parent_item = $r[0];
121                 $parent = $r[0]['id'];
122
123                 // multi-level threading - preserve the info but re-parent to our single level threading
124                 //if(($parid) && ($parid != $parent))
125                 $thr_parent = $parent_uri;
126
127                 if($parent_item['contact-id'] && $uid) {
128                         $r = q("SELECT * FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
129                                 intval($parent_item['contact-id']),
130                                 intval($uid)
131                         );
132                         if(count($r))
133                                 $parent_contact = $r[0];
134
135                         // If the contact id doesn't fit with the contact, then set the contact to null
136                         $thrparent = q("SELECT `author-link`, `network` FROM `item` WHERE `uri` = '%s' LIMIT 1", dbesc($thr_parent));
137                         if (count($thrparent) AND ($thrparent[0]["network"] === NETWORK_OSTATUS)
138                                 AND (normalise_link($parent_contact["url"]) != normalise_link($thrparent[0]["author-link"]))) {
139                                 $parent_contact = null;
140
141                                 require_once("include/Scrape.php");
142                                 $probed_contact = probe_url($thrparent[0]["author-link"]);
143                                 if ($probed_contact["network"] != NETWORK_FEED) {
144                                         $parent_contact = $probed_contact;
145                                         $parent_contact["nurl"] = normalise_link($probed_contact["url"]);
146                                         $parent_contact["thumb"] = $probed_contact["photo"];
147                                         $parent_contact["micro"] = $probed_contact["photo"];
148                                         $parent_contact["addr"] = $probed_contact["addr"];
149                                 }
150                                 logger('no contact found: '.print_r($thrparent, true), LOGGER_DEBUG);
151                         } else
152                                 logger('parent contact: '.print_r($parent_contact, true), LOGGER_DEBUG);
153                 }
154         }
155
156         if($parent) logger('mod_item: item_post parent=' . $parent);
157
158         $profile_uid = ((x($_REQUEST,'profile_uid')) ? intval($_REQUEST['profile_uid']) : 0);
159         $post_id     = ((x($_REQUEST,'post_id'))     ? intval($_REQUEST['post_id'])     : 0);
160         $app         = ((x($_REQUEST,'source'))      ? strip_tags($_REQUEST['source'])  : '');
161         $extid       = ((x($_REQUEST,'extid'))       ? strip_tags($_REQUEST['extid'])  : '');
162
163         $allow_moderated = false;
164
165         // here is where we are going to check for permission to post a moderated comment.
166
167         // First check that the parent exists and it is a wall item.
168
169         if((x($_REQUEST,'commenter')) && ((! $parent) || (! $parent_item['wall']))) {
170                 notice( t('Permission denied.') . EOL) ;
171                 if(x($_REQUEST,'return'))
172                         goaway($a->get_baseurl() . "/" . $return_path );
173                 killme();
174         }
175
176         // Now check that it is a page_type of PAGE_BLOG, and that valid personal details
177         // have been provided, and run any anti-spam plugins
178
179
180         // TODO
181
182
183
184
185         if((! can_write_wall($a,$profile_uid)) && (! $allow_moderated)) {
186                 notice( t('Permission denied.') . EOL) ;
187                 if(x($_REQUEST,'return'))
188                         goaway($a->get_baseurl() . "/" . $return_path );
189                 killme();
190         }
191
192
193         // is this an edited post?
194
195         $orig_post = null;
196
197         if($post_id) {
198                 $i = q("SELECT * FROM `item` WHERE `uid` = %d AND `id` = %d LIMIT 1",
199                         intval($profile_uid),
200                         intval($post_id)
201                 );
202                 if(! count($i))
203                         killme();
204                 $orig_post = $i[0];
205         }
206
207         $user = null;
208
209         $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
210                 intval($profile_uid)
211         );
212         if(count($r))
213                 $user = $r[0];
214
215         if($orig_post) {
216                 $str_group_allow   = $orig_post['allow_gid'];
217                 $str_contact_allow = $orig_post['allow_cid'];
218                 $str_group_deny    = $orig_post['deny_gid'];
219                 $str_contact_deny  = $orig_post['deny_cid'];
220                 $location          = $orig_post['location'];
221                 $coord             = $orig_post['coord'];
222                 $verb              = $orig_post['verb'];
223                 $objecttype        = $orig_post['object-type'];
224                 $emailcc           = $orig_post['emailcc'];
225                 $app               = $orig_post['app'];
226                 $categories        = $orig_post['file'];
227                 $title             = notags(trim($_REQUEST['title']));
228                 $body              = escape_tags(trim($_REQUEST['body']));
229                 $private           = $orig_post['private'];
230                 $pubmail_enable    = $orig_post['pubmail'];
231                 $network           = $orig_post['network'];
232                 $guid              = $orig_post['guid'];
233                 $extid             = $orig_post['extid'];
234
235         } else {
236
237                 // if coming from the API and no privacy settings are set,
238                 // use the user default permissions - as they won't have
239                 // been supplied via a form.
240
241                 if(($api_source)
242                         && (! array_key_exists('contact_allow',$_REQUEST))
243                         && (! array_key_exists('group_allow',$_REQUEST))
244                         && (! array_key_exists('contact_deny',$_REQUEST))
245                         && (! array_key_exists('group_deny',$_REQUEST))) {
246                         $str_group_allow   = $user['allow_gid'];
247                         $str_contact_allow = $user['allow_cid'];
248                         $str_group_deny    = $user['deny_gid'];
249                         $str_contact_deny  = $user['deny_cid'];
250                 }
251                 else {
252
253                         // use the posted permissions
254
255                         $str_group_allow   = perms2str($_REQUEST['group_allow']);
256                         $str_contact_allow = perms2str($_REQUEST['contact_allow']);
257                         $str_group_deny    = perms2str($_REQUEST['group_deny']);
258                         $str_contact_deny  = perms2str($_REQUEST['contact_deny']);
259                 }
260
261                 $title             = notags(trim($_REQUEST['title']));
262                 $location          = notags(trim($_REQUEST['location']));
263                 $coord             = notags(trim($_REQUEST['coord']));
264                 $verb              = notags(trim($_REQUEST['verb']));
265                 $emailcc           = notags(trim($_REQUEST['emailcc']));
266                 $body              = escape_tags(trim($_REQUEST['body']));
267                 $network           = notags(trim($_REQUEST['network']));
268                 $guid              = get_guid(32);
269
270
271                 $naked_body = preg_replace('/\[(.+?)\]/','',$body);
272
273                 if (version_compare(PHP_VERSION, '5.3.0', '>=')) {
274                         $l = new Text_LanguageDetect;
275                         //$lng = $l->detectConfidence($naked_body);
276                         //$postopts = (($lng['language']) ? 'lang=' . $lng['language'] . ';' . $lng['confidence'] : '');
277
278                         $lng = $l->detect($naked_body, 3);
279
280                         if (sizeof($lng) > 0) {
281                                 $postopts = "";
282
283                                 foreach ($lng as $language => $score) {
284                                         if ($postopts == "")
285                                                 $postopts = "lang=";
286                                         else
287                                                 $postopts .= ":";
288
289                                         $postopts .= $language.";".$score;
290                                 }
291                         }
292
293                         logger('mod_item: detect language' . print_r($lng,true) . $naked_body, LOGGER_DATA);
294                 }
295                 else
296                         $postopts = '';
297
298
299                 $private = ((strlen($str_group_allow) || strlen($str_contact_allow) || strlen($str_group_deny) || strlen($str_contact_deny)) ? 1 : 0);
300
301
302                 if($user['hidewall'])
303                         $private = 2;
304
305                 // If this is a comment, set the permissions from the parent.
306
307                 if($parent_item) {
308                         $private = 0;
309
310                         // for non native networks use the network of the original post as network of the item
311                         if (($parent_item['network'] != NETWORK_DIASPORA)
312                                 AND ($parent_item['network'] != NETWORK_OSTATUS)
313                                 AND ($network == ""))
314                                 $network = $parent_item['network'];
315
316                         if(($parent_item['private'])
317                                 || strlen($parent_item['allow_cid'])
318                                 || strlen($parent_item['allow_gid'])
319                                 || strlen($parent_item['deny_cid'])
320                                 || strlen($parent_item['deny_gid'])) {
321                                 $private = (($parent_item['private']) ? $parent_item['private'] : 1);
322                         }
323
324                         $str_contact_allow = $parent_item['allow_cid'];
325                         $str_group_allow   = $parent_item['allow_gid'];
326                         $str_contact_deny  = $parent_item['deny_cid'];
327                         $str_group_deny    = $parent_item['deny_gid'];
328                 }
329                 $pubmail_enable    = ((x($_REQUEST,'pubmail_enable') && intval($_REQUEST['pubmail_enable']) && (! $private)) ? 1 : 0);
330
331                 // if using the API, we won't see pubmail_enable - figure out if it should be set
332
333                 if($api_source && $profile_uid && $profile_uid == local_user() && (! $private)) {
334                         $mail_disabled = ((function_exists('imap_open') && (! get_config('system','imap_disabled'))) ? 0 : 1);
335                         if(! $mail_disabled) {
336                                 $r = q("SELECT * FROM `mailacct` WHERE `uid` = %d AND `server` != '' LIMIT 1",
337                                         intval(local_user())
338                                 );
339                                 if(count($r) && intval($r[0]['pubmail']))
340                                         $pubmail_enabled = true;
341                         }
342                 }
343
344                 if(! strlen($body)) {
345                         if($preview)
346                                 killme();
347                         info( t('Empty post discarded.') . EOL );
348                         if(x($_REQUEST,'return'))
349                                 goaway($a->get_baseurl() . "/" . $return_path );
350                         killme();
351                 }
352         }
353
354         if(strlen($categories)) {
355                 // get the "fileas" tags for this post
356                 $filedas = file_tag_file_to_list($categories, 'file');
357         }
358         // save old and new categories, so we can determine what needs to be deleted from pconfig
359         $categories_old = $categories;
360         $categories = file_tag_list_to_file(trim($_REQUEST['category']), 'category');
361         $categories_new = $categories;
362         if(strlen($filedas)) {
363                 // append the fileas stuff to the new categories list
364                 $categories .= file_tag_list_to_file($filedas, 'file');
365         }
366
367         // Work around doubled linefeeds in Tinymce 3.5b2
368         // First figure out if it's a status post that would've been
369         // created using tinymce. Otherwise leave it alone.
370
371 /*      $plaintext = (local_user() ? intval(get_pconfig(local_user(),'system','plaintext')) || !feature_enabled($profile_uid,'richtext') : 0);
372         if((! $parent) && (! $api_source) && (! $plaintext)) {
373                 $body = fix_mce_lf($body);
374         }*/
375         $plaintext = (local_user() ? !feature_enabled($profile_uid,'richtext') : 0);
376         if((! $parent) && (! $api_source) && (! $plaintext)) {
377                 $body = fix_mce_lf($body);
378         }
379
380
381         // get contact info for poster
382
383         $author = null;
384         $self   = false;
385         $contact_id = 0;
386
387         if((local_user()) && (local_user() == $profile_uid)) {
388                 $self = true;
389                 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `self` = 1 LIMIT 1",
390                         intval($_SESSION['uid'])
391                 );
392         }
393         elseif(remote_user()) {
394                 if(is_array($_SESSION['remote'])) {
395                         foreach($_SESSION['remote'] as $v) {
396                                 if($v['uid'] == $profile_uid) {
397                                         $contact_id = $v['cid'];
398                                         break;
399                                 }
400                         }
401                 }
402                 if($contact_id) {
403                         $r = q("SELECT * FROM `contact` WHERE `id` = %d LIMIT 1",
404                                 intval($contact_id)
405                         );
406                 }
407         }
408
409         if(count($r)) {
410                 $author = $r[0];
411                 $contact_id = $author['id'];
412         }
413
414         // get contact info for owner
415
416         if($profile_uid == local_user()) {
417                 $contact_record = $author;
418         }
419         else {
420                 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `self` = 1 LIMIT 1",
421                         intval($profile_uid)
422                 );
423                 if(count($r))
424                         $contact_record = $r[0];
425         }
426
427         $post_type = notags(trim($_REQUEST['type']));
428
429         if($post_type === 'net-comment') {
430                 if($parent_item !== null) {
431                         if($parent_item['wall'] == 1)
432                                 $post_type = 'wall-comment';
433                         else
434                                 $post_type = 'remote-comment';
435                 }
436         }
437
438         /**
439          *
440          * When a photo was uploaded into the message using the (profile wall) ajax
441          * uploader, The permissions are initially set to disallow anybody but the
442          * owner from seeing it. This is because the permissions may not yet have been
443          * set for the post. If it's private, the photo permissions should be set
444          * appropriately. But we didn't know the final permissions on the post until
445          * now. So now we'll look for links of uploaded messages that are in the
446          * post and set them to the same permissions as the post itself.
447          *
448          */
449
450         $match = null;
451
452         if((! $preview) && preg_match_all("/\[img([\=0-9x]*?)\](.*?)\[\/img\]/",$body,$match)) {
453                 $images = $match[2];
454                 if(count($images)) {
455
456                         $objecttype = ACTIVITY_OBJ_IMAGE;
457
458                         foreach($images as $image) {
459                                 if(! stristr($image,$a->get_baseurl() . '/photo/'))
460                                         continue;
461                                 $image_uri = substr($image,strrpos($image,'/') + 1);
462                                 $image_uri = substr($image_uri,0, strpos($image_uri,'-'));
463                                 if(! strlen($image_uri))
464                                         continue;
465                                 $srch = '<' . intval($contact_id) . '>';
466
467                                 $r = q("SELECT `id` FROM `photo` WHERE `allow_cid` = '%s' AND `allow_gid` = '' AND `deny_cid` = '' AND `deny_gid` = ''
468                                         AND `resource-id` = '%s' AND `uid` = %d LIMIT 1",
469                                         dbesc($srch),
470                                         dbesc($image_uri),
471                                         intval($profile_uid)
472                                 );
473
474                                 if(! count($r))
475                                         continue;
476
477
478                                 $r = q("UPDATE `photo` SET `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s'
479                                         WHERE `resource-id` = '%s' AND `uid` = %d AND `album` = '%s' ",
480                                         dbesc($str_contact_allow),
481                                         dbesc($str_group_allow),
482                                         dbesc($str_contact_deny),
483                                         dbesc($str_group_deny),
484                                         dbesc($image_uri),
485                                         intval($profile_uid),
486                                         dbesc( t('Wall Photos'))
487                                 );
488
489                         }
490                 }
491         }
492
493
494         /**
495          * Next link in any attachment references we find in the post.
496          */
497
498         $match = false;
499
500         if((! $preview) && preg_match_all("/\[attachment\](.*?)\[\/attachment\]/",$body,$match)) {
501                 $attaches = $match[1];
502                 if(count($attaches)) {
503                         foreach($attaches as $attach) {
504                                 $r = q("SELECT * FROM `attach` WHERE `uid` = %d AND `id` = %d LIMIT 1",
505                                         intval($profile_uid),
506                                         intval($attach)
507                                 );
508                                 if(count($r)) {
509                                         $r = q("UPDATE `attach` SET `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s'
510                                                 WHERE `uid` = %d AND `id` = %d",
511                                                 dbesc($str_contact_allow),
512                                                 dbesc($str_group_allow),
513                                                 dbesc($str_contact_deny),
514                                                 dbesc($str_group_deny),
515                                                 intval($profile_uid),
516                                                 intval($attach)
517                                         );
518                                 }
519                         }
520                 }
521         }
522
523         // embedded bookmark in post? set bookmark flag
524
525         $bookmark = 0;
526         if(preg_match_all("/\[bookmark\=([^\]]*)\](.*?)\[\/bookmark\]/ism",$body,$match,PREG_SET_ORDER)) {
527                 $objecttype = ACTIVITY_OBJ_BOOKMARK;
528                 $bookmark = 1;
529         }
530
531         $body = bb_translate_video($body);
532
533
534         /**
535          * Fold multi-line [code] sequences
536          */
537
538         $body = preg_replace('/\[\/code\]\s*\[code\]/ism',"\n",$body);
539
540         $body = scale_external_images($body,false);
541
542
543         // Setting the object type if not defined before
544         if (!$objecttype) {
545                 $objecttype = ACTIVITY_OBJ_NOTE; // Default value
546                 require_once("include/plaintext.php");
547                 $objectdata = get_attached_data($body);
548
549                 if ($post["type"] == "link")
550                         $objecttype = ACTIVITY_OBJ_BOOKMARK;
551                 elseif ($post["type"] == "video")
552                         $objecttype = ACTIVITY_OBJ_VIDEO;
553                 elseif ($post["type"] == "photo")
554                         $objecttype = ACTIVITY_OBJ_IMAGE;
555
556         }
557
558         /**
559          * Look for any tags and linkify them
560          */
561
562         $str_tags = '';
563         $inform   = '';
564
565
566         $tags = get_tags($body);
567
568         /**
569          * add a statusnet style reply tag if the original post was from there
570          * and we are replying, and there isn't one already
571          */
572
573         if($parent AND ($parent_contact['network'] === NETWORK_OSTATUS)) {
574                 if ($parent_contact['id'] != "")
575                         $contact = '@'.$parent_contact['nick'].'+'.$parent_contact['id'];
576                 else
577                         $contact = '@[url='.$parent_contact['url'].']'.$parent_contact['nick'].'[/url]';
578
579                 if (!in_array($contact,$tags)) {
580                         $body = $contact.' '.$body;
581                         $tags[] = $contact;
582                 }
583
584                 $toplevel_contact = "";
585                 $toplevel_parent = q("SELECT `contact`.* FROM `contact`
586                                                 INNER JOIN `item` ON `item`.`contact-id` = `contact`.`id` AND `contact`.`url` = `item`.`author-link`
587                                                 WHERE `item`.`id` = `item`.`parent` AND `item`.`parent` = %d", intval($parent));
588                 if ($toplevel_parent)
589                         $toplevel_contact = '@'.$toplevel_parent[0]['nick'].'+'.$toplevel_parent[0]['id'];
590                 else {
591                         $toplevel_parent = q("SELECT `author-link`, `author-name` FROM `item` WHERE `id` = `parent` AND `parent` = %d", intval($parent));
592                         $toplevel_contact = '@[url='.$toplevel_parent[0]['author-link'].']'.$toplevel_parent[0]['author-name'].'[/url]';
593                 }
594
595                 if (!in_array($toplevel_contact,$tags))
596                         $tags[] = $toplevel_contact;
597         }
598
599         $tagged = array();
600
601         $private_forum = false;
602
603         if(count($tags)) {
604                 foreach($tags as $tag) {
605
606                         if(strpos($tag,'#') === 0)
607                                 continue;
608
609                         // If we already tagged 'Robert Johnson', don't try and tag 'Robert'.
610                         // Robert Johnson should be first in the $tags array
611
612                         $fullnametagged = false;
613                         for($x = 0; $x < count($tagged); $x ++) {
614                                 if(stristr($tagged[$x],$tag . ' ')) {
615                                         $fullnametagged = true;
616                                         break;
617                                 }
618                         }
619                         if($fullnametagged)
620                                 continue;
621
622                         $success = handle_tag($a, $body, $inform, $str_tags, (local_user()) ? local_user() : $profile_uid , $tag, $network);
623                         if($success['replaced'])
624                                 $tagged[] = $tag;
625                         if(is_array($success['contact']) && intval($success['contact']['prv'])) {
626                                 $private_forum = true;
627                                 $private_id = $success['contact']['id'];
628                         }
629                 }
630         }
631
632         if(($private_forum) && (! $parent) && (! $private)) {
633                 // we tagged a private forum in a top level post and the message was public.
634                 // Restrict it.
635                 $private = 1;
636                 $str_contact_allow = '<' . $private_id . '>';
637         }
638
639         $attachments = '';
640         $match = false;
641
642         if(preg_match_all('/(\[attachment\]([0-9]+)\[\/attachment\])/',$body,$match)) {
643                 foreach($match[2] as $mtch) {
644                         $r = q("SELECT `id`,`filename`,`filesize`,`filetype` FROM `attach` WHERE `uid` = %d AND `id` = %d LIMIT 1",
645                                 intval($profile_uid),
646                                 intval($mtch)
647                         );
648                         if(count($r)) {
649                                 if(strlen($attachments))
650                                         $attachments .= ',';
651                                 $attachments .= '[attach]href="' . $a->get_baseurl() . '/attach/' . $r[0]['id'] . '" length="' . $r[0]['filesize'] . '" type="' . $r[0]['filetype'] . '" title="' . (($r[0]['filename']) ? $r[0]['filename'] : '') . '"[/attach]';
652                         }
653                         $body = str_replace($match[1],'',$body);
654                 }
655         }
656
657         $wall = 0;
658
659         if($post_type === 'wall' || $post_type === 'wall-comment')
660                 $wall = 1;
661
662         if(! strlen($verb))
663                 $verb = ACTIVITY_POST ;
664
665         if ($network == "")
666                 $network = NETWORK_DFRN;
667
668         $gravity = (($parent) ? 6 : 0 );
669
670         // even if the post arrived via API we are considering that it
671         // originated on this site by default for determining relayability.
672
673         $origin = ((x($_REQUEST,'origin')) ? intval($_REQUEST['origin']) : 1);
674
675         $notify_type = (($parent) ? 'comment-new' : 'wall-new' );
676
677         $uri = (($message_id) ? $message_id : item_new_uri($a->get_hostname(),$profile_uid, $guid));
678
679         // Fallback so that we alway have a thr-parent
680         if(!$thr_parent)
681                 $thr_parent = $uri;
682
683         $datarray = array();
684         $datarray['uid']           = $profile_uid;
685         $datarray['type']          = $post_type;
686         $datarray['wall']          = $wall;
687         $datarray['gravity']       = $gravity;
688         $datarray['network']       = $network;
689         $datarray['contact-id']    = $contact_id;
690         $datarray['owner-name']    = $contact_record['name'];
691         $datarray['owner-link']    = $contact_record['url'];
692         $datarray['owner-avatar']  = $contact_record['thumb'];
693         $datarray['author-name']   = $author['name'];
694         $datarray['author-link']   = $author['url'];
695         $datarray['author-avatar'] = $author['thumb'];
696         $datarray['created']       = datetime_convert();
697         $datarray['edited']        = datetime_convert();
698         $datarray['commented']     = datetime_convert();
699         $datarray['received']      = datetime_convert();
700         $datarray['changed']       = datetime_convert();
701         $datarray['extid']         = $extid;
702         $datarray['guid']          = $guid;
703         $datarray['uri']           = $uri;
704         $datarray['title']         = $title;
705         $datarray['body']          = $body;
706         $datarray['app']           = $app;
707         $datarray['location']      = $location;
708         $datarray['coord']         = $coord;
709         $datarray['tag']           = $str_tags;
710         $datarray['file']          = $categories;
711         $datarray['inform']        = $inform;
712         $datarray['verb']          = $verb;
713         $datarray['object-type']   = $objecttype;
714         $datarray['allow_cid']     = $str_contact_allow;
715         $datarray['allow_gid']     = $str_group_allow;
716         $datarray['deny_cid']      = $str_contact_deny;
717         $datarray['deny_gid']      = $str_group_deny;
718         $datarray['private']       = $private;
719         $datarray['pubmail']       = $pubmail_enable;
720         $datarray['attach']        = $attachments;
721         $datarray['bookmark']      = intval($bookmark);
722         $datarray['thr-parent']    = $thr_parent;
723         $datarray['postopts']      = $postopts;
724         $datarray['origin']        = $origin;
725         $datarray['moderated']     = $allow_moderated;
726
727         /**
728          * These fields are for the convenience of plugins...
729          * 'self' if true indicates the owner is posting on their own wall
730          * If parent is 0 it is a top-level post.
731          */
732
733         $datarray['parent']        = $parent;
734         $datarray['self']          = $self;
735 //      $datarray['prvnets']       = $user['prvnets'];
736
737         if($orig_post)
738                 $datarray['edit']      = true;
739
740         // Search for hashtags
741         item_body_set_hashtags($datarray);
742
743         // preview mode - prepare the body for display and send it via json
744
745         if($preview) {
746                 require_once('include/conversation.php');
747                 $o = conversation($a,array(array_merge($contact_record,$datarray)),'search', false, true);
748                 logger('preview: ' . $o);
749                 echo json_encode(array('preview' => $o));
750                 killme();
751         }
752
753
754         call_hooks('post_local',$datarray);
755
756         if(x($datarray,'cancel')) {
757                 logger('mod_item: post cancelled by plugin.');
758                 if($return_path) {
759                         goaway($a->get_baseurl() . "/" . $return_path);
760                 }
761
762                 $json = array('cancel' => 1);
763                 if(x($_REQUEST,'jsreload') && strlen($_REQUEST['jsreload']))
764                         $json['reload'] = $a->get_baseurl() . '/' . $_REQUEST['jsreload'];
765
766                 echo json_encode($json);
767                 killme();
768         }
769
770         // Fill the cache field
771         put_item_in_cache($datarray);
772
773         if($orig_post) {
774                 $r = q("UPDATE `item` SET `title` = '%s', `body` = '%s', `tag` = '%s', `attach` = '%s', `file` = '%s', `rendered-html` = '%s', `rendered-hash` = '%s', `edited` = '%s', `changed` = '%s' WHERE `id` = %d AND `uid` = %d",
775                         dbesc($datarray['title']),
776                         dbesc($datarray['body']),
777                         dbesc($datarray['tag']),
778                         dbesc($datarray['attach']),
779                         dbesc($datarray['file']),
780                         dbesc($datarray['rendered-html']),
781                         dbesc($datarray['rendered-hash']),
782                         dbesc(datetime_convert()),
783                         dbesc(datetime_convert()),
784                         intval($post_id),
785                         intval($profile_uid)
786                 );
787
788                 create_tags_from_item($post_id);
789                 create_files_from_item($post_id);
790                 update_thread($post_id);
791
792                 // update filetags in pconfig
793                 file_tag_update_pconfig($uid,$categories_old,$categories_new,'category');
794
795                 proc_run('php', "include/notifier.php", 'edit_post', "$post_id");
796                 if((x($_REQUEST,'return')) && strlen($return_path)) {
797                         logger('return: ' . $return_path);
798                         goaway($a->get_baseurl() . "/" . $return_path );
799                 }
800                 killme();
801         }
802         else
803                 $post_id = 0;
804
805
806         $r = q("INSERT INTO `item` (`guid`, `extid`, `uid`,`type`,`wall`,`gravity`, `network`, `contact-id`,`owner-name`,`owner-link`,`owner-avatar`, `author-name`, `author-link`, `author-avatar`,
807                 `created`, `edited`, `commented`, `received`, `changed`, `uri`, `thr-parent`, `title`, `body`, `app`, `location`, `coord`, `tag`, `inform`, `verb`, `object-type`, `postopts`,
808                 `allow_cid`, `allow_gid`, `deny_cid`, `deny_gid`, `private`, `pubmail`, `attach`, `bookmark`,`origin`, `moderated`, `file`, `rendered-html`, `rendered-hash`)
809                 VALUES( '%s', '%s', %d, '%s', %d, %d, '%s', %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, %d, '%s', %d, %d, %d, '%s', '%s', '%s')",
810                 dbesc($datarray['guid']),
811                 dbesc($datarray['extid']),
812                 intval($datarray['uid']),
813                 dbesc($datarray['type']),
814                 intval($datarray['wall']),
815                 intval($datarray['gravity']),
816                 dbesc($datarray['network']),
817                 intval($datarray['contact-id']),
818                 dbesc($datarray['owner-name']),
819                 dbesc($datarray['owner-link']),
820                 dbesc($datarray['owner-avatar']),
821                 dbesc($datarray['author-name']),
822                 dbesc($datarray['author-link']),
823                 dbesc($datarray['author-avatar']),
824                 dbesc($datarray['created']),
825                 dbesc($datarray['edited']),
826                 dbesc($datarray['commented']),
827                 dbesc($datarray['received']),
828                 dbesc($datarray['changed']),
829                 dbesc($datarray['uri']),
830                 dbesc($datarray['thr-parent']),
831                 dbesc($datarray['title']),
832                 dbesc($datarray['body']),
833                 dbesc($datarray['app']),
834                 dbesc($datarray['location']),
835                 dbesc($datarray['coord']),
836                 dbesc($datarray['tag']),
837                 dbesc($datarray['inform']),
838                 dbesc($datarray['verb']),
839                 dbesc($datarray['object-type']),
840                 dbesc($datarray['postopts']),
841                 dbesc($datarray['allow_cid']),
842                 dbesc($datarray['allow_gid']),
843                 dbesc($datarray['deny_cid']),
844                 dbesc($datarray['deny_gid']),
845                 intval($datarray['private']),
846                 intval($datarray['pubmail']),
847                 dbesc($datarray['attach']),
848                 intval($datarray['bookmark']),
849                 intval($datarray['origin']),
850                 intval($datarray['moderated']),
851                 dbesc($datarray['file']),
852                 dbesc($datarray['rendered-html']),
853                 dbesc($datarray['rendered-hash'])
854                );
855
856         $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' LIMIT 1",
857                 dbesc($datarray['uri']));
858         if(!count($r)) {
859                 logger('mod_item: unable to retrieve post that was just stored.');
860                 notice( t('System error. Post not saved.') . EOL);
861                 goaway($a->get_baseurl() . "/" . $return_path );
862                 // NOTREACHED
863         }
864
865         // Store the guid and other relevant data
866         add_guid($datarray);
867
868         $post_id = $r[0]['id'];
869         logger('mod_item: saved item ' . $post_id);
870
871         $datarray["id"] = $post_id;
872         $datarray["plink"] = $a->get_baseurl().'/display/'.urlencode($datarray["guid"]);
873
874         // update filetags in pconfig
875         file_tag_update_pconfig($uid,$categories_old,$categories_new,'category');
876
877         if($parent) {
878
879                 // This item is the last leaf and gets the comment box, clear any ancestors
880                 $r = q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent` = %d ",
881                         dbesc(datetime_convert()),
882                         intval($parent)
883                 );
884                 update_thread($parent, true);
885
886                 // Inherit ACLs from the parent item.
887
888                 $r = q("UPDATE `item` SET `allow_cid` = '%s', `allow_gid` = '%s', `deny_cid` = '%s', `deny_gid` = '%s', `private` = %d
889                         WHERE `id` = %d",
890                         dbesc($parent_item['allow_cid']),
891                         dbesc($parent_item['allow_gid']),
892                         dbesc($parent_item['deny_cid']),
893                         dbesc($parent_item['deny_gid']),
894                         intval($parent_item['private']),
895                         intval($post_id)
896                 );
897
898                 if($contact_record != $author) {
899                         notification(array(
900                                 'type'         => NOTIFY_COMMENT,
901                                 'notify_flags' => $user['notify-flags'],
902                                 'language'     => $user['language'],
903                                 'to_name'      => $user['username'],
904                                 'to_email'     => $user['email'],
905                                 'uid'          => $user['uid'],
906                                 'item'         => $datarray,
907                                 'link'          => $a->get_baseurl().'/display/'.urlencode($datarray['guid']),
908                                 'source_name'  => $datarray['author-name'],
909                                 'source_link'  => $datarray['author-link'],
910                                 'source_photo' => $datarray['author-avatar'],
911                                 'verb'         => ACTIVITY_POST,
912                                 'otype'        => 'item',
913                                 'parent'       => $parent,
914                                 'parent_uri'   => $parent_item['uri']
915                         ));
916
917                 }
918
919
920                 // Store the comment signature information in case we need to relay to Diaspora
921                 store_diaspora_comment_sig($datarray, $author, ($self ? $a->user['prvkey'] : false), $parent_item, $post_id);
922
923         } else {
924                 $parent = $post_id;
925
926                 if($contact_record != $author) {
927                         notification(array(
928                                 'type'         => NOTIFY_WALL,
929                                 'notify_flags' => $user['notify-flags'],
930                                 'language'     => $user['language'],
931                                 'to_name'      => $user['username'],
932                                 'to_email'     => $user['email'],
933                                 'uid'          => $user['uid'],
934                                 'item'         => $datarray,
935                                 'link'          => $a->get_baseurl().'/display/'.urlencode($datarray['guid']),
936                                 'source_name'  => $datarray['author-name'],
937                                 'source_link'  => $datarray['author-link'],
938                                 'source_photo' => $datarray['author-avatar'],
939                                 'verb'         => ACTIVITY_POST,
940                                 'otype'        => 'item'
941                         ));
942                 }
943         }
944
945         // fallback so that parent always gets set to non-zero.
946
947         if(! $parent)
948                 $parent = $post_id;
949
950         $r = q("UPDATE `item` SET `parent` = %d, `parent-uri` = '%s', `plink` = '%s', `changed` = '%s', `last-child` = 1, `visible` = 1
951                 WHERE `id` = %d",
952                 intval($parent),
953                 dbesc(($parent == $post_id) ? $uri : $parent_item['uri']),
954                 dbesc($a->get_baseurl().'/display/'.urlencode($datarray['guid'])),
955                 dbesc(datetime_convert()),
956                 intval($post_id)
957         );
958
959         // photo comments turn the corresponding item visible to the profile wall
960         // This way we don't see every picture in your new photo album posted to your wall at once.
961         // They will show up as people comment on them.
962
963         if(! $parent_item['visible']) {
964                 $r = q("UPDATE `item` SET `visible` = 1 WHERE `id` = %d",
965                         intval($parent_item['id'])
966                 );
967                 update_thread($parent_item['id']);
968         }
969
970         // update the commented timestamp on the parent
971
972         q("UPDATE `item` set `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
973                 dbesc(datetime_convert()),
974                 dbesc(datetime_convert()),
975                 intval($parent)
976         );
977         if ($post_id != $parent)
978                 update_thread($parent);
979
980         call_hooks('post_local_end', $datarray);
981
982         if(strlen($emailcc) && $profile_uid == local_user()) {
983                 $erecips = explode(',', $emailcc);
984                 if(count($erecips)) {
985                         foreach($erecips as $recip) {
986                                 $addr = trim($recip);
987                                 if(! strlen($addr))
988                                         continue;
989                                 $disclaimer = '<hr />' . sprintf( t('This message was sent to you by %s, a member of the Friendica social network.'),$a->user['username'])
990                                         . '<br />';
991                                 $disclaimer .= sprintf( t('You may visit them online at %s'), $a->get_baseurl() . '/profile/' . $a->user['nickname']) . EOL;
992                                 $disclaimer .= t('Please contact the sender by replying to this post if you do not wish to receive these messages.') . EOL;
993                                 if (!$datarray['title']=='') {
994                                     $subject = email_header_encode($datarray['title'],'UTF-8');
995                                 } else {
996                                     $subject = email_header_encode('[Friendica]' . ' ' . sprintf( t('%s posted an update.'),$a->user['username']),'UTF-8');
997                                 }
998                                 $link = '<a href="' . $a->get_baseurl() . '/profile/' . $a->user['nickname'] . '"><img src="' . $author['thumb'] . '" alt="' . $a->user['username'] . '" /></a><br /><br />';
999                                 $html    = prepare_body($datarray);
1000                                 $message = '<html><body>' . $link . $html . $disclaimer . '</body></html>';
1001                                 include_once('include/html2plain.php');
1002                                 $params = array (
1003                                     'fromName' => $a->user['username'],
1004                                     'fromEmail' => $a->user['email'],
1005                                     'toEmail' => $addr,
1006                                     'replyTo' => $a->user['email'],
1007                                     'messageSubject' => $subject,
1008                                     'htmlVersion' => $message,
1009                                     'textVersion' => html2plain($html.$disclaimer),
1010                                 );
1011                                 Emailer::send($params);
1012                         }
1013                 }
1014         }
1015
1016         create_tags_from_item($post_id);
1017         create_files_from_item($post_id);
1018
1019         if ($post_id == $parent)
1020                 add_thread($post_id);
1021
1022         // This is a real juggling act on shared hosting services which kill your processes
1023         // e.g. dreamhost. We used to start delivery to our native delivery agents in the background
1024         // and then run our plugin delivery from the foreground. We're now doing plugin delivery first,
1025         // because as soon as you start loading up a bunch of remote delivey processes, *this* page is
1026         // likely to get killed off. If you end up looking at an /item URL and a blank page,
1027         // it's very likely the delivery got killed before all your friends could be notified.
1028         // Currently the only realistic fixes are to use a reliable server - which precludes shared hosting,
1029         // or cut back on plugins which do remote deliveries.
1030
1031         proc_run('php', "include/notifier.php", $notify_type, "$post_id");
1032
1033         logger('post_complete');
1034
1035         item_post_return($a->get_baseurl(), $api_source, $return_path);
1036         // NOTREACHED
1037 }
1038
1039 function item_post_return($baseurl, $api_source, $return_path) {
1040         // figure out how to return, depending on from whence we came
1041
1042         if($api_source)
1043                 return;
1044
1045         if($return_path) {
1046                 goaway($baseurl . "/" . $return_path);
1047         }
1048
1049         $json = array('success' => 1);
1050         if(x($_REQUEST,'jsreload') && strlen($_REQUEST['jsreload']))
1051                 $json['reload'] = $baseurl . '/' . $_REQUEST['jsreload'];
1052
1053         logger('post_json: ' . print_r($json,true), LOGGER_DEBUG);
1054
1055         echo json_encode($json);
1056         killme();
1057 }
1058
1059
1060
1061 function item_content(&$a) {
1062
1063         if((! local_user()) && (! remote_user()))
1064                 return;
1065
1066         require_once('include/security.php');
1067
1068         $o = '';
1069         if(($a->argc == 3) && ($a->argv[1] === 'drop') && intval($a->argv[2])) {
1070                 $o = drop_item($a->argv[2], !is_ajax());
1071                 if (is_ajax()){
1072                         // ajax return: [<item id>, 0 (no perm) | <owner id>]
1073                         echo json_encode(array(intval($a->argv[2]), intval($o)));
1074                         killme();
1075                 }
1076         }
1077         return $o;
1078 }
1079
1080 /**
1081  * This function removes the tag $tag from the text $body and replaces it with
1082  * the appropiate link.
1083  *
1084  * @param unknown_type $body the text to replace the tag in
1085  * @param unknown_type $inform a comma-seperated string containing everybody to inform
1086  * @param unknown_type $str_tags string to add the tag to
1087  * @param unknown_type $profile_uid
1088  * @param unknown_type $tag the tag to replace
1089  *
1090  * @return boolean true if replaced, false if not replaced
1091  */
1092 function handle_tag($a, &$body, &$inform, &$str_tags, $profile_uid, $tag, $network = "") {
1093
1094         $replaced = false;
1095         $r = null;
1096
1097         //is it a person tag?
1098         if(strpos($tag,'@') === 0) {
1099                 //is it already replaced?
1100                 if(strpos($tag,'[url=')) {
1101                         //append tag to str_tags
1102                         if(!stristr($str_tags,$tag)) {
1103                                 if(strlen($str_tags))
1104                                         $str_tags .= ',';
1105                                 $str_tags .= $tag;
1106                         }
1107
1108                         // Checking for the alias that is used for OStatus
1109                         $pattern = "/@\[url\=(.*?)\](.*?)\[\/url\]/ism";
1110                         if (preg_match($pattern, $tag, $matches)) {
1111                                 $data = probe_url($matches[1]);
1112                                 if ($data["alias"] != "") {
1113                                         $newtag = '@[url='.$data["alias"].']'.$data["name"].'[/url]';
1114                                         if(!stristr($str_tags,$newtag)) {
1115                                                 if(strlen($str_tags))
1116                                                         $str_tags .= ',';
1117                                                 $str_tags .= $newtag;
1118                                         }
1119                                 }
1120                         }
1121
1122                         return $replaced;
1123                 }
1124                 $stat = false;
1125                 //get the person's name
1126                 $name = substr($tag,1);
1127                 //is it a link or a full dfrn address?
1128                 if((strpos($name,'@')) || (strpos($name,'http://'))) {
1129                         $newname = $name;
1130                         //get the profile links
1131                         $links = @lrdd($name);
1132                         if(count($links)) {
1133                                 //for all links, collect how is to inform and how's profile is to link
1134                                 foreach($links as $link) {
1135                                         if($link['@attributes']['rel'] === 'http://webfinger.net/rel/profile-page')
1136                                                 $profile = $link['@attributes']['href'];
1137                                         if($link['@attributes']['rel'] === 'salmon') {
1138                                                 if(strlen($inform))
1139                                                         $inform .= ',';
1140                                                 $inform .= 'url:' . str_replace(',','%2c',$link['@attributes']['href']);
1141                                         }
1142                                 }
1143                         }
1144                 } elseif (($network != NETWORK_OSTATUS) AND ($network != NETWORK_TWITTER) AND
1145                         ($network != NETWORK_STATUSNET) AND ($network != NETWORK_APPNET)) {
1146                         //if it is a name rather than an address
1147                         $newname = $name;
1148                         $alias = '';
1149                         $tagcid = 0;
1150                         //is it some generated name?
1151                         if(strrpos($newname,'+')) {
1152                                 //get the id
1153                                 $tagcid = intval(substr($newname,strrpos($newname,'+') + 1));
1154                                 //remove the next word from tag's name
1155                                 if(strpos($name,' ')) {
1156                                         $name = substr($name,0,strpos($name,' '));
1157                                 }
1158                         }
1159                         if($tagcid) { //if there was an id
1160                                 //select contact with that id from the logged in user's contact list
1161                                 $r = q("SELECT * FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
1162                                                 intval($tagcid),
1163                                                 intval($profile_uid)
1164                                 );
1165                         }
1166                         else {
1167                                 $newname = str_replace('_',' ',$name);
1168
1169                                 // At first try to fetch a contact according to the given network
1170                                 if ($network != "") {
1171                                         //select someone from this user's contacts by name
1172                                         $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `network` = '%s' AND `uid` = %d LIMIT 1",
1173                                                         dbesc($newname),
1174                                                         dbesc($network),
1175                                                         intval($profile_uid)
1176                                         );
1177                                         if(! $r) {
1178                                                 //select someone by attag or nick and the name passed in
1179                                                 $r = q("SELECT * FROM `contact` WHERE `attag` = '%s' OR `nick` = '%s' AND `network` = '%s' AND `uid` = %d ORDER BY `attag` DESC LIMIT 1",
1180                                                                 dbesc($name),
1181                                                                 dbesc($name),
1182                                                                 dbesc($network),
1183                                                                 intval($profile_uid)
1184                                                 );
1185                                         }
1186                                 } else
1187                                         $r = false;
1188
1189                                 if(! $r) {
1190                                         //select someone from this user's contacts by name
1191                                         $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `uid` = %d LIMIT 1",
1192                                                         dbesc($newname),
1193                                                         intval($profile_uid)
1194                                         );
1195                                 }
1196
1197                                 if(! $r) {
1198                                         //select someone by attag or nick and the name passed in
1199                                         $r = q("SELECT * FROM `contact` WHERE `attag` = '%s' OR `nick` = '%s' AND `uid` = %d ORDER BY `attag` DESC LIMIT 1",
1200                                                         dbesc($name),
1201                                                         dbesc($name),
1202                                                         intval($profile_uid)
1203                                         );
1204                                 }
1205                         }
1206 /*                      } elseif(strstr($name,'_') || strstr($name,' ')) { //no id
1207                                 //get the real name
1208                                 $newname = str_replace('_',' ',$name);
1209                                 //select someone from this user's contacts by name
1210                                 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `uid` = %d LIMIT 1",
1211                                                 dbesc($newname),
1212                                                 intval($profile_uid)
1213                                 );
1214                         } else {
1215                                 //select someone by attag or nick and the name passed in
1216                                 $r = q("SELECT * FROM `contact` WHERE `attag` = '%s' OR `nick` = '%s' AND `uid` = %d ORDER BY `attag` DESC LIMIT 1",
1217                                                 dbesc($name),
1218                                                 dbesc($name),
1219                                                 intval($profile_uid)
1220                                 );
1221                         }*/
1222                         //$r is set, if someone could be selected
1223                         if(count($r)) {
1224                                 $profile = $r[0]['url'];
1225                                 //set newname to nick, find alias
1226                                 if(($r[0]['network'] === NETWORK_OSTATUS) OR ($r[0]['network'] === NETWORK_TWITTER)
1227                                         OR ($r[0]['network'] === NETWORK_STATUSNET) OR ($r[0]['network'] === NETWORK_APPNET)) {
1228                                         $newname = $r[0]['nick'];
1229                                         $stat = true;
1230                                         if($r[0]['alias'])
1231                                                 $alias = $r[0]['alias'];
1232                                 }
1233                                 else
1234                                         $newname = $r[0]['name'];
1235                                 //add person's id to $inform
1236                                 if(strlen($inform))
1237                                         $inform .= ',';
1238                                 $inform .= 'cid:' . $r[0]['id'];
1239                         }
1240                 }
1241                 //if there is an url for this persons profile
1242                 if(isset($profile)) {
1243                         $replaced = true;
1244                         //create profile link
1245                         $profile = str_replace(',','%2c',$profile);
1246                         $newtag = '@[url=' . $profile . ']' . $newname  . '[/url]';
1247                         $body = str_replace('@' . $name, $newtag, $body);
1248                         //append tag to str_tags
1249                         if(! stristr($str_tags,$newtag)) {
1250                                 if(strlen($str_tags))
1251                                         $str_tags .= ',';
1252                                 $str_tags .= $newtag;
1253                         }
1254
1255                         // Status.Net seems to require the numeric ID URL in a mention if the person isn't
1256                         // subscribed to you. But the nickname URL is OK if they are. Grrr. We'll tag both.
1257
1258                         if(strlen($alias)) {
1259                                 $newtag = '@[url=' . $alias . ']' . $newname    . '[/url]';
1260                                 if(! stristr($str_tags,$newtag)) {
1261                                         if(strlen($str_tags))
1262                                                 $str_tags .= ',';
1263                                         $str_tags .= $newtag;
1264                                 }
1265                         }
1266                 }
1267         }
1268
1269         return array('replaced' => $replaced, 'contact' => $r[0]);
1270 }
1271
1272
1273 function store_diaspora_comment_sig($datarray, $author, $uprvkey, $parent_item, $post_id) {
1274         // We won't be able to sign Diaspora comments for authenticated visitors - we don't have their private key
1275
1276         $enabled = intval(get_config('system','diaspora_enabled'));
1277         if(! $enabled) {
1278                 logger('mod_item: diaspora support disabled, not storing comment signature', LOGGER_DEBUG);
1279                 return;
1280         }
1281
1282
1283         logger('mod_item: storing diaspora comment signature');
1284
1285         require_once('include/bb2diaspora.php');
1286         $signed_body = html_entity_decode(bb2diaspora($datarray['body']));
1287
1288         // Only works for NETWORK_DFRN
1289         $contact_baseurl_start = strpos($author['url'],'://') + 3;
1290         $contact_baseurl_length = strpos($author['url'],'/profile') - $contact_baseurl_start;
1291         $contact_baseurl = substr($author['url'], $contact_baseurl_start, $contact_baseurl_length);
1292         $diaspora_handle = $author['nick'] . '@' . $contact_baseurl;
1293
1294         $signed_text = $datarray['guid'] . ';' . $parent_item['guid'] . ';' . $signed_body . ';' . $diaspora_handle;
1295
1296         if( $uprvkey !== false )
1297                 $authorsig = base64_encode(rsa_sign($signed_text,$uprvkey,'sha256'));
1298         else
1299                 $authorsig = '';
1300
1301         q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
1302                 intval($post_id),
1303                 dbesc($signed_text),
1304                 dbesc(base64_encode($authorsig)),
1305                 dbesc($diaspora_handle)
1306         );
1307
1308         return;
1309 }