SimpleMachines / SMF2.1

			// Fetch a list of member_names if necessary

			if ((!is_array($members) && $members === $user_info['id']) || (is_array($members) && count($members) == 1 && in_array($user_info['id'], $members)))

				$member_names = array($user_info['username']);

			else

			{

				$member_names = array();

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

					SELECT member_name

					FROM {db_prefix}members

					WHERE ' . $condition,

					$parameters

				);

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

					$member_names[] = $row['member_name'];

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

			}

			if (!empty($member_names))

				foreach ($vars_to_integrate as $var)

	// Any topics found?

	$topicsInfo = array();

	if (!empty($topics))

	{

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

			SELECT mf.subject, mf.poster_time as started_on, COALESCE(memf.real_name, mf.poster_name) as started_by, ml.poster_time as last_post_on, COALESCE(meml.real_name, ml.poster_name) as last_post_by, t.id_topic

			FROM {db_prefix}topics AS t

				INNER JOIN {db_prefix}messages AS ml ON (ml.id_msg = t.id_last_msg)

				INNER JOIN {db_prefix}messages AS mf ON (mf.id_msg = t.id_first_msg)

				LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)

				LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)

			WHERE t.id_topic IN ({array_int:topics})',

			array(

				'topics' => $topics,

			)

		);

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

			$topicsInfo[] = $row;

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

	}

	return $topicsInfo;

}