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         require_once("html2plain.php");
   7         /*
   8          * Twitter-Like API
   9          *
  10          */
  11
  12         $API = Array();
  13         $called_api = Null;
  14
  15         function api_date($str){
  16                 //Wed May 23 06:01:13 +0000 2007
  17                 return datetime_convert('UTC', 'UTC', $str, "D M d H:i:s +0000 Y" );
  18         }
  19
  20
  21         function api_register_func($path, $func, $auth=false){
  22                 global $API;
  23                 $API[$path] = array('func'=>$func,
  24                                                         'auth'=>$auth);
  25         }
  26
  27         /**
  28          * Simple HTTP Login
  29          */
  30
  31         function api_login(&$a){
  32                 // login with oauth
  33                 try{
  34                         $oauth = new FKOAuth1();
  35                         list($consumer,$token) = $oauth->verify_request(OAuthRequest::from_request());
  36                         if (!is_null($token)){
  37                                 $oauth->loginUser($token->uid);
  38                                 call_hooks('logged_in', $a->user);
  39                                 return;
  40                         }
  41                         echo __file__.__line__.__function__."<pre>"; var_dump($consumer, $token); die();
  42                 }catch(Exception $e){
  43                         logger(__file__.__line__.__function__."\n".$e);
  44                         //die(__file__.__line__.__function__."<pre>".$e); die();
  45                 }
  46
  47
  48
  49                 // workaround for HTTP-auth in CGI mode
  50                 if(x($_SERVER,'REDIRECT_REMOTE_USER')) {
  51                         $userpass = base64_decode(substr($_SERVER["REDIRECT_REMOTE_USER"],6)) ;
  52                         if(strlen($userpass)) {
  53                                 list($name, $password) = explode(':', $userpass);
  54                                 $_SERVER['PHP_AUTH_USER'] = $name;
  55                                 $_SERVER['PHP_AUTH_PW'] = $password;
  56                         }
  57                 }
  58
  59                 if (!isset($_SERVER['PHP_AUTH_USER'])) {
  60                    logger('API_login: ' . print_r($_SERVER,true), LOGGER_DEBUG);
  61                     header('WWW-Authenticate: Basic realm="Friendica"');
  62                     header('HTTP/1.0 401 Unauthorized');
  63                     die('This api requires login');
  64                 }
  65
  66                 $user = $_SERVER['PHP_AUTH_USER'];
  67                 $encrypted = hash('whirlpool',trim($_SERVER['PHP_AUTH_PW']));
  68
  69
  70                         /**
  71                          *  next code from mod/auth.php. needs better solution
  72                          */
  73
  74                 // process normal login request
  75
  76                 $r = q("SELECT * FROM `user` WHERE ( `email` = '%s' OR `nickname` = '%s' )
  77                         AND `password` = '%s' AND `blocked` = 0 AND `account_expired` = 0 AND `verified` = 1 LIMIT 1",
  78                         dbesc(trim($user)),
  79                         dbesc(trim($user)),
  80                         dbesc($encrypted)
  81                 );
  82                 if(count($r)){
  83                         $record = $r[0];
  84                 } else {
  85                    logger('API_login failure: ' . print_r($_SERVER,true), LOGGER_DEBUG);
  86                     header('WWW-Authenticate: Basic realm="Friendica"');
  87                     header('HTTP/1.0 401 Unauthorized');
  88                     die('This api requires login');
  89                 }
  90
  91                 require_once('include/security.php');
  92                 authenticate_success($record);
  93
  94                 call_hooks('logged_in', $a->user);
  95
  96         }
  97
  98         /**************************
  99          *  MAIN API ENTRY POINT  *
 100          **************************/
 101         function api_call(&$a){
 102                 GLOBAL $API, $called_api;
 103
 104                 // preset
 105                 $type="json";
 106
 107                 foreach ($API as $p=>$info){
 108                         if (strpos($a->query_string, $p)===0){
 109                                 $called_api= explode("/",$p);
 110                                 //unset($_SERVER['PHP_AUTH_USER']);
 111                                 if ($info['auth']===true && local_user()===false) {
 112                                                 api_login($a);
 113                                 }
 114
 115                                 load_contact_links(local_user());
 116
 117                                 logger('API call for ' . $a->user['username'] . ': ' . $a->query_string);
 118                                 logger('API parameters: ' . print_r($_REQUEST,true));
 119                                 $type="json";
 120                                 if (strpos($a->query_string, ".xml")>0) $type="xml";
 121                                 if (strpos($a->query_string, ".json")>0) $type="json";
 122                                 if (strpos($a->query_string, ".rss")>0) $type="rss";
 123                                 if (strpos($a->query_string, ".atom")>0) $type="atom";
 124                                 if (strpos($a->query_string, ".as")>0) $type="as";
 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                                         case "as":
 149                                                 //header ("Content-Type: application/json");
 150                                                 //foreach($r as $rr)
 151                                                 //    return json_encode($rr);
 152                                                 return json_encode($r);
 153                                                 break;
 154
 155                                 }
 156                                 //echo "<pre>"; var_dump($r); die();
 157                         }
 158                 }
 159                 logger('API call not implemented: '.$a->query_string." - ".print_r($_REQUEST,true));
 160                 $r = '<status><error>not implemented</error></status>';
 161                 switch($type){
 162                         case "xml":
 163                                 header ("Content-Type: text/xml");
 164                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 165                                 break;
 166                         case "json":
 167                                 header ("Content-Type: application/json");
 168                             return json_encode(array('error' => 'not implemented'));
 169                                 break;
 170                         case "rss":
 171                                 header ("Content-Type: application/rss+xml");
 172                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 173                                 break;
 174                         case "atom":
 175                                 header ("Content-Type: application/atom+xml");
 176                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 177                                 break;
 178                 }
 179         }
 180
 181         /**
 182          * RSS extra info
 183          */
 184         function api_rss_extra(&$a, $arr, $user_info){
 185                 if (is_null($user_info)) $user_info = api_get_user($a);
 186                 $arr['$user'] = $user_info;
 187                 $arr['$rss'] = array(
 188                         'alternate' => $user_info['url'],
 189                         'self' => $a->get_baseurl(). "/". $a->query_string,
 190                         'base' => $a->get_baseurl(),
 191                         'updated' => api_date(null),
 192                         'atom_updated' => datetime_convert('UTC','UTC','now',ATOM_TIME),
 193                         'language' => $user_info['language'],
 194                         'logo'  => $a->get_baseurl()."/images/friendica-32.png",
 195                 );
 196
 197                 return $arr;
 198         }
 199
 200         /**
 201          * Returns user info array.
 202          */
 203         function api_get_user(&$a, $contact_id = Null){
 204                 global $called_api;
 205                 $user = null;
 206                 $extra_query = "";
 207
 208
 209                 if(!is_null($contact_id)){
 210                         $user=$contact_id;
 211                         $extra_query = "AND `contact`.`id` = %d ";
 212                 }
 213
 214                 if(is_null($user) && x($_GET, 'user_id')) {
 215                         $user = intval($_GET['user_id']);
 216                         $extra_query = "AND `contact`.`id` = %d ";
 217                 }
 218                 if(is_null($user) && x($_GET, 'screen_name')) {
 219                         $user = dbesc($_GET['screen_name']);
 220                         $extra_query = "AND `contact`.`nick` = '%s' ";
 221                         if (local_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(local_user());
 222
 223                 }
 224
 225                 if (is_null($user) && $a->argc > (count($called_api)-1)){
 226                         $argid = count($called_api);
 227                         list($user, $null) = explode(".",$a->argv[$argid]);
 228                         if(is_numeric($user)){
 229                                 $user = intval($user);
 230                                 $extra_query = "AND `contact`.`id` = %d ";
 231                         } else {
 232                                 $user = dbesc($user);
 233                                 $extra_query = "AND `contact`.`nick` = '%s' ";
 234                                 if (local_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(local_user());
 235                         }
 236                 }
 237
 238                 if (! $user) {
 239                         if (local_user()===false) {
 240                                 api_login($a); return False;
 241                         } else {
 242                                 $user = $_SESSION['uid'];
 243                                 $extra_query = "AND `contact`.`uid` = %d AND `contact`.`self` = 1 ";
 244                         }
 245
 246                 }
 247
 248                 logger('api_user: ' . $extra_query . ', user: ' . $user);
 249                 // user info
 250                 $uinfo = q("SELECT *, `contact`.`id` as `cid` FROM `contact`
 251                                 WHERE 1
 252                                 $extra_query",
 253                                 $user
 254                 );
 255                 if (count($uinfo)==0) {
 256                         return False;
 257                 }
 258
 259                 if($uinfo[0]['self']) {
 260                         $usr = q("select * from user where uid = %d limit 1",
 261                                 intval(local_user())
 262                         );
 263                         $profile = q("select * from profile where uid = %d and `is-default` = 1 limit 1",
 264                                 intval(local_user())
 265                         );
 266
 267                         // count public wall messages
 268                         $r = q("SELECT COUNT(`id`) as `count` FROM `item`
 269                                         WHERE  `uid` = %d
 270                                         AND `type`='wall'
 271                                         AND `allow_cid`='' AND `allow_gid`='' AND `deny_cid`='' AND `deny_gid`=''",
 272                                         intval($uinfo[0]['uid'])
 273                         );
 274                         $countitms = $r[0]['count'];
 275                 }
 276                 else {
 277                         $r = q("SELECT COUNT(`id`) as `count` FROM `item`
 278                                         WHERE  `contact-id` = %d
 279                                         AND `allow_cid`='' AND `allow_gid`='' AND `deny_cid`='' AND `deny_gid`=''",
 280                                         intval($uinfo[0]['id'])
 281                         );
 282                         $countitms = $r[0]['count'];
 283                 }
 284
 285                 // count friends
 286                 $r = q("SELECT COUNT(`id`) as `count` FROM `contact`
 287                                 WHERE  `uid` = %d AND `rel` IN ( %d, %d )
 288                                 AND `self`=0 AND `blocked`=0 AND `pending`=0 AND `hidden`=0",
 289                                 intval($uinfo[0]['uid']),
 290                                 intval(CONTACT_IS_SHARING),
 291                                 intval(CONTACT_IS_FRIEND)
 292                 );
 293                 $countfriends = $r[0]['count'];
 294
 295                 $r = q("SELECT COUNT(`id`) as `count` FROM `contact`
 296                                 WHERE  `uid` = %d AND `rel` IN ( %d, %d )
 297                                 AND `self`=0 AND `blocked`=0 AND `pending`=0 AND `hidden`=0",
 298                                 intval($uinfo[0]['uid']),
 299                                 intval(CONTACT_IS_FOLLOWER),
 300                                 intval(CONTACT_IS_FRIEND)
 301                 );
 302                 $countfollowers = $r[0]['count'];
 303
 304                 $r = q("SELECT count(`id`) as `count` FROM item where starred = 1 and uid = %d and deleted = 0",
 305                         intval($uinfo[0]['uid'])
 306                 );
 307                 $starred = $r[0]['count'];
 308
 309
 310                 if(! $uinfo[0]['self']) {
 311                         $countfriends = 0;
 312                         $countfollowers = 0;
 313                         $starred = 0;
 314                 }
 315
 316                 $ret = Array(
 317                         'id' => intval($uinfo[0]['cid']),
 318                         'self' => intval($uinfo[0]['self']),
 319                         'uid' => intval($uinfo[0]['uid']),
 320                         'name' => (($uinfo[0]['name']) ? $uinfo[0]['name'] : $uinfo[0]['nick']),
 321                         'screen_name' => (($uinfo[0]['nick']) ? $uinfo[0]['nick'] : $uinfo[0]['name']),
 322                         'location' => ($usr) ? $usr[0]['default-location'] : '',
 323                         'profile_image_url' => $uinfo[0]['micro'],
 324                         'url' => $uinfo[0]['url'],
 325                         'contact_url' => $a->get_baseurl()."/contacts/".$uinfo[0]['cid'],
 326                         'protected' => false,
 327                         'friends_count' => intval($countfriends),
 328                         'created_at' => api_date($uinfo[0]['name-date']),
 329                         'utc_offset' => "+00:00",
 330                         'time_zone' => 'UTC', //$uinfo[0]['timezone'],
 331                         'geo_enabled' => false,
 332                         'statuses_count' => intval($countitms), #XXX: fix me
 333                         'lang' => 'en', #XXX: fix me
 334                         'description' => (($profile) ? $profile[0]['pdesc'] : ''),
 335                         'followers_count' => intval($countfollowers),
 336                         'favourites_count' => intval($starred),
 337                         'contributors_enabled' => false,
 338                         'follow_request_sent' => true,
 339                         'profile_background_color' => 'cfe8f6',
 340                         'profile_text_color' => '000000',
 341                         'profile_link_color' => 'FF8500',
 342                         'profile_sidebar_fill_color' =>'AD0066',
 343                         'profile_sidebar_border_color' => 'AD0066',
 344                         'profile_background_image_url' => '',
 345                         'profile_background_tile' => false,
 346                         'profile_use_background_image' => false,
 347                         'notifications' => false,
 348                         'following' => '', #XXX: fix me
 349                         'verified' => true, #XXX: fix me
 350                         'status' => array()
 351                 );
 352
 353                 return $ret;
 354
 355         }
 356
 357         function api_item_get_user(&$a, $item) {
 358                 global $usercache;
 359
 360                 // The author is our direct contact, in a conversation with us.
 361                 if(link_compare($item['url'],$item['author-link'])) {
 362                         return api_get_user($a,$item['cid']);
 363                 }
 364                 else {
 365                         // The author may be a contact of ours, but is replying to somebody else.
 366                         // Figure out if we know him/her.
 367                         $normalised = normalise_link((strlen($item['author-link'])) ? $item['author-link'] : $item['url']);
 368             if(($normalised != 'mailbox') && (x($a->contacts[$normalised])))
 369                                 return api_get_user($a,$a->contacts[$normalised]['id']);
 370                 }
 371                 // We don't know this person directly.
 372
 373                 list($nick, $name) = array_map("trim",explode("(",$item['author-name']));
 374                 $name=str_replace(")","",$name);
 375
 376                 if ($name == '')
 377                         $name = $nick;
 378
 379                 if ($nick == '')
 380                         $nick = $name;
 381
 382                 // Generating a random ID
 383                 if (is_null($usercache[$nick]) or !array_key_exists($nick, $usercache))
 384                         $usercache[$nick] = mt_rand(2000000, 2100000);
 385
 386                 $ret = array(
 387                         'id' => $usercache[$nick],
 388                         'name' => $name,
 389                         'screen_name' => $nick,
 390                         'location' => '', //$uinfo[0]['default-location'],
 391                         'description' => '',
 392                         'profile_image_url' => $item['author-avatar'],
 393                         'url' => $item['author-link'],
 394                         'protected' => false,   #
 395                         'followers_count' => 0,
 396                         'friends_count' => 0,
 397                         'created_at' => '',
 398                         'favourites_count' => 0,
 399                         'utc_offset' => 0, #XXX: fix me
 400                         'time_zone' => '', //$uinfo[0]['timezone'],
 401                         'statuses_count' => 0,
 402                         'following' => 1,
 403                         'statusnet_blocking' => false,
 404                         'notifications' => false,
 405                         'uid' => 0,
 406                         'contact_url' => 0,
 407                         'geo_enabled' => false,
 408                         'lang' => 'en', #XXX: fix me
 409                         'contributors_enabled' => false,
 410                         'follow_request_sent' => false,
 411                         'profile_background_color' => 'cfe8f6',
 412                         'profile_text_color' => '000000',
 413                         'profile_link_color' => 'FF8500',
 414                         'profile_sidebar_fill_color' =>'AD0066',
 415                         'profile_sidebar_border_color' => 'AD0066',
 416                         'profile_background_image_url' => '',
 417                         'profile_background_tile' => false,
 418                         'profile_use_background_image' => false,
 419                         'verified' => true, #XXX: fix me
 420                         'followers' => '', #XXX: fix me
 421                         'status' => array()
 422                 );
 423
 424                 return $ret;
 425         }
 426
 427
 428         /**
 429          *  load api $templatename for $type and replace $data array
 430          */
 431         function api_apply_template($templatename, $type, $data){
 432
 433                 $a = get_app();
 434
 435                 switch($type){
 436                         case "atom":
 437                         case "rss":
 438                         case "xml":
 439                                 $data = array_xmlify($data);
 440                                 $tpl = get_markup_template("api_".$templatename."_".$type.".tpl");
 441                                 $ret = replace_macros($tpl, $data);
 442                                 break;
 443                         case "json":
 444                                 $ret = $data;
 445                                 break;
 446                 }
 447                 return $ret;
 448         }
 449
 450         /**
 451          ** TWITTER API
 452          */
 453
 454         /**
 455          * Returns an HTTP 200 OK response code and a representation of the requesting user if authentication was successful;
 456          * returns a 401 status code and an error message if not.
 457          * http://developer.twitter.com/doc/get/account/verify_credentials
 458          */
 459         function api_account_verify_credentials(&$a, $type){
 460                 if (local_user()===false) return false;
 461                 $user_info = api_get_user($a);
 462
 463                 return api_apply_template("user", $type, array('$user' => $user_info));
 464
 465         }
 466         api_register_func('api/account/verify_credentials','api_account_verify_credentials', true);
 467
 468
 469         /**
 470          * get data from $_POST or $_GET
 471          */
 472         function requestdata($k){
 473                 if (isset($_POST[$k])){
 474                         return $_POST[$k];
 475                 }
 476                 if (isset($_GET[$k])){
 477                         return $_GET[$k];
 478                 }
 479                 return null;
 480         }
 481
 482 /*Waitman Gobble Mod*/
 483         function api_statuses_mediap(&$a, $type) {
 484                 if (local_user()===false) {
 485                         logger('api_statuses_update: no user');
 486                         return false;
 487                 }
 488                 $user_info = api_get_user($a);
 489
 490                 $_REQUEST['type'] = 'wall';
 491                 $_REQUEST['profile_uid'] = local_user();
 492                 $_REQUEST['api_source'] = true;
 493                 $txt = urldecode(requestdata('status'));
 494
 495                 require_once('library/HTMLPurifier.auto.php');
 496                 require_once('include/html2bbcode.php');
 497
 498                 if((strpos($txt,'<') !== false) || (strpos($txt,'>') !== false)) {
 499                         $txt = html2bb_video($txt);
 500                         $config = HTMLPurifier_Config::createDefault();
 501                         $config->set('Cache.DefinitionImpl', null);
 502                         $purifier = new HTMLPurifier($config);
 503                         $txt = $purifier->purify($txt);
 504                 }
 505                 $txt = html2bbcode($txt);
 506
 507                 $a->argv[1]=$user_info['screen_name']; //should be set to username?
 508
 509                 $_REQUEST['hush']='yeah'; //tell wall_upload function to return img info instead of echo
 510                 require_once('mod/wall_upload.php');
 511                 $bebop = wall_upload_post($a);
 512
 513                 //now that we have the img url in bbcode we can add it to the status and insert the wall item.
 514                 $_REQUEST['body']=$txt."\n\n".$bebop;
 515                 require_once('mod/item.php');
 516                 item_post($a);
 517
 518                 // this should output the last post (the one we just posted).
 519                 return api_status_show($a,$type);
 520         }
 521         api_register_func('api/statuses/mediap','api_statuses_mediap', true);
 522 /*Waitman Gobble Mod*/
 523
 524
 525         function api_statuses_update(&$a, $type) {
 526                 if (local_user()===false) {
 527                         logger('api_statuses_update: no user');
 528                         return false;
 529                 }
 530                 $user_info = api_get_user($a);
 531
 532                 // convert $_POST array items to the form we use for web posts.
 533
 534                 // logger('api_post: ' . print_r($_POST,true));
 535
 536                 if(requestdata('htmlstatus')) {
 537                         require_once('library/HTMLPurifier.auto.php');
 538                         require_once('include/html2bbcode.php');
 539
 540                         $txt = requestdata('htmlstatus');
 541                         if((strpos($txt,'<') !== false) || (strpos($txt,'>') !== false)) {
 542
 543                                 $txt = html2bb_video($txt);
 544
 545                                 $config = HTMLPurifier_Config::createDefault();
 546                                 $config->set('Cache.DefinitionImpl', null);
 547
 548
 549                                 $purifier = new HTMLPurifier($config);
 550                                 $txt = $purifier->purify($txt);
 551
 552                                 $_REQUEST['body'] = html2bbcode($txt);
 553                         }
 554
 555                 }
 556                 else
 557                         $_REQUEST['body'] = urldecode(requestdata('status'));
 558
 559                 $parent = requestdata('in_reply_to_status_id');
 560                 if(ctype_digit($parent))
 561                         $_REQUEST['parent'] = $parent;
 562                 else
 563                         $_REQUEST['parent_uri'] = $parent;
 564
 565                 if(requestdata('lat') && requestdata('long'))
 566                         $_REQUEST['coord'] = sprintf("%s %s",requestdata('lat'),requestdata('long'));
 567                 $_REQUEST['profile_uid'] = local_user();
 568                 if(requestdata('parent'))
 569                         $_REQUEST['type'] = 'net-comment';
 570                 else {
 571                         $_REQUEST['type'] = 'wall';
 572                         if(x($_FILES,'media')) {
 573                                 // upload the image if we have one
 574                                 $_REQUEST['hush']='yeah'; //tell wall_upload function to return img info instead of echo
 575                                 require_once('mod/wall_upload.php');
 576                                 $media = wall_upload_post($a);
 577                                 if(strlen($media)>0)
 578                                         $_REQUEST['body'] .= "\n\n".$media;
 579                                 }
 580                 }
 581
 582                 // set this so that the item_post() function is quiet and doesn't redirect or emit json
 583
 584                 $_REQUEST['api_source'] = true;
 585
 586                 // call out normal post function
 587
 588                 require_once('mod/item.php');
 589                 item_post($a);
 590
 591                 // this should output the last post (the one we just posted).
 592                 return api_status_show($a,$type);
 593         }
 594         api_register_func('api/statuses/update','api_statuses_update', true);
 595
 596
 597         function api_status_show(&$a, $type){
 598                 $user_info = api_get_user($a);
 599                 // get last public wall message
 600                 $lastwall = q("SELECT `item`.*, `i`.`contact-id` as `reply_uid`, `i`.`nick` as `reply_author`
 601                                 FROM `item`, `contact`,
 602                                         (SELECT `item`.`id`, `item`.`contact-id`, `contact`.`nick` FROM `item`,`contact` WHERE `contact`.`id`=`item`.`contact-id`) as `i`
 603                                 WHERE `item`.`contact-id` = %d
 604                                         AND `i`.`id` = `item`.`parent`
 605                                         AND `contact`.`id`=`item`.`contact-id` AND `contact`.`self`=1
 606                                         AND `type`!='activity'
 607                                         AND `item`.`allow_cid`='' AND `item`.`allow_gid`='' AND `item`.`deny_cid`='' AND `item`.`deny_gid`=''
 608                                 ORDER BY `created` DESC
 609                                 LIMIT 1",
 610                                 intval($user_info['id'])
 611                 );
 612
 613                 if (count($lastwall)>0){
 614                         $lastwall = $lastwall[0];
 615
 616                         $in_reply_to_status_id = '';
 617                         $in_reply_to_user_id = '';
 618                         $in_reply_to_screen_name = '';
 619                         if ($lastwall['parent']!=$lastwall['id']) {
 620                                 $in_reply_to_status_id=$lastwall['parent'];
 621                                 $in_reply_to_user_id = $lastwall['reply_uid'];
 622                                 $in_reply_to_screen_name = $lastwall['reply_author'];
 623                         }
 624                         $status_info = array(
 625                                 'text' => html2plain(bbcode($lastwall['body']), 0),
 626                                 'truncated' => false,
 627                                 'created_at' => api_date($lastwall['created']),
 628                                 'in_reply_to_status_id' => $in_reply_to_status_id,
 629                                 'source' => (($lastwall['app']) ? $lastwall['app'] : 'web'),
 630                                 'id' => $lastwall['contact-id'],
 631                                 'in_reply_to_user_id' => $in_reply_to_user_id,
 632                                 'in_reply_to_screen_name' => $in_reply_to_screen_name,
 633                                 'geo' => '',
 634                                 'favorited' => false,
 635                                 'coordinates' => $lastwall['coord'],
 636                                 'place' => $lastwall['location'],
 637                                 'contributors' => ''
 638                         );
 639                         $status_info['user'] = $user_info;
 640                 }
 641                 return  api_apply_template("status", $type, array('$status' => $status_info));
 642
 643         }
 644
 645
 646
 647
 648
 649         /**
 650          * Returns extended information of a given user, specified by ID or screen name as per the required id parameter.
 651          * The author's most recent status will be returned inline.
 652          * http://developer.twitter.com/doc/get/users/show
 653          */
 654         function api_users_show(&$a, $type){
 655                 $user_info = api_get_user($a);
 656                 // get last public wall message
 657                 $lastwall = q("SELECT `item`.*, `i`.`contact-id` as `reply_uid`, `i`.`nick` as `reply_author`
 658                                 FROM `item`, `contact`,
 659                                         (SELECT `item`.`id`, `item`.`contact-id`, `contact`.`nick` FROM `item`,`contact` WHERE `contact`.`id`=`item`.`contact-id`) as `i`
 660                                 WHERE `item`.`contact-id` = %d
 661                                         AND `i`.`id` = `item`.`parent`
 662                                         AND `contact`.`id`=`item`.`contact-id` AND `contact`.`self`=1
 663                                         AND `type`!='activity'
 664                                         AND `item`.`allow_cid`='' AND `item`.`allow_gid`='' AND `item`.`deny_cid`='' AND `item`.`deny_gid`=''
 665                                 ORDER BY `created` DESC
 666                                 LIMIT 1",
 667                                 intval($user_info['id'])
 668                 );
 669
 670                 if (count($lastwall)>0){
 671                         $lastwall = $lastwall[0];
 672
 673                         $in_reply_to_status_id = '';
 674                         $in_reply_to_user_id = '';
 675                         $in_reply_to_screen_name = '';
 676                         if ($lastwall['parent']!=$lastwall['id']) {
 677                                 $in_reply_to_status_id=$lastwall['parent'];
 678                                 $in_reply_to_user_id = $lastwall['reply_uid'];
 679                                 $in_reply_to_screen_name = $lastwall['reply_author'];
 680                         }
 681                         $user_info['status'] = array(
 682                                 'created_at' => api_date($lastwall['created']),
 683                                 'id' => $lastwall['contact-id'],
 684                                 'text' => html2plain(bbcode($lastwall['body']), 0),
 685                                 'source' => (($lastwall['app']) ? $lastwall['app'] : 'web'),
 686                                 'truncated' => false,
 687                                 'in_reply_to_status_id' => $in_reply_to_status_id,
 688                                 'in_reply_to_user_id' => $in_reply_to_user_id,
 689                                 'favorited' => false,
 690                                 'in_reply_to_screen_name' => $in_reply_to_screen_name,
 691                                 'geo' => '',
 692                                 'coordinates' => $lastwall['coord'],
 693                                 'place' => $lastwall['location'],
 694                                 'contributors' => ''
 695                         );
 696                 }
 697                 return  api_apply_template("user", $type, array('$user' => $user_info));
 698
 699         }
 700         api_register_func('api/users/show','api_users_show');
 701
 702         /**
 703          *
 704          * http://developer.twitter.com/doc/get/statuses/home_timeline
 705          *
 706          * TODO: Optional parameters
 707          * TODO: Add reply info
 708          */
 709         function api_statuses_home_timeline(&$a, $type){
 710                 if (local_user()===false) return false;
 711
 712                 $user_info = api_get_user($a);
 713                 // get last newtork messages
 714
 715
 716                 // params
 717                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
 718                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
 719                 if ($page<0) $page=0;
 720                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 721                 $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
 722                 $exclude_replies = (x($_REQUEST,'exclude_replies')?1:0);
 723                 //$since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 724
 725                 $start = $page*$count;
 726
 727                 //$include_entities = (x($_REQUEST,'include_entities')?$_REQUEST['include_entities']:false);
 728
 729                 $sql_extra = '';
 730                 if ($max_id > 0)
 731                         $sql_extra .= ' AND `item`.`id` <= '.intval($max_id);
 732                 if ($exclude_replies > 0)
 733                         $sql_extra .= ' AND `item`.`parent` = `item`.`id`';
 734
 735                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
 736                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
 737                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
 738                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
 739                         FROM `item`, `contact`
 740                         WHERE `item`.`uid` = %d
 741                         AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
 742                         AND `contact`.`id` = `item`.`contact-id`
 743                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 744                         $sql_extra
 745                         AND `item`.`id`>%d
 746                         ORDER BY `item`.`received` DESC LIMIT %d ,%d ",
 747                         intval($user_info['uid']),
 748                         intval($since_id),
 749                         intval($start), intval($count)
 750                 );
 751
 752                 $ret = api_format_items($r,$user_info);
 753
 754
 755                 $data = array('$statuses' => $ret);
 756                 switch($type){
 757                         case "atom":
 758                         case "rss":
 759                                 $data = api_rss_extra($a, $data, $user_info);
 760                                 break;
 761                         case "as":
 762                                 $as = api_format_as($a, $ret, $user_info);
 763                                 $as['title'] = $a->config['sitename']." Home Timeline";
 764                                 $as['link']['url'] = $a->get_baseurl()."/".$user_info["screen_name"]."/all";
 765                                 return($as);
 766                                 break;
 767                 }
 768
 769                 return  api_apply_template("timeline", $type, $data);
 770         }
 771         api_register_func('api/statuses/home_timeline','api_statuses_home_timeline', true);
 772         api_register_func('api/statuses/friends_timeline','api_statuses_home_timeline', true);
 773
 774         function api_statuses_public_timeline(&$a, $type){
 775                 if (local_user()===false) return false;
 776
 777                 $user_info = api_get_user($a);
 778                 // get last newtork messages
 779
 780
 781                 // params
 782                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
 783                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
 784                 if ($page<0) $page=0;
 785                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 786                 $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
 787                 //$since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 788
 789                 $start = $page*$count;
 790
 791                 //$include_entities = (x($_REQUEST,'include_entities')?$_REQUEST['include_entities']:false);
 792
 793                 if ($max_id > 0)
 794                         $sql_extra = 'AND `item`.`id` <= '.intval($max_id);
 795
 796                 /*$r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
 797                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
 798                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
 799                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
 800                         FROM `item`, `contact`
 801                         WHERE `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
 802                         AND `item`.`allow_cid` = ''  AND `item`.`allow_gid` = ''
 803                         AND `item`.`deny_cid`  = '' AND `item`.`deny_gid`  = ''
 804                         AND `item`.`private` = 0 AND `item`.`wall` = 1 AND `user`.`hidewall` = 0
 805                         AND `contact`.`id` = `item`.`contact-id`
 806                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 807                         $sql_extra
 808                         AND `item`.`id`>%d
 809                         ORDER BY `item`.`received` DESC LIMIT %d ,%d ",
 810                         intval($since_id),
 811                         intval($start), intval($count)
 812                 );*/
 813                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
 814                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
 815                         `contact`.`network`, `contact`.`thumb`, `contact`.`self`, `contact`.`writable`,
 816                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`,
 817                         `user`.`nickname`, `user`.`hidewall`
 818                         FROM `item` LEFT JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
 819                         LEFT JOIN `user` ON `user`.`uid` = `item`.`uid`
 820                         WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
 821                         AND `item`.`allow_cid` = ''  AND `item`.`allow_gid` = ''
 822                         AND `item`.`deny_cid`  = '' AND `item`.`deny_gid`  = ''
 823                         AND `item`.`private` = 0 AND `item`.`wall` = 1 AND `user`.`hidewall` = 0
 824                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 825                         $sql_extra
 826                         AND `item`.`id`>%d
 827                         ORDER BY `received` DESC LIMIT %d, %d ",
 828                         intval($since_id),
 829                         intval($start),
 830                         intval($count));
 831
 832                 $ret = api_format_items($r,$user_info);
 833
 834
 835                 $data = array('$statuses' => $ret);
 836                 switch($type){
 837                         case "atom":
 838                         case "rss":
 839                                 $data = api_rss_extra($a, $data, $user_info);
 840                                 break;
 841                         case "as":
 842                                 $as = api_format_as($a, $ret, $user_info);
 843                                 $as['title'] = $a->config['sitename']." Public Timeline";
 844                                 $as['link']['url'] = $a->get_baseurl()."/";
 845                                 return($as);
 846                                 break;
 847                 }
 848
 849                 return  api_apply_template("timeline", $type, $data);
 850         }
 851         api_register_func('api/statuses/public_timeline','api_statuses_public_timeline', true);
 852
 853         /**
 854          *
 855          */
 856         function api_statuses_show(&$a, $type){
 857                 if (local_user()===false) return false;
 858
 859                 $user_info = api_get_user($a);
 860
 861                 // params
 862                 $id = intval($a->argv[3]);
 863
 864                 logger('API: api_statuses_show: '.$id);
 865
 866                 //$include_entities = (x($_REQUEST,'include_entities')?$_REQUEST['include_entities']:false);
 867
 868                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
 869                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
 870                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
 871                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
 872                         FROM `item`, `contact`
 873                         WHERE `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
 874                         AND `contact`.`id` = `item`.`contact-id`
 875                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 876                         $sql_extra
 877                         AND `item`.`id`=%d",
 878                         intval($id)
 879                 );
 880
 881                 $ret = api_format_items($r,$user_info);
 882
 883                 $data = array('$status' => $ret[0]);
 884                 /*switch($type){
 885                         case "atom":
 886                         case "rss":
 887                                 $data = api_rss_extra($a, $data, $user_info);
 888                 }*/
 889                 return  api_apply_template("status", $type, $data);
 890         }
 891         api_register_func('api/statuses/show','api_statuses_show', true);
 892
 893
 894         /**
 895          *
 896          */
 897         function api_statuses_repeat(&$a, $type){
 898                 if (local_user()===false) return false;
 899
 900                 $user_info = api_get_user($a);
 901
 902                 // params
 903                 $id = intval($a->argv[3]);
 904
 905                 logger('API: api_statuses_repeat: '.$id);
 906
 907                 //$include_entities = (x($_REQUEST,'include_entities')?$_REQUEST['include_entities']:false);
 908
 909                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `contact`.`nick` as `reply_author`,
 910                         `contact`.`name`, `contact`.`photo`, `contact`.`url` as `reply_url`, `contact`.`rel`,
 911                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
 912                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
 913                         FROM `item`, `contact`
 914                         WHERE `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
 915                         AND `contact`.`id` = `item`.`contact-id`
 916                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 917                         $sql_extra
 918                         AND `item`.`id`=%d",
 919                         intval($id)
 920                 );
 921
 922                 if ($r[0]['body'] != "") {
 923                         $_REQUEST['body'] = html_entity_decode("&#x2672; ", ENT_QUOTES, 'UTF-8')."[url=".$r[0]['reply_url']."]".$r[0]['reply_author']."[/url] \n".$r[0]['body'];
 924                         $_REQUEST['profile_uid'] = local_user();
 925                         $_REQUEST['type'] = 'wall';
 926                         $_REQUEST['api_source'] = true;
 927
 928                         require_once('mod/item.php');
 929                         item_post($a);
 930                 }
 931
 932                 if ($type == 'xml')
 933                         $ok = "true";
 934                 else
 935                         $ok = "ok";
 936
 937                 return api_apply_template('test', $type, array('$ok' => $ok));
 938         }
 939         api_register_func('api/statuses/retweet','api_statuses_repeat', true);
 940
 941         /**
 942          *
 943          */
 944         function api_statuses_destroy(&$a, $type){
 945                 if (local_user()===false) return false;
 946
 947                 $user_info = api_get_user($a);
 948
 949                 // params
 950                 $id = intval($a->argv[3]);
 951
 952                 logger('API: api_statuses_destroy: '.$id);
 953
 954                 require_once('include/items.php');
 955                 drop_item($id, false);
 956
 957                 if ($type == 'xml')
 958                         $ok = "true";
 959                 else
 960                         $ok = "ok";
 961
 962                 return api_apply_template('test', $type, array('$ok' => $ok));
 963         }
 964         api_register_func('api/statuses/destroy','api_statuses_destroy', true);
 965
 966         /**
 967          *
 968          * http://developer.twitter.com/doc/get/statuses/mentions
 969          *
 970          */
 971         function api_statuses_mentions(&$a, $type){
 972                 if (local_user()===false) return false;
 973
 974                 $user_info = api_get_user($a);
 975                 // get last newtork messages
 976
 977
 978                 // params
 979                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
 980                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
 981                 if ($page<0) $page=0;
 982                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 983                 $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
 984                 //$since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 985
 986                 $start = $page*$count;
 987
 988                 //$include_entities = (x($_REQUEST,'include_entities')?$_REQUEST['include_entities']:false);
 989
 990                 $myurl = $a->get_baseurl() . '/profile/'. $a->user['nickname'];
 991                 $myurl = substr($myurl,strpos($myurl,'://')+3);
 992                 $myurl = str_replace(array('www.','.'),array('','\\.'),$myurl);
 993                 $diasp_url = str_replace('/profile/','/u/',$myurl);
 994
 995                 if (get_config('system','use_fulltext_engine'))
 996                         $sql_extra .= sprintf(" AND `item`.`parent` IN (SELECT distinct(`parent`) from item where (MATCH(`author-link`) AGAINST ('".'"%s"'."' in boolean mode) or MATCH(`tag`) AGAINST ('".'"%s"'."' in boolean mode) or MATCH(tag) AGAINST ('".'"%s"'."' in boolean mode))) ",
 997                                 dbesc(protect_sprintf($myurl)),
 998                                 dbesc(protect_sprintf($myurl)),
 999                                 dbesc(protect_sprintf($diasp_url))
1000                         );
1001                 else
1002                         $sql_extra .= sprintf(" AND `item`.`parent` IN (SELECT distinct(`parent`) from item where ( `author-link` like '%s' or `tag` like '%s' or tag like '%s' )) ",
1003                                 dbesc(protect_sprintf('%' . $myurl)),
1004                                 dbesc(protect_sprintf('%' . $myurl . ']%')),
1005                                 dbesc(protect_sprintf('%' . $diasp_url . ']%'))
1006                         );
1007
1008                 if ($max_id > 0)
1009                         $sql_extra .= ' AND `item`.`id` <= '.intval($max_id);
1010
1011                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
1012                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1013                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1014                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1015                         FROM `item`, `contact`
1016                         WHERE `item`.`uid` = %d
1017                         AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1018                         AND `contact`.`id` = `item`.`contact-id`
1019                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1020                         $sql_extra
1021                         AND `item`.`id`>%d
1022                         ORDER BY `item`.`received` DESC LIMIT %d ,%d ",
1023                         intval($user_info['uid']),
1024                         intval($since_id),
1025                         intval($start), intval($count)
1026                 );
1027
1028                 $ret = api_format_items($r,$user_info);
1029
1030
1031                 $data = array('$statuses' => $ret);
1032                 switch($type){
1033                         case "atom":
1034                         case "rss":
1035                                 $data = api_rss_extra($a, $data, $user_info);
1036                                 break;
1037                         case "as":
1038                                 $as = api_format_as($a, $ret, $user_info);
1039                                 $as["title"] = $a->config['sitename']." Mentions";
1040                                 $as['link']['url'] = $a->get_baseurl()."/";
1041                                 return($as);
1042                                 break;
1043                 }
1044
1045                 return  api_apply_template("timeline", $type, $data);
1046         }
1047         api_register_func('api/statuses/mentions','api_statuses_mentions', true);
1048         api_register_func('api/statuses/replies','api_statuses_mentions', true);
1049
1050
1051         function api_statuses_user_timeline(&$a, $type){
1052                 if (local_user()===false) return false;
1053
1054                 $user_info = api_get_user($a);
1055                 // get last newtork messages
1056
1057
1058                 logger("api_statuses_user_timeline: local_user: ". local_user() .
1059                            "\nuser_info: ".print_r($user_info, true) .
1060                            "\n_REQUEST:  ".print_r($_REQUEST, true),
1061                            LOGGER_DEBUG);
1062
1063                 // params
1064                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
1065                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1066                 if ($page<0) $page=0;
1067                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1068                 $exclude_replies = (x($_REQUEST,'exclude_replies')?1:0);
1069                 //$since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1070
1071                 $start = $page*$count;
1072
1073                 $sql_extra = '';
1074                 if ($user_info['self']==1) $sql_extra .= " AND `item`.`wall` = 1 ";
1075                 if ($exclude_replies > 0)  $sql_extra .= ' AND `item`.`parent` = `item`.`id`';
1076
1077                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
1078                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1079                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1080                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1081                         FROM `item`, `contact`
1082                         WHERE `item`.`uid` = %d
1083                         AND `item`.`contact-id` = %d
1084                         AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1085                         AND `contact`.`id` = `item`.`contact-id`
1086                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1087                         $sql_extra
1088                         AND `item`.`id`>%d
1089                         ORDER BY `item`.`received` DESC LIMIT %d ,%d ",
1090                         intval(local_user()),
1091                         intval($user_info['id']),
1092                         intval($since_id),
1093                         intval($start), intval($count)
1094                 );
1095
1096                 $ret = api_format_items($r,$user_info);
1097
1098
1099                 $data = array('$statuses' => $ret);
1100                 switch($type){
1101                         case "atom":
1102                         case "rss":
1103                                 $data = api_rss_extra($a, $data, $user_info);
1104                 }
1105
1106                 return  api_apply_template("timeline", $type, $data);
1107         }
1108
1109         api_register_func('api/statuses/user_timeline','api_statuses_user_timeline', true);
1110
1111
1112         function api_favorites(&$a, $type){
1113                 if (local_user()===false) return false;
1114
1115                 $user_info = api_get_user($a);
1116                 // in friendica starred item are private
1117                 // return favorites only for self
1118                 logger('api_favorites: self:' . $user_info['self']);
1119
1120                 if ($user_info['self']==0) {
1121                         $ret = array();
1122                 } else {
1123
1124
1125                         // params
1126                         $count = (x($_GET,'count')?$_GET['count']:20);
1127                         $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1128                         if ($page<0) $page=0;
1129
1130                         $start = $page*$count;
1131
1132                         $r = q("SELECT `item`.*, `item`.`id` AS `item_id`,
1133                                 `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1134                                 `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1135                                 `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1136                                 FROM `item`, `contact`
1137                                 WHERE `item`.`uid` = %d
1138                                 AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1139                                 AND `item`.`starred` = 1
1140                                 AND `contact`.`id` = `item`.`contact-id`
1141                                 AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1142                                 $sql_extra
1143                                 ORDER BY `item`.`received` DESC LIMIT %d ,%d ",
1144                                 intval($user_info['uid']),
1145                                 intval($start), intval($count)
1146                         );
1147
1148                         $ret = api_format_items($r,$user_info);
1149
1150                 }
1151
1152                 $data = array('$statuses' => $ret);
1153                 switch($type){
1154                         case "atom":
1155                         case "rss":
1156                                 $data = api_rss_extra($a, $data, $user_info);
1157                 }
1158
1159                 return  api_apply_template("timeline", $type, $data);
1160         }
1161
1162         api_register_func('api/favorites','api_favorites', true);
1163
1164         function api_format_as($a, $ret, $user_info) {
1165
1166                 $as = array();
1167                 $as['title'] = $a->config['sitename']." Public Timeline";
1168                 $items = array();
1169                 foreach ($ret as $item) {
1170                         $singleitem["actor"]["displayName"] = $item["user"]["name"];
1171                         $singleitem["actor"]["id"] = $item["user"]["contact_url"];
1172                         $avatar[0]["url"] = $item["user"]["profile_image_url"];
1173                         $avatar[0]["rel"] = "avatar";
1174                         $avatar[0]["type"] = "";
1175                         $avatar[0]["width"] = 96;
1176                         $avatar[0]["height"] = 96;
1177                         $avatar[1]["url"] = $item["user"]["profile_image_url"];
1178                         $avatar[1]["rel"] = "avatar";
1179                         $avatar[1]["type"] = "";
1180                         $avatar[1]["width"] = 48;
1181                         $avatar[1]["height"] = 48;
1182                         $avatar[2]["url"] = $item["user"]["profile_image_url"];
1183                         $avatar[2]["rel"] = "avatar";
1184                         $avatar[2]["type"] = "";
1185                         $avatar[2]["width"] = 24;
1186                         $avatar[2]["height"] = 24;
1187                         $singleitem["actor"]["avatarLinks"] = $avatar;
1188
1189                         $singleitem["actor"]["image"]["url"] = $item["user"]["profile_image_url"];
1190                         $singleitem["actor"]["image"]["rel"] = "avatar";
1191                         $singleitem["actor"]["image"]["type"] = "";
1192                         $singleitem["actor"]["image"]["width"] = 96;
1193                         $singleitem["actor"]["image"]["height"] = 96;
1194                         $singleitem["actor"]["type"] = "person";
1195                         $singleitem["actor"]["url"] = $item["person"]["contact_url"];
1196                         $singleitem["actor"]["statusnet:profile_info"]["local_id"] = $item["user"]["id"];
1197                         $singleitem["actor"]["statusnet:profile_info"]["following"] = $item["user"]["following"] ? "true" : "false";
1198                         $singleitem["actor"]["statusnet:profile_info"]["blocking"] = "false";
1199                         $singleitem["actor"]["contact"]["preferredUsername"] = $item["user"]["screen_name"];
1200                         $singleitem["actor"]["contact"]["displayName"] = $item["user"]["name"];
1201                         $singleitem["actor"]["contact"]["addresses"] = "";
1202
1203                         $singleitem["body"] = $item["text"];
1204                         $singleitem["object"]["displayName"] = $item["text"];
1205                         $singleitem["object"]["id"] = $item["url"];
1206                         $singleitem["object"]["type"] = "note";
1207                         $singleitem["object"]["url"] = $item["url"];
1208                         //$singleitem["context"] =;
1209                         $singleitem["postedTime"] = date("c", strtotime($item["published"]));
1210                         $singleitem["provider"]["objectType"] = "service";
1211                         $singleitem["provider"]["displayName"] = "Test";
1212                         $singleitem["provider"]["url"] = "http://test.tld";
1213                         $singleitem["title"] = $item["text"];
1214                         $singleitem["verb"] = "post";
1215                         $singleitem["statusnet:notice_info"]["local_id"] = $item["id"];
1216                                 $singleitem["statusnet:notice_info"]["source"] = $item["source"];
1217                                 $singleitem["statusnet:notice_info"]["favorite"] = "false";
1218                                 $singleitem["statusnet:notice_info"]["repeated"] = "false";
1219                                 //$singleitem["original"] = $item;
1220                                 $items[] = $singleitem;
1221                 }
1222                 $as['items'] = $items;
1223                 $as['link']['url'] = $a->get_baseurl()."/".$user_info["screen_name"]."/all";
1224                 $as['link']['rel'] = "alternate";
1225                 $as['link']['type'] = "text/html";
1226                 return($as);
1227         }
1228
1229         function api_format_items($r,$user_info) {
1230
1231                 //logger('api_format_items: ' . print_r($r,true));
1232
1233                 //logger('api_format_items: ' . print_r($user_info,true));
1234
1235                 $a = get_app();
1236                 $ret = Array();
1237
1238                 foreach($r as $item) {
1239                         localize_item($item);
1240                         $status_user = (($item['cid']==$user_info['id'])?$user_info: api_item_get_user($a,$item));
1241
1242                         if ($item['parent']!=$item['id']) {
1243                                 $r = q("select id from item where parent=%s and id<%s order by id desc limit 1",
1244                                         intval($item['parent']), intval($item['id']));
1245                                 if ($r)
1246                                         $in_reply_to_status_id = $r[0]['id'];
1247                                 else
1248                                         $in_reply_to_status_id = $item['parent'];
1249
1250                                 $r = q("select `item`.`contact-id`, `contact`.nick, `item`.`author-name` from item, contact
1251                                         where `contact`.`id` = `item`.`contact-id` and `item`.id=%d", intval($in_reply_to_status_id));
1252
1253                                 $in_reply_to_screen_name = $r[0]['author-name'];
1254                                 $in_reply_to_user_id = $r[0]['contact-id'];
1255
1256                         } else {
1257                                 $in_reply_to_screen_name = '';
1258                                 $in_reply_to_user_id = 0;
1259                                 $in_reply_to_status_id = 0;
1260                         }
1261
1262                         // Workaround for ostatus messages where the title is identically to the body
1263                         $statusbody = trim(html2plain(bbcode($item['body']), 0));
1264                         $statustitle = trim($item['title']);
1265
1266                         if (($statustitle != '') and (strpos($statusbody, $statustitle) !== false))
1267                                 $statustext = trim($statusbody);
1268                         else
1269                                 $statustext = trim($statustitle."\n\n".$statusbody);
1270
1271                         if (($item["network"] == NETWORK_FEED) and (strlen($statustext)> 1000))
1272                                 $statustext = substr($statustext, 0, 1000)."... \n".$item["plink"];
1273
1274                         $status = array(
1275                                 'text'          => $statustext,
1276                                 'truncated' => False,
1277                                 'created_at'=> api_date($item['created']),
1278                                 'in_reply_to_status_id' => $in_reply_to_status_id,
1279                                 'source'    => (($item['app']) ? $item['app'] : 'web'),
1280                                 'id'            => intval($item['id']),
1281                                 'in_reply_to_user_id' => $in_reply_to_user_id,
1282                                 'in_reply_to_screen_name' => $in_reply_to_screen_name,
1283                                 'geo' => '',
1284                                 'favorited' => $item['starred'] ? true : false,
1285                                 'user' =>  $status_user ,
1286                                 'statusnet_html'                => trim(bbcode($item['body'])),
1287                                 'statusnet_conversation_id'     => $item['parent'],
1288                         );
1289
1290                         // Seesmic doesn't like the following content
1291                         if ($_SERVER['HTTP_USER_AGENT'] != 'Seesmic') {
1292                                 $status2 = array(
1293                                         'updated'   => api_date($item['edited']),
1294                                         'published' => api_date($item['created']),
1295                                         'message_id' => $item['uri'],
1296                                         'url'           => ($item['plink']!=''?$item['plink']:$item['author-link']),
1297                                         'coordinates' => $item['coord'],
1298                                         'place' => $item['location'],
1299                                         'contributors' => '',
1300                                         'annotations'  => '',
1301                                         'entities'  => '',
1302                                         'objecttype' => (($item['object-type']) ? $item['object-type'] : ACTIVITY_OBJ_NOTE),
1303                                         'verb' => (($item['verb']) ? $item['verb'] : ACTIVITY_POST),
1304                                         'self' => $a->get_baseurl()."/api/statuses/show/".$item['id'].".".$type,
1305                                         'edit' => $a->get_baseurl()."/api/statuses/show/".$item['id'].".".$type,
1306                                 );
1307
1308                                 $status = array_merge($status, $status2);
1309                         }
1310
1311                         $ret[]=$status;
1312                 };
1313                 return $ret;
1314         }
1315
1316
1317         function api_account_rate_limit_status(&$a,$type) {
1318
1319                 $hash = array(
1320                           'reset_time_in_seconds' => strtotime('now + 1 hour'),
1321                           'remaining_hits' => (string) 150,
1322                           'hourly_limit' => (string) 150,
1323                           'reset_time' => datetime_convert('UTC','UTC','now + 1 hour',ATOM_TIME),
1324                 );
1325                 if ($type == "xml")
1326                         $hash['resettime_in_seconds'] = $hash['reset_time_in_seconds'];
1327
1328                 return api_apply_template('ratelimit', $type, array('$hash' => $hash));
1329
1330         }
1331         api_register_func('api/account/rate_limit_status','api_account_rate_limit_status',true);
1332
1333         function api_help_test(&$a,$type) {
1334
1335                 if ($type == 'xml')
1336                         $ok = "true";
1337                 else
1338                         $ok = "ok";
1339
1340                 return api_apply_template('test', $type, array('$ok' => $ok));
1341
1342         }
1343         api_register_func('api/help/test','api_help_test',true);
1344
1345         /**
1346          *  https://dev.twitter.com/docs/api/1/get/statuses/friends
1347          *  This function is deprecated by Twitter
1348          *  returns: json, xml
1349          **/
1350         function api_statuses_f(&$a, $type, $qtype) {
1351                 if (local_user()===false) return false;
1352                 $user_info = api_get_user($a);
1353
1354
1355                 // friends and followers only for self
1356                 if ($user_info['self']==0){
1357                         return false;
1358                 }
1359
1360                 if (x($_GET,'cursor') && $_GET['cursor']=='undefined'){
1361                         /* this is to stop Hotot to load friends multiple times
1362                         *  I'm not sure if I'm missing return something or
1363                         *  is a bug in hotot. Workaround, meantime
1364                         */
1365
1366                         /*$ret=Array();
1367                         return array('$users' => $ret);*/
1368                         return false;
1369                 }
1370
1371                 if($qtype == 'friends')
1372                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_SHARING), intval(CONTACT_IS_FRIEND));
1373                 if($qtype == 'followers')
1374                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_FOLLOWER), intval(CONTACT_IS_FRIEND));
1375
1376                 $r = q("SELECT id FROM `contact` WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 $sql_extra",
1377                         intval(local_user())
1378                 );
1379
1380                 $ret = array();
1381                 foreach($r as $cid){
1382                         $ret[] = api_get_user($a, $cid['id']);
1383                 }
1384
1385
1386                 return array('$users' => $ret);
1387
1388         }
1389         function api_statuses_friends(&$a, $type){
1390                 $data =  api_statuses_f($a,$type,"friends");
1391                 if ($data===false) return false;
1392                 return  api_apply_template("friends", $type, $data);
1393         }
1394         function api_statuses_followers(&$a, $type){
1395                 $data = api_statuses_f($a,$type,"followers");
1396                 if ($data===false) return false;
1397                 return  api_apply_template("friends", $type, $data);
1398         }
1399         api_register_func('api/statuses/friends','api_statuses_friends',true);
1400         api_register_func('api/statuses/followers','api_statuses_followers',true);
1401
1402
1403
1404
1405
1406
1407         function api_statusnet_config(&$a,$type) {
1408                 $name = $a->config['sitename'];
1409                 $server = $a->get_hostname();
1410                 $logo = $a->get_baseurl() . '/images/friendica-64.png';
1411                 $email = $a->config['admin_email'];
1412                 $closed = (($a->config['register_policy'] == REGISTER_CLOSED) ? 'true' : 'false');
1413                 $private = (($a->config['system']['block_public']) ? 'true' : 'false');
1414                 $textlimit = (string) (($a->config['max_import_size']) ? $a->config['max_import_size'] : 200000);
1415                 if($a->config['api_import_size'])
1416                         $texlimit = string($a->config['api_import_size']);
1417                 $ssl = (($a->config['system']['have_ssl']) ? 'true' : 'false');
1418                 $sslserver = (($ssl === 'true') ? str_replace('http:','https:',$a->get_baseurl()) : '');
1419
1420                 $config = array(
1421                         'site' => array('name' => $name,'server' => $server, 'theme' => 'default', 'path' => '',
1422                                 'logo' => $logo, 'fancy' => 'true', 'language' => 'en', 'email' => $email, 'broughtby' => '',
1423                                 'broughtbyurl' => '', 'timezone' => 'UTC', 'closed' => $closed, 'inviteonly' => 'false',
1424                                 'private' => $private, 'textlimit' => $textlimit, 'sslserver' => $sslserver, 'ssl' => $ssl,
1425                                 'shorturllength' => '30'
1426                         ),
1427                 );
1428
1429                 return api_apply_template('config', $type, array('$config' => $config));
1430
1431         }
1432         api_register_func('api/statusnet/config','api_statusnet_config',false);
1433
1434         function api_statusnet_version(&$a,$type) {
1435
1436                 // liar
1437
1438                 if($type === 'xml') {
1439                         header("Content-type: application/xml");
1440                         echo '<?xml version="1.0" encoding="UTF-8"?>' . "\r\n" . '<version>0.9.7</version>' . "\r\n";
1441                         killme();
1442                 }
1443                 elseif($type === 'json') {
1444                         header("Content-type: application/json");
1445                         echo '"0.9.7"';
1446                         killme();
1447                 }
1448         }
1449         api_register_func('api/statusnet/version','api_statusnet_version',false);
1450
1451
1452         function api_ff_ids(&$a,$type,$qtype) {
1453                 if(! local_user())
1454                         return false;
1455
1456                 if($qtype == 'friends')
1457                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_SHARING), intval(CONTACT_IS_FRIEND));
1458                 if($qtype == 'followers')
1459                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_FOLLOWER), intval(CONTACT_IS_FRIEND));
1460
1461
1462                 $r = q("SELECT id FROM `contact` WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 $sql_extra",
1463                         intval(local_user())
1464                 );
1465
1466                 if(is_array($r)) {
1467                         if($type === 'xml') {
1468                                 header("Content-type: application/xml");
1469                                 echo '<?xml version="1.0" encoding="UTF-8"?>' . "\r\n" . '<ids>' . "\r\n";
1470                                 foreach($r as $rr)
1471                                         echo '<id>' . $rr['id'] . '</id>' . "\r\n";
1472                                 echo '</ids>' . "\r\n";
1473                                 killme();
1474                         }
1475                         elseif($type === 'json') {
1476                                 $ret = array();
1477                                 header("Content-type: application/json");
1478                                 foreach($r as $rr) $ret[] = $rr['id'];
1479                                 echo json_encode($ret);
1480                                 killme();
1481                         }
1482                 }
1483         }
1484
1485         function api_friends_ids(&$a,$type) {
1486                 api_ff_ids($a,$type,'friends');
1487         }
1488         function api_followers_ids(&$a,$type) {
1489                 api_ff_ids($a,$type,'followers');
1490         }
1491         api_register_func('api/friends/ids','api_friends_ids',true);
1492         api_register_func('api/followers/ids','api_followers_ids',true);
1493
1494
1495         function api_direct_messages_new(&$a, $type) {
1496                 if (local_user()===false) return false;
1497
1498                 if (!x($_POST, "text") || !x($_POST,"screen_name")) return;
1499
1500                 $sender = api_get_user($a);
1501
1502                 $r = q("SELECT `id` FROM `contact` WHERE `uid`=%d AND `nick`='%s'",
1503                                 intval(local_user()),
1504                                 dbesc($_POST['screen_name']));
1505
1506                 $recipient = api_get_user($a, $r[0]['id']);
1507
1508
1509                 require_once("include/message.php");
1510                 $sub = ( (strlen($_POST['text'])>10)?substr($_POST['text'],0,10)."...":$_POST['text']);
1511                 $id = send_message($recipient['id'], $_POST['text'], $sub);
1512
1513
1514                 if ($id>-1) {
1515                         $r = q("SELECT * FROM `mail` WHERE id=%d", intval($id));
1516                         $item = $r[0];
1517                         $ret=Array(
1518                                         'id' => $item['id'],
1519                                         'created_at'=> api_date($item['created']),
1520                                         'sender_id'=> $sender['id'] ,
1521                                         'sender_screen_name'=> $sender['screen_name'],
1522                                         'sender'=> $sender,
1523                                         'recipient_id'=> $recipient['id'],
1524                                         'recipient_screen_name'=> $recipient['screen_name'],
1525                                         'recipient'=> $recipient,
1526
1527                                         'text'=> $item['title']."\n".html2plain(bbcode($item['body']), 0) ,
1528
1529                         );
1530
1531                 } else {
1532                         $ret = array("error"=>$id);
1533                 }
1534
1535                 $data = Array('$messages'=>$ret);
1536
1537                 switch($type){
1538                         case "atom":
1539                         case "rss":
1540                                 $data = api_rss_extra($a, $data, $user_info);
1541                 }
1542
1543                 return  api_apply_template("direct_messages", $type, $data);
1544
1545         }
1546         api_register_func('api/direct_messages/new','api_direct_messages_new',true);
1547
1548     function api_direct_messages_box(&$a, $type, $box) {
1549                 if (local_user()===false) return false;
1550
1551                 $user_info = api_get_user($a);
1552
1553                 // params
1554                 $count = (x($_GET,'count')?$_GET['count']:20);
1555                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1556                 if ($page<0) $page=0;
1557
1558                 $start = $page*$count;
1559
1560
1561                 if ($box=="sentbox") {
1562                         $sql_extra = "`from-url`='%s'";
1563                 } else {
1564                         $sql_extra = "`from-url`!='%s'";
1565                 }
1566
1567                 $r = q("SELECT * FROM `mail` WHERE uid=%d AND $sql_extra ORDER BY created DESC LIMIT %d,%d",
1568                                 intval(local_user()),
1569                                 dbesc( $a->get_baseurl() . '/profile/' . $a->user['nickname'] ),
1570                                 intval($start), intval($count)
1571                            );
1572
1573                 $ret = Array();
1574                 foreach($r as $item){
1575                         switch ($box){
1576                                 case "inbox":
1577                                         $recipient = $user_info;
1578                                         $sender = api_get_user($a,$item['contact-id']);
1579                                         break;
1580                                 case "sentbox":
1581                                         $recipient = api_get_user($a,$item['contact-id']);
1582                                         $sender = $user_info;
1583                                         break;
1584                         }
1585
1586                         $ret[]=Array(
1587                                 'id' => $item['id'],
1588                                 'created_at'=> api_date($item['created']),
1589                                 'sender_id'=> $sender['id'] ,
1590                                 'sender_screen_name'=> $sender['screen_name'],
1591                                 'sender'=> $sender,
1592                                 'recipient_id'=> $recipient['id'],
1593                                 'recipient_screen_name'=> $recipient['screen_name'],
1594                                 'recipient'=> $recipient,
1595
1596                                 'text'=> $item['title']."\n".html2plain(bbcode($item['body']), 0) ,
1597
1598                         );
1599
1600                 }
1601
1602
1603                 $data = array('$messages' => $ret);
1604                 switch($type){
1605                         case "atom":
1606                         case "rss":
1607                                 $data = api_rss_extra($a, $data, $user_info);
1608                 }
1609
1610                 return  api_apply_template("direct_messages", $type, $data);
1611
1612         }
1613
1614         function api_direct_messages_sentbox(&$a, $type){
1615                 return api_direct_messages_box($a, $type, "sentbox");
1616         }
1617         function api_direct_messages_inbox(&$a, $type){
1618                 return api_direct_messages_box($a, $type, "inbox");
1619         }
1620         api_register_func('api/direct_messages/sent','api_direct_messages_sentbox',true);
1621         api_register_func('api/direct_messages','api_direct_messages_inbox',true);
1622
1623
1624
1625         function api_oauth_request_token(&$a, $type){
1626                 try{
1627                         $oauth = new FKOAuth1();
1628                         $r = $oauth->fetch_request_token(OAuthRequest::from_request());
1629                 }catch(Exception $e){
1630                         echo "error=". OAuthUtil::urlencode_rfc3986($e->getMessage()); killme();
1631                 }
1632                 echo $r;
1633                 killme();
1634         }
1635         function api_oauth_access_token(&$a, $type){
1636                 try{
1637                         $oauth = new FKOAuth1();
1638                         $r = $oauth->fetch_access_token(OAuthRequest::from_request());
1639                 }catch(Exception $e){
1640                         echo "error=". OAuthUtil::urlencode_rfc3986($e->getMessage()); killme();
1641                 }
1642                 echo $r;
1643                 killme();
1644         }
1645
1646         api_register_func('api/oauth/request_token', 'api_oauth_request_token', false);
1647         api_register_func('api/oauth/access_token', 'api_oauth_access_token', false);
1648
1649 /*
1650 Not implemented by now:
1651 favorites
1652 favorites/create
1653 favorites/destroy
1654 statuses/retweets_of_me
1655 friendships/create
1656 friendships/destroy
1657 friendships/exists
1658 friendships/show
1659 account/update_location
1660 account/update_profile_background_image
1661 account/update_profile_image
1662 blocks/create
1663 blocks/destroy
1664
1665 Not implemented in status.net:
1666 statuses/retweeted_to_me
1667 statuses/retweeted_by_me
1668 direct_messages/destroy
1669 account/end_session
1670 account/update_delivery_device
1671 notifications/follow
1672 notifications/leave
1673 blocks/exists
1674 blocks/blocking
1675 */