History | View | Annotate | Download (48 kB)
commit d66aadc33fe8260b206222c9bf19d526f8372ee1Merge: 19599b4 76348ceAuthor: Andreas Fischer <bantu@phpbb.com>Date: Tue Aug 10 16:04:49 2010 +0200
Merge branch 'ticket/cs278/9760' into develop-olympus
Safe us some more calls to $db->sql_escape().Authorised by: naderman :-P
Improved search query performance through sorting words by their occurance. [Bug #21555]
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
#13579This 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 bitFixes 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
