if ($listtype == 'kbprod') {
$query = "SELECT * FROM #__fsf_prod";
$where = array();
$where[] = "published = 1";
$where[] = "inkb = 1";
if (FSF_Helper::Is16()) {
$user = JFactory::getUser();
$where[] = 'access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')';
}
if (count($where) > 0) {
$query .= " WHERE " . implode(" AND ", $where);
}
$query .= " ORDER BY ordering";
$db->setQuery($query);
$rows = $db->loadAssocList();
FSF_Helper::Tr($rows);
require JModuleHelper::getLayoutPath('mod_fsf_catprods', 'kbprod');
} else {
if ($listtype == 'kbcats') {
$prodid = $params->get('prodid');
if ($prodid == -1) {
$prodid = JRequest::getVar('prodid');
}
if ($prodid > 0) {
$qry1 = "SELECT a.kb_cat_id FROM #__fsf_kb_art as a LEFT JOIN #__fsf_kb_art_prod as p ON a.id = p.kb_art_id WHERE p.prod_id = '" . FSFJ3Helper::getEscaped($db, $prodid) . "' AND published = 1 GROUP BY a.kb_cat_id";
$qry2 = "SELECT a.kb_cat_id FROM #__fsf_kb_art as a WHERE a.allprods = '1' AND published = 1 GROUP BY a.kb_cat_id";
$query = "({$qry1}) UNION ({$qry2})";
$db->setQuery($query);
$rows = $db->loadAssocList('kb_cat_id');
$catids = array();
foreach ($rows as &$rows) {
