vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Trying to limit query to X amount of days...how? (https://vborg.vbsupport.ru/showthread.php?t=268475)

SBlueman 08-13-2011 05:46 PM
Trying to limit query to X amount of days...how?
 
What do I need to change in these bits of code to 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 0, $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 0, $af_mcpp");
        while($thread = $db->fetch_array($threads))
        { 

kh99 08-14-2011 12:40 AM
You could do something like:

PHP Code:
$cutoff = TIMENOW - (X * 86400); // replace X with number of days 

Then in the WHERE clause add

HTML Code:
AND thread.dateline > $cutoff


All times are GMT. The time now is 06:39 AM.

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.01071 seconds
  • Memory Usage 1,731KB
  • 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)bbcode_html_printable
  • (3)bbcode_php_printable
  • (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