4 require_once 'Pman.php';
6 class Reddit extends Pman
8 var $masterTemplate = 'reddit.html';
17 //DB_DataObject::debugLevel(1);
19 $day = empty($day) ? date('Y-m-d') : date('Y-m-d', strtotime($day));
20 $f = DB_DataObject::factory('reddit_livefeed');
21 $f->selectAdd('created_dt - INTERVAL 8 HOUR as created_local_dt');
24 created_dt - INTERVAL 8 HOUR > '{$day} 00:00:00'
26 created_dt - INTERVAL 8 HOUR < '{$day} 00:00:00' + INTERVAL 1 DAY
29 $f->orderBy('created_dt ASC');
30 $this->feed = $f->fetchAll();