summaryrefslogtreecommitdiff
path: root/buildmaster/status.php
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-05-31 15:58:14 +0200
committerErich Eckner <git@eckner.net>2018-05-31 15:58:14 +0200
commitf1a6d7ddc580b913ba35532b4c701bfd8e320a16 (patch)
tree321095ee035fd715d0ff7f8a90c6686578f169e6 /buildmaster/status.php
parent53d6d755fdb2515d49ed9dcb15192b36331d65cc (diff)
downloadarchweb32-f1a6d7ddc580b913ba35532b4c701bfd8e320a16.tar.xz
buildmaster/mysql-issues.php, buildmaster/status.php, buildmaster/to-delete.php: read `is_to_be_deleted` and `last_moves` from `binary_packages_in_repositories`
Diffstat (limited to 'buildmaster/status.php')
-rw-r--r--buildmaster/status.php5
1 files changed, 3 insertions, 2 deletions
diff --git a/buildmaster/status.php b/buildmaster/status.php
index 46c2fc1..2b1bd11 100644
--- a/buildmaster/status.php
+++ b/buildmaster/status.php
@@ -24,10 +24,11 @@ if ($result -> num_rows > 0) {
}
$result = mysql_run_query(
- "SELECT MAX(`binary_packages`.`last_moved`) AS `last_moved`" .
+ "SELECT MAX(`binary_packages_in_repositories`.`last_moved`) AS `last_moved`" .
" FROM `binary_packages`" .
+ " JOIN `binary_packages_in_repositories` ON `binary_packages_in_repositories`.`package`=`binary_packages`.`id`" .
" JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id`" .
- " WHERE `binary_packages`.`last_moved`>`build_assignments`.`return_date`"
+ " WHERE `binary_packages_in_repositories`.`last_moved`>`build_assignments`.`return_date`"
);
if ($result -> num_rows > 0) {