mod/dfrn_confirm.php

   1 <?php
   2
   3 /*
   4  * Module: dfrn_confirm
   5  * Purpose: Friendship acceptance for DFRN contacts
   6  *
   7  * There are two possible entry points and three scenarios.
   8  *
   9  *   1. A form was submitted by our user approving a friendship that originated elsewhere.
  10  *      This may also be called from dfrn_request to automatically approve a friendship.
  11  *
  12  *   2. We may be the target or other side of the conversation to scenario 1, and will
  13  *      interact with that process on our own user's behalf.
  14  *
  15  */
  16
  17 function dfrn_confirm_post(&$a,$handsfree = null) {
  18
  19         if(is_array($handsfree)) {
  20
  21                 /**
  22                  * We were called directly from dfrn_request due to automatic friend acceptance.
  23                  * Any $_POST parameters we may require are supplied in the $handsfree array.
  24                  *
  25                  */
  26
  27                 $node = $handsfree['node'];
  28                 $a->interactive = false; // notice() becomes a no-op since nobody is there to see it
  29
  30         }
  31         else {
  32                 if($a->argc > 1)
  33                         $node = $a->argv[1];
  34         }
  35
  36                 /**
  37                  *
  38                  * Main entry point. Scenario 1. Our user received a friend request notification (perhaps
  39                  * from another site) and clicked 'Approve'.
  40                  * $POST['source_url'] is not set. If it is, it indicates Scenario 2.
  41                  *
  42                  * We may also have been called directly from dfrn_request ($handsfree != null) due to
  43                  * this being a page type which supports automatic friend acceptance. That is also Scenario 1
  44                  * since we are operating on behalf of our registered user to approve a friendship.
  45                  *
  46                  */
  47
  48         if(! x($_POST,'source_url')) {
  49
  50                 $uid = ((is_array($handsfree)) ? $handsfree['uid'] : local_user());
  51
  52                 if(! $uid) {
  53                         notice( t('Permission denied.') . EOL );
  54                         return;
  55                 }
  56
  57                 $user = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
  58                         intval($uid)
  59                 );
  60
  61                 if(! $user) {
  62                         notice( t('Profile not found.') . EOL );
  63                         return;
  64                 }
  65
  66
  67                 // These data elements may come from either the friend request notification form or $handsfree array.
  68
  69                 if(is_array($handsfree)) {
  70                         logger('dfrn_confirm: Confirm in handsfree mode');
  71                         $dfrn_id   = $handsfree['dfrn_id'];
  72                         $intro_id  = $handsfree['intro_id'];
  73                         $duplex    = $handsfree['duplex'];
  74                         $hidden    = ((array_key_exists('hidden',$handsfree)) ? intval($handsfree['hidden']) : 0 );
  75                         $activity  = ((array_key_exists('activity',$handsfree)) ? intval($handsfree['activity']) : 0 );
  76                 }
  77                 else {
  78                         $dfrn_id  = ((x($_POST,'dfrn_id'))    ? notags(trim($_POST['dfrn_id'])) : "");
  79                         $intro_id = ((x($_POST,'intro_id'))   ? intval($_POST['intro_id'])      : 0 );
  80                         $duplex   = ((x($_POST,'duplex'))     ? intval($_POST['duplex'])        : 0 );
  81                         $cid      = ((x($_POST,'contact_id')) ? intval($_POST['contact_id'])    : 0 );
  82                         $hidden   = ((x($_POST,'hidden'))     ? intval($_POST['hidden'])        : 0 );
  83                         $activity = ((x($_POST,'activity'))   ? intval($_POST['activity'])      : 0 );
  84                 }
  85
  86                 /**
  87                  *
  88                  * Ensure that dfrn_id has precedence when we go to find the contact record.
  89                  * We only want to search based on contact id if there is no dfrn_id,
  90                  * e.g. for OStatus network followers.
  91                  *
  92                  */
  93
  94                 if(strlen($dfrn_id))
  95                         $cid = 0;
  96
  97                 logger('dfrn_confirm: Confirming request for dfrn_id (issued) ' . $dfrn_id);
  98                 if($cid)
  99                         logger('dfrn_confirm: Confirming follower with contact_id: ' . $cid);
 100
 101
 102                 /**
 103                  *
 104                  * The other person will have been issued an ID when they first requested friendship.
 105                  * Locate their record. At this time, their record will have both pending and blocked set to 1.
 106                  * There won't be any dfrn_id if this is a network follower, so use the contact_id instead.
 107                  *
 108                  */
 109
 110                 $r = q("SELECT * FROM `contact` WHERE ( ( `issued-id` != '' AND `issued-id` = '%s' ) OR ( `id` = %d AND `id` != 0 ) ) AND `uid` = %d AND `duplex` = 0 LIMIT 1",
 111                         dbesc($dfrn_id),
 112                         intval($cid),
 113                         intval($uid)
 114                 );
 115
 116                 if(! count($r)) {
 117                         logger('dfrn_confirm: Contact not found in DB.');
 118                         notice( t('Contact not found.') . EOL );
 119                         notice( t('This may occasionally happen if contact was requested by both persons and it has already been approved.') . EOL );
 120                         return;
 121                 }
 122
 123                 $contact = $r[0];
 124
 125                 $contact_id   = $contact['id'];
 126                 $relation     = $contact['rel'];
 127                 $site_pubkey  = $contact['site-pubkey'];
 128                 $dfrn_confirm = $contact['confirm'];
 129                 $aes_allow    = $contact['aes_allow'];
 130
 131                 $network = ((strlen($contact['issued-id'])) ? NETWORK_DFRN : NETWORK_OSTATUS);
 132
 133                 if($contact['network'])
 134                         $network = $contact['network'];
 135
 136                 if($network === NETWORK_DFRN) {
 137
 138                         /**
 139                          *
 140                          * Generate a key pair for all further communications with this person.
 141                          * We have a keypair for every contact, and a site key for unknown people.
 142                          * This provides a means to carry on relationships with other people if
 143                          * any single key is compromised. It is a robust key. We're much more
 144                          * worried about key leakage than anybody cracking it.
 145                          *
 146                          */
 147                         require_once('include/crypto.php');
 148
 149                         $res = new_keypair(4096);
 150
 151                         $private_key = $res['prvkey'];
 152                         $public_key  = $res['pubkey'];
 153
 154                         // Save the private key. Send them the public key.
 155
 156                         $r = q("UPDATE `contact` SET `prvkey` = '%s' WHERE `id` = %d AND `uid` = %d LIMIT 1",
 157                                 dbesc($private_key),
 158                                 intval($contact_id),
 159                                 intval($uid)
 160                         );
 161
 162                         $params = array();
 163
 164                         /**
 165                          *
 166                          * Per the DFRN protocol, we will verify both ends by encrypting the dfrn_id with our
 167                          * site private key (person on the other end can decrypt it with our site public key).
 168                          * Then encrypt our profile URL with the other person's site public key. They can decrypt
 169                          * it with their site private key. If the decryption on the other end fails for either
 170                          * item, it indicates tampering or key failure on at least one site and we will not be
 171                          * able to provide a secure communication pathway.
 172                          *
 173                          * If other site is willing to accept full encryption, (aes_allow is 1 AND we have php5.3
 174                          * or later) then we encrypt the personal public key we send them using AES-256-CBC and a
 175                          * random key which is encrypted with their site public key.
 176                          *
 177                          */
 178
 179                         $src_aes_key = random_string();
 180
 181                         $result = '';
 182                         openssl_private_encrypt($dfrn_id,$result,$user[0]['prvkey']);
 183
 184                         $params['dfrn_id'] = bin2hex($result);
 185                         $params['public_key'] = $public_key;
 186
 187
 188                         $my_url = $a->get_baseurl() . '/profile/' . $user[0]['nickname'];
 189
 190                         openssl_public_encrypt($my_url, $params['source_url'], $site_pubkey);
 191                         $params['source_url'] = bin2hex($params['source_url']);
 192
 193                         if($aes_allow && function_exists('openssl_encrypt')) {
 194                                 openssl_public_encrypt($src_aes_key, $params['aes_key'], $site_pubkey);
 195                                 $params['aes_key'] = bin2hex($params['aes_key']);
 196                                 $params['public_key'] = bin2hex(openssl_encrypt($public_key,'AES-256-CBC',$src_aes_key));
 197                         }
 198
 199                         $params['dfrn_version'] = DFRN_PROTOCOL_VERSION ;
 200                         if($duplex == 1)
 201                                 $params['duplex'] = 1;
 202
 203                         if($user[0]['page-flags'] == PAGE_COMMUNITY)
 204                                 $params['page'] = 1;
 205                         if($user[0]['page-flags'] == PAGE_PRVGROUP)
 206                                 $params['page'] = 2;
 207
 208                         logger('dfrn_confirm: Confirm: posting data to ' . $dfrn_confirm . ': ' . print_r($params,true), LOGGER_DATA);
 209
 210                         /**
 211                          *
 212                          * POST all this stuff to the other site.
 213                          * Temporarily raise the network timeout to 120 seconds because the default 60
 214                          * doesn't always give the other side quite enough time to decrypt everything.
 215                          *
 216                          */
 217
 218                         $a->config['system']['curl_timeout'] = 120;
 219
 220                         $res = post_url($dfrn_confirm,$params);
 221
 222                         logger('dfrn_confirm: Confirm: received data: ' . $res, LOGGER_DATA);
 223
 224                         // Now figure out what they responded. Try to be robust if the remote site is
 225                         // having difficulty and throwing up errors of some kind.
 226
 227                         $leading_junk = substr($res,0,strpos($res,'<?xml'));
 228
 229                         $res = substr($res,strpos($res,'<?xml'));
 230                         if(! strlen($res)) {
 231
 232                                         // No XML at all, this exchange is messed up really bad.
 233                                         // We shouldn't proceed, because the xml parser might choke,
 234                                         // and $status is going to be zero, which indicates success.
 235                                         // We can hardly call this a success.
 236
 237                                 notice( t('Response from remote site was not understood.') . EOL);
 238                                 return;
 239                         }
 240
 241                         if(strlen($leading_junk) && get_config('system','debugging')) {
 242
 243                                         // This might be more common. Mixed error text and some XML.
 244                                         // If we're configured for debugging, show the text. Proceed in either case.
 245
 246                                 notice( t('Unexpected response from remote site: ') . EOL . $leading_junk . EOL );
 247                         }
 248
 249                         $xml = parse_xml_string($res);
 250                         $status = (int) $xml->status;
 251                         $message = unxmlify($xml->message);   // human readable text of what may have gone wrong.
 252                         switch($status) {
 253                                 case 0:
 254                                         info( t("Confirmation completed successfully.") . EOL);
 255                                         if(strlen($message))
 256                                                 notice( t('Remote site reported: ') . $message . EOL);
 257                                         break;
 258                                 case 1:
 259                                         // birthday paradox - generate new dfrn-id and fall through.
 260                                         $new_dfrn_id = random_string();
 261                                         $r = q("UPDATE contact SET `issued-id` = '%s' WHERE `id` = %d AND `uid` = %d LIMIT 1",
 262                                                 dbesc($new_dfrn_id),
 263                                                 intval($contact_id),
 264                                                 intval($uid)
 265                                         );
 266
 267                                 case 2:
 268                                         notice( t("Temporary failure. Please wait and try again.") . EOL);
 269                                         if(strlen($message))
 270                                                 notice( t('Remote site reported: ') . $message . EOL);
 271                                         break;
 272
 273
 274                                 case 3:
 275                                         notice( t("Introduction failed or was revoked.") . EOL);
 276                                         if(strlen($message))
 277                                                 notice( t('Remote site reported: ') . $message . EOL);
 278                                         break;
 279                                 }
 280
 281                         if(($status == 0) && ($intro_id)) {
 282
 283                                 // Success. Delete the notification.
 284
 285                                 $r = q("DELETE FROM `intro` WHERE `id` = %d AND `uid` = %d LIMIT 1",
 286                                         intval($intro_id),
 287                                         intval($uid)
 288                                 );
 289
 290                         }
 291
 292                         if($status != 0)
 293                                 return;
 294                 }
 295
 296
 297                 /*
 298                  *
 299                  * We have now established a relationship with the other site.
 300                  * Let's make our own personal copy of their profile photo so we don't have
 301                  * to always load it from their site.
 302                  *
 303                  * We will also update the contact record with the nature and scope of the relationship.
 304                  *
 305                  */
 306
 307                 require_once('include/Photo.php');
 308
 309                 $photos = import_profile_photo($contact['photo'],$uid,$contact_id);
 310
 311                 logger('dfrn_confirm: confirm - imported photos');
 312
 313                 if($network === NETWORK_DFRN) {
 314
 315                         $new_relation = CONTACT_IS_FOLLOWER;
 316                         if(($relation == CONTACT_IS_SHARING) || ($duplex))
 317                                 $new_relation = CONTACT_IS_FRIEND;
 318
 319                         if(($relation == CONTACT_IS_SHARING) && ($duplex))
 320                                 $duplex = 0;
 321
 322                         $r = q("UPDATE `contact` SET
 323                                 `photo` = '%s',
 324                                 `thumb` = '%s',
 325                                 `micro` = '%s',
 326                                 `rel` = %d,
 327                                 `name-date` = '%s',
 328                                 `uri-date` = '%s',
 329                                 `avatar-date` = '%s',
 330                                 `blocked` = 0,
 331                                 `pending` = 0,
 332                                 `duplex` = %d,
 333                                 `hidden` = %d,
 334                                 `network` = 'dfrn' WHERE `id` = %d LIMIT 1
 335                         ",
 336                                 dbesc($photos[0]),
 337                                 dbesc($photos[1]),
 338                                 dbesc($photos[2]),
 339                                 intval($new_relation),
 340                                 dbesc(datetime_convert()),
 341                                 dbesc(datetime_convert()),
 342                                 dbesc(datetime_convert()),
 343                                 intval($duplex),
 344                                 intval($hidden),
 345                                 intval($contact_id)
 346                         );
 347                 }
 348                 else {
 349
 350                         // $network !== NETWORK_DFRN
 351
 352                         $network = (($contact['network']) ? $contact['network'] : NETWORK_OSTATUS);
 353                         $notify = (($contact['notify']) ? $contact['notify'] : '');
 354                         $poll   = (($contact['poll']) ? $contact['poll'] : '');
 355
 356                         if((! $contact['notify']) || (! $contact['poll'])) {
 357                                 $arr = lrdd($contact['url']);
 358                                 if(count($arr)) {
 359                                         foreach($arr as $link) {
 360                                                 if($link['@attributes']['rel'] === 'salmon')
 361                                                         $notify = $link['@attributes']['href'];
 362                                                 if($link['@attributes']['rel'] === NAMESPACE_FEED)
 363                                                         $poll = $link['@attributes']['href'];
 364                                         }
 365                                 }
 366                         }
 367
 368                         $new_relation = $contact['rel'];
 369                         $writable = $contact['writable'];
 370
 371                         if($network === NETWORK_DIASPORA) {
 372                                 if($duplex)
 373                                         $new_relation = CONTACT_IS_FRIEND;
 374                                 else
 375                                         $new_relation = CONTACT_IS_SHARING;
 376
 377                                 if($new_relation != CONTACT_IS_FOLLOWER)
 378                                         $writable = 1;
 379                         }
 380
 381                         $r = q("DELETE FROM `intro` WHERE `id` = %d AND `uid` = %d LIMIT 1",
 382                                 intval($intro_id),
 383                                 intval($uid)
 384                         );
 385
 386
 387                         $r = q("UPDATE `contact` SET `photo` = '%s',
 388                                 `thumb` = '%s',
 389                                 `micro` = '%s',
 390                                 `name-date` = '%s',
 391                                 `uri-date` = '%s',
 392                                 `avatar-date` = '%s',
 393                                 `notify` = '%s',
 394                                 `poll` = '%s',
 395                                 `blocked` = 0,
 396                                 `pending` = 0,
 397                                 `network` = '%s',
 398                                 `writable` = %d,
 399                                 `hidden` = %d,
 400                                 `rel` = %d
 401                                 WHERE `id` = %d LIMIT 1
 402                         ",
 403                                 dbesc($photos[0]),
 404                                 dbesc($photos[1]),
 405                                 dbesc($photos[2]),
 406                                 dbesc(datetime_convert()),
 407                                 dbesc(datetime_convert()),
 408                                 dbesc(datetime_convert()),
 409                                 dbesc($notify),
 410                                 dbesc($poll),
 411                                 dbesc($network),
 412                                 intval($writable),
 413                                 intval($hidden),
 414                                 intval($new_relation),
 415                                 intval($contact_id)
 416                         );
 417                 }
 418
 419                 if($r === false)
 420                                 notice( t('Unable to set contact photo.') . EOL);
 421
 422                 // reload contact info
 423
 424                 $r = q("SELECT * FROM `contact` WHERE `id` = %d LIMIT 1",
 425                         intval($contact_id)
 426                 );
 427                 if(count($r))
 428                         $contact = $r[0];
 429                 else
 430                         $contact = null;
 431
 432
 433                 if((isset($new_relation) && $new_relation == CONTACT_IS_FRIEND)) {
 434
 435                         if(($contact) && ($contact['network'] === NETWORK_DIASPORA)) {
 436                                 require_once('include/diaspora.php');
 437                                 $ret = diaspora_share($user[0],$r[0]);
 438                                 logger('mod_follow: diaspora_share returns: ' . $ret);
 439                         }
 440
 441                         // Send a new friend post if we are allowed to...
 442
 443                         $r = q("SELECT `hide-friends` FROM `profile` WHERE `uid` = %d AND `is-default` = 1 LIMIT 1",
 444                                 intval($uid)
 445                         );
 446
 447                         if((count($r)) && ($r[0]['hide-friends'] == 0) && ($activity) && (! $hidden)) {
 448
 449                                 require_once('include/items.php');
 450
 451                                 $self = q("SELECT * FROM `contact` WHERE `self` = 1 AND `uid` = %d LIMIT 1",
 452                                         intval($uid)
 453                                 );
 454
 455                                 if(count($self)) {
 456
 457                                         $arr = array();
 458                                         $arr['uri'] = $arr['parent-uri'] = item_new_uri($a->get_hostname(), $uid);
 459                                         $arr['uid'] = $uid;
 460                                         $arr['contact-id'] = $self[0]['id'];
 461                                         $arr['wall'] = 1;
 462                                         $arr['type'] = 'wall';
 463                                         $arr['gravity'] = 0;
 464                                         $arr['origin'] = 1;
 465                                         $arr['author-name'] = $arr['owner-name'] = $self[0]['name'];
 466                                         $arr['author-link'] = $arr['owner-link'] = $self[0]['url'];
 467                                         $arr['author-avatar'] = $arr['owner-avatar'] = $self[0]['thumb'];
 468
 469                                         $A = '[url=' . $self[0]['url'] . ']' . $self[0]['name'] . '[/url]';
 470                                         $APhoto = '[url=' . $self[0]['url'] . ']' . '[img]' . $self[0]['thumb'] . '[/img][/url]';
 471
 472                                         $B = '[url=' . $contact['url'] . ']' . $contact['name'] . '[/url]';
 473                                         $BPhoto = '[url=' . $contact['url'] . ']' . '[img]' . $contact['thumb'] . '[/img][/url]';
 474
 475                                         $arr['verb'] = ACTIVITY_FRIEND;
 476                                     $arr['object-type'] = ACTIVITY_OBJ_PERSON;
 477                                         $arr['body'] =  sprintf( t('%1$s is now friends with %2$s'), $A, $B)."\n\n\n".$BPhoto;
 478
 479                                         $arr['object'] = '<object><type>' . ACTIVITY_OBJ_PERSON . '</type><title>' . $contact['name'] . '</title>'
 480                                                 . '<id>' . $contact['url'] . '/' . $contact['name'] . '</id>';
 481                                         $arr['object'] .= '<link>' . xmlify('<link rel="alternate" type="text/html" href="' . $contact['url'] . '" />' . "\n");
 482                                         $arr['object'] .= xmlify('<link rel="photo" type="image/jpeg" href="' . $contact['thumb'] . '" />' . "\n");
 483                                         $arr['object'] .= '</link></object>' . "\n";
 484
 485                                         $arr['last-child'] = 1;
 486
 487                                         $arr['allow_cid'] = $user[0]['allow_cid'];
 488                                         $arr['allow_gid'] = $user[0]['allow_gid'];
 489                                         $arr['deny_cid']  = $user[0]['deny_cid'];
 490                                         $arr['deny_gid']  = $user[0]['deny_gid'];
 491
 492                                         $i = item_store($arr);
 493                                         if($i)
 494                                         proc_run('php',"include/notifier.php","activity","$i");
 495                                 }
 496                         }
 497                 }
 498
 499
 500                 $g = q("select def_gid from user where uid = %d limit 1",
 501                         intval($uid)
 502                 );
 503                 if($contact && $g && intval($g[0]['def_gid'])) {
 504                         require_once('include/group.php');
 505                         group_add_member($uid,'',$contact['id'],$g[0]['def_gid']);
 506                 }
 507
 508                 // Let's send our user to the contact editor in case they want to
 509                 // do anything special with this new friend.
 510
 511                 if($handsfree === null)
 512                         goaway($a->get_baseurl() . '/contacts/' . intval($contact_id));
 513                 else
 514                         return;
 515                 //NOTREACHED
 516         }
 517
 518         /**
 519          *
 520          *
 521          * End of Scenario 1. [Local confirmation of remote friend request].
 522          *
 523          * Begin Scenario 2. This is the remote response to the above scenario.
 524          * This will take place on the site that originally initiated the friend request.
 525          * In the section above where the confirming party makes a POST and
 526          * retrieves xml status information, they are communicating with the following code.
 527          *
 528          */
 529
 530         if(x($_POST,'source_url')) {
 531
 532                 // We are processing an external confirmation to an introduction created by our user.
 533
 534                 $public_key = ((x($_POST,'public_key'))   ? $_POST['public_key']           : '');
 535                 $dfrn_id    = ((x($_POST,'dfrn_id'))      ? hex2bin($_POST['dfrn_id'])     : '');
 536                 $source_url = ((x($_POST,'source_url'))   ? hex2bin($_POST['source_url'])  : '');
 537                 $aes_key    = ((x($_POST,'aes_key'))      ? $_POST['aes_key']              : '');
 538                 $duplex     = ((x($_POST,'duplex'))       ? intval($_POST['duplex'])       : 0 );
 539                 $page       = ((x($_POST,'page'))         ? intval($_POST['page'])         : 0 );
 540                 $version_id = ((x($_POST,'dfrn_version')) ? (float) $_POST['dfrn_version'] : 2.0);
 541
 542                 $forum = (($page == 1) ? 1 : 0);
 543                 $prv   = (($page == 2) ? 1 : 0);
 544
 545                 logger('dfrn_confirm: requestee contacted: ' . $node);
 546
 547                 logger('dfrn_confirm: request: POST=' . print_r($_POST,true), LOGGER_DATA);
 548
 549                 // If $aes_key is set, both of these items require unpacking from the hex transport encoding.
 550
 551                 if(x($aes_key)) {
 552                         $aes_key = hex2bin($aes_key);
 553                         $public_key = hex2bin($public_key);
 554                 }
 555
 556                 // Find our user's account
 557
 558                 $r = q("SELECT * FROM `user` WHERE `nickname` = '%s' LIMIT 1",
 559                         dbesc($node));
 560
 561                 if(! count($r)) {
 562                         $message = sprintf(t('No user record found for \'%s\' '), $node);
 563                         xml_status(3,$message); // failure
 564                         // NOTREACHED
 565                 }
 566
 567                 $my_prvkey = $r[0]['prvkey'];
 568                 $local_uid = $r[0]['uid'];
 569
 570
 571                 if(! strstr($my_prvkey,'PRIVATE KEY')) {
 572                         $message = t('Our site encryption key is apparently messed up.');
 573                         xml_status(3,$message);
 574                 }
 575
 576                 // verify everything
 577
 578                 $decrypted_source_url = "";
 579                 openssl_private_decrypt($source_url,$decrypted_source_url,$my_prvkey);
 580
 581
 582                 if(! strlen($decrypted_source_url)) {
 583                         $message = t('Empty site URL was provided or URL could not be decrypted by us.');
 584                         xml_status(3,$message);
 585                         // NOTREACHED
 586                 }
 587
 588                 $ret = q("SELECT * FROM `contact` WHERE `url` = '%s' AND `uid` = %d LIMIT 1",
 589                         dbesc($decrypted_source_url),
 590                         intval($local_uid)
 591                 );
 592                 if(! count($ret)) {
 593                         if(strstr($decrypted_source_url,'http:'))
 594                                 $newurl = str_replace('http:','https:',$decrypted_source_url);
 595                         else
 596                                 $newurl = str_replace('https:','http:',$decrypted_source_url);
 597
 598                         $ret = q("SELECT * FROM `contact` WHERE `url` = '%s' AND `uid` = %d LIMIT 1",
 599                                 dbesc($newurl),
 600                                 intval($local_uid)
 601                         );
 602                         if(! count($ret)) {
 603                                 // this is either a bogus confirmation (?) or we deleted the original introduction.
 604                                 $message = t('Contact record was not found for you on our site.');
 605                                 xml_status(3,$message);
 606                                 return; // NOTREACHED
 607                         }
 608                 }
 609
 610                 $relation = $ret[0]['rel'];
 611
 612                 // Decrypt all this stuff we just received
 613
 614                 $foreign_pubkey = $ret[0]['site-pubkey'];
 615                 $dfrn_record    = $ret[0]['id'];
 616
 617                 if(! $foreign_pubkey) {
 618                         $message = sprintf( t('Site public key not available in contact record for URL %s.'), $newurl);
 619                         xml_status(3,$message);
 620                 }
 621
 622                 $decrypted_dfrn_id = "";
 623                 openssl_public_decrypt($dfrn_id,$decrypted_dfrn_id,$foreign_pubkey);
 624
 625                 if(strlen($aes_key)) {
 626                         $decrypted_aes_key = "";
 627                         openssl_private_decrypt($aes_key,$decrypted_aes_key,$my_prvkey);
 628                         $dfrn_pubkey = openssl_decrypt($public_key,'AES-256-CBC',$decrypted_aes_key);
 629                 }
 630                 else {
 631                         $dfrn_pubkey = $public_key;
 632                 }
 633
 634                 $r = q("SELECT * FROM `contact` WHERE `dfrn-id` = '%s' LIMIT 1",
 635                         dbesc($decrypted_dfrn_id)
 636                 );
 637                 if(count($r)) {
 638                         $message = t('The ID provided by your system is a duplicate on our system. It should work if you try again.');
 639                         xml_status(1,$message); // Birthday paradox - duplicate dfrn-id
 640                         // NOTREACHED
 641                 }
 642
 643                 $r = q("UPDATE `contact` SET `dfrn-id` = '%s', `pubkey` = '%s' WHERE `id` = %d LIMIT 1",
 644                         dbesc($decrypted_dfrn_id),
 645                         dbesc($dfrn_pubkey),
 646                         intval($dfrn_record)
 647                 );
 648                 if(! count($r)) {
 649                         $message = t('Unable to set your contact credentials on our system.');
 650                         xml_status(3,$message);
 651                 }
 652
 653                 // It's possible that the other person also requested friendship.
 654                 // If it is a duplex relationship, ditch the issued-id if one exists.
 655
 656                 if($duplex) {
 657                         $r = q("UPDATE `contact` SET `issued-id` = '' WHERE `id` = %d LIMIT 1",
 658                                 intval($dfrn_record)
 659                         );
 660                 }
 661
 662                 // We're good but now we have to scrape the profile photo and send notifications.
 663
 664
 665
 666                 $r = q("SELECT `photo` FROM `contact` WHERE `id` = %d LIMIT 1",
 667                         intval($dfrn_record));
 668
 669                 if(count($r))
 670                         $photo = $r[0]['photo'];
 671                 else
 672                         $photo = $a->get_baseurl() . '/images/person-175.jpg';
 673
 674                 require_once("include/Photo.php");
 675
 676                 $photos = import_profile_photo($photo,$local_uid,$dfrn_record);
 677
 678                 logger('dfrn_confirm: request - photos imported');
 679
 680                 $new_relation = CONTACT_IS_SHARING;
 681                 if(($relation == CONTACT_IS_FOLLOWER) || ($duplex))
 682                         $new_relation = CONTACT_IS_FRIEND;
 683
 684                 if(($relation == CONTACT_IS_FOLLOWER) && ($duplex))
 685                         $duplex = 0;
 686
 687                 $r = q("UPDATE `contact` SET
 688                         `photo` = '%s',
 689                         `thumb` = '%s',
 690                         `micro` = '%s',
 691                         `rel` = %d,
 692                         `name-date` = '%s',
 693                         `uri-date` = '%s',
 694                         `avatar-date` = '%s',
 695                         `blocked` = 0,
 696                         `pending` = 0,
 697                         `duplex` = %d,
 698                         `forum` = %d,
 699                         `prv` = %d,
 700                         `network` = '%s' WHERE `id` = %d LIMIT 1
 701                 ",
 702                         dbesc($photos[0]),
 703                         dbesc($photos[1]),
 704                         dbesc($photos[2]),
 705                         intval($new_relation),
 706                         dbesc(datetime_convert()),
 707                         dbesc(datetime_convert()),
 708                         dbesc(datetime_convert()),
 709                         intval($duplex),
 710                         intval($forum),
 711                         intval($prv),
 712                         dbesc(NETWORK_DFRN),
 713                         intval($dfrn_record)
 714                 );
 715                 if($r === false) {    // indicates schema is messed up or total db failure
 716                         $message = t('Unable to update your contact profile details on our system');
 717                         xml_status(3,$message);
 718                 }
 719
 720                 // Otherwise everything seems to have worked and we are almost done. Yay!
 721                 // Send an email notification
 722
 723                 logger('dfrn_confirm: request: info updated');
 724
 725                 $r = q("SELECT `contact`.*, `user`.* FROM `contact` LEFT JOIN `user` ON `contact`.`uid` = `user`.`uid`
 726                         WHERE `contact`.`id` = %d LIMIT 1",
 727                         intval($dfrn_record)
 728                 );
 729
 730                 if(count($r))
 731                         $combined = $r[0];
 732
 733                 if((count($r)) && ($r[0]['notify-flags'] & NOTIFY_CONFIRM)) {
 734
 735                         push_lang($r[0]['language']);
 736                         $tpl = (($new_relation == CONTACT_IS_FRIEND)
 737                                 ? get_intltext_template('friend_complete_eml.tpl')
 738                                 : get_intltext_template('intro_complete_eml.tpl'));
 739
 740                         $email_tpl = replace_macros($tpl, array(
 741                                 '$sitename' => $a->config['sitename'],
 742                                 '$siteurl' =>  $a->get_baseurl(),
 743                                 '$username' => $r[0]['username'],
 744                                 '$email' => $r[0]['email'],
 745                                 '$fn' => $r[0]['name'],
 746                                 '$dfrn_url' => $r[0]['url'],
 747                                 '$uid' => $newuid )
 748                         );
 749                         require_once('include/email.php');
 750
 751                         $res = mail($r[0]['email'], email_header_encode( sprintf( t("Connection accepted at %s") , $a->config['sitename']),'UTF-8'),
 752                                 $email_tpl,
 753                                 'From: ' . 'Administrator' . '@' . $_SERVER['SERVER_NAME'] . "\n"
 754                                 . 'Content-type: text/plain; charset=UTF-8' . "\n"
 755                                 . 'Content-transfer-encoding: 8bit' );
 756
 757                         if(!$res) {
 758                                 // pointless throwing an error here and confusing the person at the other end of the wire.
 759                         }
 760                         pop_lang();
 761                 }
 762
 763                 // Send a new friend post if we are allowed to...
 764
 765                 if($page && intval(get_pconfig($local_uid,'system','post_joingroup'))) {
 766                         $r = q("SELECT `hide-friends` FROM `profile` WHERE `uid` = %d AND `is-default` = 1 LIMIT 1",
 767                                 intval($local_uid)
 768                         );
 769
 770                         if((count($r)) && ($r[0]['hide-friends'] == 0)) {
 771
 772                                 require_once('include/items.php');
 773
 774                                 $self = q("SELECT * FROM `contact` WHERE `self` = 1 AND `uid` = %d LIMIT 1",
 775                                         intval($local_uid)
 776                                 );
 777
 778                                 if(count($self)) {
 779
 780                                         $arr = array();
 781                                         $arr['uri'] = $arr['parent-uri'] = item_new_uri($a->get_hostname(), $local_uid);
 782                                         $arr['uid'] = $local_uid;
 783                                         $arr['contact-id'] = $self[0]['id'];
 784                                         $arr['wall'] = 1;
 785                                         $arr['type'] = 'wall';
 786                                         $arr['gravity'] = 0;
 787                                         $arr['origin'] = 1;
 788                                         $arr['author-name'] = $arr['owner-name'] = $self[0]['name'];
 789                                         $arr['author-link'] = $arr['owner-link'] = $self[0]['url'];
 790                                         $arr['author-avatar'] = $arr['owner-avatar'] = $self[0]['thumb'];
 791
 792                                         $A = '[url=' . $self[0]['url'] . ']' . $self[0]['name'] . '[/url]';
 793                                         $APhoto = '[url=' . $self[0]['url'] . ']' . '[img]' . $self[0]['thumb'] . '[/img][/url]';
 794
 795                                         $B = '[url=' . $combined['url'] . ']' . $combined['name'] . '[/url]';
 796                                         $BPhoto = '[url=' . $combined['url'] . ']' . '[img]' . $combined['thumb'] . '[/img][/url]';
 797
 798                                         $arr['verb'] = ACTIVITY_JOIN;
 799                                         $arr['object-type'] = ACTIVITY_OBJ_GROUP;
 800                                         $arr['body'] =  sprintf( t('%1$s has joined %2$s'), $A, $B)."\n\n\n" .$BPhoto;
 801                                         $arr['object'] = '<object><type>' . ACTIVITY_OBJ_GROUP . '</type><title>' . $combined['name'] . '</title>'
 802                                                 . '<id>' . $combined['url'] . '/' . $combined['name'] . '</id>';
 803                                         $arr['object'] .= '<link>' . xmlify('<link rel="alternate" type="text/html" href="' . $combined['url'] . '" />' . "\n");
 804                                         $arr['object'] .= xmlify('<link rel="photo" type="image/jpeg" href="' . $combined['thumb'] . '" />' . "\n");
 805                                         $arr['object'] .= '</link></object>' . "\n";
 806
 807                                         $arr['last-child'] = 1;
 808
 809                                         $arr['allow_cid'] = $user[0]['allow_cid'];
 810                                         $arr['allow_gid'] = $user[0]['allow_gid'];
 811                                         $arr['deny_cid']  = $user[0]['deny_cid'];
 812                                         $arr['deny_gid']  = $user[0]['deny_gid'];
 813
 814                                         $i = item_store($arr);
 815                                         if($i)
 816                                         proc_run('php',"include/notifier.php","activity","$i");
 817
 818                                 }
 819                         }
 820                 }
 821                 xml_status(0); // Success
 822                 return; // NOTREACHED
 823
 824                         ////////////////////// End of this scenario ///////////////////////////////////////////////
 825         }
 826
 827         // somebody arrived here by mistake or they are fishing. Send them to the homepage.
 828
 829         goaway(z_root());
 830         // NOTREACHED
 831
 832 }