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

[rocket98]

[QUOTE=mirdin]You'll have to ask your host to upgrade to a more recent version of PHP.

Or if you follow the link to the php function I posted before, it shows this code:

PHP Code:

// For users prior to PHP 4.3.0 you may do this:
function unhtmlentities($string) 
{
   $trans_tbl = get_html_translation_table(HTML_ENTITIES);
   $trans_tbl = array_flip($trans_tbl);
   return strtr($string, $trans_tbl);
}

$c = unhtmlentities($a);

echo $c; // I'll "walk" the <b>dog</b> now

?> 


If upgrading PHP is not possible for you then you could try to replace the html_entity_decode function using this example.


-----
I read the install instructions for this hack, it specified no where that certain version number dependencies were required before implementing ... it just said whoopee let's go!!!


It may not be possible for some of us to "TELL" our ISP to UPGRADE some ISP's don't give a rat's a$$ about what we do on their systems they just want their $4.95 a month.

Replace this CODE WHERE?

Thank you.

[Acido]

Originally Posted by Slapyo

ok, i think i have solved the problem with the duplicate posts. after acido mentioned that there were blank fields for the rss_feed and rss_date i realized that the vB function doesn't insert the new data.

so, to fix it i have uploaded v1.22 ... this includes the following changes:
- one more modification to functions_newpost.php (edit and upload)
- one fix to rss_update.php (just upload new one)

I'm getting a Database conflict when i run the cron on the task manager:

Database error in vBulletin 3.0.0:

Invalid SQL:
INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername,
postuserid, lastposter, dateline,
iconid, visible, attach, similar, rss_feed, rss_date)
VALUES
('Rod++++ bati? su propio r?cord de velocidad en el saque', 1081868007, 1060,
1, 0, 'Deportes', 4573,
'Deportes', 1081868007, 0, 1,
0, ', 1, ')

mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

New threads are created, but i need rebuild forum information to see the last post in the forum display. Also, the field rss_date is still null .

Hope help.

[SnowBot]

Originally Posted by Slapyo

so, to fix it i have uploaded v1.22 ... this includes the following changes:
- one more modification to functions_newpost.php (edit and upload)
- one fix to rss_update.php (just upload new one)

The Zip still says 1.21. Are the new files within this zip?

[Host Visions]

Thanks for this. Any idea how to not have duplicate posts?

[mirdin]

Originally Posted by Slapyo

so, to fix it i have uploaded v1.22 ... this includes the following changes:
- one more modification to functions_newpost.php (edit and upload)
- one fix to rss_update.php (just upload new one)

Downloaded 1.22, took the original functions_newpost.php and made the changes and uploaded it, also uploaded the new rss_update.php and still it is not recognizing already posted articles.

rss_feed fields values are all 0, rss_date fields are still empty.

[SnowBot]

i have installed this but hhhmm nothing is being posted any ideas?

The forum is set corectly as i have just click the delete all news posts and wiped the forum completely But i guess that part works......

So the bot / user isnt posting

[SnowBot]

OK i re traced my steps and now when i try and run the scedual task i get 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 */ } ?>d); } } } } // // ------------------------------ // End of RSS News Hack ?>

Help

[Slapyo]

sorry guys, i tried to get the new one up before i left for class for the day and found an error so i pulled it quickly and put back 1.21. i will fix the problem and get it back up when i get home from classes for the day.

also, i will make note of the problem with php version and include a fix for those that maybe have a lower version and can't change it.

i wasn't aware of that problem, and since it was working on mine i figured it was good to go. will include that in the next fix.

i'm still at school right now between classes, won't be home till later tonight though. hopefully i will have it checking for duplicate posts and i will have the fix for lower php versions in the install.

[Slapyo]

ok, i have fixed the duplicate post problem. it now inserts the data into the rss_feed and rss_date fields. it should check the post and not post it if it is a duplicate.

also, i have included in the rss_update.php file a section of commented code. if you use a version of PHP prior to 4.3.0 you will need to uncomment this section out, and then comment the 2 lines above it.

[Slave]

Thanks Slapuo ..

Any news about the \ problem?

(not tried 1.22 yet so don't know if still doing it .. yep it is)