X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fenotify.php;h=6d27aa8897136fecf5f9e0ea76563d7a21ad2acf;hb=d9c6c919e887eecdd09377b1c233236189650b1e;hp=d98465c6ec430fd1fd02d96d78641ed6cd64de17;hpb=baf316e89808b1480f1fa69916cc2b60c343993b;p=friendica.git
diff --git a/include/enotify.php b/include/enotify.php
index d98465c6ec..6d27aa8897 100644
--- a/include/enotify.php
+++ b/include/enotify.php
@@ -8,7 +8,9 @@ use Friendica\Core\Addon;
use Friendica\Core\Config;
use Friendica\Core\L10n;
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;
@@ -25,6 +27,11 @@ function notification($params)
{
$a = get_app();
+ // Temporary logging for finding the origin
+ if (!isset($params['language']) || !isset($params['uid'])) {
+ logger('Missing parameters.' . System::callstack());
+ }
+
// from here on everything is in the recipients language
L10n::pushLang($params['language']);
@@ -32,11 +39,11 @@ function notification($params)
$product = FRIENDICA_PLATFORM;
$siteurl = System::baseUrl(true);
$thanks = L10n::t('Thank You,');
- $sitename = $a->config['sitename'];
- if (!x($a->config['admin_name'])) {
- $site_admin = L10n::t('%s Administrator', $sitename);
+ $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('%1$s, %2$s Administrator', $a->config['admin_name'], $sitename);
+ $site_admin = L10n::t('%s Administrator', $sitename);
}
$sender_name = $sitename;
@@ -48,15 +55,17 @@ function notification($params)
$sender_email = $a->getSenderEmailAddress();
if ($params['type'] != SYSTEM_EMAIL) {
- $user = dba::selectFirst('user', ['nickname', 'page-flags'],
+ $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"], [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.
@@ -91,7 +100,12 @@ function notification($params)
$parent_id = 0;
}
+ $epreamble = '';
+
if ($params['type'] == NOTIFY_MAIL) {
+ $itemlink = $siteurl.'/message/'.$params['item']['id'];
+ $params["link"] = $itemlink;
+
$subject = L10n::t('[Friendica:Notify] New mail received at %s', $sitename);
$preamble = L10n::t('%1$s sent you a new private message at %2$s.', $params['source_name'], $sitename);
@@ -100,12 +114,11 @@ function notification($params)
$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) {
- $thread = dba::selectFirst('thread', ['ignored'], ['iid' => $parent_id]);
- if (DBM::is_result($thread) && $thread["ignored"]) {
+ $thread = DBA::selectFirst('thread', ['ignored'], ['iid' => $parent_id]);
+ if (DBA::isResult($thread) && $thread["ignored"]) {
logger("Thread ".$parent_id." will be ignored", LOGGER_DEBUG);
return;
}
@@ -116,7 +129,7 @@ function notification($params)
intval(NOTIFY_TAGSELF),
intval(NOTIFY_COMMENT),
intval(NOTIFY_SHARE),
- dbesc($params['link']),
+ DBA::escape($params['link']),
intval($params['uid'])
);
if ($p && count($p)) {
@@ -129,10 +142,11 @@ function notification($params)
$item = null;
if ($params['otype'] === 'item' && $parent_id) {
- $item = Item::selectFirst($params['uid'], [], ['id' => $parent_id]);
+ $item = Item::selectFirstForUser($params['uid'], Item::ITEM_FIELDLIST, ['id' => $parent_id]);
}
$item_post_type = item_post_type($item);
+ $itemlink = $item['plink'];
// "a post"
$dest_str = L10n::t('%1$s commented on [url=%2$s]a %3$s[/url]',
@@ -152,7 +166,7 @@ function notification($params)
}
// "your post"
- if (DBM::is_result($item) && $item['owner-id'] == $item['author-id'] && $item['wall']) {
+ 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,
@@ -241,6 +255,7 @@ function notification($params)
}
if ($params['type'] == NOTIFY_TAGSHARE) {
+ $itemlink = $params['link'];
$subject = L10n::t('[Friendica:Notify] %s tagged your post', $params['source_name']);
$preamble = L10n::t('%1$s tagged your post at %2$s', $params['source_name'], $sitename);
@@ -252,10 +267,10 @@ function notification($params)
$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'];
}
if ($params['type'] == NOTIFY_INTRO) {
+ $itemlink = $params['link'];
$subject = L10n::t('[Friendica:Notify] Introduction received');
$preamble = L10n::t('You\'ve received an introduction from \'%1$s\' at %2$s', $params['source_name'], $sitename);
@@ -269,7 +284,6 @@ function notification($params)
$sitelink = L10n::t('Please visit %s to approve or reject the introduction.');
$tsitelink = sprintf($sitelink, $siteurl);
$hsitelink = sprintf($sitelink, ''.$sitename.'');
- $itemlink = $params['link'];
switch ($params['verb']) {
case ACTIVITY_FRIEND:
@@ -299,6 +313,7 @@ function notification($params)
}
if ($params['type'] == NOTIFY_SUGGEST) {
+ $itemlink = $params['link'];
$subject = L10n::t('[Friendica:Notify] Friend suggestion received');
$preamble = L10n::t('You\'ve received a friend suggestion from \'%1$s\' at %2$s', $params['source_name'], $sitename);
@@ -315,11 +330,11 @@ function notification($params)
$sitelink = L10n::t('Please visit %s to approve or reject the suggestion.');
$tsitelink = sprintf($sitelink, $siteurl);
$hsitelink = sprintf($sitelink, ''.$sitename.'');
- $itemlink = $params['link'];
}
if ($params['type'] == NOTIFY_CONFIRM) {
if ($params['verb'] == ACTIVITY_FRIEND) { // mutual connection
+ $itemlink = $params['link'];
$subject = L10n::t('[Friendica:Notify] Connection accepted');
$preamble = L10n::t('\'%1$s\' has accepted your connection request at %2$s', $params['source_name'], $sitename);
@@ -333,8 +348,8 @@ function notification($params)
$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'];
} else { // ACTIVITY_FOLLOW
+ $itemlink = $params['link'];
$subject = L10n::t('[Friendica:Notify] Connection accepted');
$preamble = L10n::t('\'%1$s\' has accepted your connection request at %2$s', $params['source_name'], $sitename);
@@ -350,13 +365,13 @@ function notification($params)
$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'];
}
}
if ($params['type'] == NOTIFY_SYSTEM) {
switch($params['event']) {
case "SYSTEM_REGISTER_REQUEST":
+ $itemlink = $params['link'];
$subject = L10n::t('[Friendica System Notify]') . ' ' . L10n::t('registration request');
$preamble = L10n::t('You\'ve received a registration request from \'%1$s\' at %2$s', $params['source_name'], $sitename);
@@ -365,7 +380,7 @@ function notification($params)
'[url='.$params['source_link'].']'.$params['source_name'].'[/url]'
);
- $body = L10n::t('Full Name: %1$s\nSite Location: %2$s\nLogin Name: %3$s ' . "\x28" . '%4$s' . "\x29",
+ $body = L10n::t("Full Name: %s\nSite Location: %s\nLogin Name: %s (%s)",
$params['source_name'],
$siteurl, $params['source_mail'],
$params['source_nick']
@@ -374,7 +389,6 @@ function notification($params)
$sitelink = L10n::t('Please visit %s to approve or reject the request.');
$tsitelink = sprintf($sitelink, $params['link']);
$hsitelink = sprintf($sitelink, ''.$sitename.'
');
- $itemlink = $params['link'];
break;
case "SYSTEM_DB_UPDATE_FAIL":
break;
@@ -433,8 +447,8 @@ function notification($params)
$dups = false;
$hash = random_string();
$r = q("SELECT `id` FROM `notify` WHERE `hash` = '%s' LIMIT 1",
- dbesc($hash));
- if (DBM::is_result($r)) {
+ DBA::escape($hash));
+ if (DBA::isResult($r)) {
$dups = true;
}
} while ($dups == true);
@@ -466,23 +480,23 @@ function notification($params)
// create notification entry in DB
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']),
+ DBA::escape($datarray['hash']),
+ DBA::escape($datarray['name']),
+ DBA::escape($datarray['url']),
+ DBA::escape($datarray['photo']),
+ DBA::escape($datarray['date']),
intval($datarray['uid']),
- dbesc($datarray['link']),
+ DBA::escape($datarray['link']),
intval($datarray['iid']),
intval($datarray['parent']),
intval($datarray['type']),
- dbesc($datarray['verb']),
- dbesc($datarray['otype']),
- dbesc($datarray["name_cache"])
+ DBA::escape($datarray['verb']),
+ DBA::escape($datarray['otype']),
+ DBA::escape($datarray["name_cache"])
);
$r = q("SELECT `id` FROM `notify` WHERE `hash` = '%s' AND `uid` = %d LIMIT 1",
- dbesc($hash),
+ DBA::escape($hash),
intval($params['uid'])
);
if ($r) {
@@ -497,12 +511,12 @@ function notification($params)
$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', ['id' => $p[$d]['id']]);
+ DBA::delete('notify', ['id' => $p[$d]['id']]);
}
// only continue on if we stored the first one
@@ -516,15 +530,15 @@ function notification($params)
$msg = replace_macros($epreamble, ['$itemlink' => $itemlink]);
$msg_cache = format_notification_message($datarray['name_cache'], strip_tags(BBCode::convert($msg)));
q("UPDATE `notify` SET `msg` = '%s', `msg_cache` = '%s' WHERE `id` = %d AND `uid` = %d",
- dbesc($msg),
- dbesc($msg_cache),
+ DBA::escape($msg),
+ DBA::escape($msg_cache),
intval($notify_id),
intval($params['uid'])
);
}
// send email notification if notification preferences permit
- if ((intval($params['notify_flags']) & intval($params['type']))
+ if ((!empty($params['notify_flags']) & intval($params['type']))
|| $params['type'] == NOTIFY_SYSTEM
|| $params['type'] == SYSTEM_EMAIL) {
@@ -561,11 +575,8 @@ function notification($params)
}
}
- // textversion keeps linebreaks
- $textversion = strip_tags(str_replace("
", "\n", html_entity_decode(BBCode::convert(stripslashes(str_replace(["\\r\\n", "\\r", "\\n"], "\n",
- $body))),ENT_QUOTES, 'UTF-8')));
- $htmlversion = html_entity_decode(BBCode::convert(stripslashes(str_replace(["\\r\\n", "\\r", "\\n\\n", "\\n"],
- "
\n", $body))), ENT_QUOTES, 'UTF-8');
+ $textversion = BBCode::toPlaintext($body);
+ $htmlversion = BBCode::convert($body);
$datarray = [];
$datarray['banner'] = $banner;
@@ -574,12 +585,12 @@ function notification($params)
$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'] = ''.$itemlink.'';
@@ -609,7 +620,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'],
@@ -630,7 +641,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'],
@@ -665,13 +676,13 @@ function notification($params)
*/
function check_user_notification($itemid) {
// fetch all users in the thread
- $users = dba::p("SELECT DISTINCT(`contact`.`uid`) FROM `item`
+ $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)) {
+ while ($user = DBA::fetch($users)) {
check_item_notification($itemid, $user['uid']);
}
- dba::close($users);
+ DBA::close($users);
}
/**
@@ -679,7 +690,7 @@ function check_user_notification($itemid) {
*
* @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 = ["uid" => $uid, "profiles" => []];
@@ -688,13 +699,13 @@ function check_item_notification($itemid, $uid, $defaulttype = "") {
$profiles = $notification_data["profiles"];
$fields = ['notify-flags', 'language', 'username', 'email', 'nickname'];
- $user = dba::selectFirst('user', $fields, ['uid' => $uid]);
- if (!DBM::is_result($user)) {
+ $user = DBA::selectFirst('user', $fields, ['uid' => $uid]);
+ if (!DBA::isResult($user)) {
return false;
}
- $owner = dba::selectFirst('contact', ['url'], ['self' => true, 'uid' => $uid]);
- if (!DBM::is_result($owner)) {
+ $owner = DBA::selectFirst('contact', ['url'], ['self' => true, 'uid' => $uid]);
+ if (!DBA::isResult($owner)) {
return false;
}
@@ -726,28 +737,28 @@ 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."'";
+ $contact_list = implode(',', $contacts);
+
+ 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-id`, `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;
-
- $author = dba::selectFirst('contact', ['name', 'thumb', 'url'], ['id' => $item[0]['author-id']]);
+ $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 = [];
@@ -756,26 +767,26 @@ function check_item_notification($itemid, $uid, $defaulttype = "") {
$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"]);
+ $params["item"] = $item;
+ $params["parent"] = $item["parent"];
+ $params["link"] = System::baseUrl().'/display/'.urlencode($item["guid"]);
$params["otype"] = 'item';
- $params["source_name"] = $author["name"];
- $params["source_link"] = $author["url"];
- $params["source_photo"] = $author["thumb"];
+ $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?
- $send_notification = dba::exists('contact', ['id' => $item[0]['contact-id'], 'notify_new_posts' => true]);
+ $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) {
$condition = ['nurl' => normalise_link($tag["url"]), 'uid' => $uid, 'notify_new_posts' => true];
- $r = dba::exists('contact', $condition);
+ $r = DBA::exists('contact', $condition);
if ($r) {
$send_notification = true;
}
@@ -793,11 +804,11 @@ 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;
}
@@ -805,9 +816,9 @@ 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 NOT `thread`.`ignored` AND
- (`thread`.`mention` OR `item`.`author-link` IN ($profile_list))
+ (`thread`.`mention` OR `item`.`author-id` IN ($contact_list))
LIMIT 1",
- intval($item[0]["parent"]));
+ intval($item["parent"]));
if ($parent && !isset($params["type"])) {
$params["type"] = NOTIFY_COMMENT;