ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilLikeForumSearch.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
35include_once 'Services/Search/classes/class.ilForumSearch.php';
36
38{
39
44 function ilForumSearch(&$qp_obj)
45 {
46 parent::ilForumSearch($qp_obj);
47 }
48
49
51 {
52 global $ilDB;
53
54 /*
55 $concat = " CONCAT(";
56 $concat .= 'pos_message,pos_subject';
57 $concat .= ") ";
58 */
59 $concat = $ilDB->concat(
60 array(
61 array('pos_subject','text'),
62 array('pos_message','text')));
63
64 $and = " AND ( ";
65 $counter = 0;
66 foreach($this->query_parser->getQuotedWords() as $word)
67 {
68 if($counter++)
69 {
70 $and .= " OR";
71 }
72 #$and .= $concat;
73 #$and .= ("LIKE ('%".$word."%')");
74 $and .= $ilDB->like($concat,'clob','%'.$word.'%');
75 }
76 return $and.") ";
77 }
78
80 {
81 global $ilDB;
82
83 $field = 'thr_subject ';
84 $and = " AND( ";
85
86 $counter = 0;
87 foreach($this->query_parser->getQuotedWords() as $word)
88 {
89 if($counter++)
90 {
91 $and .= " OR ";
92 }
93 #$and .= $field;
94 #$and .= ("LIKE ('%".$word."%')");
95 $and .= $ilDB->like($field,'text','%'.$word.'%');
96 }
97 return $and." ) ";
98 }
99}
100?>
ilForumSearch(&$qp_obj)
Constructor @access public.
global $ilDB