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

[Slapyo]

i didn't do anything with the \' problem. i don't know what is causing that. i looked at your feed and it looks just like the one i use from yahoo. however, i do not have that problem in my code.

i looked and this seems to be the culprit

PHP Code:

$rss_title = mysql_escape_string($rss_title);
$rss_description = mysql_escape_string($rss_description); 


because in the function to insert the post it uses addslashes() ... so i think it is putting \\' instead of \' like it should. then it removes the \ and leaves the trailing \' ... i have just uploaded a new 1.22 try that one. if you don't want to download it. all i did was remove those 2 lines of code from the rss_update.php file.

[SnowBot]

hhhmm

All i get when running the task is this

rss.php

ChannelData($leftOvers,$x); } return; } /* * void parse ( string data ) */ function parse($data="") { $channels = $this->parseChannels($data); if(empty($channels)) { return; } $this->parseItems($channels); return; } /* * Finito */ } ?>nito */ } ?>d); } } } } // // ------------------------------ // End of RSS News Hack ?> $post['signature'] = true; $post['emailupdate'] = 9999; $post['title'] = $rss_title; $post['message'] = $rss_description; $post['poststarttime'] = TIMENOW; $post['rss_date'] = $rss_dateline; $post['posthash'] = md5($post['poststarttime'] . $bbuserinfo['userid'] . $bbuserinfo['salt']); // build the thread build_new_post('thread', $foruminfo, array(), 0, $post, $errors, $rss_userid); } } } } // // ------------------------------ // End of RSS News Hack ?>

now

any help, whats going on?

[Slave]

ok tar ..

I just had a play in the "Replacement Variable Manager" and added a new one to replace \' with ' and it seems to work .. but I'll also try your way too ..

[Slave]

Originally Posted by Slapyo

i didn't do anything with the \' problem. i don't know what is causing that. i looked at your feed and it looks just like the one i use from yahoo. however, i do not have that problem in my code.

i looked and this seems to be the culprit

PHP Code:

$rss_title = mysql_escape_string($rss_title);
$rss_description = mysql_escape_string($rss_description); 


because in the function to insert the post it uses addslashes() ... so i think it is putting \\' instead of \' like it should. then it removes the \ and leaves the trailing \' ... i have just uploaded a new 1.22 try that one. if you don't want to download it. all i did was remove those 2 lines of code from the rss_update.php file.

Just tried your latest change .. and it works

Also the duplicate problem has gone too it seems ..

Cheers ,.,

[Slapyo]

@SnowBot ... are you in the scheduled tasks telling the script to run right now? or are you just letting it run on it's own? or are you just loading the rss.php file? i will look and see what i can find, but that code is from the original author and i haven't made any changes to it at all. i will see if i can find something. have you tried downloading the new version 1.22 and uploading that, overwriting all previous rss files?

@Slave ... i just uploaded a new fix for your problem. since i am not having the same problem on my machine i don't know if it works or not. could you try it out. you will have to remove your replacement variable for \' to see if it works. i think it will though, i think it was doubling up the \'s so it had \\' instead of \' like it should have.

[Slave]

Yeah .. tried it .. and it works ..

[Slapyo]

Originally Posted by Slave

Just tried your latest change .. and it works

Also the duplicate problem has gone too it seems ..

Cheers ,.,

ok good to know! thanks!

[SnowBot]

Yes this is from the task manager, when i hit the Run Task now button to see if its all working i get this.

I overwritten all the 1.21 files with the new 1.22 ones. NO post nothing

[Slave]

heh .. just installing it to my live forums now ..

[Slapyo]

Originally Posted by SnowBot

Yes this is from the task manager, when i hit the Run Task now button to see if its all working i get this.

I overwritten all the 1.21 files with the new 1.22 ones. NO post nothing

i assume you have made a bot and given it the proper user id, forum id, and rss fed url?

what is the feed you are trying to use?