108
searching is not working...xoopsfaq is not listed in profile and also searching FAQ using search.php don't have any results
search.inc.php
<?php
/**
* Name: search.inc.php
* Description: Search function for XOOPS FAQ Module
*
* You may not change or alter any portion of this comment or credits
* of supporting developers from this source code or any supporting source code
* which is considered copyrighted (c) material of the original comment or credit authors.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*
* @copyright The XOOPS Project http://sourceforge.net/projects/xoops/
* @license http://www.fsf.org/copyleft/gpl.html GNU public license
* @package : XOOPS
* @Module : XOOPS FAQ
* @subpackage : Search Functions
* @since 2.3.0
* @author John Neill
* @version $Id: search.inc.php 0000 10/04/2009 09:04:24 John Neill $
*/
defined( 'XOOPS_ROOT_PATH' ) or die( 'Restricted access' );
/**
* xoopsfaq_search()
*
* @param mixed $queryarray
* @param mixed $andor
* @param mixed $limit
* @param mixed $offset
* @param mixed $userid
* @return
*/
function xoopsfaq_search( $queryarray, $andor, $limit, $offset, $userid ) {
global $xoopsDB;
$ret = array();
if ( $userid != 0 ) {
return $ret;
}
$sql = "SELECT contents_id, category_id, contents_title, contents_contents, contents_time FROM " . $xoopsDB->prefix( "xoopsfaq_contents" ) . " WHERE contents_visible=1 ";
// because count() returns 1 even if a supplied variable
// is not an array, we must check if $querryarray is really an array
$count = count( $queryarray );
if ( $count > 0 && is_array( $queryarray ) ) {
$sql .= "AND ((contents_title LIKE '%$queryarray[0]%' OR contents_contents LIKE '%$queryarray[0]%')";
for ( $i = 1; $i < $count; $i++ ) {
$sql .= " $andor ";
$sql .= "(contents_title LIKE '%$queryarray[$i]%' OR contents_contents LIKE '%$queryarray[$i]%')";
}
$sql .= ") ";
}
$sql .= "ORDER BY contents_id DESC";
$result = $xoopsDB->query( $sql, $limit, $offset );
$i = 0;
while ( $myrow = $xoopsDB->fetchArray( $result ) ) {
$ret[$i]['image'] = "images/question2.gif";
$ret[$i]['link'] = "index.php?cat_id=" . $myrow['category_id'] . "#" . $myrow['contents_id'];
$ret[$i]['title'] = $myrow['contents_title'];
$ret[$i]['time'] = $myrow['contents_time'];
$i++;
}
return $ret;
}
?>
