Thread: Forum Display Enhancements - Article Forums
View Single Post
  #935  
Old 08-07-2011, 01:15 AM
SBlueman SBlueman is offline
 
Join Date: Jan 2006
Posts: 717
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What do I need to change in these bits of code in articles.php make it where the "Most Read" and "Most Commented" so that the modules only list the top articles in the last "X" amount of days?

PHP Code:
if (in_array('mostread'$af_modules))
    {
        
$row 0;
        
$af_mrpp $vbulletin->options[af_mrpp];
        
$threads $db->query_read("
            SELECT thread.threadid,thread.title AS threadtitle
            FROM " 
TABLE_PREFIX "thread AS thread
            LEFT JOIN " 
TABLE_PREFIX "post AS post
                ON (post.postid = thread.firstpostid)
            WHERE thread.forumid IN (
$forumids)
            
$visiblethreads $authorids $condition
            ORDER BY views DESC
            LIMIT 30, 
$af_mrpp");
        while(
$thread $db->fetch_array($threads))
        {
            
$row++;
            
$thread process_thread_array($thread$lastread$foruminfo['allowicons']);
            
$thread[threadtitle] = substr($thread[threadtitle], 0$vbulletin->options[af_maxtitle]);
            eval(
'$a_most_read .= "' fetch_template('af_articlesmallbit') . '";');
        }
    } 
PHP Code:
    if (in_array('mostcommented'$af_modules))
    {
        
$row 0;
        
$af_mcpp $vbulletin->options[af_mcpp];
        
$threads $db->query_read("
            SELECT thread.threadid,thread.title AS threadtitle
            FROM " 
TABLE_PREFIX "thread AS thread
            LEFT JOIN " 
TABLE_PREFIX "post AS post
                ON (post.postid = thread.firstpostid)
            WHERE thread.forumid IN (
$forumids)
            
$visiblethreads $authorids $condition
            ORDER BY replycount DESC
            LIMIT 30, 
$af_mcpp");
        while(
$thread $db->fetch_array($threads))
        { 
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02042 seconds
  • Memory Usage 1,792KB
  • 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