Copyright 2004, Stefano Fabri
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
ob_start('ob_gzhandler');
?>
<?=htmlentities($title)?> :: UEHS
No search parameter submitted');
if (isset($_GET['login']) && !$_GET['login']) exit('Maintainer email not submitted');
elseif ($_GET['login']) $login=$_GET['login'];
if (isset($_GET['package']) AND !$_GET['package']) exit('Package name not submitted');
elseif ($_GET['package']) $package=$_GET['package'];
$login = pg_escape_string($login);
$package = pg_escape_string($package);
?>
1) {
?>
"Select id,pkgs.pop_inst,name,section,version,tot_up_error,tot_avg_error_date,pkgs.dist,up_version,watch_warn, up_changes,up_url,dversionmangled,lastupvsdebsync,lastcheck 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 updated='0' AND up_version!='' AND (maint LIKE '$login' OR uploaders LIKE '%$login%') AND name LIKE '$package'
order by pop_inst desc;",
no_upstream=>"select id,pkgs.pop_inst,name,section,version, tot_up_error, tot_avg_error_date, pkgs.dist,watch_warn,up_changes, up_version,up_url,dversionmangled,lastupvsdebsync,lastcheck,failures_count,watch 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 (maint LIKE '$login' OR uploaders LIKE '%$login%') AND name LIKE '$package' order by pop_inst desc;",
no_watch=>"SELECT id,pkgs.pop_inst,name,pkgs.version,pkgs.dist,tot_up_error, tot_avg_error_date,wwiz,wwiz_type,wwiz_version,maint,section,up_changes,up_url,dversionmangled,lastupvsdebsync,lastcheck 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 (watch IS NULL OR watch='') AND (maint LIKE '$login' OR uploaders LIKE '%$login%') AND name LIKE '$package' ORDER BY pop_inst DESC;",
ok=>"Select id,pkgs.pop_inst,name,section,version,tot_up_error,tot_avg_error_date,pkgs.dist,up_version,watch_warn, up_changes,up_url,dversionmangled,lastupvsdebsync,lastcheck 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 updated='1' AND (maint LIKE '$login' OR uploaders LIKE '%$login%') AND name LIKE '$package' AND (up_version != '' AND up_version IS NOT NULL)
order by pop_inst desc;");
foreach($sql as $key => $value) {
$rs=pg_exec($db,$value) OR Die("Error on query");
$qta=pg_exec($db, "SELECT count(name) from pkgs WHERE (maint LIKE '$login' OR uploaders LIKE '%$login%') AND name LIKE '$package' ") OR Die("Errore on query");
$totrs=pg_numrows($rs);
$totpkgs=pg_fetch_array($qta,0);
if ($totrs>0) {
?>
