Category view - show items in subcategories

function getItemsViaCategoryId($id){ global $mainframe, $option; $params = & $mainframe->getParams('com_flexicontent'); $user = & JFactory::getUser(); $db = & JFactory::getDBO(); $lang = JRequest::getWord('lang', '' ); $where = ' WHERE rel.catid = '.$id; // Second is to only select items the user has access to $states = '1, -5'; if ($user->authorize('com_flexicontent', 'state')) { $states .= ', 0 , -3, -4'; } $where .= ' AND i.state IN ('.$states.')'; $where .= ' AND i.sectionid = ' . FLEXI_SECTION; if (FLEXI_FISH) { $where .= ' AND ie.language LIKE ' . $db->Quote( $lang .'%' ); } $query = 'SELECT DISTINCT i.*, ie.*, u.name as author, ty.name AS typename,' . ' CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(\':\', i.id, i.alias) ELSE i.id END as slug' . ' FROM #__content AS i' . ' LEFT JOIN #__flexicontent_items_ext AS ie ON ie.item_id = i.id' . ' LEFT JOIN #__flexicontent_types AS ty ON ie.type_id = ty.id' . ' LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id' . ' LEFT JOIN #__categories AS c ON c.id = '. $id . ' LEFT JOIN #__users AS u ON u.id = i.created_by' .$where; $db->setQuery( $query); $db->query(); $data = $db->loadObjectList(); $items = FlexicontentFields::getFields($data, 'category', $params); return $items; }

foreach ($this->categories as $sub) :

$items = getItemsViaCategoryId($sub->id); foreach ($items as $item) : //...now you can do your position magic endforeach;

just replace the line $items = FlexicontentFields::getFields($data, 'categories', $params);

$items = FlexicontentFields::getFields($data, 'items', $params);