root / trunk / phpBB / includes / search / fulltext_mysql.php

View | Annotate | Download (25.8 KB)

  • svn:eol-style: LF
  • svn:keywords: Author Date Id Revision
# Date Author Comment
10211 10/04/2009 07:14 PM Meik Sievertsen

Copy 3.0.x branch to trunk

10075 08/31/2009 01:07 PM Meik Sievertsen

correct method comment

9931 08/05/2009 04:28 PM Joas Schilling

fix r9713 for #36565

Authorised by: AcydBurn

9713 07/02/2009 10:28 AM Joas Schilling

Fix bug #36565 - Search by authorname does not display posts of guests and deleted users

Authorised by: naderman

9438 04/11/2009 11:09 AM Meik Sievertsen

New search option: Maximum number of words allowed to search for.
(the more words the more database load)

8814 09/04/2008 02:01 PM Meik Sievertsen

Ok, story real database server info, as well as caching it
Store it on installation too - allows us to check the db version used on installation and used currently to warn the user about incompatibilities

8604 06/04/2008 07:25 PM Nils Adermann

Topic searches by author no longer return invalid results [Bug #11777]

8479 03/29/2008 01:22 AM Nils Adermann

Hiding everywhere little buggers, eh?

8285 12/26/2007 03:53 PM

This commit was manufactured by cvs2svn to create branch 'phpBB-3_0_0'.

8257 11/29/2007 07:26 PM David M

#15524

8147 10/05/2007 04:36 PM Meik Sievertsen

dumdidum... sorry. ;)

7930 07/23/2007 07:03 PM Henry Sudhof

#13579
This changes the signature of author_search. Search backends will need adjustment.

7925 07/23/2007 06:14 AM David M

- a better way of checking PCRE property support
- fixed the naming of a variable or two

7736 06/09/2007 01:11 PM Meik Sievertsen

ok, mess around with the templates + fixing some bugs + adjusting headers for those files already modified to circumvent conflicts for those having their editor set to remove trailing spaces (not recommended!)

7675 05/25/2007 02:22 PM David M

#11637

7424 04/28/2007 11:16 PM Nils Adermann

- magic urls should have class="postlink", added class="postlink-local" for 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]

7385 04/22/2007 07:12 PM Nils Adermann

- removed unneeded code from fulltext_mysql [Bug #9947]
- 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

7372 04/18/2007 11:11 PM David M

forgot to make the actual change :P

7371 04/18/2007 10:21 PM David M

#9904

7261 04/02/2007 12:15 AM Nils Adermann

- urlencoded usernames don't need htmlspecialchars [Bug #8794]
- 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)...

7252 03/31/2007 07:33 PM David M

#5401

7248 03/31/2007 04:42 PM David M

debug code :-(

7247 03/31/2007 04:36 PM David M

the mysql search backend now tries to use mbstring's regex engine if PCRE does not have property support

6941 01/27/2007 06:38 PM Nils Adermann

Display a note, that UTF-8 support in fulltext_mysql is not available with certain versins of PHP

6843 01/05/2007 10:17 PM Nils Adermann

- use constants no weird numbers ;-)
- solved problem with \w using UTF-8 search (fulltext_mysql) by using PCRE unicode character properties if available [Bug #5768]

6797 12/23/2006 07:49 PM David M

#6520

6774 12/16/2006 09:24 PM Nils Adermann

- Optimize acl_getf_global a bit
- a little performance improvement of the IP regular expressions
- convert post_text/subject collation to utf8_unicode_ci if a user wants to use mysql_fulltext to allow case insensitivity [Bug #6272]
- mysql_fulltext should alter all necessary columns at once to speed up the process...

6740 12/10/2006 06:44 PM Nils Adermann

- finally correctly calculate current time for birthday calculation [Bug #6030]
- allow searching forums with unsearchable subforums [Bug #6056]
- addition of an optional HTTP_X_FORWARDED_FOR check in sessions, including bans
- do not index forums which have indexing disabled on index recreation [Bug #6060]...

6674 11/27/2006 08:32 PM Meik Sievertsen

#5610

6595 11/17/2006 08:37 PM Meik Sievertsen

adjust some comments to work with phpdocumentor. :)

6497 10/14/2006 04:56 PM Meik Sievertsen

- store sql_layer directly within the layer itself
- new method sql_multi_insert to circumvent db-specific hacks
(hopefully not introduced any parsing errors)

6452 10/07/2006 02:36 PM Meik Sievertsen

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.

6380 09/18/2006 12:02 AM Nils Adermann

- 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]...

6273 08/12/2006 04:58 PM Nils Adermann

m_approve_fid should be negated

6271 08/12/2006 03:14 PM Meik Sievertsen

sql_in_set changes

6216 07/30/2006 04:09 PM Nils Adermann

- removed an accidentaly pasted line [Bug #3227]
- added missing images to acp_styles [Bug #2623] and added a new image btn_warn
- use the style name when exporting a style instead of the non existant path [Bug #2343]
- fixed an incorrect call of acp_styles::install_style() [Bug #2325]...

6211 07/27/2006 09:02 PM Nils Adermann

- 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]...

6153 07/07/2006 10:38 PM Nils Adermann

- fix a stupid bug in style.php
- and we'd also like the post encoding :D

6152 07/07/2006 08:43 PM Nils Adermann

- fixed a parse error (oops)
- pass forum_ids to search indexing functions
- fixed a bug in fulltext_native's cache destroying

6073 06/16/2006 06:54 PM Meik Sievertsen

- 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

6058 06/13/2006 11:06 PM Meik Sievertsen

make sure custom profile fields are created correctly on registration (#2225)

6021 06/07/2006 09:32 PM Meik Sievertsen

ok, sorry for this. :/
- cleaned up table names/constants

5981 05/28/2006 09:06 PM Nils Adermann

- 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...

5967 05/26/2006 05:04 PM Meik Sievertsen

some tiny changes...

5944 05/20/2006 04:20 PM Meik Sievertsen

- actually let the user import smilies/icons paks. ;)
- fix TRUNCATE TABLE syntax (mssql does not understand TRUNCATE alone)

5929 05/18/2006 08:18 PM Meik Sievertsen

- 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 ;)

5858 04/29/2006 03:18 AM Meik Sievertsen

- fixing some bugs, containing fixes for anonymous username displays, eaccelerator issue, permission trace and a few smaller bugs.

5837 04/23/2006 03:10 PM Nils Adermann

- properly check the Comment column on older MySQL versions [Bug #1637]

5727 03/26/2006 03:36 AM Nils Adermann

- correctly use DISTINCT and GROUP BY in search related SQL [Bug #1256]
- always display views and replies in search results [Bug #1223]
- display error messages occuring during search index creation/deletion [Bug #1274]
- correctly align the ACP link on the search results page [Bug #1160]...

5699 03/22/2006 06:30 PM Meik Sievertsen

adjusting sql_freeresult a bit as well as our error handler (it now prints out if it is because of DEBUG_EXTRA being defined - which is not enabled within the betas/rc's and stable releases).

5670 03/19/2006 03:23 PM Meik Sievertsen

- add our beloved in_phpbb check

5652 03/18/2006 03:30 PM Nils Adermann

- Lesson learned: If you rename something rename it in all places and not just in a few :)
(min_search_chars/max_search_chars/load_search_upd now prefixed with fulltext_phpbb)
- search_indexing_state should not be dynamic
- a topic link should link to a topic ;-)

5639 03/16/2006 05:22 PM Nils Adermann

- use a_search permission
- check for MyISAM in fulltext_mysql

5636 03/16/2006 12:20 AM Nils Adermann

- removed search settings from load page
- no need to retrieve mysql information on every page => removed (fulltext_mysql)
- added init() method to search plugins which is called when the search backend is changed
- optional create/delete index functions for methods which don't need to loop through all posts (like fulltext_mysql)...

5607 03/06/2006 07:21 PM Nils Adermann

Me, me, me!

- only search unapproved posts/topics in forums where the user got the m_approve permission
- resize the search cache when it grows too huge (drop distant pages)
- added unread link to search results page
- streamlined search results and viewforum html code for displaying topics...

5593 02/28/2006 07:15 PM Nils Adermann

CVS commit mail test

5488 01/22/2006 08:13 PM Nils Adermann

- added fulltext_mysql
- sort search results by topic author, not topic author id
- topic tracking on search results page
- dotted topics on search results page
- links to global announcements fixed

5236 10/02/2005 06:48 PM Meik Sievertsen

- checking in pauls (psoTFX) search changes (with tiny adjustments from me)

5114 04/09/2005 02:26 PM Meik Sievertsen

- Documentation related changes
- added resend activation email dialog
- fixed issue in session code
- log failed/successful admin re-authentication/login
- fixed simple forum dropdown box (used in mcp and posting)

5060 01/13/2005 11:30 PM psotfx

These aren't the search files you're looking for ... I can go about my business ... move along ...