/**
* This takes a list of nodes, and returns node records for all that are valid nodeids.
*
* @param mixed $nodeList array of ints
* @param bool $withJoinableContent Include joinable content
*
* @return array list of node records
**/
protected function cleanNodeList(&$nodeList, $withJoinableContent = false)
{
if (!is_array($nodeList)) {
$nodeList = array($nodeList);
}
$nodeList = array_unique($nodeList);
//many of them may be in cache.
$cached = vB_Library_Content::fetchFromCache($nodeList, vB_Library_Content::CACHELEVEL_NODE);
$listIndex = array_flip($nodeList);
if (!empty($cached['found'])) {
foreach ($cached['found'] as $node) {
$nodeid = $node['nodeid'];
if (isset($listIndex[$nodeid])) {
$nodeList[$listIndex[$nodeid]] = $node;
unset($listIndex[$nodeid]);
}
}
}
if (!empty($cached['notfound'])) {
if ($withJoinableContent) {
$nodes = vB::getDbAssertor()->assertQuery('vBForum:fetchNodeWithContent', array(vB_dB_Query::TYPE_KEY => vB_dB_Query::QUERY_METHOD, 'nodeid' => $cached['notfound']));
} else {
$nodes = vB::getDbAssertor()->assertQuery('vBForum:node', array('nodeid' => $cached['notfound']));
}
foreach ($nodes as $node) {
$nodeid = $node['nodeid'];
if (isset($listIndex[$nodeid])) {
$nodeList[$listIndex[$nodeid]] = $node;
unset($listIndex[$nodeid]);
}
}
}
//if we filtered out a node in the query, remove it from the list.
foreach ($listIndex as $key => $value) {
unset($nodeList[$value]);
}
}
protected function sendLegacyEmailNotification($data)
{
$options = vB::getDatastore()->getValue('options');
if (isset($options['enableemail']) and !$options['enableemail']) {
return;
// email notifications are globally disabled
}
/*
* Save some data for this page load. Since we can potentially fetch a bunch of the same
* data over and over if multiple users are getting notifications about the same content
* that was just created, let's get rid of the redundant calls when this function is called
* in a loop.
* Todo: we should write a bulk-send-email-notification function
*
* I can't actually think of a case where a single content creation that triggers a number
* of email notifications will have different contentnodeid in its group of notifications,
* but let's just be safe and allow for that possibility.
*/
static $recipientIndependentDataArray;
$contentnodeid = isset($data['contentnodeid']) ? $data['contentnodeid'] : 0;
if (!empty($contentnodeid) and empty($recipientIndependentDataArray[$contentnodeid])) {
//we need to load this using the correct library class or things get weird.
//note that if we load it from cache here it will be in the local memory cache
//when we load the full content and we won't do it twice.
$cached = vB_Library_Content::fetchFromCache(array($contentnodeid), vB_Library_Content::CACHELEVEL_FULLCONTENT);
if (isset($cached['found'][$contentnodeid])) {
$contenttypeid = $cached['found'][$contentnodeid]['contenttypeid'];
} else {
$row = $this->assertor->getRow('vBForum:node', array(vB_dB_Query::TYPE_KEY => vB_dB_Query::QUERY_SELECT, vB_dB_Query::COLUMNS_KEY => array('contenttypeid'), 'nodeid' => $contentnodeid));
$contenttypeid = $row['contenttypeid'];
}
$contentLib = vB_Library_Content::getContentLib($contenttypeid);
$currentNode = $contentLib->getContent($contentnodeid);
$currentNode = $currentNode[$contentnodeid];
/*
* These data are static & independent of the recipient of this message, assuming that
* we're not trying to hide any data. If we are going to check permissions for each
* recipient, we should probably check view perms & remove from the recipients list
* BEFORE we ever get to this function, and just not send them a notification instead of
* hiding data.
*/
$recipientIndependentDataArray[$contentnodeid] = array('authorname' => $currentNode['userinfo']['username'], 'nodeurl' => vB5_Route::buildUrl('node|fullurl', array('nodeid' => $contentnodeid)), 'previewtext' => vB_String::getPreviewText($currentNode['rawtext']), 'nodeid' => $currentNode['nodeid'], 'starter' => $currentNode['starter'], 'startertitle' => isset($currentNode['startertitle']) ? $currentNode['startertitle'] : '', 'parentid' => $currentNode['parentid'], 'channeltitle' => $currentNode['channeltitle'], 'channeltype' => $currentNode['channeltype']);
}
// additional data used for subscription notifications
if (isset($data['subscriptionnodeid'])) {
$subId = $data['subscriptionnodeid'];
if (!isset($recipientIndependentDataArray[$contentnodeid]['add_sub_data'][$subId])) {
//we need to load this using the correct library class or things get weird.
//note that if we load it from cache here it will be in the local memory cache
//when we load the full content and we won't do it twice.
$cached = vB_Library_Content::fetchFromCache(array($subId), vB_Library_Content::CACHELEVEL_FULLCONTENT);
if (isset($cached['found'][$subId])) {
$contenttypeid = $cached['found'][$subId]['contenttypeid'];
} else {
$row = $this->assertor->getRow('vBForum:node', array(vB_dB_Query::TYPE_KEY => vB_dB_Query::QUERY_SELECT, vB_dB_Query::COLUMNS_KEY => array('contenttypeid'), 'nodeid' => $subId));
$contenttypeid = $row['contenttypeid'];
}
if ($contenttypeid) {
$contentLib = vB_Library_Content::getContentLib($contenttypeid);
$subbedNode = $contentLib->getContent($subId);
$subbedNode = $subbedNode[$subId];
$channelTypeId = vB_Types::instance()->getContentTypeID('vBForum_Channel');
if ($subbedNode['contenttypeid'] == $channelTypeId) {
$nodetype = 'channel';
} else {
$nodetype = 'post';
}
$recipientIndependentDataArray[$contentnodeid]['add_sub_data'][$subId] = array('title' => $subbedNode['title'], 'nodetype' => $nodetype);
}
}
// We only expect channeltype_forum, channeltype_article, channeltype_blog, channeltype_group, but
// a channeltype_<> phrase for each of vB_Channel::$channelTypes should exist, so we can do this
$channeltype = "channeltype_" . $recipientIndependentDataArray[$contentnodeid]['channeltype'];
$nodetype = $recipientIndependentDataArray[$contentnodeid]['add_sub_data'][$subId]['nodetype'];
// While phrases are dependent on languageid, it's not really recipient or userid
// dependent and is shared/static among different recipients, so let's keep track
// of them.
if (!isset($phrases[$data['languageid']])) {
$phrases[$data['languageid']] = vB_Api::instanceInternal('phrase')->fetch(array($channeltype, $nodetype), $data['languageid']);
}
}
// keep track of the about strings that are for "content" notifications
$temporary = array(vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_REPLY, vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_COMMENT, vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_THREADCOMMENT, vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_SUBSCRIPTION, vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_USERMENTION);
$contentNotificationAboutStrings = array();
foreach ($temporary as $aboutString) {
$contentNotificationAboutStrings[$aboutString] = $aboutString;
}
if ($data['about'] == vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_VM) {
// A VM should have only 1 recipient, so no good reason to cache this like other URLs. Also
// VMs don't seem to work with the /node/ route, so we can't rely on that.
$vmURL = vB5_Route::buildUrl('visitormessage|fullurl', array('nodeid' => $contentnodeid));
$maildata = vB_Api::instanceInternal('phrase')->fetchEmailPhrases('visitormessage', array($data['username'], $recipientIndependentDataArray[$contentnodeid]['authorname'], $vmURL, $recipientIndependentDataArray[$contentnodeid]['previewtext'], $options['bbtitle']), array(), $data['languageid']);
} elseif ($data['about'] == vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_VOTE) {
// Vote notifications have their own section because their phrases aren't in the same format as the others
// Since a vote doesn't have a node associated with it, we don't have a "currentnode" data.
// Note that the poll library sets aboutid & contentid both to the nodeid of the poll-post
$maildata = vB_Api::instanceInternal('phrase')->fetchEmailPhrases('vote', array($data['username'], vB_Api::instanceInternal('user')->fetchUserName(vB::getCurrentSession()->get('userid')), $recipientIndependentDataArray[$contentnodeid]['nodeurl'], $options['bbtitle']), array($recipientIndependentDataArray[$contentnodeid]['startertitle']), $data['languageid']);
} elseif (isset($contentNotificationAboutStrings[$data['about']])) {
// Normally the subject would contain the topic title, but if it's a subscription let's pass in the
// title of the actual subscription node whether it's a channel, thread, blog etc.
$emailSubjectVars = array($recipientIndependentDataArray[$contentnodeid]['startertitle']);
// Since subscription email subjects don't have a title, we'll include the title in
// the email body as a 7th variable.
$emailBodyVars = array($data['username'], $recipientIndependentDataArray[$contentnodeid]['authorname'], $recipientIndependentDataArray[$contentnodeid]['nodeurl'], $recipientIndependentDataArray[$contentnodeid]['previewtext'], $options['bbtitle'], $options['frontendurl'] . '/member/' . $data['userid'] . '/subscriptions');
// blog & social groups have special phrases, unless it's a subscription notification or a user mention.
// If the latter, just send the generic subscription or user mention email.
// As of 5.1.4, we do not expect to hit this block for blogs, because the people who *would*
// receive this (the blog poster) are automatically subscribed to the blog channel, and
// subscription notifications always trump other types of notifications. See VBV-13466
if ($recipientIndependentDataArray[$contentnodeid]['channeltype'] == 'blog' and $data['about'] != vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_SUBSCRIPTION and $data['about'] != vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_USERMENTION) {
$mailPhrase = 'comment_blogentry';
} else {
if ($recipientIndependentDataArray[$contentnodeid]['channeltype'] == 'group' and $data['about'] != vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_SUBSCRIPTION and $data['about'] != vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_USERMENTION) {
$mailPhrase = 'comment_grouptopic';
} else {
switch ($data['about']) {
case vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_REPLY:
$mailPhrase = 'reply_thread';
break;
case vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_COMMENT:
$mailPhrase = 'comment_post';
break;
case vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_THREADCOMMENT:
$mailPhrase = 'comment_thread';
break;
case vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_SUBSCRIPTION:
$mailPhrase = 'subscribed_thread';
// $subId, $nodetype, $channeltype aer set above as long as 'subscriptionnodeid' was passed in.
if (!empty($subId)) {
// A new post in your {2} {3} subscription: {1}
$emailSubjectVars = array($recipientIndependentDataArray[$contentnodeid]['add_sub_data'][$subId]['title'], $phrases[$data['languageid']][$channeltype], $phrases[$data['languageid']][$nodetype]);
// Since we removed the starter title from the subject, add it to the message.
$emailBodyVars[] = $recipientIndependentDataArray[$contentnodeid]['startertitle'];
}
break;
case vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_USERMENTION:
$mailPhrase = 'usermention_post';
// subject: <username> mentioned you in <content item title>
$emailSubjectVars = array($recipientIndependentDataArray[$contentnodeid]['authorname'], $recipientIndependentDataArray[$contentnodeid]['startertitle']);
break;
default:
if ($recipientIndependentDataArray[$contentnodeid]['starter'] == $recipientIndependentDataArray[$contentnodeid]['parentid']) {
$mailPhrase = 'reply_thread';
} else {
$mailPhrase = 'reply_post';
}
break;
}
}
}
$maildata = vB_Api::instanceInternal('phrase')->fetchEmailPhrases($mailPhrase, $emailBodyVars, $emailSubjectVars, $data['languageid']);
} elseif ($data['about'] == vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_RATE) {
$node = $recipientIndependentDataArray[$contentnodeid];
// It doesn't make sense to call blog & article starters as "threads", so just go with "post"
if ($node['nodeid'] == $node['starter'] and ($node['channeltype'] == 'forum' or $node['channeltype'] == 'group')) {
$mailPhrase = 'like_thread';
} else {
$mailPhrase = 'like_post';
}
$maildata = vB_Api::instanceInternal('phrase')->fetchEmailPhrases($mailPhrase, array($data['username'], vB_Api::instanceInternal('user')->fetchUserName($data['senderid']), $node['nodeurl'], $options['bbtitle']), array($options['bbtitle']));
} elseif ($data['about'] == vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_FOLLOW) {
// the use of vB5_Route::buildUrl() below should be ok performant wise, because we're not expecting to send a bulk email for this
// notification type. We should avoid hacky hacks (see above in the content notification section for avoiding vB5_Route::buildUrl()
// to each recipient's subscription page) when forgivable.
$maildata = vB_Api::instanceInternal('phrase')->fetchEmailPhrases('follow_approve', array($data['username'], vB_Api::instanceInternal('user')->fetchUserName($data['senderid']), vB5_Route::buildUrl('profile|fullurl', array('userid' => $data['senderid'], 'tab' => 'subscribed')), $options['bbtitle']), array($options['bbtitle']));
} elseif ($data['about'] == vB_Library_Content_Privatemessage::NOTIFICATION_TYPE_FOLLOWING) {
/*
Per dev chat discussion, this never existed. Since there doesn't seem to be a strong customer request for this,
I'm gonna leave it out. I'm leaving this section in so that it's trivial to add in the future.
*/
$maildata = array();
} else {
// We don't know how to handle this.
$maildata = array();
}
if (!empty($data['email']) and !empty($maildata)) {
// Send the email
vB_Mail::vbmail($data['email'], $maildata['subject'], $maildata['message'], false);
}
}
