Project Detail

Description

I need a Joomla component modified (php code). The code is RD RSS feed (look it up in Joomla extensions). It publishes content by category to an RSS feed. It is a small component (only 2 php files).

I need the default content ordering (back end) modified to include 2 additional orderings (basically a SQL select mod within the order by case statement). The two new orderings are: Random, and Day of the Year.

"Random", will select all of the content from the category(ies) slected, then return one at random.

"Day of the Year" selects the content item where today's day of the year equals the content's day of the year from the created date.

in essence where day_of_year(jos_content.created) = day_of_year(today)

Attached is the installable component. I'll release this back to the GPL community.

You need to be familiar with Joomla, php, and preference will be given to someone that has already created installable components/modules. Show me your work - give me an example to install...


From the little research I did...

For the RANDOM option, I looked at the code in .../components/com_rd_rss/rd_rss.php


I believe on or about Line 93


*** my pseudo code ***

case 'random':
$orderby = 'a.created';
break;


Then on or about Line 158

*** more of my pseudo code ***

if (strtolower( &params->orderby ) = 'random' {

if (count($rows) > 0) {

$singlerow = $rows[rand(1,count($rows))];

$rows = $singlerow;

}
else {

error
}
}

For the "Day of the year" option, if there is a SQL function "dayofyear()" then this project will be cake. If I knew php, my guess would be 3 hours start to finish.

...more projects from this one's success ;)




Additional files submitted:
rd_rss_v1_1.zip