", $message);
$replacetags = array( 'b' => 'strong', 'i' => 'em', 'u' => 'ul', 'div' => 'div' );
foreach( $replacetags as $k => $v )
{
$message = str_replace("[" . $k . "]", "<" . $k . ">", $message);
$message = str_replace("[/" . $k . "]", "", $message);
}
$message = nl2br($message);
$message = ticketautohyperlinks($message);
return $message;
}
function getKBAutoSuggestions($text)
{
$kbarticles = array( );
$hookret = run_hook('SubmitTicketAnswerSuggestions', array( 'text' => $text ));
if( count($hookret) )
{
foreach( $hookret as $hookdat )
{
foreach( $hookdat as $arrdata )
{
$kbarticles[] = $arrdata;
}
}
}
else
{
$ignorewords = array( 'able', 'about', 'above', 'according', 'accordingly', 'across', 'actually', 'after', 'afterwards', 'again', 'against', "ain't", 'allow', 'allows', 'almost', 'alone', 'along', 'already', 'also', 'although', 'always', 'among', 'amongst', 'another', 'anybody', 'anyhow', 'anyone', 'anything', 'anyway', 'anyways', 'anywhere', 'apart', 'appear', 'appreciate', 'appropriate', "aren't", 'around', 'aside', 'asking', 'associated', 'available', 'away', 'awfully', 'became', 'because', 'become', 'becomes', 'becoming', 'been', 'before', 'beforehand', 'behind', 'being', 'believe', 'below', 'beside', 'besides', 'best', 'better', 'between', 'beyond', 'both', 'brief', "c'mon", 'came', "can't", 'cannot', 'cant', 'cause', 'causes', 'certain', 'certainly', 'changes', 'clearly', 'come', 'comes', 'concerning', 'consequently', 'consider', 'considering', 'contain', 'containing', 'contains', 'corresponding', 'could', "couldn't", 'course', 'currently', 'definitely', 'described', 'despite', "didn't", 'different', 'does', "doesn't", 'doing', "don't", 'done', 'down', 'downwards', 'during', 'each', 'eight', 'either', 'else', 'elsewhere', 'enough', 'entirely', 'especially', 'even', 'ever', 'every', 'everybody', 'everyone', 'everything', 'everywhere', 'exactly', 'example', 'except', 'fifth', 'first', 'five', 'followed', 'following', 'follows', 'former', 'formerly', 'forth', 'four', 'from', 'further', 'furthermore', 'gets', 'getting', 'given', 'gives', 'goes', 'going', 'gone', 'gotten', 'greetings', "hadn't", 'happens', 'hardly', "hasn't", 'have', "haven't", 'having', "he's", 'hello', 'help', 'hence', 'here', "here's", 'hereafter', 'hereby', 'herein', 'hereupon', 'hers', 'herself', 'himself', 'hither', 'hopefully', 'howbeit', 'however', "i'll", "i've", 'ignored', 'immediate', 'inasmuch', 'indeed', 'indicate', 'indicated', 'indicates', 'inner', 'insofar', 'instead', 'into', 'inward', "isn't", "it'd", "it'll", "it's", 'itself', 'just', 'keep', 'keeps', 'kept', 'know', 'known', 'knows', 'last', 'lately', 'later', 'latter', 'latterly', 'least', 'less', 'lest', "let's", 'like', 'liked', 'likely', 'little', 'look', 'looking', 'looks', 'mainly', 'many', 'maybe', 'mean', 'meanwhile', 'merely', 'might', 'more', 'moreover', 'most', 'mostly', 'much', 'must', 'myself', 'name', 'namely', 'near', 'nearly', 'necessary', 'need', 'needs', 'neither', 'never', 'nevertheless', 'next', 'nine', 'nobody', 'none', 'noone', 'normally', 'nothing', 'novel', 'nowhere', 'obviously', 'often', 'okay', 'once', 'ones', 'only', 'onto', 'other', 'others', 'otherwise', 'ought', 'ours', 'ourselves', 'outside', 'over', 'overall', 'particular', 'particularly', 'perhaps', 'placed', 'please', 'plus', 'possible', 'presumably', 'probably', 'provides', 'quite', 'rather', 'really', 'reasonably', 'regarding', 'regardless', 'regards', 'relatively', 'respectively', 'right', 'said', 'same', 'saying', 'says', 'second', 'secondly', 'seeing', 'seem', 'seemed', 'seeming', 'seems', 'seen', 'self', 'selves', 'sensible', 'sent', 'serious', 'seriously', 'seven', 'several', 'shall', 'should', "shouldn't", 'since', 'some', 'somebody', 'somehow', 'someone', 'something', 'sometime', 'sometimes', 'somewhat', 'somewhere', 'soon', 'sorry', 'specified', 'specify', 'specifying', 'still', 'such', 'sure', 'take', 'taken', 'tell', 'tends', 'than', 'thank', 'thanks', 'thanx', 'that', "that's", 'thats', 'their', 'theirs', 'them', 'themselves', 'then', 'thence', 'there', "there's", 'thereafter', 'thereby', 'therefore', 'therein', 'theres', 'thereupon', 'these', 'they', "they'd", "they'll", "they're", "they've", 'think', 'third', 'this', 'thorough', 'thoroughly', 'those', 'though', 'three', 'through', 'throughout', 'thru', 'thus', 'together', 'took', 'toward', 'towards', 'tried', 'tries', 'truly', 'trying', 'twice', 'under', 'unfortunately', 'unless', 'unlikely', 'until', 'unto', 'upon', 'used', 'useful', 'uses', 'using', 'usually', 'value', 'various', 'very', 'want', 'wants', "wasn't", "we'd", "we'll", "we're", "we've", 'welcome', 'well', 'went', 'were', "weren't", 'what', "what's", 'whatever', 'when', 'whence', 'whenever', 'where', "where's", 'whereafter', 'whereas', 'whereby', 'wherein', 'whereupon', 'wherever', 'whether', 'which', 'while', 'whither', "who's", 'whoever', 'whole', 'whom', 'whose', 'will', 'willing', 'wish', 'with', 'within', 'without', "won't", 'wonder', 'would', "wouldn't", "you'd", "you'll", "you're", "you've", 'your', 'yours', 'yourself', 'yourselves', 'zero' );
$text = str_replace("\n", " ", $text);
$textparts = explode(" ", strtolower($text));
$validword = 0;
foreach( $textparts as $k => $v )
{
if( in_array($v, $ignorewords) || strlen($textparts[$k]) <= 3 || 100 <= $validword )
{
unset($textparts[$k]);
}
else
{
$validword++;
}
}
$kbarticles = getKBAutoSuggestionsQuery('title', $textparts, '5');
if( count($kbarticles) < 5 )
{
$numleft = 5 - count($kbarticles);
$kbarticles = array_merge($kbarticles, getKBAutoSuggestionsQuery('article', $textparts, $numleft, $kbarticles));
}
}
return $kbarticles;
}
function getKBAutoSuggestionsQuery($field, $textparts, $limit, $existingkbarticles = '')
{
$kbarticles = array( );
$where = '';
foreach( $textparts as $textpart )
{
$where .= $field . " LIKE '%" . db_escape_string($textpart) . "%' OR ";
}
$where = !$where ? "id!=''" : substr($where, 0, 0 - 4);
if( is_array($existingkbarticles) )
{
$existingkbids = array( );
foreach( $existingkbarticles as $v )
{
$existingkbids[] = (int) $v['id'];
}
$where = "(" . $where . ")";
if( 0 < count($existingkbids) )
{
$where .= " AND id NOT IN (" . db_build_in_array($existingkbids) . ")";
}
}
$result = full_query("SELECT id,parentid FROM tblknowledgebase WHERE " . $where . " ORDER BY useful DESC LIMIT 0," . (int) $limit);
while( $data = mysql_fetch_array($result) )
{
$articleid = $data['id'];
$parentid = $data['parentid'];
if( $parentid )
{
$articleid = $parentid;
}
$result2 = full_query("SELECT tblknowledgebaselinks.categoryid FROM tblknowledgebase INNER JOIN tblknowledgebaselinks ON tblknowledgebase.id=tblknowledgebaselinks.articleid INNER JOIN tblknowledgebasecats ON tblknowledgebasecats.id=tblknowledgebaselinks.categoryid WHERE (tblknowledgebase.id=" . (int) $articleid . " OR tblknowledgebase.parentid=" . (int) $articleid . ") AND tblknowledgebasecats.hidden=''");
$data = mysql_fetch_array($result2);
$categoryid = $data['categoryid'];
if( $categoryid )
{
$result2 = full_query("SELECT * FROM tblknowledgebase WHERE (id=" . (int) $articleid . " OR parentid=" . (int) $articleid . ") AND (language='" . db_escape_string($_SESSION['Language']) . "' OR language='') ORDER BY language DESC");
$data = mysql_fetch_array($result2);
$title = $data['title'];
$article = $data['article'];
$views = $data['views'];
$kbarticles[] = array( 'id' => $articleid, 'category' => $categoryid, 'title' => $title, 'article' => ticketsummary($article), 'text' => $article );
}
}
return $kbarticles;
}
function ticketsummary($text, $length = 100)
{
$tail = "...";
$text = strip_tags($text);
$txtl = strlen($text);
if( $length < $txtl )
{
for( $i = 1; $text[$length - $i] != " "; $i++ )
{
if( $i == $length )
{
return substr($text, 0, $length) . $tail;
}
}
$text = substr($text, 0, $length - $i + 1) . $tail;
}
return $text;
}
function getTicketContacts($userid)
{
$contacts = '';
$result = select_query('tblcontacts', '', array( 'userid' => $userid, 'email' => array( 'sqltype' => 'NEQ', 'value' => '' ) ));
while( $data = mysql_fetch_array($result) )
{
$contacts .= "