diff options
| -rw-r--r-- | packages/index.php | 19 |
1 files 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 " </td>\n"; + print " <td>\n"; + print " "; + if (isset($row["move_date"])) + print $row["move_date"]; + else + print " "; + print "\n"; + print " </td>\n"; print " </tr>\n"; if ($oddity == "odd" ) $oddity = "even"; |