[Dehs-devel] r147 - trunk/www

[atomo64-guest at alioth.debian.org]

Author: atomo64-guest
Date: 2008-07-08 20:41:13 +0000 (Tue, 08 Jul 2008)
New Revision: 147

Modified:
   trunk/www/no_upstream.php
Log:
Don't display packages with a watch file, no upstream version, but no warnings from uscan


Modified: trunk/www/no_upstream.php
===================================================================
--- trunk/www/no_upstream.php	2008-07-06 00:13:31 UTC (rev 146)
+++ trunk/www/no_upstream.php	2008-07-08 20:41:13 UTC (rev 147)
@@ -14,7 +14,7 @@
 <?include("menu.inc");?>
 <?
 require "config_www.inc";
-$rsql=pg_exec($db, "select pkgs.pop_inst,name,tot_up_error, tot_avg_error_date, pkgs.dist,watch_warn  from pkgs INNER JOIN (Select SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist) as binpkgs using(name,dist) where up_version='' AND watch!='' order by pop_inst desc;");
+$rsql=pg_exec($db, "select pkgs.pop_inst,name,tot_up_error, tot_avg_error_date, pkgs.dist,watch_warn  from pkgs INNER JOIN (Select SUM(up_error) as tot_up_error,AVG(avg_error_date) as tot_avg_error_date,name,dist FROM binpkgs GROUP BY name,dist) as binpkgs using(name,dist) where up_version='' AND watch!='' AND watch_warn !='' order by pop_inst desc;");
 $rsql2=pg_exec($db, "SELECT count(name) from pkgs WHERE watch is not null");
 $totnowatch=pg_numrows($rsql);
 $totpkgs=pg_fetch_array($rsql2);