3 * Name: Facebook Connector
5 * Author: Mike Macgirvin <http://macgirvin.com/profile/mike>
9 * Installing the Friendika/Facebook connector
11 * 1. register an API key for your site from developer.facebook.com
12 * a. We'd be very happy if you include "Friendika" in the application name
13 * to increase name recognition. The Friendika icons are also present
14 * in the images directory and may be uploaded as a Facebook app icon.
15 * Use images/friendika-16.jpg for the Icon and images/friendika-128.jpg for the Logo.
16 * b. The url should be your site URL with a trailing slash.
17 * You may use http://portal.friendika.com/privacy as the privacy policy
18 * URL unless your site has different requirements, and
19 * http://portal.friendika.com as the Terms of Service URL unless
20 * you have different requirements. (Friendika is a software application
21 * and does not require Terms of Service, though your installation of it might).
22 * c. Set the following values in your .htconfig.php file
23 * $a->config['facebook']['appid'] = 'xxxxxxxxxxx';
24 * $a->config['facebook']['appsecret'] = 'xxxxxxxxxxxxxxx';
25 * Replace with the settings Facebook gives you.
26 * d. Navigate to Set Web->Site URL & Domain -> Website Settings. Set
27 * Site URL to yoursubdomain.yourdomain.com. Set Site Domain to your
29 * 2. Enable the facebook plugin by including it in .htconfig.php - e.g.
30 * $a->config['system']['addon'] = 'plugin1,plugin2,facebook';
31 * 3. Visit the Facebook Settings section of the "Settings->Plugin Settings" page.
32 * and click 'Install Facebook Connector'.
33 * 4. This will ask you to login to Facebook and grant permission to the
34 * plugin to do its stuff. Allow it to do so.
35 * 5. You're done. To turn it off visit the Plugin Settings page again and
36 * 'Remove Facebook posting'.
38 * Vidoes and embeds will not be posted if there is no other content. Links
39 * and images will be converted to a format suitable for the Facebook API and
40 * long posts truncated - with a link to view the full post.
42 * Facebook contacts will not be able to view private photos, as they are not able to
43 * authenticate to your site to establish identity. We will address this
44 * in a future release.
47 define('FACEBOOK_MAXPOSTLEN', 420);
50 function facebook_install() {
51 register_hook('post_local', 'addon/facebook/facebook.php', 'facebook_post_local');
52 register_hook('notifier_normal', 'addon/facebook/facebook.php', 'facebook_post_hook');
53 register_hook('jot_networks', 'addon/facebook/facebook.php', 'facebook_jot_nets');
54 register_hook('connector_settings', 'addon/facebook/facebook.php', 'facebook_plugin_settings');
55 register_hook('cron', 'addon/facebook/facebook.php', 'facebook_cron');
56 register_hook('queue_predeliver', 'addon/facebook/facebook.php', 'fb_queue_hook');
60 function facebook_uninstall() {
61 unregister_hook('post_local', 'addon/facebook/facebook.php', 'facebook_post_local');
62 unregister_hook('notifier_normal', 'addon/facebook/facebook.php', 'facebook_post_hook');
63 unregister_hook('jot_networks', 'addon/facebook/facebook.php', 'facebook_jot_nets');
64 unregister_hook('connector_settings', 'addon/facebook/facebook.php', 'facebook_plugin_settings');
65 unregister_hook('cron', 'addon/facebook/facebook.php', 'facebook_cron');
66 unregister_hook('queue_predeliver', 'addon/facebook/facebook.php', 'fb_queue_hook');
69 unregister_hook('post_local_end', 'addon/facebook/facebook.php', 'facebook_post_hook');
70 unregister_hook('plugin_settings', 'addon/facebook/facebook.php', 'facebook_plugin_settings');
74 /* declare the facebook_module function so that /facebook url requests will land here */
76 function facebook_module() {}
80 /* If a->argv[1] is a nickname, this is a callback from Facebook oauth requests. */
82 function facebook_init(&$a) {
88 $r = q("SELECT `uid` FROM `user` WHERE `nickname` = '%s' LIMIT 1",
95 $auth_code = (($_GET['code']) ? $_GET['code'] : '');
96 $error = (($_GET['error_description']) ? $_GET['error_description'] : '');
100 logger('facebook_init: Error: ' . $error);
102 if($auth_code && $uid) {
104 $appid = get_config('facebook','appid');
105 $appsecret = get_config('facebook', 'appsecret');
107 $x = fetch_url('https://graph.facebook.com/oauth/access_token?client_id='
108 . $appid . '&client_secret=' . $appsecret . '&redirect_uri='
109 . urlencode($a->get_baseurl() . '/facebook/' . $nick)
110 . '&code=' . $auth_code);
112 logger('facebook_init: returned access token: ' . $x, LOGGER_DATA);
114 if(strpos($x,'access_token=') !== false) {
115 $token = str_replace('access_token=', '', $x);
116 if(strpos($token,'&') !== false)
117 $token = substr($token,0,strpos($token,'&'));
118 set_pconfig($uid,'facebook','access_token',$token);
119 set_pconfig($uid,'facebook','post','1');
120 if(get_pconfig($uid,'facebook','no_linking') === false)
121 set_pconfig($uid,'facebook','no_linking',1);
123 fb_get_friends($uid);
124 fb_consume_all($uid);
133 function fb_get_self($uid) {
134 $access_token = get_pconfig($uid,'facebook','access_token');
137 $s = fetch_url('https://graph.facebook.com/me/?access_token=' . $access_token);
139 $j = json_decode($s);
140 set_pconfig($uid,'facebook','self_id',(string) $j->id);
146 function fb_get_friends($uid) {
148 $r = q("SELECT `id` FROM `user` WHERE `uid` = %d AND `account_expired` = 0 LIMIT 1",
154 $access_token = get_pconfig($uid,'facebook','access_token');
156 $no_linking = get_pconfig($uid,'facebook','no_linking');
162 $s = fetch_url('https://graph.facebook.com/me/friends?access_token=' . $access_token);
164 logger('facebook: fb_get_friends: ' . $s, LOGGER_DATA);
165 $j = json_decode($s);
166 logger('facebook: fb_get_friends: json: ' . print_r($j,true), LOGGER_DATA);
169 foreach($j->data as $person) {
170 $s = fetch_url('https://graph.facebook.com/' . $person->id . '?access_token=' . $access_token);
172 $jp = json_decode($s);
173 logger('fb_get_friends: info: ' . print_r($jp,true), LOGGER_DATA);
175 // always use numeric link for consistency
177 $jp->link = 'http://facebook.com/profile.php?id=' . $person->id;
179 // check if we already have a contact
181 $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `url` = '%s' LIMIT 1",
188 // check that we have all the photos, this has been known to fail on occasion
190 if((! $r[0]['photo']) || (! $r[0]['thumb']) || (! $r[0]['micro'])) {
191 require_once("Photo.php");
193 $photos = import_profile_photo('https://graph.facebook.com/' . $jp->id . '/picture', $uid, $r[0]['id']);
195 $r = q("UPDATE `contact` SET `photo` = '%s',
201 WHERE `id` = %d LIMIT 1
206 dbesc(datetime_convert()),
207 dbesc(datetime_convert()),
208 dbesc(datetime_convert()),
216 // create contact record
217 $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `addr`, `alias`, `notify`, `poll`,
218 `name`, `nick`, `photo`, `network`, `rel`, `priority`,
219 `writable`, `blocked`, `readonly`, `pending` )
220 VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, %d, %d, 0, 0, 0 ) ",
222 dbesc(datetime_convert()),
227 dbesc('facebook ' . $jp->id),
229 dbesc(($jp->nickname) ? $jp->nickname : strtolower($jp->first_name)),
230 dbesc('https://graph.facebook.com/' . $jp->id . '/picture'),
231 dbesc(NETWORK_FACEBOOK),
232 intval(CONTACT_IS_FRIEND),
238 $r = q("SELECT * FROM `contact` WHERE `url` = '%s' AND `uid` = %d LIMIT 1",
248 $contact_id = $r[0]['id'];
250 require_once("Photo.php");
252 $photos = import_profile_photo($r[0]['photo'],$uid,$contact_id);
254 $r = q("UPDATE `contact` SET `photo` = '%s',
260 WHERE `id` = %d LIMIT 1
265 dbesc(datetime_convert()),
266 dbesc(datetime_convert()),
267 dbesc(datetime_convert()),
276 // This is the POST method to the facebook settings page
277 // Content is posted to Facebook in the function facebook_post_hook()
279 function facebook_post(&$a) {
284 $value = ((x($_POST,'post_by_default')) ? intval($_POST['post_by_default']) : 0);
285 set_pconfig($uid,'facebook','post_by_default', $value);
287 $no_linking = get_pconfig($uid,'facebook','no_linking');
289 $no_wall = ((x($_POST,'facebook_no_wall')) ? intval($_POST['facebook_no_wall']) : 0);
290 set_pconfig($uid,'facebook','no_wall',$no_wall);
292 $private_wall = ((x($_POST,'facebook_private_wall')) ? intval($_POST['facebook_private_wall']) : 0);
293 set_pconfig($uid,'facebook','private_wall',$private_wall);
296 $linkvalue = ((x($_POST,'facebook_linking')) ? intval($_POST['facebook_linking']) : 0);
297 set_pconfig($uid,'facebook','no_linking', (($linkvalue) ? 0 : 1));
299 // FB linkage was allowed but has just been turned off - remove all FB contacts and posts
301 if((! intval($no_linking)) && (! intval($linkvalue))) {
302 $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `network` = '%s' ",
304 dbesc(NETWORK_FACEBOOK)
307 require_once('include/Contact.php');
309 contact_remove($rr['id']);
312 elseif(intval($no_linking) && intval($linkvalue)) {
313 // FB linkage is now allowed - import stuff.
315 fb_get_friends($uid);
316 fb_consume_all($uid);
319 info( t('Settings updated.') . EOL);
325 // Facebook settings form
327 function facebook_content(&$a) {
330 notice( t('Permission denied.') . EOL);
334 if($a->argc > 1 && $a->argv[1] === 'remove') {
335 del_pconfig(local_user(),'facebook','post');
336 info( t('Facebook disabled') . EOL);
339 if($a->argc > 1 && $a->argv[1] === 'friends') {
340 fb_get_friends(local_user());
341 info( t('Updating contacts') . EOL);
345 $fb_installed = get_pconfig(local_user(),'facebook','post');
347 $appid = get_config('facebook','appid');
350 notice( t('Facebook API key is missing.') . EOL);
354 $a->page['htmlhead'] .= '<link rel="stylesheet" type="text/css" href="'
355 . $a->get_baseurl() . '/addon/facebook/facebook.css' . '" media="all" />' . "\r\n";
357 $o .= '<h3>' . t('Facebook Connect') . '</h3>';
359 if(! $fb_installed) {
360 $o .= '<div id="facebook-enable-wrapper">';
362 $o .= '<a href="https://www.facebook.com/dialog/oauth?client_id=' . $appid . '&redirect_uri='
363 . $a->get_baseurl() . '/facebook/' . $a->user['nickname'] . '&scope=publish_stream,read_stream,offline_access">' . t('Install Facebook connector for this account.') . '</a>';
368 $o .= '<div id="facebook-disable-wrapper">';
370 $o .= '<a href="' . $a->get_baseurl() . '/facebook/remove' . '">' . t('Remove Facebook connector') . '</a></div>';
372 $o .= '<div id="facebook-enable-wrapper">';
374 $o .= '<a href="https://www.facebook.com/dialog/oauth?client_id=' . $appid . '&redirect_uri='
375 . $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>';
378 $o .= '<div id="facebook-post-default-form">';
379 $o .= '<form action="facebook" method="post" >';
380 $post_by_default = get_pconfig(local_user(),'facebook','post_by_default');
381 $checked = (($post_by_default) ? ' checked="checked" ' : '');
382 $o .= '<input type="checkbox" name="post_by_default" value="1"' . $checked . '/>' . ' ' . t('Post to Facebook by default') . EOL;
384 $no_linking = get_pconfig(local_user(),'facebook','no_linking');
385 $checked = (($no_linking) ? '' : ' checked="checked" ');
386 $o .= '<input type="checkbox" name="facebook_linking" value="1"' . $checked . '/>' . ' ' . t('Link all your Facebook friends and conversations on this website') . EOL ;
388 $o .= '<p>' . t('Facebook conversations consist of your <em>profile wall</em> and your friend <em>stream</em>.');
389 $o .= ' ' . t('On this website, your Facebook friend stream is only visible to you.');
390 $o .= ' ' . t('The following settings determine the privacy of your Facebook profile wall on this website.') . '</p>';
392 $private_wall = get_pconfig(local_user(),'facebook','private_wall');
393 $checked = (($private_wall) ? ' checked="checked" ' : '');
394 $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 ;
397 $no_wall = get_pconfig(local_user(),'facebook','no_wall');
398 $checked = (($no_wall) ? ' checked="checked" ' : '');
399 $o .= '<input type="checkbox" name="facebook_no_wall" value="1"' . $checked . '/>' . ' ' . t('Do not import your Facebook profile wall conversations') . EOL ;
401 $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>';
403 $o .= '<input type="submit" name="submit" value="' . t('Submit') . '" /></form></div>';
411 function facebook_cron($a,$b) {
413 $last = get_config('facebook','last_poll');
415 $poll_interval = intval(get_config('facebook','poll_interval'));
417 $poll_interval = 3600;
420 $next = $last + $poll_interval;
425 logger('facebook_cron');
428 // Find the FB users on this site and randomize in case one of them
429 // uses an obscene amount of memory. It may kill this queue run
430 // but hopefully we'll get a few others through on each run.
432 $r = q("SELECT * FROM `pconfig` WHERE `cat` = 'facebook' AND `k` = 'post' AND `v` = '1' ORDER BY RAND() ");
435 if(get_pconfig($rr['uid'],'facebook','no_linking'))
437 $ab = intval(get_config('system','account_abandon_days'));
439 $z = q("SELECT `uid` FROM `user` WHERE `uid` = %d AND `login_date` > UTC_TIMESTAMP() - INTERVAL %d DAY LIMIT 1",
447 // check for new friends once a day
448 $last_friend_check = get_pconfig($rr['uid'],'facebook','friend_check');
449 if($last_friend_check)
450 $next_friend_check = $last_friend_check + 86400;
451 if($next_friend_check <= time()) {
452 fb_get_friends($rr['uid']);
453 set_pconfig($rr['uid'],'facebook','friend_check',time());
455 fb_consume_all($rr['uid']);
459 set_config('facebook','last_poll', time());
465 function facebook_plugin_settings(&$a,&$b) {
467 $b .= '<div class="settings-block">';
468 $b .= '<h3>' . t('Facebook') . '</h3>';
469 $b .= '<a href="facebook">' . t('Facebook Connector Settings') . '</a><br />';
474 function facebook_jot_nets(&$a,&$b) {
478 $fb_post = get_pconfig(local_user(),'facebook','post');
479 if(intval($fb_post) == 1) {
480 $fb_defpost = get_pconfig(local_user(),'facebook','post_by_default');
481 $selected = ((intval($fb_defpost) == 1) ? ' checked="checked" ' : '');
482 $b .= '<div class="profile-jot-net"><input type="checkbox" name="facebook_enable"' . $selected . ' value="1" /> '
483 . t('Post to Facebook') . '</div>';
488 function facebook_post_hook(&$a,&$b) {
491 if($b['deleted'] || ($b['created'] !== $b['edited']))
495 * Post to Facebook stream
498 require_once('include/group.php');
500 logger('Facebook post');
505 $toplevel = (($b['id'] == $b['parent']) ? true : false);
507 if(strstr($b['postopts'],'facebook')) {
509 $linking = ((get_pconfig($b['uid'],'facebook','no_linking')) ? 0 : 1);
511 if((! $toplevel) && ($linking)) {
512 $r = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
513 intval($b['parent']),
516 if(count($r) && substr($r[0]['uri'],0,4) === 'fb::')
517 $reply = substr($r[0]['uri'],4);
518 elseif(count($r) && substr($r[0]['extid'],0,4) === 'fb::')
519 $reply = substr($r[0]['extid'],4);
522 logger('facebook reply id=' . $reply);
525 if($b['private'] && $reply === false) {
526 $allow_people = expand_acl($b['allow_cid']);
527 $allow_groups = expand_groups(expand_acl($b['allow_gid']));
528 $deny_people = expand_acl($b['deny_cid']);
529 $deny_groups = expand_groups(expand_acl($b['deny_gid']));
531 $recipients = array_unique(array_merge($allow_people,$allow_groups));
532 $deny = array_unique(array_merge($deny_people,$deny_groups));
534 $allow_str = dbesc(implode(', ',$recipients));
536 $r = q("SELECT `notify` FROM `contact` WHERE `id` IN ( $allow_str ) AND `network` = 'face'");
537 $allow_arr = array();
540 $allow_arr[] = $rr['notify'];
543 $deny_str = dbesc(implode(', ',$deny));
545 $r = q("SELECT `notify` FROM `contact` WHERE `id` IN ( $deny_str ) AND `network` = 'face'");
549 $deny_arr[] = $rr['notify'];
552 if(count($deny_arr) && (! count($allow_arr))) {
554 // One or more FB folks were denied access but nobody on FB was specifically allowed access.
555 // This might cause the post to be open to public on Facebook, but only to selected members
556 // on another network. Since this could potentially leak a post to somebody who was denied,
557 // we will skip posting it to Facebook with a slightly vague but relevant message that will
558 // hopefully lead somebody to this code comment for a better explanation of what went wrong.
560 notice( t('Post to Facebook cancelled because of multi-network access permission conflict.') . EOL);
565 // if it's a private message but no Facebook members are allowed or denied, skip Facebook post
567 if((! count($allow_arr)) && (! count($deny_arr)))
571 if($b['verb'] == ACTIVITY_LIKE)
575 $appid = get_config('facebook', 'appid' );
576 $secret = get_config('facebook', 'appsecret' );
578 if($appid && $secret) {
580 logger('facebook: have appid+secret');
582 $fb_token = get_pconfig($b['uid'],'facebook','access_token');
585 // post to facebook if it's a public post and we've ticked the 'post to Facebook' box,
586 // or it's a private message with facebook participants
587 // or it's a reply or likes action to an existing facebook post
589 if($fb_token && ($toplevel || $b['private'] || $reply)) {
590 logger('facebook: able to post');
591 require_once('library/facebook.php');
592 require_once('include/bbcode.php');
596 logger('Facebook post: original msg=' . $msg, LOGGER_DATA);
598 // make links readable before we strip the code
600 // unless it's a dislike - just send the text as a comment
602 if($b['verb'] == ACTIVITY_DISLIKE)
603 $msg = trim(strip_tags(bbcode($msg)));
605 $search_str = $a->get_baseurl() . '/search';
607 if(preg_match("/\[url=(.*?)\](.*?)\[\/url\]/is",$msg,$matches)) {
609 // don't use hashtags for message link
611 if(strpos($matches[2],$search_str) === false) {
613 if(substr($matches[2],0,5) != '[img]')
614 $linkname = $matches[2];
618 $msg = preg_replace("/\[url=(.*?)\](.*?)\[\/url\]/is",'$2 $1',$msg);
620 if(preg_match("/\[img\](.*?)\[\/img\]/is",$msg,$matches))
621 $image = $matches[1];
623 $msg = preg_replace("/\[img\](.*?)\[\/img\]/is", t('Image: ') . '$1', $msg);
625 if((strpos($link,z_root()) !== false) && (! $image))
626 $image = $a->get_baseurl() . '/images/friendika-64.jpg';
628 $msg = trim(strip_tags(bbcode($msg)));
629 $msg = html_entity_decode($msg,ENT_QUOTES,'UTF-8');
631 // add any attachments as text urls
633 $arr = explode(',',$b['attach']);
637 foreach($arr as $r) {
639 $cnt = preg_match('|\[attach\]href=\"(.*?)\" size=\"(.*?)\" type=\"(.*?)\" title=\"(.*?)\"\[\/attach\]|',$r,$matches);
646 if (strlen($msg) > FACEBOOK_MAXPOSTLEN) {
648 require_once('library/slinky.php');
650 $display_url = $a->get_baseurl() . '/display/' . $a->user['nickname'] . '/' . $b['id'];
651 $slinky = new Slinky( $display_url );
652 // setup a cascade of shortening services
653 // try to get a short link from these services
654 // in the order ur1.ca, trim, id.gd, tinyurl
655 $slinky->set_cascade( array( new Slinky_UR1ca(), new Slinky_Trim(), new Slinky_IsGd(), new Slinky_TinyURL() ) );
656 $shortlink = $slinky->short();
657 // the new message will be shortened such that "... $shortlink"
658 // will fit into the character limit
659 $msg = substr($msg, 0, FACEBOOK_MAXPOSTLEN - strlen($shortlink) - 4);
660 $msg .= '... ' . $shortlink;
665 logger('Facebook post: msg=' . $msg, LOGGER_DATA);
668 $postvars = array('access_token' => $fb_token);
672 'access_token' => $fb_token,
676 $postvars['picture'] = $image;
678 $postvars['link'] = $link;
680 $postvars['name'] = $linkname;
683 if(($b['private']) && (! $b['parent'])) {
684 $postvars['privacy'] = '{"value": "CUSTOM", "friends": "SOME_FRIENDS"';
685 if(count($allow_arr))
686 $postvars['privacy'] .= ',"allow": "' . implode(',',$allow_arr) . '"';
688 $postvars['privacy'] .= ',"deny": "' . implode(',',$deny_arr) . '"';
689 $postvars['privacy'] .= '}';
694 $url = 'https://graph.facebook.com/' . $reply . '/' . (($likes) ? 'likes' : 'comments');
697 $url = 'https://graph.facebook.com/me/feed';
699 $postvars['actions'] = '{"name": "' . t('View on Friendika') . '", "link": "' . $b['plink'] . '"}';
702 logger('facebook: post to ' . $url);
703 logger('facebook: postvars: ' . print_r($postvars,true));
705 // "test_mode" prevents anything from actually being posted.
706 // Otherwise, let's do it.
708 if(! get_config('facebook','test_mode')) {
709 $x = post_url($url, $postvars);
711 $retj = json_decode($x);
713 q("UPDATE `item` SET `extid` = '%s' WHERE `id` = %d LIMIT 1",
714 dbesc('fb::' . $retj->id),
720 $s = serialize(array('url' => $url, 'item' => $b['id'], 'post' => $postvars));
721 q("INSERT INTO `queue` ( `network`, `cid`, `created`, `last`, `content`)
722 VALUES ( '%s', %d, '%s', '%s', '%s') ",
723 dbesc(NETWORK_FACEBOOK),
725 dbesc(datetime_convert()),
726 dbesc(datetime_convert()),
730 notice( t('Facebook post failed. Queued for retry.') . EOL);
734 logger('Facebook post returns: ' . $x, LOGGER_DEBUG);
742 function facebook_post_local(&$a,&$b) {
744 // Figure out if Facebook posting is enabled for this post and file it in 'postopts'
745 // where we will discover it during background delivery.
747 // This can only be triggered by a local user posting to their own wall.
749 if((local_user()) && (local_user() == $b['uid'])) {
751 $fb_post = intval(get_pconfig(local_user(),'facebook','post'));
752 $fb_enable = (($fb_post && x($_POST,'facebook_enable')) ? intval($_POST['facebook_enable']) : 0);
754 // if API is used, default to the chosen settings
755 if($_POST['api_source'] && intval(get_pconfig(local_user(),'facebook','post_by_default')))
761 if(strlen($b['postopts']))
762 $b['postopts'] .= ',';
763 $b['postopts'] .= 'facebook';
768 function fb_queue_hook(&$a,&$b) {
770 $qi = q("SELECT * FROM `queue` WHERE `network` = '%s'",
771 dbesc(NETWORK_FACEBOOK)
776 require_once('include/queue_fn.php');
779 if($x['network'] !== NETWORK_FACEBOOK)
782 logger('facebook_queue: run');
784 $r = q("SELECT `user`.* FROM `user` LEFT JOIN `contact` on `contact`.`uid` = `user`.`uid`
785 WHERE `contact`.`self` = 1 AND `contact`.`id` = %d LIMIT 1",
793 $appid = get_config('facebook', 'appid' );
794 $secret = get_config('facebook', 'appsecret' );
796 if($appid && $secret) {
797 $fb_post = intval(get_pconfig($user['uid'],'facebook','post'));
798 $fb_token = get_pconfig($user['uid'],'facebook','access_token');
800 if($fb_post && $fb_token) {
801 logger('facebook_queue: able to post');
802 require_once('library/facebook.php');
804 $z = unserialize($x['content']);
806 $j = post_url($z['url'],$z['post']);
808 $retj = json_decode($j);
810 q("UPDATE `item` SET `extid` = '%s' WHERE `id` = %d LIMIT 1",
811 dbesc('fb::' . $retj->id),
814 logger('facebook_queue: success: ' . $j);
815 remove_queue_item($x['id']);
818 logger('facebook_queue: failed: ' . $j);
819 update_queue_time($x['id']);
826 function fb_consume_all($uid) {
828 require_once('include/items.php');
830 $access_token = get_pconfig($uid,'facebook','access_token');
834 if(! get_pconfig($uid,'facebook','no_wall')) {
835 $private_wall = intval(get_pconfig($uid,'facebook','private_wall'));
836 $s = fetch_url('https://graph.facebook.com/me/feed?access_token=' . $access_token);
838 $j = json_decode($s);
839 logger('fb_consume_stream: wall: ' . print_r($j,true), LOGGER_DATA);
840 fb_consume_stream($uid,$j,($private_wall) ? false : true);
843 $s = fetch_url('https://graph.facebook.com/me/home?access_token=' . $access_token);
845 $j = json_decode($s);
846 logger('fb_consume_stream: feed: ' . print_r($j,true), LOGGER_DATA);
847 fb_consume_stream($uid,$j,false);
852 function fb_consume_stream($uid,$j,$wall = false) {
857 $user = q("SELECT `nickname`, `blockwall` FROM `user` WHERE `uid` = %d AND `account_expired` = 0 LIMIT 1",
863 $my_local_url = $a->get_baseurl() . '/profile/' . $user[0]['nickname'];
865 $no_linking = get_pconfig($uid,'facebook','no_linking');
869 $self = q("SELECT * FROM `contact` WHERE `self` = 1 AND `uid` = %d LIMIT 1",
874 $self_id = get_pconfig($uid,'facebook','self_id');
875 if(! count($j->data) || (! strlen($self_id)))
878 foreach($j->data as $entry) {
879 logger('fb_consume: entry: ' . print_r($entry,true), LOGGER_DATA);
882 $r = q("SELECT * FROM `item` WHERE ( `uri` = '%s' OR `extid` = '%s') AND `uid` = %d LIMIT 1",
883 dbesc('fb::' . $entry->id),
884 dbesc('fb::' . $entry->id),
890 $top_item = $r[0]['id'];
893 $post_exists = false;
898 $datarray['gravity'] = 0;
899 $datarray['uid'] = $uid;
900 $datarray['wall'] = (($wall) ? 1 : 0);
901 $datarray['uri'] = $datarray['parent-uri'] = 'fb::' . $entry->id;
902 $from = $entry->from;
903 if($from->id == $self_id)
904 $datarray['contact-id'] = $self[0]['id'];
906 $r = q("SELECT * FROM `contact` WHERE `notify` = '%s' AND `uid` = %d AND `blocked` = 0 AND `readonly` = 0 LIMIT 1",
911 $datarray['contact-id'] = $r[0]['id'];
914 // don't store post if we don't have a contact
916 if(! x($datarray,'contact-id')) {
917 logger('no contact: post ignored');
921 $datarray['verb'] = ACTIVITY_POST;
923 $datarray['owner-name'] = $self[0]['name'];
924 $datarray['owner-link'] = $self[0]['url'];
925 $datarray['owner-avatar'] = $self[0]['thumb'];
927 if(isset($entry->application) && isset($entry->application->name) && strlen($entry->application->name))
928 $datarray['app'] = strip_tags($entry->application->name);
930 $datarray['app'] = 'facebook';
931 $datarray['author-name'] = $from->name;
932 $datarray['author-link'] = 'http://facebook.com/profile.php?id=' . $from->id;
933 $datarray['author-avatar'] = 'https://graph.facebook.com/' . $from->id . '/picture';
934 $datarray['plink'] = $datarray['author-link'] . '&v=wall&story_fbid=' . substr($entry->id,strpos($entry->id,'_') + 1);
936 $datarray['body'] = $entry->message;
938 $datarray['body'] .= "\n\n" . '[img]' . $entry->picture . '[/img]';
940 $datarray['body'] .= "\n" . linkify($entry->link);
942 $datarray['body'] .= "\n" . $entry->name;
944 $datarray['body'] .= "\n" . $entry->caption;
945 if($entry->description)
946 $datarray['body'] .= "\n" . $entry->description;
947 $datarray['created'] = datetime_convert('UTC','UTC',$entry->created_time);
948 $datarray['edited'] = datetime_convert('UTC','UTC',$entry->updated_time);
950 // If the entry has a privacy policy, we cannot assume who can or cannot see it,
951 // as the identities are from a foreign system. Mark it as private to the owner.
953 if($entry->privacy && $entry->privacy->value !== 'EVERYONE') {
954 $datarray['private'] = 1;
955 $datarray['allow_cid'] = '<' . $uid . '>';
958 $top_item = item_store($datarray);
959 $r = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
965 logger('fb: new top level item posted');
969 if(isset($entry->likes) && isset($entry->likes->data))
970 $likers = $entry->likes->data;
974 if(isset($entry->comments) && isset($entry->comments->data))
975 $comments = $entry->comments->data;
979 if(is_array($likers)) {
980 foreach($likers as $likes) {
985 // If we posted the like locally, it will be found with our url, not the FB url.
987 $second_url = (($likes->id == $self_id) ? $self[0]['url'] : 'http://facebook.com/profile.php?id=' . $likes->id);
989 $r = q("SELECT * FROM `item` WHERE `parent-uri` = '%s' AND `uid` = %d AND `verb` = '%s'
990 AND ( `author-link` = '%s' OR `author-link` = '%s' ) LIMIT 1",
991 dbesc($orig_post['uri']),
993 dbesc(ACTIVITY_LIKE),
994 dbesc('http://facebook.com/profile.php?id=' . $likes->id),
1001 $likedata = array();
1002 $likedata['parent'] = $top_item;
1003 $likedata['verb'] = ACTIVITY_LIKE;
1004 $likedata['gravity'] = 3;
1005 $likedata['uid'] = $uid;
1006 $likedata['wall'] = (($wall) ? 1 : 0);
1007 $likedata['uri'] = item_new_uri($a->get_baseurl(), $uid);
1008 $likedata['parent-uri'] = $orig_post['uri'];
1009 if($likes->id == $self_id)
1010 $likedata['contact-id'] = $self[0]['id'];
1012 $r = q("SELECT * FROM `contact` WHERE `notify` = '%s' AND `uid` = %d AND `blocked` = 0 AND `readonly` = 0 LIMIT 1",
1017 $likedata['contact-id'] = $r[0]['id'];
1019 if(! x($likedata,'contact-id'))
1020 $likedata['contact-id'] = $orig_post['contact-id'];
1022 $likedata['app'] = 'facebook';
1023 $likedata['verb'] = ACTIVITY_LIKE;
1024 $likedata['author-name'] = $likes->name;
1025 $likedata['author-link'] = 'http://facebook.com/profile.php?id=' . $likes->id;
1026 $likedata['author-avatar'] = 'https://graph.facebook.com/' . $likes->id . '/picture';
1028 $author = '[url=' . $likedata['author-link'] . ']' . $likedata['author-name'] . '[/url]';
1029 $objauthor = '[url=' . $orig_post['author-link'] . ']' . $orig_post['author-name'] . '[/url]';
1030 $post_type = t('status');
1031 $plink = '[url=' . $orig_post['plink'] . ']' . $post_type . '[/url]';
1032 $likedata['object-type'] = ACTIVITY_OBJ_NOTE;
1034 $likedata['body'] = sprintf( t('%1$s likes %2$s\'s %3$s'), $author, $objauthor, $plink);
1035 $likedata['object'] = '<object><type>' . ACTIVITY_OBJ_NOTE . '</type><local>1</local>' .
1036 '<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>';
1038 $item = item_store($likedata);
1041 if(is_array($comments)) {
1042 foreach($comments as $cmnt) {
1047 $r = q("SELECT * FROM `item` WHERE `uid` = %d AND ( `uri` = '%s' OR `extid` = '%s' ) LIMIT 1",
1049 dbesc('fb::' . $cmnt->id),
1050 dbesc('fb::' . $cmnt->id)
1055 $cmntdata = array();
1056 $cmntdata['parent'] = $top_item;
1057 $cmntdata['verb'] = ACTIVITY_POST;
1058 $cmntdata['gravity'] = 6;
1059 $cmntdata['uid'] = $uid;
1060 $cmntdata['wall'] = (($wall) ? 1 : 0);
1061 $cmntdata['uri'] = 'fb::' . $cmnt->id;
1062 $cmntdata['parent-uri'] = $orig_post['uri'];
1063 if($cmnt->from->id == $self_id) {
1064 $cmntdata['contact-id'] = $self[0]['id'];
1067 $r = q("SELECT * FROM `contact` WHERE `notify` = '%s' AND `uid` = %d LIMIT 1",
1068 dbesc($cmnt->from->id),
1072 $cmntdata['contact-id'] = $r[0]['id'];
1073 if($r[0]['blocked'] || $r[0]['readonly'])
1077 if(! x($cmntdata,'contact-id'))
1078 $cmntdata['contact-id'] = $orig_post['contact-id'];
1080 $cmntdata['app'] = 'facebook';
1081 $cmntdata['created'] = datetime_convert('UTC','UTC',$cmnt->created_time);
1082 $cmntdata['edited'] = datetime_convert('UTC','UTC',$cmnt->created_time);
1083 $cmntdata['verb'] = ACTIVITY_POST;
1084 $cmntdata['author-name'] = $cmnt->from->name;
1085 $cmntdata['author-link'] = 'http://facebook.com/profile.php?id=' . $cmnt->from->id;
1086 $cmntdata['author-avatar'] = 'https://graph.facebook.com/' . $cmnt->from->id . '/picture';
1087 $cmntdata['body'] = $cmnt->message;
1088 $item = item_store($cmntdata);