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: 

<?php
/**
 * This file contains background notification code for members to
 * reply to posts made by moderators in their own unapproved topics.
 *
 * Simple Machines Forum (SMF)
 *
 * @package SMF
 * @author Simple Machines http://www.simplemachines.org
 * @copyright 2019 Simple Machines and individual contributors
 * @license http://www.simplemachines.org/about/smf/license.php BSD
 *
 * @version 2.1 RC1
 */

/**
 * Class ApproveReply_Notify_Background
 */
class ApproveReply_Notify_Background extends SMF_BackgroundTask
{
    /**
     * This executes the task - loads up the information, puts the email in the queue and inserts alerts.
     * @return bool Always returns true.
     */
    public function execute()
    {
        global $smcFunc, $sourcedir, $scripturl, $modSettings, $language;

        $msgOptions = $this->_details['msgOptions'];
        $topicOptions = $this->_details['topicOptions'];
        $posterOptions = $this->_details['posterOptions'];

        $members = array();
        $alert_rows = array();

        $request = $smcFunc['db_query']('', '
            SELECT id_member, email_address, lngfile
            FROM {db_prefix}topics AS t
                INNER JOIN {db_prefix}members AS mem ON (mem.id_member = t.id_member_started)
            WHERE id_topic = {int:topic}',
            array(
                'topic' => $topicOptions['id'],
            )
        );

        $watched = array();
        while ($row = $smcFunc['db_fetch_assoc']($request))
        {
            $members[] = $row['id_member'];
            $watched[$row['id_member']] = $row;
        }
        $smcFunc['db_free_result']($request);

        require_once($sourcedir . '/Subs-Notify.php');
        $prefs = getNotifyPrefs($members, 'unapproved_reply', true);
        foreach ($watched as $member => $data)
        {
            $pref = !empty($prefs[$member]['unapproved_reply']) ? $prefs[$member]['unapproved_reply'] : 0;

            if ($pref & self::RECEIVE_NOTIFY_EMAIL)
            {
                // Emails are a bit complicated. We have to do language stuff.
                require_once($sourcedir . '/Subs-Post.php');
                require_once($sourcedir . '/ScheduledTasks.php');
                loadEssentialThemeData();

                $replacements = array(
                    'SUBJECT' => $msgOptions['subject'],
                    'LINK' => $scripturl . '?topic=' . $topicOptions['id'] . '.new#new',
                    'POSTERNAME' => un_htmlspecialchars($posterOptions['name']),
                );

                $emaildata = loadEmailTemplate('alert_unapproved_reply', $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' => 'unapproved',
                    'content_id' => $topicOptions['id'],
                    'content_action' => 'reply',
                    'is_read' => 0,
                    'extra' => $smcFunc['json_encode'](array(
                        'topic' => $topicOptions['id'],
                        'board' => $topicOptions['board'],
                        'content_subject' => $msgOptions['subject'],
                        'content_link' => $scripturl . '?topic=' . $topicOptions['id'] . '.new;topicseen#new',
                    )),
                );
                updateMemberData($member, array('alerts' => '+'));
            }
        }

        // Insert the alerts if any
        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()
            );

        return true;
    }
}

?>