plugin_search.inc.php

一款开源的sns系统源码 安装简单

<?php
// -----------------------------------------------------------------------
// This file is part of AROUNDMe
// 
// Copyright (C) 2003-2007 Barnraiser
// http://www.barnraiser.org/
// [e-mail]
// 
// 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 3 of the License, or
// (at your option) any later version.
// 
// 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; see the file COPYING.txt.  If not, see
// <http://www.gnu.org/licenses/>
// -----------------------------------------------------------------------


$query = "
	SELECT COUNT(blog_id) AS total
	FROM " . $db->prefix . "_plugin_blog 
	WHERE 
	MATCH(blog_title, blog_body) AGAINST (" . $db->qstr($search_text) . ") AND
	webspace_id=" . $_REQUEST['ws']
;
$result = $db->Execute($query, 1);

if ($result) {
	$total = $result[0]['total'];
	$body->set('total_nr_of_rows', $total);
}

$query = "
	SELECT MATCH(blog_title, blog_body) AGAINST (" . $db->qstr($search_text) . ") AS score
	FROM " . $db->prefix . "_plugin_blog
	WHERE 
	MATCH(blog_title, blog_body) AGAINST (" . $db->qstr($search_text) . ") AND
	webspace_id=" . $_REQUEST['ws'] . "
	ORDER BY score DESC"
;
$result = $db->Execute($query, 1);

if ($result) {
	$max = $result[0]['score'];
}



$query = "
	SELECT blog_id, webspace_id, webpage_id, blog_title as item_title,
	blog_body as item_body,
	MATCH(blog_title, blog_body) AGAINST (" . $db->qstr($search_text) . ") AS score
	FROM " . $db->prefix . "_plugin_blog
	WHERE
	MATCH(blog_title, blog_body) AGAINST (" . $db->qstr($search_text) . ") AND
	webspace_id=" . $_REQUEST['ws'] . "
	ORDER BY score DESC"
;

$from = isset($_GET['_frm']) ? (int) $_GET['_frm'] : 0;

$result = $db->Execute($query, $core_config['display']['max_list_rows'], $from);

if (!empty($result)) {
	foreach($result as $key => $r) {
		$result[$key]['percentage'] = round(($r['score'] / $max) * 100);

		$result[$key]['link'] = "index.php?ws=" . $r['webspace_id'] . "&amp;wp=" . $r['webpage_id'] . "&amp;blog_id=" . $r['blog_id'];
	}
	$search_result = $result;
}
else {
	$search_result = array();
}

?>