<?php
-
+/**
+ * @file include/enotify.php
+ */
use Friendica\App;
+use Friendica\Core\Config;
use Friendica\Core\System;
+use Friendica\Database\DBM;
+use Friendica\Util\Emailer;
-require_once('include/Emailer.php');
-require_once('include/email.php');
-require_once('include/bbcode.php');
-require_once('include/html2bbcode.php');
+require_once 'include/bbcode.php';
+require_once 'include/html2bbcode.php';
/**
* @brief Creates a notification entry and possibly sends a mail
source_link, activity, preamble, notify_flags,
language, show_in_notification_page
*/
-function notification($params) {
-
+function notification($params)
+{
$a = get_app();
// from here on everything is in the recipients language
-
push_lang($params['language']);
$banner = t('Friendica Notification');
$siteurl = System::baseUrl(true);
$thanks = t('Thank You,');
$sitename = $a->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))
+ if (empty($sender_email)) {
$sender_email = t('noreply').'@'.$hostname;
+ }
- $user = dba::select('user', array('nickname', 'page-flags'),
- array('uid' => $params['uid']), array('limit' => 1));
+ if ($params['type'] != SYSTEM_EMAIL) {
+ $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))) {
- return;
+ // 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))) {
+ return;
+ }
}
$nickname = $user["nickname"];
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;
+ }
if ($params['type'] == NOTIFY_MAIL) {
$subject = sprintf(t('[Friendica:Notify] New mail received at %s'), $sitename);
}
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),
// 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]'),
$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.
}
}
- if ($params['type'] == "SYSTEM_EMAIL") {
+ if ($params['type'] == SYSTEM_EMAIL) {
// not part of the notifications.
// it just send a mail to the user.
// It will be used by the system to send emails to users (like
$body = $h['body'];
- $sitelink = $h['sitelink'];
$tsitelink = $h['tsitelink'];
$hsitelink = $h['hsitelink'];
$itemlink = $h['itemlink'];
$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);
}
// 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']),
dbesc($hash),
intval($params['uid'])
);
- if ($r)
+ if ($r) {
$notify_id = $r[0]['id'];
- else {
+ } else {
pop_lang();
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),
}
// only continue on if we stored the first one
-
if ($notify_id != $p[0]['id']) {
pop_lang();
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",
+ q("UPDATE `notify` SET `msg` = '%s', `msg_cache` = '%s' WHERE `id` = %d AND `uid` = %d",
dbesc($msg),
dbesc($msg_cache),
intval($notify_id),
// send email notification if notification preferences permit
if ((intval($params['notify_flags']) & intval($params['type']))
|| $params['type'] == NOTIFY_SYSTEM
- || $params['type'] == "SYSTEM_EMAIL") {
+ || $params['type'] == SYSTEM_EMAIL) {
logger('sending notification email');
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']),
call_hooks('enotify_mail', $datarray);
// check whether sending post content in email notifications is allowed
- // always true for "SYSTEM_EMAIL"
- $content_allowed = ((!get_config('system', 'enotify_no_content')) || ($params['type'] == "SYSTEM_EMAIL"));
+ // 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');
));
// use the Emailer class to send the message
-
- return Emailer::send(array(
+ return Emailer::send(
+ array(
'uid' => $params['uid'],
'fromName' => $sender_name,
'fromEmail' => $sender_email,
'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);
}
/**
$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();
// Generate the notification array
$params = array();
$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"]);
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;
+ }
}
}
}
// 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;
projects / friendica.git / blobdiff