albertlast / SMF2.1

	}

	// How many notes in total?

	if (($moderator_notes_total = cache_get_data('moderator_notes_total', 240)) === null)

	{

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

			SELECT COUNT(*)

			FROM {db_prefix}log_comments AS lc

				LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = lc.id_member)

			WHERE lc.comment_type = {literal:modnote}',

			array(

			)

		);

		list ($moderator_notes_total) = $smcFunc['db_fetch_row']($request);

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

		cache_put_data('moderator_notes_total', $moderator_notes_total, 240);

	}

	// Grab the current notes. We can only use the cache for the first page of notes.

	$offset = isset($_GET['notes']) && isset($_GET['start']) ? $_GET['start'] : 0;

	// Are we loading any moderators?  If so, fix their group data...

	if (!empty($loaded_ids) && (!empty($board_info['moderators']) || !empty($board_info['moderator_groups'])) && $set === 'normal' && count($temp_mods = array_merge(array_intersect($loaded_ids, array_keys($board_info['moderators'])), $additional_mods)) !== 0)

	{

		if (($row = cache_get_data('moderator_group_info', 480)) == null)

		{

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

				SELECT group_name AS member_group, online_color AS member_group_color, icons

				FROM {db_prefix}membergroups

				WHERE id_group = {int:moderator_group}

				LIMIT 1',

				array(

					'moderator_group' => 3,

				)

			);

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

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

			cache_put_data('moderator_group_info', $row, 480);

		}

		foreach ($temp_mods as $id)

		{