ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilLikeMediaCastSearch.php
Go to the documentation of this file.
1<?php
2/*
3 +-----------------------------------------------------------------------------+
4 | ILIAS open source |
5 +-----------------------------------------------------------------------------+
6 | Copyright (c) 1998-2001 ILIAS open source, University of Cologne |
7 | |
8 | This program is free software; you can redistribute it and/or |
9 | modify it under the terms of the GNU General Public License |
10 | as published by the Free Software Foundation; either version 2 |
11 | of the License, or (at your option) any later version. |
12 | |
13 | This program is distributed in the hope that it will be useful, |
14 | but WITHOUT ANY WARRANTY; without even the implied warranty of |
15 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
16 | GNU General Public License for more details. |
17 | |
18 | You should have received a copy of the GNU General Public License |
19 | along with this program; if not, write to the Free Software |
20 | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
21 +-----------------------------------------------------------------------------+
22*/
23
34include_once 'Services/Search/classes/class.ilMediaCastSearch.php';
35
37{
38
43 function ilLikeMediaCastSearch(&$qp_obj)
44 {
45 parent::ilMediaCastSearch($qp_obj);
46 }
47
48
50 {
51 global $ilDB;
52
53 /*
54 $concat = " CONCAT(";
55 $concat .= 'title,content';
56 $concat .= ") ";
57 */
58
59 /*
60 $concat = $ilDB->concat(
61 array(
62 'title' => 'text',
63 'content' => 'clob'));
64 */
65
66 $and = " WHERE context_obj_type='mcst' AND ( ";
67 $counter = 0;
68 foreach($this->query_parser->getQuotedWords() as $word)
69 {
70 if($counter++)
71 {
72 $and .= " OR ";
73 }
74 #$and .= $concat;
75 #$and .= ("LIKE ('%".$word."%')");
76 $and .= $ilDB->like('title','text','%'.$word.'%');
77 $and .= ' OR ';
78 $and .= $ilDB->like('content','clob','%'.$word.'%');
79 }
80 return $and.") ";
81 }
82}
83?>
Class ilLikeMediaCastSearch.
ilLikeMediaCastSearch(&$qp_obj)
Constructor @access public.
global $ilDB