SimpleMachines / SMF2.1

		$null_fix = strtolower($table_row['Null']) === 'yes' && !$change['null_allowed'];

		// Get the character set that goes with the collation of the column.

		if ($column_fix && !empty($table_row['Collation']))

		{

			$request = $smcFunc['db_query']('', '

				SHOW COLLATION

				LIKE {string:collation}',

				array(

					'collation' => $table_row['Collation'],

					'db_error_skip' => true,

				)

			);

			// No results? Just forget it all together.

			if ($smcFunc['db_num_rows']($request) === 0)

				unset($table_row['Collation']);

			else

				$collation_info = $smcFunc['db_fetch_assoc']($request);

			$smcFunc['db_free_result']($request);

		}

	}

	if ($column_fix)

		if (!empty($board))

			$boards[] = (int) $board;

		if (isset($_REQUEST['children']) && !empty($boards))

		{

			// They want to mark the entire tree starting with the boards specified

			// The easiest thing is to just get all the boards they can see, but since we've specified the top of tree we ignore some of them

			$request = $smcFunc['db_query']('', '

				SELECT b.id_board, b.id_parent

				FROM {db_prefix}boards AS b

				WHERE {query_see_board}

					AND b.child_level > {int:no_parents}

					AND b.id_board NOT IN ({array_int:board_list})

				ORDER BY child_level ASC

				',

				array(

					'no_parents' => 0,

					'board_list' => $boards,

				)

			);

			while ($row = $smcFunc['db_fetch_assoc']($request))

				if (in_array($row['id_parent'], $boards))

					$boards[] = $row['id_board'];

			$smcFunc['db_free_result']($request);

		}

		$clauses = array();

		$clauseParameters = array();

		$moderator_groups = array();

		// "Inherit" any moderator permissions as needed

		if (isset($board_info['moderator_groups']))

		{

			$moderator_groups = array_keys($board_info['moderator_groups']);

		}

		elseif ($board_id !== 0)

		{

			// Get the groups that can moderate this board

			$request = $smcFunc['db_query']('', '

				SELECT id_group

				FROM {db_prefix}moderator_groups

				WHERE id_board = {int:board_id}',

				array(

					'board_id' => $board_id,

				)

			);

			while ($row = $smcFunc['db_fetch_assoc']($request))

			{

				$moderator_groups[] = $row['id_group'];

			}

			$smcFunc['db_free_result']($request);

		}

		// "Inherit" any additional permissions from the "Moderators" group

		foreach ($moderator_groups as $mod_group)

	$smcFunc['db_free_result']($request);

	if (!empty($buddiesArray))

	{

		$result = $smcFunc['db_query']('', '

			SELECT id_member

			FROM {db_prefix}members

			WHERE id_member IN ({array_int:buddy_list})

			ORDER BY real_name

			LIMIT {int:buddy_list_count}',

			array(

				'buddy_list' => $buddiesArray,

				'buddy_list_count' => substr_count($user_profile[$memID]['buddy_list'], ',') + 1,

			)

		);

		while ($row = $smcFunc['db_fetch_assoc']($result))

			$buddies[] = $row['id_member'];

		$smcFunc['db_free_result']($result);

	}

	$context['buddy_count'] = count($buddies);

	// Initialise the list of members we're ignoring.

	$ignored = array();

	if (!empty($ignoreArray))

	{

		$result = $smcFunc['db_query']('', '

			SELECT id_member

			FROM {db_prefix}members

			WHERE id_member IN ({array_int:ignore_list})

			ORDER BY real_name

			LIMIT {int:ignore_list_count}',

			array(

				'ignore_list' => $ignoreArray,

				'ignore_list_count' => substr_count($user_profile[$memID]['pm_ignore_list'], ',') + 1,

			)

		);

		while ($row = $smcFunc['db_fetch_assoc']($result))

			$ignored[] = $row['id_member'];

		$smcFunc['db_free_result']($result);

	}

	$context['ignore_count'] = count($ignored);