vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   RSS News Feed Hack (https://vborg.vbsupport.ru/showthread.php?t=60899)

cscgal 03-23-2004 10:02 PM

I was having the same problem but I found a post on page 6 or so with a quick fix. So I did the fix and then it all worked but every so often it would repost the same thread upon every single update (every 15 mins). Finally I just gave up and uninstalled the hack. I'll try again when version 2 of the hack comes out, whenever that may be.

rockergrrl 03-27-2004 07:57 PM

I just installed this on my board....

When I added in the news feed in the admincp, I accidently put the wrong forum ID/user ID (reversed the ID #s).

But its not showing up in the Modify Bots page....
So I added in what the ID # should be in a new bot.

Still not showing up under Modify Bots.

So I clicked on Delete All News (so so I thought).

Well they were deleted, but when I added in the new bot (where it should've been), it added it back into the two threads that they were in before (the reversed #s one and the correct #).

*sigh*

And when I try to delete the feeds from the bad forum, they reappear. :/

Any suggestions?

Lurk 03-27-2004 09:34 PM

Quote:

Originally Posted by rockergrrl
I just installed this on my board....

When I added in the news feed in the admincp, I accidently put the wrong forum ID/user ID (reversed the ID #s).

But its not showing up in the Modify Bots page....
So I added in what the ID # should be in a new bot.

Still not showing up under Modify Bots.

So I clicked on Delete All News (so so I thought).

Well they were deleted, but when I added in the new bot (where it should've been), it added it back into the two threads that they were in before (the reversed #s one and the correct #).

*sigh*

And when I try to delete the feeds from the bad forum, they reappear. :/

Any suggestions?

I finally found out the problem with my board....
Each RSS bot has to have a seperate user name.
for example:
it doesn't work if more than one bot uses the user id of 1..

rockergrrl 03-27-2004 10:30 PM

That wasn't the case....

I switched the forum id with the user id (I had a *dislexic* moment at the time)

So instead of forum id: 72, and member id: 27...
I had forum id: 27, and member id: 72 (which didn't exist)

So I made a new bot entry with the correct ids.

And the one with the wrong forum/member id never showed up (nor did the correct one).

And when I tried deleted everything to start over, and deleted the posted feeds in the wrong forum, and correctly added what the ID #s were suppose to be... The old bot was still posting feeds in the wrong forum - as well as the correct forum.

Messed up.... :/

Should I just replace the files that were edited, etc? and start over?
Or will it still do it?

Gracias!

Lurk 03-27-2004 10:44 PM

Quote:

Originally Posted by rockergrrl
That wasn't the case....

I switched the forum id with the user id (I had a *dislexic* moment at the time)

So instead of forum id: 72, and member id: 27...
I had forum id: 27, and member id: 72 (which didn't exist)

So I made a new bot entry with the correct ids.

And the one with the wrong forum/member id never showed up (nor did the correct one).

And when I tried deleted everything to start over, and deleted the posted feeds in the wrong forum, and correctly added what the ID #s were suppose to be... The old bot was still posting feeds in the wrong forum - as well as the correct forum.

Messed up.... :/

Should I just replace the files that were edited, etc? and start over?
Or will it still do it?

Gracias!

yeah, i think you should...

wolfstream 03-28-2004 07:21 AM

Actually, it is very possible to have the same bot posting news in multiple forums. I had this going on for quite some time.

As far as the news not updating, others have posted a fix for it. Make sure to read the whole thread, because there's a few things regarding cron that should be paid attention too. If you've got a forum that's heavily used, updating the rss feeds every time you have a page view is a very bad idea.

Lurk 03-28-2004 01:14 PM

Quote:

Originally Posted by wolfstream
Actually, it is very possible to have the same bot posting news in multiple forums. I had this going on for quite some time.

As far as the news not updating, others have posted a fix for it. Make sure to read the whole thread, because there's a few things regarding cron that should be paid attention too. If you've got a forum that's heavily used, updating the rss feeds every time you have a page view is a very bad idea.

oh?
well, when i used the same user for multiple feeds and forums.. it didn't work :(

Dean C 03-28-2004 01:24 PM

Wow I can't believe I missed this one - it looks great :)!

croft 03-28-2004 03:39 PM

I have been browsing this thread now for a while trying to find and answer.

Have anyone fixed the html tag problem that can occure when the rss feed have images and links and such ?

And could some one in detail explain to me how to fix the postcounts.

And about the cron job. Im very scared to do anything with my db cron jobs ar anything like that. I feel like everything is gonna break when i hit my cpanel link LOL.

Lurk 03-28-2004 03:55 PM

why doesn't it say the number of threads and posts? on the categories where i have rss feeds

croft 03-28-2004 10:07 PM

Im having a bit of problems.
The feed wont update and add new items ???
it added 2 the first time i executed the feed but not anymore.
Can i have a bit of help here guys ?

wolfstream 03-28-2004 10:33 PM

Quote:

Originally Posted by croft
Im having a bit of problems.
The feed wont update and add new items ???
it added 2 the first time i executed the feed but not anymore.
Can i have a bit of help here guys ?

Known problem, read through the thread, there's a fix there.

himerus 03-28-2004 11:50 PM

Quote:

Originally Posted by wolfstream
Known problem, read through the thread, there's a fix there.

Could you link to the post? I'm having the same problem, and some of these longer threads are hard to read word for word searching for the right bit of text.

:)

Thanks!!!

(I am having the same problem by the way)

wolfstream 03-28-2004 11:59 PM

https://vborg.vbsupport.ru/showthrea...9&page=4&pp=15
Read through that page, the whole page, the bugfixes are explained in there.
Perhaps the author should start supporting his own hack like he agreed to though;)

himerus 03-29-2004 12:48 AM

Quote:

Originally Posted by wolfstream
https://vborg.vbsupport.ru/showthrea...9&page=4&pp=15
Read through that page, the whole page, the bugfixes are explained in there.
Perhaps the author should start supporting his own hack like he agreed to though;)

yeah... none of that still works for me... too many bugs... not enough good code.

I'll try again when a new release of this comes out, or someone else re-releases it with new updates.

Thanks

wolfstream 03-29-2004 01:02 AM

If it didn't work, make sure you haven't been banned from the feed itself. Those fixes WILL fix the problem of not updating, I know, I had the very same problem myself. There are 2, maybe 3 fixes that should be made.


As far as releases, well, who knows. The code works if you apply the fixes, but you've got to apply them all to get it to work;)

wolfstream 03-29-2004 04:50 AM

Ok, I just took a few minutes and put together a WORKING install of this.
The file edits have been taken down to 1 and the cron script IS included.
The only thing different between this and the first zip is the file edits and the bugs have been fixed in rss_update.php.

I just tested this, and installed it on vb3 gold. There's no question in my mind it's working.
When you design the forums for these, you'll want to make sure that the forum handles html, otherwise you'll have a problem.

Action-N 03-29-2004 04:50 AM

I installed this one an managed to get it to update three times. Not sure what it takes to get it to update, but it does work. I do think it makes a difference on which feed you use. The CNET 5 news is what is working for me, the Yahoo news feed is one I found scary. Loaded the forum with about three pages of posts, stupid crap. So that forum is gone. Now I wanted to ask how I can I allow only the bot to post, with forum closed to all other users.

P.S. The really need to move this one to Beta releases, sorry Xyphen.

MrNase 03-31-2004 11:07 AM

Funny, it's not working with the vB3 newsfeeds :(

sjau 04-02-2004 10:07 AM

Going to install it today on vB3 Gold and checking how it works... have it running fine on RC3

LoOnEyToOnZ 04-02-2004 01:42 PM

Guys... how can i get Yahoo RSS feed unto my forums with this ? I already installed this hack, just dunno how to use Yahoo RSS

rockergrrl 04-02-2004 02:19 PM

Yahoo RSS is located here:
http://news.yahoo.com/rss/

Find the topic that you want and copy the URL to the feed.

It will update (works for me).

LoOnEyToOnZ 04-02-2004 03:01 PM

ic... Tonya do you just copy the url like http://news.yahoo.com/rss/tech/ ?

Or does it have to end with a .xml ?




Also... please check out my forums www.sgwhz.com and under Industry News.... you see the RSS by Yahoo! Tech. When you click on the view full article link it comes out to a error page on Yahoo....any idea why it happens ?

dethfire 04-02-2004 05:06 PM

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 :(

Vb-Hispano 04-02-2004 05:59 PM

Thanks very much for your work ;)

rockergrrl 04-02-2004 06:46 PM

Quote:

Originally Posted by LoOnEyToOnZ
ic... Tonya do you just copy the url like http://news.yahoo.com/rss/tech/ ?

Or does it have to end with a .xml ?

For Yahoo tech feeds use this url:
http://rss.news.yahoo.com/rss/tech

http://news.yahoo.com/rss/tech/ is just the general list of Feeds that are available. Copy the URL next to the subject you want listed.

PlenoJure 04-02-2004 09:17 PM

LoOnEyToOnZ, the reason that happens is because of an html decoding bug, here's what I did to fix it:

In ./includes/RSS/rss_update.php Find:
PHP Code:

$rss_description .= "\n\n[url=" $rss_allItems[$j][LINK] . "]View the Entire Article[/url]\n"

UNDER that ADD:
PHP Code:

$rss_description html_entity_decode($rss_description);
$rss_title html_entity_decode($rss_title); 

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

dethfire 04-02-2004 09:27 PM

Quote:

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 :(


anyone got a suggestion for my problem?

Leah 04-02-2004 11:39 PM

Quote:

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 :(

Same error here.

And also, the posts doesn't show up.

dethfire 04-03-2004 10:20 PM

no posts because mysql runs out of memory

dethfire 04-05-2004 01:59 AM

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

wolfstream 04-05-2004 02:20 AM

Quote:

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:)

Quote:

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.

Quote:

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 04-05-2004 02:49 AM

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

wolfstream 04-05-2004 03:02 AM

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.
Quote:

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 04-05-2004 03:05 AM

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 04-05-2004 08:22 AM

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 04-05-2004 06:41 PM

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 04-06-2004 03:26 AM

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

Entourage 04-06-2004 02:27 PM

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 04-06-2004 03:00 PM

doesn't look like this hack is supported anymore


All times are GMT. The time now is 07:43 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01379 seconds
  • Memory Usage 1,840KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete