cvs: pearweb /cron update-stats.php

cellog          Wed Oct 18 01:36:53 2006 UTC

  Modified files:              
    /pearweb/cron       update-stats.php 
  Log:
  we won't need the extra stats_updated table, updates are put
  directly into aggregated_package_data now
  
http://cvs.php.net/viewvc.cgi/pearweb/cron/update-stats.php?r1=1.1&r2=1.2&diff_format=u
Index: pearweb/cron/update-stats.php
diff -u pearweb/cron/update-stats.php:1.1 pearweb/cron/update-stats.php:1.2
--- pearweb/cron/update-stats.php:1.1   Tue Oct 17 17:54:35 2006
+++ pearweb/cron/update-stats.php       Wed Oct 18 01:36:53 2006
@@ -8,18 +8,10 @@
 $dbh =& DB::connect(PEAR_DATABASE_DSN, $options);
 $releases = $dbh->getAll('SELECT id from releases');
 foreach ($releases as $release) {
-    $lastupdate = $dbh->getOne('SELECT lastupdate FROM stats_updated WHERE 
release_id = ' . $release[0]);
-    if (PEAR::isError($lastupdate) || !$lastupdate) {
-        $lastupdate = '0000-00-00 00:00:00';
-        $dbh->query('INSERT INTO stats_updated (release_id, lastupdate) 
VALUES(' . $release[0] .
-            ', "' . $lastupdate . '")');
-    }
-    $curtime = $dbh->getOne('SELECT NOW()');
     $all = $dbh->getAll($q = 'SELECT r.package, r.id, DATE_FORMAT(d.dl_when, 
"%Y-%m-01"), COUNT(*)
                           FROM releases r, downloads d
                           WHERE r.id = ' . $release[0] . '
                             AND d.release = r.id
-                            AND d.dl_when > "' . $lastupdate . '"
                             AND d.package = r.package
                           GROUP BY YEAR(d.dl_when), MONTH(d.dl_when)
                           ORDER BY YEAR(d.dl_when) DESC, MONTH(d.dl_when) 
DESC');
@@ -29,7 +21,4 @@
             VALUES(' . $data[0] . ',' . $data[1] . ',"' . $data[2] . '",' . 
$data[3] . ')
             ON DUPLICATE KEY UPDATE downloads=downloads+' . $data[3]);
     }
-    $dbh->query('UPDATE stats_updated SET lastupdate="' . $curtime . '" WHERE 
release_id=' . $release[0]);
-    // remove old download entries
-    $dbh->query('DELETE FROM downloads WHERE dl_when < "' . $curtime . '" AND 
release=' . $release[0]);
-}
+}
\ No newline at end of file

-- 
PEAR CVS Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php