vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   What is the best way to fetch the 'x' latest articles in the CMS? (https://vborg.vbsupport.ru/showthread.php?t=243743)

Yellow Slider 06-01-2010 07:07 PM

What is the best way to fetch the 'x' latest articles in the CMS?
 
I'm building a widget that will diaplay the 'x' latest articles on the forumhome.
for every article I need the following information -
  • title
  • url
  • preview text
  • one of the attachments (will be displayed)
  • STAMP (for the date)

I'm going to use the datastore and a cron that will build the datastore every 10 min' to update the information, so there won't be any "heavy" queries on the front page for every refresh, just fetching data from the datastore (is there a better solution?)

is there a manual of how I should use the datastore in vB4?

I'll be happy to hear your solution for that.

Carnage 06-03-2010 02:40 PM

If you are making a forum block, the output is cached automatically.

I don't recall how to do this off the top of my head, but its also possible to use the vb_cache object to store your data. You can then listen for certain events which will automatically clear the cache (eg when a new article is posted)


All times are GMT. The time now is 06:13 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.01063 seconds
  • Memory Usage 1,707KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete