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
include("header.inc"); ?>
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) {
?>
- ">Name: print $res_array["name"]; ?> (LP)
- PopCon inst: print $res_array["pop_inst"]; ?>
if ($key=="no_watch") { ?>
- WWiz upstream version:
if ($res_array["wwiz_version"]) {?>
if ($res_array[up_changes]!='') { ?>
">
print $res_array["wwiz_version"]; ?>
} else print $res_array["wwiz_version"];
}
else {
print "none";
$res_array["wwiz_version"]="N/A";
}
?>
}?>
if ($key!="no_watch") { ?>
- Upstream version:
if ($res_array["up_version"]) {?>
if ($res_array[up_changes]!='') { ?>
">
print $res_array["up_version"]; ?>
} else print $res_array["up_version"];
}
else print "none";?>
}
if (!empty($res_array['up_url'])) {
echo '- Source download: ' . htmlentities(preg_replace('/(.+?)\?.*/','$1',basename($res_array['up_url']))) . '
';
}
?>
- Debian version: print htmlentities($res_array["version"]);
if ($res_array["dversionmangled"] != $res_array["version"]) {
echo ' (mangled: ' . htmlentities($res_array["dversionmangled"]) . ')';
}
?>
- Last time checked: echo htmlentities(preg_replace('/\..+/','',$res_array['lastcheck'])); ?>
- Last time found up to date: echo htmlentities($res_array['lastupvsdebsync']); ?>
- Total continuous failures: echo $res_array['failures_count']; ?>
if ($key=="no_watch") { ?>
- Watch Wizard:
if ($res_array["wwiz_type"]!="no_cright") {
?>
">
print $res_array["wwiz_type"]; ?>
}
else print "N/A";
?>
}?>
if ($key!="no_watch") {
$watch_comments = '';
if (!$res_array['up_version'] && isset($res_array['watch'])) {
$watch_comments = trim(preg_replace('/^(\s*[^#].*$|\s*#)/m','',$res_array['watch']),"\n\r\0\x0B");
}
?>
- Watch: ">view if($watch_comments) echo " (comments below)"; ?>
echo htmlspecialchars($watch_comments); ?>
Uscan errors: $res_array["watch_warn"] ? print " " . nl2br(htmlentities($res_array["watch_warn"])) : print "No errors"; ?>
Copyright: print "" . "view"; ?>
|
";
*/
// $c = (1 == $c)? 2 : 1;
}
if (2 == $c) {
?>