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                 }
  75                 else {
  76                         $dfrn_id  = ((x($_POST,'dfrn_id'))    ? notags(trim($_POST['dfrn_id'])) : "");
  77                         $intro_id = ((x($_POST,'intro_id'))   ? intval($_POST['intro_id'])      : 0 );
  78                         $duplex   = ((x($_POST,'duplex'))     ? intval($_POST['duplex'])        : 0 );
  79                         $cid      = ((x($_POST,'contact_id')) ? intval($_POST['contact_id'])    : 0 );
  80                 }
  81
  82                 /**
  83                  *
  84                  * Ensure that dfrn_id has precedence when we go to find the contact record.
  85                  * We only want to search based on contact id if there is no dfrn_id,
  86                  * e.g. for OStatus network followers.
  87                  *
  88                  */
  89
  90                 if(strlen($dfrn_id))
  91                         $cid = 0;
  92
  93                 logger('dfrn_confirm: Confirming request for dfrn_id (issued) ' . $dfrn_id);
  94                 if($cid)
  95                         logger('dfrn_confirm: Confirming follower with contact_id: ' . $cid);
  96
  97
  98                 /**
  99                  *
 100                  * The other person will have been issued an ID when they first requested friendship.
 101                  * Locate their record. At this time, their record will have both pending and blocked set to 1.
 102                  * There won't be any dfrn_id if this is a network follower, so use the contact_id instead.
 103                  *
 104                  */
 105
 106                 $r = q("SELECT * FROM `contact` WHERE ( ( `issued-id` != '' AND `issued-id` = '%s' ) OR ( `id` = %d AND `id` != 0 ) ) AND `uid` = %d LIMIT 1",
 107                         dbesc($dfrn_id),
 108                         intval($cid),
 109                         intval($uid)
 110                 );
 111
 112                 if(! count($r)) {
 113                         logger('dfrn_confirm: Contact not found in DB.');
 114                         notice( t('Contact not found.') . EOL );
 115                         return;
 116                 }
 117
 118                 $contact = $r[0];
 119
 120                 $contact_id   = $contact['id'];
 121                 $relation     = $contact['rel'];
 122                 $site_pubkey  = $contact['site-pubkey'];
 123                 $dfrn_confirm = $contact['confirm'];
 124                 $aes_allow    = $contact['aes_allow'];
 125
 126                 $network = ((strlen($contact['issued-id'])) ? 'dfrn' : 'stat');
 127
 128                 if($network === 'dfrn') {
 129
 130                         /**
 131                          *
 132                          * Generate a key pair for all further communications with this person.
 133                          * We have a keypair for every contact, and a site key for unknown people.
 134                          * This provides a means to carry on relationships with other people if
 135                          * any single key is compromised. It is a robust key. We're much more
 136                          * worried about key leakage than anybody cracking it.
 137                          *
 138                          */
 139
 140                         $res = openssl_pkey_new(array(
 141                                 'digest_alg' => 'sha1',
 142                                 'private_key_bits' => 4096,
 143                                 'encrypt_key' => false )
 144                         );
 145
 146                         $private_key = '';
 147
 148                         openssl_pkey_export($res, $private_key);
 149
 150                         $pubkey = openssl_pkey_get_details($res);
 151                         $public_key = $pubkey["key"];
 152
 153                         // Save the private key. Send them the public key.
 154
 155                         $r = q("UPDATE `contact` SET `prvkey` = '%s' WHERE `id` = %d AND `uid` = %d LIMIT 1",
 156                                 dbesc($private_key),
 157                                 intval($contact_id),
 158                                 intval($uid)
 159                         );
 160
 161                         $params = array();
 162
 163                         /**
 164                          *
 165                          * Per the DFRN protocol, we will verify both ends by encrypting the dfrn_id with our
 166                          * site private key (person on the other end can decrypt it with our site public key).
 167                          * Then encrypt our profile URL with the other person's site public key. They can decrypt
 168                          * it with their site private key. If the decryption on the other end fails for either
 169                          * item, it indicates tampering or key failure on at least one site and we will not be
 170                          * able to provide a secure communication pathway.
 171                          *
 172                          * If other site is willing to accept full encryption, (aes_allow is 1 AND we have php5.3
 173                          * or later) then we encrypt the personal public key we send them using AES-256-CBC and a
 174                          * random key which is encrypted with their site public key.
 175                          *
 176                          */
 177
 178                         $src_aes_key = random_string();
 179
 180                         $result = '';
 181                         openssl_private_encrypt($dfrn_id,$result,$user[0]['prvkey']);
 182
 183                         $params['dfrn_id'] = bin2hex($result);
 184                         $params['public_key'] = $public_key;
 185
 186
 187                         $my_url = $a->get_baseurl() . '/profile/' . $user[0]['nickname'];
 188
 189                         openssl_public_encrypt($my_url, $params['source_url'], $site_pubkey);
 190                         $params['source_url'] = bin2hex($params['source_url']);
 191
 192                         if($aes_allow && function_exists('openssl_encrypt')) {
 193                                 openssl_public_encrypt($src_aes_key, $params['aes_key'], $site_pubkey);
 194                                 $params['aes_key'] = bin2hex($params['aes_key']);
 195                                 $params['public_key'] = bin2hex(openssl_encrypt($public_key,'AES-256-CBC',$src_aes_key));
 196                         }
 197
 198                         $params['dfrn_version'] = DFRN_PROTOCOL_VERSION ;
 199                         if($duplex == 1)
 200                                 $params['duplex'] = 1;
 201
 202                         logger('dfrn_confirm: Confirm: posting data to ' . $dfrn_confirm . ': ' . print_r($params,true), LOGGER_DATA);
 203
 204                         /**
 205                          *
 206                          * POST all this stuff to the other site.
 207                          * Temporarily raise the network timeout to 120 seconds because the default 60
 208                          * doesn't always give the other side quite enough time to decrypt everything.
 209                          *
 210                          */
 211
 212                         $a->config['system']['curl_timeout'] = 120;
 213
 214                         $res = post_url($dfrn_confirm,$params);
 215
 216                         logger('dfrn_confirm: Confirm: received data: ' . $res, LOGGER_DATA);
 217
 218                         // Now figure out what they responded. Try to be robust if the remote site is
 219                         // having difficulty and throwing up errors of some kind.
 220
 221                         $leading_junk = substr($res,0,strpos($res,'<?xml'));
 222
 223                         $res = substr($res,strpos($res,'<?xml'));
 224                         if(! strlen($res)) {
 225
 226                                         // No XML at all, this exchange is messed up really bad.
 227                                         // We shouldn't proceed, because the xml parser might choke,
 228                                         // and $status is going to be zero, which indicates success.
 229                                         // We can hardly call this a success.
 230
 231                                 notice( t('Response from remote site was not understood.') . EOL);
 232                                 return;
 233                         }
 234
 235                         if(strlen($leading_junk) && get_config('system','debugging')) {
 236
 237                                         // This might be more common. Mixed error text and some XML.
 238                                         // If we're configured for debugging, show the text. Proceed in either case.
 239
 240                                 notice( t('Unexpected response from remote site: ') . EOL . $leading_junk . EOL );
 241                         }
 242
 243                         $xml = parse_xml_string($res);
 244                         $status = (int) $xml->status;
 245                         $message = unxmlify($xml->message);   // human readable text of what may have gone wrong.
 246                         switch($status) {
 247                                 case 0:
 248                                         notice( t("Confirmation completed successfully.") . EOL);
 249                                         if(strlen($message))
 250                                                 notice( t('Remote site reported: ') . $message . EOL);
 251                                         break;
 252                                 case 1:
 253                                         // birthday paradox - generate new dfrn-id and fall through.
 254                                         $new_dfrn_id = random_string();
 255                                         $r = q("UPDATE contact SET `issued-id` = '%s' WHERE `id` = %d AND `uid` = %d LIMIT 1",
 256                                                 dbesc($new_dfrn_id),
 257                                                 intval($contact_id),
 258                                                 intval($uid)
 259                                         );
 260
 261                                 case 2:
 262                                         notice( t("Temporary failure. Please wait and try again.") . EOL);
 263                                         if(strlen($message))
 264                                                 notice( t('Remote site reported: ') . $message . EOL);
 265                                         break;
 266
 267
 268                                 case 3:
 269                                         notice( t("Introduction failed or was revoked.") . EOL);
 270                                         if(strlen($message))
 271                                                 notice( t('Remote site reported: ') . $message . EOL);
 272                                         break;
 273                                 }
 274
 275                         if(($status == 0) && ($intro_id)) {
 276
 277                                 // Success. Delete the notification.
 278
 279                                 $r = q("DELETE FROM `intro` WHERE `id` = %d AND `uid` = %d LIMIT 1",
 280                                         intval($intro_id),
 281                                         intval($uid)
 282                                 );
 283
 284                         }
 285
 286                         if($status != 0)
 287                                 return;
 288                 }
 289
 290
 291                 /*
 292                  *
 293                  * We have now established a relationship with the other site.
 294                  * Let's make our own personal copy of their profile photo so we don't have
 295                  * to always load it from their site.
 296                  *
 297                  * We will also update the contact record with the nature and scope of the relationship.
 298                  *
 299                  */
 300
 301                 require_once("Photo.php");
 302
 303                 $photos = import_profile_photo($contact['photo'],$uid,$contact_id);
 304
 305                 logger('dfrn_confirm: confirm - imported photos');
 306
 307                 if($network === 'dfrn') {
 308
 309                         $new_relation = REL_VIP;
 310                         if(($relation == REL_FAN) || ($duplex))
 311                                 $new_relation = REL_BUD;
 312
 313                         if(($relation == REL_FAN) && ($duplex))
 314                                 $duplex = 0;
 315
 316                         $r = q("UPDATE `contact` SET `photo` = '%s',
 317                                 `thumb` = '%s',
 318                                 `micro` = '%s',
 319                                 `rel` = %d,
 320                                 `name-date` = '%s',
 321                                 `uri-date` = '%s',
 322                                 `avatar-date` = '%s',
 323                                 `blocked` = 0,
 324                                 `pending` = 0,
 325                                 `duplex` = %d,
 326                                 `network` = 'dfrn' WHERE `id` = %d LIMIT 1
 327                         ",
 328                                 dbesc($photos[0]),
 329                                 dbesc($photos[1]),
 330                                 dbesc($photos[2]),
 331                                 intval($new_relation),
 332                                 dbesc(datetime_convert()),
 333                                 dbesc(datetime_convert()),
 334                                 dbesc(datetime_convert()),
 335                                 intval($duplex),
 336                                 intval($contact_id)
 337                         );
 338                 }
 339                 else {
 340                         // $network !== 'dfrn'
 341
 342                         $notify = '';
 343                         $poll   = '';
 344
 345                         $arr = lrdd($contact['url']);
 346                         if(count($arr)) {
 347                                 foreach($arr as $link) {
 348                                         if($link['@attributes']['rel'] === 'salmon')
 349                                                 $notify = $link['@attributes']['href'];
 350                                         if($link['@attributes']['rel'] === NAMESPACE_FEED)
 351                                                 $poll = $link['@attributes']['href'];
 352                                 }
 353                         }
 354
 355                         $r = q("DELETE FROM `intro` WHERE `id` = %d AND `uid` = %d LIMIT 1",
 356                                 intval($intro_id),
 357                                 intval($uid)
 358                         );
 359
 360
 361                         $r = q("UPDATE `contact` SET `photo` = '%s',
 362                                 `thumb` = '%s',
 363                                 `micro` = '%s',
 364                                 `name-date` = '%s',
 365                                 `uri-date` = '%s',
 366                                 `avatar-date` = '%s',
 367                                 `notify` = '%s',
 368                                 `poll` = '%s',
 369                                 `blocked` = 0,
 370                                 `pending` = 0,
 371                                 `network` = 'stat'
 372                                 WHERE `id` = %d LIMIT 1
 373                         ",
 374                                 dbesc($photos[0]),
 375                                 dbesc($photos[1]),
 376                                 dbesc($photos[2]),
 377                                 dbesc(datetime_convert()),
 378                                 dbesc(datetime_convert()),
 379                                 dbesc(datetime_convert()),
 380                                 dbesc($notify),
 381                                 dbesc($poll),
 382                                 intval($contact_id)
 383                         );
 384                 }
 385
 386                 if($r === false)
 387                                 notice( t('Unable to set contact photo.') . EOL);
 388
 389                 // reload contact info
 390
 391                 $r = q("SELECT * FROM `contact` WHERE `id` = %d LIMIT 1",
 392                         intval($contact_id)
 393                 );
 394                 if(count($r))
 395                         $contact = $r[0];
 396                 else
 397                         $contact = null;
 398
 399                 // Send a new friend post if we are allowed to...
 400
 401                 $r = q("SELECT `hide-friends` FROM `profile` WHERE `uid` = %d AND `is-default` = 1 LIMIT 1",
 402                         intval($uid)
 403                 );
 404                 if((count($r)) && ($r[0]['hide-friends'] == 0) && (is_array($contact)) &&  isset($new_relation) && ($new_relation == REL_BUD)) {
 405
 406                         require_once('include/items.php');
 407
 408                         $self = q("SELECT * FROM `contact` WHERE `self` = 1 AND `uid` = %d LIMIT 1",
 409                                 intval($uid)
 410                         );
 411
 412                         if(count($self)) {
 413
 414                                 $arr = array();
 415                                 $arr['uri'] = $arr['parent-uri'] = item_new_uri($a->get_hostname(), $uid);
 416                                 $arr['uid'] = $uid;
 417                                 $arr['contact-id'] = $self[0]['id'];
 418                                 $arr['wall'] = 1;
 419                                 $arr['type'] = 'wall';
 420                                 $arr['gravity'] = 0;
 421                                 $arr['author-name'] = $arr['owner-name'] = $self[0]['name'];
 422                                 $arr['author-link'] = $arr['owner-link'] = $self[0]['url'];
 423                                 $arr['author-avatar'] = $arr['owner-avatar'] = $self[0]['thumb'];
 424                                 $arr['verb'] = ACTIVITY_FRIEND;
 425                                 $arr['object-type'] = ACTIVITY_OBJ_PERSON;
 426
 427                                 $A = '[url=' . $self[0]['url'] . ']' . $self[0]['name'] . '[/url]';
 428                                 $B = '[url=' . $contact['url'] . ']' . $contact['name'] . '[/url]';
 429                                 $BPhoto = '[url=' . $contact['url'] . ']' . '[img]' . $contact['thumb'] . '[/img][/url]';
 430                                 $arr['body'] =  sprintf( t('%1$s is now friends with %2$s'), $A, $B)."\n\n\n".$Bphoto;
 431
 432                                 $arr['object'] = '<object><type>' . ACTIVITY_OBJ_PERSON . '</type><title>' . $contact['name'] . '</title>'
 433                                         . '<id>' . $contact['url'] . '/' . $contact['name'] . '</id>';
 434                                 $arr['object'] .= '<link>' . xmlify('<link rel="alternate" type="text/html" href="' . $contact['url'] . '" />' . "\n");
 435                                 $arr['object'] .= xmlify('<link rel="photo" type="image/jpeg" href="' . $contact['thumb'] . '" />' . "\n");
 436                                 $arr['object'] .= '</link></object>' . "\n";
 437                                 $arr['last-child'] = 1;
 438
 439                                 $arr['allow_cid'] = $user[0]['allow_cid'];
 440                                 $arr['allow_gid'] = $user[0]['allow_gid'];
 441                                 $arr['deny_cid']  = $user[0]['deny_cid'];
 442                                 $arr['deny_gid']  = $user[0]['deny_gid'];
 443
 444                                 $i = item_store($arr);
 445                                 if($i)
 446                                 proc_run('php',"include/notifier.php","activity","$i");
 447
 448                         }
 449
 450                 }
 451                 // Let's send our user to the contact editor in case they want to
 452                 // do anything special with this new friend.
 453
 454                 if($handsfree === null)
 455                         goaway($a->get_baseurl() . '/contacts/' . intval($contact_id));
 456                 else
 457                         return;
 458                 //NOTREACHED
 459         }
 460
 461         /**
 462          *
 463          *
 464          * End of Scenario 1. [Local confirmation of remote friend request].
 465          *
 466          * Begin Scenario 2. This is the remote response to the above scenario.
 467          * This will take place on the site that originally initiated the friend request.
 468          * In the section above where the confirming party makes a POST and
 469          * retrieves xml status information, they are communicating with the following code.
 470          *
 471          */
 472
 473         if(x($_POST,'source_url')) {
 474
 475                 // We are processing an external confirmation to an introduction created by our user.
 476
 477                 $public_key = ((x($_POST,'public_key'))   ? $_POST['public_key']           : '');
 478                 $dfrn_id    = ((x($_POST,'dfrn_id'))      ? hex2bin($_POST['dfrn_id'])     : '');
 479                 $source_url = ((x($_POST,'source_url'))   ? hex2bin($_POST['source_url'])  : '');
 480                 $aes_key    = ((x($_POST,'aes_key'))      ? $_POST['aes_key']              : '');
 481                 $duplex     = ((x($_POST,'duplex'))       ? intval($_POST['duplex'])       : 0 );
 482                 $version_id = ((x($_POST,'dfrn_version')) ? (float) $_POST['dfrn_version'] : 2.0);
 483
 484                 logger('dfrn_confirm: requestee contacted: ' . $node);
 485
 486                 logger('dfrn_confirm: request: POST=' . print_r($_POST,true), LOGGER_DATA);
 487
 488                 // If $aes_key is set, both of these items require unpacking from the hex transport encoding.
 489
 490                 if(x($aes_key)) {
 491                         $aes_key = hex2bin($aes_key);
 492                         $public_key = hex2bin($public_key);
 493                 }
 494
 495                 // Find our user's account
 496
 497                 $r = q("SELECT * FROM `user` WHERE `nickname` = '%s' LIMIT 1",
 498                         dbesc($node));
 499
 500                 if(! count($r)) {
 501                         $message = sprintf(t('No user record found for \'%s\' '), $node);
 502                         xml_status(3,$message); // failure
 503                         // NOTREACHED
 504                 }
 505
 506                 $my_prvkey = $r[0]['prvkey'];
 507                 $local_uid = $r[0]['uid'];
 508
 509
 510                 if(! strstr($my_prvkey,'BEGIN RSA PRIVATE KEY')) {
 511                         $message = t('Our site encryption key is apparently messed up.');
 512                         xml_status(3,$message);
 513                 }
 514
 515                 // verify everything
 516
 517                 $decrypted_source_url = "";
 518                 openssl_private_decrypt($source_url,$decrypted_source_url,$my_prvkey);
 519
 520
 521                 if(! strlen($decrypted_source_url)) {
 522                         $message = t('Empty site URL was provided or URL could not be decrypted by us.');
 523                         xml_status(3,$message);
 524                         // NOTREACHED
 525                 }
 526
 527                 $ret = q("SELECT * FROM `contact` WHERE `url` = '%s' AND `uid` = %d LIMIT 1",
 528                         dbesc($decrypted_source_url),
 529                         intval($local_uid)
 530                 );
 531
 532                 if(! count($ret)) {
 533                         // this is either a bogus confirmation (?) or we deleted the original introduction.
 534                         $message = t('Contact record was not found for you on our site.');
 535                         xml_status(3,$message);
 536                         return; // NOTREACHED
 537                 }
 538
 539                 $relation = $ret[0]['rel'];
 540
 541                 // Decrypt all this stuff we just received
 542
 543                 $foreign_pubkey = $ret[0]['site-pubkey'];
 544                 $dfrn_record    = $ret[0]['id'];
 545
 546                 $decrypted_dfrn_id = "";
 547                 openssl_public_decrypt($dfrn_id,$decrypted_dfrn_id,$foreign_pubkey);
 548
 549                 if(strlen($aes_key)) {
 550                         $decrypted_aes_key = "";
 551                         openssl_private_decrypt($aes_key,$decrypted_aes_key,$my_prvkey);
 552                         $dfrn_pubkey = openssl_decrypt($public_key,'AES-256-CBC',$decrypted_aes_key);
 553                 }
 554                 else {
 555                         $dfrn_pubkey = $public_key;
 556                 }
 557
 558                 $r = q("SELECT * FROM `contact` WHERE `dfrn-id` = '%s' LIMIT 1",
 559                         dbesc($decrypted_dfrn_id)
 560                 );
 561                 if(count($r)) {
 562                         $message = t('The ID provided by your system is a duplicate on our system. It should work if you try again.');
 563                         xml_status(1,$message); // Birthday paradox - duplicate dfrn-id
 564                         // NOTREACHED
 565                 }
 566
 567                 $r = q("UPDATE `contact` SET `dfrn-id` = '%s', `pubkey` = '%s' WHERE `id` = %d LIMIT 1",
 568                         dbesc($decrypted_dfrn_id),
 569                         dbesc($dfrn_pubkey),
 570                         intval($dfrn_record)
 571                 );
 572                 if(! count($r)) {
 573                         $message = t('Unable to set your contact credentials on our system.');
 574                         xml_status(3,$message);
 575                 }
 576
 577                 // We're good but now we have to scrape the profile photo and send notifications.
 578
 579
 580
 581                 $r = q("SELECT `photo` FROM `contact` WHERE `id` = %d LIMIT 1",
 582                         intval($dfrn_record));
 583
 584                 if(count($r))
 585                         $photo = $r[0]['photo'];
 586                 else
 587                         $photo = $a->get_baseurl() . '/images/default-profile.jpg';
 588
 589                 require_once("Photo.php");
 590
 591                 $photos = import_profile_photo($photo,$local_uid,$dfrn_record);
 592
 593                 logger('dfrn_confirm: request - photos imported');
 594
 595                 $new_relation = REL_FAN;
 596                 if(($relation == REL_VIP) || ($duplex))
 597                         $new_relation = REL_BUD;
 598
 599                 if(($relation == REL_VIP) && ($duplex))
 600                         $duplex = 0;
 601
 602                 $r = q("UPDATE `contact` SET
 603                         `photo` = '%s',
 604                         `thumb` = '%s',
 605                         `micro` = '%s',
 606                         `rel` = %d,
 607                         `name-date` = '%s',
 608                         `uri-date` = '%s',
 609                         `avatar-date` = '%s',
 610                         `blocked` = 0,
 611                         `pending` = 0,
 612                         `duplex` = %d,
 613                         `network` = 'dfrn' WHERE `id` = %d LIMIT 1
 614                 ",
 615                         dbesc($photos[0]),
 616                         dbesc($photos[1]),
 617                         dbesc($photos[2]),
 618                         intval($new_relation),
 619                         dbesc(datetime_convert()),
 620                         dbesc(datetime_convert()),
 621                         dbesc(datetime_convert()),
 622                         intval($duplex),
 623                         intval($dfrn_record)
 624                 );
 625                 if($r === false) {    // indicates schema is messed up or total db failure
 626                         $message = t('Unable to update your contact profile details on our system');
 627                         xml_status(3,$message);
 628                 }
 629
 630                 // Otherwise everything seems to have worked and we are almost done. Yay!
 631                 // Send an email notification
 632
 633                 logger('dfrn_confirm: request: info updated');
 634
 635                 $r = q("SELECT * FROM `contact` LEFT JOIN `user` ON `contact`.`uid` = `user`.`uid`
 636                         WHERE `contact`.`id` = %d LIMIT 1",
 637                         intval($dfrn_record)
 638                 );
 639                 if((count($r)) && ($r[0]['notify-flags'] & NOTIFY_CONFIRM)) {
 640
 641                         $tpl = (($new_relation == REL_BUD)
 642                                 ? get_intltext_template('friend_complete_eml.tpl')
 643                                 : get_intltext_template('intro_complete_eml.tpl'));
 644
 645                         $email_tpl = replace_macros($tpl, array(
 646                                 '$sitename' => $a->config['sitename'],
 647                                 '$siteurl' =>  $a->get_baseurl(),
 648                                 '$username' => $r[0]['username'],
 649                                 '$email' => $r[0]['email'],
 650                                 '$fn' => $r[0]['name'],
 651                                 '$dfrn_url' => $r[0]['url'],
 652                                 '$uid' => $newuid )
 653                         );
 654
 655                         $res = mail($r[0]['email'], sprintf( t("Connection accepted at %s") , $a->config['sitename']),
 656                                 $email_tpl,
 657                                 'From: ' . t('Administrator') . '@' . $_SERVER['SERVER_NAME'] . "\n"
 658                                 . 'Content-type: text/plain; charset=UTF-8' . "\n"
 659                                 . 'Content-transfer-encoding: 8bit' );
 660
 661                         if(!$res) {
 662                                 // pointless throwing an error here and confusing the person at the other end of the wire.
 663                         }
 664                 }
 665                 xml_status(0); // Success
 666                 return; // NOTREACHED
 667
 668                         ////////////////////// End of this scenario ///////////////////////////////////////////////
 669         }
 670
 671         // somebody arrived here by mistake or they are fishing. Send them to the homepage.
 672
 673         goaway($a->get_baseurl());
 674         // NOTREACHED
 675
 676 }