RSS News Feed Hack

My friend made this hack, he owns http://www.liquidpro.net. Check him out.
You may contact him at liquidpro@neo.rr.com. Or you can IM him on AIM at LiquidPro10.

An example is shown at http://www.xtreme-forumz.net. Go to the Techno forum under the General category. Then the CNET News sub-forum.

RSS News Feed Hack for vB 3.0.0. 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!

Instructons:
Note: DON'T FORGET TO MAKE A BACKUP OF EACH FILE BEFORE YOU MODIFY IT!

Copy the files to your web server... keep the same directory structure as in the zip file.
Run the rss_install.php file to setup the RSS script.
If you're upgrading run the rss_upgrade.php file to setup the RSS script. Don't forget to remove all previous modifications (you can find them by searching for "LiquidPro")

#### open the /index.php script ####
Find this:

PHP Code:

require_once('./includes/functions_forumlist.php'); 


Add below it:

PHP Code:

require_once('./includes/RSS/rss_update.php'); 


#### open the /forumdisplay.php script ####
Find this:

PHP Code:

require_once('./includes/functions_forumdisplay.php'); 


Add below it:

PHP Code:

require_once('./includes/RSS/rss_update.php'); 


#### open the /admincp/index.php script ####

Find this:

PHP Code:

construct_nav_group("$vbphrase[styles] &amp; $vbphrase[templates]", '<hr />'); 


Add below it:

PHP Code:

// Manage Hacks
// by: Andrew Wickham
// LiquidPro Inc.
//
construct_nav_option('RSS News Feed', 'rss_admin.php', '<br />');
construct_nav_group('Hacks');
//
// End Manage Hacks 


You're done, thanks for installing the hack.

Hack by: Andrew Wickham (http://www.liquidpro.net)
Hack for: Xtreme-Forumz (http://www.xtreme-forumz.net)

[clangrounds.com]

Originally Posted by Shock.r

Guys, sjau posted a fix for this.

Find in /forum/includes/RSS/rss_update.php:

for($i = count($rss_allItems) - 1; $i >= 0; $i--) { 
            $rss_allItems[$i][OLD] = true; 
        }

Replace:

 for($i = count($rss_allItems) - 1; $i >= 0; $i--) { 
            $rss_allItems[$i][OLD] = false; 
        }

Also for updating, wolfstream posted a cron job for this!
Put the following code in wordpad and save as rssfeed.php then put it in your includes/cron/ folder.

Then in your admin control panel under "Scheduled Tasks" then click "Add New Scheduled Task" Give it a name, then under "Minute" I put mine on 59 so it updates ever 59 mins!

Then for file name put ./includes/cron/YOUR PHP FILE.php

<?
require_once('./global.php');
require_once('./includes/functions_bigthree.php');
require_once('./includes/functions_forumlist.php');
require_once('./includes/RSS/rss_update.php');
?>

Also, don't forget to remove following from /forumdisplay.php and /index.php:

require_once('./includes/RSS/rss_update.php');

I tried this and now get this error message when I try to run it in admincp:

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: INSERT INTO post (`threadid`, `username`, `userid`, `title`, `dateline`, `pagetext`, `allowsmilie`, `showsignature`, `visible`) VALUES ('2209', '', '0', 'Are Two Screens Better Than One?', '1079204704', 'Nintendo touts its latest portable video game, a dual-screen system that lets players view the action from different perspectives. Will it be a worthy rival to Sony's PSP?<br><br>View the Entire Article
', '1', '1', '1')
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 's PSP?<br><br>http://www.clangrounds.com/admincp/cronadmin.php?do=runcron&cronid=16
Referer: 
Username: Rebel
IP Address: edited

[CdaKnight]

Hey, I had a question. I briefly skimmed through the thread (I'm trying to multi-task getting ready with this), and I didn't find the answer.

Has this script been modified to be more "cron" like? Does it check the RSS feed every time a page is loaded, or is there any way that another cron can be created so that each bot runs at a certain time during a non-busy period? (Like say... I want a Cnet bot to run at 4am, and another RSS feed bot to run at 5am, etc)

Sorry if this has been answered and I missed it

[Lurk]

What style was used in the RSS feed screenshot?

[Lurk]

Originally Posted by LurkCorp

What style was used in the RSS feed screenshot?

what is the style used in this screenshot?
http://lurkcorp.com/pubsighost/screencap.gif

I really want to know...
if someone knows, please post or pm me what it is and/or where to find it.

[CdaKnight]

I would assume its one the guy designed himself.

[Lurk]

Originally Posted by CdaKnight

I would assume its one the guy designed himself.

i finally know it, it's a $40 style.
It's called GelTech
http://www.insidethepixel.com/demo/

[Lurk]

is there a certain limit to how many feeds can be used?
do only certain feeds work?

[ethics]

Originally Posted by CdaKnight

Hey, I had a question. I briefly skimmed through the thread (I'm trying to multi-task getting ready with this), and I didn't find the answer.

Has this script been modified to be more "cron" like? Does it check the RSS feed every time a page is loaded, or is there any way that another cron can be created so that each bot runs at a certain time during a non-busy period? (Like say... I want a Cnet bot to run at 4am, and another RSS feed bot to run at 5am, etc)

Sorry if this has been answered and I missed it

Vie scheduled tasks you can break up the time all bots are done via different lists that you can specify.

[jluerken]

When will you release version 2?

[cscgal]

Yes I am very curious too.