alert_count()

Complexity

Conditions	25
Paths	513

Size

Total Lines	160
Code Lines	74

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	0

<?php
function alert_count($memID, $unread = false)
{
	global $smcFunc, $user_info;

	if (empty($memID))
		return false;

	$alerts = array();
	$possible_topics = array();
	$possible_msgs = array();
	$possible_attachments = array();

The assignment to $possible_attachments is dead and can be removed.

	// We have to do this the slow way as to iterate over all possible boards the user can see.
	$request = $smcFunc['db_query']('', '
		SELECT id_alert, content_id, content_type, content_action, is_read
		FROM {db_prefix}user_alerts
		WHERE id_member = {int:id_member}
			' . ($unread ? '
			AND is_read = 0' : ''),
		array(
			'id_member' => $memID,
		)
	);
	// First we dump alerts and possible boards information out.
	while ($row = $smcFunc['db_fetch_assoc']($request))
	{
		$alerts[$row['id_alert']] = $row;

		// For these types, we need to check whether they can actually see the content.
		if ($row['content_type'] == 'msg')
		{
			$alerts[$row['id_alert']]['visible'] = false;
			$possible_msgs[$row['id_alert']] = $row['content_id'];
		}
		elseif (in_array($row['content_type'], array('topic', 'board')))
		{
			$alerts[$row['id_alert']]['visible'] = false;
			$possible_topics[$row['id_alert']] = $row['content_id'];
		}
		// For the rest, they can always see it.
		else
			$alerts[$row['id_alert']]['visible'] = true;
	}
	$smcFunc['db_free_result']($request);

	// If we need to check board access, use the correct board access filter for the member in question.
	if ((!isset($user_info['query_see_board']) || $user_info['id'] != $memID) && (!empty($possible_msgs) || !empty($possible_topics)))
		$qb = build_query_board($memID);
	else
	{
		$qb['query_see_topic_board'] = '{query_see_topic_board}';

$qb was never initialized. Although not strictly required by PHP, it is generally a good practice to add $qb = array(); before regardless.

		$qb['query_see_message_board'] = '{query_see_message_board}';
	}

	// We want only the stuff they can see.
	if (!empty($possible_msgs))
	{
		$flipped_msgs = array();
		foreach ($possible_msgs as $id_alert => $id_msg)
		{
			if (!isset($flipped_msgs[$id_msg]))
				$flipped_msgs[$id_msg] = array();

			$flipped_msgs[$id_msg][] = $id_alert;
		}

		$request = $smcFunc['db_query']('', '
			SELECT m.id_msg
			FROM {db_prefix}messages AS m
			WHERE ' . $qb['query_see_message_board'] . '
				AND m.id_msg IN ({array_int:msgs})',
			array(
				'msgs' => $possible_msgs,
			)
		);
		while ($row = $smcFunc['db_fetch_assoc']($request))
		{
			foreach ($flipped_msgs[$row['id_msg']] as $id_alert)
				$alerts[$id_alert]['visible'] = true;
		}
		$smcFunc['db_free_result']($request);
	}
	if (!empty($possible_topics))
	{
		$flipped_topics = array();
		foreach ($possible_topics as $id_alert => $id_topic)
		{
			if (!isset($flipped_topics[$id_topic]))
				$flipped_topics[$id_topic] = array();

			$flipped_topics[$id_topic][] = $id_alert;
		}

		$request = $smcFunc['db_query']('', '
			SELECT t.id_topic
			FROM {db_prefix}topics AS t
			WHERE ' . $qb['query_see_topic_board'] . '
				AND t.id_topic IN ({array_int:topics})',
			array(
				'topics' => $possible_topics,
			)
		);
		while ($row = $smcFunc['db_fetch_assoc']($request))
		{
			foreach ($flipped_topics[$row['id_topic']] as $id_alert)
				$alerts[$id_alert]['visible'] = true;
		}
		$smcFunc['db_free_result']($request);
	}

	// Now check alerts again and remove any they can't see.
	$deletes = array();
	$num_unread_deletes = 0;
	foreach ($alerts as $id_alert => $alert)
	{
		if (!$alert['visible'])
		{
			if (empty($alert['is_read']))
				$num_unread_deletes++;

			unset($alerts[$id_alert]);
			$deletes[] = $id_alert;
		}
	}

	// Penultimate task - delete these orphaned, invisible alerts, otherwise they might hang around forever.
	// This can happen if they are deleted or moved to a board this user cannot access.
	// Note that unread alerts are never purged.
	if (!empty($deletes))
	{
		$smcFunc['db_query']('', '
			DELETE FROM {db_prefix}user_alerts
			WHERE id_alert IN ({array_int:alerts})',
			array(
				'alerts' => $deletes,
			)
		);
	}

	// One last thing - tweak counter on member record.
	// Do it directly, as updateMemberData() calls this function, and may create a loop.
	// Note that $user_info is not populated when this is invoked via cron, hence the CASE statement.
	if ($num_unread_deletes > 0)
	{
		$smcFunc['db_query']('', '
			UPDATE {db_prefix}members
			SET alerts =
				CASE
					WHEN alerts < {int:unread_deletes} THEN 0
					ELSE alerts - {int:unread_deletes}
				END
			WHERE id_member = {int:member}',
			array(
				'unread_deletes' => $num_unread_deletes,
				'member' => $memID,
			)
		);
	}

	return count($alerts);
}
?>