packages/index.php: show Last Update

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 "&nbsp;";
+      print "\n";
+      print "            </td>\n";
       print "          </tr>\n";
       if ($oddity == "odd" )
         $oddity = "even";