]> git.mxchange.org Git - friendica.git/blobdiff - include/enotify.php
Don't try to build form for "None" backend.
[friendica.git] / include / enotify.php
index dc030fa8b8985b77ed7a446dafcf864c6869586d..9edfaaca82b8e2ea2a5b46365b94ad74c859fd61 100644 (file)
@@ -2,69 +2,92 @@
 /**
  * @file include/enotify.php
  */
-use Friendica\App;
+
+use Friendica\Content\Text\BBCode;
+use Friendica\Core\Addon;
 use Friendica\Core\Config;
+use Friendica\Core\L10n;
+use Friendica\Core\Logger;
+use Friendica\Core\Renderer;
 use Friendica\Core\System;
-use Friendica\Database\DBM;
+use Friendica\Database\DBA;
+use Friendica\Model\Contact;
+use Friendica\Model\Item;
+use Friendica\Util\DateTimeFormat;
 use Friendica\Util\Emailer;
-
-require_once 'include/email.php';
-require_once 'include/bbcode.php';
-require_once 'include/html2bbcode.php';
+use Friendica\Util\Strings;
 
 /**
  * @brief Creates a notification entry and possibly sends a mail
  *
  * @param array $params Array with the elements:
                      uid, item, parent, type, otype, verb, event,
                      link, subject, body, to_name, to_email, source_name,
                      source_link, activity, preamble, notify_flags,
                      language, show_in_notification_page
*                     uid, item, parent, type, otype, verb, event,
*                     link, subject, body, to_name, to_email, source_name,
*                     source_link, activity, preamble, notify_flags,
*                     language, show_in_notification_page
  */
-function notification($params) {
+function notification($params)
+{
+       $a = \get_app();
 
-       $a = get_app();
+       // Temporary logging for finding the origin
+       if (!isset($params['language']) || !isset($params['uid'])) {
+               Logger::log('Missing parameters.' . System::callstack());
+       }
 
-       // from here on everything is in the recipients language
+       // Ensure that the important fields are set at any time
+       $fields = ['notify-flags', 'language', 'username', 'email'];
+       $user = DBA::selectFirst('user', $fields, ['uid' => $params['uid']]);
 
-       push_lang($params['language']);
+       if (!DBA::isResult($user)) {
+               Logger::log('Unknown user ' . $params['uid']);
+               return;
+       }
+
+       $params['notify_flags'] = defaults($params, 'notify_flags', $user['notify-flags']);
+       $params['language']     = defaults($params, 'language'    , $user['language']);
+       $params['to_name']      = defaults($params, 'to_name'     , $user['username']);
+       $params['to_email']     = defaults($params, 'to_email'    , $user['email']);
 
-       $banner = t('Friendica Notification');
+       // from here on everything is in the recipients language
+       L10n::pushLang($params['language']);
+
+       $banner = L10n::t('Friendica Notification');
        $product = FRIENDICA_PLATFORM;
        $siteurl = System::baseUrl(true);
-       $thanks = t('Thank You,');
-       $sitename = $a->config['sitename'];
-       if (!x($a->config['admin_name']))
-           $site_admin = sprintf(t('%s Administrator'), $sitename);
-       else
-           $site_admin = sprintf(t('%1$s, %2$s Administrator'), $a->config['admin_name'], $sitename);
-
-       $nickname = "";
+       $thanks = L10n::t('Thank You,');
+       $sitename = Config::get('config', 'sitename');
+       if (Config::get('config', 'admin_name')) {
+               $site_admin = L10n::t('%1$s, %2$s Administrator', Config::get('config', 'admin_name'), $sitename);
+       } else {
+               $site_admin = L10n::t('%s Administrator', $sitename);
+       }
 
        $sender_name = $sitename;
-       $hostname = $a->get_hostname();
-       if (strpos($hostname, ':'))
+       $hostname = $a->getHostName();
+       if (strpos($hostname, ':')) {
                $hostname = substr($hostname, 0, strpos($hostname, ':'));
+       }
 
-       $sender_email = $a->config['sender_email'];
-       if (empty($sender_email))
-               $sender_email = t('noreply').'@'.$hostname;
+       $sender_email = $a->getSenderEmailAddress();
 
        if ($params['type'] != SYSTEM_EMAIL) {
-               $user = dba::select('user', array('nickname', 'page-flags'),
-                       array('uid' => $params['uid']), array('limit' => 1));
+               $user = DBA::selectFirst('user', ['nickname', 'page-flags'],
+                       ['uid' => $params['uid']]);
 
                // There is no need to create notifications for forum accounts
-               if (!DBM::is_result($user) || in_array($user["page-flags"], array(PAGE_COMMUNITY, PAGE_PRVGROUP))) {
+               if (!DBA::isResult($user) || in_array($user["page-flags"], [Contact::PAGE_COMMUNITY, Contact::PAGE_PRVGROUP])) {
                        return;
                }
+               $nickname = $user["nickname"];
+       } else {
+               $nickname = '';
        }
-       $nickname = $user["nickname"];
 
        // with $params['show_in_notification_page'] == false, the notification isn't inserted into
        // the database, and an email is sent if applicable.
        // default, if not specified: true
-       $show_in_notification_page = ((x($params, 'show_in_notification_page')) ? $params['show_in_notification_page']:true);
+       $show_in_notification_page = isset($params['show_in_notification_page']) ? $params['show_in_notification_page'] : true;
 
        $additional_mail_header = "";
        $additional_mail_header .= "Precedence: list\n";
@@ -78,217 +101,223 @@ function notification($params) {
        if (array_key_exists('item', $params)) {
                $title = $params['item']['title'];
                $body = $params['item']['body'];
-       } else
+       } else {
                $title = $body = '';
+       }
 
-       // e.g. "your post", "David's photo", etc.
-       $possess_desc = t('%s <!item_type!>');
-
-       if (isset($params['item']['id']))
+       if (isset($params['item']['id'])) {
                $item_id = $params['item']['id'];
-       else
+       } else {
                $item_id = 0;
+       }
 
-       if (isset($params['parent']))
+       if (isset($params['parent'])) {
                $parent_id = $params['parent'];
-       else
+       } else {
                $parent_id = 0;
+       }
+
+       $epreamble = '';
 
        if ($params['type'] == NOTIFY_MAIL) {
-               $subject = sprintf(t('[Friendica:Notify] New mail received at %s'), $sitename);
+               $itemlink = $siteurl.'/message/'.$params['item']['id'];
+               $params["link"] = $itemlink;
+
+               $subject = L10n::t('[Friendica:Notify] New mail received at %s', $sitename);
 
-               $preamble = sprintf(t('%1$s sent you a new private message at %2$s.'), $params['source_name'], $sitename);
-               $epreamble = sprintf(t('%1$s sent you %2$s.'), '[url='.$params['source_link'].']'.$params['source_name'].'[/url]', '[url=$itemlink]'.t('a private message').'[/url]');
+               $preamble = L10n::t('%1$s sent you a new private message at %2$s.', $params['source_name'], $sitename);
+               $epreamble = L10n::t('%1$s sent you %2$s.', '[url='.$params['source_link'].']'.$params['source_name'].'[/url]', '[url=$itemlink]'.L10n::t('a private message').'[/url]');
 
-               $sitelink = t('Please visit %s to view and/or reply to your private messages.');
+               $sitelink = L10n::t('Please visit %s to view and/or reply to your private messages.');
                $tsitelink = sprintf($sitelink, $siteurl.'/message/'.$params['item']['id']);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'/message/'.$params['item']['id'].'">'.$sitename.'</a>');
-               $itemlink = $siteurl.'/message/'.$params['item']['id'];
        }
 
        if ($params['type'] == NOTIFY_COMMENT) {
-               $p = q("SELECT `ignored` FROM `thread` WHERE `iid` = %d AND `uid` = %d LIMIT 1",
-                       intval($parent_id),
-                       intval($params['uid'])
-               );
-               if ($p && count($p) && ($p[0]["ignored"])) {
-                       logger("Thread ".$parent_id." will be ignored", LOGGER_DEBUG);
+               $thread = Item::selectFirstThreadForUser($params['uid'] ,['ignored'], ['iid' => $parent_id]);
+               if (DBA::isResult($thread) && $thread["ignored"]) {
+                       Logger::log("Thread ".$parent_id." will be ignored", Logger::DEBUG);
+                       L10n::popLang();
                        return;
                }
 
                // Check to see if there was already a tag notify or comment notify for this post.
                // If so don't create a second notification
-
-               $p = null;
-               $p = q("SELECT `id` FROM `notify` WHERE `type` IN (%d, %d, %d) AND `link` = '%s' AND `uid` = %d LIMIT 1",
-                       intval(NOTIFY_TAGSELF),
-                       intval(NOTIFY_COMMENT),
-                       intval(NOTIFY_SHARE),
-                       dbesc($params['link']),
-                       intval($params['uid'])
-               );
-               if ($p && count($p)) {
-                       pop_lang();
+               $condition = ['type' => [NOTIFY_TAGSELF, NOTIFY_COMMENT, NOTIFY_SHARE],
+                       'link' => $params['link'], 'uid' => $params['uid']];
+               if (DBA::exists('notify', $condition)) {
+                       L10n::popLang();
                        return;
                }
 
                // if it's a post figure out who's post it is.
 
-               $p = null;
+               $item = null;
 
                if ($params['otype'] === 'item' && $parent_id) {
-                       $p = q("SELECT * FROM `item` WHERE `id` = %d AND `uid` = %d LIMIT 1",
-                               intval($parent_id),
-                               intval($params['uid'])
-                       );
+                       $item = Item::selectFirstForUser($params['uid'], Item::ITEM_FIELDLIST, ['id' => $parent_id]);
                }
 
-               $item_post_type = item_post_type($p[0]);
+               $item_post_type = Item::postType($item);
+               $itemlink = $item['plink'];
 
                // "a post"
-               $dest_str = sprintf(t('%1$s commented on [url=%2$s]a %3$s[/url]'),
-                                                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                                               $itemlink,
-                                                               $item_post_type);
+               $dest_str = L10n::t('%1$s commented on [url=%2$s]a %3$s[/url]',
+                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                       $itemlink,
+                       $item_post_type
+               );
 
                // "George Bull's post"
-               if ($p)
-                       $dest_str = sprintf(t('%1$s commented on [url=%2$s]%3$s\'s %4$s[/url]'),
-                                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                               $itemlink,
-                                               $p[0]['author-name'],
-                                               $item_post_type);
+               if ($item) {
+                       $dest_str = L10n::t('%1$s commented on [url=%2$s]%3$s\'s %4$s[/url]',
+                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                               $itemlink,
+                               $item['author-name'],
+                               $item_post_type
+                       );
+               }
 
                // "your post"
-               if ($p[0]['owner-name'] == $p[0]['author-name'] && $p[0]['wall'])
-                       $dest_str = sprintf(t('%1$s commented on [url=%2$s]your %3$s[/url]'),
-                                                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                                               $itemlink,
-                                                               $item_post_type);
+               if (DBA::isResult($item) && $item['owner-id'] == $item['author-id'] && $item['wall']) {
+                       $dest_str = L10n::t('%1$s commented on [url=%2$s]your %3$s[/url]',
+                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                               $itemlink,
+                               $item_post_type
+                       );
+               }
 
                // Some mail softwares relies on subject field for threading.
                // So, we cannot have different subjects for notifications of the same thread.
                // Before this we have the name of the replier on the subject rendering
                // differents subjects for messages on the same thread.
 
-               $subject = sprintf(t('[Friendica:Notify] Comment to conversation #%1$d by %2$s'), $parent_id, $params['source_name']);
+               $subject = L10n::t('[Friendica:Notify] Comment to conversation #%1$d by %2$s', $parent_id, $params['source_name']);
 
-               $preamble = sprintf(t('%s commented on an item/conversation you have been following.'), $params['source_name']);
+               $preamble = L10n::t('%s commented on an item/conversation you have been following.', $params['source_name']);
                $epreamble = $dest_str;
 
-               $sitelink = t('Please visit %s to view and/or reply to the conversation.');
+               $sitelink = L10n::t('Please visit %s to view and/or reply to the conversation.');
                $tsitelink = sprintf($sitelink, $siteurl);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
                $itemlink =  $params['link'];
        }
 
        if ($params['type'] == NOTIFY_WALL) {
-               $subject = sprintf(t('[Friendica:Notify] %s posted to your profile wall'), $params['source_name']);
+               $subject = L10n::t('[Friendica:Notify] %s posted to your profile wall', $params['source_name']);
 
-               $preamble = sprintf(t('%1$s posted to your profile wall at %2$s'), $params['source_name'], $sitename);
-               $epreamble = sprintf(t('%1$s posted to [url=%2$s]your wall[/url]'),
-                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                       $params['link']);
+               $preamble = L10n::t('%1$s posted to your profile wall at %2$s', $params['source_name'], $sitename);
+               $epreamble = L10n::t('%1$s posted to [url=%2$s]your wall[/url]',
+                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                       $params['link']
+               );
 
-               $sitelink = t('Please visit %s to view and/or reply to the conversation.');
+               $sitelink = L10n::t('Please visit %s to view and/or reply to the conversation.');
                $tsitelink = sprintf($sitelink, $siteurl);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
                $itemlink =  $params['link'];
        }
 
        if ($params['type'] == NOTIFY_TAGSELF) {
-               $subject = sprintf(t('[Friendica:Notify] %s tagged you'), $params['source_name']);
+               $subject = L10n::t('[Friendica:Notify] %s tagged you', $params['source_name']);
 
-               $preamble = sprintf(t('%1$s tagged you at %2$s'), $params['source_name'], $sitename);
-               $epreamble = sprintf(t('%1$s [url=%2$s]tagged you[/url].'),
-                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                       $params['link']);
+               $preamble = L10n::t('%1$s tagged you at %2$s', $params['source_name'], $sitename);
+               $epreamble = L10n::t('%1$s [url=%2$s]tagged you[/url].',
+                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                       $params['link']
+               );
 
-               $sitelink = t('Please visit %s to view and/or reply to the conversation.');
+               $sitelink = L10n::t('Please visit %s to view and/or reply to the conversation.');
                $tsitelink = sprintf($sitelink, $siteurl);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
                $itemlink =  $params['link'];
        }
 
        if ($params['type'] == NOTIFY_SHARE) {
-               $subject = sprintf(t('[Friendica:Notify] %s shared a new post'), $params['source_name']);
+               $subject = L10n::t('[Friendica:Notify] %s shared a new post', $params['source_name']);
 
-               $preamble = sprintf(t('%1$s shared a new post at %2$s'), $params['source_name'], $sitename);
-               $epreamble = sprintf(t('%1$s [url=%2$s]shared a post[/url].'),
-                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                       $params['link']);
+               $preamble = L10n::t('%1$s shared a new post at %2$s', $params['source_name'], $sitename);
+               $epreamble = L10n::t('%1$s [url=%2$s]shared a post[/url].',
+                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                       $params['link']
+               );
 
-               $sitelink = t('Please visit %s to view and/or reply to the conversation.');
+               $sitelink = L10n::t('Please visit %s to view and/or reply to the conversation.');
                $tsitelink = sprintf($sitelink, $siteurl);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
                $itemlink =  $params['link'];
        }
 
        if ($params['type'] == NOTIFY_POKE) {
-               $subject = sprintf(t('[Friendica:Notify] %1$s poked you'), $params['source_name']);
+               $subject = L10n::t('[Friendica:Notify] %1$s poked you', $params['source_name']);
 
-               $preamble = sprintf(t('%1$s poked you at %2$s'), $params['source_name'], $sitename);
-               $epreamble = sprintf(t('%1$s [url=%2$s]poked you[/url].'),
-                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                       $params['link']);
+               $preamble = L10n::t('%1$s poked you at %2$s', $params['source_name'], $sitename);
+               $epreamble = L10n::t('%1$s [url=%2$s]poked you[/url].',
+                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                       $params['link']
+               );
 
-               $subject = str_replace('poked', t($params['activity']), $subject);
-               $preamble = str_replace('poked', t($params['activity']), $preamble);
-               $epreamble = str_replace('poked', t($params['activity']), $epreamble);
+               $subject = str_replace('poked', L10n::t($params['activity']), $subject);
+               $preamble = str_replace('poked', L10n::t($params['activity']), $preamble);
+               $epreamble = str_replace('poked', L10n::t($params['activity']), $epreamble);
 
-               $sitelink = t('Please visit %s to view and/or reply to the conversation.');
+               $sitelink = L10n::t('Please visit %s to view and/or reply to the conversation.');
                $tsitelink = sprintf($sitelink, $siteurl);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
                $itemlink =  $params['link'];
        }
 
        if ($params['type'] == NOTIFY_TAGSHARE) {
-               $subject = sprintf(t('[Friendica:Notify] %s tagged your post'), $params['source_name']);
+               $itemlink =  $params['link'];
+               $subject = L10n::t('[Friendica:Notify] %s tagged your post', $params['source_name']);
 
-               $preamble = sprintf(t('%1$s tagged your post at %2$s'), $params['source_name'], $sitename);
-               $epreamble = sprintf(t('%1$s tagged [url=%2$s]your post[/url]'),
-                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                       $itemlink);
+               $preamble = L10n::t('%1$s tagged your post at %2$s', $params['source_name'], $sitename);
+               $epreamble = L10n::t('%1$s tagged [url=%2$s]your post[/url]',
+                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                       $itemlink
+               );
 
-               $sitelink = t('Please visit %s to view and/or reply to the conversation.');
+               $sitelink = L10n::t('Please visit %s to view and/or reply to the conversation.');
                $tsitelink = sprintf($sitelink, $siteurl);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
-               $itemlink =  $params['link'];
        }
 
        if ($params['type'] == NOTIFY_INTRO) {
-               $subject = sprintf(t('[Friendica:Notify] Introduction received'));
+               $itemlink = $params['link'];
+               $subject = L10n::t('[Friendica:Notify] Introduction received');
 
-               $preamble = sprintf(t('You\'ve received an introduction from \'%1$s\' at %2$s'), $params['source_name'], $sitename);
-               $epreamble = sprintf(t('You\'ve received [url=%1$s]an introduction[/url] from %2$s.'),
-                                       $itemlink,
-                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]');
+               $preamble = L10n::t('You\'ve received an introduction from \'%1$s\' at %2$s', $params['source_name'], $sitename);
+               $epreamble = L10n::t('You\'ve received [url=%1$s]an introduction[/url] from %2$s.',
+                       $itemlink,
+                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]'
+               );
 
-               $body = sprintf(t('You may visit their profile at %s'), $params['source_link']);
+               $body = L10n::t('You may visit their profile at %s', $params['source_link']);
 
-               $sitelink = t('Please visit %s to approve or reject the introduction.');
+               $sitelink = L10n::t('Please visit %s to approve or reject the introduction.');
                $tsitelink = sprintf($sitelink, $siteurl);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
-               $itemlink =  $params['link'];
 
                switch ($params['verb']) {
                        case ACTIVITY_FRIEND:
                                // someone started to share with user (mostly OStatus)
-                               $subject = sprintf(t('[Friendica:Notify] A new person is sharing with you'));
+                               $subject = L10n::t('[Friendica:Notify] A new person is sharing with you');
 
-                               $preamble = sprintf(t('%1$s is sharing with you at %2$s'), $params['source_name'], $sitename);
-                               $epreamble = sprintf(t('%1$s is sharing with you at %2$s'),
-                                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                                       $sitename);
+                               $preamble = L10n::t('%1$s is sharing with you at %2$s', $params['source_name'], $sitename);
+                               $epreamble = L10n::t('%1$s is sharing with you at %2$s',
+                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                                       $sitename
+                               );
                                break;
                        case ACTIVITY_FOLLOW:
                                // someone started to follow the user (mostly OStatus)
-                               $subject = sprintf(t('[Friendica:Notify] You have a new follower'));
+                               $subject = L10n::t('[Friendica:Notify] You have a new follower');
 
-                               $preamble = sprintf(t('You have a new follower at %2$s : %1$s'), $params['source_name'], $sitename);
-                               $epreamble = sprintf(t('You have a new follower at %2$s : %1$s'),
-                                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
-                                                       $sitename);
+                               $preamble = L10n::t('You have a new follower at %2$s : %1$s', $params['source_name'], $sitename);
+                               $epreamble = L10n::t('You have a new follower at %2$s : %1$s',
+                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]',
+                                       $sitename
+                               );
                                break;
                        default:
                                // ACTIVITY_REQ_FRIEND is default activity for notifications
@@ -297,75 +326,82 @@ function notification($params) {
        }
 
        if ($params['type'] == NOTIFY_SUGGEST) {
-               $subject = sprintf(t('[Friendica:Notify] Friend suggestion received'));
+               $itemlink =  $params['link'];
+               $subject = L10n::t('[Friendica:Notify] Friend suggestion received');
 
-               $preamble = sprintf(t('You\'ve received a friend suggestion from \'%1$s\' at %2$s'), $params['source_name'], $sitename);
-               $epreamble = sprintf(t('You\'ve received [url=%1$s]a friend suggestion[/url] for %2$s from %3$s.'),
-                                       $itemlink,
-                                       '[url='.$params['item']['url'].']'.$params['item']['name'].'[/url]',
-                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]');
+               $preamble = L10n::t('You\'ve received a friend suggestion from \'%1$s\' at %2$s', $params['source_name'], $sitename);
+               $epreamble = L10n::t('You\'ve received [url=%1$s]a friend suggestion[/url] for %2$s from %3$s.',
+                       $itemlink,
+                       '[url='.$params['item']['url'].']'.$params['item']['name'].'[/url]',
+                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]'
+               );
 
-               $body = t('Name:').' '.$params['item']['name']."\n";
-               $body .= t('Photo:').' '.$params['item']['photo']."\n";
-               $body .= sprintf(t('You may visit their profile at %s'), $params['item']['url']);
+               $body = L10n::t('Name:').' '.$params['item']['name']."\n";
+               $body .= L10n::t('Photo:').' '.$params['item']['photo']."\n";
+               $body .= L10n::t('You may visit their profile at %s', $params['item']['url']);
 
-               $sitelink = t('Please visit %s to approve or reject the suggestion.');
+               $sitelink = L10n::t('Please visit %s to approve or reject the suggestion.');
                $tsitelink = sprintf($sitelink, $siteurl);
                $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
-               $itemlink =  $params['link'];
        }
 
        if ($params['type'] == NOTIFY_CONFIRM) {
                if ($params['verb'] == ACTIVITY_FRIEND) { // mutual connection
-                       $subject = sprintf(t('[Friendica:Notify] Connection accepted'));
+                       $itemlink =  $params['link'];
+                       $subject = L10n::t('[Friendica:Notify] Connection accepted');
 
-                       $preamble = sprintf(t('\'%1$s\' has accepted your connection request at %2$s'), $params['source_name'], $sitename);
-                       $epreamble = sprintf(t('%2$s has accepted your [url=%1$s]connection request[/url].'),
-                                               $itemlink,
-                                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]');
+                       $preamble = L10n::t('\'%1$s\' has accepted your connection request at %2$s', $params['source_name'], $sitename);
+                       $epreamble = L10n::t('%2$s has accepted your [url=%1$s]connection request[/url].',
+                               $itemlink,
+                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]'
+                       );
 
-                       $body =  t('You are now mutual friends and may exchange status updates, photos, and email without restriction.');
+                       $body =  L10n::t('You are now mutual friends and may exchange status updates, photos, and email without restriction.');
 
-                       $sitelink = t('Please visit %s if you wish to make any changes to this relationship.');
+                       $sitelink = L10n::t('Please visit %s if you wish to make any changes to this relationship.');
                        $tsitelink = sprintf($sitelink, $siteurl);
                        $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
-                       $itemlink =  $params['link'];
                } else { // ACTIVITY_FOLLOW
-                       $subject = sprintf(t('[Friendica:Notify] Connection accepted'));
+                       $itemlink =  $params['link'];
+                       $subject = L10n::t('[Friendica:Notify] Connection accepted');
 
-                       $preamble = sprintf(t('\'%1$s\' has accepted your connection request at %2$s'), $params['source_name'], $sitename);
-                       $epreamble = sprintf(t('%2$s has accepted your [url=%1$s]connection request[/url].'),
-                                               $itemlink,
-                                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]');
+                       $preamble = L10n::t('\'%1$s\' has accepted your connection request at %2$s', $params['source_name'], $sitename);
+                       $epreamble = L10n::t('%2$s has accepted your [url=%1$s]connection request[/url].',
+                               $itemlink,
+                               '[url='.$params['source_link'].']'.$params['source_name'].'[/url]'
+                       );
 
-                       $body =  sprintf(t('\'%1$s\' has chosen to accept you a "fan", which restricts some forms of communication - such as private messaging and some profile interactions. If this is a celebrity or community page, these settings were applied automatically.'), $params['source_name']);
+                       $body =  L10n::t('\'%1$s\' has chosen to accept you a fan, which restricts some forms of communication - such as private messaging and some profile interactions. If this is a celebrity or community page, these settings were applied automatically.', $params['source_name']);
                        $body .= "\n\n";
-                       $body .= sprintf(t('\'%1$s\' may choose to extend this into a two-way or more permissive relationship in the future.'), $params['source_name']);
+                       $body .= L10n::t('\'%1$s\' may choose to extend this into a two-way or more permissive relationship in the future.', $params['source_name']);
 
-                       $sitelink = t('Please visit %s  if you wish to make any changes to this relationship.');
+                       $sitelink = L10n::t('Please visit %s  if you wish to make any changes to this relationship.');
                        $tsitelink = sprintf($sitelink, $siteurl);
                        $hsitelink = sprintf($sitelink, '<a href="'.$siteurl.'">'.$sitename.'</a>');
-                       $itemlink =  $params['link'];
                }
        }
 
        if ($params['type'] == NOTIFY_SYSTEM) {
                switch($params['event']) {
                        case "SYSTEM_REGISTER_REQUEST":
-                               $subject = sprintf(t('[Friendica System:Notify] registration request'));
+                               $itemlink =  $params['link'];
+                               $subject = L10n::t('[Friendica System Notify]') . ' ' . L10n::t('registration request');
 
-                               $preamble = sprintf(t('You\'ve received a registration request from \'%1$s\' at %2$s'), $params['source_name'], $sitename);
-                               $epreamble = sprintf(t('You\'ve received a [url=%1$s]registration request[/url] from %2$s.'),
-                                                       $itemlink,
-                                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]');
+                               $preamble = L10n::t('You\'ve received a registration request from \'%1$s\' at %2$s', $params['source_name'], $sitename);
+                               $epreamble = L10n::t('You\'ve received a [url=%1$s]registration request[/url] from %2$s.',
+                                       $itemlink,
+                                       '[url='.$params['source_link'].']'.$params['source_name'].'[/url]'
+                               );
 
-                               $body = sprintf(t('Full Name:   %1$s\nSite Location:    %2$s\nLogin Name:       %3$s (%4$s)'),
-                                                                       $params['source_name'], $siteurl, $params['source_mail'], $params['source_nick']);
+                               $body = L10n::t("Full Name:     %s\nSite Location:      %s\nLogin Name: %s (%s)",
+                                       $params['source_name'],
+                                       $siteurl, $params['source_mail'],
+                                       $params['source_nick']
+                               );
 
-                               $sitelink = t('Please visit %s to approve or reject the request.');
+                               $sitelink = L10n::t('Please visit %s to approve or reject the request.');
                                $tsitelink = sprintf($sitelink, $params['link']);
                                $hsitelink = sprintf($sitelink, '<a href="'.$params['link'].'">'.$sitename.'</a><br><br>');
-                               $itemlink =  $params['link'];
                                break;
                        case "SYSTEM_DB_UPDATE_FAIL":
                                break;
@@ -393,7 +429,7 @@ function notification($params) {
 
        $subject .= " (".$nickname."@".$hostname.")";
 
-       $h = array(
+       $h = [
                'params'    => $params,
                'subject'   => $subject,
                'preamble'  => $preamble,
@@ -403,9 +439,9 @@ function notification($params) {
                'tsitelink' => $tsitelink,
                'hsitelink' => $hsitelink,
                'itemlink'  => $itemlink
-       );
+       ];
 
-       call_hooks('enotify', $h);
+       Addon::callHooks('enotify', $h);
 
        $subject   = $h['subject'];
 
@@ -414,31 +450,28 @@ function notification($params) {
 
        $body      = $h['body'];
 
-       $sitelink  = $h['sitelink'];
        $tsitelink = $h['tsitelink'];
        $hsitelink = $h['hsitelink'];
        $itemlink  = $h['itemlink'];
 
        if ($show_in_notification_page) {
-               logger("adding notification entry", LOGGER_DEBUG);
+               Logger::log("adding notification entry", Logger::DEBUG);
                do {
                        $dups = false;
-                       $hash = random_string();
-                       $r = q("SELECT `id` FROM `notify` WHERE `hash` = '%s' LIMIT 1",
-                               dbesc($hash));
-                       if (DBM::is_result($r)) {
+                       $hash = Strings::getRandomHex();
+                       if (DBA::exists('notify', ['hash' => $hash])) {
                                $dups = true;
                        }
                } while ($dups == true);
 
                /// @TODO One statement is enough
-               $datarray = array();
+               $datarray = [];
                $datarray['hash']  = $hash;
                $datarray['name']  = $params['source_name'];
-               $datarray['name_cache'] = strip_tags(bbcode($params['source_name']));
+               $datarray['name_cache'] = strip_tags(BBCode::convert($params['source_name']));
                $datarray['url']   = $params['source_link'];
                $datarray['photo'] = $params['source_photo'];
-               $datarray['date']  = datetime_convert();
+               $datarray['date']  = DateTimeFormat::utcNow();
                $datarray['uid']   = $params['uid'];
                $datarray['link']  = $itemlink;
                $datarray['iid']   = $item_id;
@@ -448,76 +481,50 @@ function notification($params) {
                $datarray['otype'] = $params['otype'];
                $datarray['abort'] = false;
 
-               call_hooks('enotify_store', $datarray);
+               Addon::callHooks('enotify_store', $datarray);
 
                if ($datarray['abort']) {
-                       pop_lang();
+                       L10n::popLang();
                        return False;
                }
 
                // create notification entry in DB
+               $fields = ['hash' => $datarray['hash'], 'name' => $datarray['name'], 'url' => $datarray['url'],
+                       'photo' => $datarray['photo'], 'date' => $datarray['date'], 'uid' => $datarray['uid'],
+                       'link' => $datarray['link'], 'iid' => $datarray['iid'], 'parent' => $datarray['parent'],
+                       'type' => $datarray['type'], 'verb' => $datarray['verb'], 'otype' => $datarray['otype'],
+                       'name_cache' => $datarray["name_cache"]];
+               DBA::insert('notify', $fields);
 
-               $r = q("INSERT INTO `notify` (`hash`, `name`, `url`, `photo`, `date`, `uid`, `link`, `iid`, `parent`, `type`, `verb`, `otype`, `name_cache`)
-                       values('%s', '%s', '%s', '%s', '%s', %d, '%s', %d, %d, %d, '%s', '%s', '%s')",
-                       dbesc($datarray['hash']),
-                       dbesc($datarray['name']),
-                       dbesc($datarray['url']),
-                       dbesc($datarray['photo']),
-                       dbesc($datarray['date']),
-                       intval($datarray['uid']),
-                       dbesc($datarray['link']),
-                       intval($datarray['iid']),
-                       intval($datarray['parent']),
-                       intval($datarray['type']),
-                       dbesc($datarray['verb']),
-                       dbesc($datarray['otype']),
-                       dbesc($datarray["name_cache"])
-               );
-
-               $r = q("SELECT `id` FROM `notify` WHERE `hash` = '%s' AND `uid` = %d LIMIT 1",
-                       dbesc($hash),
-                       intval($params['uid'])
-               );
-               if ($r)
-                       $notify_id = $r[0]['id'];
-               else {
-                       pop_lang();
-                       return False;
-               }
+               $notify_id = DBA::lastInsertId();
 
                // we seem to have a lot of duplicate comment notifications due to race conditions, mostly from forums
                // After we've stored everything, look again to see if there are any duplicates and if so remove them
-
-               $p = null;
                $p = q("SELECT `id` FROM `notify` WHERE `type` IN (%d, %d) AND `link` = '%s' AND `uid` = %d ORDER BY `id`",
                        intval(NOTIFY_TAGSELF),
                        intval(NOTIFY_COMMENT),
-                       dbesc($params['link']),
+                       DBA::escape($params['link']),
                        intval($params['uid'])
                );
                if ($p && (count($p) > 1)) {
                        for ($d = 1; $d < count($p); $d ++) {
-                               dba::delete('notify', array('id' => $p[$d]['id']));
+                               DBA::delete('notify', ['id' => $p[$d]['id']]);
                        }
 
                        // only continue on if we stored the first one
-
                        if ($notify_id != $p[0]['id']) {
-                               pop_lang();
-                               return False;
+                               L10n::popLang();
+                               return false;
                        }
                }
 
-
                $itemlink = System::baseUrl().'/notify/view/'.$notify_id;
-               $msg = replace_macros($epreamble, array('$itemlink' => $itemlink));
-               $msg_cache = format_notification_message($datarray['name_cache'], strip_tags(bbcode($msg)));
-               $r = q("UPDATE `notify` SET `msg` = '%s', `msg_cache` = '%s' WHERE `id` = %d AND `uid` = %d",
-                       dbesc($msg),
-                       dbesc($msg_cache),
-                       intval($notify_id),
-                       intval($params['uid'])
-               );
+               $msg = Renderer::replaceMacros($epreamble, ['$itemlink' => $itemlink]);
+               $msg_cache = format_notification_message($datarray['name_cache'], strip_tags(BBCode::convert($msg)));
+
+               $fields = ['msg' => $msg, 'msg_cache' => $msg_cache];
+               $condition = ['id' => $notify_id, 'uid' => $params['uid']];
+               DBA::update('notify', $fields, $condition);
        }
 
        // send email notification if notification preferences permit
@@ -525,58 +532,46 @@ function notification($params) {
                || $params['type'] == NOTIFY_SYSTEM
                || $params['type'] == SYSTEM_EMAIL) {
 
-               logger('sending notification email');
+               Logger::log('sending notification email');
 
                if (isset($params['parent']) && (intval($params['parent']) != 0)) {
                        $id_for_parent = $params['parent']."@".$hostname;
 
                        // Is this the first email notification for this parent item and user?
+                       if (!DBA::exists('notify-threads', ['master-parent-item' => $params['parent'], 'receiver-uid' => $params['uid']])) {
+                               Logger::log("notify_id:".intval($notify_id).", parent: ".intval($params['parent'])."uid: ".intval($params['uid']), Logger::DEBUG);
 
-                       $r = q("SELECT `id` FROM `notify-threads` WHERE `master-parent-item` = %d AND `receiver-uid` = %d LIMIT 1",
-                               intval($params['parent']),
-                               intval($params['uid']));
-
-                       // If so, create the record of it and use a message-id smtp header.
-
-                       if (!$r) {
-                               logger("notify_id:".intval($notify_id).", parent: ".intval($params['parent'])."uid: ".intval($params['uid']), LOGGER_DEBUG);
-                               $r = q("INSERT INTO `notify-threads` (`notify-id`, `master-parent-item`, `receiver-uid`, `parent-item`)
-                                       values(%d, %d, %d, %d)",
-                                       intval($notify_id),
-                                       intval($params['parent']),
-                                       intval($params['uid']),
-                                       0);
+                               $fields = ['notify-id' => $notify_id, 'master-parent-item' => $params['parent'],
+                                       'receiver-uid' => $params['uid'], 'parent-item' => 0];
+                               DBA::insert('notify-threads', $fields);
 
                                $additional_mail_header .= "Message-ID: <${id_for_parent}>\n";
                                $log_msg = "include/enotify: No previous notification found for this parent:\n".
                                                "  parent: ${params['parent']}\n"."  uid   : ${params['uid']}\n";
-                               logger($log_msg, LOGGER_DEBUG);
+                               Logger::log($log_msg, Logger::DEBUG);
                        } else {
                                // If not, just "follow" the thread.
                                $additional_mail_header .= "References: <${id_for_parent}>\nIn-Reply-To: <${id_for_parent}>\n";
-                               logger("There's already a notification for this parent:\n".print_r($r, true), LOGGER_DEBUG);
+                               Logger::log("There's already a notification for this parent.", Logger::DEBUG);
                        }
                }
 
-               // textversion keeps linebreaks
-               $textversion = strip_tags(str_replace("<br>", "\n", html_entity_decode(bbcode(stripslashes(str_replace(array("\\r\\n", "\\r", "\\n"), "\n",
-                       $body))),ENT_QUOTES, 'UTF-8')));
-               $htmlversion = html_entity_decode(bbcode(stripslashes(str_replace(array("\\r\\n", "\\r", "\\n\\n", "\\n"),
-                       "<br />\n", $body))), ENT_QUOTES, 'UTF-8');
+               $textversion = BBCode::toPlaintext($body);
+               $htmlversion = BBCode::convert($body);
 
-               $datarray = array();
+               $datarray = [];
                $datarray['banner'] = $banner;
                $datarray['product'] = $product;
                $datarray['preamble'] = $preamble;
                $datarray['sitename'] = $sitename;
                $datarray['siteurl'] = $siteurl;
                $datarray['type'] = $params['type'];
-               $datarray['parent'] = $params['parent'];
-               $datarray['source_name'] = $params['source_name'];
-               $datarray['source_link'] = $params['source_link'];
-               $datarray['source_photo'] = $params['source_photo'];
+               $datarray['parent'] = $parent_id;
+               $datarray['source_name'] = defaults($params, 'source_name', '');
+               $datarray['source_link'] = defaults($params, 'source_link', '');
+               $datarray['source_photo'] = defaults($params, 'source_photo', '');
                $datarray['uid'] = $params['uid'];
-               $datarray['username'] = $params['to_name'];
+               $datarray['username'] = defaults($params, 'to_name', '');
                $datarray['hsitelink'] = $hsitelink;
                $datarray['tsitelink'] = $tsitelink;
                $datarray['hitemlink'] = '<a href="'.$itemlink.'">'.$itemlink.'</a>';
@@ -589,15 +584,15 @@ function notification($params) {
                $datarray['subject'] = $subject;
                $datarray['headers'] = $additional_mail_header;
 
-               call_hooks('enotify_mail', $datarray);
+               Addon::callHooks('enotify_mail', $datarray);
 
                // check whether sending post content in email notifications is allowed
                // always true for SYSTEM_EMAIL
                $content_allowed = ((!Config::get('system', 'enotify_no_content')) || ($params['type'] == SYSTEM_EMAIL));
 
                // load the template for private message notifications
-               $tpl = get_markup_template('email_notify_html.tpl');
-               $email_html_body = replace_macros($tpl, array(
+               $tpl = Renderer::getMarkupTemplate('email_notify_html.tpl');
+               $email_html_body = Renderer::replaceMacros($tpl, [
                        '$banner'       => $datarray['banner'],
                        '$product'      => $datarray['product'],
                        '$preamble'     => str_replace("\n", "<br>\n", $datarray['preamble']),
@@ -606,7 +601,7 @@ function notification($params) {
                        '$source_name'  => $datarray['source_name'],
                        '$source_link'  => $datarray['source_link'],
                        '$source_photo' => $datarray['source_photo'],
-                       '$username'     => $datarray['to_name'],
+                       '$username'     => $datarray['username'],
                        '$hsitelink'    => $datarray['hsitelink'],
                        '$hitemlink'    => $datarray['hitemlink'],
                        '$thanks'       => $datarray['thanks'],
@@ -614,11 +609,11 @@ function notification($params) {
                        '$title'        => $datarray['title'],
                        '$htmlversion'  => $datarray['htmlversion'],
                        '$content_allowed'      => $content_allowed,
-               ));
+               ]);
 
                // load the template for private message notifications
-               $tpl = get_markup_template('email_notify_text.tpl');
-               $email_text_body = replace_macros($tpl, array(
+               $tpl = Renderer::getMarkupTemplate('email_notify_text.tpl');
+               $email_text_body = Renderer::replaceMacros($tpl, [
                        '$banner'       => $datarray['banner'],
                        '$product'      => $datarray['product'],
                        '$preamble'     => $datarray['preamble'],
@@ -627,7 +622,7 @@ function notification($params) {
                        '$source_name'  => $datarray['source_name'],
                        '$source_link'  => $datarray['source_link'],
                        '$source_photo' => $datarray['source_photo'],
-                       '$username'     => $datarray['to_name'],
+                       '$username'     => $datarray['username'],
                        '$tsitelink'    => $datarray['tsitelink'],
                        '$titemlink'    => $datarray['titemlink'],
                        '$thanks'       => $datarray['thanks'],
@@ -635,12 +630,12 @@ function notification($params) {
                        '$title'        => $datarray['title'],
                        '$textversion'  => $datarray['textversion'],
                        '$content_allowed'      => $content_allowed,
-               ));
+               ]);
 
+               L10n::popLang();
                // use the Emailer class to send the message
-
                return Emailer::send(
-                       array(
+                       [
                        'uid' => $params['uid'],
                        'fromName' => $sender_name,
                        'fromEmail' => $sender_email,
@@ -649,51 +644,71 @@ function notification($params) {
                        'messageSubject' => $datarray['subject'],
                        'htmlVersion' => $email_html_body,
                        'textVersion' => $email_text_body,
-                       'additionalMailHeader' => $datarray['headers'])
+                       'additionalMailHeader' => $datarray['headers']]
                );
        }
 
+       L10n::popLang();
        return false;
 }
 
+/**
+ * @brief Checks for users who should be notified
+ *
+ * @param int $itemid ID of the item for which the check should be done
+ */
+function check_user_notification($itemid) {
+       // fetch all users in the thread
+       $users = DBA::p("SELECT DISTINCT(`contact`.`uid`) FROM `item`
+                       INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id` AND `contact`.`uid` != 0
+                       WHERE `parent` IN (SELECT `parent` FROM `item` WHERE `id`=?)", $itemid);
+       while ($user = DBA::fetch($users)) {
+               check_item_notification($itemid, $user['uid']);
+       }
+       DBA::close($users);
+}
+
 /**
  * @brief Checks for item related notifications and sends them
  *
  * @param int $itemid ID of the item for which the check should be done
  * @param int $uid User ID
- * @param str $defaulttype (Optional) Forces a notification with this type.
+ * @param string $defaulttype (Optional) Forces a notification with this type.
  */
 function check_item_notification($itemid, $uid, $defaulttype = "") {
-       $notification_data = array("uid" => $uid, "profiles" => array());
-       call_hooks('check_item_notification', $notification_data);
+       $notification_data = ["uid" => $uid, "profiles" => []];
+       Addon::callHooks('check_item_notification', $notification_data);
 
        $profiles = $notification_data["profiles"];
 
-       $user = q("SELECT `notify-flags`, `language`, `username`, `email`, `nickname` FROM `user` WHERE `uid` = %d", intval($uid));
-       if (!$user)
+       $fields = ['nickname'];
+       $user = DBA::selectFirst('user', $fields, ['uid' => $uid]);
+       if (!DBA::isResult($user)) {
                return false;
+       }
 
-       $owner = q("SELECT `id`, `url` FROM `contact` WHERE `self` AND `uid` = %d LIMIT 1", intval($uid));
-       if (!$owner)
+       $owner = DBA::selectFirst('contact', ['url'], ['self' => true, 'uid' => $uid]);
+       if (!DBA::isResult($owner)) {
                return false;
+       }
 
        // This is our regular URL format
-       $profiles[] = $owner[0]["url"];
+       $profiles[] = $owner["url"];
 
        // Notifications from Diaspora are often with an URL in the Diaspora format
-       $profiles[] = System::baseUrl()."/u/".$user[0]["nickname"];
+       $profiles[] = System::baseUrl()."/u/".$user["nickname"];
 
-       $profiles2 = array();
+       $profiles2 = [];
 
        foreach ($profiles AS $profile) {
                // Check for invalid profile urls. 13 should be the shortest possible profile length:
                // http://a.bc/d
                // Additionally check for invalid urls that would return the normalised value "http:"
-               if ((strlen($profile) >= 13) && (normalise_link($profile) != "http:")) {
+               if ((strlen($profile) >= 13) && (Strings::normaliseLink($profile) != "http:")) {
                        if (!in_array($profile, $profiles2))
                                $profiles2[] = $profile;
 
-                       $profile = normalise_link($profile);
+                       $profile = Strings::normaliseLink($profile);
                        if (!in_array($profile, $profiles2))
                                $profiles2[] = $profile;
 
@@ -705,60 +720,53 @@ function check_item_notification($itemid, $uid, $defaulttype = "") {
 
        $profiles = $profiles2;
 
-       $profile_list = "";
+       $ret = DBA::select('contact', ['id'], ['uid' => 0, 'nurl' => $profiles]);
 
-       foreach ($profiles AS $profile) {
-               if ($profile_list != "")
-                       $profile_list .= "', '";
+       $contacts = [];
 
-               $profile_list .= dbesc($profile);
+       while ($contact = DBA::fetch($ret)) {
+               $contacts[] = $contact['id'];
        }
 
-       $profile_list = "'".$profile_list."'";
+       DBA::close($ret);
 
        // Only act if it is a "real" post
        // We need the additional check for the "local_profile" because of mixed situations on connector networks
-       $item = q("SELECT `id`, `mention`, `tag`,`parent`, `title`, `body`, `author-name`, `author-link`, `author-avatar`, `guid`,
-                       `parent-uri`, `uri`, `contact-id`
-                       FROM `item` WHERE `id` = %d AND `verb` IN ('%s', '') AND `type` != 'activity' AND
-                               NOT (`author-link` IN ($profile_list))  LIMIT 1",
-               intval($itemid), dbesc(ACTIVITY_POST));
-       if (!$item)
-               return false;
+       $fields = ['id', 'mention', 'tag', 'parent', 'title', 'body',
+               'author-link', 'author-name', 'author-avatar', 'author-id',
+               'guid', 'parent-uri', 'uri', 'contact-id', 'network'];
+       $condition = ['id' => $itemid, 'gravity' => [GRAVITY_PARENT, GRAVITY_COMMENT]];
+       $item = Item::selectFirst($fields, $condition);
+       if (!DBA::isResult($item) || in_array($item['author-id'], $contacts)) {
+               return;
+       }
 
        // Generate the notification array
-       $params = array();
+       $params = [];
        $params["uid"] = $uid;
-       $params["notify_flags"] = $user[0]["notify-flags"];
-       $params["language"] = $user[0]["language"];
-       $params["to_name"] = $user[0]["username"];
-       $params["to_email"] = $user[0]["email"];
-       $params["item"] = $item[0];
-       $params["parent"] = $item[0]["parent"];
-       $params["link"] = System::baseUrl().'/display/'.urlencode($item[0]["guid"]);
+       $params["item"] = $item;
+       $params["parent"] = $item["parent"];
+       $params["link"] = System::baseUrl().'/display/'.urlencode($item["guid"]);
        $params["otype"] = 'item';
-       $params["source_name"] = $item[0]["author-name"];
-       $params["source_link"] = $item[0]["author-link"];
-       $params["source_photo"] = $item[0]["author-avatar"];
+       $params["source_name"] = $item["author-name"];
+       $params["source_link"] = $item["author-link"];
+       $params["source_photo"] = $item["author-avatar"];
 
-       if ($item[0]["parent-uri"] === $item[0]["uri"]) {
+       if ($item["parent-uri"] === $item["uri"]) {
                // Send a notification for every new post?
-               $r = q("SELECT `notify_new_posts` FROM `contact` WHERE `id` = %d AND `uid` = %d AND `notify_new_posts` LIMIT 1",
-                       intval($item[0]['contact-id']),
-                       intval($uid)
-               );
-               $send_notification = DBM::is_result($r);
+               $send_notification = DBA::exists('contact', ['id' => $item['contact-id'], 'notify_new_posts' => true]);
 
                if (!$send_notification) {
                        $tags = q("SELECT `url` FROM `term` WHERE `otype` = %d AND `oid` = %d AND `type` = %d AND `uid` = %d",
                                intval(TERM_OBJ_POST), intval($itemid), intval(TERM_MENTION), intval($uid));
 
-                       if (DBM::is_result($tags)) {
+                       if (DBA::isResult($tags)) {
                                foreach ($tags AS $tag) {
-                                       $r = q("SELECT `id` FROM `contact` WHERE `nurl` = '%s' AND `uid` = %d AND `notify_new_posts`",
-                                               normalise_link($tag["url"]), intval($uid));
-                                       if (DBM::is_result($r))
+                                       $condition = ['nurl' => Strings::normaliseLink($tag["url"]), 'uid' => $uid, 'notify_new_posts' => true];
+                                       $r = DBA::exists('contact', $condition);
+                                       if ($r) {
                                                $send_notification = true;
+                                       }
                                }
                        }
                }
@@ -773,29 +781,35 @@ function check_item_notification($itemid, $uid, $defaulttype = "") {
        $tagged = false;
 
        foreach ($profiles AS $profile) {
-               if (strpos($item[0]["tag"], "=".$profile."]") || strpos($item[0]["body"], "=".$profile."]"))
+               if (strpos($item["tag"], "=".$profile."]") || strpos($item["body"], "=".$profile."]"))
                        $tagged = true;
        }
 
-       if ($item[0]["mention"] || $tagged || ($defaulttype == NOTIFY_TAGSELF)) {
+       if ($item["mention"] || $tagged || ($defaulttype == NOTIFY_TAGSELF)) {
                $params["type"] = NOTIFY_TAGSELF;
                $params["verb"] = ACTIVITY_TAG;
        }
 
-       // Is it a post that the user had started or where he interacted?
-       $parent = q("SELECT `thread`.`iid` FROM `thread` INNER JOIN `item` ON `item`.`parent` = `thread`.`iid`
-                       WHERE `thread`.`iid` = %d AND `thread`.`uid` = %d AND NOT `thread`.`ignored` AND
-                               (`thread`.`mention` OR `item`.`author-link` IN ($profile_list))
-                       LIMIT 1",
-                       intval($item[0]["parent"]), intval($uid));
+       // Is it a post that the user had started?
+       $fields = ['ignored', 'mention'];
+       $thread = Item::selectFirstThreadForUser($params['uid'], $fields, ['iid' => $item["parent"]]);
 
-       if ($parent && !isset($params["type"])) {
+       if ($thread['mention'] && !$thread['ignored'] && !isset($params["type"])) {
                $params["type"] = NOTIFY_COMMENT;
                $params["verb"] = ACTIVITY_POST;
        }
 
-       if (isset($params["type"]))
+       // And now we check for participation of one of our contacts in the thread
+       $condition = ['parent' => $item["parent"], 'author-id' => $contacts];
+
+       if (!$thread['ignored'] && !isset($params["type"]) && Item::exists($condition)) {
+               $params["type"] = NOTIFY_COMMENT;
+               $params["verb"] = ACTIVITY_POST;
+       }
+
+       if (isset($params["type"])) {
                notification($params);
+       }
 }
 
 /**