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";