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)

[dethfire]

bummer, this is a great idea, too bad it just doesn't work

[wolfstream]

Originally Posted by dethfire

I installed the new version and when I run the cron I get this error:
Warning: mysql_query(): Unable to save result set in /htdocs/www/includes/db_mysql.php on line 212

Invalid SQL: SELECT * FROM post ORDER By postid DESC
mysql error: MySQL client run out of memory

mysql error number: 2008

I only added two bots

That's an issue with your provider, not with the individual hack. Error codes are a good thing to read and pay attention to. Your mysql client ran out of memory, which is far from something that's hack related

Funny, it's not working with the vB3 newsfeeds

This hack works wonderfully on vb3 gold, and the second version makes it a lot easier to install.

That fix is running on 2 forums and seems to work well.

I'll update my zip to include that fix if it doesn't, later tonight Thanks for posting that.

I'm really not sure what happened to the original author, I'm certainly not trying to take over his project, just trying to provide working code that others can use.

[dethfire]

wolfstream, our mysql has a memory of 40mb, your telling me the 2 yahoo rss files take up that much memory? :nervous:

[wolfstream]

No, what I'm telling you is that your server's too loaded down. It's a common problem. Like I said, the error says it all right there.

mysql error: MySQL client run out of memory

Your MySQL client has no memory left, so it's bailing on you. This isn't a hack problem, this either is a memory problem or a server problem.

[dethfire]

Ok I understand that, however it still doesn't make sense. My forum is large, avg 300 people online. I would think that would crash the server more quickly than inserting a couple RSS files into the database. Wouldn't you think?

[jluerken]

Waht about version 2 of the RSS Hack? The hack is working fine but I still have the problem that I have to delete all news manually before new are posted.

[rockergrrl]

Bah.... for the last 3 days, its been reposting the same news feed. I have about 10 of the same topic/title - at its not the latest feed... its an previous one from before the last one posted.

And none of the others are updating anymore... :/

[LoOnEyToOnZ]

My yahoo RSS screwed up, post 100s of threads at 1 time..i had to disable yahoo feed in the end

[Entourage]

Installed it, works perfect. got 3 news feeds working lovely.

Have only a 2 questions:
- Is it possible to delete a complete bot?
- Possible to filter out the HTML tags?

[dethfire]

doesn't look like this hack is supported anymore

[sjau]

Originally Posted by Entourage

Installed it, works perfect. got 3 news feeds working lovely.

Have only a 2 questions:
- Is it possible to delete a complete bot?
- Possible to filter out the HTML tags?

How do you mean to delete a complete bot?

Filter out HTML - You can use php replace tags for that

[Entourage]

Originally Posted by sjau

How do you mean to delete a complete bot?

Well I added three bots now, I want to delete a bot from the Motify bot list.

[jluerken]

Originally Posted by Entourage

Well I added three bots now, I want to delete a bot from the Motify bot list.

I had the same problem Entourage and deleted the bot with phpMyAdmin directly from the DB. There is no build in option to do so.

I have also a question. The news feed is working well but only if there aren't already posts in the forum.

How can I use the sheduled task option to prune all posts from a special forum at a explicit time?

[pgowder]

When and how do the posts to the forum happen?

I've installed it and added a bot, when will the posts show up?

[PranK]

hooooolllleeeeey crap!

I installed this and I have never seen my server load and mem usage go so high before!!!

any ideas why?

Thanks.

Christian