View Single Post
  #1  
Old 09-02-2006, 01:28 PM
liquidrage liquidrage is offline
 
Join Date: Aug 2006
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How do I put RSS results into one post not seperate thread?

This is for the built in RSS manager in 3.6

What I would like to do is on a scheduled basis run an RSS feed and put all the results from the RSS feed into one post in one thread, have it be stickied, and then unsticky the previous thread.

Now, basically, I figure I can do this in mySQL by putting the RSS feed results into a hidden forum where it puts each result into it's own thread, running a scheduled sql job that selects the text from the posts in the forum, formats into one post, creates a post in the real forum, stickies the post, unstickies the previous one, and then deletes all the threads in the hidden forum.

But since this seems like something others would have liked done I'm hoping there's already something out there for this.
Plus, it seems like the plan I have using sql is going to have issues with fetching old posts, so I would need some tweaking to the plan.

Any advice on accomplishing this would be appreciated.

Thanks....

//Update since no one seems to have a pre-existing solution..............................
Basically, what I've come up with is to have the posts from the 3.6 RSS manager be defaulted as sticky threads in the hidden forum. Once a day, in the morning the schuleded task runs, grabbing the text from all sticky threads and combining the texts from all sticky threads in the hidden forum into one post, one thread, in the desired forum.
Then, lastly, my script updates the hidden forum making all posts non-sticky.
This gets around the problem the RSS manager has in keeping track.

It's certainly not elegant (shoot I've only been playing around with vB for about 2 weeks, and I'm not normally using PHP at work), but it works.

I can post a script to run if anyone's interested.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02204 seconds
  • Memory Usage 1,762KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete