| 1 | <?php |
|---|
| 2 | // $Id: search.inc.php,v 1.2 2005/03/18 12:52:49 onokazu Exp $ |
|---|
| 3 | // ------------------------------------------------------------------------ // |
|---|
| 4 | // XOOPS - PHP Content Management System // |
|---|
| 5 | // Copyright (c) 2000 XOOPS.org // |
|---|
| 6 | // <http://www.xoops.org/> // |
|---|
| 7 | // ------------------------------------------------------------------------ // |
|---|
| 8 | // This program is free software; you can redistribute it and/or modify // |
|---|
| 9 | // it under the terms of the GNU General Public License as published by // |
|---|
| 10 | // the Free Software Foundation; either version 2 of the License, or // |
|---|
| 11 | // (at your option) any later version. // |
|---|
| 12 | // // |
|---|
| 13 | // You may not change or alter any portion of this comment or credits // |
|---|
| 14 | // of supporting developers from this source code or any supporting // |
|---|
| 15 | // source code which is considered copyrighted (c) material of the // |
|---|
| 16 | // original comment or credit authors. // |
|---|
| 17 | // // |
|---|
| 18 | // This program is distributed in the hope that it will be useful, // |
|---|
| 19 | // but WITHOUT ANY WARRANTY; without even the implied warranty of // |
|---|
| 20 | // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // |
|---|
| 21 | // GNU General Public License for more details. // |
|---|
| 22 | // // |
|---|
| 23 | // You should have received a copy of the GNU General Public License // |
|---|
| 24 | // along with this program; if not, write to the Free Software // |
|---|
| 25 | // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA // |
|---|
| 26 | // ------------------------------------------------------------------------ // |
|---|
| 27 | |
|---|
| 28 | function xoopsfaq_search($queryarray, $andor, $limit, $offset, $userid) |
|---|
| 29 | { |
|---|
| 30 | global $xoopsDB; |
|---|
| 31 | $ret = array(); |
|---|
| 32 | if ( $userid != 0 ) { |
|---|
| 33 | return $ret; |
|---|
| 34 | } |
|---|
| 35 | $sql = "SELECT contents_id, category_id, contents_title, contents_contents, contents_time FROM ".$xoopsDB->prefix("xoopsfaq_contents")." WHERE contents_visible=1 "; |
|---|
| 36 | // because count() returns 1 even if a supplied variable |
|---|
| 37 | // is not an array, we must check if $querryarray is really an array |
|---|
| 38 | $count = count($queryarray); |
|---|
| 39 | if ( $count > 0 && is_array($queryarray) ) { |
|---|
| 40 | $sql .= "AND ((contents_title LIKE '%$queryarray[0]%' OR contents_contents LIKE '%$queryarray[0]%')"; |
|---|
| 41 | for ( $i = 1; $i < $count; $i++ ) { |
|---|
| 42 | $sql .= " $andor "; |
|---|
| 43 | $sql .= "(contents_title LIKE '%$queryarray[$i]%' OR contents_contents LIKE '%$queryarray[$i]%')"; |
|---|
| 44 | } |
|---|
| 45 | $sql .= ") "; |
|---|
| 46 | } |
|---|
| 47 | $sql .= "ORDER BY contents_id DESC"; |
|---|
| 48 | $result = $xoopsDB->query($sql,$limit,$offset); |
|---|
| 49 | $i = 0; |
|---|
| 50 | while ( $myrow = $xoopsDB->fetchArray($result) ) { |
|---|
| 51 | $ret[$i]['image'] = "images/question2.gif"; |
|---|
| 52 | $ret[$i]['link'] = "index.php?cat_id=".$myrow['category_id']."#".$myrow['contents_id']; |
|---|
| 53 | $ret[$i]['title'] = $myrow['contents_title']; |
|---|
| 54 | $ret[$i]['time'] = $myrow['contents_time']; |
|---|
| 55 | //$ret[$i]['uid'] = $myrow['contents_uid']; |
|---|
| 56 | $i++; |
|---|
| 57 | } |
|---|
| 58 | return $ret; |
|---|
| 59 | } |
|---|
| 60 | ?> |
|---|
