From 229df61eba717104bbaa34b6112e0b4fd5503598 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 7 Mar 2019 13:58:16 +0100 Subject: table `upstream_packages` makes available_upstream_packages() obsolete --- buildmaster/to-delete.php | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) (limited to 'buildmaster/to-delete.php') 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); ?> @@ -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"; -- cgit v1.2.3-54-g00ecf