[v1.6] Inferno RSS Forum Feeds Technology

[Tralala]

I get this error also on 3.5.2, even with cURL enabled. My host directed me to this page (http://wiki.dreamhost.com/index.php/CURL) to see "how they handle it".

Is there anything further I need to do to this hack to take advantage of cURL?

Same error as silurius (same host, too.)

cURL is enabled. In fact, it works fine with ArticleBot.

<sigh>

[dirtycrow]

is there any way to make this not create new threads? my "New Posts" page is getting hammered.

[G_Man]

is there any way to make this not create new threads? my "New Posts" page is getting hammered.

Until you (or WE) get an answer to this I found a solution: I made a new child forum in the MOD Area where only I have permissions. I get hit with the New Posts, but it doesn't show up in anyone else's listing.

Hope that at least helps a little. :)

[Tralala]

Until you (or WE) get an answer to this I found a solution: I made a new child forum in the MOD Area where only I have permissions. I get hit with the New Posts, but it doesn't show up in anyone else's listing.

Hope that at least helps a little. :)


This mod will help you filter which forums get searched for new posts:
https://vborg.vbsupport.ru/showthread.php?t=91025

[G_Man]

What would work wonders for me is if this Hack could post all of the updates in One Post for each Feed. Or even in just one thread would be much better. ;)

Thanks Again for all your hard work ZT.

:D

[James Goddard]

I'd like to suggest adding event feeds to this.

For example, I have a feed that is "Upcoming Events" for a training agency. What I'd like to do is rather than create a post on this is to create a calendar event.

The feed has an entry:

<description>
3/4/06
</description>


for single day events and an entry:

<description>
9/10/06-9/15/06
</description>


for multiday events.

[NineToez]

I upgraded to 3.5.4 from 3.5.3 and neither version has worked with this extension, but did when I was running 3.5.2 and below just fine. I keep getting an "Invalid URL to RSS feed given" error.

[mvolking]

So there is no answer to making URL's in the RSS posts actual links??

Also, is there any way to put in line breaks in after the title/URL/description?

[G_Man]

Just put spaces in the "Thread Post RSS Construct" box between elements:

Mine looks like this:

{XML[title]}

}]Read More... ({XML[link)

{XML[description]}

[Langly]

Mine just makes a thread with the link to the source forum thread. If the source forum thread has additional posts after boing posted on my forum, the updated posts are not put on my forum. How can I make it do update the original threads? I have nearly 12000 threads and like 12200 posts.

[stamos2003]

hmm, seems like it's not supporting greek letters? no iso-coding possibility?

[Sir_Yaro]

seems to hava problem with non-latin letters:
try to use this feed:
http://linux.pl/rss.php

error is in this line:
<title>Dlaczego Linux?<br>Wyniki bada�upowszechnienia oprogramowania Open Source wr� polskich przedsi�iorstw</title>

[cashpath]

How would this be edited so that it only posts A SINGLE latest news item in a RSS?

That would fix duplicates.... the way it works now it checks to see if the title= the last posted stored title. If it only checked the latest posted new and only posted 1 of them you would not got dups..

So.. anyone know how to only have it post 1??

[Zinc]

'installed' Got it working perfectly on 3.5.4, nice job.
Got the occasional ? in place of the ' char, but I guess that's down
to the feed set as ISO and my vB is UTF-8. Otherwise, v nice.

[Al-Fateh]

need help installing this one

can anyone help please

[coffee]

Thank you Zero Tolerance.

[CarpHunter]

In some wierd way it wont work properly.

I installed it and all seems ok. Got the new menu in Admincp and all.

Things get strange when I try to detect the feeds settings. I insert a link and my forum starts loading and loading and loading. After a couple of minutes my server times-out.

I tested this with the example BBC feed and some others but none seem to work.

Anyone have an explanation for this???

Board: vb 3.5.4
RSS hack: Inferno 1.6
All fresh installed and no other mods on it.

[edit]
Just tested some more and found something interesting.
My server is running WinXP Pro, PHP 4.4.2, MySQL 4.0.26 and Apache 1.3.35.
When I click the dtect button I get a PHP error on my servers monitor.
Hope someone can help me with this.

[popowich]

Hello,

I noticed there is a 1.6 with bug fixes so I downloaded and installed, but I'm still at 1.5. Looking at the product xml file it says 1.5 at the top. Is it possible 1.6 was released but the version not updated in the XML file? If there is a specific download I should be looking for attached to a post in one of the 35 pages please point out the page number. Thank you.

-Raymond

[libertate]

An excellent edition to my tools! //clicks Install//

A minor notes -

* In field feed_parser you are not escaping double quotes. Whenever someone puts a double quote in any of the RSS Setting, it gets blown away.
Wouldn't it be easier to break those fields out instead of using parsing?

* As earler mentioned a toggle to allow a specific feed to create a thread, or continue existing thread would be excellent.

[Neal-UK]

I'm getting this on one site running a cron job:

Fatal error: Call to undefined function: sb_test() in /****/***/****/********/******/**/forum/includes/class_dm_threadpost.php(1466) : eval()'d code on line 2

[libertate]

For two days the system worked fine.

Today it downloaded 3,000+ articles from one of the RSS feeds. OUCH! Talk about serious bandwidth sucking!

Can we limit the quantities as to how many to post?

[Cebby]

No problems with install. Great Hack!

*clicks install*

EDIT: OK, one problem - the ["] quote and ['] apostrophe garbage generated is a PITA, but other than that, great for my use. Any fixes for this yet?

[MrDiaz]

hi, the hack is amazing but I have a question.

When the bot post an article and I reply to it, my post appears first. Why so?

:(

[Scrolls]

i am having trouble getting the RSS feeds to update...and how do i set a bot to post threads in the forum of my choice? can someone please help with this, i will gladly give someone all the passwords to the proper areas of my admincp and server info so they could do this right quick (i have the news feed sources, i will provide the link and everything needed!)

[webgroup]

I'm only getting this in my rss posts:

Thread Title: MSN News h

News: h

h
Date: h

also the thread title has at the end the "h"

Any help?

Thanks!!!

[michaelsilvia]

You are the man Zero! Is there anything you can't do?

Mike

[Kwak]

Is this the only RSS Feed hack available for v3.5.4?

I happened to have the Articlebot installed but it never worked ever since I've installed it, but might be because it is compatible with only v.3.0.

[kall]

Is this the only RSS Feed hack available for v3.5.4?


I happened to have the Articlebot installed but it never worked ever since I've installed it, but might be because it is compatible with only v.3.0.
What does it really matter, if you haven't tried it, why search for alternatives? :)

I use this Mod, and when you add in my Users can Post HTML Mod, it's perfect.

[Kwak]

The coder for this hack is away from vBulletin.org for awhile, leaving users hanging with questions and/or problems so I'm a little hesitant to install it.
But if all users had success installing and working with this hack, it would be okay then.

But if there are no alternative and not will be one for a long time, I might as well uninstall the old Articlebot hack and try this one out.

[michaelsilvia]

I use this Mod, and when you add in my Users can Post HTML Mod, it's perfect.

What are some RSS feeds you are using that us HTML? I'd be curious to see.

Mike

[kall]

Yahoo and Goole News: http://www.nzboards.com/forums/new-zealand-news-feeds/

[michaelsilvia]

A few questions. I added the add on to this:
https://vborg.vbsupport.ru/showthread.php?t=108377

Is there a way to either:

1. Turn off the auto posting or;
2. Have the post show up better?

In the Thread Post RSS Construct I am using XLM, but that doesn't show up well on my forum. The links are broken. What is the best way to use the mod and have the RSS feeds post well.

[subnet_rx]

Anyone know what keeps a feed item from appearing twice?

[webgroup]

I'm only getting this in my rss posts:

Thread Title: MSN News h

News: h

h
Date: h

also the thread title has at the end the "h"

Any help?

Thanks!!!

any help?

[TheOutdoors]

I'm also getting the "Invalid URL To RSS Feed Given" error when adding any feed, regardless of where it originates from.

Since I can't get this to work, is there another mod that will do the same thin, or, if there a workaround or fix that some of you are using?

Thanks,

Jeremy Henricks
Discuss The Outdoors
http://www.discusstheoutdoors.com/

[Tralala]

I happened to have the Articlebot installed but it never worked ever since I've installed it, but might be because it is compatible with only v.3.0.

ArticleBot for 3.0 is here (https://vborg.vbsupport.ru/showthread.php?t=67078)

ArticleBot for 3.5.x has been moved to http://www.vbmodder.com.

[AyeCapn]

Installed and working great, with the exception of special characters showing up as garbage.

[kafi]

Installed and working great, with the exception of special characters showing up as garbage.

yeah would be nice to have some sort of translator functions, because some RSS are in different charset then forum charset...

[stevenb7]

I created a forum specifically for the feeds and set it to moderate new threads so i can review the news and only post news that is really interesting to my users. However the posts show up right away, what do i need to change so the post await moderation?

[ibeblunt]

I created a forum specifically for the feeds and set it to moderate new threads so i can review the news and only post news that is really interesting to my users. However the posts show up right away, what do i need to change so the post await moderation?

You need to change your cron job from checking the feed every minute, assuming that you are using the settings found in the setup instructions.

ACP > TASK MANAGER > Scheduled Task Manager

Edit RSS Feeds Update.

Change the minutes or hour. Depending on how you need it.

[SirTalksalot]

HI,

I love this already but I have a few formatting issues. First of all is there any way to ensure links are clickable and that they open in a seperate window, same as when a links is posted anywhere else?

EXAMPLE: http://www.productionforum.co.uk/showthread.php?t=260

Secondly, I've got some formatting problems with some of the feeds coming through.

EXAMPLE:http://www.productionforum.co.uk/showthread.php?t=182

Is there any way to tighten this up? Or will the feed providor have to sort it out?

Finally, I'm having to allow HTML in the forums I have the feeds in. Is there any way to limit it so only the account I'm using to post the feeds can use HTML?

Oh, another quick thing. Once I've clicked update feeds, it won't post the same messages again, even if I have deleted them. This makes it hard to test, is there a way round this?

Thank you in advance. :)

[Freak0204]

I get this error after trying to update the feed:

Fatal error: Only variables can be passed by reference in /home/post/public_html/forum/includes/class_ffrss.php on line 371

The line in question:

if (!empty($this->LastAdded))

Any suggestions?

[briansol]

anyone get this working with woot feeds?

it won't accept any parent config from
http://www.woot.com/salerss.aspx

[COBRAws]

Is there a way I can use a feed to grab data from and post it in the header?

I would like to set up a weather box in my header template. Does anybody know if this is possible?
Thank you.

[laskos]

Hi all

i have installed this and works a treat, one thing though can anyone tell me how i can make the latest nes posts scroll rather be static?

thanks in advance.

Paul

[Ranger187]

Seems to not work in 3.6 RC1. I get a db error.

[kall]

Seems to not work in 3.6 RC1. I get a db error.
Isn't RSS Functionality a stock feature of 3.6?

What does this Modification offer that the stock does not?

[froop]

Hi,

I have this problem:

I am wanting to create a feed for Google UK News with this:

feed://news.google.co.uk/?ned=uk&topic=n&output=rss

I have put this into the detect settings and also manually, both times I receive this message:

"While attempting to parse the document located at "feed://news.google.co.uk/?ned=uk&topic=n&output=rss" the system encountered the following error:
Invalid URL To RSS Feed Given

Please check settings related to this issue."

Could someone please either point out where I have gone wrong or suggest a valid URL?

Many Thanks.

[vBulletin THEN DAYLIGHT]

This is a really excellent hack. Saves me going to all the hassle of upgrading to 3.6! :D

I just have one question: Would the headlines still get posted in a read only forum?

[rollo tamasi]

does this work with 3.5.4 >?

[peterska2]

yes it does. I have it running on a 3.5.4 forum

[vBulletin THEN DAYLIGHT]

This is a really excellent hack. Saves me going to all the hassle of upgrading to 3.6! :D

I just have one question: Would the headlines still get posted in a read only forum?
Anyone?

[vBulletin THEN DAYLIGHT]

Anyone?????!??!??!? :(

[soletrader]

What does this mean?

Add the following scheduled task:
Title: RSS Feeds Update
Day of the Week: *
Day of the Month: *
Hour: *
Minute: 1 - - -
Log Entries: Up to you
Filename: ./includes/cron/cron_ffrss.php

Where do I go to fix this?

[bandoftheweek]

I have a question (I did skip thru the 37 pages so sorry if it was already answered). What if I have vbadvanced? How can I make the news be posted on the homepage?

[soletrader]

--------------------------------------------------------------------------------

I am trying to get a RSS news feed in my forum thread. This is the url:

http://articles.moneycentral.msn.com...S/cnbcrss.aspx


I have no clue how to fill the:

Parent RSS Tag Name
Items RSS Tag Name
Thread Title RSS Tag Name
Thread Post RSS Construct

Can anyone help? Thank you

[vBulletin THEN DAYLIGHT]

The correct link to the feed is: http://articles.moneycentral.msn.com/Feeds/RSS/cnbcrss.aspx

Click on that, and you will be displayed source code by your browser:

And from that, I can gather:

Parent RSS Tag Name: channel
Items RSS Tag Name: item
Thread Title RSS Tag Name: title
Thread Post RSS Construct:

Published: {XML[pubDate]}

{XML[description]} }]Read More... ({XML[guid)


That should work. If you look at how I have obtained that info from the source, you should get how to do it in future.

[vBulletin THEN DAYLIGHT]

What does this mean?


Add the following scheduled task:
Title: RSS Feeds Update
Day of the Week: *
Day of the Month: *
Hour: *
Minute: 1 - - -
Log Entries: Up to you
Filename: ./includes/cron/cron_ffrss.php


Where do I go to fix this?

Admin CP > Scheduled Tasks > Add New Scheduled Task

[soletrader]

How do you allows the RSS feed to post more than one line? As of now I did manage to get the feed but I am only receiving one line and then a "read more..." Also once I click on "read more" I get a http://array/ What did I do wrong?


Also is this legal?

[Cebby]

I have a question (I did skip thru the 37 pages so sorry if it was already answered). What if I have vbadvanced? How can I make the news be posted on the homepage?

Have the RSS Feed results targeted to one forum, then have your news or custom pages look to that forum for the information.

I'm doing that here:

www.furnitureresource.info

and

www.culinary-compliments.com

[Cebby]

How do you allows the RSS feed to post more than one line? As of now I did manage to get the feed but I am only receiving one line and then a "read more..." Also once I click on "read more" I get a http://array/ What did I do wrong?


Also is this legal?

Not sure of the legality of it, be sure you are giving credit where credit is due for the content.

Are you having this problem in CMPS or in a regular vB forum? Post up your RSS Feed post format.

[soletrader]

Not sure of the legality of it, be sure you are giving credit where credit is due for the content.

Are you having this problem in CMPS or in a regular vB forum? Post up your RSS Feed post format.


Feed Name : CNBC News

Feed Location/URL : http://articles.moneycentral.msn.com/Feeds/RSS/latestrss.aspx

Parent RSS Tag Name: channel

Items RSS Tag Name : item

Thread Title RSS Tag Name: title

Thread Post RSS Construct:


Published: {XML[pubDate]}

{XML[description]} }]Read More... ({XML[guid)

I am trying to post this in my vb forum. Thanks Cebby

[bandoftheweek]

I'm trying to get an rss feed from here http://www.absolutepunk.net/external.php?type=rss&forumids=165

It says Invalid URL To RSS Feed Given. Please help, thanks.

[Cebby]

Feed Name : CNBC News

Feed Location/URL : http://articles.moneycentral.msn.com/Feeds/RSS/latestrss.aspx

Parent RSS Tag Name: channel

Items RSS Tag Name : item

Thread Title RSS Tag Name: title

Thread Post RSS Construct:


Published: {XML[pubDate]}

{XML[description]} }]Read More... ({XML[guid)

I am trying to post this in my vb forum. Thanks Cebby

In looking at the actual feed, you can see that only one line is being "fed". As far as the Array problem, there's something wrong with the way the HTML is constructed (guessing)

Here's mine - and it works - maybe try this format?
{XML[description]}

}]Read more... ({XML[link)

The prob is the [guid] - I think.

[TundraSoul]

Hi,

Is there a vB 3.60 ready version of this product somewhere?

[basskiller]

Is there any way to keep the posts made by this out of the "new posts" request?

[fischermx]

I'm also want to use this with 3.6
Will it work ?

[peterska2]

3.6 has RSS feeds as a default feature. This modification uses the same tables as 3.6 and so will cause errors on upgrading to 3.6 unless you uninstall it first, and will not work due to the same tables being used.

[kr580]

My site, www.bleepingidiots.com, has CuteNews (news managment... RSS) on the front page. I also set it up so this vBulletin hack (https://vborg.vbsupport.ru/showthread.php?t=94510) automatically posts the news feeds in the appropiate forum sections. (http://www.bleepingidiots.com/forums/forumdisplay.php?f=129)

For some reason when I try to update the feed using this vB hack it gives me this message:
While attempting to parse the document located at "http://www.bleepingidiots.com/cutenews/rss.php?category=8&number=999" the system encountered the following error:
Invalid URL To RSS Feed Given

Please check settings related to this issue.It was working beautifully for a week or two and then one day it didn't feel like working. Nothing on either side (CuteNews or vB) has changed so I'm baffled as to what caused this. I'm not sure where the blame lies so I'm posting this here as well as the CuteNews forums.

Any ideas? Thanks - Kevin

[Terminatoronly]

hi,
thanks for this hack but when i try to update feed it display this error:
Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 758

Can u Please Fix this error for me.

Regards,
Terminatoronly

[Sascha Henken]

hi,
thanks for this hack but when i try to update feed it display this error:
Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_thread_firstpost in /includes/class_dm.php on line 758

Can u Please Fix this error for me.

Regards,
Terminatoronly

I agree. I get the same error. I`m running vB 3.5.5 at this moment. Would be cool to have this feature running with 3.5.5. Thank you :)

[ixian]

For some reason I still get random replies to this thread even though I unsubscribed from this hack years ago:)

It was a great hack but I really don't understand why you guys keep trying to get it to work, unsupported as it is and with VB 3.6 having a much better RSS feed system built right in to it. What's the point? Just make sure you uninstall this hack first before you upgrade to 3.6.

[Sascha Henken]

For some reason I still get random replies to this thread even though I unsubscribed from this hack years ago:)

It was a great hack but I really don't understand why you guys keep trying to get it to work, unsupported as it is and with VB 3.6 having a much better RSS feed system built right in to it. What's the point? Just make sure you uninstall this hack first before you upgrade to 3.6.

The point for me is, that my current ISP does not support MySQL 4.0 or greater, so I cannot run vB 3.6.x at all. And I still think that there are many people out there that don?t run or don?t have MySQL 4.0 and so the feature from 3.6.x cannot be used nor is an upgrade possible.

If this hack is unsupported, then I respect that and I don?t bother to post in here again. But if it is unsupported, then why not deleting this entire thread or just close it with remarks that this hack IS unsupport? It just confuses other people if it is still possible to post in here and to ask questions.

just my 2 cents for it.

Thanks anyway.

[Dannyboy1]

I am getting this error:

sb_test() in /****/***/****/********/******/**/forum/includes/class_dm_threadpost.php(1466) : eval()'d code on line 2

Does anyone have any idea how I can fix that? Thanks in advance.

[camdude]

I had this addon installed and then upgraded to 3.6.3
In version 3.6.3 there is also a database table called "rssfeed"

An upgrade to the new version the rssfeed table is overwritten, and you will get errors on the addon.

I rebuild the database table for this script and then did an uninstall of the product, then I rebuild the table that comes with VB 3.6.3

I think the uninstall of this addon was not successfull, the system is still sending me emails with database errors. And in the admin toolbar, this Inferno rss feed was not removed from the admin toolbar. The error :

Database error in vBulletin 3.6.3:

Invalid SQL:
select r.*, f.title from vb_rssfeed r left join vb_forum f on(f.forumid = r.feed_forum) order by r.feed_name;

MySQL Error : Table 'xxxxxxxx.vb_rssfeed' doesn't exist
Error Number : 1146
Date : Monday, November 20th 2006 @ 02:16:24 PM
Script : http://www.xxxxxx.com/forum/redbulljoey/ffrss.php?
Referrer : http://www.xxxxxx.com/forum/redbulljoey/index.php?do=nav
IP Address : 84.81.128.127
Username : xxxxxxxx
Classname : vb_database

What can I do ?

[paypal]

<a href="http://one.revver.com/revver" target="_blank">http://one.revver.com/revver</a> offers an RSS feed with video clips (youtube style), will this Hack work same, or is there a mod that needs to be performed?

[shaynehammy]

I had this addon installed and then upgraded to 3.6.3
In version 3.6.3 there is also a database table called "rssfeed"

An upgrade to the new version the rssfeed table is overwritten, and you will get errors on the addon.

I rebuild the database table for this script and then did an uninstall of the product, then I rebuild the table that comes with VB 3.6.3

I think the uninstall of this addon was not successfull, the system is still sending me emails with database errors. And in the admin toolbar, this Inferno rss feed was not removed from the admin toolbar. The error :

Database error in vBulletin 3.6.3:

Invalid SQL:
select r.*, f.title from vb_rssfeed r left join vb_forum f on(f.forumid = r.feed_forum) order by r.feed_name;

MySQL Error : Table 'xxxxxxxx.vb_rssfeed' doesn't exist
Error Number : 1146
Date : Monday, November 20th 2006 @ 02:16:24 PM
Script : http://www.xxxxxx.com/forum/redbulljoey/ffrss.php?
Referrer : http://www.xxxxxx.com/forum/redbulljoey/index.php?do=nav
IP Address : 84.81.128.127
Username : xxxxxxxx
Classname : vb_database

What can I do ?

Getting the exact same error in 3.6.4. Can someone fix this or upgrade this version to 3.6.4?

[shaynehammy]

Bump.

I'm getting a million and one emails saying the above error. Can someone please help me to remove this completely so i dont get the error?

Thanks for your help.

[sinpeople]

Hi,

I am using RSS feed which is integrated in 3.6.4. I can post RSS feeds of other sites into specified forums in my test forum.

Though the posts are posted, I want to modify its content. Normally, the post ends with a link to its original place. How can I remove this clickable link and replace it with the full text of this thread such that my visitors won't leave my forum.

Thanks
David

[puregraf]

Is there a way to post all rss feed from 1 rss feed to be posted inside 1 thread and have that thread be updated when rss feeds are updated?

instead of having each feed from that 1 feed be posted on seperate threads in a specific forum

thanks!

[Tralala]

Is there a way to post all rss feed from 1 rss feed to be posted inside 1 thread and have that thread be updated when rss feeds are updated?

instead of having each feed from that 1 feed be posted on seperate threads in a specific forum


FWIW, I'm not sure about Inferno - pretty sure that's not an option. But I know that's one of the newest features of ArticleBot, available on vBmodder.com, because I asked for it and the gracious developer added it in.

[serhat_kk]

It was working fine for 1 months but now it gives the same error at all rss feeds;
" Invalid URL To RSS Feed Given "

can someone help?

[nintendo]

Does any one know how to make the posts include the signature?

[serhat_kk]

It was working fine for 1 months but now it gives the same error at all rss feeds;
" Invalid URL To RSS Feed Given "

can someone help?

Help?:confused:

[x YNWA x]

Im getting a database error, anyone know why that would be?

Database error in vBulletin 3.6.7:

Invalid SQL:
select r.*, f.title from rssfeed r left join forum f on(f.forumid = r.feed_forum) order by r.feed_name;

MySQL Error : Unknown column 'r.feed_forum' in 'on clause'
Error Number : 1054
Date : Tuesday, June 12th 2007 @ 01:20:29 PM
Script : http://pesforum.co.uk/forum/admincp/ffrss.php?
Referrer : http://pesforum.co.uk/forum/admincp/index.php?do=nav
IP Address : 86.4.5.148
Username : x YNWA X
Classname : vB_Database

[username12]

Never mind. Figured out how to add the rssfeed table after uninstalling Inferno RSS in this thread (http://www.vbulletin.com/forum/showthread.php?t=230693&highlight=rssfeed).

[A|X]

When i click control forum feed i get error:

Database error in vBulletin 3.6.7:

Invalid SQL:
select r.*, f.title from rssfeed r left join forum f on(f.forumid = r.feed_forum) order by r.feed_name;

MySQL Error : Unknown column 'r.feed_forum' in 'on clause'
Error Number : 1054
Date : Friday, July 6th 2007 @ 09:23:42 AM
Script : http://www.ceritabrunei.com/forum/admincp/ffrss.php?
Referrer : http://www.ceritabrunei.com/forum/admincp/index.php?do=nav
IP Address : 61.6.198.11
Username : Editor
Classname : vb_database


WHat is the problem here?

[basskiller]

Is there any way to keep the posts made by this out of the "new posts" request?

bump

[wizard11]

Well done mate, it's pretty cool!

[TvForce]

i cant install i get this error
Database error in vBulletin 3.6.8:

Invalid SQL:
CREATE TABLE `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 'rssfeed' already exists
Error Number : 1050
Date : Saturday, July 28th 2007 @ 09:28:16 PM
Script : http://tvforce.net/admincp/plugin.php?do=productimport
Referrer : http://tvforce.net/admincp/plugin.php?do=productadd
IP Address : 2*1.**.***.9*
Username : Hypo
Classname : vB_Database
any ideas,
thanks :)

[BlackxRam]

thats because vb already has RSS functionality, this hack is out of date.

you can search any category for new posts seperately by adding &f=forumid

forumid being the number for example

www.site.com/forums/search.php?do=getnew&f=10

So you can search seperate categories by adding the above links on your forums.. not sure if there is a hack somewhere for this.

[flup]

I might have found a solution for the duplicate posts thing.. I replaced the post_thread() function with the following code:

function post_thread($title, $message, $feed)
{
global $vbulletin;

$getThread = $vbulletin->db->query("SELECT threadid FROM " . TABLE_PREFIX ."thread WHERE title = '" . mysql_real_escape_string($title) . "' AND forumid = '" . mysql_real_escape_string($feed['feed_forum']) . "'");
$ThreadNums = $vbulletin->db->num_rows($getThread);

if($ThreadNums < 1) {

$this->ItemsAdded++;

$newpost['title'] = $title;
$newpost['message'] = $message;
$smilie = true;
$foruminfo = fetch_foruminfo($feed['feed_forum']);

$ThreadDM =& datamanager_init('Thread_FirstPost', $vbulletin, ERRTYPE_ARRAY, 'threadpost');

$ThreadDM->set_info('forum', $foruminfo);
$ThreadDM->set_info('thread', $newpost);
$ThreadDM->setr('allowsmilie', $smilie);
$ThreadDM->setr('userid', $feed['feed_user']);
$ThreadDM->setr('title', $newpost['title']);
$ThreadDM->setr('pagetext', $newpost['message']);
$ThreadDM->setr('forumid', $feed['feed_forum']);
$ThreadDM->setr('dateline', $this->get_dateline());
$ThreadDM->set('visible', 1);
$ThreadDM->registry->options['floodchecktime'] = 0; // Disable flood check in memory...
$ThreadDM->pre_save();

if (sizeof($ThreadDM->errors) > 0)
{
$ThreadDM->errors = array();
}

$ThreadDM->save();

}

}

Please not that it only checks on the title.. so each post with the same title will be seen as a duplicate post and not be added to the forums. I think it works for me.. I tested it on some RSS feeds which are updated since the last cronjob and it added 1/3/4 items and not all 20 items which are on the list.

[flup]

One little change made to this piece of code.. added 'mysql_real_escape_string() over the $title var.. to prevent quotes from splitting the query in two resulting in a mysql-error.

[angusv]

This doesn't work with 3.6.8 - is there an update or a similar mod for 3.6.x?