function getObjectLink($id)
{
$link = '';
require_once JPATH_ROOT . DS . 'components' . DS . 'com_moofaq' . DS . 'helpers' . DS . 'route.php';
$query = 'SELECT a.id, a.sectionid, a.access,' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug' . ' FROM #__content AS a' . ' LEFT JOIN #__categories AS cc ON cc.id = a.catid' . ' WHERE a.id = ' . $id;
$db = JFactory::getDbo();
$db->setQuery($query);
$row = $db->loadObject();
$user = JFactory::getUser();
if ($row->access <= $user->get('aid', 0)) {
$link = JRoute::_(MoofaqHelperRoute::getArticleRoute($row->slug, $row->catslug, $row->sectionid));
} else {
$link = JRoute::_("index.php?option=com_user&task=register");
}
return $link;
}
function getObjectLink($id)
{
$link = '';
if (JCOMMENTS_JVERSION == '1.5') {
require_once JPATH_ROOT . DS . 'components' . DS . 'com_moofaq' . DS . 'helpers' . DS . 'route.php';
$query = 'SELECT a.id, a.sectionid, a.access,' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,' . ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug' . ' FROM #__content AS a' . ' LEFT JOIN #__categories AS cc ON cc.id = a.catid' . ' WHERE a.id = ' . $id;
$db = JCommentsFactory::getDBO();
$db->setQuery($query);
$row = $db->loadObject();
$user = JFactory::getUser();
if ($row->access <= $user->get('aid', 0)) {
$link = JRoute::_(MoofaqHelperRoute::getArticleRoute($row->slug, $row->catslug, $row->sectionid));
} else {
$link = JRoute::_("index.php?option=com_user&task=register");
}
}
if (JCOMMENTS_JVERSION == '1.0') {
global $mainframe, $Itemid;
$compat = $mainframe->getCfg('itemid_compat');
if ($compat == null) {
// Joomla 1.0.12 or below
if ($Itemid && $Itemid != 99999999) {
$_Itemid = $Itemid;
} else {
$_Itemid = $mainframe->getItemid($id);
}
} else {
if ((int) $compat > 0 && (int) $compat <= 11) {
// Joomla 1.0.13 or higher and Joomla 1.0.11 compability
$_Itemid = $mainframe->getItemid($id, 0, 0);
} else {
// Joomla 1.0.13 or higher and new Itemid algoritm
$_Itemid = $Itemid;
}
}
$link = JoomlaTuneRoute::_('index.php?option=com_content&task=view&id=' . $id . '&Itemid=' . $_Itemid);
}
return $link;
}
