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
$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.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Can you please put this in a text file for those who want to download the hack and keep a backup of it also? Thank you.
And I guess I'm still not exactly clear on what this does. Does it get the posts from 3 days ago and only for that day?
basicly from what i can tell it does posts from the actual day only ie
2 days ago from today would only get those posts
not all posts from two days ago up until today
so it limits posts to particular days instead of the usual way all posts from 2 days ago till today
i guess its better filtering and in depth searching
Search By Day Instead of From Day Details »»
About Developer
Visit Web Site
No support by the author.
05-31-2004, 05:57 PM
