my modification:KB search-multi words search feature
Posted: Fri Mar 01, 2013 5:17 am
Script URL:
Version of script: 2.41
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
Write your message below:
For user:
D:\wamp\www\hesk\knowledgebase.php
function hesk_kb_search($query) after hesk_kb_header($hesk_settings['kb_link']);
from
to
For admin:
D:\wamp\www\hesk\admin\knowledgebase_private.php
function hesk_kb_search($query) after hesk_kb_header($hesk_settings['kb_link']);
from:
to:
enjoy!
Version of script: 2.41
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:
Write your message below:
For user:
D:\wamp\www\hesk\knowledgebase.php
function hesk_kb_search($query) after hesk_kb_header($hesk_settings['kb_link']);
from
Code: Select all
$sql = 'SELECT t1.* FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'kb_articles` AS t1 LEFT JOIN `'.hesk_dbEscape($hesk_settings['db_pfix']).'kb_categories` AS t2 ON t1.`catid` = t2.`id` WHERE t1.`type`=\'0\' AND t2.`type`=\'0\' AND (`subject` LIKE \'%'.hesk_dbEscape($query).'%\' OR `content` LIKE \'%'.hesk_dbEscape($query).'%\') LIMIT '.hesk_dbEscape($hesk_settings['kb_search_limit']);Code: Select all
$arr=preg_split('/[\s,]+/',$query); // eagle:seperate with space or comma
for ($i=0;$i<count($arr);$i++) $arr[$i]='CONCAT(subject,content) LIKE ""%'.$arr[$i].'%""'; //eagle:create conditions
$cond=join(' AND ', $arr);
$sql = 'SELECT t1.* FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'kb_articles` AS t1 LEFT JOIN `'.hesk_dbEscape($hesk_settings['db_pfix']).'kb_categories` AS t2 ON t1.`catid` = t2.`id` WHERE t1.`type`=\'0\' AND t2.`type`=\'0\' AND ('.$cond.') ORDER BY subject DESC LIMIT '.hesk_dbEscape($hesk_settings['kb_search_limit']);D:\wamp\www\hesk\admin\knowledgebase_private.php
function hesk_kb_search($query) after hesk_kb_header($hesk_settings['kb_link']);
from:
Code: Select all
$sql = 'SELECT t1.* FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'kb_articles` AS t1 LEFT JOIN `'.hesk_dbEscape($hesk_settings['db_pfix']).'kb_categories` AS t2 ON t1.`catid` = t2.`id` WHERE t1.`type`=\'0\' AND t2.`type`=\'0\' AND (`subject` LIKE \'%'.hesk_dbEscape($query).'%\' OR `content` LIKE \'%'.hesk_dbEscape($query).'%\') LIMIT '.hesk_dbEscape($hesk_settings['kb_search_limit']);Code: Select all
"$arr=preg_split('/[\s,]+/',$query); // eagle:seperate with space or comma
for ($i=0;$i<count($arr);$i++) $arr[$i]='CONCAT(subject,content) LIKE ""%'.$arr[$i].'%""'; //eagle:create conditions
$cond=join(' AND ', $arr);
$sql = 'SELECT t1.* FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'kb_articles` AS t1 LEFT JOIN `'.hesk_dbEscape($hesk_settings['db_pfix']).'kb_categories` AS t2 ON t1.`catid` = t2.`id` WHERE t1.`type`=\'0\' AND t2.`type`=\'0\' AND ('.$cond.') ORDER BY subject DESC LIMIT '.hesk_dbEscape($hesk_settings['kb_search_limit']);"