public static function breadcrumbs($params) { $mainframe = JFactory::getApplication(); $array = array(); $view = JRequest::getCmd('view'); $id = JRequest::getInt('id'); $option = JRequest::getCmd('option'); $task = JRequest::getCmd('task'); $db = JFactory::getDBO(); $user = JFactory::getUser(); $aid = (int) $user->get('aid'); $menu = $mainframe->getMenu(); $active = $menu->getActive(); if ($option == 'com_k2') { switch ($view) { case 'item': if (K2_JVERSION != '15') { $languageCheck = ''; if ($mainframe->getLanguageFilter()) { $languageTag = JFactory::getLanguage()->getTag(); $languageCheck = " AND language IN (" . $db->Quote($languageTag) . ", " . $db->Quote('*') . ") "; } $query = "SELECT * FROM #__k2_items WHERE id={$id} AND published=1 AND trash=0 AND access IN(" . implode(',', $user->getAuthorisedViewLevels()) . ") {$languageCheck} AND EXISTS (SELECT * FROM #__k2_categories WHERE #__k2_categories.id= #__k2_items.catid AND published=1 AND access IN(" . implode(',', $user->getAuthorisedViewLevels()) . ") {$languageCheck} )"; } else { $query = "SELECT * FROM #__k2_items WHERE id={$id} AND published=1 AND trash=0 AND access<={$aid} AND EXISTS (SELECT * FROM #__k2_categories WHERE #__k2_categories.id= #__k2_items.catid AND published=1 AND access<={$aid})"; } $db->setQuery($query); $row = $db->loadObject(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } $matchItem = !is_null($active) && @$active->query['view'] == 'item' && @$active->query['id'] == $id; $matchCategory = !is_null($active) && @$active->query['view'] == 'itemlist' && @$active->query['task'] == 'category' && @$active->query['id'] == $row->catid; if ($matchItem || $matchCategory) { $title = $matchCategory ? $row->title : ''; $path = modK2ToolsHelper::getSitePath(); return array($path, $title); } $title = $row->title; $path = modK2ToolsHelper::getCategoryPath($row->catid); break; case 'itemlist': if ($task == 'category') { $match = !is_null($active) && @$active->query['view'] == 'itemlist' && @$active->query['task'] == 'category' && @$active->query['id'] == $id; if ($match) { $title = ''; $path = modK2ToolsHelper::getSitePath(); return array($path, $title); } $query = "SELECT * FROM #__k2_categories WHERE id={$id} AND published=1 AND trash=0 "; if (K2_JVERSION != '15') { $query .= " AND access IN(" . implode(',', $user->getAuthorisedViewLevels()) . ") "; if ($mainframe->getLanguageFilter()) { $languageTag = JFactory::getLanguage()->getTag(); $query .= " AND language IN (" . $db->Quote($languageTag) . ", " . $db->Quote('*') . ") "; } } else { $query .= " AND access <= {$aid}"; } $db->setQuery($query); $row = $db->loadObject(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } $title = $row->name; $path = modK2ToolsHelper::getCategoryPath($row->parent); } else { $document = JFactory::getDocument(); $title = $document->getTitle(); $path = modK2ToolsHelper::getSitePath(); } break; case 'latest': $document = JFactory::getDocument(); $title = $document->getTitle(); $path = modK2ToolsHelper::getSitePath(); break; } } else { $document = JFactory::getDocument(); $title = $document->getTitle(); $path = modK2ToolsHelper::getSitePath(); } return array($path, $title); }
function breadcrumbs($params) { $array = array(); $view = JRequest::getCmd('view'); $id = JRequest::getInt('id'); $option = JRequest::getCmd('option'); $task = JRequest::getCmd('task'); $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $aid = (int) $user->get('aid'); if ($option == 'com_k2') { switch ($view) { case 'item': $query = "SELECT * FROM #__k2_items WHERE id={$id} AND published=1 AND trash=0 AND access<={$aid} AND EXISTS (SELECT * FROM #__k2_categories WHERE #__k2_categories.id= #__k2_items.catid AND published=1 AND access<={$aid})"; $db->setQuery($query); $row = $db->loadObject(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } $title = $row->title; $path = modK2ToolsHelper::getCategoryPath($row->catid); break; case 'itemlist': if ($task == 'category') { $query = "SELECT * FROM #__k2_categories WHERE id={$id} AND published=1 AND trash=0 AND access<={$aid}"; $db->setQuery($query); $row = $db->loadObject(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } $title = $row->name; $path = modK2ToolsHelper::getCategoryPath($row->parent); } else { $document =& JFactory::getDocument(); $title = $document->getTitle(); $path = modK2ToolsHelper::getSitePath(); } break; } } else { $document =& JFactory::getDocument(); $title = $document->getTitle(); $path = modK2ToolsHelper::getSitePath(); } return array($path, $title); }