[v1.6] Inferno RSS Forum Feeds Technology

This hack was made purely by request, and the fact IPB will have a similar system as default functionality, i wouldn't like them to have a upper hand to vbulletin

v1.5 Updates:
- Auto detect RSS settings system
- Forum stats rebuilt correctly (last post info)

v1.6 Updates:
- Various bug fixes

Description:
This once added to your forum allows you to connect to any RSS feed you desire, once set up the system will automatically post data from the RSS feed into threads within a specified forum.

Previews are available at the bottom, and an FAQ is built into the admin controls since I know not everyone will understand how to set up the options. Also an example to use a BBC UK News rss feed is below

Example BBC UK News Feed:
Feed Name: BBC UK News
Feed Location: http://newsrss.bbc.co.uk/rss/newsonl...t_page/rss.xml
Feed Prefix: [BBC UK News]
Feed From User: Assign users username of your own choice
Feed Forum: Choose a forum you want threads to be posted into
Feed Read Direction: Newest First
Parent RSS Tag Name: channel
Items RSS Tag Name: item
Thread Title RSS Tag Name: title
Thread Post RSS Construct:

[b]Published:[/b] {XML[pubDate]}

{XML[description]}
[url={XML[link]}]Read More...[/url]

Note: After adding a new feed i suggest clicking update for that feed, this will manually update that singular feed specified, the cron job included will automatically update all feeds, best not to have it update them all from the start otherwise it could execute a lot of queries. Further more I highly recommend you do not have lots of feeds unless your server can with-stand it.

Enjoy

- Zero Tolerance

[XtremeOffroad]

Originally Posted by Zero Tolerance

People getting errors with bbc rss feeds? Seems to work fine on mine with no problems, i'll do a little more research into it - Zero Tolerance

Thanks much Zero Tolerance, Your work here is very Impressive for such a Young Man and Greatly Appreciated.

[Zero Tolerance]

People love it when technology can save us the hard manual work...

- Zero Tolerance

[john1744]

^ When will that be available Zero? (Thats awesome! BTW)

[Zero Tolerance]

That would be now, i thought i'd release it with that addition and a minor problem fix to help users who arn't sure what to do with the rss settings

- Zero Tolerance

[XtremeOffroad]

I take it the zip file today has been updated?
Got the email, Sorry.

Updating now. Thanks

[Zero Tolerance]

Yep, re-download and read the upgrade instructions

- Zero Tolerance

[XtremeOffroad]

Upgrade went smooth as allways.
Other then help with filling in the fields were there any other changes?

[Gryphon]

Edit: Hmm, Worked the second time I ran it for some reason. All good now.

Upgrade Error:

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
CREATE TABLE `vb3_rssfeed` (
  `feed_id` int(15) NOT NULL auto_increment,
  `feed_name` varchar(255) NOT NULL default '',
  `feed_prefix` varchar(255) NOT NULL default '',
  `feed_location` varchar(255) NOT NULL default '',
  `feed_user` int(15) NOT NULL default '0',
  `feed_forum` int(15) NOT NULL default '0',
  `feed_parser` mediumtext NOT NULL,
  `feed_lastadded` text NOT NULL,
  `feed_direction` varchar(255) NOT NULL default 'newestfirst',
  PRIMARY KEY  (`feed_id`)
) TYPE=MyISAM;;

MySQL Error  : Table 'vb3_rssfeed' already exists
Error Number : 1050
Date         : Thursday, August 18th 2005 @ 03:23:23 PM

[Zero Tolerance]

Yeah the posting of threads had a slight change, the last post info for the forum was corrected, and an error message was fixed

@ The guy with a mySQL error - Strange, in the xml file for the products, change <code version="1.5"> to <code version="1.0">, should work then.

- Zero Tolerance

[XtremeOffroad]

Originally Posted by Blackjack

Edit: Hmm, Worked the second time for some reason.

Upgrade Error:

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
CREATE TABLE `vb3_rssfeed` (
  `feed_id` int(15) NOT NULL auto_increment,
  `feed_name` varchar(255) NOT NULL default '',
  `feed_prefix` varchar(255) NOT NULL default '',
  `feed_location` varchar(255) NOT NULL default '',
  `feed_user` int(15) NOT NULL default '0',
  `feed_forum` int(15) NOT NULL default '0',
  `feed_parser` mediumtext NOT NULL,
  `feed_lastadded` text NOT NULL,
  `feed_direction` varchar(255) NOT NULL default 'newestfirst',
  PRIMARY KEY  (`feed_id`)
) TYPE=MyISAM;;

MySQL Error  : Table 'vb3_rssfeed' already exists
Error Number : 1050
Date         : Thursday, August 18th 2005 @ 03:23:23 PM

I received the same error but on the second attempt on the xml upload it worked fine from what I see.