search.inc.php

在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.

<?php
/**
 * $Id: search.php v 1.02 03 Jan 2004 Catwolf Exp $
 * Module: WF-Channel
 * Version: v1.0.5
 * Release Date: 03 Jan 2004
 * Author: Catzwolf
 * Licence: GNU
**/

function wfchannel_search($queryarray, $andor, $limit, $offset, $userid){
	global $xoopsDB, $xoopsModule, $xoopsModuleConfig;
	
	$sql = "SELECT CID, pagetitle, pageheadline, page, created FROM ".$xoopsDB->prefix("wfschannel")." WHERE ";
    list($CID, $pagetitle, $pageheadline, $page, $htmlfile ) = $xoopsDB->fetchrow($sql);

	// because count() returns 1 even if a supplied variable
	// is not an array, we must check if $querryarray is really an array
	if ( is_array($queryarray) && $count = count($queryarray) ) {
		$sql .= " ((pagetitle LIKE '%$queryarray[0]%' OR pageheadline LIKE '%$queryarray[0]%' OR page LIKE '%$queryarray[0]%')";
		for($i=1;$i<$count;$i++){
			$sql .= " $andor ";
			$sql .= "(pagetitle LIKE '%$queryarray[$i]%' OR pageheadline  LIKE '%$queryarray[$i]%' OR page LIKE '%$queryarray[$i]%')";
		}
		$sql .= ") ";
	}
	$sql .= "ORDER BY created DESC";
	$result = $xoopsDB->query($sql,$limit,$offset);
	$ret = array();
	$i = 0;
 	while($myrow = $xoopsDB->fetchArray($result)){
		//$ret[$i]['image'] = "images/forum.gif";
		$ret[$i]['link'] = "index.php?pagenum=".$myrow['CID']."";
		$ret[$i]['title'] = $myrow['pagetitle'];
		$ret[$i]['time'] = $myrow['created'];
		$i++;
	}
	return $ret;
}
?>