WB 2.08.x

03-Mar-2007 Matthias Gallas

+	Added new function for highlighting search results in the content area

	(Special thanks to "thorn" and "Funky_MF")

#	Fixed some issues in search with special chars

	(Special thanks to "thorn" and "Funky_MF")

	if(isset($_REQUEST['match'])) {

		$match = $_REQUEST['match'];

	}

		// convert a copy of $string to HTML-ENTITIES

		$string_entities=mb_convert_encoding($string, 'UTF-8', 'HTML-ENTITIES');

		$string_entities=htmlspecialchars($string_entities,ENT_QUOTES);

		$string_entities=mb_convert_encoding($string_entities, 'HTML-ENTITIES', 'UTF-8');

		// and do some convertion to both

		require(WB_PATH.'/search/search_convert.php');

		$string=strtr($string,$string_conv);

		$string_entities=strtr($string_entities,$string_entities_conv);

		$search_string = $string_entities;

		// Split $string_entities, too

		$exploded_string = explode(' ', $string_entities);

		// Make sure there is no blank values in the array

		$string_entities = array();

		foreach($exploded_string AS $each_exploded_string) {

			if($each_exploded_string != '') {

				$string_entities[] = $each_exploded_string;

			}

		}

		$exact_string=$string_entities;

		$string_entities=array();

		$string_entities[]=$exact_string;

		$query_pages = "SELECT page_id, page_title, menu_title, link, description, modified_when, modified_by FROM ".TABLE_PREFIX."pages WHERE ";

		$count = 0;

		foreach($string AS $each_string) {

			if($count != 0) { 

				$query_pages .= $logical_operator;

			$query_pages .= " visibility != 'none' AND visibility != 'deleted' AND searching = '1'".

			" AND (page_title LIKE '%$each_string%' OR menu_title LIKE '%$each_string%' OR description LIKE '%$each_string%' OR keywords LIKE '%$each_string%')";

			$count = $count+1;

		}

		$count = 0;

		$query_pages .= ' OR';

		foreach($string_entities AS $each_string) {

			if($count != 0) { 

				$query_pages .= $logical_operator;

			}

			$query_pages .= " visibility != 'none' AND visibility != 'deleted' AND searching = '1'".

			" AND (page_title LIKE '%$each_string%' OR menu_title LIKE '%$each_string%' OR description LIKE '%$each_string%' OR keywords LIKE '%$each_string%')";

			$count = $count+1;

		}

		$query_pages = $database->query($query_pages);

				//Add search string for highlighting

				$sstring = implode(" ", array_merge($string,$string_entities));

				//$link = $link."?searchresult=1&sstring=".$sstring;

				$link = $link."?searchresult=1&sstring=".urlencode($sstring);

								if($count != 0) {

									$prepared_query .= $logical_operator;

								}

							$count=0;

							$prepared_query .= ' OR ';

							foreach($string_entities AS $each_string) {

								if($count != 0) {

									$prepared_query .= $logical_operator;

								}

								$prepared_query .= str_replace('[STRING]', $each_string, $query_body);

								$count = $count+1;

							}

										//Add search string for highlighting

										$sstring = implode(" ", array_merge($string,$string_entities));

										//$link = $link."?searchresult=1&sstring=".$sstring;

										$link = $link."?searchresult=1&sstring=".urlencode($sstring);

		// Say no items found if we should

		if($pages_listed == array() AND $items_listed == array()) {

			echo $fetch_no_results['value'];

		}

<?php

// $Id$

/*

 Website Baker Project <http://www.websitebaker.org/>

 Copyright (C) 2004-2007, Ryan Djurovich

 Website Baker 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.

 Website Baker 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 Website Baker; if not, write to the Free Software

 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

*/

/*

Character Conversion file

Some special translations

*/

if(!defined('WB_URL')) {

	header('Location: ../index.php');

	exit(0);

}

//for Xinha, (htmlarea)

$string_conv=array(

	"?"=>"Š","?"=>"š","?"=>"Œ","?"=>"œ","?"=>"Ÿ",

	">"=>"&gt;","<"=>"&lt;",

	"?"=>"„","?"=>"•","?"=>"ˆ","Ν"=>"Ν","ν"=>"ν",

	"Σ"=>"Σ","Υ"=>"Υ","υ"=>"υ",

	"Ζ"=>"Ζ","ζ"=>"ζ","ξ"=>"ξ","Β"=>"Β","β"=>"β",

	"∞"=>"∞","↔"=>"↔","⁄"=>"⁄","Η"=>"Η","η"=>"η",

	"Χ"=>"Χ","∩"=>"∩","∧"=>"∧","Α"=>"Α","α"=>"α",

	"≈"=>"≈","?"=>"™","?"=>"˜","≤"=>"≤",

	"Δ"=>"Δ","δ"=>"δ","?"=>"€","?"=>"ƒ",

	"Γ"=>"Γ","γ"=>"γ","≥"=>"≥","♥"=>"♥",

	"?"=>"…","∫"=>"∫","Ι"=>"Ι","ι"=>"ι",

	"Κ"=>"Κ","κ"=>"κ","Λ"=>"Λ","λ"=>"λ",

	"←"=>"←","?"=>"“","◊"=>"◊",

	"?"=>"‹","?"=>"‘","?"=>"—","≠"=>"≠",

	"−"=>"−","Μ"=>"Μ","μ"=>"μ","?"=>"–",

	"‾"=>"‾","Ω"=>"Ω","ω"=>"ω","ο"=>"ο",

	"Φ"=>"Φ","φ"=>"φ","Π"=>"Π","π"=>"π","∂"=>"∂",

	"?"=>"‰","″"=>"″","′"=>"′","∏"=>"∏",

	"Ψ"=>"Ψ","√"=>"√","⇒"=>"⇒","→"=>"→",

	"?"=>"”","Ρ"=>"Ρ","ρ"=>"ρ",

	"?"=>"›","?"=>"’","?"=>"‚",

	"σ"=>"σ","ς"=>"ς","♠"=>"♠","∑"=>"∑",

	"Τ"=>"Τ","τ"=>"τ","Θ"=>"Θ","θ"=>"θ",

	"↑"=>"↑","Ξ"=>"Ξ"

);

//for fckeditor, (tiny_mce)

$string_entities_conv=array(

	"Œ"=>"Œ","œ"=>"œ","Š"=>"Š","š"=>"š",

	"Ÿ"=>"Ÿ",

	"˜"=>"˜","ϒ"=>"ϒ","•"=>"•","™"=>"™",

	"„"=>"„","ˆ"=>"ˆ","€"=>"€","ƒ"=>"ƒ",

	"…"=>"…","⟨"=>"〈","⌈"=>"⌈","“"=>"“",

	"⌊"=>"⌊","–"=>"–","—"=>"—",

	"‹"=>"‹","‘"=>"‘","⌋"=>"⌋","”"=>"”",

	"⌉"=>"⌉","⟩"=>"〉","ϖ"=>"ϖ","‰"=>"‰",

	"›"=>"›","’"=>"’","‚"=>"‚","ϑ"=>"&#977"

);

?>

//function to highlight search results

function search_highlight($foo='', $arr_string=array()) {

	foreach($arr_string as $string) {

		$string=str_replace('\\','\\\\',$string); 

		$string=str_replace('/','\/',$string); 

		$string=str_replace('*','\*',$string); 

		$string=str_replace('.','\.',$string); 

		$foo=preg_replace('/(>[^<]*)('.strtolower($string).')/', '$1<span class="highlight">$2</span>',$foo); 

		$foo=preg_replace('/^([^<]*)('.strtolower($string).')/', '$1<span class="highlight">$2</span>',$foo);

		$foo=preg_replace('/(>[^<]*)('.strtoupper($string).')/', '$1<span class="highlight">$2</span>',$foo); 

		$foo=preg_replace('/^([^<]*)('.strtoupper($string).')/', '$1<span class="highlight">$2</span>',$foo);

		$foo=preg_replace('/(>[^<]*)('.ucfirst($string).')/', '$1<span class="highlight">$2</span>',$foo); 

		$foo=preg_replace('/^([^<]*)('.ucfirst($string).')/', '$1<span class="highlight">$2</span>',$foo);

	}

	return $foo;

}  

				// highlights searchresults

				if (isset($_GET['searchresult']) AND is_numeric($_GET['searchresult']) ) {

					if (isset($_GET['sstring']) AND !empty($_GET['sstring']) ){

						$arr_string = explode(" ", $_GET['sstring']);

						ob_start(); //start output buffer

						require(WB_PATH.'/modules/'.$module.'/view.php');

						$foo = ob_get_contents();    // put outputbuffer in $foo

						ob_end_clean();             // clear outputbuffer

						echo search_highlight($foo, $arr_string);

					}

				} else {

					require(WB_PATH.'/modules/'.$module.'/view.php');

				}