summaryrefslogtreecommitdiff
path: root/buildmaster/to-delete.php
diff options
context:
space:
mode:
Diffstat (limited to 'buildmaster/to-delete.php')
-rw-r--r--buildmaster/to-delete.php14
1 files changed, 8 insertions, 6 deletions
diff --git a/buildmaster/to-delete.php b/buildmaster/to-delete.php
index 579bd62..8458c74 100644
--- a/buildmaster/to-delete.php
+++ b/buildmaster/to-delete.php
@@ -11,17 +11,19 @@ require_once BASE . "/lib/mysql.php";
"`binary_packages`.`pkgver`," .
"`binary_packages`.`pkgrel`," .
"`binary_packages`.`sub_pkgrel`," .
- "`architectures`.`name` AS `arch`" .
+ "`architectures`.`name` AS `arch`," .
+ "IF(`upstream_packages`.`id` IS NULL, 0, 1) AS `exists_upstream`" .
" FROM `binary_packages`" .
mysql_join_binary_packages_architectures() .
mysql_join_binary_packages_binary_packages_in_repositories() .
mysql_join_binary_packages_in_repositories_repositories() .
- "WHERE `binary_packages_in_repositories`.`is_to_be_deleted` " .
- "AND `repositories`.`is_on_master_mirror`"
+ " LEFT JOIN `upstream_packages`" .
+ " ON `upstream_packages`.`pkgname`=`binary_packages`.`pkgname`" .
+ " WHERE `binary_packages_in_repositories`.`is_to_be_deleted`" .
+ " AND `repositories`.`is_on_master_mirror`" .
+ " GROUP BY CONCAT(`binary_packages_in_repositories`.`id`,\"-\",IFNULL(`upstream_packages`.`pkgname`,0))"
);
- $available = available_upstream_packages('pkgname');
- $available = array_combine( $available, $available);
?>
<html>
<head>
@@ -39,7 +41,7 @@ if ($result -> num_rows > 0) {
while ($row = $result->fetch_assoc()) {
- if (isset($available[$row["pkgname"]]))
+ if ($row['exists_upstream'] == 1)
$color = "#FF0000";
else
$color = "#00FF00";