basicMessageInfo()

Complexity

Conditions	13
Paths	7

Size

Total Lines	46
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	13
CRAP Score	14.114

Importance

Changes

0

<?php
function basicMessageInfo($id_msg, $override_permissions = false, $detailed = false, $approved = true)
{
	global $modSettings;

	$db = database();

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

	$request = $db->fetchQuery('
		SELECT
			m.id_member, m.id_topic, m.id_board, m.id_msg, m.body, m.subject,
			m.poster_name, m.poster_email, m.poster_time, m.approved' . ($detailed === false ? '' : ',
			t.id_first_msg, t.num_replies, t.unapproved_posts, t.id_last_msg, t.id_member_started, t.locked, t.approved AS topic_approved') . '
		FROM {db_prefix}messages AS m' . ($override_permissions === true ? '' : '
			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board AND {query_see_board})') . ($detailed === false ? '' : '
			LEFT JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)') . '
		WHERE id_msg = {int:message}' . (empty($modSettings['postmod_active']) || allowedTo('approve_posts') || $approved === false ? '' : '
			AND m.approved = 1') . '
		LIMIT 1',
		[
			'message' => $id_msg,
		]
	);
	if ($request->hasResults())
	{
		$messageInfo = $request->fetch_assoc();

		$intKeys = ['id_member', 'id_topic', 'id_board', 'id_msg', 'poster_time', 'approved'];
		if ($detailed !== false) {
			$intKeys = array_merge($intKeys, ['id_first_msg', 'num_replies', 'unapproved_posts',
				'id_last_msg', 'id_member_started', 'locked', 'topic_approved'
			]);
		}

		foreach ($intKeys as $key) {
			if (isset($messageInfo[$key])) {
				$messageInfo[$key] = (int) $messageInfo[$key];
			}
		}
	}
	$request->free_result();

	return empty($messageInfo) ? false : $messageInfo;
}