simple-machines-forum/Sources/tasks/CreateAttachment-Notify.php

<?php

/**
 * This file contains code used to notify moderators when there are attachments
 * that need to be approved.
 *
 * Simple Machines Forum (SMF)
 *
 * @package SMF
 * @author Simple Machines https://www.simplemachines.org
 * @copyright 2022 Simple Machines and individual contributors
 * @license https://www.simplemachines.org/about/smf/license.php BSD
 *
 * @version 2.1.0
 */

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

		// Validate the attachment does exist and is the right approval state.
		$request = $smcFunc['db_query']('', '
			SELECT a.id_attach, m.id_board, m.id_msg, m.id_topic, m.id_member, m.subject
			FROM {db_prefix}attachments AS a
				INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
			WHERE a.id_attach = {int:attachment}
				AND a.attachment_type = {int:attachment_type}
				AND a.approved = {int:is_approved}',
			array(
				'attachment' => $this->_details['id'],
				'attachment_type' => 0,
				'is_approved' => 0,
			)
		);
		// Return true if either not found or invalid so that the cron runner deletes this task.
		if ($smcFunc['db_num_rows']($request) == 0)
			return true;
		list ($id_attach, $id_board, $id_msg, $id_topic, $id_member, $subject) = $smcFunc['db_fetch_row']($request);
		$smcFunc['db_free_result']($request);

		// We need to know who can approve this attachment.
		require_once($sourcedir . '/Subs-Members.php');
		$modMembers = membersAllowedTo('approve_posts', $id_board);

		$request = $smcFunc['db_query']('', '
			SELECT id_member, email_address, lngfile, real_name
			FROM {db_prefix}members
			WHERE id_member IN ({array_int:members})',
			array(
				'members' => array_merge($modMembers, array($id_member)),
			)
		);

		$members = array();
		$watched = array();
		$real_name = '';
		while ($row = $smcFunc['db_fetch_assoc']($request))
		{
			if ($row['id_member'] == $id_member)
				$real_name = $row['real_name'];
			else
			{
				$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_attachment', true);
		foreach ($watched as $member => $data)
		{
			$pref = !empty($prefs[$member]['unapproved_attachment']) ? $prefs[$member]['unapproved_attachment'] : 0;

			if ($pref & self::RECEIVE_NOTIFY_EMAIL)
			{
				// Emails are a bit complicated. (That's what she said)
				require_once($sourcedir . '/Subs-Post.php');
				require_once($sourcedir . '/ScheduledTasks.php');
				loadEssentialThemeData();

				$emaildata = loadEmailTemplate(
					'unapproved_attachment',
					array(
						'SUBJECT' => $subject,
						'LINK' => $scripturl . '?topic=' . $id_topic . '.msg' . $id_msg . '#msg' . $id_msg,
					),
					empty($data['lngfile']) || empty($modSettings['userLanguage']) ? $language : $data['lngfile']
				);
				sendmail(
					$data['email_address'],
					$emaildata['subject'],
					$emaildata['body'],
					null,
					'ma' . $id_attach,
					$emaildata['is_html']
				);
			}

			if ($pref & self::RECEIVE_NOTIFY_ALERT)
			{
				$alert_rows[] = array(
					'alert_time' => time(),
					'id_member' => $member,
					'id_member_started' => $id_member,
					'member_name' => $real_name,
					'content_type' => 'msg',
					'content_id' => $id_msg,
					'content_action' => 'unapproved_attachment',
					'is_read' => 0,
					'extra' => $smcFunc['json_encode'](
						array(
							'topic' => $id_topic,
							'board' => $id_board,
							'content_subject' => $subject,
							'content_link' => $scripturl . '?msg=' . $id_msg,
						)
					),
				);
			}
		}

		// Insert the alerts if any
		if (!empty($alert_rows))
		{
			$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(array_keys($watched), array('alerts' => '+'));
		}

		return true;
	}
}

?>