albertlast / SMF2.1

	if (isset($_GET['event']))

	{

		$evid = (int) $_GET['event'];

		if ($evid > 0)

		{

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

				SELECT start_date

				FROM {db_prefix}calendar

				WHERE id_event = {int:event_id}',

				array(

					'event_id' => $evid,

				)

			);

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

			{

				$_REQUEST['start_date'] = $row['start_date'];

				// We might use this later.

				$context['selected_event'] = $evid;

			}

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

		}

		unset ($_GET['event']);

	}

	);

	// If we were unapproving find the last msg in the topics...

	if (!$approve)

	{

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

			SELECT id_topic, MAX(id_msg) AS id_last_msg

			FROM {db_prefix}messages

			WHERE id_topic IN ({array_int:topic_list})

				AND approved = {int:approved}

			GROUP BY id_topic',

			array(

				'topic_list' => $topics,

				'approved' => 1,

			)

		);

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

			$topic_changes[$row['id_topic']]['id_last_msg'] = $row['id_last_msg'];

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

	}

	// ... next the topics...

	foreach ($topic_changes as $id => $changes)

	}

	// Large forums may need a bit more prodding...

	if ($modSettings['totalMessages'] > 100000)

	{

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

			SELECT id_topic

			FROM {db_prefix}topics

			WHERE num_views != {int:no_views}

			ORDER BY num_views DESC

			LIMIT 100',

			array(

				'no_views' => 0,

			)

		);

		$topic_ids = array();

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

			$topic_ids[] = $row['id_topic'];

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

	}

	else

		$topic_ids = array();

	// Topic views top 10.

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