fix_calendar_text()

Complexity

Conditions	1
Paths	1

Size

Total Lines	63
Code Lines	56

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	56
CRAP Score	1

Importance

Changes

0

<?php
 * @param int $id_parent
 *
 * @return array
 * @throws \ElkArte\Exceptions\Exception parent_not_found
 */
function getBoardParents($id_parent)
{
	$db = database();
	$cache = Cache::instance();
	$boards = array();

	// First check if we have this cached already.
	if (!$cache->getVar($boards, 'board_parents-' . $id_parent, 480))
	{
		$boards = array();
		$original_parent = $id_parent;

		// Loop while the parent is non-zero.
		while ($id_parent != 0)
		{
			$result = $db->query('', '
				SELECT
					b.id_parent, b.name, {int:board_parent} AS id_board, COALESCE(mem.id_member, 0) AS id_moderator,
					mem.real_name, b.child_level
				FROM {db_prefix}boards AS b
					LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board)
					LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = mods.id_member)
				WHERE b.id_board = {int:board_parent}',
				array(
					'board_parent' => $id_parent,
				)
			);
			// In the EXTREMELY unlikely event this happens, give an error message.
			if ($result->num_rows() == 0)
			{
				throw new \ElkArte\Exceptions\Exception('parent_not_found', 'critical');
			}
			while (($row = $result->fetch_assoc()))
			{
				if (!isset($boards[$row['id_board']]))
				{
					$id_parent = $row['id_parent'];
					$boards[$row['id_board']] = array(
						'url' => getUrl('board', ['board' => $row['id_board'], 'name' => $row['name'], 'start' => '0']),
						'name' => $row['name'],
						'level' => $row['child_level'],
						'moderators' => array()
					);
				}

				// If a moderator exists for this board, add that moderator for all children too.
				if (!empty($row['id_moderator']))
				{
					foreach ($boards as $id => $dummy)
					{
						$boards[$id]['moderators'][$row['id_moderator']] = array(
							'id' => $row['id_moderator'],
							'name' => $row['real_name'],
							'href' => getUrl('profile', ['action' => 'profile', 'u' => $row['id_moderator']]),
							'link' => '<a href="' . getUrl('profile', ['action' => 'profile', 'u' => $row['id_moderator']]) . '">' . $row['real_name'] . '</a>'
						);
					}
				}
			}