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 00034 include_once 'Services/Search/classes/class.ilMediaCastSearch.php'; 00035 00036 class ilFulltextMediaCastSearch extends ilMediaCastSearch 00037 { 00038 00043 function ilFulltextMediaCastSearch(&$qp_obj) 00044 { 00045 parent::ilMediaCastSearch($qp_obj); 00046 } 00047 00048 function __createWhereCondition() 00049 { 00050 // IN BOOLEAN MODE 00051 if($this->db->isMysql4_0OrHigher()) 00052 { 00053 $query .= " WHERE context_obj_type='mcst' AND MATCH(title,content) AGAINST('"; 00054 foreach($this->query_parser->getQuotedWords(true) as $word) 00055 { 00056 $query .= $word; 00057 $query .= '* '; 00058 } 00059 $query .= "' IN BOOLEAN MODE) "; 00060 } 00061 else 00062 { 00063 // i do not see any reason, but MATCH AGAINST(...) OR MATCH AGAINST(...) does not use an index 00064 $query .= " WHERE context_obj_type='mcst' AND MATCH (title,content) AGAINST(' "; 00065 foreach($this->query_parser->getQuotedWords(true) as $word) 00066 { 00067 $query .= $word; 00068 $query .= ' '; 00069 } 00070 $query .= "') "; 00071 } 00072 return $query; 00073 } 00074 } 00075 ?>
1.7.1