vb.org Archive - Search By Day Instead of From Day

Search By Day Instead of From Day
By: Ming Keong
Inspiration: https://vborg.vbsupport.ru/showthread.php?t=64172

Estimated Installation Time: 1-5 mins
File changes: 1 PHP

History
31May04:Initial creation
01Jun04:Added option to retain original getdaily functionality by using getdailyfrom instead

Comments
I'm not sure how many of you will find this useful, but I'll just post it anyway so that it'll benefit anyone who wants it. It's a simple hack that will probably be useful for people who run news sites.

Description
Converts 'getdaily' searches to retrieve posts for the particular day, instead of from the particular day.

getdaily -> Gets all posts X days ago
getdailyfrom -> Gets all posts from X days ago till now

Example Usage
http://www.pdatrends.com/search.php?...ys=1&forumid=6 -> Get News 1 Day Ago
http://www.pdatrends.com/search.php?...ys=3&forumid=6 -> Get News 3 Days Ago
http://www.pdatrends.com/search.php?...ys=1&forumid=6 -> Get News From 1 Day Ago Till Now
http://www.pdatrends.com/search.php?...ys=3&forumid=6 -> Get News From 3 Days Ago Till Now

Code Modifications
In search.php:

Find:

PHP Code:


		
			
$threads = $DB_site->query(" 

        SELECT threadid 

        FROM " . TABLE_PREFIX . "thread AS thread 

        LEFT JOIN " . TABLE_PREFIX . "deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread') 

        WHERE forumid IN(" . implode(', ', $forumids) . ") 

        AND thread.lastpost >= $datecut 

        AND visible = 1 

        AND delthread.primaryid IS NULL 

        ORDER BY lastpost DESC 

        LIMIT $vboptions[maxresults] 

    ");

Replace with:

PHP Code:


		
			
if ($_REQUEST['do'] == 'getdaily') { 

        $datecutplus = $datecut + (24 * 60 * 60); 

        $dayonly = "AND thread.lastpost <= $datecutplus"; 

    } 

    $threads = $DB_site->query(" 

        SELECT threadid 

        FROM " . TABLE_PREFIX . "thread AS thread 

        LEFT JOIN " . TABLE_PREFIX . "deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread') 

        WHERE forumid IN(" . implode(', ', $forumids) . ") 

        AND thread.lastpost >= $datecut 

        ".$dayonly." 

        AND visible = 1 

        AND delthread.primaryid IS NULL 

        ORDER BY lastpost DESC 

        LIMIT $vboptions[maxresults] 

    ");

Optional, if you want to retain the previous getdaily functionality:

Find:

PHP Code:


		
			
if ($_REQUEST['do'] == 'getnew' OR $_REQUEST['do'] == 'getdaily')

Replace with:

PHP Code:


		
			
if ($_REQUEST['do'] == 'getnew' OR $_REQUEST['do'] == 'getdaily' OR $_REQUEST['do'] == 'getdailyfrom')

Find:

PHP Code:


		
			
$_REQUEST['do'] = 'getdaily';

Replace with:

PHP Code:


		
			
if ($_REQUEST['do'] != 'getdaily') {

    $_REQUEST['do'] = 'getdailyfrom';

}

Known Limitations
- Retrieves x days ago relative to current time. Eg, it cannot retrieve posts for 28 May 2004. If the current time is 12pm on 29 May 2004, retrieving 1 day ago will search for all posts from 28 May 2004 12pm till 29 May 2004 12pm.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01145 seconds Memory Usage 1,747KB 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 (6)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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
Messages: