[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

[garrynewman]

OK, it seems to be working just fine. This fix will only work on new posts that are added to the forum. So if you get repeats just delete the OLD threads and you won't get any more (Or start from new).

in includes/class_ffrss.php
find the function "function post_thread($title, $message, $feed)"
and after global $vbulletin;

add:

		$dupehash = md5($feed['feed_forum'] . $title . $message . $feed['feed_user'] . 'thread');

		if ($prevpost = $vbulletin->db->query_first("
			SELECT posthash.threadid
			FROM " . TABLE_PREFIX . "posthash AS posthash
			WHERE posthash.userid = " . $feed['feed_user'] . " AND
				posthash.dupehash = '" . $vbulletin->db->escape_string($dupehash) . "'"))
		{
			return;
		}

then at the bottom of the function after $ThreadDM->save();

add:

		$vbulletin->db->query_write("
			INSERT INTO " . TABLE_PREFIX . "posthash
			(userid, threadid, dupehash, dateline)
			VALUES
			(" . intval($feed['feed_user']) . ", " . intval($ThreadDM->fetch_field('threadid')) . ", '" . $dupehash . "', " . TIMENOW . ")
		");

then, and I don't know whether this is 100% needed but..

replace the whole function get_dateline()

with

	function get_dateline()
	{
		$this->dateline = TIMENOW + 1;
		return $this->dateline;
	}

(in my test this prevented it from adding another invalid posthash)

[Vierie]

Originally Posted by DjTaz

Zero , Thanks a million for this great hack

... i have a feed on my boards 3.0.7 and it works great , but this hack on my test boards doesnt seem to want to let the same feed work ... any chance you can let me know what the problem is ?

http://www.ireland.com/feeds/rss/breaking/irish.rss

Thanks

That's an rdf-feed. You'll need that workaround: https://vborg.vbsupport.ru/showpost....&postcount=306

[skizzy203]

Originally Posted by TyleR

didnt work for the first few days, but has been working lately..only "bug" per-say is that characters are being displayed awkward..such as: WP: Lawmaker’s Abramoff ties under scrutiny

it sometimes does it in the description aswell.

I need a fix for this too, I read as far back as I could and didn't see anything that targeteted this problem. Is there anyone that knows what the deal is on the quotation (") and apostrophe (') charecters being replaced with garbage?

A fix for that would soothe my headache.

[b6gm6n]

Originally Posted by garrynewman

OK, it seems to be working just fine. This fix will only work on new posts that are added to the forum. So if you get repeats just delete the OLD threads and you won't get any more (Or start from new).

No errors, seems to work ok, im actually pulling an RSS feed of my photopost gallery installation, the feed gives various information about new uploads, uploader, thumbnail, comments etc... and is generated on the fly when a new upload is in, pulls them ok and works a treat, but although my cron log says it's run the 'cron_ffrss.php' i have rarely had an update, i hope this may fix that

-b6

[slamdog]

after trying all the fixes i'm still getting dupes from avn but not the bbc or sky news.

thanks to all who have helped/tried to fix so far.

the actual setup was a breeze, worked first time on gold.

[nailerpa]

I can't seem to get this to work. Can someone please post a screen shot of what the Navbar edit looks like exactly? Much appreciated!

Originally Posted by Carl Anderson

@Dream


One other thing someone was asking how not to exclude these posts in new posts or todays posts - do this.. if you have rss feeds in 16 15 and 23

just add &exclude=6,15,23 to the end of the do=getnew url and it'll exlude the forums with the forumids 6, 15 and 23.

Thanks Zero another great hack...

[chairman miaow]

Originally Posted by slamdog

after trying all the fixes i'm still getting dupes from avn but not the bbc or sky news.

thanks to all who have helped/tried to fix so far.

the actual setup was a breeze, worked first time on gold.

Same here - got Sky and BBC feeds working fine now without duplicates....but the cron job doesn't appear to be updating the feeds still...

[Vierie]

Originally Posted by nailerpa

I can't seem to get this to work. Can someone please post a screen shot of what the Navbar edit looks like exactly? Much appreciated!

The code for "New Posts" is

PHP Code:

search.php?do=getnew 


. If you want to exclude certain forums, you have to change that to

PHP Code:

search.php?do=getnew&exclude=x,y 


x and y being the numbers of the forums you want to exclude.
With "Today's Posts" it's normally

PHP Code:

search.php?do=getdaily 


. You have to change that to

PHP Code:

search.php?do=getdaily&exclude=x,y 


.

Just look for these words in your navbar template and change them.

[b6gm6n]

Well, i'm not sure if it's this mod or the rss feed from my photopost gallery but the feed does not update via cron, it is being run according to my logs, if i manually click 'update feed' i get nothing also... BUT if i alter the 'Feed Read Direction' from newest first to newest last it'll update the feed...weird huh? either way it's a bug which stops this great hack from being totally automatic!

One which although good, is the crippled leg of my forum!
( i may have to amputate the duff leg )

Are there any other hacks along these lines?

-b6

[nailerpa]

Ugh...I'm just not getting it...still not working. Does this look right?

<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getdaily&exclude=97,98" accesskey="2">$vbphrase[todays_posts]</a></td>

Originally Posted by Vierie

The code for "New Posts" is

PHP Code:

search.php?do=getnew 


. If you want to exclude certain forums, you have to change that to

PHP Code:

search.php?do=getnew&exclude=x,y 


x and y being the numbers of the forums you want to exclude.
With "Today's Posts" it's normally

PHP Code:

search.php?do=getdaily 


. You have to change that to

PHP Code:

search.php?do=getdaily&exclude=x,y 


.

Just look for these words in your navbar template and change them.