search.inc.php

来自「在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布X」· PHP 代码 · 共 57 行

<?php 
/* $Id: search.inc.php,v 1.7 2003/03/25 11:08:20 liquid Exp $
 * Module: WF-Downloads
 * Version: v2.0.5a
 * Release Date: 26 july 2004
 * Author: WF-Sections
 * Licence: GNU
 */
 
function wfdownloads_search($queryarray, $andor, $limit, $offset, $userid)
{
    global $xoopsDB, $xoopsUser;
	
    $sql = "SELECT lid, cid, title, submitter, published, description FROM " . $xoopsDB -> prefix('wfdownloads_downloads') . " 
	WHERE status >0 AND published > 0";
    if ($userid != 0)
    {
        $sql .= " AND submitter=" . $userid . " ";
    } 
    // 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 .= " AND ((title LIKE '%$queryarray[0]%' OR description LIKE '%$queryarray[0]%')";
        for($i = 1;$i < $count;$i++)
        {
            $sql .= " $andor ";
            $sql .= "(title LIKE '%$queryarray[$i]%' OR description LIKE '%$queryarray[$i]%')";
        } 
        $sql .= ") ";
    } 
    $sql .= "ORDER BY date DESC";
    $result = $xoopsDB -> query($sql, $limit, $offset);
    $ret = array();
    $i = 0;

    $groups = (is_object($xoopsUser)) ? $xoopsUser -> getGroups() : XOOPS_GROUP_ANONYMOUS;
    $modhandler = & xoops_gethandler('module');
    $xoopsWFDModule = & $modhandler -> getByDirname("wfdownloads");
    $gperm_handler = & xoops_gethandler('groupperm');

    while ($myrow = $xoopsDB -> fetchArray($result))
    {
        if (!$gperm_handler -> checkRight('WFDownFilePerm', $myrow['cid'] , $groups, $xoopsWFDModule -> getVar('mid')))
            continue;
        $ret[$i]['image'] = "images/size2.gif";
        $ret[$i]['link'] = "singlefile.php?cid=" . $myrow['cid'] . "&amp;lid=" . $myrow['lid'] . "";
        $ret[$i]['title'] = $myrow['title'];
        $ret[$i]['time'] = $myrow['published'];
        $ret[$i]['uid'] = $myrow['submitter'];
        $i++;
    } 
    return $ret;
} 

?>