The Arcive of Official vBulletin Modifications Site.

NEW Modified RSS News Feed Hack · **Released**: 04-12-2004

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 " 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

Acido · #17 04-13-2004, 11:42 AM

Quote:

Originally Posted by Slapyo

http://www.sportsbabble.net/showthread.php?t=570

there is a link to a post made by my news bot and it has ' in it ... but without the leading \, what is the link to the rss feed you are using?

i just uploaded a new version that fixes the bot subscribing to the threads. it should no longer subscribe to threads. the change was in rss_update.php so you can upload just that file if you want.

i can't see what is causing the problem with stories being posted multiple times. on mine i don't get the multiple stories, but every once in a while. the original author included a check in the program, but it is obviously not working properly. the code for this is in rss_update.php. i will look at it more.

I'm getting multiple Stories too. The feed that i'm using is :

Quote:

http://www.lanacion.com.ar/herramientas/rss/index.asp?origen=2

If help, the fields: rdd_feed and rss_date in the thread table, are always empty :ermm:

I'll apreciate if you can help me to avoid duplications, triplications, etc... using the bot. I think that the filter most be based in the title of the feed only, but i dont know how fix it.

Thanx in advance !

Slapyo · #18 04-13-2004, 01:27 PM

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)

mharmon · #19 04-13-2004, 01:33 PM

On the Yahoo feeds located at:

http://news.yahoo.com/rss

Is there anyway to specify a variable in the URL so you can limit the amount of headlines it grabs? I don't want 40-50 news items appearing in a forum -- I'd rather limit it to 5-10 a day..

Slapyo · #20 04-13-2004, 01:40 PM

that would be up to the feed itself if they were to accept something like that. i mean i guess you could go into the code and change the loop so that it didn't loop from:

0 -> # news articles
to
0 -> 10 (or 5)

mharmon · #21 04-13-2004, 01:42 PM

Slapyo -- Where would I change that? Can you find where that it is and shoot it over to me?

rocket98 · #22 04-13-2004, 02:03 PM

[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 · #23 04-13-2004, 02:12 PM

Quote:

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:

Quote:

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 · #24 04-13-2004, 02:37 PM

Quote:

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 · #25 04-13-2004, 03:48 PM

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

mirdin · #26 04-13-2004, 04:13 PM

Quote:

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 · #27 04-13-2004, 05:03 PM

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 · #28 04-13-2004, 07:16 PM

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 · #29 04-13-2004, 07:51 PM

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 · #30 04-13-2004, 09:00 PM

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 · #31 04-13-2004, 09:08 PM

Thanks Slapuo ..

Any news about the \ problem?

(not tried 1.22 yet so don't know if still doing it

.. yep it is)

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.13496 seconds Memory Usage 2,375KB Queries Executed 30 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!