tas2580 / seourls

	 * @return	null

	 * @access	public

	 */

	public function display_forums_modify_sql($event)

	{

		$sql_array = $event['sql_ary'];

		$sql_array['LEFT_JOIN'][] = array(

			'FROM' => array(TOPICS_TABLE => 't'),

			'ON' => "f.forum_last_post_id = t.topic_last_post_id"

		);

		$sql_array['SELECT'] .= ', t.topic_title, t.topic_id, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted';

		$event['sql_ary'] = $sql_array;

	}

	/**

	 * Store informations for the last post in forum_rows array

	 * @return	null

	 * @access	public

	 */

	public function viewforum_get_shadowtopic_data($event)

	{

		$sql_array = $event['sql_array'];

		$sql_array['SELECT'] .= ', f.forum_name';

		$sql_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TABLE => 'f'), 'ON' => 'f.forum_id = t.forum_id');

		$event['sql_array'] = $sql_array;

	}

	/**

	 * Rewrite the canonical URL on viewforum.php