NEW Modified RSS News Feed Hack

Hack originally posted by: Xyphen - RSS News Feed Hack
Modified by: wolfstream - Modified RSS News Feed Hack

I am posting this up as a new hack because of the major changes made to how the script works. Also, I didn't want people to get confused as to which one to download since there were 3 different versions on the original post.

Xyphen released the original version, then wolfstream modified the script and corrected some errors. After that, I modified wolfstreams version to change how posts were inserted. Now the post count will increase, posts will be able to be searched, and similiar threads will work.

RSS News Feed Hack for vB 3.0.x. As long as vBulletin doesn't change the database structure much, this should be good for the next release also, and those to come.

Allows you to have a live RSS news feed (such as one from Google or CNET) in a forum. The user that posts it will basically be a bot, which *should* only be used for posting the news, but you can even make it for a regular user.

Comments are welcome! Support provided through this thread.

Latest Version:
- 1.26 - for PHP 4.3.0 & above
- 1.26a - for PHP prior to 4.3.0

vBulletin Versions:
- 3.0.0
- 3.0.1

PHP Versions:
- > 4.3.0
- < 4.3.0

Installation Overview:
- Files to edit: (2) /admincp/index.php, /includes/functions_newpost.php
- Files to upload: (4) rss.php, admincp/rss_admin.php, includes/RSS/class.RSS.php, includes/RSS/rss_update.php
- Queries to run: (4) in rss_install.php

History:
Version 1.26 (23 June 2004 - Slapyo, Natch)
- listing of bot's more intuitive (Natch)
- hopefully fixed duplicate problem (Slapyo)
- stripped html tags from title and description (Slapyo)

Version 1.25 (12 May 2004 - Slapyo)
- fix for &quot; showing up
- logs action in scheduled task log if turned on

Version 1.24 (20 April 2004 - Slapyo)
- posts now deleted with delete_thread function
- post counts updated when using delete all news

Version 1.23 (14 April 2004 - Slapyo)
- added ability to delete bots
- cleaned up includes
- fix for PHP versions prior to 4.3.0 calling html_entity_decode()

Version 1.22 (13 April 2004 - Slapyo)
- duplicate posts problem fixed
- fix for problem with ' appearing as \'

Version 1.21 (12 April 2004 - Slapyo)
- bot will not be subscribed to posts now

Version 1.2 (11 April 2004 - Slapyo)
- posts now inserted with build_new_post function

Version 1.1 (28 March 2004 - wolfstream)
- file edits taken down to 1
- cron script included

Version 1.0 (28 January 2004 - Xyphen)
- original release

Common RSS Feeds:
- Yahoo!
- CNET.com
- BBC
- Wired News
- The Register
- Ars Technica
- All Headline News

[Rob Eh]

Is there a way to specify the time zone used in the control panel for this?

It uses the server time and not the time set by vB in the control panel.

Thanks,

[Mickey19781978]

I have installed this hack and got no errors running this or installing it

I installed version 1.26

My php version is 4.3.6.6

Forum ID 24
User ID 1 (which should be me once i get this to work iw ill create a user for it)
Source = http://www.sportnetwork.net/rss.php?sport=football

Nothing happens... install went smooth and all installed successfully
Scheduled task manager is set to 1 hour on Newsfeeds with filename ./rss.php

But when i hit run now
I still get nothing

Maybe i am using wrong sources?
If so could someone include a few addresses with rugby,football and UK news?

Cheers,

Mick

[Mickey19781978]

turned out i had a small failure in the functions_newpost.php

fixed it and is working now =)

awesome job on this m8ey

[Slapyo]

Originally Posted by Rob Eh

Is there a way to specify the time zone used in the control panel for this?

It uses the server time and not the time set by vB in the control panel.

Thanks,

hrm, i am not sure on how to do that. i will look into it, but it has to do with the insertion of the post ... i think it just uses now() to grab the date which would be server time. I will have to jump into vB code to see how they do it.

[CharlieBrownDE]

nice hack. installed and no problems 3.0.3 thx

[ntventures]

I installed the hack and get the following error:

Fatal error: Call to undefined function: log_cron_action() in /home/atech/www.discusssite.com/docs/rss.php on line 7

I'm running 3.0.3. It installed okay and added new threads when it installed, but hasn't added any more since. How do I fix it?

Thanks

[Slapyo]

hrm that's odd because it has all the files included that it needs above that for that function. you can remove the log_cron_action() line if you want. it's not really all that important.

[turbidblue]

edit: nevermind

problem solved

[Natch]

OK Slapyo - I need a hand - can you tell me why includex/functions_newpost.php just started giving me this error?[sql]## Invalid SQL:

UPDATE forum
SET replycount = replycount + 1,
threadcount = threadcount + 1,
lastpost = 1091567991,
lastposter = 'News',
lastthread = 'After the Accident (Forbes.com)',
lastthreadid = 3901,
lasticonid = 0
WHERE forumid =

## mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9[/sql]Whenever the RSS job is run ? it's somehow lost access to the $foruminfo[forumid] value ...

[cogimo]

Hi All

I found a great to get RSS feeds

http://www.prweb.com/rss.php

[pgowder]

I have 3 feeds setup. When I run the cron task it goes through 2 of them and then I get this error:

Warning: file(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/virtual/site2/fst/var/www/html/gathering/includes/RSS/rss_update.php on line 39

Warning: file(http://www.nativenationsnet.net/backend.php): failed to open stream: Resource temporarily unavailable in /home/virtual/site2/fst/var/www/html/gathering/includes/RSS/rss_update.php on line 39

Warning: implode(): Bad arguments. in /home/virtual/site2/fst/var/www/html/gathering/includes/RSS/rss_update.php on line 39

[M1th]

Err... is this hack secure?

RSS.php file contains nothing but

PHP Code:

<?
require_once('./global.php');
require_once('./includes/functions_bigthree.php');
require_once('./includes/functions_forumlist.php');
require_once('./includes/functions_newpost.php');
require_once('./includes/RSS/rss_update.php');
log_cron_action('RSS News Feed Posted', $nextitem);
?>

am i right in assuming that no permission check is necassary?

[croft]

Ok. My feeds wont update automaticly at all.
They did it the first time now nothing.
Im using rss version 0,91.
I cant even update the feeds by running the cron manual.

[M1th]

Originally Posted by croft

Ok. My feeds wont update automaticly at all.
They did it the first time now nothing.
Im using rss version 0,91.
I cant even update the feeds by running the cron manual.

same here.

[Slapyo]

i have been really busy with my new job and haven't been able to work on this at all.

i do suggest that you check out article bot. it is the same as this but offers alot more features for the news.