summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--web-scripts/to-delete.php23
1 files changed, 11 insertions, 12 deletions
diff --git a/web-scripts/to-delete.php b/web-scripts/to-delete.php
index 3d732a1..dfa5a39 100644
--- a/web-scripts/to-delete.php
+++ b/web-scripts/to-delete.php
@@ -12,20 +12,19 @@ if ($mysql->connect_error) {
}
$result = $mysql -> query(
- "SELECT DISTINCT " .
+ "SELECT " .
"`repositories`.`name` AS `repo`," .
- "`is_there`.`pkgname`," .
- "`is_there`.`epoch`," .
- "`is_there`.`pkgver`," .
- "`is_there`.`pkgrel`," .
- "`is_there`.`sub_pkgrel`," .
+ "`binary_packages`.`pkgname`," .
+ "`binary_packages`.`epoch`," .
+ "`binary_packages`.`pkgver`," .
+ "`binary_packages`.`pkgrel`," .
+ "`binary_packages`.`sub_pkgrel`," .
"`architectures`.`name` AS `arch` " .
- "FROM `binary_packages`AS `is_there` " .
- "JOIN `binary_packages` AS `to_delete` ON `to_delete`.`pkgname`=`is_there`.`pkgname` " .
- "JOIN `architectures` ON `is_there`.`architecture`=`architectures`.`id` " .
- "JOIN `repositories` ON `is_there`.`repository`=`repositories`.`id` " .
- "WHERE `to_delete`.`repository`=10 " .
- "AND NOT `is_there`.`repository` IN (4,9,10)"
+ "FROM `binary_packages` " .
+ "JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` " .
+ "JOIN `repositories` ON `binary_packages`.`repository`=`repositories`.`id` " .
+ "WHERE `binary_packages`.`is_to_be_deleted` " .
+ "AND NOT `repositories`.`name` IN (\"build-support\",\"build-list\",\"deletion-list\")"
);
if ($result -> num_rows > 0) {