aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/search
Commit message (Collapse)AuthorAgeFilesLines
* 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
* Better support for nested transactions...Meik Sievertsen2007-05-051-4/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@7469 89ea8834-ac86-4346-8a33-228a782c2dd0
* - magic urls should have class="postlink", added class="postlink-local" for ↵Nils Adermann2007-04-281-6/+3
| | | | | | | | | | relative magic urls [Bug #9867] run develop/adjust_magic_urls.php to modify your post/sig/pm contents to use class="postlink" - corrected a few bugs in fulltext_mysql stats [Bug #10165] git-svn-id: file:///svn/phpbb/trunk@7424 89ea8834-ac86-4346-8a33-228a782c2dd0
* - removed unneeded code from fulltext_mysql [Bug #9947]Nils Adermann2007-04-221-93/+113
| | | | | | | | - an additional combined index on post_subject and post_text is necessary for fulltext_mysql [Bug #9818] - added phrase searching support to fulltext_mysql while fixing some minor bugs in the keyword processing code, originally intended to do this about a year ago when I switched from split_words array to search_query string in the search backend interface, so finally it's there git-svn-id: file:///svn/phpbb/trunk@7385 89ea8834-ac86-4346-8a33-228a782c2dd0
* can't be negativeDavid M2007-04-211-3/+6
| | | | git-svn-id: file:///svn/phpbb/trunk@7378 89ea8834-ac86-4346-8a33-228a782c2dd0
* forgot to make the actual change :PDavid M2007-04-181-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@7372 89ea8834-ac86-4346-8a33-228a782c2dd0
* #9904David M2007-04-181-0/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@7371 89ea8834-ac86-4346-8a33-228a782c2dd0
* - correctly initialise $words in fulltext_native [Bug #347]Nils Adermann2007-04-091-2/+9
| | | | | | | | | | - display ignored words from sub-search-queries - "Return to search page" [Bug #9591] - spelling in coding guidelines - htmlspecialchars forwarded_for before logging git-svn-id: file:///svn/phpbb/trunk@7310 89ea8834-ac86-4346-8a33-228a782c2dd0
* - urlencoded usernames don't need htmlspecialchars [Bug #8794]Nils Adermann2007-04-011-28/+0
| | | | | | | | | | - fulltext_mysql still used synonyms/ignore words [Bug #5405] - merge tool extend to allow merging complete topics via quickmod and mcp_forum [Bug #5293] - renamed "fork" to "copy" (was already called "copy" in some places) - Copied posts should not increase post count, and should also not decrease it on deletion [Bug #8072] git-svn-id: file:///svn/phpbb/trunk@7261 89ea8834-ac86-4346-8a33-228a782c2dd0
* #5401David M2007-03-311-0/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7252 89ea8834-ac86-4346-8a33-228a782c2dd0
* debug code :-(David M2007-03-311-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7248 89ea8834-ac86-4346-8a33-228a782c2dd0
* the mysql search backend now tries to use mbstring's regex engine if PCRE ↵David M2007-03-311-10/+82
| | | | | | does not have property support git-svn-id: file:///svn/phpbb/trunk@7247 89ea8834-ac86-4346-8a33-228a782c2dd0
* quick fixNils Adermann2007-03-141-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7190 89ea8834-ac86-4346-8a33-228a782c2dd0
* *** empty log message ***David M2007-03-141-8/+15
| | | | git-svn-id: file:///svn/phpbb/trunk@7186 89ea8834-ac86-4346-8a33-228a782c2dd0
* - improvements to search indexing performance, espacially tidy() by adding a ↵Nils Adermann2007-03-131-22/+68
| | | | | | | | | | word_count column, the database update from b5 to next version will take quite a while on bigger databases, I also lowered the default common word threshold from 20 to 5 percent, big boards might want to use 3 or 2 percent, 20 was way too high - added some keys to ACL tables, great improvement of auth query performance - we will only add new language strings to install.php language file and won't modify any, if a language file is updated before phpBB is updated, the updater will not overwrite the user's language with english if install.php was modified git-svn-id: file:///svn/phpbb/trunk@7182 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added a UNIQUE index on the wordmatch tableNils Adermann2007-03-041-2/+4
| | | | | | | | - some modifications of search indexing which might improve the speed and hopefully fixes [Bug #8352] - added logging to search indexing [Bug #8384] git-svn-id: file:///svn/phpbb/trunk@7119 89ea8834-ac86-4346-8a33-228a782c2dd0
* #8074David M2007-02-231-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7041 89ea8834-ac86-4346-8a33-228a782c2dd0
* #8244David M2007-02-221-22/+2
| | | | | | | | - cleaned up the TRUNCATE/DELETE FROM in the native search backend - fixed an imporoper default value on some upgrades git-svn-id: file:///svn/phpbb/trunk@7036 89ea8834-ac86-4346-8a33-228a782c2dd0
* - should fix some Firebird issues ( can't believe that nobody found this ↵David M2007-02-011-3/+35
| | | | | | until now ) git-svn-id: file:///svn/phpbb/trunk@6954 89ea8834-ac86-4346-8a33-228a782c2dd0
* - ignore too short/too long search words [Bug #7438]Nils Adermann2007-01-281-9/+34
| | | | git-svn-id: file:///svn/phpbb/trunk@6944 89ea8834-ac86-4346-8a33-228a782c2dd0
* Display a note, that UTF-8 support in fulltext_mysql is not available with ↵Nils Adermann2007-01-271-0/+22
| | | | | | certain versins of PHP git-svn-id: file:///svn/phpbb/trunk@6941 89ea8834-ac86-4346-8a33-228a782c2dd0
* fixing some bugs, most being submitted grammatical/spelling errors.Meik Sievertsen2007-01-211-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6915 89ea8834-ac86-4346-8a33-228a782c2dd0
* - solved a problem with magic urls inside brackets, and with bbcodes being ↵Nils Adermann2007-01-131-8/+11
| | | | | | | | | | treated as IPv6 addresses - turn NOT IN () and IN () into 1=1 and 1=0 so the database will understand it, instead of throwing an error in sql_in_set [Bug #7118] - some tiny fixes to fulltext_native git-svn-id: file:///svn/phpbb/trunk@6886 89ea8834-ac86-4346-8a33-228a782c2dd0
* - use constants no weird numbers ;-)Nils Adermann2007-01-051-4/+10
| | | | | | | - solved problem with \w using UTF-8 search (fulltext_mysql) by using PCRE unicode character properties if available [Bug #5768] git-svn-id: file:///svn/phpbb/trunk@6843 89ea8834-ac86-4346-8a33-228a782c2dd0