I just fixed this issue but it is not released yet, i will contact to QA for verification and release this soon. This is my solution
<blockquote>Open modules/mod_jasidenews/helper.php </blockquote>
Find function getListArticles($params) and replace with this function below
function getListArticles($params)
{
$db = JFactory::getDbo();
$db->getQuery(true);
// Access filter
$access = !JComponentHelper::getParams('com_content')->get('show_noauth');
$authorised = JAccess::getAuthorisedViewLevels(JFactory::getUser()->get('id'));
// Filter by start and end dates.
$nullDate = $db->Quote($db->getNullDate());
$date = JFactory::getDate();
$nowDate = $db->Quote($date->toSql());
$query = "SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.images, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, c.alias AS category_alias, a.hits, a.featured, a.ordering, LENGTH(a.fulltext) AS readmore";
$query .= " FROM #__content AS a LEFT JOIN #__languages AS l ON l.lang_code = a.language";
$query .= " LEFT JOIN #__users AS uc ON uc.id = a.checked_out";
$query .= " LEFT JOIN #__viewlevels AS ag ON ag.id = a.access";
$query .= " LEFT JOIN #__categories AS c ON c.id = a.catid";
$query .= " LEFT JOIN #__users AS ua ON ua.id = a.created_by";
$query .= " WHERE a.state = 1";
// Filter by start and end dates.
$query .= " AND (a.publish_up = " .$nullDate. " OR a.publish_up <= " . $nowDate.")";
$query .= " AND (a.publish_down = " .$nullDate. " OR a.publish_down >= " . $nowDate.")";
//Language filter
$query .= " AND a.language in (".$db->quote(JFactory::getLanguage()->getTag()).",".$db->quote('*').")";
if($access){
$query .= " AND a.access = ".$access;
}
//get featured setting
$featured = $params->get('show_featured', 1);
if ($featured ==0) {
$query .= " AND a.featured = 0";
} elseif ($featured == 2) {
$query .= " AND a.featured = 1";
}
$categories = $params->get('display_model-modcats-category', '');
if ($categories && $categories[0] > 0) {
$catids_new = $categories;
foreach ($categories as $k => $catid) {
$subcatids = $this->getCategoryChildren($catid, true);
if ($subcatids) {
$catids_new = array_merge($catids_new, array_diff($subcatids, $catids_new));
}
}
$categories = implode(',', $catids_new);
$query .= " AND c.id IN ($categories)";
}
// Category filter
if ($params->get("display_model", "modcats") == 'modarts') {
$query .= " AND a.metakey LIKE '%Featured%'";
}
if ($params->get('sort_order_field', 'created') == "random") {
$query .= " ORDER BY RAND() ".$params->get('sort_order', 'ASC');
} elseif ($params->get('sort_order_field', 'created') == "ordering") {
$query .= " ORDER BY a.ordering ".$params->get('sort_order', 'ASC');
} elseif ($params->get('sort_order_field', 'created') == "hits") {
$query .= " ORDER BY a.hits ".$params->get('sort_order', 'ASC');
}else {
$query .= " ORDER BY a.created ".$params->get('sort_order', 'ASC');
}
$query .= " LIMIT 0 ,".$params->get('max_items', 5);
$db->setQuery($query);
$items = $db->loadObjectList();
foreach ($items as &$item) {
$item->slug = $item->id . ':' . $item->alias;
$item->catslug = $item->catid . ':' . $item->category_alias;
if ($access || in_array($item->access, $authorised)) {
// We know that user has the privilege to view the article
$item->link = JRoute::_(ContentHelperRoute::getArticleRoute($item->slug, $item->catslug));
} else {
$item->link = JRoute::_('index.php?option=com_user&view=login');
}
$item->modified =($item->modified != '' && $item->modified != '0000-00-00 00:00:00') ? $item->created : $item->created;
$item->introtext = JHtml::_('content.prepare', $item->introtext);
}
return $items;
}
Ninja Lead 11 years, 4 months ago.
