Limiting the number of articles by Date

Raven · Posted: Tue May 06, 2003 9:53 pm

If you would like to limit the old articles by the date age, in addition to the number of articles controlled by the Preferences setting, try this.
Find these lines in blocks/block-Old_Articles.php

Code:

$sql = "SELECT sid, title, time, comments FROM ".$prefix."_stories $querylang ORDER BY time DESC LIMIT $storynum, $oldnum";

Try changing them to this.

Code:

define("_CUTOFFDAYS",60);
$cutoffDate = time()-(_CUTOFFDAYS*86400);
if (isset($cutoffDate)) $querylang .= " AND (unix_timestamp(time) >= $cutoffDate)";
$sql = "SELECT sid, title, time, comments FROM ".$prefix."_stories $querylang ORDER BY time DESC LIMIT $storynum, $oldnum";

The '60' is 60 days. Make it whatever you want. Let me know if this works or not.

[Edited] I was using a modified version of Old Articles in my original post. I have corrected this hack to work with the 'virgin' 6.5 code.