public function getChildCategories($catId, $titleMax) { $categories = array(); $query = "\n\t\t\t\tSELECT c.id, c.name as title, c.alias\n\t\t\t\tFROM #__k2_categories c\n\t\t\t\tWHERE\n\t\t\t\t\tc.published = 1\n\t\t\t\t\tAND c.parent = {$catId}\n\t\t\t"; $this->db->setQuery($query); $rows = $this->db->loadObjectList(); foreach ($rows as $category) { $categories[$category->id] = $category; // // category url // $slug = $category->alias ? $category->id.':'.$category->alias : $category->id; // $category->url = JRoute::_( ContentHelperRoute::getCategoryRoute($slug) ); $category->url = urldecode(JRoute::_(K2HelperRoute::getCategoryRoute($category->id . ':' . urlencode($category->alias)))); // category title truncate $category->title = YtUtils::shorten($category->title, $titleMax); } return $categories; }