CMS Tactics, Inc.

RSS Feed Creator

Tuesday, 18 August 2009 17:52

RSS Feed Creator is a wonderful tool that allows the user to specify SQL queries that will be used to create RSS feeds.

rssfeed_large_new

Instructions:

Create a Feed entry for each RSS feed you want created:

The name will be used to select the feed when creating a menu item.
The title, description, and language will be used as properties of the feed itself.
The host, user, password, and database will be used to connect to the database (leaving any of these blank will connect to the Joomla database using the credentials from the configuration file).
The sql field specifies the SQL to run on the specified database. Each row returned will be used as an item in the RSS feed.

Examples:

PHPBB Posts:

SELECT
phpbb_posts.post_subject title,
FROM_UNIXTIME(phpbb_posts.post_time) date,
CONCAT('/forum/index.php?f=', phpbb_posts.forum_id, '&t=', phpbb_posts.topic_id, '&rb_v=viewtopic#p', phpbb_posts.post_id) link,
phpbb_posts.post_text description,
phpbb_users.username_clean author,
phpbb_forums.forum_name category,
'' comments,
phpbb_posts.bbcode_bitfield,
phpbb_posts.bbcode_uid
FROM phpbb_posts
INNER JOIN phpbb_forums
ON phpbb_forums.forum_id = phpbb_posts.forum_id
INNER JOIN phpbb_users
ON phpbb_users.user_id = phpbb_posts.poster_id
WHERE phpbb_posts.post_approved = 1
ORDER BY phpbb_posts.post_time DESC

Joomla Content:

SELECT
jos_content.title title,
jos_content.publish_up date,
CONCAT('/index.php?option=com_content&catid=', jos_content.catid, '&id=', jos_content.id, '&view=article') link,
jos_content.fulltext description,
jos_users.name author,
jos_categories.title category,
CONCAT(jos_content.hits, ' hits') comments
FROM jos_content
INNER JOIN jos_categories
ON jos_categories.id = jos_content.catid
INNER JOIN jos_users
ON jos_users.id = jos_content.created_by
ORDER BY jos_content.ordering DESC

Purchase

Last Updated on Wednesday, 21 July 2010 04:12

Username	Password

Forgot Username?	Forgot Password?	Register