Reddit.php

diff --git a/Reddit.php b/Reddit.php
index e69de29..d293100 100644 (file)
--- a/Reddit.php
+++ b/Reddit.php
@@ -0,0 +1,36 @@
+<?php
+
+<?php
+require_once 'Pman.php';
+
+class  Reddit  extends Pman
+{
+    var $masterTemplate = 'reddit.html';
+    
+    function getAuth()
+    {
+        return true;
+    }
+    
+    function get($day='')
+    {
+        //DB_DataObject::debugLevel(1);
+        
+        $day = empty($day) ? date('Y-m-d') : date('Y-m-d', strtotime($day));
+        $f = DB_DataObject::factory('reddit_livefeed');
+        $f->selectAdd('created_dt - INTERVAL 8 HOUR as created_local_dt');
+        
+        $f->whereAdd("
+                created_dt - INTERVAL 8 HOUR > '{$day} 00:00:00'
+                AND
+                created_dt - INTERVAL 8 HOUR < '{$day} 00:00:00' + INTERVAL 1 DAY                
+        ");
+        
+        $f->orderBy('created_dt ASC');
+        $this->feed = $f->fetchAll();
+        
+        
+    }
+  
+  
+}