function update_attach($m)
	{
		global $db;

		$sql = 'SELECT upload_id
				FROM fsb2_upload
				WHERE upload_filename = \'' . $db->escape($m[1]) . '\'';
		$result = $db->query($sql);
		if ($row = $db->row($result))
		{
			$db->free($result);
			return ('[attach=' . $row['upload_id'] . ']');
		}
		$db->free($result);
		return ($m[0]);
	}

	function update_attach2($m)
	{
		global $db;

		$sql = 'SELECT upload_id
				FROM fsb2_upload
				WHERE upload_filename = \'' . $db->escape($m[2]) . '\'';
		$result = $db->query($sql);
		if ($row = $db->row($result))
		{
			$db->free($result);
			return ('index.php?p=download&id=' . $row['upload_id']);
		}
		$db->free($result);
		return ($m[0]);
	}

	$sql = 'SELECT p_id, p_text
			FROM fsb2_posts
			ORDER BY p_id';
	$result = $db->query($sql);
	while ($row = $db->row($result))
	{
		if (preg_match('#\[attach=(.*?)\]#i', $row['p_text']))
		{
			$row['p_text'] = preg_replace_callback('#\[attach=(.*?)\]#i', 'update_attach', $row['p_text']);
			$row['p_text'] = preg_replace_callback('#index\.php\?p=download&(amp;)?file=([a-z0-9 _\-]*?\.[a-z]{2,5})#i', 'update_attach2', $row['p_text']);
			$sql = 'UPDATE fsb2_posts SET p_text = \'' . $db->escape($row['p_text']) . '\' WHERE p_id = ' . $row['p_id'];
			$db->query($sql);
		}
	}
	$db->free($result);

	$step = 2;
}

?>