SimpleMachines / SMF2.1

				$context['start_from'] = $context['total_visible_posts'] - 1;

				$_REQUEST['start'] = empty($options['view_newest_first']) ? $context['start_from'] : 0;

			}

			else

			{

				// Find the earliest unread message in the topic. (the use of topics here is just for both tables.)

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

					SELECT COALESCE(lt.id_msg, lmr.id_msg, -1) + 1 AS new_from

					FROM {db_prefix}topics AS t

						LEFT JOIN {db_prefix}log_topics AS lt ON (lt.id_topic = {int:current_topic} AND lt.id_member = {int:current_member})

						LEFT JOIN {db_prefix}log_mark_read AS lmr ON (lmr.id_board = {int:current_board} AND lmr.id_member = {int:current_member})

					WHERE t.id_topic = {int:current_topic}

					LIMIT 1',

					array(

						'current_board' => $board,

						'current_member' => $user_info['id'],

						'current_topic' => $topic,

					)

				);

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

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

				// Fall through to the next if statement.

				$_REQUEST['start'] = 'msg' . $new_from;

			}

		}

		// Start from a certain time index, not a message.

			elseif ($_GET['t'] <= $topicinfo['id_first_msg'])

				$earlyMsg = 0;

			// Otherwise, get the latest message before the named one.

			else

			{

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

					SELECT MAX(id_msg)

					FROM {db_prefix}messages

					WHERE id_topic = {int:current_topic}

						AND id_msg >= {int:id_first_msg}

						AND id_msg < {int:topic_msg_id}',

					array(

						'current_topic' => $topic,

						'topic_msg_id' => (int) $_GET['t'],

						'id_first_msg' => $topicinfo['id_first_msg'],

					)

				);

				list ($earlyMsg) = $smcFunc['db_fetch_row']($result);

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

			}

		}

		// Marking read from first page?  That's the whole topic.

		elseif ($_REQUEST['start'] == 0)

		// Marking read from first page?  That's the whole topic.

		elseif ($_REQUEST['start'] == 0)

			$earlyMsg = 0;

		else

		{

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

				SELECT id_msg

				FROM {db_prefix}messages

				WHERE id_topic = {int:current_topic}

				ORDER BY id_msg

				LIMIT {int:start}, 1',

				array(

					'current_topic' => $topic,

					'start' => (int) $_REQUEST['start'],

				)

			);

			list ($earlyMsg) = $smcFunc['db_fetch_row']($result);

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

			$earlyMsg--;

		}

		// Blam, unread!

		$smcFunc['db_insert']('replace',

		$context['current_theme'] = $modSettings['theme_guests'];

	}

	// Someones else :P.

	else

	{

		$context['current_member'] = (int) $_REQUEST['u'];

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

			SELECT id_theme

			FROM {db_prefix}members

			WHERE id_member = {int:current_member}

			LIMIT 1',

			array(

				'current_member' => $context['current_member'],

			)

		);

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

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

	}

	// Get the theme name and descriptions.

	$context['available_themes'] = array();