DataObjects/Core_curr_rate.php

[Pman.Core] / Prune.php

diff --git a/Prune.php b/Prune.php
index d184830..0c94d7c 100644 (file)
--- a/Prune.php
+++ b/Prune.php
@@ -11,7 +11,7 @@ require_once 'Pman.php';
 class Pman_Core_Prune extends Pman
 {
     //put your code here
-    static $cli_desc = "COre Prune -- remove old event data (6 months is normally a good idea).";
+    static $cli_desc = "Core Prune -- remove old event data (6 months is normally a good idea).";
     static $cli_opts = array(
         'months' => array(
             'desc' => 'How many months',
@@ -37,28 +37,49 @@ class Pman_Core_Prune extends Pman
     function get($m="", $opts)
     {
         
+        // prune irrelivant stuff..
+       
+        
+        
         $this->prune((int)$opts['months']);
     }
     
     function prune($inM)
     {
         // 40 seconds ? to delete 100K records..
-        //DB_DataObject::debugLevel(1);
+       // DB_DataObject::debugLevel(1);
         $f = DB_DataObject::Factory('reader_article');
         $f->query("
             DELETE FROM Events where 
                   event_when < NOW() - INTERVAL {$inM} MONTH
                   LIMIT 100000
         ");
-        // pruning is for our press project - so we do not clean up dependant tables at present..
         
+        // notificication events occur alot - so we should trash them more frequently..
+        $f = DB_DataObject::Factory('reader_article');
+        $f->query("
+            DELETE FROM Events where 
+                  event_when < NOW() - INTERVAL 1 MONTH
+                  AND
+                  action IN ('NOTIFY')
+                  LIMIT 100000
+        ");
         
+        // pruning is for our press project - so we do not clean up dependant tables at present..
+        
+        if (function_exists('posix_getpwuid')) {
+            $uinfo = posix_getpwuid( posix_getuid () ); 
+         
+            $user = $uinfo['name'];
+        } else {
+            $user = getenv('USERNAME'); // windows.
+        }
         
         $ff = HTML_Flexyframework::get()->Pman;
         
         $y = date("Y");
         $m = date("m");
-        $rootDir = $ff['storedir'].'/rss';
+        $rootDir = $ff['storedir'].'/_events_/'.$user;
         
         $dirs = array_filter(glob($rootDir."/*"), 'is_dir');
         foreach($dirs as $d){