/** function to save the faq comment
* @param array $input_array - array which contains the following values
=> int $id - Customer ie., Contact id
int $sessionid - session id
int $faqid - faq id
string $comment - comment to be added with the FAQ
* return array $result - This function will call get_KBase_details and return that array
*/
function save_faq_comment($input_array)
{
$adb = PearDatabase::getInstance();
$adb->println("Entering customer portal function save_faq_comment");
$adb->println($input_array);
$id = $input_array['id'];
$sessionid = $input_array['sessionid'];
$faqid = (int) $input_array['faqid'];
$comment = $input_array['comment'];
if (!validateSession($id, $sessionid)) {
return null;
}
$createdtime = $adb->formatDate(date('YmdHis'), true);
if (trim($comment) != '') {
$faq_query = "insert into vtiger_faqcomments values(?,?,?,?)";
$adb->pquery($faq_query, array('', $faqid, $comment, $createdtime));
}
$params = array('id' => "{$id}", 'sessionid' => "{$sessionid}");
$result = get_KBase_details($input_array);
return $result;
}
function save_faq_comment($faqid, $comment)
{
global $adb;
$createdtime = date('Y-m-d H:i:s');
$faq_query = "insert into faqcomments values(''," . $faqid . ",'" . $comment . "','" . $createdtime . "')";
$adb->query($faq_query);
$result = get_KBase_details('');
return $result;
}
