-<?php
-
-/*
- * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
- * Copyright (C) 2003-2009 The Nucleus Group
- *
- * 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.
- * (see nucleus/documentation/index.html#license for more info)
- */
-/**
- * SEARCH(querystring) offers different functionality to create an
- * SQL query to find certain items. (and comments)
- *
- * based on code by David Altherr:
- * http://www.evolt.org/article/Boolean_Fulltext_Searching_with_PHP_and_MySQL/18/15665/
- * http://davidaltherr.net/web/php_functions/boolean/funcs.mysql.boolean.txt
- *
- * @license http://nucleuscms.org/license.txt GNU General Public License
- * @copyright Copyright (C) 2002-2009 The Nucleus Group
- * @version $Id: SEARCH.php 1556 2011-07-11 14:18:48Z ftruscot $
- */
-
-
-
-class SEARCH {
-
- var $querystring;
- var $marked;
- var $inclusive;
- var $blogs;
-
-
- function SEARCH($text) {
- global $blogid;
- $text = preg_replace ("/[<,>,=,?,!,#,^,(,),[,\],:,;,\\\,%]/","",$text);
- $this->querystring = $text;
- $this->marked = $this->boolean_mark_atoms($text);
- $this->inclusive = $this->boolean_inclusive_atoms($text);
- $this->blogs = array();
-
- // get all public searchable blogs, no matter what, include the current blog allways.
- $res = sql_query('SELECT bnumber FROM '.sql_table('blog').' WHERE bincludesearch=1 ');
- while ($obj = sql_fetch_object($res))
- $this->blogs[] = intval($obj->bnumber);
- }
-
- function boolean_sql_select($match){
- if (i18n::strlen($this->inclusive) > 0) {
- /* build sql for determining score for each record */
- $result=i18n::explode(" ",$this->inclusive);
- for($cth=0;$cth<count($result);$cth++){
- if(i18n::strlen($result[$cth])>=4){
- $stringsum_long .= " $result[$cth] ";
- }else{
- $stringsum_a[] = ' '.$this->boolean_sql_select_short($result[$cth],$match).' ';
- }
- }
-
- if(i18n::strlen($stringsum_long)>0){
- $stringsum_long = sql_real_escape_string($stringsum_long);
- $stringsum_a[] = " match ($match) against ('$stringsum_long') ";
- }
-
- $stringsum .= implode("+",$stringsum_a);
- return $stringsum;
- }
- }
-
- function boolean_inclusive_atoms($string){
- $result = trim($string);
- $result = preg_replace("#([[:space:]]{2,})#", ' ', $result);
-
- # replaced eregi_replace() below with preg_replace(). ereg* functions are deprecated in PHP 5.3.0
- # just added delimiters to regex and the 'i' for case-insensitive matching
-
- /* convert normal boolean operators to shortened syntax */
- $result = preg_replace('# not #i', ' -', $result);
- $result = preg_replace('# and #i', ' ', $result);
- $result = preg_replace('# or #i', ',', $result);
-
- /* drop unnecessary spaces */
- $result = str_replace(' ,', ',', $result);
- $result = str_replace(', ', ',', $result);
- $result = str_replace('- ', '-', $result);
- $result = str_replace('+', '', $result);
-
- /* strip exlusive atoms */
- $result = preg_replace(
- "#\-\([A-Za-z0-9]{1,}[A-Za-z0-9\-\.\_\,]{0,}\)#",
- '',
- $result);
-
- $result = str_replace('(', ' ', $result);
- $result = str_replace(')', ' ', $result);
- $result = str_replace(',', ' ', $result);
-
- return $result;
- }
-
- function boolean_sql_where($match){
-
- $result = $this->marked;
-
- $this->boolean_sql_where_cb1($match); // set the static $match
-
- $result = preg_replace_callback(
-
- "/foo\[\(\'([^\)]{4,})\'\)\]bar/",
-
- array($this,'boolean_sql_where_cb1'),
-
- $result);
-
- $this->boolean_sql_where_cb2($match); // set the static $match
-
- $result = preg_replace_callback(
-
- "/foo\[\(\'([^\)]{1,3})\'\)\]bar/",
-
- array($this,'boolean_sql_where_cb2'),
-
- $result);
-
- return $result;
-
- }
-
- function boolean_sql_where_cb1($matches){
-
- static $match;
-
- if (!is_array($matches)) $match=$matches;
-
- else return ' match ('.$match.') against (\''.sql_real_escape_string($matches[1]).'\') > 0 ';
-
- }
-
- function boolean_sql_where_cb2($matches){
-
- static $match;
-
- if (!is_array($matches)) $match=$matches;
-
- else return ' ('.$this->boolean_sql_where_short(sql_real_escape_string($matches[1]),$match).') ';
-
- }
-
- function boolean_mark_atoms($string){
- $result = trim($string);
- $result = preg_replace("/([[:space:]]{2,})/",' ',$result);
-
- # replaced eregi_replace() below with preg_replace(). ereg* functions are deprecated in PHP 5.3.0
- # just added delimiters to regex and the 'i' for case-insensitive matching
-
- /* convert normal boolean operators to shortened syntax */
- $result = preg_replace('# not #i', ' -', $result);
- $result = preg_replace('# and #i', ' ', $result);
- $result = preg_replace('# or #i', ',', $result);
-
- /* strip excessive whitespace */
- $result = str_replace('( ', '(', $result);
- $result = str_replace(' )', ')', $result);
- $result = str_replace(', ', ',', $result);
- $result = str_replace(' ,', ',', $result);
- $result = str_replace('- ', '-', $result);
- $result = str_replace('+', '', $result);
-
- // remove double spaces (we might have introduced some new ones above)
- $result = trim($result);
- $result = preg_replace("#([[:space:]]{2,})#", ' ', $result);
-
- /* apply arbitrary function to all 'word' atoms */
-
- $result_a = i18n::explode(' ', $result);
-
- for($word = 0;$word<count($result_a);$word++)
- {
- $result_a[$word] = "foo[('" . $result_a[$word] . "')]bar";
- }
-
- $result = implode(' ', $result_a);
-
- /* dispatch ' ' to ' AND ' */
- $result = str_replace(' ', ' AND ', $result);
-
- /* dispatch ',' to ' OR ' */
- $result = str_replace(',', ' OR ', $result);
-
- /* dispatch '-' to ' NOT ' */
- $result = str_replace(' -', ' NOT ', $result);
- return $result;
- }
-
- function boolean_sql_where_short($string,$match){
- $match_a = i18n::explode(',',$match);
- for($ith=0;$ith<count($match_a);$ith++){
- $like_a[$ith] = " $match_a[$ith] LIKE '% $string %' ";
- }
- $like = implode(" OR ",$like_a);
-
- return $like;
- }
- function boolean_sql_select_short($string,$match){
- $match_a = i18n::explode(',',$match);
- $score_unit_weight = .2;
- for($ith=0;$ith<count($match_a);$ith++){
- $score_a[$ith] =
- " $score_unit_weight*(
- LENGTH(" . sql_real_escape_string($match_a[$ith]) . ") -
- LENGTH(REPLACE(LOWER(" . sql_real_escape_string($match_a[$ith]) . "),LOWER('" . sql_real_escape_string($string) . "'),'')))
- /LENGTH('" . sql_real_escape_string($string) . "') ";
- }
- $score = implode(" + ",$score_a);
-
- return $score;
- }
-}
-?>
+<?php\r
+\r
+/*\r
+ * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
+ * Copyright (C) 2003-2009 The Nucleus Group\r
+ *\r
+ * This program is free software; you can redistribute it and/or\r
+ * modify it under the terms of the GNU General Public License\r
+ * as published by the Free Software Foundation; either version 2\r
+ * of the License, or (at your option) any later version.\r
+ * (see nucleus/documentation/index.html#license for more info)\r
+ */\r
+/**\r
+ * SEARCH(querystring) offers different functionality to create an\r
+ * SQL query to find certain items. (and comments)\r
+ *\r
+ * based on code by David Altherr:\r
+ * http://www.evolt.org/article/Boolean_Fulltext_Searching_with_PHP_and_MySQL/18/15665/\r
+ * http://davidaltherr.net/web/php_functions/boolean/funcs.mysql.boolean.txt\r
+ *\r
+ * @license http://nucleuscms.org/license.txt GNU General Public License\r
+ * @copyright Copyright (C) 2002-2009 The Nucleus Group\r
+ * @version $Id: SEARCH.php 1556 2011-07-11 14:18:48Z ftruscot $\r
+ */\r
+\r
+\r
+\r
+class SEARCH {\r
+\r
+ var $querystring;\r
+ var $marked;\r
+ var $inclusive;\r
+ var $blogs;\r
+\r
+\r
+ function SEARCH($text) {\r
+ global $blogid;\r
+ $text = preg_replace ("/[<,>,=,?,!,#,^,(,),[,\],:,;,\\\,%]/","",$text);\r
+ $this->querystring = $text;\r
+ $this->marked = $this->boolean_mark_atoms($text);\r
+ $this->inclusive = $this->boolean_inclusive_atoms($text);\r
+ $this->blogs = array();\r
+\r
+ // get all public searchable blogs, no matter what, include the current blog allways.\r
+ $res = sql_query('SELECT bnumber FROM '.sql_table('blog').' WHERE bincludesearch=1 ');\r
+ while ($obj = sql_fetch_object($res))\r
+ $this->blogs[] = intval($obj->bnumber);\r
+ }\r
+\r
+ function boolean_sql_select($match){\r
+ if (i18n::strlen($this->inclusive) > 0) {\r
+ /* build sql for determining score for each record */\r
+ $result=i18n::explode(" ",$this->inclusive);\r
+ for($cth=0;$cth<count($result);$cth++){\r
+ if(i18n::strlen($result[$cth])>=4){\r
+ $stringsum_long .= " $result[$cth] ";\r
+ }else{\r
+ $stringsum_a[] = ' '.$this->boolean_sql_select_short($result[$cth],$match).' ';\r
+ }\r
+ }\r
+\r
+ if(i18n::strlen($stringsum_long)>0){\r
+ $stringsum_long = sql_real_escape_string($stringsum_long);\r
+ $stringsum_a[] = " match ($match) against ('$stringsum_long') ";\r
+ }\r
+\r
+ $stringsum .= implode("+",$stringsum_a);\r
+ return $stringsum;\r
+ }\r
+ }\r
+\r
+ function boolean_inclusive_atoms($string){\r
+ $result = trim($string);\r
+ $result = preg_replace("#([[:space:]]{2,})#", ' ', $result);\r
+\r
+ # replaced eregi_replace() below with preg_replace(). ereg* functions are deprecated in PHP 5.3.0\r
+ # just added delimiters to regex and the 'i' for case-insensitive matching\r
+\r
+ /* convert normal boolean operators to shortened syntax */\r
+ $result = preg_replace('# not #i', ' -', $result);\r
+ $result = preg_replace('# and #i', ' ', $result);\r
+ $result = preg_replace('# or #i', ',', $result);\r
+\r
+ /* drop unnecessary spaces */\r
+ $result = str_replace(' ,', ',', $result);\r
+ $result = str_replace(', ', ',', $result);\r
+ $result = str_replace('- ', '-', $result);\r
+ $result = str_replace('+', '', $result);\r
+\r
+ /* strip exlusive atoms */\r
+ $result = preg_replace(\r
+ "#\-\([A-Za-z0-9]{1,}[A-Za-z0-9\-\.\_\,]{0,}\)#",\r
+ '',\r
+ $result);\r
+\r
+ $result = str_replace('(', ' ', $result);\r
+ $result = str_replace(')', ' ', $result);\r
+ $result = str_replace(',', ' ', $result);\r
+\r
+ return $result;\r
+ }\r
+\r
+ function boolean_sql_where($match){\r
+\r
+ $result = $this->marked;\r
+\r
+ $this->boolean_sql_where_cb1($match); // set the static $match\r
+\r
+ $result = preg_replace_callback(\r
+\r
+ "/foo\[\(\'([^\)]{4,})\'\)\]bar/",\r
+\r
+ array($this,'boolean_sql_where_cb1'),\r
+\r
+ $result);\r
+\r
+ $this->boolean_sql_where_cb2($match); // set the static $match\r
+\r
+ $result = preg_replace_callback(\r
+\r
+ "/foo\[\(\'([^\)]{1,3})\'\)\]bar/",\r
+\r
+ array($this,'boolean_sql_where_cb2'),\r
+\r
+ $result);\r
+\r
+ return $result;\r
+\r
+ }\r
+\r
+ function boolean_sql_where_cb1($matches){\r
+\r
+ static $match;\r
+\r
+ if (!is_array($matches)) $match=$matches;\r
+\r
+ else return ' match ('.$match.') against (\''.sql_real_escape_string($matches[1]).'\') > 0 ';\r
+\r
+ }\r
+\r
+ function boolean_sql_where_cb2($matches){\r
+\r
+ static $match;\r
+\r
+ if (!is_array($matches)) $match=$matches;\r
+\r
+ else return ' ('.$this->boolean_sql_where_short(sql_real_escape_string($matches[1]),$match).') ';\r
+\r
+ } \r
+\r
+ function boolean_mark_atoms($string){\r
+ $result = trim($string);\r
+ $result = preg_replace("/([[:space:]]{2,})/",' ',$result);\r
+\r
+ # replaced eregi_replace() below with preg_replace(). ereg* functions are deprecated in PHP 5.3.0\r
+ # just added delimiters to regex and the 'i' for case-insensitive matching\r
+\r
+ /* convert normal boolean operators to shortened syntax */\r
+ $result = preg_replace('# not #i', ' -', $result);\r
+ $result = preg_replace('# and #i', ' ', $result);\r
+ $result = preg_replace('# or #i', ',', $result);\r
+\r
+ /* strip excessive whitespace */\r
+ $result = str_replace('( ', '(', $result);\r
+ $result = str_replace(' )', ')', $result);\r
+ $result = str_replace(', ', ',', $result);\r
+ $result = str_replace(' ,', ',', $result);\r
+ $result = str_replace('- ', '-', $result);\r
+ $result = str_replace('+', '', $result);\r
+\r
+ // remove double spaces (we might have introduced some new ones above)\r
+ $result = trim($result);\r
+ $result = preg_replace("#([[:space:]]{2,})#", ' ', $result);\r
+\r
+ /* apply arbitrary function to all 'word' atoms */\r
+\r
+ $result_a = i18n::explode(' ', $result);\r
+\r
+ for($word = 0;$word<count($result_a);$word++)\r
+ {\r
+ $result_a[$word] = "foo[('" . $result_a[$word] . "')]bar";\r
+ }\r
+\r
+ $result = implode(' ', $result_a);\r
+\r
+ /* dispatch ' ' to ' AND ' */\r
+ $result = str_replace(' ', ' AND ', $result);\r
+\r
+ /* dispatch ',' to ' OR ' */\r
+ $result = str_replace(',', ' OR ', $result);\r
+\r
+ /* dispatch '-' to ' NOT ' */\r
+ $result = str_replace(' -', ' NOT ', $result);\r
+ return $result;\r
+ }\r
+\r
+ function boolean_sql_where_short($string,$match){\r
+ $match_a = i18n::explode(',',$match);\r
+ for($ith=0;$ith<count($match_a);$ith++){\r
+ $like_a[$ith] = " $match_a[$ith] LIKE '% $string %' ";\r
+ }\r
+ $like = implode(" OR ",$like_a);\r
+\r
+ return $like;\r
+ }\r
+ function boolean_sql_select_short($string,$match){\r
+ $match_a = i18n::explode(',',$match);\r
+ $score_unit_weight = .2;\r
+ for($ith=0;$ith<count($match_a);$ith++){\r
+ $score_a[$ith] =\r
+ " $score_unit_weight*(\r
+ LENGTH(" . sql_real_escape_string($match_a[$ith]) . ") -\r
+ LENGTH(REPLACE(LOWER(" . sql_real_escape_string($match_a[$ith]) . "),LOWER('" . sql_real_escape_string($string) . "'),'')))\r
+ /LENGTH('" . sql_real_escape_string($string) . "') ";\r
+ }\r
+ $score = implode(" + ",$score_a);\r
+\r
+ return $score;\r
+ }\r
+}\r
+?>\r
OSDN Git Service
