Code: Select all
[url=https://www.someTLD.com/folder/someHTMLpage_12345.html]Some Text[/url]
Code: Select all
[url=https://www.someTLD.com/folder/someHTMLpage_12345.html]Some Text[/url]
Code: Select all
[url=https://www.someTLD.com/folder/someHTMLpage_12345.html]Some Text[/url]
Code: Select all
[url=https://www.someTLD.com/folder/someHTMLpage_67890.html]Some Text[/url]
Strange. But it does not work on my board. So I catched the SQL statement from includes/search/fulltext_mysql.php and entered it "by hand" on phpAdmin. It was
Code: Select all
SELECT p.post_id FROM phpbb_posts p WHERE MATCH (p.post_subject, p.post_text) AGAINST ('+12345 ' IN BOOLEAN MODE) AND (p.post_approved = 1 OR p.forum_id NOT IN (13, 15, 17, 18, 25, 26, 27, 32, 37, 38, 39, 44, 47, 51, 56, 63, 64, 68, 69, 70, 71, 72, 73, 76, 77, 78, 80, 87, 89, 95, 97, 99, 103)) ORDER BY p.post_time DESC
Code: Select all
SELECT p.post_id FROM phpbb_posts p WHERE p.post_text LIKE '%12345%' AND (p.post_approved = 1 OR p.forum_id NOT IN (13, 15, 17, 18, 25, 26, 27, 32, 37, 38, 39, 44, 47, 51, 56, 63, 64, 68, 69, 70, 71, 72, 73, 76, 77, 78, 80, 87, 89, 95, 97, 99, 103)) ORDER BY p.post_time DESC