From da6236ed6a853e4e6bb6a15a8e63ff4686aef159 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 22 Apr 2018 17:32:08 +0200 Subject: packages/index.php: show Last Update --- packages/index.php | 19 +++++++++++++++++-- 1 file changed, 17 insertions(+), 2 deletions(-) diff --git a/packages/index.php b/packages/index.php index 09a9b6e..b40ce08 100644 --- a/packages/index.php +++ b/packages/index.php @@ -76,7 +76,8 @@ "`binary_packages`.`pkgrel`,\".\"," . "`binary_packages`.`sub_pkgrel`) AS `version`," . "IF(`binary_packages`.`has_issues`,1,0) AS `has_issues`," . - "`build_assignments`.`return_date` AS `build_date`" . + "`build_assignments`.`return_date` AS `build_date`," . + "`binary_packages`.`last_moved` AS `move_date`" . $query ); $exact_matches = array(); @@ -113,6 +114,11 @@ "title" => "build date", "label" => "Build Date", "mysql" => "IFNULL(`build_assignments`.`return_date`,\"00-00-0000 00:00:00\")" + ), + "move_date" => array( + "title" => "last update", + "label" => "Last Update", + "mysql" => "IFNULL(`binary_packages`.`last_moved`,\"00-00-0000 00:00:00\")" ) ); @@ -154,7 +160,8 @@ "`binary_packages`.`pkgrel`,\".\"," . "`binary_packages`.`sub_pkgrel`) AS `version`," . "IF(`binary_packages`.`has_issues`,1,0) AS `has_issues`," . - "`build_assignments`.`return_date` AS `build_date`" . + "`build_assignments`.`return_date` AS `build_date`," . + "`binary_packages`.`last_moved` AS `move_date`" . $query . " LIMIT " . (($page-1)*100) . ", 100" ); @@ -195,6 +202,14 @@ print " "; print "\n"; print " \n"; + print " \n"; + print " "; + if (isset($row["move_date"])) + print $row["move_date"]; + else + print " "; + print "\n"; + print " \n"; print " \n"; if ($oddity == "odd" ) $oddity = "even"; -- cgit v1.2.3-70-g09d2