Outgoing RSS not working NEED HELP!

gilahacker · 10.11.2004, 21:43

(This is a repost as I didn't get an answer before)

ok, so me and Nascent hacked up my site real good to get that custom look I needed, (actually... Nascent did all the work... I just asked her a lot of questions) and I'm not using the "frontpage" thing for any of my articles anymore.

PROBLEM IS:

The RSS feed thingy (FeedCreator 1.7.1) only seems to grab articles marked as "frontpage"... I need to change that so it grabs the latest (say 10 or 15) articles whether they're marked "frontpage" or not.

I'd also like to be able to have seperate RSS feeds for my different categories if possible I.E. A "News" feed, and a "Press Release Feed", or even just the ability to pass a variable in the url to the php script that tells it which ones to grab instead of having 2 seperate scripts

i.e.
news: http://www.mysite.com/index2.php?op...ml=1&which=news
press releases: http://www.mysite.com/index2.php?op...l=1&which=press

or something to that effect.

I know that fixing the feed is just a matter of changing a line or two in the rss.php file but I can't quite figure it out. The 2 seperate feeds thing is probably more work...

any ideas?

conum pointed me to this: RSS-Feed not showing

but that's not really relevant to my problem. My RSS works per se, but it only wants to grab articles marked as "Front Page" and I'm not using "Front Page" for any of my articles as it causes issues with my site layout. I just need the RSS feed thingy to grab the latest articles by date and have it not care whether they're marked front page or not.

gilahacker · 10.11.2004, 21:46

I think this bit of code is where the problem lies:

Quote:

$query = "SELECT a.*, u.name AS author, u.usertype"
. "\n FROM #__content AS a"
. "\n INNER JOIN #__content_frontpage AS f ON f.content_id = a.id"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n WHERE a.state = '1'"
. "\n AND a.access = 0"
. "\n AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '". $now ."' )"
. "\n AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '". $now ."' )"
. "\n ORDER BY ". $orderby
. ( $info[ 'count' ] ? "\n LIMIT ". $info[ 'count' ] : '' )
;

I've tried eliminating this line: . "\n INNER JOIN #__content_frontpage AS f ON f.content_id = a.id" and I've tried just deleting the _frontpage and all that does is give me errors on the rss feed (won't generate it).

Somebody, Anybody HELP!

thanks,
-JL