aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/search
Commit message (Collapse)AuthorAgeFilesLines
* Merge remote-tracking branch 'dhruvgoel92/ticket/11288' into develop-olympusJoas Schilling2014-03-111-0/+6
|\ | | | | | | | | * dhruvgoel92/ticket/11288: [ticket/11288] Handle +,- without preceeding whitespace characters
| * [ticket/11288] Handle +,- without preceeding whitespace charactersDhruv2013-10-051-0/+6
| | | | | | | | PHPBB3-11288
* | [ticket/10945] Fix return values for split_keywords functionDhruv2014-03-081-14/+8
| | | | | | | | | | | | | | The function now returns false if all the words are common words and true otherwise. PHPBB3-10945
* | [ticket/10945] Display search query when search fails in native searchDhruv2014-03-081-18/+11
|/ | | | | | | | | | If search fails and common words are present, split_keywords returns false and search.php file prints appropriate message of common words. If search fails and there are no common words, split_keywords returns true and keyword_search returns false so that the search query is displayed in search box. PHPBB3-10945
* [ticket/11583] Use a new lang key instead of giving the old one a new meaning.Andreas Fischer2013-06-031-1/+1
| | | | PHPBB3-11583
* [ticket/11583] Allow FULLTEXT indexes on InnoDB when on MySQL 5.6.4 or higher.Andreas Fischer2013-06-011-1/+8
| | | | PHPBB3-11583
* [ticket/9551] uncomment line and change length to 255Dhruv Goel2012-06-191-1/+1
| | | | | | | incase of partial collation change post_subject field will be changed back to the default collation and length 255. PHPBB3-9551
* [ticket/9813] Only get posts table row count if we detected a fulltext index.Andreas Fischer2012-03-081-1/+1
| | | | PHPBB3-9813
* [ticket/9813] Also use estimated row count of posts table for fulltext mysql.Andreas Fischer2012-03-051-5/+1
| | | | | | | | Since this is 'only' for statistics anyway, using an estimated value does no harm. Also, if MyISAM is the underlying storage engine for the posts table, the value will actually be exact. PHPBB3-9813
* [ticket/10653] Add ability to count table rows to database abstraction layer.Andreas Fischer2012-03-031-44/+2
| | | | PHPBB3-10653
* [ticket/9813] Use table status row count only if greater than 100000 or exact.Andreas Fischer2012-03-031-26/+41
| | | | PHPBB3-9813
* [ticket/9813] Use SHOW TABLE STATUS to get search stats for native on MySQL.Andreas Fischer2012-03-031-10/+28
| | | | PHPBB3-9813
* [ticket/10630] Use sql_like_expression() method instead of hardcoded LIKE '%x%'Joas Schilling2012-02-201-1/+1
| | | | PHPBB3-10630
* [ticket/10630] Perform array_unique on authors array before creating the queryJoas Schilling2012-02-202-2/+2
| | | | | | | This is needed to avoid an additional appearance for an author for every post he made. PHPBB3-10630
* [ticket/9595] List min/max characters indexed by search for mysql_fulltext.Andreas Fischer2010-10-211-0/+8
| | | | PHPBB3-9595
* Merge branch 'ticket/cs278/9760' into develop-olympusAndreas Fischer2010-08-101-1/+12
|\ | | | | | | | | * ticket/cs278/9760: [ticket/9760] Remove unrestricted wildcards from search terms.
| * [ticket/9760] Remove unrestricted wildcards from search terms.Chris Smith2010-08-081-1/+12
| | | | | | | | | | | | | | | | Wildcards without any further result restrictions will cause phpBB to search for everything, potentially allowing a DoS attack against the DB server by any user who can use the search system. PHPBB3-9760
* | [ticket/9749] Fulltext mysql unexpected behavior on entering a dash in queryJosh Woody2010-07-291-1/+1
|/ | | | | | | | | The Fulltext_mysql class had different behavior when a dash was entered in the search query than the fulltext_native class. Specifically, a dash was automatically turned into boolean NOT even when the user wanted to search for legitimate hyphenated words like farty-pants PHPBB3-9749
* Safe us some more calls to $db->sql_escape().Andreas Fischer2010-01-112-4/+4
| | | | | | | Authorised by: naderman :-P git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10399 89ea8834-ac86-4346-8a33-228a782c2dd0
* Improved search query performance through sorting words by their occurance. ↵Nils Adermann2009-12-231-8/+13
| | | | | | [Bug #21555] git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10377 89ea8834-ac86-4346-8a33-228a782c2dd0
* Bug #54325 - Fulltext-MySQL search for keywords and username at the same ↵Joas Schilling2009-11-261-1/+1
| | | | | | | | | time. (Regression from r9931) Authorised by: bantu git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10292 89ea8834-ac86-4346-8a33-228a782c2dd0
* correct method commentMeik Sievertsen2009-08-311-4/+17
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10075 89ea8834-ac86-4346-8a33-228a782c2dd0
* fix r9713 for #36565Joas Schilling2009-08-052-8/+4
| | | | | | Authorised by: AcydBurn git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9931 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix bug #36565 - Search by authorname does not display posts of guests and ↵Joas Schilling2009-07-022-40/+87
| | | | | | | | | deleted users Authorised by: naderman git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9713 89ea8834-ac86-4346-8a33-228a782c2dd0
* Search for 'topic title only' and 'first post' should work again for ↵Meik Sievertsen2009-04-181-0/+8
| | | | | | non-mysql dbms. (Bug #40605) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9473 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix topic title only and first post search option with the ↵Meik Sievertsen2009-04-181-6/+6
| | | | | | SQL_CALC_FOUND_ROWS fix git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9472 89ea8834-ac86-4346-8a33-228a782c2dd0
* erm, forgot to globalize $config. :/Meik Sievertsen2009-04-181-1/+1
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9471 89ea8834-ac86-4346-8a33-228a782c2dd0
* [Change] Performance improvements for native fulltext search (patch by Paul)Meik Sievertsen2009-04-111-3/+19
| | | | | | (This has been tested for 2 weeks in a live environment) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9440 89ea8834-ac86-4346-8a33-228a782c2dd0
* New search option: Maximum number of words allowed to search for.Meik Sievertsen2009-04-112-3/+16
| | | | | | (the more words the more database load) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9438 89ea8834-ac86-4346-8a33-228a782c2dd0
* not quiteNils Adermann2008-12-041-1/+1
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9173 89ea8834-ac86-4346-8a33-228a782c2dd0
* Use a left join for the topics table on search to avoid trouble with FROM ↵Nils Adermann2008-12-041-11/+12
| | | | | | syntax on some databases (Bug #37005) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9172 89ea8834-ac86-4346-8a33-228a782c2dd0
* Tell users to recreate the search index after changing the common word ↵Nils Adermann2008-11-261-1/+1
| | | | | | threshold for fulltext_native (Bug #36345) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9126 89ea8834-ac86-4346-8a33-228a782c2dd0
* cleanup, related to bug #19195Meik Sievertsen2008-09-181-2/+0
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8879 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix native full text search on postgresql while using excluding keyword ↵Meik Sievertsen2008-09-181-3/+6
| | | | | | matches. (Bug #19195) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8878 89ea8834-ac86-4346-8a33-228a782c2dd0
* Ok, story real database server info, as well as caching itMeik Sievertsen2008-09-041-2/+2
| | | | | | Store it on installation too - allows us to check the db version used on installation and used currently to warn the user about incompatibilities git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8814 89ea8834-ac86-4346-8a33-228a782c2dd0
* The same way we allow defining a custom template/style path we now allow ↵Meik Sievertsen2008-08-231-4/+4
| | | | | | | | | | this for languages too. This will allow applications to define their own language folder for certain parts for example. Callable by $user->set_custom_lang_path({new_path}) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8782 89ea8834-ac86-4346-8a33-228a782c2dd0
* Topic searches by author no longer return invalid results [Bug #11777]Nils Adermann2008-06-042-5/+5
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8604 89ea8834-ac86-4346-8a33-228a782c2dd0
* removed executable props [Bug #6464]Nils Adermann2008-06-042-0/+0
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8598 89ea8834-ac86-4346-8a33-228a782c2dd0
* #15524David M2007-11-291-2/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8257 89ea8834-ac86-4346-8a33-228a782c2dd0
* dumdidum... sorry. ;)Meik Sievertsen2007-10-053-7/+10
| | | | git-svn-id: file:///svn/phpbb/trunk@8147 89ea8834-ac86-4346-8a33-228a782c2dd0
* err, forgot to commitMeik Sievertsen2007-07-271-4/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@7961 89ea8834-ac86-4346-8a33-228a782c2dd0
* a little commentHenry Sudhof2007-07-231-0/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7931 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13579Henry Sudhof2007-07-232-5/+15
| | | | | | | This changes the signature of author_search. Search backends will need adjustment. git-svn-id: file:///svn/phpbb/trunk@7930 89ea8834-ac86-4346-8a33-228a782c2dd0
* - a better way of checking PCRE property supportDavid M2007-07-231-1/+5
| | | | | | | - fixed the naming of a variable or two git-svn-id: file:///svn/phpbb/trunk@7925 89ea8834-ac86-4346-8a33-228a782c2dd0
* tweak the sql_like_expression feature a little bit to allow correct escapingMeik Sievertsen2007-06-241-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7789 89ea8834-ac86-4346-8a33-228a782c2dd0
* new wrapper for LIKE expressions to streamline the fixes. We actually need ↵Meik Sievertsen2007-06-231-1/+1
| | | | | | to adjust them for different DBMS as well as SQLite2 not supporting escaping characters in LIKE statements (which is a reason why we think about dropping sqlite support completely). git-svn-id: file:///svn/phpbb/trunk@7788 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, mess around with the templates + fixing some bugs + adjusting headers ↵Meik Sievertsen2007-06-091-3/+3
| | | | | | for those files already modified to circumvent conflicts for those having their editor set to remove trailing spaces (not recommended!) git-svn-id: file:///svn/phpbb/trunk@7736 89ea8834-ac86-4346-8a33-228a782c2dd0
* #11637David M2007-05-251-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7675 89ea8834-ac86-4346-8a33-228a782c2dd0
* label changes, language fixes...Meik Sievertsen2007-05-161-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7608 89ea8834-ac86-4346-8a33-228a782c2dd0
* - correctly transfer the search query across search result pagesNils Adermann2007-05-131-0/+1
| | | | | | | | | | | | | - changed highlighting so foo* will match foo again [Bug #10031] - restructured magic urls (functionality still mostly the same), added a check for entities in urls and punctuation at the end of magic urls [Bugs #10639, #10293] - undid the workaround for urls in quotes, as it's fixed by the new magic url handling - allow magic urls enclosed in BBCode [Bug #10319] - added handling for IPv6 addresses to the IP checking without adding extra options [Bug #9538] - correctly handle search in search results of search queries with brackets [Bug #10581] - added information about requirements for auth_apache [Bug #10107] git-svn-id: file:///svn/phpbb/trunk@7559 89ea8834-ac86-4346-8a33-228a782c2dd0