1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123:
<?php
class ApprovePost_Notify_Background extends SMF_BackgroundTask
{
public function execute()
{
global $smcFunc, $sourcedir, $scripturl, $modSettings, $language;
$msgOptions = $this->_details['msgOptions'];
$topicOptions = $this->_details['topicOptions'];
$posterOptions = $this->_details['posterOptions'];
$type = $this->_details['type'];
$members = array();
$alert_rows = array();
require_once($sourcedir . '/Subs-Members.php');
$modMembers = membersAllowedTo('approve_posts', $topicOptions['board']);
$request = $smcFunc['db_query']('', '
SELECT id_member, email_address, lngfile
FROM {db_prefix}members
WHERE id_member IN ({array_int:members})',
array(
'members' => $modMembers,
)
);
$watched = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
$members[] = $row['id_member'];
$watched[$row['id_member']] = $row;
}
$smcFunc['db_free_result']($request);
if (empty($members))
return true;
require_once($sourcedir . '/Subs-Notify.php');
$members = array_unique($members);
$prefs = getNotifyPrefs($members, 'unapproved_post', true);
foreach ($watched as $member => $data)
{
$pref = !empty($prefs[$member]['unapproved_post']) ? $prefs[$member]['unapproved_post'] : 0;
if ($pref & self::RECEIVE_NOTIFY_EMAIL)
{
require_once($sourcedir . '/Subs-Post.php');
require_once($sourcedir . '/ScheduledTasks.php');
loadEssentialThemeData();
$replacements = array(
'SUBJECT' => $msgOptions['subject'],
'LINK' => $scripturl . '?topic=' . $topicOptions['id'] . '.new#new',
);
$emaildata = loadEmailTemplate('alert_unapproved_post', $replacements, empty($data['lngfile']) || empty($modSettings['userLanguage']) ? $language : $data['lngfile']);
sendmail($data['email_address'], $emaildata['subject'], $emaildata['body'], null, 'm' . $topicOptions['id'], $emaildata['is_html']);
}
if ($pref & self::RECEIVE_NOTIFY_ALERT)
{
$alert_rows[] = array(
'alert_time' => time(),
'id_member' => $member,
'id_member_started' => $posterOptions['id'],
'member_name' => $posterOptions['name'],
'content_type' => 'topic',
'content_id' => $topicOptions['id'],
'content_action' => 'unapproved_' . $type,
'is_read' => 0,
'extra' => $smcFunc['json_encode'](array(
'topic' => $topicOptions['id'],
'board' => $topicOptions['board'],
'content_subject' => $msgOptions['subject'],
'content_link' => $scripturl . '?topic=' . $topicOptions['id'] . '.msg' . $msgOptions['id'] . '#msg' . $msgOptions['id'],
)),
);
}
}
if (!empty($alert_rows))
{
$smcFunc['db_insert']('',
'{db_prefix}user_alerts',
array('alert_time' => 'int', 'id_member' => 'int', 'id_member_started' => 'int', 'member_name' => 'string',
'content_type' => 'string', 'content_id' => 'int', 'content_action' => 'string', 'is_read' => 'int', 'extra' => 'string'),
$alert_rows,
array()
);
updateMemberData(array_keys($watched), array('alerts' => '+'));
}
return true;
}
}
?>