/** 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; }