$query .= "\n LEFT JOIN #__users u ON u.id = a.created_by" ."\n WHERE a.state = '1' AND a.access = '29'" ."\n AND a.catid = '1'" ."\n AND ( a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '". $now ."' )" ."\n AND ( a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '". $now ."' )";
From a specific category you can't without hacking Elxis. Elxis will export the latest items from all categories. But you can do this with a small and easy hack. Do exactly what I will write to you bellow if you wish to export content items only from a specific category (or from more than one).1. Set in Syndication component in Elxis administration to export content items from all categories.2. Open components/com_rss/rss.php with a text editor such as pspad (pspad.com)Go to line 161 and add bellow:If you wish to display content items from just one category:."\n AND a.catid = 'XXX'"If you wish to display content items from just more than one category separate multiple category IDs with comma: ."\n AND a.catid IN (XXX,YYY,ZZZ)"Where XXX, YYY, ZZZ the category ID(s).In the end rss.php will look like this (in this example the category id is 5): $query .= "\n LEFT JOIN #__users u ON u.id = a.created_by" ."\n WHERE a.state = '1' AND a.access = '29'" ."\n AND a.catid = '5'" ."\n AND ( a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '". $now ."' )"or like this (in this example the category IDs are 5, 8 and 27): $query .= "\n LEFT JOIN #__users u ON u.id = a.created_by" ."\n WHERE a.state = '1' AND a.access = '29'" ."\n AND a.catid IN (5,8,27)" ."\n AND ( a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '". $now ."' )"3. Save the file and upload it in your server replacing existing one.You can get the category IDs from Elxis administration (categories manager).