include/api.php

   1 <?php
   2 /* To-Do:
   3  - Automatically detect if incoming data is HTML or BBCode
   4 */
   5         require_once("include/bbcode.php");
   6         require_once("include/datetime.php");
   7         require_once("include/conversation.php");
   8         require_once("include/oauth.php");
   9         require_once("include/html2plain.php");
  10         /*
  11          * Twitter-Like API
  12          *
  13          */
  14
  15         $API = Array();
  16         $called_api = Null;
  17
  18         function api_user() {
  19                 // It is not sufficient to use local_user() to check whether someone is allowed to use the API,
  20                 // because this will open CSRF holes (just embed an image with src=friendicasite.com/api/statuses/update?status=CSRF
  21                 // into a page, and visitors will post something without noticing it).
  22                 // Instead, use this function.
  23                 if ($_SESSION["allow_api"])
  24                         return local_user();
  25
  26                 return false;
  27         }
  28
  29         function api_date($str){
  30                 //Wed May 23 06:01:13 +0000 2007
  31                 return datetime_convert('UTC', 'UTC', $str, "D M d H:i:s +0000 Y" );
  32         }
  33
  34
  35         function api_register_func($path, $func, $auth=false){
  36                 global $API;
  37                 $API[$path] = array('func'=>$func, 'auth'=>$auth);
  38
  39                 // Workaround for hotot
  40                 $path = str_replace("api/", "api/1.1/", $path);
  41                 $API[$path] = array('func'=>$func, 'auth'=>$auth);
  42         }
  43
  44         /**
  45          * Simple HTTP Login
  46          */
  47
  48         function api_login(&$a){
  49                 // login with oauth
  50                 try{
  51                         $oauth = new FKOAuth1();
  52                         list($consumer,$token) = $oauth->verify_request(OAuthRequest::from_request());
  53                         if (!is_null($token)){
  54                                 $oauth->loginUser($token->uid);
  55                                 call_hooks('logged_in', $a->user);
  56                                 return;
  57                         }
  58                         echo __file__.__line__.__function__."<pre>"; var_dump($consumer, $token); die();
  59                 }catch(Exception $e){
  60                         logger(__file__.__line__.__function__."\n".$e);
  61                         //die(__file__.__line__.__function__."<pre>".$e); die();
  62                 }
  63
  64
  65
  66                 // workaround for HTTP-auth in CGI mode
  67                 if(x($_SERVER,'REDIRECT_REMOTE_USER')) {
  68                         $userpass = base64_decode(substr($_SERVER["REDIRECT_REMOTE_USER"],6)) ;
  69                         if(strlen($userpass)) {
  70                                 list($name, $password) = explode(':', $userpass);
  71                                 $_SERVER['PHP_AUTH_USER'] = $name;
  72                                 $_SERVER['PHP_AUTH_PW'] = $password;
  73                         }
  74                 }
  75
  76                 if (!isset($_SERVER['PHP_AUTH_USER'])) {
  77                         logger('API_login: ' . print_r($_SERVER,true), LOGGER_DEBUG);
  78                         header('WWW-Authenticate: Basic realm="Friendica"');
  79                         header('HTTP/1.0 401 Unauthorized');
  80                         die((api_error($a, 'json', "This api requires login")));
  81
  82                         //die('This api requires login');
  83                 }
  84
  85                 $user = $_SERVER['PHP_AUTH_USER'];
  86                 $encrypted = hash('whirlpool',trim($_SERVER['PHP_AUTH_PW']));
  87
  88
  89                 /**
  90                  *  next code from mod/auth.php. needs better solution
  91                  */
  92
  93                 // process normal login request
  94
  95                 $r = q("SELECT * FROM `user` WHERE ( `email` = '%s' OR `nickname` = '%s' )
  96                         AND `password` = '%s' AND `blocked` = 0 AND `account_expired` = 0 AND `account_removed` = 0 AND `verified` = 1 LIMIT 1",
  97                         dbesc(trim($user)),
  98                         dbesc(trim($user)),
  99                         dbesc($encrypted)
 100                 );
 101                 if(count($r)){
 102                         $record = $r[0];
 103                 } else {
 104                         logger('API_login failure: ' . print_r($_SERVER,true), LOGGER_DEBUG);
 105                         header('WWW-Authenticate: Basic realm="Friendica"');
 106                         header('HTTP/1.0 401 Unauthorized');
 107                         die('This api requires login');
 108                 }
 109
 110                 require_once('include/security.php');
 111                 authenticate_success($record); $_SESSION["allow_api"] = true;
 112
 113                 call_hooks('logged_in', $a->user);
 114
 115         }
 116
 117         /**************************
 118          *  MAIN API ENTRY POINT  *
 119          **************************/
 120         function api_call(&$a){
 121                 GLOBAL $API, $called_api;
 122
 123                 // preset
 124                 $type="json";
 125
 126                 foreach ($API as $p=>$info){
 127                         if (strpos($a->query_string, $p)===0){
 128                                 $called_api= explode("/",$p);
 129                                 //unset($_SERVER['PHP_AUTH_USER']);
 130                                 if ($info['auth']===true && api_user()===false) {
 131                                                 api_login($a);
 132                                 }
 133
 134                                 load_contact_links(api_user());
 135
 136                                 logger('API call for ' . $a->user['username'] . ': ' . $a->query_string);
 137                                 logger('API parameters: ' . print_r($_REQUEST,true));
 138                                 $type="json";
 139                                 if (strpos($a->query_string, ".xml")>0) $type="xml";
 140                                 if (strpos($a->query_string, ".json")>0) $type="json";
 141                                 if (strpos($a->query_string, ".rss")>0) $type="rss";
 142                                 if (strpos($a->query_string, ".atom")>0) $type="atom";
 143                                 if (strpos($a->query_string, ".as")>0) $type="as";
 144
 145                                 $r = call_user_func($info['func'], $a, $type);
 146                                 if ($r===false) return;
 147
 148                                 switch($type){
 149                                         case "xml":
 150                                                 $r = mb_convert_encoding($r, "UTF-8",mb_detect_encoding($r));
 151                                                 header ("Content-Type: text/xml");
 152                                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 153                                                 break;
 154                                         case "json":
 155                                                 header ("Content-Type: application/json");
 156                                                 foreach($r as $rr)
 157                                                         return json_encode($rr);
 158                                                 break;
 159                                         case "rss":
 160                                                 header ("Content-Type: application/rss+xml");
 161                                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 162                                                 break;
 163                                         case "atom":
 164                                                 header ("Content-Type: application/atom+xml");
 165                                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 166                                                 break;
 167                                         case "as":
 168                                                 //header ("Content-Type: application/json");
 169                                                 //foreach($r as $rr)
 170                                                 //      return json_encode($rr);
 171                                                 return json_encode($r);
 172                                                 break;
 173
 174                                 }
 175                                 //echo "<pre>"; var_dump($r); die();
 176                         }
 177                 }
 178                 header("HTTP/1.1 404 Not Found");
 179                 logger('API call not implemented: '.$a->query_string." - ".print_r($_REQUEST,true));
 180                 return(api_error($a, $type, "not implemented"));
 181
 182         }
 183
 184         function api_error(&$a, $type, $error) {
 185                 $r = "<status><error>".$error."</error><request>".$a->query_string."</request></status>";
 186                 switch($type){
 187                         case "xml":
 188                                 header ("Content-Type: text/xml");
 189                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 190                                 break;
 191                         case "json":
 192                                 header ("Content-Type: application/json");
 193                                 return json_encode(array('error' => $error, 'request' => $a->query_string));
 194                                 break;
 195                         case "rss":
 196                                 header ("Content-Type: application/rss+xml");
 197                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 198                                 break;
 199                         case "atom":
 200                                 header ("Content-Type: application/atom+xml");
 201                                 return '<?xml version="1.0" encoding="UTF-8"?>'."\n".$r;
 202                                 break;
 203                 }
 204         }
 205
 206         /**
 207          * RSS extra info
 208          */
 209         function api_rss_extra(&$a, $arr, $user_info){
 210                 if (is_null($user_info)) $user_info = api_get_user($a);
 211                 $arr['$user'] = $user_info;
 212                 $arr['$rss'] = array(
 213                         'alternate' => $user_info['url'],
 214                         'self' => $a->get_baseurl(). "/". $a->query_string,
 215                         'base' => $a->get_baseurl(),
 216                         'updated' => api_date(null),
 217                         'atom_updated' => datetime_convert('UTC','UTC','now',ATOM_TIME),
 218                         'language' => $user_info['language'],
 219                         'logo'  => $a->get_baseurl()."/images/friendica-32.png",
 220                 );
 221
 222                 return $arr;
 223         }
 224
 225
 226         /**
 227          * Unique contact to contact url.
 228          */
 229         function api_unique_id_to_url($id){
 230                 $r = q("SELECT url FROM unique_contacts WHERE id=%d LIMIT 1",
 231                         intval($id));
 232                 if ($r)
 233                         return ($r[0]["url"]);
 234                 else
 235                         return false;
 236         }
 237
 238         /**
 239          * Returns user info array.
 240          */
 241         function api_get_user(&$a, $contact_id = Null, $type = "json"){
 242                 global $called_api;
 243                 $user = null;
 244                 $extra_query = "";
 245                 $url = "";
 246                 $nick = "";
 247
 248                 logger("api_get_user: Fetching user data for user ".$contact_id, LOGGER_DEBUG);
 249
 250                 // Searching for contact URL
 251                 if(!is_null($contact_id) AND (intval($contact_id) == 0)){
 252                         $user = dbesc(normalise_link($contact_id));
 253                         $url = $user;
 254                         $extra_query = "AND `contact`.`nurl` = '%s' ";
 255                         if (api_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(api_user());
 256                 }
 257
 258                 // Searching for unique contact id
 259                 if(!is_null($contact_id) AND (intval($contact_id) != 0)){
 260                         $user = dbesc(api_unique_id_to_url($contact_id));
 261
 262                         if ($user == "")
 263                                 die(api_error($a, $type, t("User not found.")));
 264
 265                         $url = $user;
 266                         $extra_query = "AND `contact`.`nurl` = '%s' ";
 267                         if (api_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(api_user());
 268                 }
 269
 270                 if(is_null($user) && x($_GET, 'user_id')) {
 271                         $user = dbesc(api_unique_id_to_url($_GET['user_id']));
 272
 273                         if ($user == "")
 274                                 die(api_error($a, $type, t("User not found.")));
 275
 276                         $url = $user;
 277                         $extra_query = "AND `contact`.`nurl` = '%s' ";
 278                         if (api_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(api_user());
 279                 }
 280                 if(is_null($user) && x($_GET, 'screen_name')) {
 281                         $user = dbesc($_GET['screen_name']);
 282                         $nick = $user;
 283                         $extra_query = "AND `contact`.`nick` = '%s' ";
 284                         if (api_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(api_user());
 285                 }
 286
 287                 if (is_null($user) AND ($a->argc > (count($called_api)-1)) AND (count($called_api) > 0)){
 288                         $argid = count($called_api);
 289                         list($user, $null) = explode(".",$a->argv[$argid]);
 290                         if(is_numeric($user)){
 291                                 $user = dbesc(api_unique_id_to_url($user));
 292
 293                                 if ($user == "")
 294                                         return false;
 295
 296                                 $url = $user;
 297                                 $extra_query = "AND `contact`.`nurl` = '%s' ";
 298                                 if (api_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(api_user());
 299                         } else {
 300                                 $user = dbesc($user);
 301                                 $nick = $user;
 302                                 $extra_query = "AND `contact`.`nick` = '%s' ";
 303                                 if (api_user()!==false)  $extra_query .= "AND `contact`.`uid`=".intval(api_user());
 304                         }
 305                 }
 306
 307                 logger("api_get_user: user ".$user, LOGGER_DEBUG);
 308
 309                 if (!$user) {
 310                         if (api_user()===false) {
 311                                 api_login($a); return False;
 312                         } else {
 313                                 $user = $_SESSION['uid'];
 314                                 $extra_query = "AND `contact`.`uid` = %d AND `contact`.`self` = 1 ";
 315                         }
 316
 317                 }
 318
 319                 logger('api_user: ' . $extra_query . ', user: ' . $user);
 320                 // user info
 321                 $uinfo = q("SELECT *, `contact`.`id` as `cid` FROM `contact`
 322                                 WHERE 1
 323                                 $extra_query",
 324                                 $user
 325                 );
 326
 327                 // Selecting the id by priority, friendica first
 328                 api_best_nickname($uinfo);
 329
 330                 // if the contact wasn't found, fetch it from the unique contacts
 331                 if (count($uinfo)==0) {
 332                         $r = array();
 333
 334                         if ($url != "")
 335                                 $r = q("SELECT * FROM unique_contacts WHERE url='%s' LIMIT 1", $url);
 336                         elseif ($nick != "")
 337                                 $r = q("SELECT * FROM unique_contacts WHERE nick='%s' LIMIT 1", $nick);
 338
 339                         if ($r) {
 340                                 // If no nick where given, extract it from the address
 341                                 if (($r[0]['nick'] == "") OR ($r[0]['name'] == $r[0]['nick']))
 342                                         $r[0]['nick'] = api_get_nick($r[0]["url"]);
 343
 344                                 $ret = array(
 345                                         'id' => $r[0]["id"],
 346                                         'id_str' => (string) $r[0]["id"],
 347                                         'name' => $r[0]["name"],
 348                                         'screen_name' => (($r[0]['nick']) ? $r[0]['nick'] : $r[0]['name']),
 349                                         'location' => NULL,
 350                                         'description' => NULL,
 351                                         'profile_image_url' => $r[0]["avatar"],
 352                                         'profile_image_url_https' => $r[0]["avatar"],
 353                                         'url' => $r[0]["url"],
 354                                         'protected' => false,
 355                                         'followers_count' => 0,
 356                                         'friends_count' => 0,
 357                                         'created_at' => api_date(0),
 358                                         'favourites_count' => 0,
 359                                         'utc_offset' => 0,
 360                                         'time_zone' => 'UTC',
 361                                         'statuses_count' => 0,
 362                                         'following' => false,
 363                                         'verified' => false,
 364                                         'statusnet_blocking' => false,
 365                                         'notifications' => false,
 366                                         'statusnet_profile_url' => $r[0]["url"],
 367                                         'uid' => 0,
 368                                         'cid' => 0,
 369                                         'self' => 0,
 370                                         'network' => '',
 371                                 );
 372
 373                                 return $ret;
 374                         } else
 375                                 die(api_error($a, $type, t("User not found.")));
 376
 377                 }
 378
 379                 if($uinfo[0]['self']) {
 380                         $usr = q("select * from user where uid = %d limit 1",
 381                                 intval(api_user())
 382                         );
 383                         $profile = q("select * from profile where uid = %d and `is-default` = 1 limit 1",
 384                                 intval(api_user())
 385                         );
 386
 387                         //AND `allow_cid`='' AND `allow_gid`='' AND `deny_cid`='' AND `deny_gid`=''",
 388                         // count public wall messages
 389                         $r = q("SELECT count(*) as `count` FROM `item`
 390                                         WHERE  `uid` = %d
 391                                         AND `type`='wall'",
 392                                         intval($uinfo[0]['uid'])
 393                         );
 394                         $countitms = $r[0]['count'];
 395                 }
 396                 else {
 397                         //AND `allow_cid`='' AND `allow_gid`='' AND `deny_cid`='' AND `deny_gid`=''",
 398                         $r = q("SELECT count(*) as `count` FROM `item`
 399                                         WHERE  `contact-id` = %d",
 400                                         intval($uinfo[0]['id'])
 401                         );
 402                         $countitms = $r[0]['count'];
 403                 }
 404
 405                 // count friends
 406                 $r = q("SELECT count(*) as `count` FROM `contact`
 407                                 WHERE  `uid` = %d AND `rel` IN ( %d, %d )
 408                                 AND `self`=0 AND `blocked`=0 AND `pending`=0 AND `hidden`=0",
 409                                 intval($uinfo[0]['uid']),
 410                                 intval(CONTACT_IS_SHARING),
 411                                 intval(CONTACT_IS_FRIEND)
 412                 );
 413                 $countfriends = $r[0]['count'];
 414
 415                 $r = q("SELECT count(*) as `count` FROM `contact`
 416                                 WHERE  `uid` = %d AND `rel` IN ( %d, %d )
 417                                 AND `self`=0 AND `blocked`=0 AND `pending`=0 AND `hidden`=0",
 418                                 intval($uinfo[0]['uid']),
 419                                 intval(CONTACT_IS_FOLLOWER),
 420                                 intval(CONTACT_IS_FRIEND)
 421                 );
 422                 $countfollowers = $r[0]['count'];
 423
 424                 $r = q("SELECT count(*) as `count` FROM item where starred = 1 and uid = %d and deleted = 0",
 425                         intval($uinfo[0]['uid'])
 426                 );
 427                 $starred = $r[0]['count'];
 428
 429
 430                 if(! $uinfo[0]['self']) {
 431                         $countfriends = 0;
 432                         $countfollowers = 0;
 433                         $starred = 0;
 434                 }
 435
 436                 // Add a nick if it isn't present there
 437                 if (($uinfo[0]['nick'] == "") OR ($uinfo[0]['name'] == $uinfo[0]['nick'])) {
 438                         $uinfo[0]['nick'] = api_get_nick($uinfo[0]["url"]);
 439                 }
 440
 441                 // Fetching unique id
 442                 $r = q("SELECT id FROM unique_contacts WHERE url='%s' LIMIT 1", dbesc(normalise_link($uinfo[0]['url'])));
 443
 444                 // If not there, then add it
 445                 if (count($r) == 0) {
 446                         q("INSERT INTO unique_contacts (url, name, nick, avatar) VALUES ('%s', '%s', '%s', '%s')",
 447                                 dbesc(normalise_link($uinfo[0]['url'])), dbesc($uinfo[0]['name']),dbesc($uinfo[0]['nick']), dbesc($uinfo[0]['micro']));
 448
 449                         $r = q("SELECT id FROM unique_contacts WHERE url='%s' LIMIT 1", dbesc(normalise_link($uinfo[0]['url'])));
 450                 }
 451
 452                 require_once('include/contact_selectors.php');
 453                 $network_name = network_to_name($uinfo[0]['network']);
 454
 455                 $ret = Array(
 456                         'id' => intval($r[0]['id']),
 457                         'id_str' => (string) intval($r[0]['id']),
 458                         'name' => (($uinfo[0]['name']) ? $uinfo[0]['name'] : $uinfo[0]['nick']),
 459                         'screen_name' => (($uinfo[0]['nick']) ? $uinfo[0]['nick'] : $uinfo[0]['name']),
 460                         'location' => ($usr) ? $usr[0]['default-location'] : $network_name,
 461                         'description' => (($profile) ? $profile[0]['pdesc'] : NULL),
 462                         'profile_image_url' => $uinfo[0]['micro'],
 463                         'profile_image_url_https' => $uinfo[0]['micro'],
 464                         'url' => $uinfo[0]['url'],
 465                         'protected' => false,
 466                         'followers_count' => intval($countfollowers),
 467                         'friends_count' => intval($countfriends),
 468                         'created_at' => api_date($uinfo[0]['created']),
 469                         'favourites_count' => intval($starred),
 470                         'utc_offset' => "0",
 471                         'time_zone' => 'UTC',
 472                         'statuses_count' => intval($countitms),
 473                         'following' => (($uinfo[0]['rel'] == CONTACT_IS_FOLLOWER) OR ($uinfo[0]['rel'] == CONTACT_IS_FRIEND)),
 474                         'verified' => true,
 475                         'statusnet_blocking' => false,
 476                         'notifications' => false,
 477                         'statusnet_profile_url' => $a->get_baseurl()."/contacts/".$uinfo[0]['cid'],
 478                         'uid' => intval($uinfo[0]['uid']),
 479                         'cid' => intval($uinfo[0]['cid']),
 480                         'self' => $uinfo[0]['self'],
 481                         'network' => $uinfo[0]['network'],
 482                 );
 483
 484                 return $ret;
 485
 486         }
 487
 488         function api_item_get_user(&$a, $item) {
 489
 490                 $author = q("SELECT * FROM unique_contacts WHERE url='%s' LIMIT 1",
 491                         dbesc(normalise_link($item['author-link'])));
 492
 493                 if (count($author) == 0) {
 494                         q("INSERT INTO unique_contacts (url, name, avatar) VALUES ('%s', '%s', '%s')",
 495                         dbesc(normalise_link($item["author-link"])), dbesc($item["author-name"]), dbesc($item["author-avatar"]));
 496
 497                         $author = q("SELECT id FROM unique_contacts WHERE url='%s' LIMIT 1",
 498                                 dbesc(normalise_link($item['author-link'])));
 499                 } else if ($item["author-link"].$item["author-name"] != $author[0]["url"].$author[0]["name"]) {
 500                         q("UPDATE unique_contacts SET name = '%s', avatar = '%s' WHERE url = '%s'",
 501                         dbesc($item["author-name"]), dbesc($item["author-avatar"]), dbesc(normalise_link($item["author-link"])));
 502                 }
 503
 504                 $owner = q("SELECT id FROM unique_contacts WHERE url='%s' LIMIT 1",
 505                         dbesc(normalise_link($item['owner-link'])));
 506
 507                 if (count($owner) == 0) {
 508                         q("INSERT INTO unique_contacts (url, name, avatar) VALUES ('%s', '%s', '%s')",
 509                         dbesc(normalise_link($item["owner-link"])), dbesc($item["owner-name"]), dbesc($item["owner-avatar"]));
 510
 511                         $owner = q("SELECT id FROM unique_contacts WHERE url='%s' LIMIT 1",
 512                                 dbesc(normalise_link($item['owner-link'])));
 513                 } else if ($item["owner-link"].$item["owner-name"] != $owner[0]["url"].$owner[0]["name"]) {
 514                         q("UPDATE unique_contacts SET name = '%s', avatar = '%s' WHERE url = '%s'",
 515                         dbesc($item["owner-name"]), dbesc($item["owner-avatar"]), dbesc(normalise_link($item["owner-link"])));
 516                 }
 517
 518                 // Comments in threads may appear as wall-to-wall postings.
 519                 // So only take the owner at the top posting.
 520                 if ($item["id"] == $item["parent"])
 521                         $status_user = api_get_user($a,$item["owner-link"]);
 522                 else
 523                         $status_user = api_get_user($a,$item["author-link"]);
 524
 525                 $status_user["protected"] = (($item["allow_cid"] != "") OR
 526                                                 ($item["allow_gid"] != "") OR
 527                                                 ($item["deny_cid"] != "") OR
 528                                                 ($item["deny_gid"] != "") OR
 529                                                 $item["private"]);
 530
 531                 return ($status_user);
 532         }
 533
 534
 535         /**
 536          *  load api $templatename for $type and replace $data array
 537          */
 538         function api_apply_template($templatename, $type, $data){
 539
 540                 $a = get_app();
 541
 542                 switch($type){
 543                         case "atom":
 544                         case "rss":
 545                         case "xml":
 546                                 $data = array_xmlify($data);
 547                                 $tpl = get_markup_template("api_".$templatename."_".$type.".tpl");
 548                                 if(! $tpl) {
 549                                         header ("Content-Type: text/xml");
 550                                         echo '<?xml version="1.0" encoding="UTF-8"?>'."\n".'<status><error>not implemented</error></status>';
 551                                         killme();
 552                                 }
 553                                 $ret = replace_macros($tpl, $data);
 554                                 break;
 555                         case "json":
 556                                 $ret = $data;
 557                                 break;
 558                 }
 559
 560                 return $ret;
 561         }
 562
 563         /**
 564          ** TWITTER API
 565          */
 566
 567         /**
 568          * Returns an HTTP 200 OK response code and a representation of the requesting user if authentication was successful;
 569          * returns a 401 status code and an error message if not.
 570          * http://developer.twitter.com/doc/get/account/verify_credentials
 571          */
 572         function api_account_verify_credentials(&$a, $type){
 573                 if (api_user()===false) return false;
 574
 575                 unset($_REQUEST["user_id"]);
 576                 unset($_GET["user_id"]);
 577
 578                 unset($_REQUEST["screen_name"]);
 579                 unset($_GET["screen_name"]);
 580
 581                 $skip_status = (x($_REQUEST,'skip_status')?$_REQUEST['skip_status']:false);
 582
 583                 $user_info = api_get_user($a);
 584
 585                 // "verified" isn't used here in the standard
 586                 unset($user_info["verified"]);
 587
 588                 // - Adding last status
 589                 if (!$skip_status) {
 590                         $user_info["status"] = api_status_show($a,"raw");
 591                         if (!count($user_info["status"]))
 592                                 unset($user_info["status"]);
 593                         else
 594                                 unset($user_info["status"]["user"]);
 595                 }
 596
 597                 // "uid" and "self" are only needed for some internal stuff, so remove it from here
 598                 unset($user_info["uid"]);
 599                 unset($user_info["self"]);
 600
 601                 return api_apply_template("user", $type, array('$user' => $user_info));
 602
 603         }
 604         api_register_func('api/account/verify_credentials','api_account_verify_credentials', true);
 605
 606
 607         /**
 608          * get data from $_POST or $_GET
 609          */
 610         function requestdata($k){
 611                 if (isset($_POST[$k])){
 612                         return $_POST[$k];
 613                 }
 614                 if (isset($_GET[$k])){
 615                         return $_GET[$k];
 616                 }
 617                 return null;
 618         }
 619
 620 /*Waitman Gobble Mod*/
 621         function api_statuses_mediap(&$a, $type) {
 622                 if (api_user()===false) {
 623                         logger('api_statuses_update: no user');
 624                         return false;
 625                 }
 626                 $user_info = api_get_user($a);
 627
 628                 $_REQUEST['type'] = 'wall';
 629                 $_REQUEST['profile_uid'] = api_user();
 630                 $_REQUEST['api_source'] = true;
 631                 $txt = requestdata('status');
 632                 //$txt = urldecode(requestdata('status'));
 633
 634                 require_once('library/HTMLPurifier.auto.php');
 635                 require_once('include/html2bbcode.php');
 636
 637                 if((strpos($txt,'<') !== false) || (strpos($txt,'>') !== false)) {
 638                         $txt = html2bb_video($txt);
 639                         $config = HTMLPurifier_Config::createDefault();
 640                         $config->set('Cache.DefinitionImpl', null);
 641                         $purifier = new HTMLPurifier($config);
 642                         $txt = $purifier->purify($txt);
 643                 }
 644                 $txt = html2bbcode($txt);
 645
 646                 $a->argv[1]=$user_info['screen_name']; //should be set to username?
 647
 648                 $_REQUEST['hush']='yeah'; //tell wall_upload function to return img info instead of echo
 649                 require_once('mod/wall_upload.php');
 650                 $bebop = wall_upload_post($a);
 651
 652                 //now that we have the img url in bbcode we can add it to the status and insert the wall item.
 653                 $_REQUEST['body']=$txt."\n\n".$bebop;
 654                 require_once('mod/item.php');
 655                 item_post($a);
 656
 657                 // this should output the last post (the one we just posted).
 658                 return api_status_show($a,$type);
 659         }
 660         api_register_func('api/statuses/mediap','api_statuses_mediap', true);
 661 /*Waitman Gobble Mod*/
 662
 663
 664         function api_statuses_update(&$a, $type) {
 665                 if (api_user()===false) {
 666                         logger('api_statuses_update: no user');
 667                         return false;
 668                 }
 669                 $user_info = api_get_user($a);
 670
 671                 // convert $_POST array items to the form we use for web posts.
 672
 673                 // logger('api_post: ' . print_r($_POST,true));
 674
 675                 if(requestdata('htmlstatus')) {
 676                         require_once('library/HTMLPurifier.auto.php');
 677                         require_once('include/html2bbcode.php');
 678
 679                         $txt = requestdata('htmlstatus');
 680                         if((strpos($txt,'<') !== false) || (strpos($txt,'>') !== false)) {
 681
 682                                 $txt = html2bb_video($txt);
 683
 684                                 $config = HTMLPurifier_Config::createDefault();
 685                                 $config->set('Cache.DefinitionImpl', null);
 686
 687
 688                                 $purifier = new HTMLPurifier($config);
 689                                 $txt = $purifier->purify($txt);
 690
 691                                 $_REQUEST['body'] = html2bbcode($txt);
 692                         }
 693
 694                 }
 695                 else
 696                         $_REQUEST['body'] = requestdata('status');
 697
 698                 $_REQUEST['title'] = requestdata('title');
 699
 700                 $parent = requestdata('in_reply_to_status_id');
 701                 if(ctype_digit($parent))
 702                         $_REQUEST['parent'] = $parent;
 703                 else
 704                         $_REQUEST['parent_uri'] = $parent;
 705
 706                 if(requestdata('lat') && requestdata('long'))
 707                         $_REQUEST['coord'] = sprintf("%s %s",requestdata('lat'),requestdata('long'));
 708                 $_REQUEST['profile_uid'] = api_user();
 709
 710                 if($parent)
 711                         $_REQUEST['type'] = 'net-comment';
 712                 else {
 713                         $_REQUEST['type'] = 'wall';
 714                         if(x($_FILES,'media')) {
 715                                 // upload the image if we have one
 716                                 $_REQUEST['hush']='yeah'; //tell wall_upload function to return img info instead of echo
 717                                 require_once('mod/wall_upload.php');
 718                                 $media = wall_upload_post($a);
 719                                 if(strlen($media)>0)
 720                                         $_REQUEST['body'] .= "\n\n".$media;
 721                         }
 722                 }
 723
 724                 // set this so that the item_post() function is quiet and doesn't redirect or emit json
 725
 726                 $_REQUEST['api_source'] = true;
 727
 728                 // call out normal post function
 729
 730                 require_once('mod/item.php');
 731                 item_post($a);
 732
 733                 // this should output the last post (the one we just posted).
 734                 return api_status_show($a,$type);
 735         }
 736         api_register_func('api/statuses/update','api_statuses_update', true);
 737         api_register_func('api/statuses/update_with_media','api_statuses_update', true);
 738
 739
 740         function api_status_show(&$a, $type){
 741                 $user_info = api_get_user($a);
 742
 743                 logger('api_status_show: user_info: '.print_r($user_info, true), LOGGER_DEBUG);
 744
 745                 // get last public wall message
 746                 $lastwall = q("SELECT `item`.*, `i`.`contact-id` as `reply_uid`, `i`.`author-link` AS `item-author`
 747                                 FROM `item`, `item` as `i`
 748                                 WHERE `item`.`contact-id` = %d
 749                                         AND ((`item`.`author-link` IN ('%s', '%s')) OR (`item`.`owner-link` IN ('%s', '%s')))
 750                                         AND `i`.`id` = `item`.`parent`
 751                                         AND `item`.`type`!='activity'
 752                                         AND `item`.`allow_cid`='' AND `item`.`allow_gid`='' AND `item`.`deny_cid`='' AND `item`.`deny_gid`=''
 753                                 ORDER BY `item`.`created` DESC
 754                                 LIMIT 1",
 755                                 intval($user_info['cid']),
 756                                 dbesc($user_info['url']),
 757                                 dbesc(normalise_link($user_info['url'])),
 758                                 dbesc($user_info['url']),
 759                                 dbesc(normalise_link($user_info['url']))
 760                 );
 761
 762                 if (count($lastwall)>0){
 763                         $lastwall = $lastwall[0];
 764
 765                         $in_reply_to_status_id = NULL;
 766                         $in_reply_to_user_id = NULL;
 767                         $in_reply_to_status_id_str = NULL;
 768                         $in_reply_to_user_id_str = NULL;
 769                         $in_reply_to_screen_name = NULL;
 770                         if ($lastwall['parent']!=$lastwall['id']) {
 771                                 $in_reply_to_status_id= intval($lastwall['parent']);
 772                                 $in_reply_to_status_id_str = (string) intval($lastwall['parent']);
 773
 774                                 $r = q("SELECT * FROM unique_contacts WHERE `url` = '%s'", dbesc(normalise_link($lastwall['item-author'])));
 775                                 if ($r) {
 776                                         if ($r[0]['nick'] == "")
 777                                                 $r[0]['nick'] = api_get_nick($r[0]["url"]);
 778
 779                                         $in_reply_to_screen_name = (($r[0]['nick']) ? $r[0]['nick'] : $r[0]['name']);
 780                                         $in_reply_to_user_id = intval($r[0]['id']);
 781                                         $in_reply_to_user_id_str = (string) intval($r[0]['id']);
 782                                 }
 783                         }
 784
 785                         $status_info = array(
 786                                 'text' => trim(html2plain(bbcode(api_clean_plain_items($lastwall['body']), false, false, 2, true), 0)),
 787                                 'truncated' => false,
 788                                 'created_at' => api_date($lastwall['created']),
 789                                 'in_reply_to_status_id' => $in_reply_to_status_id,
 790                                 'in_reply_to_status_id_str' => $in_reply_to_status_id_str,
 791                                 'source' => (($lastwall['app']) ? $lastwall['app'] : 'web'),
 792                                 'id' => intval($lastwall['id']),
 793                                 'id_str' => (string) $lastwall['id'],
 794                                 'in_reply_to_user_id' => $in_reply_to_user_id,
 795                                 'in_reply_to_user_id_str' => $in_reply_to_user_id_str,
 796                                 'in_reply_to_screen_name' => $in_reply_to_screen_name,
 797                                 'geo' => NULL,
 798                                 'favorited' => false,
 799                                 // attachments
 800                                 'user' => $user_info,
 801                                 'statusnet_html'                => trim(bbcode($lastwall['body'], false, false)),
 802                                 'statusnet_conversation_id'     => $lastwall['parent'],
 803                         );
 804
 805                         if ($lastwall['title'] != "")
 806                                 $status_info['statusnet_html'] = "<h4>".bbcode($lastwall['title'])."</h4>\n".$status_info['statusnet_html'];
 807
 808                         $entities = api_get_entitities($status_info['text'], $lastwall['body']);
 809                         if (count($entities) > 0)
 810                                 $status_info['entities'] = $entities;
 811
 812                         if (($lastwall['item_network'] != "") AND ($status["source"] == 'web'))
 813                                 $status_info["source"] = network_to_name($lastwall['item_network']);
 814                         elseif (($lastwall['item_network'] != "") AND (network_to_name($lastwall['item_network']) != $status_info["source"]))
 815                                 $status_info["source"] = trim($status_info["source"].' ('.network_to_name($lastwall['item_network']).')');
 816
 817                         // "uid" and "self" are only needed for some internal stuff, so remove it from here
 818                         unset($status_info["user"]["uid"]);
 819                         unset($status_info["user"]["self"]);
 820                 }
 821
 822                 if ($type == "raw")
 823                         return($status_info);
 824
 825                 return  api_apply_template("status", $type, array('$status' => $status_info));
 826
 827         }
 828
 829
 830
 831
 832
 833         /**
 834          * Returns extended information of a given user, specified by ID or screen name as per the required id parameter.
 835          * The author's most recent status will be returned inline.
 836          * http://developer.twitter.com/doc/get/users/show
 837          */
 838         function api_users_show(&$a, $type){
 839                 $user_info = api_get_user($a);
 840
 841                 $lastwall = q("SELECT `item`.*
 842                                 FROM `item`, `contact`
 843                                 WHERE `item`.`uid` = %d AND `verb` = '%s' AND `item`.`contact-id` = %d
 844                                         AND ((`item`.`author-link` IN ('%s', '%s')) OR (`item`.`owner-link` IN ('%s', '%s')))
 845                                         AND `contact`.`id`=`item`.`contact-id`
 846                                         AND `type`!='activity'
 847                                         AND `item`.`allow_cid`='' AND `item`.`allow_gid`='' AND `item`.`deny_cid`='' AND `item`.`deny_gid`=''
 848                                 ORDER BY `created` DESC
 849                                 LIMIT 1",
 850                                 intval(api_user()),
 851                                 dbesc(ACTIVITY_POST),
 852                                 intval($user_info['cid']),
 853                                 dbesc($user_info['url']),
 854                                 dbesc(normalise_link($user_info['url'])),
 855                                 dbesc($user_info['url']),
 856                                 dbesc(normalise_link($user_info['url']))
 857                 );
 858                 if (count($lastwall)>0){
 859                         $lastwall = $lastwall[0];
 860
 861                         $in_reply_to_status_id = NULL;
 862                         $in_reply_to_user_id = NULL;
 863                         $in_reply_to_status_id_str = NULL;
 864                         $in_reply_to_user_id_str = NULL;
 865                         $in_reply_to_screen_name = NULL;
 866                         if ($lastwall['parent']!=$lastwall['id']) {
 867                                 $reply = q("SELECT `item`.`id`, `item`.`contact-id` as `reply_uid`, `contact`.`nick` as `reply_author`, `item`.`author-link` AS `item-author`
 868                                                 FROM `item`,`contact` WHERE `contact`.`id`=`item`.`contact-id` AND `item`.`id` = %d", intval($lastwall['parent']));
 869                                 if (count($reply)>0) {
 870                                         $in_reply_to_status_id = intval($lastwall['parent']);
 871                                         $in_reply_to_status_id_str = (string) intval($lastwall['parent']);
 872
 873                                         $r = q("SELECT * FROM unique_contacts WHERE `url` = '%s'", dbesc(normalise_link($reply[0]['item-author'])));
 874                                         if ($r) {
 875                                                 if ($r[0]['nick'] == "")
 876                                                         $r[0]['nick'] = api_get_nick($r[0]["url"]);
 877
 878                                                 $in_reply_to_screen_name = (($r[0]['nick']) ? $r[0]['nick'] : $r[0]['name']);
 879                                                 $in_reply_to_user_id = intval($r[0]['id']);
 880                                                 $in_reply_to_user_id_str = (string) intval($r[0]['id']);
 881                                         }
 882                                 }
 883                         }
 884                         $user_info['status'] = array(
 885                                 'text' => trim(html2plain(bbcode(api_clean_plain_items($lastwall['body']), false, false, 2, true), 0)),
 886                                 'truncated' => false,
 887                                 'created_at' => api_date($lastwall['created']),
 888                                 'in_reply_to_status_id' => $in_reply_to_status_id,
 889                                 'in_reply_to_status_id_str' => $in_reply_to_status_id_str,
 890                                 'source' => (($lastwall['app']) ? $lastwall['app'] : 'web'),
 891                                 'id' => intval($lastwall['contact-id']),
 892                                 'id_str' => (string) $lastwall['contact-id'],
 893                                 'in_reply_to_user_id' => $in_reply_to_user_id,
 894                                 'in_reply_to_user_id_str' => $in_reply_to_user_id_str,
 895                                 'in_reply_to_screen_name' => $in_reply_to_screen_name,
 896                                 'geo' => NULL,
 897                                 'favorited' => false,
 898                                 'statusnet_html'                => trim(bbcode($lastwall['body'], false, false)),
 899                                 'statusnet_conversation_id'     => $lastwall['parent'],
 900                         );
 901
 902                         if ($lastwall['title'] != "")
 903                                 $user_info['statusnet_html'] = "<h4>".bbcode($lastwall['title'])."</h4>\n".$user_info['statusnet_html'];
 904
 905                         $entities = api_get_entitities($user_info['text'], $lastwall['body']);
 906                         if (count($entities) > 0)
 907                                 $user_info['entities'] = $entities;
 908
 909                         if (($lastwall['item_network'] != "") AND ($user_info["status"]["source"] == 'web'))
 910                                 $user_info["status"]["source"] = network_to_name($lastwall['item_network']);
 911                         if (($lastwall['item_network'] != "") AND (network_to_name($lastwall['item_network']) != $user_info["status"]["source"]))
 912                                 $user_info["status"]["source"] = trim($user_info["status"]["source"].' ('.network_to_name($lastwall['item_network']).')');
 913
 914                 }
 915
 916                 // "uid" and "self" are only needed for some internal stuff, so remove it from here
 917                 unset($user_info["uid"]);
 918                 unset($user_info["self"]);
 919
 920                 return  api_apply_template("user", $type, array('$user' => $user_info));
 921
 922         }
 923         api_register_func('api/users/show','api_users_show');
 924
 925         /**
 926          *
 927          * http://developer.twitter.com/doc/get/statuses/home_timeline
 928          *
 929          * TODO: Optional parameters
 930          * TODO: Add reply info
 931          */
 932         function api_statuses_home_timeline(&$a, $type){
 933                 if (api_user()===false) return false;
 934
 935                 unset($_REQUEST["user_id"]);
 936                 unset($_GET["user_id"]);
 937
 938                 unset($_REQUEST["screen_name"]);
 939                 unset($_GET["screen_name"]);
 940
 941                 $user_info = api_get_user($a);
 942                 // get last newtork messages
 943
 944
 945                 // params
 946                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
 947                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
 948                 if ($page<0) $page=0;
 949                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 950                 $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
 951                 //$since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
 952                 $exclude_replies = (x($_REQUEST,'exclude_replies')?1:0);
 953                 $conversation_id = (x($_REQUEST,'conversation_id')?$_REQUEST['conversation_id']:0);
 954
 955                 $start = $page*$count;
 956
 957                 $sql_extra = '';
 958                 if ($max_id > 0)
 959                         $sql_extra .= ' AND `item`.`id` <= '.intval($max_id);
 960                 if ($exclude_replies > 0)
 961                         $sql_extra .= ' AND `item`.`parent` = `item`.`id`';
 962                 if ($conversation_id > 0)
 963                         $sql_extra .= ' AND `item`.`parent` = '.intval($conversation_id);
 964
 965                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
 966                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
 967                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
 968                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
 969                         FROM `item`, `contact`
 970                         WHERE `item`.`uid` = %d AND `verb` = '%s'
 971                         AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
 972                         AND `contact`.`id` = `item`.`contact-id`
 973                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
 974                         $sql_extra
 975                         AND `item`.`id`>%d
 976                         ORDER BY `item`.`id` DESC LIMIT %d ,%d ",
 977                         intval(api_user()),
 978                         dbesc(ACTIVITY_POST),
 979                         intval($since_id),
 980                         intval($start), intval($count)
 981                 );
 982
 983                 $ret = api_format_items($r,$user_info);
 984
 985                 // We aren't going to try to figure out at the item, group, and page
 986                 // level which items you've seen and which you haven't. If you're looking
 987                 // at the network timeline just mark everything seen.
 988
 989                 $r = q("UPDATE `item` SET `unseen` = 0
 990                         WHERE `unseen` = 1 AND `uid` = %d",
 991                         //intval($user_info['uid'])
 992                         intval(api_user())
 993                 );
 994
 995
 996                 $data = array('$statuses' => $ret);
 997                 switch($type){
 998                         case "atom":
 999                         case "rss":
1000                                 $data = api_rss_extra($a, $data, $user_info);
1001                                 break;
1002                         case "as":
1003                                 $as = api_format_as($a, $ret, $user_info);
1004                                 $as['title'] = $a->config['sitename']." Home Timeline";
1005                                 $as['link']['url'] = $a->get_baseurl()."/".$user_info["screen_name"]."/all";
1006                                 return($as);
1007                                 break;
1008                 }
1009
1010                 return  api_apply_template("timeline", $type, $data);
1011         }
1012         api_register_func('api/statuses/home_timeline','api_statuses_home_timeline', true);
1013         api_register_func('api/statuses/friends_timeline','api_statuses_home_timeline', true);
1014
1015         function api_statuses_public_timeline(&$a, $type){
1016                 if (api_user()===false) return false;
1017
1018                 $user_info = api_get_user($a);
1019                 // get last newtork messages
1020
1021
1022                 // params
1023                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
1024                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1025                 if ($page<0) $page=0;
1026                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1027                 $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
1028                 //$since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1029                 $exclude_replies = (x($_REQUEST,'exclude_replies')?1:0);
1030                 $conversation_id = (x($_REQUEST,'conversation_id')?$_REQUEST['conversation_id']:0);
1031
1032                 $start = $page*$count;
1033
1034                 if ($max_id > 0)
1035                         $sql_extra = 'AND `item`.`id` <= '.intval($max_id);
1036                 if ($exclude_replies > 0)
1037                         $sql_extra .= ' AND `item`.`parent` = `item`.`id`';
1038                 if ($conversation_id > 0)
1039                         $sql_extra .= ' AND `item`.`parent` = '.intval($conversation_id);
1040
1041                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
1042                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1043                         `contact`.`network`, `contact`.`thumb`, `contact`.`self`, `contact`.`writable`,
1044                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`,
1045                         `user`.`nickname`, `user`.`hidewall`
1046                         FROM `item` STRAIGHT_JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
1047                         STRAIGHT_JOIN `user` ON `user`.`uid` = `item`.`uid`
1048                         WHERE `verb` = '%s' AND `item`.`visible` = 1 AND `item`.`deleted` = 0 and `item`.`moderated` = 0
1049                         AND `item`.`allow_cid` = ''  AND `item`.`allow_gid` = ''
1050                         AND `item`.`deny_cid`  = '' AND `item`.`deny_gid`  = ''
1051                         AND `item`.`private` = 0 AND `item`.`wall` = 1 AND `user`.`hidewall` = 0
1052                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1053                         $sql_extra
1054                         AND `item`.`id`>%d
1055                         ORDER BY `item`.`id` DESC LIMIT %d, %d ",
1056                         dbesc(ACTIVITY_POST),
1057                         intval($since_id),
1058                         intval($start),
1059                         intval($count));
1060
1061                 $ret = api_format_items($r,$user_info);
1062
1063
1064                 $data = array('$statuses' => $ret);
1065                 switch($type){
1066                         case "atom":
1067                         case "rss":
1068                                 $data = api_rss_extra($a, $data, $user_info);
1069                                 break;
1070                         case "as":
1071                                 $as = api_format_as($a, $ret, $user_info);
1072                                 $as['title'] = $a->config['sitename']." Public Timeline";
1073                                 $as['link']['url'] = $a->get_baseurl()."/";
1074                                 return($as);
1075                                 break;
1076                 }
1077
1078                 return  api_apply_template("timeline", $type, $data);
1079         }
1080         api_register_func('api/statuses/public_timeline','api_statuses_public_timeline', true);
1081
1082         /**
1083          *
1084          */
1085         function api_statuses_show(&$a, $type){
1086                 if (api_user()===false) return false;
1087
1088                 $user_info = api_get_user($a);
1089
1090                 // params
1091                 $id = intval($a->argv[3]);
1092
1093                 if ($id == 0)
1094                         $id = intval($_REQUEST["id"]);
1095
1096                 // Hotot workaround
1097                 if ($id == 0)
1098                         $id = intval($a->argv[4]);
1099
1100                 logger('API: api_statuses_show: '.$id);
1101
1102                 $conversation = (x($_REQUEST,'conversation')?1:0);
1103
1104                 $sql_extra = '';
1105                 if ($conversation)
1106                         $sql_extra .= " AND `item`.`parent` = %d ORDER BY `received` ASC ";
1107                 else
1108                         $sql_extra .= " AND `item`.`id` = %d";
1109
1110                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
1111                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1112                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1113                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1114                         FROM `item`, `contact`
1115                         WHERE `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1116                         AND `contact`.`id` = `item`.`contact-id`
1117                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1118                         $sql_extra",
1119                         intval($id)
1120                 );
1121
1122                 if (!$r)
1123                         die(api_error($a, $type, t("There is no status with this id.")));
1124
1125                 $ret = api_format_items($r,$user_info);
1126
1127                 if ($conversation) {
1128                         $data = array('$statuses' => $ret);
1129                         return api_apply_template("timeline", $type, $data);
1130                 } else {
1131                         $data = array('$status' => $ret[0]);
1132                         /*switch($type){
1133                                 case "atom":
1134                                 case "rss":
1135                                         $data = api_rss_extra($a, $data, $user_info);
1136                         }*/
1137                         return  api_apply_template("status", $type, $data);
1138                 }
1139         }
1140         api_register_func('api/statuses/show','api_statuses_show', true);
1141
1142
1143         /**
1144          *
1145          */
1146         function api_conversation_show(&$a, $type){
1147                 if (api_user()===false) return false;
1148
1149                 $user_info = api_get_user($a);
1150
1151                 // params
1152                 $id = intval($a->argv[3]);
1153                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
1154                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1155                 if ($page<0) $page=0;
1156                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1157                 $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
1158
1159                 $start = $page*$count;
1160
1161                 if ($id == 0)
1162                         $id = intval($_REQUEST["id"]);
1163
1164                 // Hotot workaround
1165                 if ($id == 0)
1166                         $id = intval($a->argv[4]);
1167
1168                 logger('API: api_conversation_show: '.$id);
1169
1170                 $sql_extra = '';
1171
1172                 if ($max_id > 0)
1173                         $sql_extra = ' AND `item`.`id` <= '.intval($max_id);
1174
1175                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
1176                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1177                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1178                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1179                         FROM `item` INNER JOIN (SELECT `uri`,`parent` FROM `item` WHERE `id` = %d) AS `temp1`
1180                         ON (`item`.`thr-parent` = `temp1`.`uri` AND `item`.`parent` = `temp1`.`parent`), `contact`
1181                         WHERE `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1182                         AND `item`.`uid` = %d AND `item`.`verb` = '%s' AND `contact`.`id` = `item`.`contact-id`
1183                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1184                         AND `item`.`id`>%d $sql_extra
1185                         ORDER BY `item`.`id` DESC LIMIT %d ,%d",
1186                         intval($id), intval(api_user()),
1187                         dbesc(ACTIVITY_POST),
1188                         intval($since_id),
1189                         intval($start), intval($count)
1190                 );
1191
1192                 if (!$r)
1193                         die(api_error($a, $type, t("There is no conversation with this id.")));
1194
1195                 $ret = api_format_items($r,$user_info);
1196
1197                 $data = array('$statuses' => $ret);
1198                 return api_apply_template("timeline", $type, $data);
1199         }
1200         api_register_func('api/conversation/show','api_conversation_show', true);
1201
1202
1203         /**
1204          *
1205          */
1206         function api_statuses_repeat(&$a, $type){
1207                 global $called_api;
1208
1209                 if (api_user()===false) return false;
1210
1211                 $user_info = api_get_user($a);
1212
1213                 // params
1214                 $id = intval($a->argv[3]);
1215
1216                 if ($id == 0)
1217                         $id = intval($_REQUEST["id"]);
1218
1219                 // Hotot workaround
1220                 if ($id == 0)
1221                         $id = intval($a->argv[4]);
1222
1223                 logger('API: api_statuses_repeat: '.$id);
1224
1225                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`, `contact`.`nick` as `reply_author`,
1226                         `contact`.`name`, `contact`.`photo` as `reply_photo`, `contact`.`url` as `reply_url`, `contact`.`rel`,
1227                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1228                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1229                         FROM `item`, `contact`
1230                         WHERE `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1231                         AND `contact`.`id` = `item`.`contact-id`
1232                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1233                         $sql_extra
1234                         AND `item`.`id`=%d",
1235                         intval($id)
1236                 );
1237
1238                 if ($r[0]['body'] != "") {
1239                         if (!intval(get_config('system','old_share'))) {
1240                                 if (strpos($r[0]['body'], "[/share]") !== false) {
1241                                         $pos = strpos($r[0]['body'], "[share");
1242                                         $post = substr($r[0]['body'], $pos);
1243                                 } else {
1244                                         $post = "[share author='".str_replace("'", "&#039;", $r[0]['author-name']).
1245                                                         "' profile='".$r[0]['author-link'].
1246                                                         "' avatar='".$r[0]['author-avatar'].
1247                                                         "' link='".$r[0]['plink']."']";
1248                                         $post .= $r[0]['body'];
1249                                         $post .= "[/share]";
1250                                 }
1251                                 $_REQUEST['body'] = $post;
1252                         } else
1253                                 $_REQUEST['body'] = html_entity_decode("&#x2672; ", ENT_QUOTES, 'UTF-8')."[url=".$r[0]['reply_url']."]".$r[0]['reply_author']."[/url] \n".$r[0]['body'];
1254
1255                         $_REQUEST['profile_uid'] = api_user();
1256                         $_REQUEST['type'] = 'wall';
1257                         $_REQUEST['api_source'] = true;
1258
1259                         require_once('mod/item.php');
1260                         item_post($a);
1261                 }
1262
1263                 // this should output the last post (the one we just posted).
1264                 $called_api = null;
1265                 return(api_status_show($a,$type));
1266         }
1267         api_register_func('api/statuses/retweet','api_statuses_repeat', true);
1268
1269         /**
1270          *
1271          */
1272         function api_statuses_destroy(&$a, $type){
1273                 if (api_user()===false) return false;
1274
1275                 $user_info = api_get_user($a);
1276
1277                 // params
1278                 $id = intval($a->argv[3]);
1279
1280                 if ($id == 0)
1281                         $id = intval($_REQUEST["id"]);
1282
1283                 // Hotot workaround
1284                 if ($id == 0)
1285                         $id = intval($a->argv[4]);
1286
1287                 logger('API: api_statuses_destroy: '.$id);
1288
1289                 $ret = api_statuses_show($a, $type);
1290
1291                 require_once('include/items.php');
1292                 drop_item($id, false);
1293
1294                 return($ret);
1295         }
1296         api_register_func('api/statuses/destroy','api_statuses_destroy', true);
1297
1298         /**
1299          *
1300          * http://developer.twitter.com/doc/get/statuses/mentions
1301          *
1302          */
1303         function api_statuses_mentions(&$a, $type){
1304                 if (api_user()===false) return false;
1305
1306                 unset($_REQUEST["user_id"]);
1307                 unset($_GET["user_id"]);
1308
1309                 unset($_REQUEST["screen_name"]);
1310                 unset($_GET["screen_name"]);
1311
1312                 $user_info = api_get_user($a);
1313                 // get last newtork messages
1314
1315
1316                 // params
1317                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
1318                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1319                 if ($page<0) $page=0;
1320                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1321                 $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
1322                 //$since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1323
1324                 $start = $page*$count;
1325
1326                 // Ugly code - should be changed
1327                 $myurl = $a->get_baseurl() . '/profile/'. $a->user['nickname'];
1328                 $myurl = substr($myurl,strpos($myurl,'://')+3);
1329                 //$myurl = str_replace(array('www.','.'),array('','\\.'),$myurl);
1330                 $myurl = str_replace('www.','',$myurl);
1331                 $diasp_url = str_replace('/profile/','/u/',$myurl);
1332
1333                 if ($max_id > 0)
1334                         $sql_extra = ' AND `item`.`id` <= '.intval($max_id);
1335
1336                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
1337                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1338                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1339                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1340                         FROM `item`, `contact`
1341                         WHERE `item`.`uid` = %d AND `verb` = '%s'
1342                         AND NOT (`item`.`author-link` IN ('https://%s', 'http://%s'))
1343                         AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1344                         AND `contact`.`id` = `item`.`contact-id`
1345                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1346                         AND `item`.`parent` IN (SELECT `iid` from thread where uid = %d AND `mention`)
1347                         $sql_extra
1348                         AND `item`.`id`>%d
1349                         ORDER BY `item`.`id` DESC LIMIT %d ,%d ",
1350                         intval(api_user()),
1351                         dbesc(ACTIVITY_POST),
1352                         dbesc(protect_sprintf($myurl)),
1353                         dbesc(protect_sprintf($myurl)),
1354                         intval(api_user()),
1355                         intval($since_id),
1356                         intval($start), intval($count)
1357                 );
1358
1359                 $ret = api_format_items($r,$user_info);
1360
1361
1362                 $data = array('$statuses' => $ret);
1363                 switch($type){
1364                         case "atom":
1365                         case "rss":
1366                                 $data = api_rss_extra($a, $data, $user_info);
1367                                 break;
1368                         case "as":
1369                                 $as = api_format_as($a, $ret, $user_info);
1370                                 $as["title"] = $a->config['sitename']." Mentions";
1371                                 $as['link']['url'] = $a->get_baseurl()."/";
1372                                 return($as);
1373                                 break;
1374                 }
1375
1376                 return  api_apply_template("timeline", $type, $data);
1377         }
1378         api_register_func('api/statuses/mentions','api_statuses_mentions', true);
1379         api_register_func('api/statuses/replies','api_statuses_mentions', true);
1380
1381
1382         function api_statuses_user_timeline(&$a, $type){
1383                 if (api_user()===false) return false;
1384
1385                 $user_info = api_get_user($a);
1386                 // get last network messages
1387
1388                 logger("api_statuses_user_timeline: api_user: ". api_user() .
1389                            "\nuser_info: ".print_r($user_info, true) .
1390                            "\n_REQUEST:  ".print_r($_REQUEST, true),
1391                            LOGGER_DEBUG);
1392
1393                 // params
1394                 $count = (x($_REQUEST,'count')?$_REQUEST['count']:20);
1395                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1396                 if ($page<0) $page=0;
1397                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1398                 //$since_id = 0;//$since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1399                 $exclude_replies = (x($_REQUEST,'exclude_replies')?1:0);
1400                 $conversation_id = (x($_REQUEST,'conversation_id')?$_REQUEST['conversation_id']:0);
1401
1402                 $start = $page*$count;
1403
1404                 $sql_extra = '';
1405                 if ($user_info['self']==1)
1406                         $sql_extra .= " AND `item`.`wall` = 1 ";
1407
1408                 if ($exclude_replies > 0)
1409                         $sql_extra .= ' AND `item`.`parent` = `item`.`id`';
1410                 if ($conversation_id > 0)
1411                         $sql_extra .= ' AND `item`.`parent` = '.intval($conversation_id);
1412
1413                 $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
1414                         `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1415                         `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1416                         `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1417                         FROM `item`, `contact`
1418                         WHERE `item`.`uid` = %d AND `verb` = '%s'
1419                         AND `item`.`contact-id` = %d
1420                         AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1421                         AND `contact`.`id` = `item`.`contact-id`
1422                         AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1423                         $sql_extra
1424                         AND `item`.`id`>%d
1425                         ORDER BY `item`.`id` DESC LIMIT %d ,%d ",
1426                         intval(api_user()),
1427                         dbesc(ACTIVITY_POST),
1428                         intval($user_info['cid']),
1429                         intval($since_id),
1430                         intval($start), intval($count)
1431                 );
1432
1433                 $ret = api_format_items($r,$user_info, true);
1434
1435                 $data = array('$statuses' => $ret);
1436                 switch($type){
1437                         case "atom":
1438                         case "rss":
1439                                 $data = api_rss_extra($a, $data, $user_info);
1440                 }
1441
1442                 return  api_apply_template("timeline", $type, $data);
1443         }
1444
1445         api_register_func('api/statuses/user_timeline','api_statuses_user_timeline', true);
1446
1447
1448         function api_favorites(&$a, $type){
1449                 global $called_api;
1450
1451                 if (api_user()===false) return false;
1452
1453                 $called_api= array();
1454
1455                 $user_info = api_get_user($a);
1456
1457                 // in friendica starred item are private
1458                 // return favorites only for self
1459                 logger('api_favorites: self:' . $user_info['self']);
1460
1461                 if ($user_info['self']==0) {
1462                         $ret = array();
1463                 } else {
1464                         $sql_extra = "";
1465
1466                         // params
1467                         $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
1468                         $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
1469                         $count = (x($_GET,'count')?$_GET['count']:20);
1470                         $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
1471                         if ($page<0) $page=0;
1472
1473                         $start = $page*$count;
1474
1475                         if ($max_id > 0)
1476                                 $sql_extra .= ' AND `item`.`id` <= '.intval($max_id);
1477
1478                         $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
1479                                 `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
1480                                 `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
1481                                 `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`
1482                                 FROM `item`, `contact`
1483                                 WHERE `item`.`uid` = %d AND `verb` = '%s'
1484                                 AND `item`.`visible` = 1 and `item`.`moderated` = 0 AND `item`.`deleted` = 0
1485                                 AND `item`.`starred` = 1
1486                                 AND `contact`.`id` = `item`.`contact-id`
1487                                 AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
1488                                 $sql_extra
1489                                 AND `item`.`id`>%d
1490                                 ORDER BY `item`.`id` DESC LIMIT %d ,%d ",
1491                                 intval(api_user()),
1492                                 dbesc(ACTIVITY_POST),
1493                                 intval($since_id),
1494                                 intval($start), intval($count)
1495                         );
1496
1497                         $ret = api_format_items($r,$user_info);
1498
1499                 }
1500
1501                 $data = array('$statuses' => $ret);
1502                 switch($type){
1503                         case "atom":
1504                         case "rss":
1505                                 $data = api_rss_extra($a, $data, $user_info);
1506                 }
1507
1508                 return  api_apply_template("timeline", $type, $data);
1509         }
1510
1511         api_register_func('api/favorites','api_favorites', true);
1512
1513         function api_format_as($a, $ret, $user_info) {
1514
1515                 $as = array();
1516                 $as['title'] = $a->config['sitename']." Public Timeline";
1517                 $items = array();
1518                 foreach ($ret as $item) {
1519                         $singleitem["actor"]["displayName"] = $item["user"]["name"];
1520                         $singleitem["actor"]["id"] = $item["user"]["contact_url"];
1521                         $avatar[0]["url"] = $item["user"]["profile_image_url"];
1522                         $avatar[0]["rel"] = "avatar";
1523                         $avatar[0]["type"] = "";
1524                         $avatar[0]["width"] = 96;
1525                         $avatar[0]["height"] = 96;
1526                         $avatar[1]["url"] = $item["user"]["profile_image_url"];
1527                         $avatar[1]["rel"] = "avatar";
1528                         $avatar[1]["type"] = "";
1529                         $avatar[1]["width"] = 48;
1530                         $avatar[1]["height"] = 48;
1531                         $avatar[2]["url"] = $item["user"]["profile_image_url"];
1532                         $avatar[2]["rel"] = "avatar";
1533                         $avatar[2]["type"] = "";
1534                         $avatar[2]["width"] = 24;
1535                         $avatar[2]["height"] = 24;
1536                         $singleitem["actor"]["avatarLinks"] = $avatar;
1537
1538                         $singleitem["actor"]["image"]["url"] = $item["user"]["profile_image_url"];
1539                         $singleitem["actor"]["image"]["rel"] = "avatar";
1540                         $singleitem["actor"]["image"]["type"] = "";
1541                         $singleitem["actor"]["image"]["width"] = 96;
1542                         $singleitem["actor"]["image"]["height"] = 96;
1543                         $singleitem["actor"]["type"] = "person";
1544                         $singleitem["actor"]["url"] = $item["person"]["contact_url"];
1545                         $singleitem["actor"]["statusnet:profile_info"]["local_id"] = $item["user"]["id"];
1546                         $singleitem["actor"]["statusnet:profile_info"]["following"] = $item["user"]["following"] ? "true" : "false";
1547                         $singleitem["actor"]["statusnet:profile_info"]["blocking"] = "false";
1548                         $singleitem["actor"]["contact"]["preferredUsername"] = $item["user"]["screen_name"];
1549                         $singleitem["actor"]["contact"]["displayName"] = $item["user"]["name"];
1550                         $singleitem["actor"]["contact"]["addresses"] = "";
1551
1552                         $singleitem["body"] = $item["text"];
1553                         $singleitem["object"]["displayName"] = $item["text"];
1554                         $singleitem["object"]["id"] = $item["url"];
1555                         $singleitem["object"]["type"] = "note";
1556                         $singleitem["object"]["url"] = $item["url"];
1557                         //$singleitem["context"] =;
1558                         $singleitem["postedTime"] = date("c", strtotime($item["published"]));
1559                         $singleitem["provider"]["objectType"] = "service";
1560                         $singleitem["provider"]["displayName"] = "Test";
1561                         $singleitem["provider"]["url"] = "http://test.tld";
1562                         $singleitem["title"] = $item["text"];
1563                         $singleitem["verb"] = "post";
1564                         $singleitem["statusnet:notice_info"]["local_id"] = $item["id"];
1565                         $singleitem["statusnet:notice_info"]["source"] = $item["source"];
1566                         $singleitem["statusnet:notice_info"]["favorite"] = "false";
1567                         $singleitem["statusnet:notice_info"]["repeated"] = "false";
1568                         //$singleitem["original"] = $item;
1569                         $items[] = $singleitem;
1570                 }
1571                 $as['items'] = $items;
1572                 $as['link']['url'] = $a->get_baseurl()."/".$user_info["screen_name"]."/all";
1573                 $as['link']['rel'] = "alternate";
1574                 $as['link']['type'] = "text/html";
1575                 return($as);
1576         }
1577
1578         function api_format_messages($item, $recipient, $sender) {
1579                 // standard meta information
1580                 $ret=Array(
1581                                 'id'                    => $item['id'],
1582                                 'sender_id'             => $sender['id'] ,
1583                                 'text'                  => "",
1584                                 'recipient_id'          => $recipient['id'],
1585                                 'created_at'            => api_date($item['created']),
1586                                 'sender_screen_name'    => $sender['screen_name'],
1587                                 'recipient_screen_name' => $recipient['screen_name'],
1588                                 'sender'                => $sender,
1589                                 'recipient'             => $recipient,
1590                 );
1591
1592                 // "uid" and "self" are only needed for some internal stuff, so remove it from here
1593                 unset($ret["sender"]["uid"]);
1594                 unset($ret["sender"]["self"]);
1595                 unset($ret["recipient"]["uid"]);
1596                 unset($ret["recipient"]["self"]);
1597
1598                 //don't send title to regular StatusNET requests to avoid confusing these apps
1599                 if (x($_GET, 'getText')) {
1600                         $ret['title'] = $item['title'] ;
1601                         if ($_GET["getText"] == "html") {
1602                                 $ret['text'] = bbcode($item['body'], false, false);
1603                         }
1604                         elseif ($_GET["getText"] == "plain") {
1605                                 //$ret['text'] = html2plain(bbcode($item['body'], false, false, true), 0);
1606                                 $ret['text'] = trim(html2plain(bbcode(api_clean_plain_items($item['body']), false, false, 2, true), 0));
1607                         }
1608                 }
1609                 else {
1610                         $ret['text'] = $item['title']."\n".html2plain(bbcode(api_clean_plain_items($item['body']), false, false, 2, true), 0);
1611                 }
1612                 if (isset($_GET["getUserObjects"]) && $_GET["getUserObjects"] == "false") {
1613                         unset($ret['sender']);
1614                         unset($ret['recipient']);
1615                 }
1616
1617                 return $ret;
1618         }
1619
1620         function api_get_entitities($text, $bbcode) {
1621                 /*
1622                 To-Do:
1623                 * Links at the first character of the post
1624                 * different sizes of pictures
1625                 * caching picture data (using the id for that?) (See privacy_image_cache)
1626                 */
1627
1628                 $include_entities = strtolower(x($_REQUEST,'include_entities')?$_REQUEST['include_entities']:"false");
1629
1630                 if ($include_entities != "true")
1631                         return array();
1632
1633                 $bbcode = bb_CleanPictureLinks($bbcode);
1634
1635                 // Change pure links in text to bbcode uris
1636                 $bbcode = preg_replace("/([^\]\='".'"'."]|^)(https?\:\/\/[a-zA-Z0-9\:\/\-\?\&\;\.\=\_\~\#\%\$\!\+\,]+)/ism", '$1[url=$2]$2[/url]', $bbcode);
1637
1638                 $entities = array();
1639                 $entities["hashtags"] = array();
1640                 $entities["symbols"] = array();
1641                 $entities["urls"] = array();
1642                 $entities["user_mentions"] = array();
1643
1644                 $URLSearchString = "^\[\]";
1645
1646                 $bbcode = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",'#$2',$bbcode);
1647
1648                 $bbcode = preg_replace("/\[bookmark\=([$URLSearchString]*)\](.*?)\[\/bookmark\]/ism",'[url=$1]$2[/url]',$bbcode);
1649                 //$bbcode = preg_replace("/\[url\](.*?)\[\/url\]/ism",'[url=$1]$1[/url]',$bbcode);
1650                 $bbcode = preg_replace("/\[video\](.*?)\[\/video\]/ism",'[url=$1]$1[/url]',$bbcode);
1651
1652                 $bbcode = preg_replace("/\[youtube\]([A-Za-z0-9\-_=]+)(.*?)\[\/youtube\]/ism",
1653                                         '[url=https://www.youtube.com/watch?v=$1]https://www.youtube.com/watch?v=$1[/url]', $bbcode);
1654                 $bbcode = preg_replace("/\[youtube\](.*?)\[\/youtube\]/ism",'[url=$1]$1[/url]',$bbcode);
1655
1656                 $bbcode = preg_replace("/\[vimeo\]([0-9]+)(.*?)\[\/vimeo\]/ism",
1657                                         '[url=https://vimeo.com/$1]https://vimeo.com/$1[/url]', $bbcode);
1658                 $bbcode = preg_replace("/\[vimeo\](.*?)\[\/vimeo\]/ism",'[url=$1]$1[/url]',$bbcode);
1659
1660                 $bbcode = preg_replace("/\[img\=([0-9]*)x([0-9]*)\](.*?)\[\/img\]/ism", '[img]$3[/img]', $bbcode);
1661
1662                 //preg_match_all("/\[url\]([$URLSearchString]*)\[\/url\]/ism", $bbcode, $urls1);
1663                 preg_match_all("/\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism", $bbcode, $urls);
1664
1665                 $ordered_urls = array();
1666                 foreach ($urls[1] AS $id=>$url) {
1667                         //$start = strpos($text, $url, $offset);
1668                         $start = iconv_strpos($text, $url, 0, "UTF-8");
1669                         if (!($start === false))
1670                                 $ordered_urls[$start] = array("url" => $url, "title" => $urls[2][$id]);
1671                 }
1672
1673                 ksort($ordered_urls);
1674
1675                 $offset = 0;
1676                 //foreach ($urls[1] AS $id=>$url) {
1677                 foreach ($ordered_urls AS $url) {
1678                         if ((substr($url["title"], 0, 7) != "http://") AND (substr($url["title"], 0, 8) != "https://") AND
1679                                 !strpos($url["title"], "http://") AND !strpos($url["title"], "https://"))
1680                                 $display_url = $url["title"];
1681                         else {
1682                                 $display_url = str_replace(array("http://www.", "https://www."), array("", ""), $url["url"]);
1683                                 $display_url = str_replace(array("http://", "https://"), array("", ""), $display_url);
1684
1685                                 if (strlen($display_url) > 26)
1686                                         $display_url = substr($display_url, 0, 25)."…";
1687                         }
1688
1689                         //$start = strpos($text, $url, $offset);
1690                         $start = iconv_strpos($text, $url["url"], $offset, "UTF-8");
1691                         if (!($start === false)) {
1692                                 $entities["urls"][] = array("url" => $url["url"],
1693                                                                 "expanded_url" => $url["url"],
1694                                                                 "display_url" => $display_url,
1695                                                                 "indices" => array($start, $start+strlen($url["url"])));
1696                                 $offset = $start + 1;
1697                         }
1698                 }
1699
1700                 preg_match_all("/\[img](.*?)\[\/img\]/ism", $bbcode, $images);
1701                 $ordered_images = array();
1702                 foreach ($images[1] AS $image) {
1703                         //$start = strpos($text, $url, $offset);
1704                         $start = iconv_strpos($text, $image, 0, "UTF-8");
1705                         if (!($start === false))
1706                                 $ordered_images[$start] = $image;
1707                 }
1708                 //$entities["media"] = array();
1709                 $offset = 0;
1710
1711                 foreach ($ordered_images AS $url) {
1712                         $display_url = str_replace(array("http://www.", "https://www."), array("", ""), $url);
1713                         $display_url = str_replace(array("http://", "https://"), array("", ""), $display_url);
1714
1715                         if (strlen($display_url) > 26)
1716                                 $display_url = substr($display_url, 0, 25)."…";
1717
1718                         $start = iconv_strpos($text, $url, $offset, "UTF-8");
1719                         if (!($start === false)) {
1720                                 $redirects = 0;
1721                                 $img_str = fetch_url($url,true, $redirects, 10);
1722                                 $image = @imagecreatefromstring($img_str);
1723                                 if ($image) {
1724                                         $entities["media"][] = array(
1725                                                                 "id" => $start+1,
1726                                                                 "id_str" => (string)$start+1,
1727                                                                 "indices" => array($start, $start+strlen($url)),
1728                                                                 "media_url" => $url,
1729                                                                 "media_url_https" => $url,
1730                                                                 "url" => $url,
1731                                                                 "display_url" => $display_url,
1732                                                                 "expanded_url" => $url,
1733                                                                 "type" => "photo",
1734                                                                 "sizes" => array("medium" => array(
1735                                                                                                 "w" => imagesx($image),
1736                                                                                                 "h" => imagesy($image),
1737                                                                                                 "resize" => "fit")));
1738                                 }
1739                                 $offset = $start + 1;
1740                         }
1741                 }
1742
1743                 return($entities);
1744         }
1745
1746         function api_format_items($r,$user_info, $filter_user = false) {
1747
1748                 $a = get_app();
1749                 $ret = Array();
1750
1751                 foreach($r as $item) {
1752                         api_share_as_retweet($a, api_user(), $item);
1753
1754                         localize_item($item);
1755                         $status_user = api_item_get_user($a,$item);
1756
1757                         // Look if the posts are matching if they should be filtered by user id
1758                         if ($filter_user AND ($status_user["id"] != $user_info["id"]))
1759                                 continue;
1760
1761                         if ($item['thr-parent'] != $item['uri']) {
1762                                 $r = q("SELECT id FROM item WHERE uid=%d AND uri='%s' LIMIT 1",
1763                                         intval(api_user()),
1764                                         dbesc($item['thr-parent']));
1765                                 if ($r)
1766                                         $in_reply_to_status_id = intval($r[0]['id']);
1767                                 else
1768                                         $in_reply_to_status_id = intval($item['parent']);
1769
1770                                 $in_reply_to_status_id_str = (string) intval($item['parent']);
1771
1772                                 $in_reply_to_screen_name = NULL;
1773                                 $in_reply_to_user_id = NULL;
1774                                 $in_reply_to_user_id_str = NULL;
1775
1776                                 $r = q("SELECT `author-link` FROM item WHERE uid=%d AND id=%d LIMIT 1",
1777                                         intval(api_user()),
1778                                         intval($in_reply_to_status_id));
1779                                 if ($r) {
1780                                         $r = q("SELECT * FROM unique_contacts WHERE `url` = '%s'", dbesc(normalise_link($r[0]['author-link'])));
1781
1782                                         if ($r) {
1783                                                 if ($r[0]['nick'] == "")
1784                                                         $r[0]['nick'] = api_get_nick($r[0]["url"]);
1785
1786                                                 $in_reply_to_screen_name = (($r[0]['nick']) ? $r[0]['nick'] : $r[0]['name']);
1787                                                 $in_reply_to_user_id = intval($r[0]['id']);
1788                                                 $in_reply_to_user_id_str = (string) intval($r[0]['id']);
1789                                         }
1790                                 }
1791                         } else {
1792                                 $in_reply_to_screen_name = NULL;
1793                                 $in_reply_to_user_id = NULL;
1794                                 $in_reply_to_status_id = NULL;
1795                                 $in_reply_to_user_id_str = NULL;
1796                                 $in_reply_to_status_id_str = NULL;
1797                         }
1798
1799                         // Workaround for ostatus messages where the title is identically to the body
1800                         //$statusbody = trim(html2plain(bbcode(api_clean_plain_items($item['body']), false, false, 5, true), 0));
1801                         $html = bbcode(api_clean_plain_items($item['body']), false, false, 2, true);
1802                         $statusbody = trim(html2plain($html, 0));
1803
1804                         $statustitle = trim($item['title']);
1805
1806                         if (($statustitle != '') and (strpos($statusbody, $statustitle) !== false))
1807                                 $statustext = trim($statusbody);
1808                         else
1809                                 $statustext = trim($statustitle."\n\n".$statusbody);
1810
1811                         if (($item["network"] == NETWORK_FEED) and (strlen($statustext)> 1000))
1812                                 $statustext = substr($statustext, 0, 1000)."... \n".$item["plink"];
1813
1814                         $status = array(
1815                                 'text'          => $statustext,
1816                                 'truncated' => False,
1817                                 'created_at'=> api_date($item['created']),
1818                                 'in_reply_to_status_id' => $in_reply_to_status_id,
1819                                 'in_reply_to_status_id_str' => $in_reply_to_status_id_str,
1820                                 'source'    => (($item['app']) ? $item['app'] : 'web'),
1821                                 'id'            => intval($item['id']),
1822                                 'id_str'        => (string) intval($item['id']),
1823                                 'in_reply_to_user_id' => $in_reply_to_user_id,
1824                                 'in_reply_to_user_id_str' => $in_reply_to_user_id_str,
1825                                 'in_reply_to_screen_name' => $in_reply_to_screen_name,
1826                                 'geo' => NULL,
1827                                 'favorited' => $item['starred'] ? true : false,
1828                                 //'attachments' => array(),
1829                                 'user' =>  $status_user ,
1830                                 //'entities' => NULL,
1831                                 'statusnet_html'                => trim(bbcode($item['body'], false, false)),
1832                                 'statusnet_conversation_id'     => $item['parent'],
1833                         );
1834
1835                         if ($item['title'] != "")
1836                                 $status['statusnet_html'] = "<h4>".bbcode($item['title'])."</h4>\n".$status['statusnet_html'];
1837
1838                         $entities = api_get_entitities($status['text'], $item['body']);
1839                         if (count($entities) > 0)
1840                                 $status['entities'] = $entities;
1841
1842                         if (($item['item_network'] != "") AND ($status["source"] == 'web'))
1843                                 $status["source"] = network_to_name($item['item_network']);
1844                         else if (($item['item_network'] != "") AND (network_to_name($item['item_network']) != $status["source"]))
1845                                 $status["source"] = trim($status["source"].' ('.network_to_name($item['item_network']).')');
1846
1847
1848                         // Retweets are only valid for top postings
1849                         // It doesn't work reliable with the link if its a feed
1850                         $IsRetweet = ($item['owner-link'] != $item['author-link']);
1851                         if ($IsRetweet)
1852                                 $IsRetweet = (($item['owner-name'] != $item['author-name']) OR ($item['owner-avatar'] != $item['author-avatar']));
1853
1854                         if ($IsRetweet AND ($item["id"] == $item["parent"])) {
1855                                 $retweeted_status = $status;
1856                                 $retweeted_status["user"] = api_get_user($a,$item["author-link"]);
1857
1858                                 $status["retweeted_status"] = $retweeted_status;
1859                         }
1860
1861                         // "uid" and "self" are only needed for some internal stuff, so remove it from here
1862                         unset($status["user"]["uid"]);
1863                         unset($status["user"]["self"]);
1864
1865                         // 'geo' => array('type' => 'Point',
1866                         //                   'coordinates' => array((float) $notice->lat,
1867                         //                                          (float) $notice->lon));
1868
1869                         $ret[] = $status;
1870                 };
1871                 return $ret;
1872         }
1873
1874
1875         function api_account_rate_limit_status(&$a,$type) {
1876
1877                 $hash = array(
1878                           'reset_time_in_seconds' => strtotime('now + 1 hour'),
1879                           'remaining_hits' => (string) 150,
1880                           'hourly_limit' => (string) 150,
1881                           'reset_time' => api_date(datetime_convert('UTC','UTC','now + 1 hour',ATOM_TIME)),
1882                 );
1883                 if ($type == "xml")
1884                         $hash['resettime_in_seconds'] = $hash['reset_time_in_seconds'];
1885
1886                 return api_apply_template('ratelimit', $type, array('$hash' => $hash));
1887
1888         }
1889         api_register_func('api/account/rate_limit_status','api_account_rate_limit_status',true);
1890
1891         function api_help_test(&$a,$type) {
1892
1893                 if ($type == 'xml')
1894                         $ok = "true";
1895                 else
1896                         $ok = "ok";
1897
1898                 return api_apply_template('test', $type, array("$ok" => $ok));
1899
1900         }
1901         api_register_func('api/help/test','api_help_test',false);
1902
1903         function api_lists(&$a,$type) {
1904
1905                 $ret = array();
1906                 return array($ret);
1907         }
1908         api_register_func('api/lists','api_lists',true);
1909
1910         function api_lists_list(&$a,$type) {
1911
1912                 $ret = array();
1913                 return array($ret);
1914         }
1915         api_register_func('api/lists/list','api_lists_list',true);
1916
1917         /**
1918          *  https://dev.twitter.com/docs/api/1/get/statuses/friends
1919          *  This function is deprecated by Twitter
1920          *  returns: json, xml
1921          **/
1922         function api_statuses_f(&$a, $type, $qtype) {
1923                 if (api_user()===false) return false;
1924                 $user_info = api_get_user($a);
1925
1926                 if (x($_GET,'cursor') && $_GET['cursor']=='undefined'){
1927                         /* this is to stop Hotot to load friends multiple times
1928                         *  I'm not sure if I'm missing return something or
1929                         *  is a bug in hotot. Workaround, meantime
1930                         */
1931
1932                         /*$ret=Array();
1933                         return array('$users' => $ret);*/
1934                         return false;
1935                 }
1936
1937                 if($qtype == 'friends')
1938                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_SHARING), intval(CONTACT_IS_FRIEND));
1939                 if($qtype == 'followers')
1940                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_FOLLOWER), intval(CONTACT_IS_FRIEND));
1941
1942                 // friends and followers only for self
1943                 if ($user_info['self'] == 0)
1944                         $sql_extra = " AND false ";
1945
1946                 $r = q("SELECT `nurl` FROM `contact` WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 $sql_extra",
1947                         intval(api_user())
1948                 );
1949
1950                 $ret = array();
1951                 foreach($r as $cid){
1952                         $user = api_get_user($a, $cid['nurl']);
1953                         // "uid" and "self" are only needed for some internal stuff, so remove it from here
1954                         unset($user["uid"]);
1955                         unset($user["self"]);
1956
1957                         if ($user)
1958                                 $ret[] = $user;
1959                 }
1960
1961                 return array('$users' => $ret);
1962
1963         }
1964         function api_statuses_friends(&$a, $type){
1965                 $data =  api_statuses_f($a,$type,"friends");
1966                 if ($data===false) return false;
1967                 return  api_apply_template("friends", $type, $data);
1968         }
1969         function api_statuses_followers(&$a, $type){
1970                 $data = api_statuses_f($a,$type,"followers");
1971                 if ($data===false) return false;
1972                 return  api_apply_template("friends", $type, $data);
1973         }
1974         api_register_func('api/statuses/friends','api_statuses_friends',true);
1975         api_register_func('api/statuses/followers','api_statuses_followers',true);
1976
1977
1978
1979
1980
1981
1982         function api_statusnet_config(&$a,$type) {
1983                 $name = $a->config['sitename'];
1984                 $server = $a->get_hostname();
1985                 $logo = $a->get_baseurl() . '/images/friendica-64.png';
1986                 $email = $a->config['admin_email'];
1987                 $closed = (($a->config['register_policy'] == REGISTER_CLOSED) ? 'true' : 'false');
1988                 $private = (($a->config['system']['block_public']) ? 'true' : 'false');
1989                 $textlimit = (string) (($a->config['max_import_size']) ? $a->config['max_import_size'] : 200000);
1990                 if($a->config['api_import_size'])
1991                         $texlimit = string($a->config['api_import_size']);
1992                 $ssl = (($a->config['system']['have_ssl']) ? 'true' : 'false');
1993                 $sslserver = (($ssl === 'true') ? str_replace('http:','https:',$a->get_baseurl()) : '');
1994
1995                 $config = array(
1996                         'site' => array('name' => $name,'server' => $server, 'theme' => 'default', 'path' => '',
1997                                 'logo' => $logo, 'fancy' => true, 'language' => 'en', 'email' => $email, 'broughtby' => '',
1998                                 'broughtbyurl' => '', 'timezone' => 'UTC', 'closed' => $closed, 'inviteonly' => false,
1999                                 'private' => $private, 'textlimit' => $textlimit, 'sslserver' => $sslserver, 'ssl' => $ssl,
2000                                 'shorturllength' => '30',
2001                                 'friendica' => array(
2002                                                 'FRIENDICA_PLATFORM' => FRIENDICA_PLATFORM,
2003                                                 'FRIENDICA_VERSION' => FRIENDICA_VERSION,
2004                                                 'DFRN_PROTOCOL_VERSION' => DFRN_PROTOCOL_VERSION,
2005                                                 'DB_UPDATE_VERSION' => DB_UPDATE_VERSION
2006                                                 )
2007                         ),
2008                 );
2009
2010                 return api_apply_template('config', $type, array('$config' => $config));
2011
2012         }
2013         api_register_func('api/statusnet/config','api_statusnet_config',false);
2014
2015         function api_statusnet_version(&$a,$type) {
2016
2017                 // liar
2018
2019                 if($type === 'xml') {
2020                         header("Content-type: application/xml");
2021                         echo '<?xml version="1.0" encoding="UTF-8"?>' . "\r\n" . '<version>0.9.7</version>' . "\r\n";
2022                         killme();
2023                 }
2024                 elseif($type === 'json') {
2025                         header("Content-type: application/json");
2026                         echo '"0.9.7"';
2027                         killme();
2028                 }
2029         }
2030         api_register_func('api/statusnet/version','api_statusnet_version',false);
2031
2032
2033         function api_ff_ids(&$a,$type,$qtype) {
2034                 if(! api_user())
2035                         return false;
2036
2037                 $user_info = api_get_user($a);
2038
2039                 if($qtype == 'friends')
2040                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_SHARING), intval(CONTACT_IS_FRIEND));
2041                 if($qtype == 'followers')
2042                         $sql_extra = sprintf(" AND ( `rel` = %d OR `rel` = %d ) ", intval(CONTACT_IS_FOLLOWER), intval(CONTACT_IS_FRIEND));
2043
2044                 if (!$user_info["self"])
2045                         $sql_extra = " AND false ";
2046
2047                 $stringify_ids = (x($_REQUEST,'stringify_ids')?$_REQUEST['stringify_ids']:false);
2048
2049                 $r = q("SELECT unique_contacts.id FROM contact, unique_contacts WHERE contact.nurl = unique_contacts.url AND `uid` = %d AND `self` = 0 AND `blocked` = 0 AND `pending` = 0 $sql_extra",
2050                         intval(api_user())
2051                 );
2052
2053                 if(is_array($r)) {
2054
2055                         if($type === 'xml') {
2056                                 header("Content-type: application/xml");
2057                                 echo '<?xml version="1.0" encoding="UTF-8"?>' . "\r\n" . '<ids>' . "\r\n";
2058                                 foreach($r as $rr)
2059                                         echo '<id>' . $rr['id'] . '</id>' . "\r\n";
2060                                 echo '</ids>' . "\r\n";
2061                                 killme();
2062                         }
2063                         elseif($type === 'json') {
2064                                 $ret = array();
2065                                 header("Content-type: application/json");
2066                                 foreach($r as $rr)
2067                                         if ($stringify_ids)
2068                                                 $ret[] = $rr['id'];
2069                                         else
2070                                                 $ret[] = intval($rr['id']);
2071
2072                                 echo json_encode($ret);
2073                                 killme();
2074                         }
2075                 }
2076         }
2077
2078         function api_friends_ids(&$a,$type) {
2079                 api_ff_ids($a,$type,'friends');
2080         }
2081         function api_followers_ids(&$a,$type) {
2082                 api_ff_ids($a,$type,'followers');
2083         }
2084         api_register_func('api/friends/ids','api_friends_ids',true);
2085         api_register_func('api/followers/ids','api_followers_ids',true);
2086
2087
2088         function api_direct_messages_new(&$a, $type) {
2089                 if (api_user()===false) return false;
2090
2091                 if (!x($_POST, "text") OR (!x($_POST,"screen_name") AND !x($_POST,"user_id"))) return;
2092
2093                 $sender = api_get_user($a);
2094
2095                 require_once("include/message.php");
2096
2097                 if ($_POST['screen_name']) {
2098                         $r = q("SELECT `id`, `nurl`, `network` FROM `contact` WHERE `uid`=%d AND `nick`='%s'",
2099                                         intval(api_user()),
2100                                         dbesc($_POST['screen_name']));
2101
2102                         // Selecting the id by priority, friendica first
2103                         api_best_nickname($r);
2104
2105                         $recipient = api_get_user($a, $r[0]['nurl']);
2106                 } else
2107                         $recipient = api_get_user($a, $_POST['user_id']);
2108
2109                 $replyto = '';
2110                 $sub     = '';
2111                 if (x($_REQUEST,'replyto')) {
2112                         $r = q('SELECT `parent-uri`, `title` FROM `mail` WHERE `uid`=%d AND `id`=%d',
2113                                         intval(api_user()),
2114                                         intval($_REQUEST['replyto']));
2115                         $replyto = $r[0]['parent-uri'];
2116                         $sub     = $r[0]['title'];
2117                 }
2118                 else {
2119                         if (x($_REQUEST,'title')) {
2120                                 $sub = $_REQUEST['title'];
2121                         }
2122                         else {
2123                                 $sub = ((strlen($_POST['text'])>10)?substr($_POST['text'],0,10)."...":$_POST['text']);
2124                         }
2125                 }
2126
2127                 $id = send_message($recipient['cid'], $_POST['text'], $sub, $replyto);
2128
2129                 if ($id>-1) {
2130                         $r = q("SELECT * FROM `mail` WHERE id=%d", intval($id));
2131                         $ret = api_format_messages($r[0], $recipient, $sender);
2132
2133                 } else {
2134                         $ret = array("error"=>$id);
2135                 }
2136
2137                 $data = Array('$messages'=>$ret);
2138
2139                 switch($type){
2140                         case "atom":
2141                         case "rss":
2142                                 $data = api_rss_extra($a, $data, $user_info);
2143                 }
2144
2145                 return  api_apply_template("direct_messages", $type, $data);
2146
2147         }
2148         api_register_func('api/direct_messages/new','api_direct_messages_new',true);
2149
2150         function api_direct_messages_box(&$a, $type, $box) {
2151                 if (api_user()===false) return false;
2152
2153                 unset($_REQUEST["user_id"]);
2154                 unset($_GET["user_id"]);
2155
2156                 unset($_REQUEST["screen_name"]);
2157                 unset($_GET["screen_name"]);
2158
2159                 $user_info = api_get_user($a);
2160
2161                 // params
2162                 $count = (x($_GET,'count')?$_GET['count']:20);
2163                 $page = (x($_REQUEST,'page')?$_REQUEST['page']-1:0);
2164                 if ($page<0) $page=0;
2165
2166                 $since_id = (x($_REQUEST,'since_id')?$_REQUEST['since_id']:0);
2167                 $max_id = (x($_REQUEST,'max_id')?$_REQUEST['max_id']:0);
2168
2169                 $start = $page*$count;
2170
2171                 //$profile_url = $a->get_baseurl() . '/profile/' . $a->user['nickname'];
2172                 $profile_url = $user_info["url"];
2173
2174                 if ($box=="sentbox") {
2175                         $sql_extra = "`mail`.`from-url`='".dbesc( $profile_url )."'";
2176                 }
2177                 elseif ($box=="conversation") {
2178                         $sql_extra = "`mail`.`parent-uri`='".dbesc( $_GET["uri"] )  ."'";
2179                 }
2180                 elseif ($box=="all") {
2181                         $sql_extra = "true";
2182                 }
2183                 elseif ($box=="inbox") {
2184                         $sql_extra = "`mail`.`from-url`!='".dbesc( $profile_url )."'";
2185                 }
2186
2187                 if ($max_id > 0)
2188                         $sql_extra .= ' AND `mail`.`id` <= '.intval($max_id);
2189
2190                 $r = q("SELECT `mail`.*, `contact`.`nurl` AS `contact-url` FROM `mail`,`contact` WHERE `mail`.`contact-id` = `contact`.`id` AND `mail`.`uid`=%d AND $sql_extra AND `mail`.`id` > %d ORDER BY `mail`.`id` DESC LIMIT %d,%d",
2191                                 intval(api_user()),
2192                                 intval($since_id),
2193                                 intval($start), intval($count)
2194                 );
2195
2196                 $ret = Array();
2197                 foreach($r as $item) {
2198                         if ($box == "inbox" || $item['from-url'] != $profile_url){
2199                                 $recipient = $user_info;
2200                                 $sender = api_get_user($a,normalise_link($item['contact-url']));
2201                         }
2202                         elseif ($box == "sentbox" || $item['from-url'] != $profile_url){
2203                                 $recipient = api_get_user($a,normalise_link($item['contact-url']));
2204                                 $sender = $user_info;
2205
2206                         }
2207
2208                         $ret[]=api_format_messages($item, $recipient, $sender);
2209                 }
2210
2211
2212                 $data = array('$messages' => $ret);
2213                 switch($type){
2214                         case "atom":
2215                         case "rss":
2216                                 $data = api_rss_extra($a, $data, $user_info);
2217                 }
2218
2219                 return  api_apply_template("direct_messages", $type, $data);
2220
2221         }
2222
2223         function api_direct_messages_sentbox(&$a, $type){
2224                 return api_direct_messages_box($a, $type, "sentbox");
2225         }
2226         function api_direct_messages_inbox(&$a, $type){
2227                 return api_direct_messages_box($a, $type, "inbox");
2228         }
2229         function api_direct_messages_all(&$a, $type){
2230                 return api_direct_messages_box($a, $type, "all");
2231         }
2232         function api_direct_messages_conversation(&$a, $type){
2233                 return api_direct_messages_box($a, $type, "conversation");
2234         }
2235         api_register_func('api/direct_messages/conversation','api_direct_messages_conversation',true);
2236         api_register_func('api/direct_messages/all','api_direct_messages_all',true);
2237         api_register_func('api/direct_messages/sent','api_direct_messages_sentbox',true);
2238         api_register_func('api/direct_messages','api_direct_messages_inbox',true);
2239
2240
2241
2242         function api_oauth_request_token(&$a, $type){
2243                 try{
2244                         $oauth = new FKOAuth1();
2245                         $r = $oauth->fetch_request_token(OAuthRequest::from_request());
2246                 }catch(Exception $e){
2247                         echo "error=". OAuthUtil::urlencode_rfc3986($e->getMessage()); killme();
2248                 }
2249                 echo $r;
2250                 killme();
2251         }
2252         function api_oauth_access_token(&$a, $type){
2253                 try{
2254                         $oauth = new FKOAuth1();
2255                         $r = $oauth->fetch_access_token(OAuthRequest::from_request());
2256                 }catch(Exception $e){
2257                         echo "error=". OAuthUtil::urlencode_rfc3986($e->getMessage()); killme();
2258                 }
2259                 echo $r;
2260                 killme();
2261         }
2262
2263         api_register_func('api/oauth/request_token', 'api_oauth_request_token', false);
2264         api_register_func('api/oauth/access_token', 'api_oauth_access_token', false);
2265
2266 function api_share_as_retweet($a, $uid, &$item) {
2267         $body = trim($item["body"]);
2268
2269         // Skip if it isn't a pure repeated messages
2270         // Does it start with a share?
2271         if (strpos($body, "[share") > 0)
2272                 return(false);
2273
2274         // Does it end with a share?
2275         if (strlen($body) > (strrpos($body, "[/share]") + 8))
2276                 return(false);
2277
2278         $attributes = preg_replace("/\[share(.*?)\]\s?(.*?)\s?\[\/share\]\s?/ism","$1",$body);
2279         // Skip if there is no shared message in there
2280         if ($body == $attributes)
2281                 return(false);
2282
2283         $author = "";
2284         preg_match("/author='(.*?)'/ism", $attributes, $matches);
2285         if ($matches[1] != "")
2286                 $author = html_entity_decode($matches[1],ENT_QUOTES,'UTF-8');
2287
2288         preg_match('/author="(.*?)"/ism', $attributes, $matches);
2289         if ($matches[1] != "")
2290                 $author = $matches[1];
2291
2292         $profile = "";
2293         preg_match("/profile='(.*?)'/ism", $attributes, $matches);
2294         if ($matches[1] != "")
2295                 $profile = $matches[1];
2296
2297         preg_match('/profile="(.*?)"/ism', $attributes, $matches);
2298         if ($matches[1] != "")
2299                 $profile = $matches[1];
2300
2301         $avatar = "";
2302         preg_match("/avatar='(.*?)'/ism", $attributes, $matches);
2303         if ($matches[1] != "")
2304                 $avatar = $matches[1];
2305
2306         preg_match('/avatar="(.*?)"/ism', $attributes, $matches);
2307         if ($matches[1] != "")
2308                 $avatar = $matches[1];
2309
2310         $shared_body = preg_replace("/\[share(.*?)\]\s?(.*?)\s?\[\/share\]\s?/ism","$2",$body);
2311
2312         if (($shared_body == "") OR ($profile == "") OR ($author == "") OR ($avatar == ""))
2313                 return(false);
2314
2315         $item["body"] = $shared_body;
2316         $item["author-name"] = $author;
2317         $item["author-link"] = $profile;
2318         $item["author-avatar"] = $avatar;
2319
2320         return(true);
2321
2322 }
2323
2324 function api_get_nick($profile) {
2325 /* To-Do:
2326  - remove trailing jung from profile url
2327  - pump.io check has to check the website
2328 */
2329
2330         $nick = "";
2331
2332         $friendica = preg_replace("=https?://(.*)/profile/(.*)=ism", "$2", $profile);
2333         if ($friendica != $profile)
2334                 $nick = $friendica;
2335
2336         if (!$nick == "") {
2337                 $diaspora = preg_replace("=https?://(.*)/u/(.*)=ism", "$2", $profile);
2338                 if ($diaspora != $profile)
2339                         $nick = $diaspora;
2340         }
2341
2342         if (!$nick == "") {
2343                 $twitter = preg_replace("=https?://twitter.com/(.*)=ism", "$1", $profile);
2344                 if ($twitter != $profile)
2345                         $nick = $twitter;
2346         }
2347
2348
2349         if (!$nick == "") {
2350                 $StatusnetHost = preg_replace("=https?://(.*)/user/(.*)=ism", "$1", $profile);
2351                 if ($StatusnetHost != $profile) {
2352                         $StatusnetUser = preg_replace("=https?://(.*)/user/(.*)=ism", "$2", $profile);
2353                         if ($StatusnetUser != $profile) {
2354                                 $UserData = fetch_url("http://".$StatusnetHost."/api/users/show.json?user_id=".$StatusnetUser);
2355                                 $user = json_decode($UserData);
2356                                 if ($user)
2357                                         $nick = $user->screen_name;
2358                         }
2359                 }
2360         }
2361
2362         // To-Do: look at the page if its really a pumpio site
2363         //if (!$nick == "") {
2364         //      $pumpio = preg_replace("=https?://(.*)/(.*)/=ism", "$2", $profile."/");
2365         //      if ($pumpio != $profile)
2366         //              $nick = $pumpio;
2367                 //      <div class="media" id="profile-block" data-profile-id="acct:kabniel@microca.st">
2368
2369         //}
2370
2371         if ($nick != "") {
2372                 q("UPDATE unique_contacts SET nick = '%s' WHERE url = '%s'",
2373                         dbesc($nick), dbesc(normalise_link($profile)));
2374                 return($nick);
2375         }
2376
2377         return(false);
2378 }
2379
2380 function api_clean_plain_items($Text) {
2381         $include_entities = strtolower(x($_REQUEST,'include_entities')?$_REQUEST['include_entities']:"false");
2382
2383         $Text = bb_CleanPictureLinks($Text);
2384
2385         $URLSearchString = "^\[\]";
2386
2387         $Text = preg_replace("/([!#@])\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",'$1$3',$Text);
2388
2389         if ($include_entities == "true") {
2390                 $Text = preg_replace("/\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",'[url=$1]$1[/url]',$Text);
2391         }
2392
2393         $Text = preg_replace_callback("((.*?)\[class=(.*?)\](.*?)\[\/class\])ism","api_cleanup_share",$Text);
2394         return($Text);
2395 }
2396
2397 function api_cleanup_share($shared) {
2398         if ($shared[2] != "type-link")
2399                 return($shared[0]);
2400
2401         if (!preg_match_all("/\[bookmark\=([^\]]*)\](.*?)\[\/bookmark\]/ism",$shared[3], $bookmark))
2402                 return($shared[0]);
2403
2404         $title = "";
2405         $link = "";
2406
2407         if (isset($bookmark[2][0]))
2408                 $title = $bookmark[2][0];
2409
2410         if (isset($bookmark[1][0]))
2411                 $link = $bookmark[1][0];
2412
2413         if (strpos($shared[1],$title) !== false)
2414                 $title = "";
2415
2416         if (strpos($shared[1],$link) !== false)
2417                 $link = "";
2418
2419         $text = trim($shared[1]);
2420
2421         //if (strlen($text) < strlen($title))
2422         if (($text == "") AND ($title != ""))
2423                 $text .= "\n\n".trim($title);
2424
2425         if ($link != "")
2426                 $text .= "\n".trim($link);
2427
2428         return(trim($text));
2429 }
2430
2431 function api_best_nickname(&$contacts) {
2432         $best_contact = array();
2433
2434         if (count($contact) == 0)
2435                 return;
2436
2437         foreach ($contacts AS $contact)
2438                 if ($contact["network"] == "") {
2439                         $contact["network"] = "dfrn";
2440                         $best_contact = array($contact);
2441                 }
2442
2443         if (sizeof($best_contact) == 0)
2444                 foreach ($contacts AS $contact)
2445                         if ($contact["network"] == "dfrn")
2446                                 $best_contact = array($contact);
2447
2448         if (sizeof($best_contact) == 0)
2449                 foreach ($contacts AS $contact)
2450                         if ($contact["network"] == "dspr")
2451                                 $best_contact = array($contact);
2452
2453         if (sizeof($best_contact) == 0)
2454                 foreach ($contacts AS $contact)
2455                         if ($contact["network"] == "stat")
2456                                 $best_contact = array($contact);
2457
2458         if (sizeof($best_contact) == 0)
2459                 foreach ($contacts AS $contact)
2460                         if ($contact["network"] == "pump")
2461                                 $best_contact = array($contact);
2462
2463         if (sizeof($best_contact) == 0)
2464                 foreach ($contacts AS $contact)
2465                         if ($contact["network"] == "twit")
2466                                 $best_contact = array($contact);
2467
2468         if (sizeof($best_contact) == 1)
2469                 $contacts = $best_contact;
2470         else
2471                 $contacts = array($contacts[0]);
2472 }
2473
2474 /*
2475 Not implemented by now:
2476 favorites
2477 favorites/create
2478 favorites/destroy
2479 statuses/retweets_of_me
2480 friendships/create
2481 friendships/destroy
2482 friendships/exists
2483 friendships/show
2484 account/update_location
2485 account/update_profile_background_image
2486 account/update_profile_image
2487 blocks/create
2488 blocks/destroy
2489
2490 Not implemented in status.net:
2491 statuses/retweeted_to_me
2492 statuses/retweeted_by_me
2493 direct_messages/destroy
2494 account/end_session
2495 account/update_delivery_device
2496 notifications/follow
2497 notifications/leave
2498 blocks/exists
2499 blocks/blocking
2500 lists
2501 */