]> git.mxchange.org Git - friendica.git/blobdiff - mod/dfrn_request.php
Add INNER JOIN to admin pending user list please @annando
[friendica.git] / mod / dfrn_request.php
index cc5a36d69cc06e1ddda4a16ca3098e66a52c0c6f..ec675865617b49d2d35f7fa8e0021117a478c16f 100644 (file)
@@ -1,5 +1,4 @@
 <?php
-
 /**
  * @file mod/dfrn_request.php
  * @brief Module: dfrn_request
  *    You also find a graphic which describes the confirmation process at
  *    https://github.com/friendica/friendica/blob/master/spec/dfrn2_contact_request.png
  */
-
 use Friendica\App;
 use Friendica\Core\Config;
 use Friendica\Core\PConfig;
 use Friendica\Core\System;
+use Friendica\Database\DBM;
+use Friendica\Model\Contact;
+use Friendica\Model\Group;
+use Friendica\Model\User;
 use Friendica\Network\Probe;
 
 require_once 'include/enotify.php';
-require_once 'include/probe.php';
-require_once 'include/group.php';
 
-function dfrn_request_init(App $a) {
-
-       if($a->argc > 1)
+function dfrn_request_init(App $a)
+{
+       if ($a->argc > 1)
                $which = $a->argv[1];
 
-       profile_load($a,$which);
+       profile_load($a, $which);
        return;
 }
 
@@ -96,7 +96,7 @@ function dfrn_request_post(App $a) {
                                        dbesc(normalise_link($dfrn_url))
                                );
 
-                               if (dbm::is_result($r)) {
+                               if (DBM::is_result($r)) {
                                        if(strlen($r[0]['dfrn-id'])) {
 
                                                /*
@@ -150,7 +150,7 @@ function dfrn_request_post(App $a) {
                                        $photo = $parms["photo"];
 
                                        // Escape the entire array
-                                       dbm::esc_array($parms);
+                                       DBM::esc_array($parms);
 
                                        /*
                                         * Create a contact record on our site for the other person
@@ -190,13 +190,12 @@ function dfrn_request_post(App $a) {
                                        dbesc($dfrn_url),
                                        $parms['key'] // this was already escaped
                                );
-                               if (dbm::is_result($r)) {
-                                       $def_gid = get_default_group(local_user(), $r[0]["network"]);
-                                       if(intval($def_gid))
-                                               group_add_member(local_user(), '', $r[0]['id'], $def_gid);
+                               if (DBM::is_result($r)) {
+                                       Group::addMember(User::getDefaultGroup($uid, $r[0]["network"]), $r[0]['id']);
 
-                                       if (isset($photo))
-                                               update_contact_avatar($photo, local_user(), $r[0]["id"], true);
+                                       if (isset($photo)) {
+                                               Contact::updateAvatar($photo, local_user(), $r[0]["id"], true);
+                                       }
 
                                        $forwardurl = System::baseUrl()."/contacts/".$r[0]['id'];
                                } else {
@@ -281,7 +280,7 @@ function dfrn_request_post(App $a) {
                                dbesc(datetime_convert('UTC','UTC','now - 24 hours')),
                                intval($uid)
                        );
-                       if (dbm::is_result($r) && count($r) > $maxreq) {
+                       if (DBM::is_result($r) && count($r) > $maxreq) {
                                notice( sprintf( t('%s has received too many connection requests today.'),  $a->profile['name']) . EOL);
                                notice( t('Spam protection measures have been invoked.') . EOL);
                                notice( t('Friends are advised to please try again in 24 hours.') . EOL);
@@ -293,42 +292,14 @@ function dfrn_request_post(App $a) {
                 *
                 * Cleanup old introductions that remain blocked.
                 * Also remove the contact record, but only if there is no existing relationship
-                * Do not remove email contacts as these may be awaiting email verification
-                */
-
-               $r = q("SELECT `intro`.*, `intro`.`id` AS `iid`, `contact`.`id` AS `cid`, `contact`.`rel`
-                       FROM `intro` LEFT JOIN `contact` on `intro`.`contact-id` = `contact`.`id`
-                       WHERE `intro`.`blocked` = 1 AND `contact`.`self` = 0
-                       AND `contact`.`network` != '%s'
-                       AND `intro`.`datetime` < UTC_TIMESTAMP() - INTERVAL 30 MINUTE ",
-                       dbesc(NETWORK_MAIL2)
-               );
-               if (dbm::is_result($r)) {
-                       foreach ($r as $rr) {
-                               if(! $rr['rel']) {
-                                       q("DELETE FROM `contact` WHERE `id` = %d AND NOT `self`",
-                                               intval($rr['cid'])
-                                       );
-                               }
-                               q("DELETE FROM `intro` WHERE `id` = %d",
-                                       intval($rr['iid'])
-                               );
-                       }
-               }
-
-               /*
-                *
-                * Cleanup any old email intros - which will have a greater lifetime
                 */
 
                $r = q("SELECT `intro`.*, `intro`.`id` AS `iid`, `contact`.`id` AS `cid`, `contact`.`rel`
                        FROM `intro` LEFT JOIN `contact` on `intro`.`contact-id` = `contact`.`id`
                        WHERE `intro`.`blocked` = 1 AND `contact`.`self` = 0
-                       AND `contact`.`network` = '%s'
-                       AND `intro`.`datetime` < UTC_TIMESTAMP() - INTERVAL 3 DAY ",
-                       dbesc(NETWORK_MAIL2)
+                       AND `intro`.`datetime` < UTC_TIMESTAMP() - INTERVAL 30 MINUTE "
                );
-               if (dbm::is_result($r)) {
+               if (DBM::is_result($r)) {
                        foreach ($r as $rr) {
                                if(! $rr['rel']) {
                                        q("DELETE FROM `contact` WHERE `id` = %d AND NOT `self`",
@@ -341,7 +312,6 @@ function dfrn_request_post(App $a) {
                        }
                }
 
-               $email_follow = (x($_POST,'email_follow') ? intval($_POST['email_follow']) : 0);
                $real_name = (x($_POST,'realname') ? notags(trim($_POST['realname'])) : '');
 
                $url = trim($_POST['dfrn_url']);
@@ -352,125 +322,25 @@ function dfrn_request_post(App $a) {
 
                $hcard = '';
 
-               if($email_follow) {
+               // Detect the network
+               $data = Probe::uri($url);
+               $network = $data["network"];
 
-                       if(! validate_email($url)) {
-                               notice( t('Invalid email address.') . EOL);
-                               return;
-                       }
+               // Canonicalise email-style profile locator
+               $url = Probe::webfingerDfrn($url,$hcard);
 
-                       $addr    = $url;
-                       $name    = ($realname) ? $realname : $addr;
-                       $nick    = substr($addr,0,strpos($addr,'@'));
-                       $url     = 'http://' . substr($addr,strpos($addr,'@') + 1);
-                       $nurl    = normalise_url($host);
-                       $poll    = 'email ' . random_string();
-                       $notify  = 'smtp ' . random_string();
-                       $network = NETWORK_MAIL2;
-                       $rel     = CONTACT_IS_FOLLOWER;
-
-                       $mail_disabled = ((function_exists('imap_open') && (! Config::get('system','imap_disabled'))) ? 0 : 1);
-                       if(Config::get('system','dfrn_only'))
-                               $mail_disabled = 1;
-
-                       if(! $mail_disabled) {
-                               $failed = false;
-                               $r = q("SELECT * FROM `mailacct` WHERE `uid` = %d LIMIT 1",
-                                       intval($uid)
-                               );
+               if (substr($url,0,5) === 'stat:') {
 
-                               if (! dbm::is_result($r)) {
-                                       notice( t('This account has not been configured for email. Request failed.') . EOL);
-                                       return;
-                               }
+                       // Every time we detect the remote subscription we define this as OStatus.
+                       // We do this even if it is not OStatus.
+                       // we only need to pass this through another section of the code.
+                       if ($network != NETWORK_DIASPORA) {
+                               $network = NETWORK_OSTATUS;
                        }
 
-                       $r = q("insert into contact ( uid, created, addr, name, nick, url, nurl, poll, notify, blocked, pending, network, rel )
-                               values( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, %d, '%s', %d ) ",
-                               intval($uid),
-                               dbesc(datetime_convert()),
-                               dbesc($addr),
-                               dbesc($name),
-                               dbesc($nick),
-                               dbesc($url),
-                               dbesc($nurl),
-                               dbesc($poll),
-                               dbesc($notify),
-                               intval($blocked),
-                               intval($pending),
-                               dbesc($network),
-                               intval($rel)
-                       );
-
-                       $r = q("SELECT `id`, `network` FROM `contact` WHERE `poll` = '%s' AND `uid` = %d LIMIT 1",
-                               dbesc($poll),
-                               intval($uid)
-                       );
-                       if (dbm::is_result($r)) {
-                               $contact_id = $r[0]['id'];
-
-                               $def_gid = get_default_group($uid, $r[0]["network"]);
-                               if (intval($def_gid))
-                                       group_add_member($uid, '', $contact_id, $def_gid);
-
-                               $photo = avatar_img($addr);
-
-                               $r = q("UPDATE `contact` SET
-                                       `photo` = '%s',
-                                       `thumb` = '%s',
-                                       `micro` = '%s',
-                                       `name-date` = '%s',
-                                       `uri-date` = '%s',
-                                       `avatar-date` = '%s',
-                                       `hidden` = 0,
-                                       WHERE `id` = %d
-                               ",
-                                       dbesc($photos[0]),
-                                       dbesc($photos[1]),
-                                       dbesc($photos[2]),
-                                       dbesc(datetime_convert()),
-                                       dbesc(datetime_convert()),
-                                       dbesc(datetime_convert()),
-                                       intval($contact_id)
-                               );
-                       }
-
-                       // contact is created. Now create an introduction
-
-                       $hash = random_string();
-
-                       $r = q("INSERT INTO `intro` ( `uid`, `contact-id`, knowyou, note, hash, datetime, blocked )
-                               VALUES( %d , %d, %d, '%s', '%s', '%s', %d ) ",
-                               intval($uid),
-                               intval($contact_id),
-                               ((x($_POST,'knowyou') && ($_POST['knowyou'] == 1)) ? 1 : 0),
-                               dbesc(notags(trim($_POST['dfrn-request-message']))),
-                               dbesc($hash),
-                               dbesc(datetime_convert()),
-                               1
-                       );
-
-                       // Next send an email verify form to the requestor.
-
+                       $url = substr($url,5);
                } else {
-                       // Detect the network
-                       $data = Probe::uri($url);
-                       $network = $data["network"];
-
-                       // Canonicalise email-style profile locator
-                       $url = Probe::webfingerDfrn($url,$hcard);
-
-                       if (substr($url,0,5) === 'stat:') {
-
-                               // Every time we detect the remote subscription we define this as OStatus.
-                               // We do this even if it is not OStatus.
-                               // we only need to pass this through another section of the code.
-                               if ($network != NETWORK_DIASPORA)
-                                       $network = NETWORK_OSTATUS;
-
-                               $url = substr($url,5);
-                       } else
-                               $network = NETWORK_DFRN;
+                       $network = NETWORK_DFRN;
                }
 
                logger('dfrn_request: url: ' . $url . ',network=' . $network, LOGGER_DEBUG);
@@ -481,7 +351,7 @@ function dfrn_request_post(App $a) {
                                dbesc($url)
                        );
 
-                       if (dbm::is_result($ret)) {
+                       if (DBM::is_result($ret)) {
                                if(strlen($ret[0]['issued-id'])) {
                                        notice( t('You have already introduced yourself here.') . EOL );
                                        return;
@@ -553,7 +423,7 @@ function dfrn_request_post(App $a) {
                                $parms['issued-id'] = $issued_id;
                                $photo = $parms["photo"];
 
-                               dbm::esc_array($parms);
+                               DBM::esc_array($parms);
                                $r = q("INSERT INTO `contact` ( `uid`, `created`, `url`, `nurl`, `addr`, `name`, `nick`, `issued-id`, `photo`, `site-pubkey`,
                                        `request`, `confirm`, `notify`, `poll`, `poco`, `network`, `blocked`, `pending` )
                                        VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, %d )",
@@ -585,9 +455,9 @@ function dfrn_request_post(App $a) {
                                                $parms['url'],
                                                $parms['issued-id']
                                        );
-                                       if (dbm::is_result($r)) {
+                                       if (DBM::is_result($r)) {
                                                $contact_record = $r[0];
-                                               update_contact_avatar($photo, $uid, $contact_record["id"], true);
+                                               Contact::updateAvatar($photo, $uid, $contact_record["id"], true);
                                        }
                                }
 
@@ -736,7 +606,7 @@ function dfrn_request_content(App $a) {
                        dbesc($_GET['confirm_key'])
                );
 
-               if (dbm::is_result($intro)) {
+               if (DBM::is_result($intro)) {
 
                        $r = q("SELECT `contact`.*, `user`.* FROM `contact` LEFT JOIN `user` ON `contact`.`uid` = `user`.`uid`
                                WHERE `contact`.`id` = %d LIMIT 1",
@@ -745,7 +615,7 @@ function dfrn_request_content(App $a) {
 
                        $auto_confirm = false;
 
-                       if (dbm::is_result($r)) {
+                       if (DBM::is_result($r)) {
                                if(($r[0]['page-flags'] != PAGE_NORMAL) && ($r[0]['page-flags'] != PAGE_PRVGROUP))
                                        $auto_confirm = true;
 
@@ -850,27 +720,6 @@ function dfrn_request_content(App $a) {
 
                $page_desc = t("Please enter your 'Identity Address' from one of the following supported communications networks:");
 
-               // see if we are allowed to have NETWORK_MAIL2 contacts
-
-               $mail_disabled = ((function_exists('imap_open') && (! Config::get('system','imap_disabled'))) ? 0 : 1);
-
-               if (Config::get('system','dfrn_only')) {
-                       $mail_disabled = 1;
-               }
-
-               if (! $mail_disabled) {
-                       $r = q("SELECT * FROM `mailacct` WHERE `uid` = %d LIMIT 1",
-                               intval($a->profile['uid'])
-                       );
-                       if (! dbm::is_result($r)) {
-                               $mail_disabled = 1;
-                       }
-               }
-
-               // "coming soon" is disabled for now
-               //$emailnet = (($mail_disabled) ? '' : t("<strike>Connect as an email follower</strike> \x28Coming soon\x29"));
-               $emailnet = "";
-
                $invite_desc = sprintf(
                        t('If you are not yet a member of the free social web, <a href="%s/siteinfo">follow this link to find a public Friendica site and join us today</a>.'),
                        get_server()
@@ -878,7 +727,7 @@ function dfrn_request_content(App $a) {
 
                $o = replace_macros($tpl,array(
                        '$header' => t('Friend/Connection Request'),
-                       '$desc' => t('Examples: jojo@demo.friendica.com, http://demo.friendica.com/profile/jojo, testuser@identi.ca'),
+                       '$desc' => t('Examples: jojo@demo.friendica.com, http://demo.friendica.com/profile/jojo, testuser@gnusocial.de'),
                        '$pls_answer' => t('Please answer the following:'),
                        '$does_know_you' => array('knowyou', sprintf(t('Does %s know you?'),$a->profile['name']), false, '', array(t('No'), t('Yes'))),
                        /*'$does_know' => sprintf( t('Does %s know you?'),$a->profile['name']),
@@ -887,12 +736,11 @@ function dfrn_request_content(App $a) {
                        '$add_note' => t('Add a personal note:'),
                        '$page_desc' => $page_desc,
                        '$friendica' => t('Friendica'),
-                       '$statusnet' => t('StatusNet/Federated Social Web'),
-                       '$diaspora' => t('Diaspora'),
+                       '$statusnet' => t('GNU Social (Pleroma, Mastodon)'),
+                       '$diaspora' => t('Diaspora (Socialhome, Hubzilla)'),
                        '$diasnote' => sprintf (t(' - please do not use this form.  Instead, enter %s into your Diaspora search bar.'),$target_addr),
                        '$your_address' => t('Your Identity Address:'),
                        '$invite_desc' => $invite_desc,
-                       '$emailnet' => $emailnet,
                        '$submit' => t('Submit Request'),
                        '$cancel' => t('Cancel'),
                        '$nickname' => $a->argv[1],