Dear Mr. Klein,

did I understand you right that, in order to enable substring search in MediaWiki, one does not have to change anything else than adding the php-file and changing the local settings as you recommended in the last posting?

I had to change two lines where you made references to „SearchMySQL“ to „SearchMySQL4“. After that the Wiki worked, but the behaviour of the search didn´t change. I still cannot use „*“ or other wild cards.

Do I have to change anything else to make your suggestion work?

Thanks very much in advance for your help.

Regards / mit freundlichen Gruessen

Sebastian Dosch

sebastian.dosch@depre.de

-------------------You wrote:-----------------------

Message: 8

Date: Wed, 28 Sep 2005 12:32:16 +0200

From: Klein.Thomas@eae.com

Subject: RE: [Mediawiki-l] mediawiki 1.4 & 1.5rc4, substring search,

how?

To: mediawiki-l@Wikimedia.org

Message-ID:

<OF2A6BE39F.59E045B1-ONC125708A.003933F9-C125708A.0039E2F7@eae.com>

Content-Type: text/plain; charset=ISO-8859-1

Now, here is the class for substring search without to change the source

and MySQL4!

The class SearchMySQL4SubString is a copy of SearchMySQL4.

Make a new file in subdir 'includes' with this name 'SearchMySQL4SubString'

and copy

the next code into this file:

<?php

/**

• Search engine hook for MySQL 4+

• @package MediaWiki

• @subpackage Search

*/

require_once( 'SearchMySQL.php' );

/**

• @package MediaWiki

• @subpackage Search

*/

class SearchMySQL4SubString extends SearchMySQL {

 var $strictMatching = true;

 /** @todo document */

 function SearchMySQL4SubString( &$db ) {

       $this->db =& $db;

 }

 function legalSearchChars() {

       return "A-Za-z_'0-9\\x80-\\xFF\\-*?+";

 }

 /** @todo document */

 function parseQuery( $filteredText, $fulltext ) {

       global $wgContLang;

       $lc = SearchEngine::legalSearchChars();

       $searchon = '';

       $this->searchTerms = array();

       wfDebug( "parseQuery filteredText is: '$filteredText'\n" );

       wfDebug( "parseQuery fulltext is: '$fulltext'\n" );

       # FIXME: This doesn't handle parenthetical expressions.

       if( preg_match_all( '/([-+<>~]?)(([' . $lc .

']+)(*?)|"[^"]*")/',

               $filteredText, $m, PREG_SET_ORDER ) ) {

             foreach( $m as $terms ) {

                   if( $searchon !== '' ) $searchon .= ' ';

                   $searchon .= $terms[1] .

$wgContLang->stripForSearch( $terms[2] );

                   if( !empty( $terms[3] ) ) {

                         $regexp = preg_quote( $terms[3], '/' );

                         if( $terms[4] ) $regexp .= "[0-9A-Za-z_]+";

                   } else {

                         $regexp = preg_quote( str_replace( '"', '',

$terms[2] ), '/' );

                   }

                   $this->searchTerms[] = $regexp;

             }

             wfDebug( "Would search with '$searchon'\n" );

             wfDebug( "Match with /\b" . implode( '\b|\b',

$this->searchTerms ) . "\b/\n" );

       } else {

             wfDebug( "Can't understand search query

'{$this->filteredText}'\n" );

       }

       $searchon = $this->db->strencode( $searchon );

       $field = $this->getIndexField( $fulltext );

       return " MATCH($field) AGAINST('$searchon' IN BOOLEAN MODE) ";

 }

}

?>

And add to lines into your 'LocalSettings.php':

require_once( 'SearchMySQL4SubString.php' );

$wgSearchType = SearchMySQL4SubString;

Now the search function have the same syntax of MySQL4.

Also, see http://dev.mysql.com/doc/mysql/en/fulltext-boolean.html for

details

about full text sql queries in MySQL.

Mit freundlichen Gr|ssen / Kind regards

i.A. Thomas Klein

OPS Koordination / OPS coordination

EAE software GmbH

Kornkamp 8

22926 Ahrensburg/Germany

Tel : +49 4102/480-513

Fax: +49 4102/480-561

e-mail: mailto:klein.thomas@eae.com

http://www.eae.com/