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: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 

<?php

/**
 * This taks handles notifying someone that a user has
 * requested to join a group they moderate.
 *
 * 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 GroupReq_Notify_Background
 */
class GroupReq_Notify_Background extends SMF_BackgroundTask
{
    /**
     * This executes the task - loads up the information, puts the email in the queue and inserts any alerts as needed.
     * @return bool Always returns true.
     */
    public function execute()
    {
        global $sourcedir, $smcFunc, $language, $modSettings, $scripturl;

        // Do we have any group moderators?
        $request = $smcFunc['db_query']('', '
            SELECT id_member
            FROM {db_prefix}group_moderators
            WHERE id_group = {int:selected_group}',
            array(
                'selected_group' => $this->_details['id_group'],
            )
        );
        $moderators = array();
        while ($row = $smcFunc['db_fetch_assoc']($request))
            $moderators[] = $row['id_member'];
        $smcFunc['db_free_result']($request);

        require_once($sourcedir . '/Subs-Members.php');

        // Make sure anyone who can moderate_membergroups gets notified as well
        $moderators = array_unique(array_merge($moderators, membersAllowedTo('manage_membergroups')));

        if (!empty($moderators))
        {
            // Figure out who wants to be alerted/emailed about this
            $data = array('alert' => array(), 'email' => array());

            require_once($sourcedir . '/Subs-Notify.php');
            $prefs = getNotifyPrefs($moderators, 'request_group', true);

            // Bitwise comparisons are fun...
            foreach ($moderators as $mod)
            {
                if (!empty($prefs[$mod]['request_group']))
                {
                    if ($prefs[$mod]['request_group'] & 0x01)
                        $data['alert'][] = $mod;

                    if ($prefs[$mod]['request_group'] & 0x02)
                        $data['email'][] = $mod;
                }
            }

            if (!empty($data['alert']))
            {
                $alert_rows = array();

                foreach ($data['alert'] as $group_mod)
                {
                    $alert_rows[] = array(
                        'alert_time' => $this->_details['time'],
                        'id_member' => $group_mod,
                        'id_member_started' => $this->_details['id_member'],
                        'member_name' => $this->_details['member_name'],
                        'content_type' => 'member',
                        'content_id' => 0,
                        'content_action' => 'group_request',
                        'is_read' => 0,
                        'extra' => $smcFunc['json_encode'](array('group_name' => $this->_details['group_name'])),
                    );
                }

                $smcFunc['db_insert']('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($data['alert'], array('alerts' => '+'));
            }

            if (!empty($data['email']))
            {
                require_once($sourcedir . '/ScheduledTasks.php');
                require_once($sourcedir . '/Subs-Post.php');
                loadEssentialThemeData();

                $request = $smcFunc['db_query']('', '
                    SELECT id_member, email_address, lngfile, member_name, mod_prefs
                    FROM {db_prefix}members
                    WHERE id_member IN ({array_int:moderator_list})
                    ORDER BY lngfile',
                    array(
                        'moderator_list' => $moderators,
                    )
                );

                while ($row = $smcFunc['db_fetch_assoc']($request))
                {
                    $replacements = array(
                        'RECPNAME' => $row['member_name'],
                        'APPYNAME' => $this->_details['member_name'],
                        'GROUPNAME' => $this->_details['group_name'],
                        'REASON' => $this->_details['reason'],
                        'MODLINK' => $scripturl . '?action=moderate;area=groups;sa=requests',
                    );

                    $emaildata = loadEmailTemplate('request_membership', $replacements, empty($row['lngfile']) || empty($modSettings['userLanguage']) ? $language : $row['lngfile']);
                    sendmail($row['email_address'], $emaildata['subject'], $emaildata['body'], null, 'groupreq' . $this->_details['id_group'], $emaildata['is_html'], 2);
                }
            }
        }

        return true;
    }
}

?>