3 * Name: Facebook Connector
5 * Author: Mike Macgirvin <http://macgirvin.com/profile/mike>
6 * Author: Tobias Hößl <https://github.com/CatoTH/>
11 * Installing the Friendica/Facebook connector
13 * Detailed instructions how to use this plugin can be found at
14 * https://github.com/friendica/friendica/wiki/How-to:-Friendica%E2%80%99s-Facebook-connector
16 * Vidoes and embeds will not be posted if there is no other content. Links
17 * and images will be converted to a format suitable for the Facebook API and
18 * long posts truncated - with a link to view the full post.
20 * Facebook contacts will not be able to view private photos, as they are not able to
21 * authenticate to your site to establish identity. We will address this
22 * in a future release.
26 * - Implement a method for the administrator to delete all configuration data the plugin has created,
27 * e.g. the app_access_token
30 // Size of maximum post length increased
31 // see http://www.facebook.com/schrep/posts/203969696349811
32 // define('FACEBOOK_MAXPOSTLEN', 420);
33 define('FACEBOOK_MAXPOSTLEN', 63206);
34 define('FACEBOOK_SESSION_ERR_NOTIFICATION_INTERVAL', 259200); // 3 days
35 define('FACEBOOK_DEFAULT_POLL_INTERVAL', 60); // given in minutes
36 define('FACEBOOK_MIN_POLL_INTERVAL', 5);
37 define('FACEBOOK_RTU_ERR_MAIL_AFTER_MINUTES', 180); // 3 hours
39 require_once('include/security.php');
41 function facebook_install() {
42 register_hook('post_local', 'addon/facebook/facebook.php', 'facebook_post_local');
43 register_hook('notifier_normal', 'addon/facebook/facebook.php', 'facebook_post_hook');
44 register_hook('jot_networks', 'addon/facebook/facebook.php', 'facebook_jot_nets');
45 register_hook('connector_settings', 'addon/facebook/facebook.php', 'facebook_plugin_settings');
46 register_hook('cron', 'addon/facebook/facebook.php', 'facebook_cron');
47 register_hook('enotify', 'addon/facebook/facebook.php', 'facebook_enotify');
48 register_hook('queue_predeliver', 'addon/facebook/facebook.php', 'fb_queue_hook');
52 function facebook_uninstall() {
53 unregister_hook('post_local', 'addon/facebook/facebook.php', 'facebook_post_local');
54 unregister_hook('notifier_normal', 'addon/facebook/facebook.php', 'facebook_post_hook');
55 unregister_hook('jot_networks', 'addon/facebook/facebook.php', 'facebook_jot_nets');
56 unregister_hook('connector_settings', 'addon/facebook/facebook.php', 'facebook_plugin_settings');
57 unregister_hook('cron', 'addon/facebook/facebook.php', 'facebook_cron');
58 unregister_hook('enotify', 'addon/facebook/facebook.php', 'facebook_enotify');
59 unregister_hook('queue_predeliver', 'addon/facebook/facebook.php', 'fb_queue_hook');
62 unregister_hook('post_local_end', 'addon/facebook/facebook.php', 'facebook_post_hook');
63 unregister_hook('plugin_settings', 'addon/facebook/facebook.php', 'facebook_plugin_settings');
67 /* declare the facebook_module function so that /facebook url requests will land here */
69 function facebook_module() {}
73 // If a->argv[1] is a nickname, this is a callback from Facebook oauth requests.
74 // If $_REQUEST["realtime_cb"] is set, this is a callback from the Real-Time Updates API
79 function facebook_init(&$a) {
81 if (x($_REQUEST, "realtime_cb") && x($_REQUEST, "realtime_cb")) {
82 logger("facebook_init: Facebook Real-Time callback called", LOGGER_DEBUG);
84 if (x($_REQUEST, "hub_verify_token")) {
85 // this is the verification callback while registering for real time updates
87 $verify_token = get_config('facebook', 'cb_verify_token');
88 if ($verify_token != $_REQUEST["hub_verify_token"]) {
89 logger('facebook_init: Wrong Facebook Callback Verifier - expected ' . $verify_token . ', got ' . $_REQUEST["hub_verify_token"]);
93 if (x($_REQUEST, "hub_challenge")) {
94 logger('facebook_init: Answering Challenge: ' . $_REQUEST["hub_challenge"], LOGGER_DATA);
95 echo $_REQUEST["hub_challenge"];
100 require_once('include/items.php');
102 // this is a status update
103 $content = file_get_contents("php://input");
104 if (is_numeric($content)) $content = file_get_contents("php://input");
105 $js = json_decode($content);
106 logger(print_r($js, true), LOGGER_DATA);
108 if (!isset($js->object) || $js->object != "user" || !isset($js->entry)) {
109 logger('facebook_init: Could not parse Real-Time Update data', LOGGER_DEBUG);
113 $affected_users = array("feed" => array(), "friends" => array());
115 foreach ($js->entry as $entry) {
116 $fbuser = $entry->uid;
117 foreach ($entry->changed_fields as $field) {
118 if (!isset($affected_users[$field])) {
119 logger('facebook_init: Unknown field "' . $field . '"');
122 if (in_array($fbuser, $affected_users[$field])) continue;
124 $r = q("SELECT `uid` FROM `pconfig` WHERE `cat` = 'facebook' AND `k` = 'self_id' AND `v` = '%s' LIMIT 1", dbesc($fbuser));
129 $access_token = get_pconfig($uid,'facebook','access_token');
135 logger('facebook_init: FB-User ' . $fbuser . ' / feed', LOGGER_DEBUG);
137 if(! get_pconfig($uid,'facebook','no_wall')) {
138 $private_wall = intval(get_pconfig($uid,'facebook','private_wall'));
139 $s = fetch_url('https://graph.facebook.com/me/feed?access_token=' . $access_token);
141 $j = json_decode($s);
142 if (isset($j->data)) {
143 logger('facebook_init: wall: ' . print_r($j,true), LOGGER_DATA);
144 fb_consume_stream($uid,$j,($private_wall) ? false : true);
146 logger('facebook_init: wall: got no data from Facebook: ' . print_r($j,true), LOGGER_NORMAL);
153 logger('facebook_init: FB-User ' . $fbuser . ' / friends', LOGGER_DEBUG);
155 fb_get_friends($uid, false);
156 set_pconfig($uid,'facebook','friend_check',time());
159 logger('facebook_init: Unknown callback field for ' . $fbuser, LOGGER_NORMAL);
161 $affected_users[$field][] = $fbuser;
172 $r = q("SELECT `uid` FROM `user` WHERE `nickname` = '%s' LIMIT 1",
175 if(!(isset($r) && count($r)))
179 $auth_code = (x($_GET, 'code') ? $_GET['code'] : '');
180 $error = (x($_GET, 'error_description') ? $_GET['error_description'] : '');
184 logger('facebook_init: Error: ' . $error);
186 if($auth_code && $uid) {
188 $appid = get_config('facebook','appid');
189 $appsecret = get_config('facebook', 'appsecret');
191 $x = fetch_url('https://graph.facebook.com/oauth/access_token?client_id='
192 . $appid . '&client_secret=' . $appsecret . '&redirect_uri='
193 . urlencode($a->get_baseurl() . '/facebook/' . $nick)
194 . '&code=' . $auth_code);
196 logger('facebook_init: returned access token: ' . $x, LOGGER_DATA);
198 if(strpos($x,'access_token=') !== false) {
199 $token = str_replace('access_token=', '', $x);
200 if(strpos($token,'&') !== false)
201 $token = substr($token,0,strpos($token,'&'));
202 set_pconfig($uid,'facebook','access_token',$token);
203 set_pconfig($uid,'facebook','post','1');
204 if(get_pconfig($uid,'facebook','no_linking') === false)
205 set_pconfig($uid,'facebook','no_linking',1);
207 fb_get_friends($uid, true);
208 fb_consume_all($uid);
220 function fb_get_self($uid) {
221 $access_token = get_pconfig($uid,'facebook','access_token');
224 $s = fetch_url('https://graph.facebook.com/me/?access_token=' . $access_token);
226 $j = json_decode($s);
227 set_pconfig($uid,'facebook','self_id',(string) $j->id);
233 * @param string $access_token
234 * @param array $persons
236 function fb_get_friends_sync_new($uid, $access_token, $persons) {
237 $persons_todo = array();
238 foreach ($persons as $person) {
239 $link = 'http://facebook.com/profile.php?id=' . $person->id;
241 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `url` = '%s' LIMIT 1",
246 if (count($r) == 0) {
247 logger('fb_get_friends: new contact found: ' . $link, LOGGER_DEBUG);
248 $persons_todo[] = $person;
251 if (count($persons_todo) > 0) fb_get_friends_sync_full($uid, $access_token, $persons_todo);
257 * @param object $contact
259 function fb_get_friends_sync_parsecontact($uid, $contact) {
260 $contact->link = 'http://facebook.com/profile.php?id=' . $contact->id;
262 // If its a page then set the first name from the username
263 if (!$contact->first_name and $contact->username)
264 $contact->first_name = $contact->username;
266 // check if we already have a contact
268 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `url` = '%s' LIMIT 1",
270 dbesc($contact->link)
275 // update profile photos once every two weeks as we have no notification of when they change.
277 $update_photo = (($r[0]['avatar-date'] < datetime_convert('','','now -14 days')) ? true : false);
279 // check that we have all the photos, this has been known to fail on occasion
281 if((! $r[0]['photo']) || (! $r[0]['thumb']) || (! $r[0]['micro']) || ($update_photo)) {
282 require_once("Photo.php");
284 $photos = import_profile_photo('https://graph.facebook.com/' . $contact->id . '/picture', $uid, $r[0]['id']);
286 q("UPDATE `contact` SET `photo` = '%s',
292 WHERE `id` = %d LIMIT 1
297 dbesc(datetime_convert()),
298 dbesc(datetime_convert()),
299 dbesc(datetime_convert()),
307 // create contact record
308 q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `addr`, `alias`, `notify`, `poll`,
309 `name`, `nick`, `photo`, `network`, `rel`, `priority`,
310 `writable`, `blocked`, `readonly`, `pending` )
311 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, %d, %d, 0, 0, 0 ) ",
313 dbesc(datetime_convert()),
314 dbesc($contact->link),
315 dbesc(normalise_link($contact->link)),
319 dbesc('facebook ' . $contact->id),
320 dbesc($contact->name),
321 dbesc(($contact->nickname) ? $contact->nickname : mb_convert_case($contact->first_name, MB_CASE_LOWER, "UTF-8")),
322 dbesc('https://graph.facebook.com/' . $contact->id . '/picture'),
323 dbesc(NETWORK_FACEBOOK),
324 intval(CONTACT_IS_FRIEND),
330 $r = q("SELECT * FROM `contact` WHERE `url` = '%s' AND `uid` = %d LIMIT 1",
331 dbesc($contact->link),
339 $contact_id = $r[0]['id'];
341 $g = q("select def_gid from user where uid = %d limit 1",
344 if($g && intval($g[0]['def_gid'])) {
345 require_once('include/group.php');
346 group_add_member($uid,'',$contact_id,$g[0]['def_gid']);
349 require_once("Photo.php");
351 $photos = import_profile_photo($r[0]['photo'],$uid,$contact_id);
353 q("UPDATE `contact` SET `photo` = '%s',
359 WHERE `id` = %d LIMIT 1
364 dbesc(datetime_convert()),
365 dbesc(datetime_convert()),
366 dbesc(datetime_convert()),
373 * @param string $access_token
374 * @param array $persons
376 function fb_get_friends_sync_full($uid, $access_token, $persons) {
377 if (count($persons) == 0) return;
378 $nums = Ceil(count($persons) / 50);
379 for ($i = 0; $i < $nums; $i++) {
380 $batch_request = array();
381 for ($j = $i * 50; $j < ($i+1) * 50 && $j < count($persons); $j++) $batch_request[] = array('method'=>'GET', 'relative_url'=>$persons[$j]->id);
382 $s = post_url('https://graph.facebook.com/', array('access_token' => $access_token, 'batch' => json_encode($batch_request)));
384 $results = json_decode($s);
385 logger('fb_get_friends: info: ' . print_r($results,true), LOGGER_DATA);
386 foreach ($results as $contact) {
387 if ($contact->code != 200) logger('fb_get_friends: not found: ' . print_r($contact,true), LOGGER_DEBUG);
388 else fb_get_friends_sync_parsecontact($uid, json_decode($contact->body));
396 // if $fullsync is true, only new contacts are searched for
400 * @param bool $fullsync
402 function fb_get_friends($uid, $fullsync = true) {
404 $r = q("SELECT `uid` FROM `user` WHERE `uid` = %d AND `account_expired` = 0 LIMIT 1",
410 $access_token = get_pconfig($uid,'facebook','access_token');
412 $no_linking = get_pconfig($uid,'facebook','no_linking');
419 $s = fetch_url('https://graph.facebook.com/me/friends?access_token=' . $access_token);
421 logger('facebook: fb_get_friends: ' . $s, LOGGER_DATA);
422 $j = json_decode($s);
423 logger('facebook: fb_get_friends: json: ' . print_r($j,true), LOGGER_DATA);
427 $persons_todo = array();
428 foreach($j->data as $person) $persons_todo[] = $person;
431 fb_get_friends_sync_full($uid, $access_token, $persons_todo);
433 fb_get_friends_sync_new($uid, $access_token, $persons_todo);
437 // This is the POST method to the facebook settings page
438 // Content is posted to Facebook in the function facebook_post_hook()
443 function facebook_post(&$a) {
449 $fb_limited = get_config('facebook','crestrict');
452 $value = ((x($_POST,'post_by_default')) ? intval($_POST['post_by_default']) : 0);
453 set_pconfig($uid,'facebook','post_by_default', $value);
455 $no_linking = get_pconfig($uid,'facebook','no_linking');
457 $no_wall = ((x($_POST,'facebook_no_wall')) ? intval($_POST['facebook_no_wall']) : 0);
458 set_pconfig($uid,'facebook','no_wall',$no_wall);
460 $private_wall = ((x($_POST,'facebook_private_wall')) ? intval($_POST['facebook_private_wall']) : 0);
461 set_pconfig($uid,'facebook','private_wall',$private_wall);
464 set_pconfig($uid,'facebook','blocked_apps',escape_tags(trim($_POST['blocked_apps'])));
466 $linkvalue = ((x($_POST,'facebook_linking')) ? intval($_POST['facebook_linking']) : 0);
470 set_pconfig($uid,'facebook','no_linking', 1);
473 set_pconfig($uid,'facebook','no_linking', (($linkvalue) ? 0 : 1));
475 // FB linkage was allowed but has just been turned off - remove all FB contacts and posts
477 if((! intval($no_linking)) && (! intval($linkvalue))) {
478 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `network` = '%s' ",
480 dbesc(NETWORK_FACEBOOK)
483 require_once('include/Contact.php');
485 contact_remove($rr['id']);
488 elseif(intval($no_linking) && intval($linkvalue)) {
489 // FB linkage is now allowed - import stuff.
491 fb_get_friends($uid, true);
492 fb_consume_all($uid);
495 info( t('Settings updated.') . EOL);
501 // Facebook settings form
507 function facebook_content(&$a) {
510 notice( t('Permission denied.') . EOL);
515 if(! service_class_allows(local_user(),'facebook_connect')) {
516 notice( t('Permission denied.') . EOL);
517 return upgrade_bool_message();
521 if($a->argc > 1 && $a->argv[1] === 'remove') {
522 del_pconfig(local_user(),'facebook','post');
523 info( t('Facebook disabled') . EOL);
526 if($a->argc > 1 && $a->argv[1] === 'friends') {
527 fb_get_friends(local_user(), true);
528 info( t('Updating contacts') . EOL);
532 $fb_limited = get_config('facebook','restrict');
536 $fb_installed = false;
537 if (get_pconfig(local_user(),'facebook','post')) {
538 $access_token = get_pconfig(local_user(),'facebook','access_token');
540 $s = fetch_url('https://graph.facebook.com/me/feed?access_token=' . $access_token);
542 $j = json_decode($s);
543 if (isset($j->data)) $fb_installed = true;
548 $appid = get_config('facebook','appid');
551 notice( t('Facebook API key is missing.') . EOL);
555 $a->page['htmlhead'] .= '<link rel="stylesheet" type="text/css" href="'
556 . $a->get_baseurl() . '/addon/facebook/facebook.css' . '" media="all" />' . "\r\n";
558 $o .= '<h3>' . t('Facebook Connect') . '</h3>';
560 if(! $fb_installed) {
561 $o .= '<div id="facebook-enable-wrapper">';
563 $o .= '<a href="https://www.facebook.com/dialog/oauth?client_id=' . $appid . '&redirect_uri='
564 . $a->get_baseurl() . '/facebook/' . $a->user['nickname'] . '&scope=publish_stream,read_stream,offline_access">' . t('Install Facebook connector for this account.') . '</a>';
569 $o .= '<div id="facebook-disable-wrapper">';
571 $o .= '<a href="' . $a->get_baseurl() . '/facebook/remove' . '">' . t('Remove Facebook connector') . '</a></div>';
573 $o .= '<div id="facebook-enable-wrapper">';
575 $o .= '<a href="https://www.facebook.com/dialog/oauth?client_id=' . $appid . '&redirect_uri='
576 . $a->get_baseurl() . '/facebook/' . $a->user['nickname'] . '&scope=publish_stream,read_stream,offline_access">' . t('Re-authenticate [This is necessary whenever your Facebook password is changed.]') . '</a>';
579 $o .= '<div id="facebook-post-default-form">';
580 $o .= '<form action="facebook" method="post" >';
581 $post_by_default = get_pconfig(local_user(),'facebook','post_by_default');
582 $checked = (($post_by_default) ? ' checked="checked" ' : '');
583 $o .= '<input type="checkbox" name="post_by_default" value="1"' . $checked . '/>' . ' ' . t('Post to Facebook by default') . EOL;
585 $no_linking = get_pconfig(local_user(),'facebook','no_linking');
586 $checked = (($no_linking) ? '' : ' checked="checked" ');
589 $o .= EOL . '<strong>' . t('Facebook friend linking has been disabled on this site. The following settings will have no effect.') . '</strong>' . EOL;
590 $checked .= " disabled ";
593 $o .= EOL . '<strong>' . t('Facebook friend linking has been disabled on this site. If you disable it, you will be unable to re-enable it.') . '</strong>' . EOL;
596 $o .= '<input type="checkbox" name="facebook_linking" value="1"' . $checked . '/>' . ' ' . t('Link all your Facebook friends and conversations on this website') . EOL ;
598 $o .= '<p>' . t('Facebook conversations consist of your <em>profile wall</em> and your friend <em>stream</em>.');
599 $o .= ' ' . t('On this website, your Facebook friend stream is only visible to you.');
600 $o .= ' ' . t('The following settings determine the privacy of your Facebook profile wall on this website.') . '</p>';
602 $private_wall = get_pconfig(local_user(),'facebook','private_wall');
603 $checked = (($private_wall) ? ' checked="checked" ' : '');
604 $o .= '<input type="checkbox" name="facebook_private_wall" value="1"' . $checked . '/>' . ' ' . t('On this website your Facebook profile wall conversations will only be visible to you') . EOL ;
607 $no_wall = get_pconfig(local_user(),'facebook','no_wall');
608 $checked = (($no_wall) ? ' checked="checked" ' : '');
609 $o .= '<input type="checkbox" name="facebook_no_wall" value="1"' . $checked . '/>' . ' ' . t('Do not import your Facebook profile wall conversations') . EOL ;
611 $o .= '<p>' . t('If you choose to link conversations and leave both of these boxes unchecked, your Facebook profile wall will be merged with your profile wall on this website and your privacy settings on this website will be used to determine who may see the conversations.') . '</p>';
614 $blocked_apps = get_pconfig(local_user(),'facebook','blocked_apps');
616 $o .= '<div><label id="blocked-apps-label" for="blocked-apps">' . t('Comma separated applications to ignore') . ' </label></div>';
617 $o .= '<div><textarea id="blocked-apps" name="blocked_apps" >' . htmlspecialchars($blocked_apps) . '</textarea></div>';
619 $o .= '<input type="submit" name="submit" value="' . t('Submit') . '" /></form></div>';
628 * @param null|object $b
631 function facebook_cron($a,$b) {
633 $last = get_config('facebook','last_poll');
635 $poll_interval = intval(get_config('facebook','poll_interval'));
637 $poll_interval = FACEBOOK_DEFAULT_POLL_INTERVAL;
640 $next = $last + ($poll_interval * 60);
645 logger('facebook_cron');
648 // Find the FB users on this site and randomize in case one of them
649 // uses an obscene amount of memory. It may kill this queue run
650 // but hopefully we'll get a few others through on each run.
652 $r = q("SELECT * FROM `pconfig` WHERE `cat` = 'facebook' AND `k` = 'post' AND `v` = '1' ORDER BY RAND() ");
655 if(get_pconfig($rr['uid'],'facebook','no_linking'))
657 $ab = intval(get_config('system','account_abandon_days'));
659 $z = q("SELECT `uid` FROM `user` WHERE `uid` = %d AND `login_date` > UTC_TIMESTAMP() - INTERVAL %d DAY LIMIT 1",
667 // check for new friends once a day
668 $last_friend_check = get_pconfig($rr['uid'],'facebook','friend_check');
669 if($last_friend_check)
670 $next_friend_check = $last_friend_check + 86400;
672 $next_friend_check = 0;
673 if($next_friend_check <= time()) {
674 fb_get_friends($rr['uid'], true);
675 set_pconfig($rr['uid'],'facebook','friend_check',time());
677 fb_consume_all($rr['uid']);
681 if (get_config('facebook', 'realtime_active') == 1) {
682 if (!facebook_check_realtime_active()) {
684 logger('facebook_cron: Facebook is not sending Real-Time Updates any more, although it is supposed to. Trying to fix it...', LOGGER_NORMAL);
685 facebook_subscription_add_users();
687 if (facebook_check_realtime_active())
688 logger('facebook_cron: Successful', LOGGER_NORMAL);
690 logger('facebook_cron: Failed', LOGGER_NORMAL);
692 $first_err = get_config('facebook', 'realtime_first_err');
695 set_config('facebook', 'realtime_first_err', $first_err);
697 $first_err_ago = (time() - $first_err);
699 if(strlen($a->config['admin_email']) && !get_config('facebook', 'realtime_err_mailsent') && $first_err_ago > (FACEBOOK_RTU_ERR_MAIL_AFTER_MINUTES * 60)) {
700 mail($a->config['admin_email'], t('Problems with Facebook Real-Time Updates'),
701 "Hi!\n\nThere's a problem with the Facebook Real-Time Updates that cannot be solved automatically. Maybe a permission issue?\n\nPlease try to re-activate it on " . $a->config["system"]["url"] . "/admin/plugins/facebook\n\nThis e-mail will only be sent once.",
702 'From: ' . t('Administrator') . '@' . $_SERVER['SERVER_NAME'] . "\n"
703 . 'Content-type: text/plain; charset=UTF-8' . "\n"
704 . 'Content-transfer-encoding: 8bit'
707 set_config('facebook', 'realtime_err_mailsent', 1);
710 } else { // !facebook_check_realtime_active()
711 del_config('facebook', 'realtime_err_mailsent');
712 del_config('facebook', 'realtime_first_err');
716 set_config('facebook','last_poll', time());
723 * @param null|object $b
725 function facebook_plugin_settings(&$a,&$b) {
727 $b .= '<div class="settings-block">';
728 $b .= '<h3>' . t('Facebook') . '</h3>';
729 $b .= '<a href="facebook">' . t('Facebook Connector Settings') . '</a><br />';
737 * @param null|object $o
739 function facebook_plugin_admin(&$a, &$o){
742 $o = '<input type="hidden" name="form_security_token" value="' . get_form_security_token("fbsave") . '">';
744 $o .= '<h4>' . t('Facebook API Key') . '</h4>';
746 $appid = get_config('facebook', 'appid' );
747 $appsecret = get_config('facebook', 'appsecret' );
748 $poll_interval = get_config('facebook', 'poll_interval' );
749 $sync_comments = get_config('facebook', 'sync_comments' );
750 if (!$poll_interval) $poll_interval = FACEBOOK_DEFAULT_POLL_INTERVAL;
752 $ret1 = q("SELECT `v` FROM `config` WHERE `cat` = 'facebook' AND `k` = 'appid' LIMIT 1");
753 $ret2 = q("SELECT `v` FROM `config` WHERE `cat` = 'facebook' AND `k` = 'appsecret' LIMIT 1");
754 if ((count($ret1) > 0 && $ret1[0]['v'] != $appid) || (count($ret2) > 0 && $ret2[0]['v'] != $appsecret)) $o .= t('Error: it appears that you have specified the App-ID and -Secret in your .htconfig.php file. As long as they are specified there, they cannot be set using this form.<br><br>');
756 $working_connection = false;
757 if ($appid && $appsecret) {
758 $subs = facebook_subscriptions_get();
759 if ($subs === null) $o .= t('Error: the given API Key seems to be incorrect (the application access token could not be retrieved).') . '<br>';
760 elseif (is_array($subs)) {
761 $o .= t('The given API Key seems to work correctly.') . '<br>';
762 $working_connection = true;
763 } else $o .= t('The correctness of the API Key could not be detected. Something strange\'s going on.') . '<br>';
766 $o .= '<label for="fb_appid">' . t('App-ID / API-Key') . '</label><input id="fb_appid" name="appid" type="text" value="' . escape_tags($appid ? $appid : "") . '"><br style="clear: both;">';
767 $o .= '<label for="fb_appsecret">' . t('Application secret') . '</label><input id="fb_appsecret" name="appsecret" type="text" value="' . escape_tags($appsecret ? $appsecret : "") . '"><br style="clear: both;">';
768 $o .= '<label for="fb_poll_interval">' . sprintf(t('Polling Interval in minutes (minimum %1$s minutes)'), FACEBOOK_MIN_POLL_INTERVAL) . '</label><input name="poll_interval" id="fb_poll_interval" type="number" min="' . FACEBOOK_MIN_POLL_INTERVAL . '" value="' . $poll_interval . '"><br style="clear: both;">';
769 $o .= '<label for="fb_sync_comments">' . t('Synchronize comments (no comments on Facebook are missed, at the cost of increased system load)') . '</label><input name="sync_comments" id="fb_sync_comments" type="checkbox" ' . ($sync_comments ? 'checked' : '') . '><br style="clear: both;">';
770 $o .= '<input type="submit" name="fb_save_keys" value="' . t('Save') . '">';
772 if ($working_connection) {
773 $o .= '<h4>' . t('Real-Time Updates') . '</h4>';
775 $activated = facebook_check_realtime_active();
777 $o .= t('Real-Time Updates are activated.') . '<br><br>';
778 $o .= '<input type="submit" name="real_time_deactivate" value="' . t('Deactivate Real-Time Updates') . '">';
780 $o .= t('Real-Time Updates not activated.') . '<br><input type="submit" name="real_time_activate" value="' . t('Activate Real-Time Updates') . '">';
789 function facebook_plugin_admin_post(&$a){
790 check_form_security_token_redirectOnErr('/admin/plugins/facebook', 'fbsave');
792 if (x($_REQUEST,'fb_save_keys')) {
793 set_config('facebook', 'appid', $_REQUEST['appid']);
794 set_config('facebook', 'appsecret', $_REQUEST['appsecret']);
795 $poll_interval = IntVal($_REQUEST['poll_interval']);
796 if ($poll_interval >= FACEBOOK_MIN_POLL_INTERVAL) set_config('facebook', 'poll_interval', $poll_interval);
797 set_config('facebook', 'sync_comments', (x($_REQUEST, 'sync_comments') ? 1 : 0));
798 del_config('facebook', 'app_access_token');
799 info(t('The new values have been saved.'));
801 if (x($_REQUEST,'real_time_activate')) {
802 facebook_subscription_add_users();
804 if (x($_REQUEST,'real_time_deactivate')) {
805 facebook_subscription_del_users();
814 function facebook_jot_nets(&$a,&$b) {
818 $fb_post = get_pconfig(local_user(),'facebook','post');
819 if(intval($fb_post) == 1) {
820 $fb_defpost = get_pconfig(local_user(),'facebook','post_by_default');
821 $selected = ((intval($fb_defpost) == 1) ? ' checked="checked" ' : '');
822 $b .= '<div class="profile-jot-net"><input type="checkbox" name="facebook_enable"' . $selected . ' value="1" /> '
823 . t('Post to Facebook') . '</div>';
833 function facebook_post_hook(&$a,&$b) {
836 if($b['deleted'] || ($b['created'] !== $b['edited']))
840 * Post to Facebook stream
843 require_once('include/group.php');
844 require_once('include/html2plain.php');
846 logger('Facebook post');
852 $allow_arr = array();
854 $toplevel = (($b['id'] == $b['parent']) ? true : false);
857 $linking = ((get_pconfig($b['uid'],'facebook','no_linking')) ? 0 : 1);
859 if((! $toplevel) && ($linking)) {
860 $r = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
861 intval($b['parent']),
864 if(count($r) && substr($r[0]['uri'],0,4) === 'fb::')
865 $reply = substr($r[0]['uri'],4);
866 elseif(count($r) && substr($r[0]['extid'],0,4) === 'fb::')
867 $reply = substr($r[0]['extid'],4);
871 $u = q("SELECT * FROM user where uid = %d limit 1",
877 // only accept comments from the item owner. Other contacts are unknown to FB.
879 if(! link_compare($b['author-link'], $a->get_baseurl() . '/profile/' . $u[0]['nickname']))
883 logger('facebook reply id=' . $reply);
886 if(strstr($b['postopts'],'facebook') || ($b['private']) || ($reply)) {
888 if($b['private'] && $reply === false) {
889 $allow_people = expand_acl($b['allow_cid']);
890 $allow_groups = expand_groups(expand_acl($b['allow_gid']));
891 $deny_people = expand_acl($b['deny_cid']);
892 $deny_groups = expand_groups(expand_acl($b['deny_gid']));
894 $recipients = array_unique(array_merge($allow_people,$allow_groups));
895 $deny = array_unique(array_merge($deny_people,$deny_groups));
897 $allow_str = dbesc(implode(', ',$recipients));
899 $r = q("SELECT `notify` FROM `contact` WHERE `id` IN ( $allow_str ) AND `network` = 'face'");
902 $allow_arr[] = $rr['notify'];
905 $deny_str = dbesc(implode(', ',$deny));
907 $r = q("SELECT `notify` FROM `contact` WHERE `id` IN ( $deny_str ) AND `network` = 'face'");
910 $deny_arr[] = $rr['notify'];
913 if(count($deny_arr) && (! count($allow_arr))) {
915 // One or more FB folks were denied access but nobody on FB was specifically allowed access.
916 // This might cause the post to be open to public on Facebook, but only to selected members
917 // on another network. Since this could potentially leak a post to somebody who was denied,
918 // we will skip posting it to Facebook with a slightly vague but relevant message that will
919 // hopefully lead somebody to this code comment for a better explanation of what went wrong.
921 notice( t('Post to Facebook cancelled because of multi-network access permission conflict.') . EOL);
926 // if it's a private message but no Facebook members are allowed or denied, skip Facebook post
928 if((! count($allow_arr)) && (! count($deny_arr)))
932 if($b['verb'] == ACTIVITY_LIKE)
936 $appid = get_config('facebook', 'appid' );
937 $secret = get_config('facebook', 'appsecret' );
939 if($appid && $secret) {
941 logger('facebook: have appid+secret');
943 $fb_token = get_pconfig($b['uid'],'facebook','access_token');
946 // post to facebook if it's a public post and we've ticked the 'post to Facebook' box,
947 // or it's a private message with facebook participants
948 // or it's a reply or likes action to an existing facebook post
950 if($fb_token && ($toplevel || $b['private'] || $reply)) {
951 logger('facebook: able to post');
952 require_once('library/facebook.php');
953 require_once('include/bbcode.php');
957 logger('Facebook post: original msg=' . $msg, LOGGER_DATA);
959 // make links readable before we strip the code
961 // unless it's a dislike - just send the text as a comment
963 // if($b['verb'] == ACTIVITY_DISLIKE)
964 // $msg = trim(strip_tags(bbcode($msg)));
967 /*$search_str = $a->get_baseurl() . '/search';
969 if(preg_match("/\[url=(.*?)\](.*?)\[\/url\]/is",$msg,$matches)) {
971 // don't use hashtags for message link
973 if(strpos($matches[2],$search_str) === false) {
975 if(substr($matches[2],0,5) != '[img]')
976 $linkname = $matches[2];
980 // strip tag links to avoid link clutter, this really should be
981 // configurable because we're losing information
983 $msg = preg_replace("/\#\[url=(.*?)\](.*?)\[\/url\]/is",'#$2',$msg);
985 // provide the link separately for normal links
986 $msg = preg_replace("/\[url=(.*?)\](.*?)\[\/url\]/is",'$2 $1',$msg);
988 if(preg_match("/\[img\](.*?)\[\/img\]/is",$msg,$matches))
989 $image = $matches[1];
991 $msg = preg_replace("/\[img\](.*?)\[\/img\]/is", t('Image: ') . '$1', $msg);
993 if((strpos($link,z_root()) !== false) && (! $image))
994 $image = $a->get_baseurl() . '/images/friendica-64.jpg';
996 $msg = trim(strip_tags(bbcode($msg)));*/
1000 // Looking for the first image
1002 if(preg_match("/\[img\=([0-9]*)x([0-9]*)\](.*?)\[\/img\]/is",$b['body'],$matches))
1003 $image = $matches[3];
1006 if(preg_match("/\[img\](.*?)\[\/img\]/is",$b['body'],$matches))
1007 $image = $matches[1];
1009 // Checking for a bookmark element
1011 if (strpos($body, "[bookmark") !== false) {
1012 // splitting the text in two parts:
1013 // before and after the bookmark
1014 $pos = strpos($body, "[bookmark");
1015 $body1 = substr($body, 0, $pos);
1016 $body2 = substr($body, $pos);
1018 // Removing the bookmark and all quotes after the bookmark
1019 // they are mostly only the content after the bookmark.
1020 $body2 = preg_replace("/\[bookmark\=([^\]]*)\](.*?)\[\/bookmark\]/ism",'',$body2);
1021 $body2 = preg_replace("/\[quote\=([^\]]*)\](.*?)\[\/quote\]/ism",'',$body2);
1022 $body2 = preg_replace("/\[quote\](.*?)\[\/quote\]/ism",'',$body2);
1024 $body = $body1.$body2;
1027 // At first convert the text to html
1028 $html = bbcode($body, false, false);
1030 // Then convert it to plain text
1031 $msg = trim($b['title']." \n\n".html2plain($html, 0, true));
1032 $msg = html_entity_decode($msg,ENT_QUOTES,'UTF-8');
1034 // Removing multiple newlines
1035 while (strpos($msg, "\n\n\n") !== false)
1036 $msg = str_replace("\n\n\n", "\n\n", $msg);
1038 // add any attachments as text urls
1039 $arr = explode(',',$b['attach']);
1043 foreach($arr as $r) {
1045 $cnt = preg_match('|\[attach\]href=\"(.*?)\" size=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"\[\/attach\]|',$r,$matches);
1047 $msg .= "\n".$matches[1];
1054 // look for bookmark-bbcode and handle it with priority
1055 if(preg_match("/\[bookmark\=([^\]]*)\](.*?)\[\/bookmark\]/is",$b['body'],$matches)) {
1056 $link = $matches[1];
1057 $linkname = $matches[2];
1060 // If there is no bookmark element then take the first link
1062 $links = collecturls($html);
1063 if (sizeof($links) > 0) {
1065 $link = current($links);
1069 // Remove trailing and leading spaces
1072 // Since facebook increased the maxpostlen massively this never should happen again :)
1073 if (strlen($msg) > FACEBOOK_MAXPOSTLEN) {
1074 require_once('library/slinky.php');
1076 $display_url = $b['plink'];
1078 $slinky = new Slinky( $display_url );
1079 // setup a cascade of shortening services
1080 // try to get a short link from these services
1081 // in the order ur1.ca, trim, id.gd, tinyurl
1082 $slinky->set_cascade( array( new Slinky_UR1ca(), new Slinky_Trim(), new Slinky_IsGd(), new Slinky_TinyURL() ) );
1083 $shortlink = $slinky->short();
1084 // the new message will be shortened such that "... $shortlink"
1085 // will fit into the character limit
1086 $msg = substr($msg, 0, FACEBOOK_MAXPOSTLEN - strlen($shortlink) - 4);
1087 $msg .= '... ' . $shortlink;
1090 // Fallback - if message is empty
1100 // If there is nothing to post then exit
1104 logger('Facebook post: msg=' . $msg, LOGGER_DATA);
1107 $postvars = array('access_token' => $fb_token);
1111 'access_token' => $fb_token,
1115 $postvars['picture'] = $image;
1116 //$postvars['type'] = "photo";
1119 $postvars['link'] = $link;
1120 //$postvars['type'] = "link";
1122 if(isset($linkname))
1123 $postvars['name'] = $linkname;
1126 if(($b['private']) && ($toplevel)) {
1127 $postvars['privacy'] = '{"value": "CUSTOM", "friends": "SOME_FRIENDS"';
1128 if(count($allow_arr))
1129 $postvars['privacy'] .= ',"allow": "' . implode(',',$allow_arr) . '"';
1130 if(count($deny_arr))
1131 $postvars['privacy'] .= ',"deny": "' . implode(',',$deny_arr) . '"';
1132 $postvars['privacy'] .= '}';
1137 $url = 'https://graph.facebook.com/' . $reply . '/' . (($likes) ? 'likes' : 'comments');
1138 } else if (($link != "") or ($image != "") or ($b['title'] == '') or (strlen($msg) < 500)) {
1139 $url = 'https://graph.facebook.com/me/feed';
1141 $postvars['actions'] = '{"name": "' . t('View on Friendica') . '", "link": "' . $b['plink'] . '"}';
1143 // if its only a message and a subject and the message is larger than 500 characters then post it as note
1145 'access_token' => $fb_token,
1146 'message' => bbcode($b['body'], false, false),
1147 'subject' => $b['title'],
1149 $url = 'https://graph.facebook.com/me/notes';
1152 logger('facebook: post to ' . $url);
1153 logger('facebook: postvars: ' . print_r($postvars,true));
1155 // "test_mode" prevents anything from actually being posted.
1156 // Otherwise, let's do it.
1158 if(! get_config('facebook','test_mode')) {
1159 $x = post_url($url, $postvars);
1160 logger('Facebook post returns: ' . $x, LOGGER_DEBUG);
1162 $retj = json_decode($x);
1164 q("UPDATE `item` SET `extid` = '%s' WHERE `id` = %d LIMIT 1",
1165 dbesc('fb::' . $retj->id),
1171 $s = serialize(array('url' => $url, 'item' => $b['id'], 'post' => $postvars));
1172 require_once('include/queue_fn.php');
1173 add_to_queue($a->contact,NETWORK_FACEBOOK,$s);
1174 notice( t('Facebook post failed. Queued for retry.') . EOL);
1177 if (isset($retj->error) && $retj->error->type == "OAuthException" && $retj->error->code == 190) {
1178 logger('Facebook session has expired due to changed password.', LOGGER_DEBUG);
1180 $last_notification = get_pconfig($b['uid'], 'facebook', 'session_expired_mailsent');
1181 if (!$last_notification || $last_notification < (time() - FACEBOOK_SESSION_ERR_NOTIFICATION_INTERVAL)) {
1182 require_once('include/enotify.php');
1184 $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1", intval($b['uid']) );
1187 'type' => NOTIFY_SYSTEM,
1188 'system_type' => 'facebook_connection_invalid',
1189 'language' => $r[0]['language'],
1190 'to_name' => $r[0]['username'],
1191 'to_email' => $r[0]['email'],
1192 'source_name' => t('Administrator'),
1193 'source_link' => $a->config["system"]["url"],
1194 'source_photo' => $a->config["system"]["url"] . '/images/person-80.jpg',
1197 set_pconfig($b['uid'], 'facebook', 'session_expired_mailsent', time());
1198 } else logger('Facebook: No notification, as the last one was sent on ' . $last_notification, LOGGER_DEBUG);
1209 * @param object $data
1211 function facebook_enotify(&$app, &$data) {
1212 if (x($data, 'params') && $data['params']['type'] == NOTIFY_SYSTEM && x($data['params'], 'system_type') && $data['params']['system_type'] == 'facebook_connection_invalid') {
1213 $data['itemlink'] = '/facebook';
1214 $data['epreamble'] = $data['preamble'] = t('Your Facebook connection became invalid. Please Re-authenticate.');
1215 $data['subject'] = t('Facebook connection became invalid');
1216 $data['body'] = sprintf( t("Hi %1\$s,\n\nThe connection between your accounts on %2\$s and Facebook became invalid. This usually happens after you change your Facebook-password. To enable the connection again, you have to %3\$sre-authenticate the Facebook-connector%4\$s."), $data['params']['to_name'], "[url=" . $app->config["system"]["url"] . "]" . $app->config["sitename"] . "[/url]", "[url=" . $app->config["system"]["url"] . "/facebook]", "[/url]");
1224 function facebook_post_local(&$a,&$b) {
1226 // Figure out if Facebook posting is enabled for this post and file it in 'postopts'
1227 // where we will discover it during background delivery.
1229 // This can only be triggered by a local user posting to their own wall.
1231 if((local_user()) && (local_user() == $b['uid'])) {
1233 $fb_post = intval(get_pconfig(local_user(),'facebook','post'));
1234 $fb_enable = (($fb_post && x($_REQUEST,'facebook_enable')) ? intval($_REQUEST['facebook_enable']) : 0);
1236 // if API is used, default to the chosen settings
1237 if($_REQUEST['api_source'] && intval(get_pconfig(local_user(),'facebook','post_by_default')))
1243 if(strlen($b['postopts']))
1244 $b['postopts'] .= ',';
1245 $b['postopts'] .= 'facebook';
1254 function fb_queue_hook(&$a,&$b) {
1256 $qi = q("SELECT * FROM `queue` WHERE `network` = '%s'",
1257 dbesc(NETWORK_FACEBOOK)
1262 require_once('include/queue_fn.php');
1264 foreach($qi as $x) {
1265 if($x['network'] !== NETWORK_FACEBOOK)
1268 logger('facebook_queue: run');
1270 $r = q("SELECT `user`.* FROM `user` LEFT JOIN `contact` on `contact`.`uid` = `user`.`uid`
1271 WHERE `contact`.`self` = 1 AND `contact`.`id` = %d LIMIT 1",
1279 $appid = get_config('facebook', 'appid' );
1280 $secret = get_config('facebook', 'appsecret' );
1282 if($appid && $secret) {
1283 $fb_post = intval(get_pconfig($user['uid'],'facebook','post'));
1284 $fb_token = get_pconfig($user['uid'],'facebook','access_token');
1286 if($fb_post && $fb_token) {
1287 logger('facebook_queue: able to post');
1288 require_once('library/facebook.php');
1290 $z = unserialize($x['content']);
1292 $j = post_url($z['url'],$z['post']);
1294 $retj = json_decode($j);
1296 q("UPDATE `item` SET `extid` = '%s' WHERE `id` = %d LIMIT 1",
1297 dbesc('fb::' . $retj->id),
1300 logger('facebook_queue: success: ' . $j);
1301 remove_queue_item($x['id']);
1304 logger('facebook_queue: failed: ' . $j);
1305 update_queue_time($x['id']);
1313 * @param string $access_token
1317 function fb_get_timeline($access_token, &$since) {
1319 $entries = new stdClass();
1320 $entries->data = array();
1323 $url = 'https://graph.facebook.com/me/home?access_token='.$access_token;
1326 $url .= "&since=".$since;
1329 $s = fetch_url($url);
1330 $j = json_decode($s);
1331 $oldestdate = time();
1332 if (isset($j->data))
1333 foreach ($j->data as $entry) {
1334 $created = strtotime($entry->created_time);
1336 if ($newest < $created)
1339 if ($created >= $since)
1340 $entries->data[] = $entry;
1342 if ($created <= $oldestdate)
1343 $oldestdate = $created;
1348 $url = (isset($j->paging) && isset($j->paging->next) ? $j->paging->next : '');
1350 } while (($oldestdate > $since) and ($since != 0) and ($url != ''));
1352 if ($newest > $since)
1361 function fb_consume_all($uid) {
1363 require_once('include/items.php');
1365 $access_token = get_pconfig($uid,'facebook','access_token');
1369 if(! get_pconfig($uid,'facebook','no_wall')) {
1370 $private_wall = intval(get_pconfig($uid,'facebook','private_wall'));
1371 $s = fetch_url('https://graph.facebook.com/me/feed?access_token=' . $access_token);
1373 $j = json_decode($s);
1374 if (isset($j->data)) {
1375 logger('fb_consume_stream: wall: ' . print_r($j,true), LOGGER_DATA);
1376 fb_consume_stream($uid,$j,($private_wall) ? false : true);
1378 logger('fb_consume_stream: wall: got no data from Facebook: ' . print_r($j,true), LOGGER_NORMAL);
1382 // Get the last date
1383 $lastdate = get_pconfig($uid,'facebook','lastdate');
1384 // fetch all items since the last date
1385 $j = fb_get_timeline($access_token, $lastdate);
1386 if (isset($j->data)) {
1387 logger('fb_consume_stream: feed: ' . print_r($j,true), LOGGER_DATA);
1388 fb_consume_stream($uid,$j,false);
1390 // Write back the last date
1391 set_pconfig($uid,'facebook','lastdate', $lastdate);
1393 logger('fb_consume_stream: feed: got no data from Facebook: ' . print_r($j,true), LOGGER_NORMAL);
1398 * @param string $link
1401 function fb_get_photo($uid,$link) {
1402 $access_token = get_pconfig($uid,'facebook','access_token');
1403 if(! $access_token || (! stristr($link,'facebook.com/photo.php')))
1405 //return "\n" . '[url=' . $link . ']' . t('link') . '[/url]';
1406 $ret = preg_match('/fbid=([0-9]*)/',$link,$match);
1408 $photo_id = $match[1];
1411 $x = fetch_url('https://graph.facebook.com/' . $photo_id . '?access_token=' . $access_token);
1412 $j = json_decode($x);
1414 return "\n\n" . '[url=' . $link . '][img]' . $j->picture . '[/img][/url]';
1416 // return "\n" . '[url=' . $link . ']' . t('link') . '[/url]';
1423 * @param array $user
1424 * @param array $self
1425 * @param string $fb_id
1427 * @param array $orig_post
1428 * @param object $cmnt
1430 function fb_consume_comment(&$a, &$user, &$self, $fb_id, $wall, &$orig_post, &$cmnt) {
1435 $top_item = $orig_post['id'];
1436 $uid = IntVal($user[0]['uid']);
1438 $r = q("SELECT * FROM `item` WHERE `uid` = %d AND ( `uri` = '%s' OR `extid` = '%s' ) LIMIT 1",
1440 dbesc('fb::' . $cmnt->id),
1441 dbesc('fb::' . $cmnt->id)
1446 $cmntdata = array();
1447 $cmntdata['parent'] = $top_item;
1448 $cmntdata['verb'] = ACTIVITY_POST;
1449 $cmntdata['gravity'] = 6;
1450 $cmntdata['uid'] = $uid;
1451 $cmntdata['wall'] = (($wall) ? 1 : 0);
1452 $cmntdata['uri'] = 'fb::' . $cmnt->id;
1453 $cmntdata['parent-uri'] = $orig_post['uri'];
1454 if($cmnt->from->id == $fb_id) {
1455 $cmntdata['contact-id'] = $self[0]['id'];
1458 $r = q("SELECT * FROM `contact` WHERE `notify` = '%s' AND `uid` = %d LIMIT 1",
1459 dbesc($cmnt->from->id),
1463 $cmntdata['contact-id'] = $r[0]['id'];
1464 if($r[0]['blocked'] || $r[0]['readonly'])
1468 if(! x($cmntdata,'contact-id'))
1469 $cmntdata['contact-id'] = $orig_post['contact-id'];
1471 $cmntdata['app'] = 'facebook';
1472 $cmntdata['created'] = datetime_convert('UTC','UTC',$cmnt->created_time);
1473 $cmntdata['edited'] = datetime_convert('UTC','UTC',$cmnt->created_time);
1474 $cmntdata['verb'] = ACTIVITY_POST;
1475 $cmntdata['author-name'] = $cmnt->from->name;
1476 $cmntdata['author-link'] = 'http://facebook.com/profile.php?id=' . $cmnt->from->id;
1477 $cmntdata['author-avatar'] = 'https://graph.facebook.com/' . $cmnt->from->id . '/picture';
1478 $cmntdata['body'] = $cmnt->message;
1479 $item = item_store($cmntdata);
1481 $myconv = q("SELECT `author-link`, `author-avatar`, `parent` FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `parent` != 0 AND `deleted` = 0",
1482 dbesc($orig_post['uri']),
1486 if(count($myconv)) {
1487 $importer_url = $a->get_baseurl() . '/profile/' . $user[0]['nickname'];
1489 foreach($myconv as $conv) {
1491 // now if we find a match, it means we're in this conversation
1493 if(! link_compare($conv['author-link'],$importer_url))
1496 require_once('include/enotify.php');
1498 $conv_parent = $conv['parent'];
1501 'type' => NOTIFY_COMMENT,
1502 'notify_flags' => $user[0]['notify-flags'],
1503 'language' => $user[0]['language'],
1504 'to_name' => $user[0]['username'],
1505 'to_email' => $user[0]['email'],
1506 'uid' => $user[0]['uid'],
1507 'item' => $cmntdata,
1508 'link' => $a->get_baseurl() . '/display/' . $user[0]['nickname'] . '/' . $item,
1509 'source_name' => $cmntdata['author-name'],
1510 'source_link' => $cmntdata['author-link'],
1511 'source_photo' => $cmntdata['author-avatar'],
1512 'verb' => ACTIVITY_POST,
1514 'parent' => $conv_parent,
1517 // only send one notification
1526 * @param array $user
1527 * @param array $self
1528 * @param string $fb_id
1530 * @param array $orig_post
1531 * @param object $likes
1533 function fb_consume_like(&$a, &$user, &$self, $fb_id, $wall, &$orig_post, &$likes) {
1535 $top_item = $orig_post['id'];
1536 $uid = IntVal($user[0]['uid']);
1541 // If we posted the like locally, it will be found with our url, not the FB url.
1543 $second_url = (($likes->id == $fb_id) ? $self[0]['url'] : 'http://facebook.com/profile.php?id=' . $likes->id);
1545 $r = q("SELECT * FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `verb` = '%s'
1546 AND ( `author-link` = '%s' OR `author-link` = '%s' ) LIMIT 1",
1547 dbesc($orig_post['uri']),
1549 dbesc(ACTIVITY_LIKE),
1550 dbesc('http://facebook.com/profile.php?id=' . $likes->id),
1557 $likedata = array();
1558 $likedata['parent'] = $top_item;
1559 $likedata['verb'] = ACTIVITY_LIKE;
1560 $likedata['gravity'] = 3;
1561 $likedata['uid'] = $uid;
1562 $likedata['wall'] = (($wall) ? 1 : 0);
1563 $likedata['uri'] = item_new_uri($a->get_baseurl(), $uid);
1564 $likedata['parent-uri'] = $orig_post['uri'];
1565 if($likes->id == $fb_id)
1566 $likedata['contact-id'] = $self[0]['id'];
1568 $r = q("SELECT * FROM `contact` WHERE `notify` = '%s' AND `uid` = %d AND `blocked` = 0 AND `readonly` = 0 LIMIT 1",
1573 $likedata['contact-id'] = $r[0]['id'];
1575 if(! x($likedata,'contact-id'))
1576 $likedata['contact-id'] = $orig_post['contact-id'];
1578 $likedata['app'] = 'facebook';
1579 $likedata['verb'] = ACTIVITY_LIKE;
1580 $likedata['author-name'] = $likes->name;
1581 $likedata['author-link'] = 'http://facebook.com/profile.php?id=' . $likes->id;
1582 $likedata['author-avatar'] = 'https://graph.facebook.com/' . $likes->id . '/picture';
1584 $author = '[url=' . $likedata['author-link'] . ']' . $likedata['author-name'] . '[/url]';
1585 $objauthor = '[url=' . $orig_post['author-link'] . ']' . $orig_post['author-name'] . '[/url]';
1586 $post_type = t('status');
1587 $plink = '[url=' . $orig_post['plink'] . ']' . $post_type . '[/url]';
1588 $likedata['object-type'] = ACTIVITY_OBJ_NOTE;
1590 $likedata['body'] = sprintf( t('%1$s likes %2$s\'s %3$s'), $author, $objauthor, $plink);
1591 $likedata['object'] = '<object><type>' . ACTIVITY_OBJ_NOTE . '</type><local>1</local>' .
1592 '<id>' . $orig_post['uri'] . '</id><link>' . xmlify('<link rel="alternate" type="text/html" href="' . xmlify($orig_post['plink']) . '" />') . '</link><title>' . $orig_post['title'] . '</title><content>' . $orig_post['body'] . '</content></object>';
1594 item_store($likedata);
1599 * @param array $user
1600 * @param object $entry
1601 * @param array $self
1602 * @param string $fb_id
1604 * @param array $orig_post
1606 function fb_consume_status(&$a, &$user, &$entry, &$self, $fb_id, $wall, &$orig_post) {
1607 $uid = IntVal($user[0]['uid']);
1608 $access_token = get_pconfig($uid, 'facebook', 'access_token');
1610 $s = fetch_url('https://graph.facebook.com/' . $entry->id . '?access_token=' . $access_token);
1612 $j = json_decode($s);
1613 if (isset($j->comments) && isset($j->comments->data))
1614 foreach ($j->comments->data as $cmnt)
1615 fb_consume_comment($a, $user, $self, $fb_id, $wall, $orig_post, $cmnt);
1617 if (isset($j->likes) && isset($j->likes->data) && isset($j->likes->count)) {
1618 if (count($j->likes->data) == $j->likes->count) {
1619 foreach ($j->likes->data as $likers) fb_consume_like($a, $user, $self, $fb_id, $wall, $orig_post, $likers);
1621 $t = fetch_url('https://graph.facebook.com/' . $entry->id . '/likes?access_token=' . $access_token);
1623 $k = json_decode($t);
1624 if (isset($k->data))
1625 foreach ($k->data as $likers)
1626 fb_consume_like($a, $user, $self, $fb_id, $wall, $orig_post, $likers);
1638 function fb_consume_stream($uid,$j,$wall = false) {
1642 $user = q("SELECT * FROM `user` WHERE `uid` = %d AND `account_expired` = 0 LIMIT 1",
1648 // $my_local_url = $a->get_baseurl() . '/profile/' . $user[0]['nickname'];
1650 $no_linking = get_pconfig($uid,'facebook','no_linking');
1654 $self = q("SELECT * FROM `contact` WHERE `self` = 1 AND `uid` = %d LIMIT 1",
1658 $blocked_apps = get_pconfig($uid,'facebook','blocked_apps');
1659 $blocked_apps_arr = explode(',',$blocked_apps);
1661 $sync_comments = get_config('facebook', 'sync_comments');
1663 /** @var string $self_id */
1664 $self_id = get_pconfig($uid,'facebook','self_id');
1665 if(! count($j->data) || (! strlen($self_id)))
1670 foreach($j->data as $entry) {
1671 logger('fb_consume: entry: ' . print_r($entry,true), LOGGER_DATA);
1672 $datarray = array();
1674 $r = q("SELECT * FROM `item` WHERE ( `uri` = '%s' OR `extid` = '%s') AND `uid` = %d LIMIT 1",
1675 dbesc('fb::' . $entry->id),
1676 dbesc('fb::' . $entry->id),
1681 $top_item = $r[0]['id'];
1688 $datarray['gravity'] = 0;
1689 $datarray['uid'] = $uid;
1690 $datarray['wall'] = (($wall) ? 1 : 0);
1691 $datarray['uri'] = $datarray['parent-uri'] = 'fb::' . $entry->id;
1692 $from = $entry->from;
1693 if($from->id == $self_id)
1694 $datarray['contact-id'] = $self[0]['id'];
1696 // Looking if user is known - if not he is added
1697 $access_token = get_pconfig($uid, 'facebook', 'access_token');
1698 fb_get_friends_sync_new($uid, $access_token, array($from));
1700 $r = q("SELECT * FROM `contact` WHERE `notify` = '%s' AND `uid` = %d AND `blocked` = 0 AND `readonly` = 0 LIMIT 1",
1705 $datarray['contact-id'] = $r[0]['id'];
1708 // don't store post if we don't have a contact
1709 if(! x($datarray,'contact-id')) {
1710 logger('facebook: no contact '.$from->name.' '.$from->id.'. post ignored');
1714 $datarray['verb'] = ACTIVITY_POST;
1716 $datarray['owner-name'] = $self[0]['name'];
1717 $datarray['owner-link'] = $self[0]['url'];
1718 $datarray['owner-avatar'] = $self[0]['thumb'];
1720 if(isset($entry->application) && isset($entry->application->name) && strlen($entry->application->name))
1721 $datarray['app'] = strip_tags($entry->application->name);
1723 $datarray['app'] = 'facebook';
1725 $found_blocked = false;
1727 if(count($blocked_apps_arr)) {
1728 foreach($blocked_apps_arr as $bad_appl) {
1729 if(strlen(trim($bad_appl)) && (stristr($datarray['app'],trim($bad_appl)))) {
1730 $found_blocked = true;
1735 if($found_blocked) {
1736 logger('facebook: blocking application: ' . $datarray['app']);
1740 $datarray['author-name'] = $from->name;
1741 $datarray['author-link'] = 'http://facebook.com/profile.php?id=' . $from->id;
1742 $datarray['author-avatar'] = 'https://graph.facebook.com/' . $from->id . '/picture';
1743 $datarray['plink'] = $datarray['author-link'] . '&v=wall&story_fbid=' . substr($entry->id,strpos($entry->id,'_') + 1);
1745 logger('facebook: post '.$entry->id.' from '.$from->name);
1747 $datarray['body'] = (isset($entry->message) ? escape_tags($entry->message) : '');
1749 if(isset($entry->name) and isset($entry->link))
1750 $datarray['body'] .= "\n\n[bookmark=".$entry->link."]".$entry->name."[/bookmark]";
1751 elseif (isset($entry->name))
1752 $datarray['body'] .= "\n\n[b]" . $entry->name."[/b]";
1754 if(isset($entry->caption)) {
1755 if(!isset($entry->name) and isset($entry->link))
1756 $datarray['body'] .= "\n\n[bookmark=".$entry->link."]".$entry->caption."[/bookmark]";
1758 $datarray['body'] .= "[i]" . $entry->caption."[/i]\n";
1761 if(!isset($entry->caption) and !isset($entry->name)) {
1762 if (isset($entry->link))
1763 $datarray['body'] .= "\n[url]".$entry->link."[/url]\n";
1765 $datarray['body'] .= "\n";
1769 if(isset($entry->description))
1770 $quote = $entry->description;
1772 if (isset($entry->properties))
1773 foreach ($entry->properties as $property)
1774 $quote .= "\n".$property->name.": [url=".$property->href."]".$property->text."[/url]";
1777 $datarray['body'] .= "\n[quote]".$quote."[/quote]";
1779 // Only import the picture when the message is no video
1780 // oembed display a picture of the video as well
1781 if ($entry->type != "video") {
1782 if(isset($entry->picture) && isset($entry->link)) {
1783 $datarray['body'] .= "\n" . '[url=' . $entry->link . '][img]'.$entry->picture.'[/img][/url]';
1786 if(isset($entry->picture))
1787 $datarray['body'] .= "\n" . '[img]' . $entry->picture . '[/img]';
1788 // if just a link, it may be a wall photo - check
1789 if(isset($entry->link))
1790 $datarray['body'] .= fb_get_photo($uid,$entry->link);
1794 if (($datarray['app'] == "Events") and isset($entry->actions))
1795 foreach ($entry->actions as $action)
1796 if ($action->name == "View")
1797 $datarray['body'] .= " [url=".$action->link."]".$entry->story."[/url]";
1799 // Just as a test - to see if these are the missing entries
1800 //if(trim($datarray['body']) == '')
1801 // $datarray['body'] = $entry->story;
1803 // Adding the "story" text to see if there are useful data in it (testing)
1804 //if (($datarray['app'] != "Events") and $entry->story)
1805 // $datarray['body'] .= "\n".$entry->story;
1807 if(trim($datarray['body']) == '') {
1808 logger('facebook: empty body '.$entry->id.' '.print_r($entry, true));
1812 $datarray['body'] .= "\n";
1814 if (isset($entry->icon))
1815 $datarray['body'] .= "[img]".$entry->icon."[/img] ";
1817 if (isset($entry->actions))
1818 foreach ($entry->actions as $action)
1819 if (($action->name != "Comment") and ($action->name != "Like"))
1820 $datarray['body'] .= "[url=".$action->link."]".$action->name."[/url] ";
1822 $datarray['body'] = trim($datarray['body']);
1824 //if(($datarray['body'] != '') and ($uid == 1))
1825 // $datarray['body'] .= "[noparse]".print_r($entry, true)."[/noparse]";
1827 if (isset($entry->place)) {
1828 if ($entry->place->name or $entry->place->location->street or
1829 $entry->place->location->city or $entry->place->location->Denmark) {
1830 $datarray['coord'] = '';
1831 if ($entry->place->name)
1832 $datarray['coord'] .= $entry->place->name;
1833 if ($entry->place->location->street)
1834 $datarray['coord'] .= $entry->place->location->street;
1835 if ($entry->place->location->city)
1836 $datarray['coord'] .= " ".$entry->place->location->city;
1837 if ($entry->place->location->country)
1838 $datarray['coord'] .= " ".$entry->place->location->country;
1839 } else if ($entry->place->location->latitude and $entry->place->location->longitude)
1840 $datarray['coord'] = substr($entry->place->location->latitude, 0, 8)
1841 .' '.substr($entry->place->location->longitude, 0, 8);
1843 $datarray['created'] = datetime_convert('UTC','UTC',$entry->created_time);
1844 $datarray['edited'] = datetime_convert('UTC','UTC',$entry->updated_time);
1846 // If the entry has a privacy policy, we cannot assume who can or cannot see it,
1847 // as the identities are from a foreign system. Mark it as private to the owner.
1849 if(isset($entry->privacy) && $entry->privacy->value !== 'EVERYONE') {
1850 $datarray['private'] = 1;
1851 $datarray['allow_cid'] = '<' . $self[0]['id'] . '>';
1854 $top_item = item_store($datarray);
1855 $r = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
1861 logger('fb: new top level item posted');
1865 /** @var array $orig_post */
1867 $likers_num = (isset($entry->likes) && isset($entry->likes->count) ? IntVal($entry->likes->count) : 0 );
1868 if(isset($entry->likes) && isset($entry->likes->data))
1869 $likers = $entry->likes->data;
1873 $comments_num = (isset($entry->comments) && isset($entry->comments->count) ? IntVal($entry->comments->count) : 0 );
1874 if(isset($entry->comments) && isset($entry->comments->data))
1875 $comments = $entry->comments->data;
1879 $needs_sync = false;
1881 if(is_array($likers)) {
1882 foreach($likers as $likes) fb_consume_like($a, $user, $self, $self_id, $wall, $orig_post, $likes);
1883 if ($sync_comments) {
1884 $r = q("SELECT COUNT(*) likes FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `verb` = '%s' AND `parent-uri` != `uri`",
1885 dbesc($orig_post['uri']),
1887 dbesc(ACTIVITY_LIKE)
1889 if ($r[0]['likes'] < $likers_num) {
1890 logger('fb_consume_stream: missing likes found for ' . $orig_post['uri'] . ' (we have ' . $r[0]['likes'] . ' of ' . $likers_num . '). Synchronizing...', LOGGER_DEBUG);
1896 if(is_array($comments)) {
1897 foreach($comments as $cmnt) fb_consume_comment($a, $user, $self, $self_id, $wall, $orig_post, $cmnt);
1898 if ($sync_comments) {
1899 $r = q("SELECT COUNT(*) comments FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `verb` = '%s' AND `parent-uri` != `uri`",
1900 dbesc($orig_post['uri']),
1904 if ($r[0]['comments'] < $comments_num) {
1905 logger('fb_consume_stream: missing comments found for ' . $orig_post['uri'] . ' (we have ' . $r[0]['comments'] . ' of ' . $comments_num . '). Synchronizing...', LOGGER_DEBUG);
1911 if ($needs_sync) fb_consume_status($a, $user, $entry, $self, $self_id, $wall, $orig_post);
1917 * @return bool|string
1919 function fb_get_app_access_token() {
1921 $acc_token = get_config('facebook','app_access_token');
1923 if ($acc_token !== false) return $acc_token;
1925 $appid = get_config('facebook','appid');
1926 $appsecret = get_config('facebook', 'appsecret');
1928 if ($appid === false || $appsecret === false) {
1929 logger('fb_get_app_access_token: appid and/or appsecret not set', LOGGER_DEBUG);
1932 logger('https://graph.facebook.com/oauth/access_token?client_id=' . $appid . '&client_secret=' . $appsecret . '&grant_type=client_credentials', LOGGER_DATA);
1933 $x = fetch_url('https://graph.facebook.com/oauth/access_token?client_id=' . $appid . '&client_secret=' . $appsecret . '&grant_type=client_credentials');
1935 if(strpos($x,'access_token=') !== false) {
1936 logger('fb_get_app_access_token: returned access token: ' . $x, LOGGER_DATA);
1938 $token = str_replace('access_token=', '', $x);
1939 if(strpos($token,'&') !== false)
1940 $token = substr($token,0,strpos($token,'&'));
1943 logger('fb_get_app_access_token: empty token: ' . $x, LOGGER_DEBUG);
1946 set_config('facebook','app_access_token',$token);
1949 logger('fb_get_app_access_token: response did not contain an access_token: ' . $x, LOGGER_DATA);
1954 function facebook_subscription_del_users() {
1956 $access_token = fb_get_app_access_token();
1958 $url = "https://graph.facebook.com/" . get_config('facebook', 'appid' ) . "/subscriptions?access_token=" . $access_token;
1959 facebook_delete_url($url);
1961 if (!facebook_check_realtime_active()) del_config('facebook', 'realtime_active');
1965 * @param bool $second_try
1967 function facebook_subscription_add_users($second_try = false) {
1969 $access_token = fb_get_app_access_token();
1971 $url = "https://graph.facebook.com/" . get_config('facebook', 'appid' ) . "/subscriptions?access_token=" . $access_token;
1973 list($usec, $sec) = explode(" ", microtime());
1974 $verify_token = sha1($usec . $sec . rand(0, 999999999));
1975 set_config('facebook', 'cb_verify_token', $verify_token);
1977 $cb = $a->get_baseurl() . '/facebook/?realtime_cb=1';
1979 $j = post_url($url,array(
1981 "fields" => "feed,friends",
1982 "callback_url" => $cb,
1983 "verify_token" => $verify_token,
1985 del_config('facebook', 'cb_verify_token');
1988 $x = json_decode($j);
1989 logger("Facebook reponse: " . $j, LOGGER_DATA);
1990 if (isset($x->error)) {
1991 logger('facebook_subscription_add_users: got an error: ' . $j);
1992 if ($x->error->type == "OAuthException" && $x->error->code == 190) {
1993 del_config('facebook', 'app_access_token');
1994 if ($second_try === false) facebook_subscription_add_users(true);
1997 logger('facebook_subscription_add_users: sucessful');
1998 if (facebook_check_realtime_active()) set_config('facebook', 'realtime_active', 1);
2004 * @return null|array
2006 function facebook_subscriptions_get() {
2008 $access_token = fb_get_app_access_token();
2009 if (!$access_token) return null;
2011 $url = "https://graph.facebook.com/" . get_config('facebook', 'appid' ) . "/subscriptions?access_token=" . $access_token;
2012 $j = fetch_url($url);
2015 $x = json_decode($j);
2016 if (isset($x->data)) $ret = $x->data;
2025 function facebook_check_realtime_active() {
2026 $ret = facebook_subscriptions_get();
2027 if (is_null($ret)) return false;
2028 if (is_array($ret)) foreach ($ret as $re) if (is_object($re) && $re->object == "user") return true;
2035 // DELETE-request to $url
2037 if(! function_exists('facebook_delete_url')) {
2039 * @param string $url
2040 * @param null|array $headers
2041 * @param int $redirects
2042 * @param int $timeout
2043 * @return bool|string
2045 function facebook_delete_url($url,$headers = null, &$redirects = 0, $timeout = 0) {
2047 $ch = curl_init($url);
2048 if(($redirects > 8) || (! $ch))
2051 curl_setopt($ch, CURLOPT_HEADER, true);
2052 curl_setopt($ch, CURLOPT_RETURNTRANSFER,true);
2053 curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");
2054 curl_setopt($ch, CURLOPT_USERAGENT, "Friendica");
2056 if(intval($timeout)) {
2057 curl_setopt($ch, CURLOPT_TIMEOUT, $timeout);
2060 $curl_time = intval(get_config('system','curl_timeout'));
2061 curl_setopt($ch, CURLOPT_TIMEOUT, (($curl_time !== false) ? $curl_time : 60));
2064 if(defined('LIGHTTPD')) {
2065 if(!is_array($headers)) {
2066 $headers = array('Expect:');
2068 if(!in_array('Expect:', $headers)) {
2069 array_push($headers, 'Expect:');
2074 curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
2076 $check_cert = get_config('system','verifyssl');
2077 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, (($check_cert) ? true : false));
2078 $prx = get_config('system','proxy');
2080 curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, 1);
2081 curl_setopt($ch, CURLOPT_PROXY, $prx);
2082 $prxusr = get_config('system','proxyuser');
2084 curl_setopt($ch, CURLOPT_PROXYUSERPWD, $prxusr);
2087 $a->set_curl_code(0);
2089 // don't let curl abort the entire application
2090 // if it throws any errors.
2092 $s = @curl_exec($ch);
2095 $curl_info = curl_getinfo($ch);
2096 $http_code = $curl_info['http_code'];
2100 // Pull out multiple headers, e.g. proxy and continuation headers
2101 // allow for HTTP/2.x without fixing code
2103 while(preg_match('/^HTTP\/[1-2].+? [1-5][0-9][0-9]/',$base)) {
2104 $chunk = substr($base,0,strpos($base,"\r\n\r\n")+4);
2106 $base = substr($base,strlen($chunk));
2109 if($http_code == 301 || $http_code == 302 || $http_code == 303) {
2111 preg_match('/(Location:|URI:)(.*?)\n/', $header, $matches);
2112 $url = trim(array_pop($matches));
2113 $url_parsed = @parse_url($url);
2114 if (isset($url_parsed)) {
2116 return facebook_delete_url($url,$headers,$redirects,$timeout);
2119 $a->set_curl_code($http_code);
2120 $body = substr($s,strlen($header));
2122 $a->set_curl_headers($header);