X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fenotify.php;h=b0ec1c1c8c4c914ab456050c57aeaeedd670b79c;hb=d49f986d1eb6894dd948577288357b6c1755e3d3;hp=d823a1ae8c92519a1775933509eaf5285424a208;hpb=cd1724eb9ef4e07ced4c9019dd7bad55dc21abce;p=friendica.git diff --git a/include/enotify.php b/include/enotify.php index d823a1ae8c..b0ec1c1c8c 100644 --- a/include/enotify.php +++ b/include/enotify.php @@ -1,13 +1,17 @@ config['sitename']; - if (!x($a->config['admin_name'])) + if (!x($a->config['admin_name'])) { $site_admin = sprintf(t('%s Administrator'), $sitename); - else + } else { $site_admin = sprintf(t('%1$s, %2$s Administrator'), $a->config['admin_name'], $sitename); - - $nickname = ""; + } $sender_name = $sitename; $hostname = $a->get_hostname(); - if (strpos($hostname, ':')) + if (strpos($hostname, ':')) { $hostname = substr($hostname, 0, strpos($hostname, ':')); + } $sender_email = $a->config['sender_email']; - if (empty($sender_email)) - $sender_email = t('noreply').'@'.$hostname; + if (empty($sender_email)) { + $sender_email = L10n::t('noreply').'@'.$hostname; + } 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 (!DBM::is_result($user) || in_array($user["page-flags"], [PAGE_COMMUNITY, PAGE_PRVGROUP])) { return; } } @@ -75,21 +79,21 @@ 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 '); - - 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; + } if ($params['type'] == NOTIFY_MAIL) { $subject = sprintf(t('[Friendica:Notify] New mail received at %s'), $sitename); @@ -97,26 +101,21 @@ function notification($params) { $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]'); - $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, ''.$sitename.''); $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"])) { + $thread = dba::selectFirst('thread', ['ignored'], ['iid' => $parent_id]); + if (DBM::is_result($thread) && $thread["ignored"]) { logger("Thread ".$parent_id." will be ignored", LOGGER_DEBUG); 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), @@ -125,22 +124,19 @@ function notification($params) { intval($params['uid']) ); if ($p && count($p)) { - pop_lang(); + 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 = dba::selectFirst('item', [], ['id' => $parent_id]); } - $item_post_type = item_post_type($p[0]); + $item_post_type = item_post_type($item); // "a post" $dest_str = sprintf(t('%1$s commented on [url=%2$s]a %3$s[/url]'), @@ -149,19 +145,21 @@ function notification($params) { $item_post_type); // "George Bull's post" - if ($p) + if ($item) { $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['author-name'], $item_post_type); + } // "your post" - if ($p[0]['owner-name'] == $p[0]['author-name'] && $p[0]['wall']) + if (DBM::is_result($item) && $item['owner-name'] == $item['author-name'] && $item['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); + } // Some mail softwares relies on subject field for threading. // So, we cannot have different subjects for notifications of the same thread. @@ -173,7 +171,7 @@ function notification($params) { $preamble = sprintf(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, ''.$sitename.''); $itemlink = $params['link']; @@ -187,7 +185,7 @@ function notification($params) { '[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, ''.$sitename.''); $itemlink = $params['link']; @@ -201,7 +199,7 @@ function notification($params) { '[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, ''.$sitename.''); $itemlink = $params['link']; @@ -215,7 +213,7 @@ function notification($params) { '[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, ''.$sitename.''); $itemlink = $params['link']; @@ -229,11 +227,11 @@ function notification($params) { '[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, ''.$sitename.''); $itemlink = $params['link']; @@ -247,7 +245,7 @@ function notification($params) { '[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, ''.$sitename.''); $itemlink = $params['link']; @@ -263,7 +261,7 @@ function notification($params) { $body = sprintf(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, ''.$sitename.''); $itemlink = $params['link']; @@ -302,11 +300,11 @@ function notification($params) { '[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 = L10n::t('Name:').' '.$params['item']['name']."\n"; + $body .= L10n::t('Photo:').' '.$params['item']['photo']."\n"; $body .= sprintf(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, ''.$sitename.''); $itemlink = $params['link']; @@ -321,9 +319,9 @@ function notification($params) { $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, ''.$sitename.''); $itemlink = $params['link']; @@ -339,7 +337,7 @@ function notification($params) { $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']); - $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, ''.$sitename.''); $itemlink = $params['link']; @@ -359,7 +357,7 @@ function notification($params) { $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']); - $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, ''.$sitename.'

'); $itemlink = $params['link']; @@ -390,7 +388,7 @@ function notification($params) { $subject .= " (".$nickname."@".$hostname.")"; - $h = array( + $h = [ 'params' => $params, 'subject' => $subject, 'preamble' => $preamble, @@ -400,9 +398,9 @@ function notification($params) { 'tsitelink' => $tsitelink, 'hsitelink' => $hsitelink, 'itemlink' => $itemlink - ); + ]; - call_hooks('enotify', $h); + Addon::callHooks('enotify', $h); $subject = $h['subject']; @@ -411,7 +409,6 @@ function notification($params) { $body = $h['body']; - $sitelink = $h['sitelink']; $tsitelink = $h['tsitelink']; $hsitelink = $h['hsitelink']; $itemlink = $h['itemlink']; @@ -423,13 +420,13 @@ function notification($params) { $hash = random_string(); $r = q("SELECT `id` FROM `notify` WHERE `hash` = '%s' LIMIT 1", dbesc($hash)); - if (dbm::is_result($r)) { + if (DBM::is_result($r)) { $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'])); @@ -445,16 +442,15 @@ 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 - - $r = q("INSERT INTO `notify` (`hash`, `name`, `url`, `photo`, `date`, `uid`, `link`, `iid`, `parent`, `type`, `verb`, `otype`, `name_cache`) + 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']), @@ -475,17 +471,15 @@ function notification($params) { dbesc($hash), intval($params['uid']) ); - if ($r) + if ($r) { $notify_id = $r[0]['id']; - else { - pop_lang(); + } else { + L10n::popLang(); return False; } // 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), @@ -494,22 +488,20 @@ function notification($params) { ); 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 = replace_macros($epreamble, ['$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", + q("UPDATE `notify` SET `msg` = '%s', `msg_cache` = '%s' WHERE `id` = %d AND `uid` = %d", dbesc($msg), dbesc($msg_cache), intval($notify_id), @@ -537,7 +529,7 @@ function notification($params) { 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`) + 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']), @@ -556,12 +548,12 @@ function notification($params) { } // textversion keeps linebreaks - $textversion = strip_tags(str_replace("
", "\n", html_entity_decode(bbcode(stripslashes(str_replace(array("\\r\\n", "\\r", "\\n"), "\n", + $textversion = strip_tags(str_replace("
", "\n", html_entity_decode(bbcode(stripslashes(str_replace(["\\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"), + $htmlversion = html_entity_decode(bbcode(stripslashes(str_replace(["\\r\\n", "\\r", "\\n\\n", "\\n"], "
\n", $body))), ENT_QUOTES, 'UTF-8'); - $datarray = array(); + $datarray = []; $datarray['banner'] = $banner; $datarray['product'] = $product; $datarray['preamble'] = $preamble; @@ -586,7 +578,7 @@ 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 @@ -594,7 +586,7 @@ function notification($params) { // load the template for private message notifications $tpl = get_markup_template('email_notify_html.tpl'); - $email_html_body = replace_macros($tpl, array( + $email_html_body = replace_macros($tpl, [ '$banner' => $datarray['banner'], '$product' => $datarray['product'], '$preamble' => str_replace("\n", "
\n", $datarray['preamble']), @@ -611,11 +603,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( + $email_text_body = replace_macros($tpl, [ '$banner' => $datarray['banner'], '$product' => $datarray['product'], '$preamble' => $datarray['preamble'], @@ -632,11 +624,11 @@ function notification($params) { '$title' => $datarray['title'], '$textversion' => $datarray['textversion'], '$content_allowed' => $content_allowed, - )); + ]); // use the Emailer class to send the message - - return Emailer::send(array( + return Emailer::send( + [ 'uid' => $params['uid'], 'fromName' => $sender_name, 'fromEmail' => $sender_email, @@ -645,11 +637,27 @@ function notification($params) { 'messageSubject' => $datarray['subject'], 'htmlVersion' => $email_html_body, 'textVersion' => $email_text_body, - 'additionalMailHeader' => $datarray['headers'], - )); + 'additionalMailHeader' => $datarray['headers']] + ); } - return False; + 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); } /** @@ -660,26 +668,29 @@ function notification($params) { * @param str $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 = ['notify-flags', 'language', 'username', 'email', 'nickname']; + $user = dba::selectFirst('user', $fields, ['uid' => $uid]); + if (!DBM::is_result($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 (!DBM::is_result($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: @@ -723,12 +734,12 @@ function check_item_notification($itemid, $uid, $defaulttype = "") { return false; // 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["notify_flags"] = $user["notify-flags"]; + $params["language"] = $user["language"]; + $params["to_name"] = $user["username"]; + $params["to_email"] = $user["email"]; $params["item"] = $item[0]; $params["parent"] = $item[0]["parent"]; $params["link"] = System::baseUrl().'/display/'.urlencode($item[0]["guid"]); @@ -739,22 +750,19 @@ function check_item_notification($itemid, $uid, $defaulttype = "") { if ($item[0]["parent-uri"] === $item[0]["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[0]['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 (DBM::is_result($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' => normalise_link($tag["url"]), 'uid' => $uid, 'notify_new_posts' => true]; + $r = dba::exists('contact', $condition); + if ($r) { $send_notification = true; + } } } } @@ -780,10 +788,10 @@ function check_item_notification($itemid, $uid, $defaulttype = "") { // 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 + WHERE `thread`.`iid` = %d AND NOT `thread`.`ignored` AND (`thread`.`mention` OR `item`.`author-link` IN ($profile_list)) LIMIT 1", - intval($item[0]["parent"]), intval($uid)); + intval($item[0]["parent"])); if ($parent && !isset($params["type"])) { $params["type"] = NOTIFY_COMMENT;