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

[dethfire]

Originally Posted by Slapyo

ok, i am at work and made some changes but can't test it out.

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)

for comparing the RSS feed with whats in the database, i just applied the same things i do before inserting the post. so it should be the same. i also applied Natch's hack to make listing the bots easier.

thanks!!! do we have to run any queries to update or just overwite the files?

[dethfire]

running the update

Database error in vBulletin 3.0.0:

Invalid SQL: ALTER TABLE rss_settings DROP forumid, DROP userid, DROP source
mysql error: Can't DROP 'forumid'. Check that column/key exists

mysql error number: 1091

[Slapyo]

sorry, no need to run the update. actually i should remove those from the install cause there is nothing to update from really. that was from the previous script.

the rss_admin.php and rss_update.php were the only files edited, so you just have to upload those.

[Natch]

Thanks - I'll let you know how this goes with the dup. posting ...

[Intex]

Slapyo - the only additional code I offered was excluding certain forums from the search (utilising 2 search scripts). If this is what you meant, go ahead, fine by me.

Originally Posted by Slapyo

nope, but if intex doesn't mind i would like to add this into the full release version. intex?

[smsmasters]

Where's the code to exclude certain forums from search?

[Intex]

I posted it way back in this thread HERE.

[Slapyo]

sorry intex, i meant Natch, but thought it was you because i saw the code in your post, but it was a quote of Natch. and yes, actually i would like to include your code to remove the posts from search because i know some people have requested that. thanks.

[Blackbeard]

Top 100 Most-Subscribed-To RSS Feeds

http://radio.xmlstoragesystem.com/rcsPublic/rssHotlist

hope this is of some use

[Blackbeard]

Done the install, set up a bot etc, then ran the schedule and got this error

Parse error: parse error in /home/httpd/vhosts/l**********.com/httpdocs/forums/includes/functions_newpost.php on line 1187

line 1187 is

?>

whats happening here