include/api.php

   1 <?php
   2         require_once("bbcode.php");
   3         require_once("datetime.php");
   4         require_once("conversation.php");
   5         require_once("oauth.php");
   6         /*
   7          * Twitter-Like API
   8          *
   9          */
  10
  11         $API = Array();
  12         $called_api = Null;
  13
  14         function api_date($str){
  15                 //Wed May 23 06:01:13 +0000 2007
  16                 return datetime_convert('UTC', 'UTC', $str, "D M d H:i:s +0000 Y" );
  17         }
  18
  19
  20         function api_register_func($path, $func, $auth=false){
  21                 global $API;
  22                 $API[$path] = array('func'=>$func,
  23                                                         'auth'=>$auth);
  24         }
  25
  26         /**
  27          * Simple HTTP Login
  28          */
  29         function api_login(&$a){
  30                 // workaround for HTTP-auth in CGI mode
  31                 if(x($_SERVER,'REDIRECT_REMOTE_USER')) {
  32                         $userpass = base64_decode(substr($_SERVER["REDIRECT_REMOTE_USER"],6)) ;
  33                         if(strlen($userpass)) {
  34                                 list($name, $password) = explode(':', $userpass);
  35                                 $_SERVER['PHP_AUTH_USER'] = $name;
  36                                 $_SERVER['PHP_AUTH_PW'] = $password;
  37                         }
  38                 }
  39
  40                 if (!isset($_SERVER['PHP_AUTH_USER'])) {
  41                    logger('API_login: ' . print_r($_SERVER,true), LOGGER_DEBUG);
  42                     header('WWW-Authenticate: Basic realm="Friendika"');
  43                     header('HTTP/1.0 401 Unauthorized');
  44                     die('This api requires login');
  45                 }
  46
  47                 $user = $_SERVER['PHP_AUTH_USER'];
  48                 $encrypted = hash('whirlpool',trim($_SERVER['PHP_AUTH_PW']));
  49
  50
  51                         /**
  52                          *  next code from mod/auth.php. needs better solution
  53                          */
  54
  55                 // process normal login request
  56
  57                 $r = q("SELECT * FROM `user` WHERE ( `email` = '%s' OR `nickname` = '%s' )
  58                         AND `password` = '%s' AND `blocked` = 0 AND `account_expired` = 0 AND `verified` = 1 LIMIT 1",
  59                         dbesc(trim($user)),
  60                         dbesc(trim($user)),
  61                         dbesc($encrypted)
  62                 );
  63                 if(count($r)){
  64                         $record = $r[0];
  65                 } else {
  66                    logger('API_login failure: ' . print_r($_SERVER,true), LOGGER_DEBUG);
  67                     header('WWW-Authenticate: Basic realm="Friendika"');
  68                     header('HTTP/1.0 401 Unauthorized');
  69                     die('This api requires login');
  70                 }
  71                 $_SESSION['uid'] = $record['uid'];
  72                 $_SESSION['theme'] = $record['theme'];
  73                 $_SESSION['authenticated'] = 1;
  74                 $_SESSION['page_flags'] = $record['page-flags'];
  75                 $_SESSION['my_url'] = $a->get_baseurl() . '/profile/' . $record['nickname'];
  76                 $_SESSION['addr'] = $_SERVER['REMOTE_ADDR'];
  77
  78                 //notice( t("Welcome back ") . $record['username'] . EOL);
  79                 $a->user = $record;
  80
  81                 if(strlen($a->user['timezone'])) {
  82                         date_default_timezone_set($a->user['timezone']);
  83                         $a->timezone = $a->user['timezone'];
  84                 }
  85
  86                 $r = q("SELECT * FROM `contact` WHERE `uid` = %s AND `self` = 1 LIMIT 1",
  87                         intval($_SESSION['uid']));
  88                 if(count($r)) {
  89                         $a->contact = $r[0];
  90                         $a->cid = $r[0]['id'];
  91                         $_SESSION['cid'] = $a->cid;
  92                 }
  93                 q("UPDATE `user` SET `login_date` = '%s' WHERE `uid` = %d LIMIT 1",
  94                         dbesc(datetime_convert()),
  95                         intval($_SESSION['uid'])
  96                 );
  97
  98                 call_hooks('logged_in', $a->user);
  99
 100                 header('X-Account-Management-Status: active; name="' . $a->user['username'] . '"; id="' . $a->user['nickname'] .'"');
 101         }
 102
 103         /**************************
 104          *  MAIN API ENTRY POINT  *
 105          **************************/
 106         function api_call(&$a){
 107                 GLOBAL $API, $called_api;
 108                 foreach ($API as $p=>$info){
 109                         if (strpos($a->query_string, $p)===0){
 110                                 $called_api= explode("/",$p);
 111                                 #unset($_SERVER['PHP_AUTH_USER']);
 112                                 if ($info['auth']===true && local_user()===false) {
 113                                                 api_login($a);
 114                                 }
 115
 116                                 load_contact_links(local_user());
 117
 118                                 logger('API call for ' . $a->user['username'] . ': ' . $a->query_string);
 119                                 logger('API parameters: ' . print_r($_REQUEST,true));
 120                                 $type="json";
 121                                 if (strpos($a->query_string, ".xml")>0) $type="xml";
 122                                 if (strpos($a->query_string, ".json")>0) $type="json";
 123                                 if (strpos($a->query_string, ".rss")>0) $type="rss";
 124                                 if (strpos($a->query_string, ".atom")>0) $type="atom";
 125
 126                                 $r = call_user_func($info['func'], $a, $type);
 127                                 if ($r===false) return;
 128
 129                                 switch($type){
 130                                         case "xml":
 131                                                 $r = mb_convert_encoding($r, "UTF-8",mb_detect_encoding($r));
 132                                                 header ("Content-Type: text/xml");
 133                                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 134                                                 break;
 135                                         case "json":
 136                                                 //header ("Content-Type: application/json");
 137                                                 foreach($r as $rr)
 138                                                     return json_encode($rr);
 139                                                 break;
 140                                         case "rss":
 141                                                 header ("Content-Type: application/rss+xml");
 142                                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 143                                                 break;
 144                                         case "atom":
 145                                                 header ("Content-Type: application/atom+xml");
 146                                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 147                                                 break;
 148
 149                                 }
 150                                 //echo "<pre>"; var_dump($r); die();
 151                         }
 152                 }
 153                 $r = '<status><error>not implemented</error></status>';
 154                 switch($type){
 155                         case "xml":
 156                                 header ("Content-Type: text/xml");
 157                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 158                                 break;
 159                         case "json":
 160                                 header ("Content-Type: application/json");
 161                             return json_encode(array('error' => 'not implemented'));
 162                                 break;
 163                         case "rss":
 164                                 header ("Content-Type: application/rss+xml");
 165                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 166                                 break;
 167                         case "atom":
 168                                 header ("Content-Type: application/atom+xml");
 169                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 170                                 break;
 171
 172                 }
 173         }
 174
 175         /**
 176          * RSS extra info
 177          */
 178         function api_rss_extra(&$a, $arr, $user_info){
 179                 if (is_null($user_info)) $user_info = api_get_user($a);
 180                 $arr['$user'] = $user_info;
 181                 $arr['$rss'] = array(
 182                         'alternate' => $user_info['url'],
 183                         'self' => $a->get_baseurl(). "/". $a->query_string,
 184                         'base' => $a->get_baseurl(),
 185                         'updated' => api_date(null),
 186                         'atom_updated' => datetime_convert('UTC','UTC','now',ATOM_TIME),
 187                         'language' => $user_info['language'],
 188                         'logo'  => $a->get_baseurl()."/images/friendika-32.png",
 189                 );
 190
 191                 return $arr;
 192         }
 193
 194         /**
 195          * Returns user info array.
 196          */
 197         function api_get_user(&$a, $contact_id = Null){
 198                 global $called_api;
 199                 $user = null;
 200                 $extra_query = "";
 201
 202
 203                 if(!is_null($contact_id)){
 204                         $user=$contact_id;
 205                         $extra_query = "AND `contact`.`id` = %d ";
 206                 }
 207
 208                 if(is_null($user) && x($_GET, 'user_id')) {
 209                         $user = intval($_GET['user_id']);
 210                         $extra_query = "AND `contact`.`id` = %d ";
 211                 }
 212                 if(is_null($user) && x($_GET, 'screen_name')) {
 213                         $user = dbesc($_GET['screen_name']);
 214                         $extra_query = "AND `contact`.`nick` = '%s' ";
 215                         if (local_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(local_user());
 216
 217                 }
 218
 219                 if (is_null($user) && $a->argc > (count($called_api)-1)){
 220                         $argid = count($called_api);
 221                         list($user, $null) = explode(".",$a->argv[$argid]);
 222                         if(is_numeric($user)){
 223                                 $user = intval($user);
 224                                 $extra_query = "AND `contact`.`id` = %d ";
 225                         } else {
 226                                 $user = dbesc($user);
 227                                 $extra_query = "AND `contact`.`nick` = '%s' ";
 228                                 if (local_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(local_user());
 229                         }
 230                 }
 231
 232                 if (! $user) {
 233                         if (local_user()===false) {
 234                                 api_login($a); return False;
 235                         } else {
 236                                 $user = $_SESSION['uid'];
 237                                 $extra_query = "AND `contact`.`uid` = %d AND `contact`.`self` = 1 ";
 238                         }
 239
 240                 }
 241
 242                 logger('api_user: ' . $extra_query . ' ' , $user);
 243                 // user info
 244                 $uinfo = q("SELECT *, `contact`.`id` as `cid` FROM `contact`
 245                                 WHERE 1
 246                                 $extra_query",
 247                                 $user
 248                 );
 249                 if (count($uinfo)==0) {
 250                         return False;
 251                 }
 252
 253                 if($uinfo[0]['self']) {
 254                         $usr = q("select * from user where uid = %d limit 1",
 255                                 intval(local_user())
 256                         );
 257                         $profile = q("select * from profile where uid = %d and `is-default` = 1 limit 1",
 258                                 intval(local_user())
 259                         );
 260
 261                         // count public wall messages
 262                         $r = q("SELECT COUNT(`id`) as `count` FROM `item`
 263                                         WHERE  `uid` = %d
 264                                         AND `type`='wall'
 265                                         AND `allow_cid`='' AND `allow_gid`='' AND `deny_cid`='' AND `deny_gid`=''",
 266                                         intval($uinfo[0]['uid'])
 267                         );
 268                         $countitms = $r[0]['count'];
 269                 }
 270                 else {
 271                         $r = q("SELECT COUNT(`id`) as `count` FROM `item`
 272                                         WHERE  `contact-id` = %d
 273                                         AND `allow_cid`='' AND `allow_gid`='' AND `deny_cid`='' AND `deny_gid`=''",
 274                                         intval($uinfo[0]['id'])
 275                         );
 276                         $countitms = $r[0]['count'];
 277                 }
 278
 279                 // count friends
 280                 $r = q("SELECT COUNT(`id`) as `count` FROM `contact`
 281                                 WHERE  `uid` = %d AND `rel` IN ( %d, %d )
 282                                 AND `self`=0 AND `blocked`=0",
 283                                 intval($uinfo[0]['uid']),
 284                                 intval(CONTACT_IS_SHARING),
 285                                 intval(CONTACT_IS_FRIEND)
 286                 );
 287                 $countfriends = $r[0]['count'];
 288
 289                 $r = q("SELECT COUNT(`id`) as `count` FROM `contact`
 290                                 WHERE  `uid` = %d AND `rel` IN ( %d, %d )
 291                                 AND `self`=0 AND `blocked`=0",
 292                                 intval($uinfo[0]['uid']),
 293                                 intval(CONTACT_IS_FOLLOWER),
 294                                 intval(CONTACT_IS_FRIEND)
 295                 );
 296                 $countfollowers = $r[0]['count'];
 297
 298                 $r = q("SELECT count(`id`) as `count` FROM item where starred = 1 and uid = %d and deleted = 0",
 299                         intval($uinfo[0]['uid'])
 300                 );
 301                 $starred = $r[0]['count'];
 302
 303
 304                 if(! $uinfo[0]['self']) {
 305                         $countfriends = 0;
 306                         $countfollowers = 0;
 307                         $starred = 0;
 308                 }
 309
 310                 $ret = Array(
 311                         'self' => intval($uinfo[0]['self']),
 312                         'uid' => intval($uinfo[0]['uid']),
 313                         'id' => intval($uinfo[0]['cid']),
 314                         'name' => $uinfo[0]['name'],
 315                         'screen_name' => (($uinfo[0]['nick']) ? $uinfo[0]['nick'] : $uinfo[0]['name']),
 316                         'location' => ($usr) ? $usr[0]['default-location'] : '',
 317                         'profile_image_url' => $uinfo[0]['micro'],
 318                         'url' => $uinfo[0]['url'],
 319                         'contact_url' => $a->get_baseurl()."/contacts/".$uinfo[0]['cid'],
 320                         'protected' => false,
 321                         'friends_count' => intval($countfriends),
 322                         'created_at' => api_date($uinfo[0]['name-date']),
 323                         'utc_offset' => "+00:00",
 324                         'time_zone' => 'UTC', //$uinfo[0]['timezone'],
 325                         'geo_enabled' => false,
 326                         'statuses_count' => intval($countitms), #XXX: fix me
 327                         'lang' => 'en', #XXX: fix me
 328                         'description' => (($profile) ? $profile[0]['pdesc'] : ''),
 329                         'followers_count' => intval($countfollowers),
 330                         'favourites_count' => intval($starred),
 331                         'contributors_enabled' => false,
 332                         'follow_request_sent' => true,
 333                         'profile_background_color' => 'cfe8f6',
 334                         'profile_text_color' => '000000',
 335                         'profile_link_color' => 'FF8500',
 336                         'profile_sidebar_fill_color' =>'AD0066',
 337                         'profile_sidebar_border_color' => 'AD0066',
 338                         'profile_background_image_url' => '',
 339                         'profile_background_tile' => false,
 340                         'profile_use_background_image' => false,
 341                         'notifications' => false,
 342                         'following' => '', #XXX: fix me
 343                         'verified' => true, #XXX: fix me
 344                         'status' => array()
 345                 );
 346
 347                 return $ret;
 348
 349         }
 350
 351         function api_item_get_user(&$a, $item) {
 352                 // The author is our direct contact, in a conversation with us.
 353                 if(link_compare($item['url'],$item['author-link'])) {
 354                         return api_get_user($a,$item['cid']);
 355                 }
 356                 else {
 357                         // The author may be a contact of ours, but is replying to somebody else.
 358                         // Figure out if we know him/her.
 359                         $normalised = normalise_link((strlen($item['author-link'])) ? $item['author-link'] : $item['url']);
 360             if(($normalised != 'mailbox') && (x($a->contacts[$normalised])))
 361                                 return api_get_user($a,$a->contacts[$normalised]['id']);
 362                 }
 363                 // We don't know this person directly.
 364
 365                 list($nick, $name) = array_map("trim",explode("(",$item['author-name']));
 366                 $name=str_replace(")","",$name);
 367
 368                 $ret = array(
 369                         'uid' => 0,
 370                         'id' => 0,
 371                         'name' => $name,
 372                         'screen_name' => $nick,
 373                         'location' => '', //$uinfo[0]['default-location'],
 374                         'profile_image_url' => $item['author-avatar'],
 375                         'url' => $item['author-link'],
 376                         'contact_url' => 0,
 377                         'protected' => false,   #
 378                         'friends_count' => 0,
 379                         'created_at' => '',
 380                         'utc_offset' => 0, #XXX: fix me
 381                         'time_zone' => '', //$uinfo[0]['timezone'],
 382                         'geo_enabled' => false,
 383                         'statuses_count' => 0,
 384                         'lang' => 'en', #XXX: fix me
 385                         'description' => '',
 386                         'followers_count' => 0,
 387                         'favourites_count' => 0,
 388                         'contributors_enabled' => false,
 389                         'follow_request_sent' => false,
 390                         'profile_background_color' => 'cfe8f6',
 391                         'profile_text_color' => '000000',
 392                         'profile_link_color' => 'FF8500',
 393                         'profile_sidebar_fill_color' =>'AD0066',
 394                         'profile_sidebar_border_color' => 'AD0066',
 395                         'profile_background_image_url' => '',
 396                         'profile_background_tile' => false,
 397                         'profile_use_background_image' => false,
 398                         'notifications' => false,
 399                         'verified' => true, #XXX: fix me
 400                         'followers' => '', #XXX: fix me
 401                         'status' => array()
 402                 );
 403
 404                 return $ret;
 405         }
 406
 407         /**
 408          * apply xmlify() to all values of array $val, recursively
 409          */
 410         function api_xmlify($val){
 411                 if (is_bool($val)) return $val?"true":"false";
 412                 if (is_array($val)) return array_map('api_xmlify', $val);
 413                 return xmlify((string) $val);
 414         }
 415
 416         /**
 417          *  load api $templatename for $type and replace $data array
 418          */
 419         function api_apply_template($templatename, $type, $data){
 420
 421                 $a = get_app();
 422
 423                 switch($type){
 424                         case "atom":
 425                         case "rss":
 426                         case "xml":
 427                                 $data = api_xmlify($data);
 428                                 $tpl = get_markup_template("api_".$templatename."_".$type.".tpl");
 429                                 $ret = replace_macros($tpl, $data);
 430                                 break;
 431                         case "json":
 432                                 $ret = $data;
 433                                 break;
 434                 }
 435                 return $ret;
 436         }
 437
 438         /**
 439          ** TWITTER API
 440          */
 441
 442         /**
 443          * Returns an HTTP 200 OK response code and a representation of the requesting user if authentication was successful;
 444          * returns a 401 status code and an error message if not.
 445          * http://developer.twitter.com/doc/get/account/verify_credentials
 446          */
 447         function api_account_verify_credentials(&$a, $type){
 448                 if (local_user()===false) return false;
 449                 $user_info = api_get_user($a);
 450
 451                 return api_apply_template("user", $type, array('$user' => $user_info));
 452
 453         }
 454         api_register_func('api/account/verify_credentials','api_account_verify_credentials', true);
 455
 456
 457         /**
 458          * get data from $_POST or $_GET
 459          */
 460         function requestdata($k){
 461                 if (isset($_POST[$k])){
 462                         return $_POST[$k];
 463                 }
 464                 if (isset($_GET[$k])){
 465                         return $_GET[$k];
 466                 }
 467                 return null;
 468         }
 469
 470         // TODO - media uploads
 471         function api_statuses_update(&$a, $type) {
 472                 if (local_user()===false) return false;
 473                 $user_info = api_get_user($a);
 474
 475                 // convert $_POST array items to the form we use for web posts.
 476
 477                 // logger('api_post: ' . print_r($_POST,true));
 478
 479                 if(requestdata('htmlstatus')) {
 480                         require_once('library/HTMLPurifier.auto.php');
 481                         require_once('include/html2bbcode.php');
 482
 483                         $txt = requestdata('htmlstatus');
 484                         if((strpos($txt,'<') !== false) || (strpos($txt,'>') !== false)) {
 485
 486                                 $txt = html2bb_video($txt);
 487
 488                                 $config = HTMLPurifier_Config::createDefault();
 489                                 $config->set('Cache.DefinitionImpl', null);
 490
 491
 492                                 $purifier = new HTMLPurifier($config);
 493                                 $txt = $purifier->purify($txt);
 494
 495                                 $_POST['body'] = html2bbcode($txt);
 496                         }
 497
 498                 }
 499                 else
 500                         $_POST['body'] = urldecode(requestdata('status'));
 501
 502                 $parent = requestdata('in_reply_to_status_id');
 503                 if(ctype_digit($parent))
 504                         $_POST['parent'] = $parent;
 505                 else
 506                         $_POST['parent_uri'] = $parent;
 507
 508                 if(requestdata('lat') && requestdata('long'))
 509                         $_POST['coord'] = sprintf("%s %s",requestdata('lat'),requestdata('long'));
 510                 $_POST['profile_uid'] = local_user();
 511                 if(requestdata('parent'))
 512                         $_POST['type'] = 'net-comment';
 513                 else
 514                         $_POST['type'] = 'wall';
 515
 516                 // set this so that the item_post() function is quiet and doesn't redirect or emit json
 517
 518                 $_POST['api_source'] = true;
 519
 520                 // call out normal post function
 521
 522                 require_once('mod/item.php');
 523                 item_post($a);
 524
 525                 // this should output the last post (the one we just posted).
 526                 return api_status_show($a,$type);
 527         }
 528         api_register_func('api/statuses/update','api_statuses_update', true);
 529
 530
 531         function api_status_show(&$a, $type){
 532                 $user_info = api_get_user($a);
 533                 // get last public wall message
 534                 $lastwall = q("SELECT `item`.*, `i`.`contact-id` as `reply_uid`, `i`.`nick` as `reply_author`
 535                                 FROM `item`, `contact`,
 536                                         (SELECT `item`.`id`, `item`.`contact-id`, `contact`.`nick` FROM `item`,`contact` WHERE `contact`.`id`=`item`.`contact-id`) as `i`
 537                                 WHERE `item`.`contact-id` = %d
 538                                         AND `i`.`id` = `item`.`parent`
 539                                         AND `contact`.`id`=`item`.`contact-id` AND `contact`.`self`=1
 540                                         AND `type`!='activity'
 541                                         AND `item`.`allow_cid`='' AND `item`.`allow_gid`='' AND `item`.`deny_cid`='' AND `item`.`deny_gid`=''
 542                                 ORDER BY `created` DESC
 543                                 LIMIT 1",
 544                                 intval($user_info['id'])
 545                 );
 546
 547                 if (count($lastwall)>0){
 548                         $lastwall = $lastwall[0];
 549
 550                         $in_reply_to_status_id = '';
 551                         $in_reply_to_user_id = '';
 552                         $in_reply_to_screen_name = '';
 553                         if ($lastwall['parent']!=$lastwall['id']) {
 554                                 $in_reply_to_status_id=$lastwall['parent'];
 555                                 $in_reply_to_user_id = $lastwall['reply_uid'];
 556                                 $in_reply_to_screen_name = $lastwall['reply_author'];
 557                         }
 558                         $status_info = array(
 559                                 'created_at' => api_date($lastwall['created']),
 560                                 'id' => $lastwall['contact-id'],
 561                                 'text' => strip_tags(bbcode($lastwall['body'])),
 562                                 'source' => (($lastwall['app']) ? $lastwall['app'] : 'web'),
 563                                 'truncated' => false,
 564                                 'in_reply_to_status_id' => $in_reply_to_status_id,
 565                                 'in_reply_to_user_id' => $in_reply_to_user_id,
 566                                 'favorited' => false,
 567                                 'in_reply_to_screen_name' => $in_reply_to_screen_name,
 568                                 'geo' => '',
 569                                 'coordinates' => $lastwall['coord'],
 570                                 'place' => $lastwall['location'],
 571                                 'contributors' => ''
 572                         );
 573                         $status_info['user'] = $user_info;
 574                 }
 575                 return  api_apply_template("status", $type, array('$status' => $status_info));
 576
 577         }
 578
 579
 580
 581
 582
 583         /**
 584          * Returns extended information of a given user, specified by ID or screen name as per the required id parameter.
 585          * The author's most recent status will be returned inline.
 586          * http://developer.twitter.com/doc/get/users/show
 587          */
 588         function api_users_show(&$a, $type){
 589                 $user_info = api_get_user($a);
 590                 // get last public wall message
 591                 $lastwall = q("SELECT `item`.*, `i`.`contact-id` as `reply_uid`, `i`.`nick` as `reply_author`
 592                                 FROM `item`, `contact`,
 593                                         (SELECT `item`.`id`, `item`.`contact-id`, `contact`.`nick` FROM `item`,`contact` WHERE `contact`.`id`=`item`.`contact-id`) as `i`
 594                                 WHERE `item`.`contact-id` = %d
 595                                         AND `i`.`id` = `item`.`parent`
 596                                         AND `contact`.`id`=`item`.`contact-id` AND `contact`.`self`=1
 597                                         AND `type`!='activity'
 598                                         AND `item`.`allow_cid`='' AND `item`.`allow_gid`='' AND `item`.`deny_cid`='' AND `item`.`deny_gid`=''
 599                                 ORDER BY `created` DESC
 600                                 LIMIT 1",
 601                                 intval($user_info['id'])
 602                 );
 603
 604                 if (count($lastwall)>0){
 605                         $lastwall = $lastwall[0];
 606
 607                         $in_reply_to_status_id = '';
 608                         $in_reply_to_user_id = '';
 609                         $in_reply_to_screen_name = '';
 610                         if ($lastwall['parent']!=$lastwall['id']) {
 611                                 $in_reply_to_status_id=$lastwall['parent'];
 612                                 $in_reply_to_user_id = $lastwall['reply_uid'];
 613                                 $in_reply_to_screen_name = $lastwall['reply_author'];
 614                         }
 615                         $user_info['status'] = array(
 616                                 'created_at' => api_date($lastwall['created']),
 617                                 'id' => $lastwall['contact-id'],
 618                                 'text' => strip_tags(bbcode($lastwall['body'])),
 619                                 'source' => (($lastwall['app']) ? $lastwall['app'] : 'web'),
 620                                 'truncated' => false,
 621                                 'in_reply_to_status_id' => $in_reply_to_status_id,
 622                                 'in_reply_to_user_id' => $in_reply_to_user_id,
 623                                 'favorited' => false,
 624                                 'in_reply_to_screen_name' => $in_reply_to_screen_name,
 625                                 'geo' => '',
 626                                 'coordinates' => $lastwall['coord'],
 627                                 'place' => $lastwall['location'],
 628                                 'contributors' => ''
 629                         );
 630                 }
 631                 return  api_apply_template("user", $type, array('$user' => $user_info));
 632
 633         }
 634         api_register_func('api/users/show','api_users_show');
 635
 636         /**
 637          *
 638          * http://developer.twitter.com/doc/get/statuses/home_timeline
 639          *
 640          * TODO: Optional parameters
 641          * TODO: Add reply info
 642          */
 643         function api_statuses_home_timeline(&$a, $type){
 644                 if (local_user()===false) return false;
 645
 646                 $user_info = api_get_user($a);
 647                 // get last newtork messages
 648
 649
 650                 // params
 651                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
 652                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
 653                 if ($page<0) $page=0;
 654                 $since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 655
 656                 $start = $page*$count;
 657
 658                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
 659                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
 660                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
 661                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
 662                         FROM `item`, `contact`
 663                         WHERE `item`.`uid` = %d
 664                         AND `item`.`visible` = 1 AND `item`.`deleted` = 0
 665                         AND `contact`.`id` = `item`.`contact-id`
 666                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 667                         $sql_extra
 668                         AND `item`.`id`>%d
 669                         ORDER BY `item`.`received` DESC LIMIT %d ,%d ",
 670                         intval($user_info['uid']),
 671                         intval($since_id),
 672                         intval($start), intval($count)
 673                 );
 674
 675                 $ret = api_format_items($r,$user_info);
 676
 677
 678                 $data = array('$statuses' => $ret);
 679                 switch($type){
 680                         case "atom":
 681                         case "rss":
 682                                 $data = api_rss_extra($a, $data, $user_info);
 683                 }
 684
 685                 return  api_apply_template("timeline", $type, $data);
 686         }
 687         api_register_func('api/statuses/home_timeline','api_statuses_home_timeline', true);
 688         api_register_func('api/statuses/friends_timeline','api_statuses_home_timeline', true);
 689
 690
 691
 692         function api_statuses_user_timeline(&$a, $type){
 693                 if (local_user()===false) return false;
 694
 695                 $user_info = api_get_user($a);
 696                 // get last newtork messages
 697
 698
 699                 logger("api_statuses_user_timeline: local_user: ". local_user() .
 700                            "\nuser_info: ".print_r($user_info, true) .
 701                            "\n_REQUEST:  ".print_r($_REQUEST, true),
 702                            LOGGER_DEBUG);
 703
 704                 // params
 705                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
 706                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
 707                 if ($page<0) $page=0;
 708                 $since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 709
 710                 $start = $page*$count;
 711
 712                 if ($user_info['self']==1) $sql_extra = "AND `item`.`wall` = 1 ";
 713
 714                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
 715                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
 716                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
 717                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
 718                         FROM `item`, `contact`
 719                         WHERE `item`.`uid` = %d
 720                         AND `item`.`contact-id` = %d
 721                         AND `item`.`visible` = 1 AND `item`.`deleted` = 0
 722                         AND `contact`.`id` = `item`.`contact-id`
 723                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 724                         $sql_extra
 725                         AND `item`.`id`>%d
 726                         ORDER BY `item`.`received` DESC LIMIT %d ,%d ",
 727                         intval(local_user()),
 728                         intval($user_info['id']),
 729                         intval($since_id),
 730                         intval($start), intval($count)
 731                 );
 732
 733                 $ret = api_format_items($r,$user_info);
 734
 735
 736                 $data = array('$statuses' => $ret);
 737                 switch($type){
 738                         case "atom":
 739                         case "rss":
 740                                 $data = api_rss_extra($a, $data, $user_info);
 741                 }
 742
 743                 return  api_apply_template("timeline", $type, $data);
 744         }
 745
 746         api_register_func('api/statuses/user_timeline','api_statuses_user_timeline', true);
 747
 748
 749         function api_favorites(&$a, $type){
 750                 if (local_user()===false) return false;
 751
 752                 $user_info = api_get_user($a);
 753                 // in friendika starred item are private
 754                 // return favorites only for self
 755                 logger('api_favorites: self:' . $user_info['self']);
 756
 757                 if ($user_info['self']==0) {
 758                         $ret = array();
 759                 } else {
 760
 761
 762                         // params
 763                         $count = (x($_GET,'count')?$_GET['count']:20);
 764                         $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
 765                         if ($page<0) $page=0;
 766
 767                         $start = $page*$count;
 768
 769                         $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
 770                                 `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
 771                                 `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
 772                                 `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
 773                                 FROM `item`, `contact`
 774                                 WHERE `item`.`uid` = %d
 775                                 AND `item`.`visible` = 1 AND `item`.`deleted` = 0
 776                                 AND `item`.`starred` = 1
 777                                 AND `contact`.`id` = `item`.`contact-id`
 778                                 AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 779                                 $sql_extra
 780                                 ORDER BY `item`.`received` DESC LIMIT %d ,%d ",
 781                                 intval($user_info['uid']),
 782                                 intval($start), intval($count)
 783                         );
 784
 785                         $ret = api_format_items($r,$user_info);
 786
 787                 }
 788
 789                 $data = array('$statuses' => $ret);
 790                 switch($type){
 791                         case "atom":
 792                         case "rss":
 793                                 $data = api_rss_extra($a, $data, $user_info);
 794                 }
 795
 796                 return  api_apply_template("timeline", $type, $data);
 797         }
 798
 799         api_register_func('api/favorites','api_favorites', true);
 800
 801
 802         function api_format_items($r,$user_info) {
 803
 804                 //logger('api_format_items: ' . print_r($r,true));
 805
 806                 //logger('api_format_items: ' . print_r($user_info,true));
 807
 808                 $a = get_app();
 809                 $ret = Array();
 810
 811                 foreach($r as $item) {
 812                         localize_item($item);
 813                         $status_user = (($item['cid']==$user_info['id'])?$user_info: api_item_get_user($a,$item));
 814                         $status = array(
 815                                 'created_at'=> api_date($item['created']),
 816                                 'published' => api_date($item['created']),
 817                                 'updated'   => api_date($item['edited']),
 818                                 'id'            => intval($item['id']),
 819                                 'message_id' => $item['uri'],
 820                                 'text'          => strip_tags(bbcode($item['body'])),
 821                                 'statusnet_html'                => bbcode($item['body']),
 822                                 'source'    => (($item['app']) ? $item['app'] : 'web'),
 823                                 'url'           => ($item['plink']!=''?$item['plink']:$item['author-link']),
 824                                 'truncated' => False,
 825                                 'in_reply_to_status_id' => ($item['parent']!=$item['id']? intval($item['parent']):''),
 826                                 'in_reply_to_user_id' => '',
 827                                 'favorited' => $item['starred'] ? true : false,
 828                                 'in_reply_to_screen_name' => '',
 829                                 'geo' => '',
 830                                 'coordinates' => $item['coord'],
 831                                 'place' => $item['location'],
 832                                 'contributors' => '',
 833                                 'annotations'  => '',
 834                                 'entities'  => '',
 835                                 'user' =>  $status_user ,
 836                                 'objecttype' => (($item['object-type']) ? $item['object-type'] : ACTIVITY_OBJ_NOTE),
 837                                 'verb' => (($item['verb']) ? $item['verb'] : ACTIVITY_POST),
 838                                 'self' => $a->get_baseurl()."/api/statuses/show/".$item['id'].".".$type,
 839                                 'edit' => $a->get_baseurl()."/api/statuses/show/".$item['id'].".".$type,
 840                         );
 841                         $ret[]=$status;
 842                 };
 843                 return $ret;
 844         }
 845
 846
 847         function api_account_rate_limit_status(&$a,$type) {
 848
 849                 $hash = array(
 850                           'remaining_hits' => (string) 150,
 851                           'hourly_limit' => (string) 150,
 852                           'reset_time' => datetime_convert('UTC','UTC','now + 1 hour',ATOM_TIME),
 853                           'reset_time_in_seconds' => strtotime('now + 1 hour')
 854                 );
 855
 856                 return api_apply_template('ratelimit', $type, array('$hash' => $hash));
 857
 858         }
 859         api_register_func('api/account/rate_limit_status','api_account_rate_limit_status',true);
 860
 861         /**
 862          *  https://dev.twitter.com/docs/api/1/get/statuses/friends
 863          *  This function is deprecated by Twitter
 864          *  returns: json, xml
 865          **/
 866         function api_statuses_f(&$a, $type, $qtype) {
 867                 if (local_user()===false) return false;
 868                 $user_info = api_get_user($a);
 869
 870
 871                 // friends and followers only for self
 872                 if ($user_info['self']==0){
 873                         return false;
 874                 }
 875
 876                 if (x($_GET,'cursor') && $_GET['cursor']=='undefined'){
 877                         /* this is to stop Hotot to load friends multiple times
 878                         *  I'm not sure if I'm missing return something or
 879                         *  is a bug in hotot. Workaround, meantime
 880                         */
 881
 882                         /*$ret=Array();
 883                         return array('$users' => $ret);*/
 884                         return false;
 885                 }
 886
 887                 if($qtype == 'friends')
 888                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_SHARING), intval(CONTACT_IS_FRIEND));
 889                 if($qtype == 'followers')
 890                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_FOLLOWER), intval(CONTACT_IS_FRIEND));
 891
 892                 $r = q("SELECT id FROM `contact` WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 $sql_extra",
 893                         intval(local_user())
 894                 );
 895
 896                 $ret = array();
 897                 foreach($r as $cid){
 898                         $ret[] = api_get_user($a, $cid['id']);
 899                 }
 900
 901
 902                 return array('$users' => $ret);
 903
 904         }
 905         function api_statuses_friends(&$a, $type){
 906                 $data =  api_statuses_f($a,$type,"friends");
 907                 if ($data===false) return false;
 908                 return  api_apply_template("friends", $type, $data);
 909         }
 910         function api_statuses_followers(&$a, $type){
 911                 $data = api_statuses_f($a,$type,"followers");
 912                 if ($data===false) return false;
 913                 return  api_apply_template("friends", $type, $data);
 914         }
 915         api_register_func('api/statuses/friends','api_statuses_friends',true);
 916         api_register_func('api/statuses/followers','api_statuses_followers',true);
 917
 918
 919
 920
 921
 922
 923         function api_statusnet_config(&$a,$type) {
 924                 $name = $a->config['sitename'];
 925                 $server = $a->get_hostname();
 926                 $logo = $a->get_baseurl() . '/images/friendika-64.png';
 927                 $email = $a->config['admin_email'];
 928                 $closed = (($a->config['register_policy'] == REGISTER_CLOSED) ? 'true' : 'false');
 929                 $private = (($a->config['system']['block_public']) ? 'true' : 'false');
 930                 $textlimit = (string) (($a->config['max_import_size']) ? $a->config['max_import_size'] : 200000);
 931                 if($a->config['api_import_size'])
 932                         $texlimit = string($a->config['api_import_size']);
 933                 $ssl = (($a->config['system']['have_ssl']) ? 'true' : 'false');
 934                 $sslserver = (($ssl === 'true') ? str_replace('http:','https:',$a->get_baseurl()) : '');
 935
 936                 $config = array(
 937                         'site' => array('name' => $name,'server' => $server, 'theme' => 'default', 'path' => '',
 938                                 'logo' => $logo, 'fancy' => 'true', 'language' => 'en', 'email' => $email, 'broughtby' => '',
 939                                 'broughtbyurl' => '', 'timezone' => 'UTC', 'closed' => $closed, 'inviteonly' => 'false',
 940                                 'private' => $private, 'textlimit' => $textlimit, 'sslserver' => $sslserver, 'ssl' => $ssl,
 941                                 'shorturllength' => '30'
 942                         ),
 943                 );
 944
 945                 return api_apply_template('config', $type, array('$config' => $config));
 946
 947         }
 948         api_register_func('api/statusnet/config','api_statusnet_config',false);
 949
 950         function api_statusnet_version(&$a,$type) {
 951
 952                 // liar
 953
 954                 if($type === 'xml') {
 955                         header("Content-type: application/xml");
 956                         echo '<?xml version="1.0" encoding="UTF-8"?>' . "\r\n" . '<version>0.9.7</version>' . "\r\n";
 957                         killme();
 958                 }
 959                 elseif($type === 'json') {
 960                         header("Content-type: application/json");
 961                         echo '"0.9.7"';
 962                         killme();
 963                 }
 964         }
 965         api_register_func('api/statusnet/version','api_statusnet_version',false);
 966
 967
 968         function api_ff_ids(&$a,$type,$qtype) {
 969                 if(! local_user())
 970                         return false;
 971
 972                 if($qtype == 'friends')
 973                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_SHARING), intval(CONTACT_IS_FRIEND));
 974                 if($qtype == 'followers')
 975                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_FOLLOWER), intval(CONTACT_IS_FRIEND));
 976
 977
 978                 $r = q("SELECT id FROM `contact` WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 $sql_extra",
 979                         intval(local_user())
 980                 );
 981
 982                 if(is_array($r)) {
 983                         if($type === 'xml') {
 984                                 header("Content-type: application/xml");
 985                                 echo '<?xml version="1.0" encoding="UTF-8"?>' . "\r\n" . '<ids>' . "\r\n";
 986                                 foreach($r as $rr)
 987                                         echo '<id>' . $rr['id'] . '</id>' . "\r\n";
 988                                 echo '</ids>' . "\r\n";
 989                                 killme();
 990                         }
 991                         elseif($type === 'json') {
 992                                 $ret = array();
 993                                 header("Content-type: application/json");
 994                                 foreach($r as $rr) $ret[] = $rr['id'];
 995                                 echo json_encode($ret);
 996                                 killme();
 997                         }
 998                 }
 999         }
1000
1001         function api_friends_ids(&$a,$type) {
1002                 api_ff_ids($a,$type,'friends');
1003         }
1004         function api_followers_ids(&$a,$type) {
1005                 api_ff_ids($a,$type,'followers');
1006         }
1007         api_register_func('api/friends/ids','api_friends_ids',true);
1008         api_register_func('api/followers/ids','api_followers_ids',true);
1009
1010
1011         function api_direct_messages_new(&$a, $type) {
1012                 if (local_user()===false) return false;
1013
1014                 if (!x($_POST, "text") || !x($_POST,"screen_name")) return;
1015
1016                 $sender = api_get_user($a);
1017
1018                 $r = q("SELECT `id` FROM `contact` WHERE `uid`=%d AND `nick`='%s'",
1019                                 intval(local_user()),
1020                                 dbesc($_POST['screen_name']));
1021
1022                 $recipient = api_get_user($a, $r[0]['id']);
1023
1024
1025                 require_once("include/message.php");
1026                 $sub = ( (strlen($_POST['text'])>10)?substr($_POST['text'],0,10)."...":$_POST['text']);
1027                 $id = send_message($recipient['id'], $_POST['text'], $sub);
1028
1029
1030                 if ($id>-1) {
1031                         $r = q("SELECT * FROM `mail` WHERE id=%d", intval($id));
1032                         $item = $r[0];
1033                         $ret=Array(
1034                                         'id' => $item['id'],
1035                                         'created_at'=> api_date($item['created']),
1036                                         'sender_id'=> $sender['id'] ,
1037                                         'sender_screen_name'=> $sender['screen_name'],
1038                                         'sender'=> $sender,
1039                                         'recipient_id'=> $recipient['id'],
1040                                         'recipient_screen_name'=> $recipient['screen_name'],
1041                                         'recipient'=> $recipient,
1042
1043                                         'text'=> $item['title']."\n".strip_tags(bbcode($item['body'])) ,
1044
1045                         );
1046
1047                 } else {
1048                         $ret = array("error"=>$id);
1049                 }
1050
1051                 $data = Array('$messages'=>$ret);
1052
1053                 switch($type){
1054                         case "atom":
1055                         case "rss":
1056                                 $data = api_rss_extra($a, $data, $user_info);
1057                 }
1058
1059                 return  api_apply_template("direct_messages", $type, $data);
1060
1061         }
1062         api_register_func('api/direct_messages/new','api_direct_messages_new',true);
1063
1064     function api_direct_messages_box(&$a, $type, $box) {
1065                 if (local_user()===false) return false;
1066
1067                 $user_info = api_get_user($a);
1068
1069                 // params
1070                 $count = (x($_GET,'count')?$_GET['count']:20);
1071                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1072                 if ($page<0) $page=0;
1073
1074                 $start = $page*$count;
1075
1076
1077                 if ($box=="sentbox") {
1078                         $sql_extra = "`from-url`='%s'";
1079                 } else {
1080                         $sql_extra = "`from-url`!='%s'";
1081                 }
1082
1083                 $r = q("SELECT * FROM `mail` WHERE uid=%d AND $sql_extra ORDER BY created DESC LIMIT %d,%d",
1084                                 intval(local_user()),
1085                                 dbesc( $a->get_baseurl() . '/profile/' . $a->user['nickname'] ),
1086                                 intval($start), intval($count)
1087                            );
1088
1089                 $ret = Array();
1090                 foreach($r as $item){
1091                         switch ($box){
1092                                 case "inbox":
1093                                         $recipient = $user_info;
1094                                         $sender = api_get_user($a,$item['contact-id']);
1095                                         break;
1096                                 case "sentbox":
1097                                         $recipient = api_get_user($a,$item['contact-id']);
1098                                         $sender = $user_info;
1099                                         break;
1100                         }
1101
1102                         $ret[]=Array(
1103                                 'id' => $item['id'],
1104                                 'created_at'=> api_date($item['created']),
1105                                 'sender_id'=> $sender['id'] ,
1106                                 'sender_screen_name'=> $sender['screen_name'],
1107                                 'sender'=> $sender,
1108                                 'recipient_id'=> $recipient['id'],
1109                                 'recipient_screen_name'=> $recipient['screen_name'],
1110                                 'recipient'=> $recipient,
1111
1112                                 'text'=> $item['title']."\n".strip_tags(bbcode($item['body'])) ,
1113
1114                         );
1115
1116                 }
1117
1118
1119                 $data = array('$messages' => $ret);
1120                 switch($type){
1121                         case "atom":
1122                         case "rss":
1123                                 $data = api_rss_extra($a, $data, $user_info);
1124                 }
1125
1126                 return  api_apply_template("direct_messages", $type, $data);
1127
1128         }
1129
1130         function api_direct_messages_sentbox(&$a, $type){
1131                 return api_direct_messages_box($a, $type, "sentbox");
1132         }
1133         function api_direct_messages_inbox(&$a, $type){
1134                 return api_direct_messages_box($a, $type, "inbox");
1135         }
1136         api_register_func('api/direct_messages/sent','api_direct_messages_sentbox',true);
1137         api_register_func('api/direct_messages','api_direct_messages_inbox',true);
1138
1139
1140
1141         function api_oauth_request_token(&$a, $type){
1142                 try{
1143                         $oauth = new FKOAuth1();
1144                         $r = $oauth->fetch_request_token(OAuthRequest::from_request());
1145                 }catch(Exception $e){
1146                         echo "error=". OAuthUtil::urlencode_rfc3986($e->getMessage()); killme();
1147                 }
1148                 echo "oauth_token=".$r->key."&oauth_secret=".$r->secret;
1149                 killme();
1150         }
1151         function api_oauth_access_token(&$a, $type){
1152                 try{
1153                         $oauth = new FKOAuth1();
1154                         $r = $oauth->fetch_access_token(OAuthRequest::from_request());
1155                 }catch(Exception $e){
1156                         echo "error=". OAuthUtil::urlencode_rfc3986($e->getMessage()); killme();
1157                 }
1158                 echo "oauth_token=".$r->key."&oauth_secret=".$r->secret;
1159                 killme();
1160         }
1161
1162         api_register_func('api/oauth/request_token', 'api_oauth_request_token', false);
1163         api_register_func('api/oauth/access_token', 'api_oauth_access_token', false);
1164
1165