$module_to_return = XXX; /* replace XXX with the module id of that module */

$limit = 5; /* alter this to change number of articles */

$nullDate = $db->Quote( $db->getNullDate() );

$jnow  =& JFactory::getDate();

$now    = $db->Quote( $db->getEscaped( $jnow->toMySQL() ) );

$query = "SELECT id "

       . " FROM #__content c, #__content_frontpage fp "

       . " WHERE c.state = 1 "

       . " AND c.id = fp.content_id "

       . " AND ( c.publish_up = $nullDate "

       . " OR c.publish_up <= $now )"

       . " AND ( c.publish_down = $nullDate "

       . " OR c.publish_down >= $now  )"

       . " ORDER BY c.created desc "

       . " LIMIT $limit ";

$db->setQuery( $query );

$ids = $db->loadResultArray();

$ids = array_reverse($ids);

$list = implode(", ", $ids);

$changes->mod( $module_to_return )->setParam( "article_ids", $list );

return $module_to_return;

$module_to_return = XXX; /* replace XXX with the module id of that module */

$limit = 5; /* alter this to change number of articles */

$nullDate = $db->Quote( $db->getNullDate() );

$jnow  =& JFactory::getDate();

$now    = $db->Quote( $db->getEscaped( $jnow->toMySQL() ) );

$query = "SELECT id "

       . " FROM #__content c LEFT JOIN #__content_frontpage fp on c.id = fp.content_id "

       . " WHERE c.state = 1 "

       . " AND fp.content_id is null "

       . " AND ( c.publish_up = $nullDate "

       . " OR c.publish_up <= $now )"

       . " AND ( c.publish_down = $nullDate "

       . " OR c.publish_down >= $now  )"

       . " ORDER BY c.created desc "

       . " LIMIT $limit ";

$db->setQuery( $query );

$ids = $db->loadResultArray();

$ids = array_reverse($ids);

$list = implode(", ", $ids);

$changes->mod( $module_to_return )->setParam( "specifics", $list );

return $module_to_return;