View file upload/library/XenForo/Model/RouteFilter.php

<?php

class XenForo_Model_RouteFilter extends XenForo_Model
{
	public function getRouteFilterById($id)
	{
		return $this->_getDb()->fetchRow('
			SELECT *
			FROM xf_route_filter
			WHERE route_filter_id = ?
		', $id);
	}

	public function getRouteFilters($routeType)
	{
		return $this->fetchAllKeyed('
			SELECT *
			FROM xf_route_filter
			WHERE route_type = ?
			ORDER BY find_route
		', 'route_filter_id', $routeType);
	}

	public function getRouteFiltersForCache()
	{
		$results = $this->_getDb()->query("
			SELECT *
			FROM xf_route_filter
			WHERE route_type = 'public' AND enabled = 1
			ORDER BY LENGTH(replace_route) DESC
		");
		$in = array();
		while ($res = $results->fetch())
		{
			list($from, $to) = XenForo_Link::translateRouteFilterToRegex(
				urldecode($res['replace_route']), urldecode($res['find_route'])
			);

			$in[$res['route_filter_id']] = array(
				'match_regex' => $from,
				'match_replace' => $to,
			);
		}

		$results = $this->_getDb()->query("
			SELECT *
			FROM xf_route_filter
			WHERE route_type = 'public'
				AND enabled = 1
				AND url_to_route_only = 0
			ORDER BY prefix, LENGTH(find_route) DESC
		");
		$out = array();
		while ($res = $results->fetch())
		{
			list($from, $to) = XenForo_Link::translateRouteFilterToRegex(
				$res['find_route'], $res['replace_route']
			);

			$out[$res['prefix']][$res['route_filter_id']] = array(
				'match_regex' => $from,
				'match_replace' => $to,
			);
		}

		return array(
			'in' => $in,
			'out' => $out
		);
	}

	public function rebuildRouteFilterCache()
	{
		$routeFilters = $this->getRouteFiltersForCache();
		$this->_getDataRegistryModel()->set('routeFiltersIn', $routeFilters['in']);
		$this->_getDataRegistryModel()->set('routeFiltersOut', $routeFilters['out']);

		return $routeFilters;
	}
}