SupportSuite – KB bug fixed

I found an issue in SupportSuite (3.0.0.32) where if a client (user) did a KB search they would get the subject line and first 255 characters of each result match – some of these matches would be PRIVATE or DRAFT knowledgebase articles.

I guess this is a bug, but based on the responses (timeframe to even review reported issues) to bugs I reported to Kayako recently, I decided to fix it myself…

Here is what I did :

MODIFIED /modules/core/client_search.php

In the section commented as :
// ===== SEARCH ALL MODULES ========

CHANGED

if ($module->isRegistered(MODULE_KNOWLEDGEBASE))
{
$_searchresults = searchKnowledgebase($_POST["searchquery"]);
}

TO

if ($module->isRegistered(MODULE_KNOWLEDGEBASE))
{
$_searchresults = searchClientKnowledgebase($_POST["searchquery"]);
}

also in the else if block directly below :

CHANGE

} else if ($_POST["searchtype"] == "knowledgebase" && $module->isRegistered(MODULE_KNOWLEDGEBASE)) {
$_searchresults = searchKnowledgebase($_POST["searchquery"]);

TO

} else if ($_POST["searchtype"] == "knowledgebase" && $module->isRegistered(MODULE_KNOWLEDGEBASE)) {
$_searchresults = searchClientKnowledgebase($_POST["searchquery"]);


So, you've now forced the client search functions to use a new function (called seachClientKnowledgebase) 
that we will now define...

Open the file /modules/core/functions_clientsearch.php
Copy the whole function named searchKnowledgebase and paste another copy into the same file.
Now rename the function to searchClientKnowledgebase.

In the newly pasted and renamed function look for the section starting with
// ========BUILD THE CATEGORY LIST FOR THIS GROUP =====

ADD

// KH get the status of each article and only use the 'published' ones
$_finalpublishedarticlelist = array();
$dbCore->query("SELECT * FROM `". TABLE_PREFIX ."kbarticles` WHERE 
  (line wrapped) kbarticleid IN (". buildIN($_finalkbarticleidlist) .");");
while ($dbCore->nextRecord())
{
if ($dbCore->Record["articlestatus"] == "published")
{
$_finalpublishedarticlelist[] = $dbCore->Record["kbarticleid"];
}
}

DIRECTLY AFTER

while ($dbCore->nextRecord())
{
if ($dbCore->Record["categorytype"] == SWIFTPUBLIC)
{
$_finalkbarticleidlist[] = $dbCore->Record["kbarticleid"];
}
}

Then modify the next block of code to read as follows :

if (!count($_finalpublishedarticlelist))
{
return $_queryresult;
}

Alternatively simply make a backup of your existing files :

• /modules/core/functions_clientsearch.php
• /modules/core/client_search.php

and replace them with the files in php_mods.zip