View | Annotate | Download (47.5 KB)
Copy 3.0.x branch to trunk
fix r9713 for #36565
Authorised by: AcydBurn
Fix bug #36565 - Search by authorname does not display posts of guests and deleted users
Authorised by: naderman
Search for 'topic title only' and 'first post' should work again for non-mysql dbms. (Bug #40605)
Fix topic title only and first post search option with the SQL_CALC_FOUND_ROWS fix
erm, forgot to globalize $config. :/
[Change] Performance improvements for native fulltext search (patch by Paul) (This has been tested for 2 weeks in a live environment)
New search option: Maximum number of words allowed to search for. (the more words the more database load)
not quite
Use a left join for the topics table on search to avoid trouble with FROM syntax on some databases (Bug #37005)
Tell users to recreate the search index after changing the common word threshold for fulltext_native (Bug #36345)
cleanup, related to bug #19195
Fix native full text search on postgresql while using excluding keyword matches. (Bug #19195)
Topic searches by author no longer return invalid results [Bug #11777]
removed executable props [Bug #6464]
Hiding everywhere little buggers, eh?
This commit was manufactured by cvs2svn to create branch 'phpBB-3_0_0'.
dumdidum... sorry. ;)
err, forgot to commit
a little comment
#13579 This changes the signature of author_search. Search backends will need adjustment.
label changes, language fixes...
- correctly transfer the search query across search result pages - 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]...
Better support for nested transactions...
can't be negative
- correctly initialise $words in fulltext_native [Bug #347] - display ignored words from sub-search-queries - "Return to search page" [Bug #9591] - spelling in coding guidelines - htmlspecialchars forwarded_for before logging
quick fix
- improvements to search indexing performance, espacially tidy() by adding a 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 a UNIQUE index on the wordmatch table - some modifications of search indexing which might improve the speed and hopefully fixes [Bug #8352] - added logging to search indexing [Bug #8384]
#8074
#8244 - cleaned up the TRUNCATE/DELETE FROM in the native search backend - fixed an imporoper default value on some upgrades
- should fix some Firebird issues ( can't believe that nobody found this until now )
- ignore too short/too long search words [Bug #7438]
fixing some bugs, most being submitted grammatical/spelling errors.
- solved a problem with magic urls inside brackets, and with bbcodes being 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
- display search type as page title for premade searches [Bug #6508] - flash enabled on user side by default, so that admins can actually change anything by activating it (still disabled by default) - properly implemented password complexity check [Bug #6584]...
#6414
- author search should use clean names for searching [Bug #5752] - local moderators are moderators too! - don't show a "word is not contained in any post" message for ignored common words - bold search words in search error messages [Bug #5762]
#5610
adjust some comments to work with phpdocumentor. :)
- fixes for the following bugs: #5326 #5318 #5304 #5290 #5288 #5278 #5276 #5272 #5266 - also fixed the "Call-time pass-by-reference" bug #5252 - within this step changed the normalize calls to require references. - added captcha size variables to the class scope (suggestion was posted at area51)
keywords is a string...
- Bug #5090
ok, i am an idiot...
Revised attachment categories a bit Fixes for the following bugs: #4830 #4818 #4816 #4810 #4808 #4798 #4796 #4772 #4662 #4646 #4546 #4524 #4270
I hope not having introduced additional severe errors :)
- store sql_layer directly within the layer itself - new method sql_multi_insert to circumvent db-specific hacks (hopefully not introduced any parsing errors)
- introducing clean usernames, needs to be tested more, I'm not sure I didn't miss anything - homograph list should probably be extended
tried to begin adjusting all string functions where applicable - still a lot to do. i hope i catched all relevant sections and did not mess something up.
- forgot to make the same change to the ODBC driver - MySQL 3.x works now - FirebirdSQL is now on the same level as MySQL and PostgreSQL, zero hacks exist inside the core code now
- no more encoding mixture, say hello to UTF-8 (I'll add a validation solution for PHP 4.3.3/4 ASAP) [side effect: fixes Bug #3762] - take local server time into consideration for birthday/age calculation - faster active topic search - allow changing active topic time frame [Bug #4150]...
- birthdays/age in user's timezone and not server's local time - parse bbcode in posts with fewer characters than selected maximum on search results page - retrieve search word context in posts which are longer than maximum characters (no raw BBCode anymore)...
we don't want all topics when searching for just a few\!
m_approve_fid should be negated
sql_in_set changes
- fixed some problems with themes - added support for {IMG_NAME_SRC}, {IMG_NAME_WIDTH} and {IMG_NAME_HEIGHT} - fulltext_native has to use group by in a few more quries
- acm_file uses an index pointer to the current row instead of shifting the result array now [Bug #2451] - all dbals adjusted to use the cache in sql_fetchfield, sql_rowseek, sql_numrows and sql_freeresult [Bug #2451] - use include_once for dbal.php to at least theoretically allow connections to multiple databases at once...
- fixed the age calculation (note: turn on your brain before commiting something like this the next time) [Bug #3337] - removed the split_words array, introduced an enforced search_query - the forum used for global topics in the search is now a forum, and no longer a category [Bug #2561]...
Fixed: bug #3243
Fixed: forgot to remove some debug code :(
Fixed: bug #3191 take two. That one should work as expected.
Fixed: bug #3191 as per NeoThermic's patch
- fix a stupid bug in style.php - and we'd also like the post encoding :D
- fixed a parse error (oops) - pass forum_ids to search indexing functions - fixed a bug in fulltext_native's cache destroying
- display age in user profile and make it available on viewtopic - various tiny bugfixes including [Bug #2351] [Bug #2549] [Bug #2681] [Bug #3015] - strip first, then change newlines [Bug #2403] - added support for creating user profiles to the login function (makes use of user_add), triggered by LOGIN_SUCCESS_CREATE_PROFILE constant...
Changed: moved the thing that compares the amount of matches to the amount of terms from outside the query (in PHP) to inside of it, thanks to a well-placed HAVING clause
- proper redirect after deleting a report [Bug #2260] - sql_escape words before fulltext update - correct language string for "search facilities" in acp_search
- removed db cache (might re-appear, but for now we do not see the need for it) - all changes to styles/subsilver/template are purely cosmetic (no functional changes) - cosmetics - bugfixes - add index to modules table - use modules ordering code for forums too
make sure custom profile fields are created correctly on registration (#2225)
ok, sorry for this. :/ - cleaned up table names/constants
- add support for min/max of numerical search backend settings - change word_text maximum length - don't update search settings if nothing was changed
- added search by author_id to solve problems with looking up posts of users with a name containing wildcards - user based flood control (seperate limits for users and guests) [Bug #1357] - inform the user about ignored words if he receives a "no words specified" message...
- fix a nasty bug in search indexing
- actually let the user import smilies/icons paks. ;) - fix TRUNCATE TABLE syntax (mssql does not understand TRUNCATE alone)
- added a few missing log variables - include acp/common.php language file if displaying logs (LOG_ variables should be stored there only now) - added check to cron.php - added database_gc config variable - recalculate binary trees every once a week ;)
- allow searches for multibyte characters in fulltext_native - use preg_quote safely
Renaming fulltext_phpbb to fulltext_native for clarity and changing a few variables