View Single Post
  #1  
Old 06-18-2004, 12:05 AM
DiscussAnything DiscussAnything is offline
 
Join Date: Jan 2002
Posts: 131
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 5 latest articles

I have the article hack (vb2) on my site, and wanted to include '5 latest articles' on the vbhome lite page. I can't seem to get it to work though, and was hoping someone could tell me what I'm missing.

This is the PHP I added to the index.php. Its based on the '10 latest threads':

PHP Code:
// +--------------------------------------------------------------
// | Latest KB Articles
// +--------------------------------------------------------------
$kbheader '';
$kbbits '';
{
  eval( 
'$kbheader = "' gettemplate'home_kbheader' ) . '";' );

  
$kbart $DB_site->query("
    SELECT artid, categoryid,date, title, hits, author
    FROM vbArticles_content
    WHERE categoryid != 7 AND categoryid != 8 
    ORDER BY artid DESC LIMIT 5
  "
);
  while ( 
$kbart $DB_site->fetch_array$kbart ) )
  {
      eval( 
'$kbbits .= "' gettemplate'home_kbbit' ) . '";' );
  }
  
$DB_site->free_result$kbart );
  unset( 
$kbart );

As you can tell this uses 2 templates, a header and a bit that displays the info for the article. The query works, I've tested it and it gives me the 5 latest additions, leaving out anything from category 7 or 8.

The index however only gives me the single latest addition, not 5. The kbbit template is:

PHP Code:
<tr class="clfirst">
<
td><img src="{imageshome}/arrow.gif" alt="" class="imgborder" height="7" width="7" border="0"/><a href="$bburl/articles.php?action=viewarticle&artid=$kbart[artid]"><span class="txtbold">$kbart[title]</span></a><br />
Added$kbart[date]<br>
Author$kbart[author]</a><br>
Views$kbart[hits]</td>
</
tr
Nothing I can see that's wrong here. So why doesn't it display 5? The query works, the template works, but together it doesn't...

help?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01265 seconds
  • Memory Usage 1,788KB
  • 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
  • (2)bbcode_php
  • (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