messagesInTopics() - Code Metrics - elkarte/Elkarte - Measure and Improve Code Quality continuously with Scrutinizer

messagesInTopics() A
last analyzed 2025-12-05 00:18 UTC

↳ Parent: Project
Complexity

Conditions	2
Paths	2
Size

Total Lines	23
Code Lines	9
Duplication

Lines	0
Ratio	0 %
Code Coverage

Tests	0
CRAP Score	6
Importance

Changes	1
Bugs	0	Features	0
Metric	Value
cc	2
eloc	9
nc	2
nop	1
dl	0
loc	23
ccs	0
cts	14
cp	0
crap	6
rs	9.9666
c	1
b	0
f	0
<?php

/**
 * This file contains functions for dealing with topics. Low-level functions,
 * i.e. database operations needed to perform.
 * These functions do NOT make permissions checks. (they assume those were
 * already made).
 *
 * @package   ElkArte Forum
 * @copyright ElkArte Forum contributors
 * @license   BSD http://opensource.org/licenses/BSD-3-Clause (see accompanying LICENSE.txt file)
 *
 * This file contains code covered by:
 * copyright: 2011 Simple Machines (http://www.simplemachines.org)
 *
 * @version 2.0 dev
 *
 */

use BBC\ParserWrapper;
use ElkArte\Cache\Cache;
use ElkArte\Helper\Util;
use ElkArte\Languages\Loader as LangLoader;
use ElkArte\MessagesDelete;
use ElkArte\Search\SearchApiWrapper;
use ElkArte\User;

/**
 * Removes the passed id_topic's checking for permissions.
 *
 * @param int[]|int $topics The topics to remove (can be an id or an array of ids).
 */
function removeTopicsPermissions($topics)
{
	global $board;

	// They can only delete their own topics. (we wouldn't be here if they couldn't do that..)
	$possible_remove = topicAttribute($topics, ['id_topic', 'id_board', 'id_member_started']);

	$removeCache = [];
	$removeCacheBoards = [];
	$test_owner = !empty($board) && !allowedTo('remove_any');
	foreach ($possible_remove as $row)
	{
		// Skip if we have to test the owner *and* the user is not the owner
		if ($test_owner && $row['id_member_started'] != User::$info->id)

		{
			continue;
		}

		$removeCache[] = $row['id_topic'];
		$removeCacheBoards[$row['id_topic']] = $row['id_board'];
	}

	// Maybe *none* were their own topics.
	if (!empty($removeCache))
	{
		removeTopics($removeCache, true, false, true, $removeCacheBoards);
	}
}

/**
 * Removes the passed id_topic's.
 *
 * - Permissions are NOT checked here because the function is used in a scheduled task
 *
 * @param int[]|int $topics The topics to remove (can be an id or an array of ids).
 * @param bool $decreasePostCount if true users' post count will be reduced
 * @param bool $ignoreRecycling if true topics are not moved to the recycle board (if it exists).
 * @param bool $log if true logs the action.
 * @param int[] $removeCacheBoards an array matching topics and boards.
 */
function removeTopics($topics, $decreasePostCount = true, $ignoreRecycling = false, $log = false, $removeCacheBoards = [])
{
	global $modSettings;

	// Nothing to do?
	if (empty($topics))
	{
		return;
	}

	$db = database();
	$cache = Cache::instance();

	// Only a single topic.
	if (!is_array($topics))
	{
		$topics = [$topics];
	}

	if ($log)
	{
		// Gotta send the notifications *first*!
		foreach ($topics as $topic)
		{
			// Only log the topic ID if it's not in the recycle board.
			logAction('remove', [(empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $removeCacheBoards[$topic] ? 'topic' : 'old_topic_id') => $topic, 'board' => $removeCacheBoards[$topic]]);
			sendNotifications($topic, 'remove');
		}
	}

	// Decrease the post counts for members.
	if ($decreasePostCount)
	{
		$requestMembers = $db->query('', '
			SELECT 
				m.id_member, COUNT(*) AS posts
			FROM {db_prefix}messages AS m
				INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
			WHERE m.id_topic IN ({array_int:topics})
				AND m.icon != {string:recycled}
				AND b.count_posts = {int:do_count_posts}
				AND m.approved = {int:is_approved}
			GROUP BY m.id_member',
			[
				'do_count_posts' => 0,
				'recycled' => 'recycled',
				'topics' => $topics,
				'is_approved' => 1,
			]
		);
		if ($requestMembers->num_rows() > 0)
		{
			require_once(SUBSDIR . '/Members.subs.php');
			while (($rowMembers = $requestMembers->fetch_assoc()))
			{
				updateMemberData($rowMembers['id_member'], ['posts' => 'posts - ' . $rowMembers['posts']]);
			}
		}
		$requestMembers->free_result();
	}

	// Recycle topics that aren't in the recycle board...
	if (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 && !$ignoreRecycling)
	{
		$possible_recycle = topicAttribute($topics, ['id_topic', 'id_board', 'unapproved_posts', 'approved']);

		if (!empty($possible_recycle))
		{
			detectServer()->setTimeLimit(300);

			// Get topics that will be recycled.
			$recycleTopics = [];
			foreach ($possible_recycle as $row)
			{
				// If it's already in the recycle board do nothing
				if ($row['id_board'] == $modSettings['recycle_board'])
				{
					continue;
				}

				$recycleTopics[] = $row['id_topic'];

				// Set the id_previous_board for this topic - and make it not sticky.
				setTopicAttribute($row['id_topic'], [
					'id_previous_board' => $row['id_board'],
					'is_sticky' => 0,
				]);
			}

			if (!empty($recycleTopics))
			{
				// Mark recycled topics as recycled.
				$db->query('', '
				UPDATE {db_prefix}messages
				SET 
					icon = {string:recycled}
				WHERE id_topic IN ({array_int:recycle_topics})',
					[
						'recycle_topics' => $recycleTopics,
						'recycled' => 'recycled',
					]
				);

				// Move the topics to the recycle board.
				require_once(SUBSDIR . '/Topic.subs.php');
				moveTopics($recycleTopics, $modSettings['recycle_board']);

				// Close reports that are being recycled.
				require_once(SUBSDIR . '/Moderation.subs.php');

				$db->query('', '
				UPDATE {db_prefix}log_reported
				SET 
					closed = {int:is_closed}
				WHERE id_topic IN ({array_int:recycle_topics})',
					[
						'recycle_topics' => $recycleTopics,
						'is_closed' => 1,
					]
				);

				updateSettings(['last_mod_report_action' => time()]);
				recountOpenReports();

				// Make in-accessible any topic/message mentions
				$remover = new MessagesDelete($modSettings['recycle_enable'], $modSettings['recycle_board']);
				$remover->deleteMessageMentions(messagesInTopics($recycleTopics), true);

				// Topics that were recycled don't need to be deleted, so subtract them.
				$topics = array_diff($topics, $recycleTopics);
			}
		}
	}

	// Still topics left to delete?
	if (empty($topics))
	{
		return;
	}

	$adjustBoards = [];

	// Find out how many posts we are deleting.
	$db->fetchQuery('
		SELECT 
			id_board, approved, COUNT(*) AS num_topics, SUM(unapproved_posts) AS unapproved_posts,
			SUM(num_replies) AS num_replies
		FROM {db_prefix}topics
		WHERE id_topic IN ({array_int:topics})
		GROUP BY id_board, approved',
		[
			'topics' => $topics,
		]
	)->fetch_callback(
		function ($row) use (&$adjustBoards, $cache) {
			if (!isset($adjustBoards[$row['id_board']]['num_posts']))
			{
				$cache->remove('board-' . $row['id_board']);

				$adjustBoards[$row['id_board']] = [
					'num_posts' => 0,
					'num_topics' => 0,
					'unapproved_posts' => 0,
					'unapproved_topics' => 0,
					'id_board' => $row['id_board']
				];
			}
			// Posts = (num_replies + 1) for each approved topic.
			$adjustBoards[$row['id_board']]['num_posts'] += $row['num_replies'] + ($row['approved'] ? $row['num_topics'] : 0);
			$adjustBoards[$row['id_board']]['unapproved_posts'] += $row['unapproved_posts'];

			// Add the topics to the right type.
			if ($row['approved'])
			{
				$adjustBoards[$row['id_board']]['num_topics'] += $row['num_topics'];
			}
			else
			{
				$adjustBoards[$row['id_board']]['unapproved_topics'] += $row['num_topics'];
			}
		}
	);

	// Decrease number of posts and topics for each board.
	detectServer()->setTimeLimit(300);
	foreach ($adjustBoards as $stats)
	{
		$db->query('', '
			UPDATE {db_prefix}boards
			SET
				num_posts = CASE WHEN {int:num_posts} > num_posts THEN 0 ELSE num_posts - {int:num_posts} END,
				num_topics = CASE WHEN {int:num_topics} > num_topics THEN 0 ELSE num_topics - {int:num_topics} END,
				unapproved_posts = CASE WHEN {int:unapproved_posts} > unapproved_posts THEN 0 ELSE unapproved_posts - {int:unapproved_posts} END,
				unapproved_topics = CASE WHEN {int:unapproved_topics} > unapproved_topics THEN 0 ELSE unapproved_topics - {int:unapproved_topics} END
			WHERE id_board = {int:id_board}',
			[
				'id_board' => $stats['id_board'],
				'num_posts' => $stats['num_posts'],
				'num_topics' => $stats['num_topics'],
				'unapproved_posts' => $stats['unapproved_posts'],
				'unapproved_topics' => $stats['unapproved_topics'],
			]
		);
	}

	// Remove polls for these topics.
	$possible_polls = topicAttribute($topics, 'id_poll');
	$polls = [];
	foreach ($possible_polls as $row)
	{
		if (!empty($row['id_poll']))
		{
			$polls[] = $row['id_poll'];
		}
	}

	if (!empty($polls))
	{
		$db->query('', '
			DELETE FROM {db_prefix}polls
			WHERE id_poll IN ({array_int:polls})',
			[
				'polls' => $polls,
			]
		);
		$db->query('', '
			DELETE FROM {db_prefix}poll_choices
			WHERE id_poll IN ({array_int:polls})',
			[
				'polls' => $polls,
			]
		);
		$db->query('', '
			DELETE FROM {db_prefix}log_polls
			WHERE id_poll IN ({array_int:polls})',
			[
				'polls' => $polls,
			]
		);
	}

	// Get rid of the attachment(s).
	require_once(SUBSDIR . '/ManageAttachments.subs.php');
	$attachmentQuery = [
		'attachment_type' => 0,
		'id_topic' => $topics,
	];
	removeAttachments($attachmentQuery, 'messages');

	// Delete search index entries.
	if (!empty($modSettings['search_custom_index_config']))
	{
		$words = [];
		$messages = [];
		$db->fetchQuery('
			SELECT 
				id_msg, body
			FROM {db_prefix}messages
			WHERE id_topic IN ({array_int:topics})',
			[
				'topics' => $topics,
			]
		)->fetch_callback(
			function ($row) use (&$words, &$messages) {
				detectServer()->setTimeLimit(300);

				$words = array_merge($words, text2words($row['body'], true));
				$messages[] = $row['id_msg'];
			}
		);
		$words = array_unique($words);

		if (!empty($words) && !empty($messages))
		{
			$db->query('', '
				DELETE FROM {db_prefix}log_search_words
				WHERE id_word IN ({array_int:word_list})
					AND id_msg IN ({array_int:message_list})',
				[
					'word_list' => $words,
					'message_list' => $messages,
				]
			);
		}
	}

	// Reuse the message array if available
	if (empty($messages))
	{
		$messages = messagesInTopics($topics);
	}

	// If there are messages left in this topic
	if (!empty($messages))
	{
		// Decrease / Update the member like counts
		require_once(SUBSDIR . '/Likes.subs.php');
		decreaseLikeCounts($messages);

		// Remove all likes now that the topic is gone
		$db->query('', '
			DELETE FROM {db_prefix}message_likes
			WHERE id_msg IN ({array_int:messages})',
			[
				'messages' => $messages,
			]
		);

		// Remove all message mentions now that the topic is gone
		$remover = new MessagesDelete($modSettings['recycle_enable'], $modSettings['recycle_board']);
		$remover->deleteMessageMentions($messages);
	}

	// Delete messages in each topic.
	$db->query('', '
		DELETE FROM {db_prefix}messages
		WHERE id_topic IN ({array_int:topics})',
		[
			'topics' => $topics,
		]
	);

	// Remove linked calendar events.
	// @todo if unlinked events are enabled, wouldn't this be expected to keep them?
	$db->query('', '
		DELETE FROM {db_prefix}calendar
		WHERE id_topic IN ({array_int:topics})',
		[
			'topics' => $topics,
		]
	);

	// Delete log_topics data
	$db->query('', '
		DELETE FROM {db_prefix}log_topics
		WHERE id_topic IN ({array_int:topics})',
		[
			'topics' => $topics,
		]
	);

	// Delete notifications
	$db->query('', '
		DELETE FROM {db_prefix}log_notify
		WHERE id_topic IN ({array_int:topics})',
		[
			'topics' => $topics,
		]
	);

	// Delete the topics themselves
	$db->query('', '
		DELETE FROM {db_prefix}topics
		WHERE id_topic IN ({array_int:topics})',
		[
			'topics' => $topics,
		]
	);

	// Remove data from the subjects for search cache
	$db->query('', '
		DELETE FROM {db_prefix}log_search_subjects
		WHERE id_topic IN ({array_int:topics})',
		[
			'topics' => $topics,
		]
	);
	require_once(SUBSDIR . '/FollowUps.subs.php');
	removeFollowUpsByTopic($topics);

	foreach ($topics as $topic_id)
	{
		$cache->remove('topic_board-' . $topic_id);
	}

	// Maybe there's an addon that wants to delete topic related data of its own
	call_integration_hook('integrate_remove_topics', [$topics]);

	// Update the totals...
	require_once(SUBSDIR . '/Messages.subs.php');
	updateMessageStats();
	updateTopicStats();
	updateSettings([
		'calendar_updated' => time(),
	]);

	require_once(SUBSDIR . '/Post.subs.php');
	$updates = [];
	foreach ($adjustBoards as $stats)
	{
		$updates[] = $stats['id_board'];
	}
	updateLastMessages($updates);
}

/**
 * Moves lots of topics to a specific board and checks if the user can move them
 *
 * @param array $moveCache [0] => int[] is the topic, [1] => int[]  is the board to move to.
 */
function moveTopicsPermissions($moveCache)
{
	global $board;

	$db = database();

	$moveTos = [];
	$moveCache2 = [];
	$countPosts = [];

	// I know - I just KNOW you're trying to beat the system.  Too bad for you... we CHECK :P.
	$db->fetchQuery('
		SELECT 
			t.id_topic, t.id_board, b.count_posts
		FROM {db_prefix}topics AS t
			LEFT JOIN {db_prefix}boards AS b ON (t.id_board = b.id_board)
		WHERE t.id_topic IN ({array_int:move_topic_ids})' . (!empty($board) && !allowedTo('move_any') ? '
			AND t.id_member_started = {int:current_member}' : '') . '
		LIMIT ' . count($moveCache[0]),
		[
			'current_member' => User::$info->id,

			'move_topic_ids' => $moveCache[0],
		]
	)->fetch_callback(
		function ($row) use (&$countPosts, &$moveCache2, &$moveTos, $moveCache) {
			$to = $moveCache[1][$row['id_topic']];

			if (empty($to))
			{
				return;
			}

			// Does this topic's board count the posts or not?
			$countPosts[$row['id_topic']] = empty($row['count_posts']);

			if (!isset($moveTos[$to]))
			{
				$moveTos[$to] = [];
			}

			$moveTos[$to][] = $row['id_topic'];

			// For reporting...
			$moveCache2[] = [$row['id_topic'], $row['id_board'], $to];
		}
	);

	// Do the actual moves...
	foreach ($moveTos as $to => $topics)
	{
		moveTopics($topics, $to, true);
	}

	// Does the post counts need to be updated?
	if (!empty($moveTos))
	{
		require_once(SUBSDIR . '/Boards.subs.php');
		$topicRecounts = [];
		$boards_info = fetchBoardsInfo(['boards' => array_keys($moveTos)], ['selects' => 'posts']);

		foreach ($boards_info as $row)
		{
			$cp = empty($row['count_posts']);

			// Go through all the topics that are being moved to this board.
			foreach ($moveTos[$row['id_board']] as $topic)
			{
				// If both boards have the same value for post counting then no adjustment needs to be made.
				if ($countPosts[$topic] != $cp)
				{
					// If the board being moved to does count the posts then the other one doesn't so add to their post count.
					$topicRecounts[$topic] = $cp ? 1 : -1;
				}
			}
		}

		if (!empty($topicRecounts))
		{
			require_once(SUBSDIR . '/Members.subs.php');

			// Get all the members who have posted in the moved topics.
			$posters = topicsPosters(array_keys($topicRecounts));
			foreach ($posters as $id_member => $topics)
			{
				$post_adj = 0;
				foreach ($topics as $id_topic)
				{
					$post_adj += $topicRecounts[$id_topic];
				}

				// And now update that member's post counts
				if (!empty($post_adj))
				{
					updateMemberData($id_member, ['posts' => 'posts + ' . $post_adj]);
				}
			}
		}
	}
}

/**
 * Moves one or more topics to a specific board.
 *
 * What it does:
 *
 * - Determines the source boards for the supplied topics
 * - Handles the moving of mark_read data
 * - Updates the posts count of the affected boards
 * - This function doesn't check permissions.
 *
 * @param int[]|int $topics
 * @param int $toBoard
 * @param bool $log if true logs the action.
 */
function moveTopics($topics, $toBoard, $log = false)
{
	global $modSettings;

	// No topics or no board?
	if (empty($topics) || empty($toBoard))
	{
		return;
	}

	$db = database();

	// Only a single topic.
	if (!is_array($topics))
	{
		$topics = [$topics];
	}

	$fromBoards = [];
	$fromCacheBoards = [];

	// Are we moving to the recycle board?
	$isRecycleDest = !empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] == $toBoard;

	// Determine the source boards...
	$request = $db->query('', '
		SELECT 
			id_topic, id_board, approved, COUNT(*) AS num_topics, SUM(unapproved_posts) AS unapproved_posts,
			SUM(num_replies) AS num_replies
		FROM {db_prefix}topics
		WHERE id_topic IN ({array_int:topics})
		GROUP BY id_topic, id_board, approved',
		[
			'topics' => $topics,
		]
	);
	// Num of rows = 0 -> no topics found. Num of rows > 1 -> topics are on multiple boards.
	if ($request->num_rows() === 0)
	{
		return;
	}

	while (($row = $request->fetch_assoc()))
	{
		$fromCacheBoards[$row['id_topic']] = $row['id_board'];
		if (!isset($fromBoards[$row['id_board']]['num_posts']))
		{
			$fromBoards[$row['id_board']] = [
				'num_posts' => 0,
				'num_topics' => 0,
				'unapproved_posts' => 0,
				'unapproved_topics' => 0,
				'id_board' => $row['id_board']
			];
		}
		// Posts = (num_replies + 1) for each approved topic.
		$fromBoards[$row['id_board']]['num_posts'] += $row['num_replies'] + ($row['approved'] ? $row['num_topics'] : 0);
		$fromBoards[$row['id_board']]['unapproved_posts'] += $row['unapproved_posts'];

		// Add the topics to the right type.
		if ($row['approved'])
		{
			$fromBoards[$row['id_board']]['num_topics'] += $row['num_topics'];
		}
		else
		{
			$fromBoards[$row['id_board']]['unapproved_topics'] += $row['num_topics'];
		}
	}
	$request->free_result();

	// Move over the mark_read data. (because it may be read and now not by some!)
	$SaveAServer = max(0, $modSettings['maxMsgID'] - 50000);
	$log_topics = [];
	$db->fetchQuery('
		SELECT
		 	lmr.id_member, lmr.id_msg, t.id_topic, COALESCE(lt.unwatched, 0) as unwatched
		FROM {db_prefix}topics AS t
			INNER JOIN {db_prefix}log_mark_read AS lmr ON (lmr.id_board = t.id_board
				AND lmr.id_msg > t.id_first_msg AND lmr.id_msg > {int:protect_lmr_msg})
			LEFT JOIN {db_prefix}log_topics AS lt ON (lt.id_topic = t.id_topic AND lt.id_member = lmr.id_member)
		WHERE t.id_topic IN ({array_int:topics})
			AND lmr.id_msg > COALESCE(lt.id_msg, 0)',
		[
			'protect_lmr_msg' => $SaveAServer,
			'topics' => $topics,
		]
	)->fetch_callback(
		function ($row) use (&$log_topics) {
			$log_topics[] = [$row['id_member'], $row['id_topic'], $row['id_msg'], $row['unwatched']];

			// Prevent queries from getting too big. Taking some steam off.
			if (count($log_topics) > 500)
			{
				markTopicsRead($log_topics, true);
				$log_topics = [];
			}
		}
	);

	// Now that we have all the topics that *should* be marked read, and by which members...
	if (!empty($log_topics))
	{
		// Insert that information into the database!
		markTopicsRead($log_topics, true);
	}

	// Update the number of posts on each board.
	$totalTopics = 0;
	$totalPosts = 0;
	$totalUnapprovedTopics = 0;
	$totalUnapprovedPosts = 0;
	foreach ($fromBoards as $stats)
	{
		$db->query('', '
			UPDATE {db_prefix}boards
			SET
				num_posts = CASE WHEN {int:num_posts} > num_posts THEN 0 ELSE num_posts - {int:num_posts} END,
				num_topics = CASE WHEN {int:num_topics} > num_topics THEN 0 ELSE num_topics - {int:num_topics} END,
				unapproved_posts = CASE WHEN {int:unapproved_posts} > unapproved_posts THEN 0 ELSE unapproved_posts - {int:unapproved_posts} END,
				unapproved_topics = CASE WHEN {int:unapproved_topics} > unapproved_topics THEN 0 ELSE unapproved_topics - {int:unapproved_topics} END
			WHERE id_board = {int:id_board}',
			[
				'id_board' => $stats['id_board'],
				'num_posts' => $stats['num_posts'],
				'num_topics' => $stats['num_topics'],
				'unapproved_posts' => $stats['unapproved_posts'],
				'unapproved_topics' => $stats['unapproved_topics'],
			]
		);
		$totalTopics += $stats['num_topics'];
		$totalPosts += $stats['num_posts'];
		$totalUnapprovedTopics += $stats['unapproved_topics'];
		$totalUnapprovedPosts += $stats['unapproved_posts'];
	}
	$db->query('', '
		UPDATE {db_prefix}boards
		SET
			num_topics = num_topics + {int:total_topics},
			num_posts = num_posts + {int:total_posts},' . ($isRecycleDest ? '
			unapproved_posts = {int:no_unapproved}, unapproved_topics = {int:no_unapproved}' : '
			unapproved_posts = unapproved_posts + {int:total_unapproved_posts},
			unapproved_topics = unapproved_topics + {int:total_unapproved_topics}') . '
		WHERE id_board = {int:id_board}',
		[
			'id_board' => $toBoard,
			'total_topics' => $totalTopics,
			'total_posts' => $totalPosts,
			'total_unapproved_topics' => $totalUnapprovedTopics,
			'total_unapproved_posts' => $totalUnapprovedPosts,
			'no_unapproved' => 0,
		]
	);

	if ($isRecycleDest)
	{
		$attributes = [
			'id_board' => $toBoard,
			'approved' => 1,
			'unapproved_posts' => 0,
		];
	}
	else
	{
		$attributes = ['id_board' => $toBoard];
	}

	// Move the topic.  Done.  :P
	setTopicAttribute($topics, $attributes);

	// If this was going to the recycle bin, check what messages are being recycled, and remove them from the queue.
	if ($isRecycleDest && ($totalUnapprovedTopics || $totalUnapprovedPosts))
	{
		$approval_msgs = [];
		$db->fetchQuery('
			SELECT 
				id_msg
			FROM {db_prefix}messages
			WHERE id_topic IN ({array_int:topics})
				and approved = {int:not_approved}',
			[
				'topics' => $topics,
				'not_approved' => 0,
			]
		)->fetch_callback(
			function ($row) use (&$approval_msgs) {
				$approval_msgs[] = $row['id_msg'];
			}
		);

		// Empty the approval queue for these, as we're going to approve them next.
		if (!empty($approval_msgs))
		{
			$db->query('', '
				DELETE FROM {db_prefix}approval_queue
				WHERE id_msg IN ({array_int:message_list})
					AND id_attach = {int:id_attach}',
				[
					'message_list' => $approval_msgs,
					'id_attach' => 0,
				]
			);
		}

		// Get all the current max and mins.
		$topicAttribute = topicAttribute($topics, ['id_topic', 'id_first_msg', 'id_last_msg']);
		$topicMaxMin = [];
		foreach ($topicAttribute as $row)
		{
			$topicMaxMin[$row['id_topic']] = [
				'min' => $row['id_first_msg'],
				'max' => $row['id_last_msg'],
			];
		}

		// Check the MAX and MIN are correct.
		$db->fetchQuery('
			SELECT 
				id_topic, MIN(id_msg) AS first_msg, MAX(id_msg) AS last_msg
			FROM {db_prefix}messages
			WHERE id_topic IN ({array_int:topics})
			GROUP BY id_topic',
			[
				'topics' => $topics,
			]
		)->fetch_callback(
			function ($row) use ($topicMaxMin) {
				// If not, update.
				if ($row['first_msg'] != $topicMaxMin[$row['id_topic']]['min'] || $row['last_msg'] != $topicMaxMin[$row['id_topic']]['max'])
				{
					setTopicAttribute($row['id_topic'], [
						'id_first_msg' => $row['first_msg'],
						'id_last_msg' => $row['last_msg'],
					]);
				}
			}
		);
	}

	$db->query('', '
		UPDATE {db_prefix}messages
		SET 
			id_board = {int:id_board}' . ($isRecycleDest ? ',approved = {int:is_approved}' : '') . '
		WHERE id_topic IN ({array_int:topics})',
		[
			'id_board' => $toBoard,
			'topics' => $topics,
			'is_approved' => 1,
		]
	);
	$db->query('', '
		UPDATE {db_prefix}log_reported
		SET 
			id_board = {int:id_board}
		WHERE id_topic IN ({array_int:topics})',
		[
			'id_board' => $toBoard,
			'topics' => $topics,
		]
	);
	$db->query('', '
		UPDATE {db_prefix}calendar
		SET 
			id_board = {int:id_board}
		WHERE id_topic IN ({array_int:topics})',
		[
			'id_board' => $toBoard,
			'topics' => $topics,
		]
	);

	// Mark target board as seen, if it was already marked as seen before.
	$request = $db->query('', '
		SELECT 
			(COALESCE(lb.id_msg, 0) >= b.id_msg_updated) AS isSeen
		FROM {db_prefix}boards AS b
			LEFT JOIN {db_prefix}log_boards AS lb ON (lb.id_board = b.id_board AND lb.id_member = {int:current_member})
		WHERE b.id_board = {int:id_board}',
		[
			'current_member' => User::$info->id,

			'id_board' => $toBoard,
		]
	);
	list ($isSeen) = $request->fetch_row();
	$request->free_result();

	if (!empty($isSeen) && User::$info->is_guest === false)

	{
		require_once(SUBSDIR . '/Boards.subs.php');
		markBoardsRead($toBoard);
	}

	// Update the cache?
	$cache = Cache::instance();
	foreach ($topics as $topic_id)
	{
		$cache->remove('topic_board-' . $topic_id);
	}

	require_once(SUBSDIR . '/Post.subs.php');

	$updates = array_keys($fromBoards);
	$updates[] = $toBoard;

	updateLastMessages(array_unique($updates));

	// Update 'em pesky stats.
	updateTopicStats();
	require_once(SUBSDIR . '/Messages.subs.php');
	updateMessageStats();
	updateSettings([
		'calendar_updated' => time(),
	]);

	if ($log)
	{
		foreach ($topics as $topic)
		{
			logAction('move', ['topic' => $topic, 'board_from' => $fromCacheBoards[$topic], 'board_to' => $toBoard]);
			sendNotifications($topic, 'move');
		}
	}
}

/**
 * Called after a topic is moved to update $board_link and $topic_link to point
 * to new location
 *
 * @param int $move_from The board the topic belongs to
 * @param int $id_board The "current" board
 * @param int $id_topic The topic id
 *
 * @return bool
 * @throws \ElkArte\Exceptions\Exception topic_already_moved
 */
function moveTopicConcurrence($move_from, $id_board, $id_topic)
{
	$db = database();

	if (empty($move_from) || empty($id_board) || empty($id_topic))
	{
		return true;
	}

	if ($move_from == $id_board)
	{
		return true;
	}

	$request = $db->query('', '
		SELECT 
			m.subject, b.name
		FROM {db_prefix}topics AS t
			LEFT JOIN {db_prefix}boards AS b ON (t.id_board = b.id_board)
			LEFT JOIN {db_prefix}messages AS m ON (t.id_first_msg = m.id_msg)
		WHERE t.id_topic = {int:topic_id}
		LIMIT 1',
		[
			'topic_id' => $id_topic,
		]
	);
	list ($topic_subject, $board_name) = $request->fetch_row();
	$request->free_result();

	$board_link = '<a href="' . getUrl('board', ['board' => $id_board, 'start' => '0', 'name' => $board_name]) . '">' . $board_name . '</a>';
	$topic_link = '<a href="' . getUrl('topic', ['topic' => $id_topic, 'start' => '0', 'subject' => $topic_subject]) . '">' . $topic_subject . '</a>';
	throw new \ElkArte\Exceptions\Exception('topic_already_moved', false, [$topic_link, $board_link]);
}

/**
 * Determine if the topic has already been deleted by another user.
 *
 * What it does:
 *  - If the topic has been removed and resides in the recycle bin, present confirm dialog
 *  - If recycling is not enabled, or user confirms or topic is not in recycle simply returns
 *
 * @throws \ElkArte\Exceptions\Exception post_already_deleted
 */
function removeDeleteConcurrence()
{
	global $modSettings, $board, $context;

	$recycled_enabled = !empty($modSettings['recycle_enable']) && !empty($modSettings['recycle_board']);

	// Trying to remove from the recycle bin
	if ($recycled_enabled && !empty($board) && !isset($_GET['confirm_delete']) && $modSettings['recycle_board'] == $board)
	{
		if (isset($_REQUEST['msg']))
		{
			$confirm_url = getUrl('action', ['action' => 'deletemsg', 'confirm_delete', 'topic' => $context['current_topic'] . '.0', 'msg' => $_REQUEST['msg'], '{session_data}']);
		}
		else
		{
			$confirm_url = getUrl('action', ['action' => 'removetopic2', 'confirm_delete', 'topic' => $context['current_topic'] . '.0', '{session_data}']);
		}

		// Give them a prompt before we remove the message
		throw new \ElkArte\Exceptions\Exception('post_already_deleted', false, [$confirm_url]);
	}
}

/**
 * Increase the number of views of this topic.
 *
 * @param int $id_topic the topic being viewed or whatnot.
 */
function increaseViewCounter($id_topic)
{
	$db = database();

	$db->query('', '
		UPDATE {db_prefix}topics
		SET 
			num_views = num_views + 1
		WHERE id_topic = {int:current_topic}',
		[
			'current_topic' => $id_topic,
		]
	);
}

/**
 * Mark topic(s) as read by the given member, at the specified message.
 *
 * @param array $mark_topics array($id_member, $id_topic, $id_msg)
 * @param bool $was_set = false - whether the topic has been previously read by the user
 */
function markTopicsRead($mark_topics, $was_set = false)
{
	$db = database();

	if (!is_array($mark_topics))

	{
		return;
	}

	$db->insert($was_set ? 'replace' : 'ignore',
		'{db_prefix}log_topics',
		[
			'id_member' => 'int', 'id_topic' => 'int', 'id_msg' => 'int', 'unwatched' => 'int',
		],
		$mark_topics,
		['id_member', 'id_topic']
	);
}

/**
 * Update user notifications for a topic... or the board it's in.
 *
 * @param int $id_topic
 * @param int $id_board
 * @todo look at board notification...
 *
 */
function updateReadNotificationsFor($id_topic, $id_board)
{
	global $context;

	$db = database();

	// Check for notifications on this topic OR board.
	$request = $db->query('', '
		SELECT 
			sent, id_topic
		FROM {db_prefix}log_notify
		WHERE (id_topic = {int:current_topic} OR id_board = {int:current_board})
			AND id_member = {int:current_member}
		LIMIT 2',
		[
			'current_board' => $id_board,
			'current_member' => User::$info->id,

			'current_topic' => $id_topic,
		]
	);
	while (($row = $request->fetch_assoc()))
	{
		// Find if this topic is marked for notification...
		if (!empty($row['id_topic']))
		{
			$context['is_marked_notify'] = true;
		}

		// Only do this once, but mark the notifications as "not sent yet" for next time.
		if (!empty($row['sent']))
		{
			$db->query('', '
				UPDATE {db_prefix}log_notify
				SET 
					sent = {int:is_not_sent}
				WHERE (id_topic = {int:current_topic} OR id_board = {int:current_board})
					AND id_member = {int:current_member}',
				[
					'current_board' => $id_board,
					'current_member' => User::$info->id,
					'current_topic' => $id_topic,
					'is_not_sent' => 0,
				]
			);

			break;
		}
	}
	$request->free_result();
}

/**
 * How many topics are still unread since (last visit)
 *
 * @param int $id_board
 * @param int $id_msg_last_visit
 * @return int
 */
function getUnreadCountSince($id_board, $id_msg_last_visit)
{
	$db = database();

	$request = $db->query('', '
		SELECT 
			COUNT(*)
		FROM {db_prefix}topics AS t
			LEFT JOIN {db_prefix}log_boards AS lb ON (lb.id_board = {int:current_board} AND lb.id_member = {int:current_member})
			LEFT JOIN {db_prefix}log_topics AS lt ON (lt.id_topic = t.id_topic AND lt.id_member = {int:current_member})
		WHERE t.id_board = {int:current_board}
			AND t.id_last_msg > COALESCE(lb.id_msg, 0)
			AND t.id_last_msg > COALESCE(lt.id_msg, 0)' .
		(empty($id_msg_last_visit) ? '' : '
			AND t.id_last_msg > {int:id_msg_last_visit}'),
		[
			'current_board' => $id_board,
			'current_member' => User::$info->id,

			'id_msg_last_visit' => (int) $id_msg_last_visit,
		]
	);
	list ($unread) = $request->fetch_row();
	$request->free_result();

	return $unread;
}

/**
 * Returns whether this member has notification turned on for the specified topic.
 *
 * @param int $id_member
 * @param int $id_topic
 * @return bool
 */
function hasTopicNotification($id_member, $id_topic)
{
	$db = database();

	// Find out if they have notification set for this topic already.
	return $db->fetchQuery('
		SELECT 
			id_member
		FROM {db_prefix}log_notify
		WHERE id_member = {int:current_member}
			AND id_topic = {int:current_topic}
		LIMIT 1',
		[
			'current_member' => $id_member,
			'current_topic' => $id_topic,
		]
	)->num_rows() != 0;
}

/**
 * Set topic notification on or off for the given member.
 *
 * @param int $id_member
 * @param int $id_topic
 * @param bool $on
 */
function setTopicNotification($id_member, $id_topic, $on = false)
{
	$db = database();

	if ($on)
	{
		// Attempt to turn notifications on.
		$db->insert('ignore',
			'{db_prefix}log_notify',
			['id_member' => 'int', 'id_topic' => 'int'],
			[$id_member, $id_topic],
			['id_member', 'id_topic']
		);
	}
	else
	{
		// Just turn notifications off.
		$db->query('', '
			DELETE FROM {db_prefix}log_notify
			WHERE id_member = {int:current_member}
				AND id_topic = {int:current_topic}',
			[
				'current_member' => $id_member,
				'current_topic' => $id_topic,
			]
		);
	}
}

/**
 * Get the previous topic from where we are.
 *
 * @param int $id_topic origin topic id
 * @param int $id_board board id
 * @param int $id_member = 0 member id
 * @param bool $includeUnapproved = false whether to include unapproved topics
 * @param bool $includeStickies = true whether to include sticky topics
 * @return int topic number
 */
function previousTopic($id_topic, $id_board, $id_member = 0, $includeUnapproved = false, $includeStickies = true)
{
	return topicPointer($id_topic, $id_board, false, $id_member, $includeUnapproved, $includeStickies);
}

/**
 * Get the next topic from where we are.
 *
 * @param int $id_topic origin topic id
 * @param int $id_board board id
 * @param int $id_member = 0 member id
 * @param bool $includeUnapproved = false whether to include unapproved topics
 * @param bool $includeStickies = true whether to include sticky topics
 * @return int topic number
 */
function nextTopic($id_topic, $id_board, $id_member = 0, $includeUnapproved = false, $includeStickies = true)
{
	return topicPointer($id_topic, $id_board, true, $id_member, $includeUnapproved, $includeStickies);
}

/**
 * Advance topic pointer.
 * (in either direction)
 * This function is used by previousTopic() and nextTopic()
 * The boolean parameter $next determines direction.
 *
 * @param int $id_topic origin topic id
 * @param int $id_board board id
 * @param bool $next = true whether to increase or decrease the pointer
 * @param int $id_member = 0 member id
 * @param bool $includeUnapproved = false whether to include unapproved topics
 * @param bool $includeStickies = true whether to include sticky topics
 * @return int the topic number
 */
function topicPointer($id_topic, $id_board, $next = true, $id_member = 0, $includeUnapproved = false, $includeStickies = true)
{
	$db = database();

	$request = $db->query('', '
		SELECT 
			t2.id_topic
		FROM {db_prefix}topics AS t
		INNER JOIN {db_prefix}topics AS t2 ON (' .
		(empty($includeStickies) ? '
				t2.id_last_msg {raw:strictly} t.id_last_msg' : '
				(t2.id_last_msg {raw:strictly} t.id_last_msg AND t2.is_sticky {raw:strictly_equal} t.is_sticky) OR t2.is_sticky {raw:strictly} t.is_sticky')
		. ')
		WHERE t.id_topic = {int:current_topic}
			AND t2.id_board = {int:current_board}' .
		($includeUnapproved ? '' : '
				AND (t2.approved = {int:is_approved} OR (t2.id_member_started != {int:id_member_started} AND t2.id_member_started = {int:current_member}))'
		) . '
		ORDER BY' . (
		$includeStickies ? '
				t2.is_sticky {raw:sorting},' :
			'') .
		' t2.id_last_msg {raw:sorting}
		LIMIT 1',
		[
			'strictly' => $next ? '<' : '>',
			'strictly_equal' => $next ? '<=' : '>=',
			'sorting' => $next ? 'DESC' : '',
			'current_board' => $id_board,
			'current_member' => $id_member,
			'current_topic' => $id_topic,
			'is_approved' => 1,
			'id_member_started' => 0,
		]
	);

	// Was there any?
	if ($request->num_rows() === 0)
	{
		$request->free_result();

		// Roll over - if we're going prev, get the last - otherwise the first.
		$request = $db->query('', '
			SELECT 
				id_topic
			FROM {db_prefix}topics
			WHERE id_board = {int:current_board}' .
			($includeUnapproved ? '' : '
				AND (approved = {int:is_approved} OR (id_member_started != {int:id_member_started} AND id_member_started = {int:current_member}))') . '
			ORDER BY' . (
			$includeStickies ? ' is_sticky {raw:sorting},' : '') .
			' id_last_msg {raw:sorting}
			LIMIT 1',
			[
				'sorting' => $next ? 'DESC' : '',
				'current_board' => $id_board,
				'current_member' => $id_member,
				'is_approved' => 1,
				'id_member_started' => 0,
			]
		);
	}
	// Now you can be sure $topic is the id_topic to view.
	list ($topic) = $request->fetch_row();
	$request->free_result();

	return $topic;
}

/**
 * Set off/on unread reply subscription for a topic
 *
 * @param int $id_member
 * @param int $topic
 * @param bool $on = false
 */
function setTopicWatch($id_member, $topic, $on = false)
{
	$db = database();

	// find the current entry if it exists that is
	$was_set = getLoggedTopics(User::$info->id, [$topic]);


	// Set topic unwatched on/off for this topic.
	$db->insert(empty($was_set[$topic]) ? 'ignore' : 'replace',
		'{db_prefix}log_topics',
		['id_member' => 'int', 'id_topic' => 'int', 'id_msg' => 'int', 'unwatched' => 'int'],
		[$id_member, $topic, !empty($was_set[$topic]['id_msg']) ? $was_set[$topic]['id_msg'] : 0, $on ? 1 : 0],
		['id_member', 'id_topic']
	);
}

/**
 * Get all the details for a given topic
 * - returns the basic topic information when $full is false
 * - returns topic details, subject, last message read, etc when full is true
 * - uses any integration information (value selects, tables and parameters) if passed and full is true
 *
 * @param array|int $topic_parameters can also accept a int value for a topic
 * @param string $full defines the values returned by the function:
 *    - if empty returns only the data from {db_prefix}topics
 *    - if 'message' returns also information about the message (subject, body, etc.)
 *    - if 'starter' returns also information about the topic starter (id_member and poster_name)
 *    - if 'all' returns additional infos about the read/unwatched status
 * @param string[] $selects (optional from integration)
 * @param string[] $tables (optional from integration)
 * @return array|bool to topic attributes
 */
function getTopicInfo($topic_parameters, $full = '', $selects = [], $tables = [])
{
	global $modSettings, $board;

	$db = database();

	// Nothing to do
	if (empty($topic_parameters))
	{
		return false;
	}

	// Build what we can with what we were given
	if (!is_array($topic_parameters))
	{
		$topic_parameters = [
			'topic' => $topic_parameters,
			'member' => User::$info->id,

			'board' => (int) $board,
		];
	}

	$messages_table = $full === 'message' || $full === 'all' || $full === 'starter';
	$members_table = $full === 'starter' || $full === 'all';
	$logs_table = $full === 'all';

	// Create the query, taking full and integration in to account
	$request = $db->fetchQuery('
		SELECT
			t.id_topic, t.is_sticky, t.id_board, t.id_first_msg, t.id_last_msg,
			t.id_member_started, t.id_member_updated, t.id_poll,
			t.num_replies, t.num_views, t.num_likes, t.locked, t.redirect_expires,
			t.id_redirect_topic, t.unapproved_posts, t.approved' . ($messages_table ? ',
			ms.subject, ms.body, ms.id_member, ms.poster_time, ms.approved as msg_approved' : '') . ($members_table ? ',
			COALESCE(mem.real_name, ms.poster_name) AS poster_name' : '') . ($logs_table ? ',
			' . (User::$info->is_guest ? 't.id_last_msg + 1' : 'COALESCE(lt.id_msg, lmr.id_msg, -1) + 1') . ' AS new_from

			' . (!empty($modSettings['recycle_board']) && $modSettings['recycle_board'] == $board ? ', t.id_previous_board, t.id_previous_topic' : '') . '
			' . (User::$info->is_guest === false ? ', COALESCE(lt.unwatched, 0) as unwatched' : '') : '') .
		(!empty($selects) ? ', ' . implode(', ', $selects) : '') . '
		FROM {db_prefix}topics AS t' . ($messages_table ? '
			INNER JOIN {db_prefix}messages AS ms ON (ms.id_msg = t.id_first_msg)' : '') . ($members_table ? '
			LEFT JOIN {db_prefix}members as mem ON (mem.id_member = ms.id_member)' : '') . ($logs_table && User::$info->is_guest === false ? '
			LEFT JOIN {db_prefix}log_topics AS lt ON (lt.id_topic = {int:topic} AND lt.id_member = {int:member})
			LEFT JOIN {db_prefix}log_mark_read AS lmr ON (lmr.id_board = {int:board} AND lmr.id_member = {int:member})' : '') . (!empty($tables) ? '
			' . implode("\n\t\t\t", $tables) : '') . '
		WHERE t.id_topic = {int:topic}
		LIMIT 1',
		$topic_parameters
	);
	$topic_info = [];
	if ($request !== false)

	{
		$topic_info = $request->fetch_assoc();
	}
	$request->free_result();

	return $topic_info;
}

/**
 * Get all the details for a given topic and message.
 * Respects permissions and post moderation
 *
 * @param int $topic id of a topic
 * @param int|null $msg the id of a message, if empty, t.id_first_msg is used
 * @return array|bool to topic attributes
 */
function getTopicInfoByMsg($topic, $msg = null)
{
	global $modSettings;

	// Nothing to do
	if (empty($topic))
	{
		return false;
	}

	$db = database();

	$request = $db->query('', '
		SELECT
			t.locked, t.num_replies, t.id_member_started, t.id_first_msg,
			m.id_msg, m.id_member, m.poster_time, m.subject, m.smileys_enabled, m.body, m.icon,
			m.modified_time, m.modified_name, m.approved
		FROM {db_prefix}messages AS m
			INNER JOIN {db_prefix}topics AS t ON (t.id_topic = {int:current_topic})
		WHERE m.id_msg = {raw:id_msg}
			AND m.id_topic = {int:current_topic}' . (allowedTo('modify_any') || allowedTo('approve_posts') ? '' : (!$modSettings['postmod_active'] ? '
			AND (m.id_member != {int:guest_id} AND m.id_member = {int:current_member})' : '
			AND (m.approved = {int:is_approved} OR (m.id_member != {int:guest_id} AND m.id_member = {int:current_member}))')),
		[
			'current_member' => User::$info->id,

			'current_topic' => $topic,
			'id_msg' => empty($msg) ? 't.id_first_msg' : $msg,
			'is_approved' => 1,
			'guest_id' => 0,
		]
	);
	$topic_info = [];
	if ($request !== false)

	{
		$topic_info = $request->fetch_assoc();
	}
	$request->free_result();

	return $topic_info;
}

/**
 * So long as you are sure... all old posts will be gone.
 * Used in Maintenance.controller.php to prune old topics.
 *
 * @param int[] $boards
 * @param string $delete_type
 * @param bool $exclude_stickies
 * @param int $older_than
 */
function removeOldTopics(array $boards, $delete_type, $exclude_stickies, $older_than)
{
	$db = database();

	// Custom conditions.
	$condition = '';
	$condition_params = [
		'boards' => $boards,
		'poster_time' => $older_than,
	];

	// Just moved notice topics?
	if ($delete_type == 'moved')
	{
		$condition .= '
			AND m.icon = {string:icon}
			AND t.locked = {int:locked}';
		$condition_params['icon'] = 'moved';
		$condition_params['locked'] = 1;
	}
	// Otherwise, maybe locked topics only?
	elseif ($delete_type == 'locked')
	{
		$condition .= '
			AND t.locked = {int:locked}';
		$condition_params['locked'] = 1;
	}

	// Exclude stickies?
	if ($exclude_stickies)
	{
		$condition .= '
			AND t.is_sticky = {int:is_sticky}';
		$condition_params['is_sticky'] = 0;
	}

	// All we're gonna do here is grab the id_topic's and send them to removeTopics().
	$topics = [];
	$db->fetchQuery('
		SELECT 
			t.id_topic
		FROM {db_prefix}topics AS t
			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_last_msg)
		WHERE
			m.poster_time < {int:poster_time}' . $condition . '
			AND t.id_board IN ({array_int:boards})',
		$condition_params
	)->fetch_callback(
		function ($row) use (&$topics) {
			$topics[] = $row['id_topic'];
		}
	);

	removeTopics($topics, false, true);
}

/**
 * Retrieve all topics started by the given member.
 *
 * @param int $memberID
 *
 * @return array
 */
function topicsStartedBy($memberID)
{
	$db = database();

	// Fetch all topics started by this user.
	$topicIDs = [];
	$db->fetchQuery('
		SELECT 
			t.id_topic
		FROM {db_prefix}topics AS t
		WHERE t.id_member_started = {int:selected_member}',
		[
			'selected_member' => $memberID,
		]
	)->fetch_callback(
		function ($row) use (&$topicIDs) {
			$topicIDs[] = $row['id_topic'];
		}
	);

	return $topicIDs;
}

/**
 * Retrieve the messages of the given topic, that are at or after
 * a message.
 * Used by split topics actions.
 *
 * @param int $id_topic
 * @param int $id_msg
 * @param bool $include_current = false
 * @param bool $only_approved = false
 *
 * @return array message ids
 */
function messagesSince($id_topic, $id_msg, $include_current = false, $only_approved = false)
{
	$db = database();

	// Fetch the message IDs of the topic that are at or after the message.
	$messages = [];
	$db->fetchQuery('
		SELECT 
			id_msg
		FROM {db_prefix}messages
		WHERE id_topic = {int:current_topic}
			AND id_msg ' . ($include_current ? '>=' : '>') . ' {int:last_msg}' . ($only_approved ? '
			AND approved = {int:approved}' : ''),
		[
			'current_topic' => $id_topic,
			'last_msg' => $id_msg,
			'approved' => 1,
		]
	)->fetch_callback(
		function ($row) use (&$messages) {
			$messages[] = $row['id_msg'];
		}
	);

	return $messages;
}

/**
 * This function returns the number of messages in a topic,
 * posted after $id_msg.
 *
 * @param int $id_topic
 * @param int $id_msg
 * @param bool $include_current = false
 * @param bool $only_approved = false
 *
 * @return int
 */
function countMessagesSince($id_topic, $id_msg, $include_current = false, $only_approved = false)
{
	$db = database();

	// Give us something to work with
	if (empty($id_topic) || empty($id_msg))
	{
		return false;

	}

	$request = $db->query('', '
		SELECT 
			COUNT(*)
		FROM {db_prefix}messages
		WHERE id_topic = {int:current_topic}
			AND id_msg ' . ($include_current ? '>=' : '>') . ' {int:last_msg}' . ($only_approved ? '
			AND approved = {int:approved}' : '') . '
		LIMIT 1',
		[
			'current_topic' => $id_topic,
			'last_msg' => $id_msg,
			'approved' => 1,
		]
	);
	list ($count) = $request->fetch_row();
	$request->free_result();

	return $count;
}

/**
 * Returns how many messages are in a topic before the specified message id.
 * Used in display to compute the start value for a specific message.
 *
 * @param int $id_topic
 * @param int $id_msg
 * @param bool $include_current = false
 * @param bool $only_approved = false
 * @param bool $include_own = false
 * @return int
 */
function countMessagesBefore($id_topic, $id_msg, $include_current = false, $only_approved = false, $include_own = false)
{
	$db = database();

	$request = $db->query('', '
		SELECT 
			COUNT(*)
		FROM {db_prefix}messages
		WHERE id_msg ' . ($include_current ? '<=' : '<') . ' {int:id_msg}
			AND id_topic = {int:current_topic}' . ($only_approved ? '
			AND (approved = {int:is_approved}' . ($include_own ? '
			OR id_member = {int:current_member}' : '') . ')' : ''),
		[
			'current_member' => User::$info->id,

			'current_topic' => $id_topic,
			'id_msg' => $id_msg,
			'is_approved' => 1,
		]
	);
	list ($count) = $request->fetch_row();
	$request->free_result();

	return $count;
}

/**
 * Select a part of the messages in a topic.
 *
 * @param int $topic
 * @param int $start The item to start with (for pagination purposes)
 * @param int $items_per_page The number of items to show per page
 * @param array $messages
 * @param bool $only_approved
 *
 * @return array
 */
function selectMessages($topic, $start, $items_per_page, $messages = [], $only_approved = false)
{
	$db = database();

	$returnMessages = [];
	$parser = ParserWrapper::instance();

	// Get the messages and stick them into an array.
	$db->fetchQuery('
		SELECT 
			m.subject, COALESCE(mem.real_name, m.poster_name) AS real_name, 
			m.poster_time, m.body, m.id_msg, m.smileys_enabled, m.id_member
		FROM (
			SELECT 
				m.id_msg 
			FROM {db_prefix}messages AS m
			WHERE m.id_topic = {int:current_topic}' . (empty($messages['before']) ? '' : '
				AND m.id_msg < {int:msg_before}') . (empty($messages['after']) ? '' : '
				AND m.id_msg > {int:msg_after}') . (empty($messages['excluded']) ? '' : '
				AND m.id_msg NOT IN ({array_int:no_split_msgs})') . (empty($messages['included']) ? '' : '
				AND m.id_msg IN ({array_int:split_msgs})') . (!$only_approved ? '' : '
				AND approved = {int:is_approved}') . '
			ORDER BY m.id_msg DESC
			LIMIT {int:start}, {int:messages_per_page}
		) AS o 
		JOIN {db_prefix}messages as m ON o.id_msg=m.id_msg 
		LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
		ORDER BY m.id_msg DESC',
		[
			'current_topic' => $topic,
			'no_split_msgs' => !empty($messages['excluded']) ? $messages['excluded'] : [],
			'split_msgs' => !empty($messages['included']) ? $messages['included'] : [],
			'is_approved' => 1,
			'start' => $start,
			'messages_per_page' => $items_per_page,
			'msg_before' => !empty($messages['before']) ? (int) $messages['before'] : 0,
			'msg_after' => !empty($messages['after']) ? (int) $messages['after'] : 0,
		]
	)->fetch_callback(
		function ($row) use (&$returnMessages, $parser) {
			$row['subject'] = censor($row['subject']);
			$row['body'] = censor($row['body']);

			$row['body'] = $parser->parseMessage($row['body'], (bool) $row['smileys_enabled']);

			$returnMessages[$row['id_msg']] = [
				'id' => $row['id_msg'],
				'subject' => $row['subject'],
				'time' => standardTime($row['poster_time']),
				'html_time' => htmlTime($row['poster_time']),
				'timestamp' => forum_time(true, $row['poster_time']),
				'body' => $row['body'],
				'poster' => $row['real_name'],
				'id_poster' => $row['id_member'],
			];
		}
	);

	return $returnMessages;
}

/**
 * Loads all the messages of a topic
 * Used when printing or other functions that require a topic listing
 *
 * @param int $topic
 * @param string $render defaults to print style rendering for parse_bbc
 *
 * @return array
 */
function topicMessages($topic, $render = 'print')
{
	global $modSettings;

	$db = database();

	$posts = [];
	$parser = ParserWrapper::instance();
	if ($render === 'print')
	{
		$parser->getCodes()->setForPrinting();
	}

	$db->fetchQuery('
		SELECT 
			subject, poster_time, body, COALESCE(mem.real_name, poster_name) AS poster_name, id_msg
		FROM {db_prefix}messages AS m
			LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
		WHERE m.id_topic = {int:current_topic}' . ($modSettings['postmod_active'] && !allowedTo('approve_posts') ? '
			AND (m.approved = {int:is_approved}' . (User::$info->is_guest ? '' : ' OR m.id_member = {int:current_member}') . ')' : '') . '

		ORDER BY m.id_msg',
		[
			'current_topic' => $topic,
			'is_approved' => 1,
			'current_member' => User::$info->id,

		]
	)->fetch_callback(
		function ($row) use (&$posts, $parser, $render) {
			// Censor the subject and message.
			$row['subject'] = censor($row['subject']);
			$row['body'] = censor($row['body']);

			$posts[$row['id_msg']] = [
				'subject' => $row['subject'],
				'member' => $row['poster_name'],
				'time' => standardTime($row['poster_time'], false),
				'html_time' => htmlTime($row['poster_time']),
				'timestamp' => forum_time(true, $row['poster_time']),
				'body' => $parser->parseMessage($row['body'], $render !== 'print'),
				'id_msg' => $row['id_msg'],
			];
		}
	);

	return $posts;
}

/**
 * Load message image attachments for use in the print page function
 * Returns array of file attachment name along with width/height properties
 * Will only return approved attachments
 *
 * @param int[] $id_messages
 *
 * @return array
 */
function messagesAttachments($id_messages)
{
	global $modSettings;

	require_once(SUBSDIR . '/Attachments.subs.php');

	$db = database();

	$temp = [];
	$printattach = [];
	$db->fetchQuery('
		SELECT
			a.id_attach, a.id_msg, a.approved, a.width, a.height, a.file_hash, a.filename, a.id_folder, a.mime_type
		FROM {db_prefix}attachments AS a
		WHERE a.id_msg IN ({array_int:message_list})
			AND a.attachment_type = {int:attachment_type}',
		[
			'message_list' => $id_messages,
			'attachment_type' => 0,
			'is_approved' => 1,
		]
	)->fetch_callback(
		function ($row) use (&$temp, &$printattach) {
			$temp[$row['id_attach']] = $row;
			if (!isset($printattach[$row['id_msg']]))
			{
				$printattach[$row['id_msg']] = [];
			}
		}
	);

	ksort($temp);

	// Load them into $context so the template can use them
	foreach ($temp as $row)
	{
		if (!empty($row['width']) && !empty($row['height']))
		{
			if (!empty($modSettings['max_image_width']) && (empty($modSettings['max_image_height']) || $row['height'] * ($modSettings['max_image_width'] / $row['width']) <= $modSettings['max_image_height']))
			{
				if ($row['width'] > $modSettings['max_image_width'])
				{
					$row['height'] = floor($row['height'] * ($modSettings['max_image_width'] / $row['width']));
					$row['width'] = $modSettings['max_image_width'];
				}
			}
			elseif (!empty($modSettings['max_image_width']))
			{
				if ($row['height'] > $modSettings['max_image_height'])
				{
					$row['width'] = floor($row['width'] * $modSettings['max_image_height'] / $row['height']);
					$row['height'] = $modSettings['max_image_height'];
				}
			}

			$row['filename'] = getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'], false, $row['file_hash']);

			// save for the template
			$printattach[$row['id_msg']][] = $row;
		}
	}

	return $printattach;
}

/**
 * Retrieve unapproved posts of the member
 * in a specific topic
 *
 * @param int $id_topic topic id
 * @param int $id_member member id
 * @return array|int empty array if no member supplied, otherwise number of posts
 */
function unapprovedPosts($id_topic, $id_member)
{
	$db = database();

	// not all guests are the same!
	if (empty($id_member))
	{
		return [];
	}

	$request = $db->query('', '
		SELECT 
			COUNT(id_member) AS my_unapproved_posts
		FROM {db_prefix}messages
		WHERE id_topic = {int:current_topic}
			AND id_member = {int:current_member}
			AND approved = 0',
		[
			'current_topic' => $id_topic,
			'current_member' => $id_member,
		]
	);
	list ($myUnapprovedPosts) = $request->fetch_row();
	$request->free_result();

	return $myUnapprovedPosts;
}

/**
 * Update topic info after a successful split of a topic.
 *
 * @param array $options
 * @param int $id_board
 */
function updateSplitTopics($options, $id_board)
{
	$db = database();

	// Any associated reported posts better follow...
	$db->query('', '
		UPDATE {db_prefix}log_reported
		SET 
			id_topic = {int:id_topic}
		WHERE id_msg IN ({array_int:split_msgs})
			AND type = {string:a_message}',
		[
			'split_msgs' => $options['splitMessages'],
			'id_topic' => $options['split2_ID_TOPIC'],
			'a_message' => 'msg',
		]
	);

	// Mess with the old topic's first, last, and number of messages.
	setTopicAttribute($options['split1_ID_TOPIC'], [
		'num_replies' => $options['split1_replies'],
		'id_first_msg' => $options['split1_first_msg'],
		'id_last_msg' => $options['split1_last_msg'],
		'id_member_started' => $options['split1_firstMem'],
		'id_member_updated' => $options['split1_lastMem'],
		'unapproved_posts' => $options['split1_unapprovedposts'],
	]);

	// Now, put the first/last message back to what they should be.
	setTopicAttribute($options['split2_ID_TOPIC'], [
		'id_first_msg' => $options['split2_first_msg'],
		'id_last_msg' => $options['split2_last_msg'],
	]);

	// If the new topic isn't approved ensure the first message flags
	// this just in case.
	if (!$options['split2_approved'])
	{
		$db->query('', '
			UPDATE {db_prefix}messages
			SET 
				approved = {int:approved}
			WHERE id_msg = {int:id_msg}
				AND id_topic = {int:id_topic}',
			[
				'approved' => 0,
				'id_msg' => $options['split2_first_msg'],
				'id_topic' => $options['split2_ID_TOPIC'],
			]
		);
	}

	// The board has more topics now (Or more unapproved ones!).
	$db->query('', '
		UPDATE {db_prefix}boards
		SET 
			' . ($options['split2_approved']
			? ' num_topics = num_topics + 1'
			: ' unapproved_topics = unapproved_topics + 1') . '
		WHERE id_board = {int:id_board}',
		[
			'id_board' => $id_board,
		]
	);
}

/**
 * Find out who started a topic, and the lock status
 *
 * @param int $topic
 * @return array with id_member_started and locked
 */
function topicStatus($topic)
{
	// Find out who started the topic, and the lock status.
	$starter = topicAttribute($topic, ['id_member_started', 'locked']);

	return [$starter['id_member_started'], $starter['locked']];
}

/**
 * Set attributes for a topic, i.e. locked, sticky.
 * Parameter $attributes is an array where the key is the column name of the
 * attribute to change, and the value is... the new value of the attribute.
 * It sets the new value for the attribute as passed to it.
 * <b>It is currently limited to integer values only</b>
 *
 * @param int|int[] $topic
 * @param array $attributes
 * @return int number of row affected
 * @todo limited to integer attributes
 */
function setTopicAttribute($topic, $attributes)
{
	$db = database();

	$update = [];
	foreach ($attributes as $key => $attr)
	{
		$attributes[$key] = (int) $attr;
		$update[] = '
				' . $key . ' = {int:' . $key . '}';
	}

	if (empty($update))
	{
		return false;

	}

	$attributes['current_topic'] = (array) $topic;

	return $db->query('', '
		UPDATE {db_prefix}topics
		SET 
			' . implode(',', $update) . '
		WHERE id_topic IN ({array_int:current_topic})',
		$attributes
	)->affected_rows();
}

/**
 * Retrieve the locked or sticky status of a topic.
 *
 * @param int|int[] $id_topic topic to get the status for
 * @param string|string[] $attributes Basically the column names
 * @return array named array based on attributes requested
 */
function topicAttribute($id_topic, $attributes)
{
	$db = database();

	// @todo maybe add a filer for known attributes... or not
// 	$attributes = array(
// 		'locked' => 'locked',
// 		'sticky' => 'is_sticky',
// 	);

	// check the lock status
	$request = $db->query('', '
		SELECT 
			{raw:attribute}
		FROM {db_prefix}topics
		WHERE id_topic IN ({array_int:current_topic})',
		[
			'current_topic' => (array) $id_topic,
			'attribute' => implode(',', (array) $attributes),
		]
	);

	if (is_array($id_topic))
	{
		$status = [];
		while (($row = $request->fetch_assoc()))
		{
			$status[] = $row;
		}
	}
	else
	{
		$status = $request->fetch_assoc();
	}

	$request->free_result();

	return $status;
}

/**
 * Retrieve some topic attributes based on the user:
 *   - locked
 *   - notify
 *   - is_sticky
 *   - id_poll
 *   - id_last_msg
 *   - id_member of the first message in the topic
 *   - id_first_msg
 *   - subject of the first message in the topic
 *   - last_post_time that is poster_time if poster_time > modified_time, or
 *       modified_time otherwise
 *
 * @param int $id_topic topic to get the status for
 * @param int $user a user id
 * @return array
 */
function topicUserAttributes($id_topic, $user)
{
	$db = database();

	$request = $db->query('', '
		SELECT
			t.locked, COALESCE(ln.id_topic, 0) AS notify, t.is_sticky, t.id_poll,
			t.id_last_msg, mf.id_member, t.id_first_msg, mf.subject,
			CASE WHEN ml.poster_time > ml.modified_time THEN ml.poster_time ELSE ml.modified_time END AS last_post_time
		FROM {db_prefix}topics AS t
			LEFT JOIN {db_prefix}log_notify AS ln ON (ln.id_topic = t.id_topic AND ln.id_member = {int:current_member})
			LEFT JOIN {db_prefix}messages AS mf ON (mf.id_msg = t.id_first_msg)
			LEFT JOIN {db_prefix}messages AS ml ON (ml.id_msg = t.id_last_msg)
		WHERE t.id_topic = {int:current_topic}
		LIMIT 1',
		[
			'current_member' => $user,
			'current_topic' => $id_topic,
		]
	);
	$return = $request->fetch_assoc();
	$request->free_result();

	return $return;
}

/**
 * Retrieve some details about the topic
 *
 * @param int[] $topics an array of topic id
 *
 * @return array
 */
function topicsDetails($topics)
{
	return topicAttribute($topics, ['id_topic', 'id_member_started', 'id_board', 'locked', 'approved', 'unapproved_posts']);
}

/**
 * Toggle sticky status for the passed topics and logs the action.
 *
 * @param int[] $topics
 * @param bool $log If true the action is logged
 * @return int Number of topics toggled
 */
function toggleTopicSticky($topics, $log = false)
{
	$db = database();

	$topics = is_array($topics) ? $topics : [$topics];


	$toggled = $db->query('', '
		UPDATE {db_prefix}topics
		SET 
			is_sticky = CASE WHEN is_sticky = 1 THEN 0 ELSE 1 END
		WHERE id_topic IN ({array_int:sticky_topic_ids})',
		[
			'sticky_topic_ids' => $topics,
		]
	)->affected_rows();

	if ($log)
	{
		// Get the board IDs and Sticky status
		$topicAttributes = topicAttribute($topics, ['id_topic', 'id_board', 'is_sticky']);
		$stickyCacheBoards = [];
		$stickyCacheStatus = [];
		foreach ($topicAttributes as $row)
		{
			$stickyCacheBoards[$row['id_topic']] = $row['id_board'];
			$stickyCacheStatus[$row['id_topic']] = empty($row['is_sticky']);
		}

		foreach ($topics as $topic)
		{
			logAction($stickyCacheStatus[$topic] ? 'unsticky' : 'sticky', ['topic' => $topic, 'board' => $stickyCacheBoards[$topic]]);
			sendNotifications($topic, 'sticky');
		}
	}

	return $toggled;
}

/**
 * Get topics from the log_topics table belonging to a certain user
 *
 * @param int $member a member id
 * @param int[] $topics an array of topics
 * @return array an array of topics in the table (key) and its unwatched status (value)
 *
 * @todo find a better name
 */
function getLoggedTopics($member, $topics)
{
	$db = database();

	$logged_topics = [];
	$db->query('', '
		SELECT 
			id_topic, id_msg, unwatched
		FROM {db_prefix}log_topics
		WHERE id_topic IN ({array_int:selected_topics})
			AND id_member = {int:current_user}',
		[
			'selected_topics' => $topics,
			'current_user' => $member,
		]
	)->fetch_callback(
		function ($row) use (&$logged_topics) {
			$logged_topics[$row['id_topic']] = $row;
		}
	);

	return $logged_topics;
}

/**
 * Returns a list of topics ids and their subjects
 *
 * @param int[] $topic_ids
 *
 * @return array
 */
function topicsList($topic_ids)
{
	global $modSettings;

	// you have to want *something* from this function
	if (empty($topic_ids))
	{
		return [];
	}

	$db = database();

	$topics = [];

	$db->fetchQuery('
		SELECT 
			t.id_topic, m.subject
		FROM {db_prefix}topics AS t
			INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
		WHERE {query_see_board}
			AND t.id_topic IN ({array_int:topic_list})' . ($modSettings['postmod_active'] ? '
			AND t.approved = {int:is_approved}' : '') . '
		LIMIT {int:limit}',
		[
			'topic_list' => $topic_ids,
			'is_approved' => 1,
			'limit' => count($topic_ids),
		]
	)->fetch_callback(
		function ($row) use (&$topics) {
			$topics[$row['id_topic']] = [
				'id_topic' => $row['id_topic'],
				'subject' => censor($row['subject']),
			];
		}
	);

	return $topics;
}

/**
 * Get each post and poster in this topic and take care of user settings such as
 * limit or sort direction.
 *
 * @param int $topic
 * @param array $limit
 * @param bool $sort set to false for a desc sort
 * @return array
 */
function getTopicsPostsAndPoster($topic, $limit, $sort)
{
	global $modSettings;

	$db = database();

	$topic_details = [
		'messages' => [],
		'all_posters' => [],
	];

	// When evaluating potentially huge offsets, grab the ids only, first.
	// The performance impact is still significant going from three columns to one.
	$postMod = $modSettings['postmod_active'] && allowedTo('approve_posts');
	$request = $db->fetchQuery('
		SELECT 
			m.id_msg, m.id_member
		FROM (
			SELECT 
				id_msg 
			FROM {db_prefix}messages
			WHERE id_topic = {int:current_topic}' . ($postMod ? '' : '
			AND (approved = {int:is_approved}' . (User::$info->is_guest ? '' : ' OR id_member = {int:current_member}') . ')') . '

			ORDER BY id_msg ' . ($sort ? '' : 'DESC') . ($limit['messages_per_page'] == -1 ? '' : '
			LIMIT ' . $limit['start'] . ', ' . $limit['offset']) . '
		) AS o 
		JOIN {db_prefix}messages as m ON o.id_msg=m.id_msg
		ORDER BY m.id_msg ' . ($sort ? '' : 'DESC'),
		[
			'current_member' => User::$info->id,

			'current_topic' => $topic,
			'is_approved' => 1,
			'blank_id_member' => 0,
		]
	);
	while ($row = $request->fetch_assoc())
	{
		if (!empty($row['id_member']))
		{
			$topic_details['all_posters'][$row['id_msg']] = $row['id_member'];
		}

		$topic_details['messages'][] = $row['id_msg'];
	}
	$request->free_result();

	return $topic_details;
}

/**
 * Remove a batch of messages (or topics)
 *
 * @param int[] $messages
 * @param array $messageDetails
 * @param string $type = replies
 */
function removeMessages($messages, $messageDetails, $type = 'replies')
{
	global $modSettings;

	// @todo something's not right, removeMessage() does check permissions,
	// removeTopics() doesn't
	if ($type === 'topics')
	{
		removeTopics($messages);

		// and tell the world about it
		foreach ($messages as $topic)
		{
			// Note, only log topic ID in native form if it's not gone forever.
			logAction('remove', [
				(empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $messageDetails[$topic]['board'] ? 'topic' : 'old_topic_id') => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board']]);
		}
	}
	else
	{
		$remover = new MessagesDelete($modSettings['recycle_enable'], $modSettings['recycle_board']);
		foreach ($messages as $post)
		{
			$remover->removeMessage($post);
		}
	}
}

/**
 * Approve a batch of posts (or topics in their own right)
 *
 * @param int[] $messages
 * @param array $messageDetails
 * @param string $type = replies
 */
function approveMessages($messages, $messageDetails, $type = 'replies')
{
	if ($type === 'topics')
	{
		approveTopics($messages, true, true);
	}
	else
	{
		require_once(SUBSDIR . '/Post.subs.php');
		approvePosts($messages);

		// and tell the world about it again
		foreach ($messages as $post)
		{
			logAction('approve', ['topic' => $messageDetails[$post]['topic'], 'subject' => $messageDetails[$post]['subject'], 'member' => $messageDetails[$post]['member'], 'board' => $messageDetails[$post]['board']]);
		}
	}
}

/**
 * Approve topics, all we got.
 *
 * @param int[] $topics array of topics ids
 * @param bool $approve = true
 * @param bool $log if true logs the action.
 *
 * @return bool|void
 */
function approveTopics($topics, $approve = true, $log = false)
{
	if (!is_array($topics))

	{
		$topics = [$topics];
	}

	if (empty($topics))
	{
		return false;
	}

	$db = database();

	$approve_type = $approve ? 0 : 1;

	if ($log)
	{
		$log_action = $approve ? 'approve_topic' : 'unapprove_topic';

		// We need unapproved topic ids, their authors and the subjects!
		$db->fetchQuery('
			SELECT 
				t.id_topic, t.id_member_started, m.subject
			FROM {db_prefix}topics as t
				LEFT JOIN {db_prefix}messages AS m ON (t.id_first_msg = m.id_msg)
			WHERE t.id_topic IN ({array_int:approve_topic_ids})
				AND t.approved = {int:approve_type}
			LIMIT ' . count($topics),
			[
				'approve_topic_ids' => $topics,
				'approve_type' => $approve_type,
			]
		)->fetch_callback(
			function ($row) use (&$log_action) {
				global $board;

				logAction($log_action, [
					'topic' => $row['id_topic'],
					'subject' => $row['subject'],
					'member' => $row['id_member_started'],
					'board' => $board]
				);
			}
		);
	}

	// Just get the messages to be approved and pass through...
	$msgs = [];
	$db->fetchQuery('
		SELECT 
			id_msg
		FROM {db_prefix}messages
		WHERE id_topic IN ({array_int:topic_list})
			AND approved = {int:approve_type}',
		[
			'topic_list' => $topics,
			'approve_type' => $approve_type,
		]
	)->fetch_callback(
		function ($row) use (&$msgs) {
			$msgs[] = $row['id_msg'];
		}
	);

	require_once(SUBSDIR . '/Post.subs.php');

	return approvePosts($msgs, $approve);
}

/**
 * Post a message at the end of the original topic
 *
 * @param string $reason the text that will become the message body
 * @param string $subject the text that will become the message subject
 * @param array $board_info some board information (at least id, name, if posts are counted)
 * @param string $new_topic used to build the url for moving to a new topic
 */
function postSplitRedirect($reason, $subject, $board_info, $new_topic)
{
	global $language, $txt, $topic, $board;

	// Should be in the boardwide language.
	if (User::$info->language != $language)

	{
		$lang_loader = new LangLoader($language, $txt, database());
		$lang_loader->load('index');
	}

	preparsecode($reason);

	// Add a URL onto the message.
	$reason = strtr($reason, [
		$txt['movetopic_auto_board'] => '[url=' . getUrl('board', ['board' => $board_info['id'], 'start' => '0', 'name' => $board_info['name']]) . ']' . $board_info['name'] . '[/url]',
		$txt['movetopic_auto_topic'] => '[iurl]' . getUrl('topic', ['topic' => $new_topic, 'start' => '0', 'subject' => $subject]) . '[/iurl]'
	]);

	$msgOptions = [
		'subject' => $txt['split'] . ': ' . strtr(Util::htmltrim(Util::htmlspecialchars($subject)), ["\r" => '', "\n" => '', "\t" => '']),
		'body' => $reason,
		'icon' => 'moved',
		'smileys_enabled' => 1,
	];

	$topicOptions = [
		'id' => $topic,
		'board' => $board,
		'mark_as_read' => true,
	];

	$posterOptions = [
		'id' => User::$info->id,

		'update_post_count' => empty($board_info['count_posts']),
	];

	createPost($msgOptions, $topicOptions, $posterOptions);
}

/**
 * General function to split off a topic.
 * creates a new topic and moves the messages with the IDs in
 * array messagesToBeSplit to the new topic.
 * the subject of the newly created topic is set to 'newSubject'.
 * marks the newly created message as read for the user splitting it.
 * updates the statistics to reflect a newly created topic.
 * logs the action in the moderation log.
 * a notification is sent to all users monitoring this topic.
 *
 * @param int $split1_ID_TOPIC
 * @param int[] $splitMessages
 * @param string $new_subject
 *
 * @return int the topic ID of the new split topic.
 * @throws \ElkArte\Exceptions\Exception no_posts_selected, selected_all_posts, cant_find_message
 */
function splitTopic($split1_ID_TOPIC, $splitMessages, $new_subject)
{
	global $txt, $modSettings;

	$db = database();

	// Nothing to split?
	if (empty($splitMessages))
	{
		throw new \ElkArte\Exceptions\Exception('no_posts_selected', false);
	}

	// Get some board info.
	$topicAttribute = topicAttribute($split1_ID_TOPIC, ['id_board', 'approved']);
	$id_board = $topicAttribute['id_board'];
	$split1_approved = $topicAttribute['approved'];

	// Find the new first and last not in the list. (old topic)
	$request = $db->query('', '
		SELECT
			MIN(m.id_msg) AS myid_first_msg, MAX(m.id_msg) AS myid_last_msg, COUNT(*) AS message_count, m.approved
		FROM {db_prefix}messages AS m
			INNER JOIN {db_prefix}topics AS t ON (t.id_topic = {int:id_topic})
		WHERE m.id_msg NOT IN ({array_int:no_msg_list})
			AND m.id_topic = {int:id_topic}
		GROUP BY m.approved
		ORDER BY m.approved DESC
		LIMIT 2',
		[
			'id_topic' => $split1_ID_TOPIC,
			'no_msg_list' => $splitMessages,
		]
	);
	// You can't select ALL the messages!
	if ($request->num_rows() === 0)
	{
		throw new \ElkArte\Exceptions\Exception('selected_all_posts', false);
	}

	$split1_first_msg = null;
	$split1_last_msg = null;

	while (($row = $request->fetch_assoc()))
	{
		// Get the right first and last message dependant on approved state...
		if (empty($split1_first_msg) || $row['myid_first_msg'] < $split1_first_msg)
		{
			$split1_first_msg = $row['myid_first_msg'];
		}

		if (empty($split1_last_msg) || $row['approved'])
		{
			$split1_last_msg = $row['myid_last_msg'];
		}

		// Get the counts correct...
		if ($row['approved'])
		{
			$split1_replies = $row['message_count'] - 1;
			$split1_unapprovedposts = 0;
		}
		else
		{
			if (!isset($split1_replies))
			{
				$split1_replies = 0;
			}
			// If the topic isn't approved then num replies must go up by one... as first post wouldn't be counted.
			elseif (!$split1_approved)
			{
				$split1_replies++;
			}

			$split1_unapprovedposts = $row['message_count'];
		}
	}
	$request->free_result();
	$split1_firstMem = getMsgMemberID($split1_first_msg);
	$split1_lastMem = getMsgMemberID($split1_last_msg);

	// Find the first and last in the list. (new topic)
	$request = $db->query('', '
		SELECT 
			MIN(id_msg) AS myid_first_msg, MAX(id_msg) AS myid_last_msg, COUNT(*) AS message_count, approved
		FROM {db_prefix}messages
		WHERE id_msg IN ({array_int:msg_list})
			AND id_topic = {int:id_topic}
		GROUP BY id_topic, approved
		ORDER BY approved DESC
		LIMIT 2',
		[
			'msg_list' => $splitMessages,
			'id_topic' => $split1_ID_TOPIC,
		]
	);
	while (($row = $request->fetch_assoc()))
	{
		// As before get the right first and last message dependant on approved state...
		if (empty($split2_first_msg) || $row['myid_first_msg'] < $split2_first_msg)
		{
			$split2_first_msg = $row['myid_first_msg'];
		}

		if (empty($split2_last_msg) || $row['approved'])
		{
			$split2_last_msg = $row['myid_last_msg'];
		}

		// Then do the counts again...
		if ($row['approved'])
		{
			$split2_approved = true;
			$split2_replies = $row['message_count'] - 1;
			$split2_unapprovedposts = 0;
		}
		else
		{
			// Should this one be approved??
			if ($split2_first_msg == $row['myid_first_msg'])
			{
				$split2_approved = false;
			}

			if (!isset($split2_replies))
			{
				$split2_replies = 0;
			}
			// As before, fix number of replies.
			elseif (!$split2_approved)

			{
				$split2_replies++;
			}

			$split2_unapprovedposts = $row['message_count'];
		}
	}
	$request->free_result();
	$split2_firstMem = getMsgMemberID($split2_first_msg);

	$split2_lastMem = getMsgMemberID($split2_last_msg);


	// No database changes yet, so let's double check to see if everything makes at least a little sense.
	if (!isset($split1_approved, $split2_approved) || $split1_first_msg <= 0 || $split1_last_msg <= 0 || $split2_first_msg <= 0 || $split2_last_msg <= 0 || $split1_replies < 0 || $split2_replies < 0 || $split1_unapprovedposts < 0 || $split2_unapprovedposts < 0)

	{
		throw new \ElkArte\Exceptions\Exception('cant_find_messages');
	}

	// You cannot split off the first message of a topic.
	if ($split1_first_msg > $split2_first_msg)
	{
		throw new \ElkArte\Exceptions\Exception('split_first_post', false);
	}

	// The message that is starting the new topic may have likes, these become topic likes
	require_once(SUBSDIR . '/Likes.subs.php');
	$split2_first_msg_likes = messageLikeCount($split2_first_msg);

	// We're off to insert the new topic!  Use 0 for now to avoid UNIQUE errors.
	$db->insert('',
		'{db_prefix}topics',
		[
			'id_board' => 'int',
			'id_member_started' => 'int',
			'id_member_updated' => 'int',
			'id_first_msg' => 'int',
			'id_last_msg' => 'int',
			'num_replies' => 'int',
			'unapproved_posts' => 'int',
			'approved' => 'int',
			'is_sticky' => 'int',
			'num_likes' => 'int',
		],
		[
			(int) $id_board, $split2_firstMem, $split2_lastMem, 0,
			0, $split2_replies, $split2_unapprovedposts, (int) $split2_approved, 0, $split2_first_msg_likes,
		],
		['id_topic']
	);
	$split2_ID_TOPIC = $db->insert_id('{db_prefix}topics');
	if ($split2_ID_TOPIC <= 0)
	{
		throw new \ElkArte\Exceptions\Exception('cant_insert_topic');
	}

	// Move the messages over to the other topic.
	$new_subject = strtr(Util::htmltrim(Util::htmlspecialchars($new_subject)), ["\r" => '', "\n" => '', "\t" => '']);

	// Check the subject length.
	if (Util::strlen($new_subject) > 100)
	{
		$new_subject = Util::substr($new_subject, 0, 100);
	}

	// Valid subject?
	if ($new_subject != '')
	{
		$db->query('', '
			UPDATE {db_prefix}messages
			SET
				id_topic = {int:id_topic},
				subject = CASE WHEN id_msg = {int:split_first_msg} THEN {string:new_subject} ELSE {string:new_subject_replies} END
			WHERE id_msg IN ({array_int:split_msgs})',
			[
				'split_msgs' => $splitMessages,
				'id_topic' => $split2_ID_TOPIC,
				'new_subject' => $new_subject,
				'split_first_msg' => $split2_first_msg,
				'new_subject_replies' => $txt['response_prefix'] . $new_subject,
			]
		);

		// Cache the new topics subject... we can do it now as all the subjects are the same!
		require_once(SUBSDIR . '/Messages.subs.php');
		updateSubjectStats($split2_ID_TOPIC, $new_subject);
		updateSubjectStats(/** @scrutinizer ignore-type */ $split2_ID_TOPIC, $new_subject);
	}

	// Any associated reported posts better follow...
	require_once(SUBSDIR . '/Topic.subs.php');
	updateSplitTopics([
		'splitMessages' => $splitMessages,
		'split1_replies' => $split1_replies,
		'split1_first_msg' => $split1_first_msg,
		'split1_last_msg' => $split1_last_msg,
		'split1_firstMem' => $split1_firstMem,
		'split1_lastMem' => $split1_lastMem,
		'split1_unapprovedposts' => $split1_unapprovedposts,
		'split1_ID_TOPIC' => $split1_ID_TOPIC,
		'split2_first_msg' => $split2_first_msg,
		'split2_last_msg' => $split2_last_msg,
		'split2_ID_TOPIC' => $split2_ID_TOPIC,
		'split2_approved' => $split2_approved,
	], $id_board);

	require_once(SUBSDIR . '/FollowUps.subs.php');

	// Let's see if we can create a stronger bridge between the two topics
	// @todo not sure what message from the oldest topic I should link to the new one, so I'll go with the first
	linkMessages($split1_first_msg, $split2_ID_TOPIC);
	linkMessages($split1_first_msg, /** @scrutinizer ignore-type */ $split2_ID_TOPIC);

	// Copy log topic entries.
	// @todo This should really be chunked.
	$replaceEntries = [];
	$db->fetchQuery('
		SELECT 
			id_member, id_msg, unwatched
		FROM {db_prefix}log_topics
		WHERE id_topic = {int:id_topic}',
		[
			'id_topic' => (int) $split1_ID_TOPIC,
		]
	)->fetch_callback(
		function ($row) use (&$replaceEntries, $split2_ID_TOPIC) {
			$replaceEntries[] = [$row['id_member'], $split2_ID_TOPIC, $row['id_msg'], $row['unwatched']];
		}
	);

	if (!empty($replaceEntries))
	{
		require_once(SUBSDIR . '/Topic.subs.php');
		markTopicsRead($replaceEntries, false);
		unset($replaceEntries);
	}

	// Housekeeping.
	updateTopicStats();
	updateLastMessages($id_board);

	logAction('split', ['topic' => $split1_ID_TOPIC, 'new_topic' => $split2_ID_TOPIC, 'board' => $id_board]);

	// Notify people that this topic has been split?
	require_once(SUBSDIR . '/Notification.subs.php');
	sendNotifications($split1_ID_TOPIC, 'split');

	// If there's a search index that needs updating, update it...
	$searchAPI = new SearchApiWrapper(!empty($modSettings['search_index']) ? $modSettings['search_index'] : '');
	$searchAPI->topicSplit($split2_ID_TOPIC, $splitMessages);
	$searchAPI->topicSplit(/** @scrutinizer ignore-type */ $split2_ID_TOPIC, $splitMessages);

	// Return the ID of the newly created topic.
	return $split2_ID_TOPIC;

}

/**
 * If we are also moving the topic somewhere else, let's try do to it
 * Includes checks for permissions move_own/any, etc.
 *
 * @param array $boards an array containing basic info of the origin and destination boards (from splitDestinationBoard)
 * @param int $totopic id of the destination topic
 */
function splitAttemptMove($boards, $totopic)
{
	global $board;

	$db = database();

	// If the starting and final boards are different we have to check some permissions and stuff
	if ($boards['destination']['id'] != $board)
	{
		$doMove = false;
		if (allowedTo('move_any'))
		{
			$doMove = true;
		}
		else
		{
			$new_topic = getTopicInfo($totopic);
			if ($new_topic['id_member_started'] == User::$info->id && allowedTo('move_own'))

			{
				$doMove = true;
			}
		}

		if ($doMove)
		{
			// Update member statistics if needed
			// @todo this should probably go into a function...
			if ($boards['destination']['count_posts'] != $boards['current']['count_posts'])
			{
				$posters = [];
				$db->fetchQuery('
					SELECT 
						id_member
					FROM {db_prefix}messages
					WHERE id_topic = {int:current_topic}
						AND approved = {int:is_approved}',
					[
						'current_topic' => $totopic,
						'is_approved' => 1,
					]
				)->fetch_callback(
					function ($row) use (&$posters) {
						if (!isset($posters[$row['id_member']]))
						{
							$posters[$row['id_member']] = 0;
						}

						$posters[$row['id_member']]++;
					}
				);

				require_once(SUBSDIR . '/Members.subs.php');
				foreach ($posters as $id_member => $posts)
				{
					// The board we're moving from counted posts, but not to.
					if (empty($boards['current']['count_posts']))
					{
						updateMemberData($id_member, ['posts' => 'posts - ' . $posts]);
					}
					// The reverse: from didn't, to did.
					else
					{
						updateMemberData($id_member, ['posts' => 'posts + ' . $posts]);
					}
				}
			}

			// And finally move it!
			moveTopics($totopic, $boards['destination']['id']);
		}
		else
		{
			$boards['destination'] = $boards['current'];
		}
	}
}

/**
 * Retrieves information of the current and destination board of a split topic
 *
 * @param int $toboard
 *
 * @return array
 * @throws \ElkArte\Exceptions\Exception no_board
 */
function splitDestinationBoard($toboard = 0)
{
	global $board, $topic;

	$current_board = boardInfo($board, $topic);
	if (empty($current_board))
	{
		throw new \ElkArte\Exceptions\Exception('no_board');
	}

	if (!empty($toboard) && $board !== $toboard)
	{
		$destination_board = boardInfo($toboard);
		if (empty($destination_board))
		{
			throw new \ElkArte\Exceptions\Exception('no_board');
		}
	}

	if (!isset($destination_board))
	{
		$destination_board = array_merge($current_board, ['id' => $board]);
	}
	else
	{
		$destination_board['id'] = $toboard;
	}

	return ['current' => $current_board, 'destination' => $destination_board];

}

/**
 * Retrieve topic notifications count.
 * (used by createList() callbacks, amongst others.)
 *
 * @param int $memID id_member
 * @return int
 */
function topicNotificationCount($memID)
{
	global $modSettings;

	$db = database();

	$request = $db->query('', '
		SELECT 
			COUNT(*)
		FROM {db_prefix}log_notify AS ln' . (!$modSettings['postmod_active'] && User::$info->query_see_board === '1=1' ? '' : '

			INNER JOIN {db_prefix}topics AS t ON (t.id_topic = ln.id_topic)') . (User::$info->query_see_board === '1=1' ? '' : '
			INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)') . '
		WHERE ln.id_member = {int:selected_member}' . (User::$info->query_see_board === '1=1' ? '' : '
			AND {query_see_board}') . ($modSettings['postmod_active'] ? '
			AND t.approved = {int:is_approved}' : ''),
		[
			'selected_member' => $memID,
			'is_approved' => 1,
		]
	);
	list ($totalNotifications) = $request->fetch_row();
	$request->free_result();

	return (int) $totalNotifications;
}

/**
 * Retrieve all topic notifications for the given user.
 * (used by createList() callbacks)
 *
 * @param int $start The item to start with (for pagination purposes)
 * @param int $items_per_page The number of items to show per page
 * @param string $sort A string indicating how to sort the results
 * @param int $memID id_member
 * @return array
 */
function topicNotifications($start, $items_per_page, $sort, $memID)
{
	global $modSettings;

	$db = database();

	// All the topics with notification on...
	$notification_topics = [];
	$db->query('', '
		SELECT
			COALESCE(lt.id_msg, lmr.id_msg, -1) + 1 AS new_from, b.id_board, b.name,
			t.id_topic, ms.subject, ms.id_member, COALESCE(mem.real_name, ms.poster_name) AS real_name_col,
			ml.id_msg_modified, ml.poster_time, ml.id_member AS id_member_updated,
			COALESCE(mem2.real_name, ml.poster_name) AS last_real_name
		FROM {db_prefix}log_notify AS ln
			INNER JOIN {db_prefix}topics AS t ON (t.id_topic = ln.id_topic' . ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '') . ')
			INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board AND {query_see_board})
			INNER JOIN {db_prefix}messages AS ms ON (ms.id_msg = t.id_first_msg)
			INNER JOIN {db_prefix}messages AS ml ON (ml.id_msg = t.id_last_msg)
			LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = ms.id_member)
			LEFT JOIN {db_prefix}members AS mem2 ON (mem2.id_member = ml.id_member)
			LEFT JOIN {db_prefix}log_topics AS lt ON (lt.id_topic = t.id_topic AND lt.id_member = {int:current_member})
			LEFT JOIN {db_prefix}log_mark_read AS lmr ON (lmr.id_board = b.id_board AND lmr.id_member = {int:current_member})
		WHERE ln.id_member = {int:selected_member}
		ORDER BY {raw:sort}
		LIMIT {int:offset}, {int:items_per_page}',
		[
			'current_member' => User::$info->id,

			'is_approved' => 1,
			'selected_member' => $memID,
			'sort' => $sort,
			'offset' => $start,
			'items_per_page' => $items_per_page,
		]
	)->fetch_callback(
		function ($row) use (&$notification_topics) {
			$row['subject'] = censor($row['subject']);
			$topic_href = getUrl('topic', ['topic' => $row['id_topic'], 'start' => '0', 'subject' => $row['subject']]);
			$topic_new_href = getUrl('topic', ['topic' => $row['id_topic'], 'start' => 'msg' . $row['new_from'], 'subject' => $row['subject']]);

			$notification_topics[] = [
				'id' => $row['id_topic'],
				'poster_link' => empty($row['id_member']) ? $row['real_name_col'] : '<a href="' . getUrl('profile', ['action' => 'profile', 'u' => $row['id_member'], 'name' => $row['real_name_col']]) . '">' . $row['real_name_col'] . '</a>',
				'poster_updated_link' => empty($row['id_member_updated']) ? $row['last_real_name'] : '<a href="' . getUrl('profile', ['action' => 'profile', 'u' => $row['id_member_updated'], 'name' => $row['last_real_name']]) . '">' . $row['last_real_name'] . '</a>',
				'subject' => $row['subject'],
				'href' => $topic_href,
				'link' => '<a href="' . $topic_href . '">' . $row['subject'] . '</a>',
				'new' => $row['new_from'] <= $row['id_msg_modified'],
				'new_from' => $row['new_from'],
				'updated' => standardTime($row['poster_time']),
				'new_href' => $topic_new_href . '#new',
				'new_link' => '<a href="' . $topic_new_href . '#new">' . $row['subject'] . '</a>',
				'board_link' => '<a href="' . getUrl('board', ['board' => $row['id_board'], 'start' => '0', 'name' => $row['name']]) . '">' . $row['name'] . '</a>',
			];
		}
	);

	return $notification_topics;
}

/**
 * Get a list of posters in this topic, and their posts counts in the topic.
 * Used to update users posts counts when topics are moved or are deleted.
 *
 * @param int $id_topic topic id to work with
 *
 * @return array
 */
function postersCount($id_topic)
{
	$db = database();

	// We only care about approved topics, the rest don't count.
	$posters = [];
	$db->query('', '
		SELECT 
			id_member
		FROM {db_prefix}messages
		WHERE id_topic = {int:current_topic}
			AND approved = {int:is_approved}',
		[
			'current_topic' => $id_topic,
			'is_approved' => 1,
		]
	)->fetch_callback(
		function ($row) use (&$posters) {
			if (!isset($posters[$row['id_member']]))
			{
				$posters[$row['id_member']] = 0;
			}

			$posters[$row['id_member']]++;
		}
	);

	return $posters;
}

/**
 * Counts topics from the given id_board.
 *
 * @param int $board
 * @param bool $approved
 * @return int
 */
function countTopicsByBoard($board, $approved = false)
{
	$db = database();

	// How many topics are on this board?  (used for paging.)
	$request = $db->query('', '
		SELECT 
			COUNT(*)
		FROM {db_prefix}topics AS t
		WHERE t.id_board = {int:id_board}' . (empty($approved) ? '
			AND t.approved = {int:is_approved}' : ''),
		[
			'id_board' => $board,
			'is_approved' => 1,
		]
	);
	list ($topics) = $request->fetch_row();
	$request->free_result();

	return $topics;
}

/**
 * Determines topics which can be merged from a specific board.
 *
 * @param int $id_board
 * @param int $id_topic
 * @param bool $approved
 * @param int $offset
 * @return array
 */
function mergeableTopics($id_board, $id_topic, $approved, $offset)
{
	global $modSettings;

	$db = database();

	// Get some topics to merge it with.
	$topics = [];
	$db->fetchQuery('
		SELECT 
			t.id_topic, m.subject, m.id_member, COALESCE(mem.real_name, m.poster_name) AS poster_name
		FROM (
			SELECT t.id_topic 
			FROM {db_prefix}topics AS t
			WHERE t.id_board = {int:id_board}
				AND t.id_topic != {int:id_topic}' . (empty($approved) ? '
				AND t.approved = {int:is_approved}' : '') . '
			ORDER BY t.is_sticky DESC, t.id_last_msg DESC
			LIMIT {int:limit} OFFSET {int:offset} 
		) AS o 
	    INNER JOIN {db_prefix}topics AS t ON (o.id_topic = t.id_topic)
	    INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
		LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
		ORDER BY t.is_sticky DESC, t.id_last_msg DESC',
		[
			'id_board' => $id_board,
			'id_topic' => $id_topic,
			'offset' => $offset,
			'limit' => $modSettings['defaultMaxTopics'],
			'is_approved' => 1,
		]
	)->fetch_callback(
		function ($row) use (&$topics) {
			$row['subject'] = censor($row['subject']);

			$href = getUrl('profile', ['action' => 'profile', 'u' => $row['id_member'], 'name' => $row['poster_name']]);
			$topics[] = [
				'id' => $row['id_topic'],
				'poster' => [
					'id' => $row['id_member'],
					'name' => $row['poster_name'],
					'href' => empty($row['id_member']) ? '' : $href,
					'link' => empty($row['id_member']) ? $row['poster_name'] : '<a href="' . $href . '" target="_blank" class="new_win">' . $row['poster_name'] . '</a>'
				],
				'subject' => $row['subject'],
				'js_subject' => addcslashes(addslashes($row['subject']), '/')
			];
		}
	);

	return $topics;
}

/**
 * Determines all messages from a given array of topics.
 *
 * @param int[] $topics integer array of topics to work with
 * @return array
 */
function messagesInTopics($topics)
{
	$db = database();

	$topics = is_array($topics) ? $topics : [$topics];


	// Obtain all the message ids we are going to affect.
	$messages = [];
	$db->fetchQuery('
		SELECT 
			id_msg
		FROM {db_prefix}messages
		WHERE id_topic IN ({array_int:topic_list})',
		[
			'topic_list' => $topics,
		]
	)->fetch_callback(
		function ($row) use (&$messages) {
			$messages[] = $row['id_msg'];
		}
	);

	return $messages;
}

/**
 * Retrieves the members that posted in a group of topics.
 *
 * @param int[] $topics integer array of topics to work with
 * @return array of topics each member posted in (grouped by members)
 */
function topicsPosters($topics)
{
	$db = database();

	// Obtain all the member ids
	$members = [];
	$db->fetchQuery('
		SELECT 
			id_member, id_topic
		FROM {db_prefix}messages
		WHERE id_topic IN ({array_int:topic_list})',
		[
			'topic_list' => $topics,
		]
	)->fetch_callback(
		function ($row) use (&$members) {
			$members[$row['id_member']][] = $row['id_topic'];
		}
	);

	return $members;
}

/**
 * Updates all the tables involved when two or more topics are merged
 *
 * @param int $first_msg the first message of the new topic
 * @param int[] $topics ids of all the topics merged
 * @param int $id_topic id of the merged topic
 * @param int $target_board id of the target board where the topic will resides
 * @param string $target_subject subject of the new topic
 * @param string $enforce_subject if not empty all the messages will be set to the same subject
 * @param int[] $notifications array of topics with active notifications
 */
function fixMergedTopics($first_msg, $topics, $id_topic, $target_board, $target_subject, $enforce_subject, $notifications)
{
	$db = database();

	// Delete the remaining topics.
	$deleted_topics = array_diff($topics, [$id_topic]);
	$db->query('', '
		DELETE FROM {db_prefix}topics
		WHERE id_topic IN ({array_int:deleted_topics})',
		[
			'deleted_topics' => $deleted_topics,
		]
	);

	$db->query('', '
		DELETE FROM {db_prefix}log_search_subjects
		WHERE id_topic IN ({array_int:deleted_topics})',
		[
			'deleted_topics' => $deleted_topics,
		]
	);

	// Change the topic IDs of all messages that will be merged.  Also adjust subjects if 'enforce subject' was checked.
	$db->query('', '
		UPDATE {db_prefix}messages
		SET
			id_topic = {int:id_topic},
			id_board = {int:target_board}' . (empty($enforce_subject) ? '' : ',
			subject = {string:subject}') . '
		WHERE id_topic IN ({array_int:topic_list})',
		[
			'topic_list' => $topics,
			'id_topic' => $id_topic,
			'target_board' => $target_board,
			'subject' => response_prefix() . $target_subject,
		]
	);

	// Any reported posts should reflect the new board.
	$db->query('', '
		UPDATE {db_prefix}log_reported
		SET
			id_topic = {int:id_topic},
			id_board = {int:target_board}
		WHERE id_topic IN ({array_int:topics_list})',
		[
			'topics_list' => $topics,
			'id_topic' => $id_topic,
			'target_board' => $target_board,
		]
	);

	// Change the subject of the first message...
	$db->query('', '
		UPDATE {db_prefix}messages
		SET 
			subject = {string:target_subject}
		WHERE id_msg = {int:first_msg}',
		[
			'first_msg' => $first_msg,
			'target_subject' => $target_subject,
		]
	);

	// Adjust all calendar events to point to the new topic.
	$db->query('', '
		UPDATE {db_prefix}calendar
		SET
			id_topic = {int:id_topic},
			id_board = {int:target_board}
		WHERE id_topic IN ({array_int:deleted_topics})',
		[
			'deleted_topics' => $deleted_topics,
			'id_topic' => $id_topic,
			'target_board' => $target_board,
		]
	);

	// Merge log topic entries.
	// The unwatched setting comes from the oldest topic
	$request = $db->query('', '
		SELECT 
			id_member, unwatched, MIN(id_msg) AS new_id_msg
		FROM {db_prefix}log_topics
		WHERE id_topic IN ({array_int:topics})
		GROUP BY id_member, unwatched',
		[
			'topics' => $topics,
		]
	);
	if ($request->num_rows() > 0)
	{
		$replaceEntries = [];
		while (($row = $request->fetch_assoc()))
		{
			$replaceEntries[] = [$row['id_member'], $id_topic, $row['new_id_msg'], $row['unwatched']];
		}

		markTopicsRead($replaceEntries, true);
		unset($replaceEntries);

		// Get rid of the old log entries.
		$db->query('', '
			DELETE FROM {db_prefix}log_topics
			WHERE id_topic IN ({array_int:deleted_topics})',
			[
				'deleted_topics' => $deleted_topics,
			]
		);
	}
	$request->free_result();

	if (!empty($notifications))
	{
		$request = $db->query('', '
			SELECT 
				id_member, MAX(sent) AS sent
			FROM {db_prefix}log_notify
			WHERE id_topic IN ({array_int:topics_list})
			GROUP BY id_member',
			[
				'topics_list' => $notifications,
			]
		);
		if ($request->num_rows() > 0)
		{
			$replaceEntries = [];
			while (($row = $request->fetch_assoc()))
			{
				$replaceEntries[] = [$row['id_member'], $id_topic, 0, $row['sent']];
			}

			$db->replace(
				'{db_prefix}log_notify',
				['id_member' => 'int', 'id_topic' => 'int', 'id_board' => 'int', 'sent' => 'int'],
				$replaceEntries,
				['id_member', 'id_topic', 'id_board']
			);
			unset($replaceEntries);

			$db->query('', '
				DELETE FROM {db_prefix}log_topics
				WHERE id_topic IN ({array_int:deleted_topics})',
				[
					'deleted_topics' => $deleted_topics,
				]
			);
		}
		$request->free_result();
	}
}

/**
 * Load the subject from a given topic id.
 *
 * @param int $id_topic
 *
 * @return string
 * @throws \ElkArte\Exceptions\Exception topic_gone
 */
function getSubject($id_topic)
{
	global $modSettings;

	$db = database();

	$request = $db->query('', '
		SELECT 
			ms.subject
		FROM {db_prefix}topics AS t
			INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
			INNER JOIN {db_prefix}messages AS ms ON (ms.id_msg = t.id_first_msg)
		WHERE t.id_topic = {int:search_topic_id}
			AND {query_see_board}' . ($modSettings['postmod_active'] ? '
			AND t.approved = {int:is_approved_true}' : '') . '
		LIMIT 1',
		[
			'is_approved_true' => 1,
			'search_topic_id' => $id_topic,
		]
	);
	if ($request->num_rows() === 0)
	{
		throw new \ElkArte\Exceptions\Exception('topic_gone', false);
	}
	list ($subject) = $request->fetch_row();
	$request->free_result();

	return $subject;
}

/**
 * This function updates the total number of topics,
 * or if parameter $increment is true it simply increments them.
 *
 * @param bool|null $increment = null if true, increment + 1 the total topics, otherwise recount all topics
 */
function updateTopicStats($increment = null)
{
	global $modSettings;

	$db = database();

	if ($increment === true)
	{
		updateSettings(['totalTopics' => true], true);
	}
	else
	{
		// Get the number of topics - a SUM is better for InnoDB tables.
		// We also ignore the recycle bin here because there will probably be a bunch of one-post topics there.
		$request = $db->query('', '
			SELECT 
				SUM(num_topics + unapproved_topics) AS total_topics
			FROM {db_prefix}boards' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
			WHERE id_board != {int:recycle_board}' : ''),
			[
				'recycle_board' => !empty($modSettings['recycle_board']) ? $modSettings['recycle_board'] : 0,
			]
		);
		$row = $request->fetch_assoc();
		$request->free_result();

		updateSettings(['totalTopics' => $row['total_topics'] ?? 0]);
	}
}

/**
 * Toggles the locked status of the passed id_topic's checking for permissions.
 *
 * @param int[] $topics The topics to lock (can be an id or an array of ids).
 * @param bool $log if true logs the action.
 */
function toggleTopicsLock($topics, $log = false)
{
	global $board;

	$db = database();

	$needs_check = !empty($board) && !allowedTo('lock_any');
	$lockCache = [];

	$topicAttribute = topicAttribute($topics, ['id_topic', 'locked', 'id_board', 'id_member_started']);

	foreach ($topicAttribute as $row)
	{
		// Skip the entry if it needs to be checked and the user is not the owen and
		// the topic was not locked or locked by someone with more permissions
		if ($needs_check && (User::$info->id != $row['id_member_started'] || !in_array($row['locked'], [0, 2])))

		{
			continue;
		}

		$lockCache[] = $row['id_topic'];

		if ($log)
		{
			$lockStatus = empty($row['locked']) ? 'lock' : 'unlock';

			logAction($lockStatus, ['topic' => $row['id_topic'], 'board' => $row['id_board']]);
			sendNotifications($row['id_topic'], $lockStatus);
		}
	}

	// It could just be that *none* were their own topics...
	if (!empty($lockCache))
	{
		// Alternate the locked value.
		$db->query('', '
			UPDATE {db_prefix}topics
			SET 
				locked = CASE WHEN locked = {int:is_locked} THEN ' . (allowedTo('lock_any') ? '1' : '2') . ' ELSE 0 END
			WHERE id_topic IN ({array_int:locked_topic_ids})',
			[
				'locked_topic_ids' => $lockCache,
				'is_locked' => 0,
			]
		);
	}
}

elkarte / Elkarte

messagesInTopics() A last analyzed 2025-12-05 00:18 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

messagesInTopics() A
last analyzed 2025-12-05 00:18 UTC
