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

[SnowBot]

Yes done that

rss feed =

http://news.bbc.co.uk/rss/newsonline_uk_edition/front_page/rss091.xml

.xml

[Slave]

[high]* Slave clicks install ..
[/high]

Works brill .. .. One user (News Bot) in 3 forums ..

[SnowBot]

Originally Posted by Slapyo

i assume you have made a bot and given it the proper user id?

I set up a new usergroup just for bots and added a new user to that group. In the RSS News feed menu i added a bot with the forum id as 29

 [url="http://www.synergyforums.com/forum/forumdisplay.php?f=29"]http://www.synergyforums.com/forum/forumdisplay.php?f=29[/url]

Added the user id as

276 and that feed

[Slapyo]

Originally Posted by SnowBot

I set up a new usergroup just for bots and added a new user to that group. In the RSS News feed menu i added a bot with the forum id as 29

 [url="http://www.synergyforums.com/forum/forumdisplay.php?f=29"]http://www.synergyforums.com/forum/forumdisplay.php?f=29[/url]

Added the user id as

276 and that feed

ok

forum id: 29
user id: 276
source: http://news.bbc.co.uk/rss/newsonline...age/rss091.xml

and you ran the rss_install.php file too correct?

everything sounds like you have it set up correctly. what version of PHP do you have?

[SnowBot]

Yep i ran the script, if i try running it again i get this

 Database error in vBulletin 3.0.0:
Invalid SQL: CREATE TABLE `rss_settings` (`enabled` tinyint(1) NOT NULL default '1' );
mysql error: Table 'rss_settings' already exists
mysql error number: 1050
Date: Tuesday 13th of April 2004 07:07:38 PM
Script: http://www.synergyforums.com/forum/rss_install.php
Referer: 
Username: Snowy
IP Address: **.**.**.**

PHP version 4.3.5

[Slapyo]

is your scheduled task is set up like this?

filename: ./rss.php

the other fields depend upon you, whatever you want to call it and whenever you want the script to run. but the file name should look like that.

[SnowBot]

Yep

[Slapyo]

wow, that's weird. it looks like it is just printing out part of the code from class.RSS.php and from rss_update.php ... but i don't know why it is doing this. lemme look some more.

[SnowBot]

Just a note, if i try and run the upgrade script i get this error

 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
Date: Tuesday 13th of April 2004 07:30:18 PM
Script: http://www.synergyforums.com/forum/rss_upgrade.php
Referer: 
Username: Snowy

How would i unistall the script and then try running it again ? Maybe that may fix it ? ? I dunno, i guess im just guessing here now

[Slapyo]

delete these tables:
vb3_rss_settings
vb3_rss_user

modify the vb3_thread table, delete these 2 fields:
rss_feed
rss_date

** Note: the table prefix might be different for you, but my table prefix is vb3_

remove these files:
rss.php
rss_install.php
rss_upgrade.php
/admincp/rss_admin.php
/includes/RSS/class.RSS.php
/includes/RSS/rss_update.php

then download the newest version, 1.22, and install it. hopefully this works.