summaryrefslogtreecommitdiff
path: root/packages
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-04-22 17:32:08 +0200
committerErich Eckner <git@eckner.net>2018-04-22 17:32:08 +0200
commitda6236ed6a853e4e6bb6a15a8e63ff4686aef159 (patch)
tree0099c935bdbd2fa19146eab9103133151b651e0f /packages
parent38e0d8c61f1912467e0fcfd4a58a321998386e86 (diff)
downloadwebsite-da6236ed6a853e4e6bb6a15a8e63ff4686aef159.tar.xz
packages/index.php: show Last Update
Diffstat (limited to 'packages')
-rw-r--r--packages/index.php19
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 "&nbsp;";
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";