Dear fastsoftcompany,
if it is the slideshow2 module and you want to add a option to enter article ids,you can try as follow
1) Open the file of modulesmod_jaslideshow2mod_jaslideshow2.xml look for this
<param name=”source-articles-max_items” type=”text” default=”5″ cols=”30″ rows=”2″ label=”MAX ARTICLES DISPLAY” description=”MAX ARTICLES DISPLAY DESC”/>
and adding above it this tag
<param name=”source-articles-articleids” type=”text” default=”5″ cols=”30″ rows=”2″ label=”Articles Ids” description=”Enter article- Ids saparate by comma “/>
2) open the file of modules/mod_jaslideshow2/helper.php look for this block of code
[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’
. “n FROM #__content AS a”.
‘ INNER JOIN #__categories AS cc ON cc.id = a.catid’ .
‘ INNER JOIN #__sections AS s ON s.id = a.sectionid’
. “n WHERE a.state = 1”
. “n AND ( a.publish_up = ” . $db->Quote( $db->getNullDate() ) . ” OR a.publish_up <= ” . $db->Quote( $now ) . ” )”
. “n AND ( a.publish_down = ” . $db->Quote( $db->getNullDate() ) . ” OR a.publish_down >= ” . $db->Quote( $now ) . ” )”
. ( ( !$mainframe->getCfg( ‘shownoauth’ ) ) ? “n AND a.access <= ” . (int) $aid : ” )
;
[/PHP]
And change it to
[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’
. “n FROM #__content AS a”.
‘ INNER JOIN #__categories AS cc ON cc.id = a.catid’ .
‘ INNER JOIN #__sections AS s ON s.id = a.sectionid’
. “n WHERE a.state = 1”
. “n AND ( a.publish_up = ” . $db->Quote( $db->getNullDate() ) . ” OR a.publish_up <= ” . $db->Quote( $now ) . ” )”
. “n AND ( a.publish_down = ” . $db->Quote( $db->getNullDate() ) . ” OR a.publish_down >= ” . $db->Quote( $now ) . ” )”
. ( ( !$mainframe->getCfg( ‘shownoauth’ ) ) ? “n AND a.access <= ” . (int) $aid : ” )
;
if( $params->get(“source-articles-articleids”) && $params->get(“source-articles-articleids”) != null){
$query .= ” AND a.id in(“.$params->get(“source-articles-articleids”).”)”;
}
[/PHP]
I hope these change make sense !
