OsTicket / phpMyFaq Mod for all

clarityproductions

This mod is a is a multi part mod it requires mod work to both osTicket and phpMyFaq. It was built using the most recent version of osTicket v 1.6 RC5 and phpMyFaq 2.0.15. the objective was to provide relevant faq records or knowledge base articles to the customer before submitting the ticket. This helps allow the customer to answer their own question possibly and not even have to submit a ticket. :)

blank

Here is what the suggestion screen looks like.

blank

The articles are shown using AJAX so the customer does not leave the page. Here is what it looks like when the customer selects an article to read. It opens up on the same page.

*=============================

MOD BEGIN FOR OSTICKET

=============================*

*OPEN class.ticket.php*

REPLACE:

if(strcasecmp($origin,'web')==0) { //Help topic only applicable on web tickets.

$fields = array('type'=>'int', 'required'=>1, 'error'=>'Select help topic');

WITH:

if(strcasecmp($origin,'web')==0) { //Help topic only applicable on web tickets.

$fields = array('type'=>'int', 'required'=>1, 'error'=>'Select help topic');

// KB MOD

$fields = array('type'=>'string', 'required'=>1, 'error'=>'Inquiry not yet submitted.');

// End KB Mod

*OPEN open.inc.php*

REPLACE:

<div>

<?if($errors) {?>

<p align="center" id="errormessage"><?=$errors?></p>

<?}elseif($msg) {?>

<p align="center" id="infomessage"><?=$msg?></p>

<?}elseif($warn) {?>

<p id="warnmessage"><?=$warn?></p>

<?}?>

</div>

<div>Please fill in the form below to open a new ticket.</div>

WITH:

<script type="text/javascript">

var http = false;

if(navigator.appName == "Microsoft Internet Explorer") {

http = new ActiveXObject("Microsoft.XMLHTTP");

} else {

http = new XMLHttpRequest();

}function validate(kba) {
 http.abort();
 http.open("GET", "/faq/index.php?ost_action=ost_artikel&action=artikel&artlang=en&id=" + kba, true);
 http.onreadystatechange=function() {
   if(http.readyState == 4) {
     document.getElementById('foo').innerHTML = http.responseText;
   }
 }
 http.send(null);
}</script>
<? if ($_POST and (! $errors and ! $errors and ! $errors and ! $errors /*and ! $errors*/)) $noerror = true; ?>
<div>
   <?if($errors) {?>
        Begin Mod 
   <? if ($_POST and (! $errors and ! $errors and ! $errors and ! $errors /*and ! $errors*/)) { ?>
   <p align="center" id="errormessage"><?=$errors?></p>
   <? } else { ?> <p align="center" id="errormessage"><?=$errors?></p>
   <? } ?>
   <?}elseif($msg) {?>
       <p align="center" id="infomessage"><?=$msg?></p>
   <?}elseif($warn) {?>
       <p id="warnmessage"><?=$warn?></p>
   <?}?>
</div>
<? if (! $_POST and ($errors or $errors or $errors or $errors)) { ?>
<div>Please fill in the form below to open a new ticket.</div>
<? } ?>
 start suggested topics 
<? if ($_POST and (! $errors and ! $errors and ! $errors and ! $errors /*and ! $errors*/)) { ?>
<div>
<p align="center" id="warnmessage" style="font-size">
To better assist you in finding the answer to your question as quickly as possible,
<br />we found the following articles that may be relevant to your inquiry: </p>
<ul>
<?
function truncate_str($str, $maxlen)
{ $newstr = substr($str, 0, $maxlen);
 $newstr = substr($newstr, 0, strrpos($newstr, " "));
 return $newstr;
}                $query = $info . ' ' . $info;
                                $topicId = $info;
                $get_tag= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 and topic_id ='.$info.' ORDER BY topic');
                               list($topicId,$topic)=db_fetch_row($get_tag);
$suggested= db_query("SELECT ( 3 * MATCH(thema) AGAINST('*$query*' IN BOOLEAN MODE)) + ( 1 * MATCH(keywords) AGAINST('*$query*' IN BOOLEAN MODE)) + ( 8 * MATCH(content) AGAINST('*$query*' IN BOOLEAN MODE)) AS relevancy, faqdata.thema, faqdata.id,
content AS preview
FROM clarityp_faq.faqdata,clarityp_faq.faqdata_tags,clarityp_faq.faqtags
WHERE MATCH(thema,keywords) AGAINST('*$query*' IN BOOLEAN MODE)
and faqtags.tagging_name = '$topic' and faqdata_tags.tagging_id = faqtags.tagging_id
and faqdata.id = faqdata_tags.record_id
and faqdata.active = 'yes'
HAVING relevancy > 0 ORDER BY relevancy DESC
LIMIT 0,5");
                while (list($relevancy,$title,$articleid,$preview) = db_fetch_row($suggested)){ ?>
                                       <li><strong><a class="sizeChart" href="#" onclick="validate(<?=$articleid?>)"><?=$title?></a></strong><br />
                                       <? $preview = strip_tags($preview); echo truncate_str($preview,90)?>....</li>
               <?
                }?>
</ul>
<div id="foo"></div>
                </div><br />
<div style="font-size;font-weight;margin-bottom">If the above articles do not answer your question, <br />use the form below to send your inquiry to our support team.
</div>
 end suggested topics 
<? }?>

clarityproductions

REPLACE:

<form action="new_open.php" method="POST" enctype="multipart/form-data">

<table align="left" cellpadding=2 cellspacing=1 width="90%">

<tr>

<th width="20%">Full Name:</th>

<td>

<?if ($thisclient && ($name=$thisclient->getName())) {

?>

<input type="hidden" name="name" value="<?=$name?>"><?=$name?>

<?}else {?>

<input type="text" name="name" size="25" value="<?=$info?>">

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th nowrap >Email Address:</th>

<td>

<?if ($thisclient && ($email=$thisclient->getEmail())) {

?>

<input type="hidden" name="email" size="25" value="<?=$email?>"><?=$email?>

<?}else {?>

<input type="text" name="email" size="25" value="<?=$info?>">

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<td>Telephone:</td>

<td><input type="text" name="phone" size="25" value="<?=$info?>">

 Ext <input type="text" name="phone_ext" size="6" value="<?=$info?>">

 <font class="error"> <?=$errors?></font></td>

</tr>

<tr height=2px><td align="left" colspan=2 > </td></tr>

<tr>

<th>Help Topic:</th>

<td>

<select name="topicId">

<option value="" selected >Select One</option>

<?

$services= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 ORDER BY topic');

while (list($topicId,$topic) = db_fetch_row($services)){

$selected = ($info==$topicId)?'selected':''; ?>

<option value="<?=$topicId?>"<?=$selected?>><?=$topic?></option>

<?

}?>

<option value="0" >General Inquiry</option>

</select>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>Subject:</th>

<td>

<input type="text" name="subject" size="35" value="<?=$info?>">

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th valign="top">Message:</th>

<td>

<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>

<textarea name="message" cols="35" rows="8" wrap="soft" style="width%"><?=$info?></textarea></td>

</tr>

<?

if($cfg->allowPriorityChange() ) {

$sql='SELECT priority_id,priority_desc FROM '.TICKET_PRIORITY_TABLE.' WHERE ispublic=1 ORDER BY priority_urgency DESC';

if(($priorities=db_query($sql)) && db_num_rows($priorities)){ ?>

<tr>

<td>Priority:</td>

<td>

<select name="pri">

<?

$info=$info?$info:$cfg->getDefaultPriorityId(); //use system's default priority.

while($row=db_fetch_array($priorities)){ ?>

<option value="<?=$row?>" <?=$info==$row?'selected':''?> ><?=$row?></option>

<?}?>

</select>

</td>

</tr>

<? }

}?>

<?if(($cfg->allowOnlineAttachments() && !$cfg->allowAttachmentsOnlogin())

|| ($cfg->allowAttachmentsOnlogin() && ($thisclient && $thisclient->isValid()))){

?>

<tr>

<td>Attachment:</td>

<td>

<input type="file" name="attachment"><font class="error"> <?=$errors?></font>

</td>

</tr>

<?}?>

<tr height=2px><td align="left" colspan=2 > </td></tr>

<tr>

<td></td>

<td>

<input class="button" type="submit" name="submit_x" value="Submit Ticket">

<input class="button" type="reset" value="Reset">

<input class="button" type="button" name="cancel" value="Cancel" onClick='window.location.href="index.php"'>

</td>

</tr>

</table>

</form>

WITH:

<form action="new_open.php" method="POST" enctype="multipart/form-data">

<? if ($_POST and (! $errors and ! $errors and ! $errors and ! $errors /*and ! $errors*/)) { ?>

<input type="hidden" name="submitonce" value="1" />

<? } ?>

<? if ($noerror) { ?>

<?if(($cfg->allowOnlineAttachments() && !$cfg->allowAttachmentsOnlogin())

|| ($cfg->allowAttachmentsOnlogin() && ($thisclient && $thisclient->isValid()))){

?>

<table>

<tr>

<td>Attachment:</td>

<td>

<input type="file" name="attachment"><font class="error"> <?=$errors?></font>

</td>

</tr>

</table>

<?}?>

<input type="hidden" name="name" value="<?=$info?>">

<input type="hidden" name="email" value="<?=$info?>" />

<input type="hidden" name="phone_ext" value="<?=$info?>" />

<input type="hidden" name="phone" value="<?=$info?>" />

<input type="hidden" name="topicId" value="<?=($info)?>" />

<input type="hidden" name="subject" value="<?=$info?>">

<input type="hidden" name="message" value="<?=$info?>">

<input class="button" type="submit" name="submit_x" value="Submit Ticket">

<input class="button" type="button" name="cancel" value="Cancel" onClick='window.location.href="index.php"'>

<? if($cfg->allowPriorityChange() ) { $info; } ?>

CONTINUES IN NEXT MESSAGE

clarityproductions

CONTINUED FROM PREVIOUS MESSAGE:

<? } else { ?>

<table align="left" cellpadding=2 cellspacing=1 width="90%">

<tr>

<th width="20%">Full Name:</th>

<td>

<?if ($thisclient && ($name=$thisclient->getName())) {

?>

<input type="hidden" name="name" value="<?=$name?>"><?=$name?>

<?}else {?>

<input type="text" name="name" size="25" value="<?=$info?>">

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th nowrap >Email Address:</th>

<td>

<?if ($thisclient && ($email=$thisclient->getEmail())) {

?>

<input type="hidden" name="email" size="25" value="<?=$email?>"><?=$email?>

<?}else {?>

<input type="text" name="email" size="25" value="<?=$info?>">

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<td>Telephone:</td>

<td><input type="text" name="phone" size="25" value="<?=$info?>">

 Ext <input type="text" name="phone_ext" size="6" value="<?=$info?>">

 <font class="error"> <?=$errors?></font></td>

</tr>

<tr height=2px><td align="left" colspan=2 > </td></tr>

<tr>

<th>Help Topic:</th>

<td>

<select name="topicId">

<option value="" selected >Select One</option>

<?

$services= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 ORDER BY topic');

while (list($topicId,$topic) = db_fetch_row($services)){

$selected = ($info==$topicId)?'selected':''; ?>

<option value="<?=$topicId?>"<?=$selected?>><?=$topic?></option>

<?

}?>

<option value="0" >General Inquiry</option>

</select>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>Subject:</th>

<td>

<input type="text" name="subject" size="35" value="<?=$info?>">

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th valign="top">Message:</th>

<td>

<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>

<textarea name="message" cols="35" rows="8" wrap="soft" style="width%"><?=$info?></textarea></td>

</tr>

<?

if($cfg->allowPriorityChange() ) {

$sql='SELECT priority_id,priority_desc FROM '.TICKET_PRIORITY_TABLE.' WHERE ispublic=1 ORDER BY priority_urgency DESC';

if(($priorities=db_query($sql)) && db_num_rows($priorities)){ ?>

<tr>

<td>Priority:</td>

<td>

<select name="pri">

<?

$info=$info?$info:$cfg->getDefaultPriorityId(); //use system's default priority.

while($row=db_fetch_array($priorities)){ ?>

<option value="<?=$row?>" <?=$info==$row?'selected':''?> ><?=$row?></option>

<?}?>

</select>

</td>

</tr>

<? }

}?>

<?if(($cfg->allowOnlineAttachments() && !$cfg->allowAttachmentsOnlogin())

|| ($cfg->allowAttachmentsOnlogin() && ($thisclient && $thisclient->isValid()))){

?>

<tr>

<td>Attachment:</td>

<td>

<input type="file" name="attachment"><font class="error"> <?=$errors?></font>

</td>

</tr>

<?}?>

<tr height=2px><td align="left" colspan=2 > </td></tr>

<tr>

<td></td>

<td>

<input class="button" type="submit" name="submit_x" value="Submit Ticket">

<input class="button" type="reset" value="Reset">

<input class="button" type="button" name="cancel" value="Cancel" onClick='window.location.href="index.php"'>

</td>

</tr>

</table>

<? } ?>

</form>

clarityproductions

*===============================

MOD BEGIN FOR PHPMYFAQ

===============================*

phpMyFaq

Open index.php

replace:

if (isset($_REQUEST) && is_string($_REQUEST) && !preg_match("=/=", $_REQUEST) && isset($allowedVariables[$_REQUEST)) {

$action = trim($_REQUEST); }

} else {

$action = "main";

}

with:

if (isset($_REQUEST) && is_string($_REQUEST) && !preg_match("=/=", $_REQUEST) && isset($allowedVariables[$_REQUEST)) {

$action = trim($_REQUEST);

$template_action = trim($_REQUEST);

} else {

$action = "main";

}

replace:

if (isset($auth)) {

$login_tpl = 'template/loggedin.tpl';

with:

if (isset($_REQUEST)) { $template_action = $_REQUEST; }

if (isset($auth)) {

$login_tpl = 'template/loggedin.tpl';

replace:

$tpl = new PMF_Template (array(

'index' => 'template/index.tpl',

'loginBox' => $login_tpl,

'rightBox' => $right_tpl,

'writeContent' => $inc_tpl));

with:

if (isset($_REQUEST)) {

$tpl = new PMF_Template (array(

'index' => 'template/ost_index.tpl',

'loginBox' => $login_tpl,

'rightBox' => $right_tpl,

'writeContent' => $inc_tpl));

} else {

$tpl = new PMF_Template (array(

'index' => 'template/index.tpl',

'loginBox' => $login_tpl,

'rightBox' => $right_tpl,

'writeContent' => $inc_tpl));

}

create a template file templates/ost_index.tpl

paste the code below into the file:

<!<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">>

<html xmlns="http://www.w3.org/1999/xhtml" xml="{metaLanguage}" lang="{metaLanguage}">

<head>

<title>{title}</title>

<base href="{baseHref}" />

<meta http-equiv="Content-Type" content="application/xhtml+xml; charset={metaCharset}" />

<meta name="title" content="{metaTitle}" />

<meta name="description" content="{metaDescription}" />

<meta name="keywords" content="{metaKeywords}" />

<meta name="author" content="{metaPublisher}" />

<meta name="publisher" content="{metaPublisher}" />

<meta name="generator" content="phpMyFAQ {version}" />

<meta name="Content-Language" content="{metaCharset}" />

<meta name="robots" content="INDEX, FOLLOW" />

<meta name="revisit-after" content="7 days" />

<meta name="MSSmartTagsPreventParsing" content="true" />

<script type="text/javascript" src="inc/js/functions.js"></script>

<link rel="shortcut icon" href="template/favicon.ico" type="image/x-icon" />

<link rel="icon" href="template/favicon.ico" type="image/x-icon" />

<link rel="alternate" title="News RSS Feed" type="application/rss+xml" href="feed/news/rss.php" />

<link rel="alternate" title="TopTen RSS Feed" type="application/rss+xml" href="feed/topten/rss.php" />

<link rel="alternate" title="Latest FAQ Records RSS Feed" type="application/rss+xml" href="feed/latest/rss.php" />

<link rel="alternate" title="Open Questions RSS Feed" type="application/rss+xml" href="feed/openquestions/rss.php" />

<link rel="microsummary" type="application/x.microsummary+xml" href="microsummary.php?action={action}" />

<link rel="search" type="application/opensearchdescription+xml" title="{metaTitle}" href="{opensearch}" />

</head>

<body dir="{dir}" onload="java_script();">

start main content

<div class="centercolumn">

<div class="centerpadding">

<div class="main-content" id="main">

{writeContent}

</div>

end main content

</body>

</html>

save a copy of of templates/artikel.tpl as ost_artikel.tpl

paste the code below into the file:

<h2>{writeThema}</h2>

Article

<div id="article_content">{writeContent}</div>

/Article

Voting Form

<div id="voting">

<form action="{saveVotingPATH}" method="post" target="_blank" style="display: inline;">

<fieldset>

<legend>{msgVoteUseability}</legend>

<input type="hidden" name="artikel" value="{saveVotingID}" />

<p align="center"><strong>{msgAverageVote}</strong> {printVotings}</p>

<p align="center">{msgVoteBad}

<input class="radio" type="radio" name="vote" value="1" /> 1

<input class="radio" type="radio" name="vote" value="2" /> 2

<input class="radio" type="radio" name="vote" value="3" /> 3

<input class="radio" type="radio" name="vote" value="4" /> 4

<input class="radio" type="radio" name="vote" value="5" /> 5

{msgVoteGood}<br />

<input class="submit" type="submit" name="submit" value="{msgVoteSubmit}" />

</p>

</fieldset>

</form>

</div>

/Voting Form

*NOTES: *

The articles shown on the new ticket page to the customer are shown

based on the tags / help topic names matching. For example if you have a help topic "ABC Returns" you would want to put the matching tag "ABC Returns" into each article in phpMyFaq realted to that help topic.

Secondly the query $suggested in open.inc.php uses my database references. You will need to change the FROM tables to match your own.

Finally the ajax call in the javascript in open.inc.php uses my phpMyFaq location. Your location may be different and /faq/ need to be changed to match yours.

http.open("GET", "/faq/index.php?ost_action=ost_artikel&action=artikel&artlang=en&id=" + kba, true);

If you have any problems with this mod let me know and I will be happy to help you where I can.

darylt

This looks great!

Do I need to install phpMyFAQ in a different folder or the same one as osTicket?

Do I use a separate database or the same one as osTicket?

Thanks

clarityproductions

I installed phpMyFAQ in a different folder and it uses its own database like a normal install would. Its really independent of OSticket with the slight mods to make it display on the new ticket open page on ost. Good luck.

gabev

the new phpMyFAQ 2.5.2 index.php file the line:

if (isset($_REQUEST) && is_string($_REQUEST) && !preg_match("=/=", $_REQUEST) && isset($allowedVariables[$_REQUEST)) {

$action = trim($_REQUEST);

$template_action = trim($_REQUEST);

} else {

$action = "main";

}

has to replace what line ?

I followed the instructions but i couldn't find the line of code which has to be replaced.Anyone had problems integrating osTicket with the new version of phpMyFAQ?

clarityproductions

Sorry. I don't understand your question/problem. I have not used the new version myself but I imagine its fairly similar. If you can explain your problem in detail perhaps I can help you.

gabev

I installed latest version of OSTicket(1.6 R5) and also latest phpMyFAQ(ver 2.5.2).

On the file index.php of phpMyFaq I looked to replace(which doesnt exist anymore):

################

if (isset($_REQUEST) && is_string($_REQUEST) && !preg_match("=/=", $_REQUEST) && isset($allowedVariables[$_REQUEST)) {

$action = trim($_REQUEST); }

} else {

$action = "main";

}

##################

with:

##################

if (isset($_REQUEST) && is_string($_REQUEST) && !preg_match("=/=", $_REQUEST) && isset($allowedVariables[$_REQUEST)) {

$action = trim($_REQUEST);

$template_action = trim($_REQUEST);

} else {

$action = "main";

}

##################

The rest of of the code I could find and replace accordingly.

when I submited a ticket ...the sugestion for answer was not displayed ..despite the fact that my tags and help topics were having the same name.

clarityproductions

Can you post the source of index.php. I will take a look at it.

gabev

index.php of phpMyFAQ ver 2.5.2

i attached the file . this is the index.php of phpmyfaq ver 2.5.2

[index.php.txt](https://forum.osticket.com/assets/files/migrated/0/4cbd0f92f7d3560f3aebbc1853170b2.txt)

clarityproductions

I suggest you take a look at line 312-314. This looks to be where the action main is set.

So try to replace:

if (preg_match("=/=", $action) && !isset($allowedVariables)) {

$action = 'main';

}

with:

if (preg_match("=/=", $action) && !isset($allowedVariables)) {

$action = trim($_REQUEST);

$template_action = trim($_REQUEST);

} else {

$action = "main";

}

Let me know if that works.

gabev

Yes, it's working now.

Thank you so much.

Gabriel

gabev

clarityproductions,

One little detail. If no article is found in the phpMyFAQ when a client wants to submit a ticket there is no visual indication, nothing is displayed.I think something like this type of message : "No articles were found at this time, please continue to submit your ticket" ...would really help any customer.By looking at the code it doesnt look like is a walk in the park, rather complicated.Any suggestion where I should start?

pbrough

No Results

I have been trying the same thing and there is a problem with the output. If I enter the code

if (preg_match("=/=", $action) && !isset($allowedVariables)) {

$action = trim($_REQUEST);

$template_action = trim($_REQUEST);

} else {

$action = "main";

}

Then the FAQ stops functioning in the main interface. The only information that can be displayed is the News and the News Archive.

I am also having a problem getting information out of the system even for a very simply entry. The subject of the ticket is ABC and there is an approved entry in the FAQ for ABC with the same tag.

I have attached the index.php for review.

This is going to be a really good thing if it works.

[index.txt](https://forum.osticket.com/assets/files/migrated/c/0bab6284cc2ee47be2c67cca024d7e9.txt)

shaiss

Are there any screenshots for this? Possibly a demo? I noticed the link pictures are protected by auth. Also, I noticed this was done with an older version of phpMYFAQ, have you updated it for v2.5.3 or 2.6?

Silky Mesmeriser

It took me a while to get this mod up and running but with some effort it did work, I am posting to note a couple of pitfalls I had incase they help some others. I am also including a small mod I made to solve the problem mentioned in this thread of there being no visual indication where there are no results.

Firstly the installation:

The original instructions still apply for osTicket, but for phpMyFAQ the first mods for 2.6.6 are different ignore the ones posted earlier and use these instead

Replace:if (isset($auth)) {

$login_tpl = 'loggedin.tpl';With:if (isset($_REQUEST)) { $template_action = $_REQUEST; }

if (isset($auth)) {

$login_tpl = 'loggedin.tpl';

Replace:$tpl = new PMF_Template (array(

'index' => 'index.tpl',

'loginBox' => $login_tpl,

'rightBox' => $right_tpl,

'writeContent' => $inc_tpl));With:if (isset($_REQUEST)) {

$tpl = new PMF_Template (array(

'index' => 'ost_index.tpl',

'loginBox' => $login_tpl,

'rightBox' => $right_tpl,

'writeContent' => $inc_tpl));

} else {

$tpl = new PMF_Template (array(

'index' => 'index.tpl',

'loginBox' => $login_tpl,

'rightBox' => $right_tpl,

'writeContent' => $inc_tpl));

}

Next, more of a note that anything it wasn't mentioned in the initial post and it took me a while to figure why I was getting errors. The path to phpMyFAQ and the database/table names for phpMyFAQ are hardcoded and overridden in osTicket in the file includes/client/open.inc.php also it will be the osTicket user accessing the phpMyFAQ database so remember to grant permissions.

Finally, the promised mod of mine:

This mod deals with the lack of feedback provided to the user when the FAQ search returns no results, the current empty gap is confusing for users. This mod will replace the null result with a message "No relevant articles found, Please continue to submit your ticket bellow."

The mod is simple enough, Replace: while (list($relevancy,$title,$articleid,$preview) = db_fetch_row($suggested)){ ?>

<li><strong><a class="sizeChart" href="#" onclick="validate(<?=$articleid?>)"><?=$title?></a></strong><br />

<? $preview = strip_tags($preview); echo truncate_str($preview,90)?>....</li>

<?

}?>

With://Edited to check if any answers were found and provide indication if null

$suggestion= db_fetch_row($suggested);

if (list($relevancy,$title,$articleid,$preview) = $suggestion){

while (list($relevancy,$title,$articleid,$preview) = $suggestion){ ?>

<li><strong><a class="sizeChart" href="#" onclick="validate(<?=$articleid?>)"><?=$title?></a></strong><br />

<? $preview = strip_tags($preview); echo truncate_str($preview,90)?>....</li>

<? $suggestion= db_fetch_row($suggested);

}

} else { ?>

<strong>No relevant articles found, Please continue to submit your ticket bellow.</strong><br />

<? } ?>

pti_breton

Hi all,

I did all the modifications but i have no result at all :(

I also updated the code for the database and the folders and created an article in phpMyFAQ including a helptopic label.

When i enter a subject after choosing a helptopic, nothing happens.

Does someone could post what the suggestion looks like ?

When this suggestion is supposed to be shown ?

pti_breton

After some tests i finally discovered i only had to submit the form to have the suggestion.

Now, whereas i choose a helptopic mentionned in an article from phpMyFAQ and in its tags, i always have the message "no relevant articles fournd..."

The MysSQL user is allowed to the 2 databases.

andrew55

I would love to get the updated version of this mod. I worked on it for several hours but was not able to get it to function with the newer versions of osticket and phpmyfaq.

I seemed to be having the most problems with the edits in index.php in phpmyfaq. Also, I got lost on how to grant user permissions in the phpMyFAQ database as suggested by Silky Mesmeriser.

I think this mod would be a great addition to integrate the two programs together. If anyone has better coding expereince than me, I would love any suggestions for getting this up to date.