]> git.mxchange.org Git - friendica.git/blobdiff - include/delivery.php
Mail: Subject are now with working "Re:"
[friendica.git] / include / delivery.php
old mode 100644 (file)
new mode 100755 (executable)
index be4f397..44a482c
@@ -1,5 +1,7 @@
 <?php
 require_once("boot.php");
+require_once('include/queue_fn.php');
+require_once('include/html2plain.php');
 
 function delivery_run($argv, $argc){
        global $a, $db;
@@ -7,7 +9,7 @@ function delivery_run($argv, $argc){
        if(is_null($a)){
                $a = new App;
        }
-  
+
        if(is_null($db)) {
                @include(".htconfig.php");
                require_once("dba.php");
@@ -20,6 +22,7 @@ function delivery_run($argv, $argc){
        require_once('include/items.php');
        require_once('include/bbcode.php');
        require_once('include/diaspora.php');
+       require_once('include/email.php');
 
        load_config('config');
        load_config('system');
@@ -31,12 +34,31 @@ function delivery_run($argv, $argc){
 
        $a->set_baseurl(get_config('system','url'));
 
-       logger('delivery: invoked: ' . print_r($argv,true));
+       logger('delivery: invoked: ' . print_r($argv,true), LOGGER_DEBUG);
 
        $cmd        = $argv[1];
        $item_id    = intval($argv[2]);
        $contact_id = intval($argv[3]);
 
+       // Some other process may have delivered this item already.
+
+       $r = q("select * from deliverq where cmd = '%s' and item = %d and contact = %d limit 1",
+               dbesc($cmd),
+               dbesc($item_id),
+               dbesc($contact_id)
+       );
+       if(! count($r)) {
+               return;
+       }       
+
+       // It's ours to deliver. Remove it from the queue.
+
+       q("delete from deliverq where cmd = '%s' and item = %d and contact = %d limit 1",
+               dbesc($cmd),
+               dbesc($item_id),
+               dbesc($contact_id)
+       );
+
        if((! $item_id) || (! $contact_id))
                return;
 
@@ -53,7 +75,7 @@ function delivery_run($argv, $argc){
                $normal_mode = false;
                $expire = true;
                $items = q("SELECT * FROM `item` WHERE `uid` = %d AND `wall` = 1 
-                       AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP - INTERVAL 30 MINUTE",
+                       AND `deleted` = 1 AND `changed` > UTC_TIMESTAMP() - INTERVAL 30 MINUTE",
                        intval($item_id)
                );
                $uid = $item_id;
@@ -64,7 +86,7 @@ function delivery_run($argv, $argc){
        else {
 
                // find ancestors
-               $r = q("SELECT * FROM `item` WHERE `id` = %d LIMIT 1",
+               $r = q("SELECT * FROM `item` WHERE `id` = %d and visible = 1 and moderated = 0 LIMIT 1",
                        intval($item_id)
                );
 
@@ -77,7 +99,12 @@ function delivery_run($argv, $argc){
                $uid = $r[0]['uid'];
                $updated = $r[0]['edited'];
 
-               $items = q("SELECT * FROM `item` WHERE `parent` = %d ORDER BY `id` ASC",
+               if(! $parent_id)
+                       return;
+
+
+               $items = q("SELECT `item`.*, `sign`.`signed_text`,`sign`.`signature`,`sign`.`signer` 
+                       FROM `item` LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id` WHERE `parent` = %d and visible = 1 and moderated = 0 ORDER BY `id` ASC",
                        intval($parent_id)
                );
 
@@ -85,13 +112,20 @@ function delivery_run($argv, $argc){
                        return;
                }
 
-               $icontacts = q("SELECT * FROM `contact` WHERE `id` IN ( SELECT distinct(`contact-id`) FROM `item` where `parent` = %d ) ",
-                       intval($parent_id)
-               );
-               if(! count($icontacts))
+               $icontacts = null;
+               $contacts_arr = array();
+               foreach($items as $item)
+                       if(! in_array($item['contact-id'],$contacts_arr))
+                               $contacts_arr[] = intval($item['contact-id']);
+               if(count($contacts_arr)) {
+                       $str_contacts = implode(',',$contacts_arr); 
+                       $icontacts = q("SELECT * FROM `contact` 
+                               WHERE `id` IN ( $str_contacts ) "
+                       );
+               }
+               if( ! ($icontacts && count($icontacts)))
                        return;
 
-
                // avoid race condition with deleting entries
 
                if($items[0]['deleted']) {
@@ -99,8 +133,10 @@ function delivery_run($argv, $argc){
                                $item['deleted'] = 1;
                }
 
-               if(count($items) == 1 && $items[0]['uri'] === $items[0]['parent-uri'])
+               if((count($items) == 1) && ($items[0]['uri'] === $items[0]['parent-uri'])) {
+                       logger('delivery: top level post');
                        $top_level = true;
+               }
        }
 
        $r = q("SELECT `contact`.*, `user`.`pubkey` AS `upubkey`, `user`.`prvkey` AS `uprvkey`, 
@@ -116,9 +152,12 @@ function delivery_run($argv, $argc){
 
        $owner = $r[0];
 
+       $walltowall = ((($top_level) && ($owner['id'] != $items[0]['contact-id'])) ? true : false);
+
        $public_message = true;
 
        // fill this in with a single salmon slap if applicable
+
        $slap = '';
 
        require_once('include/group.php');
@@ -169,8 +208,6 @@ function delivery_run($argv, $argc){
                $public_message = false; // private recipients, not public
        }
 
-       $conversant_str = intval($contact_id);
-
        $r = q("SELECT * FROM `contact` WHERE `id` = %d AND `blocked` = 0 AND `pending` = 0",
                intval($contact_id)
        );
@@ -178,62 +215,10 @@ function delivery_run($argv, $argc){
        if(count($r))
                $contact = $r[0];
        
-
-       $feed_template = get_markup_template('atom_feed.tpl');
-       $mail_template = get_markup_template('atom_mail.tpl');
-
-       $atom = '';
-       $slaps = array();
-
        $hubxml = feed_hublinks();
 
-       $birthday = feed_birthday($owner['uid'],$owner['timezone']);
-
-       if(strlen($birthday))
-               $birthday = '<dfrn:birthday>' . xmlify($birthday) . '</dfrn:birthday>';
-
-       $atom .= replace_macros($feed_template, array(
-                       '$version'      => xmlify(FRIENDIKA_VERSION),
-                       '$feed_id'      => xmlify($a->get_baseurl() . '/profile/' . $owner['nickname'] ),
-                       '$feed_title'   => xmlify($owner['name']),
-                       '$feed_updated' => xmlify(datetime_convert('UTC', 'UTC', $updated . '+00:00' , ATOM_TIME)) ,
-                       '$hub'          => $hubxml,
-                       '$salmon'       => '',  // private feed, we don't use salmon here
-                       '$name'         => xmlify($owner['name']),
-                       '$profile_page' => xmlify($owner['url']),
-                       '$photo'        => xmlify($owner['photo']),
-                       '$thumb'        => xmlify($owner['thumb']),
-                       '$picdate'      => xmlify(datetime_convert('UTC','UTC',$owner['avatar-date'] . '+00:00' , ATOM_TIME)) ,
-                       '$uridate'      => xmlify(datetime_convert('UTC','UTC',$owner['uri-date']    . '+00:00' , ATOM_TIME)) ,
-                       '$namdate'      => xmlify(datetime_convert('UTC','UTC',$owner['name-date']   . '+00:00' , ATOM_TIME)) ,
-                       '$birthday'     => $birthday
-       ));
-
-       foreach($items as $item) {
-               if(! $item['parent'])
-                       continue;
-
-               // private emails may be in included in public conversations. Filter them.
-               if(($public_message) && $item['private'])
-                       continue;
-
-               $item_contact = get_item_contact($item,$icontacts);
-               if(! $item_contact)
-                       continue;
-
-               $atom .= atom_entry($item,'text',$item_contact,$owner,true);
-
-               if(($top_level) && ($public_message) && ($item['author-link'] === $item['owner-link']) && (! $expire)) 
-                       $slaps[] = atom_entry($item,'html',$item_contact,$owner,true);
-       }
-
-       $atom .= '</feed>' . "\r\n";
-
-       logger('notifier: ' . $atom, LOGGER_DATA);
-
        logger('notifier: slaps: ' . print_r($slaps,true), LOGGER_DATA);
 
-
        require_once('include/salmon.php');
 
        if($contact['self'])
@@ -245,20 +230,110 @@ function delivery_run($argv, $argc){
 
                case NETWORK_DFRN :
                        logger('notifier: dfrndelivery: ' . $contact['name']);
+
+                       $feed_template = get_markup_template('atom_feed.tpl');
+                       $mail_template = get_markup_template('atom_mail.tpl');
+
+                       $atom = '';
+
+
+                       $birthday = feed_birthday($owner['uid'],$owner['timezone']);
+
+                       if(strlen($birthday))
+                               $birthday = '<dfrn:birthday>' . xmlify($birthday) . '</dfrn:birthday>';
+
+                       $atom .= replace_macros($feed_template, array(
+                                       '$version'      => xmlify(FRIENDICA_VERSION),
+                                       '$feed_id'      => xmlify($a->get_baseurl() . '/profile/' . $owner['nickname'] ),
+                                       '$feed_title'   => xmlify($owner['name']),
+                                       '$feed_updated' => xmlify(datetime_convert('UTC', 'UTC', $updated . '+00:00' , ATOM_TIME)) ,
+                                       '$hub'          => $hubxml,
+                                       '$salmon'       => '',  // private feed, we don't use salmon here
+                                       '$name'         => xmlify($owner['name']),
+                                       '$profile_page' => xmlify($owner['url']),
+                                       '$photo'        => xmlify($owner['photo']),
+                                       '$thumb'        => xmlify($owner['thumb']),
+                                       '$picdate'      => xmlify(datetime_convert('UTC','UTC',$owner['avatar-date'] . '+00:00' , ATOM_TIME)) ,
+                                       '$uridate'      => xmlify(datetime_convert('UTC','UTC',$owner['uri-date']    . '+00:00' , ATOM_TIME)) ,
+                                       '$namdate'      => xmlify(datetime_convert('UTC','UTC',$owner['name-date']   . '+00:00' , ATOM_TIME)) ,
+                                       '$birthday'     => $birthday
+                       ));
+
+                       foreach($items as $item) {
+                               if(! $item['parent'])
+                                       continue;
+
+                               // private emails may be in included in public conversations. Filter them.
+                               if(($public_message) && $item['private'])
+                                       continue;
+
+                               $item_contact = get_item_contact($item,$icontacts);
+                               if(! $item_contact)
+                                       continue;
+
+                               if($normal_mode) {
+                                       if($item_id == $item['id'] || $item['id'] == $item['parent'])
+                                               $atom .= atom_entry($item,'text',null,$owner,true);
+                               }
+                               else
+                                       $atom .= atom_entry($item,'text',null,$owner,true);
+
+                       }
+
+                       $atom .= '</feed>' . "\r\n";
+
+                       logger('notifier: ' . $atom, LOGGER_DATA);
+                       $basepath =  implode('/', array_slice(explode('/',$contact['url']),0,3));
+
+                       // perform local delivery if we are on the same site
+
+                       if(link_compare($basepath,$a->get_baseurl())) {
+
+                               $nickname = basename($contact['url']);
+                               if($contact['issued-id'])
+                                       $sql_extra = sprintf(" AND `dfrn-id` = '%s' ", dbesc($contact['issued-id']));
+                               else
+                                       $sql_extra = sprintf(" AND `issued-id` = '%s' ", dbesc($contact['dfrn-id']));
+
+                               $x = q("SELECT  `contact`.*, `contact`.`uid` AS `importer_uid`, 
+                                       `contact`.`pubkey` AS `cpubkey`, 
+                                       `contact`.`prvkey` AS `cprvkey`, 
+                                       `contact`.`thumb` AS `thumb`, 
+                                       `contact`.`url` as `url`,
+                                       `contact`.`name` as `senderName`,
+                                       `user`.* 
+                                       FROM `contact` 
+                                       LEFT JOIN `user` ON `contact`.`uid` = `user`.`uid` 
+                                       WHERE `contact`.`blocked` = 0 AND `contact`.`pending` = 0
+                                       AND `contact`.`network` = '%s' AND `user`.`nickname` = '%s'
+                                       $sql_extra
+                                       AND `user`.`account_expired` = 0 LIMIT 1",
+                                       dbesc(NETWORK_DFRN),
+                                       dbesc($nickname)
+                               );
+
+                               if(count($x)) {
+                                       if($owner['page-flags'] == PAGE_COMMUNITY && ! $x[0]['writable']) {
+                                               q("update contact set writable = 1 where id = %d limit 1",
+                                                       intval($x[0]['id'])
+                                               );
+                                               $x[0]['writable'] = 1;
+                                       }
+
+                                       require_once('library/simplepie/simplepie.inc');
+                                       logger('mod-delivery: local delivery');
+                                       local_delivery($x[0],$atom);
+                                       break;
+                               }
+                       }
+
                        $deliver_status = dfrn_deliver($owner,$contact,$atom);
 
                        logger('notifier: dfrn_delivery returns ' . $deliver_status);
-       
+
                        if($deliver_status == (-1)) {
                                logger('notifier: delivery failed: queuing message');
-                               // queue message for redelivery
-                               q("INSERT INTO `queue` ( `cid`, `created`, `last`, `content`)
-                                       VALUES ( %d, '%s', '%s', '%s') ",
-                                       intval($contact['id']),
-                                       dbesc(datetime_convert()),
-                                       dbesc(datetime_convert()),
-                                       dbesc($atom)
-                               );
+                               add_to_queue($contact['id'],NETWORK_DFRN,$atom);
                        }
                        break;
 
@@ -273,20 +348,32 @@ function delivery_run($argv, $argc){
                        // only send salmon if public - e.g. if it's ok to notify
                        // a public hub, it's ok to send a salmon
 
-                       if((count($slaps)) && ($public_message) && (! $expire)) {
+                       if(($public_message) && (! $expire)) {
+                               $slaps = array();
+
+                               foreach($items as $item) {
+                                       if(! $item['parent'])
+                                               continue;
+
+                                       // private emails may be in included in public conversations. Filter them.
+                                       if(($public_message) && $item['private'])
+                                               continue;
+
+                                       $item_contact = get_item_contact($item,$icontacts);
+                                       if(! $item_contact)
+                                               continue;
+
+                                       if(($top_level) && ($public_message) && ($item['author-link'] === $item['owner-link']) && (! $expire)) 
+                                               $slaps[] = atom_entry($item,'html',null,$owner,true);
+                               }
+
                                logger('notifier: slapdelivery: ' . $contact['name']);
                                foreach($slaps as $slappy) {
                                        if($contact['notify']) {
                                                $deliver_status = slapper($owner,$contact['notify'],$slappy);
                                                if($deliver_status == (-1)) {
                                                        // queue message for redelivery
-                                                       q("INSERT INTO `queue` ( `cid`, `created`, `last`, `content`)
-                                                               VALUES ( %d, '%s', '%s', '%s') ",
-                                                               intval($contact['id']),
-                                                               dbesc(datetime_convert()),
-                                                               dbesc(datetime_convert()),
-                                                               dbesc($slappy)
-                                                       );                                                              
+                                                       add_to_queue($contact['id'],NETWORK_OSTATUS,$slappy);
                                                }
                                        }
                                }
@@ -295,7 +382,8 @@ function delivery_run($argv, $argc){
                        break;
 
                case NETWORK_MAIL :
-                                               
+               case NETWORK_MAIL2:
+
                        if(get_config('system','dfrn_only'))
                                break;
                        // WARNING: does not currently convert to RFC2047 header encodings, etc.
@@ -334,68 +422,80 @@ function delivery_run($argv, $argc){
                                if($r1 && $r1[0]['reply_to'])
                                        $reply_to = $r1[0]['reply_to'];
 
-                               $subject  = (($it['title']) ? $it['title'] : t("\x28no subject\x29")) ;
-                               $headers  = 'From: ' . $local_user[0]['username'] . ' <' . $local_user[0]['email'] . '>' . "\n";
+                               $subject  = (($it['title']) ? email_header_encode($it['title'],'UTF-8') : t("\x28no subject\x29")) ;
+
+                               // only expose our real email address to true friends
+
+                               if(($contact['rel'] == CONTACT_IS_FRIEND) && (! $contact['blocked']))
+                                       $headers  = 'From: ' . email_header_encode($local_user[0]['username'],'UTF-8') . ' <' . $local_user[0]['email'] . '>' . "\n";
+                               else
+                                       $headers  = 'From: ' . email_header_encode($local_user[0]['username'],'UTF-8') . ' <' . t('noreply') . '@' . $a->get_hostname() . '>' . "\n";
+
                                if($reply_to)
                                        $headers .= 'Reply-to: ' . $reply_to . "\n";
-                               $headers .= 'Message-id: <' . $it['uri'] . '>' . "\n";
+
+                               // for testing purposes: Collect exported mails
+                               // $file = tempnam("/tmp/friendica/", "mail-out-");
+                               // file_put_contents($file, json_encode($it));
+
+                               $headers .= 'Message-Id: <' . iri2msgid($it['uri']). '>' . "\n";
+
+                               //logger("Mail: uri: ".$it['uri']." parent-uri ".$it['parent-uri'], LOGGER_DEBUG);
+                               //logger("Mail: Data: ".print_r($it, true), LOGGER_DEBUG);
+                               //logger("Mail: Data: ".print_r($it, true), LOGGER_DATA);
+
                                if($it['uri'] !== $it['parent-uri']) {
-                                       $header .= 'References: <' . $it['parent-uri'] . '>' . "\n";
-                                       if(! strlen($it['title'])) {
+                                       $headers .= 'References: <' . iri2msgid($it['parent-uri']) . '>' . "\n";
+                                       if(!strlen($it['title'])) {
                                                $r = q("SELECT `title` FROM `item` WHERE `parent-uri` = '%s' LIMIT 1",
-                                                       dbesc($it['parent-uri'])
-                                               );
-                                               if(count($r)) {
-                                                       $subtitle = $r[0]['title'];
-                                                       if($subtitle) {
-                                                               if(strncasecmp($subtitle,'RE:',3))
-                                                                       $subject = $subtitle;
-                                                               else
-                                                                       $subject = 'Re: ' . $subtitle;
-                                                       }
-                                               }
+                                                       dbesc($it['parent-uri']));
+
+                                               if(count($r) AND ($r[0]['title'] != ''))
+                                                       $subject = $r[0]['title'];
                                        }
+                                       if(strncasecmp($subject,'RE:',3))
+                                               $subject = 'Re: '.$subject;
                                }
-                               $headers .= 'MIME-Version: 1.0' . "\n";
-                               $headers .= 'Content-Type: text/html; charset=UTF-8' . "\n";
-                               $headers .= 'Content-Transfer-Encoding: 8bit' . "\n\n";
-                               $html    = prepare_body($it);
-                               $message = '<html><body>' . $html . '</body></html>';
-                               logger('notifier: email delivery to ' . $addr);
-                               mail($addr, $subject, $message, $headers);
+                               email_send($addr, $subject, $headers, $it);
                        }
                        break;
 
                case NETWORK_DIASPORA :
-                       logger('delivery: diaspora deliver: ' . $contact['name']);
+                       if($public_message)
+                               $loc = 'public batch ' . $contact['batch'];
+                       else 
+                               $loc = $contact['name'];
+
+                       logger('delivery: diaspora batch deliver: ' . $loc);
 
                        if(get_config('system','dfrn_only') || (! get_config('system','diaspora_enabled')) || (! $normal_mode))
                                break;
 
-                       if(! $contact['pubkey'])
+                       if((! $contact['pubkey']) && (! $public_message))
                                break;
-                                       
+
                        if($target_item['verb'] === ACTIVITY_DISLIKE) {
                                // unsupported
                                break;
                        }
                        elseif(($target_item['deleted']) && ($target_item['verb'] !== ACTIVITY_LIKE)) {
-                       logger('delivery: diaspora retract: ' . $contact['name']);
+                       logger('delivery: diaspora retract: ' . $loc);
                                // diaspora delete, 
-                               diaspora_send_retraction($target_item,$owner,$contact);
+                               diaspora_send_retraction($target_item,$owner,$contact,$public_message);
                                break;
                        }
                        elseif($target_item['parent'] != $target_item['id']) {
 
-                       logger('delivery: diaspora relay: ' . $contact['name']);
+                       logger('delivery: diaspora relay: ' . $loc);
 
                                // we are the relay - send comments, likes and unlikes to our conversants
-                               diaspora_send_relay($target_item,$owner,$contact);
+                               diaspora_send_relay($target_item,$owner,$contact,$public_message);
                                break;
                        }               
-                       elseif($top_level) {
-                               logger('delivery: diaspora status: ' . $contact['name']);
-                               diaspora_send_status($target_item,$owner,$contact);
+                       elseif(($top_level) && (! $walltowall)) {
+                               // currently no workable solution for sending walltowall
+                               logger('delivery: diaspora status: ' . $loc);
+                               diaspora_send_status($target_item,$owner,$contact,$public_message);
                                break;
                        }