]> git.mxchange.org Git - friendica.git/blobdiff - mod/message.php
Merge pull request #4008 from zeroadam/Oauth-#3878
[friendica.git] / mod / message.php
index 3d5a9b5a909e0ada970c009722606634403b83a4..cefc44356f34a01101f1942ffa35c3e6444cd77c 100644 (file)
@@ -1,8 +1,13 @@
 <?php
 
-require_once('include/acl_selectors.php');
-require_once('include/message.php');
-require_once('include/Smilies.php');
+use Friendica\App;
+use Friendica\Content\Smilies;
+use Friendica\Core\System;
+use Friendica\Database\DBM;
+use Friendica\Object\Contact;
+
+require_once 'include/acl_selectors.php';
+require_once 'include/message.php';
 
 function message_init(App $a) {
 
@@ -24,17 +29,17 @@ function message_init(App $a) {
                '$tabs'=>$tabs,
                '$new'=>$new,
        ));
-       $base = App::get_baseurl();
+       $base = System::baseUrl();
 
        $head_tpl = get_markup_template('message-head.tpl');
        $a->page['htmlhead'] .= replace_macros($head_tpl,array(
-               '$baseurl' => App::get_baseurl(true),
+               '$baseurl' => System::baseUrl(true),
                '$base' => $base
        ));
 
        $end_tpl = get_markup_template('message-end.tpl');
        $a->page['end'] .= replace_macros($end_tpl,array(
-               '$baseurl' => App::get_baseurl(true),
+               '$baseurl' => System::baseUrl(true),
                '$base' => $base
        ));
 
@@ -78,9 +83,8 @@ function message_post(App $a) {
        if ($norecip) {
                $a->argc = 2;
                $a->argv[1] = 'new';
-       } else {
+       } else
                goaway($_SESSION['return_url']);
-       }
 
 }
 
@@ -97,7 +101,7 @@ function item_extract_images($body) {
        $img_start = strpos($orig_body, '[img');
        $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
        $img_end = ($img_start !== false ? strpos(substr($orig_body, $img_start), '[/img]') : false);
-       while (($img_st_close !== false) && ($img_end !== false)) {
+       while(($img_st_close !== false) && ($img_end !== false)) {
 
                $img_st_close++; // make it point to AFTER the closing bracket
                $img_end += $img_start;
@@ -109,15 +113,13 @@ function item_extract_images($body) {
                        $new_body = $new_body . substr($orig_body, 0, $img_start) . '[!#saved_image' . $cnt . '#!]';
 
                        $cnt++;
-               } else {
+               } else
                        $new_body = $new_body . substr($orig_body, 0, $img_end + strlen('[/img]'));
-               }
 
                $orig_body = substr($orig_body, $img_end + strlen('[/img]'));
 
-               if ($orig_body === false) {// in case the body ends on a closing image tag
+               if ($orig_body === false) // in case the body ends on a closing image tag
                        $orig_body = '';
-               }
 
                $img_start = strpos($orig_body, '[img');
                $img_st_close = ($img_start !== false ? strpos(substr($orig_body, $img_start), ']') : false);
@@ -135,9 +137,9 @@ function item_redir_and_replace_images($body, $images, $cid) {
        $origbody = $body;
        $newbody = '';
 
-       for ($i = 0; $i < count($images); $i++) {
+       for($i = 0; $i < count($images); $i++) {
                $search = '/\[url\=(.*?)\]\[!#saved_image' . $i . '#!\]\[\/url\]' . '/is';
-               $replace = '[url=' . z_path() . '/redir/' . $cid
+               $replace = '[url=' . System::baseUrl() . '/redir/' . $cid
                           . '?f=1&url=' . '$1' . '][!#saved_image' . $i . '#!][/url]' ;
 
                $img_end = strpos($origbody, '[!#saved_image' . $i . '#!][/url]') + strlen('[!#saved_image' . $i . '#!][/url]');
@@ -173,7 +175,7 @@ function message_content(App $a) {
                return;
        }
 
-       $myprofile = App::get_baseurl().'/profile/' . $a->user['nickname'];
+       $myprofile = System::baseUrl().'/profile/' . $a->user['nickname'];
 
        $tpl = get_markup_template('mail_head.tpl');
        $header = replace_macros($tpl, array(
@@ -192,7 +194,7 @@ function message_content(App $a) {
                        // so add any arguments as hidden inputs
                        $query = explode_querystring($a->query_string);
                        $inputs = array();
-                       foreach ($query['args'] as $arg) {
+                       foreach($query['args'] as $arg) {
                                if (strpos($arg, 'confirm=') === false) {
                                        $arg_parts = explode('=', $arg);
                                        $inputs[] = array('name' => $arg_parts[0], 'value' => $arg_parts[1]);
@@ -224,15 +226,14 @@ function message_content(App $a) {
                        if ($r) {
                                info( t('Message deleted.') . EOL );
                        }
-                       //goaway(App::get_baseurl(true) . '/message' );
+                       //goaway(System::baseUrl(true) . '/message' );
                        goaway($_SESSION['return_url']);
-               }
-               else {
+               } else {
                        $r = q("SELECT `parent-uri`,`convid` FROM `mail` WHERE `id` = %d AND `uid` = %d LIMIT 1",
                                intval($a->argv[2]),
                                intval(local_user())
                        );
-                       if (dbm::is_result($r)) {
+                       if (DBM::is_result($r)) {
                                $parent = $r[0]['parent-uri'];
                                $convid = $r[0]['convid'];
 
@@ -252,11 +253,10 @@ function message_content(App $a) {
                                //      );
                                //}
 
-                               if ($r) {
+                               if ($r)
                                        info( t('Conversation removed.') . EOL );
-                               }
                        }
-                       //goaway(App::get_baseurl(true) . '/message' );
+                       //goaway(System::baseUrl(true) . '/message' );
                        goaway($_SESSION['return_url']);
                }
 
@@ -268,14 +268,14 @@ function message_content(App $a) {
 
                $tpl = get_markup_template('msg-header.tpl');
                $a->page['htmlhead'] .= replace_macros($tpl, array(
-                       '$baseurl' => App::get_baseurl(true),
+                       '$baseurl' => System::baseUrl(true),
                        '$nickname' => $a->user['nickname'],
                        '$linkurl' => t('Please enter a link URL:')
                ));
 
                $tpl = get_markup_template('msg-end.tpl');
                $a->page['end'] .= replace_macros($tpl, array(
-                       '$baseurl' => App::get_baseurl(true),
+                       '$baseurl' => System::baseUrl(true),
                        '$nickname' => $a->user['nickname'],
                        '$linkurl' => t('Please enter a link URL:')
                ));
@@ -290,21 +290,21 @@ function message_content(App $a) {
                                intval(local_user()),
                                intval($a->argv[2])
                        );
-                       if (!dbm::is_result($r)) {
+                       if (!DBM::is_result($r)) {
                                $r = q("SELECT `name`, `url`, `id` FROM `contact` WHERE `uid` = %d AND `nurl` = '%s' LIMIT 1",
                                        intval(local_user()),
                                        dbesc(normalise_link(base64_decode($a->argv[2])))
                                );
                        }
 
-                       if (!dbm::is_result($r)) {
+                       if (!DBM::is_result($r)) {
                                $r = q("SELECT `name`, `url`, `id` FROM `contact` WHERE `uid` = %d AND `addr` = '%s' LIMIT 1",
                                        intval(local_user()),
                                        dbesc(base64_decode($a->argv[2]))
                                );
                        }
 
-                       if (dbm::is_result($r)) {
+                       if (DBM::is_result($r)) {
                                $prename = $r[0]['name'];
                                $preurl = $r[0]['url'];
                                $preid = $r[0]['id'];
@@ -351,18 +351,18 @@ function message_content(App $a) {
 
                $o .= $header;
 
-               $r = q("SELECT count(*) AS `total` FROM `mail`
+               $r = q("SELECT count(*) AS `total`, ANY_VALUE(`created`) AS `created` FROM `mail`
                        WHERE `mail`.`uid` = %d GROUP BY `parent-uri` ORDER BY `created` DESC",
                        intval(local_user())
                );
 
-               if (dbm::is_result($r)) {
+               if (DBM::is_result($r)) {
                        $a->set_pager_total($r[0]['total']);
                }
 
                $r = get_messages(local_user(), $a->pager['start'], $a->pager['itemspage']);
 
-               if (! dbm::is_result($r)) {
+               if (! DBM::is_result($r)) {
                        info( t('No messages.') . EOL);
                        return $o;
                }
@@ -384,7 +384,7 @@ function message_content(App $a) {
                        intval(local_user()),
                        intval($a->argv[1])
                );
-               if (dbm::is_result($r)) {
+               if (DBM::is_result($r)) {
                        $contact_id = $r[0]['contact-id'];
                        $convid = $r[0]['convid'];
 
@@ -415,14 +415,14 @@ function message_content(App $a) {
 
                $tpl = get_markup_template('msg-header.tpl');
                $a->page['htmlhead'] .= replace_macros($tpl, array(
-                       '$baseurl' => App::get_baseurl(true),
+                       '$baseurl' => System::baseUrl(true),
                        '$nickname' => $a->user['nickname'],
                        '$linkurl' => t('Please enter a link URL:')
                ));
 
                $tpl = get_markup_template('msg-end.tpl');
                $a->page['end'] .= replace_macros($tpl, array(
-                       '$baseurl' => App::get_baseurl(true),
+                       '$baseurl' => System::baseUrl(true),
                        '$nickname' => $a->user['nickname'],
                        '$linkurl' => t('Please enter a link URL:')
                ));
@@ -431,10 +431,9 @@ function message_content(App $a) {
                $seen = 0;
                $unknown = false;
 
-               foreach ($messages as $message) {
-                       if ($message['unknown']) {
+               foreach($messages as $message) {
+                       if ($message['unknown'])
                                $unknown = true;
-                       }
                        if ($message['from-url'] == $myprofile) {
                                $from_url = $myprofile;
                                $sparkle = '';
@@ -448,41 +447,33 @@ function message_content(App $a) {
 
 
                        $extracted = item_extract_images($message['body']);
-                       if ($extracted['images']) {
+                       if ($extracted['images'])
                                $message['body'] = item_redir_and_replace_images($extracted['body'], $extracted['images'], $message['contact-id']);
-                       }
 
-                       if ($a->theme['template_engine'] === 'internal') {
-                               $from_name_e = template_escape($message['from-name']);
-                               $subject_e = template_escape($message['title']);
-                               $body_e = template_escape(Smilies::replace(bbcode($message['body'])));
-                               $to_name_e = template_escape($message['name']);
-                       } else {
-                               $from_name_e = $message['from-name'];
-                               $subject_e = $message['title'];
-                               $body_e = Smilies::replace(bbcode($message['body']));
-                               $to_name_e = $message['name'];
-                       }
+                       $from_name_e = $message['from-name'];
+                       $subject_e = $message['title'];
+                       $body_e = Smilies::replace(bbcode($message['body']));
+                       $to_name_e = $message['name'];
 
-                       $contact = get_contact_details_by_url($message['from-url']);
-                       if (isset($contact["thumb"])) {
+                       $contact = Contact::getDetailsByURL($message['from-url']);
+                       if (isset($contact["thumb"]))
                                $from_photo = $contact["thumb"];
-                       } else {
+                       else
                                $from_photo = $message['from-photo'];
-                       }
 
                        $mails[] = array(
-                               'id'         => $message['id'],
-                               'from_name'  => $from_name_e,
-                               'from_url'   => $from_url,
-                               'sparkle'    => $sparkle,
+                               'id' => $message['id'],
+                               'from_name' => $from_name_e,
+                               'from_url' => $from_url,
+                               'from_addr' => $contact['addr'],
+                               'sparkle' => $sparkle,
                                'from_photo' => proxy_url($from_photo, false, PROXY_SIZE_THUMB),
-                               'subject'    => $subject_e,
-                               'body'       => $body_e,
-                               'delete'     => t('Delete message'),
-                               'to_name'    => $to_name_e,
-                               'date'       => datetime_convert('UTC',date_default_timezone_get(),$message['created'],'D, d M Y - g:i A'),
-                               'ago'        => relative_date($message['created']),
+                               'subject' => $subject_e,
+                               'body' => $body_e,
+                               'delete' => t('Delete message'),
+                               'to_name' => $to_name_e,
+                               'date' => datetime_convert('UTC',date_default_timezone_get(),$message['created'],'D, d M Y - g:i A'),
+                                'ago' => relative_date($message['created']),
                        );
 
                        $seen = $message['seen'];
@@ -494,11 +485,7 @@ function message_content(App $a) {
 
                $tpl = get_markup_template('mail_display.tpl');
 
-               if ($a->theme['template_engine'] === 'internal') {
-                       $subjtxt_e = template_escape($message['title']);
-               } else {
-                       $subjtxt_e = $message['title'];
-               }
+               $subjtxt_e = $message['title'];
 
                $o = replace_macros($tpl, array(
                        '$thread_id' => $a->argv[1],
@@ -532,12 +519,20 @@ function message_content(App $a) {
 }
 
 function get_messages($user, $lstart, $lend) {
-
+       //TODO: rewritte with a sub-query to get the first message of each private thread with certainty
        return q("SELECT max(`mail`.`created`) AS `mailcreated`, min(`mail`.`seen`) AS `mailseen`,
-               `mail`.* , `contact`.`name`, `contact`.`url`, `contact`.`thumb` , `contact`.`network`,
-               count( * ) as count
+               ANY_VALUE(`mail`.`id`) AS `id`, ANY_VALUE(`mail`.`uid`) AS `uid`, ANY_VALUE(`mail`.`guid`) AS `guid`,
+               ANY_VALUE(`mail`.`from-name`) AS `from-name`, ANY_VALUE(`mail`.`from-photo`) AS `from-photo`,
+               ANY_VALUE(`mail`.`from-url`) AS `from-url`, ANY_VALUE(`mail`.`contact-id`) AS `contact-id`,
+               ANY_VALUE(`mail`.`convid`) AS `convid`, ANY_VALUE(`mail`.`title`) AS `title`, ANY_VALUE(`mail`.`body`) AS `body`,
+               ANY_VALUE(`mail`.`seen`) AS `seen`, ANY_VALUE(`mail`.`reply`) AS `reply`, ANY_VALUE(`mail`.`replied`) AS `replied`,
+               ANY_VALUE(`mail`.`unknown`) AS `unknown`, ANY_VALUE(`mail`.`uri`) AS `uri`,
+               `mail`.`parent-uri`,
+               ANY_VALUE(`mail`.`created`) AS `created`, ANY_VALUE(`contact`.`name`) AS `name`, ANY_VALUE(`contact`.`url`) AS `url`,
+               ANY_VALUE(`contact`.`thumb`) AS `thumb`, ANY_VALUE(`contact`.`network`) AS `network`,
+               count( * ) as `count`
                FROM `mail` LEFT JOIN `contact` ON `mail`.`contact-id` = `contact`.`id`
-               WHERE `mail`.`uid` = %d GROUP BY `parent-uri` ORDER BY `mailcreated` DESC  LIMIT %d , %d ",
+               WHERE `mail`.`uid` = %d GROUP BY `parent-uri` ORDER BY `mailcreated` DESC LIMIT %d , %d ",
                intval($user), intval($lstart), intval($lend)
        );
 }
@@ -549,9 +544,9 @@ function render_messages(array $msg, $t) {
        $tpl = get_markup_template($t);
        $rslt = '';
 
-       $myprofile = App::get_baseurl().'/profile/' . $a->user['nickname'];
+       $myprofile = System::baseUrl().'/profile/' . $a->user['nickname'];
 
-       foreach ($msg as $rr) {
+       foreach($msg as $rr) {
 
                if ($rr['unknown'])
                        $participants = sprintf( t("Unknown sender - %s"),$rr['from-name']);
@@ -560,18 +555,11 @@ function render_messages(array $msg, $t) {
                else
                        $participants = sprintf(t("%s and You"), $rr['from-name']);
 
-               if ($a->theme['template_engine'] === 'internal') {
-                       $subject_e = template_escape((($rr['mailseen']) ? $rr['title'] : '<strong>' . $rr['title'] . '</strong>'));
-                       $body_e = template_escape($rr['body']);
-                       $to_name_e = template_escape($rr['name']);
-               }
-               else {
-                       $subject_e = (($rr['mailseen']) ? $rr['title'] : '<strong>' . $rr['title'] . '</strong>');
-                       $body_e = $rr['body'];
-                       $to_name_e = $rr['name'];
-               }
+               $subject_e = (($rr['mailseen']) ? $rr['title'] : '<strong>' . $rr['title'] . '</strong>');
+               $body_e = $rr['body'];
+               $to_name_e = $rr['name'];
 
-               $contact = get_contact_details_by_url($rr['url']);
+               $contact = Contact::getDetailsByURL($rr['url']);
                if (isset($contact["thumb"]))
                        $from_photo = $contact["thumb"];
                else
@@ -581,6 +569,7 @@ function render_messages(array $msg, $t) {
                        '$id' => $rr['id'],
                        '$from_name' => $participants,
                        '$from_url' => (($rr['network'] === NETWORK_DFRN) ? 'redir/' . $rr['contact-id'] : $rr['url']),
+                       '$from_addr' => $contact['addr'],
                        '$sparkle' => ' sparkle',
                        '$from_photo' => proxy_url($from_photo, false, PROXY_SIZE_THUMB),
                        '$subject' => $subject_e,