- $r = q("UPDATE `contact` SET `photo` = '%s', `thumb` = '%s', `name-date` = '%s', `uri-date` = '%s', `avatar-date` = '%s', `blocked` = 0, `pending` = 0 WHERE `id` = %d LIMIT 1",
- dbesc($photo),
- dbesc($thumb),
- dbesc(datetime_convert()),
- dbesc(datetime_convert()),
- dbesc(datetime_convert()),
- intval($dfrn_record)
- );
- if($r === false)
- notice( t("Unable to set contact photo info.") . EOL);
-
- // Otherwise everything seems to have worked and we are almost done. Yay!
- // Send an email notification
-
- $r = q("SELECT * FROM `contact` LEFT JOIN `user` ON `contact`.`uid` = `user`.`uid`
- WHERE `contact`.`id` = %d LIMIT 1",
- intval($dfrn_record));
- if((count($r)) && ($r[0]['notify-flags'] & NOTIFY_CONFIRM)) {
-
- $tpl = file_get_contents('view/intro_complete_eml.tpl');
-
- $email_tpl = replace_macros($tpl, array(
- '$sitename' => $a->config['sitename'],
- '$siteurl' => $a->get_baseurl(),
- '$username' => $r[0]['username'],
- '$email' => $r[0]['email'],
- '$fn' => $r[0]['name'],
- '$dfrn_url' => $r[0]['url'],
- '$uid' => $newuid )
- );