00001 <?php 00002 /* 00003 +-----------------------------------------------------------------------------+ 00004 | ILIAS open source | 00005 +-----------------------------------------------------------------------------+ 00006 | Copyright (c) 1998-2001 ILIAS open source, University of Cologne | 00007 | | 00008 | This program is free software; you can redistribute it and/or | 00009 | modify it under the terms of the GNU General Public License | 00010 | as published by the Free Software Foundation; either version 2 | 00011 | of the License, or (at your option) any later version. | 00012 | | 00013 | This program is distributed in the hope that it will be useful, | 00014 | but WITHOUT ANY WARRANTY; without even the implied warranty of | 00015 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | 00016 | GNU General Public License for more details. | 00017 | | 00018 | You should have received a copy of the GNU General Public License | 00019 | along with this program; if not, write to the Free Software | 00020 | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. | 00021 +-----------------------------------------------------------------------------+ 00022 */ 00023 00035 include_once 'Services/Search/classes/class.ilMediaPoolSearch.php'; 00036 00037 class ilFulltextMediaPoolSearch extends ilMediaPoolSearch 00038 { 00039 00044 function ilFulltextMediaPoolSearch(&$qp_obj) 00045 { 00046 parent::ilMediaPoolSearch($qp_obj); 00047 } 00048 00049 function __createAndCondition() 00050 { 00051 // IN BOOLEAN MODE 00052 if($this->db->isMysql4_0OrHigher()) 00053 { 00054 $query .= " AND MATCH(title,description) AGAINST('"; 00055 foreach($this->query_parser->getQuotedWords(true) as $word) 00056 { 00057 $query .= $word; 00058 $query .= '* '; 00059 } 00060 $query .= "' IN BOOLEAN MODE) "; 00061 } 00062 else 00063 { 00064 // i do not see any reason, but MATCH AGAINST(...) OR MATCH AGAINST(...) does not use an index 00065 $query .= " AND MATCH (title,description) AGAINST(' "; 00066 foreach($this->query_parser->getQuotedWords(true) as $word) 00067 { 00068 $query .= $word; 00069 $query .= ' '; 00070 } 00071 $query .= "') "; 00072 } 00073 return $query; 00074 } 00075 } 00076 ?>