📄 search.inc.php
字号:
<?php
// $Id: search.inc.php,v 1.1.1.29 2004/11/30 17:11:46 phppp Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// 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. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
// Author: Kazumi Ono (AKA onokazu) //
// URL: http://www.myweb.ne.jp/, http://www.xoops.org/, http://jp.xoops.org/ //
// Project: The XOOPS Project //
// ------------------------------------------------------------------------- //
include_once XOOPS_ROOT_PATH.'/modules/newbb/include/functions.php';
function &newbb_search($queryarray, $andor, $limit, $offset, $userid, $forums = 0, $sortby = 0, $searchin = "both", $subquery = "")
{
global $xoopsDB, $xoopsConfig, $myts, $xoopsUser;
static $allowedForums, $newbbConfig;
$uid = (is_object($xoopsUser)&&$xoopsUser->isactive())?$xoopsUser->getVar('uid'):0;
if(!isset($allowedForums[$uid])){
$forum_handler =& xoops_getmodulehandler('forum', 'newbb');
if (is_array($forums) && count($forums) > 0) {
$forums = array_map('intval', $forums);
foreach($forums as $forumid){
$_forum = $forum_handler->get($forumid);
if($forum_handler->getPermission($_forum)) {
$allowedForums[$uid][$forumid] = $_forum;
}
unset($_forum);
}
}
elseif (is_numeric($forums) && $forums > 0) {
$forumid = $forums;
$_forum = $forum_handler->get($forumid);
if($forum_handler->getPermission($_forum)) {
$allowedForums[$uid][$forumid] = $_forum;
}
unset($_forum);
}
else {
$forums = $forum_handler->getForums();
foreach($forums as $forumid => $_forum){
if($forum_handler->getPermission($_forum)) {
$allowedForums[$uid][$forumid] = $_forum;
}
unset($_forum);
}
unset($forums);
}
}
$forum = implode(',',array_keys($allowedForums[$uid]));
$sql = 'SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time,';
$sql .= ' f.forum_name, p.post_id, p.subject
FROM '.$xoopsDB->prefix('bb_posts').' p,
'.$xoopsDB->prefix('bb_posts_text').' pt,
'.$xoopsDB->prefix('bb_forums').' f';
$sql .= ' WHERE p.post_id = pt.post_id';
$sql .= ' AND p.approved = 1';
$sql .= ' AND p.forum_id = f.forum_id';
// AND p.uid = u.uid'; // In case exists a userid with which the associated user is removed, this line will block search results. Can do nothing unless xoops changes its way dealing with user removal
if (!empty($forum)) {
$sql .= ' AND f.forum_id IN ('.$forum.')';
}
if (is_array($userid) && count($userid) > 0) {
$sql .= " AND p.uid IN (".implode(',', $userid).") ";
}
elseif ( is_numeric($userid) && $userid != 0 ) {
$sql .= " AND p.uid=".$userid." ";
}
// 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 ( is_array($queryarray) && $count > 0) {
switch ($searchin) {
case 'title':
$sql .= " AND ((p.subject LIKE '%$queryarray[0]%')";
for($i=1;$i<$count;$i++){
$sql .= " $andor ";
$sql .= "(p.subject LIKE '%$queryarray[$i]%')";
}
$sql .= ") ";
break;
case 'text':
$sql .= " AND ((pt.post_text LIKE '%$queryarray[0]%')";
for($i=1;$i<$count;$i++){
$sql .= " $andor ";
$sql .= "(pt.post_text LIKE '%$queryarray[$i]%')";
}
$sql .= ") ";
break;
case 'both' :
default:
$sql .= " AND ((p.subject LIKE '%$queryarray[0]%' OR pt.post_text LIKE '%$queryarray[0]%')";
for($i=1;$i<$count;$i++){
$sql .= " $andor ";
$sql .= "(p.subject LIKE '%$queryarray[$i]%' OR pt.post_text LIKE '%$queryarray[$i]%')";
}
$sql .= ") ";
break;
}
}
if (!$sortby) {
$sortby = "p.post_time DESC";
}
$sql .= $subquery." ORDER BY ".$sortby;
$result = $xoopsDB->query($sql,$limit,$offset);
$ret = array();
$users = array();
$i = 0;
while($myrow = $xoopsDB->fetchArray($result)){
$ret[$i]['link'] = "viewtopic.php?topic_id=".$myrow['topic_id']."&forum=".$myrow['forum_id']."&post_id=".$myrow['post_id']."#forumpost".$myrow['post_id'];
$ret[$i]['title'] = $myrow['subject'];
$ret[$i]['time'] = $myrow['post_time'];
$ret[$i]['uid'] = $myrow['uid'];
$ret[$i]['forum_name'] = newbb_html2text($myts->undoHtmlSpecialChars($myrow['forum_name']));
$ret[$i]['forum_link'] = "viewforum.php?forum=".$myrow['forum_id'];
$users[$myrow['uid']] = 1;
$ret[$i]['poster_name'] = $myrow['poster_name'];
$i++;
}
if(count($users)>0){
$member_handler =& xoops_gethandler('member');
$userid_array = array_keys($users);
$user_criteria = "(".implode(",",$userid_array).")";
$users = $member_handler->getUsers( new Criteria('uid', $user_criteria, 'IN'), true);
}else{
$users = null;
}
$module_handler = &xoops_gethandler('module');
$newbb = &$module_handler->getByDirname('newbb');
if(!isset($newbbConfig)){
$config_handler =& xoops_gethandler('config');
$newbbConfig =& $config_handler->getConfigsByCat(0, $newbb->getVar('mid'));
}
$count = count($ret);
for($i =0; $i < $count; $i ++ ){
if($ret[$i]['uid'] >0){
if ( isset($users[$ret[$i]['uid']]) && (is_object($users[$ret[$i]['uid']])) && ($users[$ret[$i]['uid']]->isActive()) ){
$poster = ($newbbConfig['show_realname']&&$users[$ret[$i]['uid']]->getVar('name'))?$users[$ret[$i]['uid']]->getVar('name'):$users[$ret[$i]['uid']]->getVar('uname');
$ret[$i]['poster'] = '<a href="'.XOOPS_URL.'/userinfo.php?uid='.$ret[$i]['uid'].'">'.$poster.'</a>';
if(newbb_isAdmin($myrow['forum_id'],$ret[$i]['uid']) && $newbbConfig['allow_moderator_html']){
$ret[$i]['title'] = newbb_html2text($myts->undoHtmlSpecialChars($ret[$i]['title']));
}else $title = $myts->htmlSpecialChars($ret[$i]['title']);
}else{
$ret[$i]['poster'] = $xoopsConfig['anonymous'];
$ret[$i]['uid'] = 0; // Have to force this to fit xoops search.php
}
}else{
$ret[$i]['poster'] = $ret[$i]['poster_name']?$ret[$i]['poster_name']:$xoopsConfig['anonymous'];
$ret[$i]['uid'] = 0;
}
}
unset($users);
return $ret;
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -