reders
Friend
Please can you tell me how I can link the Category Spotlight module to categories in VM.
Please goto:
http://www.webdesignerblackburn.com/WebProofs/Maison-Red/
What I mean is, we currently have 3 articles Furniture, Fabrics and Wine in a category.
The Spotlight module will only link to these articles, how do we change this so they link to the relevant VM Categories??
Kindest Regards,
Reders
Anonymous
Moderator
Hi reders,
Current this template does not support your idea.
But it is possible.
Please try with my guide:
+ Open modulesmod_jacatslwihelper.php file, at about line 143, find following code to change to your idea:
[PHP]$query = ‘SELECT a.*,cc.description as catdesc, cc.title as cattitle,s.description as secdesc, s.title as sectitle,’ .
‘ 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,’.
‘ CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(“:”, s.id, s.alias) ELSE s.id END as secslug’.
‘ FROM #__content AS a’ .
‘ INNER JOIN #__categories AS cc ON cc.id = a.catid’ .
‘ INNER JOIN #__sections AS s ON s.id = a.sectionid’ .
‘ WHERE a.state = 1 ‘ .
($noauth ? ‘ AND a.access <= ‘ .(int) $aid. ‘ AND cc.access <= ‘ .(int) $aid. ‘ AND s.access <= ‘ .(int) $aid : ”).
‘ AND (a.publish_up = ‘.$db->Quote($nullDate).’ OR a.publish_up <= ‘.$db->Quote($now).’ ) ‘ .
‘ AND (a.publish_down = ‘.$db->Quote($nullDate).’ OR a.publish_down >= ‘.$db->Quote($now).’ )’ .
(($catid) ? ‘ AND cc.id IN (‘ . $catid . ‘) ‘ : ”).
‘ AND cc.section = s.id’ .
‘ AND cc.published = 1’ .
‘ AND s.published = 1’ .
‘ ORDER BY a.ordering’ .
‘ LIMIT ‘.$numelem;[/PHP]
+ Open mod_jacatslwi.php file in that folder too, at about line 52, find following code to change to your link:
[PHP] $link = JRoute::_(ContentHelperRoute::getArticleRoute($l->slug, $l->catslug, $l->sectionid));
[/PHP]
I am sorry for not being of much help in this case.
This topic contains 3 replies, has 2 voices, and was last updated by 
We moved to new unified forum. Please post all new support queries in our New Forum
