/**
* Method used to get the list of FAQ entries available in the system.
*
* @access public
* @return array The list of news entries
*/
function getList()
{
$stmt = "SELECT\n faq_id,\n faq_prj_id,\n faq_title,\n faq_rank\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "faq\n ORDER BY\n faq_rank ASC";
$res = $GLOBALS["db_api"]->dbh->getAll($stmt, DB_FETCHMODE_ASSOC);
if (PEAR::isError($res)) {
Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
return "";
} else {
// get the list of associated support levels
for ($i = 0; $i < count($res); $i++) {
if (Customer::doesBackendUseSupportLevels($res[$i]['faq_prj_id'])) {
$res[$i]['support_levels'] = implode(", ", array_values(FAQ::getAssociatedSupportLevels($res[$i]['faq_prj_id'], $res[$i]['faq_id'])));
}
}
return $res;
}
}
